| MLR for INDIA NFHS IV [message #24933] |
Thu, 04 August 2022 09:04  |
phehintee@gmail.com
Messages: 5
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
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
