xx 1 The SAS System 10:34 Friday, July 14, 2000
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-010I";
4
5 LIBNAME IN 'D:\';
NOTE: Libref IN was successfully assigned as follows:
Engine: V612
Physical Name: D:\
6
7 ************************************************************************************************
8 * Calculate the expenditures for prescribed medicines associated with medical visits for asthma.
9 ************************************************************************************************;
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
22 RUN;
NOTE: The PROCEDURE FORMAT used 0.33 seconds.
23
24 *-------------------------------------------------------------------------------------
25 * Get condition records coded as asthma.
26 *-------------------------------------------------------------------------------------;
27 DATA ASCONDS;
28 SET IN.HC006R (KEEP=CONDIDX CCCODEX);
29 IF CCCODEX="128";
30
31 RUN;
NOTE: The data set WORK.ASCONDS has 982 observations and 2 variables.
NOTE: The DATA statement used 4.62 seconds.
32
33 *------------------------------------------------------------------------------------
34 * Get the events linked to each of the asthma condition records.
35 *------------------------------------------------------------------------------------;
36 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: The data set WORK.ASCONDS has 982 observations and 2 variables.
2 The SAS System 10:34 Friday, July 14, 2000
NOTE: The PROCEDURE SORT used 0.17 seconds.
37
38 proc print data=asconds (obs=50);
39 title3 "sample print of work.asconds - sorted by condidx";
40 title4 "COND (HC-006R) records where cccodex=128";
41 run;
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: The PROCEDURE PRINT used 0.22 seconds.
42
43 PROC SORT DATA=IN.HC10IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: The data set WORK.CLNK has 198363 observations and 5 variables.
NOTE: The PROCEDURE SORT used 12.67 seconds.
44
45 DATA ASCLNKS;
46 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
47 ASCONDS(IN=INASCOND KEEP=CONDIDX);
48 BY CONDIDX;
49 IF INCLNK & INASCOND;
50 RUN;
NOTE: The data set WORK.ASCLNKS has 4319 observations and 3 variables.
NOTE: The DATA statement used 1.81 seconds.
51
52 proc print data=asclnks (obs=75);
53 by condidx;
54 id condidx;
55 format eventype eventype.;
56 title3 "sample print of work.asclnks - sorted by condidx";
57 title4 "events linked to asthma condition records";
58 run;
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: The PROCEDURE PRINT used 0.39 seconds.
59
60 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: The data set WORK.ASCLNKS has 4319 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.11 seconds.
61
62 proc print data=asclnks (obs=50);
63 format eventype eventype.;
64 title3 "sample print of work.asclnks - sorted by evntidx";
65 run;
3 The SAS System 10:34 Friday, July 14, 2000
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
66
67 DATA ASCLNKS;
68 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
69 BY EVNTIDX;
70 IF FIRST.EVNTIDX;
71 RUN;
NOTE: The data set WORK.ASCLNKS has 4304 observations and 2 variables.
NOTE: The DATA statement used 0.11 seconds.
72
73 proc print data=asclnks (obs=50);
74 title3 "sample print of unique evntidxs from work.asclnks";
75 format eventype eventype.;
76 run;
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
77
78 *--------------------------------------------------------------------------------------------
79 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
80 *--------------------------------------------------------------------------------------------;
81 DATA MVIS;
82 SET IN.HC10GF1 (KEEP=EVNTIDX WTDPER96 SEETLKPV);
83 IF WTDPER96 > 0 & SEETLKPV NE 2;
84 RUN;
NOTE: The data set WORK.MVIS has 95287 observations and 3 variables.
NOTE: The DATA statement used 8.66 seconds.
85
86 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: The data set WORK.MVIS has 95287 observations and 3 variables.
NOTE: The PROCEDURE SORT used 1.54 seconds.
87
88 *---------------------------------------------------------------------------------------------
89 * Identify MVIS events which were for asthma.
90 *---------------------------------------------------------------------------------------------;
91 DATA ASMVIS;
92 MERGE ASCLNKS (IN=INASCLNK)
93 MVIS (IN=INMVIS KEEP=EVNTIDX);
94 BY EVNTIDX;
95 IF INASCLNK & INMVIS;
96 RUN;
4 The SAS System 10:34 Friday, July 14, 2000
NOTE: The data set WORK.ASMVIS has 1420 observations and 2 variables.
NOTE: The DATA statement used 0.6 seconds.
97
98 proc print data=asmvis (obs=50);
99 format eventype eventype.;
100 title3 "sample print of work.asmvis";
101 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-010G) events";
102 run;
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: The PROCEDURE PRINT used 0.27 seconds.
103
104 *-------------------------------------------------------------------------------------
105 * Get PMED IDs linked to the MVIS events which were for asthma.
106 *-------------------------------------------------------------------------------------;
107 PROC SORT DATA=IN.HC10IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: The data set WORK.RXLK has 41069 observations and 5 variables.
NOTE: The PROCEDURE SORT used 1.42 seconds.
108
109 proc print data=rxlk (obs=140);
110 by evntidx;
111 id evntidx;
112 var linkidx eventype;
113 format eventype eventype.;
114 title3 "sample print of work.rxlk - sorted by eventidx";
115 title4 "Rx+event link file records (HC-10IF2)";
116 run;
NOTE: The PROCEDURE PRINT printed pages 7-11.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
117
118 DATA PMEDIDS;
119 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
120 ASMVIS(IN=INASMVIS KEEP=EVNTIDX);
121 BY EVNTIDX;
122 IF INRXLK & INASMVIS;
123 RUN;
NOTE: The data set WORK.PMEDIDS has 1106 observations and 3 variables.
NOTE: The DATA statement used 0.27 seconds.
124
125 proc print data=pmedids (obs=50);
126 by evntidx;
127 id evntidx;
128 format eventype eventype.;
129 title3 "sample print of work.pmedids - sorted by evntidx";
5 The SAS System 10:34 Friday, July 14, 2000
130 title4 "work.rxlk records for evntidxs in work.asmvis";
131 run;
NOTE: The PROCEDURE PRINT printed pages 12-13.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
132
133 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: The data set WORK.PMEDIDS has 1106 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.05 seconds.
134
135 proc print data=pmedids (obs=50);
136 format eventype eventype.;
137 title3 "sample print of work.pmedids - sorted by linkidx";
138 run;
NOTE: The PROCEDURE PRINT printed page 14.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
139
140 DATA PMEDIDS;
141 SET PMEDIDS (KEEP=LINKIDX);
142 BY LINKIDX;
143 IF FIRST.LINKIDX;
144 RUN;
NOTE: The data set WORK.PMEDIDS has 1024 observations and 1 variables.
NOTE: The DATA statement used 0.05 seconds.
145
146 proc print data=pmedids (obs=50);
147 title3 "sample print of unique linkidxs in work.pmedids";
148 run;
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
149
150 *-----------------------------------------------------------------------------------------
151 * Get PMED records (excluding free samples) linked to MVIS events which were for asthma.
152 *-----------------------------------------------------------------------------------------;
153 PROC SORT DATA=IN.HC10A OUT=PMED; BY LINKIDX; RUN;
NOTE: The data set WORK.PMED has 171587 observations and 52 variables.
NOTE: The PROCEDURE SORT used 52.22 seconds.
154
155 DATA MVPMEDS;
156 MERGE PMED (KEEP=LINKIDX RXRECIDX FREEFLG RXXP96X WTDPER96 RXNAME)
6 The SAS System 10:34 Friday, July 14, 2000
157 PMEDIDS (IN=A);
158 BY LINKIDX;
159 IF A & FREEFLG=0;
160 RUN;
NOTE: The data set WORK.MVPMEDS has 2918 observations and 6 variables.
NOTE: The DATA statement used 11.65 seconds.
161
162 proc print data=mvpmeds (obs=200);
163 var rxrecidx rxname rxxp96x freeflg wtdper96;
164 by linkidx;
165 id linkidx;
166 title3 "sample print of work.mvpmeds";
167 title4 "PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids";
168 run;
NOTE: The PROCEDURE PRINT printed pages 16-21.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
169
170 PROC MEANS DATA=MVPMEDS N SUM;
171 VAR RXXP96X;
172 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
173 RUN;
NOTE: The PROCEDURE MEANS printed page 22.
NOTE: The PROCEDURE MEANS used 0.27 seconds.
174
175 PROC MEANS DATA=MVPMEDS N SUM;
176 VAR RXXP96X;
177 WEIGHT WTDPER96;
178 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
179 TITLE5 "Weighted";
180 RUN;
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
181
182
183
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-010I 10:34 Friday, July 14, 2000 1
sample print of work.asconds - sorted by condidx
COND (HC-006R) records where cccodex=128
OBS CONDIDX CCCODEX
1 000040320014 128
2 000170710050 128
3 000630450038 128
4 000630450044 128
5 000650110054 128
6 000850580014 128
7 000860130035 128
8 000980120017 128
9 001170160082 128
10 001300290022 128
11 001660130011 128
12 001660370019 128
13 001660440018 128
14 001830490013 128
15 001860600013 128
16 001900110024 128
17 002360270026 128
18 002400120025 128
19 002550290027 128
20 002940230026 128
21 003050120030 128
22 003210280044 128
23 003320230104 128
24 003430100019 128
25 003470170019 128
26 003540170016 128
27 003570290019 128
28 003570360018 128
29 003620170023 128
30 003620310015 128
31 003660480029 128
32 003700290015 128
33 003770240045 128
34 004060270035 128
35 004160280015 128
36 004500120011 128
37 004500450016 128
38 004630460039 128
39 004840190010 128
40 004840520061 128
41 005030330030 128
42 005060320036 128
43 005070320015 128
44 005260160028 128
45 005300270020 128
46 005420210025 128
47 005670410030 128
48 005690210026 128
49 005710290049 128
50 005710430053 128
HC-010I 10:34 Friday, July 14, 2000 2
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
000040320014 000040320012 3 EROM
000170710050 000170710013 1 MVIS
000170710020 8 PMED
000630450038 000630450237 1 MVIS
000630450251 1 MVIS
000630450282 8 PMED
000630450044 000630450268 1 MVIS
000630450282 8 PMED
000650110054 000650110177 1 MVIS
000650110184 1 MVIS
000650110191 1 MVIS
000650110204 1 MVIS
000650110211 1 MVIS
000650110735 8 PMED
000860130035 000860130097 8 PMED
000860130220 1 MVIS
000860130251 8 PMED
000980120017 000980120018 1 MVIS
000980120032 8 PMED
000980120070 8 PMED
001170160082 001170160136 1 MVIS
001170160143 1 MVIS
001170160150 1 MVIS
001170160167 1 MVIS
001170160198 8 PMED
001170160201 8 PMED
001170160218 8 PMED
001300290022 001300290043 8 PMED
001300290163 8 PMED
001300290170 8 PMED
001660130011 001660130011 8 PMED
001660370019 001660370011 8 PMED
001830490013 001830490046 1 MVIS
001830490053 1 MVIS
001830490060 1 MVIS
001830490166 8 PMED
001830490173 8 PMED
001830490375 8 PMED
HC-010I 10:34 Friday, July 14, 2000 3
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
001860600013 001860600019 1 MVIS
001860600026 8 PMED
001860600040 8 PMED
001860600057 8 PMED
001860600071 8 PMED
001860600095 8 PMED
001860600108 8 PMED
001900110024 001900110022 1 MVIS
001900110039 1 MVIS
001900110046 1 MVIS
001900110053 2 OPAT
001900110060 2 OPAT
002360270026 002360270116 1 MVIS
002360270178 2 OPAT
002360270192 8 PMED
002360270212 8 PMED
002550290027 002550290121 8 PMED
002550290138 8 PMED
002550290176 8 PMED
002550290183 8 PMED
002550290210 1 MVIS
002550290234 8 PMED
002550290241 8 PMED
002940230026 002940230142 8 PMED
002940230159 8 PMED
003050120030 003050120011 8 PMED
003050120028 8 PMED
003050120059 1 MVIS
003050120066 1 MVIS
003050120097 8 PMED
003050120100 8 PMED
003050120408 8 PMED
003210280044 003210280465 8 PMED
003210280472 8 PMED
003320230104 003320230176 8 PMED
003430100019 003430100018 8 PMED
003540170016 003540170039 8 PMED
HC-010I 10:34 Friday, July 14, 2000 4
sample print of work.asclnks - sorted by evntidx
OBS CONDIDX EVNTIDX EVENTYPE
1 000040320014 000040320012 3 EROM
2 000170710050 000170710013 1 MVIS
3 000170710050 000170710020 8 PMED
4 000630450038 000630450237 1 MVIS
5 000630450038 000630450251 1 MVIS
6 000630450044 000630450268 1 MVIS
7 000630450038 000630450282 8 PMED
8 000630450044 000630450282 8 PMED
9 000650110054 000650110177 1 MVIS
10 000650110054 000650110184 1 MVIS
11 000650110054 000650110191 1 MVIS
12 000650110054 000650110204 1 MVIS
13 000650110054 000650110211 1 MVIS
14 000650110054 000650110735 8 PMED
15 000860130035 000860130097 8 PMED
16 000860130035 000860130220 1 MVIS
17 000860130035 000860130251 8 PMED
18 000980120017 000980120018 1 MVIS
19 000980120017 000980120032 8 PMED
20 000980120017 000980120070 8 PMED
21 001170160082 001170160136 1 MVIS
22 001170160082 001170160143 1 MVIS
23 001170160082 001170160150 1 MVIS
24 001170160082 001170160167 1 MVIS
25 001170160082 001170160198 8 PMED
26 001170160082 001170160201 8 PMED
27 001170160082 001170160218 8 PMED
28 001300290022 001300290043 8 PMED
29 001300290022 001300290163 8 PMED
30 001300290022 001300290170 8 PMED
31 001660130011 001660130011 8 PMED
32 001660370019 001660370011 8 PMED
33 001830490013 001830490046 1 MVIS
34 001830490013 001830490053 1 MVIS
35 001830490013 001830490060 1 MVIS
36 001830490013 001830490166 8 PMED
37 001830490013 001830490173 8 PMED
38 001830490013 001830490375 8 PMED
39 001860600013 001860600019 1 MVIS
40 001860600013 001860600026 8 PMED
41 001860600013 001860600040 8 PMED
42 001860600013 001860600057 8 PMED
43 001860600013 001860600071 8 PMED
44 001860600013 001860600095 8 PMED
45 001860600013 001860600108 8 PMED
46 001900110024 001900110022 1 MVIS
47 001900110024 001900110039 1 MVIS
48 001900110024 001900110046 1 MVIS
49 001900110024 001900110053 2 OPAT
50 001900110024 001900110060 2 OPAT
HC-010I 10:34 Friday, July 14, 2000 5
sample print of unique evntidxs from work.asclnks
OBS EVNTIDX EVENTYPE
1 000040320012 3 EROM
2 000170710013 1 MVIS
3 000170710020 8 PMED
4 000630450237 1 MVIS
5 000630450251 1 MVIS
6 000630450268 1 MVIS
7 000630450282 8 PMED
8 000650110177 1 MVIS
9 000650110184 1 MVIS
10 000650110191 1 MVIS
11 000650110204 1 MVIS
12 000650110211 1 MVIS
13 000650110735 8 PMED
14 000860130097 8 PMED
15 000860130220 1 MVIS
16 000860130251 8 PMED
17 000980120018 1 MVIS
18 000980120032 8 PMED
19 000980120070 8 PMED
20 001170160136 1 MVIS
21 001170160143 1 MVIS
22 001170160150 1 MVIS
23 001170160167 1 MVIS
24 001170160198 8 PMED
25 001170160201 8 PMED
26 001170160218 8 PMED
27 001300290043 8 PMED
28 001300290163 8 PMED
29 001300290170 8 PMED
30 001660130011 8 PMED
31 001660370011 8 PMED
32 001830490046 1 MVIS
33 001830490053 1 MVIS
34 001830490060 1 MVIS
35 001830490166 8 PMED
36 001830490173 8 PMED
37 001830490375 8 PMED
38 001860600019 1 MVIS
39 001860600026 8 PMED
40 001860600040 8 PMED
41 001860600057 8 PMED
42 001860600071 8 PMED
43 001860600095 8 PMED
44 001860600108 8 PMED
45 001900110022 1 MVIS
46 001900110039 1 MVIS
47 001900110046 1 MVIS
48 001900110053 2 OPAT
49 001900110060 2 OPAT
50 002360270116 1 MVIS
HC-010I 10:34 Friday, July 14, 2000 6
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-010G) events
OBS EVNTIDX EVENTYPE
1 000170710013 1 MVIS
2 000630450237 1 MVIS
3 000630450251 1 MVIS
4 000650110177 1 MVIS
5 000650110184 1 MVIS
6 000650110191 1 MVIS
7 000650110204 1 MVIS
8 000650110211 1 MVIS
9 000860130220 1 MVIS
10 000980120018 1 MVIS
11 001170160136 1 MVIS
12 001170160143 1 MVIS
13 001170160150 1 MVIS
14 001170160167 1 MVIS
15 001830490046 1 MVIS
16 001830490053 1 MVIS
17 001830490060 1 MVIS
18 001860600019 1 MVIS
19 001900110022 1 MVIS
20 001900110039 1 MVIS
21 001900110046 1 MVIS
22 002360270116 1 MVIS
23 002550290210 1 MVIS
24 003050120059 1 MVIS
25 003050120066 1 MVIS
26 003540170104 1 MVIS
27 003540170111 1 MVIS
28 003540170128 1 MVIS
29 003540170135 1 MVIS
30 003570290018 1 MVIS
31 003570290025 1 MVIS
32 003570290032 1 MVIS
33 003570360018 1 MVIS
34 003570360025 1 MVIS
35 003620310014 1 MVIS
36 003620310038 1 MVIS
37 003620310076 1 MVIS
38 003620310083 1 MVIS
39 003660480012 1 MVIS
40 003700290010 1 MVIS
41 003770240020 1 MVIS
42 004840190015 1 MVIS
43 004840190022 1 MVIS
44 005070320058 1 MVIS
45 005260160083 1 MVIS
46 005260160261 1 MVIS
47 005260160278 1 MVIS
48 005260160305 1 MVIS
49 005260160312 1 MVIS
50 005260160329 1 MVIS
HC-010I 10:34 Friday, July 14, 2000 7
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-10IF2)
EVNTIDX LINKIDX EVENTYPE
000020250010 000020250027 1 MVIS
000020320010 000020320027 1 MVIS
000020490010 000020490089 1 MVIS
000020490096 1 MVIS
000020490034 000020490109 1 MVIS
000020490041 000020490116 1 MVIS
000020490058 000020490123 1 MVIS
000020490130 1 MVIS
000020490065 000020490147 4 STAZ
000020490072 000020490130 4 STAZ
000020490154 4 STAZ
000030150125 000030150156 1 MVIS
000030220098 000030220221 1 MVIS
000030220170 000030220238 1 MVIS
000030220310 000030220252 1 MVIS
000040250081 000040250098 6 OMED
000040250125 000040250149 1 MVIS
000040250372 000040250389 6 OMED
000040250396 000040250409 6 OMED
000050110017 000050110079 1 MVIS
000050110106 000050110144 1 MVIS
000050170011 000050170066 5 DVIS
000050170028 000050170073 1 MVIS
000050170193 000050170388 1 MVIS
000050170395 1 MVIS
000050170275 000050170422 2 OPAT
000050170439 2 OPAT
HC-010I 10:34 Friday, July 14, 2000 8
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-10IF2)
EVNTIDX LINKIDX EVENTYPE
000050170282 000050170446 2 OPAT
000050170453 2 OPAT
000050170319 000050170460 3 EROM
000050170326 000050170460 3 EROM
000050240011 000050240035 1 MVIS
000050240042 1 MVIS
000050240066 000050240073 1 MVIS
000050310011 000050310035 1 MVIS
000060180012 000060180050 5 DVIS
000070170086 000070170113 1 MVIS
000070240144 000070240168 1 MVIS
000070240151 000070240168 1 MVIS
000100150073 000100150080 6 OMED
000100150100 000100150179 1 MVIS
000100150124 000100150186 1 MVIS
000100150148 000100150193 5 DVIS
000100150319 000100150388 1 MVIS
000100220011 000100220059 1 MVIS
000100220066 1 MVIS
000100220073 1 MVIS
000100220097 000100220148 1 MVIS
000100220155 1 MVIS
000100220162 1 MVIS
000100220179 1 MVIS
000100220186 1 MVIS
000100220193 000100220244 1 MVIS
000100220251 1 MVIS
000100220268 1 MVIS
000100220275 1 MVIS
000100220282 1 MVIS
000110120061 000110120085 1 MVIS
HC-010I 10:34 Friday, July 14, 2000 9
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-10IF2)
EVNTIDX LINKIDX EVENTYPE
000110120061 000110120092 1 MVIS
000110120105 000110120198 1 MVIS
000110120201 1 MVIS
000110290054 000110290078 1 MVIS
000120190014 000120190021 1 MVIS
000120190038 1 MVIS
000130190057 000130190160 1 MVIS
000130190324 000130190444 1 MVIS
000130190348 000130190451 1 MVIS
000130190468 1 MVIS
000150150019 000150150026 1 MVIS
000150150033 1 MVIS
000170160061 000170160078 1 MVIS
000170600017 000170600031 1 MVIS
000170600048 1 MVIS
000170710013 000170710020 1 MVIS
000200110019 000200110108 3 EROM
000200110026 000200110115 1 MVIS
000200110033 000200110122 5 DVIS
000200110139 5 DVIS
000200280019 000200280026 1 MVIS
000200280033 1 MVIS
000200280040 1 MVIS
000200280064 000200280071 3 EROM
000200350026 000200350057 1 MVIS
000200350064 1 MVIS
000200350040 000200350071 1 MVIS
000200350088 000200350115 5 DVIS
000200350108 000200350115 5 DVIS
HC-010I 10:34 Friday, July 14, 2000 10
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-10IF2)
EVNTIDX LINKIDX EVENTYPE
000230160034 000230160065 1 MVIS
000230160116 000230160147 5 DVIS
000230160154 5 DVIS
000230160123 000230160161 1 MVIS
000230160192 000230160205 1 MVIS
000290370011 000290370059 1 MVIS
000290370042 000290370059 1 MVIS
000290370066 1 MVIS
000290370073 1 MVIS
000290370080 1 MVIS
000290370179 000290370193 3 EROM
000290370206 3 EROM
000290370213 3 EROM
000310100013 000310100068 1 MVIS
000310100075 000310100099 1 MVIS
000310230048 000310230062 1 MVIS
000310230086 000310230106 1 MVIS
000310230093 000310230113 1 MVIS
000320280030 000320280047 6 OMED
000320280054 000320280061 6 OMED
000340100045 000340100083 1 MVIS
000340100069 000340100090 1 MVIS
000340100110 000340100158 1 MVIS
000360330035 000360330042 3 EROM
000370110017 000370110106 2 OPAT
000410160016 000410160085 1 MVIS
000410160112 000410160201 1 MVIS
000410160136 000410160218 1 MVIS
HC-010I 10:34 Friday, July 14, 2000 11
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-10IF2)
EVNTIDX LINKIDX EVENTYPE
000410160136 000410160225 1 MVIS
000410160167 000410160232 1 MVIS
000410160249 1 MVIS
000410160263 000410160383 1 MVIS
000410160390 1 MVIS
000420140040 000420140211 1 MVIS
000420140228 1 MVIS
000420140273 000420140317 1 MVIS
000440150027 000440150072 4 STAZ
000440150089 4 STAZ
000440150034 000440150096 4 STAZ
000440150192 000440150281 4 STAZ
000440220010 000440220027 1 MVIS
000450100013 000450100020 1 MVIS
000450100037 1 MVIS
000450100068 000450100102 1 MVIS
000460110013 000460110068 1 MVIS
000460110044 000460110051 6 OMED
000460110304 000460110328 1 MVIS
000480180023 000480180078 1 MVIS
000480250030 000480250047 1 MVIS
000480250054 000480250061 1 MVIS
000480320030 000480320078 1 MVIS
000480320047 000480320078 1 MVIS
000480320054 000480320085 1 MVIS
HC-010I 10:34 Friday, July 14, 2000 12
sample print of work.pmedids - sorted by evntidx
work.rxlk records for evntidxs in work.asmvis
EVNTIDX LINKIDX EVENTYPE
000170710013 000170710020 1 MVIS
000630450237 000630450282 1 MVIS
000980120018 000980120032 1 MVIS
001170160136 001170160198 1 MVIS
001170160143 001170160201 1 MVIS
001170160218 1 MVIS
001830490046 001830490142 1 MVIS
001860600019 001860600026 1 MVIS
001860600033 1 MVIS
001860600040 1 MVIS
001860600057 1 MVIS
002360270116 002360270161 1 MVIS
003050120059 003050120097 1 MVIS
003540170104 003540170142 1 MVIS
003540170159 1 MVIS
003540170166 1 MVIS
003570290018 003570290063 1 MVIS
003570290070 1 MVIS
003570290025 003570290070 1 MVIS
003570360018 003570360063 1 MVIS
003620310038 003620310069 1 MVIS
003660480012 003660480029 1 MVIS
003660480036 1 MVIS
003660480043 1 MVIS
003660480050 1 MVIS
003700290010 003700290027 1 MVIS
003770240020 003770240068 1 MVIS
004840190015 004840190046 1 MVIS
004840190053 1 MVIS
004840190022 004840190060 1 MVIS
HC-010I 10:34 Friday, July 14, 2000 13
sample print of work.pmedids - sorted by evntidx
work.rxlk records for evntidxs in work.asmvis
EVNTIDX LINKIDX EVENTYPE
005260160083 005260160172 1 MVIS
005260160189 1 MVIS
005260160261 005260160374 1 MVIS
005420210010 005420210072 1 MVIS
005670410085 005670410092 1 MVIS
005670410112 1 MVIS
005670410129 1 MVIS
005950540035 005950540059 1 MVIS
006700210029 006700210074 1 MVIS
006700210081 1 MVIS
006700210098 1 MVIS
006700210101 1 MVIS
006960390021 006960390076 1 MVIS
006960390083 1 MVIS
006960460583 006960460689 1 MVIS
006960460696 1 MVIS
006960460709 1 MVIS
007030280111 007030280248 1 MVIS
007030280255 1 MVIS
007030280262 1 MVIS
HC-010I 10:34 Friday, July 14, 2000 14
sample print of work.pmedids - sorted by linkidx
OBS EVNTIDX LINKIDX EVENTYPE
1 000170710013 000170710020 1 MVIS
2 000630450237 000630450282 1 MVIS
3 000980120018 000980120032 1 MVIS
4 001170160136 001170160198 1 MVIS
5 001170160143 001170160201 1 MVIS
6 001170160143 001170160218 1 MVIS
7 001830490046 001830490142 1 MVIS
8 001860600019 001860600026 1 MVIS
9 001860600019 001860600033 1 MVIS
10 001860600019 001860600040 1 MVIS
11 001860600019 001860600057 1 MVIS
12 002360270116 002360270161 1 MVIS
13 003050120059 003050120097 1 MVIS
14 003540170104 003540170142 1 MVIS
15 003540170104 003540170159 1 MVIS
16 003540170104 003540170166 1 MVIS
17 003570290018 003570290063 1 MVIS
18 003570290018 003570290070 1 MVIS
19 003570290025 003570290070 1 MVIS
20 003570360018 003570360063 1 MVIS
21 003620310038 003620310069 1 MVIS
22 003660480012 003660480029 1 MVIS
23 003660480012 003660480036 1 MVIS
24 003660480012 003660480043 1 MVIS
25 003660480012 003660480050 1 MVIS
26 003700290010 003700290027 1 MVIS
27 003770240020 003770240068 1 MVIS
28 004840190015 004840190046 1 MVIS
29 004840190015 004840190053 1 MVIS
30 004840190022 004840190060 1 MVIS
31 005260160083 005260160172 1 MVIS
32 005260160083 005260160189 1 MVIS
33 005260160261 005260160374 1 MVIS
34 005420210010 005420210072 1 MVIS
35 005670410085 005670410092 1 MVIS
36 005670410085 005670410112 1 MVIS
37 005670410085 005670410129 1 MVIS
38 005950540035 005950540059 1 MVIS
39 006700210029 006700210074 1 MVIS
40 006700210029 006700210081 1 MVIS
41 006700210029 006700210098 1 MVIS
42 006700210029 006700210101 1 MVIS
43 006960390021 006960390076 1 MVIS
44 006960390021 006960390083 1 MVIS
45 006960460583 006960460689 1 MVIS
46 006960460583 006960460696 1 MVIS
47 006960460583 006960460709 1 MVIS
48 007030280111 007030280248 1 MVIS
49 007030280111 007030280255 1 MVIS
50 007030280111 007030280262 1 MVIS
HC-010I 10:34 Friday, July 14, 2000 15
sample print of unique linkidxs in work.pmedids
OBS LINKIDX
1 000170710020
2 000630450282
3 000980120032
4 001170160198
5 001170160201
6 001170160218
7 001830490142
8 001860600026
9 001860600033
10 001860600040
11 001860600057
12 002360270161
13 003050120097
14 003540170142
15 003540170159
16 003540170166
17 003570290063
18 003570290070
19 003570360063
20 003620310069
21 003660480029
22 003660480036
23 003660480043
24 003660480050
25 003700290027
26 003770240068
27 004840190046
28 004840190053
29 004840190060
30 005260160172
31 005260160189
32 005260160374
33 005420210072
34 005670410092
35 005670410112
36 005670410129
37 005950540059
38 006700210074
39 006700210081
40 006700210098
41 006700210101
42 006960390076
43 006960390083
44 006960460689
45 006960460696
46 006960460709
47 007030280248
48 007030280255
49 007030280262
50 007030280279
HC-010I 10:34 Friday, July 14, 2000 16
sample print of work.mvpmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
000170710020 00017071002001001 EPIEN 64.68 0 6089.40
000630450282 00063045028201001 BIAXIN 36.63 0 19737.17
000980120032 00098012003201001 UNIPHYL 21.09 0 12968.18
00098012003201002 UNIPHYL 21.00 0 12968.18
00098012003202001 THEOPHYLLINE 16.01 0 12968.18
00098012003202002 THEOPHYLLINE 16.01 0 12968.18
00098012003202003 THEOPHYLLINE 16.01 0 12968.18
001170160198 00117016019801001 SEREVENT INH 48.41 0 14880.15
001170160201 00117016020101001 DELTASONE 10.49 0 14880.15
001170160218 00117016021801001 AZMACORT 41.92 0 14880.15
001830490142 00183049014201001 BIAXIN 31.49 0 26312.38
001860600026 00186060002601001 THEOPHYLLINE 16.01 0 20127.55
00186060002601002 THEOPHYLLINE 16.01 0 20127.55
00186060002601003 THEOPHYLLINE 16.01 0 20127.55
00186060002601004 THEOPHYLLINE 16.01 0 20127.55
00186060002601005 THEOPHYLLINE 16.01 0 20127.55
00186060002601006 THEOPHYLLINE 16.01 0 20127.55
00186060002601007 THEOPHYLLINE 16.01 0 20127.55
001860600033 00186060003301001 HYZAAR 31.44 0 20127.55
00186060003301002 HYZAAR 31.44 0 20127.55
00186060003301003 HYZAAR 31.44 0 20127.55
00186060003301004 HYZAAR 31.44 0 20127.55
00186060003301005 HYZAAR 31.44 0 20127.55
00186060003301006 HYZAAR 31.44 0 20127.55
001860600040 00186060004001001 VENTOLIN 26.16 0 20127.55
00186060004001002 VENTOLIN 26.16 0 20127.55
00186060004001003 VENTOLIN 26.16 0 20127.55
00186060004001004 VENTOLIN 26.16 0 20127.55
00186060004001005 VENTOLIN 26.16 0 20127.55
00186060004001006 VENTOLIN 26.16 0 20127.55
001860600057 00186060005701001 AEROBID 52.02 0 20127.55
00186060005701002 AEROBID 52.02 0 20127.55
00186060005701003 AEROBID 52.02 0 20127.55
00186060005701004 AEROBID 52.02 0 20127.55
00186060005701005 AEROBID 52.02 0 20127.55
00186060005701006 AEROBID 52.02 0 20127.55
002360270161 00236027016101001 FERROUS SULFATE 4.99 0 19460.44
HC-010I 10:34 Friday, July 14, 2000 17
sample print of work.mvpmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
003050120097 00305012009701001 ALBUTEROL 21.43 0 7866.01
003540170142 00354017014201001 LANOXIN 6.28 0 14244.68
00354017014201002 LANOXIN 6.28 0 14244.68
00354017014201003 LANOXIN 6.28 0 14244.68
00354017014201004 LANOXIN 6.28 0 14244.68
00354017014201005 LANOXIN 6.28 0 14244.68
00354017014201006 LANOXIN 6.28 0 14244.68
00354017014201007 LANOXIN 6.28 0 14244.68
003540170159 00354017015901001 CAPOTEN 76.63 0 14244.68
00354017015901002 CAPOTEN 69.36 0 14244.68
00354017015901003 CAPOTEN 76.63 0 14244.68
00354017015901004 CAPOTEN 76.63 0 14244.68
00354017015901005 CAPOTEN 76.63 0 14244.68
00354017015901006 CAPOTEN 76.63 0 14244.68
00354017015901007 CAPOTEN 76.63 0 14244.68
003540170166 00354017016601001 ALDACTONE 37.82 0 14244.68
003570290063 00357029006301001 -9 5.96 0 6058.65
00357029006301002 -9 5.96 0 6058.65
003570290070 00357029007001001 ALBUTEROL 19.98 0 6058.65
00357029007001002 ALBUTEROL 19.98 0 6058.65
00357029007001003 ALBUTEROL 19.98 0 6058.65
00357029007001004 ALBUTEROL 19.98 0 6058.65
00357029007001005 ALBUTEROL 19.98 0 6058.65
003570360063 00357036006301001 ALBUTEROL 18.99 0 8573.39
00357036006301002 ALBUTEROL 18.99 0 8573.39
00357036006301003 ALBUTEROL 18.99 0 8573.39
00357036006301004 ALBUTEROL 18.99 0 8573.39
003620310069 00362031006901001 PPA/GG 6.77 0 4651.24
003660480029 00366048002901001 AMOXICILLIN 5.32 0 2117.99
003660480036 00366048003601001 SEREVENT 51.11 0 2117.99
003660480043 00366048004301001 PROVENTIL 26.01 0 2117.99
00366048004301002 PROVENTIL 26.01 0 2117.99
003660480050 00366048005001001 CLARITIN 54.78 0 2117.99
003700290027 00370029002701001 VENTOLIN 28.06 0 5641.61
003770240068 00377024006801001 SMZ-TMP 6.04 0 8671.69
00377024006801002 SMZ-TMP 6.04 0 8671.69
HC-010I 10:34 Friday, July 14, 2000 18
sample print of work.mvpmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
004840190046 00484019004601001 PERPHENAZINE 16.57 0 3656.02
004840190053 00484019005301001 TRAZODONE 11.65 0 3656.02
00484019005301002 TRAZODONE 11.65 0 3656.02
004840190060 00484019006001001 SOD CHL 33.97 0 3656.02
00484019006001002 SOD CHL 33.97 0 3656.02
00484019006001003 SOD CHL 33.97 0 3656.02
00484019006001004 SOD CHL 33.97 0 3656.02
00484019006001005 SOD CHL 33.97 0 3656.02
00484019006001006 SOD CHL 33.97 0 3656.02
005260160172 00526016017201001 ATROVENT NASAL SPRAY 29.97 0 14137.43
005260160189 00526016018901001 ALDACTONE 39.24 0 14137.43
00526016018901002 ALDACTONE 39.24 0 14137.43
005260160374 00526016037401001 ALBUTEROL INHALER 15.50 0 14137.43
005420210072 00542021007201001 TRIPLE ANTI OINT 5.72 0 18412.36
005670410092 00567041009201001 PRELONE 26.69 0 24123.47
005670410112 00567041011201001 ALBUTEROL SULFATE 6.76 0 24123.47
005670410129 00567041012901001 -9 5.96 0 24123.47
005950540059 00595054005901001 ALBUTEROL 18.99 0 11475.66
00595054005901002 ALBUTEROL 18.99 0 11475.66
00595054005901003 ALBUTEROL 18.99 0 11475.66
00595054005901004 ALBUTEROL 18.99 0 11475.66
00595054005901005 ALBUTEROL 18.99 0 11475.66
00595054005901006 ALBUTEROL 18.99 0 11475.66
00595054005901007 ALBUTEROL 18.99 0 11475.66
006700210074 00670021007401001 VENTOLIN INH 49.19 0 5384.58
00670021007401002 VENTOLIN INH 49.19 0 5384.58
00670021007401003 AZMA-CORT IN 25.69 0 5384.58
00670021007401004 VENTOLIN INH 49.19 0 5384.58
006700210081 00670021008101001 AZMA-CORT IN 132.69 0 5384.58
00670021008101002 AZMA-CORT IN 132.69 0 5384.58
00670021008101003 AZMA-CORT IN 132.69 0 5384.58
00670021008101004 AZMA-CORT IN 132.69 0 5384.58
006700210098 00670021009801001 BECONASE NAS 31.53 0 5384.58
00670021009801002 BECONASE NAS 31.53 0 5384.58
00670021009802001 BECONASE AQ 30.31 0 5384.58
00670021009802002 BECONASE AQ 30.31 0 5384.58
HC-010I 10:34 Friday, July 14, 2000 19
sample print of work.mvpmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
006700210101 00670021010101001 ASTECH PEAK 22.36 0 5384.58
006960390076 00696039007601001 VANCENASE 28.66 0 3766.03
006960390083 00696039008301001 KENALOG/NUTRADERM 15.86 0 3766.03
006960460689 00696046068901001 PRELONE 51.53 0 7584.65
006960460696 00696046069601001 NUCOFED EXP 16.87 0 7584.65
006960460709 00696046070901001 CROLOM 39.54 0 7584.65
00696046070901002 CROLOM 39.54 0 7584.65
00696046070901003 CROLOM 39.54 0 7584.65
00696046070901004 CROLOM 39.54 0 7584.65
00696046070901005 CROLOM 39.54 0 7584.65
007030280248 00703028024801001 DYNABAC 17.56 0 12090.79
007030280255 00703028025501001 R-TANNATE 9.22 0 12090.79
007030280262 00703028026201001 AZMACORT 40.67 0 12090.79
007030280279 00703028027901001 NAPROXEN 9.62 0 12090.79
007030280700 00703028070001001 PEAK FLOW METER STANDARD 28.68 0 12090.79
007370120025 00737012002501001 THEOPHYLLINE ER 27.66 0 4641.82
007370120032 00737012003201001 AMPICILLIN 7.99 0 4641.82
007370120049 00737012004901001 PROMETHAZINE V 5.01 0 4641.82
007470140053 00747014005301001 ERY-TAB 10.49 0 16812.41
00747014005301002 ERY-TAB 10.49 0 16812.41
007470140060 00747014006001001 GUAIFENESIN 39.65 0 16812.41
007470140142 00747014014201001 ERY-TAB 10.49 0 16812.41
007620260119 00762026011901001 AZMACORT 42.15 0 21174.64
007620260126 00762026012601001 VENTOLIN 32.92 0 21174.64
007620260133 00762026013301001 NITRO-DUR 45.26 0 21174.64
007620260140 00762026014001001 VERAPAMIL ER 57.49 0 21174.64
007620260157 00762026015701001 CAPTOPRIL 70.09 0 21174.64
HC-010I 10:34 Friday, July 14, 2000 20
sample print of work.mvpmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
007620260164 00762026016401001 FUROSEMIDE 5.34 0 21174.64
007620260171 00762026017101001 SYNTHROID 15.68 0 21174.64
007620260188 00762026018801001 KLOR-CON 11.57 0 21174.64
007620260195 00762026019501001 RELAFEN 30.20 0 21174.64
007620260455 00762026045501001 AZMACORT INHALER 111.47 0 21174.64
00762026045501002 AZMACORT INHALER 111.47 0 21174.64
00762026045501003 AZMACORT INHALER 111.47 0 21174.64
007620260462 00762026046201001 ALBUTEROL INHALER 44.16 0 21174.64
00762026046201002 ALBUTEROL INHALER 44.16 0 21174.64
00762026046201003 ALBUTEROL INHALER 44.16 0 21174.64
007620260479 00762026047901001 DEPONIT 89.89 0 21174.64
007620260486 00762026048601001 VERAPAMIL ER 57.49 0 21174.64
00762026048601002 VERAPAMIL ER 57.49 0 21174.64
00762026048601003 VERAPAMIL ER 57.49 0 21174.64
00762026048601004 VERAPAMIL ER 57.49 0 21174.64
00762026048601005 VERAPAMIL ER 57.49 0 21174.64
007620260493 00762026049301001 CAPTOPRIL 64.69 0 21174.64
00762026049301002 CAPTOPRIL 64.69 0 21174.64
00762026049301003 CAPTOPRIL 64.69 0 21174.64
00762026049301004 CAPTOPRIL 64.69 0 21174.64
00762026049301005 CAPTOPRIL 64.69 0 21174.64
00762026049301006 CAPTOPRIL 64.69 0 21174.64
007620260506 00762026050601001 FUROSEMIDE 4.30 0 21174.64
00762026050601002 FUROSEMIDE 4.30 0 21174.64
00762026050601003 FUROSEMIDE 4.30 0 21174.64
00762026050601004 FUROSEMIDE 4.30 0 21174.64
00762026050601005 FUROSEMIDE 4.30 0 21174.64
007620260513 00762026051301001 SYNTHROID 15.68 0 21174.64
00762026051301002 SYNTHROID 15.68 0 21174.64
00762026051301003 SYNTHROID 15.68 0 21174.64
00762026051301004 SYNTHROID 15.68 0 21174.64
00762026051301005 SYNTHROID 15.68 0 21174.64
00762026051301006 SYNTHROID 15.68 0 21174.64
00762026051301007 SYNTHROID 15.68 0 21174.64
007620260520 00762026052001001 KLOR-CON 13.09 0 21174.64
00762026052001002 KLOR-CON 13.09 0 21174.64
00762026052001003 KLOR-CON 13.09 0 21174.64
00762026052001004 KLOR-CON 13.09 0 21174.64
HC-010I 10:34 Friday, July 14, 2000 21
sample print of work.mvpmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
007620260520 00762026052001005 KLOR-CON 13.09 0 21174.64
007620260537 00762026053701001 RELAFEN 58.41 0 21174.64
00762026053701002 RELAFEN 58.41 0 21174.64
00762026053701003 RELAFEN 58.41 0 21174.64
00762026053701004 RELAFEN 58.41 0 21174.64
00762026053701005 RELAFEN 58.41 0 21174.64
00762026053701006 RELAFEN 58.41 0 21174.64
007620260544 00762026054401001 PAXIL 145.18 0 21174.64
00762026054401002 PAXIL 49.62 0 21174.64
00762026054401003 PAXIL 49.62 0 21174.64
007950160198 00795016019801001 PEPCID 91.27 0 7348.10
007950160201 00795016020101001 PROVENTIL 24.98 0 7348.10
007950160218 00795016021801001 FUROSEMIDE 4.39 0 7348.10
007950160225 00795016022501001 THEOPHYLLINE 11.01 0 7348.10
007950160232 00795016023201001 LANOXIN 5.94 0 7348.10
007950160249 00795016024901001 K-DUR 13.89 0 7348.10
007950160256 00795016025601001 RIGEL 2.75 0 7348.10
007950160263 00795016026301001 APAP W/CODEINE #3 5.61 0 7348.10
008510200042 00851020004201001 SOD CHL 33.97 0 4341.07
008850120138 00885012013801001 ALBUTEROL 27.60 0 7200.64
00885012013801002 ALBUTEROL 27.60 0 7200.64
00885012013801003 ALBUTEROL 27.60 0 7200.64
009290190033 00929019003301001 UNIPHYL 21.09 0 7252.51
00929019003301002 UNIPHYL 21.09 0 7252.51
009640310056 00964031005601001 PROVENTIL 20.70 0 16349.74
00964031005601002 PROVENTIL 20.70 0 16349.74
HC-010I 10:34 Friday, July 14, 2000 22
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Analysis Variable : RXXP96X SUM OF PAYMENTS RXSF96X-RXOU96X(IMPUTED)
N Sum
------------------
2918 91094.46
------------------
HC-010I 10:34 Friday, July 14, 2000 23
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
Analysis Variable : RXXP96X SUM OF PAYMENTS RXSF96X-RXOU96X(IMPUTED)
N Sum
------------------
2918 1094856747
------------------1 The SAS System 10:39 Friday, July 14, 2000
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-010I";
4
5 LIBNAME IN 'D:\';
NOTE: Libref IN was successfully assigned as follows:
Engine: V612
Physical Name: D:\
6
7 **************************************************************************************
8 * Calculate the expenditures for prescribed medicines associated with asthma.
9 **************************************************************************************;
10 PROC FORMAT;
11 VALUE EVENTYPE
12 1 = "1 MVIS"
13 2 = "2 OPAT"
14 3 = "3 EROM"
15 4 = "4 STAZ"
16 5 = "5 DVIS"
17 6 = "6 OMED"
18 7 = "7 HVIS"
19 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
20 RUN;
NOTE: The PROCEDURE FORMAT used 0.59 seconds.
21
22 *--------------------------------------------------------------------------------------
23 * Get condition records coded as asthma.
24 *--------------------------------------------------------------------------------------;
25 DATA ASCONDS;
26 SET IN.HC006R (KEEP=CONDIDX CCCODEX);
27 IF CCCODEX="128";
28 RUN;
NOTE: The data set WORK.ASCONDS has 982 observations and 2 variables.
NOTE: The DATA statement used 5.11 seconds.
29
30 *--------------------------------------------------------------------------
31 * Get the events linked to each of the asthma condition records.
32 *--------------------------------------------------------------------------;
33 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: The data set WORK.ASCONDS has 982 observations and 2 variables.
NOTE: The PROCEDURE SORT used 0.22 seconds.
2 The SAS System 10:39 Friday, July 14, 2000
34
35 proc print data=asconds (obs=50);
36 title3 "sample print of work.asconds - sorted by condidx";
37 title4 "COND (HC-006R) records where cccodex=128";
38 run;
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: The PROCEDURE PRINT used 0.22 seconds.
39
40 PROC SORT DATA=IN.HC10IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: The data set WORK.CLNK has 198363 observations and 5 variables.
NOTE: The PROCEDURE SORT used 13.67 seconds.
41
42 DATA ASCLNKS;
43 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
44 ASCONDS(IN=INASCOND KEEP=CONDIDX);
45 BY CONDIDX;
46 IF INCLNK & INASCOND;
47 RUN;
NOTE: The data set WORK.ASCLNKS has 4319 observations and 3 variables.
NOTE: The DATA statement used 3.02 seconds.
48
49 proc print data=asclnks (obs=75);
50 by condidx;
51 id condidx;
52 format eventype eventype.;
53 title3 "sample print of work.asclnks - sorted by condidx";
54 title4 "events linked to asthma condition records";
55 run;
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: The PROCEDURE PRINT used 0.33 seconds.
56
57 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: The data set WORK.ASCLNKS has 4319 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.17 seconds.
58
59 proc print data=asclnks (obs=50);
60 format eventype eventype.;
61 title3 "sample print of work.asclnks - sorted by evntidx";
62 run;
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
3 The SAS System 10:39 Friday, July 14, 2000
63
64 DATA ASCLNKS;
65 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
66 BY EVNTIDX;
67 IF FIRST.EVNTIDX;
68 RUN;
NOTE: The data set WORK.ASCLNKS has 4304 observations and 2 variables.
NOTE: The DATA statement used 0.11 seconds.
69
70 proc print data=asclnks (obs=50);
71 format eventype eventype.;
72 title3 "sample print of unique evntidxs from work.asclnks";
73 run;
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
74
75 *-------------------------------------------------------------------------------
76 * Get PMED records linked to asthma condition records.
77 *-------------------------------------------------------------------------------;
78 PROC SORT DATA=IN.HC10A OUT=PMED; BY LINKIDX; RUN;
NOTE: The data set WORK.PMED has 171587 observations and 52 variables.
NOTE: The PROCEDURE SORT used 58.32 seconds.
79
80 DATA ASPMEDS;
81 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96)
82 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX RENAME=(EVNTIDX=LINKIDX));
83 BY LINKIDX;
84 IF INASCLNK & FREEFLG=0 & WTDPER96>0;
85 RUN;
NOTE: The data set WORK.ASPMEDS has 6372 observations and 6 variables.
NOTE: The DATA statement used 12.02 seconds.
86
87 proc print data=aspmeds (obs=300);
88 by linkidx;
89 id linkidx;
90 var rxrecidx rxname rxxp96x freeflg wtdper96;
91 title3 "sample print of work.aspmeds";
92 title4 "PMED (HC-010A) records (including free samples) which link to condition records coded as asthma";
93 run;
NOTE: The PROCEDURE PRINT printed pages 6-15.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
4 The SAS System 10:39 Friday, July 14, 2000
94
95 PROC MEANS DATA=ASPMEDS N SUM;
96 VAR RXXP96X;
97 TITLE3 "Total Rx expenditures associated with asthma";
98 RUN;
NOTE: The PROCEDURE MEANS printed page 16.
NOTE: The PROCEDURE MEANS used 0.28 seconds.
99
100 PROC MEANS DATA=ASPMEDS N SUM;
101 VAR RXXP96X;
102 WEIGHT WTDPER96;
103 TITLE3 "Total Rx expenditures associated with asthma";
104 TITLE5 "Weighted";
105 RUN;
NOTE: The PROCEDURE MEANS printed page 17.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
106
107
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-010I 10:39 Friday, July 14, 2000 1
sample print of work.asconds - sorted by condidx
COND (HC-006R) records where cccodex=128
OBS CONDIDX CCCODEX
1 000040320014 128
2 000170710050 128
3 000630450038 128
4 000630450044 128
5 000650110054 128
6 000850580014 128
7 000860130035 128
8 000980120017 128
9 001170160082 128
10 001300290022 128
11 001660130011 128
12 001660370019 128
13 001660440018 128
14 001830490013 128
15 001860600013 128
16 001900110024 128
17 002360270026 128
18 002400120025 128
19 002550290027 128
20 002940230026 128
21 003050120030 128
22 003210280044 128
23 003320230104 128
24 003430100019 128
25 003470170019 128
26 003540170016 128
27 003570290019 128
28 003570360018 128
29 003620170023 128
30 003620310015 128
31 003660480029 128
32 003700290015 128
33 003770240045 128
34 004060270035 128
35 004160280015 128
36 004500120011 128
37 004500450016 128
38 004630460039 128
39 004840190010 128
40 004840520061 128
41 005030330030 128
42 005060320036 128
43 005070320015 128
44 005260160028 128
45 005300270020 128
46 005420210025 128
47 005670410030 128
48 005690210026 128
49 005710290049 128
50 005710430053 128
HC-010I 10:39 Friday, July 14, 2000 2
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
000040320014 000040320012 3 EROM
000170710050 000170710013 1 MVIS
000170710020 8 PMED
000630450038 000630450237 1 MVIS
000630450251 1 MVIS
000630450282 8 PMED
000630450044 000630450268 1 MVIS
000630450282 8 PMED
000650110054 000650110177 1 MVIS
000650110184 1 MVIS
000650110191 1 MVIS
000650110204 1 MVIS
000650110211 1 MVIS
000650110735 8 PMED
000860130035 000860130097 8 PMED
000860130220 1 MVIS
000860130251 8 PMED
000980120017 000980120018 1 MVIS
000980120032 8 PMED
000980120070 8 PMED
001170160082 001170160136 1 MVIS
001170160143 1 MVIS
001170160150 1 MVIS
001170160167 1 MVIS
001170160198 8 PMED
001170160201 8 PMED
001170160218 8 PMED
001300290022 001300290043 8 PMED
001300290163 8 PMED
001300290170 8 PMED
001660130011 001660130011 8 PMED
001660370019 001660370011 8 PMED
001830490013 001830490046 1 MVIS
001830490053 1 MVIS
001830490060 1 MVIS
001830490166 8 PMED
001830490173 8 PMED
001830490375 8 PMED
HC-010I 10:39 Friday, July 14, 2000 3
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
001860600013 001860600019 1 MVIS
001860600026 8 PMED
001860600040 8 PMED
001860600057 8 PMED
001860600071 8 PMED
001860600095 8 PMED
001860600108 8 PMED
001900110024 001900110022 1 MVIS
001900110039 1 MVIS
001900110046 1 MVIS
001900110053 2 OPAT
001900110060 2 OPAT
002360270026 002360270116 1 MVIS
002360270178 2 OPAT
002360270192 8 PMED
002360270212 8 PMED
002550290027 002550290121 8 PMED
002550290138 8 PMED
002550290176 8 PMED
002550290183 8 PMED
002550290210 1 MVIS
002550290234 8 PMED
002550290241 8 PMED
002940230026 002940230142 8 PMED
002940230159 8 PMED
003050120030 003050120011 8 PMED
003050120028 8 PMED
003050120059 1 MVIS
003050120066 1 MVIS
003050120097 8 PMED
003050120100 8 PMED
003050120408 8 PMED
003210280044 003210280465 8 PMED
003210280472 8 PMED
003320230104 003320230176 8 PMED
003430100019 003430100018 8 PMED
003540170016 003540170039 8 PMED
HC-010I 10:39 Friday, July 14, 2000 4
sample print of work.asclnks - sorted by evntidx
OBS CONDIDX EVNTIDX EVENTYPE
1 000040320014 000040320012 3 EROM
2 000170710050 000170710013 1 MVIS
3 000170710050 000170710020 8 PMED
4 000630450038 000630450237 1 MVIS
5 000630450038 000630450251 1 MVIS
6 000630450044 000630450268 1 MVIS
7 000630450038 000630450282 8 PMED
8 000630450044 000630450282 8 PMED
9 000650110054 000650110177 1 MVIS
10 000650110054 000650110184 1 MVIS
11 000650110054 000650110191 1 MVIS
12 000650110054 000650110204 1 MVIS
13 000650110054 000650110211 1 MVIS
14 000650110054 000650110735 8 PMED
15 000860130035 000860130097 8 PMED
16 000860130035 000860130220 1 MVIS
17 000860130035 000860130251 8 PMED
18 000980120017 000980120018 1 MVIS
19 000980120017 000980120032 8 PMED
20 000980120017 000980120070 8 PMED
21 001170160082 001170160136 1 MVIS
22 001170160082 001170160143 1 MVIS
23 001170160082 001170160150 1 MVIS
24 001170160082 001170160167 1 MVIS
25 001170160082 001170160198 8 PMED
26 001170160082 001170160201 8 PMED
27 001170160082 001170160218 8 PMED
28 001300290022 001300290043 8 PMED
29 001300290022 001300290163 8 PMED
30 001300290022 001300290170 8 PMED
31 001660130011 001660130011 8 PMED
32 001660370019 001660370011 8 PMED
33 001830490013 001830490046 1 MVIS
34 001830490013 001830490053 1 MVIS
35 001830490013 001830490060 1 MVIS
36 001830490013 001830490166 8 PMED
37 001830490013 001830490173 8 PMED
38 001830490013 001830490375 8 PMED
39 001860600013 001860600019 1 MVIS
40 001860600013 001860600026 8 PMED
41 001860600013 001860600040 8 PMED
42 001860600013 001860600057 8 PMED
43 001860600013 001860600071 8 PMED
44 001860600013 001860600095 8 PMED
45 001860600013 001860600108 8 PMED
46 001900110024 001900110022 1 MVIS
47 001900110024 001900110039 1 MVIS
48 001900110024 001900110046 1 MVIS
49 001900110024 001900110053 2 OPAT
50 001900110024 001900110060 2 OPAT
HC-010I 10:39 Friday, July 14, 2000 5
sample print of unique evntidxs from work.asclnks
OBS EVNTIDX EVENTYPE
1 000040320012 3 EROM
2 000170710013 1 MVIS
3 000170710020 8 PMED
4 000630450237 1 MVIS
5 000630450251 1 MVIS
6 000630450268 1 MVIS
7 000630450282 8 PMED
8 000650110177 1 MVIS
9 000650110184 1 MVIS
10 000650110191 1 MVIS
11 000650110204 1 MVIS
12 000650110211 1 MVIS
13 000650110735 8 PMED
14 000860130097 8 PMED
15 000860130220 1 MVIS
16 000860130251 8 PMED
17 000980120018 1 MVIS
18 000980120032 8 PMED
19 000980120070 8 PMED
20 001170160136 1 MVIS
21 001170160143 1 MVIS
22 001170160150 1 MVIS
23 001170160167 1 MVIS
24 001170160198 8 PMED
25 001170160201 8 PMED
26 001170160218 8 PMED
27 001300290043 8 PMED
28 001300290163 8 PMED
29 001300290170 8 PMED
30 001660130011 8 PMED
31 001660370011 8 PMED
32 001830490046 1 MVIS
33 001830490053 1 MVIS
34 001830490060 1 MVIS
35 001830490166 8 PMED
36 001830490173 8 PMED
37 001830490375 8 PMED
38 001860600019 1 MVIS
39 001860600026 8 PMED
40 001860600040 8 PMED
41 001860600057 8 PMED
42 001860600071 8 PMED
43 001860600095 8 PMED
44 001860600108 8 PMED
45 001900110022 1 MVIS
46 001900110039 1 MVIS
47 001900110046 1 MVIS
48 001900110053 2 OPAT
49 001900110060 2 OPAT
50 002360270116 1 MVIS
HC-010I 10:39 Friday, July 14, 2000 6
sample print of work.aspmeds
PMED (HC-010A) records (including free samples) which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
000170710020 00017071002001001 EPIEN 64.68 0 6089.40
000630450282 00063045028201001 BIAXIN 36.63 0 19737.17
000650110735 00065011073501001 NORVASC 33.98 0 17005.66
000860130097 00086013009701001 HISANAL 58.62 0 13634.51
000860130251 00086013025101001 CLARITIN 61.72 0 13634.51
00086013025102001 CLARITIN 61.72 0 13634.51
00086013025102002 CLARITIN 61.72 0 13634.51
00086013025102003 CLARITIN 61.72 0 13634.51
00086013025102004 CLARITIN 61.72 0 13634.51
00086013025102005 CLARITIN 61.72 0 13634.51
000980120032 00098012003201001 UNIPHYL 21.09 0 12968.18
00098012003201002 UNIPHYL 21.00 0 12968.18
00098012003202001 THEOPHYLLINE 16.01 0 12968.18
00098012003202002 THEOPHYLLINE 16.01 0 12968.18
00098012003202003 THEOPHYLLINE 16.01 0 12968.18
000980120070 00098012007001001 THEOPHYLLINE 16.01 0 12968.18
00098012007001002 THEOPHYLLINE 16.01 0 12968.18
00098012007001003 THEOPHYLLINE 16.01 0 12968.18
00098012007002001 THEOPHYLLINE 19.68 0 12968.18
001170160198 00117016019801001 SEREVENT INH 48.41 0 14880.15
001170160201 00117016020101001 DELTASONE 10.49 0 14880.15
001170160218 00117016021801001 AZMACORT 41.92 0 14880.15
001300290043 00130029004301001 VANCERIL 29.69 0 14655.98
001300290163 00130029016301001 VANCERIL INHALER 34.50 0 14655.98
001300290170 00130029017001001 ALBUTEROL INHALER 42.82 0 14655.98
001660130011 00166013001101001 VENTOLIN 32.92 0 15865.79
00166013001101002 VENTOLIN 32.92 0 15865.79
001660370011 00166037001101001 VENTOLIN 48.84 0 14531.54
001830490166 00183049016601001 INTAL 54.78 0 26312.38
00183049016601002 INTAL 54.78 0 26312.38
00183049016601003 INTAL 54.78 0 26312.38
00183049016601004 INTAL 54.78 0 26312.38
001830490173 00183049017301001 ALBUTEROL 18.34 0 26312.38
HC-010I 10:39 Friday, July 14, 2000 7
sample print of work.aspmeds
PMED (HC-010A) records (including free samples) which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
001830490173 00183049017301002 ALBUTEROL 18.34 0 26312.38
00183049017301003 ALBUTEROL 18.34 0 26312.38
00183049017301004 ALBUTEROL 18.34 0 26312.38
00183049017301005 ALBUTEROL 18.34 0 26312.38
00183049017301006 ALBUTEROL 18.34 0 26312.38
00183049017301007 ALBUTEROL 18.34 0 26312.38
00183049017301008 ALBUTEROL 18.34 0 26312.38
001830490375 00183049037501001 ALBUTEROL 18.99 0 26312.38
00183049037501002 ALBUTEROL 18.99 0 26312.38
001860600026 00186060002601001 THEOPHYLLINE 16.01 0 20127.55
00186060002601002 THEOPHYLLINE 16.01 0 20127.55
00186060002601003 THEOPHYLLINE 16.01 0 20127.55
00186060002601004 THEOPHYLLINE 16.01 0 20127.55
00186060002601005 THEOPHYLLINE 16.01 0 20127.55
00186060002601006 THEOPHYLLINE 16.01 0 20127.55
00186060002601007 THEOPHYLLINE 16.01 0 20127.55
001860600040 00186060004001001 VENTOLIN 26.16 0 20127.55
00186060004001002 VENTOLIN 26.16 0 20127.55
00186060004001003 VENTOLIN 26.16 0 20127.55
00186060004001004 VENTOLIN 26.16 0 20127.55
00186060004001005 VENTOLIN 26.16 0 20127.55
00186060004001006 VENTOLIN 26.16 0 20127.55
001860600057 00186060005701001 AEROBID 52.02 0 20127.55
00186060005701002 AEROBID 52.02 0 20127.55
00186060005701003 AEROBID 52.02 0 20127.55
00186060005701004 AEROBID 52.02 0 20127.55
00186060005701005 AEROBID 52.02 0 20127.55
00186060005701006 AEROBID 52.02 0 20127.55
001860600071 00186060007101001 THEOPHYLLINE 16.01 0 20127.55
00186060007101002 THEOPHYLLINE 16.01 0 20127.55
00186060007101003 THEOPHYLLINE 16.01 0 20127.55
00186060007101004 THEOPHYLLINE 16.01 0 20127.55
001860600095 00186060009501001 VENTOLIN 32.92 0 20127.55
00186060009501002 VENTOLIN 32.92 0 20127.55
001860600108 00186060010801001 AEROBID 52.02 0 20127.55
00186060010801002 AEROBID 52.02 0 20127.55
002550290121 00255029012101001 AZMACORT 41.63 0 23294.72
002550290138 00255029013801001 VENTOLIN 46.10 0 23294.72
002550290176 00255029017601001 AZMACORT 38.73 0 23294.72
HC-010I 10:39 Friday, July 14, 2000 8
sample print of work.aspmeds
PMED (HC-010A) records (including free samples) which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
002550290183 00255029018301001 VENTOLIN 44.69 0 23294.72
00255029018301002 VENTOLIN 44.69 0 23294.72
002550290234 00255029023401001 AZMACORT 38.73 0 23294.72
00255029023402001 AZMACORT 38.73 0 23294.72
002550290241 00255029024101001 VENTOLIN 44.69 0 23294.72
00255029024101002 VENTOLIN 44.69 0 23294.72
002940230142 00294023014201001 VENTOLIN 32.92 0 12170.07
00294023014201002 VENTOLIN 32.92 0 12170.07
002940230159 00294023015901001 VENTOLIN 32.92 0 12170.07
00294023015901002 VENTOLIN 32.92 0 12170.07
003050120011 00305012001101001 SOD CHL 33.97 0 7866.01
00305012001101002 SOD CHL 33.97 0 7866.01
00305012001101003 SOD CHL 33.97 0 7866.01
003050120028 00305012002802001 DIFIL-G 22.69 0 7866.01
003050120097 00305012009701001 ALBUTEROL 21.43 0 7866.01
003050120408 00305012040801001 DIFIL-G 22.58 0 7866.01
003210280465 00321028046501001 AZMACORT 42.37 0 5017.62
003210280472 00321028047201001 BC 14.32 0 5017.62
003320230176 00332023017601001 RESAID SR 15.84 0 8134.89
003430100018 00343010001801001 BC 14.32 0 19200.22
003540170039 00354017003901001 THEO-24 36.54 0 14244.68
003540170053 00354017005301001 AZMACORT INHALER 108.45 0 14244.68
00354017005301002 AZMACORT INHALER 97.28 0 14244.68
00354017005301003 AZMACORT INHALER 108.45 0 14244.68
003540170060 00354017006001001 SEREVENT INHALATION AEROSOL 66.20 0 14244.68
003540170173 00354017017301001 AZMACORT INHALER 108.45 0 14244.68
00354017017301002 AZMACORT INHALER 108.45 0 14244.68
00354017017301003 AZMACORT INHALER 97.24 0 14244.68
00354017017301004 AZMACORT INHALER 108.45 0 14244.68
00354017017301005 AZMACORT INHALER 108.45 0 14244.68
00354017017301006 AZMACORT INHALER 108.45 0 14244.68
00354017017301007 AZMACORT INHALER 108.45 0 14244.68
HC-010I 10:39 Friday, July 14, 2000 9
sample print of work.aspmeds
PMED (HC-010A) records (including free samples) which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
003540170180 00354017018001001 SEREVENT INHALATION AEROSOL 57.90 0 14244.68
00354017018001002 SEREVENT INHALATION AEROSOL 53.25 0 14244.68
00354017018001003 SEREVENT INHALATION AEROSOL 66.20 0 14244.68
00354017018001004 SEREVENT INHALATION AEROSOL 66.20 0 14244.68
00354017018001005 SEREVENT INHALATION AEROSOL 53.25 0 14244.68
00354017018001006 SEREVENT INHALATION AEROSOL 66.21 0 14244.68
00354017018001007 SEREVENT INHALATION AEROSOL 53.25 0 14244.68
003540170197 00354017019701001 PROVENTIL INH 55.56 0 14244.68
00354017019701002 PROVENTIL INH 55.16 0 14244.68
00354017019701003 PROVENTIL INH 55.56 0 14244.68
00354017019701004 PROVENTIL INH 55.56 0 14244.68
003540170255 00354017025501001 AZMACORT 42.15 0 14244.68
00354017025501002 AZMACORT 42.15 0 14244.68
00354017025501003 AZMACORT 42.15 0 14244.68
00354017025501004 AZMACORT 42.15 0 14244.68
003570290070 00357029007001001 ALBUTEROL 19.98 0 6058.65
00357029007001002 ALBUTEROL 19.98 0 6058.65
00357029007001003 ALBUTEROL 19.98 0 6058.65
00357029007001004 ALBUTEROL 19.98 0 6058.65
00357029007001005 ALBUTEROL 19.98 0 6058.65
003570360063 00357036006301001 ALBUTEROL 18.99 0 8573.39
00357036006301002 ALBUTEROL 18.99 0 8573.39
00357036006301003 ALBUTEROL 18.99 0 8573.39
00357036006301004 ALBUTEROL 18.99 0 8573.39
003620170038 00362017003801001 SOD CHL 33.97 0 2878.73
003620310069 00362031006901001 PPA/GG 6.77 0 4651.24
003660480036 00366048003601001 SEREVENT 51.11 0 2117.99
003660480043 00366048004301001 PROVENTIL 26.01 0 2117.99
00366048004301002 PROVENTIL 26.01 0 2117.99
003660480067 00366048006701001 PROVENTIL 27.14 0 2117.99
003700290027 00370029002701001 VENTOLIN 28.06 0 5641.61
003700290041 00370029004101001 VENTOLIN 28.06 0 5641.61
003770240082 00377024008201001 PROVENTIL 25.26 0 8671.69
003770240099 00377024009901001 AZMACORT 40.76 0 8671.69
003770240328 00377024032801001 INTAL 65.37 0 8671.69
HC-010I 10:39 Friday, July 14, 2000 10
sample print of work.aspmeds
PMED (HC-010A) records (including free samples) which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
003770240366 00377024036601001 AZMACORT 40.76 0 8671.69
003770240373 00377024037301001 PROVENTIL 25.26 0 8671.69
003770240448 00377024044801001 AZMACORT 50.00 0 8671.69
004060270075 00406027007501001 VENTOLIN ROTACAPS 23.23 0 4451.30
004160280025 00416028002501001 ALBUTEROL 18.99 0 6730.20
004500450018 00450045001801001 SOD CHL 33.97 0 11007.57
00450045001801002 SOD CHL 33.97 0 11007.57
00450045001801003 SOD CHL 33.97 0 11007.57
00450045001801004 SOD CHL 33.97 0 11007.57
004500450025 00450045002501001 SOD CHL 33.97 0 11007.57
004840190060 00484019006001001 SOD CHL 33.97 0 3656.02
00484019006001002 SOD CHL 33.97 0 3656.02
00484019006001003 SOD CHL 33.97 0 3656.02
00484019006001004 SOD CHL 33.97 0 3656.02
00484019006001005 SOD CHL 33.97 0 3656.02
00484019006001006 SOD CHL 33.97 0 3656.02
004840520212 00484052021201001 DIPHENHYDRAMINE ELX 5.69 0 3674.58
004840520236 00484052023601001 BRONCHO SALINE 10.22 0 3674.58
005070320109 00507032010901001 ALBUTEROL INHALER 30.02 0 9282.27
005070320147 00507032014701001 AZMACORT INHALER 60.90 0 9282.27
00507032014701002 AZMACORT INHALER 60.90 0 9282.27
00507032014701003 AZMACORT INHALER 60.90 0 9282.27
00507032014701004 AZMACORT INHALER 60.90 0 9282.27
00507032014701005 AZMACORT INHALER 60.90 0 9282.27
005070320154 00507032015401001 ZYRTEC 51.41 0 9282.27
005260160374 00526016037401001 ALBUTEROL INHALER 15.50 0 14137.43
005260160418 00526016041801001 AZMACORT INHALER 39.81 0 14137.43
005420210072 00542021007201001 TRIPLE ANTI OINT 5.72 0 18412.36
005670410092 00567041009201001 PRELONE 26.69 0 24123.47
005670410112 00567041011201001 ALBUTEROL SULFATE 6.76 0 24123.47
005670410129 00567041012901001 -9 5.96 0 24123.47
HC-010I 10:39 Friday, July 14, 2000 11
sample print of work.aspmeds
PMED (HC-010A) records (including free samples) which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
005690210025 00569021002501001 AZMACORT 42.12 0 13297.17
00569021002501002 AZMACORT 42.12 0 13297.17
00569021002501003 AZMACORT 42.12 0 13297.17
005710430039 00571043003901001 ALBUTEROL INHALER 29.97 0 16100.25
005950540011 00595054001101001 ALBUTEROL SYRUP 6.86 0 11475.66
005950540059 00595054005901001 ALBUTEROL 18.99 0 11475.66
00595054005901002 ALBUTEROL 18.99 0 11475.66
00595054005901003 ALBUTEROL 18.99 0 11475.66
00595054005901004 ALBUTEROL 18.99 0 11475.66
00595054005901005 ALBUTEROL 18.99 0 11475.66
00595054005901006 ALBUTEROL 18.99 0 11475.66
00595054005901007 ALBUTEROL 18.99 0 11475.66
006700210074 00670021007401001 VENTOLIN INH 49.19 0 5384.58
00670021007401002 VENTOLIN INH 49.19 0 5384.58
00670021007401003 AZMA-CORT IN 25.69 0 5384.58
00670021007401004 VENTOLIN INH 49.19 0 5384.58
006700210081 00670021008101001 AZMA-CORT IN 132.69 0 5384.58
00670021008101002 AZMA-CORT IN 132.69 0 5384.58
00670021008101003 AZMA-CORT IN 132.69 0 5384.58
00670021008101004 AZMA-CORT IN 132.69 0 5384.58
006700210098 00670021009801001 BECONASE NAS 31.53 0 5384.58
00670021009801002 BECONASE NAS 31.53 0 5384.58
00670021009802001 BECONASE AQ 30.31 0 5384.58
00670021009802002 BECONASE AQ 30.31 0 5384.58
006700210101 00670021010101001 ASTECH PEAK 22.36 0 5384.58
006960390076 00696039007601001 VANCENASE 28.66 0 3766.03
006960390090 00696039009001001 CROLOM 37.54 0 3766.03
006960390127 00696039012701001 VENTOLIN 28.40 0 3766.03
006960390261 00696039026101001 ALBUTEROL 36.59 0 3766.03
006960390278 00696039027801001 CROLOM 37.54 0 3766.03
00696039027801002 CROLOM 37.54 0 3766.03
00696039027801003 CROLOM 37.54 0 3766.03
00696039027801004 CROLOM 37.54 0 3766.03
006960390285 00696039028501001 VENTOLIN 43.62 0 3766.03
00696039028501002 VENTOLIN 48.84 0 3766.03
00696039028501003 VENTOLIN 15.85 0 3766.03
HC-010I 10:39 Friday, July 14, 2000 12
sample print of work.aspmeds
PMED (HC-010A) records (including free samples) which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
006960390285 00696039028501004 VENTOLIN 48.84 0 3766.03
006960390292 00696039029201001 INTAL 84.01 0 3766.03
006960390305 00696039030501001 VANCENASE 29.78 0 3766.03
00696039030501002 VANCENASE 29.78 0 3766.03
006960390425 00696039042501001 VENTOLIN 43.52 0 3766.03
006960390456 00696039045601001 CROLOM 38.98 0 3766.03
00696039045601002 CROLOM 38.98 0 3766.03
00696039045601003 CROLOM 38.98 0 3766.03
006960390470 00696039047001001 CROMOLYN SOD 38.20 0 3766.03
006960390487 00696039048701001 VANCENASE 29.86 0 3766.03
006960460110 00696046011001001 POLY-HISTINE 19.67 0 7584.65
006960460127 00696046012701001 USSI-ORGAN 35.99 0 7584.65
006960460141 00696046014101001 PRELONE 24.73 0 7584.65
006960460165 00696046016501001 DECONAMINE 16.20 0 7584.65
006960460172 00696046017201001 HISTUPOIN HC 10.54 0 7584.65
006960460189 00696046018901001 CROLOM 39.54 0 7584.65
006960460196 00696046019601001 VENTOLIN 28.81 0 7584.65
006960460432 00696046043201001 PRELONE 26.77 0 7584.65
006960460449 00696046044901001 CROLOM 37.54 0 7584.65
00696046044901002 CROLOM 37.54 0 7584.65
00696046044901003 CROLOM 37.54 0 7584.65
006960460456 00696046045601001 VENTOLIN 43.52 0 7584.65
00696046045601002 VENTOLIN 43.52 0 7584.65
00696046045601003 VENTOLIN 43.52 0 7584.65
006960460689 00696046068901001 PRELONE 51.53 0 7584.65
006960460709 00696046070901001 CROLOM 39.54 0 7584.65
00696046070901002 CROLOM 39.54 0 7584.65
00696046070901003 CROLOM 39.54 0 7584.65
00696046070901004 CROLOM 39.54 0 7584.65
00696046070901005 CROLOM 39.54 0 7584.65
HC-010I 10:39 Friday, July 14, 2000 13
sample print of work.aspmeds
PMED (HC-010A) records (including free samples) which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
006960460723 00696046072301001 VENTOLIN 23.52 0 7584.65
006960460747 00696046074701001 AZMACOURT 40.52 0 7584.65
006960460761 00696046076101001 INTAL 43.00 0 7584.65
006960460792 00696046079201001 BECLOVENT 30.20 0 7584.65
006960460829 00696046082901001 VENTOLIN 12.81 0 7584.65
007030280700 00703028070001001 PEAK FLOW METER STANDARD 28.68 0 12090.79
007030280724 00703028072401001 VENTOLIN ROTACAPS 23.23 0 12090.79
007030280731 00703028073101001 TILADE 25.25 0 12090.79
007030280748 00703028074801001 METAPROTERENOL 8.20 0 12090.79
007030280755 00703028075501001 ALBUTEROL UD 27.57 0 12090.79
007060330126 00706033012601001 SEREVENT 65.85 0 11709.09
00706033012601002 SEREVENT 65.85 0 11709.09
007060330133 00706033013301001 ALBUTEROL 21.41 0 11709.09
007210140078 00721014007801001 SOD CHL 33.97 0 9973.63
00721014007801002 SOD CHL 33.97 0 9973.63
007210140085 00721014008501001 VANCERIL INHALER 34.50 0 9973.63
007210140092 00721014009201001 DYAZIDE 24.36 0 9973.63
007210140105 00721014010501001 PROVENTIL REPETABS 68.59 0 9973.63
007210140129 00721014012901001 THEOPHYLLINE 16.01 0 9973.63
007210140167 00721014016701001 SOD CHL 33.97 0 9973.63
00721014016701002 SOD CHL 33.97 0 9973.63
00721014016701003 SOD CHL 33.97 0 9973.63
007210140174 00721014017401001 THEOPHYLLINE 16.01 0 9973.63
00721014017401002 THEOPHYLLINE 16.01 0 9973.63
00721014017401003 THEOPHYLLINE 16.01 0 9973.63
007210140198 00721014019801001 PROVENTIL REPETABS 68.59 0 9973.63
007210140201 00721014020101001 VANCERIL INHALER 34.50 0 9973.63
007210140294 00721014029401001 SOD CHL 33.97 0 9973.63
HC-010I 10:39 Friday, July 14, 2000 14
sample print of work.aspmeds
PMED (HC-010A) records (including free samples) which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
007210140294 00721014029401002 SOD CHL 33.97 0 9973.63
00721014029401003 SOD CHL 33.97 0 9973.63
007210140321 00721014032101001 VANCERIL INHALER 34.50 0 9973.63
007210140338 00721014033801001 SEREVENT 65.85 0 9973.63
007250300081 00725030008101001 VENTOLIN 28.40 0 15191.13
007330320019 00733032001901001 PROVENTIL AER 25.26 0 10129.90
00733032001901002 PROVENTIL AER 25.26 0 10129.90
00733032001901003 PROVENTIL AER 25.26 0 10129.90
00733032001901004 PROVENTIL AER 25.26 0 10129.90
00733032001901005 PROVENTIL AER 25.26 0 10129.90
00733032001901006 PROVENTIL AER 25.26 0 10129.90
00733032001901007 PROVENTIL AER 25.26 0 10129.90
007330320033 00733032003301001 PROVENTIL AER 25.26 0 10129.90
00733032003301002 PROVENTIL AER 25.26 0 10129.90
00733032003301003 PROVENTIL AER 25.26 0 10129.90
00733032003301004 PROVENTIL AER 25.26 0 10129.90
00733032003301005 PROVENTIL AER 25.26 0 10129.90
00733032003301006 PROVENTIL AER 25.26 0 10129.90
00733032003301007 PROVENTIL AER 25.26 0 10129.90
00733032003301008 PROVENTIL AER 25.26 0 10129.90
007350200172 00735020017201001 BRETHINE 20.65 0 4948.08
00735020017201002 BRETHINE 20.65 0 4948.08
007370120025 00737012002501001 THEOPHYLLINE ER 27.66 0 4641.82
007370120032 00737012003201001 AMPICILLIN 7.99 0 4641.82
007370120049 00737012004901001 PROMETHAZINE V 5.01 0 4641.82
007470140053 00747014005301001 ERY-TAB 10.49 0 16812.41
00747014005301002 ERY-TAB 10.49 0 16812.41
007470140060 00747014006001001 GUAIFENESIN 39.65 0 16812.41
007470140142 00747014014201001 ERY-TAB 10.49 0 16812.41
007470140200 00747014020001001 GUAIFENESIN 39.65 0 16812.41
007470140217 00747014021701001 ERY-TAB 10.49 0 16812.41
007600580048 00760058004801001 -9 5.00 0 10039.11
007600580055 00760058005501001 ALBUTEROL 18.34 0 10039.11
HC-010I 10:39 Friday, July 14, 2000 15
sample print of work.aspmeds
PMED (HC-010A) records (including free samples) which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
007600580055 00760058005501002 ALBUTEROL 18.34 0 10039.11
007600580062 00760058006201001 PREDNISONE 6.82 0 10039.11
007620260013 00762026001301001 AZMACORT 42.15 0 21174.64
HC-010I 10:39 Friday, July 14, 2000 16
Total Rx expenditures associated with asthma
Analysis Variable : RXXP96X SUM OF PAYMENTS RXSF96X-RXOU96X(IMPUTED)
N Sum
------------------
6372 207575.96
------------------
HC-010I 10:39 Friday, July 14, 2000 17
Total Rx expenditures associated with asthma
Weighted
Analysis Variable : RXXP96X SUM OF PAYMENTS RXSF96X-RXOU96X(IMPUTED)
N Sum
------------------
6372 2441625303
------------------1 The SAS System 10:54 Friday, July 14, 2000
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-010I";
5
6 LIBNAME IN 'D:\';
NOTE: Libref IN was successfully assigned as follows:
Engine: V612
Physical Name: D:\
7
8 *************************************************************************************
9 * Calculate the expenditures for medical visits 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.39 seconds.
22
23 *-----------------------------------------------------------------------------------
24 * Get conditions records coded as asthma.
25 *-----------------------------------------------------------------------------------;
26 DATA ASCONDS;
27 SET IN.HC006R (KEEP=CONDIDX CCCODEX);
28 IF CCCODEX="128";
29 RUN;
NOTE: The data set WORK.ASCONDS has 982 observations and 2 variables.
NOTE: The DATA statement used 5.42 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 982 observations and 2 variables.
NOTE: The PROCEDURE SORT used 0.22 seconds.
2 The SAS System 10:54 Friday, July 14, 2000
35
36 proc print data=asconds (obs=50);
37 title3 "sample print of work.asconds - sorted by condidx";
38 title4 "COND (HC-006R) records where cccodex=128";
39 run;
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: The PROCEDURE PRINT used 0.28 seconds.
40
41 PROC SORT DATA=IN.HC10IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: The data set WORK.CLNK has 198363 observations and 5 variables.
NOTE: The PROCEDURE SORT used 15.38 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 4319 observations and 3 variables.
NOTE: The DATA statement used 1.91 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.38 seconds.
57
58 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: The data set WORK.ASCLNKS has 4319 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;
NOTE: The PROCEDURE PRINT printed page 4.
3 The SAS System 10:54 Friday, July 14, 2000
NOTE: The PROCEDURE PRINT used 0.0 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 4304 observations and 2 variables.
NOTE: The DATA statement used 0.11 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.0 seconds.
75
76 *--------------------------------------------------------------------------------------------
77 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
78 *--------------------------------------------------------------------------------------------;
79 DATA MVIS;
80 SET IN.HC10GF1 (KEEP=EVNTIDX WTDPER96 SEETLKPV OBXP96X);
81 IF WTDPER96 > 0 & SEETLKPV NE 2;
82 RUN;
NOTE: The data set WORK.MVIS has 95287 observations and 4 variables.
NOTE: The DATA statement used 9.23 seconds.
83
84 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: The data set WORK.MVIS has 95287 observations and 4 variables.
NOTE: The PROCEDURE SORT used 1.87 seconds.
85
86 *-------------------------------------------------------------------------------------
87 * Identify MVIS events which were for asthma.
88 *-------------------------------------------------------------------------------------;
89 DATA ASMVIS;
90 MERGE ASCLNKS (IN=INASCLNK)
91 MVIS (IN=INMVIS);
92 BY EVNTIDX;
93 IF INASCLNK & INMVIS;
94 RUN;
NOTE: The data set WORK.ASMVIS has 1420 observations and 5 variables.
NOTE: The DATA statement used 0.7 seconds.
4 The SAS System 10:54 Friday, July 14, 2000
95
96 proc print data=asmvis (obs=50);
97 format eventype eventype.;
98 title3 "sample print of work.asmvis";
99 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-010G) events";
100 run;
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: The PROCEDURE PRINT used 0.28 seconds.
101
102 PROC MEANS DATA=ASMVIS N SUM;
103 VAR OBXP96X;
104 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
105 RUN;
NOTE: The PROCEDURE MEANS printed page 7.
NOTE: The PROCEDURE MEANS used 0.11 seconds.
106
107 PROC MEANS DATA=ASMVIS SUM;
108 VAR OBXP96X;
109 WEIGHT WTDPER96;
110 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
111 TITLE5 "Weighted";
112 RUN;
NOTE: The PROCEDURE MEANS printed page 8.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
113
114
115
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-010I 10:54 Friday, July 14, 2000 1
sample print of work.asconds - sorted by condidx
COND (HC-006R) records where cccodex=128
OBS CONDIDX CCCODEX
1 000040320014 128
2 000170710050 128
3 000630450038 128
4 000630450044 128
5 000650110054 128
6 000850580014 128
7 000860130035 128
8 000980120017 128
9 001170160082 128
10 001300290022 128
11 001660130011 128
12 001660370019 128
13 001660440018 128
14 001830490013 128
15 001860600013 128
16 001900110024 128
17 002360270026 128
18 002400120025 128
19 002550290027 128
20 002940230026 128
21 003050120030 128
22 003210280044 128
23 003320230104 128
24 003430100019 128
25 003470170019 128
26 003540170016 128
27 003570290019 128
28 003570360018 128
29 003620170023 128
30 003620310015 128
31 003660480029 128
32 003700290015 128
33 003770240045 128
34 004060270035 128
35 004160280015 128
36 004500120011 128
37 004500450016 128
38 004630460039 128
39 004840190010 128
40 004840520061 128
41 005030330030 128
42 005060320036 128
43 005070320015 128
44 005260160028 128
45 005300270020 128
46 005420210025 128
47 005670410030 128
48 005690210026 128
49 005710290049 128
50 005710430053 128
HC-010I 10:54 Friday, July 14, 2000 2
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
000040320014 000040320012 3 EROM
000170710050 000170710013 1 MVIS
000170710020 8 PMED
000630450038 000630450237 1 MVIS
000630450251 1 MVIS
000630450282 8 PMED
000630450044 000630450268 1 MVIS
000630450282 8 PMED
000650110054 000650110177 1 MVIS
000650110184 1 MVIS
000650110191 1 MVIS
000650110204 1 MVIS
000650110211 1 MVIS
000650110735 8 PMED
000860130035 000860130097 8 PMED
000860130220 1 MVIS
000860130251 8 PMED
000980120017 000980120018 1 MVIS
000980120032 8 PMED
000980120070 8 PMED
001170160082 001170160136 1 MVIS
001170160143 1 MVIS
001170160150 1 MVIS
001170160167 1 MVIS
001170160198 8 PMED
001170160201 8 PMED
001170160218 8 PMED
001300290022 001300290043 8 PMED
001300290163 8 PMED
001300290170 8 PMED
001660130011 001660130011 8 PMED
001660370019 001660370011 8 PMED
001830490013 001830490046 1 MVIS
001830490053 1 MVIS
001830490060 1 MVIS
001830490166 8 PMED
001830490173 8 PMED
001830490375 8 PMED
HC-010I 10:54 Friday, July 14, 2000 3
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
001860600013 001860600019 1 MVIS
001860600026 8 PMED
001860600040 8 PMED
001860600057 8 PMED
001860600071 8 PMED
001860600095 8 PMED
001860600108 8 PMED
001900110024 001900110022 1 MVIS
001900110039 1 MVIS
001900110046 1 MVIS
001900110053 2 OPAT
001900110060 2 OPAT
002360270026 002360270116 1 MVIS
002360270178 2 OPAT
002360270192 8 PMED
002360270212 8 PMED
002550290027 002550290121 8 PMED
002550290138 8 PMED
002550290176 8 PMED
002550290183 8 PMED
002550290210 1 MVIS
002550290234 8 PMED
002550290241 8 PMED
002940230026 002940230142 8 PMED
002940230159 8 PMED
003050120030 003050120011 8 PMED
003050120028 8 PMED
003050120059 1 MVIS
003050120066 1 MVIS
003050120097 8 PMED
003050120100 8 PMED
003050120408 8 PMED
003210280044 003210280465 8 PMED
003210280472 8 PMED
003320230104 003320230176 8 PMED
003430100019 003430100018 8 PMED
003540170016 003540170039 8 PMED
HC-010I 10:54 Friday, July 14, 2000 4
sample print of work.asclnks - sorted by evntidx
OBS CONDIDX EVNTIDX EVENTYPE
1 000040320014 000040320012 3 EROM
2 000170710050 000170710013 1 MVIS
3 000170710050 000170710020 8 PMED
4 000630450038 000630450237 1 MVIS
5 000630450038 000630450251 1 MVIS
6 000630450044 000630450268 1 MVIS
7 000630450038 000630450282 8 PMED
8 000630450044 000630450282 8 PMED
9 000650110054 000650110177 1 MVIS
10 000650110054 000650110184 1 MVIS
11 000650110054 000650110191 1 MVIS
12 000650110054 000650110204 1 MVIS
13 000650110054 000650110211 1 MVIS
14 000650110054 000650110735 8 PMED
15 000860130035 000860130097 8 PMED
16 000860130035 000860130220 1 MVIS
17 000860130035 000860130251 8 PMED
18 000980120017 000980120018 1 MVIS
19 000980120017 000980120032 8 PMED
20 000980120017 000980120070 8 PMED
21 001170160082 001170160136 1 MVIS
22 001170160082 001170160143 1 MVIS
23 001170160082 001170160150 1 MVIS
24 001170160082 001170160167 1 MVIS
25 001170160082 001170160198 8 PMED
26 001170160082 001170160201 8 PMED
27 001170160082 001170160218 8 PMED
28 001300290022 001300290043 8 PMED
29 001300290022 001300290163 8 PMED
30 001300290022 001300290170 8 PMED
31 001660130011 001660130011 8 PMED
32 001660370019 001660370011 8 PMED
33 001830490013 001830490046 1 MVIS
34 001830490013 001830490053 1 MVIS
35 001830490013 001830490060 1 MVIS
36 001830490013 001830490166 8 PMED
37 001830490013 001830490173 8 PMED
38 001830490013 001830490375 8 PMED
39 001860600013 001860600019 1 MVIS
40 001860600013 001860600026 8 PMED
41 001860600013 001860600040 8 PMED
42 001860600013 001860600057 8 PMED
43 001860600013 001860600071 8 PMED
44 001860600013 001860600095 8 PMED
45 001860600013 001860600108 8 PMED
46 001900110024 001900110022 1 MVIS
47 001900110024 001900110039 1 MVIS
48 001900110024 001900110046 1 MVIS
49 001900110024 001900110053 2 OPAT
50 001900110024 001900110060 2 OPAT
HC-010I 10:54 Friday, July 14, 2000 5
sample print of unique evntidxs from work.asclnks
OBS EVNTIDX EVENTYPE
1 000040320012 3 EROM
2 000170710013 1 MVIS
3 000170710020 8 PMED
4 000630450237 1 MVIS
5 000630450251 1 MVIS
6 000630450268 1 MVIS
7 000630450282 8 PMED
8 000650110177 1 MVIS
9 000650110184 1 MVIS
10 000650110191 1 MVIS
11 000650110204 1 MVIS
12 000650110211 1 MVIS
13 000650110735 8 PMED
14 000860130097 8 PMED
15 000860130220 1 MVIS
16 000860130251 8 PMED
17 000980120018 1 MVIS
18 000980120032 8 PMED
19 000980120070 8 PMED
20 001170160136 1 MVIS
21 001170160143 1 MVIS
22 001170160150 1 MVIS
23 001170160167 1 MVIS
24 001170160198 8 PMED
25 001170160201 8 PMED
26 001170160218 8 PMED
27 001300290043 8 PMED
28 001300290163 8 PMED
29 001300290170 8 PMED
30 001660130011 8 PMED
31 001660370011 8 PMED
32 001830490046 1 MVIS
33 001830490053 1 MVIS
34 001830490060 1 MVIS
35 001830490166 8 PMED
36 001830490173 8 PMED
37 001830490375 8 PMED
38 001860600019 1 MVIS
39 001860600026 8 PMED
40 001860600040 8 PMED
41 001860600057 8 PMED
42 001860600071 8 PMED
43 001860600095 8 PMED
44 001860600108 8 PMED
45 001900110022 1 MVIS
46 001900110039 1 MVIS
47 001900110046 1 MVIS
48 001900110053 2 OPAT
49 001900110060 2 OPAT
50 002360270116 1 MVIS
HC-010I 10:54 Friday, July 14, 2000 6
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-010G) events
OBS EVNTIDX EVENTYPE SEETLKPV OBXP96X WTDPER96
1 000170710013 1 MVIS 1 50.00 6089.40
2 000630450237 1 MVIS 1 69.33 19737.17
3 000630450251 1 MVIS 1 67.00 19737.17
4 000650110177 1 MVIS 1 47.00 17005.66
5 000650110184 1 MVIS 1 47.00 17005.66
6 000650110191 1 MVIS 1 47.00 17005.66
7 000650110204 1 MVIS 1 47.00 17005.66
8 000650110211 1 MVIS 1 131.00 17005.66
9 000860130220 1 MVIS 1 37.20 13634.51
10 000980120018 1 MVIS 1 29.38 12968.18
11 001170160136 1 MVIS 1 42.04 14880.15
12 001170160143 1 MVIS 1 197.00 14880.15
13 001170160150 1 MVIS 1 45.00 14880.15
14 001170160167 1 MVIS 1 45.00 14880.15
15 001830490046 1 MVIS 1 37.00 26312.38
16 001830490053 1 MVIS 1 37.00 26312.38
17 001830490060 1 MVIS 1 34.36 26312.38
18 001860600019 1 MVIS 1 49.00 20127.55
19 001900110022 1 MVIS 1 53.00 17300.53
20 001900110039 1 MVIS 1 54.99 17300.53
21 001900110046 1 MVIS 1 72.60 17300.53
22 002360270116 1 MVIS 1 95.84 19460.44
23 002550290210 1 MVIS 1 27.35 23294.72
24 003050120059 1 MVIS 1 30.00 7866.01
25 003050120066 1 MVIS 1 53.00 7866.01
26 003540170104 1 MVIS 1 657.85 14244.68
27 003540170111 1 MVIS 1 278.49 14244.68
28 003540170128 1 MVIS 1 55.41 14244.68
29 003540170135 1 MVIS 1 11.88 14244.68
30 003570290018 1 MVIS 1 217.00 6058.65
31 003570290025 1 MVIS 1 16.00 6058.65
32 003570290032 1 MVIS 1 16.00 6058.65
33 003570360018 1 MVIS 1 42.59 8573.39
34 003570360025 1 MVIS 1 16.00 8573.39
35 003620310014 1 MVIS 1 10.00 4651.24
36 003620310038 1 MVIS 1 10.00 4651.24
37 003620310076 1 MVIS 1 10.00 4651.24
38 003620310083 1 MVIS 1 26.52 4651.24
39 003660480012 1 MVIS 1 9.00 2117.99
40 003700290010 1 MVIS 1 15.00 5641.61
41 003770240020 1 MVIS 1 61.00 8671.69
42 004840190015 1 MVIS 1 40.00 3656.02
43 004840190022 1 MVIS 1 50.00 3656.02
44 005070320058 1 MVIS 1 50.00 9282.27
45 005260160083 1 MVIS 1 85.97 14137.43
46 005260160261 1 MVIS 1 126.22 14137.43
47 005260160278 1 MVIS 1 0.00 14137.43
48 005260160305 1 MVIS 1 52.97 14137.43
49 005260160312 1 MVIS 1 166.00 14137.43
50 005260160329 1 MVIS 1 42.00 14137.43
HC-010I 10:54 Friday, July 14, 2000 7
Total medical visit expenditures (excluding telephone) associated with asthma
Analysis Variable : OBXP96X SUM OF OBSF96X-OBOT96X (IMPUTED)
N Sum
------------------
1420 92139.17
------------------
HC-010I 10:54 Friday, July 14, 2000 8
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
Analysis Variable : OBXP96X SUM OF OBSF96X-OBOT96X (IMPUTED)
Sum
------------
1046099305
------------
1 The SAS System 10:55 Friday, July 14, 2000
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-010I";
5
6 LIBNAME IN 'D:\';
NOTE: Libref IN was successfully assigned as follows:
Engine: V612
Physical Name: D:\
7 **************************************************************************************
8 * Calculate the expenditures for prescribed medicines associated
9 * with insulin reported by the household as an other medical expense.
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 VALUE OMTYPE
24 -9 = '-9 NOT ASCERTAINED'
25 -8 = '-8 DK'
26 -7 = '-7 REFUSED'
27 -1 = '-1 INAPPLICABLE'
28 1 = '1 GLASSES OR CONTACT LENSES'
29 2 = '2 INSULIN'
30 3 = '3 DIABETIC EQUIPMENT/SUPPLIES'
31 4 = '4 AMBULANCE SERVICES'
32 5 = '5 ORTHOPEDIC ITEMS'
33 6 = '6 HEARING DEVICES'
34 7 = '7 PROSTHESIS'
35 8 = '8 BATHROOM AIDS'
36 9 = '9 MEDICAL EQUIPMENT'
37 10 = '10 DISPOSABLE SUPPLIES'
38 11 = '11 ALTERATIONS/MODIFICATIONS'
39 91 = '91 OTHER'
40 ;
NOTE: Format OMTYPE has been output.
41 RUN;
NOTE: The PROCEDURE FORMAT used 0.33 seconds.
42
2 The SAS System 10:55 Friday, July 14, 2000
43 *-------------------------------------------------------------------------------------
44 * Get other medical records for insulin for persons with positive weights.
45 *-------------------------------------------------------------------------------------;
46
47 DATA OMED;
48 SET IN.HC10CF1 (KEEP=EVNTIDX WTDPER96 OMTYPE1X);
49 IF WTDPER96 > 0 & OMTYPE1X=2;
50 RUN;
NOTE: The data set WORK.OMED has 481 observations and 3 variables.
NOTE: The DATA statement used 1.26 seconds.
51
52 proc print data=omed (obs=100);
53 var evntidx omtype1x wtdper96;
54 format omtype1x omtype.;
55 title3 "sample print of OMED (HC-010C) records where omtype1x=2";
56 run;
NOTE: The PROCEDURE PRINT printed pages 1-2.
NOTE: The PROCEDURE PRINT used 0.22 seconds.
57
58 *-------------------------------------------------------------------------------------
59 * Get PMED IDs linked to the OMED events which were for insulin.
60 *-------------------------------------------------------------------------------------;
61
62 PROC SORT DATA=IN.HC10IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: The data set WORK.RXLK has 41069 observations and 5 variables.
NOTE: The PROCEDURE SORT used 1.76 seconds.
63
64 proc print data=rxlk (obs=150);
65 by evntidx;
66 id evntidx;
67 var linkidx eventype;
68 format eventype eventype.;
69 title3 "sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx";
70 run;
NOTE: The PROCEDURE PRINT printed pages 3-8.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
71
72 data omedrxlk;
73 set rxlk (where=(eventype=6));
74 run;
NOTE: The data set WORK.OMEDRXLK has 850 observations and 5 variables.
NOTE: The DATA statement used 0.22 seconds.
3 The SAS System 10:55 Friday, July 14, 2000
75 proc print data=omedrxlk (obs=120);
76 by evntidx;
77 id evntidx;
78 var linkidx eventype;
79 format eventype eventype.;
80 title3 "sample print of work.omedrxlk - sorted by eventidx";
81 title4 "Rx+event link file records (HC-10IF2) where eventype=6 (omed)";
82 run;
NOTE: The PROCEDURE PRINT printed pages 9-13.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
83
84 DATA PMEDIDS;
85 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
86 OMED (IN=INOMED KEEP=EVNTIDX);
87 BY EVNTIDX;
88 IF INRXLK & INOMED;
89 RUN;
NOTE: The data set WORK.PMEDIDS has 438 observations and 3 variables.
NOTE: The DATA statement used 0.59 seconds.
90
91 proc print data=pmedids (obs=50);
92 by evntidx;
93 id evntidx;
94 format eventype eventype.;
95 title3 "sample print of work.pmedids - sorted by evntidx";
96 title4 "work.rxlk records for omed events for insulin";
97 run;
NOTE: The PROCEDURE PRINT printed pages 14-15.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
98
99 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: The data set WORK.PMEDIDS has 438 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.05 seconds.
100
101 proc print data=pmedids (obs=50);
102 format eventype eventype.;
103 title3 "sample print of work.pmedids - sorted by linkidx";
104 run;
NOTE: The PROCEDURE PRINT printed page 16.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
105
106 DATA PMEDIDS;
4 The SAS System 10:55 Friday, July 14, 2000
107 SET PMEDIDS (KEEP=LINKIDX);
108 BY LINKIDX;
109 IF FIRST.LINKIDX;
110 KEEP LINKIDX;
111 RUN;
NOTE: The data set WORK.PMEDIDS has 438 observations and 1 variables.
NOTE: The DATA statement used 0.05 seconds.
112
113 proc print data=pmedids (obs=50);
114 title3 "sample print of unique linkidxs in work.pmedids";
115 run;
NOTE: The PROCEDURE PRINT printed page 17.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
116
117
118 *------------------------------------------------------------------------------------
119 * Get PMED records for OMED event which were for insulin.
120 *------------------------------------------------------------------------------------;
121 PROC SORT DATA=IN.HC10A OUT=PMED; BY LINKIDX; RUN;
NOTE: The data set WORK.PMED has 171587 observations and 52 variables.
NOTE: The PROCEDURE SORT used 56.4 seconds.
122
123 DATA OMPMEDS;
124 MERGE PMED (KEEP=LINKIDX RXRECIDX FREEFLG RXXP96X WTDPER96 RXNAME)
125 PMEDIDS (IN=A);
126 BY LINKIDX;
127 IF A & FREEFLG=0 & WTDPER96>0;
128 RUN;
NOTE: The data set WORK.OMPMEDS has 1692 observations and 6 variables.
NOTE: The DATA statement used 12.67 seconds.
129
130 proc print data=ompmeds (obs=200);
131 by linkidx;
132 id linkidx;
133 var rxrecidx rxname rxxp96x freeflg wtdper96;
134 title3 "sample print of work.pmeds";
135 title4 "PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids";
136 run;
NOTE: The PROCEDURE PRINT printed pages 18-23.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
137
138 PROC MEANS DATA=OMPMEDS N SUM;
5 The SAS System 10:55 Friday, July 14, 2000
139 VAR RXXP96X;
140 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
141 RUN;
NOTE: The PROCEDURE MEANS printed page 24.
NOTE: The PROCEDURE MEANS used 0.28 seconds.
142
143 PROC MEANS DATA=OMPMEDS N SUM;
144 VAR RXXP96X;
145 WEIGHT WTDPER96;
146 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
147 TITLE5 "Weighted";
148 RUN;
NOTE: The PROCEDURE MEANS printed page 25.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
149
150
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-010I 10:55 Friday, July 14, 2000 1
sample print of OMED (HC-010C) records where omtype1x=2
OBS EVNTIDX OMTYPE1X WTDPER96
1 000040250081 2 INSULIN 4372.36
2 000040250372 2 INSULIN 4372.36
3 000320280030 2 INSULIN 25604.92
4 000650110108 2 INSULIN 17005.66
5 000650110348 2 INSULIN 17005.66
6 000650110595 2 INSULIN 17005.66
7 000920100039 2 INSULIN 12334.10
8 001080160158 2 INSULIN 17308.09
9 001280210016 2 INSULIN 12623.02
10 001280210061 2 INSULIN 12623.02
11 001280210105 2 INSULIN 12623.02
12 001650120050 2 INSULIN 8267.17
13 001790280243 2 INSULIN 21104.13
14 001990260092 2 INSULIN 12428.09
15 003080260013 2 INSULIN 15169.67
16 003080260068 2 INSULIN 15169.67
17 003080260102 2 INSULIN 15169.67
18 003280130322 2 INSULIN 14625.87
19 003360120081 2 INSULIN 7919.45
20 003910200162 2 INSULIN 10030.35
21 003970160036 2 INSULIN 5206.96
22 004710120013 2 INSULIN 17596.00
23 004800220368 2 INSULIN 13093.03
24 004800220539 2 INSULIN 13093.03
25 004840260060 2 INSULIN 3979.05
26 004840260135 2 INSULIN 3979.05
27 004980170068 2 INSULIN 20680.35
28 004980170739 2 INSULIN 20680.35
29 005010180060 2 INSULIN 4293.77
30 006030180172 2 INSULIN 16778.82
31 006150180193 2 INSULIN 4025.55
32 006670110104 2 INSULIN 19006.98
33 006670110262 2 INSULIN 19006.98
34 006930160157 2 INSULIN 6506.26
35 007080180076 2 INSULIN 11875.98
36 007170110025 2 INSULIN 10725.60
37 007440120439 2 INSULIN 8551.92
38 007920190217 2 INSULIN 15719.78
39 007950160136 2 INSULIN 7348.10
40 007950160472 2 INSULIN 7348.10
41 007950160585 2 INSULIN 7348.10
42 008040200061 2 INSULIN 5624.16
43 008310250011 2 INSULIN 10897.47
44 008310250097 2 INSULIN 10897.47
45 008310250124 2 INSULIN 10897.47
46 008690140266 2 INSULIN 12312.05
47 009640240169 2 INSULIN 22697.20
48 010230140064 2 INSULIN 12540.51
49 010230140482 2 INSULIN 12540.51
50 010360120272 2 INSULIN 19388.74
51 010360120405 2 INSULIN 19388.74
52 010790190083 2 INSULIN 16883.72
53 010790190254 2 INSULIN 16883.72
HC-010I 10:55 Friday, July 14, 2000 2
sample print of OMED (HC-010C) records where omtype1x=2
OBS EVNTIDX OMTYPE1X WTDPER96
54 010790190521 2 INSULIN 16883.72
55 010860180087 2 INSULIN 18030.58
56 010950150099 2 INSULIN 4805.83
57 011210230043 2 INSULIN 10973.41
58 011210230276 2 INSULIN 10973.41
59 012070100149 2 INSULIN 6670.39
60 012070100303 2 INSULIN 6670.39
61 012350120026 2 INSULIN 7622.36
62 012350121036 2 INSULIN 7622.36
63 012670240081 2 INSULIN 4844.93
64 013290160016 2 INSULIN 7798.09
65 013340360067 2 INSULIN 26985.14
66 013680140140 2 INSULIN 5519.43
67 013680140246 2 INSULIN 5519.43
68 013840110134 2 INSULIN 24983.70
69 013840110374 2 INSULIN 24983.70
70 014330100022 2 INSULIN 14275.01
71 014330100173 2 INSULIN 14275.01
72 014330100262 2 INSULIN 14275.01
73 014860220302 2 INSULIN 9967.74
74 014860220600 2 INSULIN 9967.74
75 015710290076 2 INSULIN 13097.84
76 015710290336 2 INSULIN 13097.84
77 015790200150 2 INSULIN 11980.30
78 015900180219 2 INSULIN 27782.98
79 015900180442 2 INSULIN 27782.98
80 015900180651 2 INSULIN 27782.98
81 016350200068 2 INSULIN 4326.82
82 016390330072 2 INSULIN 5618.56
83 016760150032 2 INSULIN 12208.18
84 016860270065 2 INSULIN 16004.75
85 017550200018 2 INSULIN 16062.92
86 017550200258 2 INSULIN 16062.92
87 017770100198 2 INSULIN 8276.22
88 017770100321 2 INSULIN 8276.22
89 017950170258 2 INSULIN 14331.10
90 018270100105 2 INSULIN 17576.83
91 018350120073 2 INSULIN 3253.51
92 018650130564 2 INSULIN 3411.38
93 018710150144 2 INSULIN 6249.45
94 018710150562 2 INSULIN 6249.45
95 018900290076 2 INSULIN 12936.47
96 018900290127 2 INSULIN 12936.47
97 019140190129 2 INSULIN 4304.72
98 019140190218 2 INSULIN 4304.72
99 019260240099 2 INSULIN 15829.08
100 019580120053 2 INSULIN 7452.78
HC-010I 10:55 Friday, July 14, 2000 3
sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
000020250010 000020250027 1 MVIS
000020320010 000020320027 1 MVIS
000020490010 000020490089 1 MVIS
000020490096 1 MVIS
000020490034 000020490109 1 MVIS
000020490041 000020490116 1 MVIS
000020490058 000020490123 1 MVIS
000020490130 1 MVIS
000020490065 000020490147 4 STAZ
000020490072 000020490130 4 STAZ
000020490154 4 STAZ
000030150125 000030150156 1 MVIS
000030220098 000030220221 1 MVIS
000030220170 000030220238 1 MVIS
000030220310 000030220252 1 MVIS
000040250081 000040250098 6 OMED
000040250125 000040250149 1 MVIS
000040250372 000040250389 6 OMED
000040250396 000040250409 6 OMED
000050110017 000050110079 1 MVIS
000050110106 000050110144 1 MVIS
000050170011 000050170066 5 DVIS
000050170028 000050170073 1 MVIS
000050170193 000050170388 1 MVIS
000050170395 1 MVIS
000050170275 000050170422 2 OPAT
000050170439 2 OPAT
000050170282 000050170446 2 OPAT
HC-010I 10:55 Friday, July 14, 2000 4
sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
000050170282 000050170453 2 OPAT
000050170319 000050170460 3 EROM
000050170326 000050170460 3 EROM
000050240011 000050240035 1 MVIS
000050240042 1 MVIS
000050240066 000050240073 1 MVIS
000050310011 000050310035 1 MVIS
000060180012 000060180050 5 DVIS
000070170086 000070170113 1 MVIS
000070240144 000070240168 1 MVIS
000070240151 000070240168 1 MVIS
000100150073 000100150080 6 OMED
000100150100 000100150179 1 MVIS
000100150124 000100150186 1 MVIS
000100150148 000100150193 5 DVIS
000100150319 000100150388 1 MVIS
000100220011 000100220059 1 MVIS
000100220066 1 MVIS
000100220073 1 MVIS
000100220097 000100220148 1 MVIS
000100220155 1 MVIS
000100220162 1 MVIS
000100220179 1 MVIS
000100220186 1 MVIS
000100220193 000100220244 1 MVIS
000100220251 1 MVIS
000100220268 1 MVIS
000100220275 1 MVIS
000100220282 1 MVIS
000110120061 000110120085 1 MVIS
000110120092 1 MVIS
HC-010I 10:55 Friday, July 14, 2000 5
sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
000110120105 000110120198 1 MVIS
000110120201 1 MVIS
000110290054 000110290078 1 MVIS
000120190014 000120190021 1 MVIS
000120190038 1 MVIS
000130190057 000130190160 1 MVIS
000130190324 000130190444 1 MVIS
000130190348 000130190451 1 MVIS
000130190468 1 MVIS
000150150019 000150150026 1 MVIS
000150150033 1 MVIS
000170160061 000170160078 1 MVIS
000170600017 000170600031 1 MVIS
000170600048 1 MVIS
000170710013 000170710020 1 MVIS
000200110019 000200110108 3 EROM
000200110026 000200110115 1 MVIS
000200110033 000200110122 5 DVIS
000200110139 5 DVIS
000200280019 000200280026 1 MVIS
000200280033 1 MVIS
000200280040 1 MVIS
000200280064 000200280071 3 EROM
000200350026 000200350057 1 MVIS
000200350064 1 MVIS
000200350040 000200350071 1 MVIS
000200350088 000200350115 5 DVIS
000200350108 000200350115 5 DVIS
000230160034 000230160065 1 MVIS
000230160116 000230160147 5 DVIS
HC-010I 10:55 Friday, July 14, 2000 6
sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
000230160116 000230160154 5 DVIS
000230160123 000230160161 1 MVIS
000230160192 000230160205 1 MVIS
000290370011 000290370059 1 MVIS
000290370042 000290370059 1 MVIS
000290370066 1 MVIS
000290370073 1 MVIS
000290370080 1 MVIS
000290370179 000290370193 3 EROM
000290370206 3 EROM
000290370213 3 EROM
000310100013 000310100068 1 MVIS
000310100075 000310100099 1 MVIS
000310230048 000310230062 1 MVIS
000310230086 000310230106 1 MVIS
000310230093 000310230113 1 MVIS
000320280030 000320280047 6 OMED
000320280054 000320280061 6 OMED
000340100045 000340100083 1 MVIS
000340100069 000340100090 1 MVIS
000340100110 000340100158 1 MVIS
000360330035 000360330042 3 EROM
000370110017 000370110106 2 OPAT
000410160016 000410160085 1 MVIS
000410160112 000410160201 1 MVIS
000410160136 000410160218 1 MVIS
000410160225 1 MVIS
000410160167 000410160232 1 MVIS
000410160249 1 MVIS
HC-010I 10:55 Friday, July 14, 2000 7
sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
000410160263 000410160383 1 MVIS
000410160390 1 MVIS
000420140040 000420140211 1 MVIS
000420140228 1 MVIS
000420140273 000420140317 1 MVIS
000440150027 000440150072 4 STAZ
000440150089 4 STAZ
000440150034 000440150096 4 STAZ
000440150192 000440150281 4 STAZ
000440220010 000440220027 1 MVIS
000450100013 000450100020 1 MVIS
000450100037 1 MVIS
000450100068 000450100102 1 MVIS
000460110013 000460110068 1 MVIS
000460110044 000460110051 6 OMED
000460110304 000460110328 1 MVIS
000480180023 000480180078 1 MVIS
000480250030 000480250047 1 MVIS
000480250054 000480250061 1 MVIS
000480320030 000480320078 1 MVIS
000480320047 000480320078 1 MVIS
000480320054 000480320085 1 MVIS
000480320092 000480320105 1 MVIS
000480490016 000480490023 1 MVIS
000490120034 000490120058 1 MVIS
000490290034 000490290096 1 MVIS
000490290109 1 MVIS
000490290116 1 MVIS
000490290123 1 MVIS
HC-010I 10:55 Friday, July 14, 2000 8
sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
000490290089 000490290130 1 MVIS
000490290147 1 MVIS
000490290154 000490290205 2 OPAT
HC-010I 10:55 Friday, July 14, 2000 9
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-10IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
000040250081 000040250098 6 OMED
000040250372 000040250389 6 OMED
000040250396 000040250409 6 OMED
000100150073 000100150080 6 OMED
000320280030 000320280047 6 OMED
000320280054 000320280061 6 OMED
000460110044 000460110051 6 OMED
000520170481 000520170498 6 OMED
000650110108 000650110115 6 OMED
000650110122 000650110139 6 OMED
000650110348 000650110355 6 OMED
000650110595 000650110608 6 OMED
000740250077 000740250084 6 OMED
000920100039 000920100046 6 OMED
000920100053 000920100060 6 OMED
001080160158 001080160165 6 OMED
001130170010 001130170027 6 OMED
001280210016 001280210023 6 OMED
001280210030 001280210047 6 OMED
001280210061 001280210078 6 OMED
001280210105 001280210112 6 OMED
001420270216 001420270223 6 OMED
001650120050 001650120067 6 OMED
001650120074 001650120081 6 OMED
001790280243 001790280250 6 OMED
HC-010I 10:55 Friday, July 14, 2000 10
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-10IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
001990260092 001990260105 6 OMED
001990260112 001990260129 6 OMED
003080260013 003080260020 6 OMED
003080260037 003080260044 6 OMED
003080260068 003080260075 6 OMED
003080260102 003080260119 6 OMED
003280130031 003280130048 6 OMED
003280130322 003280130339 6 OMED
003360120081 003360120098 6 OMED
003360120101 003360120118 6 OMED
003910200148 003910200155 6 OMED
003910200162 003910200179 6 OMED
003970160036 003970160043 6 OMED
003970160050 003970160067 6 OMED
004430180093 004430180106 6 OMED
004710120013 004710120020 6 OMED
004800220368 004800220375 6 OMED
004800220539 004800220546 6 OMED
004840260060 004840260077 6 OMED
004840260135 004840260142 6 OMED
004840260159 004840260166 6 OMED
004880240017 004880240024 6 OMED
004910290014 004910290021 6 OMED
004980170068 004980170075 6 OMED
004980170082 004980170099 6 OMED
HC-010I 10:55 Friday, July 14, 2000 11
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-10IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
004980170739 004980170746 6 OMED
005010180060 005010180077 6 OMED
005480200070 005480200087 6 OMED
006030180172 006030180189 6 OMED
006030180196 006030180209 6 OMED
006150180193 006150180206 6 OMED
006150180213 006150180220 6 OMED
006670110104 006670110111 6 OMED
006670110262 006670110279 6 OMED
006930160157 006930160164 6 OMED
007080180076 007080180083 6 OMED
007080180090 007080180103 6 OMED
007170110025 007170110032 6 OMED
007170110049 007170110056 6 OMED
007440120439 007440120446 6 OMED
007440120453 007440120460 6 OMED
007470140015 007470140022 6 OMED
007920190039 007920190046 6 OMED
007920190217 007920190224 6 OMED
007950160136 007950160143 6 OMED
007950160150 007950160167 6 OMED
007950160472 007950160489 6 OMED
007950160585 007950160592 6 OMED
008040130105 008040130112 6 OMED
008040200030 008040200047 6 OMED
HC-010I 10:55 Friday, July 14, 2000 12
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-10IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
008040200061 008040200078 6 OMED
008260130106 008260130113 6 OMED
008310250011 008310250028 6 OMED
008310250097 008310250100 6 OMED
008310250124 008310250131 6 OMED
009360190044 009360190051 6 OMED
009640240145 009640240152 6 OMED
009640240169 009640240176 6 OMED
010230140064 010230140071 6 OMED
010230140088 010230140095 6 OMED
010230140482 010230140499 6 OMED
010360120258 010360120265 6 OMED
010360120272 010360120289 6 OMED
010360120405 010360120412 6 OMED
010790190083 010790190090 6 OMED
010790190254 010790190285 6 OMED
010790190521 010790190538 6 OMED
010860180087 010860180094 6 OMED
010860180107 010860180114 6 OMED
010950150099 010950150102 6 OMED
010950150119 010950150126 6 OMED
011030350029 011030350036 6 OMED
011200150059 011200150066 6 OMED
011210230043 011210230050 6 OMED
011210230067 011210230074 6 OMED
HC-010I 10:55 Friday, July 14, 2000 13
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-10IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
011210230276 011210230283 6 OMED
011510200132 011510200149 6 OMED
011990260048 011990260055 6 OMED
011990260062 011990260079 6 OMED
012070100149 012070100156 6 OMED
012070100163 012070100170 6 OMED
012350120026 012350120033 6 OMED
012350120040 012350120057 6 OMED
012350121036 012350121043 6 OMED
012670240081 012670240098 6 OMED
012800310197 012800310200 6 OMED
013290160016 013290160023 6 OMED
013290160030 013290160047 6 OMED
013340360067 013340360074 6 OMED
013340360081 013340360098 6 OMED
013660170024 013660170031 6 OMED
013680140140 013680140157 6 OMED
013680140164 013680140171 6 OMED
013680140246 013680140253 6 OMED
013840110134 013840110141 6 OMED
HC-010I 10:55 Friday, July 14, 2000 14
sample print of work.pmedids - sorted by evntidx
work.rxlk records for omed events for insulin
EVNTIDX LINKIDX EVENTYPE
000040250081 000040250098 6 OMED
000040250372 000040250389 6 OMED
000320280030 000320280047 6 OMED
000650110108 000650110115 6 OMED
000650110348 000650110355 6 OMED
000650110595 000650110608 6 OMED
000920100039 000920100046 6 OMED
001080160158 001080160165 6 OMED
001280210016 001280210023 6 OMED
001280210061 001280210078 6 OMED
001280210105 001280210112 6 OMED
001650120050 001650120067 6 OMED
001790280243 001790280250 6 OMED
001990260092 001990260105 6 OMED
003080260013 003080260020 6 OMED
003080260068 003080260075 6 OMED
003080260102 003080260119 6 OMED
003280130322 003280130339 6 OMED
003360120081 003360120098 6 OMED
003910200162 003910200179 6 OMED
003970160036 003970160043 6 OMED
004710120013 004710120020 6 OMED
004800220368 004800220375 6 OMED
004800220539 004800220546 6 OMED
004840260060 004840260077 6 OMED
HC-010I 10:55 Friday, July 14, 2000 15
sample print of work.pmedids - sorted by evntidx
work.rxlk records for omed events for insulin
EVNTIDX LINKIDX EVENTYPE
004840260135 004840260142 6 OMED
004980170068 004980170075 6 OMED
004980170739 004980170746 6 OMED
005010180060 005010180077 6 OMED
006030180172 006030180189 6 OMED
006150180193 006150180206 6 OMED
006670110104 006670110111 6 OMED
006670110262 006670110279 6 OMED
006930160157 006930160164 6 OMED
007080180076 007080180083 6 OMED
007170110025 007170110032 6 OMED
007440120439 007440120446 6 OMED
007920190217 007920190224 6 OMED
007950160136 007950160143 6 OMED
007950160472 007950160489 6 OMED
007950160585 007950160592 6 OMED
008040200061 008040200078 6 OMED
008310250011 008310250028 6 OMED
008310250097 008310250100 6 OMED
008310250124 008310250131 6 OMED
009640240169 009640240176 6 OMED
010230140064 010230140071 6 OMED
010230140482 010230140499 6 OMED
010360120272 010360120289 6 OMED
010360120405 010360120412 6 OMED
HC-010I 10:55 Friday, July 14, 2000 16
sample print of work.pmedids - sorted by linkidx
OBS EVNTIDX LINKIDX EVENTYPE
1 000040250081 000040250098 6 OMED
2 000040250372 000040250389 6 OMED
3 000320280030 000320280047 6 OMED
4 000650110108 000650110115 6 OMED
5 000650110348 000650110355 6 OMED
6 000650110595 000650110608 6 OMED
7 000920100039 000920100046 6 OMED
8 001080160158 001080160165 6 OMED
9 001280210016 001280210023 6 OMED
10 001280210061 001280210078 6 OMED
11 001280210105 001280210112 6 OMED
12 001650120050 001650120067 6 OMED
13 001790280243 001790280250 6 OMED
14 001990260092 001990260105 6 OMED
15 003080260013 003080260020 6 OMED
16 003080260068 003080260075 6 OMED
17 003080260102 003080260119 6 OMED
18 003280130322 003280130339 6 OMED
19 003360120081 003360120098 6 OMED
20 003910200162 003910200179 6 OMED
21 003970160036 003970160043 6 OMED
22 004710120013 004710120020 6 OMED
23 004800220368 004800220375 6 OMED
24 004800220539 004800220546 6 OMED
25 004840260060 004840260077 6 OMED
26 004840260135 004840260142 6 OMED
27 004980170068 004980170075 6 OMED
28 004980170739 004980170746 6 OMED
29 005010180060 005010180077 6 OMED
30 006030180172 006030180189 6 OMED
31 006150180193 006150180206 6 OMED
32 006670110104 006670110111 6 OMED
33 006670110262 006670110279 6 OMED
34 006930160157 006930160164 6 OMED
35 007080180076 007080180083 6 OMED
36 007170110025 007170110032 6 OMED
37 007440120439 007440120446 6 OMED
38 007920190217 007920190224 6 OMED
39 007950160136 007950160143 6 OMED
40 007950160472 007950160489 6 OMED
41 007950160585 007950160592 6 OMED
42 008040200061 008040200078 6 OMED
43 008310250011 008310250028 6 OMED
44 008310250097 008310250100 6 OMED
45 008310250124 008310250131 6 OMED
46 009640240169 009640240176 6 OMED
47 010230140064 010230140071 6 OMED
48 010230140482 010230140499 6 OMED
49 010360120272 010360120289 6 OMED
50 010360120405 010360120412 6 OMED
HC-010I 10:55 Friday, July 14, 2000 17
sample print of unique linkidxs in work.pmedids
OBS LINKIDX
1 000040250098
2 000040250389
3 000320280047
4 000650110115
5 000650110355
6 000650110608
7 000920100046
8 001080160165
9 001280210023
10 001280210078
11 001280210112
12 001650120067
13 001790280250
14 001990260105
15 003080260020
16 003080260075
17 003080260119
18 003280130339
19 003360120098
20 003910200179
21 003970160043
22 004710120020
23 004800220375
24 004800220546
25 004840260077
26 004840260142
27 004980170075
28 004980170746
29 005010180077
30 006030180189
31 006150180206
32 006670110111
33 006670110279
34 006930160164
35 007080180083
36 007170110032
37 007440120446
38 007920190224
39 007950160143
40 007950160489
41 007950160592
42 008040200078
43 008310250028
44 008310250100
45 008310250131
46 009640240176
47 010230140071
48 010230140499
49 010360120289
50 010360120412
HC-010I 10:55 Friday, July 14, 2000 18
sample print of work.pmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
000040250098 00004025009801001 HUMULIN 20.22 0 4372.36
000040250389 00004025038901001 INSULIN REG 27.79 0 4372.36
000320280047 00032028004701001 HUMULIN-R IN 18.05 0 25604.92
00032028004702001 HUMULIN-N IN 34.59 0 25604.92
000650110115 00065011011501001 HUMULIN R U-100 INJ 18.91 0 17005.66
00065011011502001 HUMULIN R U-100 INJ 15.71 0 17005.66
00065011011502002 HUMULIN R U-100 INJ 18.91 0 17005.66
00065011011502003 HUMULIN R U-100 INJ 18.91 0 17005.66
000650110355 00065011035501001 HUMULIN R INJ 15.71 0 17005.66
00065011035501002 HUMULIN R INJ 15.71 0 17005.66
00065011035501003 HUMULIN R INJ 15.71 0 17005.66
00065011035501004 HUMULIN R U-100 INJ 15.71 0 17005.66
00065011035502001 HUMULIN N U-100 INJ 15.71 0 17005.66
00065011035502002 HUMULIN N U-100 INJ 15.71 0 17005.66
000650110608 00065011060801001 HUMULIN R INJ 15.89 0 17005.66
00065011060802001 HUMULIN N U-100 INJ 15.89 0 17005.66
00065011060802002 HUMULIN N U-100 INJ 15.89 0 17005.66
00065011060802003 HUMULIN N U-100 INJ 15.89 0 17005.66
00065011060802004 HUMULIN N U-100 INJ 15.89 0 17005.66
00065011060802005 HUMULIN N U-100 INJ 15.89 0 17005.66
000920100046 00092010004601001 INSULIN REG 27.79 0 12334.10
00092010004601002 INSULIN REG 27.79 0 12334.10
00092010004601003 INSULIN REG 27.79 0 12334.10
001080160165 00108016016501001 INSULIN REG 27.79 0 17308.09
00108016016501002 INSULIN REG 27.79 0 17308.09
00108016016501003 INSULIN REG 27.79 0 17308.09
00108016016501004 INSULIN REG 27.79 0 17308.09
00108016016501005 INSULIN REG 27.79 0 17308.09
00108016016501006 INSULIN REG 27.79 0 17308.09
00108016016501007 INSULIN REG 27.79 0 17308.09
00108016016501008 INSULIN REG 27.79 0 17308.09
00108016016501009 INSULIN REG 27.79 0 17308.09
00108016016501010 INSULIN REG 27.79 0 17308.09
00108016016501011 INSULIN REG 27.79 0 17308.09
00108016016501012 INSULIN REG 27.79 0 17308.09
001280210023 00128021002301001 INSULIN REG 27.79 0 12623.02
001280210078 00128021007801001 HUMALEN 48.29 0 12623.02
00128021007801002 HUMALEN 48.29 0 12623.02
001280210112 00128021011201001 HUMULU 83.95 0 12623.02
HC-010I 10:55 Friday, July 14, 2000 19
sample print of work.pmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
001280210112 00128021011201002 HUMULU 83.95 0 12623.02
001650120067 00165012006701001 B-D INSULIN 20.13 0 8267.17
00165012006701002 B-D INSULIN 20.13 0 8267.17
00165012006701003 B-D INSULIN 20.13 0 8267.17
00165012006701004 B-D INSULIN 20.13 0 8267.17
00165012006701005 B-D INSULIN 20.13 0 8267.17
00165012006701006 B-D INSULIN 20.13 0 8267.17
00165012006701007 B-D INSULIN 20.13 0 8267.17
00165012006701008 B-D INSULIN 20.13 0 8267.17
00165012006701009 B-D INSULIN 20.13 0 8267.17
001790280250 00179028025001001 B-D INSULIN 20.13 0 21104.13
00179028025001002 B-D INSULIN 20.13 0 21104.13
00179028025001003 B-D INSULIN 20.13 0 21104.13
00179028025001004 B-D INSULIN 20.13 0 21104.13
00179028025001005 B-D INSULIN 20.13 0 21104.13
001990260105 00199026010501001 B-D INSULIN 20.13 0 12428.09
00199026010501002 B-D INSULIN 20.13 0 12428.09
00199026010501003 B-D INSULIN 20.13 0 12428.09
003080260020 00308026002001001 INSULIN REG 27.79 0 15169.67
003080260075 00308026007501001 INSULIN REG 27.79 0 15169.67
00308026007501002 INSULIN REG 27.79 0 15169.67
00308026007501003 INSULIN REG 27.79 0 15169.67
00308026007501004 INSULIN REG 27.79 0 15169.67
00308026007501005 INSULIN REG 27.79 0 15169.67
003080260119 00308026011901001 INSULIN REG 27.79 0 15169.67
00308026011901002 INSULIN REG 27.79 0 15169.67
003280130339 00328013033901001 INSULIN REG 27.79 0 14625.87
00328013033901002 INSULIN REG 27.79 0 14625.87
00328013033901003 INSULIN REG 27.79 0 14625.87
00328013033901004 INSULIN REG 27.79 0 14625.87
00328013033901005 INSULIN REG 27.79 0 14625.87
00328013033901006 INSULIN REG 27.79 0 14625.87
00328013033901007 INSULIN REG 27.79 0 14625.87
003360120098 00336012009801001 HUMULIN 19.48 0 7919.45
00336012009801002 HUMULIN 32.99 0 7919.45
00336012009801003 HUMULIN 32.99 0 7919.45
00336012009801004 HUMULIN 32.99 0 7919.45
00336012009801005 HUMULIN 32.99 0 7919.45
003910200179 00391020017902001 INSULIN SYR 170.50 0 10030.35
00391020017902002 INSULIN SYR 170.50 0 10030.35
HC-010I 10:55 Friday, July 14, 2000 20
sample print of work.pmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
003910200179 00391020017902003 INSULIN SYR 170.50 0 10030.35
00391020017902004 INSULIN SYR 170.50 0 10030.35
003970160043 00397016004301001 B-D INSULIN 20.13 0 5206.96
00397016004301002 B-D INSULIN 20.13 0 5206.96
00397016004301003 B-D INSULIN 20.13 0 5206.96
004710120020 00471012002001001 INSULIN REG 27.79 0 17596.00
004800220375 00480022037501001 INSULIN REG 27.79 0 13093.03
004800220546 00480022054601001 INSULIN REG 27.79 0 13093.03
004840260077 00484026007701001 HUMULIN NPH 20.22 0 3979.05
00484026007701002 HUMULIN NPH 19.40 0 3979.05
00484026007701003 HUMULIN NPH 21.01 0 3979.05
004840260142 00484026014201001 HUMULIN NPH 21.01 0 3979.05
00484026014201002 HUMULIN NPH 21.01 0 3979.05
00484026014201003 HUMULIN NPH 21.01 0 3979.05
00484026014201004 HUMULIN NPH 21.01 0 3979.05
00484026014201005 HUMULIN NPH 21.01 0 3979.05
004980170075 00498017007501001 INSULIN REG 27.79 0 20680.35
00498017007501002 INSULIN REG 27.79 0 20680.35
00498017007501003 INSULIN REG 27.79 0 20680.35
004980170746 00498017074601001 INSULIN REG 27.79 0 20680.35
00498017074601002 INSULIN REG 27.79 0 20680.35
00498017074601003 INSULIN REG 27.79 0 20680.35
00498017074601004 INSULIN REG 27.79 0 20680.35
00498017074601005 INSULIN REG 27.79 0 20680.35
006030180189 00603018018901001 HUMULIN N INSULIN 18.92 0 16778.82
00603018018901002 HUMULIN N INSULIN 18.92 0 16778.82
00603018018901003 HUMULIN N INSULIN 18.92 0 16778.82
006150180206 00615018020601001 INSULIN SYR 170.50 0 4025.55
00615018020601002 INSULIN SYR 170.50 0 4025.55
006670110111 00667011011101001 INSULIN REG 27.79 0 19006.98
00667011011101002 INSULIN REG 27.79 0 19006.98
00667011011101003 INSULIN REG 27.79 0 19006.98
00667011011101004 INSULIN REG 27.79 0 19006.98
00667011011101005 INSULIN REG 27.79 0 19006.98
00667011011101006 INSULIN REG 27.79 0 19006.98
00667011011101007 INSULIN REG 27.79 0 19006.98
006670110279 00667011027901001 INSULIN REG 27.79 0 19006.98
HC-010I 10:55 Friday, July 14, 2000 21
sample print of work.pmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
006670110279 00667011027901002 INSULIN REG 27.79 0 19006.98
006930160164 00693016016401001 INSULIN REG 27.79 0 6506.26
00693016016401002 INSULIN REG 27.79 0 6506.26
00693016016401003 INSULIN REG 27.79 0 6506.26
00693016016401004 INSULIN REG 27.79 0 6506.26
00693016016401005 INSULIN REG 27.79 0 6506.26
00693016016401006 INSULIN REG 27.79 0 6506.26
00693016016401007 INSULIN REG 27.79 0 6506.26
00693016016401008 INSULIN REG 27.79 0 6506.26
00693016016401009 INSULIN REG 27.79 0 6506.26
00693016016401010 INSULIN REG 27.79 0 6506.26
007080180083 00708018008301001 INSULIN REG 27.79 0 11875.98
00708018008301002 INSULIN REG 27.79 0 11875.98
00708018008301003 INSULIN REG 27.79 0 11875.98
007170110032 00717011003201001 INSULIN REG 27.79 0 10725.60
00717011003201002 INSULIN REG 27.79 0 10725.60
00717011003201003 INSULIN REG 27.79 0 10725.60
00717011003201004 INSULIN REG 27.79 0 10725.60
00717011003201005 INSULIN REG 27.79 0 10725.60
00717011003201006 INSULIN REG 27.79 0 10725.60
00717011003201007 INSULIN REG 27.79 0 10725.60
00717011003201008 INSULIN REG 27.79 0 10725.60
00717011003201009 INSULIN REG 27.79 0 10725.60
00717011003201010 INSULIN REG 27.79 0 10725.60
00717011003201011 INSULIN REG 27.79 0 10725.60
00717011003201012 INSULIN REG 27.79 0 10725.60
007440120446 00744012044601001 B-D INSULIN 20.13 0 8551.92
007920190224 00792019022401001 INSULIN NPH 51.45 0 15719.78
007950160143 00795016014301001 HUMULIN 75.73 0 7348.10
007950160489 00795016048901001 HUMULIN 75.74 0 7348.10
00795016048901002 HUMULIN 67.47 0 7348.10
00795016048901003 HUMULIN 88.95 0 7348.10
00795016048901004 HUMULIN 67.47 0 7348.10
00795016048901005 HUMULIN 75.74 0 7348.10
007950160592 00795016059202001 HUMULIN 67.47 0 7348.10
00795016059202002 HUMULIN 67.47 0 7348.10
00795016059202003 HUMULIN 67.47 0 7348.10
008040200078 00804020007801001 B-D INSULIN 20.13 0 5624.16
008310250028 00831025002801001 INSULIN REG 27.79 0 10897.47
HC-010I 10:55 Friday, July 14, 2000 22
sample print of work.pmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
008310250100 00831025010001001 NOVOLIN R INJ 29.98 0 10897.47
008310250131 00831025013101001 NOVOLIN N INJ 66.19 0 10897.47
009640240176 00964024017601001 B-D INSULIN 20.13 0 22697.20
00964024017601002 B-D INSULIN 20.13 0 22697.20
00964024017601003 B-D INSULIN 20.13 0 22697.20
010230140071 01023014007101001 ILETIN NPH 44.49 0 12540.51
01023014007101002 ILETIN NPH 44.49 0 12540.51
010230140499 01023014049901001 INSULIN LILLY REGULAR 44.49 0 12540.51
01023014049901002 INSULIN LILLY REGULAR 51.22 0 12540.51
01023014049901003 INSULIN LILLY REGULAR 51.22 0 12540.51
01023014049901004 INSULIN LILLY REGULAR 51.22 0 12540.51
01023014049902001 INSULIN LILLY NPH 44.49 0 12540.51
01023014049902002 INSULIN LILLY NPH 51.22 0 12540.51
01023014049902003 INSULIN LILLY NPH 51.22 0 12540.51
010360120289 01036012028901001 INSULIN SYR 170.50 0 19388.74
01036012028901002 INSULIN SYR 170.50 0 19388.74
01036012028901003 INSULIN SYR 170.50 0 19388.74
010360120412 01036012041201001 INSULIN SYR 170.50 0 19388.74
01036012041201002 INSULIN SYR 170.50 0 19388.74
01036012041201003 INSULIN SYR 170.50 0 19388.74
01036012041201004 INSULIN SYR 170.50 0 19388.74
01036012041201005 INSULIN SYR 170.50 0 19388.74
01036012041201006 INSULIN SYR 170.50 0 19388.74
01036012041201007 INSULIN SYR 170.50 0 19388.74
010790190090 01079019009001001 B-D INSULIN 20.13 0 16883.72
010790190285 01079019028501001 B-D INSULIN 20.13 0 16883.72
01079019028501002 B-D INSULIN 20.13 0 16883.72
010790190538 01079019053801001 B-D INSULIN 20.13 0 16883.72
01079019053801002 B-D INSULIN 20.13 0 16883.72
010860180094 01086018009401001 INSULIN REG 27.79 0 18030.58
01086018009401002 INSULIN REG 27.79 0 18030.58
01086018009401003 INSULIN REG 27.79 0 18030.58
01086018009401004 INSULIN REG 27.79 0 18030.58
01086018009401005 INSULIN REG 27.79 0 18030.58
01086018009401006 INSULIN REG 27.79 0 18030.58
01086018009401007 INSULIN REG 27.79 0 18030.58
010950150102 01095015010201001 HUMULIN 20.58 0 4805.83
01095015010201002 HUMULIN 20.58 0 4805.83
HC-010I 10:55 Friday, July 14, 2000 23
sample print of work.pmeds
PMED (HC-010A) records (including free samples) for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP96X FREEFLG WTDPER96
011210230050 01121023005001001 INSULIN REG 27.79 0 10973.41
011210230283 01121023028301001 INSULIN REG 27.79 0 10973.41
01121023028301002 INSULIN REG 27.79 0 10973.41
01121023028301003 INSULIN REG 27.79 0 10973.41
012070100156 01207010015601001 ILETIN I NPH 32.65 0 6670.39
012350120033 01235012003301001 INSULIN REG 27.79 0 7622.36
01235012003301002 INSULIN REG 27.79 0 7622.36
HC-010I 10:55 Friday, July 14, 2000 24
Total Rx expenditures associated with other medical expenses for insulin
Analysis Variable : RXXP96X SUM OF PAYMENTS RXSF96X-RXOU96X(IMPUTED)
N Sum
------------------
1692 59228.15
------------------
HC-010I 10:55 Friday, July 14, 2000 25
Total Rx expenditures associated with other medical expenses for insulin
Weighted
Analysis Variable : RXXP96X SUM OF PAYMENTS RXSF96X-RXOU96X(IMPUTED)
N Sum
------------------
1692 729281742
------------------
<< previous page
Back
Email Updates