AHS2
> Baseline
> A2

Baseline Variable: TONSILSY

Description

Number of years since operated on for this condition: Tonsils and/or adenoids

Notes

* This variable will have a "0" level added as part of the never_had_updates
.

Data structure

Current

Original

Related variables

* SURGERY
- "Have you ever had surgery for problems other than cancer" (should be 2 if TONSILSY
is greater than 0)
* TONSILS
- No/Yes variable for surgery on "Tonsils and/or adenoids" (should be 2 if TONSILSY
is greater than 0)

Location

Questionnaires

Questionnaire Version	Labeled Page	Physical Page	TIFF Image Index	Scan Path
1	A2 info /	5	02	''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 2
variable.

SQL Code:

-- Version 1
update image.dbo.part1
set TONSILSY = 0
where TONSILSY = ''
and TONSILS = 1;

update image.dbo.part1
set TONSILSY = 0
where TONSILSY = ''
and TONSILS = ''
and SURGERY = 1;

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

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

Before / After Counts

Version 1:

Version 2:

Version 3: