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 <[email protected]>:
> 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
> [email protected]
>
> 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/
