SAS Data Management

SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop, SAS Data Preparation and others
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.

 

sas-innovate-white.png

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

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
  • 4095 views
  • 2 likes
  • 2 in conversation