|
|  |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
RE: st: monthly moving average
Maybe someone who is currently working with panel data can answer this one.
-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands
visiting address:
Buitenveldertselaan 3 (Metropolitan), room Z434
+31 20 5986715
http://home.fsw.vu.nl/m.buis/
-----------------------------------------
-----Original Message-----
From: [email protected] [mailto:[email protected]]On Behalf Of Ana Gabriela Guerrero Serdan
Sent: woensdag 28 maart 2007 12:33
To: [email protected]
Subject: Re: st: monthly moving average
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 <[email protected]> wrote:
> --- Ana Gabriela Guerrero Serdan
> <[email protected]> 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
>
> visiting address:
> 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/
*
* 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/
