Diff between proc sql merge and join?

Answer Posted / anand

Merge - Data sets must be sorted by or indexed on the BY variable prior to merging.
Proc SQL - Data sets doesnot need to be sorted or indexed.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of sas?

804


What Proc glm does?

729


What are the special input delimiters used in SAS?

751


What does the RUN statement do?

949


What is data _null_?

785






I have a dataset concat having a variable a b & c. How to rename a b to e & f?

884


What are common programming errors committed in sas

761


What do you know about sas and what we do? : sas-grid-administration

689


Explain by-group processing?

692


Mention few capabilities of sas framework.

799


Are you involved in writing the inferential analysis plan? Tables specifications?

3558


Differences between where and if statement?

684


what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2006


How is character variable converted into numeric variable and vice versa?

710


What is interleaving in SAS?

768