Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

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,
> 
> Adam Chapman
> 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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index