The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Bangladesh » Table reproduced using code on Git does'not match the report
Table reproduced using code on Git does'not match the report [message #23552] Wed, 06 October 2021 00:06 Go to previous message
salamin is currently offline  salamin
Messages: 4
Registered: September 2021
Hi, I am complete novice in DHS dataset and trying learn how to analyze DHS Data.
As a first step I am trying to reproduce the tables reported in the BDHS 2017 final report using the STATA code provided on the GIT.

However, I am unable to reproduce a table that matches the final report.

For example, following code was used to generate number of ANC visits by executing ! file.
. tab v025 rh_anc_numvs [iw=wt], row nofreq 

   type of |
  place of |                  Number of ANC visits
 residence |      none          1        2-3         4+  don't kno |     Total
     urban |      3.32       6.09      16.67      37.13      36.79 |    100.00 
     rural |      6.10       9.71      22.94      28.88      32.38 |    100.00 
     Total |      5.32       8.69      21.17      31.20      33.62 |    100.00

But, in the BDHS 2017 reports the following table (See the attached image).

Another matter that caught my attention was the number of missing values. When I explored rh_anc_numvs had 12565 missing values
Does this indicate this specific question was collected on a sub-sample? if so how was the subsample defined?

The 2017 BDHS is number of eligible women interviewed is 20,127 and reported table (image) above shows Number of women 5,051. So the number of missing value should be 15,076.
Could the mismatch with report is due to the mismatch in number of missing values? Or am I using the code incorrectly?

Thank you in advance for taking the time to help.
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Making new variables
Next Topic: Variable regarding microcredit involvement.
Goto Forum:

Current Time: Mon Jan 17 15:18:41 Coordinated Universal Time 2022