1. The SAS System Log
2. The SAS System List
Page 1 The SAS System Log 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.83
user cpu time 0:00.20
system cpu time 0:00.71
Memory 2554k
OS Memory 3292k
Timestamp 12/16/2008 2:01:55 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\M9.SAS
4
5 DESCRIPTION: THIS EXAMPLE USES THE 2005 FULL-YEAR FILE TO OUTPUT
6 DESCRIPTIVE STATISTICS SHOWING HEALTH INSURANCE
7 STATUS AND HEALTHCARE UTILIZATION.
8
9 TYPES OF EVENTS USED IN THIS PROGRAM:
10
11 PRESCRIBED MEDICINE USE (RXTOT05)
12 OFFICE-BASED VISITS (OBTOT05)
13 EMERGENCY DEPT. VISITS (ERTOT05)
14
15 INPUT FILE: C:\MEPS\DATA\H97.SAS7BDAT (2005 FULL-YEAR DATA FILE)
16
17 \********************************************************************/
18
19 FOOTNOTE 'PROGRAM: C:\MEPS\PROG\M9.SAS';
20
21 LIBNAME CDATA 'C:\MEPS\DATA' ;
NOTE: Libref CDATA was successfully assigned as follows:
Engine: V9
Physical Name: C:\MEPS\DATA
22
23 TITLE1 'AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008';
24 TITLE2 'HEALTH INSURANCE STATUS AND HEALTHCARE UTILIZATION';
25
26 PROC FORMAT;
27 VALUE YESNO
28 -9 = '-9 NOT ASCERTAINED'
29 -8 = '-8 DK'
30 -7 = '-7 REFUSED'
31 -1 = '-1 INAPPLICABLE'
32 1 = 'UNINSURED'
33 2 = 'INSURED';
NOTE: Format YESNO has been output.
34 VALUE INSCOV
35 1 = 'ANY PRIVATE'
36 2 = 'PUBLIC ONLY'
37 3 = 'UNINSURED';
NOTE: Format INSCOV has been output.
38 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 2:01:55 PM
39
40 *READ 2005 CONSOLIDATED FULL YEAR FILE;
41 DATA PUF97 ;
Page 2 The SAS System 14:01 Tuesday, December 16, 2008
42 SET CDATA.H97 (KEEP= UNINS05 INSCOV05 RXTOT05 OBTOTV05 ERTOT05
43 VARPSU VARSTR PERWT05F);
44 LABEL OBTOTV05= ' '
45 RXTOT05 = ' '
46 ERTOT05 = ' '
47 UNINS05 = ' '
48 INSCOV05= ' ';
49 RUN;
NOTE: There were 33961 observations read from the data set CDATA.H97.
NOTE: The data set WORK.PUF97 has 33961 observations and 8 variables.
NOTE: DATA statement used (Total process time):
real time 0:01.49
user cpu time 0:00.01
system cpu time 0:00.20
Memory 582k
OS Memory 4316k
Timestamp 12/16/2008 2:01:57 PM
50
51 TITLE3 'MEAN NUMBER OF PRESCRIPTIONS AND REFILLS BY INSURANCE COVERAGE
STATUS';
52
53 PROC SURVEYMEANS DATA= PUF97 NOBS SUMWGT MEAN STDERR;
54 VAR RXTOT05;
55 STRATA VARSTR;
56 CLUSTER VARPSU;
57 WEIGHT PERWT05F;
58 DOMAIN UNINS05 INSCOV05;
59 FORMAT UNINS05 YESNO. INSCOV05 INSCOV. ;
60 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.33
user cpu time 0:00.23
system cpu time 0:00.06
Memory 5048k
OS Memory 10004k
Timestamp 12/16/2008 2:01:57 PM
61
62 TITLE3 'MEAN NUMBER OF OFFICE VISITS BY INSURANCE COVERAGE STATUS';
63
64 PROC SURVEYMEANS DATA= PUF97 NOBS SUMWGT MEAN STDERR;
65 VAR OBTOTV05;
66 STRATA VARSTR;
67 CLUSTER VARPSU;
68 WEIGHT PERWT05F;
69 DOMAIN UNINS05 INSCOV05;
70 FORMAT UNINS05 YESNO. INSCOV05 INSCOV. ;
71 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.25
user cpu time 0:00.21
system cpu time 0:00.01
Memory 4126k
OS Memory 10004k
Timestamp 12/16/2008 2:01:57 PM
72
73 TITLE3 'MEAN NUMBER OF EMERGENCY DEPT. VISITS BY INSURANCE COVERAGE
STATUS';
74
75 PROC SURVEYMEANS DATA= PUF97 NOBS SUMWGT MEAN STDERR;
76 VAR ERTOT05;
77 STRATA VARSTR;
78 CLUSTER VARPSU;
79 WEIGHT PERWT05F;
80 DOMAIN UNINS05 INSCOV05;
81 FORMAT UNINS05 YESNO. INSCOV05 INSCOV. ;
82 RUN;
Page 3 The SAS System 14:01 Tuesday, December 16, 2008
NOTE: Due to nonpositive weights, 1641 observation(s) were deleted.
NOTE: The PROCEDURE SURVEYMEANS printed page 3.
NOTE: PROCEDURE SURVEYMEANS used (Total process time):
real time 0:00.25
user cpu time 0:00.21
system cpu time 0:00.01
Memory 4162k
OS Memory 10004k
Timestamp 12/16/2008 2:01:58 PM
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 0:04.66
user cpu time 0:00.95
system cpu time 0:01.14
Memory 7937k
OS Memory 10004k
Timestamp 12/16/2008 2:01:58 PM
AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 14:01 Tuesday, December 16, 2008 Page 1
Data Summary | |
---|---|
Number of Strata | 203 |
Number of Clusters | 452 |
Number of Observations | 33961 |
Number of Observations Used | 32320 |
Number of Obs with Nonpositive Weights | 1641 |
Sum of Weights | 296185002 |
Variable | N | Sum of Weights |
Mean | Std Error of Mean |
---|---|---|---|---|
RXTOT05 | 32320 | 296185002 | 10.133581 | 0.195483 |
UNINS05 | Variable | N | Sum of Weights |
Mean | Std Error of Mean |
---|---|---|---|---|---|
UNINSURED | RXTOT05 | 5097 | 36628862 | 3.596763 | 0.202357 |
INSURED | RXTOT05 | 27223 | 259556140 | 11.056065 | 0.21067 |
INSCOV05 | Variable | N | Sum of Weights |
Mean | Std Error of Mean |
---|---|---|---|---|---|
ANY PRIVATE | RXTOT05 | 18310 | 205264979 | 9.635528 | 0.193126 |
PUBLIC ONLY | RXTOT05 | 8913 | 54291161 | 16.426855 | 0.572099 |
UNINSURED | RXTOT05 | 5097 | 36628862 | 3.596763 | 0.202357 |
PROGRAM: C:\MEPS\PROG\M9.SAS
AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 14:01 Tuesday, December 16, 2008 Page 2
Data Summary | |
---|---|
Number of Strata | 203 |
Number of Clusters | 452 |
Number of Observations | 33961 |
Number of Observations Used | 32320 |
Number of Obs with Nonpositive Weights | 1641 |
Sum of Weights | 296185002 |
Variable | N | Sum of Weights |
Mean | Std Error of Mean |
---|---|---|---|---|
OBTOTV05 | 32320 | 296185002 | 5.212462 | 0.092681 |
UNINS05 | Variable | N | Sum of Weights |
Mean | Std Error of Mean |
---|---|---|---|---|---|
UNINSURED | OBTOTV05 | 5097 | 36628862 | 1.980152 | 0.097496 |
INSURED | OBTOTV05 | 27223 | 259556140 | 5.668609 | 0.099522 |
INSCOV05 | Variable | N | Sum of Weights |
Mean | Std Error of Mean |
---|---|---|---|---|---|
ANY PRIVATE | OBTOTV05 | 18310 | 205264979 | 5.525742 | 0.111378 |
PUBLIC ONLY | OBTOTV05 | 8913 | 54291161 | 6.208763 | 0.205496 |
UNINSURED | OBTOTV05 | 5097 | 36628862 | 1.980152 | 0.097496 |
PROGRAM: C:\MEPS\PROG\M9.SAS
AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 14:01 Tuesday, December 16, 2008 Page 3
Data Summary | |
---|---|
Number of Strata | 203 |
Number of Clusters | 452 |
Number of Observations | 33961 |
Number of Observations Used | 32320 |
Number of Obs with Nonpositive Weights | 1641 |
Sum of Weights | 296185002 |
Variable | N | Sum of Weights |
Mean | Std Error of Mean |
---|---|---|---|---|
ERTOT05 | 32320 | 296185002 | 0.185659 | 0.004897 |
UNINS05 | Variable | N | Sum of Weights |
Mean | Std Error of Mean |
---|---|---|---|---|---|
UNINSURED | ERTOT05 | 5097 | 36628862 | 0.152557 | 0.01058 |
INSURED | ERTOT05 | 27223 | 259556140 | 0.190331 | 0.005193 |
INSCOV05 | Variable | N | Sum of Weights |
Mean | Std Error of Mean |
---|---|---|---|---|---|
ANY PRIVATE | ERTOT05 | 18310 | 205264979 | 0.15677 | 0.004766 |
PUBLIC ONLY | ERTOT05 | 8913 | 54291161 | 0.317219 | 0.013257 |
UNINSURED | ERTOT05 | 5097 | 36628862 | 0.152557 | 0.01058 |
PROGRAM: C:\MEPS\PROG\M9.SAS