The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » How to link child health outcome with mothers' characteristics
How to link child health outcome with mothers' characteristics [message #25315] Sat, 01 October 2022 14:26 Go to previous message
Asantie is currently offline  Asantie
Messages: 3
Registered: October 2021
Member
Hello,

I am using the 2019 Ethiopian Mini DHS data to assess factors predicting child health outcomes. So I would like to merge child characteristics based on household members (PR) file to the characteristics of the specific mothers of the children based on women record (IR). I now how to merge simply PR files and IR files based on the identifier variables in IR(v001, v002, v003)and PR(hv001 hv002 hvidx)files. But I do not know how to merge the under 5 child's health outcome with characteristics of his/her mother (like age and mother's bmi etc) in the same row. Remember that one mother may have more than one under 5 child. So how can I link the information of children to their specific mothers correctly using PR and IR files?
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Merging and appending data files
Next Topic: Merge BDSQ7RDT and BDVA7RDT with the household data file
Goto Forum:
  


Current Time: Wed Nov 27 17:05:33 Coordinated Universal Time 2024