Home » Topics » Biomarkers » Blood Pressure and Diabetes Bangladesh 2017-18 (Biomarker )
| Re: Blood Pressure and Diabetes Bangladesh 2017-18 [message #30017 is a reply to message #21813] |
Wed, 11 September 2024 02:20   |
bakerchowdhury
Messages: 25
Registered: April 2014
|
Member |
|
|
Dear Dr. Riese,
Thank you so much for your continuous support with the data. I am currently reviewing the 2022 BDHS dataset, specifically focusing on the diabetes and hypertension variables, and am working with the Household Member Recode (BDPR81FL) file.
I have noticed that systolic, diastolic, and blood glucose values are recorded in separate columns for men and women. For instance, `wbp24` and `wbp25` represent systolic and diastolic values for women, while `mbp24` and `mbp25` are for men. Additionally, `wbp19` and `wbp20` denote blood pressure medication for women and men, respectively. Similarly, `sb267g` and `sb367g` represent blood glucose values for women and men, while `sb240` and `sb340` indicate diabetes medication for men and women, respectively.
Could you please advise on the best approach to consolidate this data into single columns for:
- Systolic values for both men and women
- Diastolic values for both men and women
- Blood pressure medications for both men and women
along with other characteristics such as age, sex, region, education, wealth index, and BMI, so that I can compare these with the previous survey (2017-18 BDHS) iteration? Additionally, I am looking to obtain an overall prevalence of diabetes and hypertension rather than calculating them separately for each gender.
Below is the code I have used to create the hypertension and diabetes variables for each gender separately, but I would like to have them into a single dataset for both genders.
use "BDPR81FL", replace
rename wbp24 w_systolic
rename wbp25 w_diastolic
sum w_systolic w_diastolic
gen validbp = 0
replace validbp =1 if w_systolic!=. & w_diastolic!=.
tab validbp,m
drop if validbp==0
gen w_bpclass = 0 if hv104 ==2 & validbp==1
replace w_bpclass = 1 if (w_systolic<120 & w_diastolic<80) & validbp==1
replace w_bpclass = 2 if (w_systolic>=120 & w_systolic<130) | (w_diastolic>=80 & w_diastolic<85) & validbp==1
replace w_bpclass = 3 if (w_systolic>=130 & w_systolic<140) | (w_diastolic>=85 & w_diastolic<90) & validbp==1
replace w_bpclass = 4 if (w_systolic>=140 & w_systolic<160) | (w_diastolic>=90 & w_diastolic<100) & validbp==1
replace w_bpclass = 5 if (w_systolic>=160 & w_systolic<180) | (w_diastolic>=100 & w_diastolic<110) & validbp==1
replace w_bpclass = 6 if (w_systolic>=180) | (w_diastolic>=110) & validbp==1
svy: tab w_bpclass
With this code the women hypertension prevalence matches however, I am getting no of women 7899, however report shows 7724 (Table 14.3.1)
Thank you again for your invaluable assistance.
|
|
|
|
Current Time: Mon Dec 2 13:28:20 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
