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 |
Related variables
* 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 / ![]() |
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
| 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 |


