# Re: st: monthly moving average

 From Ana Gabriela Guerrero Serdan To statalist@hsphsun2.harvard.edu Subject Re: st: monthly moving average Date Wed, 28 Mar 2007 03:32:59 -0700 (PDT)

```Dear Maarten,

thanks. I actually want to do a moving "proportion".
Sorry for being clear.

Since I had data at the individual level, I have
created another dataset that sums the deaths per
month. I can calculate the proportion permonth, but I
want to create a moving proportion which will be for
Proportion1=# female/total population for all months,
all years. For Proportion2= # female/total for
months2-12 under year 2003 and all months next years.
Etc.. so the tssmooth ma will give me an average and I
think I can only lead N/2. What I did is after using
collapse (sum) :

sort year month

. list  month year female male sex_unknown  total

+-------------------------------------------------+
month   year   female   male   sex_un~n   total
-------------------------------------------------
1.      3   2003      182    264       5915    6361
2.      4   2003       72    109       1798    1979
3.      5   2003       24    371         68     463
4.      6   2003       31    447         94     572
5.      7   2003       34    523         37     594
-------------------------------------------------
6.      8   2003       43    587        111     741
7.      9   2003       33    435         36     504
8.     10   2003       27    331         94     452
9.     11   2003       29    351         34     414
10.     12   2003       27    411         48     486
-------------------------------------------------
11.      1   2004       33    415         79     527
12.      2   2004       24    374        149     547
13.      3   2004       55    606        257     918
14.      4   2004      205    400        588    1193

Then I can generate a proportion just by
using gen=sum(female)/sum(total) but how can I specify
that this has to be calculated by moving downwards one
month every time?

Also, If I use monthly data instead of individual data
I cant calculate the confidence intervals.

So what do you suggest?

Thanks again.

Regards,
Gaby

--- Maarten buis <maartenbuis@yahoo.co.uk> wrote:

> --- Ana Gabriela Guerrero Serdan
> <ag_guerreroserdan@yahoo.com> wrote:
> > I want to create a program that will calculate the
> proportion of
> > women or men as a moving average. This proportion
> will move per
> > month.
>
> see -help tssmooth ma-
>
> Hope this helps,
> Maarten
>
> -----------------------------------------
> Maarten L. Buis
> Department of Social Research Methodology
> Vrije Universiteit Amsterdam
> Boelelaan 1081
> 1081 HV Amsterdam
> The Netherlands
>
> Buitenveldertselaan 3 (Metropolitan), room Z434
>
> +31 20 5986715
>
> http://home.fsw.vu.nl/m.buis/
> -----------------------------------------
>
>
>
>
___________________________________________________________
>
> What kind of emailer are you? Find out today - get a
> free analysis of your email personality. Take the
> quiz at the Yahoo! Mail Championship.
>
http://uk.rd.yahoo.com/evt=44106/*http://mail.yahoo.net/uk
>
> *
> *   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/
```