topic SAS_merging two datasets in All Things Community

SAS_merging two datasets

Khaladdin — Sat, 25 Mar 2017 14:53:06 GMT

Hi all,

I want to merge two data sets in SAS. I want to show by using example:

Group Value
A 10
A 8
A 6
B 7
B 9
B 11

it is my first data set. I have the second dataset as well:

Group Volume
A 2
B 3

I want to merge these two data sets. The result should be:

Group Value Volume
A 10 2
A 8 2
A 6 2
B 7 3
B 9 3
B 11 3

I hope, i can explain it. Many thanks.

Re: SAS_merging two datasets

Miracle — Sat, 25 Mar 2017 15:20:33 GMT

if by datastep

data first;
input Group $ Value @@;
datalines;
A 10 A 8 A 6 B 7 B 9 B 11
;
run;
data second;
input Group $ Volume @@;
datalines;
A 2 B 3
;
run;
proc sort data=first; by Group; run;
proc sort data=second; by Group; run;
data want; merge first second; by Group; run;
proc print data=want noobs; run;

Re: SAS_merging two datasets

Khaladdin — Sat, 25 Mar 2017 15:29:35 GMT

Thank you very much. it works