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
Give e an example of..
what is sas enterprise intelligence architecture? : Sas-bi
which features do you use to check the data validations and errors? : Sas-administrator
what is broad cast agent? : Sas-bi
what is data integration? : Sas-di
explain the function of substr in sas? : Sas-administrator
What are pdv and it functions?
Name few SAS functions?
what is ae onset date n what is RDS
what are the categories that sas informats are used to the place the data? : Sas-administrator
how will you location sas platform applications available from web browser? : Sas-bi
What are the scrubbing procedures in sas?
what is the effect of the options statement errors=1? : Sas programming
What are the automatic variables for macro? : sas-macro
What is run-group processing?