The SAS System 12:42 Thursday, September 22, 2005
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX09.
NOTE: SAS initialization used:
real time 2.28 seconds
cpu time 0.37 seconds
NOTE: AUTOEXEC processing beginning; file is C:\progra~1\sasins~1\sas\v8\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-077I";
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.12 seconds
cpu time 0.01 seconds
24
2 The SAS System 12:42 Thursday, September 22, 2005
25 *-------------------------------------------------------------------------------------
26 * Get condition records coded as asthma.
27 *-------------------------------------------------------------------------------------;
28 DATA ASCONDS;
29 SET IN.H78 (KEEP=CONDIDX CCCODEX);
30 IF CCCODEX="128";
31
32 RUN;
NOTE: There were 106279 observations read from the data set IN.H78.
NOTE: The data set WORK.ASCONDS has 1839 observations and 2 variables.
NOTE: DATA statement used:
real time 1.15 seconds
cpu time 0.23 seconds
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 1839 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1839 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.06 seconds
cpu time 0.03 seconds
38
39 proc print data=asconds (obs=50);
40 title3 "sample print of work.asconds - sorted by condidx";
41 title4 "COND (H78) 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.25 seconds
cpu time 0.06 seconds
43
44 PROC SORT DATA=IN.H77IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 343747 observations read from the data set IN.H77IF1.
NOTE: The data set WORK.CLNK has 343747 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 16.82 seconds
cpu time 2.24 seconds
45
46 DATA ASCLNKS;
47 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
48 ASCONDS(IN=INASCOND KEEP=CONDIDX);
49 BY CONDIDX;
3 The SAS System 12:42 Thursday, September 22, 2005
50 IF INCLNK & INASCOND;
51 RUN;
NOTE: There were 343747 observations read from the data set WORK.CLNK.
NOTE: There were 1839 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7392 observations and 3 variables.
NOTE: DATA statement used:
real time 0.73 seconds
cpu time 0.37 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;
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.06 seconds
cpu time 0.01 seconds
60
61 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7392 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7392 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.01 seconds
cpu time 0.01 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.03 seconds
cpu time 0.01 seconds
67
68 DATA ASCLNKS;
69 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
70 BY EVNTIDX;
71 IF FIRST.EVNTIDX;
72 RUN;
4 The SAS System 12:42 Thursday, September 22, 2005
NOTE: There were 7392 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7382 observations and 2 variables.
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.01 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.01 seconds
cpu time 0.01 seconds
78
79 *--------------------------------------------------------------------------------------------
80 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
81 *--------------------------------------------------------------------------------------------;
82 DATA MVIS;
83 SET IN.H77G (KEEP=EVNTIDX PERWT03F SEETLKPV);
84 IF PERWT03F > 0 & SEETLKPV NE 2;
85 RUN;
NOTE: There were 154853 observations read from the data set IN.H77G.
NOTE: The data set WORK.MVIS has 149794 observations and 3 variables.
NOTE: DATA statement used:
real time 3.85 seconds
cpu time 0.46 seconds
86
87 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 149794 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 149794 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.92 seconds
cpu time 0.56 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;
5 The SAS System 12:42 Thursday, September 22, 2005
NOTE: There were 7382 observations read from the data set WORK.ASCLNKS.
NOTE: There were 149794 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 2219 observations and 2 variables.
NOTE: DATA statement used:
real time 0.17 seconds
cpu time 0.15 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-077G) 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.01 seconds
cpu time 0.00 seconds
104
105 *-------------------------------------------------------------------------------------
106 * Get PMED IDs linked to the MVIS events which were for asthma.
107 *-------------------------------------------------------------------------------------;
108 PROC SORT DATA=IN.H77IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: There were 64605 observations read from the data set IN.H77IF2.
NOTE: The data set WORK.RXLK has 64605 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 0.43 seconds
cpu time 0.32 seconds
109
110 proc print data=rxlk (obs=140);
111 by evntidx;
112 id evntidx;
113 var linkidx eventype;
114 format eventype eventype.;
115 title3 "sample print of work.rxlk - sorted by evntidx";
116 title4 "Rx+event link file records (HC-77IF2)";
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.03 seconds
cpu time 0.03 seconds
118
119 DATA PMEDIDS;
120 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
121 ASMVIS(IN=INASMVIS KEEP=EVNTIDX);
122 BY EVNTIDX;
6 The SAS System 12:42 Thursday, September 22, 2005
123 IF INRXLK & INASMVIS;
124 RUN;
NOTE: There were 64605 observations read from the data set WORK.RXLK.
NOTE: There were 2219 observations read from the data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 2223 observations and 3 variables.
NOTE: DATA statement used:
real time 0.07 seconds
cpu time 0.07 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.01 seconds
cpu time 0.00 seconds
133
134 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 2223 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 2223 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.00 seconds
cpu time 0.00 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.03 seconds
cpu time 0.01 seconds
140
141 DATA PMEDIDS;
142 SET PMEDIDS (KEEP=LINKIDX);
143 BY LINKIDX;
144 IF FIRST.LINKIDX;
145 RUN;
7 The SAS System 12:42 Thursday, September 22, 2005
NOTE: There were 2223 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 2076 observations and 1 variables.
NOTE: DATA statement used:
real time 0.01 seconds
cpu 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.00 seconds
cpu time 0.00 seconds
150
151 *-----------------------------------------------------------------------------------------
152 * Get PMED records linked to MVIS events which were for asthma.
153 *-----------------------------------------------------------------------------------------;
154 PROC SORT DATA=IN.H77A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 304324 observations read from the data set IN.H77A.
NOTE: The data set WORK.PMED has 304324 observations and 13 variables.
NOTE: PROCEDURE SORT used:
real time 33.53 seconds
cpu time 4.12 seconds
155
156 DATA MVPMEDS;
157 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP03X PERWT03F RXNAME)
158 PMEDIDS (IN=A);
159 BY LINKIDX;
160 IF A;
161 RUN;
NOTE: There were 304324 observations read from the data set WORK.PMED.
NOTE: There were 2076 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 5940 observations and 5 variables.
NOTE: DATA statement used:
real time 0.43 seconds
cpu time 0.42 seconds
162
163 proc print data=mvpmeds (obs=200);
164 var rxrecidx rxname RXXP03X PERWT03F;
165 by linkidx;
166 id linkidx;
167 title3 "sample print of work.mvpmeds";
168 title4 "PMED (HC-077A) records for unique linkidxs in work.pmedids";
169 run;
8 The SAS System 12:42 Thursday, September 22, 2005
NOTE: There were 200 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE PRINT printed pages 16-21.
NOTE: PROCEDURE PRINT used:
real time 0.00 seconds
cpu time 0.00 seconds
170
171 PROC MEANS DATA=MVPMEDS N SUM;
172 VAR RXXP03X;
173 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
174 RUN;
NOTE: There were 5940 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 22.
NOTE: PROCEDURE MEANS used:
real time 0.09 seconds
cpu time 0.01 seconds
175
176 PROC MEANS DATA=MVPMEDS N SUM;
177 VAR RXXP03X;
178 WEIGHT PERWT03F;
179 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
180 TITLE5 "Weighted";
181 RUN;
NOTE: There were 5940 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used:
real time 0.01 seconds
cpu time 0.01 seconds
182
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 1:01.65
cpu time 9.78 seconds
HC-077I 12:42 Thursday, September 22, 2005 1
Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H78) records where cccodex=128
Obs CONDIDX CCCODEX
1 200260120036 128
2 200300100028 128
3 200340280018 128
4 200390220116 128
5 200410170097 128
6 200530380017 128
7 200540110059 128
8 200540230019 128
9 200640100022 128
10 200640100141 128
11 200680340054 128
12 200760300018 128
13 200880360010 128
14 200940110030 128
15 201090290010 128
16 201150170015 128
17 201290280019 128
18 201550320028 128
19 201790290043 128
20 201790320052 128
21 201790360014 128
22 201790590029 128
23 201840320043 128
24 201860330010 128
25 201930150013 128
26 201980300032 128
27 202170150026 128
28 202170290028 128
29 202240300029 128
30 202350170021 128
31 202600660049 128
32 202620130056 128
33 202650560036 128
34 202680360017 128
35 202680360051 128
36 202680430038 128
37 202680590038 128
38 202700210038 128
39 202740110040 128
40 202760300046 128
41 202900140013 128
42 203080160025 128
43 203600120037 128
44 203600290042 128
45 203650120019 128
46 203740440015 128
47 203840180080 128
48 203840250120 128
49 203840250142 128
50 204040400082 128
HC-077I 12:42 Thursday, September 22, 2005 2
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200260120036 200260121148 8 PMED
200260121155 8 PMED
200260121299 8 PMED
200260121326 8 PMED
200260121333 8 PMED
200340280018 200340280112 8 PMED
200340280143 8 PMED
200340280150 8 PMED
200340280218 8 PMED
200340280225 8 PMED
200340280270 8 PMED
200390220116 200390220541 8 PMED
200410170097 200410170370 8 PMED
200410170387 8 PMED
200540110059 200540110241 1 MVIS
200540110258 1 MVIS
200540110265 1 MVIS
200540110272 8 PMED
200540110296 8 PMED
200540110309 8 PMED
200540110316 8 PMED
200540110323 8 PMED
200540110330 8 PMED
200540110347 8 PMED
200540110378 8 PMED
200540230019 200540230215 1 MVIS
200540230239 8 PMED
200540230246 8 PMED
200540230253 8 PMED
200540230284 8 PMED
200640100022 200640100883 8 PMED
200640100890 8 PMED
200640101139 1 MVIS
200640101146 1 MVIS
200640101153 1 MVIS
200640101177 8 PMED
200640101273 8 PMED
200640101280 8 PMED
200640101317 8 PMED
200640101324 8 PMED
200640101331 1 MVIS
200640101348 1 MVIS
200640101355 1 MVIS
HC-077I 12:42 Thursday, September 22, 2005 3
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200640100022 200640101362 1 MVIS
200640101379 1 MVIS
200640101386 1 MVIS
200640101393 1 MVIS
200640101406 1 MVIS
200640101413 1 MVIS
200640101420 1 MVIS
200640101437 1 MVIS
200640101444 1 MVIS
200640101451 1 MVIS
200640101468 1 MVIS
200640101475 1 MVIS
200640101482 1 MVIS
200680340054 200680340170 8 PMED
200680340187 8 PMED
200760300018 200760300161 8 PMED
200940110030 200940110140 8 PMED
200940110164 8 PMED
201090290010 201090290040 8 PMED
201090290095 8 PMED
201150170015 201150170507 8 PMED
201150170514 8 PMED
201150170665 8 PMED
201150170716 8 PMED
201790290043 201790290410 1 MVIS
201790290650 8 PMED
201790290674 8 PMED
201790290821 1 MVIS
201790290838 1 MVIS
201790290845 1 MVIS
201790290852 1 MVIS
201790290869 1 MVIS
HC-077I 12:42 Thursday, September 22, 2005 4
Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 200260120036 200260121148 8 PMED
2 200260120036 200260121155 8 PMED
3 200260120036 200260121299 8 PMED
4 200260120036 200260121326 8 PMED
5 200260120036 200260121333 8 PMED
6 200340280018 200340280112 8 PMED
7 200340280018 200340280143 8 PMED
8 200340280018 200340280150 8 PMED
9 200340280018 200340280218 8 PMED
10 200340280018 200340280225 8 PMED
11 200340280018 200340280270 8 PMED
12 200390220116 200390220541 8 PMED
13 200410170097 200410170370 8 PMED
14 200410170097 200410170387 8 PMED
15 200540110059 200540110241 1 MVIS
16 200540110059 200540110258 1 MVIS
17 200540110059 200540110265 1 MVIS
18 200540110059 200540110272 8 PMED
19 200540110059 200540110296 8 PMED
20 200540110059 200540110309 8 PMED
21 200540110059 200540110316 8 PMED
22 200540110059 200540110323 8 PMED
23 200540110059 200540110330 8 PMED
24 200540110059 200540110347 8 PMED
25 200540110059 200540110378 8 PMED
26 200540230019 200540230215 1 MVIS
27 200540230019 200540230239 8 PMED
28 200540230019 200540230246 8 PMED
29 200540230019 200540230253 8 PMED
30 200540230019 200540230284 8 PMED
31 200640100022 200640100883 8 PMED
32 200640100022 200640100890 8 PMED
33 200640100022 200640101139 1 MVIS
34 200640100022 200640101146 1 MVIS
35 200640100022 200640101153 1 MVIS
36 200640100022 200640101177 8 PMED
37 200640100022 200640101273 8 PMED
38 200640100022 200640101280 8 PMED
39 200640100022 200640101317 8 PMED
40 200640100022 200640101324 8 PMED
41 200640100022 200640101331 1 MVIS
42 200640100022 200640101348 1 MVIS
43 200640100022 200640101355 1 MVIS
44 200640100022 200640101362 1 MVIS
45 200640100022 200640101379 1 MVIS
46 200640100022 200640101386 1 MVIS
47 200640100022 200640101393 1 MVIS
48 200640100022 200640101406 1 MVIS
49 200640100022 200640101413 1 MVIS
50 200640100022 200640101420 1 MVIS
HC-077I 12:42 Thursday, September 22, 2005 5
Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 200260121148 8 PMED
2 200260121155 8 PMED
3 200260121299 8 PMED
4 200260121326 8 PMED
5 200260121333 8 PMED
6 200340280112 8 PMED
7 200340280143 8 PMED
8 200340280150 8 PMED
9 200340280218 8 PMED
10 200340280225 8 PMED
11 200340280270 8 PMED
12 200390220541 8 PMED
13 200410170370 8 PMED
14 200410170387 8 PMED
15 200540110241 1 MVIS
16 200540110258 1 MVIS
17 200540110265 1 MVIS
18 200540110272 8 PMED
19 200540110296 8 PMED
20 200540110309 8 PMED
21 200540110316 8 PMED
22 200540110323 8 PMED
23 200540110330 8 PMED
24 200540110347 8 PMED
25 200540110378 8 PMED
26 200540230215 1 MVIS
27 200540230239 8 PMED
28 200540230246 8 PMED
29 200540230253 8 PMED
30 200540230284 8 PMED
31 200640100883 8 PMED
32 200640100890 8 PMED
33 200640101139 1 MVIS
34 200640101146 1 MVIS
35 200640101153 1 MVIS
36 200640101177 8 PMED
37 200640101273 8 PMED
38 200640101280 8 PMED
39 200640101317 8 PMED
40 200640101324 8 PMED
41 200640101331 1 MVIS
42 200640101348 1 MVIS
43 200640101355 1 MVIS
44 200640101362 1 MVIS
45 200640101379 1 MVIS
46 200640101386 1 MVIS
47 200640101393 1 MVIS
48 200640101406 1 MVIS
49 200640101413 1 MVIS
50 200640101420 1 MVIS
HC-077I 12:42 Thursday, September 22, 2005 6
Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-077G) events
Obs EVNTIDX EVENTYPE
1 200540110241 1 MVIS
2 200540110258 1 MVIS
3 200540110265 1 MVIS
4 200540230215 1 MVIS
5 200640101139 1 MVIS
6 200640101146 1 MVIS
7 200640101153 1 MVIS
8 200640101331 1 MVIS
9 200640101348 1 MVIS
10 200640101355 1 MVIS
11 200640101362 1 MVIS
12 200640101379 1 MVIS
13 200640101386 1 MVIS
14 200640101393 1 MVIS
15 200640101406 1 MVIS
16 200640101413 1 MVIS
17 200640101420 1 MVIS
18 200640101437 1 MVIS
19 200640101444 1 MVIS
20 200640101451 1 MVIS
21 200640101468 1 MVIS
22 200640101475 1 MVIS
23 200640101482 1 MVIS
24 201790290410 1 MVIS
25 201790290821 1 MVIS
26 201790290838 1 MVIS
27 201790290845 1 MVIS
28 201790290852 1 MVIS
29 201790290869 1 MVIS
30 201790290876 1 MVIS
31 201790290903 1 MVIS
32 201790360232 1 MVIS
33 201860330161 1 MVIS
34 201860330229 1 MVIS
35 201860330236 1 MVIS
36 201860330243 1 MVIS
37 201860330250 1 MVIS
38 201930150018 1 MVIS
39 202170150639 1 MVIS
40 202170150646 1 MVIS
41 202620130491 1 MVIS
42 202620130504 1 MVIS
43 202620130511 1 MVIS
44 202620130528 1 MVIS
45 202620130542 1 MVIS
46 202620130782 1 MVIS
47 202650560365 1 MVIS
48 202650560430 1 MVIS
49 202650560447 1 MVIS
50 202650560454 1 MVIS
HC-077I 12:42 Thursday, September 22, 2005 7
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-77IF2)
EVNTIDX LINKIDX EVENTYPE
200020380044 200020380051 3 EROM
200020380068 3 EROM
200030110018 200030110049 1 MVIS
200030190154 200030190161 1 MVIS
200030260332 200030260363 1 MVIS
200040180290 200040180327 1 MVIS
200040180303 200040180334 1 MVIS
200040180341 200040180365 1 MVIS
200040180358 200040180372 1 MVIS
200070160070 200070160107 5 DVIS
200070160121 200070160169 1 MVIS
200140110148 200140110131 1 MVIS
200140240440 200140240471 1 MVIS
200150190081 200150190101 1 MVIS
200150190118 1 MVIS
200150190125 1 MVIS
200150190132 1 MVIS
200150190194 200150190245 2 OPAT
200150190207 200150190252 1 MVIS
200150190290 200150190303 1 MVIS
200150190310 1 MVIS
200150190327 1 MVIS
200150190334 1 MVIS
200150190341 1 MVIS
200150190358 1 MVIS
200150260012 200150260043 1 MVIS
200160130011 200160130073 1 MVIS
200170120180 200170120217 1 MVIS
200170120231 200170120286 2 OPAT
200170120293 2 OPAT
HC-077I 12:42 Thursday, September 22, 2005 8
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-77IF2)
EVNTIDX LINKIDX EVENTYPE
200190140130 200190140147 1 MVIS
200190140154 1 MVIS
200190140161 1 MVIS
200190140192 200190140212 1 MVIS
200200160278 200200160312 1 MVIS
200210100083 200210100141 1 MVIS
200210100158 1 MVIS
200210100165 1 MVIS
200210270103 200210270110 1 MVIS
200210270127 1 MVIS
200210340134 200210340158 1 MVIS
200210410045 200210410076 1 MVIS
200220220026 200220220033 1 MVIS
200230100063 200230100107 1 MVIS
200230100114 1 MVIS
200230100070 200230100121 1 MVIS
200230100138 200230100152 1 MVIS
200230100169 1 MVIS
200260290809 200260290861 1 MVIS
200270100088 200270100139 1 MVIS
200270100095 200270100146 1 MVIS
200320100192 200320100243 1 MVIS
200320100250 1 MVIS
200320100267 1 MVIS
200320100274 1 MVIS
200320100281 1 MVIS
200320100298 1 MVIS
200320270058 200320270089 1 MVIS
200320340041 200320340089 1 MVIS
200330150118 200330150125 3 EROM
200340110218 200340110249 1 MVIS
HC-077I 12:42 Thursday, September 22, 2005 9
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-77IF2)
EVNTIDX LINKIDX EVENTYPE
200340280167 200340280181 1 MVIS
200340280198 1 MVIS
200340280232 200340280249 1 MVIS
200350180068 200350180082 5 DVIS
200350180099 5 DVIS
200390150096 200390150123 5 DVIS
200390150130 5 DVIS
200390220325 200390220356 1 MVIS
200390220407 200390220476 1 MVIS
200390220483 1 MVIS
200390220490 1 MVIS
200390220445 200390220510 1 MVIS
200390220534 200390220541 1 MVIS
200410170407 200410170510 1 MVIS
200410170527 1 MVIS
200450150111 200450150159 1 MVIS
200450150200 200450150217 1 MVIS
200450150224 1 MVIS
200460470063 200460470070 1 MVIS
200460470094 200460470107 1 MVIS
200480150114 200480150532 4 STAZ
200480150549 4 STAZ
200480150556 4 STAZ
200480150474 200480150563 1 MVIS
200480150607 200480150621 1 MVIS
200490150117 200490150131 1 MVIS
200490150148 1 MVIS
200490150124 200490150155 3 EROM
200490150162 200490150179 4 STAZ
200490460011 200490460028 1 MVIS
HC-077I 12:42 Thursday, September 22, 2005 10
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-77IF2)
EVNTIDX LINKIDX EVENTYPE
200490460035 200490460059 1 MVIS
200490460042 200490460066 5 DVIS
200510130171 200510130208 1 MVIS
200510130222 200510130239 1 MVIS
200520110035 200520110042 5 DVIS
200520140070 200520140094 1 MVIS
200530140031 200530140106 2 OPAT
200530140113 2 OPAT
200530380137 200530380144 2 OPAT
200540110241 200540110272 1 MVIS
200540110289 1 MVIS
200540110296 1 MVIS
200540110309 1 MVIS
200540110316 1 MVIS
200540110323 1 MVIS
200540110330 1 MVIS
200540160260 200540160304 1 MVIS
200540160277 200540160311 1 MVIS
200540160328 200540160373 1 MVIS
200540160380 1 MVIS
200540160397 1 MVIS
200540230133 200540230195 1 MVIS
200540230208 1 MVIS
200540230215 200540230239 1 MVIS
200540230246 1 MVIS
200540230253 1 MVIS
200540230260 1 MVIS
200540230222 200540230277 1 MVIS
200560180053 200560180077 3 EROM
200590180045 200590180052 3 EROM
200590180083 200590180134 3 EROM
200590180141 3 EROM
HC-077I 12:42 Thursday, September 22, 2005 11
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-77IF2)
EVNTIDX LINKIDX EVENTYPE
200600100227 200600100258 1 MVIS
200600100265 1 MVIS
200600100272 1 MVIS
200610130137 200610130151 1 MVIS
200610130168 1 MVIS
200610130175 1 MVIS
200640101122 200640101160 1 MVIS
200640101139 200640101177 1 MVIS
200680270043 200680270074 5 DVIS
200680270081 5 DVIS
200680340101 200680340132 1 MVIS
200680340149 1 MVIS
200700260345 200700260383 1 MVIS
200700330054 200700330061 1 MVIS
200700480176 200700480190 1 MVIS
200700480210 200700480227 1 MVIS
200720190272 200720190323 4 STAZ
HC-077I 12:42 Thursday, September 22, 2005 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
200540110241 200540110272 1 MVIS
200540110289 1 MVIS
200540110296 1 MVIS
200540110309 1 MVIS
200540110316 1 MVIS
200540110323 1 MVIS
200540110330 1 MVIS
200540230215 200540230239 1 MVIS
200540230246 1 MVIS
200540230253 1 MVIS
200540230260 1 MVIS
200640101139 200640101177 1 MVIS
201790290410 201790290650 1 MVIS
201790290667 1 MVIS
201790290674 1 MVIS
201790290681 1 MVIS
201790290698 1 MVIS
201790290701 1 MVIS
201790290718 1 MVIS
201790290725 1 MVIS
201790290732 1 MVIS
201790290756 1 MVIS
201790290763 1 MVIS
201790290770 1 MVIS
201790290787 1 MVIS
201790290794 1 MVIS
201790290821 201790290965 1 MVIS
201790290972 1 MVIS
201790290989 1 MVIS
201790290996 1 MVIS
201790291002 1 MVIS
201790291019 1 MVIS
201790291026 1 MVIS
201790291033 1 MVIS
201790291040 1 MVIS
201790291057 1 MVIS
201790291064 1 MVIS
201790291071 1 MVIS
201790291088 1 MVIS
201790291095 1 MVIS
201790290838 201790290965 1 MVIS
201790290972 1 MVIS
201790290989 1 MVIS
201790290996 1 MVIS
HC-077I 12:42 Thursday, September 22, 2005 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
201790290838 201790291002 1 MVIS
201790291019 1 MVIS
201790291026 1 MVIS
201790291033 1 MVIS
201790291040 1 MVIS
201790291057 1 MVIS
HC-077I 12:42 Thursday, September 22, 2005 14
Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx
Obs EVNTIDX LINKIDX EVENTYPE
1 200540110241 200540110272 1 MVIS
2 200540110241 200540110289 1 MVIS
3 200540110241 200540110296 1 MVIS
4 200540110241 200540110309 1 MVIS
5 200540110241 200540110316 1 MVIS
6 200540110241 200540110323 1 MVIS
7 200540110241 200540110330 1 MVIS
8 200540230215 200540230239 1 MVIS
9 200540230215 200540230246 1 MVIS
10 200540230215 200540230253 1 MVIS
11 200540230215 200540230260 1 MVIS
12 200640101139 200640101177 1 MVIS
13 201790290410 201790290650 1 MVIS
14 201790290410 201790290667 1 MVIS
15 201790290410 201790290674 1 MVIS
16 201790290410 201790290681 1 MVIS
17 201790290410 201790290698 1 MVIS
18 201790290410 201790290701 1 MVIS
19 201790290410 201790290718 1 MVIS
20 201790290410 201790290725 1 MVIS
21 201790290410 201790290732 1 MVIS
22 201790290410 201790290756 1 MVIS
23 201790290410 201790290763 1 MVIS
24 201790290410 201790290770 1 MVIS
25 201790290410 201790290787 1 MVIS
26 201790290410 201790290794 1 MVIS
27 201790290821 201790290965 1 MVIS
28 201790290838 201790290965 1 MVIS
29 201790290876 201790290965 1 MVIS
30 201790290821 201790290972 1 MVIS
31 201790290838 201790290972 1 MVIS
32 201790290876 201790290972 1 MVIS
33 201790290821 201790290989 1 MVIS
34 201790290838 201790290989 1 MVIS
35 201790290876 201790290989 1 MVIS
36 201790290821 201790290996 1 MVIS
37 201790290838 201790290996 1 MVIS
38 201790290876 201790290996 1 MVIS
39 201790290821 201790291002 1 MVIS
40 201790290838 201790291002 1 MVIS
41 201790290876 201790291002 1 MVIS
42 201790290821 201790291019 1 MVIS
43 201790290838 201790291019 1 MVIS
44 201790290876 201790291019 1 MVIS
45 201790290821 201790291026 1 MVIS
46 201790290838 201790291026 1 MVIS
47 201790290876 201790291026 1 MVIS
48 201790290821 201790291033 1 MVIS
49 201790290838 201790291033 1 MVIS
50 201790290876 201790291033 1 MVIS
HC-077I 12:42 Thursday, September 22, 2005 15
Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids
Obs LINKIDX
1 200540110272
2 200540110289
3 200540110296
4 200540110309
5 200540110316
6 200540110323
7 200540110330
8 200540230239
9 200540230246
10 200540230253
11 200540230260
12 200640101177
13 201790290650
14 201790290667
15 201790290674
16 201790290681
17 201790290698
18 201790290701
19 201790290718
20 201790290725
21 201790290732
22 201790290756
23 201790290763
24 201790290770
25 201790290787
26 201790290794
27 201790290965
28 201790290972
29 201790290989
30 201790290996
31 201790291002
32 201790291019
33 201790291026
34 201790291033
35 201790291040
36 201790291057
37 201790291064
38 201790291071
39 201790291088
40 201790291095
41 201790360249
42 201790360256
43 201790360263
44 201860330267
45 201930150025
46 201930150032
47 202170150653
48 202620130819
49 202620130826
50 202620130833
HC-077I 12:42 Thursday, September 22, 2005 16
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
200540110272 200540110272001 ORAPRED 28.52 5774.720123
200540110272002 ORAPRED 28.52 5774.720123
200540110272003 ORAPRED 28.52 5774.720123
200540110272004 ORAPRED 28.52 5774.720123
200540110289 200540110289001 ZANTAC 29.60 5774.720123
200540110289002 ZANTAC 29.60 5774.720123
200540110289003 ZANTAC 29.60 5774.720123
200540110289004 ZANTAC 29.60 5774.720123
200540110296 200540110296001 REGLAN 35.20 5774.720123
200540110296002 REGLAN 35.20 5774.720123
200540110296003 REGLAN 35.20 5774.720123
200540110296004 REGLAN 35.20 5774.720123
200540110309 200540110309001 PULMICORT 129.85 5774.720123
200540110309002 PULMICORT 129.85 5774.720123
200540110309003 PULMICORT 129.85 5774.720123
200540110309004 PULMICORT 129.85 5774.720123
200540110316 200540110316001 ALBUTEROL 21.41 5774.720123
200540110316002 ALBUTEROL 21.41 5774.720123
200540110316003 ALBUTEROL 21.41 5774.720123
200540110316004 ALBUTEROL 21.41 5774.720123
200540110316005 ALBUTEROL 21.41 5774.720123
200540110323 200540110323001 FLOVENT 81.06 5774.720123
200540110323002 FLOVENT 81.06 5774.720123
200540110323003 FLOVENT 81.06 5774.720123
200540110323004 FLOVENT 81.06 5774.720123
200540110323005 FLOVENT 81.06 5774.720123
200540110330 200540110330001 SINGULAIR 82.75 5774.720123
200540110330002 SINGULAIR 82.75 5774.720123
200540110330003 SINGULAIR 82.75 5774.720123
200540110330004 SINGULAIR 82.75 5774.720123
200540110330005 SINGULAIR 82.75 5774.720123
200540230239 200540230239001 FLOVENT 81.06 7793.388531
200540230239002 FLOVENT 81.06 7793.388531
200540230239003 FLOVENT 81.06 7793.388531
200540230239004 FLOVENT 81.06 7793.388531
200540230239005 FLOVENT 81.06 7793.388531
200540230246 200540230246001 NEBULIZER 187.02 7793.388531
200540230246002 NEBULIZER 187.02 7793.388531
200540230246003 NEBULIZER 187.02 7793.388531
200540230253 200540230253001 ALBUTEROL 21.41 7793.388531
HC-077I 12:42 Thursday, September 22, 2005 17
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
200540230253 200540230253002 ALBUTEROL 21.41 7793.388531
200540230253003 ALBUTEROL 21.41 7793.388531
200540230253004 ALBUTEROL 21.41 7793.388531
200540230253005 ALBUTEROL 21.41 7793.388531
200540230260 200540230260001 ALLEGRA 42.35 7793.388531
200540230260002 ALLEGRA 42.35 7793.388531
200640101177 200640101177001 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177002 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177003 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177004 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177005 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177006 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177007 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177008 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177009 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177010 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177011 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177012 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177013 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177014 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177015 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177016 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177017 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177018 WE ALLERGY (GRAPE) 17.76 12752.916659
201790290650 201790290650001 ALBUTEROL 42.82 2626.868553
201790290650002 ALBUTEROL 42.82 2626.868553
201790290650003 ALBUTEROL 42.82 2626.868553
201790290667 201790290667001 ULTRAM 24.38 2626.868553
201790290667002 ULTRAM 24.38 2626.868553
201790290667003 ULTRAM 24.38 2626.868553
201790290674 201790290674001 SINGULAIR 86.56 2626.868553
201790290674002 SINGULAIR 86.56 2626.868553
201790290674003 SINGULAIR 86.56 2626.868553
201790290674004 SINGULAIR 86.56 2626.868553
201790290681 201790290681001 ALTACE 53.66 2626.868553
201790290681002 ALTACE 53.66 2626.868553
201790290681003 ALTACE 53.66 2626.868553
201790290698 201790290698001 GUAIFENEX DM 17.18 2626.868553
201790290698002 GUAIFENEX DM 17.18 2626.868553
201790290698003 GUAIFENEX DM 17.18 2626.868553
201790290701 201790290701001 NEURONTIN 50.04 2626.868553
HC-077I 12:42 Thursday, September 22, 2005 18
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
201790290701 201790290701002 NEURONTIN 50.04 2626.868553
201790290701003 NEURONTIN 50.04 2626.868553
201790290701004 NEURONTIN 50.04 2626.868553
201790290718 201790290718001 AMITRIPTYLINE HCL 32.40 2626.868553
201790290718002 AMITRIPTYLINE HCL 32.40 2626.868553
201790290718003 AMITRIPTYLINE HCL 32.40 2626.868553
201790290725 201790290725001 ANEMAGEN (10X10) 12.20 2626.868553
201790290732 201790290732001 ZOLOFT 70.20 2626.868553
201790290756 201790290756001 HYDROCODONE/APAP 5.82 2626.868553
201790290756002 HYDROCODONE/APAP 5.82 2626.868553
201790290756003 HYDROCODONE/APAP 5.82 2626.868553
201790290763 201790290763001 IBUPROFEN 18.29 2626.868553
201790290763002 IBUPROFEN 18.29 2626.868553
201790290770 201790290770001 TRAMADOL HCL 50.25 2626.868553
201790290770002 TRAMADOL HCL 50.25 2626.868553
201790290787 201790290787001 CYCLOBENZAPRINE HCL 17.23 2626.868553
201790290794 201790290794001 DITROPAN XL 101.24 2626.868553
201790290794002 DITROPAN XL 101.24 2626.868553
201790290965 201790290965001 ALBUTEROL 42.82 2626.868553
201790290965002 ALBUTEROL 42.82 2626.868553
201790290965003 ALBUTEROL 42.82 2626.868553
201790290965004 ALBUTEROL 42.82 2626.868553
201790290965005 ALBUTEROL 42.82 2626.868553
201790290965006 ALBUTEROL 42.82 2626.868553
201790290965007 ALBUTEROL 42.82 2626.868553
201790290965008 ALBUTEROL 42.82 2626.868553
201790290965009 ALBUTEROL 42.82 2626.868553
201790290965010 ALBUTEROL 42.82 2626.868553
201790290965011 ALBUTEROL 42.82 2626.868553
201790290965012 ALBUTEROL 42.82 2626.868553
201790290972 201790290972001 ULTRAM 24.38 2626.868553
201790290972002 ULTRAM 24.38 2626.868553
201790290972003 ULTRAM 24.38 2626.868553
201790290989 201790290989001 ALTACE 53.66 2626.868553
201790290989002 ALTACE 53.66 2626.868553
201790290989003 ALTACE 53.66 2626.868553
201790290996 201790290996001 SINGULAIR (UNIT OF USE) 91.61 2626.868553
HC-077I 12:42 Thursday, September 22, 2005 19
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
201790290996 201790290996002 SINGULAIR (UNIT OF USE) 91.61 2626.868553
201790290996003 SINGULAIR (UNIT OF USE) 91.61 2626.868553
201790290996004 SINGULAIR (UNIT OF USE) 91.61 2626.868553
201790290996005 SINGULAIR (UNIT OF USE) 91.61 2626.868553
201790290996006 SINGULAIR (UNIT OF USE) 91.61 2626.868553
201790291002 201790291002001 GUAIFENEX DM 17.18 2626.868553
201790291002002 GUAIFENEX DM 17.18 2626.868553
201790291019 201790291019001 NEURONTIN 50.04 2626.868553
201790291019002 NEURONTIN 50.04 2626.868553
201790291019003 NEURONTIN 50.04 2626.868553
201790291019004 NEURONTIN 50.04 2626.868553
201790291019005 NEURONTIN 50.04 2626.868553
201790291026 201790291026001 AMITRIPTYLINE HCL 32.40 2626.868553
201790291026002 AMITRIPTYLINE HCL 32.40 2626.868553
201790291026003 AMITRIPTYLINE HCL 32.40 2626.868553
201790291026004 AMITRIPTYLINE HCL 32.40 2626.868553
201790291033 201790291033001 ANEMAGEN (10X10) 12.20 2626.868553
201790291033002 ANEMAGEN (10X10) 12.20 2626.868553
201790291033003 ANEMAGEN (10X10) 12.20 2626.868553
201790291033004 ANEMAGEN (10X10) 12.20 2626.868553
201790291033005 ANEMAGEN (10X10) 12.20 2626.868553
201790291033006 ANEMAGEN (10X10) 12.20 2626.868553
201790291040 201790291040001 ZOLOFT 79.40 2626.868553
201790291040002 ZOLOFT 79.40 2626.868553
201790291057 201790291057001 FLUNISOLIDE 68.21 2626.868553
201790291057002 FLUNISOLIDE 68.21 2626.868553
201790291057003 FLUNISOLIDE 68.21 2626.868553
201790291064 201790291064001 HYDROCODONE/APAP 5.82 2626.868553
201790291064002 HYDROCODONE/APAP 5.82 2626.868553
201790291064003 HYDROCODONE/APAP 5.82 2626.868553
201790291071 201790291071001 IBUPROFEN 18.29 2626.868553
201790291071002 IBUPROFEN 18.29 2626.868553
201790291071003 IBUPROFEN 18.29 2626.868553
201790291071004 IBUPROFEN 18.29 2626.868553
201790291071005 IBUPROFEN 18.29 2626.868553
201790291088 201790291088001 TRAMADOL HCL 50.25 2626.868553
201790291088002 TRAMADOL HCL 50.25 2626.868553
201790291088003 TRAMADOL HCL 50.25 2626.868553
201790291095 201790291095001 DITROPAN XL 101.24 2626.868553
HC-077I 12:42 Thursday, September 22, 2005 20
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
201790291095 201790291095002 DITROPAN XL 101.24 2626.868553
201790360249 201790360249001 THEOPHYLLINE 39.18 4144.408785
201790360249002 THEOPHYLLINE 39.18 4144.408785
201790360249003 THEOPHYLLINE 39.18 4144.408785
201790360256 201790360256001 ALBUTEROL 29.00 4144.408785
201790360256002 ALBUTEROL 29.00 4144.408785
201790360256003 ALBUTEROL 29.00 4144.408785
201790360256004 ALBUTEROL 29.00 4144.408785
201790360256005 ALBUTEROL 29.00 4144.408785
201790360256006 ALBUTEROL 29.00 4144.408785
201790360256007 ALBUTEROL 29.00 4144.408785
201790360256008 ALBUTEROL 29.00 4144.408785
201790360256009 ALBUTEROL 29.00 4144.408785
201790360256010 ALBUTEROL 29.00 4144.408785
201790360256011 ALBUTEROL 29.00 4144.408785
201790360256012 ALBUTEROL 29.00 4144.408785
201790360256013 ALBUTEROL 29.00 4144.408785
201790360256014 ALBUTEROL 29.00 4144.408785
201790360256015 ALBUTEROL 29.00 4144.408785
201790360256016 ALBUTEROL 29.00 4144.408785
201790360256017 ALBUTEROL 29.00 4144.408785
201790360256018 ALBUTEROL 29.00 4144.408785
201790360263 201790360263001 SINGULAR 107.07 4144.408785
201790360263002 SINGULAR 107.07 4144.408785
201860330267 201860330267001 CONCERTA 75.56 3205.761224
201860330267002 CONCERTA 75.56 3205.761224
201860330267003 CONCERTA 75.56 3205.761224
201930150025 201930150025001 CUTIVATE 42.89 3820.382576
201930150032 201930150032001 ALBUTEROL 24.90 3820.382576
202170150653 202170150653001 ALBUTEROL 21.41 10143.491415
202170150653002 ALBUTEROL 21.41 10143.491415
202170150653003 ALBUTEROL 21.41 10143.491415
202620130819 202620130819001 AMLODIPINE 40.13 6639.386741
202620130826 202620130826001 COMBIVENT 59.91 6639.386741
202620130833 202620130833001 SIMVASTATIN 172.86 6639.386741
202650560372 202650560372001 INSULIN 70/30 HUMAN 138.99 3495.424052
202650560372002 INSULIN 70/30 HUMAN 138.99 3495.424052
202650560372003 INSULIN 70/30 HUMAN 138.99 3495.424052
HC-077I 12:42 Thursday, September 22, 2005 21
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
202650560372 202650560372004 INSULIN 70/30 HUMAN 138.99 3495.424052
202650560372005 INSULIN 70/30 HUMAN 138.99 3495.424052
202650560372006 INSULIN 70/30 HUMAN 138.99 3495.424052
202650560389 202650560389001 GLUCOPHAGE 48.81 3495.424052
202650560389002 GLUCOPHAGE 48.81 3495.424052
HC-077I 12:42 Thursday, September 22, 2005 22
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
The MEANS Procedure
Analysis Variable : RXXP03X SUM OF PAYMENTS RXSF03X-RXOU03X(IMPUTED)
N Sum
--------------------
5940 414530.63
--------------------
HC-077I 12:42 Thursday, September 22, 2005 23
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP03X SUM OF PAYMENTS RXSF03X-RXOU03X(IMPUTED)
N Sum
--------------------
5940 3206154580
--------------------
1 The SAS System 12:44 Thursday, September 22, 2005
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX09.
NOTE: SAS initialization used:
real time 1.76 seconds
cpu time 0.45 seconds
NOTE: AUTOEXEC processing beginning; file is C:\progra~1\sasins~1\sas\v8\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-077I";
4 TITLE2 'Sample SAS Job for Example B';
5
6 LIBNAME IN '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 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.12 seconds
cpu time 0.01 seconds
22
23 *--------------------------------------------------------------------------------------
24 * Get condition records coded as asthma.
2 The SAS System 12:44 Thursday, September 22, 2005
25 *--------------------------------------------------------------------------------------;
26 DATA ASCONDS;
27 SET IN.H78 (KEEP=CONDIDX CCCODEX);
28 IF CCCODEX="128";
29 RUN;
NOTE: There were 106279 observations read from the data set IN.H78.
NOTE: The data set WORK.ASCONDS has 1839 observations and 2 variables.
NOTE: DATA statement used:
real time 1.46 seconds
cpu time 0.20 seconds
30
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 1839 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1839 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.04 seconds
cpu time 0.03 seconds
35
36 proc print data=asconds (obs=50);
37 title3 "sample print of work.asconds - sorted by condidx";
38 title4 "COND (H78) 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.20 seconds
cpu time 0.04 seconds
40
41 PROC SORT DATA=IN.H77IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 343747 observations read from the data set IN.H77IF1.
NOTE: The data set WORK.CLNK has 343747 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 16.71 seconds
cpu time 1.99 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;
3 The SAS System 12:44 Thursday, September 22, 2005
NOTE: There were 343747 observations read from the data set WORK.CLNK.
NOTE: There were 1839 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7392 observations and 3 variables.
NOTE: DATA statement used:
real time 0.92 seconds
cpu time 0.38 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.
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used:
real time 0.07 seconds
cpu time 0.04 seconds
57
58 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7392 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7392 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.03 seconds
cpu time 0.03 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.01 seconds
cpu time 0.01 seconds
64
65 DATA ASCLNKS;
66 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
67 BY EVNTIDX;
68 IF FIRST.EVNTIDX;
69 RUN;
NOTE: There were 7392 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7382 observations and 2 variables.
NOTE: DATA statement used:
4 The SAS System 12:44 Thursday, September 22, 2005
real time 0.01 seconds
cpu time 0.01 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.01 seconds
cpu time 0.01 seconds
75
76 *-------------------------------------------------------------------------------
77 * Get PMED records linked to asthma condition records.
78 *-------------------------------------------------------------------------------;
79 PROC SORT DATA=IN.H77A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 304324 observations read from the data set IN.H77A.
NOTE: The data set WORK.PMED has 304324 observations and 13 variables.
NOTE: PROCEDURE SORT used:
real time 34.09 seconds
cpu time 4.10 seconds
80
81 DATA ASPMEDS;
82 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP03X PERWT03F)
83 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX RENAME=(EVNTIDX=LINKIDX));
84 BY LINKIDX;
85 IF INASCLNK & PERWT03F>0;
86 RUN;
NOTE: There were 304324 observations read from the data set WORK.PMED.
NOTE: There were 7382 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 10833 observations and 5 variables.
NOTE: DATA statement used:
real time 0.51 seconds
cpu time 0.48 seconds
87
88 proc print data=aspmeds (obs=300);
89 by linkidx;
90 id linkidx;
91 var rxrecidx rxname RXXP03X PERWT03F;
92 title3 "sample print of work.aspmeds";
93 title4 "PMED (HC-077A) 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-14.
5 The SAS System 12:44 Thursday, September 22, 2005
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.01 seconds
95
96 PROC MEANS DATA=ASPMEDS N SUM;
97 VAR RXXP03X;
98 TITLE3 "Total Rx expenditures associated with asthma";
99 RUN;
NOTE: There were 10833 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 15.
NOTE: PROCEDURE MEANS used:
real time 0.07 seconds
cpu time 0.00 seconds
100
101 PROC MEANS DATA=ASPMEDS N SUM;
102 VAR RXXP03X;
103 WEIGHT PERWT03F;
104 TITLE3 "Total Rx expenditures associated with asthma";
105 TITLE5 "Weighted";
106 RUN;
NOTE: There were 10833 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 16.
NOTE: PROCEDURE MEANS used:
real time 0.03 seconds
cpu time 0.01 seconds
107
108
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 56.51 seconds
cpu time 7.93 seconds
HC-077I 12:44 Thursday, September 22, 2005 1
Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H78) records where cccodex=128
Obs CONDIDX CCCODEX
1 200260120036 128
2 200300100028 128
3 200340280018 128
4 200390220116 128
5 200410170097 128
6 200530380017 128
7 200540110059 128
8 200540230019 128
9 200640100022 128
10 200640100141 128
11 200680340054 128
12 200760300018 128
13 200880360010 128
14 200940110030 128
15 201090290010 128
16 201150170015 128
17 201290280019 128
18 201550320028 128
19 201790290043 128
20 201790320052 128
21 201790360014 128
22 201790590029 128
23 201840320043 128
24 201860330010 128
25 201930150013 128
26 201980300032 128
27 202170150026 128
28 202170290028 128
29 202240300029 128
30 202350170021 128
31 202600660049 128
32 202620130056 128
33 202650560036 128
34 202680360017 128
35 202680360051 128
36 202680430038 128
37 202680590038 128
38 202700210038 128
39 202740110040 128
40 202760300046 128
41 202900140013 128
42 203080160025 128
43 203600120037 128
44 203600290042 128
45 203650120019 128
46 203740440015 128
47 203840180080 128
48 203840250120 128
49 203840250142 128
50 204040400082 128
HC-077I 12:44 Thursday, September 22, 2005 2
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200260120036 200260121148 8 PMED
200260121155 8 PMED
200260121299 8 PMED
200260121326 8 PMED
200260121333 8 PMED
200340280018 200340280112 8 PMED
200340280143 8 PMED
200340280150 8 PMED
200340280218 8 PMED
200340280225 8 PMED
200340280270 8 PMED
200390220116 200390220541 8 PMED
200410170097 200410170370 8 PMED
200410170387 8 PMED
200540110059 200540110241 1 MVIS
200540110258 1 MVIS
200540110265 1 MVIS
200540110272 8 PMED
200540110296 8 PMED
200540110309 8 PMED
200540110316 8 PMED
200540110323 8 PMED
200540110330 8 PMED
200540110347 8 PMED
200540110378 8 PMED
200540230019 200540230215 1 MVIS
200540230239 8 PMED
200540230246 8 PMED
200540230253 8 PMED
200540230284 8 PMED
200640100022 200640100883 8 PMED
200640100890 8 PMED
200640101139 1 MVIS
200640101146 1 MVIS
200640101153 1 MVIS
200640101177 8 PMED
200640101273 8 PMED
200640101280 8 PMED
200640101317 8 PMED
200640101324 8 PMED
200640101331 1 MVIS
200640101348 1 MVIS
200640101355 1 MVIS
HC-077I 12:44 Thursday, September 22, 2005 3
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200640100022 200640101362 1 MVIS
200640101379 1 MVIS
200640101386 1 MVIS
200640101393 1 MVIS
200640101406 1 MVIS
200640101413 1 MVIS
200640101420 1 MVIS
200640101437 1 MVIS
200640101444 1 MVIS
200640101451 1 MVIS
200640101468 1 MVIS
200640101475 1 MVIS
200640101482 1 MVIS
200680340054 200680340170 8 PMED
200680340187 8 PMED
200760300018 200760300161 8 PMED
200940110030 200940110140 8 PMED
200940110164 8 PMED
201090290010 201090290040 8 PMED
201090290095 8 PMED
201150170015 201150170507 8 PMED
201150170514 8 PMED
201150170665 8 PMED
201150170716 8 PMED
201790290043 201790290410 1 MVIS
201790290650 8 PMED
201790290674 8 PMED
201790290821 1 MVIS
201790290838 1 MVIS
201790290845 1 MVIS
201790290852 1 MVIS
201790290869 1 MVIS
HC-077I 12:44 Thursday, September 22, 2005 4
Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 200260120036 200260121148 8 PMED
2 200260120036 200260121155 8 PMED
3 200260120036 200260121299 8 PMED
4 200260120036 200260121326 8 PMED
5 200260120036 200260121333 8 PMED
6 200340280018 200340280112 8 PMED
7 200340280018 200340280143 8 PMED
8 200340280018 200340280150 8 PMED
9 200340280018 200340280218 8 PMED
10 200340280018 200340280225 8 PMED
11 200340280018 200340280270 8 PMED
12 200390220116 200390220541 8 PMED
13 200410170097 200410170370 8 PMED
14 200410170097 200410170387 8 PMED
15 200540110059 200540110241 1 MVIS
16 200540110059 200540110258 1 MVIS
17 200540110059 200540110265 1 MVIS
18 200540110059 200540110272 8 PMED
19 200540110059 200540110296 8 PMED
20 200540110059 200540110309 8 PMED
21 200540110059 200540110316 8 PMED
22 200540110059 200540110323 8 PMED
23 200540110059 200540110330 8 PMED
24 200540110059 200540110347 8 PMED
25 200540110059 200540110378 8 PMED
26 200540230019 200540230215 1 MVIS
27 200540230019 200540230239 8 PMED
28 200540230019 200540230246 8 PMED
29 200540230019 200540230253 8 PMED
30 200540230019 200540230284 8 PMED
31 200640100022 200640100883 8 PMED
32 200640100022 200640100890 8 PMED
33 200640100022 200640101139 1 MVIS
34 200640100022 200640101146 1 MVIS
35 200640100022 200640101153 1 MVIS
36 200640100022 200640101177 8 PMED
37 200640100022 200640101273 8 PMED
38 200640100022 200640101280 8 PMED
39 200640100022 200640101317 8 PMED
40 200640100022 200640101324 8 PMED
41 200640100022 200640101331 1 MVIS
42 200640100022 200640101348 1 MVIS
43 200640100022 200640101355 1 MVIS
44 200640100022 200640101362 1 MVIS
45 200640100022 200640101379 1 MVIS
46 200640100022 200640101386 1 MVIS
47 200640100022 200640101393 1 MVIS
48 200640100022 200640101406 1 MVIS
49 200640100022 200640101413 1 MVIS
50 200640100022 200640101420 1 MVIS
HC-077I 12:44 Thursday, September 22, 2005 5
Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 200260121148 8 PMED
2 200260121155 8 PMED
3 200260121299 8 PMED
4 200260121326 8 PMED
5 200260121333 8 PMED
6 200340280112 8 PMED
7 200340280143 8 PMED
8 200340280150 8 PMED
9 200340280218 8 PMED
10 200340280225 8 PMED
11 200340280270 8 PMED
12 200390220541 8 PMED
13 200410170370 8 PMED
14 200410170387 8 PMED
15 200540110241 1 MVIS
16 200540110258 1 MVIS
17 200540110265 1 MVIS
18 200540110272 8 PMED
19 200540110296 8 PMED
20 200540110309 8 PMED
21 200540110316 8 PMED
22 200540110323 8 PMED
23 200540110330 8 PMED
24 200540110347 8 PMED
25 200540110378 8 PMED
26 200540230215 1 MVIS
27 200540230239 8 PMED
28 200540230246 8 PMED
29 200540230253 8 PMED
30 200540230284 8 PMED
31 200640100883 8 PMED
32 200640100890 8 PMED
33 200640101139 1 MVIS
34 200640101146 1 MVIS
35 200640101153 1 MVIS
36 200640101177 8 PMED
37 200640101273 8 PMED
38 200640101280 8 PMED
39 200640101317 8 PMED
40 200640101324 8 PMED
41 200640101331 1 MVIS
42 200640101348 1 MVIS
43 200640101355 1 MVIS
44 200640101362 1 MVIS
45 200640101379 1 MVIS
46 200640101386 1 MVIS
47 200640101393 1 MVIS
48 200640101406 1 MVIS
49 200640101413 1 MVIS
50 200640101420 1 MVIS
HC-077I 12:44 Thursday, September 22, 2005 6
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-077A) records which link to condition records coded as asthma
linkidx rxrecidx RXNAME RXXP03X PERWT03F
200260121148 200260121148001 ATROVENT 58.37 17683.329086
200260121148002 ATROVENT 58.37 17683.329086
200260121155 200260121155001 ADVAIR DISKUS 177.84 17683.329086
200260121155002 ADVAIR DISKUS 177.84 17683.329086
200260121299 200260121299001 SINGULAR 107.07 17683.329086
200260121326 200260121326001 ATROVENT 58.37 17683.329086
200260121333 200260121333001 ADVAIR DISKUS 135.60 17683.329086
200340280112 200340280112001 ADVAIR DISKUS 177.84 4221.140660
200340280143 200340280143001 ALBUTEROL 25.95 4221.140660
200340280143002 ALBUTEROL 25.95 4221.140660
200340280150 200340280150001 AZMACORT 65.24 4221.140660
200340280150002 AZMACORT 65.24 4221.140660
200340280218 200340280218001 ALBUTEROL 21.41 4221.140660
200340280225 200340280225001 NASONEX 79.81 4221.140660
200340280270 200340280270001 ADVAIR DISKUS 100/50 287.72 4221.140660
200390220541 200390220541001 ADVAIR DISKUS 177.84 8837.632649
200410170370 200410170370001 BECONASE AQ 70.00 4180.514701
200410170387 200410170387001 ALBUTEROL 14.50 4180.514701
200540110272 200540110272001 ORAPRED 28.52 5774.720123
200540110272002 ORAPRED 28.52 5774.720123
200540110272003 ORAPRED 28.52 5774.720123
200540110272004 ORAPRED 28.52 5774.720123
200540110296 200540110296001 REGLAN 35.20 5774.720123
200540110296002 REGLAN 35.20 5774.720123
200540110296003 REGLAN 35.20 5774.720123
200540110296004 REGLAN 35.20 5774.720123
200540110309 200540110309001 PULMICORT 129.85 5774.720123
200540110309002 PULMICORT 129.85 5774.720123
200540110309003 PULMICORT 129.85 5774.720123
200540110309004 PULMICORT 129.85 5774.720123
200540110316 200540110316001 ALBUTEROL 21.41 5774.720123
200540110316002 ALBUTEROL 21.41 5774.720123
HC-077I 12:44 Thursday, September 22, 2005 7
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-077A) records which link to condition records coded as asthma
linkidx rxrecidx RXNAME RXXP03X PERWT03F
200540110316 200540110316003 ALBUTEROL 21.41 5774.720123
200540110316004 ALBUTEROL 21.41 5774.720123
200540110316005 ALBUTEROL 21.41 5774.720123
200540110323 200540110323001 FLOVENT 81.06 5774.720123
200540110323002 FLOVENT 81.06 5774.720123
200540110323003 FLOVENT 81.06 5774.720123
200540110323004 FLOVENT 81.06 5774.720123
200540110323005 FLOVENT 81.06 5774.720123
200540110330 200540110330001 SINGULAIR 82.75 5774.720123
200540110330002 SINGULAIR 82.75 5774.720123
200540110330003 SINGULAIR 82.75 5774.720123
200540110330004 SINGULAIR 82.75 5774.720123
200540110330005 SINGULAIR 82.75 5774.720123
200540110347 200540110347001 PULMICORT 129.85 5774.720123
200540110347002 PULMICORT 129.85 5774.720123
200540110347003 PULMICORT 129.85 5774.720123
200540110347004 PULMICORT 129.85 5774.720123
200540110378 200540110378001 SINGULAIR 82.75 5774.720123
200540110378002 SINGULAIR 82.75 5774.720123
200540110378003 SINGULAIR 82.75 5774.720123
200540110378004 SINGULAIR 82.75 5774.720123
200540230239 200540230239001 FLOVENT 81.06 7793.388531
200540230239002 FLOVENT 81.06 7793.388531
200540230239003 FLOVENT 81.06 7793.388531
200540230239004 FLOVENT 81.06 7793.388531
200540230239005 FLOVENT 81.06 7793.388531
200540230246 200540230246001 NEBULIZER 187.02 7793.388531
200540230246002 NEBULIZER 187.02 7793.388531
200540230246003 NEBULIZER 187.02 7793.388531
200540230253 200540230253001 ALBUTEROL 21.41 7793.388531
200540230253002 ALBUTEROL 21.41 7793.388531
200540230253003 ALBUTEROL 21.41 7793.388531
200540230253004 ALBUTEROL 21.41 7793.388531
200540230253005 ALBUTEROL 21.41 7793.388531
200540230284 200540230284001 ALBUTEROL 21.41 7793.388531
200640100883 200640100883001 ALBUTEROL 52.40 12752.916659
200640100883002 ALBUTEROL 52.40 12752.916659
200640100890 200640100890001 CLARITIN 84.36 12752.916659
200640100890002 CLARITIN 84.36 12752.916659
HC-077I 12:44 Thursday, September 22, 2005 8
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-077A) records which link to condition records coded as asthma
linkidx rxrecidx RXNAME RXXP03X PERWT03F
200640101177 200640101177001 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177002 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177003 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177004 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177005 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177006 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177007 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177008 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177009 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177010 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177011 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177012 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177013 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177014 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177015 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177016 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177017 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101177018 WE ALLERGY (GRAPE) 17.76 12752.916659
200640101273 200640101273001 SINGULAIR 91.61 12752.916659
200640101273002 SINGULAIR 91.61 12752.916659
200640101273003 SINGULAIR 91.61 12752.916659
200640101273004 SINGULAIR 91.61 12752.916659
200640101280 200640101280001 ALBUTEROL 29.95 12752.916659
200640101280002 ALBUTEROL 29.95 12752.916659
200640101280003 ALBUTEROL 29.95 12752.916659
200640101280004 ALBUTEROL 29.95 12752.916659
200640101317 200640101317001 SEREVENT 183.78 12752.916659
200640101317002 SEREVENT 183.78 12752.916659
200640101317003 SEREVENT 183.78 12752.916659
200640101317004 SEREVENT 183.78 12752.916659
200640101324 200640101324001 FLOVENT 20.00 12752.916659
200640101324002 FLOVENT 20.00 12752.916659
200640101324003 FLOVENT 20.00 12752.916659
200640101324004 FLOVENT 20.00 12752.916659
200680340170 200680340170001 FLOVENT 73.48 3578.972297
200680340187 200680340187001 FLONASE NASAL SPRAY 65.01 3578.972297
200760300161 200760300161001 ALBUTEROL 17.30 2059.152215
200940110140 200940110140001 ALBUTEROL 25.95 1214.643497
200940110164 200940110164001 XOPENEX 108.22 1214.643497
HC-077I 12:44 Thursday, September 22, 2005 9
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-077A) records which link to condition records coded as asthma
linkidx rxrecidx RXNAME RXXP03X PERWT03F
201090290040 201090290040001 SEREVENT 242.28 2068.683012
201090290095 201090290095001 SEREVENT 82.51 2068.683012
201150170507 201150170507001 COMBIVENT 57.06 7928.833801
201150170507002 COMBIVENT 57.06 7928.833801
201150170514 201150170514001 FLOVENT 81.06 7928.833801
201150170665 201150170665001 ALBUTEROL/IPRATROPIUM 108.58 7928.833801
201150170665002 ALBUTEROL/IPRATROPIUM 108.58 7928.833801
201150170665003 ALBUTEROL/IPRATROPIUM 108.58 7928.833801
201150170716 201150170716001 FLUTICASONE PROP 85.65 7928.833801
201790290650 201790290650001 ALBUTEROL 42.82 2626.868553
201790290650002 ALBUTEROL 42.82 2626.868553
201790290650003 ALBUTEROL 42.82 2626.868553
201790290674 201790290674001 SINGULAIR 86.56 2626.868553
201790290674002 SINGULAIR 86.56 2626.868553
201790290674003 SINGULAIR 86.56 2626.868553
201790290674004 SINGULAIR 86.56 2626.868553
201790290965 201790290965001 ALBUTEROL 42.82 2626.868553
201790290965002 ALBUTEROL 42.82 2626.868553
201790290965003 ALBUTEROL 42.82 2626.868553
201790290965004 ALBUTEROL 42.82 2626.868553
201790290965005 ALBUTEROL 42.82 2626.868553
201790290965006 ALBUTEROL 42.82 2626.868553
201790290965007 ALBUTEROL 42.82 2626.868553
201790290965008 ALBUTEROL 42.82 2626.868553
201790290965009 ALBUTEROL 42.82 2626.868553
201790290965010 ALBUTEROL 42.82 2626.868553
201790290965011 ALBUTEROL 42.82 2626.868553
201790290965012 ALBUTEROL 42.82 2626.868553
201790290996 201790290996001 SINGULAIR (UNIT OF USE) 91.61 2626.868553
201790290996002 SINGULAIR (UNIT OF USE) 91.61 2626.868553
201790290996003 SINGULAIR (UNIT OF USE) 91.61 2626.868553
201790290996004 SINGULAIR (UNIT OF USE) 91.61 2626.868553
201790290996005 SINGULAIR (UNIT OF USE) 91.61 2626.868553
201790290996006 SINGULAIR (UNIT OF USE) 91.61 2626.868553
201790291153 201790291153001 ALBUTEROL 42.82 2626.868553
201790291153002 ALBUTEROL 42.82 2626.868553
201790291153003 ALBUTEROL 42.82 2626.868553
201790291184 201790291184001 SINGULAIR 86.56 2626.868553
HC-077I 12:44 Thursday, September 22, 2005 10
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-077A) records which link to condition records coded as asthma
linkidx rxrecidx RXNAME RXXP03X PERWT03F
201790291184 201790291184002 SINGULAIR 86.56 2626.868553
201790291184003 SINGULAIR 86.56 2626.868553
201790360181 201790360181001 SINGULAIR 79.86 4144.408785
201790360181002 SINGULAIR 79.86 4144.408785
201790360181003 SINGULAIR 79.86 4144.408785
201790360198 201790360198001 THEOPHYLLINE 39.18 4144.408785
201790360198002 THEOPHYLLINE 39.18 4144.408785
201790360201 201790360201001 ALBUTEROL 29.00 4144.408785
201790360201002 ALBUTEROL 29.00 4144.408785
201790360249 201790360249001 THEOPHYLLINE 39.18 4144.408785
201790360249002 THEOPHYLLINE 39.18 4144.408785
201790360249003 THEOPHYLLINE 39.18 4144.408785
201790360256 201790360256001 ALBUTEROL 29.00 4144.408785
201790360256002 ALBUTEROL 29.00 4144.408785
201790360256003 ALBUTEROL 29.00 4144.408785
201790360256004 ALBUTEROL 29.00 4144.408785
201790360256005 ALBUTEROL 29.00 4144.408785
201790360256006 ALBUTEROL 29.00 4144.408785
201790360256007 ALBUTEROL 29.00 4144.408785
201790360256008 ALBUTEROL 29.00 4144.408785
201790360256009 ALBUTEROL 29.00 4144.408785
201790360256010 ALBUTEROL 29.00 4144.408785
201790360256011 ALBUTEROL 29.00 4144.408785
201790360256012 ALBUTEROL 29.00 4144.408785
201790360256013 ALBUTEROL 29.00 4144.408785
201790360256014 ALBUTEROL 29.00 4144.408785
201790360256015 ALBUTEROL 29.00 4144.408785
201790360256016 ALBUTEROL 29.00 4144.408785
201790360256017 ALBUTEROL 29.00 4144.408785
201790360256018 ALBUTEROL 29.00 4144.408785
201790360263 201790360263001 SINGULAR 107.07 4144.408785
201790360263002 SINGULAR 107.07 4144.408785
201790360270 201790360270001 ALBUTEROL 42.82 4144.408785
201790360270002 ALBUTEROL 42.82 4144.408785
201790360270003 ALBUTEROL 42.82 4144.408785
201790360287 201790360287001 SINGULAR 107.07 4144.408785
201790360287002 SINGULAR 107.07 4144.408785
201790360287003 SINGULAR 107.07 4144.408785
201840320196 201840320196001 NEBULIZER 187.02 4518.276232
HC-077I 12:44 Thursday, September 22, 2005 11
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-077A) records which link to condition records coded as asthma
linkidx rxrecidx RXNAME RXXP03X PERWT03F
201840320343 201840320343001 ALBUTEROL 13.69 4518.276232
201860330274 201860330274001 ALBUTEROL 29.79 3205.761224
201930150025 201930150025001 CUTIVATE 42.89 3820.382576
201930150032 201930150032001 ALBUTEROL 24.90 3820.382576
201930150049 201930150049001 ZITHROMAX 43.20 3820.382576
201930150056 201930150056001 CUTIVATE 61.58 3820.382576
201930150063 201930150063001 ALBUTEROL 24.90 3820.382576
202170150595 202170150595001 FLOVENT 66.60 10143.491415
202170150595002 FLOVENT 66.60 10143.491415
202170150595003 FLOVENT 66.60 10143.491415
202170150595004 FLOVENT 66.60 10143.491415
202170150608 202170150608001 ALBUTEROL 21.41 10143.491415
202170150608002 ALBUTEROL 21.41 10143.491415
202170150608003 ALBUTEROL 21.41 10143.491415
202170150653 202170150653001 ALBUTEROL 21.41 10143.491415
202170150653002 ALBUTEROL 21.41 10143.491415
202170150653003 ALBUTEROL 21.41 10143.491415
202170150660 202170150660001 ADVAIR DISKUS 122.96 10143.491415
202170150660002 ADVAIR DISKUS 122.96 10143.491415
202350170439 202350170439001 ALBUTEROL 44.84 6373.202393
202350170600 202350170600001 ALBUTEROL 44.84 6373.202393
202350170600002 ALBUTEROL 44.84 6373.202393
202350170600003 ALBUTEROL 44.84 6373.202393
202350170775 202350170775001 ALBUTEROL 26.90 6373.202393
202350170775002 ALBUTEROL 26.90 6373.202393
202350170775003 ALBUTEROL 26.90 6373.202393
202350170775004 ALBUTEROL 26.90 6373.202393
202350170775005 ALBUTEROL 26.90 6373.202393
202350170775006 ALBUTEROL 26.90 6373.202393
202350170775007 ALBUTEROL 26.90 6373.202393
202350170775008 ALBUTEROL 26.90 6373.202393
202350170802 202350170802001 RESCON MX 36.42 6373.202393
202350170802002 RESCON MX 36.42 6373.202393
202600660146 202600660146001 ALBUTEROL 11.42 4378.300587
HC-077I 12:44 Thursday, September 22, 2005 12
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-077A) records which link to condition records coded as asthma
linkidx rxrecidx RXNAME RXXP03X PERWT03F
202620130737 202620130737001 COMBIVENT 70.23 6639.386741
202620130744 202620130744001 XX-SALMETEROL 70.44 6639.386741
202620130768 202620130768001 QVAR 52.69 6639.386741
202620130775 202620130775001 G/P 22.18 6639.386741
202620130826 202620130826001 COMBIVENT 59.91 6639.386741
202620130864 202620130864001 G/P 22.18 6639.386741
202650560423 202650560423001 ALBUTEROL 42.82 3495.424052
202650560423002 ALBUTEROL 42.82 3495.424052
202650560423003 ALBUTEROL 42.82 3495.424052
202650560423004 ALBUTEROL 42.82 3495.424052
202650560423005 ALBUTEROL 42.82 3495.424052
202650560423006 ALBUTEROL 42.82 3495.424052
202650560536 202650560536001 ALBUTEROL 42.82 3495.424052
202650560536002 ALBUTEROL 42.82 3495.424052
202650560536003 ALBUTEROL 42.82 3495.424052
202680360239 202680360239001 STERAPRED DS 25.78 2106.116391
202680360373 202680360373001 ADVAIR DISKUS 107.75 2106.116391
202680360380 202680360380001 SINGULAIR 78.06 2106.116391
202680360380002 SINGULAIR 78.06 2106.116391
202680360506 202680360506001 SINGULAIR 82.75 2106.116391
202680360506002 SINGULAIR 82.75 2106.116391
202680360513 202680360513001 ADVAIR DISKUS 107.75 2106.116391
202680360513002 ADVAIR DISKUS 107.75 2106.116391
202680360520 202680360520001 BRONCHO SALINE 9.90 2106.116391
202680360520002 BRONCHO SALINE 9.90 2106.116391
202700210138 202700210138001 ALBUTEROL 17.30 4510.391596
202740110637 202740110637001 AZMACORT 68.12 4496.367476
202740110637002 AZMACORT 68.12 4496.367476
202740110644 202740110644001 ALBUTEROL 22.50 4496.367476
202740110644002 ALBUTEROL 22.50 4496.367476
202740110651 202740110651001 ALBUTEROL 154.50 4496.367476
202740110651002 ALBUTEROL 154.50 4496.367476
HC-077I 12:44 Thursday, September 22, 2005 13
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-077A) records which link to condition records coded as asthma
linkidx rxrecidx RXNAME RXXP03X PERWT03F
202740111041 202740111041001 AZMACORT 68.12 4496.367476
202740111041002 AZMACORT 68.12 4496.367476
202740111041003 AZMACORT 68.12 4496.367476
202740111041004 AZMACORT 68.12 4496.367476
202740111041005 AZMACORT 68.12 4496.367476
202740111058 202740111058001 ALBUTEROL 22.50 4496.367476
202740111058002 ALBUTEROL 22.50 4496.367476
202740111058003 ALBUTEROL 22.50 4496.367476
202740111058004 ALBUTEROL 22.50 4496.367476
202740111058005 ALBUTEROL 22.50 4496.367476
202740111065 202740111065001 ALBUTEROL 154.50 4496.367476
202740111065002 ALBUTEROL 154.50 4496.367476
202740111065003 ALBUTEROL 154.50 4496.367476
202740111065004 ALBUTEROL 154.50 4496.367476
202740111065005 ALBUTEROL 154.50 4496.367476
202760300132 202760300132001 ALBUTEROL 29.79 13551.349815
202760300149 202760300149001 QVAR 52.69 13551.349815
203080160284 203080160284001 NASACORT AQ 63.14 3192.465247
203600120232 203600120232001 ALBUTEROL 22.49 16689.535921
203600120232002 ALBUTEROL 22.49 16689.535921
203600290225 203600290225001 IPRATROPIUM BROMIDE 661.32 15542.911419
203600290294 203600290294001 NEBULIZER 2.94 15542.911419
203600290307 203600290307001 DIOVAN HCT 51.12 15542.911419
203740440216 203740440216001 PREDNISONE 3.06 12507.699207
203740440223 203740440223001 TRIMOX 8.93 12507.699207
203740440230 203740440230001 ALLEGRA 73.93 12507.699207
203740440247 203740440247001 ALBUTEROL 27.85 12507.699207
203740440247002 ALBUTEROL 27.85 12507.699207
203740440278 203740440278001 ALBUTEROL 40.59 12507.699207
203840180220 203840180220001 ALBUTEROL 29.00 28194.096575
203840250371 203840250371001 ORAPRED (DYE-FREE,GRAPE) 25.00 25235.151951
203840250395 203840250395001 PRELONE 18.05 25235.151951
HC-077I 12:44 Thursday, September 22, 2005 14
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-077A) records which link to condition records coded as asthma
linkidx rxrecidx RXNAME RXXP03X PERWT03F
203840250408 203840250408001 ALBUTEROL SULFATE (PF) 74.16 25235.151951
204040400269 204040400269001 QVAR 49.42 5146.238970
204040400269002 QVAR 49.42 5146.238970
204060130368 204060130368001 ALBUTEROL 14.89 21126.427199
204190191191 204190191191001 FLOVENT 85.65 16375.493603
204190191191002 FLOVENT 85.65 16375.493603
204190191191003 FLOVENT 85.65 16375.493603
204190191191004 FLOVENT 85.65 16375.493603
204190191280 204190191280001 PROVENTIL HFA 42.89 16375.493603
204190191297 204190191297001 FLONASE 46.44 16375.493603
204190191297002 FLONASE 46.44 16375.493603
204340120109 204340120109001 ALBUTEROL 17.50 17838.278713
204340120109002 ALBUTEROL 17.50 17838.278713
204350100100 204350100100001 AEROBID-M (MENTHOL) 62.38 18470.946812
204350100148 204350100148001 SEREVENT 76.38 18470.946812
HC-077I 12:44 Thursday, September 22, 2005 15
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
The MEANS Procedure
Analysis Variable : RXXP03X SUM OF PAYMENTS RXSF03X-RXOU03X(IMPUTED)
N Sum
---------------------
10833 736783.09
---------------------
HC-077I 12:44 Thursday, September 22, 2005 16
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP03X SUM OF PAYMENTS RXSF03X-RXOU03X(IMPUTED)
N Sum
---------------------
10833 6255664604
---------------------
1 The SAS System 12:47 Thursday, September 22, 2005
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX09.
NOTE: SAS initialization used:
real time 2.17 seconds
cpu time 0.37 seconds
NOTE: AUTOEXEC processing beginning; file is C:\progra~1\sasins~1\sas\v8\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1
2 OPTIONS LS=132 PS=59;
3
4 TITLE1 "HC-077I";
5 TITLE2 'Sample SAS Job for Example C';
6
7 LIBNAME IN 'C:\DATA';
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.14 seconds
cpu time 0.00 seconds
23
24 *-----------------------------------------------------------------------------------
2 The SAS System 12:47 Thursday, September 22, 2005
25 * Get conditions records coded as asthma.
26 *-----------------------------------------------------------------------------------;
27 DATA ASCONDS;
28 SET IN.H78 (KEEP=CONDIDX CCCODEX);
29 IF CCCODEX="128";
30 RUN;
NOTE: There were 106279 observations read from the data set IN.H78.
NOTE: The data set WORK.ASCONDS has 1839 observations and 2 variables.
NOTE: DATA statement used:
real time 1.40 seconds
cpu time 0.14 seconds
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 1839 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1839 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.06 seconds
cpu time 0.03 seconds
36
37 proc print data=asconds (obs=50);
38 title3 "sample print of work.asconds - sorted by condidx";
39 title4 "COND (HC-078) 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 0.46 seconds
cpu time 0.00 seconds
41
42 PROC SORT DATA=IN.H77IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 343747 observations read from the data set IN.H77IF1.
NOTE: The data set WORK.CLNK has 343747 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 18.68 seconds
cpu time 2.10 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;
3 The SAS System 12:47 Thursday, September 22, 2005
NOTE: There were 343747 observations read from the data set WORK.CLNK.
NOTE: There were 1839 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7392 observations and 3 variables.
NOTE: DATA statement used:
real time 0.39 seconds
cpu time 0.37 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;
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.06 seconds
cpu time 0.03 seconds
58
59 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7392 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7392 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.01 seconds
cpu time 0.01 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.01 seconds
cpu 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 7392 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7382 observations and 2 variables.
4 The SAS System 12:47 Thursday, September 22, 2005
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.01 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.01 seconds
cpu 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;
81 SET IN.H77G (KEEP=EVNTIDX PERWT03F SEETLKPV OBXP03X);
82 IF PERWT03F > 0 & SEETLKPV NE 2;
83 RUN;
NOTE: There were 154853 observations read from the data set IN.H77G.
NOTE: The data set WORK.MVIS has 149794 observations and 4 variables.
NOTE: DATA statement used:
real time 4.03 seconds
cpu time 0.51 seconds
84
85 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 149794 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 149794 observations and 4 variables.
NOTE: PROCEDURE SORT used:
real time 0.93 seconds
cpu time 0.57 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 7382 observations read from the data set WORK.ASCLNKS.
NOTE: There were 149794 observations read from the data set WORK.MVIS.
5 The SAS System 12:47 Thursday, September 22, 2005
NOTE: The data set WORK.ASMVIS has 2219 observations and 5 variables.
NOTE: DATA statement used:
real time 0.17 seconds
cpu time 0.17 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-077G) 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.03 seconds
cpu time 0.01 seconds
102
103 PROC MEANS DATA=ASMVIS N SUM;
104 VAR OBXP03X;
105 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
106 RUN;
NOTE: There were 2219 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 7.
NOTE: PROCEDURE MEANS used:
real time 0.31 seconds
cpu time 0.01 seconds
107
108 PROC MEANS DATA=ASMVIS SUM;
109 VAR OBXP03X;
110 WEIGHT PERWT03F;
111 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
112 TITLE5 "Weighted";
113 RUN;
NOTE: There were 2219 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 8.
NOTE: PROCEDURE MEANS used:
real time 0.01 seconds
cpu 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 29.42 seconds
cpu time 4.49 seconds
HC-077I 12:47 Thursday, September 22, 2005 1
Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx
COND (HC-078) records where cccodex=128
Obs CONDIDX CCCODEX
1 200260120036 128
2 200300100028 128
3 200340280018 128
4 200390220116 128
5 200410170097 128
6 200530380017 128
7 200540110059 128
8 200540230019 128
9 200640100022 128
10 200640100141 128
11 200680340054 128
12 200760300018 128
13 200880360010 128
14 200940110030 128
15 201090290010 128
16 201150170015 128
17 201290280019 128
18 201550320028 128
19 201790290043 128
20 201790320052 128
21 201790360014 128
22 201790590029 128
23 201840320043 128
24 201860330010 128
25 201930150013 128
26 201980300032 128
27 202170150026 128
28 202170290028 128
29 202240300029 128
30 202350170021 128
31 202600660049 128
32 202620130056 128
33 202650560036 128
34 202680360017 128
35 202680360051 128
36 202680430038 128
37 202680590038 128
38 202700210038 128
39 202740110040 128
40 202760300046 128
41 202900140013 128
42 203080160025 128
43 203600120037 128
44 203600290042 128
45 203650120019 128
46 203740440015 128
47 203840180080 128
48 203840250120 128
49 203840250142 128
50 204040400082 128
HC-077I 12:47 Thursday, September 22, 2005 2
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200260120036 200260121148 8 PMED
200260121155 8 PMED
200260121299 8 PMED
200260121326 8 PMED
200260121333 8 PMED
200340280018 200340280112 8 PMED
200340280143 8 PMED
200340280150 8 PMED
200340280218 8 PMED
200340280225 8 PMED
200340280270 8 PMED
200390220116 200390220541 8 PMED
200410170097 200410170370 8 PMED
200410170387 8 PMED
200540110059 200540110241 1 MVIS
200540110258 1 MVIS
200540110265 1 MVIS
200540110272 8 PMED
200540110296 8 PMED
200540110309 8 PMED
200540110316 8 PMED
200540110323 8 PMED
200540110330 8 PMED
200540110347 8 PMED
200540110378 8 PMED
200540230019 200540230215 1 MVIS
200540230239 8 PMED
200540230246 8 PMED
200540230253 8 PMED
200540230284 8 PMED
200640100022 200640100883 8 PMED
200640100890 8 PMED
200640101139 1 MVIS
200640101146 1 MVIS
200640101153 1 MVIS
200640101177 8 PMED
200640101273 8 PMED
200640101280 8 PMED
200640101317 8 PMED
200640101324 8 PMED
200640101331 1 MVIS
200640101348 1 MVIS
200640101355 1 MVIS
HC-077I 12:47 Thursday, September 22, 2005 3
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200640100022 200640101362 1 MVIS
200640101379 1 MVIS
200640101386 1 MVIS
200640101393 1 MVIS
200640101406 1 MVIS
200640101413 1 MVIS
200640101420 1 MVIS
200640101437 1 MVIS
200640101444 1 MVIS
200640101451 1 MVIS
200640101468 1 MVIS
200640101475 1 MVIS
200640101482 1 MVIS
200680340054 200680340170 8 PMED
200680340187 8 PMED
200760300018 200760300161 8 PMED
200940110030 200940110140 8 PMED
200940110164 8 PMED
201090290010 201090290040 8 PMED
201090290095 8 PMED
201150170015 201150170507 8 PMED
201150170514 8 PMED
201150170665 8 PMED
201150170716 8 PMED
201790290043 201790290410 1 MVIS
201790290650 8 PMED
201790290674 8 PMED
201790290821 1 MVIS
201790290838 1 MVIS
201790290845 1 MVIS
201790290852 1 MVIS
201790290869 1 MVIS
HC-077I 12:47 Thursday, September 22, 2005 4
Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 200260120036 200260121148 8 PMED
2 200260120036 200260121155 8 PMED
3 200260120036 200260121299 8 PMED
4 200260120036 200260121326 8 PMED
5 200260120036 200260121333 8 PMED
6 200340280018 200340280112 8 PMED
7 200340280018 200340280143 8 PMED
8 200340280018 200340280150 8 PMED
9 200340280018 200340280218 8 PMED
10 200340280018 200340280225 8 PMED
11 200340280018 200340280270 8 PMED
12 200390220116 200390220541 8 PMED
13 200410170097 200410170370 8 PMED
14 200410170097 200410170387 8 PMED
15 200540110059 200540110241 1 MVIS
16 200540110059 200540110258 1 MVIS
17 200540110059 200540110265 1 MVIS
18 200540110059 200540110272 8 PMED
19 200540110059 200540110296 8 PMED
20 200540110059 200540110309 8 PMED
21 200540110059 200540110316 8 PMED
22 200540110059 200540110323 8 PMED
23 200540110059 200540110330 8 PMED
24 200540110059 200540110347 8 PMED
25 200540110059 200540110378 8 PMED
26 200540230019 200540230215 1 MVIS
27 200540230019 200540230239 8 PMED
28 200540230019 200540230246 8 PMED
29 200540230019 200540230253 8 PMED
30 200540230019 200540230284 8 PMED
31 200640100022 200640100883 8 PMED
32 200640100022 200640100890 8 PMED
33 200640100022 200640101139 1 MVIS
34 200640100022 200640101146 1 MVIS
35 200640100022 200640101153 1 MVIS
36 200640100022 200640101177 8 PMED
37 200640100022 200640101273 8 PMED
38 200640100022 200640101280 8 PMED
39 200640100022 200640101317 8 PMED
40 200640100022 200640101324 8 PMED
41 200640100022 200640101331 1 MVIS
42 200640100022 200640101348 1 MVIS
43 200640100022 200640101355 1 MVIS
44 200640100022 200640101362 1 MVIS
45 200640100022 200640101379 1 MVIS
46 200640100022 200640101386 1 MVIS
47 200640100022 200640101393 1 MVIS
48 200640100022 200640101406 1 MVIS
49 200640100022 200640101413 1 MVIS
50 200640100022 200640101420 1 MVIS
HC-077I 12:47 Thursday, September 22, 2005 5
Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 200260121148 8 PMED
2 200260121155 8 PMED
3 200260121299 8 PMED
4 200260121326 8 PMED
5 200260121333 8 PMED
6 200340280112 8 PMED
7 200340280143 8 PMED
8 200340280150 8 PMED
9 200340280218 8 PMED
10 200340280225 8 PMED
11 200340280270 8 PMED
12 200390220541 8 PMED
13 200410170370 8 PMED
14 200410170387 8 PMED
15 200540110241 1 MVIS
16 200540110258 1 MVIS
17 200540110265 1 MVIS
18 200540110272 8 PMED
19 200540110296 8 PMED
20 200540110309 8 PMED
21 200540110316 8 PMED
22 200540110323 8 PMED
23 200540110330 8 PMED
24 200540110347 8 PMED
25 200540110378 8 PMED
26 200540230215 1 MVIS
27 200540230239 8 PMED
28 200540230246 8 PMED
29 200540230253 8 PMED
30 200540230284 8 PMED
31 200640100883 8 PMED
32 200640100890 8 PMED
33 200640101139 1 MVIS
34 200640101146 1 MVIS
35 200640101153 1 MVIS
36 200640101177 8 PMED
37 200640101273 8 PMED
38 200640101280 8 PMED
39 200640101317 8 PMED
40 200640101324 8 PMED
41 200640101331 1 MVIS
42 200640101348 1 MVIS
43 200640101355 1 MVIS
44 200640101362 1 MVIS
45 200640101379 1 MVIS
46 200640101386 1 MVIS
47 200640101393 1 MVIS
48 200640101406 1 MVIS
49 200640101413 1 MVIS
50 200640101420 1 MVIS
HC-077I 12:47 Thursday, September 22, 2005 6
Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-077G) events
Obs EVNTIDX EVENTYPE SEETLKPV OBXP03X PERWT03F
1 200540110241 1 MVIS 1 60.00 5774.72
2 200540110258 1 MVIS 1 0.00 5774.72
3 200540110265 1 MVIS 1 52.00 5774.72
4 200540230215 1 MVIS 1 66.45 7793.39
5 200640101139 1 MVIS 1 68.00 12752.92
6 200640101146 1 MVIS 1 52.00 12752.92
7 200640101153 1 MVIS 1 52.00 12752.92
8 200640101331 1 MVIS 1 52.00 12752.92
9 200640101348 1 MVIS 1 52.00 12752.92
10 200640101355 1 MVIS 1 52.00 12752.92
11 200640101362 1 MVIS 1 52.00 12752.92
12 200640101379 1 MVIS 1 52.00 12752.92
13 200640101386 1 MVIS 1 52.00 12752.92
14 200640101393 1 MVIS 1 52.00 12752.92
15 200640101406 1 MVIS 1 52.00 12752.92
16 200640101413 1 MVIS 1 52.00 12752.92
17 200640101420 1 MVIS 1 52.00 12752.92
18 200640101437 1 MVIS 1 52.00 12752.92
19 200640101444 1 MVIS 1 52.00 12752.92
20 200640101451 1 MVIS 1 52.00 12752.92
21 200640101468 1 MVIS 1 34.49 12752.92
22 200640101475 1 MVIS 1 34.49 12752.92
23 200640101482 1 MVIS 1 34.49 12752.92
24 201790290410 1 MVIS 1 90.00 2626.87
25 201790290821 1 MVIS 1 509.00 2626.87
26 201790290838 1 MVIS 1 691.00 2626.87
27 201790290845 1 MVIS 1 110.00 2626.87
28 201790290852 1 MVIS 1 61.00 2626.87
29 201790290869 1 MVIS 1 120.00 2626.87
30 201790290876 1 MVIS 1 128.32 2626.87
31 201790290903 1 MVIS 1 50.40 2626.87
32 201790360232 1 MVIS 1 30.00 4144.41
33 201860330161 1 MVIS 1 49.74 3205.76
34 201860330229 1 MVIS 1 49.74 3205.76
35 201860330236 1 MVIS 1 49.74 3205.76
36 201860330243 1 MVIS 1 49.74 3205.76
37 201860330250 1 MVIS 1 36.31 3205.76
38 201930150018 1 MVIS 1 76.00 3820.38
39 202170150639 1 MVIS 1 43.20 10143.49
40 202170150646 1 MVIS 1 58.50 10143.49
41 202620130491 1 MVIS 1 51.39 6639.39
42 202620130504 1 MVIS 1 192.89 6639.39
43 202620130511 1 MVIS 1 51.39 6639.39
44 202620130528 1 MVIS 1 59.66 6639.39
45 202620130542 1 MVIS 1 59.66 6639.39
46 202620130782 1 MVIS 1 80.16 6639.39
47 202650560365 1 MVIS 1 26.84 3495.42
48 202650560430 1 MVIS 1 39.54 3495.42
49 202650560447 1 MVIS 1 39.54 3495.42
50 202650560454 1 MVIS 1 0.00 3495.42
HC-077I 12:47 Thursday, September 22, 2005 7
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
The MEANS Procedure
Analysis Variable : OBXP03X SUM OF OBSF03X - OBOT03X (IMPUTED)
N Sum
--------------------
2219 223503.09
--------------------
HC-077I 12:47 Thursday, September 22, 2005 8
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : OBXP03X SUM OF OBSF03X - OBOT03X (IMPUTED)
Sum
------------
1740213361
------------
1 The SAS System 12:50 Thursday, September 22, 2005
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX09.
NOTE: SAS initialization used:
real time 2.51 seconds
cpu time 0.43 seconds
NOTE: AUTOEXEC processing beginning; file is C:\progra~1\sasins~1\sas\v8\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1
2 OPTIONS LS=132 PS=59;
3
4 TITLE1 "HC-077I";
5 TITLE2 'Sample SAS Job for Example D';
6
7 LIBNAME IN 'C:\DATA';
NOTE: Libref IN was successfully assigned as follows:
Engine: V8
Physical Name: C:\DATA
8
9 **************************************************************************************
10 * Calculate the expenditures for prescribed medicines associated
11 * with insulin reported by the household as an other medical expense.
12 **************************************************************************************;
13
14 PROC FORMAT;
15 VALUE EVENTYPE
16 1 = "1 MVIS"
17 2 = "2 OPAT"
18 3 = "3 EROM"
19 4 = "4 STAZ"
20 5 = "5 DVIS"
21 6 = "6 OMED"
22 7 = "7 HVIS"
23 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
24
25 VALUE OMTYPE
26 -9 = "-9 NOT ASCERTAINED"
27 -8 = "-8 DK"
28 -7 = "-7 REFUSED"
29 -1 = "-1 INAPPLICABLE"
30 1 = "1 GLASSES OR CONTACT LENSES"
2 The SAS System 12:50 Thursday, September 22, 2005
31 2 = "2 INSULIN"
32 3 = "3 DIABETIC EQUIPMENT/SUPPLIES"
33 4 = "4 AMBULANCE SERVICES"
34 5 = "5 ORTHOPEDIC ITEMS"
35 6 = "6 HEARING DEVICES"
36 7 = "7 PROSTHESIS"
37 8 = "8 BATHROOM AIDS"
38 9 = "9 MEDICAL EQUIPMENT"
39 10 = "10 DISPOSABLE SUPPLIES"
40 11 = "11 ALTERATIONS/MODIFICATIONS"
41 91 = "91 OTHER"
42 ;
NOTE: Format OMTYPE has been output.
43 RUN;
NOTE: PROCEDURE FORMAT used:
real time 0.10 seconds
cpu time 0.04 seconds
44
45 *-------------------------------------------------------------------------------------
46 * Get other medical records for insulin for persons with positive weights.
47 *-------------------------------------------------------------------------------------;
48
49 DATA OMED;
50 SET IN.H77C (KEEP=EVNTIDX PERWT03F OMTYPEX);
51 IF PERWT03F > 0 & OMTYPEX = 2;
52 RUN;
NOTE: There were 9671 observations read from the data set IN.H77C.
NOTE: The data set WORK.OMED has 565 observations and 3 variables.
NOTE: DATA statement used:
real time 0.67 seconds
cpu time 0.10 seconds
53
54 proc print data=omed (obs=100);
55 var evntidx OMTYPEX PERWT03F;
56 format OMTYPEX omtype.;
57 title3 "sample print of OMED (HC-077C) records where OMTYPEX=2";
58 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 0.23 seconds
cpu time 0.03 seconds
59
60 *-------------------------------------------------------------------------------------
61 * Get PMED IDs linked to the OMED events which were for insulin.
62 *-------------------------------------------------------------------------------------;
63
64 PROC SORT DATA=IN.H77IF2 OUT=RXLK; BY EVNTIDX; RUN;
3 The SAS System 12:50 Thursday, September 22, 2005
NOTE: There were 64605 observations read from the data set IN.H77IF2.
NOTE: The data set WORK.RXLK has 64605 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 0.51 seconds
cpu time 0.45 seconds
65
66 proc print data=rxlk (obs=150);
67 by evntidx;
68 id evntidx;
69 var linkidx eventype;
70 format eventype eventype.;
71 title3 "sample print of Rx+event link file records (HC-77IF2) - sorted by evntidx";
72 run;
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.09 seconds
cpu time 0.04 seconds
73
74 data omedrxlk;
75 set rxlk (where=(eventype=6));
76 run;
NOTE: There were 1867 observations read from the data set WORK.RXLK.
WHERE eventype=6;
NOTE: The data set WORK.OMEDRXLK has 1867 observations and 5 variables.
NOTE: DATA statement used:
real time 0.03 seconds
cpu time 0.01 seconds
77 proc print data=omedrxlk (obs=120);
78 by evntidx;
79 id evntidx;
80 var linkidx eventype;
81 format eventype eventype.;
82 title3 "sample print of work.omedrxlk - sorted by evntidx";
83 title4 "Rx+event link file records (HC-77IF2) where eventype=6 (omed)";
84 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.03 seconds
cpu time 0.01 seconds
85
86 DATA PMEDIDS;
87 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
88 OMED (IN=INOMED KEEP=EVNTIDX);
4 The SAS System 12:50 Thursday, September 22, 2005
89 BY EVNTIDX;
90 IF INRXLK & INOMED;
91 RUN;
NOTE: There were 64605 observations read from the data set WORK.RXLK.
NOTE: There were 565 observations read from the data set WORK.OMED.
NOTE: The data set WORK.PMEDIDS has 525 observations and 3 variables.
NOTE: DATA statement used:
real time 0.07 seconds
cpu time 0.07 seconds
92
93 proc print data=pmedids (obs=50);
94 by evntidx;
95 id evntidx;
96 format eventype eventype.;
97 title3 "sample print of work.pmedids - sorted by evntidx";
98 title4 "work.rxlk records for omed events for insulin";
99 run;
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
cpu time 0.00 seconds
100
101 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 525 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 525 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.00 seconds
cpu time 0.00 seconds
102
103 proc print data=pmedids (obs=50);
104 format eventype eventype.;
105 title3 "sample print of work.pmedids - sorted by linkidx";
106 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.01 seconds
cpu time 0.00 seconds
107
108 DATA PMEDIDS;
109 SET PMEDIDS (KEEP=LINKIDX);
110 BY LINKIDX;
111 IF FIRST.LINKIDX;
112 KEEP LINKIDX;
5 The SAS System 12:50 Thursday, September 22, 2005
113 RUN;
NOTE: There were 525 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 525 observations and 1 variables.
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.00 seconds
114
115 proc print data=pmedids (obs=50);
116 title3 "sample print of unique linkidxs in work.pmedids";
117 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
cpu time 0.00 seconds
118
119
120 *------------------------------------------------------------------------------------
121 * Get PMED records for OMED event which were for insulin.
122 *------------------------------------------------------------------------------------;
123 PROC SORT DATA=IN.H77A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 304324 observations read from the data set IN.H77A.
NOTE: The data set WORK.PMED has 304324 observations and 13 variables.
NOTE: PROCEDURE SORT used:
real time 37.21 seconds
cpu time 4.06 seconds
124
125 DATA OMPMEDS;
126 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP03X PERWT03F RXNAME)
127 PMEDIDS (IN=A);
128 BY LINKIDX;
129 IF A & PERWT03F>0;
130 RUN;
NOTE: There were 304324 observations read from the data set WORK.PMED.
NOTE: There were 525 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.OMPMEDS has 2051 observations and 5 variables.
NOTE: DATA statement used:
real time 0.46 seconds
cpu time 0.46 seconds
131
132 proc print data=ompmeds (obs=200);
133 by linkidx;
134 id linkidx;
135 var rxrecidx rxname RXXP03X PERWT03F;
136 title3 "sample print of work.pmeds";
6 The SAS System 12:50 Thursday, September 22, 2005
137 title4 "PMED (HC-077A) records for unique linkidxs in work.pmedids";
138 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.01 seconds
cpu time 0.01 seconds
139
140 PROC MEANS DATA=OMPMEDS N SUM;
141 VAR RXXP03X;
142 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
143 RUN;
NOTE: There were 2051 observations read from the data set WORK.OMPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used:
real time 0.07 seconds
cpu time 0.03 seconds
144
145 PROC MEANS DATA=OMPMEDS N SUM;
146 VAR RXXP03X;
147 WEIGHT PERWT03F;
148 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
149 TITLE5 "Weighted";
150 RUN;
NOTE: There were 2051 observations read from the data set WORK.OMPMEDS.
NOTE: The PROCEDURE MEANS printed page 24.
NOTE: PROCEDURE MEANS used:
real time 0.03 seconds
cpu time 0.03 seconds
151
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 42.79 seconds
cpu time 5.93 seconds
HC-077I 12:50 Thursday, September 22, 2005 1
Sample SAS Job for Example D
sample print of OMED (HC-077C) records where OMTYPEX=2
Obs EVNTIDX OMTYPEX PERWT03F
1 201070130735 2 INSULIN 21413.85
2 201150170552 2 INSULIN 7928.83
3 201290110356 2 INSULIN 10556.52
4 201510150554 2 INSULIN 3903.95
5 201510150698 2 INSULIN 3903.95
6 202750160855 2 INSULIN 13836.14
7 203300140473 2 INSULIN 9605.82
8 203520150313 2 INSULIN 13605.28
9 204910230937 2 INSULIN 16641.94
10 205150110452 2 INSULIN 4405.72
11 205320130826 2 INSULIN 3312.15
12 205560200235 2 INSULIN 4821.82
13 205560200300 2 INSULIN 4821.82
14 205690140894 2 INSULIN 2794.05
15 205780101202 2 INSULIN 2040.93
16 206840120413 2 INSULIN 7362.00
17 206860190264 2 INSULIN 798.41
18 207220190423 2 INSULIN 4945.80
19 207240280143 2 INSULIN 7933.93
20 207630150433 2 INSULIN 38628.28
21 207930280950 2 INSULIN 10995.12
22 207930281179 2 INSULIN 10995.12
23 208110150249 2 INSULIN 8831.47
24 208890670356 2 INSULIN 1110.85
25 208890670818 2 INSULIN 1110.85
26 209490130282 2 INSULIN 2778.32
27 209490130528 2 INSULIN 2778.32
28 209860130318 2 INSULIN 10957.00
29 209860130483 2 INSULIN 10957.00
30 209860130630 2 INSULIN 10957.00
31 210130260536 2 INSULIN 6000.26
32 210130260947 2 INSULIN 6000.26
33 210710260503 2 INSULIN 1734.55
34 211140160389 2 INSULIN 22401.30
35 211140160492 2 INSULIN 22401.30
36 211240120458 2 INSULIN 10438.07
37 211240120592 2 INSULIN 10438.07
38 211280120752 2 INSULIN 13169.79
39 211550110510 2 INSULIN 1264.83
40 211550110798 2 INSULIN 1264.83
41 211810130907 2 INSULIN 9521.53
42 212870141165 2 INSULIN 4247.04
43 213150200704 2 INSULIN 5720.47
44 213150201050 2 INSULIN 5720.47
45 213370190415 2 INSULIN 13226.39
46 213780230241 2 INSULIN 11078.17
47 213780230354 2 INSULIN 11078.17
48 213840270629 2 INSULIN 10618.12
49 214240110555 2 INSULIN 10619.27
50 214240110795 2 INSULIN 10619.27
51 214990270366 2 INSULIN 5440.46
52 215110133095 2 INSULIN 5884.96
53 215550100918 2 INSULIN 6925.32
HC-077I 12:50 Thursday, September 22, 2005 2
Sample SAS Job for Example D
sample print of OMED (HC-077C) records where OMTYPEX=2
Obs EVNTIDX OMTYPEX PERWT03F
54 216010140657 2 INSULIN 14141.64
55 216130261213 2 INSULIN 7410.55
56 216130262021 2 INSULIN 7410.55
57 216820150334 2 INSULIN 27920.25
58 216820150454 2 INSULIN 27920.25
59 217020400195 2 INSULIN 2267.32
60 217020400246 2 INSULIN 2267.32
61 218200230609 2 INSULIN 17132.56
62 218200230767 2 INSULIN 17132.56
63 218820370239 2 INSULIN 9350.96
64 218820370311 2 INSULIN 9350.96
65 219490270160 2 INSULIN 5034.77
66 220010110645 2 INSULIN 1835.86
67 220780120789 2 INSULIN 2036.68
68 221090240331 2 INSULIN 2568.63
69 221220172064 2 INSULIN 2630.68
70 221220172711 2 INSULIN 2630.68
71 221870141240 2 INSULIN 6347.16
72 221870141562 2 INSULIN 6347.16
73 223030390587 2 INSULIN 3625.48
74 223060180100 2 INSULIN 9146.64
75 223060180162 2 INSULIN 9146.64
76 223360170313 2 INSULIN 9670.09
77 223360170522 2 INSULIN 9670.09
78 223590220422 2 INSULIN 6031.66
79 223640100516 2 INSULIN 4948.44
80 223640100787 2 INSULIN 4948.44
81 224010200106 2 INSULIN 1410.01
82 224090141095 2 INSULIN 8743.18
83 224100100579 2 INSULIN 6949.70
84 224100270853 2 INSULIN 6962.06
85 224340150776 2 INSULIN 14942.06
86 224720190371 2 INSULIN 11239.17
87 225420150512 2 INSULIN 3130.50
88 225420150707 2 INSULIN 3130.50
89 226120200398 2 INSULIN 3354.79
90 226120200521 2 INSULIN 3354.79
91 227780171194 2 INSULIN 2413.94
92 228140130787 2 INSULIN 9285.28
93 229000260507 2 INSULIN 14920.83
94 229000260696 2 INSULIN 14920.83
95 229350191376 2 INSULIN 2539.02
96 230840100344 2 INSULIN 13641.03
97 230840100488 2 INSULIN 13641.03
98 230900220632 2 INSULIN 7418.58
99 230900220865 2 INSULIN 7418.58
100 231420180529 2 INSULIN 8229.01
HC-077I 12:50 Thursday, September 22, 2005 3
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-77IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
200020380044 200020380051 3 EROM
200020380068 3 EROM
200030110018 200030110049 1 MVIS
200030190154 200030190161 1 MVIS
200030260332 200030260363 1 MVIS
200040180290 200040180327 1 MVIS
200040180303 200040180334 1 MVIS
200040180341 200040180365 1 MVIS
200040180358 200040180372 1 MVIS
200070160070 200070160107 5 DVIS
200070160121 200070160169 1 MVIS
200140110148 200140110131 1 MVIS
200140240440 200140240471 1 MVIS
200150190081 200150190101 1 MVIS
200150190118 1 MVIS
200150190125 1 MVIS
200150190132 1 MVIS
200150190194 200150190245 2 OPAT
200150190207 200150190252 1 MVIS
200150190290 200150190303 1 MVIS
200150190310 1 MVIS
200150190327 1 MVIS
200150190334 1 MVIS
200150190341 1 MVIS
200150190358 1 MVIS
200150260012 200150260043 1 MVIS
200160130011 200160130073 1 MVIS
200170120180 200170120217 1 MVIS
200170120231 200170120286 2 OPAT
200170120293 2 OPAT
HC-077I 12:50 Thursday, September 22, 2005 4
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-77IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
200190140130 200190140147 1 MVIS
200190140154 1 MVIS
200190140161 1 MVIS
200190140192 200190140212 1 MVIS
200200160278 200200160312 1 MVIS
200210100083 200210100141 1 MVIS
200210100158 1 MVIS
200210100165 1 MVIS
200210270103 200210270110 1 MVIS
200210270127 1 MVIS
200210340134 200210340158 1 MVIS
200210410045 200210410076 1 MVIS
200220220026 200220220033 1 MVIS
200230100063 200230100107 1 MVIS
200230100114 1 MVIS
200230100070 200230100121 1 MVIS
200230100138 200230100152 1 MVIS
200230100169 1 MVIS
200260290809 200260290861 1 MVIS
200270100088 200270100139 1 MVIS
200270100095 200270100146 1 MVIS
200320100192 200320100243 1 MVIS
200320100250 1 MVIS
200320100267 1 MVIS
200320100274 1 MVIS
200320100281 1 MVIS
200320100298 1 MVIS
200320270058 200320270089 1 MVIS
200320340041 200320340089 1 MVIS
200330150118 200330150125 3 EROM
200340110218 200340110249 1 MVIS
HC-077I 12:50 Thursday, September 22, 2005 5
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-77IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
200340280167 200340280181 1 MVIS
200340280198 1 MVIS
200340280232 200340280249 1 MVIS
200350180068 200350180082 5 DVIS
200350180099 5 DVIS
200390150096 200390150123 5 DVIS
200390150130 5 DVIS
200390220325 200390220356 1 MVIS
200390220407 200390220476 1 MVIS
200390220483 1 MVIS
200390220490 1 MVIS
200390220445 200390220510 1 MVIS
200390220534 200390220541 1 MVIS
200410170407 200410170510 1 MVIS
200410170527 1 MVIS
200450150111 200450150159 1 MVIS
200450150200 200450150217 1 MVIS
200450150224 1 MVIS
200460470063 200460470070 1 MVIS
200460470094 200460470107 1 MVIS
200480150114 200480150532 4 STAZ
200480150549 4 STAZ
200480150556 4 STAZ
200480150474 200480150563 1 MVIS
200480150607 200480150621 1 MVIS
200490150117 200490150131 1 MVIS
200490150148 1 MVIS
200490150124 200490150155 3 EROM
200490150162 200490150179 4 STAZ
200490460011 200490460028 1 MVIS
HC-077I 12:50 Thursday, September 22, 2005 6
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-77IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
200490460035 200490460059 1 MVIS
200490460042 200490460066 5 DVIS
200510130171 200510130208 1 MVIS
200510130222 200510130239 1 MVIS
200520110035 200520110042 5 DVIS
200520140070 200520140094 1 MVIS
200530140031 200530140106 2 OPAT
200530140113 2 OPAT
200530380137 200530380144 2 OPAT
200540110241 200540110272 1 MVIS
200540110289 1 MVIS
200540110296 1 MVIS
200540110309 1 MVIS
200540110316 1 MVIS
200540110323 1 MVIS
200540110330 1 MVIS
200540160260 200540160304 1 MVIS
200540160277 200540160311 1 MVIS
200540160328 200540160373 1 MVIS
200540160380 1 MVIS
200540160397 1 MVIS
200540230133 200540230195 1 MVIS
200540230208 1 MVIS
200540230215 200540230239 1 MVIS
200540230246 1 MVIS
200540230253 1 MVIS
200540230260 1 MVIS
200540230222 200540230277 1 MVIS
200560180053 200560180077 3 EROM
200590180045 200590180052 3 EROM
200590180083 200590180134 3 EROM
200590180141 3 EROM
HC-077I 12:50 Thursday, September 22, 2005 7
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-77IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
200600100227 200600100258 1 MVIS
200600100265 1 MVIS
200600100272 1 MVIS
200610130137 200610130151 1 MVIS
200610130168 1 MVIS
200610130175 1 MVIS
200640101122 200640101160 1 MVIS
200640101139 200640101177 1 MVIS
200680270043 200680270074 5 DVIS
200680270081 5 DVIS
200680340101 200680340132 1 MVIS
200680340149 1 MVIS
200700260345 200700260383 1 MVIS
200700330054 200700330061 1 MVIS
200700480176 200700480190 1 MVIS
200700480210 200700480227 1 MVIS
200720190272 200720190323 4 STAZ
200720190330 4 STAZ
200720190450 200720190481 1 MVIS
200720190498 1 MVIS
200720190501 1 MVIS
200720190518 1 MVIS
200720190525 1 MVIS
200720190532 1 MVIS
200720190549 1 MVIS
200720190556 1 MVIS
200740260214 200740260221 4 STAZ
HC-077I 12:50 Thursday, September 22, 2005 8
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-77IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
201070130735 201070130742 6 OMED
201070130759 201070130766 6 OMED
201150170552 201150170569 6 OMED
201160190278 201160190285 6 OMED
201160190367 201160190374 6 OMED
201290110356 201290110363 6 OMED
201290110370 201290110387 6 OMED
201290110452 201290110469 6 OMED
201510150554 201510150561 6 OMED
201510150578 201510150585 6 OMED
201540110030 201540110047 6 OMED
201620290820 201620290837 6 OMED
202010190260 202010190277 6 OMED
202240230374 202240230381 6 OMED
202620130686 202620130693 6 OMED
202750160831 202750160848 6 OMED
202750160855 202750160862 6 OMED
202900140947 202900140954 6 OMED
202900141173 202900141180 6 OMED
203130180202 203130180219 6 OMED
203130180315 203130180322 6 OMED
203210190346 203210190353 6 OMED
203300140404 203300140411 6 OMED
203300140473 203300140480 6 OMED
203300140497 203300140500 6 OMED
HC-077I 12:50 Thursday, September 22, 2005 9
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-77IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
203450100524 203450100531 6 OMED
203520150217 203520150224 6 OMED
203630110195 203630110208 6 OMED
203960100375 203960100382 6 OMED
203980200537 203980200544 6 OMED
204580280256 204580280263 6 OMED
204910230759 204910230766 6 OMED
205070150653 205070150660 6 OMED
205150110452 205150110469 6 OMED
205150110476 205150110483 6 OMED
205320130826 205320130833 6 OMED
205320130840 205320130857 6 OMED
205320130922 205320130939 6 OMED
205560200235 205560200242 6 OMED
205560200259 205560200266 6 OMED
205560200300 205560200317 6 OMED
205560200324 205560200331 6 OMED
205690140558 205690140565 6 OMED
205690140894 205690140907 6 OMED
205690140914 205690140921 6 OMED
205780100970 205780100987 6 OMED
205780101202 205780101219 6 OMED
205780101226 205780101233 6 OMED
205860130234 205860130241 6 OMED
206050140504 206050140511 6 OMED
HC-077I 12:50 Thursday, September 22, 2005 10
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-77IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
206150150494 206150150507 6 OMED
206840120324 206840120331 6 OMED
206840120413 206840120420 6 OMED
206840120437 206840120444 6 OMED
206860190264 206860190271 6 OMED
206860190288 206860190295 6 OMED
207220190423 207220190430 6 OMED
207240280143 207240280150 6 OMED
207240280167 207240280174 6 OMED
207240280198 207240280201 6 OMED
207410200455 207410200462 6 OMED
207540190451 207540190468 6 OMED
207630150351 207630150368 6 OMED
207630150433 207630150440 6 OMED
207630150457 207630150464 6 OMED
207930280950 207930280967 6 OMED
207930280974 207930280981 6 OMED
207930281179 207930281186 6 OMED
207930281193 207930281206 6 OMED
207940210524 207940210531 6 OMED
208110150249 208110150256 6 OMED
208110150263 208110150270 6 OMED
208110150307 208110150314 6 OMED
208320230650 208320230667 6 OMED
208890110148 208890110155 6 OMED
HC-077I 12:50 Thursday, September 22, 2005 11
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-77IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
208890670356 208890670363 6 OMED
208890670370 208890670387 6 OMED
208890670818 208890670825 6 OMED
209020160461 209020160478 6 OMED
209120290389 209120290396 6 OMED
209120290512 209120290529 6 OMED
209490130282 209490130299 6 OMED
209490130302 209490130319 6 OMED
209490130528 209490130535 6 OMED
209490130542 209490130559 6 OMED
209860130318 209860130325 6 OMED
209860130332 209860130349 6 OMED
209860130469 209860130476 6 OMED
209860130483 209860130490 6 OMED
209860130630 209860130647 6 OMED
209860130654 209860130661 6 OMED
209940131177 209940131184 6 OMED
210130260536 210130260543 6 OMED
210130260550 210130260567 6 OMED
210130260947 210130260954 6 OMED
210130260961 210130260978 6 OMED
210710260503 210710260510 6 OMED
210710260527 210710260534 6 OMED
210900100806 210900100813 6 OMED
211040110301 211040110318 6 OMED
HC-077I 12:50 Thursday, September 22, 2005 12
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-77IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
211040110476 211040110483 6 OMED
211140160389 211140160396 6 OMED
211140160409 211140160416 6 OMED
211140160492 211140160505 6 OMED
211140160512 211140160529 6 OMED
211240120458 211240120465 6 OMED
211240120472 211240120489 6 OMED
211240120578 211240120585 6 OMED
211240120592 211240120605 6 OMED
211280120752 211280120769 6 OMED
211550110510 211550110527 6 OMED
211550110541 211550110558 6 OMED
211550110798 211550110801 6 OMED
211550110818 211550110825 6 OMED
211640120749 211640120756 6 OMED
211640120787 211640120794 6 OMED
211810130907 211810130914 6 OMED
211810130921 211810130938 6 OMED
212510151729 212510151736 6 OMED
212530250574 212530250581 6 OMED
HC-077I 12:50 Thursday, September 22, 2005 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
201070130735 201070130742 6 OMED
201150170552 201150170569 6 OMED
201290110356 201290110363 6 OMED
201510150554 201510150561 6 OMED
202750160855 202750160862 6 OMED
203300140473 203300140480 6 OMED
205150110452 205150110469 6 OMED
205320130826 205320130833 6 OMED
205560200235 205560200242 6 OMED
205560200300 205560200317 6 OMED
205690140894 205690140907 6 OMED
205780101202 205780101219 6 OMED
206840120413 206840120420 6 OMED
206860190264 206860190271 6 OMED
207220190423 207220190430 6 OMED
207240280143 207240280150 6 OMED
207630150433 207630150440 6 OMED
207930280950 207930280967 6 OMED
207930281179 207930281186 6 OMED
208110150249 208110150256 6 OMED
208890670356 208890670363 6 OMED
208890670818 208890670825 6 OMED
209490130282 209490130299 6 OMED
209490130528 209490130535 6 OMED
209860130318 209860130325 6 OMED
HC-077I 12:50 Thursday, September 22, 2005 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
209860130483 209860130490 6 OMED
209860130630 209860130647 6 OMED
210130260536 210130260543 6 OMED
210130260947 210130260954 6 OMED
210710260503 210710260510 6 OMED
211140160389 211140160396 6 OMED
211140160492 211140160505 6 OMED
211240120458 211240120465 6 OMED
211240120592 211240120605 6 OMED
211280120752 211280120769 6 OMED
211550110510 211550110527 6 OMED
211550110798 211550110801 6 OMED
211810130907 211810130914 6 OMED
212870141165 212870141172 6 OMED
213150200704 213150200711 6 OMED
213150201050 213150201067 6 OMED
213370190415 213370190422 6 OMED
213780230241 213780230258 6 OMED
213780230354 213780230361 6 OMED
213840270629 213840270636 6 OMED
214240110555 214240110562 6 OMED
214240110795 214240110808 6 OMED
214990270366 214990270373 6 OMED
215110133095 215110133108 6 OMED
215550100918 215550100925 6 OMED
HC-077I 12:50 Thursday, September 22, 2005 15
Sample SAS Job for Example D
sample print of work.pmedids - sorted by linkidx
Obs EVNTIDX LINKIDX EVENTYPE
1 201070130735 201070130742 6 OMED
2 201150170552 201150170569 6 OMED
3 201290110356 201290110363 6 OMED
4 201510150554 201510150561 6 OMED
5 202750160855 202750160862 6 OMED
6 203300140473 203300140480 6 OMED
7 205150110452 205150110469 6 OMED
8 205320130826 205320130833 6 OMED
9 205560200235 205560200242 6 OMED
10 205560200300 205560200317 6 OMED
11 205690140894 205690140907 6 OMED
12 205780101202 205780101219 6 OMED
13 206840120413 206840120420 6 OMED
14 206860190264 206860190271 6 OMED
15 207220190423 207220190430 6 OMED
16 207240280143 207240280150 6 OMED
17 207630150433 207630150440 6 OMED
18 207930280950 207930280967 6 OMED
19 207930281179 207930281186 6 OMED
20 208110150249 208110150256 6 OMED
21 208890670356 208890670363 6 OMED
22 208890670818 208890670825 6 OMED
23 209490130282 209490130299 6 OMED
24 209490130528 209490130535 6 OMED
25 209860130318 209860130325 6 OMED
26 209860130483 209860130490 6 OMED
27 209860130630 209860130647 6 OMED
28 210130260536 210130260543 6 OMED
29 210130260947 210130260954 6 OMED
30 210710260503 210710260510 6 OMED
31 211140160389 211140160396 6 OMED
32 211140160492 211140160505 6 OMED
33 211240120458 211240120465 6 OMED
34 211240120592 211240120605 6 OMED
35 211280120752 211280120769 6 OMED
36 211550110510 211550110527 6 OMED
37 211550110798 211550110801 6 OMED
38 211810130907 211810130914 6 OMED
39 212870141165 212870141172 6 OMED
40 213150200704 213150200711 6 OMED
41 213150201050 213150201067 6 OMED
42 213370190415 213370190422 6 OMED
43 213780230241 213780230258 6 OMED
44 213780230354 213780230361 6 OMED
45 213840270629 213840270636 6 OMED
46 214240110555 214240110562 6 OMED
47 214240110795 214240110808 6 OMED
48 214990270366 214990270373 6 OMED
49 215110133095 215110133108 6 OMED
50 215550100918 215550100925 6 OMED
HC-077I 12:50 Thursday, September 22, 2005 16
Sample SAS Job for Example D
sample print of unique linkidxs in work.pmedids
Obs LINKIDX
1 201070130742
2 201150170569
3 201290110363
4 201510150561
5 202750160862
6 203300140480
7 205150110469
8 205320130833
9 205560200242
10 205560200317
11 205690140907
12 205780101219
13 206840120420
14 206860190271
15 207220190430
16 207240280150
17 207630150440
18 207930280967
19 207930281186
20 208110150256
21 208890670363
22 208890670825
23 209490130299
24 209490130535
25 209860130325
26 209860130490
27 209860130647
28 210130260543
29 210130260954
30 210710260510
31 211140160396
32 211140160505
33 211240120465
34 211240120605
35 211280120769
36 211550110527
37 211550110801
38 211810130914
39 212870141172
40 213150200711
41 213150201067
42 213370190422
43 213780230258
44 213780230361
45 213840270636
46 214240110562
47 214240110808
48 214990270373
49 215110133108
50 215550100925
HC-077I 12:50 Thursday, September 22, 2005 17
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
201070130742 201070130742001 HUMULIN R (VIAL) 91.57 21413.847955
201150170569 201150170569001 INSULIN 103.83 7928.833801
201150170569002 INSULIN 103.83 7928.833801
201150170569003 INSULIN 103.83 7928.833801
201150170569004 INSULIN 103.83 7928.833801
201150170569005 INSULIN 103.83 7928.833801
201150170569006 INSULIN 103.83 7928.833801
201150170569007 INSULIN 103.83 7928.833801
201150170569008 INSULIN 103.83 7928.833801
201290110363 201290110363001 HUMULIN 70/30 (VIAL) 25.59 10556.524398
201290110363002 HUMULIN 70/30 (VIAL) 25.59 10556.524398
201290110363003 HUMULIN 70/30 (VIAL) 25.59 10556.524398
201510150561 201510150561001 HUMULIN 70/30 (VIAL) 49.63 3903.946581
201510150561002 HUMULIN 70/30 (VIAL) 49.63 3903.946581
201510150561003 HUMULIN 70/30 (VIAL) 49.63 3903.946581
201510150561004 HUMULIN 70/30 (VIAL) 49.63 3903.946581
202750160862 202750160862001 INSULIN GLARGINE 103.83 13836.137339
202750160862002 INSULIN GLARGINE 103.83 13836.137339
202750160862003 INSULIN GLARGINE 103.83 13836.137339
203300140480 203300140480001 INSULIN 103.83 9605.816176
203300140480002 INSULIN 103.83 9605.816176
203300140480003 INSULIN 103.83 9605.816176
203300140480004 INSULIN 103.83 9605.816176
203300140480005 INSULIN 103.83 9605.816176
205150110469 205150110469001 HUMULIN N (VIAL) 55.78 4405.721708
205150110469002 HUMULIN N (VIAL) 55.78 4405.721708
205150110469003 HUMULIN N (VIAL) 55.78 4405.721708
205150110469004 HUMULIN N (VIAL) 55.78 4405.721708
205150110469005 HUMULIN N (VIAL) 55.78 4405.721708
205150110469006 HUMULIN N (VIAL) 55.78 4405.721708
205320130833 205320130833001 INSULIN 103.83 3312.146873
205320130833002 INSULIN 103.83 3312.146873
205320130833003 INSULIN 103.83 3312.146873
205320130833004 INSULIN 103.83 3312.146873
205320130833005 INSULIN 103.83 3312.146873
205320130833006 INSULIN 103.83 3312.146873
205320130833007 INSULIN 103.83 3312.146873
205560200242 205560200242001 INSULIN 103.83 4821.824005
205560200242002 INSULIN 103.83 4821.824005
205560200242003 INSULIN 103.83 4821.824005
205560200242004 INSULIN 103.83 4821.824005
HC-077I 12:50 Thursday, September 22, 2005 18
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
205560200317 205560200317001 INSULIN 103.83 4821.824005
205560200317002 INSULIN 103.83 4821.824005
205560200317003 INSULIN 103.83 4821.824005
205690140907 205690140907001 INSULIN 103.83 2794.048924
205690140907002 INSULIN 103.83 2794.048924
205690140907003 INSULIN 103.83 2794.048924
205690140907004 INSULIN 103.83 2794.048924
205690140907005 INSULIN 103.83 2794.048924
205690140907006 INSULIN 103.83 2794.048924
205690140907007 INSULIN 103.83 2794.048924
205690140907008 INSULIN 103.83 2794.048924
205780101219 205780101219001 HUMULIN N VIAL 55.49 2040.928435
206840120420 206840120420001 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 35.00 7362.001510
206840120420002 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 35.00 7362.001510
206840120420003 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 35.00 7362.001510
206860190271 206860190271001 INSULIN 103.83 798.413705
206860190271002 INSULIN 103.83 798.413705
207220190430 207220190430001 INSULIN 103.83 4945.800401
207240280150 207240280150001 INSULIN 103.83 7933.934395
207240280150002 INSULIN 103.83 7933.934395
207240280150003 INSULIN 103.83 7933.934395
207630150440 207630150440001 INSULIN 103.83 38628.283327
207630150440002 INSULIN 103.83 38628.283327
207630150440003 INSULIN 103.83 38628.283327
207630150440004 INSULIN 103.83 38628.283327
207630150440005 INSULIN 103.83 38628.283327
207630150440006 INSULIN 103.83 38628.283327
207630150440007 INSULIN 103.83 38628.283327
207630150440008 INSULIN 103.83 38628.283327
207930280967 207930280967001 HUMALOG 56.19 10995.118391
207930280967002 HUMALOG 56.19 10995.118391
207930281186 207930281186001 HUMULIN 53.18 10995.118391
207930281186002 HUMULIN 53.18 10995.118391
207930281186003 HUMULIN 53.18 10995.118391
207930281186004 HUMULIN 53.18 10995.118391
208110150256 208110150256001 HUMALOG (VIAL) 138.22 8831.466725
208110150256002 HUMALOG (VIAL) 138.22 8831.466725
208890670363 208890670363001 INSULIN 103.83 1110.845283
HC-077I 12:50 Thursday, September 22, 2005 19
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
208890670363 208890670363002 INSULIN 103.83 1110.845283
208890670825 208890670825001 INSULIN 103.83 1110.845283
208890670825002 INSULIN 103.83 1110.845283
208890670825003 INSULIN 103.83 1110.845283
208890670825004 INSULIN 103.83 1110.845283
208890670825005 INSULIN 103.83 1110.845283
208890670825006 INSULIN 103.83 1110.845283
208890670825007 INSULIN 103.83 1110.845283
208890670825008 INSULIN 103.83 1110.845283
209490130299 209490130299001 LANTUS 52.01 2778.320542
209490130299002 LANTUS 52.01 2778.320542
209490130299003 LANTUS 52.01 2778.320542
209490130299004 LANTUS 52.01 2778.320542
209490130299005 LANTUS 52.01 2778.320542
209490130299006 LANTUS 52.01 2778.320542
209490130299007 LANTUS 52.01 2778.320542
209490130535 209490130535001 INSULIN 103.83 2778.320542
209490130535002 INSULIN 103.83 2778.320542
209490130535003 INSULIN 103.83 2778.320542
209860130325 209860130325001 LANTUS 51.21 10956.996571
209860130490 209860130490001 LANTUS 51.21 10956.996571
209860130490002 LANTUS 51.21 10956.996571
209860130490003 LANTUS 51.21 10956.996571
209860130490004 LANTUS 51.21 10956.996571
209860130647 209860130647001 LANTUS 51.21 10956.996571
209860130647002 LANTUS 51.21 10956.996571
209860130647003 LANTUS 51.21 10956.996571
209860130647004 LANTUS 51.21 10956.996571
210130260543 210130260543001 HUMULIN 70/30 (VIAL) 27.89 6000.264925
210130260543002 HUMULIN 70/30 (VIAL) 27.89 6000.264925
210130260954 210130260954001 HUMULIN 70/30 (VIAL) 27.89 6000.264925
210130260954002 HUMULIN 70/30 (VIAL) 27.89 6000.264925
210130260954003 HUMULIN 70/30 (VIAL) 27.89 6000.264925
210130260954004 HUMULIN 70/30 (VIAL) 27.89 6000.264925
210130260954005 HUMULIN 70/30 (VIAL) 27.89 6000.264925
210130260954006 HUMULIN 70/30 (VIAL) 27.89 6000.264925
210130260954007 HUMULIN 70/30 (VIAL) 27.89 6000.264925
210130260954008 HUMULIN 70/30 (VIAL) 27.89 6000.264925
210710260510 210710260510001 INSULIN 103.83 1734.549821
210710260510002 INSULIN 103.83 1734.549821
HC-077I 12:50 Thursday, September 22, 2005 20
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
211140160396 211140160396001 LANTUS 51.21 22401.303900
211140160396002 LANTUS 51.21 22401.303900
211140160396003 LANTUS 51.21 22401.303900
211140160396004 LANTUS 51.21 22401.303900
211140160396005 LANTUS 51.21 22401.303900
211140160396006 LANTUS 51.21 22401.303900
211140160505 211140160505001 INSULIN 103.83 22401.303900
211240120465 211240120465001 INSULIN 103.83 10438.072776
211240120465002 INSULIN 103.83 10438.072776
211240120465003 INSULIN 103.83 10438.072776
211240120465004 INSULIN 103.83 10438.072776
211240120605 211240120605001 INSULIN NPH (HUMAN) 114.99 10438.072776
211240120605002 INSULIN NPH (HUMAN) 114.99 10438.072776
211240120605003 INSULIN NPH (HUMAN) 114.99 10438.072776
211240120605004 INSULIN NPH (HUMAN) 114.99 10438.072776
211240120605005 INSULIN NPH (HUMAN) 114.99 10438.072776
211280120769 211280120769001 INSULIN 103.83 13169.794345
211550110527 211550110527001 INSULIN 103.83 1264.826974
211550110527002 INSULIN 103.83 1264.826974
211550110527003 INSULIN 103.83 1264.826974
211550110527004 INSULIN 103.83 1264.826974
211550110527005 INSULIN 103.83 1264.826974
211550110801 211550110801001 INSULIN 103.83 1264.826974
211550110801002 INSULIN 103.83 1264.826974
211550110801003 INSULIN 103.83 1264.826974
211810130914 211810130914001 INSULIN 103.83 9521.526170
211810130914002 INSULIN 103.83 9521.526170
211810130914003 INSULIN 103.83 9521.526170
212870141172 212870141172001 INSULIN 103.83 4247.035759
212870141172002 INSULIN 103.83 4247.035759
212870141172003 INSULIN 103.83 4247.035759
212870141172004 INSULIN 103.83 4247.035759
213150200711 213150200711001 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 118.66 5720.466564
213150200711002 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 118.66 5720.466564
213150200711003 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 118.66 5720.466564
213150200711004 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 118.66 5720.466564
213150200711005 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 118.66 5720.466564
213150201067 213150201067001 INSULIN 103.83 5720.466564
213150201067002 INSULIN 103.83 5720.466564
HC-077I 12:50 Thursday, September 22, 2005 21
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
213150201067 213150201067003 INSULIN 103.83 5720.466564
213370190422 213370190422001 INSULIN 103.83 13226.386080
213370190422002 INSULIN 103.83 13226.386080
213780230258 213780230258001 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 268.14 11078.170128
213780230258002 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 268.14 11078.170128
213780230361 213780230361001 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 292.00 11078.170128
213840270636 213840270636001 INSULIN 103.83 10618.122267
214240110562 214240110562001 INSULIN REG 138.99 10619.273513
214240110808 214240110808001 INSULIN 103.83 10619.273513
214990270373 214990270373001 INSULIN 103.83 5440.456183
215110133108 215110133108001 HUMULIN R (VIAL) 25.00 5884.958199
215550100925 215550100925001 HUMULIN N (VIAL) 27.93 6925.319204
215550100925002 HUMULIN N (VIAL) 27.93 6925.319204
215550100925003 HUMULIN N (VIAL) 27.93 6925.319204
215550100925004 HUMULIN N (VIAL) 27.93 6925.319204
216010140664 216010140664001 INSULIN 103.83 14141.643143
216010140664002 INSULIN 103.83 14141.643143
216130261220 216130261220001 HUMULIN N PEN (PREFILLED DISPOSABLE) 145.99 7410.547658
216130262038 216130262038001 HUMALOG PEN (PREFILLED DISPOSABLE) 110.11 7410.547658
216130262038002 HUMALOG PEN (PREFILLED DISPOSABLE) 110.11 7410.547658
216130262038003 HUMALOG PEN (PREFILLED DISPOSABLE) 110.11 7410.547658
216820150341 216820150341001 INSULIN 103.83 27920.253994
216820150341002 INSULIN 103.83 27920.253994
216820150461 216820150461001 NOVOLIN R PENFILL (SRN) 163.40 27920.253994
217020400208 217020400208001 INSULIN 103.83 2267.315815
217020400208002 INSULIN 103.83 2267.315815
217020400208003 INSULIN 103.83 2267.315815
217020400208004 INSULIN 103.83 2267.315815
217020400208005 INSULIN 103.83 2267.315815
217020400208006 INSULIN 103.83 2267.315815
217020400253 217020400253001 INSULIN 103.83 2267.315815
217020400253002 INSULIN 103.83 2267.315815
217020400253003 INSULIN 103.83 2267.315815
HC-077I 12:50 Thursday, September 22, 2005 22
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-077A) records for unique linkidxs in work.pmedids
linkidx rxrecidx RXNAME RXXP03X PERWT03F
217020400253 217020400253004 INSULIN 103.83 2267.315815
217020400253005 INSULIN 103.83 2267.315815
218200230616 218200230616001 HUMULIN 70/30 (VIAL) 72.62 17132.561258
218200230616002 HUMULIN 70/30 (VIAL) 72.62 17132.561258
218200230774 218200230774001 HUMULIN 70/30 (VIAL) 79.28 17132.561258
218200230774002 HUMULIN 70/30 (VIAL) 79.28 17132.561258
218820370246 218820370246001 HUMULIN N (VIAL) 33.50 9350.958142
218820370246002 HUMULIN N (VIAL) 33.50 9350.958142
218820370246003 HUMULIN N (VIAL) 33.50 9350.958142
HC-077I 12:50 Thursday, September 22, 2005 23
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
The MEANS Procedure
Analysis Variable : RXXP03X SUM OF PAYMENTS RXSF03X-RXOU03X(IMPUTED)
N Sum
--------------------
2051 174317.49
--------------------
HC-077I 12:50 Thursday, September 22, 2005 24
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
Weighted
The MEANS Procedure
Analysis Variable : RXXP03X SUM OF PAYMENTS RXSF03X-RXOU03X(IMPUTED)
N Sum
--------------------
2051 1429152836
--------------------
<< previous page