topic query in SAS Procedures

query

rakeshvvv — Wed, 31 Dec 2014 17:35:33 GMT

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

Re: query

Jagadishkatam — Wed, 31 Dec 2014 17:45:34 GMT

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

Re: query

stat_sas — Wed, 31 Dec 2014 21:29:05 GMT

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