How would you combine 3 or more tables with different
structures?
Answer Posted / piyushjk
I would use Merge statement to combine theree tables (SAS
Datasets). First you have to sort the datasets by common
variable. provide the condition with in merge statement.
For e.g. Three datasets are A, B, C and common var is SSN,
then
DATA Together;
Merge A (IN=A)
B (IN=B)
C (IN=C);
By SSN; Run;
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are the data types does SAS contain?
What are the 3 components in sas programming?
Tell me more about the parameters in macro? : sas-macro
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
how does sas handle missing values in assignment statements? : Sas programming
why is sas considered self-documenting? : Sas programming
What are the difference between ceil and floor functions in sas?
How do you define proc in sas? : sas-grid-administration
What are the features of SAS?
What are the applications primarily used by business analyst? : Sas-bi
Name types of category in which SAS Informats are placed?
Where do you use proc means over proc freq?
How we can call macros with in data step? : sas-macro
What is the basic syntax style in SAS?
what is sas and what are the functions? : Sas-administrator