The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » approximate level-1 and level-2 weights mens dataset NFHS-5 (weighting of data)
approximate level-1 and level-2 weights mens dataset NFHS-5 [message #25351] Tue, 11 October 2022 02:44 Go to next message
vbrar4 is currently offline  vbrar4
Messages: 13
Registered: February 2022
Member
Hello!

I just had a very quick concern. Currently I am working with the male dataset subset of the NFHS-5 and for my analysis I wanted to proceed with a mulitlevel model but, I am having some issues.

After reading over the resource posted by the DHS program called "Multilevel Modeling Using DHS Surveys: A Framework to Approximate Level-Weights (English)" I have been unable to make any logical progression with determining weights due to missing crucial information in the final report.

The document continuousally refers to tables who's equivalent do not exist in the final report of the NFHS-5.
The document wants information regarding the total number of census clusters and the average number of households per cluster by sampling strata but i cannot find this anywhere.


The two variables of concern produced in the document seem to be A_h and M_h.

For a_c_h the following seems to work:

gen a_c_h=.
quietly levelsof mv022, local(1strata)
foreach 1s of local 1strata {
tab mv021 if mv022==`1s', matrow(T)
scalar stemp=rowsof(T)
replace a_c_h=stemp if mv022==`1s'
}

For m_c the following seem to work:

quietly summarize mv001
gen m_c=r(N)

And according to what i can find in the final report M=636,699, S_h=22 and DHSwt would be DHSwt=mv005/1000000

Any support with how to determine the remaining required information would be appreciated.



Re: approximate level-1 and level-2 weights mens dataset NFHS-5 [message #25353 is a reply to message #25351] Tue, 11 October 2022 07:45 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member

Following is a response from DHS staff member, Tom Pullum:

We have a folder about multilevel weights on GitHub ( https://github.com/DHSProgram/DHS-Analysis-Code/tree/main/Mu ltilevel_Weights) and within that there is a folder specifically about NFHS-4 and NFHS-5, which had the same sampling design and sampling frame.
Re: approximate level-1 and level-2 weights mens dataset NFHS-5 [message #25355 is a reply to message #25353] Tue, 11 October 2022 13:33 Go to previous messageGo to next message
vbrar4 is currently offline  vbrar4
Messages: 13
Registered: February 2022
Member
Thank you!

However after accessing this site and reading through what is mentioned, there is an issue with the link to the census of India website that has the excels files required to obtain data regarding the villages for the rural clusters.

I am not sure how to proceed as there is no other list mentioned of which excel files are needed.


Any additional support or method on how to proceed would be greatly appreciated.

Re: approximate level-1 and level-2 weights mens dataset NFHS-5 [message #25366 is a reply to message #25355] Wed, 12 October 2022 14:14 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member

Following is a response from DHS staff member, Tom Pullum:

I believe the information on our website is complete and does not require users to access Excel files from another website. Please look again.

Staff who could help with this topic have left DHS or are traveling. We will try to give another response as soon as possible.

Re: approximate level-1 and level-2 weights mens dataset NFHS-5 [message #25367 is a reply to message #25366] Wed, 12 October 2022 14:18 Go to previous messageGo to next message
vbrar4 is currently offline  vbrar4
Messages: 13
Registered: February 2022
Member
Hello!

I have double checked on multiple browsers and devices. The download for the urban excel dataset works fine but the link provided to the rural data tables from the census of India website is not functioning. The URL leads to an error.

Re: approximate level-1 and level-2 weights mens dataset NFHS-5 [message #25397 is a reply to message #25367] Fri, 14 October 2022 12:48 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
Please see this post.
Previous Topic: Fieldworker characteristics in 2019-2021 data
Next Topic: Calculation of multilevel weights for NFHS-4 and NFHS-5
Goto Forum:
  


Current Time: Sat Nov 23 20:40:37 Coordinated Universal Time 2024