How would you combine 3 or more tables with different
structures?
Answer Posted / ameenpasha
I think sort them with common variables and use merge statement.
No matter if they are of different structures, only that the result will have missing values for nonmatching records. If you wanna avoid this use In() operator OR
use proc sql with Join clause which will just pick matching records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
what can you learn from the sas log when debugging? : Sas programming
what is intially documentation in sas?
do you prefer proc report or proc tabulate? Why? : Sas programming
What are the advantages of using sas?
where to use sas business intelligence? : Sas-bi
what techniques and/or procs do you use for tables? : Sas programming
Difference between SAS STATA & SPSS?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
how do you test for missing values? : Sas programming
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
what are sas/access and sas/connect? : Sas programming
Name few SAS functions?
what is treatment emergent events and treatment emregent adverse event