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 next message is currently offline
Messages: 4
Registered: July 2018
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. 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
Re: MLR for INDIA NFHS IV [message #24940 is a reply to message #24933] Thu, 04 August 2022 15:34 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2635
Registered: 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
Next Topic: Social norms and women's work_India
Goto Forum:

Current Time: Sat Dec 3 20:57:40 Coordinated Universal Time 2022