how can u join the two tables without using proc sql Joins
and nested queries ?

Answers were Sorted based on User's Feedback



how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / rajaanku11

By using the DATA step Merge.

Is This Answer Correct ?    30 Yes 1 No

how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / kumarravi111

we can use Merge and set statements to join the tables in
Data step

Is This Answer Correct ?    19 Yes 1 No

how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / sai

we can join two tables by using merge statement and also by
using two SET statements .


data one;
set two;
set three;
run;

Is This Answer Correct ?    3 Yes 0 No

how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / shiva,ibm

both above are right

Is This Answer Correct ?    4 Yes 2 No

how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / amit

By mearge statement

Is This Answer Correct ?    1 Yes 1 No

how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / vimal

actually i think UNION and UNION ALL is the correct answer.. since they ask related to that.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More SAS Interview Questions

I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

0 Answers  


What is the difference between match merge and one to one merge?

0 Answers  


hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

0 Answers   SAS,


What is interleaving in SAS?

0 Answers  


What is proc sql pass through facility?

4 Answers   L&T,






Explain the main difference between the sas procedures and functions? : Sas-administrator

0 Answers  


What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here

2 Answers  


Differentiate between proc means and proc summary.

0 Answers  


If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?

3 Answers   Accenture,


What is the role of unrestrictive users? : sas-grid-administration

0 Answers  


Mention the difference between ceil and floor functions in sas?

0 Answers  


I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,


Categories