1 The SAS System 14:41 Monday, September 18, 2006
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX09.
NOTE: SAS initialization used:
real time 3.28 seconds
cpu time 0.54 seconds
NOTE: AUTOEXEC processing beginning; file is C:\progra~1\sasins~1\sas\v8\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-085I";
4 TITLE2 "Sample SAS Job for Example A";
5
6 LIBNAME IN V8 "C:\DATA";
NOTE: Libref IN was successfully assigned as follows:
Engine: V8
Physical Name: C:\DATA
7
8 ************************************************************************************************
9 * Calculate the expenditures for prescribed medicines associated with medical visits for asthma.
10 ************************************************************************************************;
11
12 PROC FORMAT;
13 VALUE EVENTYPE
14 1 = "1 MVIS"
15 2 = "2 OPAT"
16 3 = "3 EROM"
17 4 = "4 STAZ"
18 5 = "5 DVIS"
19 6 = "6 OMED"
20 7 = "7 HVIS"
21 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
22
23 RUN;
NOTE: PROCEDURE FORMAT used:
real time 0.17 seconds
cpu time 0.00 seconds
24
2 The SAS System 14:41 Monday, September 18, 2006
25 *-------------------------------------------------------------------------------------
26 * Get condition records coded as asthma.
27 *-------------------------------------------------------------------------------------;
28 DATA ASCONDS;
29 SET IN.H87 (KEEP=CONDIDX CCCODEX);
30 IF CCCODEX="128";
31
32 RUN;
NOTE: There were 106738 observations read from the data set IN.H87.
NOTE: The data set WORK.ASCONDS has 1835 observations and 2 variables.
NOTE: DATA statement used:
real time 1.81 seconds
cpu time 0.18 seconds
33
34 *------------------------------------------------------------------------------------
35 * Get the events linked to each of the asthma condition records.
36 *------------------------------------------------------------------------------------;
37 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 1835 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1835 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.10 seconds
cpu time 0.00 seconds
38
39 proc print data=asconds (obs=50);
40 title3 "sample print of work.asconds - sorted by condidx";
41 title4 "COND (H87) records where cccodex=128";
42 run;
NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used:
real time 0.46 seconds
cpu time 0.03 seconds
43
44 PROC SORT DATA=IN.H85IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 348119 observations read from the data set IN.H85IF1.
NOTE: The data set WORK.CLNK has 348119 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 18.96 seconds
cpu time 2.31 seconds
45
46 DATA ASCLNKS;
47 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
48 ASCONDS(IN=INASCOND KEEP=CONDIDX);
49 BY CONDIDX;
3 The SAS System 14:41 Monday, September 18, 2006
50 IF INCLNK & INASCOND;
51 RUN;
NOTE: There were 348119 observations read from the data set WORK.CLNK.
NOTE: There were 1835 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7244 observations and 3 variables.
NOTE: DATA statement used:
real time 1.06 seconds
cpu time 0.39 seconds
52
53 proc print data=asclnks (obs=75);
54 by condidx;
55 id condidx;
56 format eventype eventype.;
57 title3 "sample print of work.asclnks - sorted by condidx";
58 title4 "events linked to asthma condition records";
59 run;
NOTE: There were 75 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used:
real time 0.12 seconds
cpu time 0.03 seconds
60
61 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7244 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7244 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.03 seconds
cpu time 0.03 seconds
62
63 proc print data=asclnks (obs=50);
64 format eventype eventype.;
65 title3 "sample print of work.asclnks - sorted by evntidx";
66 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.00 seconds
67
68 DATA ASCLNKS;
69 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
70 BY EVNTIDX;
71 IF FIRST.EVNTIDX;
72 RUN;
4 The SAS System 14:41 Monday, September 18, 2006
NOTE: There were 7244 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7225 observations and 2 variables.
NOTE: DATA statement used:
real time 0.03 seconds
cpu time 0.03 seconds
73
74 proc print data=asclnks (obs=50);
75 title3 "sample print of unique evntidxs from work.asclnks";
76 format eventype eventype.;
77 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.01 seconds
78
79 *--------------------------------------------------------------------------------------------
80 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
81 *--------------------------------------------------------------------------------------------;
82 DATA MVIS;
83 SET IN.H85G (KEEP=EVNTIDX PERWT04F SEETLKPV);
84 IF PERWT04F > 0 & SEETLKPV NE 2;
85 RUN;
NOTE: There were 157536 observations read from the data set IN.H85G.
NOTE: The data set WORK.MVIS has 152603 observations and 3 variables.
NOTE: DATA statement used:
real time 1.71 seconds
cpu time 0.56 seconds
86
87 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 152603 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 152603 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.76 seconds
cpu time 0.70 seconds
88
89 *---------------------------------------------------------------------------------------------
90 * Identify MVIS events which were for asthma.
91 *---------------------------------------------------------------------------------------------;
92 DATA ASMVIS;
93 MERGE ASCLNKS (IN=INASCLNK)
94 MVIS (IN=INMVIS KEEP=EVNTIDX);
95 BY EVNTIDX;
96 IF INASCLNK & INMVIS;
97 RUN;
5 The SAS System 14:41 Monday, September 18, 2006
NOTE: There were 7225 observations read from the data set WORK.ASCLNKS.
NOTE: There were 152603 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 2165 observations and 2 variables.
NOTE: DATA statement used:
real time 0.90 seconds
cpu time 0.18 seconds
98
99 proc print data=asmvis (obs=50);
100 format eventype eventype.;
101 title3 "sample print of work.asmvis";
102 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-085G) events";
103 run;
NOTE: There were 50 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.01 seconds
104
105 *-------------------------------------------------------------------------------------
106 * Get PMED IDs linked to the MVIS events which were for asthma.
107 *-------------------------------------------------------------------------------------;
108 PROC SORT DATA=IN.H85IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: There were 62663 observations read from the data set IN.H85IF2.
NOTE: The data set WORK.RXLK has 62663 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 0.35 seconds
cpu time 0.35 seconds
109
110 proc print data=rxlk (obs=140);
111 by evntidx;
112 id evntidx;
113 var linkidx eventype;
114 format eventype eventype.;
115 title3 "sample print of work.rxlk - sorted by evntidx";
116 title4 "Rx+event link file records (HC-85IF2)";
117 run;
NOTE: There were 140 observations read from the data set WORK.RXLK.
NOTE: The PROCEDURE PRINT printed pages 7-11.
NOTE: PROCEDURE PRINT used:
real time 0.03 seconds
cpu time 0.01 seconds
118
119 DATA PMEDIDS;
120 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
121 ASMVIS(IN=INASMVIS KEEP=EVNTIDX);
122 BY EVNTIDX;
6 The SAS System 14:41 Monday, September 18, 2006
123 IF INRXLK & INASMVIS;
124 RUN;
NOTE: There were 62663 observations read from the data set WORK.RXLK.
NOTE: There were 2165 observations read from the data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 1978 observations and 3 variables.
NOTE: DATA statement used:
real time 0.07 seconds
cpu time 0.07 seconds
125
126 proc print data=pmedids (obs=50);
127 by evntidx;
128 id evntidx;
129 format eventype eventype.;
130 title3 "sample print of work.pmedids - sorted by evntidx";
131 title4 "work.rxlk records for evntidxs in work.asmvis";
132 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed pages 12-13.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.00 seconds
133
134 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 1978 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1978 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.01 seconds
cpu time 0.01 seconds
135
136 proc print data=pmedids (obs=50);
137 format eventype eventype.;
138 title3 "sample print of work.pmedids - sorted by linkidx";
139 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 14.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.00 seconds
140
141 DATA PMEDIDS;
142 SET PMEDIDS (KEEP=LINKIDX);
143 BY LINKIDX;
144 IF FIRST.LINKIDX;
145 RUN;
7 The SAS System 14:41 Monday, September 18, 2006
NOTE: There were 1978 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1867 observations and 1 variables.
NOTE: DATA statement used:
real time 0.00 seconds
cpu time 0.00 seconds
146
147 proc print data=pmedids (obs=50);
148 title3 "sample print of unique linkidxs in work.pmedids";
149 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: PROCEDURE PRINT used:
real time 0.00 seconds
cpu time 0.00 seconds
150
151 *-----------------------------------------------------------------------------------------
152 * Get PMED records linked to MVIS events which were for asthma.
153 *-----------------------------------------------------------------------------------------;
154 PROC SORT DATA=IN.H85A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 317065 observations read from the data set IN.H85A.
NOTE: The data set WORK.PMED has 317065 observations and 13 variables.
NOTE: PROCEDURE SORT used:
real time 47.00 seconds
cpu time 4.56 seconds
155
156 DATA MVPMEDS;
157 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP04X PERWT04F RXNAME)
158 PMEDIDS (IN=A);
159 BY LINKIDX;
160 IF A;
161 RUN;
NOTE: There were 317065 observations read from the data set WORK.PMED.
NOTE: There were 1867 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 4945 observations and 5 variables.
NOTE: DATA statement used:
real time 0.71 seconds
cpu time 0.48 seconds
162
163 proc print data=mvpmeds (obs=200);
164 var rxrecidx rxname RXXP04X PERWT04F;
165 by linkidx;
166 id linkidx;
167 title3 "sample print of work.mvpmeds";
168 title4 "PMED (HC-085A) records for unique linkidxs in work.pmedids";
169 run;
8 The SAS System 14:41 Monday, September 18, 2006
NOTE: There were 200 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE PRINT printed pages 16-21.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.01 seconds
170
171 PROC MEANS DATA=MVPMEDS N SUM;
172 VAR RXXP04X;
173 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
174 RUN;
NOTE: There were 4945 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 22.
NOTE: PROCEDURE MEANS used:
real time 0.31 seconds
cpu time 0.01 seconds
175
176 PROC MEANS DATA=MVPMEDS N SUM;
177 VAR RXXP04X;
178 WEIGHT PERWT04F;
179 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
180 TITLE5 "Weighted";
181 RUN;
NOTE: There were 4945 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used:
real time 0.01 seconds
cpu time 0.00 seconds
182
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 1:19.01
cpu time 10.73 seconds
HC-085I 14:41 Monday, September 18, 2006 1
Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H87) records where cccodex=128
Obs CCCODEX CONDIDX
1 128 500070130028
2 128 500070200033
3 128 500200110056
4 128 500360140018
5 128 500430190052
6 128 500460100016
7 128 500660410013
8 128 500680120023
9 128 500700150079
10 128 500950250018
11 128 500990170024
12 128 501090310018
13 128 501150120029
14 128 501160150036
15 128 501170360054
16 128 501290180058
17 128 501420340016
18 128 501690160041
19 128 501840550020
20 128 501840620013
21 128 501910540019
22 128 501970350043
23 128 502110120053
24 128 502620440014
25 128 502870280065
26 128 502900180021
27 128 503080270027
28 128 503100450013
29 128 503250380018
30 128 503370280017
31 128 503500310054
32 128 503580110010
33 128 503720160023
34 128 503730590022
35 128 504010100086
36 128 504200240023
37 128 504200480015
38 128 504230270053
39 128 504480460018
40 128 504520190016
41 128 504580270025
42 128 504580270075
43 128 504600560011
44 128 504720230091
45 128 504910450035
46 128 505160200037
47 128 505160500013
48 128 505160670034
49 128 505180190034
50 128 505280110061
HC-085I 14:41 Monday, September 18, 2006 2
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
500070130028 500070130256 8 PMED
500070130263 8 PMED
500070130410 8 PMED
500070130427 8 PMED
500070200033 500070200085 8 PMED
500070200092 8 PMED
500070200105 8 PMED
500200110056 500200110232 8 PMED
500200110636 8 PMED
500200111040 8 PMED
500360140018 500360140029 1 MVIS
500360140074 8 PMED
500360140252 8 PMED
500360140269 8 PMED
500360140276 8 PMED
500360140283 8 PMED
500360140290 8 PMED
500360140601 8 PMED
500360140618 8 PMED
500360140625 8 PMED
500430190052 500430190066 8 PMED
500460100016 500460100012 8 PMED
500660410013 500660410013 1 MVIS
500660410020 1 MVIS
500660410037 1 MVIS
500660410044 8 PMED
500660410051 8 PMED
500660410068 8 PMED
500660410082 8 PMED
500680120023 500680120011 1 MVIS
500680120035 8 PMED
500680120042 8 PMED
500680120059 8 PMED
500680120117 8 PMED
500680120124 8 PMED
500700150079 500700150393 8 PMED
500700150413 1 MVIS
500700150437 1 MVIS
500700150622 8 PMED
500700150660 8 PMED
HC-085I 14:41 Monday, September 18, 2006 3
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
500990170024 500990170063 8 PMED
500990170169 8 PMED
500990170176 8 PMED
500990170183 8 PMED
500990170272 8 PMED
501090310018 501090310018 1 MVIS
501090310025 1 MVIS
501090310032 1 MVIS
501090310049 1 MVIS
501090310056 1 MVIS
501090310063 1 MVIS
501090310070 1 MVIS
501090310087 1 MVIS
501090310176 8 PMED
501090310183 8 PMED
501150120029 501150120037 8 PMED
501150120119 1 MVIS
501150120126 1 MVIS
501150120133 1 MVIS
501150120140 1 MVIS
501150120157 1 MVIS
501150120164 8 PMED
501160150036 501160150024 1 MVIS
501160150031 1 MVIS
501160150048 8 PMED
501160150079 8 PMED
501160150144 1 MVIS
501160150168 8 PMED
501160150459 8 PMED
501160150466 8 PMED
501170360054 501170360156 1 MVIS
501170360170 8 PMED
501170360214 8 PMED
501170360221 8 PMED
501170360238 8 PMED
HC-085I 14:41 Monday, September 18, 2006 4
Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx
Obs EVNTIDX EVENTYPE CONDIDX
1 500070130256 8 PMED 500070130028
2 500070130263 8 PMED 500070130028
3 500070130410 8 PMED 500070130028
4 500070130427 8 PMED 500070130028
5 500070200085 8 PMED 500070200033
6 500070200092 8 PMED 500070200033
7 500070200105 8 PMED 500070200033
8 500200110232 8 PMED 500200110056
9 500200110636 8 PMED 500200110056
10 500200111040 8 PMED 500200110056
11 500360140029 1 MVIS 500360140018
12 500360140074 8 PMED 500360140018
13 500360140252 8 PMED 500360140018
14 500360140269 8 PMED 500360140018
15 500360140276 8 PMED 500360140018
16 500360140283 8 PMED 500360140018
17 500360140290 8 PMED 500360140018
18 500360140601 8 PMED 500360140018
19 500360140618 8 PMED 500360140018
20 500360140625 8 PMED 500360140018
21 500430190066 8 PMED 500430190052
22 500460100012 8 PMED 500460100016
23 500660410013 1 MVIS 500660410013
24 500660410020 1 MVIS 500660410013
25 500660410037 1 MVIS 500660410013
26 500660410044 8 PMED 500660410013
27 500660410051 8 PMED 500660410013
28 500660410068 8 PMED 500660410013
29 500660410082 8 PMED 500660410013
30 500680120011 1 MVIS 500680120023
31 500680120035 8 PMED 500680120023
32 500680120042 8 PMED 500680120023
33 500680120059 8 PMED 500680120023
34 500680120117 8 PMED 500680120023
35 500680120124 8 PMED 500680120023
36 500700150393 8 PMED 500700150079
37 500700150413 1 MVIS 500700150079
38 500700150437 1 MVIS 500700150079
39 500700150622 8 PMED 500700150079
40 500700150660 8 PMED 500700150079
41 500990170063 8 PMED 500990170024
42 500990170169 8 PMED 500990170024
43 500990170176 8 PMED 500990170024
44 500990170183 8 PMED 500990170024
45 500990170272 8 PMED 500990170024
46 501090310018 1 MVIS 501090310018
47 501090310025 1 MVIS 501090310018
48 501090310032 1 MVIS 501090310018
49 501090310049 1 MVIS 501090310018
50 501090310056 1 MVIS 501090310018
HC-085I 14:41 Monday, September 18, 2006 5
Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 500070130256 8 PMED
2 500070130263 8 PMED
3 500070130410 8 PMED
4 500070130427 8 PMED
5 500070200085 8 PMED
6 500070200092 8 PMED
7 500070200105 8 PMED
8 500200110232 8 PMED
9 500200110636 8 PMED
10 500200111040 8 PMED
11 500360140029 1 MVIS
12 500360140074 8 PMED
13 500360140252 8 PMED
14 500360140269 8 PMED
15 500360140276 8 PMED
16 500360140283 8 PMED
17 500360140290 8 PMED
18 500360140601 8 PMED
19 500360140618 8 PMED
20 500360140625 8 PMED
21 500430190066 8 PMED
22 500460100012 8 PMED
23 500660410013 1 MVIS
24 500660410020 1 MVIS
25 500660410037 1 MVIS
26 500660410044 8 PMED
27 500660410051 8 PMED
28 500660410068 8 PMED
29 500660410082 8 PMED
30 500680120011 1 MVIS
31 500680120035 8 PMED
32 500680120042 8 PMED
33 500680120059 8 PMED
34 500680120117 8 PMED
35 500680120124 8 PMED
36 500700150393 8 PMED
37 500700150413 1 MVIS
38 500700150437 1 MVIS
39 500700150622 8 PMED
40 500700150660 8 PMED
41 500990170063 8 PMED
42 500990170169 8 PMED
43 500990170176 8 PMED
44 500990170183 8 PMED
45 500990170272 8 PMED
46 501090310018 1 MVIS
47 501090310025 1 MVIS
48 501090310032 1 MVIS
49 501090310049 1 MVIS
50 501090310056 1 MVIS
HC-085I 14:41 Monday, September 18, 2006 6
Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-085G) events
Obs EVNTIDX EVENTYPE
1 500360140029 1 MVIS
2 500660410013 1 MVIS
3 500660410020 1 MVIS
4 500660410037 1 MVIS
5 500680120011 1 MVIS
6 500700150413 1 MVIS
7 500700150437 1 MVIS
8 501090310018 1 MVIS
9 501090310025 1 MVIS
10 501090310032 1 MVIS
11 501090310049 1 MVIS
12 501090310056 1 MVIS
13 501090310063 1 MVIS
14 501090310070 1 MVIS
15 501090310087 1 MVIS
16 501150120119 1 MVIS
17 501150120126 1 MVIS
18 501150120133 1 MVIS
19 501150120140 1 MVIS
20 501150120157 1 MVIS
21 501160150024 1 MVIS
22 501160150031 1 MVIS
23 501160150144 1 MVIS
24 501170360156 1 MVIS
25 501290180101 1 MVIS
26 501290180252 1 MVIS
27 501420340022 1 MVIS
28 501420340039 1 MVIS
29 501420340046 1 MVIS
30 501420340053 1 MVIS
31 501420340060 1 MVIS
32 501420340077 1 MVIS
33 501420340084 1 MVIS
34 501420340091 1 MVIS
35 501420340104 1 MVIS
36 501420340111 1 MVIS
37 501420340128 1 MVIS
38 501420340135 1 MVIS
39 501420340142 1 MVIS
40 501420340159 1 MVIS
41 501420340166 1 MVIS
42 501420340173 1 MVIS
43 501420340180 1 MVIS
44 501420340197 1 MVIS
45 501420340231 1 MVIS
46 501420340248 1 MVIS
47 501420340255 1 MVIS
48 501910540017 1 MVIS
49 501970350012 1 MVIS
50 503250380022 1 MVIS
HC-085I 14:41 Monday, September 18, 2006 7
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-85IF2)
EVNTIDX LINKIDX EVENTYPE
500020110010 500020110130 1 MVIS
500020110027 500020110147 1 MVIS
500020110058 500020110154 1 MVIS
500020110065 500020110147 1 MVIS
500020150016 500020150023 1 MVIS
500020150030 1 MVIS
500020150054 500020150143 1 MVIS
500020150150 1 MVIS
500020150167 1 MVIS
500020150085 500020150174 1 MVIS
500020150181 1 MVIS
500020150105 500020150181 1 MVIS
500020150129 500020150174 1 MVIS
500020150198 1 MVIS
500020150201 1 MVIS
500020150225 500020150263 1 MVIS
500020150270 1 MVIS
500020150287 1 MVIS
500020150256 500020150307 4 STAZ
500020150314 4 STAZ
500020150294 500020150321 1 MVIS
500020390016 500020390054 1 MVIS
500020390023 500020390061 1 MVIS
500020390078 1 MVIS
500020390085 1 MVIS
500020390129 500020390150 1 MVIS
500020390167 1 MVIS
500020390143 500020390167 1 MVIS
500020390201 500020390256 1 MVIS
500020390218 500020390256 1 MVIS
500030180016 500030180078 1 MVIS
HC-085I 14:41 Monday, September 18, 2006 8
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-85IF2)
EVNTIDX LINKIDX EVENTYPE
500030180023 500030180085 1 MVIS
500030180061 500030180092 1 MVIS
500030180174 500030180198 1 MVIS
500030180181 500030180201 1 MVIS
500030180287 500030180307 1 MVIS
500030250078 500030250085 1 MVIS
500030250092 1 MVIS
500050180027 500050180034 1 MVIS
500050180041 1 MVIS
500060110012 500060110098 1 MVIS
500060110101 1 MVIS
500060110118 1 MVIS
500060110125 1 MVIS
500060110067 500060110132 1 MVIS
500060110245 500060110416 1 MVIS
500070130218 500070130232 1 MVIS
500070130249 1 MVIS
500070200016 500070200085 1 MVIS
500070200092 1 MVIS
500070200105 1 MVIS
500070200078 500070200112 1 MVIS
500080130048 500080130106 1 MVIS
500080130055 500080130113 1 MVIS
500080130079 500080130120 5 DVIS
500080130137 5 DVIS
500100260034 500100260161 1 MVIS
500100260178 1 MVIS
500100260185 1 MVIS
500100260192 1 MVIS
500100260205 1 MVIS
500100260212 1 MVIS
500100260229 1 MVIS
500100260236 1 MVIS
HC-085I 14:41 Monday, September 18, 2006 9
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-85IF2)
EVNTIDX LINKIDX EVENTYPE
500100260034 500100260243 1 MVIS
500100260250 1 MVIS
500110200020 500110200037 3 EROM
500120260111 500120260166 5 DVIS
500130170015 500130170060 5 DVIS
500130170022 500130170060 5 DVIS
500130170077 500130170128 5 DVIS
500130170084 500130170128 5 DVIS
500130170091 500130170128 5 DVIS
500130170111 500130170135 2 OPAT
500130170142 500130170180 5 DVIS
500130170159 500130170180 5 DVIS
500130170173 500130170197 1 MVIS
500130240039 500130240046 1 MVIS
500130240060 500130240084 1 MVIS
500130240077 500130240091 1 MVIS
500140150029 500140150245 1 MVIS
500140150194 500140150252 1 MVIS
500140220012 500140220043 1 MVIS
500140220067 500140220098 1 MVIS
500150220024 500150220048 1 MVIS
500150530024 500150530048 4 STAZ
500190190015 500190190046 1 MVIS
500190190053 1 MVIS
500190190060 1 MVIS
500190190022 500190190053 3 EROM
500190190077 3 EROM
HC-085I 14:41 Monday, September 18, 2006 10
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-85IF2)
EVNTIDX LINKIDX EVENTYPE
500190190022 500190190084 3 EROM
500190190091 3 EROM
500190190039 500190190046 2 OPAT
500190190053 2 OPAT
500190190084 2 OPAT
500190190104 500190190111 1 MVIS
500190190128 1 MVIS
500190260015 500190260022 1 MVIS
500190260053 500190260060 1 MVIS
500190260077 1 MVIS
500190260084 1 MVIS
500190330022 500190330039 1 MVIS
500190400022 500190400039 1 MVIS
500190400046 1 MVIS
500190590020 500190590044 1 MVIS
500190590037 500190590051 1 MVIS
500190590068 1 MVIS
500190590075 1 MVIS
500190590082 500190590126 1 MVIS
500190590133 1 MVIS
500190590140 1 MVIS
500190590099 500190590140 1 MVIS
500200110085 500200110136 4 STAZ
500200110294 500200110530 4 STAZ
500240160045 500240160069 1 MVIS
500240160076 1 MVIS
500240300038 500240300052 3 EROM
500250270018 500250270025 1 MVIS
500250270032 500250270114 1 MVIS
500250270121 1 MVIS
500260320018 500260320049 1 MVIS
HC-085I 14:41 Monday, September 18, 2006 11
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-85IF2)
EVNTIDX LINKIDX EVENTYPE
500290130019 500290130146 1 MVIS
500290130153 1 MVIS
500290130160 1 MVIS
500290130177 1 MVIS
500290130184 1 MVIS
500290130191 500290130437 1 MVIS
500290130300 500290130444 1 MVIS
500290200019 500290200095 1 MVIS
500290200108 1 MVIS
500290200115 1 MVIS
500290200122 500290200153 1 MVIS
500290200160 1 MVIS
500290200139 500290200177 1 MVIS
500300170013 500300170037 1 MVIS
500300240013 500300240068 1 MVIS
500330220025 500330220049 1 MVIS
500330460018 500330460032 3 EROM
500330460049 3 EROM
HC-085I 14:41 Monday, September 18, 2006 12
Sample SAS Job for Example A
sample print of work.pmedids - sorted by evntidx
work.rxlk records for evntidxs in work.asmvis
EVNTIDX EVENTYPE LINKIDX
500360140029 1 MVIS 500360140074
500660410013 1 MVIS 500660410044
500660410037 1 MVIS 500660410051
500680120011 1 MVIS 500680120028
500700150413 1 MVIS 500700150622
501170360156 1 MVIS 501170360170
1 MVIS 501170360207
501910540017 1 MVIS 501910540024
501970350012 1 MVIS 501970350043
503250380022 1 MVIS 503250380046
1 MVIS 503250380053
504480460070 1 MVIS 504480460114
504480460087 1 MVIS 504480460121
1 MVIS 504480460138
504480460183 1 MVIS 504480460265
1 MVIS 504480460272
504480460296 1 MVIS 504480460354
1 MVIS 504480460361
504480460347 1 MVIS 504480460378
1 MVIS 504480460392
504520190012 1 MVIS 504520190029
1 MVIS 504520190036
504580270179 1 MVIS 504580270186
1 MVIS 504580270193
1 MVIS 504580270206
1 MVIS 504580270213
1 MVIS 504580270220
504600560019 1 MVIS 504600560026
505160200019 1 MVIS 505160200040
505160500065 1 MVIS 505160500096
1 MVIS 505160500109
HC-085I 14:41 Monday, September 18, 2006 13
Sample SAS Job for Example A
sample print of work.pmedids - sorted by evntidx
work.rxlk records for evntidxs in work.asmvis
EVNTIDX EVENTYPE LINKIDX
505160500065 1 MVIS 505160500116
1 MVIS 505160500123
505160670096 1 MVIS 505160670123
1 MVIS 505160670130
1 MVIS 505160670147
505460330017 1 MVIS 505460330024
506250260669 1 MVIS 506250260690
1 MVIS 506250260703
506310290013 1 MVIS 506310290075
506310290455 1 MVIS 506310290462
506350380042 1 MVIS 506350380066
1 MVIS 506350380073
1 MVIS 506350380080
1 MVIS 506350380097
1 MVIS 506350380100
506350750012 1 MVIS 506350750036
1 MVIS 506350750043
506350750050 1 MVIS 506350750074
1 MVIS 506350750081
HC-085I 14:41 Monday, September 18, 2006 14
Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx
Obs EVNTIDX EVENTYPE LINKIDX
1 500360140029 1 MVIS 500360140074
2 500660410013 1 MVIS 500660410044
3 500660410037 1 MVIS 500660410051
4 500680120011 1 MVIS 500680120028
5 500700150413 1 MVIS 500700150622
6 501170360156 1 MVIS 501170360170
7 501170360156 1 MVIS 501170360207
8 501910540017 1 MVIS 501910540024
9 501970350012 1 MVIS 501970350043
10 503250380022 1 MVIS 503250380046
11 503250380022 1 MVIS 503250380053
12 504480460070 1 MVIS 504480460114
13 504480460087 1 MVIS 504480460121
14 504480460087 1 MVIS 504480460138
15 504480460183 1 MVIS 504480460265
16 504480460183 1 MVIS 504480460272
17 504480460296 1 MVIS 504480460354
18 504480460296 1 MVIS 504480460361
19 504480460347 1 MVIS 504480460378
20 504480460347 1 MVIS 504480460392
21 504520190012 1 MVIS 504520190029
22 504520190012 1 MVIS 504520190036
23 504580270179 1 MVIS 504580270186
24 504580270179 1 MVIS 504580270193
25 504580270179 1 MVIS 504580270206
26 504580270179 1 MVIS 504580270213
27 504580270179 1 MVIS 504580270220
28 504600560019 1 MVIS 504600560026
29 505160200019 1 MVIS 505160200040
30 505160500065 1 MVIS 505160500096
31 505160500065 1 MVIS 505160500109
32 505160500065 1 MVIS 505160500116
33 505160500065 1 MVIS 505160500123
34 505160670096 1 MVIS 505160670123
35 505160670096 1 MVIS 505160670130
36 505160670096 1 MVIS 505160670147
37 505460330017 1 MVIS 505460330024
38 506250260669 1 MVIS 506250260690
39 506250260669 1 MVIS 506250260703
40 506310290013 1 MVIS 506310290075
41 506310290455 1 MVIS 506310290462
42 506350380042 1 MVIS 506350380066
43 506350380042 1 MVIS 506350380073
44 506350380042 1 MVIS 506350380080
45 506350380042 1 MVIS 506350380097
46 506350380042 1 MVIS 506350380100
47 506350750012 1 MVIS 506350750036
48 506350750012 1 MVIS 506350750043
49 506350750050 1 MVIS 506350750074
50 506350750050 1 MVIS 506350750081
HC-085I 14:41 Monday, September 18, 2006 15
Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids
Obs LINKIDX
1 500360140074
2 500660410044
3 500660410051
4 500680120028
5 500700150622
6 501170360170
7 501170360207
8 501910540024
9 501970350043
10 503250380046
11 503250380053
12 504480460114
13 504480460121
14 504480460138
15 504480460265
16 504480460272
17 504480460354
18 504480460361
19 504480460378
20 504480460392
21 504520190029
22 504520190036
23 504580270186
24 504580270193
25 504580270206
26 504580270213
27 504580270220
28 504600560026
29 505160200040
30 505160500096
31 505160500109
32 505160500116
33 505160500123
34 505160670123
35 505160670130
36 505160670147
37 505460330024
38 506250260690
39 506250260703
40 506310290075
41 506310290462
42 506350380066
43 506350380073
44 506350380080
45 506350380097
46 506350380100
47 506350750036
48 506350750043
49 506350750074
50 506350750081
HC-085I 14:41 Monday, September 18, 2006 16
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
500360140074 500360140074001 ALBUTEROL 29.79 18145.547255
500660410044 500660410044001 TRIPROLIDINE/PSEUDOEPHEDRINE 2.34 1746.779809
500660410051 500660410051001 ALBUTEROL 5.71 1746.779809
500680120028 500680120028001 FLONASE 71.68 10088.578356
500700150622 500700150622001 PREDNISONE 9.99 13075.037223
501170360170 501170360170001 ALBUTEROL 17.32 5454.071837
501170360170002 ALBUTEROL 17.32 5454.071837
501170360170003 ALBUTEROL 17.32 5454.071837
501170360207 501170360207001 ZYRTEC 59.40 5454.071837
501910540024 501910540024001 ALBUTEROL 20.50 2697.068823
501910540024002 ALBUTEROL 20.50 2697.068823
501910540024003 ALBUTEROL 20.50 2697.068823
501970350043 501970350043001 ALLEGRA-D 29.70 2370.738304
503250380046 503250380046001 FLOVENT 59.14 4859.543960
503250380053 503250380053001 ALBUTEROL 9.70 4859.543960
504480460114 504480460114001 ORAPRED 11.53 23796.692200
504480460121 504480460121001 FLOVENT 41.02 23796.692200
504480460121002 FLOVENT 58.72 23796.692200
504480460138 504480460138001 NASACORT AQ 65.35 23796.692200
504480460138002 NASACORT AQ 31.76 23796.692200
504480460265 504480460265001 FLOVENT 43.72 23796.692200
504480460265002 FLOVENT 43.72 23796.692200
504480460272 504480460272001 NASACORT AQ 31.76 23796.692200
504480460272002 NASACORT AQ 35.35 23796.692200
504480460354 504480460354001 PREDNISONE 3.46 23796.692200
504480460361 504480460361001 AMOXIL (BUBBLEGUM) 6.55 23796.692200
504480460378 504480460378001 FLOVENT 41.02 23796.692200
504480460392 504480460392001 ALBUTEROL 11.43 23796.692200
504520190029 504520190029001 ALBUTEROL 29.79 4720.030822
HC-085I 14:41 Monday, September 18, 2006 17
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
504520190036 504520190036001 ALLEGRA-D 89.49 4720.030822
504580270186 504580270186001 ADVAIR 2.72 6698.424396
504580270186002 ADVAIR 2.72 6698.424396
504580270186003 ADVAIR 2.72 6698.424396
504580270193 504580270193001 ZYRTEC 158.85 6698.424396
504580270193002 ZYRTEC 158.85 6698.424396
504580270193003 ZYRTEC 158.85 6698.424396
504580270206 504580270206001 RHINOCORT AQUA 74.84 6698.424396
504580270206002 RHINOCORT AQUA 74.84 6698.424396
504580270206003 RHINOCORT AQUA 74.84 6698.424396
504580270213 504580270213001 ZITHROMAX Z-PAK 49.43 6698.424396
504580270220 504580270220001 ALBUTEROL 10.14 6698.424396
504600560026 504600560026001 AVALIDE 54.55 4836.513225
505160200040 505160200040001 ENALAPRIL 61.27 1743.606923
505160500096 505160500096001 FORADIL AEROLIZER (10X6) 85.52 2219.999712
505160500096002 FORADIL AEROLIZER (10X6) 85.52 2219.999712
505160500096003 FORADIL AEROLIZER (10X6) 85.52 2219.999712
505160500096004 FORADIL AEROLIZER (10X6) 85.52 2219.999712
505160500096005 FORADIL AEROLIZER (10X6) 85.52 2219.999712
505160500109 505160500109001 CLARITIN 32.38 2219.999712
505160500109002 CLARITIN 32.38 2219.999712
505160500109003 CLARITIN 32.38 2219.999712
505160500109004 CLARITIN 32.38 2219.999712
505160500109005 CLARITIN 32.38 2219.999712
505160500116 505160500116001 SINGULAIR (UNIT OF USE) 90.54 2219.999712
505160500116002 SINGULAIR (UNIT OF USE) 90.54 2219.999712
505160500116003 SINGULAIR (UNIT OF USE) 90.54 2219.999712
505160500116004 SINGULAIR (UNIT OF USE) 90.54 2219.999712
505160500116005 SINGULAIR (UNIT OF USE) 90.54 2219.999712
505160500123 505160500123001 FLOVENT 60.33 2219.999712
505160500123002 FLOVENT 60.33 2219.999712
505160500123003 FLOVENT 60.33 2219.999712
505160500123004 FLOVENT 60.33 2219.999712
505160500123005 FLOVENT 60.33 2219.999712
505160670123 505160670123001 PULMICORT RESPULES (5X6) 262.19 1585.083960
505160670123002 PULMICORT RESPULES (5X6) 262.19 1585.083960
505160670123003 PULMICORT RESPULES (5X6) 262.19 1585.083960
HC-085I 14:41 Monday, September 18, 2006 18
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
505160670123 505160670123004 PULMICORT RESPULES (5X6) 237.77 1585.083960
505160670123005 PULMICORT RESPULES (5X6) 246.86 1585.083960
505160670130 505160670130001 SINGULAIR (UNIT OF USE) 81.85 1585.083960
505160670130002 SINGULAIR (UNIT OF USE) 81.85 1585.083960
505160670130003 SINGULAIR (UNIT OF USE) 81.85 1585.083960
505160670130004 SINGULAIR (UNIT OF USE) 81.85 1585.083960
505160670130005 SINGULAIR (UNIT OF USE) 81.85 1585.083960
505160670147 505160670147001 CLARITIN 32.38 1585.083960
505160670147002 CLARITIN 32.38 1585.083960
505160670147003 CLARITIN 32.38 1585.083960
505160670147004 CLARITIN 32.38 1585.083960
505160670147005 CLARITIN 32.38 1585.083960
505460330024 505460330024001 ALBUTEROL 21.41 1194.723502
505460330024002 ALBUTEROL 21.41 1194.723502
506250260690 506250260690001 ALBUTEROL 155.70 7142.252547
506250260703 506250260703001 AZMACORT 88.15 7142.252547
506310290075 506310290075001 PULMICORT 261.29 2414.143569
506310290462 506310290462001 ADVAIR DISKUS 171.41 2414.143569
506350380066 506350380066001 ALBUTEROL 21.41 17226.408358
506350380066002 ALBUTEROL 21.41 17226.408358
506350380073 506350380073001 ADVAIR DISKUS 100/50 114.38 17226.408358
506350380080 506350380080001 ALLEGRA (FILM-COATED) 22.02 17226.408358
506350380080002 ALLEGRA (FILM-COATED) 22.02 17226.408358
506350380097 506350380097001 ELIDEL 50.83 17226.408358
506350380100 506350380100001 FLONASE 66.70 17226.408358
506350750036 506350750036001 ALBUTEROL 21.41 11826.856420
506350750036002 ALBUTEROL 21.41 11826.856420
506350750043 506350750043001 ZITHROMAX 47.99 11826.856420
506350750074 506350750074001 ALBUTEROL 24.99 11826.856420
506350750081 506350750081001 ZITHROMAX 61.31 11826.856420
506350750081002 ZITHROMAX 61.31 11826.856420
506350750098 506350750098001 SINGULAIR 90.54 11826.856420
HC-085I 14:41 Monday, September 18, 2006 19
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
506350750098 506350750098002 SINGULAIR 90.54 11826.856420
506450470038 506450470038001 SINGULAIR 81.85 4787.331871
506450470038002 SINGULAIR 81.85 4787.331871
506450470038003 SINGULAIR 81.85 4787.331871
506450470038004 SINGULAIR 81.85 4787.331871
506450470038005 SINGULAIR 81.85 4787.331871
506600190237 506600190237001 WARFARIN SODIUM 24.76 11149.008735
506600190244 506600190244001 AVANDIA 118.78 11149.008735
506600190251 506600190251001 LISINOPRIL 7.32 11149.008735
506600190268 506600190268001 SINGULAIR 33.65 11149.008735
506600190275 506600190275001 LIPITOR 68.42 11149.008735
506860150074 506860150074001 ADVAIR DISKUS 250/50 139.36 14580.339502
506860150074002 ADVAIR DISKUS 250/50 139.36 14580.339502
506860150081 506860150081001 ALBUTEROL 30.90 14580.339502
506860150098 506860150098001 PREDNISONE 4.01 14580.339502
506860150098002 PREDNISONE 4.01 14580.339502
506860150098003 PREDNISONE 4.01 14580.339502
506860150098004 PREDNISONE 4.01 14580.339502
506860150098005 PREDNISONE 4.01 14580.339502
506870150727 506870150727001 ADVAIR DISKUS 250/50 271.89 2542.936632
506870150734 506870150734001 SPIRIVA (W/HANDIHALER) 120.00 2542.936632
506870151080 506870151080001 ALBUTEROL 18.90 2542.936632
506870151080002 ALBUTEROL 18.90 2542.936632
506870151080003 ALBUTEROL 18.90 2542.936632
506870151080004 ALBUTEROL 18.90 2542.936632
506870151080005 ALBUTEROL 18.90 2542.936632
506870151080006 ALBUTEROL 18.90 2542.936632
506870151097 506870151097001 THEOPHYLLINE 17.67 2542.936632
506870151097002 THEOPHYLLINE 16.03 2542.936632
506870151097003 THEOPHYLLINE 17.67 2542.936632
506870151097004 THEOPHYLLINE 17.67 2542.936632
506870151097005 THEOPHYLLINE 16.03 2542.936632
506870151097006 THEOPHYLLINE 20.86 2542.936632
506870151097007 THEOPHYLLINE 20.86 2542.936632
506870151100 506870151100001 ALBUTEROL 19.51 2542.936632
HC-085I 14:41 Monday, September 18, 2006 20
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
506870151100 506870151100002 ALBUTEROL 19.51 2542.936632
506870151100003 ALBUTEROL 19.51 2542.936632
506870151100004 ALBUTEROL 13.35 2542.936632
506870151100005 ALBUTEROL 13.35 2542.936632
506870151100006 ALBUTEROL 13.35 2542.936632
506870151100007 ALBUTEROL 19.51 2542.936632
506870151117 506870151117001 FUROSEMIDE 6.31 2542.936632
506870151117002 FUROSEMIDE 6.31 2542.936632
506870151117003 FUROSEMIDE 6.31 2542.936632
506870151117004 FUROSEMIDE 6.31 2542.936632
506870151117005 FUROSEMIDE 6.31 2542.936632
506870151117006 FUROSEMIDE 6.31 2542.936632
506870151117007 FUROSEMIDE 6.31 2542.936632
506870151124 506870151124001 SPIRIVA (W/HANDIHALER) 120.00 2542.936632
506870151124002 SPIRIVA (W/HANDIHALER) 120.00 2542.936632
506870151124003 SPIRIVA (W/HANDIHALER) 120.00 2542.936632
506870151124004 SPIRIVA (W/HANDIHALER) 120.00 2542.936632
506870151124005 SPIRIVA (W/HANDIHALER) 120.00 2542.936632
507680400105 507680400105001 ORAPRED (DYE-FREE,GRAPE) 45.17 1847.389592
507680400105002 ORAPRED (DYE-FREE,GRAPE) 31.90 1847.389592
507680400129 507680400129001 ALBUTEROL SULFATE (PF) 14.57 1847.389592
508200140013 508200140013001 FLOVENT 66.74 6686.895596
508200140020 508200140020001 FORADIL AEROLIZER (BLISTER PACK,10X6) 83.15 6686.895596
509070180042 509070180042001 ALBUTEROL 19.20 12945.051075
509070180059 509070180059001 IPRATROPIUM BROMIDE 7.00 12945.051075
509250240180 509250240180001 ADVAIR 22.85 14875.543284
509250240180002 ADVAIR 22.85 14875.543284
509250240180003 ADVAIR 22.85 14875.543284
510780110039 510780110039001 PREDNISONE 10.20 4063.251901
510780110522 510780110522001 TRIAMTERENE/HCTZ 10.11 4063.251901
510780110522002 TRIAMTERENE/HCTZ 10.11 4063.251901
510780110539 510780110539001 SEREVENT DISKUS 46.81 4063.251901
510780110539002 SEREVENT DISKUS 48.12 4063.251901
510780110539003 SEREVENT DISKUS 46.81 4063.251901
510780110539004 SEREVENT DISKUS 48.12 4063.251901
510780110546 510780110546001 ASTELIN 31.35 4063.251901
HC-085I 14:41 Monday, September 18, 2006 21
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
510780110553 510780110553001 ESTRACE 34.19 4063.251901
510780110560 510780110560001 ACIPHEX 188.79 4063.251901
510780110560002 ACIPHEX 188.79 4063.251901
510780110560003 ACIPHEX 188.79 4063.251901
510780110560004 ACIPHEX 188.79 4063.251901
510780110577 510780110577001 STORE CALCIUM 3.49 4063.251901
510780110584 510780110584001 WELCHOL 33.50 4063.251901
510780110584002 WELCHOL 33.50 4063.251901
510780110584003 WELCHOL 33.50 4063.251901
510780110584004 WELCHOL 33.50 4063.251901
510780110591 510780110591001 STORE IRON 4.06 4063.251901
510780110604 510780110604001 TYLENOL 2.99 4063.251901
510780110611 510780110611001 LEVOTHYROXINE SODIUM 7.46 4063.251901
510780110611002 LEVOTHYROXINE SODIUM 7.46 4063.251901
510780110611003 LEVOTHYROXINE SODIUM 7.46 4063.251901
510900200176 510900200176001 ADVAIR 114.66 16486.283663
510900200183 510900200183001 OGESTREL-28 (3X28) 33.81 16486.283663
510900200183002 OGESTREL-28 (3X28) 33.81 16486.283663
510900200183003 OGESTREL-28 (3X28) 33.81 16486.283663
510900200183004 OGESTREL-28 (3X28) 33.81 16486.283663
510900200190 510900200190001 ALBUTEROL 19.50 16486.283663
511120700030 511120700030001 FLOVENT 57.09 1754.764178
511120700030002 FLOVENT 57.09 1754.764178
511120700047 511120700047001 SINGULAIR 84.19 1754.764178
511120700047002 SINGULAIR 84.19 1754.764178
511120700054 511120700054001 ALBUTEROL 10.78 1754.764178
511120700054002 ALBUTEROL 10.78 1754.764178
511280130123 511280130123001 NORVASC 72.89 7821.827981
511280130123002 NORVASC 72.89 7821.827981
511280130123003 NORVASC 72.89 7821.827981
511280130130 511280130130001 METOPROLOL 35.98 7821.827981
HC-085I 14:41 Monday, September 18, 2006 22
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
The MEANS Procedure
Analysis Variable : RXXP04X SUM OF PAYMENTS RXSF04X-RXOU04X(IMPUTED)
N Sum
--------------------
4945 304956.43
--------------------
HC-085I 14:41 Monday, September 18, 2006 23
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP04X SUM OF PAYMENTS RXSF04X-RXOU04X(IMPUTED)
N Sum
--------------------
4945 2470593127
--------------------
1 The SAS System 14:42 Monday, September 18, 2006
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX09.
NOTE: SAS initialization used:
real time 2.31 seconds
cpu time 0.39 seconds
NOTE: AUTOEXEC processing beginning; file is C:\progra~1\sasins~1\sas\v8\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-085I";
4 TITLE2 "Sample SAS Job for Example B";
5
6 LIBNAME IN "C:\data";
NOTE: Libref IN was successfully assigned as follows:
Engine: V8
Physical Name: C:\data
7
8 **************************************************************************************
9 * Calculate the expenditures for prescribed medicines associated with asthma.
10 **************************************************************************************;
11 PROC FORMAT;
12 VALUE EVENTYPE
13 1 = "1 MVIS"
14 2 = "2 OPAT"
15 3 = "3 EROM"
16 4 = "4 STAZ"
17 5 = "5 DVIS"
18 6 = "6 OMED"
19 7 = "7 HVIS"
20 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
21 RUN;
NOTE: PROCEDURE FORMAT used:
real time 0.10 seconds
cpu time 0.01 seconds
22
23 *--------------------------------------------------------------------------------------
24 * Get condition records coded as asthma.
2 The SAS System 14:42 Monday, September 18, 2006
25 *--------------------------------------------------------------------------------------;
26 DATA ASCONDS;
27 SET IN.H87 (KEEP=CONDIDX CCCODEX);
28 IF CCCODEX="128";
29 RUN;
NOTE: There were 106738 observations read from the data set IN.H87.
NOTE: The data set WORK.ASCONDS has 1835 observations and 2 variables.
NOTE: DATA statement used:
real time 1.35 seconds
cpu time 0.20 seconds
30
31 *--------------------------------------------------------------------------
32 * Get the events linked to each of the asthma condition records.
33 *--------------------------------------------------------------------------;
34 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 1835 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1835 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.06 seconds
cpu time 0.03 seconds
35
36 proc print data=asconds (obs=50);
37 title3 "sample print of work.asconds - sorted by condidx";
38 title4 "COND (H87) records where cccodex=128";
39 run;
NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used:
real time 0.21 seconds
cpu time 0.03 seconds
40
41 PROC SORT DATA=IN.H85IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 348119 observations read from the data set IN.H85IF1.
NOTE: The data set WORK.CLNK has 348119 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 23.37 seconds
cpu time 2.67 seconds
42
43 DATA ASCLNKS;
44 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
45 ASCONDS(IN=INASCOND KEEP=CONDIDX);
46 BY CONDIDX;
47 IF INCLNK & INASCOND;
48 RUN;
3 The SAS System 14:42 Monday, September 18, 2006
NOTE: There were 348119 observations read from the data set WORK.CLNK.
NOTE: There were 1835 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7244 observations and 3 variables.
NOTE: DATA statement used:
real time 3.17 seconds
cpu time 0.37 seconds
49
50 proc print data=asclnks (obs=75);
51 by condidx;
52 id condidx;
53 format eventype eventype.;
54 title3 "sample print of work.asclnks - sorted by condidx";
55 title4 "events linked to asthma condition records";
56 run;
NOTE: There were 75 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used:
real time 0.07 seconds
cpu time 0.00 seconds
57
58 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7244 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7244 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.03 seconds
cpu time 0.01 seconds
59
60 proc print data=asclnks (obs=50);
61 format eventype eventype.;
62 title3 "sample print of work.asclnks - sorted by evntidx";
63 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.01 seconds
64
65 DATA ASCLNKS;
66 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
67 BY EVNTIDX;
68 IF FIRST.EVNTIDX;
69 RUN;
NOTE: There were 7244 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7225 observations and 2 variables.
NOTE: DATA statement used:
4 The SAS System 14:42 Monday, September 18, 2006
real time 0.03 seconds
cpu time 0.03 seconds
70
71 proc print data=asclnks (obs=50);
72 format eventype eventype.;
73 title3 "sample print of unique evntidxs from work.asclnks";
74 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.00 seconds
75
76 *-------------------------------------------------------------------------------
77 * Get PMED records linked to asthma condition records.
78 *-------------------------------------------------------------------------------;
79 PROC SORT DATA=IN.H85A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 317065 observations read from the data set IN.H85A.
NOTE: The data set WORK.PMED has 317065 observations and 13 variables.
NOTE: PROCEDURE SORT used:
real time 56.31 seconds
cpu time 4.53 seconds
80
81 DATA ASPMEDS;
82 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F)
83 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX RENAME=(EVNTIDX=LINKIDX));
84 BY LINKIDX;
85 IF INASCLNK & PERWT04F>0;
86 RUN;
NOTE: There were 317065 observations read from the data set WORK.PMED.
NOTE: There were 7225 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 10670 observations and 5 variables.
NOTE: DATA statement used:
real time 1.73 seconds
cpu time 0.63 seconds
87
88 proc print data=aspmeds (obs=300);
89 by linkidx;
90 id linkidx;
91 var rxrecidx rxname RXXP04X PERWT04F;
92 title3 "sample print of work.aspmeds";
93 title4 "PMED (HC-085A) records which link to condition records coded as asthma";
94 run;
NOTE: There were 300 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE PRINT printed pages 6-14.
5 The SAS System 14:42 Monday, September 18, 2006
NOTE: PROCEDURE PRINT used:
real time 0.00 seconds
cpu time 0.00 seconds
95
96 PROC MEANS DATA=ASPMEDS N SUM;
97 VAR RXXP04X;
98 TITLE3 "Total Rx expenditures associated with asthma";
99 RUN;
NOTE: There were 10670 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 15.
NOTE: PROCEDURE MEANS used:
real time 0.09 seconds
cpu time 0.01 seconds
100
101 PROC MEANS DATA=ASPMEDS N SUM;
102 VAR RXXP04X;
103 WEIGHT PERWT04F;
104 TITLE3 "Total Rx expenditures associated with asthma";
105 TITLE5 "Weighted";
106 RUN;
NOTE: There were 10670 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 16.
NOTE: PROCEDURE MEANS used:
real time 0.03 seconds
cpu time 0.01 seconds
107
108
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 1:29.32
cpu time 9.06 seconds
HC-085I 14:42 Monday, September 18, 2006 1
Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H87) records where cccodex=128
Obs CCCODEX CONDIDX
1 128 500070130028
2 128 500070200033
3 128 500200110056
4 128 500360140018
5 128 500430190052
6 128 500460100016
7 128 500660410013
8 128 500680120023
9 128 500700150079
10 128 500950250018
11 128 500990170024
12 128 501090310018
13 128 501150120029
14 128 501160150036
15 128 501170360054
16 128 501290180058
17 128 501420340016
18 128 501690160041
19 128 501840550020
20 128 501840620013
21 128 501910540019
22 128 501970350043
23 128 502110120053
24 128 502620440014
25 128 502870280065
26 128 502900180021
27 128 503080270027
28 128 503100450013
29 128 503250380018
30 128 503370280017
31 128 503500310054
32 128 503580110010
33 128 503720160023
34 128 503730590022
35 128 504010100086
36 128 504200240023
37 128 504200480015
38 128 504230270053
39 128 504480460018
40 128 504520190016
41 128 504580270025
42 128 504580270075
43 128 504600560011
44 128 504720230091
45 128 504910450035
46 128 505160200037
47 128 505160500013
48 128 505160670034
49 128 505180190034
50 128 505280110061
HC-085I 14:42 Monday, September 18, 2006 2
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
500070130028 500070130256 8 PMED
500070130263 8 PMED
500070130410 8 PMED
500070130427 8 PMED
500070200033 500070200085 8 PMED
500070200092 8 PMED
500070200105 8 PMED
500200110056 500200110232 8 PMED
500200110636 8 PMED
500200111040 8 PMED
500360140018 500360140029 1 MVIS
500360140074 8 PMED
500360140252 8 PMED
500360140269 8 PMED
500360140276 8 PMED
500360140283 8 PMED
500360140290 8 PMED
500360140601 8 PMED
500360140618 8 PMED
500360140625 8 PMED
500430190052 500430190066 8 PMED
500460100016 500460100012 8 PMED
500660410013 500660410013 1 MVIS
500660410020 1 MVIS
500660410037 1 MVIS
500660410044 8 PMED
500660410051 8 PMED
500660410068 8 PMED
500660410082 8 PMED
500680120023 500680120011 1 MVIS
500680120035 8 PMED
500680120042 8 PMED
500680120059 8 PMED
500680120117 8 PMED
500680120124 8 PMED
500700150079 500700150393 8 PMED
500700150413 1 MVIS
500700150437 1 MVIS
500700150622 8 PMED
500700150660 8 PMED
HC-085I 14:42 Monday, September 18, 2006 3
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
500990170024 500990170063 8 PMED
500990170169 8 PMED
500990170176 8 PMED
500990170183 8 PMED
500990170272 8 PMED
501090310018 501090310018 1 MVIS
501090310025 1 MVIS
501090310032 1 MVIS
501090310049 1 MVIS
501090310056 1 MVIS
501090310063 1 MVIS
501090310070 1 MVIS
501090310087 1 MVIS
501090310176 8 PMED
501090310183 8 PMED
501150120029 501150120037 8 PMED
501150120119 1 MVIS
501150120126 1 MVIS
501150120133 1 MVIS
501150120140 1 MVIS
501150120157 1 MVIS
501150120164 8 PMED
501160150036 501160150024 1 MVIS
501160150031 1 MVIS
501160150048 8 PMED
501160150079 8 PMED
501160150144 1 MVIS
501160150168 8 PMED
501160150459 8 PMED
501160150466 8 PMED
501170360054 501170360156 1 MVIS
501170360170 8 PMED
501170360214 8 PMED
501170360221 8 PMED
501170360238 8 PMED
HC-085I 14:42 Monday, September 18, 2006 4
Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx
Obs EVNTIDX EVENTYPE CONDIDX
1 500070130256 8 PMED 500070130028
2 500070130263 8 PMED 500070130028
3 500070130410 8 PMED 500070130028
4 500070130427 8 PMED 500070130028
5 500070200085 8 PMED 500070200033
6 500070200092 8 PMED 500070200033
7 500070200105 8 PMED 500070200033
8 500200110232 8 PMED 500200110056
9 500200110636 8 PMED 500200110056
10 500200111040 8 PMED 500200110056
11 500360140029 1 MVIS 500360140018
12 500360140074 8 PMED 500360140018
13 500360140252 8 PMED 500360140018
14 500360140269 8 PMED 500360140018
15 500360140276 8 PMED 500360140018
16 500360140283 8 PMED 500360140018
17 500360140290 8 PMED 500360140018
18 500360140601 8 PMED 500360140018
19 500360140618 8 PMED 500360140018
20 500360140625 8 PMED 500360140018
21 500430190066 8 PMED 500430190052
22 500460100012 8 PMED 500460100016
23 500660410013 1 MVIS 500660410013
24 500660410020 1 MVIS 500660410013
25 500660410037 1 MVIS 500660410013
26 500660410044 8 PMED 500660410013
27 500660410051 8 PMED 500660410013
28 500660410068 8 PMED 500660410013
29 500660410082 8 PMED 500660410013
30 500680120011 1 MVIS 500680120023
31 500680120035 8 PMED 500680120023
32 500680120042 8 PMED 500680120023
33 500680120059 8 PMED 500680120023
34 500680120117 8 PMED 500680120023
35 500680120124 8 PMED 500680120023
36 500700150393 8 PMED 500700150079
37 500700150413 1 MVIS 500700150079
38 500700150437 1 MVIS 500700150079
39 500700150622 8 PMED 500700150079
40 500700150660 8 PMED 500700150079
41 500990170063 8 PMED 500990170024
42 500990170169 8 PMED 500990170024
43 500990170176 8 PMED 500990170024
44 500990170183 8 PMED 500990170024
45 500990170272 8 PMED 500990170024
46 501090310018 1 MVIS 501090310018
47 501090310025 1 MVIS 501090310018
48 501090310032 1 MVIS 501090310018
49 501090310049 1 MVIS 501090310018
50 501090310056 1 MVIS 501090310018
HC-085I 14:42 Monday, September 18, 2006 5
Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 500070130256 8 PMED
2 500070130263 8 PMED
3 500070130410 8 PMED
4 500070130427 8 PMED
5 500070200085 8 PMED
6 500070200092 8 PMED
7 500070200105 8 PMED
8 500200110232 8 PMED
9 500200110636 8 PMED
10 500200111040 8 PMED
11 500360140029 1 MVIS
12 500360140074 8 PMED
13 500360140252 8 PMED
14 500360140269 8 PMED
15 500360140276 8 PMED
16 500360140283 8 PMED
17 500360140290 8 PMED
18 500360140601 8 PMED
19 500360140618 8 PMED
20 500360140625 8 PMED
21 500430190066 8 PMED
22 500460100012 8 PMED
23 500660410013 1 MVIS
24 500660410020 1 MVIS
25 500660410037 1 MVIS
26 500660410044 8 PMED
27 500660410051 8 PMED
28 500660410068 8 PMED
29 500660410082 8 PMED
30 500680120011 1 MVIS
31 500680120035 8 PMED
32 500680120042 8 PMED
33 500680120059 8 PMED
34 500680120117 8 PMED
35 500680120124 8 PMED
36 500700150393 8 PMED
37 500700150413 1 MVIS
38 500700150437 1 MVIS
39 500700150622 8 PMED
40 500700150660 8 PMED
41 500990170063 8 PMED
42 500990170169 8 PMED
43 500990170176 8 PMED
44 500990170183 8 PMED
45 500990170272 8 PMED
46 501090310018 1 MVIS
47 501090310025 1 MVIS
48 501090310032 1 MVIS
49 501090310049 1 MVIS
50 501090310056 1 MVIS
HC-085I 14:42 Monday, September 18, 2006 6
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-085A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
500070130256 500070130256001 ALBUTEROL 10.68 8889.356585
500070130256002 ALBUTEROL 10.68 8889.356585
500070130256003 ALBUTEROL 10.68 8889.356585
500070130263 500070130263001 FLOVENT 76.55 8889.356585
500070130263002 FLOVENT 76.55 8889.356585
500070130263003 FLOVENT 76.55 8889.356585
500070130410 500070130410001 ALBUTEROL 36.54 8889.356585
500070130410002 ALBUTEROL 36.54 8889.356585
500070130410003 ALBUTEROL 36.54 8889.356585
500070130427 500070130427001 FLOVENT 76.55 8889.356585
500070130427002 FLOVENT 76.55 8889.356585
500070130427003 FLOVENT 76.55 8889.356585
500070200085 500070200085001 ALBUTEROL 20.50 6960.075150
500070200085002 ALBUTEROL 20.50 6960.075150
500070200085003 ALBUTEROL 20.50 6960.075150
500070200092 500070200092001 FLOVENT 83.47 6960.075150
500070200092002 FLOVENT 83.47 6960.075150
500070200092003 FLOVENT 83.47 6960.075150
500070200105 500070200105001 CLARINEX 66.20 6960.075150
500200110232 500200110232001 SINGULAIR (UNIT OF USE) 88.79 5925.342066
500200110636 500200110636001 ALLEGRA (FILM-COATED) 83.51 5925.342066
500200110636002 ALLEGRA (FILM-COATED) 83.51 5925.342066
500200110636003 ALLEGRA (FILM-COATED) 83.51 5925.342066
500200110636004 ALLEGRA (FILM-COATED) 83.51 5925.342066
500200110636005 ALLEGRA (FILM-COATED) 83.51 5925.342066
500200111040 500200111040001 ALLEGRA 39.43 5925.342066
500200111040002 ALLEGRA 39.43 5925.342066
500200111040003 ALLEGRA 39.43 5925.342066
500200111040004 ALLEGRA 39.43 5925.342066
500200111040005 ALLEGRA 39.43 5925.342066
500360140074 500360140074001 ALBUTEROL 29.79 18145.547255
500360140252 500360140252001 ADVAIR DISKUS 60'S 521.34 18145.547255
500360140252002 ADVAIR DISKUS 60'S 521.34 18145.547255
500360140269 500360140269001 IPRATROPIUM BROMIDE 56.19 18145.547255
500360140269002 IPRATROPIUM BROMIDE 56.19 18145.547255
500360140276 500360140276001 UNIPHYL 110.73 18145.547255
HC-085I 14:42 Monday, September 18, 2006 7
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-085A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
500360140276 500360140276002 UNIPHYL 110.73 18145.547255
500360140283 500360140283001 COMBIVENT 302.84 18145.547255
500360140283002 COMBIVENT 302.84 18145.547255
500360140290 500360140290001 PREDNISONE 4.41 18145.547255
500360140290002 PREDNISONE 4.41 18145.547255
500360140601 500360140601001 COMBIVENT 302.84 18145.547255
500360140601002 COMBIVENT 302.84 18145.547255
500360140618 500360140618001 IPRATROPIUM BROMIDE 56.19 18145.547255
500360140618002 IPRATROPIUM BROMIDE 56.19 18145.547255
500360140625 500360140625001 METHYLPREDNISOLONE 74.34 18145.547255
500360140625002 METHYLPREDNISOLONE 74.34 18145.547255
500360140625003 METHYLPREDNISOLONE 74.34 18145.547255
500430190066 500430190066001 ALBUTEROL 11.34 6423.278613
500460100012 500460100012001 ORTHO TRI-CYCLEN 43.74 8690.565089
500460100012002 ORTHO TRI-CYCLEN 43.74 8690.565089
500460100012003 ORTHO TRI-CYCLEN 43.74 8690.565089
500460100012004 ORTHO TRI-CYCLEN 43.74 8690.565089
500660410044 500660410044001 TRIPROLIDINE/PSEUDOEPHEDRINE 2.34 1746.779809
500660410051 500660410051001 ALBUTEROL 5.71 1746.779809
500660410068 500660410068001 BROTAPP-DM C+C 14.49 1746.779809
500660410082 500660410082001 DIPHEN AF (CHERRY) 17.99 1746.779809
500680120035 500680120035001 SEREVENT DISKUS 20.00 10088.578356
500680120042 500680120042001 COMBIVENT 58.47 10088.578356
500680120059 500680120059001 FLOVENT 20.00 10088.578356
500680120117 500680120117001 SEREVENT DISKUS 20.00 10088.578356
500680120124 500680120124001 FLOVENT 20.00 10088.578356
500700150393 500700150393001 ALBUTEROL 21.41 13075.037223
500700150622 500700150622001 PREDNISONE 9.99 13075.037223
500700150660 500700150660001 ALBUTEROL 21.41 13075.037223
500700150660002 ALBUTEROL 21.41 13075.037223
HC-085I 14:42 Monday, September 18, 2006 8
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-085A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
500990170063 500990170063001 ADVAIR DISKUS 100/50 118.01 4051.586162
500990170169 500990170169001 ADVAIR DISKUS 100/50 114.32 4051.586162
500990170176 500990170176001 FLONASE 64.36 4051.586162
500990170183 500990170183001 ALBUTEROL 10.05 4051.586162
500990170272 500990170272001 ADVAIR DISKUS 100/50 118.01 4051.586162
501090310176 501090310176001 ADVAIR 106.02 12809.897585
501090310183 501090310183001 NASACORT 59.85 12809.897585
501150120037 501150120037001 SINGULAIR (UNIT OF USE) 98.40 5655.210465
501150120037002 SINGULAIR (UNIT OF USE) 98.40 5655.210465
501150120037003 SINGULAIR (UNIT OF USE) 98.40 5655.210465
501150120164 501150120164001 SINGULAIR (UNIT OF USE) 86.17 5655.210465
501150120164002 SINGULAIR (UNIT OF USE) 86.17 5655.210465
501150120164003 SINGULAIR (UNIT OF USE) 86.17 5655.210465
501150120164004 SINGULAIR (UNIT OF USE) 98.40 5655.210465
501160150048 501160150048001 SINGULAIR (UNIT OF USE) 20.00 16315.927203
501160150079 501160150079001 ADVAIR DISKUS 100/50 129.10 16315.927203
501160150168 501160150168001 SINGULAIR (UNIT OF USE) 20.00 16315.927203
501160150459 501160150459001 ASTELIN 74.06 16315.927203
501160150466 501160150466001 ADVAIR DISKUS 250/50 163.41 16315.927203
501170360170 501170360170001 ALBUTEROL 17.32 5454.071837
501170360170002 ALBUTEROL 17.32 5454.071837
501170360170003 ALBUTEROL 17.32 5454.071837
501170360214 501170360214001 NASONEX 77.58 5454.071837
501170360221 501170360221001 SODIUM CHLORIDE 19.28 5454.071837
501170360238 501170360238001 PULMICORT 269.08 5454.071837
501290180194 501290180194001 ALBUTEROL 42.82 8032.825596
501290180194002 ALBUTEROL 42.82 8032.825596
501290180303 501290180303001 NASONEX 67.17 8032.825596
501290180303002 NASONEX 67.17 8032.825596
HC-085I 14:42 Monday, September 18, 2006 9
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-085A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
501290180341 501290180341001 ALBUTEROL 21.35 8032.825596
501290180341002 ALBUTEROL 21.35 8032.825596
501290180358 501290180358001 AZMACORT 88.15 8032.825596
501290180358002 AZMACORT 88.15 8032.825596
501420340200 501420340200001 ALBUTEROL 89.37 11749.261656
501420340279 501420340279001 SINGULAIR (UNIT OF USE) 98.40 11749.261656
501420340286 501420340286001 THEOPHYLLINE ER 95.81 11749.261656
501420340293 501420340293001 ADVAIR DISKUS 500/50 40.00 11749.261656
501420340313 501420340313001 ALBUTEROL 89.37 11749.261656
501420340313002 ALBUTEROL 89.37 11749.261656
501420340313003 ALBUTEROL 89.37 11749.261656
501420340313004 ALBUTEROL 89.37 11749.261656
501420340313005 ALBUTEROL 89.37 11749.261656
501420340313006 ALBUTEROL 89.37 11749.261656
501420340368 501420340368001 ALBUTEROL 64.23 11749.261656
501420340375 501420340375001 SINGULAIR (UNIT OF USE) 40.00 11749.261656
501420340382 501420340382001 THEOPHYLLINE ER 95.81 11749.261656
501420340399 501420340399001 ADVAIR DISKUS 500/50 40.00 11749.261656
501420340402 501420340402001 PREDNISONE 7.98 11749.261656
501420340402002 PREDNISONE 7.98 11749.261656
501420340419 501420340419001 FLONASE 71.68 11749.261656
501690160090 501690160090001 FORMALIN 19.60 2468.166224
501690160090002 FORMALIN 19.60 2468.166224
501690160090003 FORMALIN 19.60 2468.166224
501690160103 501690160103001 SINGULAIR 40.00 2468.166224
501690160103002 SINGULAIR 40.00 2468.166224
501690160103003 SINGULAIR 40.00 2468.166224
501690160247 501690160247001 FLOVENT 89.36 2468.166224
501690160247002 FLOVENT 89.36 2468.166224
501690160247003 FLOVENT 89.36 2468.166224
501690160247004 FLOVENT 89.36 2468.166224
501690160329 501690160329001 ADVAIR DISKUS 250/50 163.41 2468.166224
501690160329002 ADVAIR DISKUS 250/50 163.41 2468.166224
HC-085I 14:42 Monday, September 18, 2006 10
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-085A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
501690160329 501690160329003 ADVAIR DISKUS 250/50 163.41 2468.166224
501840550070 501840550070001 FLOVENT 62.69 2263.595578
501840550087 501840550087001 PROVENTIL 4.33 2263.595578
501840550121 501840550121001 FLOVENT 77.71 2263.595578
501840550121002 FLOVENT 77.71 2263.595578
501840550121003 FLOVENT 77.71 2263.595578
501840550176 501840550176001 FLOVENT 77.71 2263.595578
501840550183 501840550183001 PROVENTIL 4.33 2263.595578
501840620025 501840620025001 FLOVENT 62.69 2860.398153
501840620025002 FLOVENT 62.69 2860.398153
501840620025003 FLOVENT 62.69 2860.398153
501840620032 501840620032001 ALBUTEROL 12.10 2860.398153
501840620063 501840620063001 FLOVENT 62.69 2860.398153
501840620063002 FLOVENT 62.69 2860.398153
501840620063003 FLOVENT 62.69 2860.398153
501840620070 501840620070001 ALBUTEROL 17.99 2860.398153
501840620107 501840620107001 FLOVENT 62.69 2860.398153
501840620107002 FLOVENT 62.69 2860.398153
501840620114 501840620114001 ALBUTEROL 21.41 2860.398153
501910540024 501910540024001 ALBUTEROL 20.50 2697.068823
501910540024002 ALBUTEROL 20.50 2697.068823
501910540024003 ALBUTEROL 20.50 2697.068823
501910540055 501910540055001 ALBUTEROL 12.10 2697.068823
501910540062 501910540062001 ALBUTEROL 20.50 2697.068823
501910540079 501910540079001 PREDNISOLONE SODIUM PHOSPHATE 12.60 2697.068823
501970350043 501970350043001 ALLEGRA-D 29.70 2370.738304
502110120089 502110120089001 DILEX-G 10.07 17173.728728
502620440012 502620440012001 ADVAIR 114.66 6994.808716
502620440012002 ADVAIR 114.66 6994.808716
502620440012003 ADVAIR 114.66 6994.808716
502620440012004 ADVAIR 114.66 6994.808716
HC-085I 14:42 Monday, September 18, 2006 11
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-085A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
502620440012 502620440012005 ADVAIR 114.66 6994.808716
502620440012006 ADVAIR 114.66 6994.808716
502620440012007 ADVAIR 114.66 6994.808716
502620440012008 ADVAIR 114.66 6994.808716
502870280137 502870280137001 ADVAIR DISKUS 171.41 6662.211040
502870280137002 ADVAIR DISKUS 171.41 6662.211040
502870280168 502870280168001 ALBUTEROL 9.96 6662.211040
502870280168002 ALBUTEROL 9.96 6662.211040
502870280168003 ALBUTEROL 9.96 6662.211040
502870280264 502870280264001 ADVAIR DISKUS 250/50 163.41 6662.211040
503080270063 503080270063001 FLOVENT 54.43 22924.398377
503100450013 503100450013001 SINGULAIR 85.14 10693.385683
503100450013002 SINGULAIR 85.14 10693.385683
503100450013003 SINGULAIR 85.14 10693.385683
503100450013004 SINGULAIR 85.14 10693.385683
503100450020 503100450020001 SINGULAIR 81.31 10693.385683
503100450020002 SINGULAIR 81.31 10693.385683
503100450037 503100450037001 ALBUTEROL 27.85 10693.385683
503100450037002 ALBUTEROL 27.85 10693.385683
503100450037003 ALBUTEROL 27.85 10693.385683
503100450044 503100450044001 ALBUTEROL 27.85 10693.385683
503100450044002 ALBUTEROL 27.85 10693.385683
503100450051 503100450051001 SINGULAIR 81.31 10693.385683
503100450051002 SINGULAIR 81.31 10693.385683
503250380046 503250380046001 FLOVENT 59.14 4859.543960
503250380053 503250380053001 ALBUTEROL 9.70 4859.543960
503370280056 503370280056001 ALBUTEROL 19.60 4920.362655
503500310167 503500310167001 ALBUTEROL SULFATE 12.03 14552.194330
503500310174 503500310174001 ALBUTEROL 18.75 14552.194330
503580110017 503580110017001 THEOPHYLLINE 13.81 13651.008031
503580110017002 THEOPHYLLINE 13.81 13651.008031
503580110024 503580110024001 ALBUTEROL 17.47 13651.008031
503580110024002 ALBUTEROL 6.23 13651.008031
HC-085I 14:42 Monday, September 18, 2006 12
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-085A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
503580110031 503580110031001 FLOVENT 138.81 13651.008031
503580110031002 FLOVENT 138.81 13651.008031
503580110048 503580110048001 GUAIFENESIN 9.07 13651.008031
503580110048002 GUAIFENESIN 9.07 13651.008031
503580110079 503580110079001 THEOPHYLLINE 13.81 13651.008031
503580110079002 THEOPHYLLINE 13.81 13651.008031
503580110079003 THEOPHYLLINE 13.81 13651.008031
503580110079004 THEOPHYLLINE 13.81 13651.008031
503580110079005 THEOPHYLLINE 13.81 13651.008031
503580110086 503580110086001 ALBUTEROL 15.22 13651.008031
503580110086002 ALBUTEROL 15.22 13651.008031
503580110086003 ALBUTEROL 15.22 13651.008031
503580110086004 ALBUTEROL 15.22 13651.008031
503580110086005 ALBUTEROL 15.22 13651.008031
503580110093 503580110093001 FLOVENT 138.81 13651.008031
503580110093002 FLOVENT 138.81 13651.008031
503580110093003 FLOVENT 138.81 13651.008031
503580110093004 FLOVENT 138.81 13651.008031
503580110093005 FLOVENT 138.81 13651.008031
503580110106 503580110106001 GUAIFENESIN 9.07 13651.008031
503580110106002 GUAIFENESIN 9.07 13651.008031
503580110106003 GUAIFENESIN 9.07 13651.008031
503580110106004 GUAIFENESIN 9.07 13651.008031
503580110106005 GUAIFENESIN 9.07 13651.008031
503580110137 503580110137001 THEOPHYLLINE 13.81 13651.008031
503580110137002 THEOPHYLLINE 13.81 13651.008031
503580110137003 THEOPHYLLINE 13.81 13651.008031
503580110137004 THEOPHYLLINE 13.81 13651.008031
503580110144 503580110144001 ALBUTEROL 6.23 13651.008031
503580110144002 ALBUTEROL 6.23 13651.008031
503580110144003 ALBUTEROL 6.23 13651.008031
503580110144004 ALBUTEROL 6.23 13651.008031
503580110151 503580110151001 FLOVENT 138.81 13651.008031
503580110151002 FLOVENT 138.81 13651.008031
503580110151003 FLOVENT 138.81 13651.008031
503580110151004 FLOVENT 138.81 13651.008031
503580110168 503580110168001 GUAIFENESIN 9.07 13651.008031
503580110168002 GUAIFENESIN 9.07 13651.008031
503580110168003 GUAIFENESIN 9.07 13651.008031
503580110168004 GUAIFENESIN 9.07 13651.008031
HC-085I 14:42 Monday, September 18, 2006 13
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-085A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
503720160032 503720160032001 BRONCHO SALINE 6.79 18405.939356
503720160032002 BRONCHO SALINE 6.79 18405.939356
503720160032003 BRONCHO SALINE 6.79 18405.939356
503720160107 503720160107001 BRONCHO SALINE 6.79 18405.939356
503720160107002 BRONCHO SALINE 6.79 18405.939356
503720160107003 BRONCHO SALINE 6.79 18405.939356
503720160107004 BRONCHO SALINE 6.79 18405.939356
503720160107005 BRONCHO SALINE 6.79 18405.939356
503720160114 503720160114001 ALBUTEROL 10.38 18405.939356
503720160114002 ALBUTEROL 10.38 18405.939356
503720160114003 ALBUTEROL 10.38 18405.939356
503720160114004 ALBUTEROL 10.38 18405.939356
503720160114005 ALBUTEROL 10.38 18405.939356
503720160114006 ALBUTEROL 10.38 18405.939356
503720160190 503720160190001 BRONCHO SALINE 6.79 18405.939356
503720160190002 BRONCHO SALINE 6.79 18405.939356
503720160190003 BRONCHO SALINE 6.79 18405.939356
504010100228 504010100228001 ADVAIR 23.04 8758.376893
504010100228002 ADVAIR 23.04 8758.376893
504010100228003 ADVAIR 23.04 8758.376893
504200240039 504200240039001 SINGULAIR 108.03 4410.770983
504200240053 504200240053001 SINGULAIR 108.03 4410.770983
504230270109 504230270109001 ADVAIR DISKUS 250/50 163.41 13933.778795
504230270109002 ADVAIR DISKUS 250/50 163.41 13933.778795
504480460114 504480460114001 ORAPRED 11.53 23796.692200
504480460121 504480460121001 FLOVENT 41.02 23796.692200
504480460121002 FLOVENT 58.72 23796.692200
504480460265 504480460265001 FLOVENT 43.72 23796.692200
504480460265002 FLOVENT 43.72 23796.692200
504480460272 504480460272001 NASACORT AQ 31.76 23796.692200
504480460272002 NASACORT AQ 35.35 23796.692200
504480460354 504480460354001 PREDNISONE 3.46 23796.692200
504480460378 504480460378001 FLOVENT 41.02 23796.692200
504480460392 504480460392001 ALBUTEROL 11.43 23796.692200
HC-085I 14:42 Monday, September 18, 2006 14
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-085A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
504520190029 504520190029001 ALBUTEROL 29.79 4720.030822
504580270035 504580270035001 Z-PAK 45.00 6698.424396
504580270042 504580270042001 CHOLESTYRAMINE 5.00 6698.424396
504580270059 504580270059001 ADVAIR 23.04 6698.424396
504580270059002 ADVAIR 23.04 6698.424396
504580270059003 ADVAIR 23.04 6698.424396
504580270066 504580270066001 ZYRTEC 59.67 6698.424396
504580270066002 ZYRTEC 59.67 6698.424396
504580270066003 ZYRTEC 59.67 6698.424396
504580270097 504580270097001 ZYRTEC 158.85 6698.424396
504580270097002 ZYRTEC 158.85 6698.424396
504580270097003 ZYRTEC 158.85 6698.424396
504580270097004 ZYRTEC 158.85 6698.424396
504580270097005 ZYRTEC 158.85 6698.424396
504580270100 504580270100001 ADVAIR 23.04 6698.424396
504580270100002 ADVAIR 23.04 6698.424396
504580270100003 ADVAIR 23.04 6698.424396
504580270100004 ADVAIR 23.04 6698.424396
504580270100005 ADVAIR 23.04 6698.424396
504580270117 504580270117001 RHINOCORT AQUA 74.84 6698.424396
504580270117002 RHINOCORT AQUA 74.84 6698.424396
504580270117003 RHINOCORT AQUA 74.84 6698.424396
504580270117004 RHINOCORT AQUA 74.84 6698.424396
504580270117005 RHINOCORT AQUA 74.84 6698.424396
504580270186 504580270186001 ADVAIR 2.72 6698.424396
504580270186002 ADVAIR 2.72 6698.424396
504580270186003 ADVAIR 2.72 6698.424396
504580270220 504580270220001 ALBUTEROL 10.14 6698.424396
504600560026 504600560026001 AVALIDE 54.55 4836.513225
504600560095 504600560095001 AVALIDE 179.22 4836.513225
504720230077 504720230077001 ADVAIR 100/50 112.73 21497.051971
504720230077002 ADVAIR 100/50 112.73 21497.051971
504720230077003 ADVAIR 100/50 112.73 21497.051971
504720230084 504720230084001 ATROVENT 57.94 21497.051971
HC-085I 14:42 Monday, September 18, 2006 15
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
The MEANS Procedure
Analysis Variable : RXXP04X SUM OF PAYMENTS RXSF04X-RXOU04X(IMPUTED)
N Sum
---------------------
10670 729496.51
---------------------
HC-085I 14:42 Monday, September 18, 2006 16
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP04X SUM OF PAYMENTS RXSF04X-RXOU04X(IMPUTED)
N Sum
---------------------
10670 6400164170
---------------------
1 The SAS System 14:44 Monday, September 18, 2006
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX09.
NOTE: SAS initialization used:
real time 2.10 seconds
cpu time 0.39 seconds
NOTE: AUTOEXEC processing beginning; file is C:\progra~1\sasins~1\sas\v8\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1
2 OPTIONS LS=132 PS=59;
3
4 TITLE1 "HC-085I";
5 TITLE2 "Sample SAS Job for Example C";
6
7 LIBNAME IN "C:\DATA";
NOTE: Libref IN was successfully assigned as follows:
Engine: V8
Physical Name: C:\DATA
8
9 *************************************************************************************
10 * Calculate the expenditures for medical visits associated with asthma.
11 *************************************************************************************;
12 PROC FORMAT;
13 VALUE EVENTYPE
14 1 = "1 MVIS"
15 2 = "2 OPAT"
16 3 = "3 EROM"
17 4 = "4 STAZ"
18 5 = "5 DVIS"
19 6 = "6 OMED"
20 7 = "7 HVIS"
21 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
22 RUN;
NOTE: PROCEDURE FORMAT used:
real time 0.10 seconds
cpu time 0.01 seconds
23
24 *-----------------------------------------------------------------------------------
2 The SAS System 14:44 Monday, September 18, 2006
25 * Get conditions records coded as asthma.
26 *-----------------------------------------------------------------------------------;
27 DATA ASCONDS;
28 SET IN.H87 (KEEP=CONDIDX CCCODEX);
29 IF CCCODEX="128";
30 RUN;
NOTE: There were 106738 observations read from the data set IN.H87.
NOTE: The data set WORK.ASCONDS has 1835 observations and 2 variables.
NOTE: DATA statement used:
real time 1.43 seconds
cpu time 0.17 seconds
31
32 *------------------------------------------------------------------------------------
33 * Get the events linked to each of the asthma condition records.
34 *------------------------------------------------------------------------------------;
35 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 1835 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1835 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.04 seconds
cpu time 0.00 seconds
36
37 proc print data=asconds (obs=50);
38 title3 "sample print of work.asconds - sorted by condidx";
39 title4 "COND (HC-087) records where cccodex=128";
40 run;
NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used:
real time 0.21 seconds
cpu time 0.00 seconds
41
42 PROC SORT DATA=IN.H85IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 348119 observations read from the data set IN.H85IF1.
NOTE: The data set WORK.CLNK has 348119 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 21.67 seconds
cpu time 2.54 seconds
43
44 DATA ASCLNKS;
45 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
46 ASCONDS(IN=INASCOND KEEP=CONDIDX);
47 BY CONDIDX;
48 IF INCLNK & INASCOND;
49 RUN;
3 The SAS System 14:44 Monday, September 18, 2006
NOTE: There were 348119 observations read from the data set WORK.CLNK.
NOTE: There were 1835 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7244 observations and 3 variables.
NOTE: DATA statement used:
real time 2.82 seconds
cpu time 0.40 seconds
50
51 proc print data=asclnks (obs=75);
52 by condidx;
53 id condidx;
54 format eventype eventype.;
55 title3 "sample print of work.asclnks - sorted by condidx";
56 title4 "events linked to asthma condition records";
57 run;
NOTE: There were 75 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used:
real time 0.32 seconds
cpu time 0.04 seconds
58
59 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7244 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7244 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.01 seconds
cpu time 0.01 seconds
60
61 proc print data=asclnks (obs=50);
62 format eventype eventype.;
63 title3 "sample print of work.asclnks - sorted by evntidx";
64 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used:
real time 0.06 seconds
cpu time 0.00 seconds
65
66 DATA ASCLNKS;
67 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
68 BY EVNTIDX;
69 IF FIRST.EVNTIDX;
70 RUN;
NOTE: There were 7244 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7225 observations and 2 variables.
4 The SAS System 14:44 Monday, September 18, 2006
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.01 seconds
71
72 proc print data=asclnks (obs=50);
73 format eventype eventype.;
74 title3 "sample print of unique evntidxs from work.asclnks";
75 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used:
real time 0.06 seconds
cpu time 0.00 seconds
76
77 *--------------------------------------------------------------------------------------------
78 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
79 *--------------------------------------------------------------------------------------------;
80 DATA MVIS;
81 SET IN.H85G (KEEP=EVNTIDX PERWT04F SEETLKPV OBXP04X);
82 IF PERWT04F > 0 & SEETLKPV NE 2;
83 RUN;
NOTE: There were 157536 observations read from the data set IN.H85G.
NOTE: The data set WORK.MVIS has 152603 observations and 4 variables.
NOTE: DATA statement used:
real time 7.53 seconds
cpu time 0.71 seconds
84
85 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 152603 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 152603 observations and 4 variables.
NOTE: PROCEDURE SORT used:
real time 4.28 seconds
cpu time 0.87 seconds
86
87 *-------------------------------------------------------------------------------------
88 * Identify MVIS events which were for asthma.
89 *-------------------------------------------------------------------------------------;
90 DATA ASMVIS;
91 MERGE ASCLNKS (IN=INASCLNK)
92 MVIS (IN=INMVIS);
93 BY EVNTIDX;
94 IF INASCLNK & INMVIS;
95 RUN;
NOTE: There were 7225 observations read from the data set WORK.ASCLNKS.
NOTE: There were 152603 observations read from the data set WORK.MVIS.
5 The SAS System 14:44 Monday, September 18, 2006
NOTE: The data set WORK.ASMVIS has 2165 observations and 5 variables.
NOTE: DATA statement used:
real time 1.59 seconds
cpu time 0.18 seconds
96
97 proc print data=asmvis (obs=50);
98 format eventype eventype.;
99 title3 "sample print of work.asmvis";
100 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-085G) events";
101 run;
NOTE: There were 50 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.00 seconds
102
103 PROC MEANS DATA=ASMVIS N SUM;
104 VAR OBXP04X;
105 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
106 RUN;
NOTE: There were 2165 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 7.
NOTE: PROCEDURE MEANS used:
real time 0.09 seconds
cpu time 0.01 seconds
107
108 PROC MEANS DATA=ASMVIS N SUM;
109 VAR OBXP04X;
110 WEIGHT PERWT04F;
111 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
112 TITLE5 "Weighted";
113 RUN;
NOTE: There were 2165 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 8.
NOTE: PROCEDURE MEANS used:
real time 0.01 seconds
cpu time 0.01 seconds
114
115
116
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 42.90 seconds
cpu time 5.53 seconds
HC-085I 14:44 Monday, September 18, 2006 1
Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx
COND (HC-087) records where cccodex=128
Obs CCCODEX CONDIDX
1 128 500070130028
2 128 500070200033
3 128 500200110056
4 128 500360140018
5 128 500430190052
6 128 500460100016
7 128 500660410013
8 128 500680120023
9 128 500700150079
10 128 500950250018
11 128 500990170024
12 128 501090310018
13 128 501150120029
14 128 501160150036
15 128 501170360054
16 128 501290180058
17 128 501420340016
18 128 501690160041
19 128 501840550020
20 128 501840620013
21 128 501910540019
22 128 501970350043
23 128 502110120053
24 128 502620440014
25 128 502870280065
26 128 502900180021
27 128 503080270027
28 128 503100450013
29 128 503250380018
30 128 503370280017
31 128 503500310054
32 128 503580110010
33 128 503720160023
34 128 503730590022
35 128 504010100086
36 128 504200240023
37 128 504200480015
38 128 504230270053
39 128 504480460018
40 128 504520190016
41 128 504580270025
42 128 504580270075
43 128 504600560011
44 128 504720230091
45 128 504910450035
46 128 505160200037
47 128 505160500013
48 128 505160670034
49 128 505180190034
50 128 505280110061
HC-085I 14:44 Monday, September 18, 2006 2
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
500070130028 500070130256 8 PMED
500070130263 8 PMED
500070130410 8 PMED
500070130427 8 PMED
500070200033 500070200085 8 PMED
500070200092 8 PMED
500070200105 8 PMED
500200110056 500200110232 8 PMED
500200110636 8 PMED
500200111040 8 PMED
500360140018 500360140029 1 MVIS
500360140074 8 PMED
500360140252 8 PMED
500360140269 8 PMED
500360140276 8 PMED
500360140283 8 PMED
500360140290 8 PMED
500360140601 8 PMED
500360140618 8 PMED
500360140625 8 PMED
500430190052 500430190066 8 PMED
500460100016 500460100012 8 PMED
500660410013 500660410013 1 MVIS
500660410020 1 MVIS
500660410037 1 MVIS
500660410044 8 PMED
500660410051 8 PMED
500660410068 8 PMED
500660410082 8 PMED
500680120023 500680120011 1 MVIS
500680120035 8 PMED
500680120042 8 PMED
500680120059 8 PMED
500680120117 8 PMED
500680120124 8 PMED
500700150079 500700150393 8 PMED
500700150413 1 MVIS
500700150437 1 MVIS
500700150622 8 PMED
500700150660 8 PMED
HC-085I 14:44 Monday, September 18, 2006 3
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
500990170024 500990170063 8 PMED
500990170169 8 PMED
500990170176 8 PMED
500990170183 8 PMED
500990170272 8 PMED
501090310018 501090310018 1 MVIS
501090310025 1 MVIS
501090310032 1 MVIS
501090310049 1 MVIS
501090310056 1 MVIS
501090310063 1 MVIS
501090310070 1 MVIS
501090310087 1 MVIS
501090310176 8 PMED
501090310183 8 PMED
501150120029 501150120037 8 PMED
501150120119 1 MVIS
501150120126 1 MVIS
501150120133 1 MVIS
501150120140 1 MVIS
501150120157 1 MVIS
501150120164 8 PMED
501160150036 501160150024 1 MVIS
501160150031 1 MVIS
501160150048 8 PMED
501160150079 8 PMED
501160150144 1 MVIS
501160150168 8 PMED
501160150459 8 PMED
501160150466 8 PMED
501170360054 501170360156 1 MVIS
501170360170 8 PMED
501170360214 8 PMED
501170360221 8 PMED
501170360238 8 PMED
HC-085I 14:44 Monday, September 18, 2006 4
Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx
Obs EVNTIDX EVENTYPE CONDIDX
1 500070130256 8 PMED 500070130028
2 500070130263 8 PMED 500070130028
3 500070130410 8 PMED 500070130028
4 500070130427 8 PMED 500070130028
5 500070200085 8 PMED 500070200033
6 500070200092 8 PMED 500070200033
7 500070200105 8 PMED 500070200033
8 500200110232 8 PMED 500200110056
9 500200110636 8 PMED 500200110056
10 500200111040 8 PMED 500200110056
11 500360140029 1 MVIS 500360140018
12 500360140074 8 PMED 500360140018
13 500360140252 8 PMED 500360140018
14 500360140269 8 PMED 500360140018
15 500360140276 8 PMED 500360140018
16 500360140283 8 PMED 500360140018
17 500360140290 8 PMED 500360140018
18 500360140601 8 PMED 500360140018
19 500360140618 8 PMED 500360140018
20 500360140625 8 PMED 500360140018
21 500430190066 8 PMED 500430190052
22 500460100012 8 PMED 500460100016
23 500660410013 1 MVIS 500660410013
24 500660410020 1 MVIS 500660410013
25 500660410037 1 MVIS 500660410013
26 500660410044 8 PMED 500660410013
27 500660410051 8 PMED 500660410013
28 500660410068 8 PMED 500660410013
29 500660410082 8 PMED 500660410013
30 500680120011 1 MVIS 500680120023
31 500680120035 8 PMED 500680120023
32 500680120042 8 PMED 500680120023
33 500680120059 8 PMED 500680120023
34 500680120117 8 PMED 500680120023
35 500680120124 8 PMED 500680120023
36 500700150393 8 PMED 500700150079
37 500700150413 1 MVIS 500700150079
38 500700150437 1 MVIS 500700150079
39 500700150622 8 PMED 500700150079
40 500700150660 8 PMED 500700150079
41 500990170063 8 PMED 500990170024
42 500990170169 8 PMED 500990170024
43 500990170176 8 PMED 500990170024
44 500990170183 8 PMED 500990170024
45 500990170272 8 PMED 500990170024
46 501090310018 1 MVIS 501090310018
47 501090310025 1 MVIS 501090310018
48 501090310032 1 MVIS 501090310018
49 501090310049 1 MVIS 501090310018
50 501090310056 1 MVIS 501090310018
HC-085I 14:44 Monday, September 18, 2006 5
Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 500070130256 8 PMED
2 500070130263 8 PMED
3 500070130410 8 PMED
4 500070130427 8 PMED
5 500070200085 8 PMED
6 500070200092 8 PMED
7 500070200105 8 PMED
8 500200110232 8 PMED
9 500200110636 8 PMED
10 500200111040 8 PMED
11 500360140029 1 MVIS
12 500360140074 8 PMED
13 500360140252 8 PMED
14 500360140269 8 PMED
15 500360140276 8 PMED
16 500360140283 8 PMED
17 500360140290 8 PMED
18 500360140601 8 PMED
19 500360140618 8 PMED
20 500360140625 8 PMED
21 500430190066 8 PMED
22 500460100012 8 PMED
23 500660410013 1 MVIS
24 500660410020 1 MVIS
25 500660410037 1 MVIS
26 500660410044 8 PMED
27 500660410051 8 PMED
28 500660410068 8 PMED
29 500660410082 8 PMED
30 500680120011 1 MVIS
31 500680120035 8 PMED
32 500680120042 8 PMED
33 500680120059 8 PMED
34 500680120117 8 PMED
35 500680120124 8 PMED
36 500700150393 8 PMED
37 500700150413 1 MVIS
38 500700150437 1 MVIS
39 500700150622 8 PMED
40 500700150660 8 PMED
41 500990170063 8 PMED
42 500990170169 8 PMED
43 500990170176 8 PMED
44 500990170183 8 PMED
45 500990170272 8 PMED
46 501090310018 1 MVIS
47 501090310025 1 MVIS
48 501090310032 1 MVIS
49 501090310049 1 MVIS
50 501090310056 1 MVIS
HC-085I 14:44 Monday, September 18, 2006 6
Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-085G) events
Obs EVNTIDX EVENTYPE SEETLKPV OBXP04X PERWT04F
1 500360140029 1 MVIS 1 168.62 18145.55
2 500660410013 1 MVIS 1 94.73 1746.78
3 500660410020 1 MVIS 1 49.53 1746.78
4 500660410037 1 MVIS 1 183.00 1746.78
5 500680120011 1 MVIS 1 103.20 10088.58
6 500700150413 1 MVIS 1 156.44 13075.04
7 500700150437 1 MVIS 1 128.72 13075.04
8 501090310018 1 MVIS 1 110.00 12809.90
9 501090310025 1 MVIS 1 89.91 12809.90
10 501090310032 1 MVIS 1 113.00 12809.90
11 501090310049 1 MVIS 1 86.24 12809.90
12 501090310056 1 MVIS 1 11.07 12809.90
13 501090310063 1 MVIS 1 30.00 12809.90
14 501090310070 1 MVIS 1 121.00 12809.90
15 501090310087 1 MVIS 1 107.68 12809.90
16 501150120119 1 MVIS 1 13.33 5655.21
17 501150120126 1 MVIS 1 13.33 5655.21
18 501150120133 1 MVIS 1 13.33 5655.21
19 501150120140 1 MVIS 1 31.11 5655.21
20 501150120157 1 MVIS 1 20.00 5655.21
21 501160150024 1 MVIS 1 58.00 16315.93
22 501160150031 1 MVIS 1 58.00 16315.93
23 501160150144 1 MVIS 1 58.00 16315.93
24 501170360156 1 MVIS 1 61.16 5454.07
25 501290180101 1 MVIS 1 14.00 8032.83
26 501290180252 1 MVIS 1 61.97 8032.83
27 501420340022 1 MVIS 1 10.00 11749.26
28 501420340039 1 MVIS 1 10.00 11749.26
29 501420340046 1 MVIS 1 69.00 11749.26
30 501420340053 1 MVIS 1 264.00 11749.26
31 501420340060 1 MVIS 1 10.00 11749.26
32 501420340077 1 MVIS 1 10.00 11749.26
33 501420340084 1 MVIS 1 10.00 11749.26
34 501420340091 1 MVIS 1 10.00 11749.26
35 501420340104 1 MVIS 1 10.00 11749.26
36 501420340111 1 MVIS 1 10.00 11749.26
37 501420340128 1 MVIS 1 10.00 11749.26
38 501420340135 1 MVIS 1 264.00 11749.26
39 501420340142 1 MVIS 1 10.00 11749.26
40 501420340159 1 MVIS 1 10.00 11749.26
41 501420340166 1 MVIS 1 10.00 11749.26
42 501420340173 1 MVIS 1 10.00 11749.26
43 501420340180 1 MVIS 1 10.00 11749.26
44 501420340197 1 MVIS 1 126.11 11749.26
45 501420340231 1 MVIS 1 69.49 11749.26
46 501420340248 1 MVIS 1 155.60 11749.26
47 501420340255 1 MVIS 1 155.60 11749.26
48 501910540017 1 MVIS 1 103.95 2697.07
49 501970350012 1 MVIS 1 0.00 2370.74
50 503250380022 1 MVIS 1 26.00 4859.54
HC-085I 14:44 Monday, September 18, 2006 7
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
The MEANS Procedure
Analysis Variable : OBXP04X SUM OF OBSF04X - OBOT04X (IMPUTED)
N Sum
--------------------
2165 179729.42
--------------------
HC-085I 14:44 Monday, September 18, 2006 8
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : OBXP04X SUM OF OBSF04X - OBOT04X (IMPUTED)
N Sum
--------------------
2165 1518235749
--------------------
1 The SAS System 14:45 Monday, September 18, 2006
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX09.
NOTE: SAS initialization used:
real time 2.17 seconds
cpu time 0.38 seconds
NOTE: AUTOEXEC processing beginning; file is C:\progra~1\sasins~1\sas\v8\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1
2 OPTIONS LS=132 PS=59;
3
4 TITLE1 "HC-085I";
5 TITLE2 "Sample SAS Job for Example D";
6
7 LIBNAME IN "C:\DATA";
NOTE: Libref IN was successfully assigned as follows:
Engine: V8
Physical Name: C:\DATA
8
9 **************************************************************************************
10 * Calculate the expenditures for prescribed medicines associated
11 * with insulin reported by the household as an other medical expense.
12 **************************************************************************************;
13
14 PROC FORMAT;
15 VALUE EVENTYPE
16 1 = "1 MVIS"
17 2 = "2 OPAT"
18 3 = "3 EROM"
19 4 = "4 STAZ"
20 5 = "5 DVIS"
21 6 = "6 OMED"
22 7 = "7 HVIS"
23 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
24
25 VALUE OMTYPE
26 -9 = "-9 NOT ASCERTAINED"
27 -8 = "-8 DK"
28 -7 = "-7 REFUSED"
29 -1 = "-1 INAPPLICABLE"
30 1 = "1 GLASSES OR CONTACT LENSES"
2 The SAS System 14:45 Monday, September 18, 2006
31 2 = "2 INSULIN"
32 3 = "3 DIABETIC EQUIPMENT/SUPPLIES"
33 4 = "4 AMBULANCE SERVICES"
34 5 = "5 ORTHOPEDIC ITEMS"
35 6 = "6 HEARING DEVICES"
36 7 = "7 PROSTHESIS"
37 8 = "8 BATHROOM AIDS"
38 9 = "9 MEDICAL EQUIPMENT"
39 10 = "10 DISPOSABLE SUPPLIES"
40 11 = "11 ALTERATIONS/MODIFICATIONS"
41 91 = "91 OTHER"
42 ;
NOTE: Format OMTYPE has been output.
43 RUN;
NOTE: PROCEDURE FORMAT used:
real time 0.10 seconds
cpu time 0.01 seconds
44
45 *-------------------------------------------------------------------------------------
46 * Get other medical records for insulin for persons with positive weights.
47 *-------------------------------------------------------------------------------------;
48
49 DATA OMED;
50 SET IN.H85C (KEEP=EVNTIDX PERWT04F OMTYPEX);
51 IF PERWT04F > 0 & OMTYPEX = 2;
52 RUN;
NOTE: There were 9580 observations read from the data set IN.H85C.
NOTE: The data set WORK.OMED has 558 observations and 3 variables.
NOTE: DATA statement used:
real time 0.43 seconds
cpu time 0.01 seconds
53
54 PROC SORT DATA=OMED; BY EVNTIDX; RUN;
NOTE: There were 558 observations read from the data set WORK.OMED.
NOTE: The data set WORK.OMED has 558 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.04 seconds
cpu time 0.01 seconds
55
56 proc print data=omed (obs=100);
57 var evntidx OMTYPEX PERWT04F;
58 format OMTYPEX omtype.;
59 title3 "sample print of OMED (HC-085C) records where OMTYPEX=2";
60 run;
NOTE: There were 100 observations read from the data set WORK.OMED.
NOTE: The PROCEDURE PRINT printed pages 1-2.
NOTE: PROCEDURE PRINT used:
3 The SAS System 14:45 Monday, September 18, 2006
real time 0.32 seconds
cpu time 0.06 seconds
61
62 *-------------------------------------------------------------------------------------
63 * Get PMED IDs linked to the OMED events which were for insulin.
64 *-------------------------------------------------------------------------------------;
65
66 PROC SORT DATA=IN.H85IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: There were 62663 observations read from the data set IN.H85IF2.
NOTE: The data set WORK.RXLK has 62663 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 0.62 seconds
cpu time 0.60 seconds
67
68 proc print data=rxlk (obs=150);
69 by evntidx;
70 id evntidx;
71 var linkidx eventype;
72 format eventype eventype.;
73 title3 "sample print of Rx+event link file records (HC-85IF2) - sorted by evntidx";
74 run;
NOTE: There were 150 observations read from the data set WORK.RXLK.
NOTE: The PROCEDURE PRINT printed pages 3-7.
NOTE: PROCEDURE PRINT used:
real time 0.06 seconds
cpu time 0.01 seconds
75
76 data omedrxlk;
77 set rxlk (where=(eventype=6));
78 run;
NOTE: There were 1958 observations read from the data set WORK.RXLK.
WHERE eventype=6;
NOTE: The data set WORK.OMEDRXLK has 1958 observations and 5 variables.
NOTE: DATA statement used:
real time 0.03 seconds
cpu time 0.03 seconds
79 proc print data=omedrxlk (obs=120);
80 by evntidx;
81 id evntidx;
82 var linkidx eventype;
83 format eventype eventype.;
84 title3 "sample print of work.omedrxlk - sorted by evntidx";
85 title4 "Rx+event link file records (HC-85IF2) where eventype=6 (omed)";
86 run;
NOTE: There were 120 observations read from the data set WORK.OMEDRXLK.
4 The SAS System 14:45 Monday, September 18, 2006
NOTE: The PROCEDURE PRINT printed pages 8-12.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.00 seconds
87
88 DATA PMEDIDS;
89 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
90 OMED (IN=INOMED KEEP=EVNTIDX);
91 BY EVNTIDX;
92 IF INRXLK & INOMED;
93 RUN;
NOTE: There were 62663 observations read from the data set WORK.RXLK.
NOTE: There were 558 observations read from the data set WORK.OMED.
NOTE: The data set WORK.PMEDIDS has 524 observations and 3 variables.
NOTE: DATA statement used:
real time 0.07 seconds
cpu time 0.07 seconds
94
95 proc print data=pmedids (obs=50);
96 by evntidx;
97 id evntidx;
98 format eventype eventype.;
99 title3 "sample print of work.pmedids - sorted by evntidx";
100 title4 "work.rxlk records for omed events for insulin";
101 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed pages 13-14.
NOTE: PROCEDURE PRINT used:
real time 0.03 seconds
cpu time 0.01 seconds
102
103 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 524 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 524 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.00 seconds
cpu time 0.00 seconds
104
105 proc print data=pmedids (obs=50);
106 format eventype eventype.;
107 title3 "sample print of work.pmedids - sorted by linkidx";
108 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: PROCEDURE PRINT used:
5 The SAS System 14:45 Monday, September 18, 2006
real time 0.01 seconds
cpu time 0.00 seconds
109
110 DATA PMEDIDS;
111 SET PMEDIDS (KEEP=LINKIDX);
112 BY LINKIDX;
113 IF FIRST.LINKIDX;
114 KEEP LINKIDX;
115 RUN;
NOTE: There were 524 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 524 observations and 1 variables.
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.00 seconds
116
117 proc print data=pmedids (obs=50);
118 title3 "sample print of unique linkidxs in work.pmedids";
119 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 16.
NOTE: PROCEDURE PRINT used:
real time 0.00 seconds
cpu time 0.00 seconds
120
121
122 *------------------------------------------------------------------------------------
123 * Get PMED records for OMED event which were for insulin.
124 *------------------------------------------------------------------------------------;
125 PROC SORT DATA=IN.H85A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 317065 observations read from the data set IN.H85A.
NOTE: The data set WORK.PMED has 317065 observations and 13 variables.
NOTE: PROCEDURE SORT used:
real time 57.95 seconds
cpu time 4.78 seconds
126
127 DATA OMPMEDS;
128 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP04X PERWT04F RXNAME)
129 PMEDIDS (IN=A);
130 BY LINKIDX;
131 IF A & PERWT04F>0;
132 RUN;
NOTE: There were 317065 observations read from the data set WORK.PMED.
NOTE: There were 524 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.OMPMEDS has 1778 observations and 5 variables.
NOTE: DATA statement used:
6 The SAS System 14:45 Monday, September 18, 2006
real time 1.29 seconds
cpu time 0.56 seconds
133
134 proc print data=ompmeds (obs=200);
135 by linkidx;
136 id linkidx;
137 var rxrecidx rxname RXXP04X PERWT04F;
138 title3 "sample print of work.pmeds";
139 title4 "PMED (HC-085A) records for unique linkidxs in work.pmedids";
140 run;
NOTE: There were 200 observations read from the data set WORK.OMPMEDS.
NOTE: The PROCEDURE PRINT printed pages 17-22.
NOTE: PROCEDURE PRINT used:
real time 0.00 seconds
cpu time 0.00 seconds
141
142 PROC MEANS DATA=OMPMEDS N SUM;
143 VAR RXXP04X;
144 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
145 RUN;
NOTE: There were 1778 observations read from the data set WORK.OMPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used:
real time 0.09 seconds
cpu time 0.01 seconds
146
147 PROC MEANS DATA=OMPMEDS N SUM;
148 VAR RXXP04X;
149 WEIGHT PERWT04F;
150 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
151 TITLE5 "Weighted";
152 RUN;
NOTE: There were 1778 observations read from the data set WORK.OMPMEDS.
NOTE: The PROCEDURE MEANS printed page 24.
NOTE: PROCEDURE MEANS used:
real time 0.03 seconds
cpu time 0.01 seconds
153
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 1:03.75
cpu time 6.71 seconds
HC-085I 14:45 Monday, September 18, 2006 1
Sample SAS Job for Example D
sample print of OMED (HC-085C) records where OMTYPEX=2
Obs EVNTIDX OMTYPEX PERWT04F
1 500700150300 2 INSULIN 13075.04
2 501080110161 2 INSULIN 18430.40
3 501310130073 2 INSULIN 5163.42
4 501870180072 2 INSULIN 3468.33
5 501970110238 2 INSULIN 2187.34
6 501970110454 2 INSULIN 2187.34
7 502530110012 2 INSULIN 3273.35
8 502690200024 2 INSULIN 10510.90
9 502690200113 2 INSULIN 10510.90
10 502690200233 2 INSULIN 10510.90
11 503170120154 2 INSULIN 13931.14
12 503170121013 2 INSULIN 13931.14
13 503410180024 2 INSULIN 8126.48
14 503410180586 2 INSULIN 8126.48
15 503660150374 2 INSULIN 23221.14
16 503660150398 2 INSULIN 23221.14
17 503990290017 2 INSULIN 4825.86
18 504400260201 2 INSULIN 4159.47
19 504610440051 2 INSULIN 3598.28
20 504980110161 2 INSULIN 11916.39
21 505580280033 2 INSULIN 4117.42
22 506420190015 2 INSULIN 4223.47
23 506430140144 2 INSULIN 3912.15
24 506430140548 2 INSULIN 3912.15
25 506510110154 2 INSULIN 4754.90
26 506510110483 2 INSULIN 4754.90
27 506510110750 2 INSULIN 4754.90
28 507030240050 2 INSULIN 2804.13
29 508170140168 2 INSULIN 26666.52
30 508190110291 2 INSULIN 5580.12
31 508190110626 2 INSULIN 5580.12
32 508340150046 2 INSULIN 11959.31
33 508340150128 2 INSULIN 11959.31
34 509560340032 2 INSULIN 9519.80
35 509630150030 2 INSULIN 14901.34
36 509900180151 2 INSULIN 1461.32
37 509900180264 2 INSULIN 1461.32
38 510300200053 2 INSULIN 8222.21
39 510300200337 2 INSULIN 8222.21
40 510300200755 2 INSULIN 8222.21
41 510750220064 2 INSULIN 5016.14
42 510750220235 2 INSULIN 5016.14
43 512580110025 2 INSULIN 19642.33
44 513230190049 2 INSULIN 14134.78
45 513230190087 2 INSULIN 14134.78
46 513410200067 2 INSULIN 11319.22
47 513410200283 2 INSULIN 11319.22
48 513410201111 2 INSULIN 11319.22
49 514550150013 2 INSULIN 3681.44
50 514770130079 2 INSULIN 6216.68
51 515660240064 2 INSULIN 9037.21
52 515660240266 2 INSULIN 9037.21
53 516110150030 2 INSULIN 1670.71
HC-085I 14:45 Monday, September 18, 2006 2
Sample SAS Job for Example D
sample print of OMED (HC-085C) records where OMTYPEX=2
Obs EVNTIDX OMTYPEX PERWT04F
54 516460240056 2 INSULIN 4718.72
55 516460240114 2 INSULIN 4718.72
56 516710230163 2 INSULIN 11757.18
57 517300230188 2 INSULIN 13334.03
58 518070470242 2 INSULIN 5963.44
59 518860190081 2 INSULIN 21968.89
60 518860190252 2 INSULIN 21968.89
61 518860190889 2 INSULIN 21968.89
62 519610160020 2 INSULIN 9370.18
63 519610160102 2 INSULIN 9370.18
64 520060210199 2 INSULIN 6039.12
65 520800210446 2 INSULIN 10524.68
66 521130140083 2 INSULIN 8213.66
67 521350120033 2 INSULIN 6483.53
68 521350120280 2 INSULIN 6483.53
69 521710240102 2 INSULIN 5918.06
70 521940180111 2 INSULIN 5456.91
71 521940180611 2 INSULIN 5456.91
72 522090160029 2 INSULIN 9805.65
73 522090160207 2 INSULIN 9805.65
74 522090160365 2 INSULIN 9805.65
75 522440190135 2 INSULIN 9234.98
76 522460130029 2 INSULIN 4023.71
77 522720240030 2 INSULIN 12938.34
78 522720240369 2 INSULIN 12938.34
79 522720240496 2 INSULIN 12938.34
80 523100200036 2 INSULIN 12375.90
81 523370220762 2 INSULIN 19824.93
82 523820190032 2 INSULIN 10314.33
83 524020240182 2 INSULIN 11081.75
84 524130150015 2 INSULIN 7017.68
85 524130150053 2 INSULIN 7017.68
86 524390120131 2 INSULIN 7209.98
87 524390120237 2 INSULIN 7209.98
88 524680260105 2 INSULIN 10436.37
89 524680260352 2 INSULIN 10436.37
90 524680260578 2 INSULIN 10436.37
91 525360230067 2 INSULIN 4338.87
92 527320181514 2 INSULIN 9054.18
93 527370190026 2 INSULIN 8038.61
94 527660110033 2 INSULIN 13661.81
95 527660110235 2 INSULIN 13661.81
96 527660110475 2 INSULIN 13661.81
97 528050260196 2 INSULIN 1791.34
98 529470140127 2 INSULIN 10531.71
99 529470140374 2 INSULIN 10531.71
100 530840140130 2 INSULIN 4915.79
HC-085I 14:45 Monday, September 18, 2006 3
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-85IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
500020110010 500020110130 1 MVIS
500020110027 500020110147 1 MVIS
500020110058 500020110154 1 MVIS
500020110065 500020110147 1 MVIS
500020150016 500020150023 1 MVIS
500020150030 1 MVIS
500020150054 500020150143 1 MVIS
500020150150 1 MVIS
500020150167 1 MVIS
500020150085 500020150174 1 MVIS
500020150181 1 MVIS
500020150105 500020150181 1 MVIS
500020150129 500020150174 1 MVIS
500020150198 1 MVIS
500020150201 1 MVIS
500020150225 500020150263 1 MVIS
500020150270 1 MVIS
500020150287 1 MVIS
500020150256 500020150307 4 STAZ
500020150314 4 STAZ
500020150294 500020150321 1 MVIS
500020390016 500020390054 1 MVIS
500020390023 500020390061 1 MVIS
500020390078 1 MVIS
500020390085 1 MVIS
500020390129 500020390150 1 MVIS
500020390167 1 MVIS
500020390143 500020390167 1 MVIS
500020390201 500020390256 1 MVIS
500020390218 500020390256 1 MVIS
500030180016 500030180078 1 MVIS
HC-085I 14:45 Monday, September 18, 2006 4
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-85IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
500030180023 500030180085 1 MVIS
500030180061 500030180092 1 MVIS
500030180174 500030180198 1 MVIS
500030180181 500030180201 1 MVIS
500030180287 500030180307 1 MVIS
500030250078 500030250085 1 MVIS
500030250092 1 MVIS
500050180027 500050180034 1 MVIS
500050180041 1 MVIS
500060110012 500060110098 1 MVIS
500060110101 1 MVIS
500060110118 1 MVIS
500060110125 1 MVIS
500060110067 500060110132 1 MVIS
500060110245 500060110416 1 MVIS
500070130218 500070130232 1 MVIS
500070130249 1 MVIS
500070200016 500070200085 1 MVIS
500070200092 1 MVIS
500070200105 1 MVIS
500070200078 500070200112 1 MVIS
500080130048 500080130106 1 MVIS
500080130055 500080130113 1 MVIS
500080130079 500080130120 5 DVIS
500080130137 5 DVIS
500100260034 500100260161 1 MVIS
500100260178 1 MVIS
500100260185 1 MVIS
500100260192 1 MVIS
500100260205 1 MVIS
500100260212 1 MVIS
500100260229 1 MVIS
500100260236 1 MVIS
500100260243 1 MVIS
HC-085I 14:45 Monday, September 18, 2006 5
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-85IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
500100260034 500100260250 1 MVIS
500110200020 500110200037 3 EROM
500120260111 500120260166 5 DVIS
500130170015 500130170060 5 DVIS
500130170022 500130170060 5 DVIS
500130170077 500130170128 5 DVIS
500130170084 500130170128 5 DVIS
500130170091 500130170128 5 DVIS
500130170111 500130170135 2 OPAT
500130170142 500130170180 5 DVIS
500130170159 500130170180 5 DVIS
500130170173 500130170197 1 MVIS
500130240039 500130240046 1 MVIS
500130240060 500130240084 1 MVIS
500130240077 500130240091 1 MVIS
500140150029 500140150245 1 MVIS
500140150194 500140150252 1 MVIS
500140220012 500140220043 1 MVIS
500140220067 500140220098 1 MVIS
500150220024 500150220048 1 MVIS
500150530024 500150530048 4 STAZ
500190190015 500190190046 1 MVIS
500190190053 1 MVIS
500190190060 1 MVIS
500190190022 500190190053 3 EROM
500190190077 3 EROM
500190190084 3 EROM
500190190091 3 EROM
HC-085I 14:45 Monday, September 18, 2006 6
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-85IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
500190190039 500190190046 2 OPAT
500190190053 2 OPAT
500190190084 2 OPAT
500190190104 500190190111 1 MVIS
500190190128 1 MVIS
500190260015 500190260022 1 MVIS
500190260053 500190260060 1 MVIS
500190260077 1 MVIS
500190260084 1 MVIS
500190330022 500190330039 1 MVIS
500190400022 500190400039 1 MVIS
500190400046 1 MVIS
500190590020 500190590044 1 MVIS
500190590037 500190590051 1 MVIS
500190590068 1 MVIS
500190590075 1 MVIS
500190590082 500190590126 1 MVIS
500190590133 1 MVIS
500190590140 1 MVIS
500190590099 500190590140 1 MVIS
500200110085 500200110136 4 STAZ
500200110294 500200110530 4 STAZ
500240160045 500240160069 1 MVIS
500240160076 1 MVIS
500240300038 500240300052 3 EROM
500250270018 500250270025 1 MVIS
500250270032 500250270114 1 MVIS
500250270121 1 MVIS
500260320018 500260320049 1 MVIS
500290130019 500290130146 1 MVIS
500290130153 1 MVIS
500290130160 1 MVIS
500290130177 1 MVIS
HC-085I 14:45 Monday, September 18, 2006 7
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-85IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
500290130019 500290130184 1 MVIS
500290130191 500290130437 1 MVIS
500290130300 500290130444 1 MVIS
500290200019 500290200095 1 MVIS
500290200108 1 MVIS
500290200115 1 MVIS
500290200122 500290200153 1 MVIS
500290200160 1 MVIS
500290200139 500290200177 1 MVIS
500300170013 500300170037 1 MVIS
500300240013 500300240068 1 MVIS
500330220025 500330220049 1 MVIS
500330460018 500330460032 3 EROM
500330460049 3 EROM
500340100021 500340100052 1 MVIS
500340100069 1 MVIS
500340100076 500340100398 1 MVIS
500340100401 1 MVIS
500340100418 1 MVIS
500340100425 1 MVIS
500340100432 1 MVIS
500340100449 1 MVIS
500340100305 500340100456 4 STAZ
500340100312 500340100398 4 STAZ
HC-085I 14:45 Monday, September 18, 2006 8
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-85IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
500520250140 500520250157 6 OMED
500700150595 500700150608 6 OMED
500790140147 500790140154 6 OMED
500970120169 500970120176 6 OMED
500970120183 500970120190 6 OMED
501080110161 501080110178 6 OMED
501080110192 501080110205 6 OMED
501310130073 501310130080 6 OMED
501310130097 501310130100 6 OMED
501520130123 501520130130 6 OMED
501720140021 501720140038 6 OMED
501720140141 501720140158 6 OMED
501720140312 501720140329 6 OMED
501870180072 501870180089 6 OMED
501870180096 501870180109 6 OMED
501870180349 501870180356 6 OMED
501870490027 501870490034 6 OMED
501870490096 501870490109 6 OMED
501970110238 501970110245 6 OMED
501970110454 501970110461 6 OMED
501970110478 501970110485 6 OMED
502530110012 502530110029 6 OMED
502530110036 502530110043 6 OMED
502690200024 502690200031 6 OMED
502690200048 502690200055 6 OMED
HC-085I 14:45 Monday, September 18, 2006 9
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-85IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
502690200113 502690200120 6 OMED
502690200137 502690200144 6 OMED
502690200233 502690200240 6 OMED
502690200257 502690200264 6 OMED
502850140211 502850140228 6 OMED
503170120154 503170120161 6 OMED
503170120178 503170120185 6 OMED
503170121013 503170121020 6 OMED
503170121037 503170121044 6 OMED
503220250234 503220250241 6 OMED
503290100376 503290100383 6 OMED
503410180024 503410180031 6 OMED
503410180048 503410180055 6 OMED
503410180295 503410180308 6 OMED
503410180586 503410180593 6 OMED
503410180606 503410180613 6 OMED
503660150374 503660150381 6 OMED
503660150398 503660150401 6 OMED
503990290017 503990290024 6 OMED
503990290031 503990290048 6 OMED
504450280971 504450280988 6 OMED
504600190087 504600190094 6 OMED
504600190138 504600190145 6 OMED
504610130051 504610130068 6 OMED
504610440051 504610440068 6 OMED
HC-085I 14:45 Monday, September 18, 2006 10
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-85IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
504610440075 504610440082 6 OMED
504610440164 504610440171 6 OMED
504980110041 504980110058 6 OMED
504980110147 504980110154 6 OMED
504980110161 504980110178 6 OMED
505360110073 505360110080 6 OMED
505580280033 505580280040 6 OMED
505580280057 505580280064 6 OMED
505710170055 505710170062 6 OMED
505710170202 505710170219 6 OMED
505710170308 505710170315 6 OMED
506420190015 506420190022 6 OMED
506420190039 506420190046 6 OMED
506430140144 506430140151 6 OMED
506430140548 506430140555 6 OMED
506430140562 506430140579 6 OMED
506480160058 506480160065 6 OMED
506480160212 506480160229 6 OMED
506480160445 506480160452 6 OMED
506510110154 506510110161 6 OMED
506510110178 506510110185 6 OMED
506510110483 506510110490 6 OMED
506510110503 506510110510 6 OMED
506510110750 506510110767 6 OMED
506510110774 506510110781 6 OMED
HC-085I 14:45 Monday, September 18, 2006 11
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-85IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
506510280243 506510280250 6 OMED
506600190117 506600190124 6 OMED
506640250068 506640250075 6 OMED
506700230156 506700230163 6 OMED
506870340448 506870340455 6 OMED
506870340462 506870340479 6 OMED
506870341085 506870341092 6 OMED
506870341105 506870341112 6 OMED
506950160148 506950160155 6 OMED
507120160211 507120160228 6 OMED
507310100310 507310100327 6 OMED
507310100581 507310100598 6 OMED
507480290250 507480290267 6 OMED
507500100621 507500100638 6 OMED
507680190030 507680190047 6 OMED
508060250060 508060250077 6 OMED
508190110291 508190110304 6 OMED
508190110311 508190110328 6 OMED
508190110626 508190110633 6 OMED
508190110640 508190110657 6 OMED
508190110917 508190110924 6 OMED
508320210012 508320210029 6 OMED
508320210238 508320210245 6 OMED
508320210372 508320210389 6 OMED
508340150046 508340150053 6 OMED
HC-085I 14:45 Monday, September 18, 2006 12
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-85IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
508340150128 508340150135 6 OMED
508340150142 508340150159 6 OMED
508340150320 508340150337 6 OMED
509070180028 509070180035 6 OMED
509360280135 509360280142 6 OMED
509360280173 509360280180 6 OMED
509560340032 509560340049 6 OMED
509560340056 509560340063 6 OMED
509630150030 509630150047 6 OMED
509630220218 509630220225 6 OMED
509810190031 509810190048 6 OMED
509810190233 509810190240 6 OMED
509900180151 509900180168 6 OMED
509900180175 509900180182 6 OMED
509900180264 509900180271 6 OMED
509900180288 509900180295 6 OMED
510160140220 510160140237 6 OMED
510160210333 510160210340 6 OMED
510230110025 510230110032 6 OMED
510300200053 510300200060 6 OMED
HC-085I 14:45 Monday, September 18, 2006 13
Sample SAS Job for Example D
sample print of work.pmedids - sorted by evntidx
work.rxlk records for omed events for insulin
EVNTIDX EVENTYPE LINKIDX
501080110161 6 OMED 501080110178
501310130073 6 OMED 501310130080
501870180072 6 OMED 501870180089
501970110238 6 OMED 501970110245
501970110454 6 OMED 501970110461
502530110012 6 OMED 502530110029
502690200024 6 OMED 502690200031
502690200113 6 OMED 502690200120
502690200233 6 OMED 502690200240
503170120154 6 OMED 503170120161
503170121013 6 OMED 503170121020
503410180024 6 OMED 503410180031
503410180586 6 OMED 503410180593
503660150374 6 OMED 503660150381
503660150398 6 OMED 503660150401
503990290017 6 OMED 503990290024
504610440051 6 OMED 504610440068
504980110161 6 OMED 504980110178
505580280033 6 OMED 505580280040
506420190015 6 OMED 506420190022
506430140144 6 OMED 506430140151
506430140548 6 OMED 506430140555
506510110154 6 OMED 506510110161
506510110483 6 OMED 506510110490
506510110750 6 OMED 506510110767
HC-085I 14:45 Monday, September 18, 2006 14
Sample SAS Job for Example D
sample print of work.pmedids - sorted by evntidx
work.rxlk records for omed events for insulin
EVNTIDX EVENTYPE LINKIDX
508190110291 6 OMED 508190110304
508190110626 6 OMED 508190110633
508340150046 6 OMED 508340150053
508340150128 6 OMED 508340150135
509560340032 6 OMED 509560340049
509630150030 6 OMED 509630150047
509900180151 6 OMED 509900180168
509900180264 6 OMED 509900180271
510300200053 6 OMED 510300200060
510300200337 6 OMED 510300200344
510300200755 6 OMED 510300200762
510750220064 6 OMED 510750220071
510750220235 6 OMED 510750220242
512580110025 6 OMED 512580110032
513230190049 6 OMED 513230190056
513230190087 6 OMED 513230190094
513410200067 6 OMED 513410200074
513410200283 6 OMED 513410200290
513410201111 6 OMED 513410201128
514550150013 6 OMED 514550150020
514770130079 6 OMED 514770130086
515660240064 6 OMED 515660240595
515660240266 6 OMED 515660240273
516460240056 6 OMED 516460240063
516460240114 6 OMED 516460240121
HC-085I 14:45 Monday, September 18, 2006 15
Sample SAS Job for Example D
sample print of work.pmedids - sorted by linkidx
Obs EVNTIDX EVENTYPE LINKIDX
1 501080110161 6 OMED 501080110178
2 501310130073 6 OMED 501310130080
3 501870180072 6 OMED 501870180089
4 501970110238 6 OMED 501970110245
5 501970110454 6 OMED 501970110461
6 502530110012 6 OMED 502530110029
7 502690200024 6 OMED 502690200031
8 502690200113 6 OMED 502690200120
9 502690200233 6 OMED 502690200240
10 503170120154 6 OMED 503170120161
11 503170121013 6 OMED 503170121020
12 503410180024 6 OMED 503410180031
13 503410180586 6 OMED 503410180593
14 503660150374 6 OMED 503660150381
15 503660150398 6 OMED 503660150401
16 503990290017 6 OMED 503990290024
17 504610440051 6 OMED 504610440068
18 504980110161 6 OMED 504980110178
19 505580280033 6 OMED 505580280040
20 506420190015 6 OMED 506420190022
21 506430140144 6 OMED 506430140151
22 506430140548 6 OMED 506430140555
23 506510110154 6 OMED 506510110161
24 506510110483 6 OMED 506510110490
25 506510110750 6 OMED 506510110767
26 508190110291 6 OMED 508190110304
27 508190110626 6 OMED 508190110633
28 508340150046 6 OMED 508340150053
29 508340150128 6 OMED 508340150135
30 509560340032 6 OMED 509560340049
31 509630150030 6 OMED 509630150047
32 509900180151 6 OMED 509900180168
33 509900180264 6 OMED 509900180271
34 510300200053 6 OMED 510300200060
35 510300200337 6 OMED 510300200344
36 510300200755 6 OMED 510300200762
37 510750220064 6 OMED 510750220071
38 510750220235 6 OMED 510750220242
39 512580110025 6 OMED 512580110032
40 513230190049 6 OMED 513230190056
41 513230190087 6 OMED 513230190094
42 513410200067 6 OMED 513410200074
43 513410200283 6 OMED 513410200290
44 513410201111 6 OMED 513410201128
45 514550150013 6 OMED 514550150020
46 514770130079 6 OMED 514770130086
47 515660240266 6 OMED 515660240273
48 515660240064 6 OMED 515660240595
49 516460240056 6 OMED 516460240063
50 516460240114 6 OMED 516460240121
HC-085I 14:45 Monday, September 18, 2006 16
Sample SAS Job for Example D
sample print of unique linkidxs in work.pmedids
Obs LINKIDX
1 501080110178
2 501310130080
3 501870180089
4 501970110245
5 501970110461
6 502530110029
7 502690200031
8 502690200120
9 502690200240
10 503170120161
11 503170121020
12 503410180031
13 503410180593
14 503660150381
15 503660150401
16 503990290024
17 504610440068
18 504980110178
19 505580280040
20 506420190022
21 506430140151
22 506430140555
23 506510110161
24 506510110490
25 506510110767
26 508190110304
27 508190110633
28 508340150053
29 508340150135
30 509560340049
31 509630150047
32 509900180168
33 509900180271
34 510300200060
35 510300200344
36 510300200762
37 510750220071
38 510750220242
39 512580110032
40 513230190056
41 513230190094
42 513410200074
43 513410200290
44 513410201128
45 514550150020
46 514770130086
47 515660240273
48 515660240595
49 516460240063
50 516460240121
HC-085I 14:45 Monday, September 18, 2006 17
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
501080110178 501080110178001 HUMULIN N 91.50 18430.395108
501080110178002 HUMULIN N 91.50 18430.395108
501080110178003 HUMULIN N 91.50 18430.395108
501310130080 501310130080001 INSULIN 83.67 5163.421124
501310130080002 INSULIN 83.67 5163.421124
501870180089 501870180089001 INSULIN 83.67 3468.326078
501870180089002 INSULIN 83.67 3468.326078
501870180089003 INSULIN 83.67 3468.326078
501970110245 501970110245001 INSULIN NOVOLIN NOVO DE 80.58 2187.339310
501970110245002 INSULIN NOVOLIN NOVO DE 80.58 2187.339310
501970110245003 INSULIN NOVOLIN NOVO DE 80.58 2187.339310
501970110461 501970110461001 INSULIN NOVOLIN NOVO DE 80.58 2187.339310
501970110461002 INSULIN NOVOLIN NOVO DE 80.58 2187.339310
502530110029 502530110029001 INSULIN 83.67 3273.354593
502530110029002 INSULIN 83.67 3273.354593
502530110029003 INSULIN 83.67 3273.354593
502690200031 502690200031001 INSULIN 83.67 10510.898613
502690200120 502690200120001 HUMULIN R (VIAL) 26.45 10510.898613
502690200240 502690200240001 HUMULIN R (VIAL) 27.75 10510.898613
502690200240002 HUMULIN R (VIAL) 27.75 10510.898613
502690200240003 HUMULIN R (VIAL) 27.75 10510.898613
502690200240004 HUMULIN R (VIAL) 27.75 10510.898613
502690200240005 HUMULIN R (VIAL) 27.75 10510.898613
503170120161 503170120161001 LANTUS 121.70 13931.140208
503170121020 503170121020001 HUMALOG 93.86 13931.140208
503170121020002 HUMALOG 93.86 13931.140208
503170121020003 HUMALOG 93.86 13931.140208
503170121020004 HUMALOG 93.86 13931.140208
503410180031 503410180031001 HUMULIN 70/30 (VIAL) 55.09 8126.477197
503410180593 503410180593001 HUMULIN 70/30 (VIAL) 57.94 8126.477197
503410180593002 HUMULIN 70/30 (VIAL) 57.94 8126.477197
503410180593003 HUMULIN 70/30 (VIAL) 57.94 8126.477197
503410180593004 HUMULIN 70/30 (VIAL) 57.94 8126.477197
503410180593005 HUMULIN 70/30 (VIAL) 57.94 8126.477197
503660150381 503660150381001 INSULIN 83.67 23221.138824
503660150381002 INSULIN 83.67 23221.138824
HC-085I 14:45 Monday, September 18, 2006 18
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
503660150381 503660150381003 INSULIN 83.67 23221.138824
503660150401 503660150401001 INSULIN 83.67 23221.138824
503660150401002 INSULIN 83.67 23221.138824
503660150401003 INSULIN 83.67 23221.138824
503990290024 503990290024001 INSULIN 83.67 4825.858715
504610440068 504610440068001 INSULIN 30.76 3598.275760
504980110178 504980110178001 INSULIN 83.67 11916.390791
505580280040 505580280040001 INSULIN 83.67 4117.416060
506420190022 506420190022001 HUMULIN N 30.76 4223.466629
506430140151 506430140151001 HUMALOG 62.17 3912.151905
506430140151002 HUMALOG 62.17 3912.151905
506430140151003 HUMALOG 62.17 3912.151905
506430140555 506430140555001 LANTUS 53.73 3912.151905
506430140555002 LANTUS 53.73 3912.151905
506430140555003 LANTUS 58.44 3912.151905
506510110161 506510110161001 INSULIN 30.76 4754.895939
506510110161002 INSULIN 30.76 4754.895939
506510110161003 INSULIN 30.76 4754.895939
506510110490 506510110490001 INSULIN 30.76 4754.895939
506510110490002 INSULIN 30.76 4754.895939
506510110490003 INSULIN 30.76 4754.895939
506510110490004 INSULIN 30.76 4754.895939
506510110767 506510110767001 INSULIN 30.76 4754.895939
506510110767002 INSULIN 30.76 4754.895939
508190110304 508190110304001 HUMALOG MIX 75/25 139.92 5580.122341
508190110304002 HUMALOG MIX 75/25 139.92 5580.122341
508190110304003 HUMALOG MIX 75/25 139.92 5580.122341
508190110304004 HUMALOG MIX 75/25 139.92 5580.122341
508190110304005 HUMALOG MIX 75/25 139.92 5580.122341
508190110304006 HUMALOG MIX 75/25 139.92 5580.122341
508190110633 508190110633001 INSULIN 30.76 5580.122341
508190110633002 INSULIN 30.76 5580.122341
508340150053 508340150053001 LANTUS 105.45 11959.314156
508340150135 508340150135001 INSULIN 83.67 11959.314156
HC-085I 14:45 Monday, September 18, 2006 19
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
508340150135 508340150135002 INSULIN 83.67 11959.314156
509560340049 509560340049001 INSULIN 83.67 9519.802194
509630150047 509630150047001 NOVOLIN N 91.50 14901.342788
509630150047002 NOVOLIN N 91.50 14901.342788
509900180168 509900180168001 INSULIN 83.67 1461.320448
509900180168002 INSULIN 83.67 1461.320448
509900180168003 INSULIN 83.67 1461.320448
509900180168004 INSULIN 83.67 1461.320448
509900180168005 INSULIN 83.67 1461.320448
509900180168006 INSULIN 83.67 1461.320448
509900180168007 INSULIN 83.67 1461.320448
509900180168008 INSULIN 83.67 1461.320448
509900180168009 INSULIN 83.67 1461.320448
509900180168010 INSULIN 83.67 1461.320448
509900180271 509900180271001 INSULIN 83.67 1461.320448
509900180271002 INSULIN 83.67 1461.320448
509900180271003 INSULIN 83.67 1461.320448
509900180271004 INSULIN 83.67 1461.320448
509900180271005 INSULIN 83.67 1461.320448
509900180271006 INSULIN 83.67 1461.320448
509900180271007 INSULIN 83.67 1461.320448
509900180271008 INSULIN 83.67 1461.320448
509900180271009 INSULIN 83.67 1461.320448
509900180271010 INSULIN 83.67 1461.320448
510300200060 510300200060001 LANTUS 113.03 8222.207028
510300200060002 LANTUS 58.27 8222.207028
510300200060003 LANTUS 58.27 8222.207028
510300200344 510300200344001 LANTUS 113.03 8222.207028
510300200344002 LANTUS 113.03 8222.207028
510300200344003 LANTUS 113.03 8222.207028
510300200344004 LANTUS 113.03 8222.207028
510300200344005 LANTUS 113.03 8222.207028
510300200344006 LANTUS 113.03 8222.207028
510300200762 510300200762001 LANTUS 122.89 8222.207028
510300200762002 LANTUS 113.03 8222.207028
510300200762003 LANTUS 122.89 8222.207028
510300200762004 LANTUS 122.89 8222.207028
510300200762005 LANTUS 113.03 8222.207028
510300200762006 LANTUS 122.89 8222.207028
510300200762007 LANTUS 122.89 8222.207028
510750220071 510750220071001 HUMULIN N PEN (PREFILLED DISPOSABLE) 96.61 5016.143983
HC-085I 14:45 Monday, September 18, 2006 20
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
510750220071 510750220071002 HUMULIN N PEN (PREFILLED DISPOSABLE) 102.49 5016.143983
510750220242 510750220242001 HUMULIN N PEN (PREFILLED DISPOSABLE) 106.69 5016.143983
510750220242002 HUMULIN N PEN (PREFILLED DISPOSABLE) 96.61 5016.143983
510750220242003 HUMULIN N PEN (PREFILLED DISPOSABLE) 96.61 5016.143983
510750220242004 HUMULIN N PEN (PREFILLED DISPOSABLE) 96.61 5016.143983
510750220242005 HUMULIN N PEN (PREFILLED DISPOSABLE) 106.69 5016.143983
512580110032 512580110032001 INSULIN HUMAN NPH 80.58 19642.332695
513230190056 513230190056001 INSULIN 83.67 14134.776807
513230190094 513230190094001 INSULIN 83.67 14134.776807
513410200074 513410200074001 HUMULIN N 61.00 11319.218855
513410200290 513410200290001 HUMULIN N 53.60 11319.218855
513410200290002 HUMULIN N 53.60 11319.218855
513410200290003 HUMULIN N 53.60 11319.218855
513410200290004 HUMULIN N 53.60 11319.218855
513410200290005 HUMULIN N 57.99 11319.218855
513410200290006 HUMULIN N 57.99 11319.218855
513410201128 513410201128001 HUMULIN N 57.99 11319.218855
513410201128002 HUMULIN N 57.99 11319.218855
514550150020 514550150020001 INSULIN 83.67 3681.444088
514550150020002 INSULIN 83.67 3681.444088
514770130086 514770130086001 INSULIN 30.76 6216.676135
515660240273 515660240273001 INSULIN GLARGINE 38.69 9037.210537
515660240595 515660240595001 INSULIN GLARGINE 6.09 9037.210537
515660240595002 INSULIN GLARGINE 6.09 9037.210537
515660240595003 INSULIN GLARGINE 6.09 9037.210537
516460240063 516460240063001 INSULIN 83.67 4718.719456
516460240063002 INSULIN 83.67 4718.719456
516460240063003 INSULIN 83.67 4718.719456
516460240121 516460240121001 INSULIN 83.67 4718.719456
516460240121002 INSULIN 83.67 4718.719456
516460240121003 INSULIN 83.67 4718.719456
516710230170 516710230170001 LANTUS 54.58 11757.181617
516710230170002 LANTUS 54.58 11757.181617
516710230170003 LANTUS 54.58 11757.181617
516710230170004 LANTUS 54.58 11757.181617
HC-085I 14:45 Monday, September 18, 2006 21
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
516710230170 516710230170005 LANTUS 54.58 11757.181617
517300230195 517300230195001 INSULIN 83.67 13334.029474
518070470259 518070470259001 HUMULIN N 30.76 5963.437092
518070470259002 HUMULIN N 30.76 5963.437092
518860190098 518860190098001 INSULIN 83.67 21968.892227
518860190269 518860190269001 INSULIN 83.67 21968.892227
518860190269002 INSULIN 83.67 21968.892227
518860190896 518860190896001 HUMULIN R 30.76 21968.892227
519610160037 519610160037001 INSULIN 83.67 9370.182095
519610160037002 INSULIN 83.67 9370.182095
519610160037003 INSULIN 83.67 9370.182095
519610160119 519610160119001 INSULIN 83.67 9370.182095
519610160119002 INSULIN 83.67 9370.182095
519610160119003 INSULIN 83.67 9370.182095
519610160119004 INSULIN 83.67 9370.182095
519610160119005 INSULIN 83.67 9370.182095
519610160119006 INSULIN 83.67 9370.182095
519610160119007 INSULIN 83.67 9370.182095
519610160119008 INSULIN 83.67 9370.182095
519610160119009 INSULIN 83.67 9370.182095
519610160119010 INSULIN 83.67 9370.182095
520060210202 520060210202001 INSULIN 83.67 6039.122452
520060210202002 INSULIN 83.67 6039.122452
520060210202003 INSULIN 83.67 6039.122452
520800210453 520800210453001 INSULIN NOVOLIN 30.29 10524.682402
520800210453002 INSULIN NOVOLIN 30.29 10524.682402
520800210453003 INSULIN NOVOLIN 30.29 10524.682402
520800210453004 INSULIN NOVOLIN 30.29 10524.682402
521130140090 521130140090001 HUMULIN N 30.50 8213.658232
521130140090002 HUMULIN N 30.50 8213.658232
521130140090003 HUMULIN N 30.50 8213.658232
521350120040 521350120040001 INSULIN 30.76 6483.531936
521350120040002 INSULIN 30.76 6483.531936
521350120040003 INSULIN 30.76 6483.531936
521350120297 521350120297001 INSULIN 30.76 6483.531936
521350120297002 INSULIN 30.76 6483.531936
521350120297003 INSULIN 30.76 6483.531936
HC-085I 14:45 Monday, September 18, 2006 22
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-085A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP04X PERWT04F
521710240119 521710240119001 INSULIN 83.67 5918.059051
521710240119002 INSULIN 83.67 5918.059051
521710240119003 INSULIN 83.67 5918.059051
521710240119004 INSULIN 83.67 5918.059051
521940180128 521940180128001 HUMULIN 70/30 (VIAL) 79.89 5456.907176
521940180128002 HUMULIN 70/30 (VIAL) 79.89 5456.907176
521940180128003 HUMULIN 70/30 (VIAL) 79.89 5456.907176
521940180128004 HUMULIN 70/30 (VIAL) 79.89 5456.907176
521940180128005 HUMULIN 70/30 (VIAL) 79.89 5456.907176
521940180628 521940180628001 HUMULIN 70/30 (VIAL) 79.89 5456.907176
521940180628002 HUMULIN 70/30 (VIAL) 79.89 5456.907176
521940180628003 HUMULIN 70/30 (VIAL) 79.89 5456.907176
522090160036 522090160036001 INSULIN 83.67 9805.653493
522090160214 522090160214001 INSULIN 83.67 9805.653493
522090160214002 INSULIN 83.67 9805.653493
522090160214003 INSULIN 83.67 9805.653493
522090160214004 INSULIN 83.67 9805.653493
HC-085I 14:45 Monday, September 18, 2006 23
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
The MEANS Procedure
Analysis Variable : RXXP04X SUM OF PAYMENTS RXSF04X-RXOU04X(IMPUTED)
N Sum
--------------------
1778 124276.65
--------------------
HC-085I 14:45 Monday, September 18, 2006 24
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
Weighted
The MEANS Procedure
Analysis Variable : RXXP04X SUM OF PAYMENTS RXSF04X-RXOU04X(IMPUTED)
N Sum
--------------------
1778 1099947734
--------------------
--------------------
<< previous page