Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Reshape


From   absc11@bangor.ac.uk
To   statalist@hsphsun2.harvard.edu
Subject   st: Reshape
Date   Tue, 10 Feb 2004 14:04:51 +0000

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 Im doing something
wrong because Im 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/



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