Interested to Buy Any Domain ? << Click Here >> for more details...
what is Difference between PROC SQL JOINS and MERGE?
- 3 Answers
- 26341 Views
- Accenture, Wipro, I also Faced
- E-Mail Answers
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 sas enterprise intelligence architecture? : Sas-bi
explain about data integrator metadata reports? : Sas-di
Describe crosslist option in tables statement?
what is the difference between unique key and primary key? : Sas-di
How would you determine the number of missing or nonmissing values in computations?
What are the statements in proc sql?
do you need to know if there are any missing values? : Sas programming
What is connection profile? : sas-grid-administration
what are validation tools that are used in sas? : Sas-administrator
What is the role of sas grid administrator? : sas-grid-administration
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
name the scheduler for scheduling job and explain the scheduler? : Sas-di
What is the difference between where and if statement?
What is the role of administrative users? : sas-grid-administration
How substr function works in sas?
