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
--- [email protected] 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/