By Anonymous - November 3, 2014

AHS2
> Baseline
> A5

Baseline Variable: ALLERGYY

Description

Number of years since diagnosed with: Allergies to dust/mold/pollens/animals.

Notes

* Version 1 data for this variable will be recoded from (1 to 6) to (0 to 5) as part of the never_had_updates
.
* This variable is NOT present in versions 2/3.

Data Values

Current

Levels Value
(empty string) Missing
0 Never Had (derived from on A05Q9
variables)
1 Less than 5 years ago
2 5-9 years ago
3 10-14 years ago
4 15-19 years ago
5 20+ years ago

Original

Levels Value (v1) Value (v2/3)
(empty string) Missing Missing
1 Never Had Less than 5 year ago
2 Less than 5 year ago 5-9 years ago
3 5-9 years ago 10-14 years ago
4 10-14 years ago 15-19 years ago
5 15-19 years ago 20+ years ago
6 20+ years ago N/A

* A05Q9
- version 1 - "never been told that you had any of the conditions listed below"

Location

Questionnaires

Questionnaire Version Labeled Page Physical Page TIFF Image Index Scan Path
1 A5 info
/image		 8 05 ''R:\Tiff_Quest_V1''
2 not present
3 not present

Database Tables

Table Name Description
image.dbo.part1 modified version 1 part 1 data
image.dbo.part1_unmodified original/raw version 1 part 1 data

Modifications

"Never Had" Update

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

SQL Code:

-- Version 1
update image.dbo.part1
set ALLERGYY = '0'
where ALLERGYY = ''
and A05Q9 = '1';

update image.dbo.part1
set ALLERGYY = ALLERGYY - 1
where ALLERGYY in ('1','2','3','4','5','6');

Before / After counts

Version 1

Before After
A05Q9 ALLERGYY Count A05Q9 ALLERGYY Count
1632 1632
1 967 0 967
2 10 1 10
3 3 2 3
4 2 3 2
6 2 5 2
0 1 1 0 0 1
1 2326 1 0 2407
1 1 81 1 5 1
1 6 1

Version 2/3

(not present)