With regard to Missing Data, Table 15 provides details of the relatively minimal ‘Missing Data’ from ANDIAB2.

The Missing Data items are listed in increasing frequency. Overall Missing Data ranged from [n=5] 0.4% [Have Contact Number for Advice] to [n=451] 21.2 % [HbA1c], however 53.7% of the data items were less than 5% missing {[0-1] 13.0% | [1-2] 3.7% | [2-3] 18.5% | [3-4] 14.8%] | [4-5] 3.7%]}, 24.1% were missing from 5-10% of records and 22.2% were missing from 10.3-22.5% of records.

This is in contrast to ANDIAB2 2005, where there was less missing data:
85.5% of the data items were less than 5% missing {[0-1] 36.4% | [1-2] 23.6% | [2-3] 18.2% | [3-4.5] 7.3%]}, 9.1% were missing from 5-10% of records and 5.5% {just three fields} were missing from 11-27.6% of records.

This is in stark contrast to ANDIAB 2009 [N=8563] however, where only 20.0% of the data items were less than 20% missing. Further analysis of ANDIAB data showed:
Whilst some data items were almost 100% collected, overall Missing Data ranged from [n=25] 0.4% [Date of Birth] to [n=6007] 70.2% [BP-Thiazides], thence [n=5848] 68.3 % [Attended Optometrist] and 67.4% [BP-Other]. There were 20.0% of the data items less than 20% missing {[0-5] 7.0% / [5-10] 1.7% / [10- 15] 3.5% / [15-20] 7.8%]}, 23.5% were missing from 20-40% of records and 56.5% were missing from >40% of records [Table 24] 2.

Whilst much of the ANDIAB 2009 missing data relate to Fields such as Eye Data, which may not be readily available to the Clinician, there would appear no doubt that the ANDIAB2 completeness of data collection is a testament to the diligence of those who participated [including the individuals themselves in completing the EQ-5D and DDS components].

[See Appendices > Missing Data - for all missing data graphs].

Sites were given an opportunity to supply any missing data and to validate questionable data. Table 15[a] shows the Missing ‘Vital’ Data items obtained by requesting their provision from sites – with substantial improvements, (except ‘Insulin Since’ - only 39.3% obtained). As can be seen from the Table below, this process reduced the missing data in six of the seven elements sought, by two thirds - to over 90% {67.6-90.7%}.

It was only necessary in a few instances to review data items that were not possible (as indicated in Methodlogy Undertaken) [eg ‘Management Method’ not Insulin, but ‘Insulin Since’ not null - in which case the ‘Insulin Since’ date was removed and considered missing in the pooled database, prior to final data analysis].

There was one duplicate data sheet provided – and the extra one was removed.

Table 15[a] Missing Data Obtained from Sites

Initially Missing

Data Item
n =
[%]
Date of Birth
28
1.3%
Sex
74
3.5%
Initial Visit
75
3.5%
Diagnosis Year
37
1.7%
Diabetes Type
52
2.4%
Diabetes Therapy
82
3.8%
Insulin Since
56
2.6%

Still Missing

Data Item
n =
[%]
Date of Birth
7
0.3%
Sex
9
0.4%
Initial Visit
7
0.3%
Diagnosis Year
12
0.6%
Diabetes Type
5
0.2%
Diabetes Therapy
8
0.4%
Insulin Since
34
1.6%

Obtained

Data Item
[%]
Date of Birth
75.0%
Sex
87.8%
Initial Visit
90.7%
Diagnosis Year
67.6%
Diabetes Type
90.4%
Diabetes Therapy
90.2%
Insulin Since
39.3%

Table 15 Missing Data

'Field (Condition)'
'n 2005'
% 2005'
'n 2010'
'% 2010'
Complementary Therapy - Told Dr or Educator of use ( Only Patients who are on Complementary Therapy )
2
0.6
5
0.8
Tried to stop smoking ( Current Smokers Only )
13
8.8
6
2.2
Advice - Have contact number of Diabetes Care contact ( Only Patients who know who to contact )
2
0.2
7
0.4
Date Of Birth
34
2.4
10
0.5
Initial Visit
25
1.8
12
0.6
Year of diagnosis
16
1.1
14
0.7
Type of Diabetes
2
0.1
16
0.8
Management method
9
0.6
18
0.8
DDS 17 Questionnaire Done
0
21
2.6
Sex of Individual
26
1.9
27
1.3
Insulin start year (Only patients using Insulin)
20
3.3
32
2.3
Take Medicines as prescribed?
4
0.3
41
1.9
Carrying Identification
22
1.6
44
2.1
Advice - Know who to contact for Diabetes Care?
30
2.1
50
2.3
Attended Podiatrist
7
0.5
52
2.4
Attended Diabetes Specialist
12
0.9
54
2.5
Smoker: currently
28
2
59
2.8
Smoking Status
0
59
2.8
Attended Diabetes Educator
13
0.9
60
2.8
Attended Optometrist
0
70
3.3
Complementary Therapy or dietary supplement used
24
1.7
71
3.3
Attended Psychologist
10
0.7
72
3.4
Attended Dietitian
12
0.9
72
3.4
Hypoglycamia Awareness (Not on Sulphonylurea / Insulin or no hypo in 6/12)
18
1.3
73
3.4
Attended Dentist
0
75
3.5
Carrying Hypoglycaemic Rx (Not on Sulphonylurea or Insulin)
7
0.5
75
3.5
Attended Exercise Physiologist
0
80
3.8
Attended Social Worker
20
1.4
92
4.3
Given Consumer Medicines Information?
56
4
100
4.7
Vaccination - Flu in past 12 months
6
0.4
115
5.4
LipoHypertrophy Present
62
4.4
119
5.6
Vaccination- Pneumococcal in past 12 months
14
1
130
6.1
LipoAtrophy Present
51
3.8
148
6.9
Indigenous - ATSI
134
9.5
156
7.3
NDSS Member
0
157
7.4
DVA Patient
155
11
178
8.4
DDS - Regimen-related Burden
0
183
22.3
DDS - Emotional Burden
0
183
22.3
DDS - Physician-related Burden
0
184
22.4
DDS - Total DDS Score
0
184
22.4
DDS - Interpersonal Distress
0
185
22.5
Pregnant: Currently
70
5
201
9.4
BCD - Brief case-find for depression (Calculated)
0
205
9.6
BCD - Feeling unhappy or depressed
5
0.4
208
9.8
BCD - Had restless or disturbed nights
7
0.5
210
9.9
BCD - Felt unable to overcome difficulties
6
0.4
212
9.9
On antidepressants
0
214
10
BCD - Dissatisfied with their way of doing things
9
0.6
219
10.3
Psychiatric treatment/counselling - previous
9
0.6
222
10.4
Psychiatric treatment/counselling - current
9
0.6
223
10.5
DDS - Screening Scale Q1
0
257
12.1
DDS - Screening Scale Q2
0
258
12.1
QOL - Own Health State Rating (0-100)
38
2.7
282
13.2
Glycated Haemoglobin
0
451
21.2
Top of page