i don't see why
reshape long x1_ x2_ x3_ x4_ x5_, i(code country industry) j(year)
wouldn't work
> Dear statalisters,
>
> I have the following data format:
>
> code country industry x1_90 x1_91 ... x1_99 x2_90 x2_91 ... x2_99 x3_90 etc
> n1 UK GEN . . ... . . . ... . .
> n2 SP BIO . . ... . . . ... . .
> n3 NL SUP . . ... . . . ... . .
> n4 GR ITE . . ... . . . ... . .
> n5 PT AUT . . ... . . . ... . .
>
> And I wish to reshape the dataset as follows:
>
> code country industry YEAR x1 x2 x3 x4 x5
> n1 UK GEN 90
> n1 UK GEN 91
> . . . .
> n1 UK GEN 99
> n2 SP BIO 90
> n2 SP BIO 91
> . . . .
> n2 SP BIO 99
> n3 NL SUP 90
> n3 NL SUP 91
> . . . .
> n3 NL SUP 99
>
> etc
>
> Now, I tried the -reshape- related commands but obviously I�m doing something
> wrong because I�m not able to get the format I need.
> Can someone please advice me on this,
>
> many thanx in advance,
> Dimitris
>
> --
> This mail sent through http://webmail.bangor.ac.uk
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
--
Edwin Leuven
Department of Economics
University of Amsterdam
Roetersstraat 11
1018 WB Amsterdam
the Netherlands
tel: +31 20 525 5241
fax: +31 20 525 4310
http://www.fee.uva.nl/scholar/mdw/leuven
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/