Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Eric A. Booth
Public Policy Research Institute
Texas A&M University
On Sep 17, 2010, at 2:54 AM, Kaspar Dardas wrote:
> Hello statalisters,
> I have an unbalanced panel dataset with about 50 Variables and 30000
> observations between 2003 - 2010 in long format.
> I need to create a running rum variable"3m_sum_variable" which
> aggregates a certain variable (lets call it) "value" 3 months into the
> past. In other words, the variable "3m_sum_variable" should be the sum
> of all "value" variables which occurred in the last 3 months relative
> (and including) to the current observation.
> I think I might create such a variable fairly easy with reshaping.
> However, since I have about 50 Variable I would rather work with my
> long format and create a loop which "goes back 3 months" into the past
> and aggregates the previous "value" variables. Does anybody know of a
> loop that can do this efficiently for an unbalanced panel datatset?
> Best & thanks,
> * 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/
* For searches and help try: