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
Are you sensitive to code walk-throughs peer review or QC review?
What are types of transport files?
What is maximum storage capability of SAS?
Mention what is the difference between nodupkey and nodup options?
what is transformation in sas data integration? : Sas-di
What do you know about sas and what we do? : sas-grid-administration
explain about sas business intelligence? : Sas-bi
What is the sas data set? : sas-grid-administration
How to specify variables to be processed by the freq procedure?
What are the data types does SAS contain?
How many data types are there in SAS?
what are the categories that sas informats are used to the place the data? : Sas-administrator
explain the use of % includes a statement in sas? : Sas-administrator
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
Explain the main difference between the sas procedures and functions? : Sas-administrator