Bookmark and Share

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: Missing Values - Extrapolation


From   David Ashcraft <[email protected]>
To   "[email protected]" <[email protected]>
Subject   Re: st: Missing Values - Extrapolation
Date   Tue, 7 Jan 2014 21:19:29 -0800 (PST)

You basically have two scenarios one requires backward calculations while the other is forward. 
I also believe Abida and Aqueela have some ids. 
you must tsset or txset your data   
mvencode var, mv(1000) override   /*this will encode the missing value*/
replace var=(1.04*L.var) if var==1000
replace var=. if var>999
mvencode var, mv(1000) override

replace var=(0.96*F.var) if var==1000

I hope this will work

David


On Wednesday, January 8, 2014 7:46:17 AM, Sadia Khalid <[email protected]> wrote:
Hi

I have working on Panel data. For some of the individuals starting and
ending values are missing. I have to fill these values by first
calculating the growth of the known five values.

Like for the individual Aqueela values for the year 1996 – 2000 are
missing. I will first calculate the growth rate of values from
1991-1995. The growth rate is 1.05%.now the value in 1996 = value in
1995*(1+growth rate).

And value in 1997= value in 1996 * (1+growth rate).

And so on.

For the second individual starting values are missing from 1990-1994.
First I will have to find the r=growth rate of values from 1995-1999.
Than the value in 1994 =value in 1995/(1+ growth rate) and

value in 1995 =value in 1996/(1+ growth rate) and so on.

I only have to fill in the missing values if the no of missing values
is less than or equal to five.

What i have

1990 Aqueela 50.06
1991 Aqueela 39.94
1992 Aqueela 93.36
1993 Aqueela 53.43
1994 Aqueela 5.89
1995 Aqueela 41.65
1996 Aqueela
1997 Aqueela
1998 Aqueela
1999 Aqueela
2000 Aqueela
1990 Abida
1991 Abida
1992 Abida
1993 Abida
1994 Abida
1995 Abida 84.82
1996 Abida 81.82
1997 Abida 78.82
1998 Abida 75.82
1999 Abida 72.82
2000 Abida 59.69


What I want to have
1990 Aqueela 50.06
1991 Aqueela 39.94
1992 Aqueela 93.36
1993 Aqueela 53.43
1994 Aqueela 5.89
1995 Aqueela 41.65
1996 Aqueela 42.08
1997 Aqueela 42.52
1998 Aqueela 42.97
1999 Aqueela 43.42
2000 Aqueela 43.87
1990 Abida 102.64
1991 Abida 98.79
1992 Abida 95.10
1993 Abida 91.54
1994 Abida 88.11
1995 Abida 84.82
1996 Abida 81.82
1997 Abida 78.82
1998 Abida 75.82
1999 Abida 72.82
2000 Abida 59.69

*
*   For searches and help try:
*  http://www.stata.com/help.cgi?searchhttp://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index