Where statement for several variables

[mayasak]

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

[SASKiwi]

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;

[Astounding · Accepted solution]

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.

[mayasak]

Thank you. That was helpful