Merging 3 datasets to find no matches

wil1212 — Tue, 22 Nov 2016 17:34:44 GMT

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;

Re: Merging 3 datasets to find no matches

bnawrocki — Tue, 22 Nov 2016 17:53:26 GMT

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;

topic Re: Merging 3 datasets to find no matches in SAS Programming

Merging 3 datasets to find no matches

Re: Merging 3 datasets to find no matches