Table of Contents

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 ;

Back to top

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;

Back to top

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

Back to top


The SAS System List

AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 14:01 Tuesday, December 16, 2008 Page 1

HEALTH INSURANCE STATUS AND HEALTHCARE UTILIZATION
MEAN NUMBER OF PRESCRIPTIONS AND REFILLS BY INSURANCE COVERAGE STATUS
The SURVEYMEANS Procedure
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
Statistics
Variable N Sum of
Weights
Mean Std Error
of Mean
RXTOT05 32320 296185002 10.133581 0.195483
Domain Analysis: UNINS05
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
Domain Analysis: INSCOV05
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

HEALTH INSURANCE STATUS AND HEALTHCARE UTILIZATION
MEAN NUMBER OF OFFICE VISITS BY INSURANCE COVERAGE STATUS
The SURVEYMEANS Procedure
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
Statistics
Variable N Sum of
Weights
Mean Std Error
of Mean
OBTOTV05 32320 296185002 5.212462 0.092681
Domain Analysis: UNINS05
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
Domain Analysis: INSCOV05
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

Back to top

AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 14:01 Tuesday, December 16, 2008 Page 3

HEALTH INSURANCE STATUS AND HEALTHCARE UTILIZATION
MEAN NUMBER OF EMERGENCY DEPT. VISITS BY INSURANCE COVERAGE STATUS
The SURVEYMEANS Procedure
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
Statistics
Variable N Sum of
Weights
Mean Std Error
of Mean
ERTOT05 32320 296185002 0.185659 0.004897
Domain Analysis: UNINS05
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
Domain Analysis: INSCOV05
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

Back to top