Table of Contents

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

Page 1 The SAS System Log 13:59 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.76
user cpu time 0:00.21
system cpu time 0:00.71
Memory 2554k
OS Memory 3292k
Timestamp 12/16/2008 1:59:52 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\M1.SAS
4
5 DESCRIPTION: THIS EXAMPLE SHOWS THE NEED FOR USING WEIGHT
6 VARIABLES WHEN ANALYZING MEPS DATA FOR
7 NATIONAL ESTIMATES.
8
9
10 INPUT FILE: C:\MEPS\DATA\H97.SAS7BDAT (2005 FULL-YEAR DATA FILE)
11
12 \********************************************************************/
13
14 FOOTNOTE 'PROGRAM: C:\MEPS\PROG\M1.SAS';
15
16 LIBNAME CDATA 'C:\MEPS\DATA';
NOTE: Libref CDATA was successfully assigned as follows:
Engine: V9
Physical Name: C:\MEPS\DATA
17
18 TITLE1 'AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008';
19 TITLE2 'EFFECT OF WEIGHT VARIABLE ON RACE/ETHNICITY PERCENTAGE';
20
21 PROC FORMAT;
22
22 ! VALUE RACETHNB
23 0='TOTAL'
24 1 = 'HISPANIC'
25 2 = 'BLACK-NO OTH RACE/NOT HISPANIC'
26 3 = 'ASIAN-NO OTH RACE/NOT HISPANIC'
27 4 = 'OTHER/NOT HISPANIC';
NOTE: Format RACETHNB has been output.
28 RUN;

NOTE: PROCEDURE FORMAT used (Total process time):
real time 0:00.10
user cpu time 0:00.00
system cpu time 0:00.04
Memory 145k
OS Memory 3548k
Timestamp 12/16/2008 1:59:53 PM

29
30 /***** MODIFY RACE/ETHNICITY CATEGORIES *****/
31
32 * READ 2005 CONSOLIDATED FULL YEAR FILE;
33 DATA PUF97 ;
34 SET CDATA.H97 (KEEP= RACETHNX PERWT05F);
35 RUN;

NOTE: There were 33961 observations read from the data set CDATA.H97.
NOTE: The data set WORK.PUF97 has 33961 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0:01.88
user cpu time 0:00.01
Page 2 The SAS System 13:59 Tuesday, December 16, 2008

Back to top

system cpu time 0:00.20
Memory 579k
OS Memory 4316k
Timestamp 12/16/2008 1:59:55 PM

36
37 * CREATE UNWEIGHTED INTERNAL FILE;
38 PROC FREQ DATA=PUF97 NOPRINT;
39 TABLE RACETHNX/ OUT=UNWT(KEEP=RACETHNX PERCENT);
40 FORMAT RACETHNX RACETHNB.;
41 RUN;

NOTE: There were 33961 observations read from the data set WORK.PUF97.
NOTE: The data set WORK.UNWT has 4 observations and 2 variables.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0:00.15
user cpu time 0:00.01
system cpu time 0:00.01
Memory 383k
OS Memory 4572k
Timestamp 12/16/2008 1:59:55 PM

42
43 * CREATE WEIGHTED INTERNAL FILE;
44 PROC FREQ DATA=PUF97 NOPRINT;
45 TABLE RACETHNX/ OUT=WT(KEEP=RACETHNX PERCENT);
46 FORMAT RACETHNX RACETHNB.;
47 WEIGHT PERWT05F;
48 RUN;

NOTE: There were 33961 observations read from the data set WORK.PUF97.
NOTE: The data set WORK.WT has 4 observations and 2 variables.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0:00.03
user cpu time 0:00.00
system cpu time 0:00.03
Memory 226k
OS Memory 4572k
Timestamp 12/16/2008 1:59:55 PM

49
50 * MERGE UNWEIGHTED AND WEIGHTED FILES;
51 DATA PCT;
52 MERGE UNWT WT(RENAME=(PERCENT=WTPCT));
53 BY RACETHNX;
54 FORMAT PERCENT WTPCT 5.2;
55 LABEL PERCENT='UNWEIGHTED PERCENTAGE'
56 WTPCT='WEIGHTED PERCENTAGE';
57 RUN;

NOTE: There were 4 observations read from the data set WORK.UNWT.
NOTE: There were 4 observations read from the data set WORK.WT.
NOTE: The data set WORK.PCT has 4 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0:00.12
user cpu time 0:00.00
system cpu time 0:00.01
Memory 242k
OS Memory 4572k
Timestamp 12/16/2008 1:59:55 PM

58
59 PROC PRINT DATA=PCT NOOBS LABEL;
60 VAR RACETHNX PERCENT WTPCT;
61 RUN;

NOTE: There were 4 observations read from the data set WORK.PCT.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0:00.10
user cpu time 0:00.01
system cpu time 0:00.03
Memory 856k
 

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

Back to top

OS Memory 5084k
Timestamp 12/16/2008 1:59:55 PM

62

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 0:04.70
user cpu time 0:00.29
system cpu time 0:01.24
Memory 3925k
OS Memory 5084k
Timestamp 12/16/2008 1:59:55 PM

Back to top


The SAS System List

AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008 13:59 Tuesday, December 16, 2008 Page 1

EFFECT OF WEIGHT VARIABLE ON RACE/ETHNICITY PERCENTAGE
RACE/ETHNICITY
(EDITED/IMPUTED)
UNWEIGHTED
PERCENTAGE
WEIGHTED
PERCENTAGE
HISPANIC 27.87 14.71
BLACK-NO OTH RACE/NOT HISPANIC 16.48 12.11
ASIAN-NO OTH RACE/NOT HISPANIC 3.73 4.25
OTHER/NOT HISPANIC 51.92 68.92

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

Back to top