Diff between proc sql merge and join?



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

Post New Answer

More SAS Interview Questions

how do you debug and test your sas programs? : Sas programming

0 Answers  


How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?

3 Answers   Reddy Labs,


For clinical entire study how many tables will create approx?

0 Answers   TCS,


What are the statements that are executed only?

0 Answers  


What is SAS? What are the functions does it performs?

0 Answers  






What is criteria for adverse events and treatment-emergent adverse events?

2 Answers   Accenture,


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

8 Answers  


how to generate report for 0 observation dataset?

3 Answers   Mind Tree, Student,


what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

0 Answers  


What are symbol tables?Differemce between Local N Global Symbol tables.....

2 Answers   TCS,


what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?

1 Answers   Satyam,


If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

0 Answers  


Categories