The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging IR and BR (Using the same code, some countries IR and BR merged, while some others do not)
Merging IR and BR [message #17794] Tue, 04 June 2019 10:20 Go to next message
funkyola is currently offline  funkyola
Messages: 8
Registered: April 2018
Location: NIgeria
Dear DHS Specialist,

Kindly assist me. I used the same code written below and it merged the BR and IR of some countries while it did not work for most others.

use BFBR62FL.DTA, clear
sort caseid v001 v002 v003 bidx
save BFBR62-temp.dta, replace
use BFIR62FL.DTA, clear
sort caseid v001 v002 v003
merge caseid v001 v002 v003 using BFBR62-temp.dta
ta _merge
save BFIRBR.dta, replace
erase BFBR62-temp.dta
ta v044, nola
keep if v044==1
save BFIRBR_mod.dta, replace

Countries that merged: Ethiopia, Kenya, Zimbabwe, Zambia, Malawi

All other countries were not successful such as Burundi, Nigeria, Comoros and so on. Nigeria gave me a 3.2 mb file for both IR and BR file after merging and same applies to all others.

Pls guide
Re: Merging IR and BR [message #17846 is a reply to message #17794] Mon, 24 June 2019 14:47 Go to previous message
boyle014 is currently offline  boyle014
Messages: 73
Registered: December 2015
Location: Minneapolis
Senior Member
You may want to try using IPUMS DHS. If you select births as your unit of analysis, all of the mother variables from the IR file will be accessible to you.

Select your samples, the variables you want, and click "View Data Cart." (The data are free.) Select the file format that's appropriate for you and download a single merged file with all samples appended and all of your selected variables harmonized. The file will also contain a survey variable and combined psu and strata variables (idhspsu, idhsstrata) with unique values for comparative analysis.

Professor Elizabeth Boyle
Sociology & Law, University of Minnesota, USA
Principal Investigator, IPUMS-DHS
Previous Topic: Merging PR, KR and IR
Next Topic: Merging BR file with PR file for NFHS-4 round(India)
Goto Forum:

Current Time: Mon Jul 6 19:32:02 Eastern Daylight Time 2020