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

st: RE: Reshape


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Reshape
Date   Tue, 10 Feb 2004 14:14:00 -0000

Looks something like 

reshape long x1_ x2_ x3_ x4_ x5_ , i(code) j(year) 

forval i = 1/5 { 
	rename x`i'_ x`i'
} 

Nick 
n.j.cox@durham.ac.uk 

absc11@bangor.ac.uk
 
> 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,

*
*   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