Data Visualization and Data Summary - Text Mining Techniques for Healthcare Provider Quality Determination - page 70

DUPERSID);
WHERE QUERY_FOR_SUMMARY_STATISTIC_00.IPICD1X IN (“808”, “812”, “820”, “821”, “822”,
“824”, “827”) OR QUERY_FOR_SUMMARY_STATISTIC_00.IPICD2X IN (“805”, “812”) OR QUERY_FOR_
SUMMARY_STATISTIC_00.IPICD3X IN (“807”, “814”);
QUIT;

Table 8 lists the inpatients with fractures who are taking medications for osteoporosis.
With the exception of patients #6 and 12, these patients are on the high end of the number of doses.
It suggests that patients with osteoporosis, and patients who have broken bones because of it are more
diligent in taking their medication compared to patients who are taking it as a preventative medication.
We can see if this remains the case for outpatient visits for fractures (Table 9).
There is a red flag on the 156 doses of Fosamax®. These patients are getting far more than is reason-
able, and their physicians are ignoring prescription guidelines. And yet, it is very interesting that patients
with fractures and problems related to osteoporosis are the ones taking the high doses. It would be of
interest to determine whether patients who are taking the medications just as a preventative measure
to avoid osteoporosis are the ones with limited compliance compared to patients who already have the
disease, and who have complications related to the disease. It is said that “an ounce of prevention is
worth a pound of cure”. However, if the patients don't accept the prevention, it will do little good.

future trends

Kernel density remains a rarely used technique in the medical literature to investigate population dis-
tributions. One of the reasons for this is that few statistical software packages include it as a technique.
When it is used in a Medline article (an article in a medical journal indexed by Medline as provided by

Table 8. Osteoporosis medications by inpatient fractures

Row
number

Revised
RXName

STRENGTH OF Rx/
PRESCR MED DOSE

QUANTITY OF Rx/
PRESCR MED_Sum

3-DIGIT
ICD-9-CM
CODE

3-DIGIT
ICD-9-CM
CODE

3-DIGIT
ICD-9-CM
CODE

1 Actonel® 35 12 821 -1 -1

2 Actonel® 35 12 821 -1 -1

3 Fosamax® 70 90 822 -1 -1

4

Evista® 60 150 724 733 807

5 Actonel® 35 24 827 -1 -1

6 Fosamax® 70 4 808 922 -1

7 Fosamax® 70 28 820 707 -1

8 Fosamax® 70 12 041 805 787

9 Fosamax® 70 8 824 -1 -1

10 Fosamax® 35 24 824 -1 -1

11 Actonel® 35 12 812 -1 -1

12 Fosamax® 70 4 820 812 814