The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » NFHS-5 data from STATA not matching the factsheets (Extracting data using Household data file does not yield similar results as per the factsheet. What am I missing?)
NFHS-5 data from STATA not matching the factsheets [message #28361] Wed, 20 December 2023 14:32 Go to previous message
anshul.11 is currently offline  anshul.11
Messages: 2
Registered: December 2023
Member
Hi!

For a project, I am supposed to extract data from the Household data file. However, despite running commands which as per me are correct for tabulating, the results are not matching the fact sheets published by DHS. For example, following are the commands I run for defining svyset

gen pwt=.
replace pwt= hv005/1000000
tab hv206
egen cluster_id = group( hv021 hv024 )
egen stratum_id = group( hv023 hv024)
svyset cluster_id [pw=pwt], strata(stratum_id)

following which, I am trying to tabulte the percentage of households which have electricity in each state

svy: tabulate hv024 hv206, row

However, the results have a mismatch from the factsheets. as in, Bihar has 95.61% households with electricity as per the output in STATA. In the factsheet the percentage is 96.3% (accessed from: http://rchiips.org/nfhs/NFHS-5_FCTS/Bihar.pdf). Similarly, for the country, the percentage of households with electricity in the output is 96.53%; factsheet has 96.8% as the value. Same discrepancy exists with other indicators. Can anyone please let me know what am I doing wrong?






 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Construction of a variable related to agricultural land
Next Topic: Merging BR to PR in NFHS-1 and NFHS-2
Goto Forum:
  


Current Time: Thu Jul 11 10:17:51 Coordinated Universal Time 2024