Re: st: Manipulating a data structure

[James Hicks <james@earlyvoting.net>]

Tobias,

Thanks for the tip: I did. It turns out to have been a problem with  
unique identifiers and subgroupings, although Stata was spewing out  
some strange output.

James

On Jun 19, 2008, at 1:42 PM, Tobias Pfutze wrote:


> 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/
*
*   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/