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 intially documentation in sas?

1 Answers   Accenture,


What is the size of PDV?

2 Answers   L&T,


What is the basic structure of a sas program?

0 Answers  


Given an unsorted data set, how to read the last observation to a new data set?

0 Answers  


What is instream data in SAS?

1 Answers  


If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?

4 Answers  


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

3 Answers  


What is the difference between proportion and average?

0 Answers   KPMG,


Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

0 Answers  


How to find out no. of business days in a month using macros.???(excluding weekends and holidays).

2 Answers   HSBC,


Difference b/n proc means and proc summary procedures?

3 Answers   Accenture,


Name statements that are execution only?

7 Answers  


Categories