Multiple OR comparison

Question

I have a group of variables , say b1-b30 and i need to test same condition on same variables among themselves like, if b1='a' or b2='a' or b3='a'.. and so on. is there any solution in SAS macros or using of sas arrays to do this task to avoid writing this explicitly. sample code is like this:

data test;
    input d1 d2 d3 d4 d5 ;
cards;
1 2 1 1 0
2 3 1 0 0 
0 0 0 1 0
0 2 1 0 2
0 4 0 2 2
0 0 0 0 3
;
run;

data want;
    set test;
    if d1=1 or d2=1 or d3=1 or d4=1 then flag=1;
    else flag=0;
run;

so i have around 50 variable , to test same condition and flag it .

score 2 · Answer 1 · answered Apr 12 '16 at 17:16

2

You could use WHICHN() or WHICHC() functions.

flag1 = not 0=whichn(1,of d1-d4);

answered Apr 12 '16 at 17:16

Tom

47,574
2
16
29

data _null_ · Answer 2 · 2016-04-12T17:29:48.120

1

The IN operator with array-name will work but you would need to make an array for each variable group. Using WHICHN would be easier.

array d[5];
if 1 in d then flag2=1; else flag2=0;

edited Apr 12 '16 at 17:29

answered Apr 12 '16 at 17:19

data _null_

8,534
12
14

Multiple OR comparison

2 Answers2