The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Sampling » Malawi Micronutrient Survey design issue (Contention between reported values and calculated values)
Malawi Micronutrient Survey design issue [message #26467] Thu, 23 March 2023 18:01 Go to previous message
IsmailZoutat is currently offline  IsmailZoutat
Messages: 3
Registered: March 2023
Member
I'm having some issue with the 2016 Malawi micronutrient survey. I'm using the biomarker dataset to investigate iodine status of school aged children and women of reproductive age.

While in the process of setting the survey design I noticed that the the typical variable for stratum was not present (v024). With respect to that I followed protocol and grouped region and urban/rural residence (mtype x mregion) on stata. Following on from that i then set a new variable named "wght" which took the sample weight variable labelled "mweight" and divided it by 1000000.

As the primary sampling unit variable, typically v021 or any variation of it, was not present I used the "mcluster" as a suitable alternative.

I then set the survey design as follows:

svyset mcluster [pw=wght], strata(stratum)

Now it all worked fine, however when took to assessing school aged children's characteristics i noticed some discrepancies between the values I was calculating vs those reported in the MNS 2017. I've included the discrepancies in the screenshots below.

Now they are very close to each-other but there should be no reason why my output should be any different to those in DHS report. The number of children are the same (n=800). From what I can only assume, either i've done something wrong in setting the survey design or theres something else at play here. Either way I would much appreciate anyone who can help solve this issue.

Just to add the values in the final MNS report screenshot are said to be weighted. So it's not that they are crude unadjusted values.

 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Do clusters change over time?
Next Topic: PSU and GOV in Egypt
Goto Forum:
  


Current Time: Thu Apr 18 14:09:12 Coordinated Universal Time 2024