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

Re: st: Reshape


From   Edwin Leuven <e.leuven@uva.nl>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Reshape
Date   Tue, 10 Feb 2004 15:13:29 +0100 (CET)

i don't see why

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

wouldn't work

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

-- 
Edwin Leuven
Department of Economics
University of Amsterdam
Roetersstraat 11
1018 WB Amsterdam
the Netherlands
tel: +31 20 525 5241
fax: +31 20 525 4310
http://www.fee.uva.nl/scholar/mdw/leuven
*
*   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