topic Re: I need help to create 1 to 7 sequence in whole dataset in New SAS User

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

kk26 — Fri, 24 Apr 2020 21:41:47 GMT

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.

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

Reeza — Sat, 25 Apr 2020 00:51:47 GMT

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;