The DHS Program User Forum: Weighting data » Multilevel weighting issue in Bangladesh DHS data

Home » Data » Weighting data » Multilevel weighting issue in Bangladesh DHS data

Show: Today's Messages :: Show Polls :: Message Navigator

Re: Multilevel weighting issue in Bangladesh DHS data [message #30538 is a reply to message #30533]

Tue, 17 December 2024 05:59

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.

Report message to a moderator

[Message index]

		Multilevel weighting issue in Bangladesh DHS data By: toukir86 on Sat, 14 December 2024 22:08
		Re: Multilevel weighting issue in Bangladesh DHS data By: Bridgette-DHS on Mon, 16 December 2024 09:57
		Re: Multilevel weighting issue in Bangladesh DHS data By: toukir86 on Tue, 17 December 2024 05:59
		Re: Multilevel weighting issue in Bangladesh DHS data By: Bridgette-DHS on Tue, 17 December 2024 07:26

Previous Topic:	Guidance Needed on Weighting for Pooled DHS Data in Logistic Regression
Next Topic:	Publication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jul 28 19:28:47 Coordinated Universal Time 2025