abhishekdagarit
9/27/2017 - 3:39 PM

Merging datasets

Merging datasets in SAS

Merging datasets in SAS

The process is straight forward.

Data 1

data d1;
input name$ age;
datalines;
ak 12
bk 32
ck 22
;
run;

Data 2

data d2;
input name$ sex$;
datalines;
ak 'm'
bk 'f'
ck 'm'
;
run;

Merging datasets: Simply use merge ______ by

data combined_data;
merge d1 d2;
by name;
run;

Print statement

proc print data=combined_data;
run;