Thank you very much Nick and Friedrich. I will try the -reshape- as
you both suggested.
Regina
Quoting Nick Cox <[email protected]>:
> In addition, your example shows that you
> want to zap the originals once they have
> been copies, so that you
> would need two extra lines in your
> loop:
>
> replace S_`M' = . in `i'
> replace A_`M' = . in `i'
>
> If I were doing this, I would -reshape-, as Friedrich
> suggested. That would be easier if you used names S_0
> and A_0 rather than SA and MA. That way it would be
> easy to sort mothers to the start of each block of
> observations.
>
> Nick
> [email protected]
>
> n j cox
>
> > Friedrich's advice is very good. Nevertheless here is one way
> to
> > do what you want:
> >
> > gen SA = .
> > gen MA = .
> > qui forval i = 1/`=_N' {
> > local M = Mom[`i']
> > replace SA = S_`M' in `i'
> > replace MA = A_`M' in `i'
> > }
> >
> > >>> [email protected]
> >
> > 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
> >
>
> *
> * 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/
