The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Estimation of level-weights using the Couple-Recode (CR) data from the DHS dataset
Re: Estimation of level-weights using the Couple-Recode (CR) data from the DHS dataset [message #27058 is a reply to message #27057] Fri, 16 June 2023 18:56 Go to previous message
DHS user is currently offline  DHS user
Messages: 111
Registered: February 2013
Senior Member
Following is a response from Senior DHS staff member, Tom Pullum:

Our general practice is to use the men's weight (mv005) for the CR file. That's because men's nonresponse is usually more serious than women's nonresponse.

You cannot assume that the male partner is the household head. Some households will be more complicated than that. I propose the following lines in Stata. If you do this, you will not need to use the CR file at all.

Not sure this is what you want, but it's an option if you want to pair the woman with the household head. Note that it can happen that the woman is the household head. This will be the case if v003=head_hvidx. Cheers--Tom

* Construct a file that attaches the characteristics of the household head to each 
*  eligible woman in the household

* June 16, 2023

* specify a workspace
cd e:\DHS\DHS_data\scratch

use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\NGPR7BFL.DTA", clear 

* reduce to just household heads
keep if hv101==1

* select variables you need, not necessarily as illustrated here
keep hvidx hv0* hv1*

* rename to avoid possible confusion
rename hv* head_hv*

* specify variables for the merge
rename head_hv001 cluster 
rename head_hv002 hh
sort cluster hh
save temp.dta, replace


use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\NGIR7BFL.DTA", clear 
rename v001 cluster
rename v002 hh
sort cluster hh

* merge is m:1 because there may be more than 1 eligible woman per household
merge m:1 cluster hh using temp.dta
tab _merge

* _merge=2 for households that do not include any eligible women
drop if _merege==2

drop _merge

[Updated on: Fri, 16 June 2023 18:58] by Moderator

Report message to a moderator

 
Read Message
Read Message
Previous Topic: Household weighted prevalence estimates
Next Topic: Replicating Step 7 and Level-2 Weight from Report 27
Goto Forum:
  


Current Time: Fri Nov 29 02:13:22 Coordinated Universal Time 2024