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 would you change about your job?

1926


what is the difference between infile and input? : Sas-administrator

607


What do you know about sas data set?

592


Mention some common errors that are usually committed in sas programming.

588


Enlist the syntax rules followed in sas statements.

617






what is proc Index? and what is proc document?

1995


What do the SAS log messages "numeric values have been converted to character" mean?

888


Differentiate between format and informat? : sas-grid-administration

578


What is the purpose of _character_ and _numeric_?

588


what is metadata? : Sas-bi

600


Explain the purpose of substr functions in sas programming.

563


Enlist the functions performed by sas.

674


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1098


what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

550


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

621