By Anonymous - November 4, 2014

AHS2
> Baseline
> A3

Baseline Variable: PROSTY

Description

Number of years since surgery on the prostate gland

Notes

* This variable will have a "0" level added as part of the never_had_updates
.
* In version 1 only, this has an associated YES/NO variable (PROST
)
* This is a male-specific condition and should be validated with the SEX
variable.

Data Values

Current

Levels Value
(empty string) Missing
0 Never Had (derived from on PROST
/SURGERY
variables)
1 Less than 1 year ago
2 1-4 years ago
3 5-9 years ago
4 10-19 years ago
5 20+ years ago

Original

Levels Value
(empty string) Missing
1 Less than 1 year ago
2 1-4 years ago
3 5-9 years ago
4 10-19 years ago
5 20+ years ago

* SURGERY
- "Have you ever had surgery for problems other than cancer" (should be 2 if PROSTY
is greater than 0)
* PROST
- Version 1 - No/Yes variable for "surgery on the prostate gland" (should be 2 if PROSTY
is greater than 0)
* SEX
- "What is your sex?"

Location

Questionnaires

Questionnaire Version Labeled Page Physical Page TIFF Image Index Scan Path
1 A2 info
/image
5 02 ''R:\Tiff_Quest_V1''
2 A3 info
/image
6 44 ''R:\Tiff_Quest_V2''
3 A3 info
/image
6 44 ''R:\Tiff_Quest_V3''

Database Tables

Table Name Description
image.dbo.part1 modified version 1 part 1 data
image.dbo.part1_unmodified original/raw version 1 part 1 data

Modifications

"Never Had" Update

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

SQL Code:

-- Version 1
update image.dbo.part1
set PROSTY = '0'
where PROSTY = ''
and PROST = '1';

update image.dbo.part1
set PROSTY = '0'
where PROSTY = ''
and PROST = ''
and SURGERY = '1';

-- Version 2/3
-- no modifications (because SURGERY variable is on another page)

Before / After counts

Version 1

Before After
SURGERY PROST PROSTY COUNT SURGERY PROST PROSTY COUNT
78 78
1 15 1 0 15
1 803 1 0 803
1 3 1 1 3 1
1 1 34 1 1 0 34
2 3040 2 3040
2 1 1 2 1 1
2 3 3 2 3 3
2 4 5 2 4 5
2 1 898 2 1 0 898
2 1 2 1 2 1 2 1
2 1 3 3 2 1 3 3
2 1 4 2 2 1 4 2
2 1 5 1 2 1 5 1
2 2 6 2 2 6
2 2 1 12 2 2 1 12
2 2 2 31 2 2 2 31
2 2 3 31 2 2 3 31
2 2 4 44 2 2 4 44
2 2 5 16 2 2 5 16

Version 2/3

(no modification)