topic Re: How to account for order in a do loop in SAS Programming

How to account for order in a do loop

sdaniels429 — Sun, 23 May 2021 20:42:02 GMT

Dear SAS users,

I'm trying to capture change as well as the order of change in a do loop. But I can't get the code to work. Below is my hypothetical data and code. I want to create a "censor" variable for the observations to flag those who got category=2 and never got category=4 with the rest of the days. So for example, id=1 should get censor=1, but id=2 or id=3 shouldn't because it got category=4 afterwards.

With my current code, I'm only able to code id=1 and id=3 correctly. I realize I shouldn't use do until but I can't get do while to work. I also don't have to stick to the do loop if that's not the appropriate approach. Any suggestion is appreciated.

Thanks in advance!

data have;
input ID days category;
datalines;

1 89 4
1 79 3
1 60 2
1 2 1
2 88 3
2 72 2
2 70 1
2 50 4
3 88 2
3 35 4
;
run;

proc sort data=have ;
by ID descending days;
run;

data have2;
do until(last.ID);
set have;
by ID category notsorted;
if lag(category)^=4 and category=2 then censor=1;
end;
run;

Re: How to account for order in a do loop

SASKiwi — Sun, 23 May 2021 21:15:07 GMT

How about this? Don't think you need a DO loop.

data have;
input ID days category;
datalines;
1 89 4
1 79 3
1 60 2
1 2 1
2 88 3
2 72 2
2 70 1
2 50 4
3 88 2
3 35 4
;
run;

proc sort data=have ;
by ID descending days;
run;

data have2;
  set have;
  by ID;
  if first.id then censor = 0;
  retain censor;
  if category = 2 then censor = 1;
  if censor = 1 and category = 4 then censor = 0;
run;

Re: How to account for order in a do loop

sdaniels429 — Mon, 24 May 2021 00:22:17 GMT

thank you @SASKiwi very much! That resolved my problem! I appreciate your help!