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 <[email protected]>
>
> <>
>
> 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" <[email protected]>
> To: <[email protected]>
> 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/
