Solved
New Contributor
Posts: 4

# Cumulative count based on other variable

[ Edited ]
``````DATA ALL ;
SET ALL ;
run;``````

Dear all,

I need your unreserved help. I am using SAS version 9.4.  I want to count admin variable in cumulative fashion for value "o" by pa_id, sa_id, time.

the structure of the data is given below

I am expecting like this

Accepted Solutions
Solution
‎05-16-2018 05:31 PM
PROC Star
Posts: 1,547

## Re: Cumulative count based on other variable

``````data have;
input pa_id	sa_id 	time	Admin \$;
cards;
1	11	23	o
1	11	36	o
1	11	82	p
1	12	45	o
1	12	55	p
1	12	67	o
1	12	70	o
1	12	90	o
2	13	36	o
2	13	46	o
2	13	59	p
2	14	25	p
2	14	34	o
2	14	40	p
;
data want;
set have;
by pa_id sa_id;
if first.sa_id then do; count=0;cum_count=1;end;
else cum_count+1;
run;``````

All Replies
PROC Star
Posts: 1,547

## Re: Cumulative count based on other variable

[ Edited ]

I'm afraid pics or screen shots doesn't help in ease of copy pasting the data values

untested

data want;
set have;
by pa_id sa_id;
if first.sa_id then do; count=0;cum_count=1;end;
else cum_count+1;
run;

Solution
‎05-16-2018 05:31 PM
PROC Star
Posts: 1,547

## Re: Cumulative count based on other variable

``````data have;
input pa_id	sa_id 	time	Admin \$;
cards;
1	11	23	o
1	11	36	o
1	11	82	p
1	12	45	o
1	12	55	p
1	12	67	o
1	12	70	o
1	12	90	o
2	13	36	o
2	13	46	o
2	13	59	p
2	14	25	p
2	14	34	o
2	14	40	p
;
data want;
set have;
by pa_id sa_id;
if first.sa_id then do; count=0;cum_count=1;end;
else cum_count+1;
run;``````
New Contributor
Posts: 4