How would you combine 3 or more tables with different
structures?
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 does sas handle missing values in procs? : Sas programming
Explain proc univariate?
what is SAS OPTIMIZATION?
how to change the execute of macro
How do you test for missing values?
What are the difference between sas functions and procedures?
What are the special input delimiters used in SAS?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
What is SAS informats?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
In sas, what are the areas that you are most interested in? : sas-grid-administration
How do you use the do loop if you don’t know how many times you should execute the do loop?
What is a method to debug and test your SAS program?
what is data governance? : Sas-di
Give e an example of..