Re: st: Re: Fill Missing values at the End

[Sadia Khalid <sadiakhalid234@gmail.com>]

Thanks Nick Cox for your reply.
I am extremely sorry for this. That why i have posted this question again.

Kindly Consider this data

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

What I want to 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 42.1
1997 Aqueela 42.5
1998 Aqueela 43.0
1999 Aqueela 43.4
2000 Aqueela 43.9
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 59.3
1997 Abida 62.9
1998 Abida 66.7
1999 Abida 70.7
2000 Abida 75.0
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


Kindly do not consider the previous data .
take this data into consideration.
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.
Similarly for other individuals.


Regards
Sadia Khalid

On 9 January 2014 18:00, Nick Cox <njcoxstata@gmail.com> wrote:
> <>
>
> In fact
>
> http://www.stata.com/statalist/archive/2014-01/msg00231.html
>
> is not even internally consistent.
> Nick
> njcoxstata@gmail.com
>
>
> On 9 January 2014 12:53, Nick Cox <njcoxstata@gmail.com> wrote:
>> This question gets more difficult to understand, not less. Let's focus
>> on Abida. You say you want to get
>>
>> 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 42.1
>> 1997 Abida 42.5
>> 1998 Abida 43.0
>> 1999 Abida 43.4
>> 2000 Abida 43.9
>>
>> whereas in http://www.stata.com/statalist/archive/2014-01/msg00231.html
>> the data were stated to be
>>
>> 1990 Abida 57.0
>> 1991 Abida 44.3
>> 1992 Abida 41.3
>> 1993 Abida 92.3
>> 1994 Abida 42.2
>> 1995 Abida 56.0
>>
>> and you said you wanted
>>
>> 1996 Abida 96.6
>> 1997 Abida 113.0
>> 1998 Abida 132.0
>> 1999 Abida 154.4
>> 2000 Abida 180.4
>>
>> What's up with 1995?
>>
>> What rule gets you from 82.7 to 42.1 (this post)?
>>
>> What rule gets you from 56.0 to 96.6 (this post)?
>>
>> There couldn't be good answers if the questions make no sense.
>>
>> Nick
>> njcoxstata@gmail.com
>>
>>
>> On 9 January 2014 04:01, Sadia Khalid <sadiakhalid234@gmail.com> wrote:
>>> Sir
>>> I am new to Stata and do not know how to write codes.
>>>
>>> Sir I have posted in the previous messages what i have and what i want to get.
>>> 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
>>>
>>>
>>> What I want to get.
>>> 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 42.1
>>> 1997 Aqueela 42.5
>>> 1998 Aqueela 43.0
>>> 1999 Aqueela 43.4
>>> 2000 Aqueela 43.9
>>> 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 42.1
>>> 1997 Abida 42.5
>>> 1998 Abida 43.0
>>> 1999 Abida 43.4
>>> 2000 Abida 43.9
>>> 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
>>>
>>>
>>> actually the code is not giving the above mentioed results.
>>>
>>> Please help me out.
>>>
>>>
>>>
>>>
>>> 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/
> *
> *   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/