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.
This is pretty straighforward if you provide some sample data 🙂
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:
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=helpcenter...
Related to your problem: http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=basess&docsetTarget=p19t3r1gxa...
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.