Table of Contents

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

Page 1 The SAS System 14:01 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.57
user cpu time 0:00.20
system cpu time 0:00.78
Memory 2554k
OS Memory 3292k
Timestamp 12/16/2008 2:01:08 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\M6.SAS
4
5 DESCRIPTION: THIS EXAMPLE SHOWS THE USE OF THE DIABETES CARE SUPPLEMENT
6 (DCS) WEIGHT VARIABLE (DIABW05F) FOR GENERATING ESTIMATES
7 FOR ANALYSES USING QUESTIONS FROM THE DCS.
8
9 TWO DCS VARIABLES ARE USED:
10
11 (1) DSA1C53 (NUMBER OF TIMES TESTED FOR HEMOGLOBIN A1C)
12 (2) DSINSU53 (DIABETES TREATED WITH INSULIN INJECTIONS?)
13
14 INPUT FILES: C:\MEPS\DATA\H97.SAS7BDAT (2005 FULL-YEAR DATA FILE)
15
16 \**************************************************************************/
17
18 FOOTNOTE 'PROGRAM: C:\MEPS\PROG\M6.SAS';
19
20 LIBNAME CDATA 'C:\MEPS\DATA' ;
NOTE: Libref CDATA was successfully assigned as follows:
Engine: V9
Physical Name: C:\MEPS\DATA
21
22 TITLE1 'AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008';
23 TITLE2 'DIABETES CARE SUPPLEMENT ESTIMATES';
24
25 PROC FORMAT;
26 VALUE A1CF
27 -9 = '-9 NOT ASCERTAINED'
28 -8 = '-8 DK'
29 -1 = '-1 INAPPLICABLE'
30 1-20 = '1-20 TIMES'
31 21-50 = '21-50 TIMES'
32 50-HIGH = '51 TIMES OR MORE';
NOTE: Format A1CF has been output.
33 VALUE INSF
34 -9 = '-9 NOT ASCERTAINED'
35 -8 = '-8 DK'
36 -1 = '-1 INAPPLICABLE'
37 1 = '1 YES'
38 0 = '0 NO';
NOTE: Format INSF has been output.
39 RUN;

NOTE: PROCEDURE FORMAT used (Total process time):
real time 0:00.09
user cpu time 0:00.00
system cpu time 0:00.04
Memory 146k
OS Memory 3548k
Timestamp 12/16/2008 2:01:08 PM

40
41 *READ 2005 CONSOLIDATED FULL YEAR FILE AND KEEP SELECTED DIABETES VARIABLES;

Back to top

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

42 DATA FY2005;
43 SET CDATA.H97 (KEEP= DUPERSID DIABW05F VARSTR VARPSU
44 DSA1C53 DSINSU53);
45 RUN;

NOTE: There were 33961 observations read from the data set CDATA.H97.
NOTE: The data set WORK.FY2005 has 33961 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 0:01.92
user cpu time 0:00.01
system cpu time 0:00.17
Memory 580k
OS Memory 4316k
Timestamp 12/16/2008 2:01:10 PM

46
47 PROC SURVEYFREQ DATA= FY2005 ;
48 STRATA VARSTR;
49 CLUSTER VARPSU;
50 WEIGHT DIABW05F;
51 TABLES DSA1C53 DSINSU53 ;
52 FORMAT DSA1C53 A1CF. DSINSU53 INSF. ;
53 RUN;

NOTE: 32307 observations were omitted due to nonpositive weights.
NOTE: There is at least one stratum that contains only a single cluster for the table of DSA1C53. Single-cluster strata are not
included in the variance estimates.
NOTE: There is at least one stratum that contains only a single cluster for the table of DSINSU53. Single-cluster strata are not
included in the variance estimates.
NOTE: The PROCEDURE SURVEYFREQ printed page 1.
NOTE: PROCEDURE SURVEYFREQ used (Total process time):
real time 0:00.16
user cpu time 0:00.06
system cpu time 0:00.04
Memory 3793k
OS Memory 8188k
Timestamp 12/16/2008 2:01:10 PM

54
55
56

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 0:04.19
user cpu time 0:00.32
system cpu time 0:01.20
Memory 6681k
OS Memory 8188k
Timestamp 12/16/2008 2:01:10 PM

Back to top


The SAS System List

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

DIABETES CARE SUPPLEMENT ESTIMATES
The SURVEYFREQ Procedure
Data Summary
Number of Strata 200
Number of Clusters 384
Number of Observations 33961
Number of Observations Used 1654
Number of Obs with Nonpositive Weights 32307
Sum of Weights 16934272.2
DCS: TIMES TESTED FOR A-ONE-C - 2005
DSA1C53 Frequency Weighted
Frequency
Std Dev of
Wgt Freq
Percent Std Err of
Percent
-9 NOT ASCERTAINED 68 570685 74212 3.3700 0.4120
-8 DK 214 2099803 166302 12.3997 0.9286
0 88 915366 112774 5.4054 0.6301
1-20 TIMES 1183 12481083 434504 73.7031 1.2143
21-50 TIMES 15 153183 50317 0.9046 0.2960
51 TIMES OR MORE 86 714152 82177 4.2172 0.4548
Total 1654 16934272 536203 100.000  
DCS: TREAT DIABETES W/INSULIN INJECTIONS
DSA1C53 Frequency Weighted
Frequency
Std Dev of
Wgt Freq
Percent Std Err of
Percent
-9 NOT ASCERTAINED 12 153763 45982 0.9080 0.2717
1 YES 427 4167239 245560 24.6083 1.2382
2 1215 12613270 459769 74.4837 1.2734
Total 1654 16934272 536203 100.000  

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

Back to top