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.]]>

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)

]]>

Thank you for your response.

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]]>

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.

]]>

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.]]>

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?]]>

I'm using the 2018 Nigeria DHS. Haven't seen the figures in the documentation.]]>