AHS2
> Baseline
> A3

Baseline Variable: MIY

Description

Number of years since diagnosed with: Heart attack (myocardial infarction)

Notes

* "Never Had" value, coded as 0, added as appropriate as part of the never_had_updates
.
* The collective variable A03Q7
is set to zero for four records in the version 2 data.

Data Values

Current

Original

Related variables

* A03Q7
- "never been told that you had any of the conditions listed below"
* MI
- Treated for this in the last 12 months: Heart attack (myocardial infarction)

Location

Questionnaires

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

Database Tables

Modifications

"Never Had" Update

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

SQL Code:

-- Version 1
update image.dbo.part1
set MIY = '0'
where MIY = ''
and A03Q7 = '1';

-- Version 2
update image.dbo.v2part1
set MIY = '0'
where MIY = ''
and A03Q7 = '1';

-- Version 3
update image.dbo.v3part1
set MIY = '0'
where MIY = ''
and A03Q7 = '1';

Before / After Count

Version 1

Version 2

Version 3