topic Re: Easy way to do IF X = 1 2 3 or 4 THEN Y = 0 in New SAS User

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

pramenon1 — Tue, 13 Jul 2021 19:14:45 GMT

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!

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

PaigeMiller — Tue, 13 Jul 2021 19:18:48 GMT

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;

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

Tom — Tue, 13 Jul 2021 19:20:09 GMT

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;

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

pramenon1 — Tue, 13 Jul 2021 19:43:11 GMT

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;

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

Tom — Tue, 13 Jul 2021 19:53:54 GMT

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;