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

What is your favorite all time computer book? Why?

2272


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

921


What Proc glm does?

866


How do you control the number of observations and/or variables read or written?

1030


What is the good sas programming practices for processing large data sets?

895


how sas deals with business intelligence? : Sas-bi

833


what is broad cast agent? : Sas-bi

841


explain the difference between proc means and proc summary?

901


Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1483


I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2495


What does P-value signify about the statistical data?

1121


how can you put a "trace" in your program? : Sas programming

836


Differences between where and if statement?

809


What is the difference between reading data from an external file and reading data from an existing data set?

938


how can you import .csv file in to sas? : Sas programming

869