By Anonymous - November 3, 2014

AHS2
> Baseline
> A5

Baseline Variable: HIVY

Description

Number of years since diagnosed with: Tested HIV positive.

Notes

* Version 1 data for this variable will be recoded from (1 to 6) to (0 to 5) as part of the never_had_updates
.
* This variable is NOT present in versions 2/3.

Data Values

Current

Levels Value
(empty string) Missing
0 Never Had (derived from on A05Q9
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 (v1) Value (v2/3)
(empty string) Missing Missing
1 Never Had Less than 5 year ago
2 Less than 5 year ago 5-9 years ago
3 5-9 years ago 10-14 years ago
4 10-14 years ago 15-19 years ago
5 15-19 years ago 20+ years ago
6 20+ years ago N/A

* A05Q9
- version 1 - "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 A5 info
/image		 8 05 ''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 6
variable.

SQL Code:

-- Version 1
update image.dbo.part1
set HIVY = '0'
where HIVY = ''
and A05Q9 = '1';

update image.dbo.part1
set HIVY = HIVY - 1
where HIVY in ('1','2','3','4','5','6');;

Before / After Counts

Version 1

Before After
A05Q9 HIVY Count A05Q9 HIVY Count
1687 1687
1 923 0 923
2 2 1 2
3 1 2 1
4 1 3 1
5 1 4 1
6 1 5 1
0 1 1 0 0 1
1 2343 1 0 2408
1 1 65

Version 2/3

(not present)