AHS2
> Baseline
> A4

Baseline Variable: COLITISY

Description

Number of years since diagnosed with: Ulcerative colitis/Crohn's disease

Notes

* "Never Had" value, coded as 0, added as appropriate as part of the never_had_updates
.
* Located on page A4
in version 1, page A3
on versions 2/3.

Data Values

Current

Original

Related variables

* A04Q8
- Version 1 - "never been told that you had any of the conditions listed below"
* A03Q7
- Version 2/3 - "never been told that you had any of the conditions listed below"
* COLITIS
- Treated for this in the last 12 months: Ulcerative colitis/Crohn's disease

Location

Questionnaires

Questionnaire Version	Labeled Page	Physical Page	TIFF Image Index	Scan Path
1	A4 info /	7	04	''R:\Tiff_Quest_V1''
2	A3 info /	6	44	''R:\Tiff_Quest_V2''
3	A3 info /	6	44	''R:\Tiff_Quest_V3''

Database Tables

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

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

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

Before / After Counts

Version 1

Version 2

Version 3