AHS2
> Baseline
> A2

Baseline Variable: CAROTIDY

Description

Number of years since operated on for this condition: Carotid arteries (arteries in neck)

Notes

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

Data Values

Current

Original

Related variables

* SURGERY
- "Have you ever had surgery for problems other than cancer" (should be 2 if CAROTIDY
is greater than 0)
* CAROTID
- No/Yes variable for surgery on "Carotid arteries" (should be 2 if CAROTIDY
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 CAROTIDY = '0'
where CAROTIDY = ''
and CAROTID = '1';

update image.dbo.part1
set CAROTIDY = '0'
where CAROTIDY = ''
and CAROTID = ''
and SURGERY = '1';

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

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

Before / After counts

Version 1

Version 2

Version 3