query

[rakeshvvv]

I have a dataset with four variables id,acn,acn1,acn2 with id as identifier variable..I should output those records where  acn, acn1,acn2 are not equal to NOT APPLICABLE  or missing

[Jagadishkatam · Accepted solution]

please try

data want;

set have;

if acn not in ("NOT APPLICABLE",' ') and acn1 not in ("NOT APPLICABLE",' ') and acn2 not in ("NOT APPLICABLE",' ') then output;

run;

Thanks,

Jag

[stat_sas]

At least one or all of the variables acn, acn1,acn2 should satisfy conditions at the same time?