Re: st: Reshape help

[Philipp Rehm <philipp.rehm@gmx.de>]

Perhaps this:

reshape wide z, i(y) j(x)
drop y

HTH,
Philipp

Joe Trubisz wrote:
> Hi....
>
> I have a reshape (I think) problem, and I can't get what I
> want. Hopefully, someone can assist me.
>
> I have a dataset that looks like the following:
>
> x y z
> 1 1 11
> 1 2 12
> 1 3 13
> 2 1 21
> 2 2 22
> 2 3 23
> 3 1 31
> 3 2 32
> 3 3 33
>
> And I want to reshape it so it looks like
> 11 21 31
> 12 22 32
> 13 23 33
>
> where all the z values are arranged in columns by x
> (column 1 contains the z values where x=1, etc.)
>
> Any help here would be greatly appreciated.
>
> Thanks,
> Joe
> *
> *   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/
*
*   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/