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]

st: Fill Missing values at the End


From   Sadia Khalid <[email protected]>
To   [email protected]
Subject   st: Fill Missing values at the End
Date   Wed, 8 Jan 2014 18:55:17 +0500

Hi

I have working on Panel data. For some of the individuals end 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 formula for calculating the growth rate is
=((41.6/39.9)^(1/(5-1))-1). 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 1996-2000
First I will have to find the r=growth rate of values from 1991-1995.
Than 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 last indiviual values are missing from 1995-2000
if for any indiviual more than 5 values are missing do not fill that.
any code for this

what i have
year name y
1990 Aqueela 50.1
1991 Aqueela 39.9
1992 Aqueela 93.4
1993 Aqueela 53.4
1994 Aqueela 5.9
1995 Aqueela 41.6
1996 Aqueela
1997 Aqueela
1998 Aqueela
1999 Aqueela
2000 Aqueela
1990 Abida 57.0
1991 Abida 44.3
1992 Abida 41.3
1993 Abida 92.3
1994 Abida 42.2
1995 Abida 56.0
1996 Abida
1997 Abida
1998 Abida
1999 Abida
2000 Abida
1990 Zubaida 68.5
1991 Zubaida 51.0
1992 Zubaida 41.7
1993 Zubaida 91.5
1994 Zubaida 40.7
1995 Zubaida
1996 Zubaida
1997 Zubaida
1998 Zubaida
1999 Zubaida
2000 Zubaida

and what i want

year name y
1990 Aqueela 50.1
1991 Aqueela 39.9
1992 Aqueela 93.4
1993 Aqueela 53.4
1994 Aqueela 5.9
1995 Aqueela 41.6
1996 Aqueela 96.6
1997 Aqueela 113.0
1998 Aqueela 132.0
1999 Aqueela 154.4
2000 Aqueela 180.4
1990 Abida 57.0
1991 Abida 44.3
1992 Abida 41.3
1993 Abida 92.3
1994 Abida 42.2
1995 Abida 82.7
1996 Abida 96.6
1997 Abida 113.0
1998 Abida 132.0
1999 Abida 154.4
2000 Abida 180.4
1990 Zubaida 68.5
1991 Zubaida 51.0
1992 Zubaida 41.7
1993 Zubaida 91.5
1994 Zubaida 40.7
1995 Zubaida
1996 Zubaida
1997 Zubaida
1998 Zubaida
1999 Zubaida
2000 Zubaida

Regards
Sadia Khalid

*
*   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