The DHS Program User Forum: Sampling » MLR for INDIA NFHS IV

Home » Data » Sampling » MLR for INDIA NFHS IV (Level weight calculatin)

Show: Today's Messages :: Show Polls :: Message Navigator

MLR for INDIA NFHS IV [message #24933]

Thu, 04 August 2022 09:04

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

Report message to a moderator

Re: MLR for INDIA NFHS IV [message #24940 is a reply to message #24933]

Thu, 04 August 2022 15:34

Bridgette-DHS
Messages: 2670
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.

Report message to a moderator

Previous Topic:	Why a fixed number of households per enumeration area
Next Topic:	Social norms and women's work_India

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Feb 6 00:37:31 Coordinated Universal Time 2023