Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: AW: Carry over information on time-invariant covariate to all observations of a household?
From
Jen Zhen <[email protected]>
To
[email protected]
Subject
Re: st: AW: Carry over information on time-invariant covariate to all observations of a household?
Date
Tue, 3 Aug 2010 11:02:14 +0200
Great, thanks!
On Tue, Aug 3, 2010 at 10:35 AM, Dr. Martin Weiss <[email protected]> wrote:
>
> <>
>
> Use
>
> *************
> bysort HH (X): replace X = X[1]
> *************
>
> then!
>
>
> HTH
> Martin
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[email protected]] Im Auftrag von Jen Zhen
> Gesendet: Dienstag, 3. August 2010 10:29
> An: [email protected]
> Betreff: st: Carry over information on time-invariant covariate to all
> observations of a household?
>
> Dear Listers,
>
> suppose I have a panel with dimensions Household and Year. I have the
> time-invariant household characteristic X. Information on it is
> currently given for each household in only one of the years, but I
> would like to carry over this information to all observations of each
> household.
>
> To illustrate, the dataset looks like this:
>
> HH Year X
> 1 1990 5
> 1 1991 .
> 1 1992 .
> 2 1990 .
> 2 1991 3
> 2 1992 .
> 3 1990 .
> 3 1991 .
> 3 1992 2
>
> and I would like to fill in the missing values.
>
> Currently my way of doing it is this:
> - bysort HH: egen X2 = max(X) -
> - replace X = X2 -
>
> However, in a large dataset running this command takes forever, so I
> am wondering whether there is a faster way to do this?
>
> Many thanks,
> JZ
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/