Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Maarten buis <maartenbuis@yahoo.co.uk> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: running sum |
Date | Wed, 4 Aug 2010 15:03:31 +0000 (GMT) |
--- On Wed, 4/8/10, Maximiliano Manuel Silva Correa wrote: > Suppose we have serveral power distribution lines (composed > of serveral substations) all around the states. Suppose our > variables are LINE SUBST POWER > > I want to generate a variable CUM_POW containing the > cummulative sum of POWER by LINE SUBST bys LINE (SUBST) : gen CUM_POW = sum(POWER) Within each line, Stata sorts on SUBST, and the -sum- function returns the running sum. Hope this helps, Maarten -------------------------- Maarten L. Buis Institut fuer Soziologie Universitaet Tuebingen Wilhelmstrasse 36 72074 Tuebingen Germany http://www.maartenbuis.nl -------------------------- * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/