I need help to create 1 to 7 sequence in whole dataset

[kk26]

Dear All,

I am trying to create variable seq that has sequence 1 to 7 max by subject and start date.if by variables changes then again it will starts from 1 but max 7 only. please check this excel file for final output should look like this. i have tried many times but can not able to solve this issue on my own. 

[Reeza · Accepted solution]

Here's the a very simple way.

RETAIN holds the value across the rows. 

FIRST.SEX is one on the first record of every Sex grouping and 0 otherwise. 

proc sort data=sashelp.class out=class;
by sex;
run;

data want;
set class;
by sex;
retain count;
if first.sex then count=1;
else if count=7 then count=1;
else count+1;
run;