# st: RE: Calculating running cumulative totals

 From "Kieran McCaul" <[email protected]> To <[email protected]> Subject st: RE: Calculating running cumulative totals Date Wed, 16 Apr 2003 13:36:16 +0800

```sort month
gen cum12month=month[1]
replace cum12month=month[_n]+ cum12month[_n-1] if _n>1

> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of Adam Chapman
> Sent: Wednesday, 16 April 2003 1:27 PM
> To: [email protected]
> Subject: st: Calculating running cumulative totals
>
>
> I wonder if anyone can help me with this...
>
> I'm trying to calculate a running cumulative total for observations over
> the previous 12 months (cum12month).  My data looks like:
>
> # Obs  Month  Cum12month
> 2	1	2
> 4	2	6
> 3	3	9
> 1	4	10
> 2	5	12
> 4	6	16
> 2	7	18
> 1	8	19
> 5	9	24
> 3	10	27
> 2	11	29
> 4	12	33
> 5	13	36
> 2	14	34
> 3	15	34
> 2	16	35
> 4	17	37
> etc
>
> I'm sure this should be simple, but I can't work out an easy way
> to do this!
>
> Many thanks,
>
> Deakin University
> Melbourne, VICTORIA
>
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
>

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```