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 we can create SAS USER DEFINED CODE?
Differentiate between format and informat? : sas-grid-administration
Explain the difference between nodup and nodupkey options?
Explain the use of proc print and proc contents?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
Mention the validation tools used in SAS?
Explain data step in SAS
how would you determine the number of missing or nonmissing values in computations? : Sas programming
what other sas products have you used and consider yourself proficient in using? : Sas programming
What are the difficulties u faced while doing vital signs table or dataset?
what techniques and/or procs do you use for tables? : Sas programming
how many types of prompts are there? : Sas-bi
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
Enlist the syntax rules followed in sas statements.
what is sas business intelligence? : Sas-bi