Hello Experts,
I have two datasets as following below. I would like to know which observations are matched and unmatched. So I am going to create a dummy variable. 1 is coded If an observation is matched or exist in both datasets and 0 is coded if the observation is unmatched. Can anyone tell me how I can write the code? Thanks in advance!!!
Dataset1
ID1 ID2 Year
1 246 1990
12 359 1991
25 427 1993
Dataset2
ID1 ID2 Year
1 246 1990
6 531 1995
42 236 2002
25 427 1993
Assuming your datasets are sorted:
data want;
merge ds1(in=in1) ds2(in=in2);
by id1 id2 year;
flag = in1 and in2;
run;
(untested)
Assuming your datasets are sorted:
data want;
merge ds1(in=in1) ds2(in=in2);
by id1 id2 year;
flag = in1 and in2;
run;
(untested)
Thank you PG! You are the Best!!!!
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.