topic Re: Merging Two data sets in SAS Programming

Merging Two data sets

Kiko — Wed, 19 Apr 2017 14:05:23 GMT

Hello,

I have two datasets called A and B- group B is a subset of group A (everyone in group B should be in group A), and group B is the people who had an event/outcome, and ultimately I'd like to have a master dataset w. people who had an event and who had not had an event. Then I would like to have a new variable (e.g. outcome) and assign values so that everyone from B should have 1 and the rest of the people have 0. What SAS procedures should I use? Any suggestion/examples would be greatly appreciated.

Thank you.

Re: Merging Two data sets

PeterClemmensen — Wed, 19 Apr 2017 14:07:44 GMT

This is pretty straighforward if you provide some sample data 🙂

Re: Merging Two data sets

Reeza — Wed, 19 Apr 2017 14:12:32 GMT

This is data management, combing datasets, which is handled either in a data step or proc SQL.

Data want;

set A B indsname=source;

source_dsn = source;

run;

Relevant reference, there's many examples here:

http://support.sas.com/documentation/cdl/en/basess/68381/HTML/default/viewer.htm#p19t3r1gxavpoin14jdd23gcheve.htm

Re: Merging Two data sets

andreas_lds — Wed, 19 Apr 2017 14:15:19 GMT

Similar questions are asked at least daily, please use the search functionality.

New documentation site: http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=basewn&docsetTarget=helpcenterfeedback.htm&locale=de

Re: Merging Two data sets

Astounding — Wed, 19 Apr 2017 14:22:35 GMT

If B is a subset of A, you could use this approach:

proc sort data=a;

by id;

run;

proc sort data=b;

by id;

run;

data want;

merge a b (in=b);

by id;

outcome=b;

run;

You haven't told us the names of your variables, so I'm using ID here as the common variable to match on.