topic Re: Running Total by Group with New Variable in SAS Programming

Running Total by Group with New Variable

BCNAV — Tue, 14 Jul 2020 14:57:48 GMT

I have a dataset that is organized by a variable called daily_grouping. I would like a running total based on the daily_grouping. For example, the following:

Daily_Grouping	Amt
104095512	1
104095512	3
104095512	4
104095512	5
104095513	10
104095513	11
104095513	15
104095513	22

Would become:

Daily_Grouping	Amt	Run_Tot
104095512	1	1
104095512	3	4
104095512	4	8
104095512	5	13
104095513	10	10
104095513	11	21
104095513	15	36
104095513	22	58

thanks in advance!

Re: Running Total by Group with New Variable

Reeza — Tue, 14 Jul 2020 15:07:52 GMT

data want;
set have;
by daily_grouping;
retain run_tot;
if first.daily_grouping then run_tot = amt;
else run_tot+amt;
run;

Re: Running Total by Group with New Variable

Kurt_Bremser — Tue, 14 Jul 2020 15:31:14 GMT

It seems you have this question at least once a year.