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 is data _null_?
how can you put a "trace" in your program? : Sas programming
explain what is factor analysis? : Sas-administrator
how do you want missing values handled? : Sas programming
How will you generate test data with no input data?
do you prefer proc report or proc tabulate? Why? : Sas programming
What is the difference between SAS functions and procedures?
what are the component of range? : Sas-bi
For what purpose would you use the RETAIN statement?
what can you learn from the sas log when debugging? : Sas programming
List out some key concept of SAS
What is the use of the %include statement?
What is the maximum and minimum length of macro variable
What does the RUN statement do?
What are the five ways to do a table lookup in sas? : sas-grid-administration