The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » How to Merged HR dataset and KR dataset (Merging the KR and HR dataset in R)
How to Merged HR dataset and KR dataset [message #26049] Wed, 01 February 2023 18:50 Go to next message
Kazi_Salahin is currently offline  Kazi_Salahin
Messages: 9
Registered: February 2023
Member
Please guide me how I merged KR dataset with HR dataset in R
Re: How to Merged HR dataset and KR dataset [message #26069 is a reply to message #26049] Fri, 03 February 2023 16:17 Go to previous messageGo to next message
Janet-DHS is currently online  Janet-DHS
Messages: 666
Registered: April 2022
Senior Member
Thank you for submitting your question. Could you please provide some more detailed information so we can better advise you?

Can you let us know:

• Which survey you are using (Include country name and year)?
• Which data files you are referring to?
• Which software you are using (Stata, SPSS, R, etc.)?

If you are trying to match a Table in a final report, please also indicate which table and which estimate you are trying to match.
Re: How to Merged HR dataset and KR dataset [message #26071 is a reply to message #26069] Fri, 03 February 2023 18:11 Go to previous messageGo to next message
Kazi_Salahin is currently offline  Kazi_Salahin
Messages: 9
Registered: February 2023
Member
Dear Janet
Thank you for your reply. I am using the Bangladesh dataset in 2017-2018, and using R.

[Updated on: Sat, 04 February 2023 03:03]

Report message to a moderator

Re: How to Merged HR dataset and KR dataset [message #26103 is a reply to message #26049] Wed, 08 February 2023 09:45 Go to previous message
Janet-DHS is currently online  Janet-DHS
Messages: 666
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

I don't know why you would want to merge the KR and HR files. A child in the KR file will only be in the same household as the mother if b9=0. A household may have NO children in the KR file, or may have several, especially if there are multiple mothers in the same household. However, if you want to do this then you just match hv001 and hv002 in the HR file with v001 and v002 in the KR file. Many examples of merges have been posted on the forum and this is an easy one, with only two identifiers.
Previous Topic: Birth Weight
Next Topic: How to make Date of Birth
Goto Forum:
  


Current Time: Thu Mar 28 15:38:22 Coordinated Universal Time 2024