I think you should do
reshape long x1 x2...., i(code country industry) j(year 90-99)
a.
----- Original Message -----
From: <[email protected]>
To: <[email protected]>
Sent: Tuesday, February 10, 2004 3:04 PM
Subject: st: Reshape
> 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/
*
* 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/
