# Re: st: Manipulating a data structure

 From Tobias Pfutze To statalist@hsphsun2.harvard.edu Subject Re: st: Manipulating a data structure Date Thu, 19 Jun 2008 16:42:04 -0400

```Did you specify the "string" option when using reshape?

*************************************************

Tobias Pfutze
Visiting Assistant Professor
Georgetown Public Policy Institute

----- Original Message -----
From: James Hicks <james.hicks@reed.edu>
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/
```