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/