Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: moving average with event data
From
A Loumiotis <[email protected]>
To
[email protected]
Subject
Re: st: moving average with event data
Date
Tue, 27 Dec 2011 17:14:41 +0200
Hi Knill,
You could use -tsfill- to fill in the gaps in your time variable.
Best,
Antonis
On Tue, Dec 27, 2011 at 4:32 PM, Knill, April <[email protected]> wrote:
> I am trying to create a five-year moving average using data that has payments. The data contain only years where there are payments, i.e., there are no observations when payments are not made. So, for example, for the data below, I would like Stata to calculate a trailing 5-year average for firm 2177 in the year 2000 as (1000 + 0 + 500 + 1000 + 0)/5. In other words, for the non-observations, Stata should count this as a zero. This is different than the posts I saw which actually had an observation for ALL years and simply a "." If the data were a manageable size I could just go in input the observations but this is a dataset of several thousand firms. Can I still create this moving average?
>
> FirmNo Year DollarPmnt
> 2177 1991 41700
> 2177 1992 44850
> 2177 1994 32900
> 2177 1995 33200
> 2177 1997 41350
> 2177 2000 60958
> 3331 1991 1000
> 3331 1996 4500
> 10002 1992 800
> 10002 1997 1000
> 10002 1998 500
> 10002 2000 1000
> 10002 2001 2000
> 10002 2002 2500
> 10002 2003 2000
> 10002 2004 1000
>
>
> Best Regards,
>
> April Knill, Ph.D.
>
>
>
> *
> * 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:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/