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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is program data vector? : Sas-administrator

614


Mention what is PROC in SAS?

603


Compare sas with other data analytics tools.

583


Name types of category in which SAS Informats are placed?

736


What are the applications primarily used by business analyst? : Sas-bi

552






What is the general format of function in sas? : sas-grid-administration

569


why is sas data integration studio important? : Sas-di

561


What do the SAS log messages "numeric values have been converted to character" mean?

888


What are the advantages of using sas?

607


what do you mean by data staging area? : Sas-di

605


How do you connect the desktop application to metadata server? : sas-grid-administration

584


What are the functions which are used for character handling functions?

620


How can sas program be validated?

577


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

611


How would you identify a macro variable?

651