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

SELECT * FROM Meps.INPATIENT_1996
OUTER UNION CORR
SELECT * FROM Meps.INPATIENT_1997
OUTER UNION CORR
SELECT * FROM Meps.INPATIENT_1998
OUTER UNION CORR
SELECT * FROM Meps.INPATIENT_1999
OUTER UNION CORR
SELECT * FROM Meps.INPATIENT_2000
OUTER UNION CORR
SELECT * FROM Meps.INPATIENT_2001
OUTER UNION CORR
SELECT * FROM Meps.INPATIENT_2002
OUTER UNION CORR
SELECT * FROM Meps.INPATIENT_2003
OUTER UNION CORR
SELECT * FROM Meps.INPATIENT_2004
;
Quit;
The above code appends the inpatient datasets together for the years 1996-2005.
PROC SQL;
CREATE TABLE Meps.Bypasspatients AS SELECT MEPS.APPEND_MEPSTABLE.DUID,
MEPS.APPEND_MEPSTABLE.PID,
MEPS.APPEND_MEPSTABLE.DUPERSID,
MEPS.APPEND_MEPSTABLE.EVNTIDX,
MEPS.APPEND_MEPSTABLE.EVENTRN,
MEPS.APPEND_MEPSTABLE.ERHEVIDX,
MEPS.APPEND_MEPSTABLE.FFEEIDX,
MEPS.APPEND_MEPSTABLE.PANEL,
MEPS.APPEND_MEPSTABLE.MPCDATA,
MEPS.APPEND_MEPSTABLE.IPBEGYR,
MEPS.APPEND_MEPSTABLE.IPBEGMM,
MEPS.APPEND_MEPSTABLE.IPBEGDD,
MEPS.APPEND_MEPSTABLE.IPENDYR,
MEPS.APPEND_MEPSTABLE.IPENDMM,
MEPS.APPEND_MEPSTABLE.IPENDDD,
MEPS.APPEND_MEPSTABLE.NUMNIGHX,
MEPS.APPEND_MEPSTABLE.NUMNIGHT,
MEPS.APPEND_MEPSTABLE.EMERROOM,
MEPS.APPEND_MEPSTABLE.SPECCOND,
MEPS.APPEND_MEPSTABLE.RSNINHOS,
MEPS.APPEND_MEPSTABLE.ANYOPER,