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

what is change analysis in sas di ? : Sas-di

801


What is the basic syntax style in SAS?

844


What is the purpose of _character_ and _numeric_?

817


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

1017


how does sas handle missing values in a merge? : Sas programming

779


how many display types available in sas bi dashboard? : Sas-bi

854


how many types of prompts are there? : Sas-bi

757


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

782


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

1156


What are the data types that sas contain?

902


What are the ways in which macro variables can be created in sas programming?

797


Do you need to know if there are any missing values?

806


how does sas handle missing values in formats? : Sas programming

849


how does sas handle missing values in assignment statements? : Sas programming

793


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

793