what is Difference between PROC SQL JOINS and MERGE?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

why a stop statement is needed for the point= option on a set statement?

823


Describe a time when you were really stuck on a problem and how you solved it?

2424


How do you connect the desktop application to metadata server? : sas-grid-administration

854


How many ways to overcome a missing values???

2557


Describe what are the different levels of administrative users in sas? : sas-grid-administration

797


Explain the purpose of substr functions in sas programming.

804


Which command is used to save logs in the external file?

813


What is the maximum length of the macro variable? : sas-macro

854


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

1382


What Proc glm does?

843


What is by-group processing?

754


how does sas handle missing values in sort order? : Sas programming

729


What are the prime responsibilities of data integration administrator? : Sas-di

820


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

898


How to create list output for cross-tabulations in proc freq?

857