Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: RE: reshape problem


From   "Ada Ma" <[email protected]>
To   [email protected]
Subject   Re: st: RE: reshape problem
Date   Tue, 9 Dec 2008 15:31:07 +0000

Emanuele,

Have you read in the data correctly?  If the data isn't read in
correctly then it may not form a proper rectangle, which explains why
it doesn't -reshape- properly.

Ada


On Tue, Dec 9, 2008 at 1:41 PM, Martin Weiss <[email protected]> wrote:
> Sounds like a http://www.stata.com/statalist/archive/2005-11/msg01084.html
> problem... Where should the randomness come from in a command like
> -reshape-?
>
> HTH
> Martin
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Emanuele
> Millemaci
> Sent: Tuesday, December 09, 2008 1:27 PM
> To: [email protected]
> Subject: st: reshape problem
>
> Hi,
>
> I had a dataset on excel with regions on the rows and years on the columns.
> I moved this data to Stata 10.1 MP(updated to the latest packages) and
> was trying to reshaping from wide to long as I would like to have all
> years' data of the same variable on the same column.
>
> Below, I report an example of what I have:
>
> regio prod1995 prod1996 .....prod2006
>
> 1         ....             ...            ...
> 2          ...             ...            ...
> 3         ...              ...            ...
> 4         ...             ...            ...
>
> I would like to get:
>
> regio years    prod
> 1      1995    ...
> 1      1996    ...
> ..
> 2      1995    ...
> ..
> 3      1995    ...
> ..
> 4      1995    ...
> ..
>
> The command I use is:
>
> reshape long prod, i(regio) j(year)
>
> It would appear a very easy task. Instead, the result I get is always
> different (every time I launch the command) and never correct.
> Stata drops many observations and many others become missing for some
> variable (whereas my dataset has no missing value). I have also
> checked that Stata considers data as numeric.
>
> Thanks in advance,
>
> Emanuele
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>



-- 
Ada Ma
Research Fellow
Health Economics Research Unit
University of Aberdeen, UK.
http://www.abdn.ac.uk/heru/
Tel: +44 (0) 1224 553863
Fax: +44 (0) 1224 550926
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index