...
Assuming that hh_3 is coded either 0 or 1:
clear
input hh_id person_id hh_3
4003 01 0
4003 02 1
4003 03 0
4004 01 0
4004 02 1
4004 03 1
4005 01 0
4005 02 0
4005 03 0
end
sort hh_id
by hh_id:egen new_hh_3 = max(hh_3)
list
+------------------------------------+
| hh_id person~d hh_3 new_hh_3 |
|------------------------------------|
1. | 4003 1 0 1 |
2. | 4003 2 1 1 |
3. | 4003 3 0 1 |
4. | 4004 1 0 1 |
5. | 4004 2 1 1 |
|------------------------------------|
6. | 4004 3 1 1 |
7. | 4005 1 0 0 |
8. | 4005 2 0 0 |
9. | 4005 3 0 0 |
+------------------------------------+
______________________________________________
Kieran McCaul MPH PhD
WA Centre for Health & Ageing (M573)
University of Western Australia
Level 6, Ainslie House
48 Murray St
Perth 6000
Phone: (08) 9224-2701
Fax: (08) 9224 8009
email: [email protected]
______________________________________________
If you live to be one hundred, you've got it made.
Very few people die past that age - George Burns
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Robin Pleau
Sent: Thursday, 3 December 2009 10:09 AM
To: [email protected]
Subject: st: Simple loop problem?
Hello. I am using Stata 9. I have what seems like a simple coding
problem but can't figure it out (I'm a relatively new Stata user). I
believe the solution lies in the foreach/forvalues commands, but can't
seem to come up with a solution.
I need to recode a person-level variable based on whether other people
in the household have the same characteristic. Specifically, I want to
recode the variable hh_3 with the value of 1 (1=the person lives in a
three-generational household) if anyone in the household already has
hh_3=1. I want to loop through the whole dataset.
hh_id person_id hh_3
4003 01 0
4003 02 1
4003 03 0
4004 01 0
4004 02 1
4004 03 1
Thank you for your help.
Robin
*
* 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/
