Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Re: Generating index numbers with panel data in long format


From   Manfred Fleischer <mf.rott@googlemail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Re: Generating index numbers with panel data in long format
Date   Mon, 15 Jun 2009 22:30:29 +0200

Hi Martin,

Thank you for your "Here we go". It was a wonderful help in a perfect
format. I would have never found such an elegant solution  on my own.

Manfred

2009/6/15 Martin Weiss <martin.weiss1@gmx.de>:
> <>
>
>
> Here we go:
>
> ***
> clear*
>
> input countyid/*
> */ year entry exit
> 1 1983 35 33
> 1 1984 37 36
> 1 1985 38 39
> 2 1983 120 125
> 2 1984 122 127
> 2 1985 125 130
> end
>
> compress
> list, noobs/*
> */ sepby(countyid)
>
> bys countyid (year): /*
> */egen baseentry=total((year==1984)*entry)
> bys countyid (year): /*
> */egen baseexit=total((year==1984)*exit)
>
> bys countyid (year):/*
> */gen entry_index=100*entry/ baseentry
> bys countyid (year):/*
> */gen exit_index=100*exit/ baseexit
>
> list, noobs/*
> */ sepby(countyid)
> ***
>
>
> HTH
> Martin
> _______________________
> ----- Original Message ----- From: "Manfred Fleischer"
> <mf.rott@googlemail.com>
> To: <statalist@hsphsun2.harvard.edu>
> Sent: Monday, June 15, 2009 8:39 PM
> Subject: Re: st: Re: Generating index numbers with panel data in long format
>
>
>> Hi Martin,
>>
>> Thank you for the hint. I will work through the suggested SJ article.
>> Sorry, that I have not included the index numbers in the example. Here
>> they are using 1984 as the base year ...
>>
>> county-id year entry exit entry_index exit_index
>> 1 1983 35 33 94.6 91.7
>> 1 1984 37 36 100.0 100.0
>> 1 1985 38 39 102.7 108.3
>> etc.
>> 2 1983 120 125 98.4 98.4
>> 2 1984 122 127 100.0 100.0
>> 2 1985 125 130 102.5 102.4
>> etc.
>>
>> Thanks,
>> Manfred
>>
>>
>>
>> 2009/6/15 Martin Weiss <martin.weiss1@gmx.de>
>>>
>>> <>
>>>
>>> Could you give us a hint what the calculation of the "index number" would
>>> look like in your example? I have a feeling that
>>> http://www.stata-journal.com/sjpdf.html?articlenum=pr0004
>>> will be the solution, but just write down what your result should look
>>> like...
>>>
>>> HTH
>>> Martin
>>> _______________________
>>> ----- Original Message ----- From: "Manfred Fleischer"
>>> <mf.rott@googlemail.com>
>>> To: <statalist@hsphsun2.harvard.edu>
>>> Sent: Monday, June 15, 2009 7:57 PM
>>> Subject: st: Generating index numbers with panel data in long format
>>>
>>>
>>>> Hi,
>>>>
>>>> Would anyone know whether there exists a possibility to generate index
>>>> numbers over time with panel data stored in long format.
>>>>
>>>> The dataset consists of new firm entry and exit rates for German
>>>> counties from 1983 to 2004. It looks like this
>>>>
>>>> county-id year entry exit
>>>> 1 1983 35 33
>>>> 1 1984 37 36
>>>> 1 1985 38 39
>>>> etc.
>>>> 2 1983 120 125
>>>> 2 1984 122 127
>>>> 2 1985 125 130
>>>> etc.
>>>>
>>>> Now I would like to generate index numbers by county for entry and
>>>> exit e.g. with 1984 as the base year. I have looked for egen and
>>>> time-series commands, but I couldn't find a solution. Maybe the only
>>>> solution is to reshape the file into the wide format, compute the
>>>> index numbers there and then return with the generated index numbers
>>>> in the long format. But that's what I don't know.
>>>>
>>>> Any help is very much appreciated.
>>>> Thanks,
>>>> Manfred
>>>> ----------------------------------------------------------------
>>>> Manfred Fleischer
>>>> D-52159 Roetgen-Rott (Kreis Aachen), Germany
>>>> Page: http://www.wzb.eu/mp/mps/people/manfred_fleischer.en.htm
>>>>
>>>> *
>>>> * For searches and help try:
>>>> * http://www.stata.com/help.cgi?search
>>>> * http://www.stata.com/support/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/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/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/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/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index