Table of Contents

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

Page 1 The SAS System Log 14:00 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.77
user cpu time 0:00.21
system cpu time 0:00.93
Memory 2554k
OS Memory 3292k
Timestamp 12/16/2008 2:00:10 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\M2.SAS
4
5 DESCRIPTION: THIS EXAMPLE SHOWS THE NEED FOR USING THE
6 STRATUM AND PSU VARIABLES WHEN ANALYZING MEPS
7 DATA FOR NATIONAL ESTIMATES. THAT IS, TAKING
8 THE MEPS COMPLEX DESIGN PROPERTIES INTO
9 ACCOUNT.
10
11 INPUT FILE: C:\MEPS\DATA\H97.SAS7BDAT (2005 FULL-YEAR DATA FILE)
12
13 \********************************************************************/
14
15 FOOTNOTE 'PROGRAM: C:\MEPS\PROG\M2.SAS';
16
17 LIBNAME CDATA 'C:\MEPS\DATA' ;
NOTE: Libref CDATA was successfully assigned as follows:
Engine: V9
Physical Name: C:\MEPS\DATA
18
19 TITLE1 'AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008';
20 TITLE2 'EFFECT OF STRATA AND PSU VARIABLES ON COMPUTING';
21 TITLE3 'STANDARD ERRORS FOR TOTAL HEALTH-CARE EXPENDITURES';
22
23 * READ 2005 CONSOLIDATED FULL YEAR FILE;
24 DATA PUF97 ;
25 SET CDATA.H97 (KEEP= TOTEXP05 VARPSU VARSTR PERWT05F);
26 RUN;

NOTE: There were 33961 observations read from the data set CDATA.H97.
NOTE: The data set WORK.PUF97 has 33961 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0:01.66
user cpu time 0:00.01
system cpu time 0:00.21
Memory 586k
OS Memory 4316k
Timestamp 12/16/2008 2:00:12 PM

27
28 /***** ASSUME SIMPLE RANDOM SAMPLE *****/
29
30 PROC SURVEYMEANS DATA= PUF97 NOBS SUM ;
31 WEIGHT PERWT05F ;
32 VAR TOTEXP05 ;
33 ODS OUTPUT STATISTICS= SRSTOT (KEEP= SUM STDDEV) ;
34 RUN;

NOTE: Due to nonpositive weights, 1641 observation(s) were deleted.
NOTE: The data set WORK.SRSTOT has 1 observations and 2 variables.
NOTE: The PROCEDURE SURVEYMEANS printed page 1.
NOTE: PROCEDURE SURVEYMEANS used (Total process time):
real time 0:00.35
user cpu time 0:00.03

Page 2 The SAS System 14:00 Tuesday, December 16, 2008

Back to top

system cpu time 0:00.09
Memory 2781k
OS Memory 6680k
Timestamp 12/16/2008 2:00:12 PM

35
36 /***** ACCOUNT FOR MEPS COMPLEX SAMPLE DESIGN *****/
37
38 PROC SURVEYMEANS DATA= PUF97 NOBS SUM ;
39 STRATUM VARSTR ;
40 CLUSTER VARPSU ;
41 WEIGHT PERWT05F ;
42 VAR TOTEXP05 ;
43 ODS OUTPUT STATISTICS= COMPTOT (KEEP= SUM STDDEV);
44 RUN;

NOTE: Due to nonpositive weights, 1641 observation(s) were deleted.
NOTE: The data set WORK.COMPTOT has 1 observations and 2 variables.
NOTE: The PROCEDURE SURVEYMEANS printed page 2.
NOTE: PROCEDURE SURVEYMEANS used (Total process time):
real time 0:00.09
user cpu time 0:00.06
system cpu time 0:00.03
Memory 2371k
OS Memory 7704k
Timestamp 12/16/2008 2:00:12 PM

45
46 DATA _NULL_;
47 SET SRSTOT;
48 PUT 'SRS TOTAL IS ' SUM DOLLAR22.2 ;
49 PUT 'SRS SE TOTAL IS ' STDDEV DOLLAR22.2 ;
50 RUN;

SRS TOTAL IS $1,023,763,462,949.70
SRS SE TOTAL IS $23,916,914,371.13
NOTE: There were 1 observations read from the data set WORK.SRSTOT.
NOTE: DATA statement used (Total process time):
real time 0:00.01
user cpu time 0:00.00
system cpu time 0:00.01
Memory 169k
OS Memory 6904k
Timestamp 12/16/2008 2:00:12 PM

51
52 DATA _NULL_;
53 SET COMPTOT;
54 PUT 'COMPLEX DESIGN TOTAL IS ' SUM DOLLAR22.2 ;
55 PUT 'COMPLEX DESIGN TOTAL SE IS ' STDDEV DOLLAR22.2 ;
56 RUN;

COMPLEX DESIGN TOTAL IS $1,023,763,462,949.70
COMPLEX DESIGN TOTAL SE IS $33,630,954,197.88
NOTE: There were 1 observations read from the data set WORK.COMPTOT.
NOTE: DATA statement used (Total process time):
real time 0:00.01
user cpu time 0:00.00
system cpu time 0:00.00
Memory 169k
OS Memory 6904k
Timestamp 12/16/2008 2:00:12 PM

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 0:04.30
user cpu time 0:00.35
system cpu time 0:01.40
Memory 6438k
OS Memory 7704k
Timestamp 12/16/2008 2:00:12 PM

Back to top


The SAS System List

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

EFFECT OF STRATA AND PSU VARIABLES ON COMPUTING

STANDARD ERRORS FOR TOTAL HEALTH-CARE EXPENDITURES

The SURVEYMEANS Procedure
Data Summary
Number of Observations
33961
Number of Observations Used
32320
Number of Obs with Nonpositive Weights
1641
Sum of Weights
296185002

Statistics
Variable Label N Sum Std Dev
TOTEXP05
TOTAL HEALTH CARE EXP 05
32320
1023763500000
23916914371

 

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

Back to top

AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 14:00 Tuesday, December 16, 2008 2

EFFECT OF STRATA AND PSU VARIABLES ON COMPUTING

STANDARD ERRORS FOR TOTAL HEALTH-CARE EXPENDITURES

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 Label N Sum Std Dev
TOTEXP05
TOTAL HEALTH CARE EXP 05
32320
1.0237635E12
33630954198

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

Back to top