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

Which statement does not perform automatic conversions in comparisons?

0 Answers  


how to display duplicated observations in a data using base sas.

13 Answers   HCL, TCS,


/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance

2 Answers   Eval Source,


/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;

5 Answers  


Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks

2 Answers  






Can you execute a macro within a macro? Describe. : sas-macro

0 Answers  


when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.

1 Answers  


what is transformation in sas data integration? : Sas-di

0 Answers  


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

0 Answers  


What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;

3 Answers  


At compile time when a SAS data set is read, what items are created?

14 Answers   Accenture,


What are TEAEs

2 Answers   Accenture, Quintiles,


Categories