Re: st: RE: reshape problem

[Antoine Terracol <terracol@univ-paris1.fr>]

I had no problems -reshape-ing your data:


. reshape long x, i(regio) j(year)
(note: j = 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 
1975 1976 1977 1978 1979 1980 1981 1982 1983 1984
>  1985 1986 1987 1989 1990 1991 1992 1993 1994 1995 1996 1997 1999 
2000 2001 2002 2003 2004 2005 2006)

Data                               wide   ->   long
-----------------------------------------------------------------------------
Number of obs.                       21   ->     882
Number of variables                  43   ->       3
j variable (42 values)                    ->   year
xij variables:
                  x1963 x1964 ... x2006   ->   x
-----------------------------------------------------------------------------

. su

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       regio |       882          11    6.058736          1         21
       annee |       882    1984.095    12.81874       1963       2006
           x |       882    31.23255    9.333917      9.844     50.513


You could try to re-install Stata (?)

Antoine


Emanuele Millemaci wrote:
> 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/

*
*   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/