The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Ethiopia » Selecting appropriate weights when IR and MR files are pooled
Re: Selecting appropriate weights when IR and MR files are pooled [message #26726 is a reply to message #26719] Mon, 24 April 2023 08:07 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3066
Registered: February 2013
Senior Member
Following is a response from Senior DHS staff member, Tom Pullum:


Your results looked ok but the only way I could confirm was by doing it myself. I'll paste the Stata lines below because they could be useful to others. I get the same results.
* Specify workspace
cd e:\DHS\DHS_data\scratch

use "...ETAR71FL.DTA", clear 
gen cluster=hivclust
gen hh=hivnumb
gen line=hivline
sort cluster hh line
save ARtemp.dta, replace

use "...ETIR71FL.DTA", clear 
gen sex=2
save IRtemp.dta, replace

use "...ETMR71FL.DTA", clear 
gen sex=1
rename mv* v*
append using IRtemp.dta
gen cluster=v001
gen hh=v002
gen line=v003
sort cluster hh line
merge 1:1 cluster hh line using ARtemp.dta
tab _merge

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Trend Analysis
Next Topic: Using separate wealth index
Goto Forum:
  


Current Time: Wed May 29 13:09:43 Coordinated Universal Time 2024