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 |
Related variables
* 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 / ![]() |
5 | 02 | ''R:\Tiff_Quest_V1'' |
| 2 | A3 info / ![]() |
6 | 44 | ''R:\Tiff_Quest_V2'' |
| 3 | A3 info / ![]() |
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)


