topic Re: Enumeration Varible 3 By Groups in SAS Programming

Enumeration Varible 3 By Groups

eabc0351 — Tue, 02 Apr 2019 00:16:13 GMT

Hello. I am trying to create an enumeration variable that must take into account 3 by groups. I need to get two different variables - one restarts by patient ID and the other keeps counting. All the solutions online and on this forum are not working. Please assist. This is what I am going for:

PID RID LID RestartVariable CountVariable (trying to get the last two variables)

141 57 19 1 1

141 58 13 2 2

141 58 14 3 3

141 59 20 4 4

142 59 25 1 5

142 60 26 2 6

143 60 26 1 7

Thank you.

Re: Enumeration Varible 3 By Groups

PeterClemmensen — Tue, 02 Apr 2019 00:23:07 GMT

Like this?

EDIT: I edited my code because you changes your question. I think this is what you want. But shouldn't RestartVariable=1 at the bottom?

EDIT2: I see you changed your question again 🙂 @eabc0351 does this work for you?

data have;
input PID RID LID;
datalines;
141 57 19
141 57 19
141 58 13
141 58 14
141 59 20
141 59 20
142 59 25
142 59 25
142 59 25
142 60 26
143 60 26
;

data want;
   set have;
   by PID notsorted RID notsorted LID notsorted;
   if first.PID | first.RID | first.LID then do;
      CountVariable+1;
      RestartVariable+1;
   end;
   if first.PID then RestartVariable=1;
run;

Re: Enumeration Varible 3 By Groups

eabc0351 — Tue, 02 Apr 2019 00:24:29 GMT

Hi @PeterClemmensen. Yes, I messed up the bottom number. This solution works for both variables. Thank you for your assistance.

Re: Enumeration Varible 3 By Groups

PeterClemmensen — Tue, 02 Apr 2019 00:27:43 GMT

Anytime, glad to help 🙂