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
What are the ways in which macro variables can be created in sas programming?
What are all the problems you faced while validating tables and reports?
what is proc Index? and what is proc document?
How can sas program be validated?
what are all the reports you generated in your recent project?
Name some categories in sas 9? : sas-grid-administration
What is the general format of function in sas? : sas-grid-administration
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
How to include or exclude specific variables in a data set?
What is the role of administrative users? : sas-grid-administration
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
How would you invoke a macro? : sas-macro
Explain data step in SAS
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?