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

From |
Antoine Terracol <terracol@univ-paris1.fr> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: RE: reshape problem |

Date |
Tue, 09 Dec 2008 21:17:06 +0100 |

I had no problems -reshape-ing your data: . reshape long x, i(regio) j(year)

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 MillemaciI had a dataset on excel with regions on the rows and years on thecolumns.I moved this data to Stata 10.1 MP(updated to the latest packages)andwas trying to reshaping from wide to long as I would like to haveallyears' 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 isalwaysdifferent (every time I launch the command) and never correct. Stata drops many observations and many others become missing forsomevariable (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/

**Follow-Ups**:**Re: st: RE: reshape problem***From:*Antoine Terracol <terracol@univ-paris1.fr>

**References**:**st: reshape problem***From:*"Emanuele Millemaci" <e.millemaci@gmail.com>

**Re: st: RE: reshape problem***From:*"Ada Ma" <heu034@googlemail.com>

**Re: st: RE: reshape problem***From:*"Emanuele Millemaci" <e.millemaci@gmail.com>

**Re: st: RE: reshape problem***From:*"Anders Alexandersson" <andersalex@gmail.com>

**Re: st: RE: reshape problem***From:*"Emanuele Millemaci" <e.millemaci@gmail.com>

**RE: st: RE: reshape problem***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

**Re: st: RE: reshape problem***From:*"Emanuele Millemaci" <e.millemaci@gmail.com>

- Prev by Date:
**st: Re: Exporting results after -table-** - Next by Date:
**RE: st: RE: reshape problem** - Previous by thread:
**Re: st: RE: reshape problem** - Next by thread:
**Re: st: RE: reshape problem** - Index(es):

© Copyright 1996–2017 StataCorp LLC | Terms of use | Privacy | Contact us | What's new | Site index |