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 does sas handle missing values in functions? : Sas programming

870


how do you test for missing values? : Sas programming

805


Which function is used to count the number of intervals between two sas dates?

870


What are the difference between sas functions and procedures?

870


Of all your work, where have you been the most successful?

4448


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

800


Approximately what date is represented by the SAS date value of 730?

1002


How would you define the end of a macro? : sas-macro

871


what do the pad and dim functions do? : Sas programming

805


How are numeric and character missing values represented internally?

1408


which date function advances a date, time or datetime value by a given interval? : Sas programming

821


How would you identify a macro variable?

871


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

877


what is broad cast agent? : Sas-bi

840


Where do you use proc means over proc freq?

788