As always, the _exact_ code you are using
is instructive. But this does indeed sound
like a single step:
reshape long inc ed , i(id) j(year)
There is a similar example in the on-line help.
Also, this FAQ
http://www.stata.com/support/faqs/data/reshape3.html
offers further commentary.
Nick
[email protected]
Jonathan A. Schwabish
> I am trying to reshape a panel data set and am sure
> there is a more efficient way than what I've tried so
> far and was hoping someone could help.
>
> Let's say I have seven variables, an "id", three
> income variables (inc80, inc81, inc82) and three
> education variables (ed80, ed81, ed82). The way I've
> been reshaping a data set like this is to perform a
> reshape, save the file, do another reshape and save
> that file, and then merge the two together by "id". Is
> there a way to reshape the entire data set in one
> step?
*
* 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/