what is Difference between PROC SQL JOINS and MERGE?

Answer Posted / nrtya vardhanapu

merge is a statement which is used in the data step Whereas
join is a procedure which is used in the proc step. But the
outputs produced are the same !!!!

Is This Answer Correct ?    0 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what do you mean by data staging area? : Sas-di

844


Explain the main difference between the sas procedures and functions? : Sas-administrator

803


What is the difference between proportion and average?

3017


Explain the purpose of retain statement.

810


What is proc sort?

910


For what purposes have you used sas macros? : sas-macro

774


What does the trace option do?

885


What is the general format of function in sas? : sas-grid-administration

781


what is SAS OPTIMIZATION?

2042


explain what is data set in sas? : Sas-administrator

740


What is the purpose of trailing @ and @@? How do you use them?

799


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

858


Differentiate between ceil and floor functions.

895


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

887


What is the purpose of _character_ and _numeric_?

823