Table of Contents

1. The SAS System Log
2. The SAS System List

Page 1 The SAS System Log 13:58 Tuesday, December 16, 2008

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS1M0)
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC/AHRQ/NIH/HRSA, Site 0070021279.
NOTE: This session is executing on the XP_PRO platform.

NOTE: SAS initialization used:
real time 0:01.65
user cpu time 0:00.15
system cpu time 0:00.74
Memory 2554k
OS Memory 3292k
Timestamp 12/16/2008 1:58:27 PM

NOTE: AUTOEXEC processing beginning; file is C:\PROGRA~1\SAS92\SASFOU~1\9.2\autoexec.sas.

NOTE: AUTOEXEC processing completed.

1 /***************************************************************************\
2
3 PROGRAM: C:\MEPS\PROG\E8.SAS
4
5 DESCRIPTION: THIS PROGRAM GENERATES TWO SETS OF EXPENDITURE DATA FOR 2005
6 INPATIENT STAYS, SIMILAR TO THOSE REPORTED IN MEPS STAT BRIEF
7 #164 (FIGURES 1 AND 5). STAT BRIEF #164 USED 2004 MEPS DATA.
8 THIS PROGRAM USES 2005 MEPS DATA.
9
10 ESTIMATES COMPARABLE TO FIGURE 1 ARE BY EVENT TYPE AND BY
11 SOURCE OF PAYMENT FOR INPATIENT (IP) STAY EXPENSES.
12
13 EVENT TYPE DEFINITIONS:
14
15 AMBULATORY: OFFICE-BASED + OUTPATIENT + EMERGENCY DEPARTMENT
16 HOSPITAL: HOSPITAL INPATIENT
17 PRESCRIBED MEDICINES: PMED (RX)
18 OTHER: TOTAL EXPENDITURES - (AMBULATORY + HOSPITAL + PMED)
19
20 NOTES: (1) EXPENSES INCLUDE BOTH FACILITY AND PHYSICIAN EXPENSES.
21 (2) PRIVATE INCLUDES TRICARE, BUT NOT 'OTHER PRIVATE'.
22
23 TOTAL HEALTH CARE EXP: $963,882,049,581
24 (SB: $963.9 BILLION)
25
26 EVENT TYPES: 2005 DATA 2004 DATA (SB#164)
27
28 PMED: 20.8% 19.8%
29 HOSPITAL: 30.9% 31.4%
30 AMBULATORY: 34.7% 35.6%
31 OTHER: 13.5% 13.2%
32
33 FOR HOSPITAL EXPENSES (SB #164)
34 FIRST BULLET IN HIGHLIGHTS STATES,
35 "EXPENSES FOR HOSPITAL INPATIENT STAYS
36 ACCOUNTED FOR NEARLY ONE-THIRD OF ALL
37 HEALTH CARE EXPENSES..." [30.9% IN 2005]
38
39 IP SOPs: 2005 DATA 2004 DATA (SB#164)
40
41 PRIVATE: 41.1% 43.7%
42 MEDICARE: 37.7% 38.8%
43 MEDICAID: 10.6% 9.6%
44 OUT-OF-POCKET: 3.8% 2.2%
45 OTHER: 6.9% 5.7%
46
47 FIGURE 5: IP EXPENSES PER STAY AND PER DIEM
48
49 PER STAY 2005 DATA 2004 DATA (SB#164)
50
51 W/ SURG $15,160 $14,729
52 W/0 SURG $ 8,439 $ 7,678
53
54 PER DIEM
55
56 W/ SURG $ 5,226 $ 5,059


Page 2 The SAS System 13:58 Tuesday, December 16, 2008

Back to top

57 W/O SURG $ 2,173 $ 1,954
58
59 NOTE: FOR THE SMALL NUMBER OF ZERO NIGHT STAYS, LENGTH
60 OF STAY WAS CONSIDERED TO BE ONE.
61
62 INPUT FILES: (1) C:\MEPS\DATA\H97.SAS7BDAT (2005 FULL-YEAR FILE)
63 (2) C:\MEPS\DATA\H94D.SAS7BDAT (2005 HOSP. IP STAYS)
64
65 \******************************************************************/
66
67 FOOTNOTE 'PROGRAM: C:\MEPS\PROG\E8.SAS';
68
69 LIBNAME CDATA 'C:\MEPS\DATA';
NOTE: Libref CDATA was successfully assigned as follows:
Engine: V9
Physical Name: C:\MEPS\DATA
70
71 TITLE1 'AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008';
72
73 PROC FORMAT;
74
74 ! VALUE SURGF
75 1 = 'SURGERY'
76 OTHER = 'OTHER';
NOTE: Format SURGF has been output.
77 RUN;

NOTE: PROCEDURE FORMAT used (Total process time):
real time 0:00.09
user cpu time 0:00.01
system cpu time 0:00.03
Memory 145k
OS Memory 3548k
Timestamp 12/16/2008 1:58:27 PM

78
79 /* READ IN DATA FROM 2005 CONSOLIDATED DATA FILE (HC-097) */
80
81 DATA PUF97 (KEEP= TOTAL PRESCRIBED_MEDICINES HOSPITAL_INPATIENT
82 AMBULATORY_CARE OTHER
83 IP_TOTAL IP_PRIVATE_INS IP_MEDICARE IP_MEDICAID
84 IP_OUT_OF_POCKET IP_OTHER VARSTR VARPSU PERWT05F);
85 SET CDATA.H97 (KEEP= TOTEXP05 RXEXP05 OBVEXP05 OPDEXP05 OPFEXP05
86 ERDEXP05 ERFEXP05 IPDEXP05 IPFEXP05
87 IPDPRV05 IPFPRV05 IPDTRI05 IPFTRI05
88 IPDMCR05 IPFMCR05 IPDMCD05 IPFMCD05
89 IPDSLF05 IPFSLF05
90 VARSTR VARPSU PERWT05F);
91
92 TOTAL = TOTEXP05;
93 PRESCRIBED_MEDICINES = RXEXP05;
94 HOSPITAL_INPATIENT = (IPDEXP05 + IPFEXP05);
95 AMBULATORY_CARE = (OBVEXP05 + OPDEXP05 + OPFEXP05 + ERDEXP05 + ERFEXP05);
96 OTHER = TOTAL - (PRESCRIBED_MEDICINES + HOSPITAL_INPATIENT + AMBULATORY_CARE);
97
98 IP_TOTAL = HOSPITAL_INPATIENT;
99 IP_PRIVATE_INS = (IPDPRV05 + IPFPRV05) + (IPDTRI05 + IPFTRI05);
100 IP_MEDICARE = IPDMCR05 + IPFMCR05;
101 IP_MEDICAID = IPDMCD05 + IPFMCD05;
102 IP_OUT_OF_POCKET = IPDSLF05 + IPFSLF05;
103 IP_OTHER = IP_TOTAL - (IP_PRIVATE_INS+IP_MEDICARE+IP_MEDICAID+IP_OUT_OF_POCKET);
104 RUN;

NOTE: There were 33961 observations read from the data set CDATA.H97.
NOTE: The data set WORK.PUF97 has 33961 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0:01.83
user cpu time 0:00.00
system cpu time 0:00.23
Memory 653k
OS Memory 4316k
Timestamp 12/16/2008 1:58:29 PM

105
106 TITLE2 'HEALTHCARE EXPENSES, 2005 (CF. MEPS STAT BRIEF #164, 2004 DATA)';


Page 3 The SAS System 13:58 Tuesday, December 16, 2008

Back to top

107 TITLE3 'FIGURE 1: DISTRIBUTION BY EVENT TYPE';
108
109 PROC SURVEYMEANS DATA= PUF97 MEAN STDERR SUM STD;
110 STRATUM VARSTR;
111 CLUSTER VARPSU;
112 WEIGHT PERWT05F;
113 VAR PRESCRIBED_MEDICINES HOSPITAL_INPATIENT AMBULATORY_CARE OTHER TOTAL;
114 RATIO PRESCRIBED_MEDICINES HOSPITAL_INPATIENT AMBULATORY_CARE OTHER / TOTAL;
115 RUN;

NOTE: Due to nonpositive weights, 1641 observation(s) were deleted.
NOTE: The PROCEDURE SURVEYMEANS printed page 1.
NOTE: PROCEDURE SURVEYMEANS used (Total process time):
real time 0:00.63
user cpu time 0:00.56
system cpu time 0:00.07
Memory 10801k
OS Memory 14916k
Timestamp 12/16/2008 1:58:30 PM

116
117 TITLE3 'FIGURE 1: DISTRIBUTION OF INPATIENT (IP) EXPENSES BY SOURCE OF PAYMENT';
118
119 PROC SURVEYMEANS DATA= PUF97 MEAN STDERR SUM STD;
120 STRATUM VARSTR;
121 CLUSTER VARPSU;
122 WEIGHT PERWT05F;
123 VAR IP_PRIVATE_INS IP_MEDICARE IP_MEDICAID IP_OUT_OF_POCKET IP_OTHER IP_TOTAL;
124 RATIO IP_PRIVATE_INS IP_MEDICARE IP_MEDICAID IP_OUT_OF_POCKET IP_OTHER / IP_TOTAL;
125 RUN;

NOTE: Due to nonpositive weights, 1641 observation(s) were deleted.
NOTE: The PROCEDURE SURVEYMEANS printed page 2.
NOTE: PROCEDURE SURVEYMEANS used (Total process time):
real time 0:00.62
user cpu time 0:00.59
system cpu time 0:00.00
Memory 9916k
OS Memory 15700k
Timestamp 12/16/2008 1:58:30 PM

126
127 /* READ IN DATA FROM 2005 HOSPITAL INPATIENT STAYS DATA FILE (HC-094D) */
128
129 DATA IP2005;
130 SET CDATA.H94D (KEEP= DUPERSID EVNTIDX RSNINHOS IPXP05X NUMNIGHX
131 PERWT05F VARSTR VARPSU);
132 IF NUMNIGHX = 0
133 THEN NUMNIGHX = 1;
134 PERDIEM = ROUND(IPXP05X/NUMNIGHX);
135 RUN;

NOTE: There were 3341 observations read from the data set CDATA.H94D.
NOTE: The data set WORK.IP2005 has 3341 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0:00.07
user cpu time 0:00.01
system cpu time 0:00.01
Memory 326k
OS Memory 8180k
Timestamp 12/16/2008 1:58:30 PM

136
137 TITLE3 'FIGURE 5: AVERAGE IP EXPENSES PER STAY WITH AND WITHOUT SURGERY';
138
139 PROC SURVEYMEANS DATA= IP2005 MEAN STDERR;
140 STRATUM VARSTR;
141 CLUSTER VARPSU;
142 WEIGHT PERWT05F;
143 VAR IPXP05X;
144 DOMAIN RSNINHOS ;
145 FORMAT RSNINHOS SURGF. ;
146 RUN;

Page 4 The SAS System 13:58 Tuesday, December 16, 2008

Back to top

NOTE: Due to nonpositive weights, 129 observation(s) were deleted.
NOTE: Only one cluster in a stratum for variable(s) IPXP05X. The estimate of variance for IPXP05X will omit this stratum.
NOTE: The PROCEDURE SURVEYMEANS printed page 3.
NOTE: PROCEDURE SURVEYMEANS used (Total process time):
real time 0:00.06
user cpu time 0:00.04
system cpu time 0:00.01
Memory 3119k
OS Memory 8980k
Timestamp 12/16/2008 1:58:30 PM

147
148 TITLE3 'FIGURE 5: AVERAGE IP EXPENSES PER DIEM WITH AND WITHOUT SURGERY';
149
150 PROC SURVEYMEANS DATA= IP2005 MEAN STDERR;
151 STRATUM VARSTR;
152 CLUSTER VARPSU;
153 WEIGHT PERWT05F;
154 VAR PERDIEM;
155 DOMAIN RSNINHOS ;
156 FORMAT RSNINHOS SURGF. ;
157 RUN;

NOTE: Due to nonpositive weights, 129 observation(s) were deleted.
NOTE: Only one cluster in a stratum for variable(s) PERDIEM. The estimate of variance for PERDIEM will omit this stratum.
NOTE: The PROCEDURE SURVEYMEANS printed page 4.
NOTE: PROCEDURE SURVEYMEANS used (Total process time):
real time 0:00.06
user cpu time 0:00.04
system cpu time 0:00.01
Memory 3108k
OS Memory 8980k
Timestamp 12/16/2008 1:58:30 PM

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 0:05.47
user cpu time 0:01.45F
system cpu time 0:01.34
Memory 13696k
OS Memory 15700k
Timestamp 12/16/2008 1:58:30 PM

Back to top

The SAS System List

AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 13:58 Tuesday, December 16, 2008 Page 1
HEALTHCARE EXPENSES, 2005 (CF. MEPS STAT BRIEF #164, 2004 DATA)
FIGURE 1: DISTRIBUTION BY EVENT TYPE

Back to top

PROGRAM: C:\MEPS\PROG\E8.SAS
AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 13:58 Tuesday, December 16, 2008 Page 2
HEALTHCARE EXPENSES, 2005 (CF. MEPS STAT BRIEF #164, 2004 DATA)

FIGURE 1: DISTRIBUTION OF INPATIENT (IP) EXPENSES BY SOURCE OF PAYMENT

Back to top

PROGRAM: C:\MEPS\PROG\E8.SAS
AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 13:58 Tuesday, December 16, 2008 Page 3
HEALTHCARE EXPENSES, 2005 (CF. MEPS STAT BRIEF #164, 2004 DATA)

FIGURE 5: AVERAGE IP EXPENSES PER STAY WITH AND WITHOUT SURGERY

Back to top

PROGRAM: C:\MEPS\PROG\E8.SAS
AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 13:58 Tuesday, December 16, 2008 Page 4
HEALTHCARE EXPENSES, 2005 (CF. MEPS STAT BRIEF #164, 2004 DATA)

FIGURE 5: AVERAGE IP EXPENSES PER DIEM WITH AND WITHOUT SURGERY

PROGRAM: C:\MEPS\PROG\E8.SAS

Back to top