The DHS Program User Forum: Merging data files » Merging children, mother, and father's characteristics

Home » Data » Merging data files » Merging children, mother, and father's characteristics

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

Merging children, mother, and father's characteristics [message #26113]

Thu, 09 February 2023 06:03

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

Report message to a moderator

Re: Merging children, mother, and father's characteristics [message #26118 is a reply to message #26113]

Thu, 09 February 2023 11:37

Bridgette-DHS
Messages: 3189
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.

Report message to a moderator

Re: Merging children, mother, and father's characteristics [message #26120 is a reply to message #26118]

Thu, 09 February 2023 11:46

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

Report message to a moderator

Re: Merging children, mother, and father's characteristics [message #26174 is a reply to message #26120]

Tue, 14 February 2023 11:29

Bridgette-DHS
Messages: 3189
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).

Attachment: merge_children_mothers_fathers_do_14Feb2023.txt
(Size: 8.29KB, Downloaded 212 times)

Report message to a moderator

Re: Merging children, mother, and father's characteristics [message #26279 is a reply to message #26174]

Fri, 03 March 2023 05:31

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

Report message to a moderator

Re: Merging children, mother, and father's characteristics [message #26281 is a reply to message #26279]

Fri, 03 March 2023 07:55

Bridgette-DHS
Messages: 3189
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?

Report message to a moderator

Re: Merging children, mother, and father's characteristics [message #26283 is a reply to message #26281]

Fri, 03 March 2023 09:27

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 7 13:35:17 Coordinated Universal Time 2024