AHS2
> Baseline
> A4

Baseline Variable: TYPEIIY

Description

Number of years since diagnosed with: Diabetes mellitus (Type II - adult onset)

Notes

* "Never Had" value, coded as 0, added as appropriate as part of the never_had_updates
.

Data Values

Current

Original

Related variables

* A04Q8
- "never been told that you had any of the conditions listed below"
* TYPEII
- Treated for this in the last 12 months: Diabetes mellitus (Type II - adult onset)

Location

Questionnaires

Questionnaire Version	Labeled Page	Physical Page	TIFF Image Index	Scan Path
1	A4 info /	7	04	''R:\Tiff_Quest_V1''
2	A4 info /	7	43	''R:\Tiff_Quest_V2''
3	A4 info /	7	43	''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 TYPEIIY = '0'
where TYPEIIY = ''
and A04Q8 = '1';

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

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

Before / After Counts

Version 1

Version 2

Version 3