[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
Tobias Pfutze <tp95@georgetown.edu> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Manipulating a data structure |

Date |
Fri, 20 Jun 2008 10:11:55 -0400 |

Does that mean you solved the problem? As far as I can see "i(prec race mode)" should define a logical observation. ************************************************* Tobias Pfutze Visiting Assistant Professor Georgetown Public Policy Institute ----- Original Message ----- From: James Hicks <james@earlyvoting.net> Date: Thursday, June 19, 2008 7:36 pm Subject: Re: st: Manipulating a data structure > 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/ > * * 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/

- Prev by Date:
**Re: st: Re: interpretation of mfx** - Next by Date:
**Re: st: split window view of do files** - Previous by thread:
**Re: st: Manipulating a data structure** - Next by thread:
**RE: st: R: Spearman's rank correlation coefficient - power calculation** - Index(es):

© Copyright 1996–2014 StataCorp LP | Terms of use | Privacy | Contact us | What's new | Site index |