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/