topic Re: How to merge two datasets by two variables in SAS Programming

How to merge two datasets by two variables

tim-hahn — Wed, 03 Jun 2020 13:15:15 GMT

Hi SAS users,

thank you for taking your time.

I have the dataset "Data1", with a structure like this:

And I have the Dataset "Sum1", which looks like this:

I would like to merge those two so that for every row in data set "Data1" the corresponding values of variables sum1 and n from Dataset "Sum1" show up if the Jahr=Jahr and if ICBSUC=ICBSUC

So for example for every observation in data set "Data1" which in from Jahr 2010 and has an industry code ICBSUC of 10101010 the value in the variable sum1 should be 1.173... and the value in variable n should be 19.

my current code looks like this:

proc sort data=work.Data1;

by ICBSUC;

run;

proc summary data=Data1 nway;

class icbsuc Jahr;

var KehrwertM;

output out=sum1 sum=sum1 n=n;

run;

data Data2;

merge Data1 sum1 (in =in2);

by Jahr icbsuc;

if in2;

run;

thank you for your help!

Re: How to merge two datasets by two variables

Jagadishkatam — Wed, 03 Jun 2020 13:37:32 GMT

I believe the code what you wrote is correct, a minor update to include if in1 and in2 as below

data Data2;
    merge Data1(in=in1) sum1 (in =in2);
    by Jahr icbsuc;
    if in1 and in2;
run;

Re: How to merge two datasets by two variables

smantha — Wed, 03 Jun 2020 16:10:30 GMT

proc sort data=work.Data1;

by ICBSUC Jahr;

run;

proc summary data=Data1 nway;

class icbsuc Jahr;

var KehrwertM;

output out=sum1 sum=sum1 n=n;

run;

data Data2;

merge Data1 sum1 (in =in2);

by icbsuc Jahr;

if in2;

run;