11-22-2016 12:34 PM
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.
merge A(in= inA) B(in=inB) C(in=inC);
by id date;
if not inA or (not inB and not inC) then
11-22-2016 12:53 PM
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;