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

From |
Friedrich Huebler <huebler@rocketmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
st: Re: How to extract and recode variables in a multiple member household survey |

Date |
Thu, 10 Feb 2005 16:58:37 -0800 (PST) |

Regina, Have you considered to -reshape- your data? I find survey data easier to work with if one observation represents one household member. You could then look at these FAQs: http://www.stata.com/support/faqs/data/anyall.html http://www.stata.com/support/faqs/data/members.html Friedrich --- ra248@columbia.edu wrote: > I have the following problem. I am working with a household survey > and I need to separate the information of the mother. I have a set > of variables recording a set of characteristics for each household > member. For instance, variable S_i (where i=1,…,46) records the sex > of the ith member. Variable A_i records the age of the ith member > and so on. I also have a variable that takes the value of i for > the mother in the household. > > My dataset looks like this: > > ID Mom S_1 A_1 S_2 A_2 S_3 A_3… S_46 A_46 > 1 2 M 24 F 22 F 12 M 67 > 2 1 F 29 M 32 M 8 . . > 3 46 F 76 M 75 F 46 F 41 > . > . > > What I need is to identify the mother in each row and create a set > of separate variables for her (i.e. MS, MA), while at the same > time deleting the original mother observation from the original > data set of variables (shown below). > > > ID Mom S_1 A_1 S_2 A_2 S_3 A_3… S_46 A_46 MS MA > 1 2 M 24 . . F 12 M 67 F 22 > 2 1 . . M 32 M 8 . . F 29 > 3 46 F 76 M 75 F 46 . . F 41 __________________________________ Do you Yahoo!? All your favorites on one personal page – Try My Yahoo! http://my.yahoo.com * * 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/

**Follow-Ups**:**Re: st: Re: How to extract and recode variables in a multiple member household survey***From:*ra248@columbia.edu

**References**:**st: How to extract and recode variables in a multiple member household survey***From:*ra248@columbia.edu

- Prev by Date:
**RE: st: Superimposing graphs** - Next by Date:
**Re: st: Re: How to extract and recode variables in a multiple member household survey** - Previous by thread:
**st: How to extract and recode variables in a multiple member household survey** - Next by thread:
**Re: st: Re: How to extract and recode variables in a multiple member household survey** - Index(es):

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