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 is sas enterprise intelligence architecture? : Sas-bi

0 Answers  


what are the types of interactive display types? : Sas-bi

0 Answers  


how do the in= variables improve the capability of a merge? : Sas programming

0 Answers  


what is chi-square test? have you used that?

1 Answers   Accenture, Quintiles,


What is run-group processing?

0 Answers  






How do you put a giraffe into the refrigerator?

3 Answers   Oracle,


what is sas application server? : Sas-di

0 Answers  


Name few SAS functions?

0 Answers  


Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.

4 Answers  


define table lookup and how may ways it can be done...explian

3 Answers  


SAS using companies in chennai

1 Answers  


What is the difference between %local and %global? : sas-macro

0 Answers  


Categories