The DHS Program User Forum: Child Health » How to Merged HR dataset and KR dataset

Home » Topics » Child Health » How to Merged HR dataset and KR dataset (Merging the KR and HR dataset in R)

Show: Today's Messages :: Show Polls :: Message Navigator

How to Merged HR dataset and KR dataset [message #26049]

Wed, 01 February 2023 18:50

Kazi_Salahin
Messages: 9
Registered: February 2023

Member

Please guide me how I merged KR dataset with HR dataset in R

Report message to a moderator

Re: How to Merged HR dataset and KR dataset [message #26069 is a reply to message #26049]

Fri, 03 February 2023 16:17

Janet-DHS
Messages: 891
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.

Report message to a moderator

Re: How to Merged HR dataset and KR dataset [message #26071 is a reply to message #26069]

Fri, 03 February 2023 18:11

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

Janet-DHS
Messages: 891
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.

Report message to a moderator

Previous Topic:	Birth Weight
Next Topic:	How to make Date of Birth

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 27 00:40:18 Coordinated Universal Time 2024