The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging children, mother, and father's characteristics
Merging children, mother, and father's characteristics [message #26113] Thu, 09 February 2023 06:03 Go to next message
fraeus is currently offline  fraeus
Messages: 14
Registered: February 2023
Member
Hi, I know it is probably a silly question, still I do not understand how to identify those variables. So, I merged PR, IR, and CR (just keeping my variables of interest for CR and IR). I do not understand how I find for instance the mum of child x. Can someone help me?

Best,
Francesca
Re: Merging children, mother, and father's characteristics [message #26118 is a reply to message #26113] Thu, 09 February 2023 11:37 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

Which survey are you working with? What variables for children are you using? Some are in the PR file, but most are only in the KR file.
Re: Merging children, mother, and father's characteristics [message #26120 is a reply to message #26118] Thu, 09 February 2023 11:46 Go to previous messageGo to next message
fraeus is currently offline  fraeus
Messages: 14
Registered: February 2023
Member
I am working with different rounds of DHS for Rwanda, let's suppose 2010. I merged PR, IR, and CR using V001, v002, v003, sstruct,sdistr. First, I notice that if I keep the variable CASEID, I have +50k of duplicates out of 56k obs. I am trying to fix it but I do not get why I have this error (I get same obs as the PR file, which is my base, but with duplicates).

In terms of variables needed, I need some information for children like educational attainement, height, weights, sex, relationship to head, age. For women and men, I need, head of the household, age, marital status, educational attainement, ownership of land, relationship to head. What can I do?
THanks a lot for the help
Re: Merging children, mother, and father's characteristics [message #26174 is a reply to message #26120] Tue, 14 February 2023 11:29 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member
Following is a response from Senior DHS staff member, Tom Pullum:

Below is a general Stata program that you can use to combine, in one file, all the data for children and their parents.

It includes explanatory comments. At some point we will put a version of the program on our GitHub site. The surveys must include hv111-hv114 and b16. If the program is to be used for the India surveys, the ID codes must include state (hv024, v024, or mv024).
Re: Merging children, mother, and father's characteristics [message #26279 is a reply to message #26174] Fri, 03 March 2023 05:31 Go to previous messageGo to next message
fraeus is currently offline  fraeus
Messages: 14
Registered: February 2023
Member
thanks, this is exactly what I needed. I would also need the same information but at the household level, so the rows of my dataset will be households instead of children. Is it possibile? thank you
Re: Merging children, mother, and father's characteristics [message #26281 is a reply to message #26279] Fri, 03 March 2023 07:55 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

I was able to combine information in the PR, IR, MR, and BR files, with children age 0-17 as the units of analysis, but I don't understand what you are looking for at the household level. The only file in which households are units is the HR file. This is a "wide" version of the PR file. Can you give an example of what you want to do with the proposed file?
Re: Merging children, mother, and father's characteristics [message #26283 is a reply to message #26281] Fri, 03 March 2023 09:27 Go to previous message
fraeus is currently offline  fraeus
Messages: 14
Registered: February 2023
Member
Hi, thank you for your reply. So, for sure I'll need the merging you have given to me. Also, I have been suggested to use the household level as to match households and then to get the information I need from the previous file.

Previous Topic: Merging IR to PR
Next Topic: Merging Colombia DHS 1995 and 2000 with Municipality Information
Goto Forum:
  


Current Time: Fri Mar 29 10:20:57 Coordinated Universal Time 2024