| Re: Residing in same household in KR file [message #28761 is a reply to message #28758] |
Tue, 05 March 2024 09:54  |
Bridgette-DHS
Messages: 3199
Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS Stata Specialist, Tom Pullum:
In the KR file for the NFHS's, children in the same household will have the same values of v024 v001 v002. Children with the same mother (in the household) will have the same values of v024 v001 v002 v003. You cannot do what you want to do by just adding a binary variable for "same household" or "same mother" because you want to describe a relationship between cases.
One way to approach this would be with a multi-level model. You can find some literature on household clustering or maternal clustering. Frankly, however, I don't think that will be very helpful.
I suggest another approach, which is to construct a data file of PAIRS of children in the KR file who have the same mother. You might expect a huge number of such pairs but I calculate that there would only be 62,170 pairs in the KR file for the NFHS5, compared with 232,920 children in that file.
I suggest that you use the following Stata program to construct a file that pairs the child with bidx=1 with the child with bidx=2, for women who have 2+ children. There are 50,253 such pairs. If you bring in other pairs, such as pairs of bidx=1 and bidx=3, you will be repeating the children with bidx=1. With this file you can look at similarities and differences between the two children. You will, however, have some difficulties. For example, there will not be many pairs in which both children are age 12-23 months. Note that some of these pairs are twins. Hope this will help.
* Construct a file of pairs of the two most recent births in the same household
cd e:\DHS\DHS_data\scratch
use "...IAKR7EFL.DTA", clear
tab bidx
rename v024 state
rename v001 cluster
rename v002 HH
rename v003 MO_line
save temp0.dta, replace
keep if bidx==1
rename b* b*_1
rename m* m*_1
rename h* h*_1
rename HH hh
rename MO_line mo_line
save temp1.dta, replace
use temp0.dta, clear
keep if bidx==2
keep state cluster HH MO_line b* m* h*
rename b* b*_2
rename m* m*_2
rename h* h*_2
rename HH hh
rename MO_line mo_line
merge 1:1 state cluster hh mo_line using temp1.dta
tab _merge
keep if _merge==3
drop _merge
* File with the data for the two most recent births, if 2+
save temp12.dta, replace
tab bidx*
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
