By Anonymous - November 4, 2014

AHS2
> Baseline
> A3

Baseline Variable: VASECTY

Description

Number of years since surgery: vasectomy

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 (VASECT
)
* 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 VASECT
/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
- Version 1 - "Have you ever had surgery for problems other than cancer" (should be 2 if VASECTY
is greater than 0)
* VASECT
- Version 1 - No/Yes variable for "Vasectomy" (should be 2 if VASECTY
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 VASECTY = '0'
where VASECTY = ''
and VASECT = '1';

update image.dbo.part1
set VASECTY = '0'
where VASECTY = ''
and VASECT = ''
and SURGERY = '1';

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

Before / After counts

Version 1

Before After
SURGERY VASECT VASECTY COUNT SURGERY VASECT VASECTY COUNT
74 74
2 1 2 1
4 1 4 1
5 2 5 2
1 14 1 0 14
2 1 2 1
1 802 1 0 802
1 4 1 1 4 1
1 5 4 1 5 4
1 1 31 1 1 0 31
2 2923 2 2923
2 2 3 2 2 3
2 3 1 2 3 1
2 4 6 2 4 6
2 5 16 2 5 16
2 1 622 2 1 0 622
2 1 5 1 2 1 5 1
2 2 11 2 2 11
2 2 2 23 2 2 2 23
2 2 3 28 2 2 3 28
2 2 4 86 2 2 4 86
2 2 5 374 2 2 5 374

Version 2/3

(no modifications)