Interested to Buy Any Domain ? << Click Here >> for more details...
How would you combine 3 or more tables with different
structures?
- 7 Answers
- 18311 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
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
what is the primary data source for the wrs? : Sas-bi
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
What is Linear Regression?
How do dates work in sas?
How do you specify the number of iterations and specific condition within a single do loop?
explain the function of substr in sas? : Sas-administrator
how can you put a "trace" in your program? : Sas programming
How would you define the end of a macro?
what is the basic structure sas administrator? : Sas-administrator
How to limit decimal places for the variable using proc means?
explain what is data set in sas? : Sas-administrator
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
How would you identify a macro variable?
what is the function of catx syntax? : Sas-administrator
