The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Merging IR and BR (Using the same code, some countries IR and BR merged, while some others do not)

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

Merging IR and BR [message #17794]

Tue, 04 June 2019 10:20

funkyola
Messages: 8
Registered: April 2018
Location: NIgeria

Member

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

Report message to a moderator

[Message index]

		Merging IR and BR By: funkyola on Tue, 04 June 2019 10:20
		Re: Merging IR and BR By: boyle014 on Mon, 24 June 2019 14:47

Previous Topic:	Merging PR, KR and IR
Next Topic:	Merging BR file with PR file for NFHS-4 round(India)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Dec 20 01:14:40 Coordinated Universal Time 2024