Interested to Buy Any Domain ? << Click Here >> for more details...
what is Difference between PROC SQL JOINS and MERGE?
- 3 Answers
- 26281 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 |
name several ways to achieve efficiency in your program? : Sas programming
how we can create optional or required parameters in SAS macro...
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C
Explain what Proc glm does?
where will go the observations that were deleted by delete statement?
What are the differences between proc means and proc summary?
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
how does sas handle missing values in assignment statements? : Sas programming
How do you use the do loop if you don’t know how many times you should execute the do loop?
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
Teradata 
