1 The SAS System 13:27 Saturday, November 20, 2004
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
Licensed to AGENCY FOR HEALTHCARE RESEARCH & QUALITY, Site 0040776001.
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX08.
NOTE: AUTOEXEC processing beginning; file is C:\PROGRA~1\SASINS~1\SAS\V8\autoexec.sas.
1 ** C:\PROGRAM FILES\SAS INSTITUTE\SAS\V8\AUTOEXEC.SAS ;
2
3 OPTIONS LS= 132 PS= 70 MERGENOBY=ERROR MSGLEVEL=i;
NOTE: AUTOEXEC processing completed.
1 /****************************************************************\
2
3 PROGRAM: C:\MEPS\PROG\EXAMPLE_E5.SAS
4
5 DESCRIPTION: THIS EXAMPLE SHOWS HOW TO COMPUTE EVENT-LEVEL
6 ESTIMATES.
7 IN THIS PROGRAM
8 (1) THE 2001 MEPS INPATIENT HOSPITAL STAYS FILE IS
9 USED TO COMPUTE MEAN FACILITY EXPENSE PER
10 STAY.
11 (2) THE 2001 MEPS OFFICE-BASED MEDICAL PROVIDER
12 VISITS FILE IS USED TO COMPUTE MEAN
13 EXPENSE PER OFFICE VISIT TO A MEDICAL
14 PROVIDER.
15
16 INPUT FILE: (1) C:\MEPS\DATA\H59D.SAS7BDAT
17 -- 2001 HOSPITAL STAYS FILE
18 (2) C:\MEPS\DATA\H59G.SAS7BDAT
19 -- 2001 OFFICE-BASED VISITS FILE
20
21 \****************************************************************/
22
23 LIBNAME CMEPS V8 'C:\MEPS\DATA' ;
NOTE: Libref CMEPS was successfully assigned as follows:
Engine: V8
Physical Name: C:\MEPS\DATA
24
25 FOOTNOTE 'PROGRAM: C:\MEPS\PROG\EXAMPLE_E5.SAS';
26
27 TITLE1 'AHRQ MEPS DATA USERS WORKSHOP (ESTIMATION) -- NOV/DEC 2004';
28 TITLE2 'COMPUTING EVENT-LEVEL ESTIMATES';
29 TITLE3 ' ';
30
31 /***** THESE DATA STEPS READS IN THE REQUIRED VARIABLES FROM THE *****/
32 /***** FULL-YEAR FILES. *****/
33
34 /***** INPATIENT HOSPITAL STAYS FILE. *****/
35 /***** *IPFXP01X* IS THE TOTAL EXPENSE VARIABLE. *****/
36
37 TITLE4 'MEAN FACILITY EXPENSE PER INPATIENT STAY' ;
38
39 DATA IP2001;
40 SET CMEPS.H59D (KEEP= DUPERSID IPFXP01X PERWT01F VARSTR01
41 VARPSU01);
42 LABEL IPFXP01X = 'TOTAL HOSP. STAY EXPENSES';
43 RUN;
NOTE: There were 3428 observations read from the data set CMEPS.H59D.
NOTE: The data set WORK.IP2001 has 3428 observations and 5 variables.
2 The SAS System 13:27 Saturday, November 20, 2004
44
45 PROC SURVEYMEANS DATA= IP2001 NOBS SUMWGT MEAN STDERR CLM;
46 VAR IPFXP01X;
47 STRATA VARSTR01;
48 CLUSTER VARPSU01;
49 WEIGHT PERWT01F;
50 RUN;
NOTE: Due to nonpositive weights, 100 observation(s) were deleted.
NOTE: Only one cluster in a stratum for variable(s) IPFXP01X. The variance of IPFXP01X in that stratum is estimated by zero.
NOTE: There were 3428 observations read from the data set WORK.IP2001.
NOTE: The PROCEDURE SURVEYMEANS printed page 1.
51
52 /***** OFFICE BASED MEDICAL PROVIDER VISITS FILE. *****/
53 /***** *OBXP01X* IS THE TOTAL EXPENSE VARIABLE. *****/
54
55 TITLE4 'MEAN EXPENSE PER OFFICE VISIT TO A MEDICAL PROVIDER' ;
56
57 DATA OB2001;
58 SET CMEPS.H59G (KEEP= DUPERSID OBXP01X PERWT01F VARSTR01
59 VARPSU01);
60 LABEL OBXP01X = 'TOTAL OFFICE VISIT EXPENSES';
61 RUN;
NOTE: There were 147490 observations read from the data set CMEPS.H59G.
NOTE: The data set WORK.OB2001 has 147490 observations and 5 variables.
62
63 PROC SURVEYMEANS DATA= OB2001 NOBS SUMWGT MEAN STDERR CLM;
64 VAR OBXP01X;
65 STRATA VARSTR01;
66 CLUSTER VARPSU01;
67 WEIGHT PERWT01F;
68 RUN;
NOTE: Due to nonpositive weights, 2980 observation(s) were deleted.
NOTE: There were 147490 observations read from the data set WORK.OB2001.
NOTE: The PROCEDURE SURVEYMEANS printed page 2.
69
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
AHRQ MEPS DATA USERS WORKSHOP (ESTIMATION) -- NOV/DEC 2004 1
COMPUTING EVENT-LEVEL ESTIMATES 13:27 Saturday, November 20, 2004
MEAN FACILITY EXPENSE PER INPATIENT STAY
The SURVEYMEANS Procedure
Data Summary
Number of Strata 145
Number of Clusters 514
Number of Observations 3428
Number of Observations Used 3328
Number of Obs with Nonpositive Weights 100
Sum of Weights 30172114.6
Statistics
Sum of Std Error Lower 95% Upper 95%
Variable Label N Weights Mean of Mean CL for Mean CL for Mean
------------------------------------------------------------------------------------------------------------------------------
IPFXP01X TOTAL HOSP. STAY EXPENSES 3328 30172115 6628.807015 263.362555 6110.917996 7146.696034
------------------------------------------------------------------------------------------------------------------------------
PROGRAM: C:\MEPS\PROG\EXAMPLE_E5.SAS
AHRQ MEPS DATA USERS WORKSHOP (ESTIMATION) -- NOV/DEC 2004 2
COMPUTING EVENT-LEVEL ESTIMATES 13:27 Saturday, November 20, 2004
MEAN EXPENSE PER OFFICE VISIT TO A MEDICAL PROVIDER
The SURVEYMEANS Procedure
Data Summary
Number of Strata 145
Number of Clusters 557
Number of Observations 147490
Number of Observations Used 144510
Number of Obs with Nonpositive Weights 2980
Sum of Weights 1372644966
Statistics
Sum of Std Error Lower 95% Upper 95%
Variable Label N Weights Mean of Mean CL for Mean CL for Mean
--------------------------------------------------------------------------------------------------------------------------------
OBXP01X TOTAL OFFICE VISIT EXPENSES 144510 1372644966 114.168495 1.677911 110.870160 117.466830
--------------------------------------------------------------------------------------------------------------------------------
PROGRAM: C:\MEPS\PROG\EXAMPLE_E5.SAS