what is Difference between PROC SQL JOINS and MERGE?
- 3 Answers
- 25435 Views
- Accenture, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / siddu
Before doing the merge process we have to do sorting depended the key variable, but in proc sql joins no need to do sorting.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / nrtya vardhanapu
merge is a statement which is used in the data step Whereas
join is a procedure which is used in the proc step. But the
outputs produced are the same !!!!
| Is This Answer Correct ? | 0 Yes | 13 No |
how to delete the duplicates by using proc sql?
if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually
How to display duplicate observations in data?
what are input dataset and output dataset options?
how could you generate test data with no input data? : Sas programming
how to read raw data in sas. Do it manually and throw the programming.
Name statements that function at both compile and execution time.
what is the diff b/w verification validation in sas
Difference between nodup and nodupkey options?
This entry was posted in General. Bookmark the permalink. Post a comment or leave
what are several options for creating reports in web report studio? : Sas-bi
What is Transaction...? And what are Comment, Roll back n Save point..?
Teradata 
