| 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
|
|
|
|
| Re: Merging IR and BR [message #17846 is a reply to message #17794] |
Mon, 24 June 2019 14:47  |
boyle014
Messages: 78
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
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
