The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » Need Help to Clarify (Need to Understand Missing Data Background)
Re: Need Help to Clarify [message #25433 is a reply to message #25386] Tue, 18 October 2022 16:40 Go to previous messageGo to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 938
Registered: April 2022
Senior Member
Following is a response from DHS staff member Tom Pullum:

This survey had a 1/6 subsample of men for the men's interview. (In 1/3 of the clusters, half of the households were selected.) In the PR file there is a variable hv027 that is 1 if the household was selected for the men's interview. This subsampling had implications for the women's interview. For example, the questions for the variables you mention (v169a, v170, v743a) were only asked in the households selected for the men's interview. The design of the survey anticipated that researchers would want to relate them to characteristics of the husband.

The PR/IR merge below confirms that v170, for example, is Not Applicable (coded with a dot) for women in the households that were not selected for the men's interview.


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

* Prepare the IR file for the merge
use "...IAIR7DFL.DTA", clear

keep v001 v002 v003 v025 v170
rename v025 state
rename v001 cluster
rename v002 hh
rename v003 line
sort state cluster hh line
save IAtemp.dta, replace


* Prepare the PR file and do the merge
use "...IAPR7DFL.DTA", clear

keep if hv117==1
keep hv001 hv002 hvidx hv025 hv027
rename hv025 state
rename hv001 cluster
rename hv002 hh
rename hvidx line
sort state cluster hh line
merge state cluster hh line using IAtemp.dta
tab _merge
keep if _merge==3

* Check the pattern of NA on v170 with the subsampling
tab hv027 v170,m

[Updated on: Tue, 18 October 2022 16:41]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Literacy v155
Next Topic: DHS Indicators
Goto Forum:
  


Current Time: Thu Feb 20 12:48:32 Coordinated Universal Time 2025