| About extracting information on household characteristics [message #28613] |
Tue, 06 February 2024 03:21  |
bugz
Messages: 8
Registered: January 2024
|
Member |
|
|
Dear DHS,
I have used the Birth records of infants and their house level characteristics (water source, cooking fuel, and mother's education, wealth index) from the same BR file.
In some countries where there was missing information on household characteristics in the BR file, I merged the PR file using the individual line and extracted the information assuming it represents the child and his mother.
Can I please know whether this method is correct, what are the issues in this approach.
In the case of children, is it possible to refer to their household information such as water source, cooking fuel, and mother's education from the same BR file and PR file.
Thank you so much!
[Updated on: Tue, 06 February 2024 03:24] Report message to a moderator |
|
|
|
| Re: About extracting information on household characteristics [message #28621 is a reply to message #28613] |
Wed, 07 February 2024 12:52  |
Janet-DHS
Messages: 698
Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member, Tom Pullum:
Household-level characteristics are the same for everyone in the same household. You can get them from the HR file, which has one record per household, or from the PR file, if you just keep one record per household, for example the household head (keep if hv101==1). You then match hv001 hv002 for the household with v001 v002 for the child's record. The approach you describe will be ok if you have just one record per household.
Note that many household-level variables have already been copied into the IR file and then into the BR file, but sometimes with different names. For example, wealth quintile is hv270 in the HR and PR files, and is v190 in the IR and PR files.
Also note that the BR file (and KR file) includes children who have died and children who are not living with their mother--that is, are in a different household. The variable b9 is 0 if the child is living with the mother. You may want to restrict to such children.
|
|
|
|
|
|
|
|
|
|
| Re: About extracting information on household characteristics [message #28668 is a reply to message #28656] |
Mon, 19 February 2024 06:35 |
bugz
Messages: 8
Registered: January 2024
|
Member |
|
|
Hi thank you for your kind message,
I have a small issue again when merging the Mali 2001 wave MLBR41FL.dta, to MLHR41FL.DTA
*Variables hv001 hv002 do not uniquely identify observations in the using data
could you please let me know whether there is any issue in my code,
use MLHR41FL.DTA, clear
rename hv001 DHS
rename hv002 hh_ID
save HR.dta, replace
use MLBR41FL.dta, clear
rename v001 DHS
rename v002 hh_ID
save BR.dta, replace
use HR.dta, clear
merge m:1 DHS hh_ID in_line using BR.dta
variables DHS hh_ID do not uniquely identify observations in the
using data
[Updated on: Mon, 19 February 2024 06:36] Report message to a moderator |
|
|
|
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
