Looks something like
reshape long x1_ x2_ x3_ x4_ x5_ , i(code) j(year)
forval i = 1/5 {
rename x`i'_ x`i'
}
Nick
[email protected]
[email protected]
> 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,
*
* 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/
