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
Difference in differences with PPML and Log-OLS reveal substantially different resultsDear Statalisters, I have differences-in-differences setting where I have multiple treatments that o…
Compute returns based on lag variableHello, Can you please help me with the following issue: I want to form quantiles based on the credi…
GLM for grouped/ blocked population standardized binary data.Sorry for imposing further but I could really use some help. Let me explain more. I have data on in…
Calculating media of several variables with missing dataGood afternoon, I like would to calculate the media of several variables with missing data. Code: …
correct to use*svy brr syntax with bootstrap weights and svy bootstrap syntax with brr weights?*Dear Statalisters, Is it correct to use the svy brr syntax with bootstrap weights and svy bootstrap…
Subscribe to:
Post Comments (Atom)
0 Response to How to create household ID given the person ID
Post a Comment