topic Re: Where statement for several variables in SAS Programming

Where statement for several variables

mayasak — Sun, 19 Dec 2021 02:01:43 GMT

I'm trying to get a subset dataset which contains variables uns_n and sns_n ne '.' and uns_n and sns_n ne 0 and drug = 'abc'.

Here's the code I had:

data ABgn;
set ABgn_Miss (where=(drug='abc') and uns_n ne . & uns_n ne 0 & sns_n ne . & sns_n ne 0 );
run;

I also tried different ways but I'm not getting the right data set needed.

I'm wondering what is the best way to do it.

Thank you

Re: Where statement for several variables

SASKiwi — Sun, 19 Dec 2021 04:51:37 GMT

Try this - it looks like your brackets aren't quite right.

data ABgn;
set ABgn_Miss (where=(drug='abc' and uns_n not in (.,0) and sns_n not in (.,0));
run;

Re: Where statement for several variables

Astounding — Sun, 19 Dec 2021 13:22:47 GMT

A useful shortcut:

set ABgn_Miss (where=(drug='abc' and uns_n and sns_n));

Numeric values of missing and zero are considered to be false while all other values are considered to be true.

Re: Where statement for several variables

mayasak — Mon, 20 Dec 2021 21:54:41 GMT

Thank you. That was helpful