The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Sampling » MLR for INDIA NFHS IV (Level weight calculatin)
MLR for INDIA NFHS IV [message #24933] Thu, 04 August 2022 09:04 Go to previous message
phehintee@gmail.com is currently offline  phehintee@gmail.com
Messages: 4
Registered: July 2018
Member
Please I would appreciate if I can get help in confirming my coding for calculating level-weighting.

I used the Zimbabwe guide and downloaded the excel document provided for the approximation of the average number of households per cluster by sampling strata required for the approximation. https://github.com/DHSProgram/DHS-Analysis-Code/tree/main/Mu ltilevel_Weights/India

So I just summed up the No of CEBs and total number of households and EA Average size in each column, then inputed them as M, A_h and M_h respectively.


Below are my STATA input
a* Stage A *** Compile parameters/inputs for Level-weights calculations

. ************************************************************ **********

. * a_c_h completed clusters by strata

. gen a_c_h=.
(94,388 missing values generated)

. quietly levelsof v022, local(lstrata)

. quietly foreach ls of local lstrata {
. tab v021 if v022==`ls', matrow(T)
. scalar stemp=rowsof(T)
. replace a_c_h=stemp if v022==`ls'
. }

. replace a_c_h=stemp if v022==`ls'

gen DHSwt = v005 / 1000000

*Step 1. De-normalize the final weight, using approximated normalization factor

. gen d_HH = DHSwt * (249454252/80137279)

.
. gen f = d_HH / ((696232/a_c_h) * (69361.60205/22))

* Calculating the level-weights based on different values of alpha

. local alphas 0 0.1 .25 .50 .75 0.90 1

. local i = 1


Please am I on track

Looking forward to your responsel
 
Read Message
Read Message
Previous Topic: Why a fixed number of households per enumeration area
Next Topic: Social norms and women's work_India
Goto Forum:
  


Current Time: Thu Mar 28 16:01:59 Coordinated Universal Time 2024