AHS2
> Baseline
> A5

Baseline Variable: BPHY

Description

Number of years since diagnosed with: Enlarged Prostate (BPH: benign prostatic hyperplasia).

Notes

* Version 1 data for this variable will be recoded from (1 to 6) to (0 to 5) as part of the never_had_updates
.
* Version 1 was coded 1 to 6, while versions 2 and 3 were 1 to 5.
* In version 1, variable is located on A5
. In version 2/3 it is on A4

* This is a male only condition and should be validated with SEX
.

Data Values

Current

Original

Related variables

* A05Q9
- version 1 - "never been told that you had any of the conditions listed below"
* A04Q8
- version 2/3 - "never been told that you had any of the conditions listed below"
* SEX
- "What is your sex?"
* BPH
- Treated for BPH in last 12 months

Location

Questionnaires

Questionnaire Version	Labeled Page	Physical Page	TIFF Image Index	Scan Path
1	A5 info /	8	05	''R:\Tiff_Quest_V1''
2	A4 info /	7	43	''R:\Tiff_Quest_V2''
3	A4 info /	7	43	''R:\Tiff_Quest_V3''

Database Tables

Modifications

"Never Had" Update

For details see: "Never Had" updates
. This is a never_had_updates#Type 6
variable.

SQL Code:

-- Version 1
update image.dbo.part1
set BPHY = '0'
where BPHY = ''
and A05Q9 = '1';

-- Note: update was already applied
-- update image.dbo.part1
-- set BPHY = BPHY - 1
-- where BPHY > 0;

-- Version 2/3
update image.dbo.v2part1
set BPHY = '0'
where BPHY = ''
and A04Q8 = '1';

update image.dbo.v3part1
set BPHY = '0'
where BPHY = ''
and A04Q8 = '1';

Before / After Counts

Version 1

Note: the "minus one" correction had already been applied.

Version 2

Version 3