The DHS Program User Forum: Ethiopia » IR file and BR file Merge Issue

Home » Countries » Ethiopia » IR file and BR file Merge Issue

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

IR file and BR file Merge Issue [message #20412]

Thu, 29 October 2020 04:03

Hassen
Messages: 121
Registered: April 2018
Location: Ethiopia,Africa

Senior Member

Dear DHS Users, I want to merge BR file and IR file into one dataset? So, How can I merge them?
With Warmest regards, Hassen Ali

Hassen Ali(Chief Public Health Professional Specialist)

Report message to a moderator

Re: IR file and BR file Merge Issue [message #20413 is a reply to message #20412]

Thu, 29 October 2020 07:06

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

This kind of question has come up many times on the forum. If you search with keyword "??" you should find answers to your questions. Also, please see the PDF of the Guide to DHS Statistics - search for "Matching and Merging Datasets", and see the examples in this section.

Report message to a moderator

Re: IR file and BR file Merge Issue [message #20427 is a reply to message #20413]

Sun, 01 November 2020 00:01

Hassen
Messages: 121
Registered: April 2018
Location: Ethiopia,Africa

Senior Member

Dear, Bridgette Thank you for your response! Anyways, I am not clear regarding merging IR file into BR file! Still I need your assistance and guidance.
Cheers, Hassen Ali

Hassen Ali(Chief Public Health Professional Specialist)

Report message to a moderator

Re: IR file and BR file Merge Issue [message #20438 is a reply to message #20427]

Mon, 02 November 2020 08:07

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The cases in the IR file are the women age 15-49 who were interviewed in the survey. The cases in the BR file are all the children those women had, whether they are living or have died. Women who had no children are not represented at all in the BR file. Most of the information about a woman in the IR file is included on each of her children's records in the BR file.

Have you looked at the IR and BR files separately? A merge only makes sense if there are variables for the women in the IR file that you need for your research and that do not already appear in the BR file. You would only want to copy those variables. In both files, the identifiers for the women are v001 v002 v003. I am curious--please let me know which IR variables do you need that are not already in the BR file?

Report message to a moderator

Re: IR file and BR file Merge Issue [message #20473 is a reply to message #20438]

Sun, 08 November 2020 09:32

Hassen
Messages: 121
Registered: April 2018
Location: Ethiopia,Africa

Senior Member

Dear Dr.Tom Pullum & Bridgette, Thank you very much for your response! I have ocean of gratitude and appreciation for your assistance! I want to examine the association between female genital mutilation and obstetric outcomes (obstetric fistula, perinatal mortality, low birth weight, caesarean delivery) among women of reproductive age (15-49 years) in Ethiopia. Can I use the BR file only for the above listed outcome variables? I want to create a binary corm for perinatal death as a case "1=if perinatal mortality occurred) and non-case (0=if death not occurred). So, how can I creat the variable? I need your kindly assistance and guidance!
With Best Wishes, Hassen

Hassen Ali(Chief Public Health Professional Specialist)

Report message to a moderator

Re: IR file and BR file Merge Issue [message #20479 is a reply to message #20473]

Mon, 09 November 2020 08:58

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The Stata files to construct indicators and tables are now on our GitHub site: https://github.com/DHSProgram/DHS-Indicators-Stata. The code to construct perinatal mortality and child mortality is in Chapter 8. Perinatal mortality can only be calculated for children born in the past 5 years. Other mortality rates can be calculated for all births in the BR file. The FGC variables, g1*, are in the IR, BR, and KR files. You should be able to do all of this with the BR file. If you want to relate child survival to FGC, be sure to include other covariates as controls...

Report message to a moderator

Re: IR file and BR file Merge Issue [message #20482 is a reply to message #20479]

Mon, 09 November 2020 22:53

Hassen
Messages: 121
Registered: April 2018
Location: Ethiopia,Africa

Senior Member

Thank you for your attractive response!

Hassen Ali(Chief Public Health Professional Specialist)

Report message to a moderator

Previous Topic:	perinatal mortality
Next Topic:	Replicating table 8.4: ETHIOPIA DHS 2000

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Dec 21 12:05:52 Coordinated Universal Time 2024