The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Ethiopia » IR file and BR file Merge Issue
IR file and BR file Merge Issue [message #20412] Thu, 29 October 2020 04:03 Go to next message
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)
Re: IR file and BR file Merge Issue [message #20413 is a reply to message #20412] Thu, 29 October 2020 07:06 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3203
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.
Re: IR file and BR file Merge Issue [message #20427 is a reply to message #20413] Sun, 01 November 2020 00:01 Go to previous messageGo to next message
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)
Re: IR file and BR file Merge Issue [message #20438 is a reply to message #20427] Mon, 02 November 2020 08:07 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3203
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?

Re: IR file and BR file Merge Issue [message #20473 is a reply to message #20438] Sun, 08 November 2020 09:32 Go to previous messageGo to next message
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)
Re: IR file and BR file Merge Issue [message #20479 is a reply to message #20473] Mon, 09 November 2020 08:58 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3203
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...


Re: IR file and BR file Merge Issue [message #20482 is a reply to message #20479] Mon, 09 November 2020 22:53 Go to previous message
Hassen
Messages: 121
Registered: April 2018
Location: Ethiopia,Africa
Senior Member
Thank you for your attractive response!

Hassen Ali(Chief Public Health Professional Specialist)
Previous Topic: perinatal mortality
Next Topic: Replicating table 8.4: ETHIOPIA DHS 2000
Goto Forum:
  


Current Time: Sun Dec 8 10:10:16 Coordinated Universal Time 2024