Statalist


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

RE: st: RE: reshape problem


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: RE: reshape problem
Date   Tue, 9 Dec 2008 18:53:32 -0000

Despite various attempts your problem looks just as puzzling as when
first posted. 

If there is some way for you to post your data file in an accessible
place, interested people will be able to look themselves. 

Alternatively, I suggest you get in touch with StataCorp tech-support. I
guess they will want a copy of the file too. 

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

Emanuele Millemaci

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

*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index