1 The SAS System 08:37 Tuesday, June 24, 2003
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC/AHRQ, Site 0038838053.
NOTE: This session is executing on the WIN_95 platform.
NOTE: SAS initialization used:
real time 5.00 seconds
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-051I";
4 TITLE2 'Sample SAS Job for Example A';
5
6 LIBNAME IN V8 'C:\DATA';
NOTE: Libref IN was successfully assigned as follows:
Engine: V8
Physical Name: C:\DATA
7
8 ************************************************************************************************
9 * Calculate the expenditures for prescribed medicines associated with medical visits for asthma.
10 ************************************************************************************************;
11
12 PROC FORMAT;
13 VALUE EVENTYPE
14 1 = "1 MVIS"
15 2 = "2 OPAT"
16 3 = "3 EROM"
17 4 = "4 STAZ"
18 5 = "5 DVIS"
19 6 = "6 OMED"
20 7 = "7 HVIS"
21 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
22
23 RUN;
NOTE: PROCEDURE FORMAT used:
real time 0.39 seconds
24
25 *-------------------------------------------------------------------------------------
26 * Get condition records coded as asthma.
27 *-------------------------------------------------------------------------------------;
28 DATA ASCONDS;
29 SET IN.H52 (KEEP=CONDIDX CCCODEX);
30 IF CCCODEX="128";
31
32 RUN;
NOTE: There were 72624 observations read from the data set IN.H52.
NOTE: The data set WORK.ASCONDS has 1156 observations and 2 variables.
NOTE: DATA statement used:
real time 8.50 seconds
2 The SAS System 08:37 Tuesday, June 24, 2003
33
34 *------------------------------------------------------------------------------------
35 * Get the events linked to each of the asthma condition records.
36 *------------------------------------------------------------------------------------;
37 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 1156 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1156 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.17 seconds
38
39 proc print data=asconds (obs=50);
40 title3 "sample print of work.asconds - sorted by condidx";
41 title4 "COND (H52) records where cccodex=128";
42 run;
NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used:
real time 0.71 seconds
43
44 PROC SORT DATA=IN.H51IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 217414 observations read from the data set IN.H51IF1.
NOTE: The data set WORK.CLNK has 217414 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 6.98 seconds
45
46 DATA ASCLNKS;
47 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
48 ASCONDS(IN=INASCOND KEEP=CONDIDX);
49 BY CONDIDX;
50 IF INCLNK & INASCOND;
51 RUN;
NOTE: There were 217414 observations read from the data set WORK.CLNK.
NOTE: There were 1156 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 4737 observations and 3 variables.
NOTE: DATA statement used:
real time 3.39 seconds
52
53 proc print data=asclnks (obs=75);
54 by condidx;
55 id condidx;
56 format eventype eventype.;
57 title3 "sample print of work.asclnks - sorted by condidx";
58 title4 "events linked to asthma condition records";
59 run;
3 The SAS System 08:37 Tuesday, June 24, 2003
NOTE: There were 75 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used:
real time 0.33 seconds
60
61 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 4737 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 4737 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.05 seconds
62
63 proc print data=asclnks (obs=50);
64 format eventype eventype.;
65 title3 "sample print of work.asclnks - sorted by evntidx";
66 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used:
real time 0.04 seconds
67
68 DATA ASCLNKS;
69 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
70 BY EVNTIDX;
71 IF FIRST.EVNTIDX;
72 RUN;
NOTE: There were 4737 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 4712 observations and 2 variables.
NOTE: DATA statement used:
real time 0.05 seconds
73
74 proc print data=asclnks (obs=50);
75 title3 "sample print of unique evntidxs from work.asclnks";
76 format eventype eventype.;
77 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used:
real time 0.05 seconds
78
79 *--------------------------------------------------------------------------------------------
80 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
81 *--------------------------------------------------------------------------------------------;
4 The SAS System 08:37 Tuesday, June 24, 2003
82 DATA MVIS;
83 SET IN.H51G (KEEP=EVNTIDX PERWT00F SEETLKPV);
84 IF PERWT00F > 0 & SEETLKPV NE 2;
85 RUN;
NOTE: There were 102530 observations read from the data set IN.H51G.
NOTE: The data set WORK.MVIS has 98816 observations and 3 variables.
NOTE: DATA statement used:
real time 14.16 seconds
86
87 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 98816 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 98816 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.76 seconds
88
89 *---------------------------------------------------------------------------------------------
90 * Identify MVIS events which were for asthma.
91 *---------------------------------------------------------------------------------------------;
92 DATA ASMVIS;
93 MERGE ASCLNKS (IN=INASCLNK)
94 MVIS (IN=INMVIS KEEP=EVNTIDX);
95 BY EVNTIDX;
96 IF INASCLNK & INMVIS;
97 RUN;
NOTE: There were 4712 observations read from the data set WORK.ASCLNKS.
NOTE: There were 98816 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1509 observations and 2 variables.
NOTE: DATA statement used:
real time 0.44 seconds
98
99 proc print data=asmvis (obs=50);
100 format eventype eventype.;
101 title3 "sample print of work.asmvis";
102 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-051G) events";
103 run;
NOTE: There were 50 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: PROCEDURE PRINT used:
real time 0.05 seconds
104
105 *-------------------------------------------------------------------------------------
106 * Get PMED IDs linked to the MVIS events which were for asthma.
107 *-------------------------------------------------------------------------------------;
108 PROC SORT DATA=IN.H51IF2 OUT=RXLK; BY EVENTIDX; RUN;
5 The SAS System 08:37 Tuesday, June 24, 2003
NOTE: There were 42089 observations read from the data set IN.H51IF2.
NOTE: The data set WORK.RXLK has 42089 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 0.82 seconds
109
110 proc print data=rxlk (obs=140);
111 by eventidx;
112 id eventidx;
113 var linkidx eventype;
114 format eventype eventype.;
115 title3 "sample print of work.rxlk - sorted by eventidx";
116 title4 "Rx+event link file records (HC-51IF2)";
117 run;
NOTE: There were 140 observations read from the data set WORK.RXLK.
NOTE: The PROCEDURE PRINT printed pages 7-11.
NOTE: PROCEDURE PRINT used:
real time 0.05 seconds
118
119 DATA PMEDIDS;
120 MERGE RXLK (IN=INRXLK KEEP=EVENTIDX LINKIDX EVENTYPE RENAME=(EVENTIDX=EVNTIDX))
121 ASMVIS(IN=INASMVIS KEEP=EVNTIDX);
122 BY EVNTIDX;
123 IF INRXLK & INASMVIS;
124 RUN;
NOTE: There were 42089 observations read from the data set WORK.RXLK.
NOTE: There were 1509 observations read from the data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 1439 observations and 3 variables.
NOTE: DATA statement used:
real time 0.22 seconds
125
126 proc print data=pmedids (obs=50);
127 by evntidx;
128 id evntidx;
129 format eventype eventype.;
130 title3 "sample print of work.pmedids - sorted by evntidx";
131 title4 "work.rxlk records for evntidxs in work.asmvis";
132 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed pages 12-13.
NOTE: PROCEDURE PRINT used:
real time 0.04 seconds
133
134 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 1439 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1439 observations and 3 variables.
6 The SAS System 08:37 Tuesday, June 24, 2003
NOTE: PROCEDURE SORT used:
real time 0.05 seconds
135
136 proc print data=pmedids (obs=50);
137 format eventype eventype.;
138 title3 "sample print of work.pmedids - sorted by linkidx";
139 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 14.
NOTE: PROCEDURE PRINT used:
real time 0.00 seconds
140
141 DATA PMEDIDS;
142 SET PMEDIDS (KEEP=LINKIDX);
143 BY LINKIDX;
144 IF FIRST.LINKIDX;
145 RUN;
NOTE: There were 1439 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1336 observations and 1 variables.
NOTE: DATA statement used:
real time 0.00 seconds
146
147 proc print data=pmedids (obs=50);
148 title3 "sample print of unique linkidxs in work.pmedids";
149 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: PROCEDURE PRINT used:
real time 0.28 seconds
150
151 *-----------------------------------------------------------------------------------------
152 * Get PMED records linked to MVIS events which were for asthma.
153 *-----------------------------------------------------------------------------------------;
154 PROC SORT DATA=IN.H51A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 182677 observations read from the data set IN.H51A.
NOTE: The data set WORK.PMED has 182677 observations and 52 variables.
NOTE: PROCEDURE SORT used:
real time 1:30.78
155
156 DATA MVPMEDS;
157 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP00X PERWT00F RXNAME)
158 PMEDIDS (IN=A);
159 BY LINKIDX;
7 The SAS System 08:37 Tuesday, June 24, 2003
160 IF A;
161 RUN;
NOTE: There were 182677 observations read from the data set WORK.PMED.
NOTE: There were 1336 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 3351 observations and 5 variables.
NOTE: DATA statement used:
real time 23.07 seconds
162
163 proc print data=mvpmeds (obs=200);
164 var rxrecidx rxname RXXP00X PERWT00F;
165 by linkidx;
166 id linkidx;
167 title3 "sample print of work.mvpmeds";
168 title4 "PMED (HC-051A) records for unique linkidxs in work.pmedids";
169 run;
NOTE: There were 200 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE PRINT printed pages 16-22.
NOTE: PROCEDURE PRINT used:
real time 0.05 seconds
170
171 PROC MEANS DATA=MVPMEDS N SUM;
172 VAR RXXP00X;
173 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
174 RUN;
NOTE: There were 3351 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used:
real time 0.55 seconds
175
176 PROC MEANS DATA=MVPMEDS N SUM;
177 VAR RXXP00X;
178 WEIGHT PERWT00F;
179 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
180 TITLE5 "Weighted";
181 RUN;
NOTE: There were 3351 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 24.
NOTE: PROCEDURE MEANS used:
real time 0.00 seconds
182
183
184
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used: 2:37.91
HC-051I 08:37 Tuesday, June 24, 2003 1
Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H52) records where cccodex=128
Obs CONDIDX CCCODEX
1 700020160021 128
2 700030270103 128
3 700160460057 128
4 700250310022 128
5 700400180023 128
6 700600150036 128
7 700620410027 128
8 700650190014 128
9 700710230197 128
10 700710470076 128
11 700710470139 128
12 700710470220 128
13 700840260044 128
14 700920230022 128
15 700920230072 128
16 701040310031 128
17 701070510018 128
18 701290210090 128
19 701750470029 128
20 701790470012 128
21 701860280028 128
22 701950340024 128
23 702140270063 128
24 702140410061 128
25 702470440015 128
26 702510110017 128
27 702630600025 128
28 702800530017 128
29 702800600016 128
30 702970120037 128
31 703290450025 128
32 703480330115 128
33 703620260038 128
34 703720350022 128
35 703740330010 128
36 703760300019 128
37 704370650012 128
38 704410120049 128
39 704460370015 128
40 704650140053 128
41 705050370023 128
42 705050440022 128
43 705150120020 128
44 705300280039 128
45 705330450013 128
46 705380510029 128
47 705420300016 128
48 705440380013 128
49 705480280016 128
50 705560320026 128
HC-051I 08:37 Tuesday, June 24, 2003 2
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
700020160021 700020160244 1 MVIS
700030270103 700030270153 1 MVIS
700160460057 700160460349 3 EROM
700160460356 8 PMED
700250310022 700250310055 1 MVIS
700250310062 8 PMED
700400180023 700400180068 8 PMED
700600150036 700600150096 8 PMED
700600150109 8 PMED
700600150123 8 PMED
700600150178 8 PMED
700600150185 8 PMED
700650190014 700650190159 8 PMED
700650190166 8 PMED
700650190197 8 PMED
700650190217 1 MVIS
700650190231 8 PMED
700650190248 8 PMED
700650190286 8 PMED
700650190293 8 PMED
700650190306 8 PMED
700710470139 700710470131 1 MVIS
700710470148 1 MVIS
700710470186 8 PMED
700710470244 8 PMED
700710470282 8 PMED
700710470302 8 PMED
700710470220 700710470213 1 MVIS
700710470268 8 PMED
700710470275 8 PMED
700840260044 700840260136 1 MVIS
700840260198 8 PMED
700840260287 8 PMED
700920230022 700920230207 1 MVIS
700920230214 1 MVIS
700920230221 1 MVIS
700920230238 8 PMED
700920230269 8 PMED
HC-051I 08:37 Tuesday, June 24, 2003 3
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
700920230072 700920230276 1 MVIS
700920230283 1 MVIS
700920230290 8 PMED
700920230303 8 PMED
700920230310 8 PMED
700920230327 8 PMED
701040310031 701040310062 1 MVIS
701040310079 8 PMED
701040310093 1 MVIS
701040310106 8 PMED
701290210090 701290210146 1 MVIS
701290210153 1 MVIS
701290210160 1 MVIS
701290210177 1 MVIS
701290210184 1 MVIS
701290210191 8 PMED
701290210204 8 PMED
701290210211 8 PMED
701290210228 8 PMED
701750470029 701750470078 1 MVIS
701750470085 1 MVIS
701750470092 1 MVIS
701750470105 1 MVIS
701750470112 1 MVIS
701750470129 1 MVIS
701750470136 8 PMED
701750470143 8 PMED
701750470150 8 PMED
701790470012 701790470202 8 PMED
701950340024 701950340049 8 PMED
701950340056 8 PMED
702140270063 702140270133 1 MVIS
702140270157 8 PMED
702140410061 702140410133 1 MVIS
702510110017 702510110257 1 MVIS
702510110264 1 MVIS
HC-051I 08:37 Tuesday, June 24, 2003 4
Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 700020160021 700020160244 1 MVIS
2 700030270103 700030270153 1 MVIS
3 700160460057 700160460349 3 EROM
4 700160460057 700160460356 8 PMED
5 700250310022 700250310055 1 MVIS
6 700250310022 700250310062 8 PMED
7 700400180023 700400180068 8 PMED
8 700600150036 700600150096 8 PMED
9 700600150036 700600150109 8 PMED
10 700600150036 700600150123 8 PMED
11 700600150036 700600150130 8 PMED
12 700600150036 700600150178 8 PMED
13 700600150036 700600150185 8 PMED
14 700650190014 700650190159 8 PMED
15 700650190014 700650190166 8 PMED
16 700650190014 700650190197 8 PMED
17 700650190014 700650190217 1 MVIS
18 700650190014 700650190231 8 PMED
19 700650190014 700650190248 8 PMED
20 700650190014 700650190286 8 PMED
21 700650190014 700650190293 8 PMED
22 700650190014 700650190306 8 PMED
23 700710470139 700710470131 1 MVIS
24 700710470139 700710470148 1 MVIS
25 700710470139 700710470186 8 PMED
26 700710470220 700710470213 1 MVIS
27 700710470139 700710470244 8 PMED
28 700710470220 700710470268 8 PMED
29 700710470220 700710470275 8 PMED
30 700710470139 700710470282 8 PMED
31 700710470139 700710470302 8 PMED
32 700840260044 700840260136 1 MVIS
33 700840260044 700840260198 8 PMED
34 700840260044 700840260287 8 PMED
35 700920230022 700920230207 1 MVIS
36 700920230022 700920230214 1 MVIS
37 700920230022 700920230221 1 MVIS
38 700920230022 700920230238 8 PMED
39 700920230022 700920230269 8 PMED
40 700920230072 700920230276 1 MVIS
41 700920230072 700920230283 1 MVIS
42 700920230072 700920230290 8 PMED
43 700920230072 700920230303 8 PMED
44 700920230072 700920230310 8 PMED
45 700920230072 700920230327 8 PMED
46 701040310031 701040310062 1 MVIS
47 701040310031 701040310079 8 PMED
48 701040310031 701040310093 1 MVIS
49 701040310031 701040310106 8 PMED
50 701290210090 701290210146 1 MVIS
HC-051I 08:37 Tuesday, June 24, 2003 5
Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 700020160244 1 MVIS
2 700030270153 1 MVIS
3 700160460349 3 EROM
4 700160460356 8 PMED
5 700250310055 1 MVIS
6 700250310062 8 PMED
7 700400180068 8 PMED
8 700600150096 8 PMED
9 700600150109 8 PMED
10 700600150123 8 PMED
11 700600150130 8 PMED
12 700600150178 8 PMED
13 700600150185 8 PMED
14 700650190159 8 PMED
15 700650190166 8 PMED
16 700650190197 8 PMED
17 700650190217 1 MVIS
18 700650190231 8 PMED
19 700650190248 8 PMED
20 700650190286 8 PMED
21 700650190293 8 PMED
22 700650190306 8 PMED
23 700710470131 1 MVIS
24 700710470148 1 MVIS
25 700710470186 8 PMED
26 700710470213 1 MVIS
27 700710470244 8 PMED
28 700710470268 8 PMED
29 700710470275 8 PMED
30 700710470282 8 PMED
31 700710470302 8 PMED
32 700840260136 1 MVIS
33 700840260198 8 PMED
34 700840260287 8 PMED
35 700920230207 1 MVIS
36 700920230214 1 MVIS
37 700920230221 1 MVIS
38 700920230238 8 PMED
39 700920230269 8 PMED
40 700920230276 1 MVIS
41 700920230283 1 MVIS
42 700920230290 8 PMED
43 700920230303 8 PMED
44 700920230310 8 PMED
45 700920230327 8 PMED
46 701040310062 1 MVIS
47 701040310079 8 PMED
48 701040310093 1 MVIS
49 701040310106 8 PMED
50 701290210146 1 MVIS
HC-051I 08:37 Tuesday, June 24, 2003 6
Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-051G) events
Obs EVNTIDX EVENTYPE
1 700020160244 1 MVIS
2 700030270153 1 MVIS
3 700250310055 1 MVIS
4 700650190217 1 MVIS
5 700710470131 1 MVIS
6 700710470148 1 MVIS
7 700710470213 1 MVIS
8 700840260136 1 MVIS
9 700920230207 1 MVIS
10 700920230214 1 MVIS
11 700920230221 1 MVIS
12 700920230276 1 MVIS
13 700920230283 1 MVIS
14 701040310062 1 MVIS
15 701040310093 1 MVIS
16 701290210146 1 MVIS
17 701290210153 1 MVIS
18 701290210160 1 MVIS
19 701290210177 1 MVIS
20 701290210184 1 MVIS
21 701750470078 1 MVIS
22 701750470085 1 MVIS
23 701750470092 1 MVIS
24 701750470105 1 MVIS
25 701750470112 1 MVIS
26 701750470129 1 MVIS
27 702140270133 1 MVIS
28 702140410133 1 MVIS
29 702510110257 1 MVIS
30 702510110264 1 MVIS
31 702510110459 1 MVIS
32 702630600060 1 MVIS
33 702970120198 1 MVIS
34 702970120201 1 MVIS
35 702970120218 1 MVIS
36 704410120052 1 MVIS
37 704410120069 1 MVIS
38 704410120076 1 MVIS
39 704410120083 1 MVIS
40 705150120301 1 MVIS
41 705480280281 1 MVIS
42 705480280298 1 MVIS
43 705480280414 1 MVIS
44 705700290090 1 MVIS
45 705820230365 1 MVIS
46 705820230512 1 MVIS
47 705820230601 1 MVIS
48 705820230618 1 MVIS
49 705820230625 1 MVIS
50 705820230632 1 MVIS
HC-051I 08:37 Tuesday, June 24, 2003 7
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-51IF2)
EVENTIDX LINKIDX EVENTYPE
700020160244 700020160268 1 MVIS
700020160251 700020160275 3 EROM
700030100160 700030100177 1 MVIS
700030100191 700030100211 1 MVIS
700030270108 700030270122 1 MVIS
700030270139 1 MVIS
700030270153 700030270177 1 MVIS
700030340033 700030340040 1 MVIS
700030340057 1 MVIS
700030570065 700030570089 1 MVIS
700040210067 700040210074 1 MVIS
700050110128 700050110135 1 MVIS
700050230123 700050230130 1 MVIS
700060190073 700060190100 1 MVIS
700060260080 700060260179 1 MVIS
700060260186 1 MVIS
700060260193 1 MVIS
700060260244 700060260364 1 MVIS
700060260251 700060260371 1 MVIS
700060260388 1 MVIS
700070210087 700070210152 1 MVIS
700070450049 700070450070 1 MVIS
700070450087 1 MVIS
700070450056 700070450070 1 MVIS
700070450087 1 MVIS
700070510088 700070510095 1 MVIS
700130330073 700130330100 1 MVIS
700140160115 700140160122 1 MVIS
HC-051I 08:37 Tuesday, June 24, 2003 8
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-51IF2)
EVENTIDX LINKIDX EVENTYPE
700140230362 700140230519 1 MVIS
700140230468 700140230475 6 OMED
700140230824 700140230831 6 OMED
700160150065 700160150116 1 MVIS
700160220010 700160220027 1 MVIS
700160390010 700160390027 1 MVIS
700160390034 1 MVIS
700160460185 700160460229 1 MVIS
700160460236 1 MVIS
700160460243 1 MVIS
700160460192 700160460250 1 MVIS
700160460267 1 MVIS
700160460349 700160460356 3 EROM
700170170223 700170170292 1 MVIS
700170170305 1 MVIS
700170170312 1 MVIS
700170170329 1 MVIS
700170170285 700170170292 6 OMED
700170170336 700170170374 1 MVIS
700170170343 700170170374 1 MVIS
700170170350 700170170374 1 MVIS
700170170367 700170170374 1 MVIS
700170240090 700170240134 1 MVIS
700170240141 700170240223 1 MVIS
700170240230 1 MVIS
700170240247 1 MVIS
700170240254 1 MVIS
700170240261 1 MVIS
700170240209 700170240216 6 OMED
700170240278 700170240312 1 MVIS
700170240329 1 MVIS
HC-051I 08:37 Tuesday, June 24, 2003 9
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-51IF2)
EVENTIDX LINKIDX EVENTYPE
700170240278 700170240336 1 MVIS
700170240343 1 MVIS
700170240367 1 MVIS
700170240381 1 MVIS
700170240285 700170240312 1 MVIS
700170240329 1 MVIS
700170240336 1 MVIS
700170240343 1 MVIS
700170240367 1 MVIS
700170240381 1 MVIS
700170240292 700170240312 1 MVIS
700170240329 1 MVIS
700170240336 1 MVIS
700170240343 1 MVIS
700170240367 1 MVIS
700170240381 1 MVIS
700170240305 700170240312 1 MVIS
700170240329 1 MVIS
700170240336 1 MVIS
700170240343 1 MVIS
700170240367 1 MVIS
700170240381 1 MVIS
700200440060 700200440077 1 MVIS
700210130019 700210130033 1 MVIS
700210270050 700210270074 1 MVIS
700210270081 1 MVIS
700210270101 700210270125 1 MVIS
700210270132 1 MVIS
700210270118 700210270132 1 MVIS
700210270156 700210270187 1 MVIS
700210270194 1 MVIS
700210270207 1 MVIS
700210270214 1 MVIS
700250170048 700250170055 1 MVIS
700250170062 1 MVIS
700250310055 700250310062 1 MVIS
700250310079 1 MVIS
HC-051I 08:37 Tuesday, June 24, 2003 10
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-51IF2)
EVENTIDX LINKIDX EVENTYPE
700250480024 700250480031 1 MVIS
700280240520 700280240582 1 MVIS
700280240537 700280240599 1 MVIS
700280240602 1 MVIS
700280240619 1 MVIS
700280240544 700280240626 1 MVIS
700280240551 700280240633 1 MVIS
700280240575 700280240633 4 STAZ
700280241218 700280241225 1 MVIS
700300260145 700300260152 1 MVIS
700300260241 700300260289 1 MVIS
700300260258 700300260296 1 MVIS
700320160339 700320160391 3 EROM
700320160404 3 EROM
700320160411 3 EROM
700320160346 700320160428 1 MVIS
700320160360 700320160435 1 MVIS
700380130115 700380130122 1 MVIS
700380130177 700380130235 1 MVIS
700380130242 1 MVIS
700380130259 1 MVIS
700380130204 700380130273 1 MVIS
700380250141 700380250292 1 MVIS
700380250158 700380250305 1 MVIS
700380250189 700380250292 1 MVIS
700380250278 700380250305 4 STAZ
700390180407 700390180414 6 OMED
700390180541 700390180596 1 MVIS
HC-051I 08:37 Tuesday, June 24, 2003 11
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-51IF2)
EVENTIDX LINKIDX EVENTYPE
700390180541 700390180609 1 MVIS
700390180616 1 MVIS
700390180623 1 MVIS
700390180678 700390180743 5 DVIS
700390180729 700390180736 6 OMED
700400180037 700400180068 1 MVIS
700430180041 700430180058 1 MVIS
700450110312 700450110374 1 MVIS
700450170070 700450170087 3 EROM
700450170094 3 EROM
700450170107 700450170114 1 MVIS
700450170121 1 MVIS
700450170138 1 MVIS
700450330225 700450330256 1 MVIS
700450330294 700450330338 5 DVIS
700450330345 5 DVIS
HC-051I 08:37 Tuesday, June 24, 2003 12
Sample SAS Job for Example A
sample print of work.pmedids - sorted by evntidx
work.rxlk records for evntidxs in work.asmvis
EVNTIDX LINKIDX EVENTYPE
700020160244 700020160268 1 MVIS
700030270153 700030270177 1 MVIS
700250310055 700250310062 1 MVIS
700250310079 1 MVIS
700650190217 700650190224 1 MVIS
700650190231 1 MVIS
700650190248 1 MVIS
700650190255 1 MVIS
700650190262 1 MVIS
700650190279 1 MVIS
700710470131 700710470186 1 MVIS
700710470213 700710470268 1 MVIS
700710470275 1 MVIS
700710470282 1 MVIS
700840260136 700840260143 1 MVIS
700840260150 1 MVIS
700840260167 1 MVIS
700840260174 1 MVIS
700840260181 1 MVIS
700840260198 1 MVIS
700920230276 700920230290 1 MVIS
700920230303 1 MVIS
700920230310 1 MVIS
700920230283 700920230290 1 MVIS
700920230310 1 MVIS
700920230327 1 MVIS
701040310062 701040310079 1 MVIS
701040310093 701040310106 1 MVIS
701290210146 701290210191 1 MVIS
701290210204 1 MVIS
701290210211 1 MVIS
701290210228 1 MVIS
701750470078 701750470136 1 MVIS
701750470143 1 MVIS
701750470129 701750470136 1 MVIS
HC-051I 08:37 Tuesday, June 24, 2003 13
Sample SAS Job for Example A
sample print of work.pmedids - sorted by evntidx
work.rxlk records for evntidxs in work.asmvis
EVNTIDX LINKIDX EVENTYPE
702140270133 702140270157 1 MVIS
702630600060 702630600104 1 MVIS
702970120198 702970120225 1 MVIS
702970120232 1 MVIS
702970120249 1 MVIS
702970120256 1 MVIS
702970120263 1 MVIS
702970120270 1 MVIS
704410120052 704410120090 1 MVIS
705150120301 705150120370 1 MVIS
705150120387 1 MVIS
705150120394 1 MVIS
705150120407 1 MVIS
705150120414 1 MVIS
705150120421 1 MVIS
HC-051I 08:37 Tuesday, June 24, 2003 14
Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx
Obs EVNTIDX LINKIDX EVENTYPE
1 700020160244 700020160268 1 MVIS
2 700030270153 700030270177 1 MVIS
3 700250310055 700250310062 1 MVIS
4 700250310055 700250310079 1 MVIS
5 700650190217 700650190224 1 MVIS
6 700650190217 700650190231 1 MVIS
7 700650190217 700650190248 1 MVIS
8 700650190217 700650190255 1 MVIS
9 700650190217 700650190262 1 MVIS
10 700650190217 700650190279 1 MVIS
11 700710470131 700710470186 1 MVIS
12 700710470213 700710470268 1 MVIS
13 700710470213 700710470275 1 MVIS
14 700710470213 700710470282 1 MVIS
15 700840260136 700840260143 1 MVIS
16 700840260136 700840260150 1 MVIS
17 700840260136 700840260167 1 MVIS
18 700840260136 700840260174 1 MVIS
19 700840260136 700840260181 1 MVIS
20 700840260136 700840260198 1 MVIS
21 700920230276 700920230290 1 MVIS
22 700920230283 700920230290 1 MVIS
23 700920230276 700920230303 1 MVIS
24 700920230276 700920230310 1 MVIS
25 700920230283 700920230310 1 MVIS
26 700920230283 700920230327 1 MVIS
27 701040310062 701040310079 1 MVIS
28 701040310093 701040310106 1 MVIS
29 701290210146 701290210191 1 MVIS
30 701290210146 701290210204 1 MVIS
31 701290210146 701290210211 1 MVIS
32 701290210146 701290210228 1 MVIS
33 701750470078 701750470136 1 MVIS
34 701750470129 701750470136 1 MVIS
35 701750470078 701750470143 1 MVIS
36 702140270133 702140270157 1 MVIS
37 702630600060 702630600104 1 MVIS
38 702970120198 702970120225 1 MVIS
39 702970120198 702970120232 1 MVIS
40 702970120198 702970120249 1 MVIS
41 702970120198 702970120256 1 MVIS
42 702970120198 702970120263 1 MVIS
43 702970120198 702970120270 1 MVIS
44 704410120052 704410120090 1 MVIS
45 705150120301 705150120370 1 MVIS
46 705150120301 705150120387 1 MVIS
47 705150120301 705150120394 1 MVIS
48 705150120301 705150120407 1 MVIS
49 705150120301 705150120414 1 MVIS
50 705150120301 705150120421 1 MVIS
HC-051I 08:37 Tuesday, June 24, 2003 15
Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids
Obs LINKIDX
1 700020160268
2 700030270177
3 700250310062
4 700250310079
5 700650190224
6 700650190231
7 700650190248
8 700650190255
9 700650190262
10 700650190279
11 700710470186
12 700710470268
13 700710470275
14 700710470282
15 700840260143
16 700840260150
17 700840260167
18 700840260174
19 700840260181
20 700840260198
21 700920230290
22 700920230303
23 700920230310
24 700920230327
25 701040310079
26 701040310106
27 701290210191
28 701290210204
29 701290210211
30 701290210228
31 701750470136
32 701750470143
33 702140270157
34 702630600104
35 702970120225
36 702970120232
37 702970120249
38 702970120256
39 702970120263
40 702970120270
41 704410120090
42 705150120370
43 705150120387
44 705150120394
45 705150120407
46 705150120414
47 705150120421
48 705150120438
49 705150120445
50 705150120452
HC-051I 08:37 Tuesday, June 24, 2003 16
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
700020160268 700020160268001 MOTRIN 12.62 14309.468408
700030270177 700030270177001 TRIPLE ANTIBIOTIC 3.13 11255.554274
700250310062 700250310062001 ALBUTEROL SULFATE 3.83 4141.903714
700250310079 700250310079001 AMOXICILLIN 5.28 4141.903714
700650190224 700650190224001 CLARITIN 60.69 8288.535695
700650190224002 CLARITIN 60.69 8288.535695
700650190224003 CLARITIN 62.46 8288.535695
700650190224004 CLARITIN 60.10 8288.535695
700650190231 700650190231001 ALBUTEROL 17.99 8288.535695
700650190231002 ALBUTEROL 17.99 8288.535695
700650190231003 ALBUTEROL 16.64 8288.535695
700650190231004 ALBUTEROL 16.64 8288.535695
700650190248 700650190248001 FLOVENT 54.59 8288.535695
700650190248002 FLOVENT 54.59 8288.535695
700650190248003 FLOVENT 54.59 8288.535695
700650190248004 FLOVENT 54.59 8288.535695
700650190255 700650190255001 RHINOCORT 34.03 8288.535695
700650190255002 RHINOCORT 34.03 8288.535695
700650190255003 RHINOCORT 34.03 8288.535695
700650190255004 RHINOCORT 34.03 8288.535695
700650190262 700650190262001 VERAPAMIL HCL 20.68 8288.535695
700650190262002 VERAPAMIL HCL 20.68 8288.535695
700650190262003 VERAPAMIL HCL 20.68 8288.535695
700650190262004 VERAPAMIL HCL 20.68 8288.535695
700650190279 700650190279001 ZESTRIL 25.00 8288.535695
700650190279002 ZESTRIL 25.00 8288.535695
700650190279003 ZESTRIL 25.00 8288.535695
700650190279004 ZESTRIL 25.00 8288.535695
700710470186 700710470186001 SEREVENT DISKUS 63.44 9015.740428
700710470186002 SEREVENT DISKUS 63.44 9015.740428
700710470268 700710470268001 AMOXIL 10.00 9015.740428
700710470275 700710470275001 PEDIAPRED 22.98 9015.740428
700710470282 700710470282001 ALBUTEROL 18.99 9015.740428
700840260143 700840260143001 MISOPROSTOL 150.94 27728.284639
HC-051I 08:37 Tuesday, June 24, 2003 17
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
700840260150 700840260150001 LISINOPRIL 77.37 27728.284639
700840260167 700840260167001 SULINDAC 55.52 27728.284639
700840260174 700840260174001 ADALAT 31.95 27728.284639
700840260181 700840260181001 LEVOTHYROXINE 15.57 27728.284639
700840260198 700840260198001 AEROBID 67.01 27728.284639
700920230290 700920230290001 PREDISONE 10.88 5006.337153
700920230303 700920230303001 AEROCHAMBER 30.12 5006.337153
700920230310 700920230310001 VENTOLIN 64.24 5006.337153
700920230310002 VENTOLIN 64.24 5006.337153
700920230327 700920230327001 AZMACORT 49.09 5006.337153
701040310079 701040310079001 ALBUTEROL 17.44 4142.210684
701040310106 701040310106001 ALBUTEROL 17.44 4142.210684
701290210191 701290210191001 PREDNISOLONE 7.77 7299.943487
701290210191002 PREDNISOLONE 7.77 7299.943487
701290210204 701290210204001 SINGULAIR (UNIT OF USE) 84.33 7299.943487
701290210211 701290210211001 BECLOVENT 134.82 7299.943487
701290210211002 BECLOVENT 134.82 7299.943487
701290210211003 BECLOVENT 134.82 7299.943487
701290210228 701290210228001 NEBULIZER 77.38 7299.943487
701750470136 701750470136001 FLOVENT 99.44 4668.209540
701750470136002 FLOVENT 99.44 4668.209540
701750470143 701750470143001 ALBUTEROL 9.65 4668.209540
702140270157 702140270157001 VENTOLIN 64.24 18941.563378
702140270157002 VENTOLIN 64.24 18941.563378
702630600104 702630600104001 ALBUTEROL 17.50 5284.005215
702630600104002 ALBUTEROL 17.50 5284.005215
702630600104003 ALBUTEROL 17.50 5284.005215
702630600104004 ALBUTEROL 17.50 5284.005215
702630600104005 ALBUTEROL 17.50 5284.005215
702970120225 702970120225001 ACCOLATE 59.34 15096.510751
HC-051I 08:37 Tuesday, June 24, 2003 18
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
702970120232 702970120232001 PULMICORT 217.02 15096.510751
702970120249 702970120249001 ZYRTEC 101.39 15096.510751
702970120249002 ZYRTEC 54.44 15096.510751
702970120249003 ZYRTEC 101.39 15096.510751
702970120249004 ZYRTEC 101.39 15096.510751
702970120249005 ZYRTEC 54.44 15096.510751
702970120256 702970120256001 VENTOLIN 29.02 15096.510751
702970120263 702970120263001 PREDNISONE 8.84 15096.510751
702970120263002 PREDNISONE 8.84 15096.510751
702970120270 702970120270001 METHYLPREDNISOLONE (UNIT OF USE) 13.24 15096.510751
704410120090 704410120090001 ROBITUSSIN 24.19 3520.146263
705150120370 705150120370001 PREVACID 111.99 3391.455336
705150120370002 PREVACID 111.99 3391.455336
705150120387 705150120387001 SULFADIAZINE 12.64 3391.455336
705150120394 705150120394001 HOMATROPINE/HYDROCODONE 5.43 3391.455336
705150120407 705150120407001 BIAXIN 72.68 3391.455336
705150120414 705150120414001 PATANOL 59.99 3391.455336
705150120421 705150120421001 FLONASE 50.48 3391.455336
705150120438 705150120438001 PRAVACHOL 335.80 3391.455336
705150120445 705150120445001 PREDNISONE 6.98 3391.455336
705150120452 705150120452001 ZYRTEC 17.86 3391.455336
705150120469 705150120469001 ALLEGRA-D 64.36 3391.455336
705150120476 705150120476001 CROMOLYN 24.34 3391.455336
705150120483 705150120483001 LIVOSTIN 39.41 3391.455336
705480280394 705480280394001 ESTRATAB 16.78 13477.023448
705700290103 705700290103001 Z-PAK 37.27 26722.792484
705700290110 705700290110001 CLARITIN 69.34 26722.792484
705700290127 705700290127001 RELION/NOVO 15.00 26722.792484
HC-051I 08:37 Tuesday, June 24, 2003 19
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
705820230790 705820230790001 PREDNISONE 6.05 16052.116072
705820230790002 PREDNISONE 6.05 16052.116072
705820230790003 PREDNISONE 6.05 16052.116072
705960430170 705960430170001 PREDNISONE 3.90 659.650918
705960430187 705960430187001 ALBUTEROL 16.37 659.650918
705960430194 705960430194001 FLOVENT 59.13 659.650918
706130120050 706130120050001 Ibuprofen 18.67 15913.710072
706130120067 706130120067001 ALBUTEROL 42.88 15913.710072
706220240568 706220240568001 ALLEGRA 49.44 17318.346064
706220240575 706220240575001 FLOVENT 63.57 17318.346064
706220240582 706220240582001 ALBUTEROL 28.97 17318.346064
706440430073 706440430073001 PROPOXY-N W/APAP 15.19 6825.819171
706440430073002 PROPOXY-N W/APAP 15.19 6825.819171
706440430080 706440430080001 PROMETHAZINE DM 3.49 6825.819171
706440430080002 PROMETHAZINE DM 3.49 6825.819171
706440430131 706440430131001 PROMETHAZINE DM 3.49 6825.819171
706440430148 706440430148001 CEFTIN 65.56 6825.819171
706970200685 706970200685001 KLONOPIN 33.03 6486.389241
706970200685002 KLONOPIN 36.87 6486.389241
706970200685003 KLONOPIN 36.87 6486.389241
706970200692 706970200692001 UNIPHYL 6.98 6486.389241
706970200692002 UNIPHYL 6.98 6486.389241
706970200692003 UNIPHYL 6.98 6486.389241
706970200692004 UNIPHYL 6.98 6486.389241
706970200705 706970200705001 KLONOPIN 37.80 6486.389241
706970200705002 KLONOPIN 37.80 6486.389241
706970200705003 KLONOPIN 37.80 6486.389241
706970200705004 KLONOPIN 37.80 6486.389241
707140430404 707140430404001 HISTINEX DM (A.F., S.F.,BERRY) 9.29 14053.576563
707610340089 707610340089001 ALBUTEROL 6.37 15037.945696
707610340096 707610340096001 INTAL 48.27 15037.945696
HC-051I 08:37 Tuesday, June 24, 2003 20
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
707610340109 707610340109001 VISINE A EYE DROPS 13.13 15037.945696
707610340130 707610340130001 VICKS VAPOR RUB 9.19 15037.945696
707740290101 707740290101001 PROVENTIL HFA (M.D.I.) 30.44 7688.745440
707740290118 707740290118001 PULMICORT 119.10 7688.745440
707740290170 707740290170001 MINOCYCLINE 37.50 7688.745440
707740290187 707740290187001 HYDROCORTISONE VALERATE 31.16 7688.745440
707740290194 707740290194001 PROVENTIL HFA (M.D.I.) 30.44 7688.745440
707740290207 707740290207001 BIAXIN FILMTAB 75.30 7688.745440
707740290214 707740290214001 APAP/HYDROCODONE BITARTRATE 9.53 7688.745440
707740290221 707740290221001 PULMICORT 119.10 7688.745440
707740290238 707740290238001 CLARITIN-D 39.07 7688.745440
707740360194 707740360194001 PANFIL G 87.63 7631.214436
707740360207 707740360207001 PREDNISOLONE 9.56 7631.214436
707740430101 707740430101001 PANFIL G 28.98 7381.782920
707740430118 707740430118001 ZITHROMAX 34.85 7381.782920
707740430132 707740430132001 XOPENEX (P.F.) 179.50 7381.782920
708190130432 708190130432001 ALBUTEROL 31.74 16932.495560
709600400116 709600400116001 ALBUTEROL 10.42 3403.718615
709600400243 709600400243001 BIAXIN FILMTAB 67.94 3403.718615
709600400250 709600400250001 ALBUTEROL INHALER 21.50 3403.718615
709600400267 709600400267001 FLOVENT 42.67 3403.718615
709600400274 709600400274001 CROMOLYN SODIUM (VIAL) 31.93 3403.718615
709600400281 709600400281001 ALBUTEROL SULFATE 9.37 3403.718615
709940230949 709940230949001 NASONEX 47.32 8301.175199
709940230956 709940230956001 PREDNISONE 4.37 8301.175199
HC-051I 08:37 Tuesday, June 24, 2003 21
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
710310170212 710310170212001 CLARITIN-D 71.68 13053.216890
710310170229 710310170229001 TEQUIN 43.99 13053.216890
711550170396 711550170396001 ALPRAZOLAM 28.91 3792.271371
711550170396002 ALPRAZOLAM 28.91 3792.271371
711550170396003 ALPRAZOLAM 28.91 3792.271371
711550170396004 ALPRAZOLAM 28.91 3792.271371
711550170409 711550170409001 ACCOLATE 44.69 3792.271371
711550170409002 ACCOLATE 44.69 3792.271371
711550170416 711550170416001 PREDNISONE 9.98 3792.271371
711550170416002 PREDNISONE 9.98 3792.271371
711550170447 711550170447001 LOTREL 80.69 3792.271371
711550170447002 LOTREL 74.69 3792.271371
711550170447003 LOTREL 80.69 3792.271371
711550170447004 LOTREL 74.69 3792.271371
711550170454 711550170454001 ALBUTEROL 28.98 3792.271371
711550170454002 ALBUTEROL 28.98 3792.271371
711550170454003 ALBUTEROL 28.98 3792.271371
711550170529 711550170529001 LOTREL 80.69 3792.271371
711550170529002 LOTREL 80.69 3792.271371
711550170529003 LOTREL 80.69 3792.271371
711550170536 711550170536001 ALPRAZOLAM 22.83 3792.271371
711550170536002 ALPRAZOLAM 22.83 3792.271371
711550170536003 ALPRAZOLAM 22.83 3792.271371
711550170543 711550170543001 PREDNISONE 9.98 3792.271371
711550170543002 PREDNISONE 9.98 3792.271371
711550170543003 PREDNISONE 9.98 3792.271371
711550170550 711550170550001 AEROCHAMBER 31.63 3792.271371
711550170550002 AEROCHAMBER 31.63 3792.271371
711550170550003 AEROCHAMBER 31.63 3792.271371
711550170567 711550170567001 ACCOLATE 46.69 3792.271371
711550170567002 ACCOLATE 46.69 3792.271371
711550170567003 ACCOLATE 46.69 3792.271371
711550170574 711550170574001 LOPERAMIDE HCL 23.98 3792.271371
711550170574002 LOPERAMIDE HCL 23.98 3792.271371
711550170574003 LOPERAMIDE HCL 23.98 3792.271371
712370190686 712370190686001 PULMICORT 119.10 4557.939313
HC-051I 08:37 Tuesday, June 24, 2003 22
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
712370190686 712370190686002 PULMICORT 119.10 4557.939313
712370190686003 PULMICORT 119.10 4557.939313
713630160110 713630160110001 PROVENTIL HFA (M.D.I.) 33.43 15294.859620
713630160110002 PROVENTIL HFA (M.D.I.) 33.43 15294.859620
713630160110003 PROVENTIL HFA (M.D.I.) 33.43 15294.859620
713650180537 713650180537001 ZESTORETIC 39.19 5442.223911
713650180537002 ZESTORETIC 39.19 5442.223911
713650180537003 ZESTORETIC 39.19 5442.223911
713650180537004 ZESTORETIC 39.19 5442.223911
713650180575 713650180575001 PRAVACHOL 195.25 5442.223911
713650180575002 PRAVACHOL 195.25 5442.223911
713650180575003 PRAVACHOL 195.25 5442.223911
713650180619 713650180619001 FLOVENT 55.46 5442.223911
713650180619002 FLOVENT 55.46 5442.223911
713650180619003 FLOVENT 55.46 5442.223911
713650180619004 FLOVENT 55.46 5442.223911
HC-051I 08:37 Tuesday, June 24, 2003 23
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
The MEANS Procedure
Analysis Variable : RXXP00X SUM OF PAYMENTS RXSF00X-RXOU00X(IMPUTED)
N Sum
--------------------
3351 160483.82
--------------------
HC-051I 08:37 Tuesday, June 24, 2003 24
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP00X SUM OF PAYMENTS RXSF00X-RXOU00X(IMPUTED)
N Sum
--------------------
3351 1702472286
--------------------
1 The SAS System 08:42 Tuesday, June 24, 2003
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC/AHRQ, Site 0038838053.
NOTE: This session is executing on the WIN_95 platform.
NOTE: SAS initialization used:
real time 4.67 seconds
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-051I";
4 TITLE2 'Sample SAS Job for Example B';
5
6 LIBNAME IN 'C:\data';
NOTE: Directory for library IN contains files of mixed engine types.
NOTE: Libref IN was successfully assigned as follows:
Engine: V8
Physical Name: C:\data
7
8 **************************************************************************************
9 * Calculate the expenditures for prescribed medicines associated with asthma.
10 **************************************************************************************;
11 PROC FORMAT;
12 VALUE EVENTYPE
13 1 = "1 MVIS"
14 2 = "2 OPAT"
15 3 = "3 EROM"
16 4 = "4 STAZ"
17 5 = "5 DVIS"
18 6 = "6 OMED"
19 7 = "7 HVIS"
20 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
21 RUN;
NOTE: PROCEDURE FORMAT used:
real time 0.26 seconds
22
23 *--------------------------------------------------------------------------------------
24 * Get condition records coded as asthma.
25 *--------------------------------------------------------------------------------------;
26 DATA ASCONDS;
27 SET IN.H52 (KEEP=CONDIDX CCCODEX);
28 IF CCCODEX="128";
29 RUN;
NOTE: There were 72624 observations read from the data set IN.H52.
NOTE: The data set WORK.ASCONDS has 1156 observations and 2 variables.
NOTE: DATA statement used:
real time 9.00 seconds
30
2 The SAS System 08:42 Tuesday, June 24, 2003
31 *--------------------------------------------------------------------------
32 * Get the events linked to each of the asthma condition records.
33 *--------------------------------------------------------------------------;
34 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 1156 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1156 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.15 seconds
35
36 proc print data=asconds (obs=50);
37 title3 "sample print of work.asconds - sorted by condidx";
38 title4 "COND (H52) records where cccodex=128";
39 run;
NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used:
real time 0.44 seconds
40
41 PROC SORT DATA=IN.H51IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 217414 observations read from the data set IN.H51IF1.
NOTE: The data set WORK.CLNK has 217414 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 6.98 seconds
42
43 DATA ASCLNKS;
44 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
45 ASCONDS(IN=INASCOND KEEP=CONDIDX);
46 BY CONDIDX;
47 IF INCLNK & INASCOND;
48 RUN;
NOTE: There were 217414 observations read from the data set WORK.CLNK.
NOTE: There were 1156 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 4737 observations and 3 variables.
NOTE: DATA statement used:
real time 3.40 seconds
49
50 proc print data=asclnks (obs=75);
51 by condidx;
52 id condidx;
53 format eventype eventype.;
54 title3 "sample print of work.asclnks - sorted by condidx";
55 title4 "events linked to asthma condition records";
56 run;
NOTE: There were 75 observations read from the data set WORK.ASCLNKS.
3 The SAS System 08:42 Tuesday, June 24, 2003
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used:
real time 0.32 seconds
57
58 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 4737 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 4737 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.05 seconds
59
60 proc print data=asclnks (obs=50);
61 format eventype eventype.;
62 title3 "sample print of work.asclnks - sorted by evntidx";
63 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used:
real time 0.00 seconds
64
65 DATA ASCLNKS;
66 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
67 BY EVNTIDX;
68 IF FIRST.EVNTIDX;
69 RUN;
NOTE: There were 4737 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 4712 observations and 2 variables.
NOTE: DATA statement used:
real time 0.05 seconds
70
71 proc print data=asclnks (obs=50);
72 format eventype eventype.;
73 title3 "sample print of unique evntidxs from work.asclnks";
74 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used:
real time 0.04 seconds
75
76 *-------------------------------------------------------------------------------
77 * Get PMED records linked to asthma condition records.
78 *-------------------------------------------------------------------------------;
79 PROC SORT DATA=IN.H51A OUT=PMED; BY LINKIDX; RUN;
4 The SAS System 08:42 Tuesday, June 24, 2003
NOTE: There were 182677 observations read from the data set IN.H51A.
NOTE: The data set WORK.PMED has 182677 observations and 52 variables.
NOTE: PROCEDURE SORT used:
real time 1:30.07
80
81 DATA ASPMEDS;
82 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F)
83 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX RENAME=(EVNTIDX=LINKIDX));
84 BY LINKIDX;
85 IF INASCLNK & PERWT00F>0;
86 RUN;
NOTE: There were 182677 observations read from the data set WORK.PMED.
NOTE: There were 4712 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 6307 observations and 5 variables.
NOTE: DATA statement used:
real time 23.62 seconds
87
88 proc print data=aspmeds (obs=300);
89 by linkidx;
90 id linkidx;
91 var rxrecidx rxname RXXP00X PERWT00F;
92 title3 "sample print of work.aspmeds";
93 title4 "PMED (HC-051A) records which link to condition records coded as asthma";
94 run;
NOTE: There were 300 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE PRINT printed pages 6-15.
NOTE: PROCEDURE PRINT used:
real time 0.04 seconds
95
96 PROC MEANS DATA=ASPMEDS N SUM;
97 VAR RXXP00X;
98 TITLE3 "Total Rx expenditures associated with asthma";
99 RUN;
NOTE: There were 6307 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 16.
NOTE: PROCEDURE MEANS used:
real time 0.50 seconds
100
101 PROC MEANS DATA=ASPMEDS N SUM;
102 VAR RXXP00X;
103 WEIGHT PERWT00F;
104 TITLE3 "Total Rx expenditures associated with asthma";
105 TITLE5 "Weighted";
106 RUN;
NOTE: There were 6307 observations read from the data set WORK.ASPMEDS.
5 The SAS System 08:42 Tuesday, June 24, 2003
NOTE: The PROCEDURE MEANS printed page 17.
NOTE: PROCEDURE MEANS used:
real time 0.04 seconds
107
108
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 2:20.39
HC-051I 08:42 Tuesday, June 24, 2003 1
Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H52) records where cccodex=128
Obs CONDIDX CCCODEX
1 700020160021 128
2 700030270103 128
3 700160460057 128
4 700250310022 128
5 700400180023 128
6 700600150036 128
7 700620410027 128
8 700650190014 128
9 700710230197 128
10 700710470076 128
11 700710470139 128
12 700710470220 128
13 700840260044 128
14 700920230022 128
15 700920230072 128
16 701040310031 128
17 701070510018 128
18 701290210090 128
19 701750470029 128
20 701790470012 128
21 701860280028 128
22 701950340024 128
23 702140270063 128
24 702140410061 128
25 702470440015 128
26 702510110017 128
27 702630600025 128
28 702800530017 128
29 702800600016 128
30 702970120037 128
31 703290450025 128
32 703480330115 128
33 703620260038 128
34 703720350022 128
35 703740330010 128
36 703760300019 128
37 704370650012 128
38 704410120049 128
39 704460370015 128
40 704650140053 128
41 705050370023 128
42 705050440022 128
43 705150120020 128
44 705300280039 128
45 705330450013 128
46 705380510029 128
47 705420300016 128
48 705440380013 128
49 705480280016 128
50 705560320026 128
HC-051I 08:42 Tuesday, June 24, 2003 2
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
700020160021 700020160244 1 MVIS
700030270103 700030270153 1 MVIS
700160460057 700160460349 3 EROM
700160460356 8 PMED
700250310022 700250310055 1 MVIS
700250310062 8 PMED
700400180023 700400180068 8 PMED
700600150036 700600150096 8 PMED
700600150109 8 PMED
700600150123 8 PMED
700600150130 8 PMED
700600150178 8 PMED
700600150185 8 PMED
700650190014 700650190159 8 PMED
700650190166 8 PMED
700650190197 8 PMED
700650190217 1 MVIS
700650190231 8 PMED
700650190248 8 PMED
700650190286 8 PMED
700650190293 8 PMED
700650190306 8 PMED
700710470139 700710470131 1 MVIS
700710470148 1 MVIS
700710470186 8 PMED
700710470244 8 PMED
700710470282 8 PMED
700710470302 8 PMED
700710470220 700710470213 1 MVIS
700710470268 8 PMED
700710470275 8 PMED
700840260044 700840260136 1 MVIS
700840260198 8 PMED
700840260287 8 PMED
700920230022 700920230207 1 MVIS
700920230214 1 MVIS
700920230221 1 MVIS
700920230238 8 PMED
700920230269 8 PMED
HC-051I 08:42 Tuesday, June 24, 2003 3
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
700920230072 700920230276 1 MVIS
700920230283 1 MVIS
700920230290 8 PMED
700920230303 8 PMED
700920230310 8 PMED
700920230327 8 PMED
701040310031 701040310062 1 MVIS
701040310079 8 PMED
701040310093 1 MVIS
701040310106 8 PMED
701290210090 701290210146 1 MVIS
701290210153 1 MVIS
701290210160 1 MVIS
701290210177 1 MVIS
701290210184 1 MVIS
701290210191 8 PMED
701290210204 8 PMED
701290210211 8 PMED
701290210228 8 PMED
701750470029 701750470078 1 MVIS
701750470085 1 MVIS
701750470092 1 MVIS
701750470105 1 MVIS
701750470112 1 MVIS
701750470129 1 MVIS
701750470136 8 PMED
701750470143 8 PMED
701750470150 8 PMED
701790470012 701790470202 8 PMED
701950340024 701950340049 8 PMED
701950340056 8 PMED
702140270063 702140270133 1 MVIS
702140270157 8 PMED
702140410061 702140410133 1 MVIS
702510110017 702510110257 1 MVIS
702510110264 1 MVIS
HC-051I 08:42 Tuesday, June 24, 2003 4
Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 700020160021 700020160244 1 MVIS
2 700030270103 700030270153 1 MVIS
3 700160460057 700160460349 3 EROM
4 700160460057 700160460356 8 PMED
5 700250310022 700250310055 1 MVIS
6 700250310022 700250310062 8 PMED
7 700400180023 700400180068 8 PMED
8 700600150036 700600150096 8 PMED
9 700600150036 700600150109 8 PMED
10 700600150036 700600150123 8 PMED
11 700600150036 700600150130 8 PMED
12 700600150036 700600150178 8 PMED
13 700600150036 700600150185 8 PMED
14 700650190014 700650190159 8 PMED
15 700650190014 700650190166 8 PMED
16 700650190014 700650190197 8 PMED
17 700650190014 700650190217 1 MVIS
18 700650190014 700650190231 8 PMED
19 700650190014 700650190248 8 PMED
20 700650190014 700650190286 8 PMED
21 700650190014 700650190293 8 PMED
22 700650190014 700650190306 8 PMED
23 700710470139 700710470131 1 MVIS
24 700710470139 700710470148 1 MVIS
25 700710470139 700710470186 8 PMED
26 700710470220 700710470213 1 MVIS
27 700710470139 700710470244 8 PMED
28 700710470220 700710470268 8 PMED
29 700710470220 700710470275 8 PMED
30 700710470139 700710470282 8 PMED
31 700710470139 700710470302 8 PMED
32 700840260044 700840260136 1 MVIS
33 700840260044 700840260198 8 PMED
34 700840260044 700840260287 8 PMED
35 700920230022 700920230207 1 MVIS
36 700920230022 700920230214 1 MVIS
37 700920230022 700920230221 1 MVIS
38 700920230022 700920230238 8 PMED
39 700920230022 700920230269 8 PMED
40 700920230072 700920230276 1 MVIS
41 700920230072 700920230283 1 MVIS
42 700920230072 700920230290 8 PMED
43 700920230072 700920230303 8 PMED
44 700920230072 700920230310 8 PMED
45 700920230072 700920230327 8 PMED
46 701040310031 701040310062 1 MVIS
47 701040310031 701040310079 8 PMED
48 701040310031 701040310093 1 MVIS
49 701040310031 701040310106 8 PMED
50 701290210090 701290210146 1 MVIS
HC-051I 08:42 Tuesday, June 24, 2003 5
Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 700020160244 1 MVIS
2 700030270153 1 MVIS
3 700160460349 3 EROM
4 700160460356 8 PMED
5 700250310055 1 MVIS
6 700250310062 8 PMED
7 700400180068 8 PMED
8 700600150096 8 PMED
9 700600150109 8 PMED
10 700600150123 8 PMED
11 700600150130 8 PMED
12 700600150178 8 PMED
13 700600150185 8 PMED
14 700650190159 8 PMED
15 700650190166 8 PMED
16 700650190197 8 PMED
17 700650190217 1 MVIS
18 700650190231 8 PMED
19 700650190248 8 PMED
20 700650190286 8 PMED
21 700650190293 8 PMED
22 700650190306 8 PMED
23 700710470131 1 MVIS
24 700710470148 1 MVIS
25 700710470186 8 PMED
26 700710470213 1 MVIS
27 700710470244 8 PMED
28 700710470268 8 PMED
29 700710470275 8 PMED
30 700710470282 8 PMED
31 700710470302 8 PMED
32 700840260136 1 MVIS
33 700840260198 8 PMED
34 700840260287 8 PMED
35 700920230207 1 MVIS
36 700920230214 1 MVIS
37 700920230221 1 MVIS
38 700920230238 8 PMED
39 700920230269 8 PMED
40 700920230276 1 MVIS
41 700920230283 1 MVIS
42 700920230290 8 PMED
43 700920230303 8 PMED
44 700920230310 8 PMED
45 700920230327 8 PMED
46 701040310062 1 MVIS
47 701040310079 8 PMED
48 701040310093 1 MVIS
49 701040310106 8 PMED
50 701290210146 1 MVIS
HC-051I 08:42 Tuesday, June 24, 2003 6
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-051A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
700160460356 700160460356001 ALBUTEROL INHALER 21.50 2266.249744
700160460356002 ALBUTEROL INHALER 21.50 2266.249744
700250310062 700250310062001 ALBUTEROL SULFATE 3.83 4141.903714
700400180068 700400180068001 ALBUTEROL 21.41 21060.815185
700600150096 700600150096001 FLOVENT 46.94 33813.691425
700600150096002 FLOVENT 46.94 33813.691425
700600150096003 FLOVENT 46.94 33813.691425
700600150096004 FLOVENT 46.94 33813.691425
700600150096005 FLOVENT 46.94 33813.691425
700600150109 700600150109001 ALBUTEROL 21.43 33813.691425
700600150123 700600150123001 FLOVENT 198.88 33813.691425
700600150130 700600150130001 ALBUTEROL 21.41 33813.691425
700600150178 700600150178001 FLOVENT 46.94 33813.691425
700600150185 700600150185001 ALBUTEROL 21.41 33813.691425
700650190159 700650190159001 CLARITIN 58.96 8288.535695
700650190166 700650190166001 ALBUTEROL 6.37 8288.535695
700650190166002 ALBUTEROL 6.37 8288.535695
700650190197 700650190197001 VERAPAMIL HCL 20.68 8288.535695
700650190197002 VERAPAMIL HCL 20.68 8288.535695
700650190231 700650190231001 ALBUTEROL 17.99 8288.535695
700650190231002 ALBUTEROL 17.99 8288.535695
700650190231003 ALBUTEROL 16.64 8288.535695
700650190231004 ALBUTEROL 16.64 8288.535695
700650190248 700650190248001 FLOVENT 54.59 8288.535695
700650190248002 FLOVENT 54.59 8288.535695
700650190248003 FLOVENT 54.59 8288.535695
700650190248004 FLOVENT 54.59 8288.535695
700650190286 700650190286001 ALBUTEROL 21.41 8288.535695
700650190293 700650190293001 CLARITIN 62.71 8288.535695
700650190306 700650190306001 VERAPAMIL HCL 76.20 8288.535695
700650190306002 VERAPAMIL HCL 76.20 8288.535695
700710470186 700710470186001 SEREVENT DISKUS 63.44 9015.740428
HC-051I 08:42 Tuesday, June 24, 2003 7
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-051A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
700710470186 700710470186002 SEREVENT DISKUS 63.44 9015.740428
700710470244 700710470244001 SEREVENT DISKUS 63.44 9015.740428
700710470268 700710470268001 AMOXIL 10.00 9015.740428
700710470275 700710470275001 PEDIAPRED 22.98 9015.740428
700710470282 700710470282001 ALBUTEROL 18.99 9015.740428
700710470302 700710470302001 CLARITIN 59.11 9015.740428
700840260198 700840260198001 AEROBID 67.01 27728.284639
700840260287 700840260287001 FLUNISOLIDE 9.57 27728.284639
700840260287002 FLUNISOLIDE 9.57 27728.284639
700920230238 700920230238001 VENTOLIN 7.23 5006.337153
700920230238002 VENTOLIN 7.23 5006.337153
700920230269 700920230269001 VENTOLIN 7.23 5006.337153
700920230290 700920230290001 PREDISONE 10.88 5006.337153
700920230303 700920230303001 AEROCHAMBER 30.12 5006.337153
700920230310 700920230310001 VENTOLIN 64.24 5006.337153
700920230310002 VENTOLIN 64.24 5006.337153
700920230327 700920230327001 AZMACORT 49.09 5006.337153
701040310079 701040310079001 ALBUTEROL 17.44 4142.210684
701040310106 701040310106001 ALBUTEROL 17.44 4142.210684
701290210191 701290210191001 PREDNISOLONE 7.77 7299.943487
701290210191002 PREDNISOLONE 7.77 7299.943487
701290210204 701290210204001 SINGULAIR (UNIT OF USE) 84.33 7299.943487
701290210211 701290210211001 BECLOVENT 134.82 7299.943487
701290210211002 BECLOVENT 134.82 7299.943487
701290210211003 BECLOVENT 134.82 7299.943487
701290210228 701290210228001 NEBULIZER 77.38 7299.943487
701750470136 701750470136001 FLOVENT 99.44 4668.209540
701750470136002 FLOVENT 99.44 4668.209540
HC-051I 08:42 Tuesday, June 24, 2003 8
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-051A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
701750470143 701750470143001 ALBUTEROL 9.65 4668.209540
701750470150 701750470150001 FLOVENT 46.94 4668.209540
701750470150002 FLOVENT 46.94 4668.209540
701790470202 701790470202001 FLOVENT 55.29 11329.944540
701790470202002 FLOVENT 55.29 11329.944540
701790470202003 FLOVENT 55.29 11329.944540
701790470202004 FLOVENT 55.29 11329.944540
701790470202005 FLOVENT 55.29 11329.944540
701790470202006 FLOVENT 55.29 11329.944540
701950340049 701950340049001 ASACOL 123.54 22178.852828
701950340049002 ASACOL 123.54 22178.852828
701950340049003 ASACOL 123.54 22178.852828
701950340056 701950340056001 ASACOL 117.77 22178.852828
701950340056002 ASACOL 117.77 22178.852828
702140270157 702140270157001 VENTOLIN 64.24 18941.563378
702140270157002 VENTOLIN 64.24 18941.563378
702630600104 702630600104001 ALBUTEROL 17.50 5284.005215
702630600104002 ALBUTEROL 17.50 5284.005215
702630600104003 ALBUTEROL 17.50 5284.005215
702630600104004 ALBUTEROL 17.50 5284.005215
702630600104005 ALBUTEROL 17.50 5284.005215
702630600128 702630600128001 ALBUTEROL 17.50 5284.005215
702630600142 702630600142001 AZMACORT 55.35 5284.005215
702630600142002 AZMACORT 55.35 5284.005215
702970120225 702970120225001 ACCOLATE 59.34 15096.510751
702970120232 702970120232001 PULMICORT 217.02 15096.510751
702970120249 702970120249001 ZYRTEC 101.39 15096.510751
702970120249002 ZYRTEC 54.44 15096.510751
702970120249003 ZYRTEC 101.39 15096.510751
702970120249004 ZYRTEC 101.39 15096.510751
702970120249005 ZYRTEC 54.44 15096.510751
702970120256 702970120256001 VENTOLIN 29.02 15096.510751
702970120263 702970120263001 PREDNISONE 8.84 15096.510751
702970120263002 PREDNISONE 8.84 15096.510751
702970120270 702970120270001 METHYLPREDNISOLONE (UNIT OF USE) 13.24 15096.510751
HC-051I 08:42 Tuesday, June 24, 2003 9
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-051A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
702970120294 702970120294001 ZYRTEC 102.39 15096.510751
702970120294002 ZYRTEC 102.39 15096.510751
702970120307 702970120307001 ALLEGRA 103.38 15096.510751
702970120307002 ALLEGRA 103.38 15096.510751
702970120314 702970120314001 ALBUTEROL 11.00 15096.510751
703480330225 703480330225001 KIE 11.97 18679.846555
703480330232 703480330232001 VENTOLIN 29.02 18679.846555
703620260108 703620260108001 MINOCYCLINE 10.00 9696.909242
703740330227 703740330227001 KIE 11.97 9138.998321
703740330234 703740330234001 DESMOPRESSIN ACETATE 98.02 9138.998321
703740330234002 DESMOPRESSIN ACETATE 98.02 9138.998321
703740330234003 DESMOPRESSIN ACETATE 98.02 9138.998321
703740330234004 DESMOPRESSIN ACETATE 98.02 9138.998321
703740330234005 DESMOPRESSIN ACETATE 98.02 9138.998321
703760300132 703760300132001 NASACORT 43.64 8670.962915
704370650084 704370650084001 CLARITIN 69.34 11691.009918
704370650084002 CLARITIN 69.34 11691.009918
704370650084003 CLARITIN 69.34 11691.009918
704370650091 704370650091001 VANCENASE AQ DOUBLE STRENGTH 55.78 11691.009918
704370650091002 VANCENASE AQ DOUBLE STRENGTH 55.78 11691.009918
704370650104 704370650104001 ALBUTEROL 21.41 11691.009918
704370650142 704370650142001 ALBUTEROL 21.41 11691.009918
704370650166 704370650166001 CLARITIN 69.34 11691.009918
704370650166002 CLARITIN 69.34 11691.009918
704370650166003 CLARITIN 69.34 11691.009918
704370650180 704370650180001 VANCENASE AQ DOUBLE STRENGTH 55.78 11691.009918
704370650180002 VANCENASE AQ DOUBLE STRENGTH 55.78 11691.009918
704410120090 704410120090001 ROBITUSSIN 24.19 3520.146263
704460370405 704460370405001 VANCERIL 75.73 8776.359930
704650140676 704650140676001 MAXAIR 105.41 4373.124642
704650140676002 MAXAIR 105.41 4373.124642
704650140676003 MAXAIR 105.41 4373.124642
HC-051I 08:42 Tuesday, June 24, 2003 10
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-051A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
704650140676 704650140676004 MAXAIR 105.41 4373.124642
704650140950 704650140950001 ALBUTEROL INHALER 17.50 4373.124642
704650140950002 ALBUTEROL INHALER 17.50 4373.124642
704650140950003 ALBUTEROL INHALER 17.50 4373.124642
704650140950004 ALBUTEROL INHALER 17.50 4373.124642
705050370099 705050370099001 ALBUTEROL 9.97 11276.406996
705050370140 705050370140001 ALBUTEROL 9.97 11276.406996
705050370157 705050370157001 ALBUTEROL INHALER 19.79 11276.406996
705050440037 705050440037001 ALBUTEROL 9.97 11276.406996
705050440051 705050440051001 ALBUTEROL 9.97 11276.406996
705050440068 705050440068001 ALBUTEROL INHALER 19.79 11276.406996
705300280084 705300280084001 PROVENTIL HFA (M.D.I.) 27.62 7789.910172
705300280084002 PROVENTIL HFA (M.D.I.) 26.75 7789.910172
705300280084003 PROVENTIL HFA (M.D.I.) 27.62 7789.910172
705300280084004 PROVENTIL HFA (M.D.I.) 26.75 7789.910172
705300280091 705300280091001 ACCOLATE 54.59 7789.910172
705300280091002 ACCOLATE 54.59 7789.910172
705300280159 705300280159001 ACCOLATE 54.59 7789.910172
705300280166 705300280166001 PROVENTIL HFA (M.D.I.) 27.62 7789.910172
705300280166002 PROVENTIL HFA (M.D.I.) 27.62 7789.910172
705300280166003 PROVENTIL HFA (M.D.I.) 28.15 7789.910172
705330450121 705330450121001 AEROBID 67.01 5224.833045
705330450121002 AEROBID 67.01 5224.833045
705330450138 705330450138001 ALBUTEROL 17.99 5224.833045
705330450138002 ALBUTEROL 17.99 5224.833045
705330450145 705330450145001 ALBUTEROL 31.74 5224.833045
705330450145002 ALBUTEROL 31.74 5224.833045
705380510112 705380510112001 ALBUTEROL SULFATE 10.47 10215.233912
705380510136 705380510136001 VANCENASE AQ 66.06 10215.233912
705380510136002 VANCENASE AQ 66.06 10215.233912
705380510143 705380510143001 ALBUTEROL 21.41 10215.233912
705380510143002 ALBUTEROL 21.41 10215.233912
HC-051I 08:42 Tuesday, June 24, 2003 11
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-051A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
705380510143 705380510143003 ALBUTEROL 21.41 10215.233912
705420300028 705420300028001 CVS ALLERGY 2.19 13917.850228
705420300059 705420300059001 ALBUTEROL 21.41 13917.850228
705480280394 705480280394001 ESTRATAB 16.78 13477.023448
705480280438 705480280438001 SEREVENT 20.00 13477.023448
705480280438002 SEREVENT 20.00 13477.023448
705480280445 705480280445001 BECLOVENT 44.94 13477.023448
705480280445002 BECLOVENT 44.94 13477.023448
705480280445003 BECLOVENT 44.94 13477.023448
705480280445004 BECLOVENT 44.94 13477.023448
705480280445005 BECLOVENT 44.94 13477.023448
705480280445006 BECLOVENT 44.94 13477.023448
705480280534 705480280534001 SEREVENT 60.68 13477.023448
705480280558 705480280558001 VANCERIL 43.00 13477.023448
705480280623 705480280623001 VANCERIL 43.00 13477.023448
705480280623002 VANCERIL 43.00 13477.023448
705700290103 705700290103001 Z-PAK 37.27 26722.792484
705700290110 705700290110001 CLARITIN 69.34 26722.792484
705700290127 705700290127001 RELION/NOVO 15.00 26722.792484
705720660177 705720660177001 ALBUTEROL SULFATE 16.93 14375.567988
705750220120 705750220120001 AEROBID 58.57 6414.816769
705750220137 705750220137001 SEREVENT 58.42 6414.816769
705770170109 705770170109001 ALBUTEROL (REFILL) 39.58 11540.793201
705770170123 705770170123001 VANCERIL 38.99 11540.793201
705770170130 705770170130001 ALBUTEROL 21.41 11540.793201
705770170154 705770170154001 VANCERIL 40.09 11540.793201
705770170154002 VANCERIL 40.54 11540.793201
705770170154003 VANCERIL 40.54 11540.793201
705770170154004 VANCERIL 40.09 11540.793201
705770170161 705770170161001 SEREVENT 63.42 11540.793201
HC-051I 08:42 Tuesday, June 24, 2003 12
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-051A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
705770170161 705770170161002 SEREVENT 63.42 11540.793201
705770170161003 SEREVENT 63.42 11540.793201
705770170161004 SEREVENT 63.42 11540.793201
705770170192 705770170192001 SEREVENT 62.73 11540.793201
705770170192002 SEREVENT 62.73 11540.793201
705770170205 705770170205001 FLONASE 50.99 11540.793201
705770170205002 FLONASE 48.68 11540.793201
705770170212 705770170212001 VANCERIL 40.41 11540.793201
705770170212002 VANCERIL 40.41 11540.793201
705770170229 705770170229001 ALBUTEROL 21.41 11540.793201
705820230416 705820230416001 SINGULAIR (UNIT OF USE) 66.23 16052.116072
705820230416002 SINGULAIR (UNIT OF USE) 66.23 16052.116072
705820230416003 SINGULAIR (UNIT OF USE) 66.23 16052.116072
705820230416004 SINGULAIR (UNIT OF USE) 188.01 16052.116072
705820230423 705820230423001 COMBIVENT 37.02 16052.116072
705820230423002 COMBIVENT 37.02 16052.116072
705820230574 705820230574001 SINGULAIR (UNIT OF USE) 202.11 16052.116072
705820230574002 SINGULAIR (UNIT OF USE) 202.11 16052.116072
705820230574003 SINGULAIR (UNIT OF USE) 202.11 16052.116072
705820230574004 SINGULAIR (UNIT OF USE) 202.11 16052.116072
705820230581 705820230581001 COMBIVENT 37.02 16052.116072
705820230581002 COMBIVENT 37.66 16052.116072
705820230581003 COMBIVENT 37.66 16052.116072
705820230581004 COMBIVENT 37.66 16052.116072
705820230790 705820230790001 PREDNISONE 6.05 16052.116072
705820230790002 PREDNISONE 6.05 16052.116072
705820230790003 PREDNISONE 6.05 16052.116072
705820230834 705820230834001 SINGULAIR (UNIT OF USE) 207.69 16052.116072
705820230834002 SINGULAIR (UNIT OF USE) 207.69 16052.116072
705820230834003 SINGULAIR (UNIT OF USE) 207.69 16052.116072
705820230834004 SINGULAIR (UNIT OF USE) 207.69 16052.116072
705820230841 705820230841001 COMBIVENT 37.66 16052.116072
705820230841002 COMBIVENT 37.66 16052.116072
705820230841003 COMBIVENT 37.66 16052.116072
705820230841004 COMBIVENT 37.66 16052.116072
705960430170 705960430170001 PREDNISONE 3.90 659.650918
HC-051I 08:42 Tuesday, June 24, 2003 13
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-051A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
705960430187 705960430187001 ALBUTEROL 16.37 659.650918
705960430194 705960430194001 FLOVENT 59.13 659.650918
706030191334 706030191334001 ALBUTEROL 57.78 8239.521469
706120160040 706120160040001 ALBUTEROL 8.94 10341.586039
706120160064 706120160064001 ALBUTEROL 8.94 10341.586039
706120160064002 ALBUTEROL 8.94 10341.586039
706120160064003 ALBUTEROL 8.94 10341.586039
706130120067 706130120067001 ALBUTEROL 42.88 15913.710072
706220240575 706220240575001 FLOVENT 63.57 17318.346064
706220240582 706220240582001 ALBUTEROL 28.97 17318.346064
706220240828 706220240828001 ALLEGRA 49.44 17318.346064
706220240866 706220240866001 FLOVENT 63.57 17318.346064
706240310170 706240310170001 ALBUTEROL 21.41 6983.167036
706240310170002 ALBUTEROL 21.41 6983.167036
706240310170003 ALBUTEROL 21.41 6983.167036
706240310187 706240310187001 AYR SALINE 3.55 6983.167036
706240310187002 AYR SALINE 3.55 6983.167036
706240310187003 AYR SALINE 3.55 6983.167036
706440430059 706440430059001 DIFIL G 13.89 6825.819171
706440430059002 DIFIL G 13.89 6825.819171
706440430059003 DIFIL G 13.89 6825.819171
706440430073 706440430073001 PROPOXY-N W/APAP 15.19 6825.819171
706440430073002 PROPOXY-N W/APAP 15.19 6825.819171
706440430080 706440430080001 PROMETHAZINE DM 3.49 6825.819171
706440430080002 PROMETHAZINE DM 3.49 6825.819171
706440430131 706440430131001 PROMETHAZINE DM 3.49 6825.819171
706440430148 706440430148001 CEFTIN 65.56 6825.819171
706460490186 706460490186001 ALBUTEROL 10.31 7020.320170
706470170923 706470170923001 ALBUTEROL 85.64 9712.489314
706470170930 706470170930001 FLOVENT 55.29 9712.489314
HC-051I 08:42 Tuesday, June 24, 2003 14
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-051A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
706470170961 706470170961001 PROVENTIL 30.28 9712.489314
706470170961002 PROVENTIL 30.28 9712.489314
706470171084 706470171084001 ALBUTEROL 85.64 9712.489314
706470171084002 ALBUTEROL 85.64 9712.489314
706500690112 706500690112001 PROVENTIL 32.66 8299.989960
706780310123 706780310123001 VENTOLIN 7.23 21135.388243
706920430087 706920430087001 PROVENTIL 57.27 11407.204417
706970200490 706970200490001 PROVENTIL 31.14 6486.389241
706970200490002 PROVENTIL 31.14 6486.389241
706970200490003 PROVENTIL 31.14 6486.389241
706970200490004 PROVENTIL 31.14 6486.389241
706970200503 706970200503001 UNIPHYL 6.98 6486.389241
706970200503002 UNIPHYL 6.98 6486.389241
706970200503003 UNIPHYL 6.98 6486.389241
706970200692 706970200692001 UNIPHYL 6.98 6486.389241
706970200692002 UNIPHYL 6.98 6486.389241
706970200692003 UNIPHYL 6.98 6486.389241
706970200692004 UNIPHYL 6.98 6486.389241
706970200832 706970200832001 PROVENTIL 31.14 6486.389241
706970200832002 PROVENTIL 31.14 6486.389241
706970200849 706970200849001 UNIPHYL 6.98 6486.389241
706970200849002 UNIPHYL 6.98 6486.389241
706970200849003 UNIPHYL 6.98 6486.389241
706970200849004 UNIPHYL 6.98 6486.389241
707110170167 707110170167001 SEREVENT 58.71 16519.345983
707110170174 707110170174001 FLOVENT 54.74 16519.345983
707110170181 707110170181001 ALBUTEROL 21.41 16519.345983
707110170181002 ALBUTEROL 21.41 16519.345983
707110170198 707110170198001 PREDNISONE 7.70 16519.345983
707110170403 707110170403001 SEREVENT 58.71 16519.345983
707110170403002 SEREVENT 58.71 16519.345983
707110170410 707110170410001 FLOVENT 54.74 16519.345983
707110170410002 FLOVENT 56.85 16519.345983
HC-051I 08:42 Tuesday, June 24, 2003 15
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-051A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
707110170427 707110170427001 ALBUTEROL 21.41 16519.345983
707110170427002 ALBUTEROL 21.41 16519.345983
707110170509 707110170509001 SEREVENT 60.99 16519.345983
707110170516 707110170516001 FLOVENT 56.85 16519.345983
707110170523 707110170523001 ALBUTEROL 21.41 16519.345983
707110170530 707110170530001 PREDNISONE 7.70 16519.345983
707140430308 707140430308001 ALBUTEROL SULFATE 13.11 14053.576563
707140430346 707140430346001 FLOVENT 54.34 14053.576563
707140430346002 FLOVENT 54.34 14053.576563
707140430346003 FLOVENT 54.34 14053.576563
707140430606 707140430606001 FLOVENT 56.45 14053.576563
707140430606002 FLOVENT 54.34 14053.576563
HC-051I 08:42 Tuesday, June 24, 2003 16
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
The MEANS Procedure
Analysis Variable : RXXP00X SUM OF PAYMENTS RXSF00X-RXOU00X(IMPUTED)
N Sum
--------------------
6307 273294.93
--------------------
HC-051I 08:42 Tuesday, June 24, 2003 17
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP00X SUM OF PAYMENTS RXSF00X-RXOU00X(IMPUTED)
N Sum
--------------------
6307 3239010632
--------------------
1 The SAS System 08:46 Tuesday, June 24, 2003
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC/AHRQ, Site 0038838053.
NOTE: This session is executing on the WIN_95 platform.
NOTE: SAS initialization used:
real time 5.16 seconds
1
2 OPTIONS LS=132 PS=59;
3
4 TITLE1 "HC-051I";
5 TITLE2 'Sample SAS Job for Example C';
6
7 LIBNAME IN 'C:\DATA';
NOTE: Directory for library IN contains files of mixed engine types.
NOTE: Libref IN was successfully assigned as follows:
Engine: V8
Physical Name: C:\DATA
8
9 *************************************************************************************
10 * Calculate the expenditures for medical visits associated with asthma.
11 *************************************************************************************;
12 PROC FORMAT;
13 VALUE EVENTYPE
14 1 = "1 MVIS"
15 2 = "2 OPAT"
16 3 = "3 EROM"
17 4 = "4 STAZ"
18 5 = "5 DVIS"
19 6 = "6 OMED"
20 7 = "7 HVIS"
21 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
22 RUN;
NOTE: PROCEDURE FORMAT used:
real time 0.33 seconds
23
24 *-----------------------------------------------------------------------------------
25 * Get conditions records coded as asthma.
26 *-----------------------------------------------------------------------------------;
27 DATA ASCONDS;
28 SET IN.H52 (KEEP=CONDIDX CCCODEX);
29 IF CCCODEX="128";
30 RUN;
NOTE: There were 72624 observations read from the data set IN.H52.
NOTE: The data set WORK.ASCONDS has 1156 observations and 2 variables.
NOTE: DATA statement used:
real time 13.84 seconds
2 The SAS System 08:46 Tuesday, June 24, 2003
31
32 *------------------------------------------------------------------------------------
33 * Get the events linked to each of the asthma condition records.
34 *------------------------------------------------------------------------------------;
35 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 1156 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1156 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.22 seconds
36
37 proc print data=asconds (obs=50);
38 title3 "sample print of work.asconds - sorted by condidx";
39 title4 "COND (HC-052) records where cccodex=128";
40 run;
NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used:
real time 1.15 seconds
41
42 PROC SORT DATA=IN.H51IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 217414 observations read from the data set IN.H51IF1.
NOTE: The data set WORK.CLNK has 217414 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 12.90 seconds
43
44 DATA ASCLNKS;
45 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
46 ASCONDS(IN=INASCOND KEEP=CONDIDX);
47 BY CONDIDX;
48 IF INCLNK & INASCOND;
49 RUN;
NOTE: There were 217414 observations read from the data set WORK.CLNK.
NOTE: There were 1156 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 4737 observations and 3 variables.
NOTE: DATA statement used:
real time 1.25 seconds
50
51 proc print data=asclnks (obs=75);
52 by condidx;
53 id condidx;
54 format eventype eventype.;
55 title3 "sample print of work.asclnks - sorted by condidx";
56 title4 "events linked to asthma condition records";
57 run;
3 The SAS System 08:46 Tuesday, June 24, 2003
NOTE: There were 75 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used:
real time 0.44 seconds
58
59 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 4737 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 4737 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.04 seconds
60
61 proc print data=asclnks (obs=50);
62 format eventype eventype.;
63 title3 "sample print of work.asclnks - sorted by evntidx";
64 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used:
real time 0.00 seconds
65
66 DATA ASCLNKS;
67 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
68 BY EVNTIDX;
69 IF FIRST.EVNTIDX;
70 RUN;
NOTE: There were 4737 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 4712 observations and 2 variables.
NOTE: DATA statement used:
real time 0.04 seconds
71
72 proc print data=asclnks (obs=50);
73 format eventype eventype.;
74 title3 "sample print of unique evntidxs from work.asclnks";
75 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used:
real time 0.00 seconds
76
77 *--------------------------------------------------------------------------------------------
78 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
79 *--------------------------------------------------------------------------------------------;
80 DATA MVIS;
4 The SAS System 08:46 Tuesday, June 24, 2003
81 SET IN.H51G (KEEP=EVNTIDX PERWT00F SEETLKPV OBXP00X);
82 IF PERWT00F > 0 & SEETLKPV NE 2;
83 RUN;
NOTE: There were 102530 observations read from the data set IN.H51G.
NOTE: The data set WORK.MVIS has 98816 observations and 4 variables.
NOTE: DATA statement used:
real time 14.76 seconds
84
85 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 98816 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 98816 observations and 4 variables.
NOTE: PROCEDURE SORT used:
real time 1.53 seconds
86
87 *-------------------------------------------------------------------------------------
88 * Identify MVIS events which were for asthma.
89 *-------------------------------------------------------------------------------------;
90 DATA ASMVIS;
91 MERGE ASCLNKS (IN=INASCLNK)
92 MVIS (IN=INMVIS);
93 BY EVNTIDX;
94 IF INASCLNK & INMVIS;
95 RUN;
NOTE: There were 4712 observations read from the data set WORK.ASCLNKS.
NOTE: There were 98816 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1509 observations and 5 variables.
NOTE: DATA statement used:
real time 0.44 seconds
96
97 proc print data=asmvis (obs=50);
98 format eventype eventype.;
99 title3 "sample print of work.asmvis";
100 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-051G) events";
101 run;
NOTE: There were 50 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: PROCEDURE PRINT used:
real time 0.04 seconds
102
103 PROC MEANS DATA=ASMVIS N SUM;
104 VAR OBXP00X;
105 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
106 RUN;
NOTE: There were 1509 observations read from the data set WORK.ASMVIS.
5 The SAS System 08:46 Tuesday, June 24, 2003
NOTE: The PROCEDURE MEANS printed page 7.
NOTE: PROCEDURE MEANS used:
real time 0.38 seconds
107
108 PROC MEANS DATA=ASMVIS SUM;
109 VAR OBXP00X;
110 WEIGHT PERWT00F;
111 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
112 TITLE5 "Weighted";
113 RUN;
NOTE: There were 1509 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 8.
NOTE: PROCEDURE MEANS used:
real time 0.00 seconds
114
115
116
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 53.66 seconds
HC-051I 08:46 Tuesday, June 24, 2003 1
Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx
COND (HC-052) records where cccodex=128
Obs CONDIDX CCCODEX
1 700020160021 128
2 700030270103 128
3 700160460057 128
4 700250310022 128
5 700400180023 128
6 700600150036 128
7 700620410027 128
8 700650190014 128
9 700710230197 128
10 700710470076 128
11 700710470139 128
12 700710470220 128
13 700840260044 128
14 700920230022 128
15 700920230072 128
16 701040310031 128
17 701070510018 128
18 701290210090 128
19 701750470029 128
20 701790470012 128
21 701860280028 128
22 701950340024 128
23 702140270063 128
24 702140410061 128
25 702470440015 128
26 702510110017 128
27 702630600025 128
28 702800530017 128
29 702800600016 128
30 702970120037 128
31 703290450025 128
32 703480330115 128
33 703620260038 128
34 703720350022 128
35 703740330010 128
36 703760300019 128
37 704370650012 128
38 704410120049 128
39 704460370015 128
40 704650140053 128
41 705050370023 128
42 705050440022 128
43 705150120020 128
44 705300280039 128
45 705330450013 128
46 705380510029 128
47 705420300016 128
48 705440380013 128
49 705480280016 128
50 705560320026 128
HC-051I 08:46 Tuesday, June 24, 2003 2
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
700020160021 700020160244 1 MVIS
700030270103 700030270153 1 MVIS
700160460057 700160460349 3 EROM
700160460356 8 PMED
700250310022 700250310055 1 MVIS
700250310062 8 PMED
700400180023 700400180068 8 PMED
700600150036 700600150096 8 PMED
700600150109 8 PMED
700600150123 8 PMED
700600150130 8 PMED
700600150178 8 PMED
700600150185 8 PMED
700650190014 700650190159 8 PMED
700650190166 8 PMED
700650190197 8 PMED
700650190217 1 MVIS
700650190231 8 PMED
700650190248 8 PMED
700650190286 8 PMED
700650190293 8 PMED
700650190306 8 PMED
700710470139 700710470131 1 MVIS
700710470148 1 MVIS
700710470186 8 PMED
700710470244 8 PMED
700710470282 8 PMED
700710470302 8 PMED
700710470220 700710470213 1 MVIS
700710470268 8 PMED
700710470275 8 PMED
700840260044 700840260136 1 MVIS
700840260198 8 PMED
700840260287 8 PMED
700920230022 700920230207 1 MVIS
700920230214 1 MVIS
700920230221 1 MVIS
700920230238 8 PMED
700920230269 8 PMED
HC-051I 08:46 Tuesday, June 24, 2003 3
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
700920230072 700920230276 1 MVIS
700920230283 1 MVIS
700920230290 8 PMED
700920230303 8 PMED
700920230310 8 PMED
700920230327 8 PMED
701040310031 701040310062 1 MVIS
701040310079 8 PMED
701040310093 1 MVIS
701040310106 8 PMED
701290210090 701290210146 1 MVIS
701290210153 1 MVIS
701290210160 1 MVIS
701290210177 1 MVIS
701290210184 1 MVIS
701290210191 8 PMED
701290210204 8 PMED
701290210211 8 PMED
701290210228 8 PMED
701750470029 701750470078 1 MVIS
701750470085 1 MVIS
701750470092 1 MVIS
701750470105 1 MVIS
701750470112 1 MVIS
701750470129 1 MVIS
701750470136 8 PMED
701750470143 8 PMED
701750470150 8 PMED
701790470012 701790470202 8 PMED
701950340024 701950340049 8 PMED
701950340056 8 PMED
702140270063 702140270133 1 MVIS
702140270157 8 PMED
702140410061 702140410133 1 MVIS
702510110017 702510110257 1 MVIS
702510110264 1 MVIS
HC-051I 08:46 Tuesday, June 24, 2003 4
Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 700020160021 700020160244 1 MVIS
2 700030270103 700030270153 1 MVIS
3 700160460057 700160460349 3 EROM
4 700160460057 700160460356 8 PMED
5 700250310022 700250310055 1 MVIS
6 700250310022 700250310062 8 PMED
7 700400180023 700400180068 8 PMED
8 700600150036 700600150096 8 PMED
9 700600150036 700600150109 8 PMED
10 700600150036 700600150123 8 PMED
11 700600150036 700600150130 8 PMED
12 700600150036 700600150178 8 PMED
13 700600150036 700600150185 8 PMED
14 700650190014 700650190159 8 PMED
15 700650190014 700650190166 8 PMED
16 700650190014 700650190197 8 PMED
17 700650190014 700650190217 1 MVIS
18 700650190014 700650190231 8 PMED
19 700650190014 700650190248 8 PMED
20 700650190014 700650190286 8 PMED
21 700650190014 700650190293 8 PMED
22 700650190014 700650190306 8 PMED
23 700710470139 700710470131 1 MVIS
24 700710470139 700710470148 1 MVIS
25 700710470139 700710470186 8 PMED
26 700710470220 700710470213 1 MVIS
27 700710470139 700710470244 8 PMED
28 700710470220 700710470268 8 PMED
29 700710470220 700710470275 8 PMED
30 700710470139 700710470282 8 PMED
31 700710470139 700710470302 8 PMED
32 700840260044 700840260136 1 MVIS
33 700840260044 700840260198 8 PMED
34 700840260044 700840260287 8 PMED
35 700920230022 700920230207 1 MVIS
36 700920230022 700920230214 1 MVIS
37 700920230022 700920230221 1 MVIS
38 700920230022 700920230238 8 PMED
39 700920230022 700920230269 8 PMED
40 700920230072 700920230276 1 MVIS
41 700920230072 700920230283 1 MVIS
42 700920230072 700920230290 8 PMED
43 700920230072 700920230303 8 PMED
44 700920230072 700920230310 8 PMED
45 700920230072 700920230327 8 PMED
46 701040310031 701040310062 1 MVIS
47 701040310031 701040310079 8 PMED
48 701040310031 701040310093 1 MVIS
49 701040310031 701040310106 8 PMED
50 701290210090 701290210146 1 MVIS
HC-051I 08:46 Tuesday, June 24, 2003 5
Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 700020160244 1 MVIS
2 700030270153 1 MVIS
3 700160460349 3 EROM
4 700160460356 8 PMED
5 700250310055 1 MVIS
6 700250310062 8 PMED
7 700400180068 8 PMED
8 700600150096 8 PMED
9 700600150109 8 PMED
10 700600150123 8 PMED
11 700600150130 8 PMED
12 700600150178 8 PMED
13 700600150185 8 PMED
14 700650190159 8 PMED
15 700650190166 8 PMED
16 700650190197 8 PMED
17 700650190217 1 MVIS
18 700650190231 8 PMED
19 700650190248 8 PMED
20 700650190286 8 PMED
21 700650190293 8 PMED
22 700650190306 8 PMED
23 700710470131 1 MVIS
24 700710470148 1 MVIS
25 700710470186 8 PMED
26 700710470213 1 MVIS
27 700710470244 8 PMED
28 700710470268 8 PMED
29 700710470275 8 PMED
30 700710470282 8 PMED
31 700710470302 8 PMED
32 700840260136 1 MVIS
33 700840260198 8 PMED
34 700840260287 8 PMED
35 700920230207 1 MVIS
36 700920230214 1 MVIS
37 700920230221 1 MVIS
38 700920230238 8 PMED
39 700920230269 8 PMED
40 700920230276 1 MVIS
41 700920230283 1 MVIS
42 700920230290 8 PMED
43 700920230303 8 PMED
44 700920230310 8 PMED
45 700920230327 8 PMED
46 701040310062 1 MVIS
47 701040310079 8 PMED
48 701040310093 1 MVIS
49 701040310106 8 PMED
50 701290210146 1 MVIS
HC-051I 08:46 Tuesday, June 24, 2003 6
Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-051G) events
Obs EVNTIDX EVENTYPE SEETLKPV OBXP00X PERWT00F
1 700020160244 1 MVIS 1 238.00 14309.47
2 700030270153 1 MVIS 1 49.40 11255.55
3 700250310055 1 MVIS 1 33.54 4141.90
4 700650190217 1 MVIS 1 15.00 8288.54
5 700710470131 1 MVIS 1 63.00 9015.74
6 700710470148 1 MVIS 1 63.00 9015.74
7 700710470213 1 MVIS 1 64.00 9015.74
8 700840260136 1 MVIS 1 204.00 27728.28
9 700920230207 1 MVIS 1 58.92 5006.34
10 700920230214 1 MVIS 1 54.00 5006.34
11 700920230221 1 MVIS 1 58.92 5006.34
12 700920230276 1 MVIS 1 18.00 5006.34
13 700920230283 1 MVIS 1 15.84 5006.34
14 701040310062 1 MVIS 1 21.61 4142.21
15 701040310093 1 MVIS 1 24.30 4142.21
16 701290210146 1 MVIS 1 111.11 7299.94
17 701290210153 1 MVIS 1 74.20 7299.94
18 701290210160 1 MVIS 1 45.67 7299.94
19 701290210177 1 MVIS 1 74.20 7299.94
20 701290210184 1 MVIS 1 219.56 7299.94
21 701750470078 1 MVIS 1 70.34 4668.21
22 701750470085 1 MVIS 1 87.20 4668.21
23 701750470092 1 MVIS 1 81.75 4668.21
24 701750470105 1 MVIS 1 110.00 4668.21
25 701750470112 1 MVIS 1 125.00 4668.21
26 701750470129 1 MVIS 1 90.00 4668.21
27 702140270133 1 MVIS 1 65.61 18941.56
28 702140410133 1 MVIS 1 58.00 15148.37
29 702510110257 1 MVIS 1 90.00 11195.02
30 702510110264 1 MVIS 1 45.72 11195.02
31 702510110459 1 MVIS 1 53.00 11195.02
32 702630600060 1 MVIS 1 19.00 5284.01
33 702970120198 1 MVIS 1 46.92 15096.51
34 702970120201 1 MVIS 1 41.50 15096.51
35 702970120218 1 MVIS 1 49.50 15096.51
36 704410120052 1 MVIS 1 25.64 3520.15
37 704410120069 1 MVIS 1 25.64 3520.15
38 704410120076 1 MVIS 1 60.25 3520.15
39 704410120083 1 MVIS 1 25.64 3520.15
40 705150120301 1 MVIS 1 31.49 3391.46
41 705480280281 1 MVIS 1 54.00 13477.02
42 705480280298 1 MVIS 1 54.00 13477.02
43 705480280414 1 MVIS 1 78.00 13477.02
44 705700290090 1 MVIS 1 109.91 26722.79
45 705820230365 1 MVIS 1 57.58 16052.12
46 705820230512 1 MVIS 1 70.00 16052.12
47 705820230601 1 MVIS 1 70.00 16052.12
48 705820230618 1 MVIS 1 70.00 16052.12
49 705820230625 1 MVIS 1 131.00 16052.12
50 705820230632 1 MVIS 1 85.37 16052.12
HC-051I 08:46 Tuesday, June 24, 2003 7
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
The MEANS Procedure
Analysis Variable : OBXP00X SUM OF OBSF00X - OBOT00X (IMPUTED)
N Sum
--------------------
1509 115160.55
--------------------
HC-051I 08:46 Tuesday, June 24, 2003 8
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : OBXP00X SUM OF OBSF00X - OBOT00X (IMPUTED)
Sum
------------
1227885582
------------
1 The SAS System 08:55 Tuesday, June 24, 2003
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC/AHRQ, Site 0038838053.
NOTE: This session is executing on the WIN_95 platform.
NOTE: SAS initialization used:
real time 4.72 seconds
1
2 OPTIONS LS=132 PS=59;
3
4 TITLE1 "HC-051I";
5 TITLE2 'Sample SAS Job for Example D';
6
7 LIBNAME IN 'C:\DATA';
NOTE: Directory for library IN contains files of mixed engine types.
NOTE: Libref IN was successfully assigned as follows:
Engine: V8
Physical Name: C:\DATA
8 **************************************************************************************
9 * Calculate the expenditures for prescribed medicines associated
10 * with insulin reported by the household as an other medical expense.
11 **************************************************************************************;
12
13 PROC FORMAT;
14 VALUE EVENTYPE
15 1 = "1 MVIS"
16 2 = "2 OPAT"
17 3 = "3 EROM"
18 4 = "4 STAZ"
19 5 = "5 DVIS"
20 6 = "6 OMED"
21 7 = "7 HVIS"
22 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
23
24 VALUE OMTYPE
25 -9 = '-9 NOT ASCERTAINED'
26 -8 = '-8 DK'
27 -7 = '-7 REFUSED'
28 -1 = '-1 INAPPLICABLE'
29 1 = '1 GLASSES OR CONTACT LENSES'
30 2 = '2 INSULIN'
31 3 = '3 DIABETIC EQUIPMENT/SUPPLIES'
32 4 = '4 AMBULANCE SERVICES'
33 5 = '5 ORTHOPEDIC ITEMS'
34 6 = '6 HEARING DEVICES'
35 7 = '7 PROSTHESIS'
36 8 = '8 BATHROOM AIDS'
37 9 = '9 MEDICAL EQUIPMENT'
38 10 = '10 DISPOSABLE SUPPLIES'
39 11 = '11 ALTERATIONS/MODIFICATIONS'
40 91 = '91 OTHER'
41 ;
NOTE: Format OMTYPE has been output.
2 The SAS System 08:55 Tuesday, June 24, 2003
42 RUN;
NOTE: PROCEDURE FORMAT used:
real time 0.33 seconds
43
44 *-------------------------------------------------------------------------------------
45 * Get other medical records for insulin for persons with positive weights.
46 *-------------------------------------------------------------------------------------;
47
48 DATA OMED;
49 SET IN.H51C (KEEP=EVNTIDX PERWT00F OMTYPEX);
50 IF PERWT00F > 0 & OMTYPEX = 2;
51 RUN;
NOTE: There were 6586 observations read from the data set IN.H51C.
NOTE: The data set WORK.OMED has 448 observations and 3 variables.
NOTE: DATA statement used:
real time 1.53 seconds
52
53 proc print data=omed (obs=100);
54 var evntidx OMTYPEX PERWT00F;
55 format OMTYPEX omtype.;
56 title3 "sample print of OMED (HC-051C) records where OMTYPEX=2";
57 run;
NOTE: There were 100 observations read from the data set WORK.OMED.
NOTE: The PROCEDURE PRINT printed pages 1-2.
NOTE: PROCEDURE PRINT used:
real time 1.70 seconds
58
59 *-------------------------------------------------------------------------------------
60 * Get PMED IDs linked to the OMED events which were for insulin.
61 *-------------------------------------------------------------------------------------;
62
63 PROC SORT DATA=IN.H51IF2 OUT=RXLK; BY EVENTIDX; RUN;
NOTE: There were 42089 observations read from the data set IN.H51IF2.
NOTE: The data set WORK.RXLK has 42089 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 0.99 seconds
64
65 proc print data=rxlk (obs=150);
66 by eventidx;
67 id eventidx;
68 var linkidx eventype;
69 format eventype eventype.;
70 title3 "sample print of Rx+event link file records (HC-51IF2) - sorted by eventidx";
71 run;
3 The SAS System 08:55 Tuesday, June 24, 2003
NOTE: There were 150 observations read from the data set WORK.RXLK.
NOTE: The PROCEDURE PRINT printed pages 3-7.
NOTE: PROCEDURE PRINT used:
real time 0.15 seconds
72
73 data omedrxlk;
74 set rxlk (where=(eventype=6));
75 run;
NOTE: There were 1210 observations read from the data set WORK.RXLK.
WHERE eventype=6;
NOTE: The data set WORK.OMEDRXLK has 1210 observations and 5 variables.
NOTE: DATA statement used:
real time 0.15 seconds
76 proc print data=omedrxlk (obs=120);
77 by eventidx;
78 id eventidx;
79 var linkidx eventype;
80 format eventype eventype.;
81 title3 "sample print of work.omedrxlk - sorted by eventidx";
82 title4 "Rx+event link file records (HC-51IF2) where eventype=6 (omed)";
83 run;
NOTE: There were 120 observations read from the data set WORK.OMEDRXLK.
NOTE: The PROCEDURE PRINT printed pages 8-12.
NOTE: PROCEDURE PRINT used:
real time 0.00 seconds
84
85 DATA PMEDIDS;
86 MERGE RXLK (IN=INRXLK KEEP=EVENTIDX LINKIDX EVENTYPE RENAME=(EVENTIDX=EVNTIDX))
87 OMED (IN=INOMED KEEP=EVNTIDX);
88 BY EVNTIDX;
89 IF INRXLK & INOMED;
90 RUN;
NOTE: There were 42089 observations read from the data set WORK.RXLK.
NOTE: There were 448 observations read from the data set WORK.OMED.
NOTE: The data set WORK.PMEDIDS has 425 observations and 3 variables.
NOTE: DATA statement used:
real time 0.15 seconds
91
92 proc print data=pmedids (obs=50);
93 by evntidx;
94 id evntidx;
95 format eventype eventype.;
96 title3 "sample print of work.pmedids - sorted by evntidx";
97 title4 "work.rxlk records for omed events for insulin";
98 run;
4 The SAS System 08:55 Tuesday, June 24, 2003
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed pages 13-14.
NOTE: PROCEDURE PRINT used:
real time 0.06 seconds
99
100 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 425 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 425 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.04 seconds
101
102 proc print data=pmedids (obs=50);
103 format eventype eventype.;
104 title3 "sample print of work.pmedids - sorted by linkidx";
105 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: PROCEDURE PRINT used:
real time 0.05 seconds
106
107 DATA PMEDIDS;
108 SET PMEDIDS (KEEP=LINKIDX);
109 BY LINKIDX;
110 IF FIRST.LINKIDX;
111 KEEP LINKIDX;
112 RUN;
NOTE: There were 425 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 425 observations and 1 variables.
NOTE: DATA statement used:
real time 0.04 seconds
113
114 proc print data=pmedids (obs=50);
115 title3 "sample print of unique linkidxs in work.pmedids";
116 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 16.
NOTE: PROCEDURE PRINT used:
real time 0.00 seconds
117
118
119 *------------------------------------------------------------------------------------
120 * Get PMED records for OMED event which were for insulin.
121 *------------------------------------------------------------------------------------;
5 The SAS System 08:55 Tuesday, June 24, 2003
122 PROC SORT DATA=IN.H51A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 182677 observations read from the data set IN.H51A.
NOTE: The data set WORK.PMED has 182677 observations and 52 variables.
NOTE: PROCEDURE SORT used:
real time 2:12.48
123
124 DATA OMPMEDS;
125 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP00X PERWT00F RXNAME)
126 PMEDIDS (IN=A);
127 BY LINKIDX;
128 IF A & PERWT00F>0;
129 RUN;
NOTE: There were 182677 observations read from the data set WORK.PMED.
NOTE: There were 425 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.OMPMEDS has 1428 observations and 5 variables.
NOTE: DATA statement used:
real time 38.28 seconds
130
131 proc print data=ompmeds (obs=200);
132 by linkidx;
133 id linkidx;
134 var rxrecidx rxname RXXP00X PERWT00F;
135 title3 "sample print of work.pmeds";
136 title4 "PMED (HC-051A) records for unique linkidxs in work.pmedids";
137 run;
NOTE: There were 200 observations read from the data set WORK.OMPMEDS.
NOTE: The PROCEDURE PRINT printed pages 17-22.
NOTE: PROCEDURE PRINT used:
real time 0.05 seconds
138
139 PROC MEANS DATA=OMPMEDS N SUM;
140 VAR RXXP00X;
141 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
142 RUN;
NOTE: There were 1428 observations read from the data set WORK.OMPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used:
real time 0.55 seconds
143
144 PROC MEANS DATA=OMPMEDS N SUM;
145 VAR RXXP00X;
146 WEIGHT PERWT00F;
147 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
148 TITLE5 "Weighted";
149 RUN;
6 The SAS System 08:55 Tuesday, June 24, 2003
NOTE: There were 1428 observations read from the data set WORK.OMPMEDS.
NOTE: The PROCEDURE MEANS printed page 24.
NOTE: PROCEDURE MEANS used:
real time 0.05 seconds
150
151
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 3:02.34
HC-051I 08:55 Tuesday, June 24, 2003 1
Sample SAS Job for Example D
sample print of OMED (HC-051C) records where OMTYPEX=2
Obs EVNTIDX OMTYPEX PERWT00F
1 700170170285 2 INSULIN 6565.88
2 700390180407 2 INSULIN 14761.19
3 700390180729 2 INSULIN 14761.19
4 701050290296 2 INSULIN 16826.66
5 702320191014 2 INSULIN 13402.96
6 702790220591 2 INSULIN 16208.01
7 702790220762 2 INSULIN 16208.01
8 703010100486 2 INSULIN 7498.93
9 703010100804 2 INSULIN 7498.93
10 703710110328 2 INSULIN 2919.24
11 704090250298 2 INSULIN 18693.20
12 704090250421 2 INSULIN 18693.20
13 704220100853 2 INSULIN 36865.67
14 704810110285 2 INSULIN 7840.56
15 706010180565 2 INSULIN 9595.59
16 706010180736 2 INSULIN 9595.59
17 706520113033 2 INSULIN 6352.29
18 706520113742 2 INSULIN 6352.29
19 706520114389 2 INSULIN 6352.29
20 706740230373 2 INSULIN 9136.93
21 707590140135 2 INSULIN 11717.13
22 707610270130 2 INSULIN 32666.40
23 708950310933 2 INSULIN 3845.59
24 710050230454 2 INSULIN 35514.59
25 710580530204 2 INSULIN 2921.27
26 710580530242 2 INSULIN 2921.27
27 711100270364 2 INSULIN 10026.35
28 711100270491 2 INSULIN 10026.35
29 711190130703 2 INSULIN 26391.50
30 711190130929 2 INSULIN 26391.50
31 711190131117 2 INSULIN 26391.50
32 711740350491 2 INSULIN 18578.53
33 712460240378 2 INSULIN 4948.38
34 712820170592 2 INSULIN 21016.98
35 712820170958 2 INSULIN 21016.98
36 712820171191 2 INSULIN 21016.98
37 713900140537 2 INSULIN 4602.95
38 714080290438 2 INSULIN 24046.46
39 714080290534 2 INSULIN 24046.46
40 714480150247 2 INSULIN 12754.81
41 714480150329 2 INSULIN 12754.81
42 714480150381 2 INSULIN 12754.81
43 714750200360 2 INSULIN 11367.47
44 714780530265 2 INSULIN 8401.10
45 715680250473 2 INSULIN 3111.78
46 716330290590 2 INSULIN 13962.86
47 716460200464 2 INSULIN 8344.92
48 716800140306 2 INSULIN 19309.17
49 716800140522 2 INSULIN 19309.17
50 717810210167 2 INSULIN 9752.59
51 717810210270 2 INSULIN 9752.59
52 717810210345 2 INSULIN 9752.59
53 718320340255 2 INSULIN 10164.11
HC-051I 08:55 Tuesday, June 24, 2003 2
Sample SAS Job for Example D
sample print of OMED (HC-051C) records where OMTYPEX=2
Obs EVNTIDX OMTYPEX PERWT00F
54 718370140588 2 INSULIN 13694.74
55 718370140906 2 INSULIN 13694.74
56 719290220484 2 INSULIN 6361.70
57 719560320092 2 INSULIN 10002.19
58 720210190119 2 INSULIN 12568.49
59 721110260168 2 INSULIN 7784.15
60 722530160717 2 INSULIN 15892.26
61 724150160447 2 INSULIN 22917.64
62 724930140448 2 INSULIN 10671.70
63 725250150250 2 INSULIN 13818.40
64 725710300102 2 INSULIN 10430.63
65 725710300284 2 INSULIN 10430.63
66 725760190391 2 INSULIN 10790.43
67 725760190531 2 INSULIN 10790.43
68 725760190620 2 INSULIN 10790.43
69 725790120013 2 INSULIN 5147.72
70 725790120068 2 INSULIN 5147.72
71 726190290436 2 INSULIN 14300.81
72 726190290758 2 INSULIN 14300.81
73 726670211772 2 INSULIN 3796.63
74 727090142213 2 INSULIN 7277.57
75 729490180591 2 INSULIN 19291.48
76 729490180779 2 INSULIN 19291.48
77 730270270479 2 INSULIN 14356.16
78 730530290552 2 INSULIN 12958.86
79 730530290716 2 INSULIN 12958.86
80 730530291168 2 INSULIN 12958.86
81 731110120247 2 INSULIN 11904.03
82 731110120312 2 INSULIN 11904.03
83 732590130263 2 INSULIN 7770.87
84 733030120062 2 INSULIN 3115.24
85 733390110298 2 INSULIN 1408.95
86 733390110469 2 INSULIN 1408.95
87 733610220407 2 INSULIN 2111.25
88 734770140872 2 INSULIN 21530.52
89 734770141464 2 INSULIN 21530.52
90 734800120300 2 INSULIN 14927.77
91 734800120406 2 INSULIN 14927.77
92 734800120499 2 INSULIN 14927.77
93 735050130757 2 INSULIN 5112.29
94 735050131034 2 INSULIN 5112.29
95 735050201250 2 INSULIN 6939.63
96 736050180798 2 INSULIN 6135.54
97 736050181044 2 INSULIN 6135.54
98 736360161209 2 INSULIN 11308.65
99 736450361269 2 INSULIN 2883.28
100 736500190125 2 INSULIN 7244.20
HC-051I 08:55 Tuesday, June 24, 2003 3
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-51IF2) - sorted by eventidx
EVENTIDX LINKIDX EVENTYPE
700020160244 700020160268 1 MVIS
700020160251 700020160275 3 EROM
700030100160 700030100177 1 MVIS
700030100191 700030100211 1 MVIS
700030270108 700030270122 1 MVIS
700030270139 1 MVIS
700030270153 700030270177 1 MVIS
700030340033 700030340040 1 MVIS
700030340057 1 MVIS
700030570065 700030570089 1 MVIS
700040210067 700040210074 1 MVIS
700050110128 700050110135 1 MVIS
700050230123 700050230130 1 MVIS
700060190073 700060190100 1 MVIS
700060260080 700060260179 1 MVIS
700060260186 1 MVIS
700060260193 1 MVIS
700060260244 700060260364 1 MVIS
700060260251 700060260371 1 MVIS
700060260388 1 MVIS
700070210087 700070210152 1 MVIS
700070450049 700070450070 1 MVIS
700070450087 1 MVIS
700070450056 700070450070 1 MVIS
700070450087 1 MVIS
700070510088 700070510095 1 MVIS
700130330073 700130330100 1 MVIS
700140160115 700140160122 1 MVIS
700140230362 700140230519 1 MVIS
HC-051I 08:55 Tuesday, June 24, 2003 4
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-51IF2) - sorted by eventidx
EVENTIDX LINKIDX EVENTYPE
700140230468 700140230475 6 OMED
700140230824 700140230831 6 OMED
700160150065 700160150116 1 MVIS
700160220010 700160220027 1 MVIS
700160390010 700160390027 1 MVIS
700160390034 1 MVIS
700160460185 700160460229 1 MVIS
700160460236 1 MVIS
700160460243 1 MVIS
700160460192 700160460250 1 MVIS
700160460267 1 MVIS
700160460349 700160460356 3 EROM
700170170223 700170170292 1 MVIS
700170170305 1 MVIS
700170170312 1 MVIS
700170170329 1 MVIS
700170170285 700170170292 6 OMED
700170170336 700170170374 1 MVIS
700170170343 700170170374 1 MVIS
700170170350 700170170374 1 MVIS
700170170367 700170170374 1 MVIS
700170240090 700170240134 1 MVIS
700170240141 700170240223 1 MVIS
700170240230 1 MVIS
700170240247 1 MVIS
700170240254 1 MVIS
700170240261 1 MVIS
700170240209 700170240216 6 OMED
700170240278 700170240312 1 MVIS
700170240329 1 MVIS
700170240336 1 MVIS
700170240343 1 MVIS
700170240367 1 MVIS
HC-051I 08:55 Tuesday, June 24, 2003 5
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-51IF2) - sorted by eventidx
EVENTIDX LINKIDX EVENTYPE
700170240278 700170240381 1 MVIS
700170240285 700170240312 1 MVIS
700170240329 1 MVIS
700170240336 1 MVIS
700170240343 1 MVIS
700170240367 1 MVIS
700170240381 1 MVIS
700170240292 700170240312 1 MVIS
700170240329 1 MVIS
700170240336 1 MVIS
700170240343 1 MVIS
700170240367 1 MVIS
700170240381 1 MVIS
700170240305 700170240312 1 MVIS
700170240329 1 MVIS
700170240336 1 MVIS
700170240343 1 MVIS
700170240367 1 MVIS
700170240381 1 MVIS
700200440060 700200440077 1 MVIS
700210130019 700210130033 1 MVIS
700210270050 700210270074 1 MVIS
700210270081 1 MVIS
700210270101 700210270125 1 MVIS
700210270132 1 MVIS
700210270118 700210270132 1 MVIS
700210270156 700210270187 1 MVIS
700210270194 1 MVIS
700210270207 1 MVIS
700210270214 1 MVIS
700250170048 700250170055 1 MVIS
700250170062 1 MVIS
700250310055 700250310062 1 MVIS
700250310079 1 MVIS
700250480024 700250480031 1 MVIS
700280240520 700280240582 1 MVIS
HC-051I 08:55 Tuesday, June 24, 2003 6
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-51IF2) - sorted by eventidx
EVENTIDX LINKIDX EVENTYPE
700280240537 700280240599 1 MVIS
700280240602 1 MVIS
700280240619 1 MVIS
700280240544 700280240626 1 MVIS
700280240551 700280240633 1 MVIS
700280240575 700280240633 4 STAZ
700280241218 700280241225 1 MVIS
700300260145 700300260152 1 MVIS
700300260241 700300260289 1 MVIS
700300260258 700300260296 1 MVIS
700320160339 700320160391 3 EROM
700320160404 3 EROM
700320160411 3 EROM
700320160346 700320160428 1 MVIS
700320160360 700320160435 1 MVIS
700380130115 700380130122 1 MVIS
700380130177 700380130235 1 MVIS
700380130242 1 MVIS
700380130259 1 MVIS
700380130204 700380130273 1 MVIS
700380250141 700380250292 1 MVIS
700380250158 700380250305 1 MVIS
700380250189 700380250292 1 MVIS
700380250278 700380250305 4 STAZ
700390180407 700390180414 6 OMED
700390180541 700390180596 1 MVIS
700390180609 1 MVIS
700390180616 1 MVIS
700390180623 1 MVIS
700390180678 700390180743 5 DVIS
HC-051I 08:55 Tuesday, June 24, 2003 7
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-51IF2) - sorted by eventidx
EVENTIDX LINKIDX EVENTYPE
700390180729 700390180736 6 OMED
700400180037 700400180068 1 MVIS
700430180041 700430180058 1 MVIS
700450110312 700450110374 1 MVIS
700450170070 700450170087 3 EROM
700450170094 3 EROM
700450170107 700450170114 1 MVIS
700450170121 1 MVIS
700450170138 1 MVIS
700450330225 700450330256 1 MVIS
700450330294 700450330338 5 DVIS
700450330345 5 DVIS
700450330352 5 DVIS
700450330376 700450330410 1 MVIS
700450330390 700450330410 1 MVIS
700450330403 700450330410 1 MVIS
700460220069 700460220076 1 MVIS
700460220083 700460220090 1 MVIS
700480110042 700480110148 1 MVIS
700480110155 1 MVIS
700480280028 700480280035 1 MVIS
700490180038 700490180103 1 MVIS
HC-051I 08:55 Tuesday, June 24, 2003 8
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-51IF2) where eventype=6 (omed)
EVENTIDX LINKIDX EVENTYPE
700140230468 700140230475 6 OMED
700140230824 700140230831 6 OMED
700170170285 700170170292 6 OMED
700170240209 700170240216 6 OMED
700390180407 700390180414 6 OMED
700390180729 700390180736 6 OMED
701050290272 701050290289 6 OMED
701050290296 701050290309 6 OMED
701510240453 701510240460 6 OMED
701510240580 701510240597 6 OMED
701510240679 701510240686 6 OMED
701890180615 701890180622 6 OMED
702030260267 702030260274 6 OMED
702030260363 702030260370 6 OMED
702320191014 702320191021 6 OMED
702320191038 702320191045 6 OMED
702760270183 702760270190 6 OMED
702790220591 702790220604 6 OMED
702790220611 702790220628 6 OMED
702790220762 702790220779 6 OMED
702790220786 702790220793 6 OMED
703010100486 703010100493 6 OMED
703010100506 703010100513 6 OMED
703010100784 703010100791 6 OMED
703010100804 703010100811 6 OMED
HC-051I 08:55 Tuesday, June 24, 2003 9
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-51IF2) where eventype=6 (omed)
EVENTIDX LINKIDX EVENTYPE
703180160363 703180160370 6 OMED
703430270684 703430270691 6 OMED
703430270893 703430270906 6 OMED
703660190227 703660190234 6 OMED
703680230289 703680230296 6 OMED
703710110277 703710110284 6 OMED
703710110328 703710110335 6 OMED
703710110342 703710110359 6 OMED
704090250298 704090250301 6 OMED
704090250318 704090250325 6 OMED
704090250421 704090250438 6 OMED
704090250445 704090250452 6 OMED
704090250476 704090250483 6 OMED
704180150035 704180150042 6 OMED
704180150148 704180150155 6 OMED
704180150193 704180150206 6 OMED
704220100853 704220100860 6 OMED
704220100877 704220100884 6 OMED
704810110285 704810110292 6 OMED
705480350503 705480350510 6 OMED
706010180565 706010180572 6 OMED
706010180589 706010180596 6 OMED
706010180736 706010180743 6 OMED
706520113033 706520113040 6 OMED
706520113057 706520113064 6 OMED
HC-051I 08:55 Tuesday, June 24, 2003 10
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-51IF2) where eventype=6 (omed)
EVENTIDX LINKIDX EVENTYPE
706520113742 706520113759 6 OMED
706520113766 706520113773 6 OMED
706520114389 706520114396 6 OMED
706520114409 706520114416 6 OMED
706740160373 706740160380 6 OMED
706740230373 706740230380 6 OMED
706800170489 706800170496 6 OMED
706970200476 706970200483 6 OMED
707340130138 707340130145 6 OMED
707590140135 707590140142 6 OMED
707590140159 707590140166 6 OMED
707590140224 707590140231 6 OMED
707610270130 707610270147 6 OMED
707610270154 707610270161 6 OMED
708320190321 708320190198 6 OMED
708440210291 708440210304 6 OMED
708460140474 708460140481 6 OMED
708710180288 708710180295 6 OMED
708810120144 708810120151 6 OMED
708810120288 708810120295 6 OMED
708810260089 708810260096 6 OMED
708810260154 708810260161 6 OMED
708810260267 708810260274 6 OMED
708950310933 708950310940 6 OMED
708950310957 708950310964 6 OMED
HC-051I 08:55 Tuesday, June 24, 2003 11
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-51IF2) where eventype=6 (omed)
EVENTIDX LINKIDX EVENTYPE
709060260395 709060260408 6 OMED
709110100075 709110100082 6 OMED
709260200552 709260200569 6 OMED
709620140703 709620140710 6 OMED
709730160172 709730160189 6 OMED
710050230454 710050230461 6 OMED
710580530204 710580530211 6 OMED
710580530228 710580530235 6 OMED
710580530242 710580530259 6 OMED
710580530266 710580530273 6 OMED
710820140435 710820140442 6 OMED
711100270364 711100270371 6 OMED
711100270388 711100270395 6 OMED
711100270491 711100270504 6 OMED
711140130319 711140130326 6 OMED
711140130453 711140130460 6 OMED
711190130727 711190130734 6 OMED
711190130929 711190130936 6 OMED
711190130943 711190130950 6 OMED
711190131117 711190131124 6 OMED
711190131131 711190131148 6 OMED
711740350491 711740350504 6 OMED
711740350511 711740350528 6 OMED
711770270431 711770270448 6 OMED
712460240378 712460240385 6 OMED
HC-051I 08:55 Tuesday, June 24, 2003 12
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-51IF2) where eventype=6 (omed)
EVENTIDX LINKIDX EVENTYPE
712460240392 712460240405 6 OMED
712570240158 712570240165 6 OMED
712570240172 712570240189 6 OMED
712570240223 712570240230 6 OMED
712570310401 712570310418 6 OMED
712570310463 712570310470 6 OMED
712570310569 712570310576 6 OMED
712580171280 712580171297 6 OMED
712820170592 712820170605 6 OMED
712820170612 712820170629 6 OMED
712820170958 712820170965 6 OMED
712820170972 712820170989 6 OMED
712820171191 712820171204 6 OMED
712820171211 712820171228 6 OMED
712890130867 712890130874 6 OMED
713690140195 713690140208 6 OMED
713900140537 713900140544 6 OMED
713900140551 713900140568 6 OMED
714080290438 714080290445 6 OMED
714080290452 714080290469 6 OMED
HC-051I 08:55 Tuesday, June 24, 2003 13
Sample SAS Job for Example D
sample print of work.pmedids - sorted by evntidx
work.rxlk records for omed events for insulin
EVNTIDX LINKIDX EVENTYPE
700170170285 700170170292 6 OMED
700390180407 700390180414 6 OMED
700390180729 700390180736 6 OMED
701050290296 701050290309 6 OMED
702320191014 702320191021 6 OMED
702790220591 702790220604 6 OMED
702790220762 702790220779 6 OMED
703010100486 703010100493 6 OMED
703010100804 703010100811 6 OMED
703710110328 703710110335 6 OMED
704090250298 704090250301 6 OMED
704090250421 704090250438 6 OMED
704220100853 704220100860 6 OMED
704810110285 704810110292 6 OMED
706010180565 706010180572 6 OMED
706010180736 706010180743 6 OMED
706520113033 706520113040 6 OMED
706520113742 706520113759 6 OMED
706520114389 706520114396 6 OMED
706740230373 706740230380 6 OMED
707590140135 707590140142 6 OMED
707610270130 707610270147 6 OMED
708950310933 708950310940 6 OMED
710050230454 710050230461 6 OMED
710580530204 710580530211 6 OMED
HC-051I 08:55 Tuesday, June 24, 2003 14
Sample SAS Job for Example D
sample print of work.pmedids - sorted by evntidx
work.rxlk records for omed events for insulin
EVNTIDX LINKIDX EVENTYPE
710580530242 710580530259 6 OMED
711100270364 711100270371 6 OMED
711100270491 711100270504 6 OMED
711190130929 711190130936 6 OMED
711190131117 711190131124 6 OMED
711740350491 711740350504 6 OMED
712460240378 712460240385 6 OMED
712820170592 712820170605 6 OMED
712820170958 712820170965 6 OMED
712820171191 712820171204 6 OMED
713900140537 713900140544 6 OMED
714080290438 714080290445 6 OMED
714080290534 714080290541 6 OMED
714480150247 714480150254 6 OMED
714480150329 714480150336 6 OMED
714480150381 714480150398 6 OMED
714750200360 714750200377 6 OMED
714780530265 714780530272 6 OMED
715680250473 715680250480 6 OMED
716330290590 716330290603 6 OMED
716460200464 716460200471 6 OMED
716800140306 716800140313 6 OMED
716800140522 716800140539 6 OMED
717810210167 717810210174 6 OMED
717810210270 717810210287 6 OMED
HC-051I 08:55 Tuesday, June 24, 2003 15
Sample SAS Job for Example D
sample print of work.pmedids - sorted by linkidx
Obs EVNTIDX LINKIDX EVENTYPE
1 700170170285 700170170292 6 OMED
2 700390180407 700390180414 6 OMED
3 700390180729 700390180736 6 OMED
4 701050290296 701050290309 6 OMED
5 702320191014 702320191021 6 OMED
6 702790220591 702790220604 6 OMED
7 702790220762 702790220779 6 OMED
8 703010100486 703010100493 6 OMED
9 703010100804 703010100811 6 OMED
10 703710110328 703710110335 6 OMED
11 704090250298 704090250301 6 OMED
12 704090250421 704090250438 6 OMED
13 704220100853 704220100860 6 OMED
14 704810110285 704810110292 6 OMED
15 706010180565 706010180572 6 OMED
16 706010180736 706010180743 6 OMED
17 706520113033 706520113040 6 OMED
18 706520113742 706520113759 6 OMED
19 706520114389 706520114396 6 OMED
20 706740230373 706740230380 6 OMED
21 707590140135 707590140142 6 OMED
22 707610270130 707610270147 6 OMED
23 708950310933 708950310940 6 OMED
24 710050230454 710050230461 6 OMED
25 710580530204 710580530211 6 OMED
26 710580530242 710580530259 6 OMED
27 711100270364 711100270371 6 OMED
28 711100270491 711100270504 6 OMED
29 711190130929 711190130936 6 OMED
30 711190131117 711190131124 6 OMED
31 711740350491 711740350504 6 OMED
32 712460240378 712460240385 6 OMED
33 712820170592 712820170605 6 OMED
34 712820170958 712820170965 6 OMED
35 712820171191 712820171204 6 OMED
36 713900140537 713900140544 6 OMED
37 714080290438 714080290445 6 OMED
38 714080290534 714080290541 6 OMED
39 714480150247 714480150254 6 OMED
40 714480150329 714480150336 6 OMED
41 714480150381 714480150398 6 OMED
42 714750200360 714750200377 6 OMED
43 714780530265 714780530272 6 OMED
44 715680250473 715680250480 6 OMED
45 716330290590 716330290603 6 OMED
46 716460200464 716460200471 6 OMED
47 716800140306 716800140313 6 OMED
48 716800140522 716800140539 6 OMED
49 717810210167 717810210174 6 OMED
50 717810210270 717810210287 6 OMED
HC-051I 08:55 Tuesday, June 24, 2003 16
Sample SAS Job for Example D
sample print of unique linkidxs in work.pmedids
Obs LINKIDX
1 700170170292
2 700390180414
3 700390180736
4 701050290309
5 702320191021
6 702790220604
7 702790220779
8 703010100493
9 703010100811
10 703710110335
11 704090250301
12 704090250438
13 704220100860
14 704810110292
15 706010180572
16 706010180743
17 706520113040
18 706520113759
19 706520114396
20 706740230380
21 707590140142
22 707610270147
23 708950310940
24 710050230461
25 710580530211
26 710580530259
27 711100270371
28 711100270504
29 711190130936
30 711190131124
31 711740350504
32 712460240385
33 712820170605
34 712820170965
35 712820171204
36 713900140544
37 714080290445
38 714080290541
39 714480150254
40 714480150336
41 714480150398
42 714750200377
43 714780530272
44 715680250480
45 716330290603
46 716460200471
47 716800140313
48 716800140539
49 717810210174
50 717810210287
HC-051I 08:55 Tuesday, June 24, 2003 17
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
700170170292 700170170292001 HUMULIN N (VIAL) 44.18 6565.877991
700170170292002 HUMULIN N (VIAL) 44.18 6565.877991
700170170292003 HUMULIN N (VIAL) 44.18 6565.877991
700170170292004 HUMULIN N (VIAL) 44.18 6565.877991
700170170292005 HUMULIN N (VIAL) 44.18 6565.877991
700390180414 700390180414001 INSULIN NPH 61.44 14761.185211
700390180736 700390180736001 INSULIN NPH 61.44 14761.185211
700390180736002 INSULIN NPH 61.44 14761.185211
701050290309 701050290309001 INSULIN NPH 61.44 16826.662253
701050290309002 INSULIN NPH 61.44 16826.662253
701050290309003 INSULIN NPH 61.44 16826.662253
702320191021 702320191021001 INSULIN NPH 61.44 13402.955911
702320191021002 INSULIN NPH 61.44 13402.955911
702320191021003 INSULIN NPH 61.44 13402.955911
702790220604 702790220604001 INSULIN NOVOLIN 9.64 16208.011436
702790220604002 INSULIN NOVOLIN 9.64 16208.011436
702790220604003 INSULIN NOVOLIN 9.64 16208.011436
702790220604004 INSULIN NOVOLIN 9.64 16208.011436
702790220604005 INSULIN NOVOLIN 9.64 16208.011436
702790220779 702790220779001 INSULIN NOVOLIN 9.64 16208.011436
702790220779002 INSULIN NOVOLIN 9.64 16208.011436
702790220779003 INSULIN NOVOLIN 9.64 16208.011436
702790220779004 INSULIN NOVOLIN 9.64 16208.011436
703010100493 703010100493001 INSULIN NOVOLIN 9.64 7498.931904
703010100493002 INSULIN NOVOLIN 9.64 7498.931904
703010100493003 INSULIN NOVOLIN 9.64 7498.931904
703010100493004 INSULIN NOVOLIN 9.64 7498.931904
703010100811 703010100811001 HUMULIN N (VIAL) 70.41 7498.931904
703710110335 703710110335001 INSULIN NOVOLIN 9.64 2919.235979
703710110335002 INSULIN NOVOLIN 9.64 2919.235979
703710110335003 INSULIN NOVOLIN 9.64 2919.235979
703710110335004 INSULIN NOVOLIN 9.64 2919.235979
704090250301 704090250301001 INSULIN NPH 61.44 18693.199276
704090250301002 INSULIN NPH 61.44 18693.199276
704090250301003 INSULIN NPH 61.44 18693.199276
704090250301004 INSULIN NPH 61.44 18693.199276
704090250301005 INSULIN NPH 61.44 18693.199276
704090250438 704090250438001 INSULIN NPH 61.44 18693.199276
HC-051I 08:55 Tuesday, June 24, 2003 18
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
704090250438 704090250438002 INSULIN NPH 61.44 18693.199276
704090250438003 INSULIN NPH 61.44 18693.199276
704090250438004 INSULIN NPH 61.44 18693.199276
704090250438005 INSULIN NPH 61.44 18693.199276
704090250438006 INSULIN NPH 61.44 18693.199276
704220100860 704220100860001 INSULIN NOVOLIN 9.64 36865.666721
704810110292 704810110292001 INSULIN NOVOLIN 9.64 7840.563501
704810110292002 INSULIN NOVOLIN 9.64 7840.563501
704810110292003 INSULIN NOVOLIN 9.64 7840.563501
706010180572 706010180572001 HUMULIN 70/30 (VIAL) 70.67 9595.593650
706010180572002 HUMULIN 70/30 (VIAL) 70.67 9595.593650
706010180572003 HUMULIN 70/30 (VIAL) 67.54 9595.593650
706010180572004 HUMULIN 70/30 (VIAL) 70.67 9595.593650
706010180572005 HUMULIN 70/30 (VIAL) 70.67 9595.593650
706010180743 706010180743001 INSULIN NPH 61.44 9595.593650
706010180743002 INSULIN NPH 61.44 9595.593650
706010180743003 INSULIN NPH 61.44 9595.593650
706010180743004 INSULIN NPH 61.44 9595.593650
706520113040 706520113040001 HUMULIN N (VIAL) 24.10 6352.289112
706520113759 706520113759001 HUMULIN N (VIAL) 24.10 6352.289112
706520114396 706520114396001 HUMULIN N (VIAL) 22.97 6352.289112
706740230380 706740230380001 INSULIN NPH 61.44 9136.926346
706740230380002 INSULIN NPH 61.44 9136.926346
706740230380003 INSULIN NPH 61.44 9136.926346
707590140142 707590140142001 INSULIN NPH 61.44 11717.133054
707590140142002 INSULIN NPH 61.44 11717.133054
707590140142003 INSULIN NPH 61.44 11717.133054
707590140142004 INSULIN NPH 61.44 11717.133054
707610270147 707610270147001 INSULIN NPH 61.44 32666.400903
708950310940 708950310940001 HUMULIN R (VIAL) 24.10 3845.590523
708950310940002 HUMULIN R (VIAL) 24.10 3845.590523
708950310940003 HUMULIN R (VIAL) 24.10 3845.590523
710050230461 710050230461001 INSULIN NPH 61.44 35514.590570
710050230461002 INSULIN NPH 61.44 35514.590570
710580530211 710580530211001 HUMALOG (VIAL) 125.90 2921.270878
710580530211002 HUMALOG (VIAL) 125.90 2921.270878
HC-051I 08:55 Tuesday, June 24, 2003 19
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
710580530211 710580530211003 HUMALOG (VIAL) 125.90 2921.270878
710580530211004 HUMALOG (VIAL) 125.90 2921.270878
710580530211005 HUMALOG (VIAL) 125.90 2921.270878
710580530211006 HUMALOG (VIAL) 125.90 2921.270878
710580530211007 HUMALOG (VIAL) 125.90 2921.270878
710580530211008 HUMALOG (VIAL) 125.90 2921.270878
710580530211009 HUMALOG (VIAL) 125.90 2921.270878
710580530211010 HUMALOG (VIAL) 125.90 2921.270878
710580530211011 HUMALOG (VIAL) 125.90 2921.270878
710580530211012 HUMALOG (VIAL) 125.90 2921.270878
710580530259 710580530259001 INSULIN NPH 61.44 2921.270878
710580530259002 INSULIN NPH 61.44 2921.270878
710580530259003 INSULIN NPH 61.44 2921.270878
710580530259004 INSULIN NPH 61.44 2921.270878
711100270371 711100270371001 INSULIN NPH 61.44 10026.350828
711100270371002 INSULIN NPH 61.44 10026.350828
711100270504 711100270504001 HUMULIN 70/30 (VIAL) 65.40 10026.350828
711100270504002 HUMULIN 70/30 (VIAL) 65.40 10026.350828
711190130936 711190130936001 INSULIN NOVOLIN MPH HUMAN 12.05 26391.503933
711190131124 711190131124001 INSULIN NOVOLIN NPH HUMAN 23.91 26391.503933
711740350504 711740350504001 INSULIN NOVOLIN 9.64 18578.534408
711740350504002 INSULIN NOVOLIN 9.64 18578.534408
711740350504003 INSULIN NOVOLIN 9.64 18578.534408
712460240385 712460240385001 INSULIN NPH 61.44 4948.379991
712460240385002 INSULIN NPH 61.44 4948.379991
712820170605 712820170605001 HUMULIN R (VIAL) 22.46 21016.984302
712820170965 712820170965001 HUMULIN 70/30 (VIAL) 44.43 21016.984302
712820170965002 HUMULIN 70/30 (VIAL) 44.43 21016.984302
712820170965003 HUMULIN 70/30 (VIAL) 23.47 21016.984302
712820171204 712820171204001 HUMULIN 70/30 (VIAL) 24.39 21016.984302
712820171204002 HUMULIN 70/30 (VIAL) 24.39 21016.984302
712820171204003 HUMULIN 70/30 (VIAL) 24.39 21016.984302
713900140544 713900140544001 INSULIN NOVOLIN 9.64 4602.950611
714080290445 714080290445001 INSULIN NPH 61.44 24046.457255
714080290445002 INSULIN NPH 61.44 24046.457255
714080290445003 INSULIN NPH 61.44 24046.457255
HC-051I 08:55 Tuesday, June 24, 2003 20
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
714080290541 714080290541001 INSULIN NPH 61.44 24046.457255
714480150254 714480150254001 INSULIN NOVOLIN 9.64 12754.813051
714480150254002 INSULIN NOVOLIN 9.64 12754.813051
714480150254003 INSULIN NOVOLIN 9.64 12754.813051
714480150336 714480150336001 NOVOLIN N (VIAL) 20.97 12754.813051
714480150398 714480150398001 INSULIN NOVOLIN 9.64 12754.813051
714480150398002 INSULIN NOVOLIN 9.64 12754.813051
714480150398003 INSULIN NOVOLIN 9.64 12754.813051
714480150398004 INSULIN NOVOLIN 9.64 12754.813051
714480150398005 INSULIN NOVOLIN 9.64 12754.813051
714480150398006 INSULIN NOVOLIN 9.64 12754.813051
714480150398007 INSULIN NOVOLIN 9.64 12754.813051
714480150398008 INSULIN NOVOLIN 9.64 12754.813051
714480150398009 INSULIN NOVOLIN 9.64 12754.813051
714480150398010 INSULIN NOVOLIN 9.64 12754.813051
714480150398011 INSULIN NOVOLIN 9.64 12754.813051
714480150398012 INSULIN NOVOLIN 9.64 12754.813051
714750200377 714750200377001 INSULIN NPH 61.44 11367.469633
714750200377002 INSULIN NPH 61.44 11367.469633
714750200377003 INSULIN NPH 61.44 11367.469633
714750200377004 INSULIN NPH 61.44 11367.469633
714750200377005 INSULIN NPH 61.44 11367.469633
714780530272 714780530272001 INSULIN NOVOLIN 9.64 8401.104621
714780530272002 INSULIN NOVOLIN 9.64 8401.104621
715680250480 715680250480001 HUMULIN R (VIAL) 24.70 3111.775610
715680250480002 HUMULIN R (VIAL) 24.70 3111.775610
715680250480003 HUMULIN R (VIAL) 24.70 3111.775610
715680250480004 HUMULIN R (VIAL) 24.70 3111.775610
715680250480005 HUMULIN R (VIAL) 24.70 3111.775610
716330290603 716330290603001 INSULIN NPH 61.44 13962.863799
716460200471 716460200471001 INSULIN NPH 61.44 8344.917130
716460200471002 INSULIN NPH 61.44 8344.917130
716460200471003 INSULIN NPH 61.44 8344.917130
716460200471004 INSULIN NPH 61.44 8344.917130
716460200471005 INSULIN NPH 61.44 8344.917130
716800140313 716800140313001 INSULIN NOVOLIN 9.64 19309.170720
716800140539 716800140539001 HUMULIN N (VIAL) 45.98 19309.170720
717810210174 717810210174001 INSULIN NOVOLIN 9.64 9752.590190
HC-051I 08:55 Tuesday, June 24, 2003 21
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
717810210174 717810210174002 INSULIN NOVOLIN 9.64 9752.590190
717810210174003 INSULIN NOVOLIN 9.64 9752.590190
717810210174004 INSULIN NOVOLIN 9.64 9752.590190
717810210174005 INSULIN NOVOLIN 9.64 9752.590190
717810210174006 INSULIN NOVOLIN 9.64 9752.590190
717810210174007 INSULIN NOVOLIN 9.64 9752.590190
717810210174008 INSULIN NOVOLIN 9.64 9752.590190
717810210174009 INSULIN NOVOLIN 9.64 9752.590190
717810210287 717810210287001 INSULIN NOVOLIN 9.64 9752.590190
717810210287002 INSULIN NOVOLIN 9.64 9752.590190
717810210287003 INSULIN NOVOLIN 9.64 9752.590190
717810210287004 INSULIN NOVOLIN 9.64 9752.590190
717810210287005 INSULIN NOVOLIN 9.64 9752.590190
717810210287006 INSULIN NOVOLIN 9.64 9752.590190
717810210287007 INSULIN NOVOLIN 9.64 9752.590190
717810210287008 INSULIN NOVOLIN 9.64 9752.590190
717810210287009 INSULIN NOVOLIN 9.64 9752.590190
717810210287010 INSULIN NOVOLIN 9.64 9752.590190
717810210287011 INSULIN NOVOLIN 9.64 9752.590190
717810210287012 INSULIN NOVOLIN 9.64 9752.590190
717810210352 717810210352001 INSULIN NOVOLIN 9.64 9752.590190
717810210352002 INSULIN NOVOLIN 9.64 9752.590190
717810210352003 INSULIN NOVOLIN 9.64 9752.590190
717810210352004 INSULIN NOVOLIN 9.64 9752.590190
717810210352005 INSULIN NOVOLIN 9.64 9752.590190
717810210352006 INSULIN NOVOLIN 9.64 9752.590190
717810210352007 INSULIN NOVOLIN 9.64 9752.590190
717810210352008 INSULIN NOVOLIN 9.64 9752.590190
718320340262 718320340262001 INSULIN NPH 61.44 10164.109025
718320340262002 INSULIN NPH 61.44 10164.109025
718320340262003 INSULIN NPH 61.44 10164.109025
718370140595 718370140595001 INSULIN NOVOLIN 9.64 13694.735422
718370140595002 INSULIN NOVOLIN 9.64 13694.735422
718370140595003 INSULIN NOVOLIN 9.64 13694.735422
718370140595004 INSULIN NOVOLIN 9.64 13694.735422
718370140595005 INSULIN NOVOLIN 9.64 13694.735422
718370140595006 INSULIN NOVOLIN 9.64 13694.735422
718370140913 718370140913001 INSULIN NOVOLIN 9.64 13694.735422
718370140913002 INSULIN NOVOLIN 9.64 13694.735422
718370140913003 INSULIN NOVOLIN 9.64 13694.735422
718370140913004 INSULIN NOVOLIN 9.64 13694.735422
719290220491 719290220491001 INSULIN NPH 61.44 6361.695255
719290220491002 INSULIN NPH 61.44 6361.695255
HC-051I 08:55 Tuesday, June 24, 2003 22
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-051A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP00X PERWT00F
719560320105 719560320105001 INSULIN NPH 61.44 10002.189560
719560320105002 INSULIN NPH 61.44 10002.189560
719560320105003 INSULIN NPH 61.44 10002.189560
720210190126 720210190126001 INSULIN NOVOLIN 9.64 12568.488328
720210190126002 INSULIN NOVOLIN 9.64 12568.488328
720210190126003 INSULIN NOVOLIN 9.64 12568.488328
721110260175 721110260175001 INSULIN NPH 61.44 7784.154032
722530160724 722530160724001 INSULIN NPH 61.44 15892.258263
722530160724002 INSULIN NPH 61.44 15892.258263
HC-051I 08:55 Tuesday, June 24, 2003 23
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
The MEANS Procedure
Analysis Variable : RXXP00X SUM OF PAYMENTS RXSF00X-RXOU00X(IMPUTED)
N Sum
--------------------
1428 66667.85
--------------------
HC-051I 08:55 Tuesday, June 24, 2003 24
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
Weighted
The MEANS Procedure
Analysis Variable : RXXP00X SUM OF PAYMENTS RXSF00X-RXOU00X(IMPUTED)
N Sum
--------------------
1428 714102690
--------------------
<< previous page