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]

From |
Sadia Khalid <[email protected]> |

To |
[email protected] |

Subject |
Re: st: Missing Values - Extrapolation |

Date |
Wed, 8 Jan 2014 10:45:08 +0500 |

Thanks David for your reply. I am not getting the desired results as i have posed. i have a panel data for 20 indiviuals over the time period 1990 to 2000. no of variables is 25. some of the variables values are missing for start and some of the variables values are missing at the end. if five or less than five values are missing , then i have to fill these values. Thanks On 8 January 2014 10:19, David Ashcraft <[email protected]> wrote: > 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?search > * http://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/ * * 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/

**Follow-Ups**:**Re: st: Missing Values - Extrapolation***From:*David Ashcraft <[email protected]>

**References**:**st: Missing Values - Extrapolation***From:*Sadia Khalid <[email protected]>

**Re: st: Missing Values - Extrapolation***From:*David Ashcraft <[email protected]>

- Prev by Date:
**Re: st: Missing Values - Extrapolation** - Next by Date:
**Re: st: Missing Values - Extrapolation** - Previous by thread:
**Re: st: Missing Values - Extrapolation** - Next by thread:
**Re: st: Missing Values - Extrapolation** - Index(es):