The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » Total number households reported vs v002 (Unable to match total number of households in reports to v002/hv002 variables)
Re: Total number households reported vs v002 [message #20277 is a reply to message #20267] Mon, 19 October 2020 10:00 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3214
Registered: February 2013
Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The cluster id (v001) is unique for each cluster. However, the household id (v002) is within clusters. That is, each cluster has a household 1, etc. Similarly, line number (v002) is numbered within households. Perhaps that is the source of the discrepancy.

To find out how many households there are you could enter a line such as "egen hh=group(v001 v002)" and then "summarize hh". The maximum value of hh would be the number of households in the survey.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Merged Housedhold and Domestic Violence dataset
Next Topic: Active relationship
Goto Forum:
  


Current Time: Mon Dec 23 14:17:54 Coordinated Universal Time 2024