BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
dapenDaniel
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

Assuming your datasets are sorted:

 

data want;
merge ds1(in=in1) ds2(in=in2);
by id1 id2 year;
flag = in1 and in2;
run;

(untested)

 

PG

View solution in original post

2 REPLIES 2
PGStats
Opal | Level 21

Assuming your datasets are sorted:

 

data want;
merge ds1(in=in1) ds2(in=in2);
by id1 id2 year;
flag = in1 and in2;
run;

(untested)

 

PG
dapenDaniel
Obsidian | Level 7

Thank you PG! You are the Best!!!!

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1172 views
  • 0 likes
  • 2 in conversation