Re: NFHS-5 data from STATA not matching the factsheets [message #28367 is a reply to message #28361] |
Thu, 21 December 2023 14:55 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to previous message](/theme/default/images/down.png) |
Bridgette-DHS
Messages: 3152 Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS staff member, Tom Pullum:
I see that you used the HR file, in which households are units. Your calculation is correct for households. However, in the Bihar report, and elsewhere, the label is "Population living in households with electricity (%)". If you run the same lines on the PR file, in which individuals are units, you will match the report. Or, see below, you can match the report with the HR file if you multiply the weight by the household size.
For the percentages you only need the weights. You do not need the full svyset command. The adjustments for clusters and strata can be omitted. Also you do not need all the steps for the weights. You just need the following two lines in the HR file:
* The following line gives the percentages for households
tab hv024 hv206 [iweight=hv005/1000000], row
* The following line gives the percentages for individuals
tab hv024 hv206 [iweight=hv009*hv005/1000000], row
In the second command, I multiply the weight by hv009, which is the number of individuals in the household.
|
|
|