what is Difference between PROC SQL JOINS and MERGE?
Answer Posted / rajitha macherla
The resultant dataset depends on the input datasets.
In case of one to one and one to many both work
similarly,i.e. the resultant dataset is same.
But differs in case of many to many and non matching
datasets:
many to many:
ex: (merge on x) (proc sql)
X Y X Z X Y Z X Y Z
----- ------ ------- -------
1 A 1 F 1 A F 1 A F
1 C 1 R ---> 1 C R 1 A R
2 B 2 G 2 B G 1 C F
1 C R
2 B G
NON MATCHING DATA:
ex: (merge on x) (proc sql)
X Y X Z X Y Z X Y Z
----- ------ ------- -------
1 A 1 F 1 A F 1 A F
2 B 3 T ---> 2 B . 3 C T
3 C 4 G 3 C T
4 . G
Is This Answer Correct ? | 28 Yes | 6 No |
Post New Answer View All Answers
What is run-group processing?
Enlist the functions performed by sas.
What are the table names in oracle database...?
Name some categories in sas 9? : sas-grid-administration
Differentiate between sas functions and sas procedures.
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
what is sas business intelligence? : Sas-bi
What are the statements that are executed only?
If you could design your ideal job, what would it look like?
What is the role of sas grid administrator? : sas-grid-administration
What are the different versions of sas that you have used until now? : sas-grid-administration
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
Differentiate between ceil and floor functions.
what does the run statement do? : Sas programming
what is information maps?