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

how can you create zero observation dataset? : Sas programming

639


Differentiate between ceil and floor functions.

658


what is information maps?

1616


Explain translate function?

631


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1460






Mention what are the data types does SAS contain?

696


What is the role of unrestrictive users? : sas-grid-administration

571


Tell e how how dealt with..

1757


In sas admin differentiate between roles and capabilities? : sas-grid-administration

556


what are the scrubbing procedures in sas? : Sas programming

831


How substr function works in sas?

701


Given an unsorted data set, how to read the last observation to a new data set?

837


Explain the difference between using drop = data set option in set and data statement?

682


What is connection profile? : sas-grid-administration

647


Differences between where and if statement?

582