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