1 The SAS System 11:33 Wednesday, December 19, 2001
NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 6.12 TS060
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC, Site 0026405003.
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-026I";
4 TITLE2 'Sample SAS Job for Example A';
5
6 LIBNAME IN 'C:\';
NOTE: Directory for library IN contains files of mixed engine types.
NOTE: Libref IN was successfully assigned as follows:
Engine: V612
Physical Name: C:\
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: The PROCEDURE FORMAT used 0.05 seconds.
24
25 *-------------------------------------------------------------------------------------
26 * Get condition records coded as asthma.
27 *-------------------------------------------------------------------------------------;
28 DATA ASCONDS;
29 SET IN.H27 (KEEP=CONDIDX CCCODEX);
30 IF CCCODEX="128";
31
32 RUN;
NOTE: The data set WORK.ASCONDS has 1243 observations and 2 variables.
NOTE: The DATA statement used 0.59 seconds.
33
34 *------------------------------------------------------------------------------------
35 * Get the events linked to each of the asthma condition records.
36 *------------------------------------------------------------------------------------;
37 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
2 The SAS System 11:33 Wednesday, December 19, 2001
NOTE: The data set WORK.ASCONDS has 1243 observations and 2 variables.
NOTE: The PROCEDURE SORT used 0.17 seconds.
38
39 proc print data=asconds (obs=50);
40 title3 "sample print of work.asconds - sorted by condidx";
41 title4 "COND (H27) records where cccodex=128";
42 run;
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: The PROCEDURE PRINT used 0.38 seconds.
43
44 PROC SORT DATA=IN.H26IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: The data set WORK.CLNK has 219144 observations and 5 variables.
NOTE: The PROCEDURE SORT used 3.85 seconds.
45
46 DATA ASCLNKS;
47 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
48 ASCONDS(IN=INASCOND KEEP=CONDIDX);
49 BY CONDIDX;
50 IF INCLNK & INASCOND;
51 RUN;
NOTE: The data set WORK.ASCLNKS has 4817 observations and 3 variables.
NOTE: The DATA statement used 1.32 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: The PROCEDURE PRINT printed pages 2-3.
NOTE: The PROCEDURE PRINT used 0.11 seconds.
60
61 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: The data set WORK.ASCLNKS has 4817 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.1 seconds.
62
63 proc print data=asclnks (obs=50);
64 format eventype eventype.;
3 The SAS System 11:33 Wednesday, December 19, 2001
65 title3 "sample print of work.asclnks - sorted by evntidx";
66 run;
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
67
68 DATA ASCLNKS;
69 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
70 BY EVNTIDX;
71 IF FIRST.EVNTIDX;
72 RUN;
NOTE: The data set WORK.ASCLNKS has 4807 observations and 2 variables.
NOTE: The DATA statement used 0.11 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: The PROCEDURE PRINT printed page 5.
NOTE: The PROCEDURE PRINT used 0.05 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.H26GF1 (KEEP=EVNTIDX WTDPER98 SEETLKPV);
84 IF WTDPER98 > 0 & SEETLKPV NE 2;
85 RUN;
NOTE: The data set WORK.MVIS has 101135 observations and 3 variables.
NOTE: The DATA statement used 1.04 seconds.
86
87 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: The data set WORK.MVIS has 101135 observations and 3 variables.
NOTE: The PROCEDURE SORT used 1.04 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;
4 The SAS System 11:33 Wednesday, December 19, 2001
97 RUN;
NOTE: The data set WORK.ASMVIS has 1608 observations and 2 variables.
NOTE: The DATA statement used 0.44 seconds.
98
99 proc print data=asmvis (obs=50);
100 format eventype eventype.;
101 title3 "sample print of work.asmvis";
102 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-026G) events";
103 run;
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
104
105 *-------------------------------------------------------------------------------------
106 * Get PMED IDs linked to the MVIS events which were for asthma.
107 *-------------------------------------------------------------------------------------;
108 PROC SORT DATA=IN.H26IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: The data set WORK.RXLK has 41264 observations and 5 variables.
NOTE: The PROCEDURE SORT used 0.7 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 eventidx";
116 title4 "Rx+event link file records (HC-26IF2)";
117 run;
NOTE: The PROCEDURE PRINT printed pages 7-11.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
118
119 DATA PMEDIDS;
120 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
121 ASMVIS(IN=INASMVIS KEEP=EVNTIDX);
122 BY EVNTIDX;
123 IF INRXLK & INASMVIS;
124 RUN;
NOTE: The data set WORK.PMEDIDS has 1241 observations and 3 variables.
NOTE: The DATA statement used 0.33 seconds.
125
126 proc print data=pmedids (obs=50);
127 by evntidx;
128 id evntidx;
5 The SAS System 11:33 Wednesday, December 19, 2001
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: The PROCEDURE PRINT printed pages 12-13.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
133
134 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: The data set WORK.PMEDIDS has 1241 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.11 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: The PROCEDURE PRINT printed page 14.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
140
141 DATA PMEDIDS;
142 SET PMEDIDS (KEEP=LINKIDX);
143 BY LINKIDX;
144 IF FIRST.LINKIDX;
145 RUN;
NOTE: The data set WORK.PMEDIDS has 1147 observations and 1 variables.
NOTE: The DATA statement used 0.17 seconds.
146
147 proc print data=pmedids (obs=50);
148 title3 "sample print of unique linkidxs in work.pmedids";
149 run;
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
150
151 *-----------------------------------------------------------------------------------------
152 * Get PMED records linked to MVIS events which were for asthma.
153 *-----------------------------------------------------------------------------------------;
154 PROC SORT DATA=IN.H26A OUT=PMED; BY LINKIDX; RUN;
NOTE: The data set WORK.PMED has 172031 observations and 51 variables.
NOTE: The PROCEDURE SORT used 26.85 seconds.
155
6 The SAS System 11:33 Wednesday, December 19, 2001
156 DATA MVPMEDS;
157 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP98X WTDPER98 RXNAME)
158 PMEDIDS (IN=A);
159 BY LINKIDX;
160 IF A;
161 RUN;
NOTE: The data set WORK.MVPMEDS has 2807 observations and 5 variables.
NOTE: The DATA statement used 1.63 seconds.
162
163 proc print data=mvpmeds (obs=200);
164 var rxrecidx rxname RXXP98X WTDPER98;
165 by linkidx;
166 id linkidx;
167 title3 "sample print of work.mvpmeds";
168 title4 "PMED (HC-026A) records for unique linkidxs in work.pmedids";
169 run;
NOTE: The PROCEDURE PRINT printed pages 16-22.
NOTE: The PROCEDURE PRINT used 0.11 seconds.
170
171 PROC MEANS DATA=MVPMEDS N SUM;
172 VAR RXXP98X;
173 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
174 RUN;
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
175
176 PROC MEANS DATA=MVPMEDS N SUM;
177 VAR RXXP98X;
178 WEIGHT WTDPER98;
179 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
180 TITLE5 "Weighted";
181 RUN;
NOTE: The PROCEDURE MEANS printed page 24.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
182
183
184
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-026I 11:33 Wednesday, December 19, 2001 1
Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H27) records where cccodex=128
OBS CONDIDX CCCODEX
1 300090440043 128
2 300250280014 128
3 300440450027 128
4 300440510027 128
5 300650110034 128
6 300760110011 128
7 300790330011 128
8 300820410011 128
9 300820660046 128
10 300850210026 128
11 300850280035 128
12 300860170094 128
13 300930200025 128
14 300930200047 128
15 300930370030 128
16 301130110028 128
17 301170150039 128
18 301440390013 128
19 301730670017 128
20 301740160080 128
21 301740460022 128
22 301740790033 128
23 301740870019 128
24 301750330049 128
25 301750330061 128
26 301770320016 128
27 301780410013 128
28 301800150035 128
29 301890170054 128
30 301910480036 128
31 301910540014 128
32 302100140091 128
33 302100210012 128
34 302190490020 128
35 302230180020 128
36 302340400020 128
37 302340560014 128
38 302580120069 128
39 302690390085 128
40 302850180127 128
41 302850250029 128
42 302870290014 128
43 302880230064 128
44 303170330027 128
45 303260180027 128
46 303320110064 128
47 303370440041 128
48 303370440079 128
49 303490470019 128
50 303490530031 128
HC-026I 11:33 Wednesday, December 19, 2001 2
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
300250280014 300250280030 3 EROM
300250280047 1 MVIS
300250280085 8 PMED
300440450027 300440450091 8 PMED
300440510027 300440510016 1 MVIS
300440510023 8 PMED
300760110011 300760110303 8 PMED
300760110365 7 HVIS
300760110416 7 HVIS
300790330011 300790330230 8 PMED
300790330247 8 PMED
300790330292 1 MVIS
300790330312 8 PMED
300790330329 8 PMED
300790330336 8 PMED
300790330343 8 PMED
300820660046 300820660030 8 PMED
300850210026 300850210050 1 MVIS
300850210081 8 PMED
300860170094 300860170243 2 OPAT
300860170370 8 PMED
300860170387 8 PMED
300860170394 8 PMED
300930200025 300930200016 3 EROM
300930200061 8 PMED
300930200047 300930200030 3 EROM
300930200047 3 EROM
300930200054 8 PMED
300930370030 300930370047 8 PMED
301130110028 301130110052 8 PMED
301130110076 8 PMED
301170150039 301170150172 8 PMED
301170150230 8 PMED
301170150261 8 PMED
301730670017 301730670064 8 PMED
HC-026I 11:33 Wednesday, December 19, 2001 3
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
301740160080 301740160294 8 PMED
301740160369 8 PMED
301740160403 8 PMED
301740160427 8 PMED
301740460022 301740460175 8 PMED
301740460219 8 PMED
301740790033 301740790173 1 MVIS
301740790180 8 PMED
301740790197 8 PMED
301740790231 8 PMED
301740870019 301740870165 8 PMED
301740870172 8 PMED
301750330049 301750330108 1 MVIS
301750330122 8 PMED
301750330139 8 PMED
301750330160 1 MVIS
301750330177 8 PMED
301750330061 301750330160 1 MVIS
301780410013 301780410035 1 MVIS
301800150035 301800150195 8 PMED
301800150208 8 PMED
301890170054 301890170238 8 PMED
301890170245 8 PMED
301890170252 8 PMED
301890170303 1 MVIS
301890170310 1 MVIS
301890170327 1 MVIS
301890170334 1 MVIS
301890170341 1 MVIS
301890170358 1 MVIS
301890170365 1 MVIS
301890170485 8 PMED
301890170492 8 PMED
301890170505 8 PMED
301890170567 8 PMED
301890170574 8 PMED
301890170581 8 PMED
302100140091 302100140256 1 MVIS
302100140263 1 MVIS
302100140270 1 MVIS
HC-026I 11:33 Wednesday, December 19, 2001 4
Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx
OBS CONDIDX EVNTIDX EVENTYPE
1 300250280014 300250280030 3 EROM
2 300250280014 300250280047 1 MVIS
3 300250280014 300250280085 8 PMED
4 300440450027 300440450091 8 PMED
5 300440510027 300440510016 1 MVIS
6 300440510027 300440510023 8 PMED
7 300760110011 300760110303 8 PMED
8 300760110011 300760110365 7 HVIS
9 300760110011 300760110416 7 HVIS
10 300790330011 300790330230 8 PMED
11 300790330011 300790330247 8 PMED
12 300790330011 300790330292 1 MVIS
13 300790330011 300790330312 8 PMED
14 300790330011 300790330329 8 PMED
15 300790330011 300790330336 8 PMED
16 300790330011 300790330343 8 PMED
17 300820660046 300820660030 8 PMED
18 300850210026 300850210050 1 MVIS
19 300850210026 300850210081 8 PMED
20 300860170094 300860170243 2 OPAT
21 300860170094 300860170370 8 PMED
22 300860170094 300860170387 8 PMED
23 300860170094 300860170394 8 PMED
24 300930200025 300930200016 3 EROM
25 300930200047 300930200030 3 EROM
26 300930200047 300930200047 3 EROM
27 300930200047 300930200054 8 PMED
28 300930200025 300930200061 8 PMED
29 300930370030 300930370047 8 PMED
30 301130110028 301130110052 8 PMED
31 301130110028 301130110076 8 PMED
32 301170150039 301170150172 8 PMED
33 301170150039 301170150230 8 PMED
34 301170150039 301170150261 8 PMED
35 301730670017 301730670064 8 PMED
36 301740160080 301740160294 8 PMED
37 301740160080 301740160369 8 PMED
38 301740160080 301740160403 8 PMED
39 301740160080 301740160427 8 PMED
40 301740460022 301740460175 8 PMED
41 301740460022 301740460219 8 PMED
42 301740790033 301740790173 1 MVIS
43 301740790033 301740790180 8 PMED
44 301740790033 301740790197 8 PMED
45 301740790033 301740790231 8 PMED
46 301740870019 301740870165 8 PMED
47 301740870019 301740870172 8 PMED
48 301750330049 301750330108 1 MVIS
49 301750330049 301750330122 8 PMED
50 301750330049 301750330139 8 PMED
HC-026I 11:33 Wednesday, December 19, 2001 5
Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks
OBS EVNTIDX EVENTYPE
1 300250280030 3 EROM
2 300250280047 1 MVIS
3 300250280085 8 PMED
4 300440450091 8 PMED
5 300440510016 1 MVIS
6 300440510023 8 PMED
7 300760110303 8 PMED
8 300760110365 7 HVIS
9 300760110416 7 HVIS
10 300790330230 8 PMED
11 300790330247 8 PMED
12 300790330292 1 MVIS
13 300790330312 8 PMED
14 300790330329 8 PMED
15 300790330336 8 PMED
16 300790330343 8 PMED
17 300820660030 8 PMED
18 300850210050 1 MVIS
19 300850210081 8 PMED
20 300860170243 2 OPAT
21 300860170370 8 PMED
22 300860170387 8 PMED
23 300860170394 8 PMED
24 300930200016 3 EROM
25 300930200030 3 EROM
26 300930200047 3 EROM
27 300930200054 8 PMED
28 300930200061 8 PMED
29 300930370047 8 PMED
30 301130110052 8 PMED
31 301130110076 8 PMED
32 301170150172 8 PMED
33 301170150230 8 PMED
34 301170150261 8 PMED
35 301730670064 8 PMED
36 301740160294 8 PMED
37 301740160369 8 PMED
38 301740160403 8 PMED
39 301740160427 8 PMED
40 301740460175 8 PMED
41 301740460219 8 PMED
42 301740790173 1 MVIS
43 301740790180 8 PMED
44 301740790197 8 PMED
45 301740790231 8 PMED
46 301740870165 8 PMED
47 301740870172 8 PMED
48 301750330108 1 MVIS
49 301750330122 8 PMED
50 301750330139 8 PMED
HC-026I 11:33 Wednesday, December 19, 2001 6
Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-026G) events
OBS EVNTIDX EVENTYPE
1 300250280047 1 MVIS
2 300440510016 1 MVIS
3 300790330292 1 MVIS
4 300850210050 1 MVIS
5 301740790173 1 MVIS
6 301750330108 1 MVIS
7 301750330160 1 MVIS
8 301780410035 1 MVIS
9 301890170303 1 MVIS
10 301890170310 1 MVIS
11 301890170327 1 MVIS
12 301890170334 1 MVIS
13 301890170341 1 MVIS
14 301890170358 1 MVIS
15 301890170365 1 MVIS
16 302100140256 1 MVIS
17 302100140263 1 MVIS
18 302100140270 1 MVIS
19 302100140287 1 MVIS
20 302100140321 1 MVIS
21 302190490106 1 MVIS
22 302340560416 1 MVIS
23 302580120173 1 MVIS
24 302850180545 1 MVIS
25 302850180552 1 MVIS
26 302850180569 1 MVIS
27 302850180576 1 MVIS
28 302850250090 1 MVIS
29 302880230603 1 MVIS
30 303260180222 1 MVIS
31 303540380056 1 MVIS
32 303650250102 1 MVIS
33 303650250119 1 MVIS
34 303650250126 1 MVIS
35 303650250133 1 MVIS
36 303650250140 1 MVIS
37 303670160641 1 MVIS
38 303670160658 1 MVIS
39 303670160665 1 MVIS
40 303670160672 1 MVIS
41 303670160689 1 MVIS
42 303670160730 1 MVIS
43 304040160399 1 MVIS
44 304040160515 1 MVIS
45 304040160522 1 MVIS
46 304660390140 1 MVIS
47 304730420519 1 MVIS
48 304730420526 1 MVIS
49 304820210012 1 MVIS
50 304820210067 1 MVIS
HC-026I 11:33 Wednesday, December 19, 2001 7
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-26IF2)
EVNTIDX LINKIDX EVENTYPE
300010160237 300010160268 2 OPAT
300010160371 300010160446 1 MVIS
300010160453 1 MVIS
300010160460 1 MVIS
300010160477 1 MVIS
300010160484 1 MVIS
300010160422 300010160439 6 OMED
300010230220 300010230251 1 MVIS
300010230237 300010230268 5 DVIS
300010230282 300010230302 1 MVIS
300010230319 1 MVIS
300010230299 300010230302 1 MVIS
300010230319 1 MVIS
300010230326 300010230333 1 MVIS
300010230340 1 MVIS
300010300100 300010300117 1 MVIS
300010300124 1 MVIS
300010300131 1 MVIS
300010300148 1 MVIS
300010300162 300010300193 1 MVIS
300010300206 1 MVIS
300010300213 1 MVIS
300010300220 1 MVIS
300010300179 300010300237 3 EROM
300010300244 300010300268 1 MVIS
300010300275 1 MVIS
300010300282 1 MVIS
300010300299 1 MVIS
300040160522 300040160680 4 STAZ
300040160697 4 STAZ
300040160539 300040160680 4 STAZ
300040160700 4 STAZ
300040160577 300040160680 1 MVIS
300040160957 300040161032 1 MVIS
HC-026I 11:33 Wednesday, December 19, 2001 8
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-26IF2)
EVNTIDX LINKIDX EVENTYPE
300040160957 300040161049 1 MVIS
300040161056 1 MVIS
300040161063 1 MVIS
300040161070 1 MVIS
300040161087 1 MVIS
300040161094 1 MVIS
300050150140 300050150164 1 MVIS
300050220222 300050220239 4 STAZ
300050220284 300050220304 1 MVIS
300050390486 300050390513 3 EROM
300050390493 300050390520 1 MVIS
300060120555 300060120644 1 MVIS
300060120682 300060120702 4 STAZ
300060120719 4 STAZ
300060120726 4 STAZ
300060120733 4 STAZ
300060120740 4 STAZ
300080250050 300080250074 1 MVIS
300080320067 300080320074 1 MVIS
300090130472 300090130516 1 MVIS
300090130523 1 MVIS
300090440136 300090440201 1 MVIS
300090440218 1 MVIS
300120310032 300120310049 3 EROM
300130250076 300130250090 1 MVIS
300130250103 1 MVIS
300130320134 300130320172 3 EROM
300130320189 3 EROM
300130320230 300130320247 1 MVIS
300130490110 300130490134 1 MVIS
300140210482 300140210502 5 DVIS
HC-026I 11:33 Wednesday, December 19, 2001 9
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-26IF2)
EVNTIDX LINKIDX EVENTYPE
300170100072 300170100096 1 MVIS
300170100116 300170100109 1 MVIS
300170270109 300170270325 5 DVIS
300170270161 300170270332 4 STAZ
300170270349 4 STAZ
300170270356 4 STAZ
300170270363 4 STAZ
300170270370 4 STAZ
300170270387 4 STAZ
300190190266 300190190348 2 OPAT
300190190300 300190190355 1 MVIS
300190190362 1 MVIS
300190190379 1 MVIS
300190190386 1 MVIS
300200180389 300200180423 1 MVIS
300200180430 1 MVIS
300200180447 1 MVIS
300200180396 300200180454 1 MVIS
300200180409 300200180416 6 OMED
300200180461 300200180485 1 MVIS
300200180492 1 MVIS
300200180505 1 MVIS
300200180512 1 MVIS
300200180478 300200180492 1 MVIS
300200180505 1 MVIS
300200180529 1 MVIS
300230150194 300230150207 1 MVIS
300230220081 300230220125 3 EROM
300230220098 300230220132 1 MVIS
300230220149 300230220170 1 MVIS
300230220163 300230220170 2 OPAT
300240180434 300240180578 4 STAZ
300240180585 4 STAZ
HC-026I 11:33 Wednesday, December 19, 2001 10
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-26IF2)
EVNTIDX LINKIDX EVENTYPE
300240180434 300240180592 4 STAZ
300240180605 4 STAZ
300240180612 4 STAZ
300240180530 300240180547 6 OMED
300240180554 300240180561 6 OMED
300240180667 300240180807 1 MVIS
300240180814 1 MVIS
300240180821 1 MVIS
300240180838 1 MVIS
300240180845 1 MVIS
300240180852 1 MVIS
300240180869 1 MVIS
300240180787 300240180794 6 OMED
300250110181 300250110249 1 MVIS
300250110201 300250110218 6 OMED
300250110225 300250110232 6 OMED
300250110263 300250110270 6 OMED
300250110287 300250110294 6 OMED
300250280030 300250280054 3 EROM
300250280061 3 EROM
300250280078 3 EROM
300250280085 3 EROM
300250280092 300250280129 3 EROM
300250280105 300250280136 1 MVIS
300270190357 300270190408 1 MVIS
300270260124 300270260213 1 MVIS
300270260162 300270260220 1 MVIS
300280130104 300280130128 1 MVIS
300280130142 1 MVIS
300330100583 300330100665 1 MVIS
300330100627 300330100672 4 STAZ
HC-026I 11:33 Wednesday, December 19, 2001 11
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-26IF2)
EVNTIDX LINKIDX EVENTYPE
300330100689 300330100747 4 STAZ
300330100723 300330100754 1 MVIS
300330100761 1 MVIS
300330100778 1 MVIS
300330100730 300330100785 1 MVIS
300350180350 300350180463 2 OPAT
300350180401 300350180470 1 MVIS
300350180487 1 MVIS
300370140092 300370140129 1 MVIS
300370210030 300370210054 1 MVIS
300370210061 1 MVIS
HC-026I 11:33 Wednesday, December 19, 2001 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
300440510016 300440510023 1 MVIS
300790330292 300790330305 1 MVIS
300850210050 300850210081 1 MVIS
301740790173 301740790180 1 MVIS
301740790197 1 MVIS
301740790200 1 MVIS
301740790217 1 MVIS
301740790224 1 MVIS
301740790231 1 MVIS
301750330108 301750330122 1 MVIS
301750330139 1 MVIS
301750330160 301750330177 1 MVIS
301890170303 301890170423 1 MVIS
301890170430 1 MVIS
301890170447 1 MVIS
301890170310 301890170454 1 MVIS
301890170358 301890170461 1 MVIS
301890170365 301890170447 1 MVIS
302100140256 302100140294 1 MVIS
302100140307 1 MVIS
302100140314 1 MVIS
302100140321 302100140345 1 MVIS
302100140352 1 MVIS
302190490106 302190490120 1 MVIS
302340560416 302340560423 1 MVIS
302850180569 302850180627 1 MVIS
302850180634 1 MVIS
302850180576 302850180627 1 MVIS
302850180634 1 MVIS
302850250090 302850250103 1 MVIS
302880230603 302880230627 1 MVIS
HC-026I 11:33 Wednesday, December 19, 2001 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
303260180222 303260180239 1 MVIS
303540380056 303540380070 1 MVIS
303650250119 303650250171 1 MVIS
303650250188 1 MVIS
303650250133 303650250195 1 MVIS
303650250208 1 MVIS
303650250215 1 MVIS
304040160515 304040160546 1 MVIS
304040160553 1 MVIS
304040160522 304040160560 1 MVIS
304730420519 304730420533 1 MVIS
304730420540 1 MVIS
304730420557 1 MVIS
304730420564 1 MVIS
304730420571 1 MVIS
304730420588 1 MVIS
304730420595 1 MVIS
304730420526 304730420533 1 MVIS
304730420557 1 MVIS
HC-026I 11:33 Wednesday, December 19, 2001 14
Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx
OBS EVNTIDX LINKIDX EVENTYPE
1 300440510016 300440510023 1 MVIS
2 300790330292 300790330305 1 MVIS
3 300850210050 300850210081 1 MVIS
4 301740790173 301740790180 1 MVIS
5 301740790173 301740790197 1 MVIS
6 301740790173 301740790200 1 MVIS
7 301740790173 301740790217 1 MVIS
8 301740790173 301740790224 1 MVIS
9 301740790173 301740790231 1 MVIS
10 301750330108 301750330122 1 MVIS
11 301750330108 301750330139 1 MVIS
12 301750330160 301750330177 1 MVIS
13 301890170303 301890170423 1 MVIS
14 301890170303 301890170430 1 MVIS
15 301890170303 301890170447 1 MVIS
16 301890170365 301890170447 1 MVIS
17 301890170310 301890170454 1 MVIS
18 301890170358 301890170461 1 MVIS
19 302100140256 302100140294 1 MVIS
20 302100140256 302100140307 1 MVIS
21 302100140256 302100140314 1 MVIS
22 302100140321 302100140345 1 MVIS
23 302100140321 302100140352 1 MVIS
24 302190490106 302190490120 1 MVIS
25 302340560416 302340560423 1 MVIS
26 302850180569 302850180627 1 MVIS
27 302850180576 302850180627 1 MVIS
28 302850180569 302850180634 1 MVIS
29 302850180576 302850180634 1 MVIS
30 302850250090 302850250103 1 MVIS
31 302880230603 302880230627 1 MVIS
32 303260180222 303260180239 1 MVIS
33 303540380056 303540380070 1 MVIS
34 303650250119 303650250171 1 MVIS
35 303650250119 303650250188 1 MVIS
36 303650250133 303650250195 1 MVIS
37 303650250133 303650250208 1 MVIS
38 303650250133 303650250215 1 MVIS
39 304040160515 304040160546 1 MVIS
40 304040160515 304040160553 1 MVIS
41 304040160522 304040160560 1 MVIS
42 304730420519 304730420533 1 MVIS
43 304730420526 304730420533 1 MVIS
44 304730420519 304730420540 1 MVIS
45 304730420519 304730420557 1 MVIS
46 304730420526 304730420557 1 MVIS
47 304730420519 304730420564 1 MVIS
48 304730420526 304730420564 1 MVIS
49 304730420519 304730420571 1 MVIS
50 304730420526 304730420571 1 MVIS
HC-026I 11:33 Wednesday, December 19, 2001 15
Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids
OBS LINKIDX
1 300440510023
2 300790330305
3 300850210081
4 301740790180
5 301740790197
6 301740790200
7 301740790217
8 301740790224
9 301740790231
10 301750330122
11 301750330139
12 301750330177
13 301890170423
14 301890170430
15 301890170447
16 301890170454
17 301890170461
18 302100140294
19 302100140307
20 302100140314
21 302100140345
22 302100140352
23 302190490120
24 302340560423
25 302850180627
26 302850180634
27 302850250103
28 302880230627
29 303260180239
30 303540380070
31 303650250171
32 303650250188
33 303650250195
34 303650250208
35 303650250215
36 304040160546
37 304040160553
38 304040160560
39 304730420533
40 304730420540
41 304730420557
42 304730420564
43 304730420571
44 304730420588
45 304730420595
46 304820210029
47 304820210036
48 304820210043
49 304820210050
50 304820210074
HC-026I 11:33 Wednesday, December 19, 2001 16
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
300440510023 300440510023001 ALBUTEROL SULFATE 10.69 16284.45
300790330305 300790330305001 EXGEST LA 5.00 1186.13
300850210081 300850210081001 -9 3.00 3325.32
301740790180 301740790180001 SEREVENT 57.08 3457.53
301740790197 301740790197001 AZMACORT 133.09 3457.53
301740790200 301740790200001 CLARITIN-D 12HR 68.86 3457.53
301740790217 301740790217001 FLONASE 164.50 3457.53
301740790224 301740790224001 ZYRTEC 99.95 3457.53
301740790231 301740790231001 ALBUTEROL 84.63 3457.53
301750330122 301750330122001 -9 13.33 19819.94
301750330139 301750330139001 BIAXIN 25.97 19819.94
301750330177 301750330177001 ANTIBIOTIC 14.95 19819.94
301890170423 301890170423001 ZESTRIL 161.26 15961.99
301890170423002 ZESTRIL 50.48 15961.99
301890170423003 ZESTRIL 161.26 15961.99
301890170423004 ZESTRIL 50.48 15961.99
301890170430 301890170430001 K-DUR 15.54 15961.99
301890170430002 K-DUR 15.22 15961.99
301890170430003 K-DUR 15.54 15961.99
301890170430004 K-DUR 15.22 15961.99
301890170430005 K-DUR 15.54 15961.99
301890170430006 K-DUR 15.54 15961.99
301890170430007 K-DUR 15.54 15961.99
301890170430008 K-DUR 15.54 15961.99
301890170430009 K-DUR 15.54 15961.99
301890170430010 K-DUR 15.22 15961.99
301890170430011 K-DUR 15.22 15961.99
301890170447 301890170447001 FUROSEMIDE 4.55 15961.99
301890170447002 FUROSEMIDE 4.55 15961.99
301890170447003 FUROSEMIDE 4.55 15961.99
301890170447004 FUROSEMIDE 4.55 15961.99
301890170447005 FUROSEMIDE 4.55 15961.99
301890170447006 FUROSEMIDE 4.55 15961.99
301890170447007 FUROSEMIDE 4.55 15961.99
301890170447008 FUROSEMIDE 4.55 15961.99
HC-026I 11:33 Wednesday, December 19, 2001 17
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
301890170454 301890170454001 LANOXIN 9.69 15961.99
301890170454002 LANOXIN 9.69 15961.99
301890170454003 LANOXIN 9.69 15961.99
301890170454004 LANOXIN 9.69 15961.99
301890170454005 LANOXIN 9.69 15961.99
301890170461 301890170461001 COZAAR 68.28 15961.99
301890170461002 COZAAR 68.28 15961.99
301890170461003 COZAAR 68.28 15961.99
302100140294 302100140294001 FLUOCINONIDE 12.40 1458.81
302100140294002 FLUOCINONIDE 12.40 1458.81
302100140307 302100140307001 AMBIEN 24.55 1458.81
302100140307002 AMBIEN 24.55 1458.81
302100140307003 AMBIEN 24.55 1458.81
302100140307004 AMBIEN 24.55 1458.81
302100140314 302100140314001 HYDROXYZINE 24.73 1458.81
302100140345 302100140345001 NAPROXEN 11.67 1458.81
302100140345002 NAPROXEN 11.67 1458.81
302100140345003 NAPROXEN 11.67 1458.81
302100140352 302100140352001 APAP/CODINE 8.20 1458.81
302190490120 302190490120001 VENTOLIN ROTACAPS 35.76 9465.66
302190490120002 VENTOLIN ROTACAPS 35.76 9465.66
302340560423 302340560423001 BECONASE AQ 53.99 3309.39
302850180627 302850180627001 PROZAC 65.29 8106.00
302850180627002 PROZAC 65.29 8106.00
302850180627003 PROZAC 129.07 8106.00
302850180627004 PROZAC 65.29 8106.00
302850180627005 PROZAC 129.07 8106.00
302850180634 302850180634001 GLUCOPHAGE 28.91 8106.00
302850180634002 GLUCOPHAGE 28.91 8106.00
302850250103 302850250103001 CLARITIN 30.85 9943.89
302880230627 302880230627001 MOTRIN 11.73 5807.26
303260180239 303260180239001 SEREVENT 58.33 25618.20
303540380070 303540380070001 TUSSORGANIDIN DM 17.47 5838.47
303650250171 303650250171001 TILADE INHALER 66.85 19458.95
HC-026I 11:33 Wednesday, December 19, 2001 18
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
303650250171 303650250171002 TILADE INHALER 66.85 19458.95
303650250188 303650250188001 AEROCHAMBER 27.84 19458.95
303650250195 303650250195001 RHINOCORT 34.45 19458.95
303650250195002 RHINOCORT 34.45 19458.95
303650250208 303650250208001 AUGMENTIN 43.23 19458.95
303650250215 303650250215001 SINGULAIR 66.96 19458.95
303650250215002 SINGULAIR 66.96 19458.95
303650250215003 SINGULAIR 66.96 19458.95
304040160546 304040160546001 TOPROL XL 30.11 8340.92
304040160553 304040160553001 LOTREL 82.07 8340.92
304040160560 304040160560001 ALBUTEROL 21.41 8340.92
304040160560002 ALBUTEROL 21.41 8340.92
304730420533 304730420533001 ALBUTEROL 16.78 13574.99
304730420533002 ALBUTEROL 16.78 13574.99
304730420533003 ALBUTEROL 16.78 13574.99
304730420533004 ALBUTEROL 16.78 13574.99
304730420533005 ALBUTEROL 16.78 13574.99
304730420540 304730420540001 SODIUM CHLORIDE 8.95 13574.99
304730420540002 SODIUM CHLORIDE 8.95 13574.99
304730420540003 SODIUM CHLORIDE 8.95 13574.99
304730420540004 SODIUM CHLORIDE 8.95 13574.99
304730420540005 SODIUM CHLORIDE 8.95 13574.99
304730420557 304730420557001 PROVENTIL 13.50 13574.99
304730420557002 PROVENTIL 13.50 13574.99
304730420557003 PROVENTIL 13.50 13574.99
304730420557004 PROVENTIL 13.50 13574.99
304730420557005 PROVENTIL 13.50 13574.99
304730420564 304730420564001 THEOPHYLLINE 5.22 13574.99
304730420564002 THEOPHYLLINE 5.22 13574.99
304730420564003 THEOPHYLLINE 5.22 13574.99
304730420564004 THEOPHYLLINE 5.22 13574.99
304730420564005 THEOPHYLLINE 5.22 13574.99
304730420571 304730420571001 AEROBID 51.44 13574.99
304730420571002 AEROBID 51.44 13574.99
304730420571003 AEROBID 51.44 13574.99
304730420571004 AEROBID 51.44 13574.99
304730420571005 AEROBID 51.44 13574.99
HC-026I 11:33 Wednesday, December 19, 2001 19
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
304730420588 304730420588001 ATROVENT 34.26 13574.99
304730420588002 ATROVENT 34.26 13574.99
304730420588003 ATROVENT 34.26 13574.99
304730420588004 ATROVENT 34.26 13574.99
304730420588005 ATROVENT 34.26 13574.99
304730420595 304730420595001 COMBIVENT INHALER 42.92 13574.99
304730420595002 COMBIVENT INHALER 42.92 13574.99
304730420595003 COMBIVENT INHALER 42.92 13574.99
304730420595004 COMBIVENT INHALER 42.92 13574.99
304730420595005 COMBIVENT INHALER 42.92 13574.99
304820210029 304820210029001 ALBUTEROL 53.62 4217.27
304820210036 304820210036001 PHENERGAN 27.70 4217.27
304820210043 304820210043001 CEDAX 48.00 4217.27
304820210050 304820210050001 NALDECON-DX 10.80 4217.27
304820210074 304820210074001 CEDAX 48.00 4217.27
304820210081 304820210081001 NALEX-DH 6.84 4217.27
304820210098 304820210098001 TYLENOL 6.58 4217.27
305000340025 305000340025001 CHERATUSSIN DAC 5.96 10566.04
305190210050 305190210050001 PROVENTIL 28.93 1209.14
305190380043 305190380043001 PROVENTIL 21.41 2196.08
305430370091 305430370091001 PROVENTIL 32.69 1802.77
305430370135 305430370135001 CLARITIN 64.06 1802.77
305430370135002 CLARITIN 64.06 1802.77
305430370142 305430370142001 AEROBID INHALER 69.80 1802.77
305430370142002 AEROBID INHALER 69.80 1802.77
305430370142003 AEROBID INHALER 69.80 1802.77
305430370159 305430370159001 PROVENTIL 32.69 1802.77
305430370159002 PROVENTIL 32.69 1802.77
305430370159003 PROVENTIL 32.69 1802.77
305430370180 305430370180001 CLARITIN-D 72.19 1802.77
305430370197 305430370197001 SEREVENT 56.30 1802.77
HC-026I 11:33 Wednesday, December 19, 2001 20
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
305430370200 305430370200001 ALBUTEROL 21.41 1802.77
305530310039 305530310039001 ALBUTEROL INHALER 21.41 3480.31
306370480276 306370480276001 CROMOLYN 40.80 14528.53
306370480310 306370480310001 AUGMENTIN 21.80 14528.53
306370480310002 AUGMENTIN 21.80 14528.53
306370480334 306370480334001 PRELONE 49.02 14528.53
306370480430 306370480430001 NYSTATIN 6.62 14528.53
306370480512 306370480512001 ZITHROMAX 27.34 14528.53
306370480529 306370480529001 CROMOLYN 36.13 14528.53
306370480529002 CROMOLYN 36.13 14528.53
306370480529003 CROMOLYN 36.13 14528.53
306370480536 306370480536001 CODITUSS DH 7.04 14528.53
306780210270 306780210270001 AEROBID 51.44 5142.02
306780210287 306780210287001 ALBUTEROL 22.00 5142.02
306780210294 306780210294001 ATUSS DM 19.85 5142.02
306780210307 306780210307001 AUGMENTIN 69.75 5142.02
306780210314 306780210314001 TESSALON 29.05 5142.02
307100650128 307100650128001 ALBUTEROL 18.89 11945.57
307100650128002 ALBUTEROL 18.89 11945.57
307100650128003 ALBUTEROL 18.89 11945.57
307100740068 307100740068001 ALBUTEROL 188.91 11945.57
307100740068002 ALBUTEROL 19.85 11945.57
307100740068003 ALBUTEROL 188.91 11945.57
307100740068004 ALBUTEROL 188.91 11945.57
307480180333 307480180333001 DYPHYLLINE-GG 8.99 1561.16
307480180333002 DYPHYLLINE-GG 8.99 1561.16
307480180333003 DYPHYLLINE-GG 8.99 1561.16
307480180333004 DYPHYLLINE-GG 8.99 1561.16
307660720050 307660720050001 CROMOLYN SODIUM 48.20 3711.05
307770270035 307770270035001 EZ SPACER 12.51 9144.06
HC-026I 11:33 Wednesday, December 19, 2001 21
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
307770270042 307770270042001 DONATUSSIN DC 13.76 9144.06
307930150107 307930150107001 FLOVENT 53.29 7266.21
307930150107002 DEVILBLISS PULMOMATE 13.25 7266.21
307930150114 307930150114001 SEREVENT 58.33 7266.21
307930150114002 SEREVENT 58.33 7266.21
308150300143 308150300143001 AZMACORT 47.65 4515.18
308180280950 308180280950001 PREDNISONE 3.13 25922.74
308180281117 308180281117001 PREDNISONE 3.98 25922.74
308180281117002 PREDNISONE 3.98 25922.74
308180281117003 PREDNISONE 3.98 25922.74
308970260340 308970260340001 LOTENSIN 25.17 4861.52
308970260535 308970260535001 PREDNISONE 10.69 4861.52
308970260542 308970260542001 BIAXIN 58.45 4861.52
308970260559 308970260559001 PROMETHAZINE W/DM 6.02 4861.52
308970260559002 PROMETHAZINE W/DM 6.02 4861.52
308970260566 308970260566001 LEVOTHROID 21.09 4861.52
309180160080 309180160080001 CODEINE/PROMETHAZINE HCL 6.21 3106.07
309180940139 309180940139001 PRELONE 11.42 4769.53
309390330315 309390330315001 IBUPROFEN 7.66 8380.19
309390330322 309390330322001 AMOXICILLIN 6.66 8380.19
309390330339 309390330339001 INTRON-A 235.49 8380.19
311500140180 311500140180001 VANCERIL 35.77 3411.00
311500140197 311500140197001 -9 5.62 3411.00
311600140695 311600140695001 METHOTREXATE 73.07 27046.91
311600140695002 METHOTREXATE 79.93 27046.91
311600140695003 METHOTREXATE 73.07 27046.91
311600140695004 METHOTREXATE 79.93 27046.91
311600140695005 METHOTREXATE 73.07 27046.91
311600140695006 METHOTREXATE 79.93 27046.91
311600140708 311600140708001 NAPROXEN 21.34 27046.91
HC-026I 11:33 Wednesday, December 19, 2001 22
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
311600140708 311600140708002 NAPROXEN 20.99 27046.91
311600140708003 NAPROXEN 20.99 27046.91
311600140708004 NAPROXEN 20.99 27046.91
HC-026I 11:33 Wednesday, December 19, 2001 23
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Analysis Variable : RXXP98X SUM OF PAYMENTS RXSF98X-RXOU98X(IMPUTED)
N Sum
------------------
2807 98698.15
------------------
HC-026I 11:33 Wednesday, December 19, 2001 24
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
Analysis Variable : RXXP98X SUM OF PAYMENTS RXSF98X-RXOU98X(IMPUTED)
N Sum
------------------
2807 995125072
------------------
1 The SAS System 11:09 Wednesday, December 19, 2001
NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 6.12 TS060
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC, Site 0026405003.
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-026I";
4 TITLE2 'Sample SAS Job for Example B';
5
6 LIBNAME IN 'C:\';
NOTE: Directory for library IN contains files of mixed engine types.
NOTE: Libref IN was successfully assigned as follows:
Engine: V612
Physical Name: C:\
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: The PROCEDURE FORMAT used 0.11 seconds.
22
23 *--------------------------------------------------------------------------------------
24 * Get condition records coded as asthma.
25 *--------------------------------------------------------------------------------------;
26 DATA ASCONDS;
27 SET IN.H27 (KEEP=CONDIDX CCCODEX);
28 IF CCCODEX="128";
29 RUN;
NOTE: The data set WORK.ASCONDS has 1243 observations and 2 variables.
NOTE: The DATA statement used 0.66 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: The data set WORK.ASCONDS has 1243 observations and 2 variables.
NOTE: The PROCEDURE SORT used 0.17 seconds.
2 The SAS System 11:09 Wednesday, December 19, 2001
35
36 proc print data=asconds (obs=50);
37 title3 "sample print of work.asconds - sorted by condidx";
38 title4 "COND (H27) records where cccodex=128";
39 run;
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: The PROCEDURE PRINT used 0.33 seconds.
40
41 PROC SORT DATA=IN.H26IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: The data set WORK.CLNK has 219144 observations and 5 variables.
NOTE: The PROCEDURE SORT used 4.28 seconds.
42
43 DATA ASCLNKS;
44 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
45 ASCONDS(IN=INASCOND KEEP=CONDIDX);
46 BY CONDIDX;
47 IF INCLNK & INASCOND;
48 RUN;
NOTE: The data set WORK.ASCLNKS has 4817 observations and 3 variables.
NOTE: The DATA statement used 1.59 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: The PROCEDURE PRINT printed pages 2-3.
NOTE: The PROCEDURE PRINT used 0.11 seconds.
57
58 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: The data set WORK.ASCLNKS has 4817 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.11 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;
3 The SAS System 11:09 Wednesday, December 19, 2001
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
64
65 DATA ASCLNKS;
66 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
67 BY EVNTIDX;
68 IF FIRST.EVNTIDX;
69 RUN;
NOTE: The data set WORK.ASCLNKS has 4807 observations and 2 variables.
NOTE: The DATA statement used 0.22 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: The PROCEDURE PRINT printed page 5.
NOTE: The PROCEDURE PRINT used 0.11 seconds.
75
76 *-------------------------------------------------------------------------------
77 * Get PMED records linked to asthma condition records.
78 *-------------------------------------------------------------------------------;
79 PROC SORT DATA=IN.H26A OUT=PMED; BY LINKIDX; RUN;
NOTE: The data set WORK.PMED has 172031 observations and 51 variables.
NOTE: The PROCEDURE SORT used 34.32 seconds.
80
81 DATA ASPMEDS;
82 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98)
83 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX RENAME=(EVNTIDX=LINKIDX));
84 BY LINKIDX;
85 IF INASCLNK & WTDPER98>0;
86 RUN;
NOTE: The data set WORK.ASPMEDS has 6142 observations and 5 variables.
NOTE: The DATA statement used 5.59 seconds.
87
88 proc print data=aspmeds (obs=300);
89 by linkidx;
90 id linkidx;
91 var rxrecidx rxname RXXP98X WTDPER98;
92 title3 "sample print of work.aspmeds";
93 title4 "PMED (HC-026A) records which link to condition records coded as asthma";
94 run;
NOTE: The PROCEDURE PRINT printed pages 6-14.
4 The SAS System 11:09 Wednesday, December 19, 2001
NOTE: The PROCEDURE PRINT used 0.33 seconds.
95
96 PROC MEANS DATA=ASPMEDS N SUM;
97 VAR RXXP98X;
98 TITLE3 "Total Rx expenditures associated with asthma";
99 RUN;
NOTE: The PROCEDURE MEANS printed page 15.
NOTE: The PROCEDURE MEANS used 0.11 seconds.
100
101 PROC MEANS DATA=ASPMEDS N SUM;
102 VAR RXXP98X;
103 WEIGHT WTDPER98;
104 TITLE3 "Total Rx expenditures associated with asthma";
105 TITLE5 "Weighted";
106 RUN;
NOTE: The PROCEDURE MEANS printed page 16.
NOTE: The PROCEDURE MEANS used 0.05 seconds.
107
108
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-026I 11:09 Wednesday, December 19, 2001 1
Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H27) records where cccodex=128
OBS CONDIDX CCCODEX
1 300090440043 128
2 300250280014 128
3 300440450027 128
4 300440510027 128
5 300650110034 128
6 300760110011 128
7 300790330011 128
8 300820410011 128
9 300820660046 128
10 300850210026 128
11 300850280035 128
12 300860170094 128
13 300930200025 128
14 300930200047 128
15 300930370030 128
16 301130110028 128
17 301170150039 128
18 301440390013 128
19 301730670017 128
20 301740160080 128
21 301740460022 128
22 301740790033 128
23 301740870019 128
24 301750330049 128
25 301750330061 128
26 301770320016 128
27 301780410013 128
28 301800150035 128
29 301890170054 128
30 301910480036 128
31 301910540014 128
32 302100140091 128
33 302100210012 128
34 302190490020 128
35 302230180020 128
36 302340400020 128
37 302340560014 128
38 302580120069 128
39 302690390085 128
40 302850180127 128
41 302850250029 128
42 302870290014 128
43 302880230064 128
44 303170330027 128
45 303260180027 128
46 303320110064 128
47 303370440041 128
48 303370440079 128
49 303490470019 128
50 303490530031 128
HC-026I 11:09 Wednesday, December 19, 2001 2
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
300250280014 300250280030 3 EROM
300250280047 1 MVIS
300250280085 8 PMED
300440450027 300440450091 8 PMED
300440510027 300440510016 1 MVIS
300440510023 8 PMED
300760110011 300760110303 8 PMED
300760110365 7 HVIS
300760110416 7 HVIS
300790330011 300790330230 8 PMED
300790330247 8 PMED
300790330292 1 MVIS
300790330312 8 PMED
300790330329 8 PMED
300790330336 8 PMED
300790330343 8 PMED
300820660046 300820660030 8 PMED
300850210026 300850210050 1 MVIS
300850210081 8 PMED
300860170094 300860170243 2 OPAT
300860170370 8 PMED
300860170387 8 PMED
300860170394 8 PMED
300930200025 300930200016 3 EROM
300930200061 8 PMED
300930200047 300930200030 3 EROM
300930200047 3 EROM
300930200054 8 PMED
300930370030 300930370047 8 PMED
301130110028 301130110052 8 PMED
301130110076 8 PMED
301170150039 301170150172 8 PMED
301170150230 8 PMED
301170150261 8 PMED
301730670017 301730670064 8 PMED
HC-026I 11:09 Wednesday, December 19, 2001 3
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
301740160080 301740160294 8 PMED
301740160369 8 PMED
301740160403 8 PMED
301740160427 8 PMED
301740460022 301740460175 8 PMED
301740460219 8 PMED
301740790033 301740790173 1 MVIS
301740790180 8 PMED
301740790197 8 PMED
301740790231 8 PMED
301740870019 301740870165 8 PMED
301740870172 8 PMED
301750330049 301750330108 1 MVIS
301750330122 8 PMED
301750330139 8 PMED
301750330160 1 MVIS
301750330177 8 PMED
301750330061 301750330160 1 MVIS
301780410013 301780410035 1 MVIS
301800150035 301800150195 8 PMED
301800150208 8 PMED
301890170054 301890170238 8 PMED
301890170245 8 PMED
301890170252 8 PMED
301890170303 1 MVIS
301890170310 1 MVIS
301890170327 1 MVIS
301890170334 1 MVIS
301890170341 1 MVIS
301890170358 1 MVIS
301890170365 1 MVIS
301890170485 8 PMED
301890170492 8 PMED
301890170505 8 PMED
301890170567 8 PMED
301890170574 8 PMED
301890170581 8 PMED
302100140091 302100140256 1 MVIS
302100140263 1 MVIS
302100140270 1 MVIS
HC-026I 11:09 Wednesday, December 19, 2001 4
Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx
OBS CONDIDX EVNTIDX EVENTYPE
1 300250280014 300250280030 3 EROM
2 300250280014 300250280047 1 MVIS
3 300250280014 300250280085 8 PMED
4 300440450027 300440450091 8 PMED
5 300440510027 300440510016 1 MVIS
6 300440510027 300440510023 8 PMED
7 300760110011 300760110303 8 PMED
8 300760110011 300760110365 7 HVIS
9 300760110011 300760110416 7 HVIS
10 300790330011 300790330230 8 PMED
11 300790330011 300790330247 8 PMED
12 300790330011 300790330292 1 MVIS
13 300790330011 300790330312 8 PMED
14 300790330011 300790330329 8 PMED
15 300790330011 300790330336 8 PMED
16 300790330011 300790330343 8 PMED
17 300820660046 300820660030 8 PMED
18 300850210026 300850210050 1 MVIS
19 300850210026 300850210081 8 PMED
20 300860170094 300860170243 2 OPAT
21 300860170094 300860170370 8 PMED
22 300860170094 300860170387 8 PMED
23 300860170094 300860170394 8 PMED
24 300930200025 300930200016 3 EROM
25 300930200047 300930200030 3 EROM
26 300930200047 300930200047 3 EROM
27 300930200047 300930200054 8 PMED
28 300930200025 300930200061 8 PMED
29 300930370030 300930370047 8 PMED
30 301130110028 301130110052 8 PMED
31 301130110028 301130110076 8 PMED
32 301170150039 301170150172 8 PMED
33 301170150039 301170150230 8 PMED
34 301170150039 301170150261 8 PMED
35 301730670017 301730670064 8 PMED
36 301740160080 301740160294 8 PMED
37 301740160080 301740160369 8 PMED
38 301740160080 301740160403 8 PMED
39 301740160080 301740160427 8 PMED
40 301740460022 301740460175 8 PMED
41 301740460022 301740460219 8 PMED
42 301740790033 301740790173 1 MVIS
43 301740790033 301740790180 8 PMED
44 301740790033 301740790197 8 PMED
45 301740790033 301740790231 8 PMED
46 301740870019 301740870165 8 PMED
47 301740870019 301740870172 8 PMED
48 301750330049 301750330108 1 MVIS
49 301750330049 301750330122 8 PMED
50 301750330049 301750330139 8 PMED
HC-026I 11:09 Wednesday, December 19, 2001 5
Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks
OBS EVNTIDX EVENTYPE
1 300250280030 3 EROM
2 300250280047 1 MVIS
3 300250280085 8 PMED
4 300440450091 8 PMED
5 300440510016 1 MVIS
6 300440510023 8 PMED
7 300760110303 8 PMED
8 300760110365 7 HVIS
9 300760110416 7 HVIS
10 300790330230 8 PMED
11 300790330247 8 PMED
12 300790330292 1 MVIS
13 300790330312 8 PMED
14 300790330329 8 PMED
15 300790330336 8 PMED
16 300790330343 8 PMED
17 300820660030 8 PMED
18 300850210050 1 MVIS
19 300850210081 8 PMED
20 300860170243 2 OPAT
21 300860170370 8 PMED
22 300860170387 8 PMED
23 300860170394 8 PMED
24 300930200016 3 EROM
25 300930200030 3 EROM
26 300930200047 3 EROM
27 300930200054 8 PMED
28 300930200061 8 PMED
29 300930370047 8 PMED
30 301130110052 8 PMED
31 301130110076 8 PMED
32 301170150172 8 PMED
33 301170150230 8 PMED
34 301170150261 8 PMED
35 301730670064 8 PMED
36 301740160294 8 PMED
37 301740160369 8 PMED
38 301740160403 8 PMED
39 301740160427 8 PMED
40 301740460175 8 PMED
41 301740460219 8 PMED
42 301740790173 1 MVIS
43 301740790180 8 PMED
44 301740790197 8 PMED
45 301740790231 8 PMED
46 301740870165 8 PMED
47 301740870172 8 PMED
48 301750330108 1 MVIS
49 301750330122 8 PMED
50 301750330139 8 PMED
HC-026I 11:09 Wednesday, December 19, 2001 6
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-026A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
300250280085 300250280085001 ALBUTEROL 21.49 2507.60
300440450091 300440450091001 HYDROPHED 30.78 13570.52
300440450091002 HYDROPHED 30.78 13570.52
300440450091003 HYDROPHED 30.78 13570.52
300440510023 300440510023001 ALBUTEROL SULFATE 10.69 16284.45
300790330230 300790330230001 FLOVENT 167.04 1186.13
300790330247 300790330247001 SEREVENT INHALER 72.82 1186.13
300790330247002 SEREVENT INHALER 72.82 1186.13
300790330312 300790330312001 FLOVENT 167.04 1186.13
300790330312002 FLOVENT 167.04 1186.13
300790330312003 FLOVENT 167.04 1186.13
300790330312004 FLOVENT 167.04 1186.13
300790330329 300790330329001 SEREVENT 116.66 1186.13
300790330329002 SEREVENT 116.66 1186.13
300790330329003 SEREVENT 8.97 1186.13
300790330329004 SEREVENT 116.66 1186.13
300790330336 300790330336001 FLOVENT 167.04 1186.13
300790330336002 FLOVENT 167.04 1186.13
300790330336003 FLOVENT 167.04 1186.13
300790330336004 FLOVENT 167.04 1186.13
300790330343 300790330343001 SEREVENT 116.66 1186.13
300790330343002 SEREVENT 6.99 1186.13
300790330343003 SEREVENT 6.99 1186.13
300790330343004 SEREVENT 6.99 1186.13
300820660030 300820660030001 ALBUTEROL 24.76 11088.56
300850210081 300850210081001 -9 3.00 3325.32
300860170370 300860170370001 ALBUTEROL 26.98 5106.67
300860170387 300860170387001 PREDNISONE 5.00 5106.67
300860170394 300860170394001 FLOVENT 54.10 5106.67
300860170394002 FLOVENT 54.10 5106.67
300930200054 300930200054001 ALBUTEROL 21.99 5902.66
300930200061 300930200061001 ALBUTEROL 21.49 5902.66
300930370047 300930370047001 PROVENTIL HFA 27.32 8288.16
HC-026I 11:09 Wednesday, December 19, 2001 7
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-026A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
301130110052 301130110052001 ALBUTEROL 21.41 2752.93
301130110052002 ALBUTEROL 21.41 2752.93
301130110076 301130110076001 ALBUTEROL 21.41 2752.93
301130110076002 ALBUTEROL 21.41 2752.93
301130110076003 ALBUTEROL 21.41 2752.93
301170150172 301170150172001 THEOPHYLLINE ER 26.40 8279.84
301170150230 301170150230001 PROPULSID 89.72 8279.84
301170150261 301170150261001 THEOPHYLLINE 10.24 8279.84
301730670064 301730670064001 DIMETAPP 4.29 1517.94
301740160294 301740160294001 MENTHOL CR/AVEENO 8.73 5519.81
301740160294002 MENTHOL CR/AVEENO 8.73 5519.81
301740160369 301740160369001 POTASSIUM CHLORIDE 19.04 5519.81
301740160369002 POTASSIUM CHLORIDE 19.04 5519.81
301740160403 301740160403001 ALBUTEROL 21.75 5519.81
301740160427 301740160427001 THEOPHYLLINE ANHYDROUS 15.20 5519.81
301740160427002 THEOPHYLLINE ANHYDROUS 15.20 5519.81
301740160427003 THEOPHYLLINE ANHYDROUS 15.20 5519.81
301740160427004 THEOPHYLLINE ANHYDROUS 15.20 5519.81
301740160427005 THEOPHYLLINE ANHYDROUS 15.20 5519.81
301740460175 301740460175001 SEREVENT 56.30 1275.60
301740460219 301740460219001 PROVENTIL 57.86 1275.60
301740790180 301740790180001 SEREVENT 57.08 3457.53
301740790197 301740790197001 AZMACORT 133.09 3457.53
301740790231 301740790231001 ALBUTEROL 84.63 3457.53
301740870165 301740870165001 SLO-BID GYROCAPS 31.59 4148.40
301740870172 301740870172001 SEREVENT INH 156.25 4148.40
301750330122 301750330122001 -9 13.33 19819.94
301750330139 301750330139001 BIAXIN 25.97 19819.94
301750330177 301750330177001 ANTIBIOTIC 14.95 19819.94
HC-026I 11:09 Wednesday, December 19, 2001 8
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-026A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
301800150195 301800150195001 SEREVENT 116.66 18065.37
301800150208 301800150208001 ALBUTEROL 30.29 18065.37
301890170238 301890170238001 SEREVENT REFILL 51.20 15961.99
301890170245 301890170245001 ATROVENT REFILL 28.91 15961.99
301890170252 301890170252001 AZMACORT 47.33 15961.99
301890170252002 AZMACORT 47.33 15961.99
301890170485 301890170485001 SEREVENT REFILL 53.67 15961.99
301890170485002 SEREVENT REFILL 53.67 15961.99
301890170485003 SEREVENT REFILL 53.67 15961.99
301890170485004 SEREVENT REFILL 53.67 15961.99
301890170485005 SEREVENT REFILL 53.67 15961.99
301890170485006 SEREVENT REFILL 53.67 15961.99
301890170485007 SEREVENT REFILL 53.67 15961.99
301890170492 301890170492001 ATROVENT REFILL 30.07 15961.99
301890170492002 ATROVENT REFILL 31.15 15961.99
301890170492003 ATROVENT REFILL 30.07 15961.99
301890170492004 ATROVENT REFILL 30.07 15961.99
301890170492005 ATROVENT REFILL 31.15 15961.99
301890170492006 ATROVENT REFILL 30.07 15961.99
301890170492007 ATROVENT REFILL 30.07 15961.99
301890170492008 ATROVENT REFILL 31.15 15961.99
301890170492009 ATROVENT REFILL 30.07 15961.99
301890170505 301890170505001 AZMACORT 47.33 15961.99
301890170505002 AZMACORT 49.10 15961.99
301890170505003 AZMACORT 49.10 15961.99
301890170505004 AZMACORT 47.33 15961.99
301890170505005 AZMACORT 49.10 15961.99
301890170505006 AZMACORT 49.10 15961.99
301890170505007 AZMACORT 47.33 15961.99
301890170505008 AZMACORT 47.33 15961.99
301890170505009 AZMACORT 47.33 15961.99
301890170505010 AZMACORT 49.10 15961.99
301890170505011 AZMACORT 49.10 15961.99
301890170567 301890170567001 SEREVENT REFILL 53.67 15961.99
301890170567002 SEREVENT REFILL 53.67 15961.99
301890170567003 SEREVENT REFILL 53.67 15961.99
301890170574 301890170574001 ATROVENT REFILL 31.15 15961.99
301890170574002 ATROVENT REFILL 31.15 15961.99
301890170574003 ATROVENT REFILL 31.15 15961.99
HC-026I 11:09 Wednesday, December 19, 2001 9
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-026A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
301890170581 301890170581001 AZMACORT 49.10 15961.99
301890170581002 AZMACORT 49.10 15961.99
301890170581003 AZMACORT 49.10 15961.99
302100210263 302100210263001 CARBAMAZEPINE 35.22 1870.22
302100210270 302100210270001 ALBUTEROL 20.45 1870.22
302190490120 302190490120001 VENTOLIN ROTACAPS 35.76 9465.66
302190490120002 VENTOLIN ROTACAPS 35.76 9465.66
302230180732 302230180732001 PANFIL G 10.00 3376.03
302230180749 302230180749001 ALBUTEROL INHALER 21.41 3376.03
302230180749002 ALBUTEROL INHALER 21.41 3376.03
302340400042 302340400042001 ALBUTEROL 12.10 5178.65
302340560423 302340560423001 BECONASE AQ 53.99 3309.39
302340560454 302340560454001 BECONASE AQ 53.99 3309.39
302340560454002 BECONASE AQ 53.99 3309.39
302340560454003 BECONASE AQ 53.99 3309.39
302340560461 302340560461001 ALBUTEROL 11.12 3309.39
302340560461002 ALBUTEROL 11.12 3309.39
302340560461003 ALBUTEROL 11.12 3309.39
302340560478 302340560478001 PSEUDOEPHEDRINE 3.17 3309.39
302340560478002 PSEUDOEPHEDRINE 3.17 3309.39
302340560478003 PSEUDOEPHEDRINE 3.17 3309.39
302340560492 302340560492001 BECONASE AQ 53.99 3309.39
302340560492002 BECONASE AQ 53.99 3309.39
302340560505 302340560505001 ALBUTEROL 11.12 3309.39
302340560505002 ALBUTEROL 11.12 3309.39
302340560512 302340560512001 PSEUDOEPHEDRINE 3.17 3309.39
302340560512002 PSEUDOEPHEDRINE 3.17 3309.39
302580120197 302580120197001 AEROCHAMBER 40.75 9703.32
302850250103 302850250103001 CLARITIN 30.85 9943.89
302850250165 302850250165001 CLARITIN 30.85 9943.89
302850250165002 CLARITIN 30.85 9943.89
302850250165003 CLARITIN 30.85 9943.89
302850250165004 CLARITIN 30.85 9943.89
HC-026I 11:09 Wednesday, December 19, 2001 10
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-026A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
302850250172 302850250172001 E-MYCIN 15.26 9943.89
302880230627 302880230627001 MOTRIN 11.73 5807.26
303260180099 303260180099001 AZMACORT 49.18 25618.20
303260180099002 AZMACORT 49.18 25618.20
303260180099003 AZMACORT 49.18 25618.20
303260180102 303260180102001 ALBUTEROL 21.41 25618.20
303260180102002 ALBUTEROL 21.41 25618.20
303260180102003 ALBUTEROL 21.41 25618.20
303260180102004 ALBUTEROL 21.41 25618.20
303260180195 303260180195001 AZMACORT 49.18 25618.20
303260180195002 AZMACORT 49.18 25618.20
303260180195003 AZMACORT 49.18 25618.20
303260180195004 AZMACORT 49.18 25618.20
303260180208 303260180208001 ALBUTEROL 21.41 25618.20
303260180208002 ALBUTEROL 21.41 25618.20
303260180208003 ALBUTEROL 21.41 25618.20
303260180208004 ALBUTEROL 21.41 25618.20
303260180208005 ALBUTEROL 21.41 25618.20
303260180208006 ALBUTEROL 21.41 25618.20
303260180239 303260180239001 SEREVENT 58.33 25618.20
303260180246 303260180246001 AZMACORT 49.18 25618.20
303260180246002 AZMACORT 49.18 25618.20
303260180253 303260180253001 ALBUTEROL 21.41 25618.20
303260180253002 ALBUTEROL 21.41 25618.20
303260180253003 ALBUTEROL 21.41 25618.20
303260180253004 ALBUTEROL 21.41 25618.20
303320110584 303320110584001 ALBUTEROL 11.07 17519.00
303320110591 303320110591001 VANCERIL 48.88 17519.00
303540380070 303540380070001 TUSSORGANIDIN DM 17.47 5838.47
303650250171 303650250171001 TILADE INHALER 66.85 19458.95
303650250171002 TILADE INHALER 66.85 19458.95
303650250188 303650250188001 AEROCHAMBER 27.84 19458.95
303650250195 303650250195001 RHINOCORT 34.45 19458.95
303650250195002 RHINOCORT 34.45 19458.95
HC-026I 11:09 Wednesday, December 19, 2001 11
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-026A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
303650250215 303650250215001 SINGULAIR 66.96 19458.95
303650250215002 SINGULAIR 66.96 19458.95
303650250215003 SINGULAIR 66.96 19458.95
303650250246 303650250246001 SINGULAIR 66.96 19458.95
303650250246002 SINGULAIR 66.96 19458.95
303650250253 303650250253001 RHINOCORT 34.45 19458.95
303650250260 303650250260001 TILADE INHALER 66.85 19458.95
303650250260002 TILADE INHALER 66.85 19458.95
303670160583 303670160583001 BRETHINE 31.07 5364.52
303670160583002 BRETHINE 31.07 5364.52
303940330034 303940330034001 PROVENTIL 28.93 2422.50
303940330041 303940330041001 VISTARIL 34.68 2422.50
303940330041002 VISTARIL 34.68 2422.50
303940330058 303940330058001 PROVENTIL 28.93 2422.50
303940330065 303940330065001 VISTARIL 16.62 2422.50
303940330065002 VISTARIL 16.62 2422.50
303940330072 303940330072001 PROVENTIL 28.93 2422.50
303940330072002 PROVENTIL 28.93 2422.50
303940330089 303940330089001 VISTARIL 34.68 2422.50
303940330089002 VISTARIL 34.68 2422.50
304040160344 304040160344001 VANCERIL 38.73 8340.92
304040160344002 VANCERIL 38.73 8340.92
304040160344003 VANCERIL 38.73 8340.92
304040160344004 VANCERIL 38.73 8340.92
304040160351 304040160351001 ALBUTEROL 10.25 8340.92
304040160351002 ALBUTEROL 10.25 8340.92
304040160351003 ALBUTEROL 10.25 8340.92
304040160464 304040160464001 TOPROL XL 47.89 8340.92
304040160488 304040160488001 ALBUTEROL 8.14 8340.92
304040160488002 ALBUTEROL 8.14 8340.92
304040160488003 ALBUTEROL 8.14 8340.92
304040160488004 ALBUTEROL 8.14 8340.92
304040160488005 ALBUTEROL 8.14 8340.92
304040160488006 ALBUTEROL 8.14 8340.92
HC-026I 11:09 Wednesday, December 19, 2001 12
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-026A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
304040160508 304040160508001 VANCERIL 38.73 8340.92
304040160508002 VANCERIL 38.73 8340.92
304040160508003 VANCERIL 38.73 8340.92
304040160508004 VANCERIL 38.73 8340.92
304040160546 304040160546001 TOPROL XL 30.11 8340.92
304040160560 304040160560001 ALBUTEROL 21.41 8340.92
304040160560002 ALBUTEROL 21.41 8340.92
304220140163 304220140163001 INTAL INHALER 76.13 14586.07
304220140163002 INTAL INHALER 76.13 14586.07
304230130824 304230130824001 ALBUTEROL 13.07 10639.91
304230130951 304230130951001 VENTOLIN 35.37 10639.91
304230200533 304230200533001 ATROVENT 33.09 4188.36
304230200533002 ATROVENT 33.09 4188.36
304230200533003 ATROVENT 33.09 4188.36
304230200533004 ATROVENT 33.09 4188.36
304230200533005 ATROVENT 33.09 4188.36
304230200533006 ATROVENT 33.09 4188.36
304230200691 304230200691001 ATROVENT I 47.76 4188.36
304240170092 304240170092001 VENTOLIN 26.94 3780.92
304240170092002 VENTOLIN 26.94 3780.92
304240170092003 VENTOLIN 26.94 3780.92
304240170092004 VENTOLIN 26.94 3780.92
304240170092005 VENTOLIN 26.94 3780.92
304240170092006 VENTOLIN 26.94 3780.92
304240170092007 VENTOLIN 26.94 3780.92
304240170105 304240170105001 EZ SPACER 12.51 3780.92
304240170105002 EZ SPACER 12.51 3780.92
304240170105003 EZ SPACER 12.51 3780.92
304240170105004 EZ SPACER 12.51 3780.92
304240170105005 EZ SPACER 12.51 3780.92
304240170105006 EZ SPACER 12.51 3780.92
304240170105007 EZ SPACER 12.51 3780.92
304290500189 304290500189001 VANCENASE 46.51 3005.58
304290500196 304290500196001 AEROCHAMBER 33.39 3005.58
304290500196002 AEROCHAMBER 33.39 3005.58
304290500209 304290500209001 ALBUTEROL 9.88 3005.58
304290500209002 ALBUTEROL 9.88 3005.58
HC-026I 11:09 Wednesday, December 19, 2001 13
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-026A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
304290500209 304290500209003 ALBUTEROL 9.88 3005.58
304310250320 304310250320001 ALBUTEROL 10.38 8036.09
304310250515 304310250515001 ALBUTEROL 21.41 8036.09
304470110281 304470110281001 AEROBID INHALER 69.80 2657.64
304470110281002 AEROBID INHALER 69.80 2657.64
304470110281003 AEROBID INHALER 69.80 2657.64
304470110298 304470110298001 INSPIREASE 20.99 2657.64
304470110298002 INSPIREASE 20.99 2657.64
304470110298003 INSPIREASE 20.99 2657.64
304470110301 304470110301001 AFRIN 14.78 2657.64
304470110318 304470110318001 EZ SPACER 12.51 2657.64
304470110452 304470110452001 AEROBID INHALER 69.80 2657.64
304470110452002 AEROBID INHALER 69.80 2657.64
304470110452003 AEROBID INHALER 69.80 2657.64
304470110452004 AEROBID INHALER 69.80 2657.64
304470110452005 AEROBID INHALER 69.80 2657.64
304470110452006 AEROBID INHALER 69.80 2657.64
304470110452007 AEROBID INHALER 69.80 2657.64
304470110469 304470110469001 INSPIREASE 20.99 2657.64
304470110469002 INSPIREASE 20.99 2657.64
304470110469003 INSPIREASE 20.99 2657.64
304470110469004 INSPIREASE 20.99 2657.64
304470110469005 INSPIREASE 20.99 2657.64
304470110469006 INSPIREASE 20.99 2657.64
304470110469007 INSPIREASE 20.99 2657.64
304470110476 304470110476001 AFRIN 14.78 2657.64
304470110476002 AFRIN 14.78 2657.64
304470110476003 AFRIN 14.78 2657.64
304470110476004 AFRIN 14.78 2657.64
304470110476005 AFRIN 14.78 2657.64
304470110476006 AFRIN 14.78 2657.64
304470110476007 AFRIN 14.78 2657.64
304470110483 304470110483001 EZ SPACER 12.51 2657.64
304470110483002 EZ SPACER 12.51 2657.64
304470110483003 EZ SPACER 12.51 2657.64
304470110483004 EZ SPACER 12.51 2657.64
304470110483005 EZ SPACER 12.51 2657.64
304470110483006 EZ SPACER 12.51 2657.64
304470110483007 EZ SPACER 12.51 2657.64
HC-026I 11:09 Wednesday, December 19, 2001 14
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-026A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
304470110490 304470110490001 CIMETIDINE 170.00 2657.64
304470110490002 CIMETIDINE 170.00 2657.64
304470110490003 CIMETIDINE 170.00 2657.64
304470110490004 CIMETIDINE 170.00 2657.64
304470110490005 CIMETIDINE 170.00 2657.64
304470110490006 CIMETIDINE 170.00 2657.64
304470110490007 CIMETIDINE 170.00 2657.64
304470110503 304470110503001 PROVENTIL REPETABS 38.81 2657.64
304470110503002 PROVENTIL REPETABS 38.81 2657.64
304470110503003 PROVENTIL REPETABS 38.81 2657.64
304470110503004 PROVENTIL REPETABS 38.81 2657.64
304470110503005 PROVENTIL REPETABS 38.81 2657.64
304470110503006 PROVENTIL REPETABS 38.81 2657.64
304470110503007 PROVENTIL REPETABS 38.81 2657.64
304470110510 304470110510001 ALLEGRA 25.60 2657.64
304470110510002 ALLEGRA 25.60 2657.64
304470110510003 ALLEGRA 25.60 2657.64
304470110510004 ALLEGRA 25.60 2657.64
304470110510005 ALLEGRA 25.60 2657.64
304470110510006 ALLEGRA 25.60 2657.64
304470110510007 ALLEGRA 25.60 2657.64
304660390171 304660390171001 ALBUTEROL INH 27.95 4554.36
HC-026I 11:09 Wednesday, December 19, 2001 15
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Analysis Variable : RXXP98X SUM OF PAYMENTS RXSF98X-RXOU98X(IMPUTED)
N Sum
------------------
6142 216221.93
------------------
HC-026I 11:09 Wednesday, December 19, 2001 16
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
Analysis Variable : RXXP98X SUM OF PAYMENTS RXSF98X-RXOU98X(IMPUTED)
N Sum
------------------
6142 2230518530
------------------
1 The SAS System 11:19 Wednesday, December 19, 2001
NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 6.12 TS060
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC, Site 0026405003.
1
2 OPTIONS LS=132 PS=59;
3
4 TITLE1 "HC-026I";
5 TITLE2 'Sample SAS Job for Example C';
6
7 LIBNAME IN 'C:\';
NOTE: Directory for library IN contains files of mixed engine types.
NOTE: Libref IN was successfully assigned as follows:
Engine: V612
Physical Name: C:\
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: The PROCEDURE FORMAT used 0.17 seconds.
23
24 *-----------------------------------------------------------------------------------
25 * Get conditions records coded as asthma.
26 *-----------------------------------------------------------------------------------;
27 DATA ASCONDS;
28 SET IN.H27 (KEEP=CONDIDX CCCODEX);
29 IF CCCODEX="128";
30 RUN;
NOTE: The data set WORK.ASCONDS has 1243 observations and 2 variables.
NOTE: The DATA statement used 0.93 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: The data set WORK.ASCONDS has 1243 observations and 2 variables.
2 The SAS System 11:19 Wednesday, December 19, 2001
NOTE: The PROCEDURE SORT used 0.16 seconds.
36
37 proc print data=asconds (obs=50);
38 title3 "sample print of work.asconds - sorted by condidx";
39 title4 "COND (HC-027) records where cccodex=128";
40 run;
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: The PROCEDURE PRINT used 0.33 seconds.
41
42 PROC SORT DATA=IN.H26IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: The data set WORK.CLNK has 219144 observations and 5 variables.
NOTE: The PROCEDURE SORT used 8.94 seconds.
43
44 DATA ASCLNKS;
45 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
46 ASCONDS(IN=INASCOND KEEP=CONDIDX);
47 BY CONDIDX;
48 IF INCLNK & INASCOND;
49 RUN;
NOTE: The data set WORK.ASCLNKS has 4817 observations and 3 variables.
NOTE: The DATA statement used 5.32 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: The PROCEDURE PRINT printed pages 2-3.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
58
59 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: The data set WORK.ASCLNKS has 4817 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.22 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;
3 The SAS System 11:19 Wednesday, December 19, 2001
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
65
66 DATA ASCLNKS;
67 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
68 BY EVNTIDX;
69 IF FIRST.EVNTIDX;
70 RUN;
NOTE: The data set WORK.ASCLNKS has 4807 observations and 2 variables.
NOTE: The DATA statement used 0.33 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: The PROCEDURE PRINT printed page 5.
NOTE: The PROCEDURE PRINT used 0.11 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.H26GF1 (KEEP=EVNTIDX WTDPER98 SEETLKPV OBXP98X);
82 IF WTDPER98 > 0 & SEETLKPV NE 2;
83 RUN;
NOTE: The data set WORK.MVIS has 101135 observations and 4 variables.
NOTE: The DATA statement used 2.08 seconds.
84
85 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: The data set WORK.MVIS has 101135 observations and 4 variables.
NOTE: The PROCEDURE SORT used 2.79 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;
4 The SAS System 11:19 Wednesday, December 19, 2001
NOTE: The data set WORK.ASMVIS has 1608 observations and 5 variables.
NOTE: The DATA statement used 2.64 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-026G) events";
101 run;
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: The PROCEDURE PRINT used 0.17 seconds.
102
103 PROC MEANS DATA=ASMVIS N SUM;
104 VAR OBXP98X;
105 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
106 RUN;
NOTE: The PROCEDURE MEANS printed page 7.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
107
108 PROC MEANS DATA=ASMVIS SUM;
109 VAR OBXP98X;
110 WEIGHT WTDPER98;
111 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
112 TITLE5 "Weighted";
113 RUN;
NOTE: The PROCEDURE MEANS printed page 8.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
114
115
116
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-026I 11:19 Wednesday, December 19, 2001 1
Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx
COND (HC-027) records where cccodex=128
OBS CONDIDX CCCODEX
1 300090440043 128
2 300250280014 128
3 300440450027 128
4 300440510027 128
5 300650110034 128
6 300760110011 128
7 300790330011 128
8 300820410011 128
9 300820660046 128
10 300850210026 128
11 300850280035 128
12 300860170094 128
13 300930200025 128
14 300930200047 128
15 300930370030 128
16 301130110028 128
17 301170150039 128
18 301440390013 128
19 301730670017 128
20 301740160080 128
21 301740460022 128
22 301740790033 128
23 301740870019 128
24 301750330049 128
25 301750330061 128
26 301770320016 128
27 301780410013 128
28 301800150035 128
29 301890170054 128
30 301910480036 128
31 301910540014 128
32 302100140091 128
33 302100210012 128
34 302190490020 128
35 302230180020 128
36 302340400020 128
37 302340560014 128
38 302580120069 128
39 302690390085 128
40 302850180127 128
41 302850250029 128
42 302870290014 128
43 302880230064 128
44 303170330027 128
45 303260180027 128
46 303320110064 128
47 303370440041 128
48 303370440079 128
49 303490470019 128
50 303490530031 128
HC-026I 11:19 Wednesday, December 19, 2001 2
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
300250280014 300250280030 3 EROM
300250280047 1 MVIS
300250280085 8 PMED
300440450027 300440450091 8 PMED
300440510027 300440510016 1 MVIS
300440510023 8 PMED
300760110011 300760110303 8 PMED
300760110365 7 HVIS
300760110416 7 HVIS
300790330011 300790330230 8 PMED
300790330247 8 PMED
300790330292 1 MVIS
300790330312 8 PMED
300790330329 8 PMED
300790330336 8 PMED
300790330343 8 PMED
300820660046 300820660030 8 PMED
300850210026 300850210050 1 MVIS
300850210081 8 PMED
300860170094 300860170243 2 OPAT
300860170370 8 PMED
300860170387 8 PMED
300860170394 8 PMED
300930200025 300930200016 3 EROM
300930200061 8 PMED
300930200047 300930200030 3 EROM
300930200047 3 EROM
300930200054 8 PMED
300930370030 300930370047 8 PMED
301130110028 301130110052 8 PMED
301130110076 8 PMED
301170150039 301170150172 8 PMED
301170150230 8 PMED
301170150261 8 PMED
301730670017 301730670064 8 PMED
HC-026I 11:19 Wednesday, December 19, 2001 3
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
301740160080 301740160294 8 PMED
301740160369 8 PMED
301740160403 8 PMED
301740160427 8 PMED
301740460022 301740460175 8 PMED
301740460219 8 PMED
301740790033 301740790173 1 MVIS
301740790180 8 PMED
301740790197 8 PMED
301740790231 8 PMED
301740870019 301740870165 8 PMED
301740870172 8 PMED
301750330049 301750330108 1 MVIS
301750330122 8 PMED
301750330139 8 PMED
301750330160 1 MVIS
301750330177 8 PMED
301750330061 301750330160 1 MVIS
301780410013 301780410035 1 MVIS
301800150035 301800150195 8 PMED
301800150208 8 PMED
301890170054 301890170238 8 PMED
301890170245 8 PMED
301890170252 8 PMED
301890170303 1 MVIS
301890170310 1 MVIS
301890170327 1 MVIS
301890170334 1 MVIS
301890170341 1 MVIS
301890170358 1 MVIS
301890170365 1 MVIS
301890170485 8 PMED
301890170492 8 PMED
301890170505 8 PMED
301890170567 8 PMED
301890170574 8 PMED
301890170581 8 PMED
302100140091 302100140256 1 MVIS
302100140263 1 MVIS
302100140270 1 MVIS
HC-026I 11:19 Wednesday, December 19, 2001 4
Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx
OBS CONDIDX EVNTIDX EVENTYPE
1 300250280014 300250280030 3 EROM
2 300250280014 300250280047 1 MVIS
3 300250280014 300250280085 8 PMED
4 300440450027 300440450091 8 PMED
5 300440510027 300440510016 1 MVIS
6 300440510027 300440510023 8 PMED
7 300760110011 300760110303 8 PMED
8 300760110011 300760110365 7 HVIS
9 300760110011 300760110416 7 HVIS
10 300790330011 300790330230 8 PMED
11 300790330011 300790330247 8 PMED
12 300790330011 300790330292 1 MVIS
13 300790330011 300790330312 8 PMED
14 300790330011 300790330329 8 PMED
15 300790330011 300790330336 8 PMED
16 300790330011 300790330343 8 PMED
17 300820660046 300820660030 8 PMED
18 300850210026 300850210050 1 MVIS
19 300850210026 300850210081 8 PMED
20 300860170094 300860170243 2 OPAT
21 300860170094 300860170370 8 PMED
22 300860170094 300860170387 8 PMED
23 300860170094 300860170394 8 PMED
24 300930200025 300930200016 3 EROM
25 300930200047 300930200030 3 EROM
26 300930200047 300930200047 3 EROM
27 300930200047 300930200054 8 PMED
28 300930200025 300930200061 8 PMED
29 300930370030 300930370047 8 PMED
30 301130110028 301130110052 8 PMED
31 301130110028 301130110076 8 PMED
32 301170150039 301170150172 8 PMED
33 301170150039 301170150230 8 PMED
34 301170150039 301170150261 8 PMED
35 301730670017 301730670064 8 PMED
36 301740160080 301740160294 8 PMED
37 301740160080 301740160369 8 PMED
38 301740160080 301740160403 8 PMED
39 301740160080 301740160427 8 PMED
40 301740460022 301740460175 8 PMED
41 301740460022 301740460219 8 PMED
42 301740790033 301740790173 1 MVIS
43 301740790033 301740790180 8 PMED
44 301740790033 301740790197 8 PMED
45 301740790033 301740790231 8 PMED
46 301740870019 301740870165 8 PMED
47 301740870019 301740870172 8 PMED
48 301750330049 301750330108 1 MVIS
49 301750330049 301750330122 8 PMED
50 301750330049 301750330139 8 PMED
HC-026I 11:19 Wednesday, December 19, 2001 5
Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks
OBS EVNTIDX EVENTYPE
1 300250280030 3 EROM
2 300250280047 1 MVIS
3 300250280085 8 PMED
4 300440450091 8 PMED
5 300440510016 1 MVIS
6 300440510023 8 PMED
7 300760110303 8 PMED
8 300760110365 7 HVIS
9 300760110416 7 HVIS
10 300790330230 8 PMED
11 300790330247 8 PMED
12 300790330292 1 MVIS
13 300790330312 8 PMED
14 300790330329 8 PMED
15 300790330336 8 PMED
16 300790330343 8 PMED
17 300820660030 8 PMED
18 300850210050 1 MVIS
19 300850210081 8 PMED
20 300860170243 2 OPAT
21 300860170370 8 PMED
22 300860170387 8 PMED
23 300860170394 8 PMED
24 300930200016 3 EROM
25 300930200030 3 EROM
26 300930200047 3 EROM
27 300930200054 8 PMED
28 300930200061 8 PMED
29 300930370047 8 PMED
30 301130110052 8 PMED
31 301130110076 8 PMED
32 301170150172 8 PMED
33 301170150230 8 PMED
34 301170150261 8 PMED
35 301730670064 8 PMED
36 301740160294 8 PMED
37 301740160369 8 PMED
38 301740160403 8 PMED
39 301740160427 8 PMED
40 301740460175 8 PMED
41 301740460219 8 PMED
42 301740790173 1 MVIS
43 301740790180 8 PMED
44 301740790197 8 PMED
45 301740790231 8 PMED
46 301740870165 8 PMED
47 301740870172 8 PMED
48 301750330108 1 MVIS
49 301750330122 8 PMED
50 301750330139 8 PMED
HC-026I 11:19 Wednesday, December 19, 2001 6
Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-026G) events
OBS EVNTIDX EVENTYPE SEETLKPV OBXP98X WTDPER98
1 300250280047 1 MVIS 1 16.00 2507.60
2 300440510016 1 MVIS 1 46.00 16284.45
3 300790330292 1 MVIS 1 40.78 1186.13
4 300850210050 1 MVIS 1 38.00 3325.32
5 301740790173 1 MVIS 1 1220.66 3457.53
6 301750330108 1 MVIS 1 45.00 19819.94
7 301750330160 1 MVIS 1 59.00 19819.94
8 301780410035 1 MVIS 1 30.00 2966.91
9 301890170303 1 MVIS 1 141.00 15961.99
10 301890170310 1 MVIS 1 69.56 15961.99
11 301890170327 1 MVIS 1 89.00 15961.99
12 301890170334 1 MVIS 1 68.00 15961.99
13 301890170341 1 MVIS 1 62.00 15961.99
14 301890170358 1 MVIS 1 38.00 15961.99
15 301890170365 1 MVIS 1 42.92 15961.99
16 302100140256 1 MVIS 1 43.20 1458.81
17 302100140263 1 MVIS 1 43.20 1458.81
18 302100140270 1 MVIS 1 42.29 1458.81
19 302100140287 1 MVIS 1 43.20 1458.81
20 302100140321 1 MVIS 1 32.00 1458.81
21 302190490106 1 MVIS 1 39.00 9465.66
22 302340560416 1 MVIS 1 58.81 3309.39
23 302580120173 1 MVIS 1 31.00 9703.32
24 302850180545 1 MVIS 1 42.62 8106.00
25 302850180552 1 MVIS 1 63.29 8106.00
26 302850180569 1 MVIS 1 11.98 8106.00
27 302850180576 1 MVIS 1 11.98 8106.00
28 302850250090 1 MVIS 1 57.70 9943.89
29 302880230603 1 MVIS 1 52.08 5807.26
30 303260180222 1 MVIS 1 90.00 25618.20
31 303540380056 1 MVIS 1 32.82 5838.47
32 303650250102 1 MVIS 1 14.38 19458.95
33 303650250119 1 MVIS 1 30.08 19458.95
34 303650250126 1 MVIS 1 67.36 19458.95
35 303650250133 1 MVIS 1 101.69 19458.95
36 303650250140 1 MVIS 1 70.38 19458.95
37 303670160641 1 MVIS 1 52.00 5364.52
38 303670160658 1 MVIS 1 62.31 5364.52
39 303670160665 1 MVIS 1 29.56 5364.52
40 303670160672 1 MVIS 1 26.22 5364.52
41 303670160689 1 MVIS 1 75.13 5364.52
42 303670160730 1 MVIS 1 57.00 5364.52
43 304040160399 1 MVIS 1 38.19 8340.92
44 304040160515 1 MVIS 1 37.13 8340.92
45 304040160522 1 MVIS 1 54.17 8340.92
46 304660390140 1 MVIS 1 34.00 4554.36
47 304730420519 1 MVIS 1 179.76 13574.99
48 304730420526 1 MVIS 1 230.00 13574.99
49 304820210012 1 MVIS 1 185.96 4217.27
50 304820210067 1 MVIS 1 16.56 4217.27
HC-026I 11:19 Wednesday, December 19, 2001 7
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Analysis Variable : OBXP98X SUM OF OBSF98X-OBOT98X (IMPUTED)
N Sum
------------------
1608 132674.92
------------------
HC-026I 11:19 Wednesday, December 19, 2001 8
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
Analysis Variable : OBXP98X SUM OF OBSF98X-OBOT98X (IMPUTED)
Sum
------------
1426547322
------------
1 The SAS System 11:25 Wednesday, December 19, 2001
NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 6.12 TS060
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC, Site 0026405003.
1
2 OPTIONS LS=132 PS=59;
3
4 TITLE1 "HC-026I";
5 TITLE2 'Sample SAS Job for Example D';
6
7 LIBNAME IN 'C:\';
NOTE: Directory for library IN contains files of mixed engine types.
NOTE: Libref IN was successfully assigned as follows:
Engine: V612
Physical Name: C:\
8 **************************************************************************************
9 * Calculate the expenditures for prescribed medicines associated
10 * with insulin reported by the household as an other medical expense.
11 **************************************************************************************;
12
13 PROC FORMAT;
14 VALUE EVENTYPE
15 1 = "1 MVIS"
16 2 = "2 OPAT"
17 3 = "3 EROM"
18 4 = "4 STAZ"
19 5 = "5 DVIS"
20 6 = "6 OMED"
21 7 = "7 HVIS"
22 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
23
24 VALUE OMTYPE
25 -9 = '-9 NOT ASCERTAINED'
26 -8 = '-8 DK'
27 -7 = '-7 REFUSED'
28 -1 = '-1 INAPPLICABLE'
29 1 = '1 GLASSES OR CONTACT LENSES'
30 2 = '2 INSULIN'
31 3 = '3 DIABETIC EQUIPMENT/SUPPLIES'
32 4 = '4 AMBULANCE SERVICES'
33 5 = '5 ORTHOPEDIC ITEMS'
34 6 = '6 HEARING DEVICES'
35 7 = '7 PROSTHESIS'
36 8 = '8 BATHROOM AIDS'
37 9 = '9 MEDICAL EQUIPMENT'
38 10 = '10 DISPOSABLE SUPPLIES'
39 11 = '11 ALTERATIONS/MODIFICATIONS'
40 91 = '91 OTHER'
41 ;
NOTE: Format OMTYPE has been output.
42 RUN;
NOTE: The PROCEDURE FORMAT used 0.11 seconds.
2 The SAS System 11:25 Wednesday, December 19, 2001
43
44 *-------------------------------------------------------------------------------------
45 * Get other medical records for insulin for persons with positive weights.
46 *-------------------------------------------------------------------------------------;
47
48 DATA OMED;
49 SET IN.H26CF1 (KEEP=EVNTIDX WTDPER98 OMTYPEX);
50 IF WTDPER98 > 0 & OMTYPEX = 2;
51 RUN;
NOTE: The data set WORK.OMED has 386 observations and 3 variables.
NOTE: The DATA statement used 0.16 seconds.
52
53 proc print data=omed (obs=100);
54 var evntidx OMTYPEX WTDPER98;
55 format OMTYPEX omtype.;
56 title3 "sample print of OMED (HC-026C) records where OMTYPEX=2";
57 run;
NOTE: The PROCEDURE PRINT printed pages 1-2.
NOTE: The PROCEDURE PRINT used 0.33 seconds.
58
59 *-------------------------------------------------------------------------------------
60 * Get PMED IDs linked to the OMED events which were for insulin.
61 *-------------------------------------------------------------------------------------;
62
63 PROC SORT DATA=IN.H26IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: The data set WORK.RXLK has 41264 observations and 5 variables.
NOTE: The PROCEDURE SORT used 1.09 seconds.
64
65 proc print data=rxlk (obs=150);
66 by evntidx;
67 id evntidx;
68 var linkidx eventype;
69 format eventype eventype.;
70 title3 "sample print of Rx+event link file records (HC-26IF2) - sorted by eventidx";
71 run;
NOTE: The PROCEDURE PRINT printed pages 3-7.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
72
73 data omedrxlk;
74 set rxlk (where=(eventype=6));
75 run;
NOTE: The data set WORK.OMEDRXLK has 998 observations and 5 variables.
NOTE: The DATA statement used 0.16 seconds.
3 The SAS System 11:25 Wednesday, December 19, 2001
76 proc print data=omedrxlk (obs=120);
77 by evntidx;
78 id evntidx;
79 var linkidx eventype;
80 format eventype eventype.;
81 title3 "sample print of work.omedrxlk - sorted by eventidx";
82 title4 "Rx+event link file records (HC-26IF2) where eventype=6 (omed)";
83 run;
NOTE: The PROCEDURE PRINT printed pages 8-12.
NOTE: The PROCEDURE PRINT used 0.11 seconds.
84
85 DATA PMEDIDS;
86 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
87 OMED (IN=INOMED KEEP=EVNTIDX);
88 BY EVNTIDX;
89 IF INRXLK & INOMED;
90 RUN;
NOTE: The data set WORK.PMEDIDS has 363 observations and 3 variables.
NOTE: The DATA statement used 0.27 seconds.
91
92 proc print data=pmedids (obs=50);
93 by evntidx;
94 id evntidx;
95 format eventype eventype.;
96 title3 "sample print of work.pmedids - sorted by evntidx";
97 title4 "work.rxlk records for omed events for insulin";
98 run;
NOTE: The PROCEDURE PRINT printed pages 13-14.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
99
100 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: The data set WORK.PMEDIDS has 363 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.0 seconds.
101
102 proc print data=pmedids (obs=50);
103 format eventype eventype.;
104 title3 "sample print of work.pmedids - sorted by linkidx";
105 run;
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
4 The SAS System 11:25 Wednesday, December 19, 2001
106
107 DATA PMEDIDS;
108 SET PMEDIDS (KEEP=LINKIDX);
109 BY LINKIDX;
110 IF FIRST.LINKIDX;
111 KEEP LINKIDX;
112 RUN;
NOTE: The data set WORK.PMEDIDS has 363 observations and 1 variables.
NOTE: The DATA statement used 0.05 seconds.
113
114 proc print data=pmedids (obs=50);
115 title3 "sample print of unique linkidxs in work.pmedids";
116 run;
NOTE: The PROCEDURE PRINT printed page 16.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
117
118
119 *------------------------------------------------------------------------------------
120 * Get PMED records for OMED event which were for insulin.
121 *------------------------------------------------------------------------------------;
122 PROC SORT DATA=IN.H26A OUT=PMED; BY LINKIDX; RUN;
NOTE: The data set WORK.PMED has 172031 observations and 51 variables.
NOTE: The PROCEDURE SORT used 33.39 seconds.
123
124 DATA OMPMEDS;
125 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP98X WTDPER98 RXNAME)
126 PMEDIDS (IN=A);
127 BY LINKIDX;
128 IF A & WTDPER98>0;
129 RUN;
NOTE: The data set WORK.OMPMEDS has 1455 observations and 5 variables.
NOTE: The DATA statement used 6.15 seconds.
130
131 proc print data=ompmeds (obs=200);
132 by linkidx;
133 id linkidx;
134 var rxrecidx rxname RXXP98X WTDPER98;
135 title3 "sample print of work.pmeds";
136 title4 "PMED (HC-026A) records for unique linkidxs in work.pmedids";
137 run;
NOTE: The PROCEDURE PRINT printed pages 17-22.
NOTE: The PROCEDURE PRINT used 0.22 seconds.
5 The SAS System 11:25 Wednesday, December 19, 2001
138
139 PROC MEANS DATA=OMPMEDS N SUM;
140 VAR RXXP98X;
141 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
142 RUN;
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: The PROCEDURE MEANS used 0.05 seconds.
143
144 PROC MEANS DATA=OMPMEDS N SUM;
145 VAR RXXP98X;
146 WEIGHT WTDPER98;
147 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
148 TITLE5 "Weighted";
149 RUN;
NOTE: The PROCEDURE MEANS printed page 24.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
150
151
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-026I 11:25 Wednesday, December 19, 2001 1
Sample SAS Job for Example D
sample print of OMED (HC-026C) records where OMTYPEX=2
OBS EVNTIDX OMTYPEX WTDPER98
1 300240180530 2 INSULIN 3714.96
2 300250110201 2 INSULIN 3120.23
3 300250110263 2 INSULIN 3120.23
4 300890120705 2 INSULIN 8352.31
5 301060183220 2 INSULIN 1749.53
6 301140270818 2 INSULIN 7077.24
7 301140271037 2 INSULIN 7077.24
8 301140271171 2 INSULIN 7077.24
9 301230220119 2 INSULIN 12784.86
10 301230220208 2 INSULIN 12784.86
11 301230220253 2 INSULIN 12784.86
12 302220160376 2 INSULIN 1153.65
13 302220160650 2 INSULIN 1153.65
14 303070170168 2 INSULIN 4084.39
15 303070170219 2 INSULIN 4084.39
16 303070170257 2 INSULIN 4084.39
17 304610280640 2 INSULIN 5095.78
18 304610280859 2 INSULIN 5095.78
19 304610280986 2 INSULIN 5095.78
20 304740160492 2 INSULIN 5514.04
21 305030230313 2 INSULIN 4844.49
22 306830190178 2 INSULIN 9500.80
23 306830190250 2 INSULIN 9500.80
24 307460400170 2 INSULIN 5913.78
25 307460400221 2 INSULIN 5913.78
26 307460400245 2 INSULIN 5913.78
27 307520150081 2 INSULIN 3812.19
28 307910140616 2 INSULIN 4240.25
29 307910140863 2 INSULIN 4240.25
30 307920250509 2 INSULIN 8423.78
31 307920250650 2 INSULIN 8423.78
32 308710360177 2 INSULIN 3329.92
33 308710360242 2 INSULIN 3329.92
34 308710360280 2 INSULIN 3329.92
35 308970260491 2 INSULIN 4861.52
36 310680150284 2 INSULIN 3849.70
37 310680220551 2 INSULIN 6771.63
38 310680220924 2 INSULIN 6771.63
39 310880170279 2 INSULIN 18877.97
40 310880170402 2 INSULIN 18877.97
41 310980230141 2 INSULIN 3707.39
42 311090170702 2 INSULIN 8067.56
43 311150110134 2 INSULIN 12428.47
44 311150110261 2 INSULIN 12428.47
45 311150110343 2 INSULIN 12428.47
46 311380130557 2 INSULIN 25293.13
47 311460170265 2 INSULIN 5023.66
48 311460170354 2 INSULIN 5023.66
49 311730210460 2 INSULIN 22206.59
50 312830140397 2 INSULIN 9499.16
51 312830140657 2 INSULIN 9499.16
52 312830140828 2 INSULIN 9499.16
53 313010140361 2 INSULIN 12821.69
HC-026I 11:25 Wednesday, December 19, 2001 2
Sample SAS Job for Example D
sample print of OMED (HC-026C) records where OMTYPEX=2
OBS EVNTIDX OMTYPEX WTDPER98
54 313630120572 2 INSULIN 17521.67
55 313630120692 2 INSULIN 17521.67
56 314620130505 2 INSULIN 18083.43
57 314810210359 2 INSULIN 12774.78
58 314880280103 2 INSULIN 21630.99
59 314880280172 2 INSULIN 21630.99
60 314880280223 2 INSULIN 21630.99
61 315010120852 2 INSULIN 12990.56
62 315010121660 2 INSULIN 12990.56
63 315010121906 2 INSULIN 12990.56
64 315330120715 2 INSULIN 10580.11
65 315330120811 2 INSULIN 10580.11
66 315970280192 2 INSULIN 2754.67
67 315970280318 2 INSULIN 2754.67
68 315970280421 2 INSULIN 2754.67
69 316050340555 2 INSULIN 11966.99
70 316590310147 2 INSULIN 3998.39
71 316590310229 2 INSULIN 3998.39
72 316880160500 2 INSULIN 2569.14
73 317390120392 2 INSULIN 8430.95
74 317420260259 2 INSULIN 11946.01
75 318500190582 2 INSULIN 5901.11
76 318530141438 2 INSULIN 7106.10
77 318660230373 2 INSULIN 838.99
78 319810180311 2 INSULIN 11235.68
79 319810180373 2 INSULIN 11235.68
80 319860190463 2 INSULIN 11892.22
81 319860190658 2 INSULIN 11892.22
82 319860190805 2 INSULIN 11892.22
83 320170730350 2 INSULIN 810.34
84 320170730456 2 INSULIN 810.34
85 320330220267 2 INSULIN 5660.67
86 320330220490 2 INSULIN 5660.67
87 320330220750 2 INSULIN 5660.67
88 320340110370 2 INSULIN 3253.43
89 320340110630 2 INSULIN 3253.43
90 320900110134 2 INSULIN 1469.04
91 322650150225 2 INSULIN 2386.84
92 322650150270 2 INSULIN 2386.84
93 323000130595 2 INSULIN 7621.20
94 323000130824 2 INSULIN 7621.20
95 323000130982 2 INSULIN 7621.20
96 323490150286 2 INSULIN 15605.59
97 323490150368 2 INSULIN 15605.59
98 324240120863 2 INSULIN 5035.79
99 324240121133 2 INSULIN 5035.79
100 324240121311 2 INSULIN 5035.79
HC-026I 11:25 Wednesday, December 19, 2001 3
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-26IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
300010160237 300010160268 2 OPAT
300010160371 300010160446 1 MVIS
300010160453 1 MVIS
300010160460 1 MVIS
300010160477 1 MVIS
300010160484 1 MVIS
300010160422 300010160439 6 OMED
300010230220 300010230251 1 MVIS
300010230237 300010230268 5 DVIS
300010230282 300010230302 1 MVIS
300010230319 1 MVIS
300010230299 300010230302 1 MVIS
300010230319 1 MVIS
300010230326 300010230333 1 MVIS
300010230340 1 MVIS
300010300100 300010300117 1 MVIS
300010300124 1 MVIS
300010300131 1 MVIS
300010300148 1 MVIS
300010300162 300010300193 1 MVIS
300010300206 1 MVIS
300010300213 1 MVIS
300010300220 1 MVIS
300010300179 300010300237 3 EROM
300010300244 300010300268 1 MVIS
300010300275 1 MVIS
300010300282 1 MVIS
300010300299 1 MVIS
300040160522 300040160680 4 STAZ
300040160697 4 STAZ
300040160539 300040160680 4 STAZ
300040160700 4 STAZ
300040160577 300040160680 1 MVIS
300040160957 300040161032 1 MVIS
300040161049 1 MVIS
HC-026I 11:25 Wednesday, December 19, 2001 4
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-26IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
300040160957 300040161056 1 MVIS
300040161063 1 MVIS
300040161070 1 MVIS
300040161087 1 MVIS
300040161094 1 MVIS
300050150140 300050150164 1 MVIS
300050220222 300050220239 4 STAZ
300050220284 300050220304 1 MVIS
300050390486 300050390513 3 EROM
300050390493 300050390520 1 MVIS
300060120555 300060120644 1 MVIS
300060120682 300060120702 4 STAZ
300060120719 4 STAZ
300060120726 4 STAZ
300060120733 4 STAZ
300060120740 4 STAZ
300080250050 300080250074 1 MVIS
300080320067 300080320074 1 MVIS
300090130472 300090130516 1 MVIS
300090130523 1 MVIS
300090440136 300090440201 1 MVIS
300090440218 1 MVIS
300120310032 300120310049 3 EROM
300130250076 300130250090 1 MVIS
300130250103 1 MVIS
300130320134 300130320172 3 EROM
300130320189 3 EROM
300130320230 300130320247 1 MVIS
300130490110 300130490134 1 MVIS
300140210482 300140210502 5 DVIS
300170100072 300170100096 1 MVIS
HC-026I 11:25 Wednesday, December 19, 2001 5
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-26IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
300170100116 300170100109 1 MVIS
300170270109 300170270325 5 DVIS
300170270161 300170270332 4 STAZ
300170270349 4 STAZ
300170270356 4 STAZ
300170270363 4 STAZ
300170270370 4 STAZ
300170270387 4 STAZ
300190190266 300190190348 2 OPAT
300190190300 300190190355 1 MVIS
300190190362 1 MVIS
300190190379 1 MVIS
300190190386 1 MVIS
300200180389 300200180423 1 MVIS
300200180430 1 MVIS
300200180447 1 MVIS
300200180396 300200180454 1 MVIS
300200180409 300200180416 6 OMED
300200180461 300200180485 1 MVIS
300200180492 1 MVIS
300200180505 1 MVIS
300200180512 1 MVIS
300200180478 300200180492 1 MVIS
300200180505 1 MVIS
300200180529 1 MVIS
300230150194 300230150207 1 MVIS
300230220081 300230220125 3 EROM
300230220098 300230220132 1 MVIS
300230220149 300230220170 1 MVIS
300230220163 300230220170 2 OPAT
300240180434 300240180578 4 STAZ
300240180585 4 STAZ
300240180592 4 STAZ
300240180605 4 STAZ
300240180612 4 STAZ
HC-026I 11:25 Wednesday, December 19, 2001 6
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-26IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
300240180530 300240180547 6 OMED
300240180554 300240180561 6 OMED
300240180667 300240180807 1 MVIS
300240180814 1 MVIS
300240180821 1 MVIS
300240180838 1 MVIS
300240180845 1 MVIS
300240180852 1 MVIS
300240180869 1 MVIS
300240180787 300240180794 6 OMED
300250110181 300250110249 1 MVIS
300250110201 300250110218 6 OMED
300250110225 300250110232 6 OMED
300250110263 300250110270 6 OMED
300250110287 300250110294 6 OMED
300250280030 300250280054 3 EROM
300250280061 3 EROM
300250280078 3 EROM
300250280085 3 EROM
300250280092 300250280129 3 EROM
300250280105 300250280136 1 MVIS
300270190357 300270190408 1 MVIS
300270260124 300270260213 1 MVIS
300270260162 300270260220 1 MVIS
300280130104 300280130128 1 MVIS
300280130142 1 MVIS
300330100583 300330100665 1 MVIS
300330100627 300330100672 4 STAZ
300330100689 300330100747 4 STAZ
300330100723 300330100754 1 MVIS
300330100761 1 MVIS
HC-026I 11:25 Wednesday, December 19, 2001 7
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-26IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
300330100723 300330100778 1 MVIS
300330100730 300330100785 1 MVIS
300350180350 300350180463 2 OPAT
300350180401 300350180470 1 MVIS
300350180487 1 MVIS
300370140092 300370140129 1 MVIS
300370210030 300370210054 1 MVIS
300370210061 1 MVIS
300370210078 1 MVIS
300380100051 300380100157 1 MVIS
300380100099 300380100164 1 MVIS
300380270253 300380270277 5 DVIS
300380270291 300380270335 1 MVIS
300380270311 300380270342 5 DVIS
300390160870 300390160983 1 MVIS
300390160938 300390160990 1 MVIS
300390160945 300390161006 1 MVIS
300390160952 300390161013 3 EROM
HC-026I 11:25 Wednesday, December 19, 2001 8
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-26IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
300010160422 300010160439 6 OMED
300200180409 300200180416 6 OMED
300240180530 300240180547 6 OMED
300240180554 300240180561 6 OMED
300240180787 300240180794 6 OMED
300250110201 300250110218 6 OMED
300250110225 300250110232 6 OMED
300250110263 300250110270 6 OMED
300250110287 300250110294 6 OMED
300850660755 300850660762 6 OMED
300860170565 300860170572 6 OMED
300860170661 300860170678 6 OMED
300890120705 300890120712 6 OMED
300890120729 300890120736 6 OMED
300890120921 300890120938 6 OMED
300930560155 300930560162 6 OMED
301140270818 301140270825 6 OMED
301140270832 301140270849 6 OMED
301140271037 301140271044 6 OMED
301140271051 301140271068 6 OMED
301140271171 301140271188 6 OMED
301140271195 301140271208 6 OMED
301230220119 301230220126 6 OMED
301230220133 301230220140 6 OMED
301230220208 301230220215 6 OMED
HC-026I 11:25 Wednesday, December 19, 2001 9
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-26IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
301230220222 301230220239 6 OMED
301230220253 301230220260 6 OMED
301230220277 301230220284 6 OMED
301440150242 301440150259 6 OMED
301440150355 301440150362 6 OMED
301440150444 301440150451 6 OMED
301640160335 301640160342 6 OMED
302220160376 302220160383 6 OMED
302220160390 302220160403 6 OMED
302220160650 302220160667 6 OMED
302220160674 302220160681 6 OMED
303070170168 303070170175 6 OMED
303070170182 303070170199 6 OMED
303070170219 303070170226 6 OMED
303070170233 303070170240 6 OMED
303070170257 303070170264 6 OMED
303070170271 303070170288 6 OMED
303520110337 303520110344 6 OMED
304000180479 304000180486 6 OMED
304610280640 304610280657 6 OMED
304610280664 304610280671 6 OMED
304610280835 304610280842 6 OMED
304610280859 304610280866 6 OMED
304610280986 304610280993 6 OMED
304610281009 304610281016 6 OMED
HC-026I 11:25 Wednesday, December 19, 2001 10
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-26IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
304740160492 304740160505 6 OMED
304740160512 304740160529 6 OMED
304950100238 304950100245 6 OMED
305030230313 305030230320 6 OMED
305030230337 305030230344 6 OMED
305030230642 305030230659 6 OMED
306050140864 306050140871 6 OMED
306830190178 306830190185 6 OMED
306830190192 306830190205 6 OMED
306830190250 306830190267 6 OMED
307130130899 307130130902 6 OMED
307130131361 307130131378 6 OMED
307460400170 307460400187 6 OMED
307460400194 307460400207 6 OMED
307460400221 307460400238 6 OMED
307460400245 307460400252 6 OMED
307520150067 307520150074 6 OMED
307520150081 307520150098 6 OMED
307590200308 307590200315 6 OMED
307590200404 307590200411 6 OMED
307780380732 307780380749 6 OMED
307910140616 307910140623 6 OMED
307910140630 307910140647 6 OMED
307910140863 307910140870 6 OMED
307910140887 307910140894 6 OMED
HC-026I 11:25 Wednesday, December 19, 2001 11
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-26IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
307910141037 307910141044 6 OMED
307920250509 307920250516 6 OMED
307920250523 307920250530 6 OMED
307920250650 307920250667 6 OMED
307920250674 307920250681 6 OMED
308260150120 308260150137 6 OMED
308260150144 308260150151 6 OMED
308710360191 308710360204 6 OMED
308710360242 308710360259 6 OMED
308710360266 308710360273 6 OMED
308710360280 308710360297 6 OMED
308710360300 308710360317 6 OMED
308970260491 308970260504 6 OMED
308970260511 308970260528 6 OMED
309260140184 309260140191 6 OMED
309260140393 309260140406 6 OMED
310130530184 310130530191 6 OMED
310140180498 310140180501 6 OMED
310680150284 310680150291 6 OMED
310680150304 310680150311 6 OMED
310680150455 310680150462 6 OMED
310680220551 310680220568 6 OMED
310680220575 310680220582 6 OMED
310680220924 310680220931 6 OMED
310680220948 310680220955 6 OMED
HC-026I 11:25 Wednesday, December 19, 2001 12
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-26IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
310880170293 310880170306 6 OMED
310880170402 310880170419 6 OMED
310880170426 310880170433 6 OMED
311090170702 311090170719 6 OMED
311090170726 311090170733 6 OMED
311150110134 311150110141 6 OMED
311150110261 311150110278 6 OMED
311150110285 311150110292 6 OMED
311150110343 311150110350 6 OMED
311150110367 311150110374 6 OMED
311380130557 311380130564 6 OMED
311380130571 311380130588 6 OMED
311460170265 311460170272 6 OMED
311460170289 311460170296 6 OMED
311460170354 311460170361 6 OMED
311710260382 311710260399 6 OMED
311710260844 311710260851 6 OMED
311730210460 311730210477 6 OMED
311730210484 311730210491 6 OMED
311840141489 311840141496 6 OMED
HC-026I 11:25 Wednesday, December 19, 2001 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
300240180530 300240180547 6 OMED
300250110201 300250110218 6 OMED
300250110263 300250110270 6 OMED
300890120705 300890120712 6 OMED
301140270818 301140270825 6 OMED
301140271037 301140271044 6 OMED
301140271171 301140271188 6 OMED
301230220119 301230220126 6 OMED
301230220208 301230220215 6 OMED
301230220253 301230220260 6 OMED
302220160376 302220160383 6 OMED
302220160650 302220160667 6 OMED
303070170168 303070170175 6 OMED
303070170219 303070170226 6 OMED
303070170257 303070170264 6 OMED
304610280640 304610280657 6 OMED
304610280859 304610280866 6 OMED
304610280986 304610280993 6 OMED
304740160492 304740160505 6 OMED
305030230313 305030230320 6 OMED
306830190178 306830190185 6 OMED
306830190250 306830190267 6 OMED
307460400170 307460400187 6 OMED
307460400221 307460400238 6 OMED
307460400245 307460400252 6 OMED
HC-026I 11:25 Wednesday, December 19, 2001 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
307520150081 307520150098 6 OMED
307910140616 307910140623 6 OMED
307910140863 307910140870 6 OMED
307920250509 307920250516 6 OMED
307920250650 307920250667 6 OMED
308710360242 308710360259 6 OMED
308710360280 308710360297 6 OMED
308970260491 308970260504 6 OMED
310680150284 310680150291 6 OMED
310680220551 310680220568 6 OMED
310680220924 310680220931 6 OMED
310880170402 310880170419 6 OMED
311090170702 311090170719 6 OMED
311150110134 311150110141 6 OMED
311150110261 311150110278 6 OMED
311150110343 311150110350 6 OMED
311380130557 311380130564 6 OMED
311460170265 311460170272 6 OMED
311460170354 311460170361 6 OMED
311730210460 311730210477 6 OMED
312830140397 312830140400 6 OMED
312830140657 312830140664 6 OMED
312830140828 312830140835 6 OMED
313010140361 313010140378 6 OMED
313630120572 313630120589 6 OMED
HC-026I 11:25 Wednesday, December 19, 2001 15
Sample SAS Job for Example D
sample print of work.pmedids - sorted by linkidx
OBS EVNTIDX LINKIDX EVENTYPE
1 300240180530 300240180547 6 OMED
2 300250110201 300250110218 6 OMED
3 300250110263 300250110270 6 OMED
4 300890120705 300890120712 6 OMED
5 301140270818 301140270825 6 OMED
6 301140271037 301140271044 6 OMED
7 301140271171 301140271188 6 OMED
8 301230220119 301230220126 6 OMED
9 301230220208 301230220215 6 OMED
10 301230220253 301230220260 6 OMED
11 302220160376 302220160383 6 OMED
12 302220160650 302220160667 6 OMED
13 303070170168 303070170175 6 OMED
14 303070170219 303070170226 6 OMED
15 303070170257 303070170264 6 OMED
16 304610280640 304610280657 6 OMED
17 304610280859 304610280866 6 OMED
18 304610280986 304610280993 6 OMED
19 304740160492 304740160505 6 OMED
20 305030230313 305030230320 6 OMED
21 306830190178 306830190185 6 OMED
22 306830190250 306830190267 6 OMED
23 307460400170 307460400187 6 OMED
24 307460400221 307460400238 6 OMED
25 307460400245 307460400252 6 OMED
26 307520150081 307520150098 6 OMED
27 307910140616 307910140623 6 OMED
28 307910140863 307910140870 6 OMED
29 307920250509 307920250516 6 OMED
30 307920250650 307920250667 6 OMED
31 308710360242 308710360259 6 OMED
32 308710360280 308710360297 6 OMED
33 308970260491 308970260504 6 OMED
34 310680150284 310680150291 6 OMED
35 310680220551 310680220568 6 OMED
36 310680220924 310680220931 6 OMED
37 310880170402 310880170419 6 OMED
38 311090170702 311090170719 6 OMED
39 311150110134 311150110141 6 OMED
40 311150110261 311150110278 6 OMED
41 311150110343 311150110350 6 OMED
42 311380130557 311380130564 6 OMED
43 311460170265 311460170272 6 OMED
44 311460170354 311460170361 6 OMED
45 311730210460 311730210477 6 OMED
46 312830140397 312830140400 6 OMED
47 312830140657 312830140664 6 OMED
48 312830140828 312830140835 6 OMED
49 313010140361 313010140378 6 OMED
50 313630120572 313630120589 6 OMED
HC-026I 11:25 Wednesday, December 19, 2001 16
Sample SAS Job for Example D
sample print of unique linkidxs in work.pmedids
OBS LINKIDX
1 300240180547
2 300250110218
3 300250110270
4 300890120712
5 301140270825
6 301140271044
7 301140271188
8 301230220126
9 301230220215
10 301230220260
11 302220160383
12 302220160667
13 303070170175
14 303070170226
15 303070170264
16 304610280657
17 304610280866
18 304610280993
19 304740160505
20 305030230320
21 306830190185
22 306830190267
23 307460400187
24 307460400238
25 307460400252
26 307520150098
27 307910140623
28 307910140870
29 307920250516
30 307920250667
31 308710360259
32 308710360297
33 308970260504
34 310680150291
35 310680220568
36 310680220931
37 310880170419
38 311090170719
39 311150110141
40 311150110278
41 311150110350
42 311380130564
43 311460170272
44 311460170361
45 311730210477
46 312830140400
47 312830140664
48 312830140835
49 313010140378
50 313630120589
HC-026I 11:25 Wednesday, December 19, 2001 17
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
300240180547 300240180547001 ILETIN I REGULAR 16.52 3714.96
300240180547002 ILETIN I REGULAR 16.52 3714.96
300250110218 300250110218001 HUMULIN N 20.81 3120.23
300250110218002 HUMULIN N 20.81 3120.23
300250110270 300250110270001 HUMULIN N 17.49 3120.23
300250110270002 HUMULIN N 17.49 3120.23
300250110270003 HUMULIN N 17.49 3120.23
300250110270004 HUMULIN N 17.49 3120.23
300250110270005 HUMULIN N 17.49 3120.23
300250110270006 HUMULIN N 17.49 3120.23
300250110270007 HUMULIN N 17.49 3120.23
300890120712 300890120712001 HUMULIN N 19.99 8352.31
300890120712002 HUMULIN N 19.99 8352.31
300890120712003 HUMULIN N 19.99 8352.31
301140270825 301140270825001 HUMULIN N 17.51 7077.24
301140270825002 HUMULIN N 18.38 7077.24
301140270825003 HUMULIN N 18.38 7077.24
301140270825004 HUMULIN N 18.38 7077.24
301140271044 301140271044001 HUMULIN N 18.38 7077.24
301140271044002 HUMULIN N 20.10 7077.24
301140271044003 HUMULIN N 20.10 7077.24
301140271044004 HUMULIN N 20.10 7077.24
301140271188 301140271188001 HUMULIN N 20.10 7077.24
301230220126 301230220126001 HUMULIN R 20.56 12784.86
301230220126002 HUMULIN R 20.56 12784.86
301230220215 301230220215001 HUMULIN R 20.56 12784.86
301230220215002 HUMULIN R 20.56 12784.86
301230220260 301230220260001 HUMULIN R 20.56 12784.86
301230220260002 HUMULIN R 20.56 12784.86
302220160383 302220160383001 INSULIN REG 2.14 1153.65
302220160383002 INSULIN REG 2.14 1153.65
302220160383003 INSULIN REG 2.14 1153.65
302220160383004 INSULIN REG 2.14 1153.65
302220160667 302220160667001 HUMULIN N VIAL 62.43 1153.65
302220160667002 HUMULIN N VIAL 62.43 1153.65
302220160667003 HUMULIN N VIAL 62.43 1153.65
302220160667004 HUMULIN N VIAL 62.43 1153.65
HC-026I 11:25 Wednesday, December 19, 2001 18
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
303070170175 303070170175001 INSULIN REG 2.14 4084.39
303070170175002 INSULIN REG 2.14 4084.39
303070170175003 INSULIN REG 2.14 4084.39
303070170226 303070170226001 INSULIN REG 2.14 4084.39
303070170226002 INSULIN REG 2.14 4084.39
303070170226003 INSULIN REG 2.14 4084.39
303070170226004 INSULIN REG 2.14 4084.39
303070170226005 INSULIN REG 2.14 4084.39
303070170226006 INSULIN REG 2.14 4084.39
303070170264 303070170264001 INSULIN REG 46.68 4084.39
303070170264002 INSULIN REG 46.68 4084.39
303070170264003 INSULIN REG 46.68 4084.39
304610280657 304610280657001 ILETIN I REGULAR 24.25 5095.78
304610280657002 ILETIN I REGULAR 24.25 5095.78
304610280657003 ILETIN I REGULAR 24.25 5095.78
304610280866 304610280866001 INSULIN REG 46.68 5095.78
304610280866002 INSULIN REG 46.68 5095.78
304610280866003 INSULIN REG 46.68 5095.78
304610280866004 INSULIN REG 46.68 5095.78
304610280866005 INSULIN REG 46.68 5095.78
304610280993 304610280993001 INSULIN REG 46.68 5095.78
304610280993002 INSULIN REG 46.68 5095.78
304610280993003 INSULIN REG 46.68 5095.78
304610280993004 INSULIN REG 46.68 5095.78
304610280993005 INSULIN REG 46.68 5095.78
304740160505 304740160505001 INSULIN 2.08 5514.04
304740160505002 INSULIN 2.08 5514.04
304740160505003 INSULIN 2.08 5514.04
304740160505004 INSULIN 2.08 5514.04
304740160505005 INSULIN 2.08 5514.04
304740160505006 INSULIN 2.08 5514.04
304740160505007 INSULIN 2.08 5514.04
304740160505008 INSULIN 2.08 5514.04
305030230320 305030230320001 REGULAR INSULIN 24.25 4844.49
305030230320002 REGULAR INSULIN 24.25 4844.49
305030230320003 REGULAR INSULIN 24.25 4844.49
305030230320004 REGULAR INSULIN 24.25 4844.49
305030230320005 REGULAR INSULIN 24.25 4844.49
305030230320006 REGULAR INSULIN 24.25 4844.49
305030230320007 REGULAR INSULIN 24.25 4844.49
306830190185 306830190185001 INSULIN REGULAR 20.02 9500.80
HC-026I 11:25 Wednesday, December 19, 2001 19
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
306830190267 306830190267001 REGULAR INSULIN 24.25 9500.80
307460400187 307460400187001 HUMULIN 70/30 20.81 5913.78
307460400187002 HUMULIN 70/30 20.81 5913.78
307460400187003 HUMULIN 70/30 20.81 5913.78
307460400238 307460400238001 HUMULIN 70/30 20.81 5913.78
307460400238002 HUMULIN 70/30 20.81 5913.78
307460400238003 HUMULIN 70/30 20.81 5913.78
307460400238004 HUMULIN 70/30 41.62 5913.78
307460400238005 HUMULIN 70/30 20.81 5913.78
307460400238006 HUMULIN 70/30 20.81 5913.78
307460400252 307460400252001 INSULIN REG 2.14 5913.78
307520150098 307520150098001 HUMULIN 70/30 41.62 3812.19
307520150098002 HUMULIN 70/30 41.62 3812.19
307910140623 307910140623001 HUMULIN N 38.21 4240.25
307910140623002 HUMULIN N 38.21 4240.25
307910140870 307910140870001 HUMULIN R 20.10 4240.25
307910140870002 HUMULIN R 20.10 4240.25
307910140870003 HUMULIN R 20.10 4240.25
307910140870004 HUMULIN R 20.10 4240.25
307910140870005 HUMULIN R 20.10 4240.25
307920250516 307920250516001 HUMULIN N 62.43 8423.78
307920250516002 HUMULIN N 62.43 8423.78
307920250516003 HUMULIN N 62.43 8423.78
307920250516004 HUMULIN N 62.43 8423.78
307920250516005 HUMULIN N 62.43 8423.78
307920250516006 HUMULIN N 62.43 8423.78
307920250667 307920250667001 HUMULIN 70/30 41.62 8423.78
307920250667002 HUMULIN 70/30 41.62 8423.78
308710360259 308710360259001 INSULIN REG 46.68 3329.92
308710360259002 INSULIN REG 46.68 3329.92
308710360259003 INSULIN REG 46.68 3329.92
308710360297 308710360297001 ILETIN I REGULAR 24.25 3329.92
308710360297002 ILETIN I REGULAR 24.25 3329.92
308970260504 308970260504001 INSULIN REG 46.68 4861.52
308970260504002 INSULIN REG 46.68 4861.52
308970260504003 INSULIN REG 46.68 4861.52
308970260504004 INSULIN REG 46.68 4861.52
308970260504005 INSULIN REG 46.68 4861.52
HC-026I 11:25 Wednesday, December 19, 2001 20
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
310680150291 310680150291001 INSULIN REG 2.14 3849.70
310680220568 310680220568001 INSULIN REG 46.68 6771.63
310680220568002 INSULIN REG 46.68 6771.63
310680220568003 INSULIN REG 46.68 6771.63
310680220931 310680220931001 ILETIN I REGULAR 16.52 6771.63
310680220931002 ILETIN I REGULAR 16.52 6771.63
310680220931003 ILETIN I REGULAR 16.52 6771.63
310880170419 310880170419001 INSULIN REG 46.68 18877.97
311090170719 311090170719001 HUMULIN R 83.24 8067.56
311090170719002 HUMULIN R 83.24 8067.56
311150110141 311150110141001 INSULIN REGULAR 20.02 12428.47
311150110141002 INSULIN REGULAR 20.02 12428.47
311150110278 311150110278001 HUMULIN-N 20.02 12428.47
311150110278002 HUMULIN-N 20.02 12428.47
311150110278003 HUMULIN-N 20.02 12428.47
311150110278004 HUMULIN-N 20.02 12428.47
311150110278005 HUMULIN-N 20.02 12428.47
311150110278006 HUMULIN-N 20.02 12428.47
311150110350 311150110350001 HUMULIN-R 20.02 12428.47
311150110350002 HUMULIN-R 20.02 12428.47
311150110350003 HUMULIN-R 20.02 12428.47
311380130564 311380130564001 INSULIN REG 2.14 25293.13
311380130564002 INSULIN REG 2.14 25293.13
311460170272 311460170272001 HUMULIN ULTRALENTE 16.83 5023.66
311460170272002 HUMULIN ULTRALENTE 16.83 5023.66
311460170272003 HUMULIN ULTRALENTE 16.83 5023.66
311460170272004 HUMULIN ULTRALENTE 16.83 5023.66
311460170272005 HUMULIN ULTRALENTE 16.87 5023.66
311460170361 311460170361001 HUMULIN R 16.87 5023.66
311460170361002 HUMULIN R 16.87 5023.66
311460170361003 HUMULIN R 16.87 5023.66
311460170361004 HUMULIN R 16.87 5023.66
311460170361005 HUMULIN R 16.87 5023.66
311460170361006 HUMULIN R 16.87 5023.66
311460170361007 HUMULIN R 16.87 5023.66
311730210477 311730210477001 INSULIN REG 2.14 22206.59
311730210477002 INSULIN REG 2.14 22206.59
HC-026I 11:25 Wednesday, December 19, 2001 21
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
312830140400 312830140400001 ILETIN I REGULAR 16.52 9499.16
312830140664 312830140664001 INSULIN REG 46.68 9499.16
312830140664002 INSULIN REG 46.68 9499.16
312830140664003 INSULIN REG 46.68 9499.16
312830140664004 INSULIN REG 46.68 9499.16
312830140664005 INSULIN REG 46.68 9499.16
312830140835 312830140835001 INSULIN REG 2.14 9499.16
312830140835002 INSULIN REG 2.14 9499.16
312830140835003 INSULIN REG 2.14 9499.16
313010140378 313010140378001 ILETIN I REGULAR 24.25 12821.69
313010140378002 ILETIN I REGULAR 24.25 12821.69
313010140378003 ILETIN I REGULAR 24.25 12821.69
313010140378004 ILETIN I REGULAR 24.25 12821.69
313010140378005 ILETIN I REGULAR 24.25 12821.69
313630120589 313630120589001 INSULIN REG 2.14 17521.67
313630120589002 INSULIN REG 2.14 17521.67
313630120705 313630120705001 INSULIN REG 46.68 17521.67
313630120705002 INSULIN REG 46.68 17521.67
313630120705003 INSULIN REG 46.68 17521.67
313630120705004 INSULIN REG 46.68 17521.67
313630120705005 INSULIN REG 46.68 17521.67
313630120705006 INSULIN REG 46.68 17521.67
313630120705007 INSULIN REG 46.68 17521.67
313630120705008 INSULIN REG 46.68 17521.67
314620130512 314620130512001 REGULAR INSULIN 24.25 18083.43
314620130512002 REGULAR INSULIN 24.25 18083.43
314620130512003 REGULAR INSULIN 24.25 18083.43
314620130512004 REGULAR INSULIN 24.25 18083.43
314810210366 314810210366001 HUMULIN N 19.69 12774.78
314810210366002 HUMULIN N 19.69 12774.78
314810210366003 HUMULIN N 19.69 12774.78
314880280110 314880280110001 HUMULIN 70/30 59.69 21630.99
314880280110002 HUMULIN 70/30 59.69 21630.99
314880280110003 HUMULIN 70/30 59.69 21630.99
314880280189 314880280189001 HUMULIN 70/30 59.69 21630.99
314880280230 314880280230001 HUMULIN 70/30 59.69 21630.99
314880280230002 HUMULIN 70/30 59.69 21630.99
315010120869 315010120869001 HUMULIN R 41.22 12990.56
HC-026I 11:25 Wednesday, December 19, 2001 22
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-026A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP98X WTDPER98
315010120869 315010120869002 HUMULIN R 41.22 12990.56
315010121677 315010121677001 HUMULIN R 78.26 12990.56
315010121677002 HUMULIN R 78.26 12990.56
315010121677003 HUMULIN R 78.26 12990.56
315010121677004 HUMULIN R 78.26 12990.56
315010121913 315010121913001 HUMULIN R 78.26 12990.56
315010121913002 HUMULIN R 78.26 12990.56
315010121913003 HUMULIN R 78.26 12990.56
315330120722 315330120722001 HUMULIN 70/30 INSULIN 39.13 10580.11
HC-026I 11:25 Wednesday, December 19, 2001 23
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
Analysis Variable : RXXP98X SUM OF PAYMENTS RXSF98X-RXOU98X(IMPUTED)
N Sum
------------------
1455 39952.00
------------------
HC-026I 11:25 Wednesday, December 19, 2001 24
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
Weighted
Analysis Variable : RXXP98X SUM OF PAYMENTS RXSF98X-RXOU98X(IMPUTED)
N Sum
------------------
1455 400292418
------------------
<< previous page