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/
