Remove observations in Dataset A based on variables present in Dataset B- why am I getting an error?

[learn2]

Hi,

I have two datasets (raw and trmnt) and I am trying to remove some observations in Dataset A (raw data) based on Dataset B (trmnt, containing IDs of those who need to be removed from Dataset A), because individuals have an unknown treatment status. 

I merged the datasets A and B together by using the following code:

data cohort;

merge raw trmnt;

by id;

if raw and not trmnt;

run;

Then when I run the code, it yields 0 observations and a note stating raw and trmnt are uninitialized... but in the previous line of code SAS read the individual observations from each of the datasets. Any insight on why this could be? Thanks!

[SuryaKiran · Accepted solution]

Hi,

Your missing IN= option.

data cohort;
merge raw(in=in1) trmnt(in=in2);
by id;
if in1=1 and in2=0;
run;

[learn2]

Thank you so much! It worked 🙂

[PeterClemmensen]

Welcome to the SAS communities 🙂 I think what you try to do is this

data cohort;
   merge raw(in=a) trmnt(in=b);
   by id;
   if a and not b;
run;

Let us know if it works. If it does not, please provide some example data for us to test and work with.

[learn2]

It worked thanks!

[Reeza]

Please mark one of the solutions as the answer.