topic Re: Cumulative count based on other variable in SAS Data Management

Cumulative count based on other variable

Yilikal_Tesfaye — Wed, 16 May 2018 21:16:05 GMT

DATA ALL ;
SET ALL ;
by pa_id sa_id admin notsorted;
IF first.admin then seq +1;
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

Re: Cumulative count based on other variable

novinosrin — Wed, 16 May 2018 21:17:06 GMT

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;
if admin='o' then count+1;
run;

Re: Cumulative count based on other variable

novinosrin — Wed, 16 May 2018 21:19:49 GMT

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;
if admin='o' then count+1;
run;

Re: Cumulative count based on other variable

Yilikal_Tesfaye — Wed, 16 May 2018 21:32:12 GMT

Thank you in advance.