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

Figure 36. Number of doses for the drug, Estrogen
for Actonel®. Either the Actonel® is misprescribed, or the ICD9 code is inappropriately listed.
Evista® similarly has 296 out of 690 primary ICD9 codes listed as 733, but unlike Actonel®, it has
5 secondary codes also listed as 733. While there are also diagnoses listed for arthritis (715-716), there
are 88 primary codes for V68 (Encounters for administrative purposes). This code suggests that the
purpose of the encounter was to write a new prescription for a recurring medication. For Fosamax®,
there are 1531 primary codes out of 2009 for osteoporosis. There are an additional 88 primary codes for
arthritis, 46 primary codes for V68, and 61 for V82 (Special screening for other conditions). In contrast,
none of the primary codes for estrogen are for osteoporosis or arthritis. The primary code listed is for
627 (Menopausal and postmenopausal disorders). It suggests that the estrogen prescriptions are not for
osteoporosis.
Finally, we want to examine the relationship of patient compliance to hospital outcomes. We want
to consider whether patients taking these medications have any fractures, particularly hip or ankle frac-
tures, that may have resulted from osteoporosis. Then we can include patient compliance in addition to
patient severity to examine these outcomes. We merge the medications dataset to the inpatients dataset.
A similar merge to the outpatient dataset is done in the same manner.
PROC SQL;
CREATE TABLE SASUSER.QUERY1_FOR_SUMMARY_STATISTI_0001 AS SELECT MEANSUMMARYSTATSSUMMA-
RYOFHC_00.RevisedRXName,
MEANSUMMARYSTATSSUMMARYOFHC_00.RXSTRENG,
MEANSUMMARYSTATSSUMMARYOFHC_00.DUPERSID,
MEANSUMMARYSTATSSUMMARYOFHC_00._WAY_,
MEANSUMMARYSTATSSUMMARYOFHC_00._TYPE_,
MEANSUMMARYSTATSSUMMARYOFHC_00._FREQ_,
MEANSUMMARYSTATSSUMMARYOFHC_00.RXQUANTY_Mean,
MEANSUMMARYSTATSSUMMARYOFHC_00.RXQUANTY_StdDev,
MEANSUMMARYSTATSSUMMARYOFHC_00.RXQUANTY_Min,
MEANSUMMARYSTATSSUMMARYOFHC_00.RXQUANTY_Max,
MEANSUMMARYSTATSSUMMARYOFHC_00.RXQUANTY_Sum,
MEANSUMMARYSTATSSUMMARYOFHC_00.RXQUANTY_N,
h94f.DUID,