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

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

learn2 — Tue, 11 Dec 2018 21:26:09 GMT

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!

Re: Remove observations in Dataset A based on variables present in Dataset B- why am I getting an er

SuryaKiran — Tue, 11 Dec 2018 21:30:34 GMT

Hi,

Your missing IN= option.

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

Re: Remove observations in Dataset A based on variables present in Dataset B- why am I getting an er

PeterClemmensen — Tue, 11 Dec 2018 21:31:40 GMT

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.

Re: Remove observations in Dataset A based on variables present in Dataset B- why am I getting an er

learn2 — Tue, 11 Dec 2018 21:35:55 GMT

Thank you so much! It worked 🙂

Re: Remove observations in Dataset A based on variables present in Dataset B- why am I getting an er

learn2 — Tue, 11 Dec 2018 21:36:20 GMT

It worked thanks!

Re: Remove observations in Dataset A based on variables present in Dataset B- why am I getting an er

Reeza — Tue, 11 Dec 2018 21:39:42 GMT

Please mark one of the solutions as the answer.