AHS2
> Baseline
> A2

Baseline Variable: JOINTY

Description

Number of years since operated on for joint replacement

Notes

* This variable will have a "0" level added as part of the never_had_updates
.

Data Values

Current

Original

Related variables

* SURGERY
- "Have you ever had surgery for problems other than cancer" (should be 2 if JOINTY
is greater than 0)
* JOINT
- No/Yes variable for "joint replacement" (should be 2 if JOINTY
is greater than 0)

Location

Questionnaires

Questionnaire Version	Labeled Page	Physical Page	TIFF Image Index	Scan Path
1	A2 info /	5	02	''R:\Tiff_Quest_V1''
2	A2 info /	5	45	''R:\Tiff_Quest_V2''
3	A2 info /	5	45	''R:\Tiff_Quest_V3''

Database Tables

Modifications

"Never Had" Update

For details see: "Never Had" updates
. This is a never_had_updates#Type 2
variable.

SQL Code:

-- Version 1
update image.dbo.part1
set JOINTY = '0'
where JOINTY = ''
and JOINT = '1';

update image.dbo.part1
set JOINTY = '0'
where JOINTY = ''
and JOINT = ''
and SURGERY = '1';

-- Version 2/3
update image.dbo.v2part1
set JOINTY = '0'
where JOINTY = ''
and SURGERY = '1';

update image.dbo.v3part1
set JOINTY = '0'
where JOINTY = ''
and SURGERY = '1';

Before / After counts

Version 1

Version 2

Version 3