Statalist


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

st: Generating index numbers with panel data in long format


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

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/



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