By Anonymous - November 3, 2014

AHS2
> Baseline
> A4

Baseline Variable: FIBROY

Description

Number of years since diagnosed with: Fibromyalgia.

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

* A04Q8
- "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 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 FIBROY = '0'
where FIBROY = ''
and A04Q8 = '1';

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

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

Before / After Counts

Version 1

Before After
A04Q8 FIBROY Count A04Q8 FIBROY Count
2920 2920
1 64 1 64
2 36 2 36
3 19 3 19
4 11 4 11
5 20 5 20
1 1949 1 0 1949
1 1 5 1 1 5
1 4 1 1 4 1

Version 2

Before After
A04Q8 FIBROY Count A04Q8 FIBROY Count
15688 15688
* 1 * 1
1 346 1 346
2 233 2 233
3 183 3 183
4 72 4 72
5 73 5 73
0 4 0 4
1 12683 1 0 12683
1 1 2 1 1 2
1 2 1 1 2 1
1 3 1 1 3 1
1 5 3 1 5 3

Version 3

Before After
A04Q8 FIBROY Count A04Q8 FIBROY Count
31456 31456
* 1 * 1
1 575 1 575
2 426 2 426
3 318 3 318
4 160 4 160
5 130 5 130
0 1 0 1
1 28998 1 0 28998
1 1 5 1 1 5
1 2 5 1 2 5
1 3 3 1 3 3
1 4 2 1 4 2
1 5 2 1 5 2