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

Re: st: RE: RE: Creation of family id


From   "Juan David Baron" <[email protected]>
To   [email protected]
Subject   Re: st: RE: RE: Creation of family id
Date   Sun, 4 Dec 2005 07:48:25 +1100 (EST)

HI Steven:

Your suggestion worked fine, and it is much faster than the way I was
doing it.

Thanks,

Juan


> Sorry, there was a mistake in this suggestion: it should read "change the
> id
> variable from id to p_id1" not the other way around.  Steve
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of Steven
> Stillman
> Sent: Thursday, December 01, 2005 1:37 AM
> To: [email protected]
> Subject: st: RE: Creation of family id
>
>
> Hi Juan. One way to do this is to create X copies of your data set.  Copy
> 1
> is your root copy.  Open copy 2 and pre/post-fix all variables with say
> _pid1 and change the id variable from p_id1 to id.  Do the same with copy
> 3+
> using different pre/postfixes and the next p_id variable.  You can then
> merge each of these into the root copy using the p_idX as your merge
> variables and only keeping observations in the master.
>
> Hope this helps.
> Steve
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of Juan Baron
> Sent: Wednesday, November 30, 2005 11:49 AM
> To: [email protected]
> Subject: st: Creation of family id
>
>
> Dear Stata Users:
>
> Suppose I have the following data
>
> id         p_id1      p_id2      pid3
> 1            .               .            .
> 2            6              7           9
> 3            8              .            .
> 4            5              1           .
> 5            .               .            .
> 6            .               .            .
> 7            .               .            .
> 8            .               .            .
> 9            .               .            .
> 10         5               .            .
>
>
> where id is a unique id for each indiviidual and p_id#'s the id of the
> parent  (in the real data I have more than 3 pid variables)
>
> I want to create a family id in the most efficient way.   My solution to
> this problem involves looping over observations, and because of that
> it takes  a long time.  That wouldn't be a problem if my data contained
> only a few observations, but that is not the case.
>
> Can anybody suggest more efficient ways to do this task?  I was
> wondering also, how about using MATA?
>
> Thanks,
>
> Juan
>
> *
> *   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/
>
>
> *
> *   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index