By Anonymous - November 3, 2014
Baseline Variable: OSTEOPOY
Description
Number of years since diagnosed with: Osteoporosis (thinning of the bones).
Notes
* (none so far)
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 |
Related variables
* 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 /  |
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 OSTEOPOY = 0
where OSTEOPOY = ''
and A04Q8 = 1;
-- Version 2
update image.dbo.v2part1
set OSTEOPOY = 0
where OSTEOPOY = ''
and A04Q8 = 1;
-- Version 3
update image.dbo.v3part1
set OSTEOPOY = 0
where OSTEOPOY = ''
and A04Q8 = 1;