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 Thu, 04 August 2022 09:04
 phehintee@gmail.com Messages: 4Registered: 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

Re: MLR for INDIA NFHS IV [message #24940 is a reply to message #24933] Thu, 04 August 2022 15:34
 Bridgette-DHS Messages: 2549Registered: February 2013 Senior Member
Following is a response from DHS Senior Sampling Specialist, Mahmoud Elkasabi:

Please review the instructions in the report and the github page carefully.
Both A_h and M_h are district level data; the numbers should be disaggregated by districts. In your code you aggregated the numbers across all districts and used national number. This is not correct.
 Previous Topic: Why a fixed number of households per enumeration area
Goto Forum:

Current Time: Sat Aug 13 11:21:34 Coordinated Universal Time 2022