Hi,
I have individual data (see below) where r101 is the province code, r401 is Person ID, r403 is each person's relation to household head (1 = HH head, 2 = spouse, 3 = child, etc), and r601 is the person ID of each person's mother (similar to r403). I'd like to generate Household ID (hhid) given the PID. E.g. Row 1 - 7 is one family, so the hhid = 1. Row 8 - 9 is one family, so the hhid = 2. Row 10 - 14 is one family, so the hhid = 3. Does anyone have any idea on how to do such a thing?
Thank you!
clear
input byte(r101 r401 r403 r601) float(age marstat gender)
11 1 1 0 40 2 0
11 2 2 0 39 2 1
11 3 3 2 17 1 0
11 4 3 2 13 1 0
11 5 3 2 12 1 1
11 6 3 2 6 1 1
11 7 3 2 0 1 1
11 1 1 0 39 2 0
11 2 2 0 47 2 1
11 1 1 0 36 2 0
11 2 2 0 33 2 1
11 3 3 2 12 1 0
11 4 3 2 8 1 0
11 5 3 2 0 1 0
end
Related Posts with How to create household ID given the person ID
Syntax for FMM Regression for Multiple Observations Within CasesI need to estimate a 3-latent-class FMM regression (with a continous dependent variable) analyzing a…
estout by Ben Jann (available from ssc): Add horizontal lines to table, csv formatHello, after three hours of trying and searching, here is my question: Is there an elegant way to a…
Export cross tabulation table to excel using stataHello folks, this may be a dumb question, but how can i get a cross tabulation output export to exce…
correlation across error terms in nlsurHi all, I am unsure on how to impose the correlation across the error terms in nlsur. Thanks in adv…
margins not estimableHello, I am trying to have the partial effect of being an immigrant evaluated at the mean level of y…
Subscribe to:
Post Comments (Atom)
0 Response to How to create household ID given the person ID
Post a Comment