Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

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


From   ra248@columbia.edu
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Re: How to extract and recode variables in a multiple member household survey
Date   Thu, 10 Feb 2005 20:30:39 -0500

Dear listers,

I apologize for my last posting, as the formating didn't show my
data well. This is what I meant:

The variables S_i, A_i represent characteristics of household member
i.  The column Mom gives me the underscored value of where the Mom's
characteristics are. For instance, in the first household, the mom's
characteristics are S_2 and A_2 cause Mom takes the value 2. In the
second household, Mom is in S_1 and A_1...

Id   Mom   S_1   A_1   S_2   A_2   S_3   A_3 ... S_46   A_46
1      2     0    24     0    22     1    12 ...   0      67
2      1     1    29     0    32     0     8 ...   .       .
.
.
20     3     1    76     0    75     0    46 ...   1      41
.
.

What I want to create is the following:

Id  Mom  S_1  A_1  S_2  A_2  S_3  A_3 ... S_46  A_46  SA   MA
1     2    0   24    .    .    1   12 ...    0    67   0   22
2     1    .    .    0   32    0    8 ...    .     .   1   29
.
.
20    3    1   76    0   75    .    . ...    1    41   0   46



Friedrich:

I did think about it when I started working on this. However what
made me decide not to do it is that my analysis will be at the
household level; and on top of this my households have too many
members. I have households with up to 46 members; so I thought
reshape would be too complicated. Specially because I need just a
couple of characteristics from the individuals.

Again, any help would be greatly appreciated.

Regina Almeyda


Quoting Friedrich Huebler <huebler@rocketmail.com>:

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


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



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