The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Multilevel weighting issue in Bangladesh DHS data
Re: Multilevel weighting issue in Bangladesh DHS data [message #30538 is a reply to message #30533] Tue, 17 December 2024 05:59 Go to previous messageGo to previous message
toukir86 is currently offline  toukir86
Messages: 12
Registered: November 2023
Member
Thanks for your prompt reply. Also, I am facing a problem while doing a multilevel analysis for Jordan. As the strata v022 is not given in recoded way so I assumed the serial of A.2 as the serial and recoded the values of A_h and M_h

* A_h total number of census clusters by strata (Table A.2 of the DHS report)
gen A_h = 0

replace A_h = 6634 if v022 == 1 // Amman
replace A_h = 213 if v022 == 2 // Amman
replace A_h = 784 if v022 == 3 // Balqa
replace A_h = 221 if v022 == 4 // Balqa
replace A_h = 2727 if v022 == 5 // Zarqa
replace A_h = 47 if v022 == 6 // Zarqa refuge camp
replace A_h = 149 if v022 == 7 // Zarqa
replace A_h = 334 if v022 == 8 // Madaba
replace A_h = 123 if v022 == 9 // Madaba
replace A_h = 2997 if v022 == 10 // Irbid
replace A_h = 311 if v022 == 11 // Irbid
replace A_h = 584 if v022 == 12 // Mafraq
replace A_h = 114 if v022 == 13 // Mafraq refuge camp
replace A_h = 468 if v022 == 14 // Mafraq
replace A_h = 320 if v022 == 15 // Jarash
replace A_h = 134 if v022 == 16 // Jarash
replace A_h = 364 if v022 == 17 // Ajloun
replace A_h = 88 if v022 == 18 // Ajloun
replace A_h = 347 if v022 == 19 // Karak
replace A_h = 301 if v022 == 20 // Karak
replace A_h = 192 if v022 == 21 // Tafiela
replace A_h = 58 if v022 == 22 // Tafiela
replace A_h = 178 if v022 == 23 // Ma'an
replace A_h = 134 if v022 == 24 // Ma'an
replace A_h = 381 if v022 == 25 // Aqaba
replace A_h = 86 if v022 == 26 // Aqaba

*********STEP 3******
* M_h average number of households per cluster by strata (Table A.2 of the DHS report)
gen M_h = 0

replace M_h = 126 if v022 == 1 // Amman
replace M_h = 101 if v022 == 2 // Amman
replace M_h = 105 if v022 == 3 // Balqa
replace M_h = 79 if v022 == 4 // Balqa
replace M_h = 95 if v022 == 5 // Zarqa
replace M_h = 235 if v022 == 6 // Zarqa refuge camp
replace M_h = 67 if v022 == 7 // Zarqa
replace M_h = 89 if v022 == 8 // Madaba
replace M_h = 68 if v022 == 9 // Madaba
replace M_h = 109 if v022 == 10 // Irbid
replace M_h = 90 if v022 == 11 // Irbid
replace M_h = 88 if v022 == 12 // Mafraq
replace M_h = 203 if v022 == 13 // Mafraq refuge camp
replace M_h = 68 if v022 == 14 // Mafraq
replace M_h = 111 if v022 == 15 // Jarash
replace M_h = 83 if v022 == 16 // Jarash
replace M_h = 80 if v022 == 17 // Ajloun
replace M_h = 65 if v022 == 18 // Ajloun
replace M_h = 107 if v022 == 19 // Karak
replace M_h = 87 if v022 == 20 // Karak
replace M_h = 79 if v022 == 21 // Tafiela
replace M_h = 69 if v022 == 22 // Tafiela
replace M_h = 89 if v022 == 23 // Ma'an
replace M_h = 94 if v022 == 24 // Ma'an
replace M_h = 86 if v022 == 25 // Aqaba
replace M_h = 61 if v022 == 26 // Aqaba


But I am getting an error in STATA: "Weights in variable wt2_1 not constant within groups defined by: v001." The weights do not seem to be constant for the unique cluster. I think my strata assigning is not going correctly.
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Cluster level weights for NHFS-5 India
Goto Forum:
  


Current Time: Wed Dec 25 15:24:34 Coordinated Universal Time 2024