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!!!!
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.