Table of Contents

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

Page 1 The SAS System Log 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.70
user cpu time 0:00.21
system cpu time 0:00.74
Memory 2554k
OS Memory 3292k
Timestamp 12/16/2008 2:01:30 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\M8.SAS
4
5 DESCRIPTION: THIS EXAMPLE SHOWS HOW TO COMPUTE PRESCRIBED
6 MEDICINE EXPENDITURES ASSOCIATED WITH CANCER
7 CONDITIONS.
8
9 IN ADDITION TO THE MEDICAL CONDITIONS AND FULL-
10 YEAR FILES, THE PRESCRIBED MEDICINES EVENT FILE AND
11 THE CLNK FILE ARE USED.
12 THE PMED EXPENDITURES ARE SUMMED TO THE EVENT
13 LEVEL.
14 MODIFIED SOURCE OF PAYMENT (SOP) CATEGORIES
15 ARE CREATED AS COLUMN CATEGORIES.
16 ROW CATEGORIES ARE AGE AND RACE/ETHNICITY (FROM
17 THE FULL-YEAR FILE).
18 USE PROC TABULATE TO COMPUTE AND DISPLAY OUTPUT.
19
20 INPUT FILES: (1) C:\MEPS\DATA\H97.SAS7BDAT (2005 FULL-YEAR DATA FILE)
21 (2) C:\MEPS\DATA\H96.SAS7BDAT (2005 MEDICAL CONDITIONS FILE)
22 (3) C:\MEPS\DATA\H94I1.SAS7BDAT (2005 CLNK FILE)
23 THIS FILE LINKS CONDITIONS TO EVENTS
24 (4) C:\MEPS\DATA\H94A.SAS7BDAT (2005 PRESCRIBED MED. FILE)
25
26 \**********************************************************************/
27
28 FOOTNOTE 'PROGRAM: C:\MEPS\PROG\M8.SAS';
29
30 LIBNAME CDATA 'C:\MEPS\DATA';
NOTE: Libref CDATA was successfully assigned as follows:
Engine: V9
Physical Name: C:\MEPS\DATA
31
32 TITLE1 'AHRQ MEPS DATA USERS WORKSHOP -- SEPTEMBER 2008';
33 TITLE2 'PRESCRIBED MEDICINES EXPENDITURES FOR CANCER CONDITIONS';
34
35 PROC FORMAT;
36
36 ! VALUE AGECAT
37 .='TOTAL'
38 1=' < 18'
39 2='18-64'
40 3='65+'
41 ;
NOTE: Format AGECAT has been output.
42
42 ! VALUE RACETHNB
43 1 = 'HISPANIC'
44 2 = 'BLACK'
45 3 = 'ASIAN'
46 4 = 'OTHER';
NOTE: Format RACETHNB has been output.
47 RUN;

NOTE: PROCEDURE FORMAT used (Total process time):

Back to top

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

real time 0:00.11
user cpu time 0:00.00
system cpu time 0:00.06
Memory 145k
OS Memory 3548k
Timestamp 12/16/2008 2:01:30 PM

48
49 /***** USE CCCODEX VALUES TO SELECT PEOPLE WITH CANCER FROM 2005 CONDITION FILE. *****/
50
51 DATA COND05 (KEEP=DUPERSID CONDIDX);
52 SET CDATA.H96 (KEEP=DUPERSID CCCODEX CONDIDX
53 WHERE =('011' <= CCCODEX <= '045' ) );
54 RUN;

NOTE: There were 1411 observations read from the data set CDATA.H96.
WHERE (CCCODEX>='011' and CCCODEX<='045');
NOTE: The data set WORK.COND05 has 1411 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0:00.09
user cpu time 0:00.01
system cpu time 0:00.07
Memory 651k
OS Memory 4344k
Timestamp 12/16/2008 2:01:30 PM

55
56 /***** GET PRESCRIBED MEDICINES EXPENSES FROM 2005 PMED FILE. *****/
57
58
59 PROC SORT DATA= CDATA.H94A (KEEP= DUPERSID RXRECIDX LINKIDX RXSF05X RXMD05X RXPV05X
60 RXMR05X RXXP05X RXNDC)
61 OUT= PMEDACQ;
62 BY LINKIDX RXRECIDX;
63 RUN;

NOTE: There were 317587 observations read from the data set CDATA.H94A.
NOTE: The data set WORK.PMEDACQ has 317587 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0:02.02
user cpu time 0:00.18
system cpu time 0:00.32
Memory 45293k
OS Memory 49296k
Timestamp 12/16/2008 2:01:32 PM

64
65 TITLE3 'ILLUSTRATION OF PMED RECORDS AT THE ACQUISITION LEVEL';
66 TITLE4 'PRE-SELECTED PERSONS';
67
68 PROC PRINT DATA= PMEDACQ LABEL ;
69 VAR DUPERSID LINKIDX RXRECIDX RXXP05X RXSF05X RXPV05X RXMD05X RXMR05X ;
70 LABEL RXXP05X = 'TOTAL EXP'
71 RXSF05X = 'OOP'
72 RXMD05X = 'MEDICAID'
73 RXMR05X = 'MEDICARE'
74 RXPV05X = 'PRIVATE' ;
75 WHERE DUPERSID IN ('32663024', '33634027') ;
76 RUN;

NOTE: There were 74 observations read from the data set WORK.PMEDACQ.
WHERE DUPERSID in ('32663024', '33634027');
NOTE: The PROCEDURE PRINT printed pages 1-2.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0:00.14
user cpu time 0:00.04
system cpu time 0:00.06
Memory 1397k
OS Memory 5376k
Timestamp 12/16/2008 2:01:32 PM

77
78 /***** SUM PMED EXPENSES TO EVENT LEVEL *****/

Back to top

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

79
80 DATA PMEDEVNT (KEEP= DUPERSID EVNTIDX OOP MEDICARE MEDICAID PRIVATE OTHER TOTRX05 RXNDC);
81 SET PMEDACQ;
82 BY LINKIDX RXRECIDX;
83 ARRAY EXPVARS{5} OOP MEDICARE MEDICAID PRIVATE TOTRX05 ;
84 IF FIRST.LINKIDX
85 THEN DO XX = 1 TO 5;
86 EXPVARS{XX} = 0;
87 END;
88 OOP+RXSF05X;
89 MEDICARE+RXMR05X;
90 MEDICAID+RXMD05X;
91 PRIVATE+RXPV05X;
92 TOTRX05+RXXP05X;
93 EVNTIDX=LINKIDX;
94 IF LAST.LINKIDX
95 THEN
96 DO;
97 OTHER= ROUND(TOTRX05-(MEDICARE+MEDICAID+PRIVATE+OOP));
98 OUTPUT;
99 END;
100 LABEL OOP = 'OUT-OF-POCKET'
101 MEDICARE = 'MEDICARE'
102 MEDICAID = 'MEDICAID'
103 PRIVATE = 'PRIVATE'
104 OTHER = 'OTHER'
105 TOTRX05 = 'TOTAL PMED EXPENSES';
106 RUN;

NOTE: There were 317587 observations read from the data set WORK.PMEDACQ.
NOTE: The data set WORK.PMEDEVNT has 127723 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0:00.60
user cpu time 0:00.10
system cpu time 0:00.06
Memory 337k
OS Memory 5092k
Timestamp 12/16/2008 2:01:33 PM

107
108 TITLE3 'ILLUSTRATION OF PMED RECORDS AT THE EVENT LEVEL';
109 TITLE4 'PRE-SELECTED PERSONS';
110
111 PROC PRINT DATA= PMEDEVNT ;
112 VAR DUPERSID EVNTIDX RXNDC TOTRX05 OOP PRIVATE MEDICARE MEDICAID OTHER;
113 WHERE DUPERSID IN ('32663024', '33634027') ;
114 RUN;

NOTE: There were 35 observations read from the data set WORK.PMEDEVNT.
WHERE DUPERSID in ('32663024', '33634027');
NOTE: The PROCEDURE PRINT printed page 3.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0:00.01
user cpu time 0:00.00
system cpu time 0:00.01
Memory 492k
OS Memory 5376k
Timestamp 12/16/2008 2:01:33 PM

115
116 /***** MERGE CONDITIONS FILE TO PRESCRIBED MEDICINE EVENTS THROUGH CLNK FILE *****/
117
118 * READ 2005 CLNK FILE;
119 DATA CLNK;
120 SET CDATA.H94I1 (KEEP=CONDIDX EVNTIDX);
121 RUN;

NOTE: There were 343960 observations read from the data set CDATA.H94I1.
NOTE: The data set WORK.CLNK has 343960 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0:00.09
user cpu time 0:00.04
system cpu time 0:00.03
Memory 290k
OS Memory 5092k

Back to top

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

Timestamp 12/16/2008 2:01:33 PM

122
123 PROC SORT DATA=CLNK;
124 BY CONDIDX;
125 RUN;

NOTE: There were 343960 observations read from the data set WORK.CLNK.
NOTE: The data set WORK.CLNK has 343960 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0:01.33
user cpu time 0:00.15
system cpu time 0:00.06
Memory 21454k
OS Memory 26428k
Timestamp 12/16/2008 2:01:35 PM

126
127 PROC SORT DATA=COND05;
128 BY CONDIDX;
129 RUN;

NOTE: There were 1411 observations read from the data set WORK.COND05.
NOTE: The data set WORK.COND05 has 1411 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0:00.03
user cpu time 0:00.00
system cpu time 0:00.03
Memory 236k
OS Memory 5604k
Timestamp 12/16/2008 2:01:35 PM

130
131 /***** MERGE BY CONDIDX TO GET EVNTIDS ASSOCIATED WITH CANCER EVENTS *****/
132
133 DATA CONDCLNK;
134 MERGE COND05 (IN=A) CLNK (IN=B) ;
135 BY CONDIDX;
136 IF A;
137 RUN;

NOTE: There were 1411 observations read from the data set WORK.COND05.
NOTE: There were 343960 observations read from the data set WORK.CLNK.
NOTE: The data set WORK.CONDCLNK has 8194 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0:00.09
user cpu time 0:00.07
system cpu time 0:00.01
Memory 335k
OS Memory 5604k
Timestamp 12/16/2008 2:01:35 PM

138
139 PROC SORT DATA=PMEDEVNT;
140 BY EVNTIDX;
141 RUN;

NOTE: There were 127723 observations read from the data set WORK.PMEDEVNT.
NOTE: The data set WORK.PMEDEVNT has 127723 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0:00.12
user cpu time 0:00.07
system cpu time 0:00.07
Memory 16369k
OS Memory 21288k
Timestamp 12/16/2008 2:01:35 PM

142
143 PROC SORT DATA=CONDCLNK;
144 BY EVNTIDX;
145 RUN;

Back to top

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

NOTE: There were 8194 observations read from the data set WORK.CONDCLNK.
NOTE: The data set WORK.CONDCLNK has 8194 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0:00.01
user cpu time 0:00.00
system cpu time 0:00.01
Memory 629k
OS Memory 6116k
Timestamp 12/16/2008 2:01:35 PM

146
147 /***** NOW MERGE CONDITIONS FILE WITH EVENTIDS TO PMED EVENT FILE. *****/
148 /***** ONLY KEEP RECORDS THAT MATCH. *****/
149
150 DATA CONDPMED;
151 MERGE CONDCLNK (IN=A) PMEDEVNT(IN=B) ;
152 BY EVNTIDX;
153 IF A AND B;
154
155 RUN;

NOTE: There were 8194 observations read from the data set WORK.CONDCLNK.
NOTE: There were 127723 observations read from the data set WORK.PMEDEVNT.
NOTE: The data set WORK.CONDPMED has 1010 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 0:00.06
user cpu time 0:00.01
system cpu time 0:00.01
Memory 409k
OS Memory 6372k
Timestamp 12/16/2008 2:01:35 PM

156
157 PROC SORT DATA= CONDPMED;
158 BY EVNTIDX CONDIDX;
159 RUN;

NOTE: There were 1010 observations read from the data set WORK.CONDPMED.
NOTE: The data set WORK.CONDPMED has 1010 observations and 10 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0:00.01
user cpu time 0:00.00
system cpu time 0:00.00
Memory 356k
OS Memory 6372k
Timestamp 12/16/2008 2:01:35 PM

160
161 TITLE3 'ILLUSTRATION OF DUPLICATE EVENTS/EXPENDITURES';
162 TITLE4 'PRE-SELECTED PERSONS';
163
164 PROC PRINT DATA= CONDPMED ;
165 VAR DUPERSID CONDIDX EVNTIDX TOTRX05 OOP
166 PRIVATE MEDICARE MEDICAID OTHER;
167 WHERE DUPERSID IN ('32663024', '33634027') ;
168 RUN;

NOTE: There were 29 observations read from the data set WORK.CONDPMED.
WHERE DUPERSID in ('32663024', '33634027');
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0:00.01
user cpu time 0:00.00
system cpu time 0:00.01
Memory 492k
OS Memory 6656k
Timestamp 12/16/2008 2:01:35 PM

169
170 /***** DE-DUPLICATE EXPENDITURES *****/
171
172
173 PROC SORT DATA=CONDPMED NODUPKEY;

Back to top

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

174 BY EVNTIDX;
175 RUN;

NOTE: There were 1010 observations read from the data set WORK.CONDPMED.
NOTE: 33 observations with duplicate key values were deleted.
NOTE: The data set WORK.CONDPMED has 977 observations and 10 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0:00.20
user cpu time 0:00.00
system cpu time 0:00.00
Memory 356k
OS Memory 6372k
Timestamp 12/16/2008 2:01:35 PM

176
177 TITLE3 'ILLUSTRATION OF DE-DUPLICATED EVENTS/EXPENDITURES';
178 TITLE4 'PRE-SELECTED PERSONS';
179
180 PROC PRINT DATA=CONDPMED ;
181 VAR DUPERSID CONDIDX EVNTIDX TOTRX05 OOP
182 PRIVATE MEDICARE MEDICAID OTHER;
183 WHERE DUPERSID IN ('32663024', '33634027') ;
184 RUN;

NOTE: There were 13 observations read from the data set WORK.CONDPMED.
WHERE DUPERSID in ('32663024', '33634027');
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0:00.01
user cpu time 0:00.00
system cpu time 0:00.01
Memory 492k
OS Memory 6656k
Timestamp 12/16/2008 2:01:35 PM

185
186 /***** USE FULL-YEAR FILE TO GET AGE AND RACE/ETHNICITY VARIABLES. *****/
187 /***** SET AGE AS LATEST VALID AGE AND RE-CATEGORIZE RACE/ETHNICITY. *****/
188
189 * READ 2005 CONSOLIDATED FULL YEAR FILE;
190 DATA PUF97 (KEEP= DUPERSID AGECAT RACETHNX PERWT05F);
191 SET CDATA.H97 (KEEP= DUPERSID AGE: RACETHNX RACEX
192 PERWT05F);
193 IF AGE05X>=0 THEN AGE=AGE05X;
194 ELSE IF AGE53X>=0 THEN AGE=AGE53X;
195 ELSE IF AGE42X>=0 THEN AGE=AGE42X;
196 ELSE IF AGE31X>=0 THEN AGE=AGE31X;
197 ELSE AGE=AGE05X;
198 IF 0<= AGE <18 THEN AGECAT=1;
199 ELSE IF 18 <= AGE <65 THEN AGECAT=2;
200 ELSE IF AGE>=65 THEN AGECAT=3;
201 LABEL AGECAT='AGE IN YEARS'
202 RACETHNX='RACE/ENTHNICITY';
203 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:03.07
user cpu time 0:00.07
system cpu time 0:00.12
Memory 537k
OS Memory 6372k
Timestamp 12/16/2008 2:01:38 PM

204
205 /***** MERGE RACE/ETHNICITY VARIABLES ONTO COND/PMED FILE *****/
206
207 DATA TEMP;
208 MERGE CONDPMED(IN=A) PUF97 (IN=B);
209 BY DUPERSID;
210 IF A;
211 OOP=OOP/1000;
212 PRIVATE=PRIVATE/1000;

Back to top

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

213 MEDICARE=MEDICARE/1000;
214 MEDICAID=MEDICAID/1000;
215 OTHER=OTHER/1000;
216 TOTRX05=TOTRX05/1000;
217 RUN;

NOTE: There were 977 observations read from the data set WORK.CONDPMED.
NOTE: There were 33961 observations read from the data set WORK.PUF97.
NOTE: The data set WORK.TEMP has 977 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0:00.03
user cpu time 0:00.00
system cpu time 0:00.01
Memory 444k
OS Memory 6372k
Timestamp 12/16/2008 2:01:38 PM

218
219 TITLE3 'DOLLARS IN THOUSANDS';
220
221 PROC TABULATE DATA=TEMP MISSING FORMAT=COMMA10.0 ;
222 CLASS AGECAT RACETHNX;
223 VAR TOTRX05 OOP PRIVATE MEDICARE MEDICAID OTHER;
224 FORMAT AGECAT AGECAT. RACETHNX RACETHNB.;
225 TABLE ALL='TOTAL' AGECAT RACETHNX ,
226 TOTRX05*SUM OOP*SUM PRIVATE*SUM MEDICARE*SUM
227 MEDICAID*SUM OTHER*SUM
228 /RTS=20 ;
229 WEIGHT PERWT05F;
230 RUN;

NOTE: There were 977 observations read from the data set WORK.TEMP.
NOTE: The PROCEDURE TABULATE printed page 6.
NOTE: PROCEDURE TABULATE used (Total process time):
real time 0:01.06
user cpu time 0:00.01
system cpu time 0:00.10
Memory 6431k
OS Memory 11788k
Timestamp 12/16/2008 2:01:39 PM

231

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 0:11.38
user cpu time 0:01.10
system cpu time 0:02.06
Memory 48180k
OS Memory 49296k
Timestamp 12/16/2008 2:01:39 PM

Back to top

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

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

Back to top

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

PRESCRIBED MEDICINES EXPENDITURES FOR CANCER CONDITIONS
ILLUSTRATION OF PMED RECORDS AT THE ACQUISITION LEVEL
PRE-SELECTED PERSONS

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

Back to top

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

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

Back to top

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

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

Back to top

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

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

Back to top

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

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

Back to top