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.
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;
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;
SAS Innovate 2025: Save the Date
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!