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


Please Help Members By Posting Answers For Below Questions

Are you sensitive to code walk-throughs peer review or QC review?

2597


What are types of transport files?

6840


What is maximum storage capability of SAS?

904


Mention what is the difference between nodupkey and nodup options?

595


what is transformation in sas data integration? : Sas-di

550






What do you know about sas and what we do? : sas-grid-administration

597


explain about sas business intelligence? : Sas-bi

596


What is the sas data set? : sas-grid-administration

564


How to specify variables to be processed by the freq procedure?

613


What are the data types does SAS contain?

650


How many data types are there in SAS?

630


what are the categories that sas informats are used to the place the data? : Sas-administrator

611


explain the use of % includes a statement in sas? : Sas-administrator

543


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

4908


Explain the main difference between the sas procedures and functions? : Sas-administrator

534