1 The SAS System 10:56 Thursday, October 28, 2004
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 82BX08.
NOTE: SAS initialization used:
real time 2.39 seconds
cpu time 0.48 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-067I";
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
2 The SAS System 10:56 Thursday, October 28, 2004
25 *-------------------------------------------------------------------------------------
26 * Get condition records coded as asthma.
27 *-------------------------------------------------------------------------------------;
28 DATA ASCONDS;
29 SET IN.H69 (KEEP=CONDIDX CCCODEX);
30 IF CCCODEX="128";
31
32 RUN;
NOTE: There were 120795 observations read from the data set IN.H69.
NOTE: The data set WORK.ASCONDS has 2159 observations and 2 variables.
NOTE: DATA statement used:
real time 0.50 seconds
cpu time 0.17 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 2159 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 2159 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.07 seconds
cpu time 0.01 seconds
38
39 proc print data=asconds (obs=50);
40 title3 "sample print of work.asconds - sorted by condidx";
41 title4 "COND (H69) 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.28 seconds
cpu time 0.01 seconds
43
44 PROC SORT DATA=IN.H67IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 388065 observations read from the data set IN.H67IF1.
NOTE: The data set WORK.CLNK has 388065 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 23.14 seconds
cpu time 2.49 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 10:56 Thursday, October 28, 2004
50 IF INCLNK & INASCOND;
51 RUN;
NOTE: There were 388065 observations read from the data set WORK.CLNK.
NOTE: There were 2159 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 8833 observations and 3 variables.
NOTE: DATA statement used:
real time 0.42 seconds
cpu time 0.40 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.15 seconds
cpu time 0.00 seconds
60
61 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 8833 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 8833 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.03 seconds
cpu time 0.03 seconds
62
63 proc print data=asclnks (obs=50);
64 format eventype eventype.;
65 title3 "sample print of work.asclnks - sorted by evntidx";
66 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used:
real time 0.04 seconds
cpu time 0.00 seconds
67
68 DATA ASCLNKS;
69 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
70 BY EVNTIDX;
71 IF FIRST.EVNTIDX;
72 RUN;
4 The SAS System 10:56 Thursday, October 28, 2004
NOTE: There were 8833 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 8830 observations and 2 variables.
NOTE: DATA statement used:
real time 0.04 seconds
cpu time 0.03 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.03 seconds
cpu time 0.03 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.H67G (KEEP=EVNTIDX PERWT02F SEETLKPV);
84 IF PERWT02F > 0 & SEETLKPV NE 2;
85 RUN;
NOTE: There were 179745 observations read from the data set IN.H67G.
NOTE: The data set WORK.MVIS has 173591 observations and 3 variables.
NOTE: DATA statement used:
real time 2.03 seconds
cpu time 0.63 seconds
86
87 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 173591 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 173591 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 2.85 seconds
cpu time 0.65 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 10:56 Thursday, October 28, 2004
NOTE: There were 8830 observations read from the data set WORK.ASCLNKS.
NOTE: There were 173591 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 2916 observations and 2 variables.
NOTE: DATA statement used:
real time 0.18 seconds
cpu time 0.18 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-067G) 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.03 seconds
cpu time 0.01 seconds
104
105 *-------------------------------------------------------------------------------------
106 * Get PMED IDs linked to the MVIS events which were for asthma.
107 *-------------------------------------------------------------------------------------;
108 PROC SORT DATA=IN.H67IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: There were 72467 observations read from the data set IN.H67IF2.
NOTE: The data set WORK.RXLK has 72467 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 0.43 seconds
cpu time 0.35 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-67IF2)";
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.00 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 10:56 Thursday, October 28, 2004
123 IF INRXLK & INASMVIS;
124 RUN;
NOTE: There were 72467 observations read from the data set WORK.RXLK.
NOTE: There were 2916 observations read from the data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 2468 observations and 3 variables.
NOTE: DATA statement used:
real time 0.09 seconds
cpu time 0.09 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.03 seconds
cpu time 0.00 seconds
133
134 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 2468 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 2468 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.01 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 10:56 Thursday, October 28, 2004
NOTE: There were 2468 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 2264 observations and 1 variables.
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.01 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.H67A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 339308 observations read from the data set IN.H67A.
NOTE: The data set WORK.PMED has 339308 observations and 70 variables.
NOTE: PROCEDURE SORT used:
real time 7:22.73
cpu time 34.74 seconds
155
156 DATA MVPMEDS;
157 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP02X PERWT02F RXNAME)
158 PMEDIDS (IN=A);
159 BY LINKIDX;
160 IF A;
161 RUN;
NOTE: There were 339308 observations read from the data set WORK.PMED.
NOTE: There were 2264 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 6328 observations and 5 variables.
NOTE: DATA statement used:
real time 10.98 seconds
cpu time 0.99 seconds
162
163 proc print data=mvpmeds (obs=200);
164 var rxrecidx rxname RXXP02X PERWT02F;
165 by linkidx;
166 id linkidx;
167 title3 "sample print of work.mvpmeds";
168 title4 "PMED (HC-067A) records for unique linkidxs in work.pmedids";
169 run;
8 The SAS System 10:56 Thursday, October 28, 2004
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.14 seconds
cpu time 0.01 seconds
170
171 PROC MEANS DATA=MVPMEDS N SUM;
172 VAR RXXP02X;
173 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
174 RUN;
NOTE: There were 6328 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 22.
NOTE: PROCEDURE MEANS used:
real time 0.25 seconds
cpu time 0.01 seconds
175
176 PROC MEANS DATA=MVPMEDS N SUM;
177 VAR RXXP02X;
178 WEIGHT PERWT02F;
179 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
180 TITLE5 "Weighted";
181 RUN;
NOTE: There were 6328 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used:
real time 0.03 seconds
cpu time 0.01 seconds
182
183
184
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 8:09.28
cpu time 41.59 seconds
HC-067I 10:56 Thursday, October 28, 2004 1
Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H69) records where cccodex=128
Obs CONDIDX CCCODEX
1 200210270023 128
2 200260120036 128
3 200300100028 128
4 200340280018 128
5 200390220116 128
6 200410170097 128
7 200530380017 128
8 200540230019 128
9 200640100022 128
10 200640100141 128
11 200760300018 128
12 200860130041 128
13 200880360010 128
14 201090290010 128
15 201100200048 128
16 201100440018 128
17 201150170015 128
18 201170490019 128
19 201170550019 128
20 201290280019 128
21 201550320028 128
22 201790120016 128
23 201790290043 128
24 201790360014 128
25 201790590029 128
26 201840320043 128
27 201860330010 128
28 201860330032 128
29 201930150013 128
30 201980300032 128
31 202000130025 128
32 202030180047 128
33 202170150026 128
34 202170290028 128
35 202240300029 128
36 202350170021 128
37 202620130056 128
38 202650560036 128
39 202680360017 128
40 202680360051 128
41 202680430038 128
42 202680590038 128
43 202740110040 128
44 202900140013 128
45 202990190017 128
46 203080160025 128
47 203600120037 128
48 203600290042 128
49 203650120019 128
50 203740440015 128
HC-067I 10:56 Thursday, October 28, 2004 2
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200210270023 200210270069 8 PMED
200210270083 8 PMED
200260120036 200260120056 1 MVIS
200260120190 8 PMED
200260120354 1 MVIS
200260120816 8 PMED
200260120847 8 PMED
200260120854 8 PMED
200300100028 200300100019 1 MVIS
200300100026 8 PMED
200340280018 200340280016 8 PMED
200340280030 8 PMED
200340280054 8 PMED
200340280061 8 PMED
200340280085 8 PMED
200340280092 1 MVIS
200340280143 8 PMED
200340280150 8 PMED
200390220116 200390220363 8 PMED
200410170097 200410170229 8 PMED
200410170236 8 PMED
200530380017 200530380017 3 EROM
200530380024 3 EROM
200530380062 8 PMED
200530380106 8 PMED
200540230019 200540230020 1 MVIS
200540230037 1 MVIS
200540230044 8 PMED
200540230051 8 PMED
200540230075 8 PMED
200540230126 1 MVIS
200540230164 8 PMED
200540230171 8 PMED
200540230188 8 PMED
200640100022 200640100030 1 MVIS
200640100232 8 PMED
200640100249 8 PMED
200640100749 8 PMED
200640100883 8 PMED
200640100890 8 PMED
HC-067I 10:56 Thursday, October 28, 2004 3
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200640100141 200640100605 2 OPAT
200640100612 2 OPAT
200640100756 8 PMED
200760300018 200760300058 8 PMED
200760300161 8 PMED
200860130041 200860130063 8 PMED
200860130070 8 PMED
200860130087 8 PMED
200860130094 8 PMED
200860130145 8 PMED
200860130234 8 PMED
200880360010 200880360038 8 PMED
200880360103 8 PMED
201090290010 201090290019 8 PMED
201090290026 8 PMED
201090290040 8 PMED
201100200048 201100200124 1 MVIS
201100200131 1 MVIS
201100200155 1 MVIS
201100200162 8 PMED
201100200179 8 PMED
201100440018 201100440028 1 MVIS
201100440080 8 PMED
201100440097 8 PMED
201100440100 8 PMED
201100440155 8 PMED
201150170015 201150170292 8 PMED
201150170381 8 PMED
201170490019 201170490059 8 PMED
201170490066 8 PMED
201170550019 201170550012 1 MVIS
201170550029 1 MVIS
201170550036 1 MVIS
201170550043 1 MVIS
201170550050 1 MVIS
HC-067I 10:56 Thursday, October 28, 2004 4
Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 200210270023 200210270069 8 PMED
2 200210270023 200210270083 8 PMED
3 200260120036 200260120056 1 MVIS
4 200260120036 200260120190 8 PMED
5 200260120036 200260120354 1 MVIS
6 200260120036 200260120816 8 PMED
7 200260120036 200260120847 8 PMED
8 200260120036 200260120854 8 PMED
9 200300100028 200300100019 1 MVIS
10 200300100028 200300100026 8 PMED
11 200340280018 200340280016 8 PMED
12 200340280018 200340280030 8 PMED
13 200340280018 200340280054 8 PMED
14 200340280018 200340280061 8 PMED
15 200340280018 200340280085 8 PMED
16 200340280018 200340280092 1 MVIS
17 200340280018 200340280143 8 PMED
18 200340280018 200340280150 8 PMED
19 200390220116 200390220363 8 PMED
20 200410170097 200410170229 8 PMED
21 200410170097 200410170236 8 PMED
22 200530380017 200530380017 3 EROM
23 200530380017 200530380024 3 EROM
24 200530380017 200530380062 8 PMED
25 200530380017 200530380106 8 PMED
26 200540230019 200540230020 1 MVIS
27 200540230019 200540230037 1 MVIS
28 200540230019 200540230044 8 PMED
29 200540230019 200540230051 8 PMED
30 200540230019 200540230075 8 PMED
31 200540230019 200540230126 1 MVIS
32 200540230019 200540230164 8 PMED
33 200540230019 200540230171 8 PMED
34 200540230019 200540230188 8 PMED
35 200640100022 200640100030 1 MVIS
36 200640100022 200640100232 8 PMED
37 200640100022 200640100249 8 PMED
38 200640100141 200640100605 2 OPAT
39 200640100141 200640100612 2 OPAT
40 200640100022 200640100749 8 PMED
41 200640100141 200640100756 8 PMED
42 200640100022 200640100883 8 PMED
43 200640100022 200640100890 8 PMED
44 200760300018 200760300058 8 PMED
45 200760300018 200760300161 8 PMED
46 200860130041 200860130063 8 PMED
47 200860130041 200860130070 8 PMED
48 200860130041 200860130087 8 PMED
49 200860130041 200860130094 8 PMED
50 200860130041 200860130145 8 PMED
HC-067I 10:56 Thursday, October 28, 2004 5
Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 200210270069 8 PMED
2 200210270083 8 PMED
3 200260120056 1 MVIS
4 200260120190 8 PMED
5 200260120354 1 MVIS
6 200260120816 8 PMED
7 200260120847 8 PMED
8 200260120854 8 PMED
9 200300100019 1 MVIS
10 200300100026 8 PMED
11 200340280016 8 PMED
12 200340280030 8 PMED
13 200340280054 8 PMED
14 200340280061 8 PMED
15 200340280085 8 PMED
16 200340280092 1 MVIS
17 200340280143 8 PMED
18 200340280150 8 PMED
19 200390220363 8 PMED
20 200410170229 8 PMED
21 200410170236 8 PMED
22 200530380017 3 EROM
23 200530380024 3 EROM
24 200530380062 8 PMED
25 200530380106 8 PMED
26 200540230020 1 MVIS
27 200540230037 1 MVIS
28 200540230044 8 PMED
29 200540230051 8 PMED
30 200540230075 8 PMED
31 200540230126 1 MVIS
32 200540230164 8 PMED
33 200540230171 8 PMED
34 200540230188 8 PMED
35 200640100030 1 MVIS
36 200640100232 8 PMED
37 200640100249 8 PMED
38 200640100605 2 OPAT
39 200640100612 2 OPAT
40 200640100749 8 PMED
41 200640100756 8 PMED
42 200640100883 8 PMED
43 200640100890 8 PMED
44 200760300058 8 PMED
45 200760300161 8 PMED
46 200860130063 8 PMED
47 200860130070 8 PMED
48 200860130087 8 PMED
49 200860130094 8 PMED
50 200860130145 8 PMED
HC-067I 10:56 Thursday, October 28, 2004 6
Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-067G) events
Obs EVNTIDX EVENTYPE
1 200260120056 1 MVIS
2 200260120354 1 MVIS
3 200300100019 1 MVIS
4 200340280092 1 MVIS
5 200540230020 1 MVIS
6 200540230037 1 MVIS
7 200540230126 1 MVIS
8 200640100030 1 MVIS
9 201100200124 1 MVIS
10 201100200131 1 MVIS
11 201100200155 1 MVIS
12 201100440028 1 MVIS
13 201170550012 1 MVIS
14 201170550029 1 MVIS
15 201170550036 1 MVIS
16 201170550043 1 MVIS
17 201170550050 1 MVIS
18 201170550067 1 MVIS
19 201170550074 1 MVIS
20 201290280058 1 MVIS
21 201290280065 1 MVIS
22 201290280072 1 MVIS
23 201790120016 1 MVIS
24 201790290016 1 MVIS
25 201790290023 1 MVIS
26 201790290030 1 MVIS
27 201790290047 1 MVIS
28 201790290054 1 MVIS
29 201790290061 1 MVIS
30 201790290078 1 MVIS
31 201790290249 1 MVIS
32 201790360030 1 MVIS
33 201790360047 1 MVIS
34 201790360054 1 MVIS
35 201790360061 1 MVIS
36 201790360078 1 MVIS
37 201790360112 1 MVIS
38 201860330072 1 MVIS
39 201860330130 1 MVIS
40 201860330147 1 MVIS
41 201860330154 1 MVIS
42 201980300011 1 MVIS
43 202030180032 1 MVIS
44 202030180056 1 MVIS
45 202170150088 1 MVIS
46 202620130237 1 MVIS
47 202680360044 1 MVIS
48 202740110017 1 MVIS
49 202740110024 1 MVIS
50 202740110031 1 MVIS
HC-067I 10:56 Thursday, October 28, 2004 7
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-67IF2)
EVNTIDX LINKIDX EVENTYPE
200020380013 200020380020 1 MVIS
200020380037 1 MVIS
200030260041 200030260123 1 MVIS
200030260178 200030260250 1 MVIS
200040180012 200040180067 1 MVIS
200040180081 200040180187 4 STAZ
200040180101 200040180207 1 MVIS
200040180163 200040180187 1 MVIS
200040180221 200040180276 1 MVIS
200040180245 200040180283 1 MVIS
200070160018 200070160049 1 MVIS
200070160056 1 MVIS
200070160032 200070160049 1 MVIS
200120180060 200120180084 1 MVIS
200120180091 1 MVIS
200120180104 1 MVIS
200120180111 1 MVIS
200120180077 200120180128 1 MVIS
200120250022 200120250060 1 MVIS
200120250046 200120250077 3 EROM
200120250128 200120250313 1 MVIS
200120250320 1 MVIS
200120250337 1 MVIS
200120250344 1 MVIS
200120250351 1 MVIS
200120250368 1 MVIS
200140170015 200140170022 1 MVIS
200140170039 1 MVIS
200140240046 200140240382 1 MVIS
200140240180 200140240399 1 MVIS
HC-067I 10:56 Thursday, October 28, 2004 8
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-67IF2)
EVNTIDX LINKIDX EVENTYPE
200140240426 200140240433 1 MVIS
200150190012 200150190029 1 MVIS
200150190036 1 MVIS
200150190043 1 MVIS
200150190050 1 MVIS
200160650045 200160650076 1 MVIS
200160650083 200160650103 1 MVIS
200160650110 1 MVIS
200160730068 200160730082 1 MVIS
200160730075 200160730099 1 MVIS
200170120015 200170120046 1 MVIS
200170120053 1 MVIS
200170120135 200170120142 1 MVIS
200170120159 1 MVIS
200190140041 200190140072 1 MVIS
200190140058 200190140089 1 MVIS
200190140096 1 MVIS
200200160021 200200160069 1 MVIS
200200230052 200200230076 5 DVIS
200200230090 200200230127 1 MVIS
200200230134 1 MVIS
200210100045 200210100134 1 MVIS
200210270038 200210270069 1 MVIS
200210270076 1 MVIS
200210270083 1 MVIS
200210270090 1 MVIS
200210340038 200210340076 1 MVIS
200210340069 200210340083 1 MVIS
200220150026 200220150040 1 MVIS
200220460019 200220460033 1 MVIS
HC-067I 10:56 Thursday, October 28, 2004 9
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-67IF2)
EVNTIDX LINKIDX EVENTYPE
200230100018 200230100032 1 MVIS
200230100025 200230100049 1 MVIS
200260120405 200260120412 1 MVIS
200260120429 1 MVIS
200260120676 200260120683 3 EROM
200260120690 3 EROM
200260290121 200260290258 1 MVIS
200260290190 200260290265 2 OPAT
200290180018 200290180049 1 MVIS
200300100019 200300100026 1 MVIS
200320100010 200320100065 1 MVIS
200320100072 1 MVIS
200320100089 1 MVIS
200320100096 1 MVIS
200320100034 200320100109 1 MVIS
200320100123 200320100130 1 MVIS
200320100147 1 MVIS
200320100154 1 MVIS
200320100185 200320100243 4 STAZ
200320100250 4 STAZ
200320100267 4 STAZ
200320100274 4 STAZ
200320100281 4 STAZ
200320100298 4 STAZ
200330150050 200330150081 3 EROM
200330150067 200330150098 1 MVIS
200340110054 200340110061 2 OPAT
200360130010 200360130058 5 DVIS
200360130109 200360130130 1 MVIS
200360200027 200360200065 1 MVIS
200360200072 200360200154 1 MVIS
HC-067I 10:56 Thursday, October 28, 2004 10
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-67IF2)
EVNTIDX LINKIDX EVENTYPE
200390150010 200390150027 1 MVIS
200390150034 200390150041 1 MVIS
200390220010 200390220116 1 MVIS
200390220123 1 MVIS
200390220130 1 MVIS
200390220147 1 MVIS
200390220072 200390220154 1 MVIS
200390220089 200390220154 1 MVIS
200390220192 200390220229 1 MVIS
200390220205 200390220236 5 DVIS
200390220243 5 DVIS
200390220281 200390220332 5 DVIS
200410170154 200410170185 1 MVIS
200440170026 200440170033 1 MVIS
200450150104 200450150142 1 MVIS
200450150128 200450150166 1 MVIS
200460230018 200460230025 1 MVIS
200460470018 200460470025 1 MVIS
200480150018 200480150025 1 MVIS
200480150032 200480150049 1 MVIS
200510130051 200510130068 1 MVIS
200510130075 1 MVIS
200510130082 1 MVIS
200510130099 1 MVIS
200510130119 200510130133 1 MVIS
200520140018 200520140025 1 MVIS
200520140032 200520140049 1 MVIS
200520140056 1 MVIS
200530380017 200530380048 3 EROM
HC-067I 10:56 Thursday, October 28, 2004 11
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-67IF2)
EVNTIDX LINKIDX EVENTYPE
200530380017 200530380055 3 EROM
200530380062 3 EROM
200530380079 3 EROM
200530380024 200530380062 3 EROM
200530380093 200530380106 3 EROM
200540110049 200540110056 1 MVIS
200540110070 200540110114 1 MVIS
200540110121 1 MVIS
200540110138 1 MVIS
200540110145 1 MVIS
200540110152 1 MVIS
200540160013 200540160051 1 MVIS
200540160171 200540160208 1 MVIS
200540160215 1 MVIS
200540160188 200540160222 1 MVIS
200540160253 200540160284 2 OPAT
200540160291 2 OPAT
200540230020 200540230044 1 MVIS
200540230051 1 MVIS
200540230037 200540230068 1 MVIS
HC-067I 10:56 Thursday, October 28, 2004 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
200300100019 200300100026 1 MVIS
200540230020 200540230044 1 MVIS
200540230051 1 MVIS
200540230037 200540230068 1 MVIS
200540230075 1 MVIS
200540230126 200540230164 1 MVIS
200540230171 1 MVIS
200540230188 1 MVIS
200640100030 200640100136 1 MVIS
200640100150 1 MVIS
201100200124 201100200162 1 MVIS
201100200179 1 MVIS
201100440028 201100440080 1 MVIS
201100440097 1 MVIS
201100440100 1 MVIS
201170550012 201170550098 1 MVIS
201290280058 201290280089 1 MVIS
201790120016 201790120023 1 MVIS
201790120030 1 MVIS
201790120047 1 MVIS
201790290016 201790290150 1 MVIS
201790290167 1 MVIS
201790290174 1 MVIS
201790290181 1 MVIS
201790290198 1 MVIS
201790290201 1 MVIS
201790290218 1 MVIS
201790290225 1 MVIS
201790290249 201790290256 1 MVIS
201790290263 1 MVIS
201790290270 1 MVIS
201790290287 1 MVIS
201790290294 1 MVIS
201790290307 1 MVIS
201790290314 1 MVIS
201790290321 1 MVIS
201790290338 1 MVIS
HC-067I 10:56 Thursday, October 28, 2004 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
201790360112 201790360129 1 MVIS
201790360136 1 MVIS
201790360143 1 MVIS
201860330072 201860330109 1 MVIS
201860330130 201860330205 1 MVIS
201860330212 1 MVIS
201980300011 201980300042 1 MVIS
201980300059 1 MVIS
202170150088 202170150122 1 MVIS
202170150146 1 MVIS
202170150160 1 MVIS
202170150177 1 MVIS
202620130237 202620130408 1 MVIS
HC-067I 10:56 Thursday, October 28, 2004 14
Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx
Obs EVNTIDX LINKIDX EVENTYPE
1 200300100019 200300100026 1 MVIS
2 200540230020 200540230044 1 MVIS
3 200540230020 200540230051 1 MVIS
4 200540230037 200540230068 1 MVIS
5 200540230037 200540230075 1 MVIS
6 200540230126 200540230164 1 MVIS
7 200540230126 200540230171 1 MVIS
8 200540230126 200540230188 1 MVIS
9 200640100030 200640100136 1 MVIS
10 200640100030 200640100150 1 MVIS
11 201100200124 201100200162 1 MVIS
12 201100200124 201100200179 1 MVIS
13 201100440028 201100440080 1 MVIS
14 201100440028 201100440097 1 MVIS
15 201100440028 201100440100 1 MVIS
16 201170550012 201170550098 1 MVIS
17 201290280058 201290280089 1 MVIS
18 201790120016 201790120023 1 MVIS
19 201790120016 201790120030 1 MVIS
20 201790120016 201790120047 1 MVIS
21 201790290016 201790290150 1 MVIS
22 201790290016 201790290167 1 MVIS
23 201790290016 201790290174 1 MVIS
24 201790290016 201790290181 1 MVIS
25 201790290016 201790290198 1 MVIS
26 201790290016 201790290201 1 MVIS
27 201790290016 201790290218 1 MVIS
28 201790290016 201790290225 1 MVIS
29 201790290249 201790290256 1 MVIS
30 201790290249 201790290263 1 MVIS
31 201790290249 201790290270 1 MVIS
32 201790290249 201790290287 1 MVIS
33 201790290249 201790290294 1 MVIS
34 201790290249 201790290307 1 MVIS
35 201790290249 201790290314 1 MVIS
36 201790290249 201790290321 1 MVIS
37 201790290249 201790290338 1 MVIS
38 201790360112 201790360129 1 MVIS
39 201790360112 201790360136 1 MVIS
40 201790360112 201790360143 1 MVIS
41 201860330072 201860330109 1 MVIS
42 201860330130 201860330205 1 MVIS
43 201860330130 201860330212 1 MVIS
44 201980300011 201980300042 1 MVIS
45 201980300011 201980300059 1 MVIS
46 202170150088 202170150122 1 MVIS
47 202170150088 202170150146 1 MVIS
48 202170150088 202170150160 1 MVIS
49 202170150088 202170150177 1 MVIS
50 202620130237 202620130408 1 MVIS
HC-067I 10:56 Thursday, October 28, 2004 15
Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids
Obs LINKIDX
1 200300100026
2 200540230044
3 200540230051
4 200540230068
5 200540230075
6 200540230164
7 200540230171
8 200540230188
9 200640100136
10 200640100150
11 201100200162
12 201100200179
13 201100440080
14 201100440097
15 201100440100
16 201170550098
17 201290280089
18 201790120023
19 201790120030
20 201790120047
21 201790290150
22 201790290167
23 201790290174
24 201790290181
25 201790290198
26 201790290201
27 201790290218
28 201790290225
29 201790290256
30 201790290263
31 201790290270
32 201790290287
33 201790290294
34 201790290307
35 201790290314
36 201790290321
37 201790290338
38 201790360129
39 201790360136
40 201790360143
41 201860330109
42 201860330205
43 201860330212
44 201980300042
45 201980300059
46 202170150122
47 202170150146
48 202170150160
49 202170150177
50 202620130408
HC-067I 10:56 Thursday, October 28, 2004 16
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
200300100026 200300100026001 BRONCHO SALINE 25.32 6875.179859
200540230044 200540230044001 ALBUTEROL SULFATE 16.50 6982.585232
200540230051 200540230051001 NEBULIZER 155.50 6982.585232
200540230068 200540230068001 AMOXIL (BUBBLE GUM) 9.80 6982.585232
200540230075 200540230075001 PRELONE (CHERRY) 24.01 6982.585232
200540230164 200540230164001 FLOVENT 44.66 6982.585232
200540230171 200540230171001 ALBUTEROL 22.96 6982.585232
200540230188 200540230188001 ORAPRED 23.27 6982.585232
200640100136 200640100136001 CIPRO (W/DILUENT) 81.41 11866.144818
200640100150 200640100150001 SERZONE 93.04 11866.144818
200640100150002 SERZONE 93.04 11866.144818
200640100150003 SERZONE 93.04 11866.144818
201100200162 201100200162001 ALBUTEROL INHALER 19.79 15775.475999
201100200179 201100200179001 ADVAIR 161.29 15775.475999
201100440080 201100440080001 ALBUTEROL 21.28 17098.352782
201100440097 201100440097001 PRELONE 7.41 17098.352782
201100440100 201100440100001 CROMOLYN NEBULIZER 75.75 17098.352782
201170550098 201170550098001 ALBUTEROL INHALER 19.79 9275.716784
201290280089 201290280089001 BRONCHO SALINE 9.90 8416.575038
201290280089002 BRONCHO SALINE 9.90 8416.575038
201290280089003 BRONCHO SALINE 9.90 8416.575038
201790120023 201790120023001 ALBUTEROL 24.99 1623.934114
201790120023002 ALBUTEROL 24.99 1623.934114
201790120030 201790120030001 NAPROXEN NF 16.68 1623.934114
201790120047 201790120047001 AMPICILLIN 9.99 1623.934114
201790290150 201790290150001 ALBUTEROL 26.99 2381.510797
201790290150002 ALBUTEROL 26.99 2381.510797
201790290150003 ALBUTEROL 26.99 2381.510797
201790290150004 ALBUTEROL 26.99 2381.510797
HC-067I 10:56 Thursday, October 28, 2004 17
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
201790290150 201790290150005 ALBUTEROL 26.99 2381.510797
201790290167 201790290167001 ULTRAM 50.87 2381.510797
201790290167002 ULTRAM 50.87 2381.510797
201790290167003 ULTRAM 50.87 2381.510797
201790290167004 ULTRAM 50.87 2381.510797
201790290167005 ULTRAM 50.87 2381.510797
201790290174 201790290174001 ALTACE 133.84 2381.510797
201790290174002 ALTACE 133.84 2381.510797
201790290174003 ALTACE 133.84 2381.510797
201790290174004 ALTACE 133.84 2381.510797
201790290174005 ALTACE 133.84 2381.510797
201790290181 201790290181001 SINGULAIR 81.44 2381.510797
201790290181002 SINGULAIR 81.44 2381.510797
201790290181003 SINGULAIR 81.44 2381.510797
201790290181004 SINGULAIR 81.44 2381.510797
201790290181005 SINGULAIR 81.44 2381.510797
201790290198 201790290198001 GUAIFENEX DM 16.68 2381.510797
201790290198002 GUAIFENEX DM 16.68 2381.510797
201790290198003 GUAIFENEX DM 16.68 2381.510797
201790290201 201790290201001 NEURONTIN 110.00 2381.510797
201790290201002 NEURONTIN 110.00 2381.510797
201790290218 201790290218001 AMITRIPTYLINE HCL 6.78 2381.510797
201790290218002 AMITRIPTYLINE HCL 6.78 2381.510797
201790290218003 AMITRIPTYLINE HCL 6.78 2381.510797
201790290218004 AMITRIPTYLINE HCL 6.78 2381.510797
201790290218005 AMITRIPTYLINE HCL 6.78 2381.510797
201790290225 201790290225001 ANEMAGEN (10X10) 14.89 2381.510797
201790290225002 ANEMAGEN (10X10) 39.69 2381.510797
201790290225003 ANEMAGEN (10X10) 39.69 2381.510797
201790290225004 ANEMAGEN (10X10) 14.89 2381.510797
201790290225005 ANEMAGEN (10X10) 39.69 2381.510797
201790290256 201790290256001 ALBUTEROL 26.99 2381.510797
201790290256002 ALBUTEROL 26.99 2381.510797
201790290256003 ALBUTEROL 26.99 2381.510797
201790290256004 ALBUTEROL 26.99 2381.510797
201790290256005 ALBUTEROL 26.99 2381.510797
201790290256006 ALBUTEROL 26.99 2381.510797
201790290256007 ALBUTEROL 26.99 2381.510797
201790290256008 ALBUTEROL 26.99 2381.510797
201790290256009 ALBUTEROL 26.99 2381.510797
201790290256010 ALBUTEROL 26.99 2381.510797
HC-067I 10:56 Thursday, October 28, 2004 18
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
201790290263 201790290263001 ULTRAM 46.75 2381.510797
201790290270 201790290270001 ALTACE 133.84 2381.510797
201790290270002 ALTACE 133.84 2381.510797
201790290270003 ALTACE 133.84 2381.510797
201790290270004 ALTACE 133.84 2381.510797
201790290270005 ALTACE 133.84 2381.510797
201790290287 201790290287001 SINGULAIR 81.44 2381.510797
201790290287002 SINGULAIR 81.44 2381.510797
201790290287003 SINGULAIR 81.44 2381.510797
201790290287004 SINGULAIR 81.44 2381.510797
201790290287005 SINGULAIR 81.44 2381.510797
201790290287006 SINGULAIR 81.44 2381.510797
201790290294 201790290294001 NEURONTIN 110.00 2381.510797
201790290294002 NEURONTIN 110.00 2381.510797
201790290294003 NEURONTIN 110.00 2381.510797
201790290294004 NEURONTIN 110.00 2381.510797
201790290294005 NEURONTIN 110.00 2381.510797
201790290294006 NEURONTIN 110.00 2381.510797
201790290307 201790290307001 AMITRIPTYLINE HCL 6.78 2381.510797
201790290307002 AMITRIPTYLINE HCL 6.78 2381.510797
201790290307003 AMITRIPTYLINE HCL 6.78 2381.510797
201790290307004 AMITRIPTYLINE HCL 6.78 2381.510797
201790290307005 AMITRIPTYLINE HCL 6.78 2381.510797
201790290314 201790290314001 FLUNISOLIDE 75.39 2381.510797
201790290314002 FLUNISOLIDE 75.39 2381.510797
201790290314003 FLUNISOLIDE 75.39 2381.510797
201790290314004 FLUNISOLIDE 75.39 2381.510797
201790290314005 FLUNISOLIDE 75.39 2381.510797
201790290321 201790290321001 HYDROCODONE/APAP 7.17 2381.510797
201790290321002 HYDROCODONE/APAP 7.17 2381.510797
201790290321003 HYDROCODONE/APAP 7.17 2381.510797
201790290321004 HYDROCODONE/APAP 7.17 2381.510797
201790290321005 HYDROCODONE/APAP 7.17 2381.510797
201790290338 201790290338001 IBUPROFEN 800MG TABLETS 22.67 2381.510797
201790290338002 IBUPROFEN 800MG TABLETS 22.67 2381.510797
201790290338003 IBUPROFEN 800MG TABLETS 22.67 2381.510797
201790290338004 IBUPROFEN 800MG TABLETS 22.67 2381.510797
201790290338005 IBUPROFEN 800MG TABLETS 22.67 2381.510797
201790360129 201790360129001 ALBUTEROL 19.84 3060.514064
201790360129002 ALBUTEROL 19.84 3060.514064
201790360129003 ALBUTEROL 19.84 3060.514064
HC-067I 10:56 Thursday, October 28, 2004 19
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
201790360129 201790360129004 ALBUTEROL 19.84 3060.514064
201790360129005 ALBUTEROL 19.84 3060.514064
201790360129006 ALBUTEROL 19.84 3060.514064
201790360129007 ALBUTEROL 19.84 3060.514064
201790360129008 ALBUTEROL 19.84 3060.514064
201790360129009 ALBUTEROL 19.84 3060.514064
201790360129010 ALBUTEROL 19.84 3060.514064
201790360136 201790360136001 SINGULAR 76.74 3060.514064
201790360136002 SINGULAR 76.74 3060.514064
201790360136003 SINGULAR 76.74 3060.514064
201790360136004 SINGULAR 76.74 3060.514064
201790360136005 SINGULAR 76.74 3060.514064
201790360143 201790360143001 DESOXIMETASONE 71.15 3060.514064
201790360143002 DESOXIMETASONE 71.15 3060.514064
201790360143003 DESOXIMETASONE 71.15 3060.514064
201790360143004 DESOXIMETASONE 71.15 3060.514064
201790360143005 DESOXIMETASONE 71.15 3060.514064
201860330109 201860330109001 ADDERALL 71.43 2561.461929
201860330109002 ADDERALL 71.43 2561.461929
201860330205 201860330205001 CONCERTA 73.13 2561.461929
201860330205002 CONCERTA 73.13 2561.461929
201860330205003 CONCERTA 73.13 2561.461929
201860330212 201860330212001 ALBUTEROL 59.70 2561.461929
201860330212002 ALBUTEROL 59.70 2561.461929
201980300042 201980300042001 NEOMYCIN/POLY/GRAM 5.98 12875.700659
201980300059 201980300059001 TRIAMCINOLONE ORAL INHALER 45.83 12875.700659
201980300059002 TRIAMCINOLONE ORAL INHALER 45.83 12875.700659
202170150122 202170150122001 ALBUTEROL 18.78 9578.335265
202170150122002 ALBUTEROL 18.78 9578.335265
202170150122003 ALBUTEROL 18.78 9578.335265
202170150122004 ALBUTEROL 18.78 9578.335265
202170150122005 ALBUTEROL 18.78 9578.335265
202170150122006 ALBUTEROL 18.78 9578.335265
202170150122007 ALBUTEROL 18.78 9578.335265
202170150146 202170150146001 TYLENOL W/CODEINE #3 6.19 9578.335265
202170150160 202170150160001 FLOVENT 210.64 9578.335265
202170150160002 FLOVENT 210.64 9578.335265
202170150160003 FLOVENT 210.64 9578.335265
202170150160004 FLOVENT 210.64 9578.335265
HC-067I 10:56 Thursday, October 28, 2004 20
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
202170150160 202170150160005 FLOVENT 210.64 9578.335265
202170150160006 FLOVENT 210.64 9578.335265
202170150160007 FLOVENT 210.64 9578.335265
202170150177 202170150177001 VIOXX 13.58 9578.335265
202170150177002 VIOXX 13.58 9578.335265
202170150177003 VIOXX 13.58 9578.335265
202170150177004 VIOXX 13.58 9578.335265
202170150177005 VIOXX 13.58 9578.335265
202170150177006 VIOXX 13.58 9578.335265
202620130408 202620130408001 NORVASC 65.23 8845.099617
202620130408002 NORVASC 65.23 8845.099617
202620130408003 NORVASC 65.23 8845.099617
202620130415 202620130415001 SEREVENT 167.66 8845.099617
202620130422 202620130422001 VANCERIL 99.82 8845.099617
202620130439 202620130439001 COMBIVENT 102.76 8845.099617
202620130446 202620130446001 ZOCOR (UNIT OF USE) 132.26 8845.099617
202680360075 202680360075001 BRONCHO SALINE 25.32 1722.753723
202680360075002 BRONCHO SALINE 25.32 1722.753723
202680360075003 BRONCHO SALINE 25.32 1722.753723
202680360075004 BRONCHO SALINE 25.32 1722.753723
202680360075005 BRONCHO SALINE 25.32 1722.753723
202680360082 202680360082001 PREDNISONE 3.34 1722.753723
202680360099 202680360099001 ZYRTEC 65.15 1722.753723
202680360102 202680360102001 ALBUTEROL 26.49 1722.753723
202740110106 202740110106001 DURAGESIC 414.23 3865.747467
202740110113 202740110113001 HYDROMET 10.13 3865.747467
202740110120 202740110120001 BONTRIL PDM 13.55 3865.747467
202740110120002 BONTRIL PDM 13.55 3865.747467
202740110137 202740110137001 ZOLOFT 68.55 3865.747467
202740110144 202740110144001 NITROSTAT 9.25 3865.747467
202740110151 202740110151001 FLONASE 58.44 3865.747467
202740110168 202740110168001 AZMACORT 66.23 3865.747467
HC-067I 10:56 Thursday, October 28, 2004 21
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
202740110175 202740110175001 ALBUTEROL 22.94 3865.747467
202740110182 202740110182001 ALBUTEROL 19.12 3865.747467
202740110199 202740110199001 CIMETIDINE 9.80 3865.747467
202740110202 202740110202001 SPIRONOLACT 17.43 3865.747467
202740110219 202740110219001 ZAROXOLYN 29.99 3865.747467
202740110226 202740110226001 CARISOPRO 8.59 3865.747467
202740110233 202740110233001 CAPOTEN 112.33 3865.747467
202740110240 202740110240001 TOPROL XL 60.73 3865.747467
202740110257 202740110257001 BISACODYL 7.05 3865.747467
202740110264 202740110264001 PSYLLIUM FREEDA 13.99 3865.747467
202740110353 202740110353001 TOPAMAX (SPRINKLE) 157.25 3865.747467
202740110579 202740110579001 DURAGESIC 446.63 3865.747467
202740110579002 DURAGESIC 446.63 3865.747467
202740110579003 DURAGESIC 446.63 3865.747467
202740110579004 DURAGESIC 446.63 3865.747467
202740110579005 DURAGESIC 446.63 3865.747467
202740110586 202740110586001 HYDROMET 10.13 3865.747467
202740110586002 HYDROMET 10.13 3865.747467
HC-067I 10:56 Thursday, October 28, 2004 22
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
The MEANS Procedure
Analysis Variable : RXXP02X SUM OF PAYMENTS RXSF02X-RXOU02X(IMPUTED)
N Sum
--------------------
6328 364959.66
--------------------
HC-067I 10:56 Thursday, October 28, 2004 23
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP02X SUM OF PAYMENTS RXSF02X-RXOU02X(IMPUTED)
N Sum
--------------------
6328 2587126925
--------------------
1 The SAS System 11:08 Thursday, October 28, 2004
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 82BX08.
NOTE: SAS initialization used:
real time 4.18 seconds
cpu time 0.38 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-067I";
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.15 seconds
cpu time 0.00 seconds
22
23 *--------------------------------------------------------------------------------------
24 * Get condition records coded as asthma.
25 *--------------------------------------------------------------------------------------;
2 The SAS System 11:08 Thursday, October 28, 2004
26 DATA ASCONDS;
27 SET IN.H69 (KEEP=CONDIDX CCCODEX);
28 IF CCCODEX="128";
29 RUN;
NOTE: There were 120795 observations read from the data set IN.H69.
NOTE: The data set WORK.ASCONDS has 2159 observations and 2 variables.
NOTE: DATA statement used:
real time 1.87 seconds
cpu time 0.21 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 2159 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 2159 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.07 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 (H69) 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.26 seconds
cpu time 0.01 seconds
40
41 PROC SORT DATA=IN.H67IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 388065 observations read from the data set IN.H67IF1.
NOTE: The data set WORK.CLNK has 388065 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 21.18 seconds
cpu time 2.56 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 11:08 Thursday, October 28, 2004
NOTE: There were 388065 observations read from the data set WORK.CLNK.
NOTE: There were 2159 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 8833 observations and 3 variables.
NOTE: DATA statement used:
real time 0.68 seconds
cpu time 0.40 seconds
49
50 proc print data=asclnks (obs=75);
51 by condidx;
52 id condidx;
53 format eventype eventype.;
54 title3 "sample print of work.asclnks - sorted by condidx";
55 title4 "events linked to asthma condition records";
56 run;
NOTE: There were 75 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used:
real time 0.09 seconds
cpu time 0.01 seconds
57
58 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 8833 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 8833 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.03 seconds
cpu time 0.00 seconds
64
65 DATA ASCLNKS;
66 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
67 BY EVNTIDX;
68 IF FIRST.EVNTIDX;
69 RUN;
NOTE: There were 8833 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 8830 observations and 2 variables.
NOTE: DATA statement used:
4 The SAS System 11:08 Thursday, October 28, 2004
real time 0.04 seconds
cpu time 0.04 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.03 seconds
cpu time 0.01 seconds
75
76 *-------------------------------------------------------------------------------
77 * Get PMED records linked to asthma condition records.
78 *-------------------------------------------------------------------------------;
79 PROC SORT DATA=IN.H67A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 339308 observations read from the data set IN.H67A.
NOTE: The data set WORK.PMED has 339308 observations and 70 variables.
NOTE: PROCEDURE SORT used:
real time 4:44.39
cpu time 32.81 seconds
80
81 DATA ASPMEDS;
82 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F)
83 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX RENAME=(EVNTIDX=LINKIDX));
84 BY LINKIDX;
85 IF INASCLNK & PERWT02F>0;
86 RUN;
NOTE: There were 339308 observations read from the data set WORK.PMED.
NOTE: There were 8830 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 12112 observations and 5 variables.
NOTE: DATA statement used:
real time 7.42 seconds
cpu time 1.15 seconds
87
88 proc print data=aspmeds (obs=300);
89 by linkidx;
90 id linkidx;
91 var rxrecidx rxname RXXP02X PERWT02F;
92 title3 "sample print of work.aspmeds";
93 title4 "PMED (HC-067A) records which link to condition records coded as asthma";
94 run;
NOTE: There were 300 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE PRINT printed pages 6-15.
5 The SAS System 11:08 Thursday, October 28, 2004
NOTE: PROCEDURE PRINT used:
real time 0.17 seconds
cpu time 0.00 seconds
95
96 PROC MEANS DATA=ASPMEDS N SUM;
97 VAR RXXP02X;
98 TITLE3 "Total Rx expenditures associated with asthma";
99 RUN;
NOTE: There were 12112 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 16.
NOTE: PROCEDURE MEANS used:
real time 0.21 seconds
cpu time 0.03 seconds
100
101 PROC MEANS DATA=ASPMEDS N SUM;
102 VAR RXXP02X;
103 WEIGHT PERWT02F;
104 TITLE3 "Total Rx expenditures associated with asthma";
105 TITLE5 "Weighted";
106 RUN;
NOTE: There were 12112 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 17.
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 5:21.96
cpu time 37.84 seconds
HC-067I 11:08 Thursday, October 28, 2004 1
Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H69) records where cccodex=128
Obs CONDIDX CCCODEX
1 200210270023 128
2 200260120036 128
3 200300100028 128
4 200340280018 128
5 200390220116 128
6 200410170097 128
7 200530380017 128
8 200540230019 128
9 200640100022 128
10 200640100141 128
11 200760300018 128
12 200860130041 128
13 200880360010 128
14 201090290010 128
15 201100200048 128
16 201100440018 128
17 201150170015 128
18 201170490019 128
19 201170550019 128
20 201290280019 128
21 201550320028 128
22 201790120016 128
23 201790290043 128
24 201790360014 128
25 201790590029 128
26 201840320043 128
27 201860330010 128
28 201860330032 128
29 201930150013 128
30 201980300032 128
31 202000130025 128
32 202030180047 128
33 202170150026 128
34 202170290028 128
35 202240300029 128
36 202350170021 128
37 202620130056 128
38 202650560036 128
39 202680360017 128
40 202680360051 128
41 202680430038 128
42 202680590038 128
43 202740110040 128
44 202900140013 128
45 202990190017 128
46 203080160025 128
47 203600120037 128
48 203600290042 128
49 203650120019 128
50 203740440015 128
HC-067I 11:08 Thursday, October 28, 2004 2
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200210270023 200210270069 8 PMED
200210270083 8 PMED
200260120036 200260120056 1 MVIS
200260120190 8 PMED
200260120354 1 MVIS
200260120816 8 PMED
200260120847 8 PMED
200260120854 8 PMED
200300100028 200300100019 1 MVIS
200300100026 8 PMED
200340280018 200340280016 8 PMED
200340280030 8 PMED
200340280054 8 PMED
200340280061 8 PMED
200340280085 8 PMED
200340280092 1 MVIS
200340280143 8 PMED
200340280150 8 PMED
200390220116 200390220363 8 PMED
200410170097 200410170229 8 PMED
200410170236 8 PMED
200530380017 200530380017 3 EROM
200530380024 3 EROM
200530380062 8 PMED
200530380106 8 PMED
200540230019 200540230020 1 MVIS
200540230037 1 MVIS
200540230044 8 PMED
200540230051 8 PMED
200540230075 8 PMED
200540230126 1 MVIS
200540230164 8 PMED
200540230171 8 PMED
200540230188 8 PMED
200640100022 200640100030 1 MVIS
200640100232 8 PMED
200640100249 8 PMED
200640100749 8 PMED
200640100883 8 PMED
200640100890 8 PMED
HC-067I 11:08 Thursday, October 28, 2004 3
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200640100141 200640100605 2 OPAT
200640100612 2 OPAT
200640100756 8 PMED
200760300018 200760300058 8 PMED
200760300161 8 PMED
200860130041 200860130063 8 PMED
200860130070 8 PMED
200860130087 8 PMED
200860130094 8 PMED
200860130145 8 PMED
200860130234 8 PMED
200880360010 200880360038 8 PMED
200880360103 8 PMED
201090290010 201090290019 8 PMED
201090290026 8 PMED
201090290040 8 PMED
201100200048 201100200124 1 MVIS
201100200131 1 MVIS
201100200155 1 MVIS
201100200162 8 PMED
201100200179 8 PMED
201100440018 201100440028 1 MVIS
201100440080 8 PMED
201100440097 8 PMED
201100440100 8 PMED
201100440155 8 PMED
201150170015 201150170292 8 PMED
201150170381 8 PMED
201170490019 201170490059 8 PMED
201170490066 8 PMED
201170550019 201170550012 1 MVIS
201170550029 1 MVIS
201170550036 1 MVIS
201170550043 1 MVIS
201170550050 1 MVIS
HC-067I 11:08 Thursday, October 28, 2004 4
Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 200210270023 200210270069 8 PMED
2 200210270023 200210270083 8 PMED
3 200260120036 200260120056 1 MVIS
4 200260120036 200260120190 8 PMED
5 200260120036 200260120354 1 MVIS
6 200260120036 200260120816 8 PMED
7 200260120036 200260120847 8 PMED
8 200260120036 200260120854 8 PMED
9 200300100028 200300100019 1 MVIS
10 200300100028 200300100026 8 PMED
11 200340280018 200340280016 8 PMED
12 200340280018 200340280030 8 PMED
13 200340280018 200340280054 8 PMED
14 200340280018 200340280061 8 PMED
15 200340280018 200340280085 8 PMED
16 200340280018 200340280092 1 MVIS
17 200340280018 200340280143 8 PMED
18 200340280018 200340280150 8 PMED
19 200390220116 200390220363 8 PMED
20 200410170097 200410170229 8 PMED
21 200410170097 200410170236 8 PMED
22 200530380017 200530380017 3 EROM
23 200530380017 200530380024 3 EROM
24 200530380017 200530380062 8 PMED
25 200530380017 200530380106 8 PMED
26 200540230019 200540230020 1 MVIS
27 200540230019 200540230037 1 MVIS
28 200540230019 200540230044 8 PMED
29 200540230019 200540230051 8 PMED
30 200540230019 200540230075 8 PMED
31 200540230019 200540230126 1 MVIS
32 200540230019 200540230164 8 PMED
33 200540230019 200540230171 8 PMED
34 200540230019 200540230188 8 PMED
35 200640100022 200640100030 1 MVIS
36 200640100022 200640100232 8 PMED
37 200640100022 200640100249 8 PMED
38 200640100141 200640100605 2 OPAT
39 200640100141 200640100612 2 OPAT
40 200640100022 200640100749 8 PMED
41 200640100141 200640100756 8 PMED
42 200640100022 200640100883 8 PMED
43 200640100022 200640100890 8 PMED
44 200760300018 200760300058 8 PMED
45 200760300018 200760300161 8 PMED
46 200860130041 200860130063 8 PMED
47 200860130041 200860130070 8 PMED
48 200860130041 200860130087 8 PMED
49 200860130041 200860130094 8 PMED
50 200860130041 200860130145 8 PMED
HC-067I 11:08 Thursday, October 28, 2004 5
Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 200210270069 8 PMED
2 200210270083 8 PMED
3 200260120056 1 MVIS
4 200260120190 8 PMED
5 200260120354 1 MVIS
6 200260120816 8 PMED
7 200260120847 8 PMED
8 200260120854 8 PMED
9 200300100019 1 MVIS
10 200300100026 8 PMED
11 200340280016 8 PMED
12 200340280030 8 PMED
13 200340280054 8 PMED
14 200340280061 8 PMED
15 200340280085 8 PMED
16 200340280092 1 MVIS
17 200340280143 8 PMED
18 200340280150 8 PMED
19 200390220363 8 PMED
20 200410170229 8 PMED
21 200410170236 8 PMED
22 200530380017 3 EROM
23 200530380024 3 EROM
24 200530380062 8 PMED
25 200530380106 8 PMED
26 200540230020 1 MVIS
27 200540230037 1 MVIS
28 200540230044 8 PMED
29 200540230051 8 PMED
30 200540230075 8 PMED
31 200540230126 1 MVIS
32 200540230164 8 PMED
33 200540230171 8 PMED
34 200540230188 8 PMED
35 200640100030 1 MVIS
36 200640100232 8 PMED
37 200640100249 8 PMED
38 200640100605 2 OPAT
39 200640100612 2 OPAT
40 200640100749 8 PMED
41 200640100756 8 PMED
42 200640100883 8 PMED
43 200640100890 8 PMED
44 200760300058 8 PMED
45 200760300161 8 PMED
46 200860130063 8 PMED
47 200860130070 8 PMED
48 200860130087 8 PMED
49 200860130094 8 PMED
50 200860130145 8 PMED
HC-067I 11:08 Thursday, October 28, 2004 6
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-067A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
200210270069 200210270069001 DYPHYL-G 75.75 11440.484860
200210270083 200210270083001 ALBUTEROL 29.85 11440.484860
200260120190 200260120190001 SINGULAR 76.74 14422.861431
200260120816 200260120816001 SINGULAR 76.74 14422.861431
200260120847 200260120847001 ATROVENT 51.50 14422.861431
200260120854 200260120854001 ADVAIR 154.81 14422.861431
200300100026 200300100026001 BRONCHO SALINE 25.32 6875.179859
200340280016 200340280016001 ALBUTEROL 19.85 4001.735317
200340280016002 ALBUTEROL 19.85 4001.735317
200340280016003 ALBUTEROL 19.85 4001.735317
200340280030 200340280030001 SEREVENT 72.26 4001.735317
200340280054 200340280054001 AZMACORT 68.58 4001.735317
200340280061 200340280061001 ALBUTEROL 18.74 4001.735317
200340280061002 ALBUTEROL 18.10 4001.735317
200340280061003 ALBUTEROL 18.74 4001.735317
200340280085 200340280085001 NASONEX 59.50 4001.735317
200340280085002 NASONEX 57.61 4001.735317
200340280085003 NASONEX 57.61 4001.735317
200340280085004 NASONEX 55.97 4001.735317
200340280085005 NASONEX 57.61 4001.735317
200340280085006 NASONEX 55.97 4001.735317
200340280143 200340280143001 SEREVENT 72.26 4001.735317
200340280150 200340280150001 AZMACORT 68.58 4001.735317
200390220363 200390220363001 ADVAIR 161.29 8338.461457
200410170229 200410170229001 BECONASE AQ 58.56 3886.379063
200410170236 200410170236001 ALBUTEROL 29.79 3886.379063
200530380062 200530380062001 ALBUTEROL 12.29 3847.961236
200530380106 200530380106001 ALBUTEROL 11.68 3847.961236
200540230044 200540230044001 ALBUTEROL SULFATE 16.50 6982.585232
HC-067I 11:08 Thursday, October 28, 2004 7
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-067A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
200540230051 200540230051001 NEBULIZER 155.50 6982.585232
200540230075 200540230075001 PRELONE (CHERRY) 24.01 6982.585232
200540230164 200540230164001 FLOVENT 44.66 6982.585232
200540230171 200540230171001 ALBUTEROL 22.96 6982.585232
200540230188 200540230188001 ORAPRED 23.27 6982.585232
200640100232 200640100232001 SINGULAIR 15.00 11866.144818
200640100232002 SINGULAIR 15.00 11866.144818
200640100232003 SINGULAIR 15.00 11866.144818
200640100249 200640100249001 ALBUTEROL 29.79 11866.144818
200640100249002 ALBUTEROL 29.79 11866.144818
200640100249003 ALBUTEROL 29.79 11866.144818
200640100749 200640100749001 SINGULAIR 104.76 11866.144818
200640100749002 SINGULAIR 104.76 11866.144818
200640100749003 SINGULAIR 104.76 11866.144818
200640100749004 SINGULAIR 104.76 11866.144818
200640100749005 SINGULAIR 104.76 11866.144818
200640100756 200640100756001 ALBUTEROL 29.79 11866.144818
200640100756002 ALBUTEROL 29.79 11866.144818
200640100756003 ALBUTEROL 29.79 11866.144818
200640100756004 ALBUTEROL 29.79 11866.144818
200640100756005 ALBUTEROL 29.79 11866.144818
200640100883 200640100883001 ALBUTEROL 29.79 11866.144818
200640100883002 ALBUTEROL 29.79 11866.144818
200640100883003 ALBUTEROL 29.79 11866.144818
200640100890 200640100890001 CLARITIN 76.64 11866.144818
200640100890002 CLARITIN 76.64 11866.144818
200640100890003 CLARITIN 76.64 11866.144818
200760300058 200760300058001 ALBUTEROL 52.89 1580.929768
200760300058002 ALBUTEROL 52.89 1580.929768
200760300161 200760300161001 ALBUTEROL 52.89 1580.929768
200860130063 200860130063001 SINGULAIR (UNIT OF USE) 87.43 20904.059986
200860130063002 SINGULAIR (UNIT OF USE) 87.43 20904.059986
200860130063003 SINGULAIR (UNIT OF USE) 87.43 20904.059986
200860130070 200860130070001 SEREVENT 74.26 20904.059986
HC-067I 11:08 Thursday, October 28, 2004 8
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-067A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
200860130087 200860130087001 ALBUTEROL 21.41 20904.059986
200860130094 200860130094001 DYPHYL-G 75.75 20904.059986
200860130145 200860130145001 SINGULAIR (UNIT OF USE) 87.43 20904.059986
200860130145002 SINGULAIR (UNIT OF USE) 87.43 20904.059986
200860130145003 SINGULAIR (UNIT OF USE) 87.43 20904.059986
200860130145004 SINGULAIR (UNIT OF USE) 87.43 20904.059986
200860130234 200860130234001 DUONEB 49.56 20904.059986
200880360038 200880360038001 ALBUTEROL 29.79 22914.223159
200880360103 200880360103001 VENTOLIN 40.00 22914.223159
201090290019 201090290019001 SEREVENT 76.38 2229.654650
201090290026 201090290026001 SEREVENT 72.26 2229.654650
201090290026002 SEREVENT 72.26 2229.654650
201090290040 201090290040001 SEREVENT 72.26 2229.654650
201100200162 201100200162001 ALBUTEROL INHALER 19.79 15775.475999
201100200179 201100200179001 ADVAIR 161.29 15775.475999
201100440080 201100440080001 ALBUTEROL 21.28 17098.352782
201100440097 201100440097001 PRELONE 7.41 17098.352782
201100440100 201100440100001 CROMOLYN NEBULIZER 75.75 17098.352782
201100440155 201100440155001 ALBUTEROL 40.99 17098.352782
201150170292 201150170292001 ALBUTEROL/IPRATROP 7.00 7331.777668
201150170381 201150170381001 ALBUTEROL/IPRATROP 7.00 7331.777668
201170490059 201170490059001 VENTOLIN 40.00 7606.136908
201170490066 201170490066001 ALBUTEROL 22.96 7606.136908
201170550098 201170550098001 ALBUTEROL INHALER 19.79 9275.716784
201290280089 201290280089001 BRONCHO SALINE 9.90 8416.575038
201290280089002 BRONCHO SALINE 9.90 8416.575038
201290280089003 BRONCHO SALINE 9.90 8416.575038
201790120023 201790120023001 ALBUTEROL 24.99 1623.934114
HC-067I 11:08 Thursday, October 28, 2004 9
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-067A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
201790120023 201790120023002 ALBUTEROL 24.99 1623.934114
201790290150 201790290150001 ALBUTEROL 26.99 2381.510797
201790290150002 ALBUTEROL 26.99 2381.510797
201790290150003 ALBUTEROL 26.99 2381.510797
201790290150004 ALBUTEROL 26.99 2381.510797
201790290150005 ALBUTEROL 26.99 2381.510797
201790290181 201790290181001 SINGULAIR 81.44 2381.510797
201790290181002 SINGULAIR 81.44 2381.510797
201790290181003 SINGULAIR 81.44 2381.510797
201790290181004 SINGULAIR 81.44 2381.510797
201790290181005 SINGULAIR 81.44 2381.510797
201790290256 201790290256001 ALBUTEROL 26.99 2381.510797
201790290256002 ALBUTEROL 26.99 2381.510797
201790290256003 ALBUTEROL 26.99 2381.510797
201790290256004 ALBUTEROL 26.99 2381.510797
201790290256005 ALBUTEROL 26.99 2381.510797
201790290256006 ALBUTEROL 26.99 2381.510797
201790290256007 ALBUTEROL 26.99 2381.510797
201790290256008 ALBUTEROL 26.99 2381.510797
201790290256009 ALBUTEROL 26.99 2381.510797
201790290256010 ALBUTEROL 26.99 2381.510797
201790290287 201790290287001 SINGULAIR 81.44 2381.510797
201790290287002 SINGULAIR 81.44 2381.510797
201790290287003 SINGULAIR 81.44 2381.510797
201790290287004 SINGULAIR 81.44 2381.510797
201790290287005 SINGULAIR 81.44 2381.510797
201790290287006 SINGULAIR 81.44 2381.510797
201790290650 201790290650001 ALBUTEROL 26.99 2381.510797
201790290650002 ALBUTEROL 26.99 2381.510797
201790290650003 ALBUTEROL 26.99 2381.510797
201790290650004 ALBUTEROL 26.99 2381.510797
201790290674 201790290674001 SINGULAIR 81.44 2381.510797
201790360085 201790360085001 ALBUTEROL 19.84 3060.514064
201790360085002 ALBUTEROL 19.84 3060.514064
201790360092 201790360092001 SINGULAR 76.74 3060.514064
201790360092002 SINGULAR 76.74 3060.514064
201790360092003 SINGULAR 76.74 3060.514064
201790360129 201790360129001 ALBUTEROL 19.84 3060.514064
201790360129002 ALBUTEROL 19.84 3060.514064
201790360129003 ALBUTEROL 19.84 3060.514064
HC-067I 11:08 Thursday, October 28, 2004 10
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-067A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
201790360129 201790360129004 ALBUTEROL 19.84 3060.514064
201790360129005 ALBUTEROL 19.84 3060.514064
201790360129006 ALBUTEROL 19.84 3060.514064
201790360129007 ALBUTEROL 19.84 3060.514064
201790360129008 ALBUTEROL 19.84 3060.514064
201790360129009 ALBUTEROL 19.84 3060.514064
201790360129010 ALBUTEROL 19.84 3060.514064
201790360136 201790360136001 SINGULAR 76.74 3060.514064
201790360136002 SINGULAR 76.74 3060.514064
201790360136003 SINGULAR 76.74 3060.514064
201790360136004 SINGULAR 76.74 3060.514064
201790360136005 SINGULAR 76.74 3060.514064
201790360181 201790360181001 SINGULAR 76.74 3060.514064
201790360198 201790360198001 THEOPHYLLINE 16.07 3060.514064
201790360201 201790360201001 ALBUTEROL 19.84 3060.514064
201790360201002 ALBUTEROL 19.84 3060.514064
201840320209 201840320209001 ALBUTEROL 30.68 3651.586892
201860330065 201860330065001 ALBUTEROL 21.41 2561.461929
201860330116 201860330116001 PREDNISONE 8.99 2561.461929
201860330123 201860330123001 ALBUTEROL 29.85 2561.461929
201860330212 201860330212001 ALBUTEROL 59.70 2561.461929
201860330212002 ALBUTEROL 59.70 2561.461929
201980300042 201980300042001 NEOMYCIN/POLY/GRAM 5.98 12875.700659
201980300059 201980300059001 TRIAMCINOLONE ORAL INHALER 45.83 12875.700659
201980300059002 TRIAMCINOLONE ORAL INHALER 45.83 12875.700659
202030180094 202030180094001 PROVENTIL 38.86 3012.542202
202030180094002 PROVENTIL 38.86 3012.542202
202030180107 202030180107001 ADVAIR 154.81 3012.542202
202030180107002 ADVAIR 154.81 3012.542202
202170150122 202170150122001 ALBUTEROL 18.78 9578.335265
202170150122002 ALBUTEROL 18.78 9578.335265
202170150122003 ALBUTEROL 18.78 9578.335265
202170150122004 ALBUTEROL 18.78 9578.335265
202170150122005 ALBUTEROL 18.78 9578.335265
202170150122006 ALBUTEROL 18.78 9578.335265
HC-067I 11:08 Thursday, October 28, 2004 11
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-067A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
202170150122 202170150122007 ALBUTEROL 18.78 9578.335265
202170150160 202170150160001 FLOVENT 210.64 9578.335265
202170150160002 FLOVENT 210.64 9578.335265
202170150160003 FLOVENT 210.64 9578.335265
202170150160004 FLOVENT 210.64 9578.335265
202170150160005 FLOVENT 210.64 9578.335265
202170150160006 FLOVENT 210.64 9578.335265
202170150160007 FLOVENT 210.64 9578.335265
202170150526 202170150526001 ALBUTEROL 18.78 9578.335265
202170150526002 ALBUTEROL 18.78 9578.335265
202170150533 202170150533001 FLOVENT 210.64 9578.335265
202170150533002 FLOVENT 210.64 9578.335265
202170290170 202170290170001 ALBUTEROL 29.79 19354.593195
202170290170002 ALBUTEROL 29.79 19354.593195
202240300103 202240300103001 ALBUTEROL 27.72 13242.284649
202350170244 202350170244001 ALBUTEROL SULFATE 13.73 5444.690060
202350170244002 ALBUTEROL SULFATE 13.73 5444.690060
202350170244003 ALBUTEROL SULFATE 13.73 5444.690060
202350170333 202350170333001 ALBUTEROL SULFATE 13.73 5444.690060
202350170333002 ALBUTEROL SULFATE 13.73 5444.690060
202350170333003 ALBUTEROL SULFATE 13.73 5444.690060
202350170333004 ALBUTEROL SULFATE 13.73 5444.690060
202350170333005 ALBUTEROL SULFATE 13.73 5444.690060
202350170439 202350170439001 ALBUTEROL SULFATE 13.73 5444.690060
202350170439002 ALBUTEROL SULFATE 13.73 5444.690060
202350170439003 ALBUTEROL SULFATE 13.73 5444.690060
202350170439004 ALBUTEROL SULFATE 13.73 5444.690060
202620130162 202620130162001 ALBUTEROL 54.30 8845.099617
202620130179 202620130179001 SEREVENT INHALER 104.66 8845.099617
202620130186 202620130186001 VANCERIL 99.82 8845.099617
202620130415 202620130415001 SEREVENT 167.66 8845.099617
202620130422 202620130422001 VANCERIL 99.82 8845.099617
202620130439 202620130439001 COMBIVENT 102.76 8845.099617
202620130600 202620130600001 COMBIVENT 102.76 8845.099617
HC-067I 11:08 Thursday, October 28, 2004 12
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-067A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
202620130624 202620130624001 SEREVENT 167.66 8845.099617
202620130631 202620130631001 VANCERIL 99.82 8845.099617
202650560074 202650560074001 ALBUTEROL INHALER 19.79 3595.909035
202650560074002 ALBUTEROL INHALER 19.79 3595.909035
202650560334 202650560334001 ALBUTEROL INHALER 19.79 3595.909035
202680360075 202680360075001 BRONCHO SALINE 25.32 1722.753723
202680360075002 BRONCHO SALINE 25.32 1722.753723
202680360075003 BRONCHO SALINE 25.32 1722.753723
202680360075004 BRONCHO SALINE 25.32 1722.753723
202680360075005 BRONCHO SALINE 25.32 1722.753723
202680360082 202680360082001 PREDNISONE 3.34 1722.753723
202680360246 202680360246001 SINGULAIR 15.00 1722.753723
202680360253 202680360253001 ALBUTEROL 21.41 1722.753723
202680360260 202680360260001 PREDNISONE 3.34 1722.753723
202680430068 202680430068001 ALBUTEROL 15.08 1235.155999
202680430075 202680430075001 PREDNISONE 11.80 1235.155999
202680590052 202680590052001 ALBUTEROL 15.08 1500.255676
202740110168 202740110168001 AZMACORT 66.23 3865.747467
202740110175 202740110175001 ALBUTEROL 22.94 3865.747467
202740110182 202740110182001 ALBUTEROL 19.12 3865.747467
202740110428 202740110428001 AZMACORT 64.50 3865.747467
202740110428002 AZMACORT 64.50 3865.747467
202740110428003 AZMACORT 64.50 3865.747467
202740110428004 AZMACORT 64.50 3865.747467
202740110428005 AZMACORT 64.50 3865.747467
202740110428006 AZMACORT 64.50 3865.747467
202740110428007 AZMACORT 64.50 3865.747467
202740110435 202740110435001 ALBUTEROL (REFILL) 14.45 3865.747467
202740110435002 ALBUTEROL (REFILL) 14.45 3865.747467
202740110435003 ALBUTEROL (REFILL) 14.45 3865.747467
202740110435004 ALBUTEROL (REFILL) 14.45 3865.747467
202740110435005 ALBUTEROL (REFILL) 14.45 3865.747467
202740110435006 ALBUTEROL (REFILL) 14.45 3865.747467
HC-067I 11:08 Thursday, October 28, 2004 13
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-067A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
202740110435 202740110435007 ALBUTEROL (REFILL) 14.45 3865.747467
202740110442 202740110442001 ALBUTEROL 19.12 3865.747467
202740110442002 ALBUTEROL 19.12 3865.747467
202740110637 202740110637001 AZMACORT 71.18 3865.747467
202740110637002 AZMACORT 71.18 3865.747467
202740110637003 AZMACORT 71.18 3865.747467
202740110644 202740110644001 ALBUTEROL 22.94 3865.747467
202740110644002 ALBUTEROL 22.94 3865.747467
202740110644003 ALBUTEROL 22.94 3865.747467
202740110651 202740110651001 ALBUTEROL 19.12 3865.747467
202740110651002 ALBUTEROL 19.12 3865.747467
202740110651003 ALBUTEROL 19.12 3865.747467
202990190049 202990190049001 ALBUTEROL 10.59 11050.409291
202990190049002 ALBUTEROL 10.59 11050.409291
202990190056 202990190056001 SEREVENT 74.26 11050.409291
202990190056002 SEREVENT 75.88 11050.409291
202990190063 202990190063001 FLOVENT 104.92 11050.409291
202990190063002 FLOVENT 104.92 11050.409291
202990190145 202990190145001 ALBUTEROL 10.59 11050.409291
202990190152 202990190152001 SEREVENT 74.26 11050.409291
202990190169 202990190169001 FLOVENT 104.92 11050.409291
202990190176 202990190176001 RANITIDINE HCL 175.80 11050.409291
202990190183 202990190183001 ALBUTEROL 10.59 11050.409291
202990190190 202990190190001 SEREVENT 72.75 11050.409291
202990190203 202990190203001 FLOVENT 104.92 11050.409291
202990190210 202990190210001 RANITIDINE HCL 175.80 11050.409291
203080160051 203080160051001 ALBUTEROL 19.84 2930.950078
203080160051002 ALBUTEROL 19.84 2930.950078
203080160164 203080160164001 NASACORT AQ 54.41 2930.950078
203080160284 203080160284001 NASONEX 57.46 2930.950078
203080160284002 NASONEX 57.46 2930.950078
HC-067I 11:08 Thursday, October 28, 2004 14
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-067A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
203080160284 203080160284003 NASONEX 57.46 2930.950078
203080160284004 NASONEX 57.46 2930.950078
203080160284005 NASONEX 57.46 2930.950078
203080160284006 NASONEX 57.46 2930.950078
203080160284007 NASONEX 57.46 2930.950078
203600120105 203600120105001 PREDNISONE 8.99 14729.271001
203600120105002 PREDNISONE 8.99 14729.271001
203600120143 203600120143001 COMBIVENT 50.39 14729.271001
203600290112 203600290112001 NEBULIZER 155.50 14710.824302
203600290218 203600290218001 SODIUM POLYSTYRENE SULFONATE 73.87 14710.824302
203600290225 203600290225001 IPRATROPIUM BROMIDE (VIAL) 88.85 14710.824302
203600290225002 IPRATROPIUM BROMIDE (VIAL) 88.85 14710.824302
203600290232 203600290232001 ALBUTEROL SULFATE (VIAL) 137.82 14710.824302
203600290232002 ALBUTEROL SULFATE (VIAL) 137.82 14710.824302
203600290232003 ALBUTEROL SULFATE (VIAL) 137.82 14710.824302
203650120025 203650120025001 OPTIHALER (METERED DOSE INHALER) 39.58 8228.034938
203740440038 203740440038001 ALBUTEROL 21.41 10847.674238
203740440052 203740440052001 ALBUTEROL 16.34 10847.674238
203740440052002 ALBUTEROL 16.34 10847.674238
203740440052003 ALBUTEROL 30.68 10847.674238
203740440090 203740440090001 ALBUTEROL 30.68 10847.674238
203840180275 203840180275001 NASONEX 69.68 21372.829443
204060130053 204060130053001 ZITHROMAX 27.45 19190.149525
204060130060 204060130060001 PREDNISONE 9.99 19190.149525
204060130104 204060130104001 ALBUTEROL 22.96 19190.149525
204060130104002 ALBUTEROL 22.96 19190.149525
204060130135 204060130135001 ALBUTEROL 22.96 19190.149525
204190190047 204190190047001 FLOVENT 85.65 15698.239641
204190190307 204190190307001 LEVAQUIN 108.14 15698.239641
204190190561 204190190561001 FLOVENT 85.65 15698.239641
204190190561002 FLOVENT 85.65 15698.239641
HC-067I 11:08 Thursday, October 28, 2004 15
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-067A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
204340120065 204340120065001 ALBUTEROL 18.31 14898.017996
204340120065002 ALBUTEROL 18.31 14898.017996
204340120065003 ALBUTEROL 18.31 14898.017996
204340120065004 ALBUTEROL 18.31 14898.017996
204350100028 204350100028001 CLARITIN 94.08 15127.369032
HC-067I 11:08 Thursday, October 28, 2004 16
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
The MEANS Procedure
Analysis Variable : RXXP02X SUM OF PAYMENTS RXSF02X-RXOU02X(IMPUTED)
N Sum
---------------------
12112 728935.66
---------------------
HC-067I 11:08 Thursday, October 28, 2004 17
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP02X SUM OF PAYMENTS RXSF02X-RXOU02X(IMPUTED)
N Sum
---------------------
12112 5624031844
---------------------
1 The SAS System 11:17 Thursday, October 28, 2004
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 82BX08.
NOTE: SAS initialization used:
real time 3.29 seconds
cpu time 0.29 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-067I";
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.15 seconds
cpu time 0.00 seconds
23
24 *-----------------------------------------------------------------------------------
25 * Get conditions records coded as asthma.
26 *-----------------------------------------------------------------------------------;
2 The SAS System 11:17 Thursday, October 28, 2004
27 DATA ASCONDS;
28 SET IN.H69 (KEEP=CONDIDX CCCODEX);
29 IF CCCODEX="128";
30 RUN;
NOTE: There were 120795 observations read from the data set IN.H69.
NOTE: The data set WORK.ASCONDS has 2159 observations and 2 variables.
NOTE: DATA statement used:
real time 1.51 seconds
cpu time 0.21 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 2159 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 2159 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.09 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-069) 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.28 seconds
cpu time 0.03 seconds
41
42 PROC SORT DATA=IN.H67IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 388065 observations read from the data set IN.H67IF1.
NOTE: The data set WORK.CLNK has 388065 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 21.00 seconds
cpu time 2.23 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 11:17 Thursday, October 28, 2004
NOTE: There were 388065 observations read from the data set WORK.CLNK.
NOTE: There were 2159 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 8833 observations and 3 variables.
NOTE: DATA statement used:
real time 0.43 seconds
cpu time 0.40 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.54 seconds
cpu time 0.01 seconds
58
59 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 8833 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 8833 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.03 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.03 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 8833 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 8830 observations and 2 variables.
4 The SAS System 11:17 Thursday, October 28, 2004
NOTE: DATA statement used:
real time 0.21 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.03 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.H67G (KEEP=EVNTIDX PERWT02F SEETLKPV OBXP02X);
82 IF PERWT02F > 0 & SEETLKPV NE 2;
83 RUN;
NOTE: There were 179745 observations read from the data set IN.H67G.
NOTE: The data set WORK.MVIS has 173591 observations and 4 variables.
NOTE: DATA statement used:
real time 3.75 seconds
cpu time 0.56 seconds
84
85 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 173591 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 173591 observations and 4 variables.
NOTE: PROCEDURE SORT used:
real time 1.67 seconds
cpu time 0.67 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 8830 observations read from the data set WORK.ASCLNKS.
NOTE: There were 173591 observations read from the data set WORK.MVIS.
5 The SAS System 11:17 Thursday, October 28, 2004
NOTE: The data set WORK.ASMVIS has 2916 observations and 5 variables.
NOTE: DATA statement used:
real time 0.31 seconds
cpu time 0.18 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-067G) 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.00 seconds
102
103 PROC MEANS DATA=ASMVIS N SUM;
104 VAR OBXP02X;
105 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
106 RUN;
NOTE: There were 2916 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 7.
NOTE: PROCEDURE MEANS used:
real time 0.10 seconds
cpu time 0.01 seconds
107
108 PROC MEANS DATA=ASMVIS SUM;
109 VAR OBXP02X;
110 WEIGHT PERWT02F;
111 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
112 TITLE5 "Weighted";
113 RUN;
NOTE: There were 2916 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 8.
NOTE: PROCEDURE MEANS used:
real time 0.03 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 34.07 seconds
cpu time 4.78 seconds
HC-067I 11:17 Thursday, October 28, 2004 1
Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx
COND (HC-069) records where cccodex=128
Obs CONDIDX CCCODEX
1 200210270023 128
2 200260120036 128
3 200300100028 128
4 200340280018 128
5 200390220116 128
6 200410170097 128
7 200530380017 128
8 200540230019 128
9 200640100022 128
10 200640100141 128
11 200760300018 128
12 200860130041 128
13 200880360010 128
14 201090290010 128
15 201100200048 128
16 201100440018 128
17 201150170015 128
18 201170490019 128
19 201170550019 128
20 201290280019 128
21 201550320028 128
22 201790120016 128
23 201790290043 128
24 201790360014 128
25 201790590029 128
26 201840320043 128
27 201860330010 128
28 201860330032 128
29 201930150013 128
30 201980300032 128
31 202000130025 128
32 202030180047 128
33 202170150026 128
34 202170290028 128
35 202240300029 128
36 202350170021 128
37 202620130056 128
38 202650560036 128
39 202680360017 128
40 202680360051 128
41 202680430038 128
42 202680590038 128
43 202740110040 128
44 202900140013 128
45 202990190017 128
46 203080160025 128
47 203600120037 128
48 203600290042 128
49 203650120019 128
50 203740440015 128
HC-067I 11:17 Thursday, October 28, 2004 2
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200210270023 200210270069 8 PMED
200210270083 8 PMED
200260120036 200260120056 1 MVIS
200260120190 8 PMED
200260120354 1 MVIS
200260120816 8 PMED
200260120847 8 PMED
200260120854 8 PMED
200300100028 200300100019 1 MVIS
200300100026 8 PMED
200340280018 200340280016 8 PMED
200340280030 8 PMED
200340280054 8 PMED
200340280061 8 PMED
200340280085 8 PMED
200340280092 1 MVIS
200340280143 8 PMED
200340280150 8 PMED
200390220116 200390220363 8 PMED
200410170097 200410170229 8 PMED
200410170236 8 PMED
200530380017 200530380017 3 EROM
200530380024 3 EROM
200530380062 8 PMED
200530380106 8 PMED
200540230019 200540230020 1 MVIS
200540230037 1 MVIS
200540230044 8 PMED
200540230051 8 PMED
200540230075 8 PMED
200540230126 1 MVIS
200540230164 8 PMED
200540230171 8 PMED
200540230188 8 PMED
200640100022 200640100030 1 MVIS
200640100232 8 PMED
200640100249 8 PMED
200640100749 8 PMED
200640100883 8 PMED
200640100890 8 PMED
HC-067I 11:17 Thursday, October 28, 2004 3
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
200640100141 200640100605 2 OPAT
200640100612 2 OPAT
200640100756 8 PMED
200760300018 200760300058 8 PMED
200760300161 8 PMED
200860130041 200860130063 8 PMED
200860130070 8 PMED
200860130087 8 PMED
200860130094 8 PMED
200860130145 8 PMED
200860130234 8 PMED
200880360010 200880360038 8 PMED
200880360103 8 PMED
201090290010 201090290019 8 PMED
201090290026 8 PMED
201090290040 8 PMED
201100200048 201100200124 1 MVIS
201100200131 1 MVIS
201100200155 1 MVIS
201100200162 8 PMED
201100200179 8 PMED
201100440018 201100440028 1 MVIS
201100440080 8 PMED
201100440097 8 PMED
201100440100 8 PMED
201100440155 8 PMED
201150170015 201150170292 8 PMED
201150170381 8 PMED
201170490019 201170490059 8 PMED
201170490066 8 PMED
201170550019 201170550012 1 MVIS
201170550029 1 MVIS
201170550036 1 MVIS
201170550043 1 MVIS
201170550050 1 MVIS
HC-067I 11:17 Thursday, October 28, 2004 4
Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 200210270023 200210270069 8 PMED
2 200210270023 200210270083 8 PMED
3 200260120036 200260120056 1 MVIS
4 200260120036 200260120190 8 PMED
5 200260120036 200260120354 1 MVIS
6 200260120036 200260120816 8 PMED
7 200260120036 200260120847 8 PMED
8 200260120036 200260120854 8 PMED
9 200300100028 200300100019 1 MVIS
10 200300100028 200300100026 8 PMED
11 200340280018 200340280016 8 PMED
12 200340280018 200340280030 8 PMED
13 200340280018 200340280054 8 PMED
14 200340280018 200340280061 8 PMED
15 200340280018 200340280085 8 PMED
16 200340280018 200340280092 1 MVIS
17 200340280018 200340280143 8 PMED
18 200340280018 200340280150 8 PMED
19 200390220116 200390220363 8 PMED
20 200410170097 200410170229 8 PMED
21 200410170097 200410170236 8 PMED
22 200530380017 200530380017 3 EROM
23 200530380017 200530380024 3 EROM
24 200530380017 200530380062 8 PMED
25 200530380017 200530380106 8 PMED
26 200540230019 200540230020 1 MVIS
27 200540230019 200540230037 1 MVIS
28 200540230019 200540230044 8 PMED
29 200540230019 200540230051 8 PMED
30 200540230019 200540230075 8 PMED
31 200540230019 200540230126 1 MVIS
32 200540230019 200540230164 8 PMED
33 200540230019 200540230171 8 PMED
34 200540230019 200540230188 8 PMED
35 200640100022 200640100030 1 MVIS
36 200640100022 200640100232 8 PMED
37 200640100022 200640100249 8 PMED
38 200640100141 200640100605 2 OPAT
39 200640100141 200640100612 2 OPAT
40 200640100022 200640100749 8 PMED
41 200640100141 200640100756 8 PMED
42 200640100022 200640100883 8 PMED
43 200640100022 200640100890 8 PMED
44 200760300018 200760300058 8 PMED
45 200760300018 200760300161 8 PMED
46 200860130041 200860130063 8 PMED
47 200860130041 200860130070 8 PMED
48 200860130041 200860130087 8 PMED
49 200860130041 200860130094 8 PMED
50 200860130041 200860130145 8 PMED
HC-067I 11:17 Thursday, October 28, 2004 5
Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 200210270069 8 PMED
2 200210270083 8 PMED
3 200260120056 1 MVIS
4 200260120190 8 PMED
5 200260120354 1 MVIS
6 200260120816 8 PMED
7 200260120847 8 PMED
8 200260120854 8 PMED
9 200300100019 1 MVIS
10 200300100026 8 PMED
11 200340280016 8 PMED
12 200340280030 8 PMED
13 200340280054 8 PMED
14 200340280061 8 PMED
15 200340280085 8 PMED
16 200340280092 1 MVIS
17 200340280143 8 PMED
18 200340280150 8 PMED
19 200390220363 8 PMED
20 200410170229 8 PMED
21 200410170236 8 PMED
22 200530380017 3 EROM
23 200530380024 3 EROM
24 200530380062 8 PMED
25 200530380106 8 PMED
26 200540230020 1 MVIS
27 200540230037 1 MVIS
28 200540230044 8 PMED
29 200540230051 8 PMED
30 200540230075 8 PMED
31 200540230126 1 MVIS
32 200540230164 8 PMED
33 200540230171 8 PMED
34 200540230188 8 PMED
35 200640100030 1 MVIS
36 200640100232 8 PMED
37 200640100249 8 PMED
38 200640100605 2 OPAT
39 200640100612 2 OPAT
40 200640100749 8 PMED
41 200640100756 8 PMED
42 200640100883 8 PMED
43 200640100890 8 PMED
44 200760300058 8 PMED
45 200760300161 8 PMED
46 200860130063 8 PMED
47 200860130070 8 PMED
48 200860130087 8 PMED
49 200860130094 8 PMED
50 200860130145 8 PMED
HC-067I 11:17 Thursday, October 28, 2004 6
Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-067G) events
Obs EVNTIDX EVENTYPE SEETLKPV OBXP02X PERWT02F
1 200260120056 1 MVIS 1 593.50 14422.86
2 200260120354 1 MVIS 1 1032.00 14422.86
3 200300100019 1 MVIS 1 663.69 6875.18
4 200340280092 1 MVIS 1 94.00 4001.74
5 200540230020 1 MVIS 1 80.00 6982.59
6 200540230037 1 MVIS 1 61.00 6982.59
7 200540230126 1 MVIS 1 176.63 6982.59
8 200640100030 1 MVIS 1 88.00 11866.14
9 201100200124 1 MVIS 1 95.00 15775.48
10 201100200131 1 MVIS 1 95.00 15775.48
11 201100200155 1 MVIS 1 32.35 15775.48
12 201100440028 1 MVIS 1 106.08 17098.35
13 201170550012 1 MVIS 1 86.49 9275.72
14 201170550029 1 MVIS 1 86.49 9275.72
15 201170550036 1 MVIS 1 131.56 9275.72
16 201170550043 1 MVIS 1 105.18 9275.72
17 201170550050 1 MVIS 1 113.75 9275.72
18 201170550067 1 MVIS 1 113.75 9275.72
19 201170550074 1 MVIS 1 73.00 9275.72
20 201290280058 1 MVIS 1 91.20 8416.58
21 201290280065 1 MVIS 1 63.72 8416.58
22 201290280072 1 MVIS 1 67.14 8416.58
23 201790120016 1 MVIS 1 12.00 1623.93
24 201790290016 1 MVIS 1 148.00 2381.51
25 201790290023 1 MVIS 1 210.00 2381.51
26 201790290030 1 MVIS 1 150.00 2381.51
27 201790290047 1 MVIS 1 113.00 2381.51
28 201790290054 1 MVIS 1 28.00 2381.51
29 201790290061 1 MVIS 1 245.00 2381.51
30 201790290078 1 MVIS 1 246.00 2381.51
31 201790290249 1 MVIS 1 336.00 2381.51
32 201790360030 1 MVIS 1 0.00 3060.51
33 201790360047 1 MVIS 1 40.00 3060.51
34 201790360054 1 MVIS 1 0.00 3060.51
35 201790360061 1 MVIS 1 0.00 3060.51
36 201790360078 1 MVIS 1 40.00 3060.51
37 201790360112 1 MVIS 1 6.00 3060.51
38 201860330072 1 MVIS 1 92.82 2561.46
39 201860330130 1 MVIS 1 130.27 2561.46
40 201860330147 1 MVIS 1 130.27 2561.46
41 201860330154 1 MVIS 1 130.27 2561.46
42 201980300011 1 MVIS 1 90.00 12875.70
43 202030180032 1 MVIS 1 154.97 3012.54
44 202030180056 1 MVIS 1 179.00 3012.54
45 202170150088 1 MVIS 1 93.00 9578.34
46 202620130237 1 MVIS 1 101.01 8845.10
47 202680360044 1 MVIS 1 55.00 1722.75
48 202740110017 1 MVIS 1 489.72 3865.75
49 202740110024 1 MVIS 1 70.31 3865.75
50 202740110031 1 MVIS 1 4636.60 3865.75
HC-067I 11:17 Thursday, October 28, 2004 7
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
The MEANS Procedure
Analysis Variable : OBXP02X SUM OF OBSF02X - OBOT02X (IMPUTED)
N Sum
--------------------
2916 305902.82
--------------------
HC-067I 11:17 Thursday, October 28, 2004 8
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : OBXP02X SUM OF OBSF02X - OBOT02X (IMPUTED)
Sum
------------
2042744316
------------
1 The SAS System 11:18 Thursday, October 28, 2004
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 82BX08.
NOTE: SAS initialization used:
real time 3.00 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-067I";
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 11:18 Thursday, October 28, 2004
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.15 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.H67C (KEEP=EVNTIDX PERWT02F OMTYPEX);
51 IF PERWT02F > 0 & OMTYPEX = 2;
52 RUN;
NOTE: There were 10564 observations read from the data set IN.H67C.
NOTE: The data set WORK.OMED has 669 observations and 3 variables.
NOTE: DATA statement used:
real time 0.51 seconds
cpu time 0.09 seconds
53
54 proc print data=omed (obs=100);
55 var evntidx OMTYPEX PERWT02F;
56 format OMTYPEX omtype.;
57 title3 "sample print of OMED (HC-067C) 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.32 seconds
cpu time 0.04 seconds
59
60 *-------------------------------------------------------------------------------------
61 * Get PMED IDs linked to the OMED events which were for insulin.
62 *-------------------------------------------------------------------------------------;
63
64 PROC SORT DATA=IN.H67IF2 OUT=RXLK; BY EVNTIDX; RUN;
3 The SAS System 11:18 Thursday, October 28, 2004
NOTE: There were 72467 observations read from the data set IN.H67IF2.
NOTE: The data set WORK.RXLK has 72467 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 0.67 seconds
cpu time 0.49 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-67IF2) - 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.10 seconds
cpu time 0.01 seconds
73
74 data omedrxlk;
75 set rxlk (where=(eventype=6));
76 run;
NOTE: There were 2056 observations read from the data set WORK.RXLK.
WHERE eventype=6;
NOTE: The data set WORK.OMEDRXLK has 2056 observations and 5 variables.
NOTE: DATA statement used:
real time 0.03 seconds
cpu time 0.03 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-67IF2) 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.04 seconds
cpu time 0.03 seconds
85
86 DATA PMEDIDS;
87 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
88 OMED (IN=INOMED KEEP=EVNTIDX);
4 The SAS System 11:18 Thursday, October 28, 2004
89 BY EVNTIDX;
90 IF INRXLK & INOMED;
91 RUN;
NOTE: There were 72467 observations read from the data set WORK.RXLK.
NOTE: There were 669 observations read from the data set WORK.OMED.
NOTE: The data set WORK.PMEDIDS has 636 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.04 seconds
cpu time 0.01 seconds
100
101 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 636 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 636 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.01 seconds
cpu time 0.01 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.03 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 11:18 Thursday, October 28, 2004
113 RUN;
NOTE: There were 636 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 636 observations and 1 variables.
NOTE: DATA statement used:
real time 0.00 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.01 seconds
cpu time 0.01 seconds
118
119
120 *------------------------------------------------------------------------------------
121 * Get PMED records for OMED event which were for insulin.
122 *------------------------------------------------------------------------------------;
123 PROC SORT DATA=IN.H67A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 339308 observations read from the data set IN.H67A.
NOTE: The data set WORK.PMED has 339308 observations and 70 variables.
NOTE: PROCEDURE SORT used:
real time 4:56.39
cpu time 31.24 seconds
124
125 DATA OMPMEDS;
126 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP02X PERWT02F RXNAME)
127 PMEDIDS (IN=A);
128 BY LINKIDX;
129 IF A & PERWT02F>0;
130 RUN;
NOTE: There were 339308 observations read from the data set WORK.PMED.
NOTE: There were 636 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.OMPMEDS has 2372 observations and 5 variables.
NOTE: DATA statement used:
real time 4.60 seconds
cpu time 1.15 seconds
131
132 proc print data=ompmeds (obs=200);
133 by linkidx;
134 id linkidx;
135 var rxrecidx rxname RXXP02X PERWT02F;
136 title3 "sample print of work.pmeds";
6 The SAS System 11:18 Thursday, October 28, 2004
137 title4 "PMED (HC-067A) 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.45 seconds
cpu time 0.03 seconds
139
140 PROC MEANS DATA=OMPMEDS N SUM;
141 VAR RXXP02X;
142 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
143 RUN;
NOTE: There were 2372 observations read from the data set WORK.OMPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used:
real time 0.28 seconds
cpu time 0.01 seconds
144
145 PROC MEANS DATA=OMPMEDS N SUM;
146 VAR RXXP02X;
147 WEIGHT PERWT02F;
148 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
149 TITLE5 "Weighted";
150 RUN;
NOTE: There were 2372 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.00 seconds
151
152
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 5:08.09
cpu time 33.81 seconds
HC-067I 11:18 Thursday, October 28, 2004 1
Sample SAS Job for Example D
sample print of OMED (HC-067C) records where OMTYPEX=2
Obs EVNTIDX OMTYPEX PERWT02F
1 200720190121 2 INSULIN 2612.83
2 201070130115 2 INSULIN 21620.73
3 201070130266 2 INSULIN 21620.73
4 201150170165 2 INSULIN 7331.78
5 201150170189 2 INSULIN 7331.78
6 201290110034 2 INSULIN 9167.69
7 201510150047 2 INSULIN 3187.58
8 201510150338 2 INSULIN 3187.58
9 202550130179 2 INSULIN 9537.04
10 202650190124 2 INSULIN 2202.30
11 202650560163 2 INSULIN 3595.91
12 202750160146 2 INSULIN 11669.45
13 202750160595 2 INSULIN 11669.45
14 202940160115 2 INSULIN 2830.74
15 202940160259 2 INSULIN 2830.74
16 203410210144 2 INSULIN 4319.02
17 204580280136 2 INSULIN 10839.14
18 204580280181 2 INSULIN 10839.14
19 204680150064 2 INSULIN 3236.75
20 204910230033 2 INSULIN 15303.40
21 204910230228 2 INSULIN 15303.40
22 205150110154 2 INSULIN 3149.28
23 205690140421 2 INSULIN 2534.07
24 205780100312 2 INSULIN 2013.99
25 206840120088 2 INSULIN 6979.34
26 206840120177 2 INSULIN 6979.34
27 206840120259 2 INSULIN 6979.34
28 206860190055 2 INSULIN 676.01
29 207220190207 2 INSULIN 4774.78
30 207630150039 2 INSULIN 27483.31
31 207630150111 2 INSULIN 27483.31
32 207630150200 2 INSULIN 27483.31
33 207930280056 2 INSULIN 12195.82
34 207930280176 2 INSULIN 12195.82
35 207930280570 2 INSULIN 12195.82
36 208110150181 2 INSULIN 6376.10
37 208390130032 2 INSULIN 4133.85
38 208890670089 2 INSULIN 1064.59
39 209860130065 2 INSULIN 8962.99
40 209860130154 2 INSULIN 8962.99
41 210130260187 2 INSULIN 5735.15
42 210130260365 2 INSULIN 5735.15
43 210690140199 2 INSULIN 7498.99
44 210710260072 2 INSULIN 1390.33
45 211140160036 2 INSULIN 20702.54
46 211240120061 2 INSULIN 7121.78
47 211240120256 2 INSULIN 7121.78
48 211240120390 2 INSULIN 7121.78
49 211550110332 2 INSULIN 1298.50
50 211810130654 2 INSULIN 10782.45
51 212870140662 2 INSULIN 3025.08
52 213150200211 2 INSULIN 4322.26
53 213150200386 2 INSULIN 4322.26
HC-067I 11:18 Thursday, October 28, 2004 2
Sample SAS Job for Example D
sample print of OMED (HC-067C) records where OMTYPEX=2
Obs EVNTIDX OMTYPEX PERWT02F
54 213370190042 2 INSULIN 10594.16
55 213370190193 2 INSULIN 10594.16
56 213700330020 2 INSULIN 6435.85
57 213700330133 2 INSULIN 6435.85
58 214240110428 2 INSULIN 9696.98
59 214400140059 2 INSULIN 4256.63
60 214400140528 2 INSULIN 4256.63
61 214990270075 2 INSULIN 4356.53
62 214990270171 2 INSULIN 4356.53
63 215320120836 2 INSULIN 6946.45
64 215550100463 2 INSULIN 6430.52
65 216010140246 2 INSULIN 12998.12
66 216130260669 2 INSULIN 5119.65
67 216820150098 2 INSULIN 25134.35
68 217020400037 2 INSULIN 2376.65
69 217020400099 2 INSULIN 2376.65
70 217080260073 2 INSULIN 3611.88
71 217080260155 2 INSULIN 3611.88
72 218200230058 2 INSULIN 15314.80
73 218200230394 2 INSULIN 15314.80
74 219470370014 2 INSULIN 17032.83
75 220010110025 2 INSULIN 2296.60
76 220780120152 2 INSULIN 1990.88
77 220780120392 2 INSULIN 1990.88
78 221090240064 2 INSULIN 2489.49
79 221090240153 2 INSULIN 2489.49
80 221110110424 2 INSULIN 4048.42
81 221110110835 2 INSULIN 4048.42
82 221220170051 2 INSULIN 2807.68
83 221220171030 2 INSULIN 2807.68
84 221870140052 2 INSULIN 5784.05
85 221870140367 2 INSULIN 5784.05
86 221870140792 2 INSULIN 5784.05
87 223060180028 2 INSULIN 8174.11
88 223060180080 2 INSULIN 8174.11
89 223360170039 2 INSULIN 8644.09
90 223360170135 2 INSULIN 8644.09
91 223360170197 2 INSULIN 8644.09
92 223390120349 2 INSULIN 1433.54
93 224090140201 2 INSULIN 8470.39
94 224090140547 2 INSULIN 8470.39
95 224100100031 2 INSULIN 5806.41
96 224100270031 2 INSULIN 6697.78
97 224100270308 2 INSULIN 6697.78
98 226780160062 2 INSULIN 1589.29
99 226780160257 2 INSULIN 1589.29
100 227060220024 2 INSULIN 8039.72
HC-067I 11:18 Thursday, October 28, 2004 3
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-67IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
200020380013 200020380020 1 MVIS
200020380037 1 MVIS
200030260041 200030260123 1 MVIS
200030260178 200030260250 1 MVIS
200040180012 200040180067 1 MVIS
200040180081 200040180187 4 STAZ
200040180101 200040180207 1 MVIS
200040180163 200040180187 1 MVIS
200040180221 200040180276 1 MVIS
200040180245 200040180283 1 MVIS
200070160018 200070160049 1 MVIS
200070160056 1 MVIS
200070160032 200070160049 1 MVIS
200120180060 200120180084 1 MVIS
200120180091 1 MVIS
200120180104 1 MVIS
200120180111 1 MVIS
200120180077 200120180128 1 MVIS
200120250022 200120250060 1 MVIS
200120250046 200120250077 3 EROM
200120250128 200120250313 1 MVIS
200120250320 1 MVIS
200120250337 1 MVIS
200120250344 1 MVIS
200120250351 1 MVIS
200120250368 1 MVIS
200140170015 200140170022 1 MVIS
200140170039 1 MVIS
200140240046 200140240382 1 MVIS
200140240180 200140240399 1 MVIS
200140240426 200140240433 1 MVIS
HC-067I 11:18 Thursday, October 28, 2004 4
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-67IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
200150190012 200150190029 1 MVIS
200150190036 1 MVIS
200150190043 1 MVIS
200150190050 1 MVIS
200160650045 200160650076 1 MVIS
200160650083 200160650103 1 MVIS
200160650110 1 MVIS
200160730068 200160730082 1 MVIS
200160730075 200160730099 1 MVIS
200170120015 200170120046 1 MVIS
200170120053 1 MVIS
200170120135 200170120142 1 MVIS
200170120159 1 MVIS
200190140041 200190140072 1 MVIS
200190140058 200190140089 1 MVIS
200190140096 1 MVIS
200200160021 200200160069 1 MVIS
200200230052 200200230076 5 DVIS
200200230090 200200230127 1 MVIS
200200230134 1 MVIS
200210100045 200210100134 1 MVIS
200210270038 200210270069 1 MVIS
200210270076 1 MVIS
200210270083 1 MVIS
200210270090 1 MVIS
200210340038 200210340076 1 MVIS
200210340069 200210340083 1 MVIS
200220150026 200220150040 1 MVIS
200220460019 200220460033 1 MVIS
200230100018 200230100032 1 MVIS
200230100025 200230100049 1 MVIS
HC-067I 11:18 Thursday, October 28, 2004 5
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-67IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
200260120405 200260120412 1 MVIS
200260120429 1 MVIS
200260120676 200260120683 3 EROM
200260120690 3 EROM
200260290121 200260290258 1 MVIS
200260290190 200260290265 2 OPAT
200290180018 200290180049 1 MVIS
200300100019 200300100026 1 MVIS
200320100010 200320100065 1 MVIS
200320100072 1 MVIS
200320100089 1 MVIS
200320100096 1 MVIS
200320100034 200320100109 1 MVIS
200320100123 200320100130 1 MVIS
200320100147 1 MVIS
200320100154 1 MVIS
200320100185 200320100243 4 STAZ
200320100250 4 STAZ
200320100267 4 STAZ
200320100274 4 STAZ
200320100281 4 STAZ
200320100298 4 STAZ
200330150050 200330150081 3 EROM
200330150067 200330150098 1 MVIS
200340110054 200340110061 2 OPAT
200360130010 200360130058 5 DVIS
200360130109 200360130130 1 MVIS
200360200027 200360200065 1 MVIS
200360200072 200360200154 1 MVIS
200390150010 200390150027 1 MVIS
200390150034 200390150041 1 MVIS
HC-067I 11:18 Thursday, October 28, 2004 6
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-67IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
200390220010 200390220116 1 MVIS
200390220123 1 MVIS
200390220130 1 MVIS
200390220147 1 MVIS
200390220072 200390220154 1 MVIS
200390220089 200390220154 1 MVIS
200390220192 200390220229 1 MVIS
200390220205 200390220236 5 DVIS
200390220243 5 DVIS
200390220281 200390220332 5 DVIS
200410170154 200410170185 1 MVIS
200440170026 200440170033 1 MVIS
200450150104 200450150142 1 MVIS
200450150128 200450150166 1 MVIS
200460230018 200460230025 1 MVIS
200460470018 200460470025 1 MVIS
200480150018 200480150025 1 MVIS
200480150032 200480150049 1 MVIS
200510130051 200510130068 1 MVIS
200510130075 1 MVIS
200510130082 1 MVIS
200510130099 1 MVIS
200510130119 200510130133 1 MVIS
200520140018 200520140025 1 MVIS
200520140032 200520140049 1 MVIS
200520140056 1 MVIS
200530380017 200530380048 3 EROM
200530380055 3 EROM
200530380062 3 EROM
200530380079 3 EROM
200530380024 200530380062 3 EROM
HC-067I 11:18 Thursday, October 28, 2004 7
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-67IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
200530380093 200530380106 3 EROM
200540110049 200540110056 1 MVIS
200540110070 200540110114 1 MVIS
200540110121 1 MVIS
200540110138 1 MVIS
200540110145 1 MVIS
200540110152 1 MVIS
200540160013 200540160051 1 MVIS
200540160171 200540160208 1 MVIS
200540160215 1 MVIS
200540160188 200540160222 1 MVIS
200540160253 200540160284 2 OPAT
200540160291 2 OPAT
200540230020 200540230044 1 MVIS
200540230051 1 MVIS
200540230037 200540230068 1 MVIS
200540230075 1 MVIS
200540230126 200540230164 1 MVIS
200540230171 1 MVIS
200540230188 1 MVIS
200550130019 200550130026 1 MVIS
200560250015 200560250022 1 MVIS
200560320015 200560320022 1 MVIS
200590180014 200590180038 3 EROM
200590250014 200590250045 1 MVIS
200590250038 200590250052 1 MVIS
HC-067I 11:18 Thursday, October 28, 2004 8
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-67IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
200600100063 200600100070 6 OMED
200600100145 200600100152 6 OMED
200720190121 200720190138 6 OMED
200720190145 200720190152 6 OMED
201030140440 201030140457 6 OMED
201070130115 201070130122 6 OMED
201070130266 201070130273 6 OMED
201070130280 201070130297 6 OMED
201070130406 201070130413 6 OMED
201150170165 201150170172 6 OMED
201150170189 201150170196 6 OMED
201290110034 201290110041 6 OMED
201290110058 201290110065 6 OMED
201510150047 201510150054 6 OMED
201510150061 201510150078 6 OMED
201510150150 201510150167 6 OMED
201510150338 201510150345 6 OMED
201510150352 201510150369 6 OMED
201950120027 201950120034 6 OMED
202550130179 202550130186 6 OMED
202550130193 202550130206 6 OMED
202620130117 202620130124 6 OMED
202650190124 202650190131 6 OMED
202650190148 202650190155 6 OMED
202650560163 202650560170 6 OMED
HC-067I 11:18 Thursday, October 28, 2004 9
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-67IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
202650560187 202650560194 6 OMED
202750160122 202750160139 6 OMED
202750160146 202750160153 6 OMED
202750160595 202750160608 6 OMED
202750160615 202750160622 6 OMED
202940160115 202940160122 6 OMED
202940160139 202940160146 6 OMED
202940160259 202940160266 6 OMED
202940160273 202940160280 6 OMED
203300140219 203300140226 6 OMED
203300140339 203300140346 6 OMED
203310310256 203310310263 6 OMED
203310310458 203310310465 6 OMED
203310310472 203310310489 6 OMED
203410210144 203410210151 6 OMED
203410210168 203410210175 6 OMED
203450100024 203450100031 6 OMED
203450100106 203450100113 6 OMED
203520150091 203520150104 6 OMED
203960100053 203960100060 6 OMED
203960100231 203960100248 6 OMED
204460190262 204460190279 6 OMED
204490250015 204490250022 6 OMED
204580280030 204580280047 6 OMED
204580280112 204580280129 6 OMED
HC-067I 11:18 Thursday, October 28, 2004 10
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-67IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
204580280136 204580280143 6 OMED
204580280181 204580280198 6 OMED
204580280201 204580280218 6 OMED
204680150064 204680150071 6 OMED
204680150139 204680150146 6 OMED
204910230033 204910230040 6 OMED
204910230057 204910230064 6 OMED
204910230204 204910230211 6 OMED
204910230228 204910230235 6 OMED
205070150146 205070150153 6 OMED
205070150280 205070150297 6 OMED
205150110154 205150110161 6 OMED
205150110178 205150110185 6 OMED
205560200153 205560200160 6 OMED
205690140421 205690140438 6 OMED
205690140445 205690140452 6 OMED
205780100292 205780100305 6 OMED
205780100312 205780100329 6 OMED
205860130063 205860130070 6 OMED
205890360099 205890360102 6 OMED
206150150052 206150150069 6 OMED
206150150292 206150150305 6 OMED
206400270092 206400270105 6 OMED
206440150071 206440150088 6 OMED
206440150204 206440150211 6 OMED
HC-067I 11:18 Thursday, October 28, 2004 11
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-67IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
206440150317 206440150324 6 OMED
206490100637 206490100644 6 OMED
206630270237 206630270244 6 OMED
206680190030 206680190047 6 OMED
206680190441 206680190458 6 OMED
206840120088 206840120095 6 OMED
206840120108 206840120115 6 OMED
206840120177 206840120184 6 OMED
206840120191 206840120204 6 OMED
206840120259 206840120266 6 OMED
206840120273 206840120280 6 OMED
206860190055 206860190062 6 OMED
206860190079 206860190086 6 OMED
207140160197 207140160200 6 OMED
207220190207 207220190214 6 OMED
207220190334 207220190341 6 OMED
207240280092 207240280105 6 OMED
207630150039 207630150046 6 OMED
207630150053 207630150060 6 OMED
207630150111 207630150128 6 OMED
207630150135 207630150142 6 OMED
207630150200 207630150217 6 OMED
207630150224 207630150231 6 OMED
207930280056 207930280063 6 OMED
207930280176 207930280183 6 OMED
HC-067I 11:18 Thursday, October 28, 2004 12
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-67IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
207930280190 207930280203 6 OMED
207930280570 207930280587 6 OMED
207930280594 207930280607 6 OMED
208110150181 208110150198 6 OMED
208110150201 208110150218 6 OMED
208390130032 208390130049 6 OMED
208390130056 208390130063 6 OMED
208890670089 208890670096 6 OMED
208890670109 208890670116 6 OMED
208960230254 208960230261 6 OMED
209120290036 209120290043 6 OMED
209860130065 209860130072 6 OMED
209860130089 209860130096 6 OMED
209860130154 209860130161 6 OMED
209860130178 209860130185 6 OMED
209960290073 209960290080 6 OMED
210130260187 210130260194 6 OMED
210130260207 210130260214 6 OMED
210130260365 210130260372 6 OMED
210130260389 210130260396 6 OMED
HC-067I 11:18 Thursday, October 28, 2004 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
200720190121 200720190138 6 OMED
201070130115 201070130122 6 OMED
201070130266 201070130273 6 OMED
201150170165 201150170172 6 OMED
201150170189 201150170196 6 OMED
201290110034 201290110041 6 OMED
201510150047 201510150054 6 OMED
201510150338 201510150345 6 OMED
202550130179 202550130186 6 OMED
202650190124 202650190131 6 OMED
202650560163 202650560170 6 OMED
202750160146 202750160153 6 OMED
202750160595 202750160608 6 OMED
202940160115 202940160122 6 OMED
202940160259 202940160266 6 OMED
203410210144 203410210151 6 OMED
204580280136 204580280143 6 OMED
204580280181 204580280198 6 OMED
204680150064 204680150071 6 OMED
204910230033 204910230040 6 OMED
204910230228 204910230235 6 OMED
205150110154 205150110161 6 OMED
205690140421 205690140438 6 OMED
205780100312 205780100329 6 OMED
206840120088 206840120095 6 OMED
HC-067I 11:18 Thursday, October 28, 2004 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
206840120177 206840120184 6 OMED
206840120259 206840120266 6 OMED
206860190055 206860190062 6 OMED
207220190207 207220190214 6 OMED
207630150039 207630150046 6 OMED
207630150111 207630150128 6 OMED
207630150200 207630150217 6 OMED
207930280056 207930280063 6 OMED
207930280176 207930280183 6 OMED
207930280570 207930280587 6 OMED
208110150181 208110150198 6 OMED
208390130032 208390130049 6 OMED
208890670089 208890670096 6 OMED
209860130065 209860130072 6 OMED
209860130154 209860130161 6 OMED
210130260187 210130260194 6 OMED
210130260365 210130260372 6 OMED
210690140199 210690140202 6 OMED
210710260072 210710260089 6 OMED
211140160036 211140160043 6 OMED
211240120061 211240120078 6 OMED
211240120256 211240120263 6 OMED
211240120390 211240120403 6 OMED
211550110332 211550110349 6 OMED
211810130654 211810130661 6 OMED
HC-067I 11:18 Thursday, October 28, 2004 15
Sample SAS Job for Example D
sample print of work.pmedids - sorted by linkidx
Obs EVNTIDX LINKIDX EVENTYPE
1 200720190121 200720190138 6 OMED
2 201070130115 201070130122 6 OMED
3 201070130266 201070130273 6 OMED
4 201150170165 201150170172 6 OMED
5 201150170189 201150170196 6 OMED
6 201290110034 201290110041 6 OMED
7 201510150047 201510150054 6 OMED
8 201510150338 201510150345 6 OMED
9 202550130179 202550130186 6 OMED
10 202650190124 202650190131 6 OMED
11 202650560163 202650560170 6 OMED
12 202750160146 202750160153 6 OMED
13 202750160595 202750160608 6 OMED
14 202940160115 202940160122 6 OMED
15 202940160259 202940160266 6 OMED
16 203410210144 203410210151 6 OMED
17 204580280136 204580280143 6 OMED
18 204580280181 204580280198 6 OMED
19 204680150064 204680150071 6 OMED
20 204910230033 204910230040 6 OMED
21 204910230228 204910230235 6 OMED
22 205150110154 205150110161 6 OMED
23 205690140421 205690140438 6 OMED
24 205780100312 205780100329 6 OMED
25 206840120088 206840120095 6 OMED
26 206840120177 206840120184 6 OMED
27 206840120259 206840120266 6 OMED
28 206860190055 206860190062 6 OMED
29 207220190207 207220190214 6 OMED
30 207630150039 207630150046 6 OMED
31 207630150111 207630150128 6 OMED
32 207630150200 207630150217 6 OMED
33 207930280056 207930280063 6 OMED
34 207930280176 207930280183 6 OMED
35 207930280570 207930280587 6 OMED
36 208110150181 208110150198 6 OMED
37 208390130032 208390130049 6 OMED
38 208890670089 208890670096 6 OMED
39 209860130065 209860130072 6 OMED
40 209860130154 209860130161 6 OMED
41 210130260187 210130260194 6 OMED
42 210130260365 210130260372 6 OMED
43 210690140199 210690140202 6 OMED
44 210710260072 210710260089 6 OMED
45 211140160036 211140160043 6 OMED
46 211240120061 211240120078 6 OMED
47 211240120256 211240120263 6 OMED
48 211240120390 211240120403 6 OMED
49 211550110332 211550110349 6 OMED
50 211810130654 211810130661 6 OMED
HC-067I 11:18 Thursday, October 28, 2004 16
Sample SAS Job for Example D
sample print of unique linkidxs in work.pmedids
Obs LINKIDX
1 200720190138
2 201070130122
3 201070130273
4 201150170172
5 201150170196
6 201290110041
7 201510150054
8 201510150345
9 202550130186
10 202650190131
11 202650560170
12 202750160153
13 202750160608
14 202940160122
15 202940160266
16 203410210151
17 204580280143
18 204580280198
19 204680150071
20 204910230040
21 204910230235
22 205150110161
23 205690140438
24 205780100329
25 206840120095
26 206840120184
27 206840120266
28 206860190062
29 207220190214
30 207630150046
31 207630150128
32 207630150217
33 207930280063
34 207930280183
35 207930280587
36 208110150198
37 208390130049
38 208890670096
39 209860130072
40 209860130161
41 210130260194
42 210130260372
43 210690140202
44 210710260089
45 211140160043
46 211240120078
47 211240120263
48 211240120403
49 211550110349
50 211810130661
HC-067I 11:18 Thursday, October 28, 2004 17
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
200720190138 200720190138001 NOVOLIN INSULIN 85.44 2612.831833
200720190138002 NOVOLIN INSULIN 85.44 2612.831833
201070130122 201070130122001 INSULIN REG HUMAN 24.54 21620.734548
201070130273 201070130273001 HUMULIN R (VIAL) 106.24 21620.734548
201150170172 201150170172001 INSULIN REG HUMAN 28.25 7331.777668
201150170196 201150170196001 INSULIN 56.50 7331.777668
201150170196002 INSULIN 56.50 7331.777668
201150170196003 INSULIN 56.50 7331.777668
201150170196004 INSULIN 56.50 7331.777668
201150170196005 INSULIN 56.50 7331.777668
201150170196006 INSULIN 56.50 7331.777668
201150170196007 INSULIN 56.50 7331.777668
201150170196008 INSULIN 56.50 7331.777668
201290110041 201290110041001 INSULIN 56.50 9167.694953
201290110041002 INSULIN 56.50 9167.694953
201510150054 201510150054001 HUMULIN 70/30 (VIAL) 47.39 3187.584836
201510150345 201510150345001 HUMULIN 70/30 (VIAL) 49.63 3187.584836
201510150345002 HUMULIN 70/30 (VIAL) 47.39 3187.584836
201510150345003 HUMULIN 70/30 (VIAL) 49.63 3187.584836
202550130186 202550130186001 HUMULIN 70/30 (VIAL) 69.23 9537.044568
202550130186002 HUMULIN 70/30 (VIAL) 69.23 9537.044568
202550130186003 HUMULIN 70/30 (VIAL) 69.23 9537.044568
202550130186004 HUMULIN 70/30 (VIAL) 69.23 9537.044568
202650190131 202650190131001 INSULIN 56.50 2202.301704
202650190131002 INSULIN 56.50 2202.301704
202650190131003 INSULIN 56.50 2202.301704
202650190131004 INSULIN 56.50 2202.301704
202650560170 202650560170001 INSULIN 56.50 3595.909035
202650560170002 INSULIN 56.50 3595.909035
202650560170003 INSULIN 56.50 3595.909035
202650560170004 INSULIN 56.50 3595.909035
202750160153 202750160153001 NOVOLIN INSULIN 33.50 11669.454487
202750160153002 NOVOLIN INSULIN 33.50 11669.454487
202750160608 202750160608001 INSULIN REG HUMAN 113.00 11669.454487
202750160608002 INSULIN REG HUMAN 113.00 11669.454487
202750160608003 INSULIN REG HUMAN 113.00 11669.454487
HC-067I 11:18 Thursday, October 28, 2004 18
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
202940160122 202940160122001 HUMULIN N (VIAL) 26.59 2830.742845
202940160122002 HUMULIN N (VIAL) 26.59 2830.742845
202940160266 202940160266001 HUMULIN N (VIAL) 26.59 2830.742845
203410210151 203410210151001 INSULIN 56.50 4319.020693
203410210151002 INSULIN 56.50 4319.020693
203410210151003 INSULIN 56.50 4319.020693
203410210151004 INSULIN 56.50 4319.020693
204580280143 204580280143001 HUMALOG (VIAL) 114.21 10839.142625
204580280143002 HUMALOG (VIAL) 114.31 10839.142625
204580280198 204580280198001 HUMALOG (VIAL) 123.45 10839.142625
204680150071 204680150071001 HUMULIN N (VIAL) 25.01 3236.752656
204680150071002 HUMULIN N (VIAL) 25.01 3236.752656
204680150071003 HUMULIN N (VIAL) 25.01 3236.752656
204680150071004 HUMULIN N (VIAL) 25.01 3236.752656
204680150071005 HUMULIN N (VIAL) 25.01 3236.752656
204680150071006 HUMULIN N (VIAL) 25.01 3236.752656
204910230040 204910230040001 HUMALOG (VIAL) 50.09 15303.398114
204910230040002 HUMALOG (VIAL) 50.09 15303.398114
204910230040003 HUMALOG (VIAL) 50.09 15303.398114
204910230040004 HUMALOG (VIAL) 50.09 15303.398114
204910230235 204910230235001 HUMULIN R (VIAL) 26.56 15303.398114
204910230235002 HUMULIN R (VIAL) 26.56 15303.398114
204910230235003 HUMULIN R (VIAL) 26.56 15303.398114
204910230235004 HUMULIN R (VIAL) 26.56 15303.398114
204910230235005 HUMULIN R (VIAL) 26.56 15303.398114
204910230235006 HUMULIN R (VIAL) 26.56 15303.398114
204910230235007 HUMULIN R (VIAL) 26.56 15303.398114
204910230235008 HUMULIN R (VIAL) 26.56 15303.398114
205150110161 205150110161001 HUMULIN N (VIAL) 53.12 3149.284850
205150110161002 HUMULIN N (VIAL) 53.12 3149.284850
205150110161003 HUMULIN N (VIAL) 53.12 3149.284850
205150110161004 HUMULIN N (VIAL) 53.12 3149.284850
205690140438 205690140438001 INSULIN 56.50 2534.065709
205690140438002 INSULIN 56.50 2534.065709
205690140438003 INSULIN 56.50 2534.065709
205690140438004 INSULIN 56.50 2534.065709
205690140438005 INSULIN 56.50 2534.065709
205690140438006 INSULIN 56.50 2534.065709
205780100329 205780100329001 INSULIN 56.50 2013.993709
HC-067I 11:18 Thursday, October 28, 2004 19
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
205780100329 205780100329002 INSULIN 56.50 2013.993709
206840120095 206840120095001 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 28.59 6979.341326
206840120095002 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 28.59 6979.341326
206840120184 206840120184001 INSULIN 56.50 6979.341326
206840120184002 INSULIN 56.50 6979.341326
206840120266 206840120266001 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 100.80 6979.341326
206840120266002 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 100.80 6979.341326
206840120266003 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 100.80 6979.341326
206860190062 206860190062001 INSULIN 56.50 676.014985
206860190062002 INSULIN 56.50 676.014985
207220190214 207220190214001 HUMULIN 50/50 (VIAL) 159.36 4774.778386
207630150046 207630150046001 INSULIN 56.50 27483.314168
207630150046002 INSULIN 56.50 27483.314168
207630150128 207630150128001 INSULIN 56.50 27483.314168
207630150128002 INSULIN 56.50 27483.314168
207630150128003 INSULIN 56.50 27483.314168
207630150128004 INSULIN 56.50 27483.314168
207630150128005 INSULIN 56.50 27483.314168
207630150217 207630150217001 INSULIN 56.50 27483.314168
207630150217002 INSULIN 56.50 27483.314168
207930280063 207930280063001 LANTUS 41.96 12195.822895
207930280183 207930280183001 HUMULIN R 25.99 12195.822895
207930280183002 HUMULIN R 25.99 12195.822895
207930280183003 HUMULIN R 25.99 12195.822895
207930280183004 HUMULIN R 25.99 12195.822895
207930280183005 HUMULIN R 25.99 12195.822895
207930280587 207930280587001 NOVOLIN N 126.03 12195.822895
207930280587002 NOVOLIN N 126.03 12195.822895
207930280587003 NOVOLIN N 126.03 12195.822895
207930280587004 NOVOLIN N 126.03 12195.822895
207930280587005 NOVOLIN N 126.03 12195.822895
207930280587006 NOVOLIN N 126.03 12195.822895
207930280587007 NOVOLIN N 126.03 12195.822895
208110150198 208110150198001 INSULIN 56.50 6376.102194
208110150198002 INSULIN 56.50 6376.102194
208390130049 208390130049001 HUMULIN N (VIAL) 79.68 4133.854314
HC-067I 11:18 Thursday, October 28, 2004 20
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
208890670096 208890670096001 INSULIN 56.50 1064.591057
208890670096002 INSULIN 56.50 1064.591057
208890670096003 INSULIN 56.50 1064.591057
208890670096004 INSULIN 56.50 1064.591057
209860130072 209860130072001 HUMALOG (VIAL) 100.18 8962.990676
209860130072002 HUMALOG (VIAL) 100.18 8962.990676
209860130072003 HUMALOG (VIAL) 100.18 8962.990676
209860130161 209860130161001 HUMALOG (VIAL) 100.18 8962.990676
209860130161002 HUMALOG (VIAL) 100.18 8962.990676
209860130161003 HUMALOG (VIAL) 100.18 8962.990676
209860130161004 HUMALOG (VIAL) 100.18 8962.990676
209860130161005 HUMALOG (VIAL) 100.18 8962.990676
210130260194 210130260194001 INSULIN REG 49.99 5735.151824
210130260194002 INSULIN REG 49.99 5735.151824
210130260194003 INSULIN REG 49.99 5735.151824
210130260194004 INSULIN REG 49.99 5735.151824
210130260372 210130260372001 HUMULIN 70/30 (VIAL) 53.12 5735.151824
210130260372002 HUMULIN 70/30 (VIAL) 26.56 5735.151824
210130260372003 HUMULIN 70/30 (VIAL) 53.12 5735.151824
210130260372004 HUMULIN 70/30 (VIAL) 26.56 5735.151824
210130260372005 HUMULIN 70/30 (VIAL) 53.12 5735.151824
210130260372006 HUMULIN 70/30 (VIAL) 53.12 5735.151824
210130260372007 HUMULIN 70/30 (VIAL) 26.56 5735.151824
210130260372008 HUMULIN 70/30 (VIAL) 53.12 5735.151824
210690140202 210690140202001 INSULIN 56.50 7498.987726
210690140202002 INSULIN 56.50 7498.987726
210710260089 210710260089001 INSULIN NPH-REGULAR 54.59 1390.333896
210710260089002 INSULIN NPH-REGULAR 106.20 1390.333896
211140160043 211140160043001 LANTUS 42.88 20702.535217
211240120078 211240120078001 INSULIN 56.50 7121.783346
211240120078002 INSULIN 56.50 7121.783346
211240120263 211240120263001 INSULIN 26.56 7121.783346
211240120263002 INSULIN 26.56 7121.783346
211240120263003 INSULIN 26.56 7121.783346
211240120263004 INSULIN 26.56 7121.783346
211240120263005 INSULIN 26.56 7121.783346
211240120263006 INSULIN 26.56 7121.783346
211240120403 211240120403001 INSULIN 75.21 7121.783346
211240120403002 INSULIN 75.21 7121.783346
HC-067I 11:18 Thursday, October 28, 2004 21
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
211240120403 211240120403003 INSULIN 75.21 7121.783346
211240120403004 INSULIN 75.21 7121.783346
211240120403005 INSULIN 75.21 7121.783346
211240120403006 INSULIN 75.21 7121.783346
211240120403007 INSULIN 75.21 7121.783346
211550110349 211550110349001 INSULIN REG HUMAN 113.00 1298.502799
211550110349002 INSULIN REG HUMAN 113.00 1298.502799
211550110349003 INSULIN REG HUMAN 113.00 1298.502799
211810130661 211810130661001 INSULIN 56.50 10782.451426
212870140679 212870140679001 HUMULIN R (VIAL) 27.24 3025.084636
212870140679002 HUMULIN R (VIAL) 27.24 3025.084636
212870140679003 HUMULIN R (VIAL) 27.24 3025.084636
212870140679004 HUMULIN R (VIAL) 27.24 3025.084636
212870140679005 HUMULIN R (VIAL) 27.24 3025.084636
212870140679006 HUMULIN R (VIAL) 27.24 3025.084636
212870140679007 HUMULIN R (VIAL) 27.24 3025.084636
212870140679008 HUMULIN R (VIAL) 27.24 3025.084636
212870140679009 HUMULIN R (VIAL) 27.24 3025.084636
212870140679010 HUMULIN R (VIAL) 27.24 3025.084636
212870140679011 HUMULIN R (VIAL) 27.24 3025.084636
212870140679012 HUMULIN R (VIAL) 27.24 3025.084636
212870140679013 HUMULIN R (VIAL) 27.24 3025.084636
212870140679014 HUMULIN R (VIAL) 27.24 3025.084636
212870140679015 HUMULIN R (VIAL) 27.24 3025.084636
212870140679016 HUMULIN R (VIAL) 27.24 3025.084636
212870140679017 HUMULIN R (VIAL) 27.24 3025.084636
213150200228 213150200228001 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 94.72 4322.255432
213150200228002 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 94.72 4322.255432
213150200228003 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 94.72 4322.255432
213150200393 213150200393001 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 101.96 4322.255432
213150200393002 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 101.96 4322.255432
213150200393003 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 101.96 4322.255432
213150200393004 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 101.96 4322.255432
213150200393005 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 101.96 4322.255432
213150200393006 HUMALOG MIX 75/25 PEN (PREFILLED DISPOSABLE) 101.96 4322.255432
213370190059 213370190059001 INSULIN REG HUMAN 113.00 10594.159083
213370190206 213370190206001 INSULIN REG HUMAN 28.25 10594.159083
213700330037 213700330037001 INSULIN 56.50 6435.851684
213700330140 213700330140001 HUMULIN R (VIAL) 24.00 6435.851684
213700330140002 HUMULIN R (VIAL) 24.00 6435.851684
HC-067I 11:18 Thursday, October 28, 2004 22
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-067A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP02X PERWT02F
213700330140 213700330140003 HUMULIN R (VIAL) 24.00 6435.851684
213700330140004 HUMULIN R (VIAL) 24.00 6435.851684
213700330140005 HUMULIN R (VIAL) 24.00 6435.851684
213700330140006 HUMULIN R (VIAL) 24.00 6435.851684
213700330140007 HUMULIN R (VIAL) 24.00 6435.851684
214240110435 214240110435001 INSULIN 56.50 9696.980668
214400140066 214400140066001 HUMULIN N (VIAL) 53.50 4256.634182
214400140066002 HUMULIN N (VIAL) 53.50 4256.634182
214400140066003 HUMULIN N (VIAL) 53.50 4256.634182
214400140066004 HUMULIN N (VIAL) 53.50 4256.634182
HC-067I 11:18 Thursday, October 28, 2004 23
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
The MEANS Procedure
Analysis Variable : RXXP02X SUM OF PAYMENTS RXSF02X-RXOU02X(IMPUTED)
N Sum
--------------------
2372 141423.50
--------------------
HC-067I 11:18 Thursday, October 28, 2004 24
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
Weighted
The MEANS Procedure
Analysis Variable : RXXP02X SUM OF PAYMENTS RXSF02X-RXOU02X(IMPUTED)
N Sum
--------------------
2372 1006392685
--------------------
<< previous page
|