Working from Claims Data - Text Mining Techniques for Healthcare Provider Quality Determination - page 345

tests performed in physician offices by the medication choice to see if treatment decisions are related
to medications. The following code merges the dataset containing the medications by patient and the
physician visits, file H94G. The description of this physician visit dataset is located at http://www.meps.
ahrq.gov/mepsweb/data_stats/download_data_files_codebook.jsp?PUFId=H94G. Then we can examine
the physician orders in relationship to physician choice for medications.

PROC SQL;
CREATE TABLE SASUSER.medsandvisits AS SELECT QUERY1_FOR_SUMMARY_STATISTI_00.Revise-

dRXName,
QUERY1_FOR_SUMMARY_STATISTI_00.RXSTRENG,
QUERY1_FOR_SUMMARY_STATISTI_00.DUPERSID,
QUERY1_FOR_SUMMARY_STATISTI_00._WAY_,
QUERY1_FOR_SUMMARY_STATISTI_00._TYPE_,
QUERY1_FOR_SUMMARY_STATISTI_00._FREQ_,
QUERY1_FOR_SUMMARY_STATISTI_00.RXQUANTY_Mean,
QUERY1_FOR_SUMMARY_STATISTI_00.RXQUANTY_StdDev,
QUERY1_FOR_SUMMARY_STATISTI_00.RXQUANTY_Min,
QUERY1_FOR_SUMMARY_STATISTI_00.RXQUANTY_Max,
QUERY1_FOR_SUMMARY_STATISTI_00.RXQUANTY_Sum,
QUERY1_FOR_SUMMARY_STATISTI_00.RXQUANTY_N,
QUERY1_FOR_SUMMARY_STATISTI_00.DUID,
QUERY1_FOR_SUMMARY_STATISTI_00.PID,
.
.
.

QUERY1_FOR_SUMMARY_STATISTI_00.VARSTR,

QUERY1_FOR_SUMMARY_STATISTI_00.VARPSU,

H94G.DUID AS DUID1,

H94G.PID AS PID1,

H94G.DUPERSID AS DUPERSID2,

H94G.EVNTIDX AS EVNTIDX1,

H94G.EVENTRN AS EVENTRN1,

H94G.FFEEIDX AS FFEEIDX1,

H94G.PANEL AS PANEL1,

H94G.MPCELIG,

H94G.MPCDATA AS MPCDATA1,

H94G.OBDATEYR,

H94G.OBDATEMM,

H94G.OBDATEDD,

H94G.SEETLKPV AS SEETLKPV1,

H94G.MVPLACE,

H94G.SEEDOC AS SEEDOC1,

H94G.DRSPLTY AS DRSPLTY1,

H94G.MEDPTYPE AS MEDPTYPE1,