Skip to main content

Table 2 Percentage (%) of cases with missing data for specific variables in the original APPROACH database

From: An administrative data merging solution for dealing with missing data in a clinical registry: adaptation from ICD-9 to ICD-10

   FISCAL YEAR
   ICD-9-CM ICD-10
CLINICAL VARIABLES TOTAL 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005
N 86,649 6,348 6,131 6,242 6,718 8,110 8,469 8,479 8,767 8,835 9,257 9,293
Dialysis (%) 11.5 4.7 2.8 2.5 3.6 4.9 2.1 24.1 11.0 20.7 21.5 18.2
Diabetes Type I (%) 6.5 4.7 2.8 2.5 3.6 2.9 0.9 14.4 8.8 7.8 10.0 9.2
Renal (Creatinine > 200 mmol/L) (%) 29.8 20.8 12.7 15.3 28.8 59.5 43.2 32.3 26.7 25.1 24.6 30.0
Malignancy/Metastatic Disease (%) 10.4 7.0 5.7 5.9 5.9 5.1 2.1 20.5 17.7 14.4 11.7 13.5
Prior CABG (%) 9.2 20.8 11.1 10.4 10.9 12.2 6.3 1.1 0.1 10.0 12.4 10.3
Liver/GI (%) 11.1 0.2 0.1 5.4 5.9 5.1 2.1 39.1 16.4 13.2 11.3 13.8
Prior PCI (%) 9.3 19.3 11.3 10.1 11.0 12.7 6.6 1.2 0.2 10.0 12.8 12.1
Cerebrovascular Disease (%) 10.8 4.7 2.8 2.5 3.6 4.9 2.1 11.9 11.3 21.3 23.7 20.1
PVD (%) 10.4 4.7 2.8 2.5 3.6 4.9 2.1 12.0 11.3 21.4 21.0 18.6
Pulmonary Disease (%) 9.3 7.0 5.7 5.9 5.9 5.1 2.1 17.6 14.2 11.7 11.0 12.5
Congestive heart failure (%) 14.1 20.6 17.3 8.3 10.7 16.0 10.2 12.5 10.8 17.2 17.5 14.4
Diabetes Type II (%) 6.7 4.7 2.8 2.5 3.6 2.9 0.9 14.7 8.9 7.6 10.3 10.1
Prior MI (%) 15.8 19.3 15.9 9.5 12.2 16.6 11.4 17.7 18.2 19.1 17.5 14.9
Hypertension (%) 11.2 14.9 12.4 7.8 10.8 15.1 10.9 11.5 10.0 8.7 12.2 9.3
Hyperlipidemia (%) 17.4 28.0 26.8 19.9 20.8 22.7 17.1 14.8 12.9 13.2 12.1 11.0
Proportion with one or more missing 58.9 48.2 45.8 39.5 49.5 72.3 58.3 74.1 60.0 64.8 60.2 61.3