By Anonymous - October 27, 2014

AHS2
> Baseline
> A2

Baseline Variable: BONESY

Description

Number of years since operated on for this condition: Surgery for broken bones

Notes

* This variable will have a "0" level added as part of the never_had_updates
.
* Only present in version 1

Data Values

Current

Levels Value
(empty string) Missing
0 Never Had (derived from on BONES
/SURGERY
variables)
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

Original

Levels Value
(empty string) 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

* SURGERY
- "Have you ever had surgery for problems other than cancer" (should be 2 if BONESY
is greater than 0)
* BONES
- No/Yes variable for "Surgery for broken bones" (should be 2 if BONESY
is greater than 0)

Location

Questionnaires

Questionnaire Version Labeled Page Physical Page TIFF Image Index Scan Path
1 A2 info
/image		 5 02 ''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 1
variable.

SQL Code:

update image.dbo.part1
set BONESY = 0
where BONESY = ''
and BONES = 1;

update image.dbo.part1
set BONESY = 0
where BONESY = ''
and BONES = ''
and SURGERY = 1;

Before / After counts

Version 1

Before After
SURGERY BONES BONESY COUNT SURGERY BONES BONESY COUNT
67 67
2 1 2 1
1 23 1 0 23
2 2 2 2
1 773 1 0 773
1 1 65 1 1 0 65
2 1348 2 1348
2 1 1 2 1 1
2 2 6 2 2 6
2 3 4 2 3 4
2 4 6 2 4 6
2 5 13 2 5 13
2 1 2237 2 1 0 2237
2 1 2 2 2 1 2 2
2 1 4 3 2 1 4 3
2 1 5 4 2 1 5 4
2 2 24 2 2 24
2 2 1 24 2 2 1 24
2 2 2 61 2 2 2 61
2 2 3 61 2 2 3 61
2 2 4 100 2 2 4 100
2 2 5 200 2 2 5 200

Version 2/3

(Variable not present)