BookmarkSubscribeRSS Feed
wil1212
Calcite | Level 5

I would like to merge three datasets A, B, and C to find all the obs in A that do not match B and C. B and C are both subsets of A. Obs in B and C do not match each other.

 

I have tried the code below and many other logic test, but I cannot seem to get the right output. Any help would be appreciated.

 

data want;

merge A(in= inA) B(in=inB) C(in=inC);

by id date;

if not inA or (not inB and not inC) then

output want;

run;

1 REPLY 1
bnawrocki
Quartz | Level 8

So you want to keep all records in A that don't find matches in either B or C?

 

I would suggest this code:

data want;
   merge a(in=inA) b(in=inB) c(in=inC);
   by id date;
   if inA and not inB and not inC;
run;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 1 reply
  • 1123 views
  • 3 likes
  • 2 in conversation