Easy way to do IF X = 1 2 3 or 4 THEN Y = 0

[pramenon1]

Hi,

Was wondering if there was a less tedious way to write my below code: Essentially I am trying to say that if the anti retroviral therapy they have is type 3, 4, 5, etc the they are using a combination ART (ie. 2). What I have below works, but is there an easier way to write this out?

DATA dtanl.hivcancerdta;
set dtanl.hivcancerdta;
IF arv1_d1 = . THEN arvtype = .;
ELSE IF arv1_d1 = 3 THEN arvtype = 2;
ELSE IF arv1_d1 = 4 THEN arvtype = 2;
ELSE IF arv1_d1 = 5 THEN arvtype = 2;
ELSE IF arv1_d1 = 11 THEN arvtype = 2;
ELSE IF arv1_d1 = 14 THEN arvtype = 2;
ELSE IF arv1_d1 = 42 THEN arvtype = 2;
ELSE IF arv1_d1 = 44 THEN arvtype = 2;
ELSE IF arv1_d1 = 45 THEN arvtype = 2;
RUN;

Thank you!

[PaigeMiller · Accepted solution]

DATA dtanl.hivcancerdta;
set dtanl.hivcancerdta;
IF arv1_d1 = . THEN arvtype = .;
ELSE IF arv1_d1 in (3,4,5,11,14,42,44,45) then arvtype = 2;
RUN;

[pramenon1]

Quick follow up, along with arv1_d1, i also have arv1_d2 and arv1_d3. Is there a way to make this same condition apply to arv1_d2 and arv1_d3 etc?

Below is the long way but is there a shorter way?

ELSE IF arv1_d1 in (3,4,5,11,14,42,44,45) then arvtype = 2;
ELSE IF arv1_d2 in (3,4,5,11,14,42,44,45) then arvtype = 2;
ELSE IF arv1_d3 in (3,4,5,11,14,42,44,45) then arvtype = 2;
ELSE IF arv2_d1 in (3,4,5,11,14,42,44,45) then arvtype = 2;

[Tom]

To repeat the same logic across multiple variables use an array.

array list arv1_d1 arv1_d2 arv1_d3 arv2_d1 ;
arvtype=.;
do index=1 to dim(list) until (arvtype=2);
  IF list[index] in (3,4,5,11,14,42,44,45) then arvtype = 2;
end;

[Tom]

Use the IN operator instead of the = operator.

For consecutive integers you can even use the min:max syntax. 

IF arv1_d1 = . THEN arvtype = .;
ELSE IF arv1_d1 in (3:5 11 14 42 44 45) THEN arvtype = 2;