The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Multilevel analysis (Multilevel analysis on NDHS data)
Multilevel analysis Thu, 07 October 2021 23:51
 Ugonna Messages: 26Registered: June 2020 Member
Hello everyone,

I am doing a multilevel analysis in stata and I have some challenges I would like to be cleared on.

To find out the proportion of women in the community with at least secondary education, I did this:
gen sec_edu=0
replace sec_edu=1 if mat_edu>=4 & mat_edu<=5

So, to obtain the proportion at the cluster level, please what is the most appropriate option amongst these...

egen sec_edu_prop = pc(sec_edu), prop by(v021)
OR
egen sec_edu_prop = mean(sec_edu), by(v021)
OR
egen sec_edu_prop = rowmean(sec_edu), by(v021)

Then while running the analysis, do I need to apply a different kind of weight other than this?
svyset[pw=wt],psu(v021)strata(v022) singleunit(center)

Thank you for your anticipated response.
Re: Multilevel analysis [message #23570 is a reply to message #23563] Mon, 11 October 2021 06:35
 Bridgette-DHS Messages: 3113Registered: February 2013 Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The usual variable for education is v106, with codes 0, 1, 2, 3. The recode would be

```gen sec_edu=0
replace sec_edu=1 if v106>=2 & v106<=3
The cluster-level proportion would come from

egen sec_edu_prop = mean(sec_edu), by(v021)

```
The weights (v005) are the same for all the women in the same cluster. You can do the analysis with svyset as you give it (I would insert a space after "svyset"). However, because sec_edu_prop is the same for every woman in the same cluster, you could consider a multi-level model with women (or children) as level 1 and clusters as level 2. Methodological Report 27 (https://www.dhsprogram.com/pubs/pdf/MR27/MR27.pdf) will help if you go in that direction.

Re: Multilevel analysis [message #23573 is a reply to message #23570] Tue, 12 October 2021 03:29
 Ugonna Messages: 26Registered: June 2020 Member
Hello Bridgette,

I am going through the material sent and I saw IR file was used to get the level-weights at the individual level.

Being that I'm working with the child KR file, please I want to ask if the variables in the kr file can be used to for it.

Thank you
Re: Multilevel analysis [message #23574 is a reply to message #23573] Tue, 12 October 2021 05:55
 Bridgette-DHS Messages: 3113Registered: February 2013 Senior Member
These are the different weights for different sample selections/units of analysis:

Households: hv005
Household members: hv005
Women or children: v005
Men: mv005
Domestic Violence: d005
HIV test results: hiv05

You need to divide the sampling weight you are using by 1,000,000.
Re: Multilevel analysis [message #23691 is a reply to message #23574] Sun, 07 November 2021 02:10
 Ugonna Messages: 26Registered: June 2020 Member
Thank you Bridgette,

I'm going through the MR27 booklet on multilevel modelling and I'm lost on getting the total number of households in the country and households selected per stratum.

Please how do I get those information?

Thank you.
Re: Multilevel analysis [message #23699 is a reply to message #23691] Tue, 09 November 2021 08:51
 Bridgette-DHS Messages: 3113Registered: February 2013 Senior Member

Following is a response from DHS Senior Sampling Specialist, Mahmoud Elkasabi:

Typically, you should find these numbers in appendix B, or in some reports in appendix C, of the final report, unless it is a very old report with these numbers not documented.

Which survey are you referring to?
Re: Multilevel analysis [message #23710 is a reply to message #23699] Thu, 11 November 2021 09:52
 Ugonna Messages: 26Registered: June 2020 Member
Hello Bridgette,

I'm using the 2018 Nigeria DHS. Haven't seen the figures in the documentation.
Re: Multilevel analysis [message #23714 is a reply to message #23710] Fri, 12 November 2021 09:46
 Ugonna Messages: 26Registered: June 2020 Member
Appendix A of 2018 Nigeria DHS has population and EA information gotten from the 2006 Census EA frame, but nothing on the total number of households in the country.

[Updated on: Fri, 12 November 2021 09:46]

Report message to a moderator

Re: Multilevel analysis [message #23733 is a reply to message #23714] Thu, 18 November 2021 10:31
 Bridgette-DHS Messages: 3113Registered: February 2013 Senior Member
See post 23732

[Updated on: Thu, 18 November 2021 10:32]

Report message to a moderator

 Previous Topic: Cluster level population density data (Geospatial Covariate Datasets) Next Topic: SUEST
Goto Forum:

Current Time: Sun Jul 14 13:31:46 Coordinated Universal Time 2024