topic paired data merging in SAS Programming

paired data merging

Archibald2 — Wed, 18 Jul 2018 17:42:28 GMT

Hello,

I need to merge the DATASET 1 with DATASET 2 to get to a final dataset "DATA WANT" and I need some guidance.

please note that dataset 1 is a matched pair data of students and dataset 2 contains additional variables on the matched pairs data.

DATASET 1

DATASET 2

DATA WANT

Any help would be appreciated. Thanks

Astounding — Wed, 18 Jul 2018 18:33:58 GMT

If I understand the problem correctly, this should work:

data dataset1_revised;

set dataset1;

id = groupA_id;

grade = groupA_grade;

sex = groupA_sex;

output;

id = groupB_id;

grade = groupB_grade;

sex = groupB_sex;

output;

keep id grade sex;

run;

The rest becomes a more commonplace sort + merge:

proc sort data=dataset1_revised nodupkey;

by id;

run;

proc sort data=dataset2 out=dataset2_revised nodupkey;

by id;

run;

data want;

merge dataset1_revised dataset2_revised;

by id;

run;

Archibald2 — Wed, 18 Jul 2018 21:06:37 GMT

Many thanks Astounding!

This is what I wanted to accomplish. Note- I added a keep statement for dataset1_revised since the last statement did work only for dataset2_revised.