Interested to Buy Any Domain ? << Click Here >> for more details...
what is Difference between PROC SQL JOINS and MERGE?
- 3 Answers
- 26564 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 |
here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
how do you validate sas program?
What are common programming errors committed in sas
What is the order of application for output data set options, input data set options and SAS statements?
what does .. meant in sas macros
How to read an input file in sas?
What sas features do you use to check errors and data validation?
How to sort in descending order?
for what purpose would you use the retain statement? : Sas programming
what is the prob plot in clinical domain
What is the one statement to set the criteria of data that can be coded in any step?
how can you get the single data set from the library(which has the number of data sets)?
3 Answers Accenture, Deloitte,
Teradata 
