Interested to Buy Any Domain ? << Click Here >> for more details...
How would you combine 3 or more tables with different
structures?
- 7 Answers
- 18583 Views
- I also Faced
- E-Mail Answers
Answer Posted / nandu
sort all datasets before going to merge
data abc ;
merge aa (in=a) bb (in=b) cc(in=c) ;
by empid /*by variable*/
if a or b or c;/*based on your requirement*/
run;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
how does sas handle missing values in assignment statements? : Sas programming
how will you locate the sas platform applications? : Sas-bi
What are the uses of sas?
What sas features do you use to check errors and data validation?
What is interleaving in SAS?
How we can create SAS USER DEFINED CODE?
how many display types available in sas bi dashboard? : Sas-bi
What is the sas data set? : sas-grid-administration
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
What is the function of output statement in a SAS Program?
Tell e how how dealt with..
Explain translate function?
Differentiate input and infile.
