Please write codes to merge two datasets and keep every
record in the first dataset.



Please write codes to merge two datasets and keep every record in the first dataset...

Answer / reshma

proc sort data=dataA;
by commonvar;
run;

proc sort data=dataB;
by commonvar;
run;

data new;
merge dataA (in=a) dataB (in=b);
if a ;
by commonvar;
run;

Is This Answer Correct ?    14 Yes 0 No

Post New Answer

More SAS Interview Questions

what are sas/access and sas/connect? : Sas programming

0 Answers  


How would you code a macro statement to produce information on the SAS log? This statement can be coded anywhere.

8 Answers  


What is SAS?

0 Answers  


What does error:1 mean?

8 Answers   Accenture,


Name statements that are recognized at compile time only?

3 Answers   Accenture,






Why is SAS considered self-documenting?

1 Answers   Quintiles,


what is Business Intelligence?

3 Answers   CitiGroup,


What type of tables you are using in YOUR reporting..???

2 Answers   GSK GlaxoSmithKline,


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

0 Answers  


what is Difference between PROC SQL JOINS and MERGE?

3 Answers   Accenture, Wipro,


What is maximum storage capability of SAS?

0 Answers  


what is slowly changing dimension? : Sas-di

0 Answers  


Categories