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

st: Re: Reshape


From   "Anna D'Addio" <anna.daddio@hiva.kuleuven.ac.be>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: Reshape
Date   Tue, 10 Feb 2004 15:20:01 +0100

I think you should do
reshape long x1 x2...., i(code country industry) j(year 90-99)

a.
----- Original Message ----- 
From: <absc11@bangor.ac.uk>
To: <statalist@hsphsun2.harvard.edu>
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 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/

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