The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Multilevel weights level 2 (Figuring out how to create second-level weights COIR72)
Multilevel weights level 2 [message #30320] Sun, 03 November 2024 16:54 Go to next message
Deidi is currently offline  Deidi
Messages: 14
Registered: March 2021
Member

Dear DHS Forum,

I hope all is well. mr
I'm reaching out because I am working on a multilevel model using the 2015 Colombian dataset (IR & MR), and I am trying to figure out how to create second-level weights.
Specifically, I haven't been able to figure out what values to assign for A_h and M_h using Colombia's final reports (Volume I & 2). I haven't been able to identify a specific table with the distribution of EAs and their average size in number of households by region and type of residence (rural/urban) that correspond with the min and max value of v022(min 1, max 65). Also, in the survey, V022 and V023 do not have labels for which regions the values correspond to. If I tabulate v022 and rural/urban, I observe different values for rural and urban, but I'm not sure if that corresponds to A_h or M_h, or neither. Any guidance would be much appreciated.

Warm regards,
Deidi
Re: Multilevel weights level 2 [message #30323 is a reply to message #30320] Mon, 04 November 2024 11:49 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3208
Registered: February 2013
Senior Member
Following is a response from Senior DHS staff member, Tom Pullum:

The files for the Colombia 2015 survey include another geographic subdivision, "Subregion". You can open the HR file and enter the following lines in Stata:

label list hv024
label list hv025
label list SHSUBREG

gen comb=1
collapse (mean) comb, by(hv022 hv024 hv025 shsubreg)
drop comb
list, table clean noobs
list, table clean nolabel noobs

This will help you to identify the geographic areas in the stratification, although with some remaining ambiguity. I wish DHS could help with the creation of cluster-level weights for specific surveys--actually I wish that DHS could have constructed them and made them available for all surveys. However, we are not able to do this. The sampling statistician who was our main expert on this topic, Mahmoud Elkasabi, left DHS two years ago. Perhaps other users can help.

Re: Multilevel weights level 2 [message #30328 is a reply to message #30323] Tue, 05 November 2024 12:24 Go to previous message
Deidi is currently offline  Deidi
Messages: 14
Registered: March 2021
Member
Thank you Bridgette and Dr. Pullum! This response and code are very helpful. I really appreciate it.
And I second Dr. Pullum's sentiment. Making cluster-level weight variables available for all DHS surveys would be great and a huge help!

Warmly,

Deidi

[Updated on: Tue, 05 November 2024 15:02] by Moderator

Report message to a moderator

Previous Topic: Multilevel GLM poisson analysis
Next Topic: Sampling
Goto Forum:
  


Current Time: Wed Dec 11 17:24:29 Coordinated Universal Time 2024