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

How do you test for missing values?

1053


Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3058


Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

1577


What are the functions used for character handling?

637


List down the reasons for choosing sas over other data analytics tools.

806






Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

1908


How would you identify a macro variable? : sas-macro

529


What is the differnce between SDTM 3.1.2 to 3.1.1 version

4609


explain the proc in sas? : Sas-administrator

618


What makes sas stand out to be the best over other data analytics tools?

584


What do the PUT and INPUT functions do?

773


Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1344


What is the function of Stop statement in a SAS Program?

642


Differentiate input and infile.

592


How do dates work in SAS data?

682