AHS2
> Baseline
> A2

Baseline Variable: APPENDY

Description

Number of years since operated on for this condition: Appendix

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 APPENDY
is greater than 0)
* APPEND
- No/Yes variable for surgery for "Appendix" (should be 2 if APPENDY
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 APPENDY = '0'
where APPENDY = ''
and APPEND = '1';

update image.dbo.part1
set APPENDY = '0'
where APPENDY = ''
and APPEND = ''
and SURGERY = '1';

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

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

Before / After Counts

Version 1

Version 2

Version 3