AHS2
> Baseline
> A3

Baseline Variable: ASTHMAY

Description

Number of years since diagnosed with: Asthma

Notes

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

Data Values

Current

Original

Related variables

* A03Q7
- "never been told that you had any of the conditions listed below"
* ASTHMA
- Treated for this in the last 12 months: Asthma

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 ASTHMAY = '0'
where ASTHMAY = ''
and A03Q7 = '1';

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

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

Before / After Counts

Version 1

Version 2

Version 3