BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Yilikal_Tesfaye
Fluorite | Level 6
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

 

prop data.PNG

 

I am expecting like this 

 

Capture1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20
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;

View solution in original post

3 REPLIES 3
novinosrin
Tourmaline | Level 20

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;

novinosrin
Tourmaline | Level 20
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;
Yilikal_Tesfaye
Fluorite | Level 6

Thank you in advance.

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 4279 views
  • 2 likes
  • 2 in conversation