| Matching blood pressure results [message #21702] |
Thu, 10 December 2020 06:52  |
RebeccadeVlieg
Messages: 5
Registered: December 2020
|
Member |
|
|
Dear DHS experts,
I am trying to match the South Africa DHS 2016 with the report table 16.7.1 and 16.7.2 (Blood pressure status of men and women). However, I am unable to match total number of women and the systolic and diastolic mean pressure with the report. I end up with more women compared to the numbers in the report. I have attached my results and the DHS report results to this message.
I used the following coding in SPSS to calculate the blood pressure of Women:
Use file ZAPR71FL.SAV (*householdfile)
RENAME VARIABLES HVIDX= HIVLINE HV001= HIVCLUST HV002= HIVNUMB HV105= Age SH221A = SysBP1_W SH228A = SysBP2_W SH232A= SysBP3_W SH221B= DiasBP1_w SH228B= DiasBP2_W SH232B = DiasBP3_W
RECODE Age (15 thru 24=1) (25 thru 34=2) (35 thru 44=3) (45 thru 54=4) (55 thru 64=5) (65 thru
Highest=6) INTO Age_Groups_BP.
VARIABLE LABELS Age_Groups_BP 'age groups'.
EXECUTE.
RECODE DiasBP1_W (994=SYSMIS) (995=SYSMIS) (996=SYSMIS).
EXECUTE.
RECODE DiasBP2_W (994=SYSMIS) (995=SYSMIS) (996=SYSMIS).
EXECUTE.
RECODE DiasBP3_W (994=SYSMIS) (995=SYSMIS) (996=SYSMIS).
EXECUTE.
RECODE SysBP1_W (994=SYSMIS) (995=SYSMIS) (996=SYSMIS).
EXECUTE.
RECODE SysBP2_W (994=SYSMIS) (995=SYSMIS) (996=SYSMIS).
EXECUTE.
RECODE SysBP3_W (994=SYSMIS) (995=SYSMIS) (996=SYSMIS).
EXECUTE.
I cleaned for implausible values as follows:
RECODE SysBP1_W SysBP2_W SysBP3_W SysBP1_M SysBP2_M SysBP3_M (240 thru Highest=SYSMIS) (Lowest thru
70=SYSMIS).
EXECUTE.
RECODE DiasBP1_W DiasBP2_W DiasBP3_W DiasBP1_M DiasBP2_M DiasBP3_M (130 thru Highest=SYSMIS)
(Lowest thru 40=SYSMIS).
EXECUTE.
To obtain all numbers in the average I had to make the sysmis zero
RECODE SysBP1_W SysBP2_W SysBP3_W (SYSMIS=0).
EXECUTE.
RECODE DiasBP1_W DiasBP2_W DiasBP3_W (SYSMIS=0).
EXECUTE.
Calculating the average of BP
COMPUTE SysBP_W_average = (SysBP2_W + SysBP3_W)/2 .
Execute.
IF (SysBP3_W = 0) SysBP_W_average = SysBP2_W.
IF (SysBP2_W = 0) SysBP_W_average = SysBP3_W.
IF (SysBP2_W= 0 AND SysBP3_W=0) SysBP_W_average=SysBP1_W.
EXECUTE.
RECODE SysBP_W_average (0=SYSMIS).
COMPUTE DiasBP_W_average = (DiasBP2_W + DiasBP3_W)/2 .
Execute.
IF (DiasBP3_W = 0) DiasBP_W_average = DiasBP2_W.
IF (DiasBP2_W = 0) DiasBP_W_average = DiasBP3_W.
IF (DiasBP2_W= 0 AND DiasBP3_W=0) DiasBP_W_average=DiasBP1_W.
EXECUTE.
RECODE DiasBP_W_average (0=SYSMIS).
EXECUTE.
Putting the weight on
Compute WGT = HV005/1000000.
Weight by WGT.
Could you please help me to resolve this matching problem?
Many thanks!
|
|
|
|
Members
Search
Help
Register
Login
Home
