topic Re: Running Totals and Running Growth Rate in SAS Programming

Running Totals and Running Growth Rate

BCNAV — Thu, 25 Jul 2019 20:14:04 GMT

I have data like:

Day Current Previous Growth

1 10 5 1.0

2 20 10 1.0

3 30 15 1.0

etc.

I would like to add another variable that creates a running total (RT) and running growth rate:

Day Current Previous Growth RT_Curr RT_Prev RT_Growth

1 10 5 1.0 10 5 1.0

2 20 10 1.0 30 15 1.0

3 30 15 1.0 60 30 1.0

etc.

Is there an easy way to do this in SAS? Datastep?

Thanks!

PaigeMiller — Thu, 25 Jul 2019 20:22:48 GMT

I can't determine from your example how running total growth is computed. Nevertheless, running totals are simple.

data want;
    set have;
    rt_curr+current;
    rt_prev+previous;
run;

BCNAV — Mon, 29 Jul 2019 18:58:05 GMT

Totally forgot about that !!! Thx!