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/