By Anonymous - November 3, 2014

AHS2
> Baseline
> A4

Baseline Variable: HYPOTHY

Description

Number of years since diagnosed with: Hypothyroidism (underactive thyroid)

Notes

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

Data Values

Current

Levels Value
(empty string) Missing
0 Never Had (derived from on A04Q8
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
(empty string) Missing Missing
1 Less than 1 year ago
2 1-4 years ago
3 5-9 years ago
4 10-19 years ago
5 20+ years ago

* A04Q8
- "never been told that you had any of the conditions listed below"
* HYPOTH
- Treated for this in the last 12 months: Hypothyroidism (underactive thyroid)

Location

Questionnaires

Questionnaire Version Labeled Page Physical Page TIFF Image Index Scan Path
1 A4 info
/image
7 04 ''R:\Tiff_Quest_V1''
2 A4 info
/image
7 43 ''R:\Tiff_Quest_V2''
3 A4 info
/image
7 43 ''R:\Tiff_Quest_V3''

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 5
variable.

SQL Code:

-- Version 1
update image.dbo.part1
set HYPOTHY = '0'
where HYPOTHY = ''
and A04Q8 = '1';

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

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

Before / After Counts

Version 1

Before After
A04Q8 HYPOTHY Count A04Q8 HYPOTHY Count
2558 2558
1 136 1 136
2 52 2 52
3 60 3 60
4 42 4 42
5 222 5 222
1 1943 1 0 1943
1 1 2 1 1 2
1 2 3 1 2 3
1 3 3 1 3 3
1 5 4 1 5 4

Version 2

Before After
A04Q8 HYPOTHY Count A04Q8 HYPOTHY Count
13569 13569
1 771 1 771
2 432 2 432
3 305 3 305
4 262 4 262
5 1257 5 1257
0 4 0 4
1 12658 1 0 12658
1 1 8 1 1 8
1 2 6 1 2 6
1 3 3 1 3 3
1 4 4 1 4 4
1 5 11 1 5 11

Version 3

Before After
A04Q8 HYPOTHY Count A04Q8 HYPOTHY Count
28052 28052
* 4 * 4
1 1395 1 1395
2 815 2 815
3 639 3 639
4 424 4 424
5 1737 5 1737
0 1 0 1
1 28971 1 * 2
1 * 2 1 0 28971
1 1 15 1 1 15
1 2 9 1 2 9
1 3 2 1 3 2
1 4 5 1 4 5
1 5 11 1 5 11