Did you specify the "string" option when using reshape?
*************************************************
Tobias Pfutze
Visiting Assistant Professor
Georgetown Public Policy Institute
----- Original Message -----
From: James Hicks <[email protected]>
Date: Thursday, June 19, 2008 3:19 pm
Subject: st: Manipulating a data structure
> Hi all:
>
> I have a simple question (sorry!) about reformatting a data structure.
>
> A simplified version of my current data looks like this:
>
> cou prec race mode votetype total
> 1 1 1 1 over x1
> 1 1 1 1 under y1
> 1 1 1 1 blank z1
> 1 1 1 2 over x2
> 1 1 1 2 under y2
> 1 1 1 2 blank z2
> 1 1 1 3 over x3
> 1 1 1 3 under y3
> 1 1 1 3 blank z3
> 1 1 2 1 over x4
> 1 1 2 1 under y4
> 1 1 2 1 blank z4
> 1 1 2 2 over x5
> 1 1 2 2 under y5
> 1 1 2 2 blank z5
> 1 1 2 3 over x6
> 1 1 2 3 under y6
> 1 1 2 3 blank z6
> 1 2 1 1 over x7
> 1 2 1 1 under y7
> 1 2 1 1 blank z7
> 1 2 1 2 over x8
> 1 2 1 2 under y8
> 1 2 1 2 blank z8
> 1 2 1 3 over x9
> 1 2 1 3 under y9
> 1 2 1 3 blank z9
>
> etc...
>
> This pattern repeats first for a number of different values of
> 'race',
> and then all over again for several values of 'prec'. 'Cou' is
> uniform
> within each of the datasets. Since the smallest unit that we want
> to
> analyze is cou x prec x race x mode, I'm trying to make the data
> take
> on this more compact shape:
>
> cou prec race mode over under blank
> 1 1 1 1 x1 y1 z1
> 1 1 1 2 x2 y2 z2
> 1 1 1 3 x3 y3 z3
> 1 1 2 1 x4 y4 z4
> 1 1 2 2 x5 y5 z5
> 1 1 2 3 x6 y6 z6
> 1 1 3 1 x7 y7 z7
> 1 1 3 2 x8 y8 z8
> 1 1 3 3 x9 y9 z9
> 1 2 1 1 x10 y10 z10
> 1 2 1 2 x11 y11 z11
> 1 2 1 3 x12 y12 z12
> 1 2 2 1 x13 y13 z13
> 1 2 2 2 x14 y14 z14
> 1 2 2 3 x15 y15 z15
> 1 2 3 1 x16 y16 z16
> 1 2 3 2 x17 y17 z17
> 1 2 3 3 x18 y18 z18
>
> So, I want to turn the 'votetype' variable into three separate
> variables for each of its values. I thought this was a case for
> reshape, but I can't seem to produce the right result. Can anyone
> point me in the right direction?
>
> Many thanks,
>
> James
>
> *
> * 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/
