Statalist


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

Re: st: RE: reshape problem


From   "Emanuele Millemaci" <e.millemaci@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: reshape problem
Date   Tue, 9 Dec 2008 21:03:04 +0100

As the file *.dta containing the dataset is small(few KB), I try to
send it attached to this message. Alternatively, such a file can be
downloaded  at this link:

http://www.2shared.com/file/4425484/c1951cbd/produc.html
(perhaps, need to wait few seconds before displaying the working link
at the bottom of the page)

The command I use is
reshape long x, i(regio) j(year)

Thanks
Emanuele

2008/12/9 Nick Cox <n.j.cox@durham.ac.uk>:
> 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/
>
*
*   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