AHS2
> Baseline
> A3

Baseline Variable: TUBALY

Description

Number of years since surgery: Tubal ligation

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 (TUBAL
)
* In version 1, there is *no same-page collective variable* (i.e. SURGERY
)
* This is a female-specific condition and should be validated with the SEX
variable.

Data Values

Current

Original

Related variables

* SURGERY
- Version 2/3 - "Have you ever had surgery for problems other than cancer" (should be 2 if TUBALY
is greater than 0)
* TUBAL
- Version 1 - No/Yes variable for "Tubal ligation" (should be 2 if TUBALY
is greater than 0)
* SEX
- "What is your sex?"

Location

Questionnaires

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

Database Tables

Modifications

"Never Had" Update

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

SQL Code:

-- Version 1
update image.dbo.part1
set TUBALY = '0'
where TUBALY = ''
and TUBAL = '1';

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

update image.dbo.v3part1
set TUBALY = '0'
where TUBALY = ''
and SURGERY = '1';

Before / After counts

Version 1

Version 2

Version 3