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 previous 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
Read Message
Read Message
Previous Topic: Merging PR, KR and IR
Next Topic: Merging BR file with PR file for NFHS-4 round(India)
Goto Forum:

Current Time: Tue Oct 20 04:05:52 Eastern Daylight Time 2020