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

st: Re: Re: How to speed up loop


From   "Michael Blasnik" <michael.blasnik@verizon.net>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: Re: How to speed up loop
Date   Wed, 15 Sep 2004 12:36:59 -0400

How about using merge:

keep hhid lineno age
rename lineno mlineno
rename age mage
sort hhid mlineno
save lookup

use master
sort hhid mlineno
merge hhid mlineno using lookup, nokeep

I haven't tested this, but something like it should work and should be very
fast.

Michael Blasnik
michael.blasnik@verizon.net


----- Original Message ----- 
From: "Friedrich Huebler" <huebler@rocketmail.com>
To: <statalist@hsphsun2.harvard.edu>
Sent: Wednesday, September 15, 2004 12:24 PM
Subject: st: Re: How to speed up loop


> I appreciate the responses that I received so far but realize that my
> initial message was not precise enough.
>
> The variable mlineno lists the line number of a household member's
> mother. In household 1 in my example data, household member 2 is the
> mother of household member 3. In household 2, 1 is the mother of 2,
> and 3 is the mother of 4 and 5. I would like to create a variable
> that lists the age of each household member's mother. The result
> should look like this:
>
> hhid    lineno       age   mlineno      mage
>    1         1        32         .         .
>    1         2        30         .         .
>    1         3         5         2        30
>    2         1        68         .         .
>    2         2        41         1        68
>    2         3        40         .         .
>    2         4        17         3        40
>    2         5        14         3        40
>
> The loop that I am using to create the variable mage works perfectly
> but it is very slow with a large number of observations.
>
> Friedrich
>


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