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
How would you include common or reuse to be processed along with your statements?
what are sas bi dashboard components? : Sas-bi
what is ae onset date n what is RDS
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
Explain why double trailing @@ is used in input statement?
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
Explain the purpose of retain statement.
how do you test for missing values? : Sas programming
explain the function of substr in sas? : Sas-administrator
what are several options for creating reports in web report studio? : Sas-bi
What is the use of PROC gplot?
what are validation tools that are used in sas? : Sas-administrator
Name validation tools used in SAS
What is the maximum and minimum length of macro variable
What is the sas data set? : sas-grid-administration