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