Diff between proc sql merge and join?

Question Posted / saikrishna2cherish

Diff between proc sql merge and join?..

Answer / 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

More SAS Interview Questions

What SAS statements would you code to read an external raw data file to a DATA step?

Why double trailing @@ is used in input statement?

What is by-group processing?

who is the best SAS clinical Trainer in Hyderabad?

In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?

Explain the difference between using drop = data set option in set and data statement?

How to get part of string form the source string without using sub string function in SAS?

How would you combine 3 or more tables with different structures?

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

Tell e how how dealt with..

Differentiate between sas functions and sas procedures.

For more SAS Interview Questions Click Here