topic How do I create a sort variable that restarts the count when a new subject occurs in the next rows? in SAS Programming

How do I create a sort variable that restarts the count when a new subject occurs in the next rows?

Hello_there — Fri, 18 Nov 2022 18:25:05 GMT

Hello,

I'm trying to create a sort variable that restarts every new subject.

data have;
	input subject $;
datalines;
001
001
002
003
003
003
004
006
007
007
008
;
run;

desired output:

PaigeMiller — Fri, 18 Nov 2022 18:52:56 GMT

data want;
    set have;
    by subject;
    if first.subject then sort=0;
    sort+1;
run;

Hello_there — Fri, 18 Nov 2022 18:56:36 GMT

Thanks, PaigeMiller, this worked!

Kurt_Bremser — Fri, 18 Nov 2022 18:57:24 GMT

data want;
set have;
by subject;
if first.subject
then sort = 1;
else sort + 1;
run;

Use of a SUM statement causes an implied retain.