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 are some good sas programming practices for processing very large data sets? : Sas programming

591


Name types of category in which SAS Informats are placed?

837


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

703


what are the benefits of data integration? : Sas-di

632


Enlist the functions performed by sas.

774






what has been your most common programming mistake? : Sas programming

666


In sas admin differentiate between roles and capabilities? : sas-grid-administration

652


What are the statements that are executed only?

774


what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

786


What can you learn from the SAS log when debugging?

1007


what is change analysis in sas di ? : Sas-di

686


what is the use of proc sql? : Sas programming

686


What is proc sort?

809


Do you need to know if there are any missing values?

687


Why and when do you use proc sql?

850