Multilevel weighting issue in Bangladesh DHS data [message #30526] |
Sat, 14 December 2024 22:08 |
toukir86
Messages: 12 Registered: November 2023
|
Member |
|
|
Dear Concern,
I am working with multilevel analysis for the most recent Bangladesh DHS but BDHS 2022 does not provide Table A.2 as the guideline for the multilevel analysis described and given in many countries like Nepal (attached below).
There are 16 clusters in BDHS 2022 but can you provide me with the values of the total number of census clusters by strata (A_h) and the average number of households per cluster by strata (M_h)?
I am giving the code below can you kindly provide me with the correct values?
* A_h total number of census clusters by strata
gen A_h = 0
replace A_h = 122 if v022 == 1
replace A_h = 87 if v022 == 2
replace A_h = 134 if v022 == 3
replace A_h = 182 if v022 == 4
replace A_h = 167 if v022 == 5
replace A_h = 206 if v022 == 6
replace A_h = 124 if v022 == 7
replace A_h = 131 if v022 == 8
replace A_h = 17 if v022 == 9
replace A_h = 86 if v022 == 10
replace A_h = 127 if v022 == 11
replace A_h = 156 if v022 == 12
replace A_h = 122 if v022 == 13
replace A_h = 138 if v022 == 14
replace A_h = 122 if v022 == 15
replace A_h = 91 if v022 == 16
* M_h average number of households per cluster by strata
gen M_h = 0
replace M_h = 24 if v022 == 1
replace M_h = 47 if v022 == 2
replace M_h = 39 if v022 == 3
replace M_h = 56 if v022 == 4
replace M_h = 52 if v022 == 5
replace M_h = 53 if v022 == 6
replace M_h = 28 if v022 == 7
replace M_h = 58 if v022 == 8
replace M_h = 17 if v022 == 9
replace M_h = 58 if v022 == 10
replace M_h = 31 if v022 == 11
replace M_h = 58 if v022 == 12
replace M_h = 23 if v022 == 13
replace M_h = 61 if v022 == 14
replace M_h = 23 if v022 == 15
replace M_h = 47 if v022 == 16
|
|
|