Interested to Buy Any Domain ? << Click Here >> for more details...
what is Difference between PROC SQL JOINS and MERGE?
- 3 Answers
- 26327 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 |
Can we replace a dataset into view?
Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?
data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
In PROC PRINT, can you print only variables that begin with the letter “A”?
what are some differences between proc summary and proc means? : Sas programming
what are sas bi dashboard components? : Sas-bi
what are informats in sas? : Sas-administrator
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What are the default statistics that proc means produce?
How to include or exclude specific variables in a data set?
if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record
Teradata 
