The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Birth order and Antenatal Care NFHS-5 India (Replicating Table 8.3)
Re: Birth order and Antenatal Care NFHS-5 India [message #27898 is a reply to message #27893] Thu, 19 October 2023 08:41 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3190
Registered: February 2013
Senior Member
Following is a response from Senior DHS Staff Member, Tom Pullum:

The Stata lines pasted below will calculate the outcome variable used in NFHS-5 table 8.3. The problem you are having may be with the handling of cases with multiple providers. In such cases, the variable is classified with the most qualified provider, which is the one farthest to the left in the columns of the table. Note that this sequence is a little different from the sequence of the providers in the questionnaire. Because you have already constructed to covariates for this table, you should be able to reproduce the whole table now.

* Antenatal care, NFHS5, table 8.3
* combine m2a to m2n into a single variable, with a higher qualified provider replacing
*   a less qualified provider

* Sequence the providers as in table 8.3

* m2a M2A        prenatal: doctor
* m2b M2B        prenatal: anm/nurse/midwife/lhv
* m2g M2G        prenatal: dai/traditional birth attendant
* m2i M2I        prenatal: anganwadi/icds worker
* m2h M2H        prenatal: community/village health worker
* m2j M2J        prenatal: asha
* m2k M2K        prenatal: other
* m2n M2N        prenatal: no one

* Follow THE REVERSE of this sequence in the construction


use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\IAKR7EFL.DTA", clear

gen wt=v005/1000000

gen provider=8
replace provider=7 if m2k==1
replace provider=6 if m2j==1
replace provider=5 if m2h==1
replace provider=4 if m2i==1
replace provider=3 if m2g==1
replace provider=2 if m2b==1
replace provider=1 if m2a==1

label define type 1 "Doctor" 2 "ANM or nurse or midwife or LHV" 3 "Dai or TBA" 4 "Aganwadi or ICDS worker" 5 "Community or village health worker" 6 "ASHA" 7 "Other" 8 "None"

label values provider type
tab provider if bidx==1 [iweight=wt]

* This matches the percentages and n in the bottom row of table 8.3
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: stunting calculation
Next Topic: GMHS and Weighting
Goto Forum:
  


Current Time: Sat Nov 9 06:27:04 Coordinated Universal Time 2024