Risk Adjustment Based Upon Resource Utilization - Text Mining Techniques for Healthcare Provider Quality Determination - page 243

MEPS.APPEND_MEPSTABLE.VAPLACE,
MEPS.APPEND_MEPSTABLE.IPICD1X,
MEPS.APPEND_MEPSTABLE.IPICD2X,
MEPS.APPEND_MEPSTABLE.IPICD3X,
MEPS.APPEND_MEPSTABLE.IPICD4X,
MEPS.APPEND_MEPSTABLE.IPPRO1X,
MEPS.APPEND_MEPSTABLE.IPPRO2X,
MEPS.APPEND_MEPSTABLE.IPCCC1X,
MEPS.APPEND_MEPSTABLE.IPCCC2X,
MEPS.APPEND_MEPSTABLE.IPCCC3X,
MEPS.APPEND_MEPSTABLE.IPCCC4X,
MEPS.APPEND_MEPSTABLE.DSCHPMED,
MEPS.APPEND_MEPSTABLE.FFIPTYPE,
MEPS.APPEND_MEPSTABLE.IMPFLAG,
MEPS.APPEND_MEPSTABLE.PERWT05F,
MEPS.APPEND_MEPSTABLE.VARSTR,
MEPS.APPEND_MEPSTABLE.VARPSU,
MEPS.APPEND_MEPSTABLE.self_pay,
MEPS.APPEND_MEPSTABLE.self_pay_physician,
MEPS.APPEND_MEPSTABLE.private,
MEPS.APPEND_MEPSTABLE.private_physician,
MEPS.APPEND_MEPSTABLE.public,
MEPS.APPEND_MEPSTABLE.public_physician,
MEPS.APPEND_MEPSTABLE.totalfacilities,
MEPS.APPEND_MEPSTABLE.totaldoctor,
MEPS.APPEND_MEPSTABLE.facilitycharge,
MEPS.APPEND_MEPSTABLE.physiciancharge,
MEPS.APPEND_MEPSTABLE.totalreimbursement
FROM MEPS.APPEND_MEPSTABLE AS MEPS.APPEND_MEPSTABLE;
WHERE meps.append_mepstable.IPPRO1X = “36”;
QUIT;
The remaining code filters the appended data to those observations with a primary procedure of
“36”. Table 1 gives the summary statistics by year for the payment variables. It gives the number of
procedures by year.
There is no question that there is an increase in costs by year, so that resource utilization as estimated
by payments must include some variable related to inflation. The best way to do this is to normalize the
costs for each year. Then we can identify the patients by order of costs, and examine their diagnoses.
The code to normalize is below:
Proc sort data= Meps.Bypasspatients;
By IPBEGYR;
DATA WORK.keepvariablenames;
SET meps.bypasspatients;