Hi I need help with calculating the sum of observation by ID
My data look like this;
ID drug day_supply
1 A 30
1 A 30
1 B 10
2 B 15
2 B 15
2 B 15
I want to create a variable that sums up the day_supply
ID drug Total_day_supply
1 A 60
1 B 10
2 B 45
Thanks in advance!
Alternatively, you could use proc summary:
data have; input ID drug $ day_supply; cards; 1 A 30 1 A 30 1 B 10 2 B 15 2 B 15 2 B 15 ; proc summary data=have; var day_supply; by id drug; output out=want (drop=_:) sum=total_day_supply; run;
Art, CEO, AnalystFinder.com
something like this
proc sql;
create table newtable as
select id, drug, sum(day_supply) as total_day_supply
from yourtable
group by id, drug;
quit;
Alternatively, you could use proc summary:
data have; input ID drug $ day_supply; cards; 1 A 30 1 A 30 1 B 10 2 B 15 2 B 15 2 B 15 ; proc summary data=have; var day_supply; by id drug; output out=want (drop=_:) sum=total_day_supply; run;
Art, CEO, AnalystFinder.com
Thanks you all for providing the answers.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.