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]
st: AW: Carry over information on time-invariant covariate to all observations of a household?
From
"Dr. Martin Weiss" <[email protected]>
To
<[email protected]>
Subject
st: AW: Carry over information on time-invariant covariate to all observations of a household?
Date
Tue, 3 Aug 2010 10:35:22 +0200
<>
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/