By Anonymous - November 3, 2014

AHS2
> Baseline
> A3

Baseline Variable: TIAY

Description

Number of years since diagnosed with: Small stroke (TIA), less than 24 hours

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 A03Q7
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
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

* A03Q7
- "never been told that you had any of the conditions listed below"
* TIA
- Treated for this in the last 12 months: Small stroke (TIA), less than 24 hours

Location

Questionnaires

Questionnaire Version Labeled Page Physical Page TIFF Image Index Scan Path
1 A3 info
/image
6 03 ''R:\Tiff_Quest_V1''
2 A3 info
/image
6 44 ''R:\Tiff_Quest_V2''
3 A3 info
/image
6 44 ''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 TIAY = '0'
where TIAY = ''
and A03Q7 = '1';

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

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

Before / After Count

Version 1

Before After
A03Q7 TIAY COUNT A03Q7 TIAY COUNT
2629 2629
1 88 1 88
2 27 2 27
3 22 3 22
4 7 4 7
5 14 5 14
1 2231 1 0 2231
1 1 3 1 1 3
1 2 1 1 2 1
1 3 2 1 3 2
1 4 1 1 4 1

Version 2

Before After
A03Q7 TIAY COUNT A03Q7 TIAY COUNT
17036 17036
* 1 * 1
1 435 1 435
2 171 2 171
3 89 3 89
4 44 4 44
5 64 5 64
0 3 0 3
0 1 1 0 1 1
1 11423 1 0 11423
1 1 10 1 1 10
1 2 4 1 2 4
1 3 2 1 3 2
1 4 4 1 4 4
1 5 3 1 5 3

Version 3

Before After
A03Q7 TIAY COUNT A03Q7 TIAY COUNT
34867 34867
* 5 * 5
1 750 1 750
2 353 2 353
3 172 3 172
4 77 4 77
5 116 5 116
1 25708 1 0 25708
1 1 17 1 1 17
1 2 6 1 2 6
1 3 6 1 3 6
1 4 2 1 4 2
1 5 3 1 5 3