[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: Re: How to extract and recode variables in a multiple member household survey
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:
--- firstname.lastname@example.org 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!
* For searches and help try: