topic Re: How to enumerate specific values by a group using data step in SAS Programming

How to enumerate specific values by a group using data step

sboktor — Thu, 14 Apr 2022 15:54:11 GMT

I would like to assign ascending count for observations above certain value by id and start with the first observation of the id by 1 regardless of the value and continue the count if value is above 5 the output would be like:

id	days	event_count
A	1	1
A	5	0
A	2	0
A	4	0
A	7	2
A	5	0
A	8	3
A	2	0
A	1	0
A	16	4
B	1	1
B	5	0
B	2	0
B	4	0
B	7	2
B	5	0
B	8	3
B	2	0
B	1	0
B	16	4
B	4	0
B	5	0
B	3	0
B	4	0
B	7	5
B	8	6
B	8	7

Thank you.

Re: How to enumerate specific values by a group using data step

PaigeMiller — Thu, 14 Apr 2022 16:22:29 GMT

data want;
    set have;
    by id;
    if first.id then count=1;
    if days>5 then count+1;
    if days>5 or first.id then event_count=count;
    else event_count=0;
    drop count;
run;

Re: How to enumerate specific values by a group using data step

sboktor — Thu, 14 Apr 2022 17:05:36 GMT

Thank you PaigeMiller. The solution you suggested worked nicely.