topic Re: subsetting a dataset where multiple variables equal the same number in SAS Programming

subsetting a dataset where multiple variables equal the same number

BenBrady — Fri, 11 Aug 2017 00:32:36 GMT

i want to subset my dataset by where multiple variables are equal to the number 1. I have been doing this by using the following code:

data want;

set have;

where group=1 or fish-=1 or net=1 or food=1;

run;

I was wandering if there was a shorter way to write this, as it would be much longer if there were a lot of variables. i.e something along the lines of writing all the variables out and only having to write one '=1' in the code.

Cheers

Re: subsetting a dataset where multiple variables equal the same number

Reeza — Fri, 11 Aug 2017 00:40:59 GMT

WHICHN()

where whichn(1, var1, var2, var3, ... );

If you can use IF instead variable lists can be used:

if whichn(1, of var:)>0;

Re: subsetting a dataset where multiple variables equal the same number

novinosrin — Fri, 11 Aug 2017 01:16:23 GMT

@BenBradyIf you wanna play:

data have;

a=1;

b=0;

c=0;

output;

a=0;

b=0;

c=0;

output;

run;

data want;

set have;

array n _numeric_;

if 1 in n;

run;