Solved: Re: query - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Quartz | Level 8

Quartz | Level 8

query

Posted 12-31-2014 12:35 PM (1230 views)

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

1 ACCEPTED SOLUTION

Accepted Solutions

Amethyst | Level 16

Amethyst | Level 16

Re: query

Posted 12-31-2014 12:45 PM (1290 views) | In reply to rakeshvvv

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

Thanks,
Jag

View solution in original post

2 REPLIES 2

Amethyst | Level 16

Amethyst | Level 16

Re: query

Posted 12-31-2014 12:45 PM (1291 views) | In reply to rakeshvvv

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

Thanks,
Jag

Ammonite | Level 13

Ammonite | Level 13

Re: query

Posted 12-31-2014 04:29 PM (1133 views) | In reply to rakeshvvv

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