Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Re:


From   austin nichols <austinnichols@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Re:
Date   Fri, 2 Sep 2005 13:55:24 -0400

Going from long data like 

id  p   obs
1   10  1
1   5   2
1   6   3
2   3   1
2   1   2
2   5   3

to wide data like:

id p1  p2  p3
1  10  5   6
2  3   1   5

requires the -reshape- command, which has changed many times over the
different versions of Stata--in fact, I believe both Stata 6 and Stata
7 implemented changes during their intervals as the most current
versions.

I certainly remember one of them causing trouble for me running an old
do-file under version control with old reshape command syntax that was
good in an earlier version of that release number (I think it was 6)
but not in the last version.

The short answer would be, look at the help file on your system to
determine the -reshape- syntax that applies to you.  Or

. version 5
. reshape groups obs
. reshape vars p
. reshape cons id
. reshape long

should work for you, assuming you've got the obs variable defined.  If
not, -sort- your data the way you want before you run the above, and

. qui by id: gen long obs=_n

Perhaps Nick Cox has several versions of Stata 6 installed, and is in
a better position to answer this question...

On 9/2/05, <clinton.thompson@summitllc.us> wrote:
> Stata commands tend (always?) to be lowercase.  Try
> reshape wide x i(id) j(rate)
> And I'm not sure about v.6, but you may have to include a comma after
> wide, e.g.
> reshape wide, i(id) j(rate)
> Good luck,
> Clint
> 
> > Hello, I tried Stephen Bradleys command, to transpose data but got this
> > error.
> >
> > Reshape wide x i(id) j(rate)
> > reshape already defined
> > (error occurred while loading Reshape.ado)
> > r(110);
> >
> > Can someone explain? I am a new user and using version 6
> > Thanks
> > Jeff

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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