The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Biomarkers » 'Percentage measured for blood pressure' - Namibia 2013 (The variable used for 'Percentage measured for blood pressure' in the final report)
'Percentage measured for blood pressure' - Namibia 2013 Tue, 01 September 2020 14:42
 ALICE -DHS USER Messages: 8Registered: September 2020 Member
Hello,

I am using the Namibian DHS 2013 to look at hypertension and I am beginning by matching my tables in STATA with the tables in the final report to ensure I am using the right dataset.

For Table 17.1 of the Namibia 2013 DHS the table include 'Percentage measured for blood pressure^1'. I wondered if anyone would be able to advise me which variable was used to determine this, as there were three measurements taken and different numbers consented each time. I have tried to create tables with a number of the consent or measurement variables but I have not been able to get the numbers to match. The column heading in the table does have the superscript 1 although I haven't been able to find this explained or detailed in the footnotes of the table.

Any suggestions for the variable that would be used would be much appreciated, thank you :)
Re: 'Percentage measured for blood pressure' - Namibia 2013 [message #19926 is a reply to message #19923] Wed, 02 September 2020 09:41
 Shireen-DHS Messages: 136Registered: August 2020 Location: USA Senior Member
Dear Alice,

The Stata code below will give you the percentage of men/women that were measured for blood pressure. The variables used for the blood pressure measurement are sh335aa and sh335ab .
Only consider values in the range of 30 to 300 for sh335aa and in the range of 0 to 160 for sh335ab.

*Table 17.1
gen bpmeasured=0 if inrange(hv105,34,65) & hs0!=.
replace bpmeasured=1 if sh333==1

*to see the total for men and women. Note that the table is unweighted.
tab bpmeasured hv104, col

Thank you

Best,
Shireen Assaf
The DHS Program
Re: 'Percentage measured for blood pressure' - Namibia 2013 [message #19929 is a reply to message #19926] Thu, 03 September 2020 08:47
 ALICE -DHS USER Messages: 8Registered: September 2020 Member
Dear Shireen Assaf

Thank you so much for your help, I have been able to match my numbers in STATA with Table 17.1.

I do have another question regarding the blood pressure variables. Is it possible to group the Blood pressure readings into the Classifications- Optimal, Normal, High normal etc. as in Table 17.4.1 of the final report.
I am aware of how to group data from one variable however since these blood pressure classifications involve the range of both systolic and diastolic readings, for examples the Optimal group would require systolic (sh335aa) readings below 120 and diastolic (sh335ab) reading below 80, I am not sure how to go about this in STATA?

Thank you,

Alice
Re: 'Percentage measured for blood pressure' - Namibia 2013 [message #19931 is a reply to message #19929] Thu, 03 September 2020 10:51
 Shireen-DHS Messages: 136Registered: August 2020 Location: USA Senior Member
Hello Alice,

Following the ranges described on p241 of the final report, please use the following Stata code to match Table 17.4.1.

Best,
Shireen

*** Stata code for Table 17.4.1 Namibia 2013 survey ****

gen bpmeasured=0 if inrange(hv105,34,65) & hs0!=.
replace bpmeasured=1 if sh333==1

gen wt=hv005/1000000

gen bplevels=0
replace bplevels=1 if sh335aa<120 & sh335ab<80
replace bplevels=2 if inrange(sh335aa,120,129) | inrange(sh335ab,80,84)
replace bplevels=3 if inrange(sh335aa,130,139) | inrange(sh335ab,85,89)
replace bplevels=4 if inrange(sh335aa,140,159) | inrange(sh335ab,90,99)
replace bplevels=5 if inrange(sh335aa,160,179) | inrange(sh335ab,100,109)
replace bplevels=6 if sh335aa>180 | sh335ab>110

replace bplevels =. if bpmeasured==0 | !inrange(sh335aa,30,300) | !inrange(sh335ab,0,160)
label define bplevels 1"optimal" 2"normal" 3"high normal" 4"mildly elevated" 5"moderately elevated" 6"severely elevated"
label values bplevels bplevels

*for women - Table 17.4.1
tab bplevels if hv104==2 [iw=wt]
Re: 'Percentage measured for blood pressure' - Namibia 2013 [message #19939 is a reply to message #19931] Fri, 04 September 2020 09:53
 ALICE -DHS USER Messages: 8Registered: September 2020 Member
Hello Shireen

Thank you so much for your help with Table 17.4.1, that has solved the problem I was having completely.

In a previous answer regarding Blood Pressure you mentioned to 'Only consider values in the range of 30 to 300 for sh335aa and in the range of 0 to 160 for sh335ab.'
I wondered if this is also the case with with Fasting Blood Glucose sh336k, is there a cut off range for these readings as well?

Thank you
Alice
Re: 'Percentage measured for blood pressure' - Namibia 2013 [message #19942 is a reply to message #19939] Fri, 04 September 2020 11:24
 Shireen-DHS Messages: 136Registered: August 2020 Location: USA Senior Member
Hello Alice,

You are correct, the range for sh336k is from 0 to 222. You will also need the variable sh336e to select for those who granted permission to be measured.

Best,

Shireen
Re: 'Percentage measured for blood pressure' - Namibia 2013 [message #19943 is a reply to message #19939] Fri, 04 September 2020 11:32
 ALICE -DHS USER Messages: 8Registered: September 2020 Member
Thank you for your help Shireen.

Best,
Alice
Re: 'Percentage measured for blood pressure' - Namibia 2013 [message #19990 is a reply to message #19943] Fri, 11 September 2020 10:44
 ALICE -DHS USER Messages: 8Registered: September 2020 Member
Hello Shireen

For table 17.4.1 and 17.4.2 I am having difficulty matching the total number for the 'Normal Blood Pressure and taking medication' column.
The code I have tried is below however I think I have overlooked something because the number I am getting are too large.
E.g. 5.9% of 1406 men had 'Normal Blood Pressure and taking medication' so I am trying to get a number close to 82.954 however with my code I get 123.23402.
For weighting I have been using the gen wt=hv005/1000000 for my tables.

Any advice about where I am going wrong would be very helpful.

Thank you
Alice

* Normal BP and taking medication
* normal BP
gen nbp = 0
replace nbp = 1 if inrange(sh335aa,30,139) | inrange(sh335ab,0,89)

* normal BP and medication
gen nbp_med = 0
replace nbp_med = 1 if sh319a== 1 & nbp == 1

Re: 'Percentage measured for blood pressure' - Namibia 2013 [message #19991 is a reply to message #19990] Fri, 11 September 2020 11:18
 Shireen-DHS Messages: 136Registered: August 2020 Location: USA Senior Member
Hello Alice,

It's better if you use the previous code I provided that constructs the bpmeasured and bplevels variables. This has already selected for the correct age group, for those who were measured, and for the correct bp range. You also need to identify the sex using the hv104 variable for each table. Following the previous code, please generate the bplevels variable and then run the following code for women (hv104==2). This gave me a match of 8% for 2,048 women.

Thank you.
Best,
Shireen

* normal BP and medication
gen nbp_med = 0 if bplevels!=.
replace nbp_med = 1 if sh319a== 1 & bplevels <4

tab nbp_med if hv104==2 [iw=wt]
Re: 'Percentage measured for blood pressure' - Namibia 2013 [message #20019 is a reply to message #19991] Wed, 16 September 2020 07:27
 ALICE -DHS USER Messages: 8Registered: September 2020 Member
Hello Shireen

Thank you so much for your reply and help once again!

Best
Alice
Re: 'Percentage measured for blood pressure' - Namibia 2013 [message #20020 is a reply to message #20019] Wed, 16 September 2020 08:19
 Shireen-DHS Messages: 136Registered: August 2020 Location: USA Senior Member

You're very welcome.

Shireen
 Previous Topic: childhood tuberculosis Next Topic: Standardizing glucose measurements across surveys
Goto Forum:

Current Time: Mon Jun 5 15:57:21 Coordinated Universal Time 2023