1 The SAS System 07:25 Thursday, March 11, 2004
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX07.
NOTE: SAS initialization used:
real time 3.64 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-059I";
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.14 seconds
cpu time 0.01 seconds
2 The SAS System 07:25 Thursday, March 11, 2004
24
25 *-------------------------------------------------------------------------------------
26 * Get condition records coded as asthma.
27 *-------------------------------------------------------------------------------------;
28 DATA ASCONDS;
29 SET IN.H61 (KEEP=CONDIDX CCCODEX);
30 IF CCCODEX="128";
31
32 RUN;
NOTE: There were 102489 observations read from the data set IN.H61.
NOTE: The data set WORK.ASCONDS has 1695 observations and 2 variables.
NOTE: DATA statement used:
real time 0.40 seconds
cpu time 0.13 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 1695 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1695 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.04 seconds
cpu time 0.01 seconds
38
39 proc print data=asconds (obs=50);
40 title3 "sample print of work.asconds - sorted by condidx";
41 title4 "COND (H61) 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.26 seconds
cpu time 0.01 seconds
43
44 PROC SORT DATA=IN.H59IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 314599 observations read from the data set IN.H59IF1.
NOTE: The data set WORK.CLNK has 314599 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 3.45 seconds
cpu time 1.76 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 07:25 Thursday, March 11, 2004
50 IF INCLNK & INASCOND;
51 RUN;
NOTE: There were 314599 observations read from the data set WORK.CLNK.
NOTE: There were 1695 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7046 observations and 3 variables.
NOTE: DATA statement used:
real time 0.35 seconds
cpu time 0.31 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.07 seconds
cpu time 0.03 seconds
60
61 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7046 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7046 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.01 seconds
cpu time 0.01 seconds
62
63 proc print data=asclnks (obs=50);
64 format eventype eventype.;
65 title3 "sample print of work.asclnks - sorted by evntidx";
66 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used:
real time 0.03 seconds
cpu time 0.03 seconds
67
68 DATA ASCLNKS;
69 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
70 BY EVNTIDX;
71 IF FIRST.EVNTIDX;
72 RUN;
4 The SAS System 07:25 Thursday, March 11, 2004
NOTE: There were 7046 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7033 observations and 2 variables.
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.01 seconds
73
74 proc print data=asclnks (obs=50);
75 title3 "sample print of unique evntidxs from work.asclnks";
76 format eventype eventype.;
77 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.01 seconds
78
79 *--------------------------------------------------------------------------------------------
80 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
81 *--------------------------------------------------------------------------------------------;
82 DATA MVIS;
83 SET IN.H59G (KEEP=EVNTIDX PERWT01F SEETLKPV);
84 IF PERWT01F > 0 & SEETLKPV NE 2;
85 RUN;
NOTE: There were 147490 observations read from the data set IN.H59G.
NOTE: The data set WORK.MVIS has 142776 observations and 3 variables.
NOTE: DATA statement used:
real time 2.10 seconds
cpu time 0.42 seconds
86
87 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 142776 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 142776 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.40 seconds
cpu time 0.39 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 07:25 Thursday, March 11, 2004
NOTE: There were 7033 observations read from the data set WORK.ASCLNKS.
NOTE: There were 142776 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 2238 observations and 2 variables.
NOTE: DATA statement used:
real time 0.17 seconds
cpu time 0.15 seconds
98
99 proc print data=asmvis (obs=50);
100 format eventype eventype.;
101 title3 "sample print of work.asmvis";
102 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-059G) 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.H59IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: There were 60519 observations read from the data set IN.H59IF2.
NOTE: The data set WORK.RXLK has 60519 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 0.48 seconds
cpu time 0.26 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-59IF2)";
117 run;
NOTE: There were 140 observations read from the data set WORK.RXLK.
NOTE: The PROCEDURE PRINT printed pages 7-11.
NOTE: PROCEDURE PRINT used:
real time 0.03 seconds
cpu time 0.03 seconds
118
119 DATA PMEDIDS;
120 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
121 ASMVIS(IN=INASMVIS KEEP=EVNTIDX);
122 BY EVNTIDX;
6 The SAS System 07:25 Thursday, March 11, 2004
123 IF INRXLK & INASMVIS;
124 RUN;
NOTE: There were 60519 observations read from the data set WORK.RXLK.
NOTE: There were 2238 observations read from the data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 1861 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 1861 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1861 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.03 seconds
cpu time 0.00 seconds
135
136 proc print data=pmedids (obs=50);
137 format eventype eventype.;
138 title3 "sample print of work.pmedids - sorted by linkidx";
139 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 14.
NOTE: PROCEDURE PRINT used:
real time 0.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 07:25 Thursday, March 11, 2004
NOTE: There were 1861 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1780 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.01 seconds
cpu time 0.01 seconds
150
151 *-----------------------------------------------------------------------------------------
152 * Get PMED records linked to MVIS events which were for asthma.
153 *-----------------------------------------------------------------------------------------;
154 PROC SORT DATA=IN.H59A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 277866 observations read from the data set IN.H59A.
NOTE: The data set WORK.PMED has 277866 observations and 74 variables.
NOTE: PROCEDURE SORT used:
real time 3:06.45
cpu time 21.10 seconds
155
156 DATA MVPMEDS;
157 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP01X PERWT01F RXNAME)
158 PMEDIDS (IN=A);
159 BY LINKIDX;
160 IF A;
161 RUN;
NOTE: There were 277866 observations read from the data set WORK.PMED.
NOTE: There were 1780 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 4599 observations and 5 variables.
NOTE: DATA statement used:
real time 2.68 seconds
cpu time 0.96 seconds
162
163 proc print data=mvpmeds (obs=200);
164 var rxrecidx rxname RXXP01X PERWT01F;
165 by linkidx;
166 id linkidx;
167 title3 "sample print of work.mvpmeds";
168 title4 "PMED (HC-059A) records for unique linkidxs in work.pmedids";
169 run;
8 The SAS System 07:25 Thursday, March 11, 2004
NOTE: There were 200 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE PRINT printed pages 16-22.
NOTE: PROCEDURE PRINT used:
real time 0.48 seconds
cpu time 0.01 seconds
170
171 PROC MEANS DATA=MVPMEDS N SUM;
172 VAR RXXP01X;
173 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
174 RUN;
NOTE: There were 4599 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used:
real time 0.29 seconds
cpu time 0.01 seconds
175
176 PROC MEANS DATA=MVPMEDS N SUM;
177 VAR RXXP01X;
178 WEIGHT PERWT01F;
179 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
180 TITLE5 "Weighted";
181 RUN;
NOTE: There were 4599 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 24.
NOTE: PROCEDURE MEANS used:
real time 0.01 seconds
cpu time 0.00 seconds
182
183
184
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 3:24.11
cpu time 26.34 seconds
HC-059I 07:25 Thursday, March 11, 2004 1
Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H61) records where cccodex=128
Obs CONDIDX CCCODEX
1 400060150010 128
2 400060220025 128
3 400100460013 128
4 400120250093 128
5 400150180047 128
6 400150320017 128
7 400420120055 128
8 400500160056 128
9 400630140015 128
10 400670280087 128
11 400700390037 128
12 400830280016 128
13 400840180025 128
14 400840320017 128
15 400850110076 128
16 400990200047 128
17 401160130036 128
18 401650150017 128
19 401700450040 128
20 401710240020 128
21 401840370020 128
22 401870110028 128
23 401870350010 128
24 402060410053 128
25 402160430011 128
26 402160660010 128
27 402190190014 128
28 402260280015 128
29 402350120018 128
30 402530190024 128
31 402720640014 128
32 402740320012 128
33 402970200016 128
34 403000160011 128
35 403110150117 128
36 403210170016 128
37 403210480013 128
38 403230280069 128
39 403320410016 128
40 403330360012 128
41 403340270061 128
42 403510210075 128
43 403860370035 128
44 404130470038 128
45 404210160041 128
46 404550260035 128
47 404670140024 128
48 404760860025 128
49 404770150034 128
50 404790560018 128
HC-059I 07:25 Thursday, March 11, 2004 2
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
400100460013 400100460012 8 PMED
400100460029 8 PMED
400100460036 8 PMED
400100460043 8 PMED
400120250093 400120250196 8 PMED
400150180047 400150180038 1 MVIS
400150180076 8 PMED
400150180083 8 PMED
400150180090 8 PMED
400150180463 1 MVIS
400150180470 1 MVIS
400150180507 8 PMED
400150320017 400150320014 1 MVIS
400150320021 1 MVIS
400150320038 1 MVIS
400150320045 1 MVIS
400150320052 1 MVIS
400150320069 1 MVIS
400150320090 1 MVIS
400150320103 1 MVIS
400150320110 8 PMED
400420120055 400420120077 8 PMED
400420120180 8 PMED
400500160056 400500160080 8 PMED
400500160097 8 PMED
400630140015 400630140025 1 MVIS
400630140049 4 STAZ
400630140056 3 EROM
400630140070 8 PMED
400630140087 8 PMED
400630140107 8 PMED
400630140145 1 MVIS
400630140152 8 PMED
400630140169 8 PMED
400630140183 8 PMED
400630140227 8 PMED
400630140234 8 PMED
400630140258 8 PMED
400670280087 400670280130 8 PMED
400670280147 8 PMED
400670280154 8 PMED
400670280161 8 PMED
HC-059I 07:25 Thursday, March 11, 2004 3
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
400670280087 400670280250 8 PMED
400700390037 400700390041 8 PMED
400830280016 400830280011 8 PMED
400840180025 400840180019 2 OPAT
400840180040 2 OPAT
400840180095 8 PMED
400840180108 8 PMED
400840180115 8 PMED
400840180122 8 PMED
400840180146 1 MVIS
400840180204 8 PMED
400840180211 8 PMED
400840180228 8 PMED
400840180259 8 PMED
400840180297 2 OPAT
400840180300 2 OPAT
400840180317 2 OPAT
400840180331 2 OPAT
400840180379 8 PMED
400840180386 8 PMED
400840180393 8 PMED
400840320017 400840320026 2 OPAT
400840320033 2 OPAT
400840320191 2 OPAT
400850110076 400850110226 8 PMED
400850110308 1 MVIS
400850110315 1 MVIS
400850110322 1 MVIS
400850110360 1 MVIS
400850110377 1 MVIS
400850110428 8 PMED
400850110435 8 PMED
400990200047 400990200092 8 PMED
HC-059I 07:25 Thursday, March 11, 2004 4
Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 400100460013 400100460012 8 PMED
2 400100460013 400100460029 8 PMED
3 400100460013 400100460036 8 PMED
4 400100460013 400100460043 8 PMED
5 400120250093 400120250196 8 PMED
6 400150180047 400150180038 1 MVIS
7 400150180047 400150180076 8 PMED
8 400150180047 400150180083 8 PMED
9 400150180047 400150180090 8 PMED
10 400150180047 400150180463 1 MVIS
11 400150180047 400150180470 1 MVIS
12 400150180047 400150180507 8 PMED
13 400150320017 400150320014 1 MVIS
14 400150320017 400150320021 1 MVIS
15 400150320017 400150320038 1 MVIS
16 400150320017 400150320045 1 MVIS
17 400150320017 400150320052 1 MVIS
18 400150320017 400150320069 1 MVIS
19 400150320017 400150320090 1 MVIS
20 400150320017 400150320103 1 MVIS
21 400150320017 400150320110 8 PMED
22 400420120055 400420120077 8 PMED
23 400420120055 400420120180 8 PMED
24 400500160056 400500160080 8 PMED
25 400500160056 400500160097 8 PMED
26 400630140015 400630140025 1 MVIS
27 400630140015 400630140049 4 STAZ
28 400630140015 400630140056 3 EROM
29 400630140015 400630140070 8 PMED
30 400630140015 400630140087 8 PMED
31 400630140015 400630140107 8 PMED
32 400630140015 400630140145 1 MVIS
33 400630140015 400630140152 8 PMED
34 400630140015 400630140169 8 PMED
35 400630140015 400630140183 8 PMED
36 400630140015 400630140227 8 PMED
37 400630140015 400630140234 8 PMED
38 400630140015 400630140258 8 PMED
39 400670280087 400670280130 8 PMED
40 400670280087 400670280147 8 PMED
41 400670280087 400670280154 8 PMED
42 400670280087 400670280161 8 PMED
43 400670280087 400670280250 8 PMED
44 400700390037 400700390041 8 PMED
45 400830280016 400830280011 8 PMED
46 400840180025 400840180019 2 OPAT
47 400840180025 400840180040 2 OPAT
48 400840180025 400840180095 8 PMED
49 400840180025 400840180108 8 PMED
50 400840180025 400840180115 8 PMED
HC-059I 07:25 Thursday, March 11, 2004 5
Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 400100460012 8 PMED
2 400100460029 8 PMED
3 400100460036 8 PMED
4 400100460043 8 PMED
5 400120250196 8 PMED
6 400150180038 1 MVIS
7 400150180076 8 PMED
8 400150180083 8 PMED
9 400150180090 8 PMED
10 400150180463 1 MVIS
11 400150180470 1 MVIS
12 400150180507 8 PMED
13 400150320014 1 MVIS
14 400150320021 1 MVIS
15 400150320038 1 MVIS
16 400150320045 1 MVIS
17 400150320052 1 MVIS
18 400150320069 1 MVIS
19 400150320090 1 MVIS
20 400150320103 1 MVIS
21 400150320110 8 PMED
22 400420120077 8 PMED
23 400420120180 8 PMED
24 400500160080 8 PMED
25 400500160097 8 PMED
26 400630140025 1 MVIS
27 400630140049 4 STAZ
28 400630140056 3 EROM
29 400630140070 8 PMED
30 400630140087 8 PMED
31 400630140107 8 PMED
32 400630140145 1 MVIS
33 400630140152 8 PMED
34 400630140169 8 PMED
35 400630140183 8 PMED
36 400630140227 8 PMED
37 400630140234 8 PMED
38 400630140258 8 PMED
39 400670280130 8 PMED
40 400670280147 8 PMED
41 400670280154 8 PMED
42 400670280161 8 PMED
43 400670280250 8 PMED
44 400700390041 8 PMED
45 400830280011 8 PMED
46 400840180019 2 OPAT
47 400840180040 2 OPAT
48 400840180095 8 PMED
49 400840180108 8 PMED
50 400840180115 8 PMED
HC-059I 07:25 Thursday, March 11, 2004 6
Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-059G) events
Obs EVNTIDX EVENTYPE
1 400150180038 1 MVIS
2 400150180463 1 MVIS
3 400150180470 1 MVIS
4 400150320014 1 MVIS
5 400150320021 1 MVIS
6 400150320038 1 MVIS
7 400150320045 1 MVIS
8 400150320052 1 MVIS
9 400150320069 1 MVIS
10 400150320090 1 MVIS
11 400150320103 1 MVIS
12 400630140025 1 MVIS
13 400630140145 1 MVIS
14 400840180146 1 MVIS
15 400850110308 1 MVIS
16 400850110315 1 MVIS
17 400850110322 1 MVIS
18 400850110360 1 MVIS
19 400850110377 1 MVIS
20 401650150016 1 MVIS
21 401870350013 1 MVIS
22 402160660102 1 MVIS
23 402260280014 1 MVIS
24 402260280038 1 MVIS
25 402530190036 1 MVIS
26 402530190043 1 MVIS
27 402530190125 1 MVIS
28 402530190132 1 MVIS
29 402530190149 1 MVIS
30 402530190245 1 MVIS
31 402530190276 1 MVIS
32 402720640014 1 MVIS
33 402720640021 1 MVIS
34 402720640069 1 MVIS
35 402970200015 1 MVIS
36 402970200039 1 MVIS
37 402970200046 1 MVIS
38 402970200053 1 MVIS
39 402970200128 1 MVIS
40 402970200135 1 MVIS
41 402970200142 1 MVIS
42 402970200159 1 MVIS
43 402970200166 1 MVIS
44 402970200262 1 MVIS
45 402970200286 1 MVIS
46 403000160012 1 MVIS
47 403000160029 1 MVIS
48 403210170015 1 MVIS
49 403210480046 1 MVIS
50 403210480053 1 MVIS
HC-059I 07:25 Thursday, March 11, 2004 7
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-59IF2)
EVNTIDX LINKIDX EVENTYPE
400010130020 400010130051 1 MVIS
400010130037 400010130044 6 OMED
400010130068 400010130075 6 OMED
400010200075 400010200082 1 MVIS
400070150018 400070150025 1 MVIS
400070150049 400070150056 3 EROM
400100150029 400100150118 1 MVIS
400110130013 400110130020 1 MVIS
400110130037 400110130068 5 DVIS
400110130044 400110130068 5 DVIS
400110200044 400110200051 2 OPAT
400110370013 400110370020 1 MVIS
400110370037 400110370044 1 MVIS
400110370051 1 MVIS
400120250014 400120250069 1 MVIS
400120250021 400120250076 1 MVIS
400120250038 400120250076 1 MVIS
400120250083 400120250090 1 MVIS
400120250110 400120250134 2 OPAT
400120250141 2 OPAT
400130170019 400130170071 4 STAZ
400130170088 4 STAZ
400130170095 4 STAZ
400130170108 4 STAZ
400130170115 4 STAZ
400130170122 4 STAZ
400130170139 4 STAZ
400130170146 4 STAZ
400130170153 4 STAZ
400130170160 4 STAZ
HC-059I 07:25 Thursday, March 11, 2004 8
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-59IF2)
EVNTIDX LINKIDX EVENTYPE
400130240160 400130240259 1 MVIS
400150180014 400150180052 3 EROM
400150180021 400150180069 1 MVIS
400150180038 400150180076 1 MVIS
400150180083 1 MVIS
400150180090 1 MVIS
400150180134 400150180487 2 OPAT
400150180141 400150180494 2 OPAT
400150320090 400150320110 1 MVIS
400170190012 400170190050 1 MVIS
400170190029 400170190067 1 MVIS
400170190149 400170190156 1 MVIS
400170190163 1 MVIS
400170190170 1 MVIS
400170190187 1 MVIS
400170260050 400170260067 1 MVIS
400170260074 1 MVIS
400170260101 400170260149 1 MVIS
400180180015 400180180022 1 MVIS
400180180039 400180180046 1 MVIS
400180350012 400180350029 3 EROM
400190150014 400190150083 1 MVIS
400190150090 1 MVIS
400190150103 1 MVIS
400190150110 1 MVIS
400190150127 1 MVIS
400190150134 1 MVIS
400190150052 400190150141 1 MVIS
400190150069 400190150076 6 OMED
400190150165 400190150209 1 MVIS
HC-059I 07:25 Thursday, March 11, 2004 9
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-59IF2)
EVNTIDX LINKIDX EVENTYPE
400190150172 400190150209 1 MVIS
400190150196 400190150216 1 MVIS
400190150292 400190150312 1 MVIS
400190150329 1 MVIS
400190150336 1 MVIS
400190150343 1 MVIS
400190150350 1 MVIS
400190150367 1 MVIS
400190220052 400190220083 1 MVIS
400190220069 400190220076 6 OMED
400190220305 400190220456 1 MVIS
400190220463 1 MVIS
400190220312 400190220487 1 MVIS
400190220329 400190220494 1 MVIS
400190390045 400190390254 1 MVIS
400190390069 400190390261 1 MVIS
400190390165 400190390254 1 MVIS
400190390196 400190390278 1 MVIS
400200100035 400200100042 1 MVIS
400200270028 400200270035 1 MVIS
400200270080 400200270131 1 MVIS
400230180015 400230180039 1 MVIS
400230180022 400230180046 1 MVIS
400230180077 400230180104 1 MVIS
400230180111 1 MVIS
400230180091 400230180128 1 MVIS
400230320053 400230320104 1 MVIS
400230490015 400230490022 1 MVIS
400230490039 1 MVIS
HC-059I 07:25 Thursday, March 11, 2004 10
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-59IF2)
EVNTIDX LINKIDX EVENTYPE
400250210017 400250210024 1 MVIS
400280170016 400280170061 5 DVIS
400280170078 5 DVIS
400280240023 400280240030 1 MVIS
400290360092 400290360105 1 MVIS
400290430054 400290430078 1 MVIS
400290430061 400290430085 1 MVIS
400300180052 400300180069 1 MVIS
400300180076 1 MVIS
400300180090 400300180110 1 MVIS
400340190014 400340190196 1 MVIS
400340190209 1 MVIS
400340190216 1 MVIS
400340190021 400340190223 1 MVIS
400340190189 400340190230 2 OPAT
400340190590 400340190709 1 MVIS
400340190716 1 MVIS
400340190723 1 MVIS
400340190603 400340190709 1 MVIS
400340190716 1 MVIS
400340190723 1 MVIS
400350300016 400350300023 1 MVIS
400350300030 1 MVIS
400350300047 400350300054 1 MVIS
400350470016 400350470023 1 MVIS
400360130011 400360130100 3 EROM
400360130028 400360130117 2 OPAT
400360130124 2 OPAT
400360130131 2 OPAT
400360130148 2 OPAT
400360130066 400360130155 4 STAZ
HC-059I 07:25 Thursday, March 11, 2004 11
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-59IF2)
EVNTIDX LINKIDX EVENTYPE
400360130066 400360130162 4 STAZ
400360130179 4 STAZ
400380140010 400380140027 1 MVIS
400380140034 1 MVIS
400380140041 1 MVIS
400380140058 1 MVIS
400400190102 400400190157 1 MVIS
400400190119 400400190164 1 MVIS
400400190171 1 MVIS
400400190133 400400190140 6 OMED
400400190397 400400190400 6 OMED
400400190688 400400190695 6 OMED
400420120022 400420120053 1 MVIS
400420120060 1 MVIS
400420120077 1 MVIS
400420120084 1 MVIS
400420120091 1 MVIS
400420120104 1 MVIS
400420120135 400420120166 2 OPAT
400450280031 400450280106 1 MVIS
HC-059I 07:25 Thursday, March 11, 2004 12
Sample SAS Job for Example A
sample print of work.pmedids - sorted by evntidx
work.rxlk records for evntidxs in work.asmvis
EVNTIDX LINKIDX EVENTYPE
400150180038 400150180076 1 MVIS
400150180083 1 MVIS
400150180090 1 MVIS
400150320090 400150320110 1 MVIS
400630140145 400630140152 1 MVIS
400630140169 1 MVIS
400630140176 1 MVIS
400630140183 1 MVIS
401650150016 401650150112 1 MVIS
402260280014 402260280021 1 MVIS
402260280038 402260280045 1 MVIS
402720640014 402720640038 1 MVIS
402720640045 1 MVIS
402720640021 402720640052 1 MVIS
402720640069 402720640083 1 MVIS
402720640090 1 MVIS
402970200015 402970200077 1 MVIS
402970200039 402970200077 1 MVIS
402970200084 1 MVIS
402970200128 402970200197 1 MVIS
402970200166 402970200200 1 MVIS
402970200262 402970200293 1 MVIS
403000160012 403000160036 1 MVIS
403000160043 1 MVIS
403210480046 403210480111 1 MVIS
403210480084 403210480128 1 MVIS
403210480173 403210480231 1 MVIS
403320410025 403320410049 1 MVIS
403320410056 1 MVIS
403320410063 1 MVIS
HC-059I 07:25 Thursday, March 11, 2004 13
Sample SAS Job for Example A
sample print of work.pmedids - sorted by evntidx
work.rxlk records for evntidxs in work.asmvis
EVNTIDX LINKIDX EVENTYPE
403330360014 403330360021 1 MVIS
403340270075 403340270119 1 MVIS
404130470060 404130470077 1 MVIS
404550260205 404550260212 1 MVIS
404550260229 1 MVIS
404550260236 1 MVIS
404550260243 1 MVIS
404550260250 1 MVIS
404550260267 1 MVIS
404760860037 404760860044 1 MVIS
404760860051 1 MVIS
404770150200 404770150255 1 MVIS
404840150029 404840150036 1 MVIS
404840150043 1 MVIS
404840150050 1 MVIS
405330290011 405330290035 1 MVIS
405470360064 405470360088 1 MVIS
405540510016 405540510023 1 MVIS
405540510030 1 MVIS
406030880019 406030880026 1 MVIS
HC-059I 07:25 Thursday, March 11, 2004 14
Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx
Obs EVNTIDX LINKIDX EVENTYPE
1 400150180038 400150180076 1 MVIS
2 400150180038 400150180083 1 MVIS
3 400150180038 400150180090 1 MVIS
4 400150320090 400150320110 1 MVIS
5 400630140145 400630140152 1 MVIS
6 400630140145 400630140169 1 MVIS
7 400630140145 400630140176 1 MVIS
8 400630140145 400630140183 1 MVIS
9 401650150016 401650150112 1 MVIS
10 402260280014 402260280021 1 MVIS
11 402260280038 402260280045 1 MVIS
12 402720640014 402720640038 1 MVIS
13 402720640014 402720640045 1 MVIS
14 402720640021 402720640052 1 MVIS
15 402720640069 402720640083 1 MVIS
16 402720640069 402720640090 1 MVIS
17 402970200015 402970200077 1 MVIS
18 402970200039 402970200077 1 MVIS
19 402970200039 402970200084 1 MVIS
20 402970200128 402970200197 1 MVIS
21 402970200166 402970200200 1 MVIS
22 402970200262 402970200293 1 MVIS
23 403000160012 403000160036 1 MVIS
24 403000160012 403000160043 1 MVIS
25 403210480046 403210480111 1 MVIS
26 403210480084 403210480128 1 MVIS
27 403210480173 403210480231 1 MVIS
28 403320410025 403320410049 1 MVIS
29 403320410025 403320410056 1 MVIS
30 403320410025 403320410063 1 MVIS
31 403330360014 403330360021 1 MVIS
32 403340270075 403340270119 1 MVIS
33 404130470060 404130470077 1 MVIS
34 404550260205 404550260212 1 MVIS
35 404550260205 404550260229 1 MVIS
36 404550260205 404550260236 1 MVIS
37 404550260205 404550260243 1 MVIS
38 404550260205 404550260250 1 MVIS
39 404550260205 404550260267 1 MVIS
40 404760860037 404760860044 1 MVIS
41 404760860037 404760860051 1 MVIS
42 404770150200 404770150255 1 MVIS
43 404840150029 404840150036 1 MVIS
44 404840150029 404840150043 1 MVIS
45 404840150029 404840150050 1 MVIS
46 405330290011 405330290035 1 MVIS
47 405470360064 405470360088 1 MVIS
48 405540510016 405540510023 1 MVIS
49 405540510016 405540510030 1 MVIS
50 406030880019 406030880026 1 MVIS
HC-059I 07:25 Thursday, March 11, 2004 15
Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids
Obs LINKIDX
1 400150180076
2 400150180083
3 400150180090
4 400150320110
5 400630140152
6 400630140169
7 400630140176
8 400630140183
9 401650150112
10 402260280021
11 402260280045
12 402720640038
13 402720640045
14 402720640052
15 402720640083
16 402720640090
17 402970200077
18 402970200084
19 402970200197
20 402970200200
21 402970200293
22 403000160036
23 403000160043
24 403210480111
25 403210480128
26 403210480231
27 403320410049
28 403320410056
29 403320410063
30 403330360021
31 403340270119
32 404130470077
33 404550260212
34 404550260229
35 404550260236
36 404550260243
37 404550260250
38 404550260267
39 404760860044
40 404760860051
41 404770150255
42 404840150036
43 404840150043
44 404840150050
45 405330290035
46 405470360088
47 405540510023
48 405540510030
49 406030880026
50 406030880033
HC-059I 07:25 Thursday, March 11, 2004 16
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
400150180076 400150180076001 FLOVENT 109.99 6058.14
400150180076002 FLOVENT 109.99 6058.14
400150180076003 FLOVENT 109.99 6058.14
400150180083 400150180083001 SEREVENT DISKUS 92.99 6058.14
400150180083002 SEREVENT DISKUS 92.99 6058.14
400150180090 400150180090001 NEBULIZER 29.09 6058.14
400150320110 400150320110001 SINGULAIR (UNIT OF USE) 94.99 6682.32
400150320110002 SINGULAIR (UNIT OF USE) 94.99 6682.32
400150320110003 SINGULAIR (UNIT OF USE) 94.99 6682.32
400150320110004 SINGULAIR (UNIT OF USE) 94.99 6682.32
400630140152 400630140152001 ALBUTEROL 43.40 13871.65
400630140152002 ALBUTEROL 43.40 13871.65
400630140152003 ALBUTEROL 43.40 13871.65
400630140169 400630140169001 AEROBID 67.01 13871.65
400630140169002 AEROBID 67.01 13871.65
400630140169003 AEROBID 67.01 13871.65
400630140176 400630140176001 CALAN SR (CAPLET) 104.29 13871.65
400630140176002 CALAN SR (CAPLET) 104.29 13871.65
400630140176003 CALAN SR (CAPLET) 104.29 13871.65
400630140183 400630140183001 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140183002 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140183003 SINGULAIR (UNIT OF USE) 165.12 13871.65
401650150112 401650150112001 ALBUTEROL 17.90 5825.09
402260280021 402260280021001 BRONCHO SALINE 11.49 11925.78
402260280045 402260280045001 BRONCHO SALINE 11.49 11925.78
402720640038 402720640038001 RIBAVIRIN 12.00 5630.79
402720640045 402720640045001 TRIMOX 10.66 5630.79
402720640052 402720640052001 AUGMENTIN (ORANGE-RASPBERRY) 38.64 5630.79
402720640083 402720640083001 ZITHROMAX 93.99 5630.79
402720640090 402720640090001 METAPROTERENOL SULFATE (S.F., CHERRY) 10.99 5630.79
402970200077 402970200077001 ASPIRIN/BUTALBITAL/CAFFEINE 32.99 3865.36
402970200084 402970200084001 AEROBID 61.79 3865.36
HC-059I 07:25 Thursday, March 11, 2004 17
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
402970200197 402970200197001 IBUPROFEN 11.00 3865.36
402970200197002 IBUPROFEN 11.00 3865.36
402970200200 402970200200001 PREDNISONE 3.90 3865.36
402970200293 402970200293001 QVAR 52.04 3865.36
403000160036 403000160036001 AEROBID 59.88 6256.73
403000160036002 AEROBID 59.88 6256.73
403000160043 403000160043001 CLARITIN 76.16 6256.73
403000160043002 CLARITIN 76.16 6256.73
403210480111 403210480111001 ZYRTEC 59.37 9525.99
403210480111002 ZYRTEC 59.37 9525.99
403210480111003 ZYRTEC 59.37 9525.99
403210480111004 ZYRTEC 59.37 9525.99
403210480111005 ZYRTEC 59.37 9525.99
403210480111006 ZYRTEC 59.37 9525.99
403210480111007 ZYRTEC 59.37 9525.99
403210480111008 ZYRTEC 59.37 9525.99
403210480128 403210480128001 XOPENEX (P.F.) 50.00 9525.99
403210480128002 XOPENEX (P.F.) 50.00 9525.99
403210480128003 XOPENEX (P.F.) 50.00 9525.99
403210480128004 XOPENEX (P.F.) 50.00 9525.99
403210480128005 XOPENEX (P.F.) 50.00 9525.99
403210480128006 XOPENEX (P.F.) 50.00 9525.99
403210480231 403210480231001 ORAPRED 20.00 9525.99
403320410049 403320410049001 SINGULAIR 96.10 16804.20
403320410056 403320410056001 RYNA-12 S (STRAWBERRY-CURRANT) 33.98 16804.20
403320410063 403320410063001 EXTENDRYL JR 21.59 16804.20
403330360021 403330360021001 ALBUTEROL 24.99 7144.93
403340270119 403340270119001 ADVAIR DISKUS 100/50 94.00 9231.69
404130470077 404130470077001 ALBUTEROL 59.58 10582.91
404550260212 404550260212001 TOPROL XL 10.31 10940.94
404550260212002 TOPROL XL 10.31 10940.94
404550260212003 TOPROL XL 10.31 10940.94
404550260229 404550260229001 ZESTRIL 29.62 10940.94
404550260229002 ZESTRIL 29.62 10940.94
HC-059I 07:25 Thursday, March 11, 2004 18
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
404550260236 404550260236001 ZOLOFT 63.63 10940.94
404550260236002 ZOLOFT 63.63 10940.94
404550260243 404550260243001 ALBUTEROL 14.49 10940.94
404550260243002 ALBUTEROL 14.49 10940.94
404550260250 404550260250001 RHINOCORT 37.09 10940.94
404550260267 404550260267001 PULMICORT TURBUHALER 112.02 10940.94
404550260267002 PULMICORT TURBUHALER 112.02 10940.94
404760860044 404760860044001 PENICILLIN 3.73 12567.27
404760860044002 PENICILLIN 3.73 12567.27
404760860044003 PENICILLIN 3.73 12567.27
404760860051 404760860051001 BRONCHO SALINE 10.29 12567.27
404770150255 404770150255001 AMLODIPINE BESYLATE 3.50 7311.39
404840150036 404840150036001 AZMACORT INHALER 145.10 8327.04
404840150043 404840150043001 ALBUTEROL 59.58 8327.04
404840150050 404840150050001 GUAIFENEX G 10.00 8327.04
405330290035 405330290035001 PREDNISONE 3.90 3431.38
405470360088 405470360088001 BRONCHO SALINE 13.95 10596.70
405540510023 405540510023001 PREDNISOLONE 6.59 4284.67
405540510030 405540510030001 FLOVENT 48.54 4284.67
406030880026 406030880026001 -9 12.27 5767.46
406030880033 406030880033001 AMOXICILLIN 8.62 5767.46
406080560049 406080560049001 ALBUTEROL SULFATE 6.99 12674.24
406490290039 406490290039001 VENTOLIN INHALER 37.30 3874.54
406490290039002 VENTOLIN INHALER 37.30 3874.54
406500250118 406500250118001 PREVACID 106.56 3497.65
406500250118002 PREVACID 106.56 3497.65
406500250125 406500250125001 THEOPHYLLINE 12.39 3497.65
406500250125002 THEOPHYLLINE 12.39 3497.65
406500250132 406500250132001 CLARITIN-D 24 HOUR 74.01 3497.65
HC-059I 07:25 Thursday, March 11, 2004 19
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
406500250132 406500250132002 CLARITIN-D 24 HOUR 74.01 3497.65
406500250149 406500250149001 SINGULAIR (UNIT OF USE) 70.72 3497.65
406500250149002 SINGULAIR (UNIT OF USE) 70.72 3497.65
406500250156 406500250156001 VIOXX 102.24 3497.65
406500250156002 VIOXX 102.24 3497.65
406500250163 406500250163001 SEREVENT 65.76 3497.65
406500250163002 SEREVENT 65.76 3497.65
406500250170 406500250170001 ALBUTEROL 27.67 3497.65
406500250170002 ALBUTEROL 27.67 3497.65
406500250187 406500250187001 HEMOCYTE PLUS (10X10, CHILD PROOF PKG) 14.48 3497.65
406500250187002 HEMOCYTE PLUS (10X10, CHILD PROOF PKG) 14.48 3497.65
406710320071 406710320071001 ADVAIR DISKUS 100/50 103.94 5902.99
406710320088 406710320088001 ALBUTEROL 21.41 5902.99
406740430129 406740430129001 ALBUTEROL 44.79 10203.32
406740430129002 ALBUTEROL 44.79 10203.32
406740430136 406740430136001 ZITHROMAX 27.34 10203.32
406740430136002 ZITHROMAX 27.34 10203.32
406740430143 406740430143001 PULMICORT 141.54 10203.32
406740430167 406740430167001 NASONEX 56.96 10203.32
406900310157 406900310157001 CLARITIN 76.15 12041.71
407090230405 407090230405001 VOLMAX 56.00 11568.99
407090230405002 VOLMAX 56.00 11568.99
407090230412 407090230412001 PREDNISONE 1.06 11568.99
407090230429 407090230429001 AZMACORT 62.20 11568.99
407090230436 407090230436001 SINGULAIR (UNIT OF USE) 82.56 11568.99
407090230436002 SINGULAIR (UNIT OF USE) 82.56 11568.99
407090230436003 SINGULAIR (UNIT OF USE) 82.56 11568.99
407210580105 407210580105001 BRONCHO SALINE 10.29 6256.57
407210580105002 BRONCHO SALINE 10.29 6256.57
407210580105003 BRONCHO SALINE 10.29 6256.57
407210580105004 BRONCHO SALINE 10.29 6256.57
407210580105005 BRONCHO SALINE 10.29 6256.57
HC-059I 07:25 Thursday, March 11, 2004 20
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
407210580167 407210580167001 BRONCHO SALINE 10.29 6256.57
407210580167002 BRONCHO SALINE 10.29 6256.57
407210580167003 BRONCHO SALINE 10.29 6256.57
407210580198 407210580198001 BRONCHO SALINE 10.29 6256.57
407850320048 407850320048001 SINGULAIR 74.33 12502.40
407850320048002 SINGULAIR 74.33 12502.40
407850320055 407850320055001 NASONEX 65.99 12502.40
407850320055002 NASONEX 65.99 12502.40
407850320055003 NASONEX 65.99 12502.40
407850320062 407850320062001 ALLEGRA 33.58 12502.40
407850320062002 ALLEGRA 33.58 12502.40
408040140025 408040140025001 VITAPLEX PLUS 5.00 10253.59
408290380042 408290380042001 ALUPENT 28.73 16114.59
408370160749 408370160749001 ZITHROMAX Z-PAK (3X6) 37.46 18743.69
408370160749002 ZITHROMAX Z-PAK (3X6) 37.46 18743.69
408370160756 408370160756001 METHYLPREDNISOLONE 11.34 18743.69
408630240034 408630240034001 NASONEX 65.99 2337.96
408630240041 408630240041001 ALBUTEROL 16.37 2337.96
408630240041002 ALBUTEROL 16.37 2337.96
408630240041003 ALBUTEROL 16.37 2337.96
408630240041004 ALBUTEROL 16.37 2337.96
408630240041005 ALBUTEROL 16.37 2337.96
408630240058 408630240058001 ADVAIR DISKUS 183.73 2337.96
409050420037 409050420037001 ALBUTEROL 17.99 7103.16
409050420044 409050420044001 CLARITIN 76.16 7103.16
409050420051 409050420051001 AMOXICILLIN 20.36 7103.16
409050420051002 AMOXICILLIN 20.36 7103.16
409050420068 409050420068001 FLONASE 57.71 7103.16
409400130020 409400130020001 INFUSION SET MMT 316 90.00 6041.80
409400130020002 INFUSION SET MMT 316 90.00 6041.80
409400130020003 INFUSION SET MMT 316 90.00 6041.80
409400130037 409400130037001 METHYLPREDNISOLONE (UNIT OF USE) 12.70 6041.80
HC-059I 07:25 Thursday, March 11, 2004 21
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
409400130037 409400130037002 METHYLPREDNISOLONE (UNIT OF USE) 12.70 6041.80
409400130037003 METHYLPREDNISOLONE (UNIT OF USE) 12.70 6041.80
409400130044 409400130044001 ALBUTEROL 24.27 6041.80
409400130044002 ALBUTEROL 24.27 6041.80
409400130044003 ALBUTEROL 24.27 6041.80
409400130051 409400130051001 ASPIRIN/CARISOPRODOL 18.75 6041.80
409400130051002 ASPIRIN/CARISOPRODOL 18.75 6041.80
409400130051003 ASPIRIN/CARISOPRODOL 18.75 6041.80
409400130051004 ASPIRIN/CARISOPRODOL 18.75 6041.80
409410200562 409410200562001 ALBUTEROL 23.49 12230.92
409410200579 409410200579001 ALBUTEROL SULFATE 8.99 12230.92
409410200586 409410200586001 IMITREX 213.77 12230.92
409410200593 409410200593001 ATROVENT 43.55 12230.92
409410200606 409410200606001 SEREVENT 69.54 12230.92
409410200613 409410200613001 LORAZEPAM 16.95 12230.92
409490140139 409490140139001 ATROVENT 40.58 10288.22
409490140139002 ATROVENT 40.58 10288.22
409490140146 409490140146001 GUAIFENESIN/PHENYLPROPANOLAMINE 9.75 10288.22
409490140146002 GUAIFENESIN/PHENYLPROPANOLAMINE 9.75 10288.22
409490140540 409490140540001 APAP/HYDROCODONE BITARTRATE 29.89 10288.22
409490140540002 APAP/HYDROCODONE BITARTRATE 29.89 10288.22
409490140540003 APAP/HYDROCODONE BITARTRATE 29.89 10288.22
409490140540004 APAP/HYDROCODONE BITARTRATE 29.89 10288.22
409490140557 409490140557001 ATROVENT 40.58 10288.22
409490140557002 ATROVENT 40.58 10288.22
409490140557003 ATROVENT 40.58 10288.22
409490140557004 ATROVENT 40.58 10288.22
409490140564 409490140564001 GUAIFENESIN/PHENYLPROPANOLAMINE 9.75 10288.22
409490140564002 GUAIFENESIN/PHENYLPROPANOLAMINE 9.75 10288.22
409490140564003 GUAIFENESIN/PHENYLPROPANOLAMINE 9.75 10288.22
409490140564004 GUAIFENESIN/PHENYLPROPANOLAMINE 9.75 10288.22
409490140571 409490140571001 LORAZEPAM 23.80 10288.22
409490140571002 LORAZEPAM 23.80 10288.22
409490140571003 LORAZEPAM 23.80 10288.22
409490140571004 LORAZEPAM 23.80 10288.22
HC-059I 07:25 Thursday, March 11, 2004 22
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
409490140588 409490140588001 MECLIZINE HCL 7.79 10288.22
409490140588002 MECLIZINE HCL 7.79 10288.22
409490140588003 MECLIZINE HCL 7.79 10288.22
409490140588004 MECLIZINE HCL 7.79 10288.22
409490140595 409490140595001 QUININE SULFATE 7.91 10288.22
409490140595002 QUININE SULFATE 7.91 10288.22
HC-059I 07:25 Thursday, March 11, 2004 23
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
The MEANS Procedure
Analysis Variable : RXXP01X SUM OF PAYMENTS RXSF01X-RXOU01X(IMPUTED)
N Sum
--------------------
4599 239286.30
--------------------
HC-059I 07:25 Thursday, March 11, 2004 24
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP01X SUM OF PAYMENTS RXSF01X-RXOU01X(IMPUTED)
N Sum
--------------------
4599 2132677425
--------------------
1 The SAS System 07:35 Thursday, March 11, 2004
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX07.
NOTE: SAS initialization used:
real time 4.89 seconds
cpu time 0.67 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-059I";
4 TITLE2 'Sample SAS Job for Example B';
5
6 LIBNAME IN 'C:\data';
NOTE: Libref IN was successfully assigned as follows:
Engine: V8
Physical Name: C:\data
7
8 **************************************************************************************
9 * Calculate the expenditures for prescribed medicines associated with asthma.
10 **************************************************************************************;
11 PROC FORMAT;
12 VALUE EVENTYPE
13 1 = "1 MVIS"
14 2 = "2 OPAT"
15 3 = "3 EROM"
16 4 = "4 STAZ"
17 5 = "5 DVIS"
18 6 = "6 OMED"
19 7 = "7 HVIS"
20 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
21 RUN;
NOTE: PROCEDURE FORMAT used:
real time 0.12 seconds
cpu time 0.03 seconds
22
23 *--------------------------------------------------------------------------------------
24 * Get condition records coded as asthma.
25 *--------------------------------------------------------------------------------------;
2 The SAS System 07:35 Thursday, March 11, 2004
26 DATA ASCONDS;
27 SET IN.H61 (KEEP=CONDIDX CCCODEX);
28 IF CCCODEX="128";
29 RUN;
NOTE: There were 102489 observations read from the data set IN.H61.
NOTE: The data set WORK.ASCONDS has 1695 observations and 2 variables.
NOTE: DATA statement used:
real time 1.87 seconds
cpu time 0.21 seconds
30
31 *--------------------------------------------------------------------------
32 * Get the events linked to each of the asthma condition records.
33 *--------------------------------------------------------------------------;
34 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 1695 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1695 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.06 seconds
cpu time 0.00 seconds
35
36 proc print data=asconds (obs=50);
37 title3 "sample print of work.asconds - sorted by condidx";
38 title4 "COND (H61) 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.00 seconds
40
41 PROC SORT DATA=IN.H59IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 314599 observations read from the data set IN.H59IF1.
NOTE: The data set WORK.CLNK has 314599 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 3.56 seconds
cpu time 1.57 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 07:35 Thursday, March 11, 2004
NOTE: There were 314599 observations read from the data set WORK.CLNK.
NOTE: There were 1695 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7046 observations and 3 variables.
NOTE: DATA statement used:
real time 0.46 seconds
cpu time 0.43 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.03 seconds
57
58 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7046 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7046 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.04 seconds
cpu time 0.03 seconds
59
60 proc print data=asclnks (obs=50);
61 format eventype eventype.;
62 title3 "sample print of work.asclnks - sorted by evntidx";
63 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.01 seconds
64
65 DATA ASCLNKS;
66 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
67 BY EVNTIDX;
68 IF FIRST.EVNTIDX;
69 RUN;
NOTE: There were 7046 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7033 observations and 2 variables.
4 The SAS System 07:35 Thursday, March 11, 2004
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.01 seconds
70
71 proc print data=asclnks (obs=50);
72 format eventype eventype.;
73 title3 "sample print of unique evntidxs from work.asclnks";
74 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.00 seconds
75
76 *-------------------------------------------------------------------------------
77 * Get PMED records linked to asthma condition records.
78 *-------------------------------------------------------------------------------;
79 PROC SORT DATA=IN.H59A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 277866 observations read from the data set IN.H59A.
NOTE: The data set WORK.PMED has 277866 observations and 74 variables.
NOTE: PROCEDURE SORT used:
real time 2:51.98
cpu time 20.46 seconds
80
81 DATA ASPMEDS;
82 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F)
83 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX RENAME=(EVNTIDX=LINKIDX));
84 BY LINKIDX;
85 IF INASCLNK & PERWT01F>0;
86 RUN;
NOTE: There were 277866 observations read from the data set WORK.PMED.
NOTE: There were 7033 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 9476 observations and 5 variables.
NOTE: DATA statement used:
real time 6.59 seconds
cpu time 0.76 seconds
87
88 proc print data=aspmeds (obs=300);
89 by linkidx;
90 id linkidx;
91 var rxrecidx rxname RXXP01X PERWT01F;
92 title3 "sample print of work.aspmeds";
93 title4 "PMED (HC-059A) records which link to condition records coded as asthma";
94 run;
NOTE: There were 300 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE PRINT printed pages 6-15.
5 The SAS System 07:35 Thursday, March 11, 2004
NOTE: PROCEDURE PRINT used:
real time 0.12 seconds
cpu time 0.01 seconds
95
96 PROC MEANS DATA=ASPMEDS N SUM;
97 VAR RXXP01X;
98 TITLE3 "Total Rx expenditures associated with asthma";
99 RUN;
NOTE: There were 9476 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 16.
NOTE: PROCEDURE MEANS used:
real time 0.17 seconds
cpu time 0.03 seconds
100
101 PROC MEANS DATA=ASPMEDS N SUM;
102 VAR RXXP01X;
103 WEIGHT PERWT01F;
104 TITLE3 "Total Rx expenditures associated with asthma";
105 TITLE5 "Weighted";
106 RUN;
NOTE: There were 9476 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 17.
NOTE: PROCEDURE MEANS used:
real time 0.01 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 3:11.21
cpu time 24.38 seconds
HC-059I 07:35 Thursday, March 11, 2004 1
Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H61) records where cccodex=128
Obs CONDIDX CCCODEX
1 400060150010 128
2 400060220025 128
3 400100460013 128
4 400120250093 128
5 400150180047 128
6 400150320017 128
7 400420120055 128
8 400500160056 128
9 400630140015 128
10 400670280087 128
11 400700390037 128
12 400830280016 128
13 400840180025 128
14 400840320017 128
15 400850110076 128
16 400990200047 128
17 401160130036 128
18 401650150017 128
19 401700450040 128
20 401710240020 128
21 401840370020 128
22 401870110028 128
23 401870350010 128
24 402060410053 128
25 402160430011 128
26 402160660010 128
27 402190190014 128
28 402260280015 128
29 402350120018 128
30 402530190024 128
31 402720640014 128
32 402740320012 128
33 402970200016 128
34 403000160011 128
35 403110150117 128
36 403210170016 128
37 403210480013 128
38 403230280069 128
39 403320410016 128
40 403330360012 128
41 403340270061 128
42 403510210075 128
43 403860370035 128
44 404130470038 128
45 404210160041 128
46 404550260035 128
47 404670140024 128
48 404760860025 128
49 404770150034 128
50 404790560018 128
HC-059I 07:35 Thursday, March 11, 2004 2
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
400100460013 400100460012 8 PMED
400100460029 8 PMED
400100460036 8 PMED
400100460043 8 PMED
400120250093 400120250196 8 PMED
400150180047 400150180038 1 MVIS
400150180076 8 PMED
400150180083 8 PMED
400150180090 8 PMED
400150180463 1 MVIS
400150180470 1 MVIS
400150180507 8 PMED
400150320017 400150320014 1 MVIS
400150320021 1 MVIS
400150320038 1 MVIS
400150320045 1 MVIS
400150320052 1 MVIS
400150320069 1 MVIS
400150320090 1 MVIS
400150320103 1 MVIS
400150320110 8 PMED
400420120055 400420120077 8 PMED
400420120180 8 PMED
400500160056 400500160080 8 PMED
400500160097 8 PMED
400630140015 400630140025 1 MVIS
400630140049 4 STAZ
400630140056 3 EROM
400630140070 8 PMED
400630140087 8 PMED
400630140107 8 PMED
400630140145 1 MVIS
400630140152 8 PMED
400630140169 8 PMED
400630140183 8 PMED
400630140227 8 PMED
400630140234 8 PMED
400630140258 8 PMED
400670280087 400670280130 8 PMED
400670280147 8 PMED
400670280154 8 PMED
400670280161 8 PMED
HC-059I 07:35 Thursday, March 11, 2004 3
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
400670280087 400670280250 8 PMED
400700390037 400700390041 8 PMED
400830280016 400830280011 8 PMED
400840180025 400840180019 2 OPAT
400840180040 2 OPAT
400840180095 8 PMED
400840180108 8 PMED
400840180115 8 PMED
400840180122 8 PMED
400840180146 1 MVIS
400840180204 8 PMED
400840180211 8 PMED
400840180228 8 PMED
400840180259 8 PMED
400840180297 2 OPAT
400840180300 2 OPAT
400840180317 2 OPAT
400840180331 2 OPAT
400840180379 8 PMED
400840180386 8 PMED
400840180393 8 PMED
400840320017 400840320026 2 OPAT
400840320033 2 OPAT
400840320191 2 OPAT
400850110076 400850110226 8 PMED
400850110308 1 MVIS
400850110315 1 MVIS
400850110322 1 MVIS
400850110360 1 MVIS
400850110377 1 MVIS
400850110428 8 PMED
400850110435 8 PMED
400990200047 400990200092 8 PMED
HC-059I 07:35 Thursday, March 11, 2004 4
Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 400100460013 400100460012 8 PMED
2 400100460013 400100460029 8 PMED
3 400100460013 400100460036 8 PMED
4 400100460013 400100460043 8 PMED
5 400120250093 400120250196 8 PMED
6 400150180047 400150180038 1 MVIS
7 400150180047 400150180076 8 PMED
8 400150180047 400150180083 8 PMED
9 400150180047 400150180090 8 PMED
10 400150180047 400150180463 1 MVIS
11 400150180047 400150180470 1 MVIS
12 400150180047 400150180507 8 PMED
13 400150320017 400150320014 1 MVIS
14 400150320017 400150320021 1 MVIS
15 400150320017 400150320038 1 MVIS
16 400150320017 400150320045 1 MVIS
17 400150320017 400150320052 1 MVIS
18 400150320017 400150320069 1 MVIS
19 400150320017 400150320090 1 MVIS
20 400150320017 400150320103 1 MVIS
21 400150320017 400150320110 8 PMED
22 400420120055 400420120077 8 PMED
23 400420120055 400420120180 8 PMED
24 400500160056 400500160080 8 PMED
25 400500160056 400500160097 8 PMED
26 400630140015 400630140025 1 MVIS
27 400630140015 400630140049 4 STAZ
28 400630140015 400630140056 3 EROM
29 400630140015 400630140070 8 PMED
30 400630140015 400630140087 8 PMED
31 400630140015 400630140107 8 PMED
32 400630140015 400630140145 1 MVIS
33 400630140015 400630140152 8 PMED
34 400630140015 400630140169 8 PMED
35 400630140015 400630140183 8 PMED
36 400630140015 400630140227 8 PMED
37 400630140015 400630140234 8 PMED
38 400630140015 400630140258 8 PMED
39 400670280087 400670280130 8 PMED
40 400670280087 400670280147 8 PMED
41 400670280087 400670280154 8 PMED
42 400670280087 400670280161 8 PMED
43 400670280087 400670280250 8 PMED
44 400700390037 400700390041 8 PMED
45 400830280016 400830280011 8 PMED
46 400840180025 400840180019 2 OPAT
47 400840180025 400840180040 2 OPAT
48 400840180025 400840180095 8 PMED
49 400840180025 400840180108 8 PMED
50 400840180025 400840180115 8 PMED
HC-059I 07:35 Thursday, March 11, 2004 5
Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 400100460012 8 PMED
2 400100460029 8 PMED
3 400100460036 8 PMED
4 400100460043 8 PMED
5 400120250196 8 PMED
6 400150180038 1 MVIS
7 400150180076 8 PMED
8 400150180083 8 PMED
9 400150180090 8 PMED
10 400150180463 1 MVIS
11 400150180470 1 MVIS
12 400150180507 8 PMED
13 400150320014 1 MVIS
14 400150320021 1 MVIS
15 400150320038 1 MVIS
16 400150320045 1 MVIS
17 400150320052 1 MVIS
18 400150320069 1 MVIS
19 400150320090 1 MVIS
20 400150320103 1 MVIS
21 400150320110 8 PMED
22 400420120077 8 PMED
23 400420120180 8 PMED
24 400500160080 8 PMED
25 400500160097 8 PMED
26 400630140025 1 MVIS
27 400630140049 4 STAZ
28 400630140056 3 EROM
29 400630140070 8 PMED
30 400630140087 8 PMED
31 400630140107 8 PMED
32 400630140145 1 MVIS
33 400630140152 8 PMED
34 400630140169 8 PMED
35 400630140183 8 PMED
36 400630140227 8 PMED
37 400630140234 8 PMED
38 400630140258 8 PMED
39 400670280130 8 PMED
40 400670280147 8 PMED
41 400670280154 8 PMED
42 400670280161 8 PMED
43 400670280250 8 PMED
44 400700390041 8 PMED
45 400830280011 8 PMED
46 400840180019 2 OPAT
47 400840180040 2 OPAT
48 400840180095 8 PMED
49 400840180108 8 PMED
50 400840180115 8 PMED
HC-059I 07:35 Thursday, March 11, 2004 6
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-059A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
400100460012 400100460012001 CLARITIN 76.16 18432.19
400100460012002 CLARITIN 76.16 18432.19
400100460029 400100460029001 ALBUTEROL 17.98 18432.19
400100460036 400100460036001 NASACORT AQ 45.98 18432.19
400100460043 400100460043001 BUTISOL SODIUM 7.47 18432.19
400120250196 400120250196001 ALBUTEROL 23.98 13391.24
400150180076 400150180076001 FLOVENT 109.99 6058.14
400150180076002 FLOVENT 109.99 6058.14
400150180076003 FLOVENT 109.99 6058.14
400150180083 400150180083001 SEREVENT DISKUS 92.99 6058.14
400150180083002 SEREVENT DISKUS 92.99 6058.14
400150180090 400150180090001 NEBULIZER 29.09 6058.14
400150180507 400150180507001 SINGULAIR 100.98 6058.14
400150180507002 SINGULAIR 100.98 6058.14
400150320110 400150320110001 SINGULAIR (UNIT OF USE) 94.99 6682.32
400150320110002 SINGULAIR (UNIT OF USE) 94.99 6682.32
400150320110003 SINGULAIR (UNIT OF USE) 94.99 6682.32
400150320110004 SINGULAIR (UNIT OF USE) 94.99 6682.32
400420120077 400420120077001 ADMIN.SET 16.85 7548.34
400420120077002 ADMIN.SET 16.85 7548.34
400420120077003 ADMIN.SET 16.85 7548.34
400420120077004 ADMIN.SET 16.85 7548.34
400420120077005 ADMIN.SET 16.85 7548.34
400420120077006 ADMIN.SET 16.85 7548.34
400420120180 400420120180001 ADMIN.SET 16.85 7548.34
400420120180002 ADMIN.SET 16.85 7548.34
400420120180003 ADMIN.SET 16.85 7548.34
400420120180004 ADMIN.SET 16.85 7548.34
400500160080 400500160080001 ALBUTEROL 16.37 7713.59
400500160080002 ALBUTEROL 16.37 7713.59
400500160080003 ALBUTEROL 16.37 7713.59
400500160080004 ALBUTEROL 16.37 7713.59
400500160080005 ALBUTEROL 16.37 7713.59
400500160097 400500160097001 FLOVENT 49.30 7713.59
400500160097002 FLOVENT 49.30 7713.59
400500160097003 FLOVENT 49.30 7713.59
HC-059I 07:35 Thursday, March 11, 2004 7
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-059A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
400500160097 400500160097004 FLOVENT 49.30 7713.59
400500160097005 FLOVENT 49.30 7713.59
400630140070 400630140070001 ALBUTEROL 67.44 13871.65
400630140070002 ALBUTEROL 67.44 13871.65
400630140087 400630140087001 AEROBID 67.01 13871.65
400630140087002 AEROBID 67.01 13871.65
400630140087003 AEROBID 67.01 13871.65
400630140107 400630140107001 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140107002 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140107003 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140107004 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140107005 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140107006 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140152 400630140152001 ALBUTEROL 43.40 13871.65
400630140152002 ALBUTEROL 43.40 13871.65
400630140152003 ALBUTEROL 43.40 13871.65
400630140169 400630140169001 AEROBID 67.01 13871.65
400630140169002 AEROBID 67.01 13871.65
400630140169003 AEROBID 67.01 13871.65
400630140183 400630140183001 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140183002 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140183003 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140227 400630140227001 ALBUTEROL 42.82 13871.65
400630140227002 ALBUTEROL 42.82 13871.65
400630140234 400630140234001 AEROBID 67.01 13871.65
400630140234002 AEROBID 67.01 13871.65
400630140234003 AEROBID 67.01 13871.65
400630140234004 AEROBID 67.01 13871.65
400630140234005 AEROBID 67.01 13871.65
400630140258 400630140258001 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140258002 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140258003 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140258004 SINGULAIR (UNIT OF USE) 165.12 13871.65
400630140258005 SINGULAIR (UNIT OF USE) 165.12 13871.65
400670280130 400670280130001 CHERATUSSIN AC 11.69 6858.69
400670280147 400670280147001 CLARITIN 77.50 6858.69
400670280154 400670280154001 ADVAIR DISKUS 500/50 164.45 6858.69
HC-059I 07:35 Thursday, March 11, 2004 8
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-059A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
400670280161 400670280161001 FLONASE 65.99 6858.69
400670280250 400670280250001 FLONASE 56.33 6858.69
400700390041 400700390041001 ALBUTEROL 74.99 17280.79
400830280011 400830280011001 ACCOLATE 58.74 2114.22
400840180095 400840180095001 ALBUTEROL 26.92 4082.26
400840180095002 ALBUTEROL 26.92 4082.26
400840180108 400840180108001 FLOVENT 109.99 4082.26
400840180108002 FLOVENT 109.99 4082.26
400840180115 400840180115001 SEREVENT 71.99 4082.26
400840180115002 SEREVENT 71.99 4082.26
400840180122 400840180122001 ALBUTEROL 37.50 4082.26
400840180204 400840180204001 ALBUTEROL 26.92 4082.26
400840180204002 ALBUTEROL 26.92 4082.26
400840180211 400840180211001 FLOVENT 109.99 4082.26
400840180211002 FLOVENT 109.99 4082.26
400840180228 400840180228001 ALBUTEROL 222.03 4082.26
400840180259 400840180259001 FLOVENT 59.87 4082.26
400840180379 400840180379001 ALBUTEROL 26.92 4082.26
400840180379002 ALBUTEROL 26.92 4082.26
400840180386 400840180386001 FLOVENT 109.99 4082.26
400840180386002 FLOVENT 109.99 4082.26
400840180393 400840180393001 SEREVENT 71.99 4082.26
400840180393002 SEREVENT 71.99 4082.26
400850110226 400850110226001 ALBUTEROL 86.10 6763.21
400850110226002 ALBUTEROL 86.10 6763.21
400850110428 400850110428001 ATROVENT 35.20 6763.21
400850110435 400850110435001 ALBUTEROL 86.10 6763.21
400850110435002 ALBUTEROL 86.10 6763.21
400990200092 400990200092001 ALBUTEROL 16.37 6205.83
400990200092002 ALBUTEROL 16.37 6205.83
400990200092003 ALBUTEROL 16.37 6205.83
HC-059I 07:35 Thursday, March 11, 2004 9
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-059A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
400990200092 400990200092004 ALBUTEROL 16.37 6205.83
400990200105 400990200105001 SEREVENT 71.99 6205.83
400990200105002 SEREVENT 71.99 6205.83
400990200105003 SEREVENT 71.99 6205.83
400990200112 400990200112001 AZMACORT 77.99 6205.83
400990200112002 AZMACORT 77.99 6205.83
400990200112003 AZMACORT 77.99 6205.83
400990200112004 AZMACORT 77.99 6205.83
401160130055 401160130055001 ALBUTEROL 26.49 10620.03
401650150112 401650150112001 ALBUTEROL 17.90 5825.09
401650150129 401650150129001 VANCERIL 50.99 5825.09
401650150150 401650150150001 CIPRO (W/DILUENT) 75.01 5825.09
401650150167 401650150167001 COMBIVENT 49.99 5825.09
401710240056 401710240056001 AZMACORT 54.62 14299.90
401710240056002 AZMACORT 54.62 14299.90
401710240063 401710240063001 ALBUTEROL 11.90 14299.90
401840370052 401840370052001 SINGULAIR 96.10 9506.64
401840370076 401840370076001 MAXAIR 60.18 9506.64
401840370083 401840370083001 RHINOCORT 35.08 9506.64
401840370090 401840370090001 SEREVENT 66.64 9506.64
401840370103 401840370103001 PROVENTIL HFA (M.D.I.) 82.64 9506.64
401870110068 401870110068001 PROVENTIL 21.41 6441.33
401870350037 401870350037001 ALBUTEROL 22.98 6999.50
401870350119 401870350119001 ALBUTEROL 22.98 6999.50
402060410211 402060410211001 BRONCHO SALINE 10.29 19450.46
402160660044 402160660044001 PANFIL G 47.98 1238.52
402160660044002 PANFIL G 47.98 1238.52
402160660044003 PANFIL G 47.98 1238.52
402160660044004 PANFIL G 47.98 1238.52
HC-059I 07:35 Thursday, March 11, 2004 10
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-059A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
402160660075 402160660075001 PANFIL G 47.98 1238.52
402160660119 402160660119001 PANFIL G 47.98 1238.52
402160660119002 PANFIL G 47.98 1238.52
402160660119003 PANFIL G 47.98 1238.52
402160660119004 PANFIL G 47.98 1238.52
402190190034 402190190034001 ALBUTEROL 22.95 4294.92
402190190041 402190190041001 ZITHROMAX 67.75 4294.92
402190190058 402190190058001 ATROVENT 43.55 4294.92
402260280021 402260280021001 BRONCHO SALINE 11.49 11925.78
402260280045 402260280045001 BRONCHO SALINE 11.49 11925.78
402350120011 402350120011001 SINGULAIR (UNIT OF USE) 71.20 9259.38
402350120011002 SINGULAIR (UNIT OF USE) 71.20 9259.38
402350120011003 SINGULAIR (UNIT OF USE) 71.20 9259.38
402530190101 402530190101001 FLONASE 52.21 5804.97
402530190101002 FLONASE 52.21 5804.97
402530190118 402530190118001 COMBIVENT 89.05 5804.97
402530190118002 COMBIVENT 89.05 5804.97
402530190221 402530190221001 FLONASE 52.21 5804.97
402530190221002 FLONASE 52.21 5804.97
402530190221003 FLONASE 52.21 5804.97
402530190221004 FLONASE 52.21 5804.97
402530190221005 FLONASE 52.21 5804.97
402530190238 402530190238001 COMBIVENT 89.05 5804.97
402530190238002 COMBIVENT 89.05 5804.97
402530190238003 COMBIVENT 89.05 5804.97
402530190238004 COMBIVENT 89.05 5804.97
402530190238005 COMBIVENT 89.05 5804.97
402720640038 402720640038001 RIBAVIRIN 12.00 5630.79
402720640090 402720640090001 METAPROTERENOL SULFATE (S.F., CHERRY) 10.99 5630.79
402740320020 402740320020001 ALBUTEROL 42.82 8602.34
402740320044 402740320044001 ALBUTEROL 26.49 8602.34
402970200077 402970200077001 ASPIRIN/BUTALBITAL/CAFFEINE 32.99 3865.36
HC-059I 07:35 Thursday, March 11, 2004 11
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-059A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
402970200084 402970200084001 AEROBID 61.79 3865.36
402970200091 402970200091001 ALBUTEROL 23.69 3865.36
402970200104 402970200104001 GUAIFENESIN 9.99 3865.36
402970200111 402970200111001 FLUNISOLIDE 152.12 3865.36
402970200200 402970200200001 PREDNISONE 3.90 3865.36
402970200224 402970200224001 ALBUTEROL 23.69 3865.36
402970200224002 ALBUTEROL 23.69 3865.36
402970200224003 ALBUTEROL 23.69 3865.36
402970200231 402970200231001 GUAIFENESIN 9.99 3865.36
402970200293 402970200293001 QVAR 52.04 3865.36
402970200320 402970200320001 ALBUTEROL 23.69 3865.36
402970200344 402970200344001 CLOTRIMAZOLE 29.96 3865.36
403000160036 403000160036001 AEROBID 59.88 6256.73
403000160036002 AEROBID 59.88 6256.73
403000160043 403000160043001 CLARITIN 76.16 6256.73
403000160043002 CLARITIN 76.16 6256.73
403110150675 403110150675001 THEOPHYLLINE 9.54 5459.30
403110150675002 THEOPHYLLINE 9.54 5459.30
403110150675003 THEOPHYLLINE 9.54 5459.30
403110150675004 THEOPHYLLINE 9.54 5459.30
403110150675005 THEOPHYLLINE 9.54 5459.30
403110150702 403110150702001 ALBUTEROL SULFATE (MDV) 59.96 5459.30
403110150702002 ALBUTEROL SULFATE (MDV) 59.96 5459.30
403110150702003 ALBUTEROL SULFATE (MDV) 59.96 5459.30
403110150702004 ALBUTEROL SULFATE (MDV) 59.96 5459.30
403110150702005 ALBUTEROL SULFATE (MDV) 59.96 5459.30
403110150702006 ALBUTEROL SULFATE (MDV) 59.96 5459.30
403210480022 403210480022001 IPRATROPIUM 41.90 9525.99
403210480039 403210480039001 CROMOLYN 6.00 9525.99
403210480128 403210480128001 XOPENEX (P.F.) 50.00 9525.99
403210480128002 XOPENEX (P.F.) 50.00 9525.99
403210480128003 XOPENEX (P.F.) 50.00 9525.99
403210480128004 XOPENEX (P.F.) 50.00 9525.99
HC-059I 07:35 Thursday, March 11, 2004 12
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-059A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
403210480128 403210480128005 XOPENEX (P.F.) 50.00 9525.99
403210480128006 XOPENEX (P.F.) 50.00 9525.99
403210480135 403210480135001 IPRATROPIUM 41.90 9525.99
403210480135002 IPRATROPIUM 41.90 9525.99
403210480142 403210480142001 ALBUTEROL 19.62 9525.99
403210480142002 ALBUTEROL 19.62 9525.99
403210480159 403210480159001 SINGULAIR 96.10 9525.99
403210480159002 SINGULAIR 96.10 9525.99
403210480159003 SINGULAIR 96.10 9525.99
403210480159004 SINGULAIR 96.10 9525.99
403210480159005 SINGULAIR 96.10 9525.99
403210480166 403210480166001 PULMICORT 230.30 9525.99
403210480166002 PULMICORT 230.30 9525.99
403210480231 403210480231001 ORAPRED 20.00 9525.99
403210480255 403210480255001 OMNICEF 105.99 9525.99
403210480279 403210480279001 XOPENEX (P.F.) 50.00 9525.99
403210480286 403210480286001 PULMICORT 230.30 9525.99403210480306 403210480306001 SINGULAIR 96.10 9525.99
403230280075 403230280075001 AZMACORT 72.55 19457.74403230280082 403230280082001 VITAPLEX PLUS 10.25 19457.74
403230280208 403230280208001 AZMACORT 126.24 19457.74
403230280215 403230280215001 VITAPLEX PLUS 10.25 19457.74
403320410049 403320410049001 SINGULAIR 96.10 16804.20
403320410063 403320410063001 EXTENDRYL JR 21.59 16804.20
403330360021 403330360021001 ALBUTEROL 24.99 7144.93
403340270119 403340270119001 ADVAIR DISKUS 100/50 94.00 9231.69
403860370031 403860370031001 COMBIVENT 42.34 7978.76
403860370031002 COMBIVENT 42.34 7978.76
403860370048 403860370048001 ALBUTEROL 19.63 7978.76
403860370048002 ALBUTEROL 19.63 7978.76
HC-059I 07:35 Thursday, March 11, 2004 13
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-059A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
404130470046 404130470046001 TRIPLE ANTIBIOTIC 7.02 10582.91404130470053 404130470053001 ALBUTEROL 25.35 10582.91
404130470077 404130470077001 ALBUTEROL 59.58 10582.91
404550260116 404550260116001 PULMICORT TURBUHALER 111.50 10940.94
404550260116002 PULMICORT TURBUHALER 111.50 10940.94
404550260123 404550260123001 ALBUTEROL 14.49 10940.94
404550260123002 ALBUTEROL 14.49 10940.94404550260185 404550260185001 PULMICORT TURBUHALER 112.02 10940.94
404550260185002 PULMICORT TURBUHALER 112.02 10940.94
404550260192 404550260192001 ALBUTEROL 14.49 10940.94
404550260192002 ALBUTEROL 14.49 10940.94
404550260243 404550260243001 ALBUTEROL 14.49 10940.94
404550260243002 ALBUTEROL 14.49 10940.94
404550260267 404550260267001 PULMICORT TURBUHALER 112.02 10940.94
404550260267002 PULMICORT TURBUHALER 112.02 10940.94
404670140171 404670140171001 ALBUTEROL 21.41 7082.79
404760860051 404760860051001 BRONCHO SALINE 10.29 12567.27
404770150084 404770150084001 ALBUTEROL/IPRATROP 39.97 7311.39
404770150084002 ALBUTEROL/IPRATROP 39.97 7311.39
404770150091 404770150091001 ALBUTEROL SULFATE 65.52 7311.39
404770150142 404770150142001 ORAPRED 20.00 7311.39
404770150166 404770150166001 SALMETEROL 7.01 7311.39
404770150166002 SALMETEROL 7.01 7311.39
404770150166003 SALMETEROL 7.01 7311.39
404770150197 404770150197001 N/F ZAFIRLUKAST 2.00 7311.39
404770150197002 N/F ZAFIRLUKAST 2.00 7311.39
404770150197003 N/F ZAFIRLUKAST 2.00 7311.39
404770150255 404770150255001 AMLODIPINE BESYLATE 3.50 7311.39
404770150262 404770150262001 ALBUTEROL 44.97 7311.39
404770150279 404770150279001 ALBUTEROL SULFATE 31.05 7311.39
HC-059I 07:35 Thursday, March 11, 2004 14
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-059A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
404770150337 404770150337001 SALMETEROL 7.01 7311.39
404770150368 404770150368001 N/F ZAFIRLUKAST 167.58 7311.39
404770150659 404770150659001 ALBUTEROL 44.97 7311.39
404770150659002 ALBUTEROL 44.97 7311.39
404770150659003 ALBUTEROL 44.97 7311.39404770150666 404770150666001 ALBUTEROL 63.60 7311.39
404770150666002 ALBUTEROL 63.60 7311.39
404770150666003 ALBUTEROL 63.60 7311.39
404770150673 404770150673001 SALMETEROL 7.01 7311.39
404770150673002 SALMETEROL 7.01 7311.39
404770150673003 SALMETEROL 7.01 7311.39
404770150680 404770150680001 IPRATROPIUM BROMIDE 138.96 7311.39
404770150680002 IPRATROPIUM BROMIDE 138.96 7311.39
404770150680003 IPRATROPIUM BROMIDE 138.96 7311.39
404770150680004 IPRATROPIUM BROMIDE 138.96 7311.39
404840150036 404840150036001 AZMACORT INHALER 145.10 8327.04
404840150043 404840150043001 ALBUTEROL 59.58 8327.04
404840150050 404840150050001 GUAIFENEX G 10.00 8327.04
404870470033 404870470033001 ALBUTEROL 22.98 5910.14
404870470033002 ALBUTEROL 22.98 5910.14404870470040 404870470040001 CROMOLYN 6.00 5910.14
404870470040002 CROMOLYN 6.00 5910.14
404870470057 404870470057001 ORAPRED 19.90 5910.14
405260140244 405260140244001 PREDNISONE 7.56 9722.48
405260140251 405260140251001 COMBIVENT 42.34 9722.48
405260140251002 COMBIVENT 42.34 9722.48
405260140268 405260140268001 ZYBAN 98.94 9722.48
405260140268002 ZYBAN 98.94 9722.48
405260140333 405260140333001 COMBIVENT 50.99 9722.48
405260140333002 COMBIVENT 50.99 9722.48
405330290035 405330290035001 PREDNISONE 3.90 3431.38
405340590045 405340590045001 ALBUTERAL 18.75 15607.85
HC-059I 07:35 Thursday, March 11, 2004 15
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-059A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
405340590052 405340590052001 SODIUM CHLORIDE 0.9% SYRINGE 131.25 15607.85
405400350081 405400350081001 ALBUTEROL 11.52 8490.21
405400350098 405400350098001 FLOVENT 59.19 8490.21
405400650051 405400650051001 SEREVENT 73.00 7915.97
405440370013 405440370013001 SINGULAIR (UNIT OF USE) 30.00 10460.24
405440370020 405440370020001 CLARITIN-D 28.60 10460.24
405440370037 405440370037001 FLOVENT 59.19 10460.24
405440370037002 FLOVENT 59.19 10460.24
405440370037003 FLOVENT 59.19 10460.24
405440370037004 FLOVENT 59.19 10460.24
HC-059I 07:35 Thursday, March 11, 2004 16
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
The MEANS Procedure
Analysis Variable : RXXP01X SUM OF PAYMENTS RXSF01X-RXOU01X(IMPUTED)
N Sum
--------------------
9476 508340.96
--------------------
HC-059I 07:35 Thursday, March 11, 2004 17
Total Rx expenditures associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP01X SUM OF PAYMENTS RXSF01X-RXOU01X(IMPUTED)
N Sum
--------------------
9476 4589918293
--------------------
1 The SAS System 07:40 Thursday, March 11, 2004
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX07.
NOTE: SAS initialization used:
real time 4.17 seconds
cpu time 0.42 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-059I";
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.12 seconds
cpu time 0.01 seconds
23
24 *-----------------------------------------------------------------------------------
25 * Get conditions records coded as asthma.
26 *-----------------------------------------------------------------------------------;
2 The SAS System 07:40 Thursday, March 11, 2004
27 DATA ASCONDS;
28 SET IN.H61 (KEEP=CONDIDX CCCODEX);
29 IF CCCODEX="128";
30 RUN;
NOTE: There were 102489 observations read from the data set IN.H61.
NOTE: The data set WORK.ASCONDS has 1695 observations and 2 variables.
NOTE: DATA statement used:
real time 1.23 seconds
cpu time 0.15 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 1695 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1695 observations and 2 variables.
NOTE: PROCEDURE SORT used:
real time 0.07 seconds
cpu time 0.01 seconds
36
37 proc print data=asconds (obs=50);
38 title3 "sample print of work.asconds - sorted by condidx";
39 title4 "COND (HC-061) 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.25 seconds
cpu time 0.01 seconds
41
42 PROC SORT DATA=IN.H59IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 314599 observations read from the data set IN.H59IF1.
NOTE: The data set WORK.CLNK has 314599 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 1.65 seconds
cpu time 1.21 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 07:40 Thursday, March 11, 2004
NOTE: There were 314599 observations read from the data set WORK.CLNK.
NOTE: There were 1695 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7046 observations and 3 variables.
NOTE: DATA statement used:
real time 0.35 seconds
cpu time 0.31 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.07 seconds
cpu time 0.01 seconds
58
59 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7046 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7046 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.23 seconds
cpu time 0.01 seconds
60
61 proc print data=asclnks (obs=50);
62 format eventype eventype.;
63 title3 "sample print of work.asclnks - sorted by evntidx";
64 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.00 seconds
65
66 DATA ASCLNKS;
67 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
68 BY EVNTIDX;
69 IF FIRST.EVNTIDX;
70 RUN;
NOTE: There were 7046 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7033 observations and 2 variables.
4 The SAS System 07:40 Thursday, March 11, 2004
NOTE: DATA statement used:
real time 0.04 seconds
cpu time 0.01 seconds
71
72 proc print data=asclnks (obs=50);
73 format eventype eventype.;
74 title3 "sample print of unique evntidxs from work.asclnks";
75 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used:
real time 0.03 seconds
cpu time 0.00 seconds
76
77 *--------------------------------------------------------------------------------------------
78 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
79 *--------------------------------------------------------------------------------------------;
80 DATA MVIS;
81 SET IN.H59G (KEEP=EVNTIDX PERWT01F SEETLKPV OBXP01X);
82 IF PERWT01F > 0 & SEETLKPV NE 2;
83 RUN;
NOTE: There were 147490 observations read from the data set IN.H59G.
NOTE: The data set WORK.MVIS has 142776 observations and 4 variables.
NOTE: DATA statement used:
real time 2.93 seconds
cpu time 0.49 seconds
84
85 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 142776 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 142776 observations and 4 variables.
NOTE: PROCEDURE SORT used:
real time 0.42 seconds
cpu time 0.40 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 7033 observations read from the data set WORK.ASCLNKS.
NOTE: There were 142776 observations read from the data set WORK.MVIS.
5 The SAS System 07:40 Thursday, March 11, 2004
NOTE: The data set WORK.ASMVIS has 2238 observations and 5 variables.
NOTE: DATA statement used:
real time 0.15 seconds
cpu time 0.15 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-059G) 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 OBXP01X;
105 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
106 RUN;
NOTE: There were 2238 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 7.
NOTE: PROCEDURE MEANS used:
real time 0.07 seconds
cpu time 0.00 seconds
107
108 PROC MEANS DATA=ASMVIS SUM;
109 VAR OBXP01X;
110 WEIGHT PERWT01F;
111 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
112 TITLE5 "Weighted";
113 RUN;
NOTE: There were 2238 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 12.29 seconds
cpu time 3.37 seconds
HC-059I 07:40 Thursday, March 11, 2004 1
Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx
COND (HC-061) records where cccodex=128
Obs CONDIDX CCCODEX
1 400060150010 128
2 400060220025 128
3 400100460013 128
4 400120250093 128
5 400150180047 128
6 400150320017 128
7 400420120055 128
8 400500160056 128
9 400630140015 128
10 400670280087 128
11 400700390037 128
12 400830280016 128
13 400840180025 128
14 400840320017 128
15 400850110076 128
16 400990200047 128
17 401160130036 128
18 401650150017 128
19 401700450040 128
20 401710240020 128
21 401840370020 128
22 401870110028 128
23 401870350010 128
24 402060410053 128
25 402160430011 128
26 402160660010 128
27 402190190014 128
28 402260280015 128
29 402350120018 128
30 402530190024 128
31 402720640014 128
32 402740320012 128
33 402970200016 128
34 403000160011 128
35 403110150117 128
36 403210170016 128
37 403210480013 128
38 403230280069 128
39 403320410016 128
40 403330360012 128
41 403340270061 128
42 403510210075 128
43 403860370035 128
44 404130470038 128
45 404210160041 128
46 404550260035 128
47 404670140024 128
48 404760860025 128
49 404770150034 128
50 404790560018 128
HC-059I 07:40 Thursday, March 11, 2004 2
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
400100460013 400100460012 8 PMED
400100460029 8 PMED
400100460036 8 PMED
400100460043 8 PMED
400120250093 400120250196 8 PMED
400150180047 400150180038 1 MVIS
400150180076 8 PMED
400150180083 8 PMED
400150180090 8 PMED
400150180463 1 MVIS
400150180470 1 MVIS
400150180507 8 PMED
400150320017 400150320014 1 MVIS
400150320021 1 MVIS
400150320038 1 MVIS
400150320045 1 MVIS
400150320052 1 MVIS
400150320069 1 MVIS
400150320090 1 MVIS
400150320103 1 MVIS
400150320110 8 PMED
400420120055 400420120077 8 PMED
400420120180 8 PMED
400500160056 400500160080 8 PMED
400500160097 8 PMED
400630140015 400630140025 1 MVIS
400630140049 4 STAZ
400630140056 3 EROM
400630140070 8 PMED
400630140087 8 PMED
400630140107 8 PMED
400630140145 1 MVIS
400630140152 8 PMED
400630140169 8 PMED
400630140183 8 PMED
400630140227 8 PMED
400630140234 8 PMED
400630140258 8 PMED
400670280087 400670280130 8 PMED
400670280147 8 PMED
400670280154 8 PMED
400670280161 8 PMED
HC-059I 07:40 Thursday, March 11, 2004 3
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
400670280087 400670280250 8 PMED
400700390037 400700390041 8 PMED
400830280016 400830280011 8 PMED
400840180025 400840180019 2 OPAT
400840180040 2 OPAT
400840180095 8 PMED
400840180108 8 PMED
400840180115 8 PMED
400840180122 8 PMED
400840180146 1 MVIS
400840180204 8 PMED
400840180211 8 PMED
400840180228 8 PMED
400840180259 8 PMED
400840180297 2 OPAT
400840180300 2 OPAT
400840180317 2 OPAT
400840180331 2 OPAT
400840180379 8 PMED
400840180386 8 PMED
400840180393 8 PMED
400840320017 400840320026 2 OPAT
400840320033 2 OPAT
400840320191 2 OPAT
400850110076 400850110226 8 PMED
400850110308 1 MVIS
400850110315 1 MVIS
400850110322 1 MVIS
400850110360 1 MVIS
400850110377 1 MVIS
400850110428 8 PMED
400850110435 8 PMED
400990200047 400990200092 8 PMED
HC-059I 07:40 Thursday, March 11, 2004 4
Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx
Obs CONDIDX EVNTIDX EVENTYPE
1 400100460013 400100460012 8 PMED
2 400100460013 400100460029 8 PMED
3 400100460013 400100460036 8 PMED
4 400100460013 400100460043 8 PMED
5 400120250093 400120250196 8 PMED
6 400150180047 400150180038 1 MVIS
7 400150180047 400150180076 8 PMED
8 400150180047 400150180083 8 PMED
9 400150180047 400150180090 8 PMED
10 400150180047 400150180463 1 MVIS
11 400150180047 400150180470 1 MVIS
12 400150180047 400150180507 8 PMED
13 400150320017 400150320014 1 MVIS
14 400150320017 400150320021 1 MVIS
15 400150320017 400150320038 1 MVIS
16 400150320017 400150320045 1 MVIS
17 400150320017 400150320052 1 MVIS
18 400150320017 400150320069 1 MVIS
19 400150320017 400150320090 1 MVIS
20 400150320017 400150320103 1 MVIS
21 400150320017 400150320110 8 PMED
22 400420120055 400420120077 8 PMED
23 400420120055 400420120180 8 PMED
24 400500160056 400500160080 8 PMED
25 400500160056 400500160097 8 PMED
26 400630140015 400630140025 1 MVIS
27 400630140015 400630140049 4 STAZ
28 400630140015 400630140056 3 EROM
29 400630140015 400630140070 8 PMED
30 400630140015 400630140087 8 PMED
31 400630140015 400630140107 8 PMED
32 400630140015 400630140145 1 MVIS
33 400630140015 400630140152 8 PMED
34 400630140015 400630140169 8 PMED
35 400630140015 400630140183 8 PMED
36 400630140015 400630140227 8 PMED
37 400630140015 400630140234 8 PMED
38 400630140015 400630140258 8 PMED
39 400670280087 400670280130 8 PMED
40 400670280087 400670280147 8 PMED
41 400670280087 400670280154 8 PMED
42 400670280087 400670280161 8 PMED
43 400670280087 400670280250 8 PMED
44 400700390037 400700390041 8 PMED
45 400830280016 400830280011 8 PMED
46 400840180025 400840180019 2 OPAT
47 400840180025 400840180040 2 OPAT
48 400840180025 400840180095 8 PMED
49 400840180025 400840180108 8 PMED
50 400840180025 400840180115 8 PMED
HC-059I 07:40 Thursday, March 11, 2004 5
Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 400100460012 8 PMED
2 400100460029 8 PMED
3 400100460036 8 PMED
4 400100460043 8 PMED
5 400120250196 8 PMED
6 400150180038 1 MVIS
7 400150180076 8 PMED
8 400150180083 8 PMED
9 400150180090 8 PMED
10 400150180463 1 MVIS
11 400150180470 1 MVIS
12 400150180507 8 PMED
13 400150320014 1 MVIS
14 400150320021 1 MVIS
15 400150320038 1 MVIS
16 400150320045 1 MVIS
17 400150320052 1 MVIS
18 400150320069 1 MVIS
19 400150320090 1 MVIS
20 400150320103 1 MVIS
21 400150320110 8 PMED
22 400420120077 8 PMED
23 400420120180 8 PMED
24 400500160080 8 PMED
25 400500160097 8 PMED
26 400630140025 1 MVIS
27 400630140049 4 STAZ
28 400630140056 3 EROM
29 400630140070 8 PMED
30 400630140087 8 PMED
31 400630140107 8 PMED
32 400630140145 1 MVIS
33 400630140152 8 PMED
34 400630140169 8 PMED
35 400630140183 8 PMED
36 400630140227 8 PMED
37 400630140234 8 PMED
38 400630140258 8 PMED
39 400670280130 8 PMED
40 400670280147 8 PMED
41 400670280154 8 PMED
42 400670280161 8 PMED
43 400670280250 8 PMED
44 400700390041 8 PMED
45 400830280011 8 PMED
46 400840180019 2 OPAT
47 400840180040 2 OPAT
48 400840180095 8 PMED
49 400840180108 8 PMED
50 400840180115 8 PMED
HC-059I 07:40 Thursday, March 11, 2004 6
Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-059G) events
Obs EVNTIDX EVENTYPE SEETLKPV OBXP01X PERWT01F
1 400150180038 1 MVIS 1 0.00 6058.14
2 400150180463 1 MVIS 1 90.54 6058.14
3 400150180470 1 MVIS 1 65.61 6058.14
4 400150320014 1 MVIS 1 54.34 6682.32
5 400150320021 1 MVIS 1 71.54 6682.32
6 400150320038 1 MVIS 1 16.50 6682.32
7 400150320045 1 MVIS 1 89.50 6682.32
8 400150320052 1 MVIS 1 89.50 6682.32
9 400150320069 1 MVIS 1 54.34 6682.32
10 400150320090 1 MVIS 1 32.32 6682.32
11 400150320103 1 MVIS 1 71.54 6682.32
12 400630140025 1 MVIS 1 59.00 13871.65
13 400630140145 1 MVIS 1 62.24 13871.65
14 400840180146 1 MVIS 1 175.00 4082.26
15 400850110308 1 MVIS 1 58.80 6763.21
16 400850110315 1 MVIS 1 96.31 6763.21
17 400850110322 1 MVIS 1 52.00 6763.21
18 400850110360 1 MVIS 1 29.75 6763.21
19 400850110377 1 MVIS 1 41.03 6763.21
20 401650150016 1 MVIS 1 78.80 5825.09
21 401870350013 1 MVIS 1 81.56 6999.50
22 402160660102 1 MVIS 1 37.94 1238.52
23 402260280014 1 MVIS 1 400.00 11925.78
24 402260280038 1 MVIS 1 215.14 11925.78
25 402530190036 1 MVIS 1 37.96 5804.97
26 402530190043 1 MVIS 1 93.74 5804.97
27 402530190125 1 MVIS 1 68.16 5804.97
28 402530190132 1 MVIS 1 129.00 5804.97
29 402530190149 1 MVIS 1 175.92 5804.97
30 402530190245 1 MVIS 1 108.68 5804.97
31 402530190276 1 MVIS 1 93.74 5804.97
32 402720640014 1 MVIS 1 42.40 5630.79
33 402720640021 1 MVIS 1 96.80 5630.79
34 402720640069 1 MVIS 1 26.15 5630.79
35 402970200015 1 MVIS 1 343.39 3865.36
36 402970200039 1 MVIS 1 0.00 3865.36
37 402970200046 1 MVIS 1 0.00 3865.36
38 402970200053 1 MVIS 1 24.58 3865.36
39 402970200128 1 MVIS 1 225.00 3865.36
40 402970200135 1 MVIS 1 122.71 3865.36
41 402970200142 1 MVIS 1 0.00 3865.36
42 402970200159 1 MVIS 1 0.00 3865.36
43 402970200166 1 MVIS 1 81.96 3865.36
44 402970200262 1 MVIS 1 203.49 3865.36
45 402970200286 1 MVIS 1 0.00 3865.36
46 403000160012 1 MVIS 1 153.92 6256.73
47 403000160029 1 MVIS 1 244.76 6256.73
48 403210170015 1 MVIS 1 12.00 6296.54
49 403210480046 1 MVIS 1 36.00 9525.99
50 403210480053 1 MVIS 1 36.00 9525.99
HC-059I 07:40 Thursday, March 11, 2004 7
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
The MEANS Procedure
Analysis Variable : OBXP01X SUM OF OBSF01X - OBOT01X (IMPUTED)
N Sum
--------------------
2238 184239.30
--------------------
HC-059I 07:40 Thursday, March 11, 2004 8
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : OBXP01X SUM OF OBSF01X - OBOT01X (IMPUTED)
Sum
------------
1528629532
------------
1 The SAS System 07:41 Thursday, March 11, 2004
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This installation is running Base SAS hot fix bundle 82BX07.
NOTE: SAS initialization used:
real time 1.81 seconds
cpu time 0.40 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-059I";
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 * Calculate the expenditures for prescribed medicines associated
10 * with insulin reported by the household as an other medical expense.
11 **************************************************************************************;
12
13 PROC FORMAT;
14 VALUE EVENTYPE
15 1 = "1 MVIS"
16 2 = "2 OPAT"
17 3 = "3 EROM"
18 4 = "4 STAZ"
19 5 = "5 DVIS"
20 6 = "6 OMED"
21 7 = "7 HVIS"
22 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
23
24 VALUE OMTYPE
25 -9 = '-9 NOT ASCERTAINED'
26 -8 = '-8 DK'
27 -7 = '-7 REFUSED'
28 -1 = '-1 INAPPLICABLE'
29 1 = '1 GLASSES OR CONTACT LENSES'
30 2 = '2 INSULIN'
2 The SAS System 07:41 Thursday, March 11, 2004
31 3 = '3 DIABETIC EQUIPMENT/SUPPLIES'
32 4 = '4 AMBULANCE SERVICES'
33 5 = '5 ORTHOPEDIC ITEMS'
34 6 = '6 HEARING DEVICES'
35 7 = '7 PROSTHESIS'
36 8 = '8 BATHROOM AIDS'
37 9 = '9 MEDICAL EQUIPMENT'
38 10 = '10 DISPOSABLE SUPPLIES'
39 11 = '11 ALTERATIONS/MODIFICATIONS'
40 91 = '91 OTHER'
41 ;
NOTE: Format OMTYPE has been output.
42 RUN;
NOTE: PROCEDURE FORMAT used:
real time 0.10 seconds
cpu time 0.00 seconds
43
44 *-------------------------------------------------------------------------------------
45 * Get other medical records for insulin for persons with positive weights.
46 *-------------------------------------------------------------------------------------;
47
48 DATA OMED;
49 SET IN.H59C (KEEP=EVNTIDX PERWT01F OMTYPEX);
50 IF PERWT01F > 0 & OMTYPEX = 2;
51 RUN;
NOTE: There were 9376 observations read from the data set IN.H59C.
NOTE: The data set WORK.OMED has 606 observations and 3 variables.
NOTE: DATA statement used:
real time 0.34 seconds
cpu time 0.04 seconds
52
53 proc print data=omed (obs=100);
54 var evntidx OMTYPEX PERWT01F;
55 format OMTYPEX omtype.;
56 title3 "sample print of OMED (HC-059C) records where OMTYPEX=2";
57 run;
NOTE: There were 100 observations read from the data set WORK.OMED.
NOTE: The PROCEDURE PRINT printed pages 1-2.
NOTE: PROCEDURE PRINT used:
real time 0.25 seconds
cpu time 0.01 seconds
58
59 *-------------------------------------------------------------------------------------
60 * Get PMED IDs linked to the OMED events which were for insulin.
61 *-------------------------------------------------------------------------------------;
62
63 PROC SORT DATA=IN.H59IF2 OUT=RXLK; BY EVNTIDX; RUN;
3 The SAS System 07:41 Thursday, March 11, 2004
NOTE: There were 60519 observations read from the data set IN.H59IF2.
NOTE: The data set WORK.RXLK has 60519 observations and 5 variables.
NOTE: PROCEDURE SORT used:
real time 0.43 seconds
cpu time 0.28 seconds
64
65 proc print data=rxlk (obs=150);
66 by evntidx;
67 id evntidx;
68 var linkidx eventype;
69 format eventype eventype.;
70 title3 "sample print of Rx+event link file records (HC-59IF2) - sorted by evntidx";
71 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.07 seconds
cpu time 0.03 seconds
72
73 data omedrxlk;
74 set rxlk (where=(eventype=6));
75 run;
NOTE: There were 1756 observations read from the data set WORK.RXLK.
WHERE eventype=6;
NOTE: The data set WORK.OMEDRXLK has 1756 observations and 5 variables.
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.01 seconds
76 proc print data=omedrxlk (obs=120);
77 by evntidx;
78 id evntidx;
79 var linkidx eventype;
80 format eventype eventype.;
81 title3 "sample print of work.omedrxlk - sorted by evntidx";
82 title4 "Rx+event link file records (HC-59IF2) where eventype=6 (omed)";
83 run;
NOTE: There were 120 observations read from the data set WORK.OMEDRXLK.
NOTE: The PROCEDURE PRINT printed pages 8-12.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.01 seconds
84
85 DATA PMEDIDS;
86 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
87 OMED (IN=INOMED KEEP=EVNTIDX);
88 BY EVNTIDX;
4 The SAS System 07:41 Thursday, March 11, 2004
89 IF INRXLK & INOMED;
90 RUN;
NOTE: There were 60519 observations read from the data set WORK.RXLK.
NOTE: There were 606 observations read from the data set WORK.OMED.
NOTE: The data set WORK.PMEDIDS has 587 observations and 3 variables.
NOTE: DATA statement used:
real time 0.07 seconds
cpu time 0.06 seconds
91
92 proc print data=pmedids (obs=50);
93 by evntidx;
94 id evntidx;
95 format eventype eventype.;
96 title3 "sample print of work.pmedids - sorted by evntidx";
97 title4 "work.rxlk records for omed events for insulin";
98 run;
NOTE: 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.01 seconds
cpu time 0.00 seconds
99
100 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 587 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 587 observations and 3 variables.
NOTE: PROCEDURE SORT used:
real time 0.01 seconds
cpu time 0.00 seconds
101
102 proc print data=pmedids (obs=50);
103 format eventype eventype.;
104 title3 "sample print of work.pmedids - sorted by linkidx";
105 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.00 seconds
106
107 DATA PMEDIDS;
108 SET PMEDIDS (KEEP=LINKIDX);
109 BY LINKIDX;
110 IF FIRST.LINKIDX;
111 KEEP LINKIDX;
112 RUN;
5 The SAS System 07:41 Thursday, March 11, 2004
NOTE: There were 587 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 587 observations and 1 variables.
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.01 seconds
113
114 proc print data=pmedids (obs=50);
115 title3 "sample print of unique linkidxs in work.pmedids";
116 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
117
118
119 *------------------------------------------------------------------------------------
120 * Get PMED records for OMED event which were for insulin.
121 *------------------------------------------------------------------------------------;
122 PROC SORT DATA=IN.H59A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 277866 observations read from the data set IN.H59A.
NOTE: The data set WORK.PMED has 277866 observations and 74 variables.
NOTE: PROCEDURE SORT used:
real time 3:09.89
cpu time 17.78 seconds
123
124 DATA OMPMEDS;
125 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP01X PERWT01F RXNAME)
126 PMEDIDS (IN=A);
127 BY LINKIDX;
128 IF A & PERWT01F>0;
129 RUN;
NOTE: There were 277866 observations read from the data set WORK.PMED.
NOTE: There were 587 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.OMPMEDS has 2130 observations and 5 variables.
NOTE: DATA statement used:
real time 4.71 seconds
cpu time 0.95 seconds
130
131 proc print data=ompmeds (obs=200);
132 by linkidx;
133 id linkidx;
134 var rxrecidx rxname RXXP01X PERWT01F;
135 title3 "sample print of work.pmeds";
136 title4 "PMED (HC-059A) records for unique linkidxs in work.pmedids";
6 The SAS System 07:41 Thursday, March 11, 2004
137 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.11 seconds
cpu time 0.01 seconds
138
139 PROC MEANS DATA=OMPMEDS N SUM;
140 VAR RXXP01X;
141 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
142 RUN;
NOTE: There were 2130 observations read from the data set WORK.OMPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used:
real time 0.18 seconds
cpu time 0.01 seconds
143
144 PROC MEANS DATA=OMPMEDS N SUM;
145 VAR RXXP01X;
146 WEIGHT PERWT01F;
147 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
148 TITLE5 "Weighted";
149 RUN;
NOTE: There were 2130 observations read from the data set WORK.OMPMEDS.
NOTE: The PROCEDURE MEANS printed page 24.
NOTE: PROCEDURE MEANS used:
real time 0.01 seconds
cpu time 0.00 seconds
150
151
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 3:20.20
cpu time 19.81 seconds
HC-059I 07:41 Thursday, March 11, 2004 1
Sample SAS Job for Example D
sample print of OMED (HC-059C) records where OMTYPEX=2
Obs EVNTIDX OMTYPEX PERWT01F
1 401790360016 2 INSULIN 2703.67
2 401790360105 2 INSULIN 2703.67
3 402010110027 2 INSULIN 5928.25
4 402010110154 2 INSULIN 5928.25
5 402010110229 2 INSULIN 5928.25
6 402640180037 2 INSULIN 4740.96
7 402640180171 2 INSULIN 4740.96
8 402640180260 2 INSULIN 4740.96
9 402760190048 2 INSULIN 12596.76
10 402760190137 2 INSULIN 12596.76
11 402760190226 2 INSULIN 12596.76
12 402790140029 2 INSULIN 11843.00
13 402950100042 2 INSULIN 9121.94
14 402950100340 2 INSULIN 9121.94
15 402970130039 2 INSULIN 6340.94
16 403030100015 2 INSULIN 7363.66
17 403030100060 2 INSULIN 7363.66
18 403030100128 2 INSULIN 7363.66
19 403770150035 2 INSULIN 6340.55
20 403770150326 2 INSULIN 6340.55
21 404070180056 2 INSULIN 11774.97
22 404070180138 2 INSULIN 11774.97
23 404070180183 2 INSULIN 11774.97
24 404220100029 2 INSULIN 11421.52
25 404220100245 2 INSULIN 11421.52
26 404910180142 2 INSULIN 4323.14
27 404910180320 2 INSULIN 4323.14
28 404930130037 2 INSULIN 2568.91
29 404930130277 2 INSULIN 2568.91
30 404930130380 2 INSULIN 2568.91
31 404930200068 2 INSULIN 3190.97
32 404930200171 2 INSULIN 3190.97
33 404930200260 2 INSULIN 3190.97
34 405450650033 2 INSULIN 6704.50
35 405650150136 2 INSULIN 6899.91
36 406250160047 2 INSULIN 5118.49
37 406250160136 2 INSULIN 5118.49
38 406880180020 2 INSULIN 8986.10
39 406880180075 2 INSULIN 8986.10
40 407770250120 2 INSULIN 6471.81
41 407770250411 2 INSULIN 6471.81
42 409050280037 2 INSULIN 5780.52
43 410270260387 2 INSULIN 7819.48
44 410820200171 2 INSULIN 10874.49
45 410820200284 2 INSULIN 10874.49
46 411100120010 2 INSULIN 10608.83
47 411100120072 2 INSULIN 10608.83
48 411330390027 2 INSULIN 8575.06
49 411330390116 2 INSULIN 8575.06
50 411330390212 2 INSULIN 8575.06
51 411620190291 2 INSULIN 4384.55
52 411990930376 2 INSULIN 10433.90
53 411990930489 2 INSULIN 10433.90
HC-059I 07:41 Thursday, March 11, 2004 2
Sample SAS Job for Example D
sample print of OMED (HC-059C) records where OMTYPEX=2
Obs EVNTIDX OMTYPEX PERWT01F
54 413130250067 2 INSULIN 13555.55
55 413130250238 2 INSULIN 13555.55
56 413130250430 2 INSULIN 13555.55
57 413400110239 2 INSULIN 8739.59
58 413400110506 2 INSULIN 8739.59
59 413400110688 2 INSULIN 8739.59
60 413520170017 2 INSULIN 10292.15
61 413520170137 2 INSULIN 10292.15
62 414090180194 2 INSULIN 13130.21
63 414090180389 2 INSULIN 13130.21
64 414130250103 2 INSULIN 5622.93
65 415160240025 2 INSULIN 3739.27
66 415160240107 2 INSULIN 3739.27
67 415160240203 2 INSULIN 3739.27
68 416050180050 2 INSULIN 3547.38
69 416050180365 2 INSULIN 3547.38
70 416050180601 2 INSULIN 3547.38
71 416090180057 2 INSULIN 5243.46
72 416090180235 2 INSULIN 5243.46
73 416090180468 2 INSULIN 5243.46
74 416170140029 2 INSULIN 10696.97
75 416460180139 2 INSULIN 10696.20
76 416650170018 2 INSULIN 2281.29
77 416650540019 2 INSULIN 1514.57
78 416900290074 2 INSULIN 7928.84
79 416900290156 2 INSULIN 7928.84
80 416900290396 2 INSULIN 7928.84
81 417250110065 2 INSULIN 11130.29
82 417250110178 2 INSULIN 11130.29
83 417250110301 2 INSULIN 11130.29
84 417290120055 2 INSULIN 2555.89
85 418020180254 2 INSULIN 17914.50
86 418170180096 2 INSULIN 7099.84
87 418170180394 2 INSULIN 7099.84
88 418650140130 2 INSULIN 8204.96
89 419360220257 2 INSULIN 19667.60
90 420030120090 2 INSULIN 13719.24
91 420510250051 2 INSULIN 12923.63
92 420510250140 2 INSULIN 12923.63
93 420510250222 2 INSULIN 12923.63
94 420930170116 2 INSULIN 9503.61
95 420980170040 2 INSULIN 5946.09
96 420980170393 2 INSULIN 5946.09
97 421920280038 2 INSULIN 9680.91
98 421920280223 2 INSULIN 9680.91
99 421920280367 2 INSULIN 9680.91
100 421940230027 2 INSULIN 5730.46
HC-059I 07:41 Thursday, March 11, 2004 3
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-59IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
400010130020 400010130051 1 MVIS
400010130037 400010130044 6 OMED
400010130068 400010130075 6 OMED
400010200075 400010200082 1 MVIS
400070150018 400070150025 1 MVIS
400070150049 400070150056 3 EROM
400100150029 400100150118 1 MVIS
400110130013 400110130020 1 MVIS
400110130037 400110130068 5 DVIS
400110130044 400110130068 5 DVIS
400110200044 400110200051 2 OPAT
400110370013 400110370020 1 MVIS
400110370037 400110370044 1 MVIS
400110370051 1 MVIS
400120250014 400120250069 1 MVIS
400120250021 400120250076 1 MVIS
400120250038 400120250076 1 MVIS
400120250083 400120250090 1 MVIS
400120250110 400120250134 2 OPAT
400120250141 2 OPAT
400130170019 400130170071 4 STAZ
400130170088 4 STAZ
400130170095 4 STAZ
400130170108 4 STAZ
400130170115 4 STAZ
400130170122 4 STAZ
400130170139 4 STAZ
400130170146 4 STAZ
400130170153 4 STAZ
400130170160 4 STAZ
400130240160 400130240259 1 MVIS
HC-059I 07:41 Thursday, March 11, 2004 4
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-59IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
400150180014 400150180052 3 EROM
400150180021 400150180069 1 MVIS
400150180038 400150180076 1 MVIS
400150180083 1 MVIS
400150180090 1 MVIS
400150180134 400150180487 2 OPAT
400150180141 400150180494 2 OPAT
400150320090 400150320110 1 MVIS
400170190012 400170190050 1 MVIS
400170190029 400170190067 1 MVIS
400170190149 400170190156 1 MVIS
400170190163 1 MVIS
400170190170 1 MVIS
400170190187 1 MVIS
400170260050 400170260067 1 MVIS
400170260074 1 MVIS
400170260101 400170260149 1 MVIS
400180180015 400180180022 1 MVIS
400180180039 400180180046 1 MVIS
400180350012 400180350029 3 EROM
400190150014 400190150083 1 MVIS
400190150090 1 MVIS
400190150103 1 MVIS
400190150110 1 MVIS
400190150127 1 MVIS
400190150134 1 MVIS
400190150052 400190150141 1 MVIS
400190150069 400190150076 6 OMED
400190150165 400190150209 1 MVIS
400190150172 400190150209 1 MVIS
400190150196 400190150216 1 MVIS
HC-059I 07:41 Thursday, March 11, 2004 5
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-59IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
400190150292 400190150312 1 MVIS
400190150329 1 MVIS
400190150336 1 MVIS
400190150343 1 MVIS
400190150350 1 MVIS
400190150367 1 MVIS
400190220052 400190220083 1 MVIS
400190220069 400190220076 6 OMED
400190220305 400190220456 1 MVIS
400190220463 1 MVIS
400190220312 400190220487 1 MVIS
400190220329 400190220494 1 MVIS
400190390045 400190390254 1 MVIS
400190390069 400190390261 1 MVIS
400190390165 400190390254 1 MVIS
400190390196 400190390278 1 MVIS
400200100035 400200100042 1 MVIS
400200270028 400200270035 1 MVIS
400200270080 400200270131 1 MVIS
400230180015 400230180039 1 MVIS
400230180022 400230180046 1 MVIS
400230180077 400230180104 1 MVIS
400230180111 1 MVIS
400230180091 400230180128 1 MVIS
400230320053 400230320104 1 MVIS
400230490015 400230490022 1 MVIS
400230490039 1 MVIS
400250210017 400250210024 1 MVIS
400280170016 400280170061 5 DVIS
400280170078 5 DVIS
HC-059I 07:41 Thursday, March 11, 2004 6
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-59IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
400280240023 400280240030 1 MVIS
400290360092 400290360105 1 MVIS
400290430054 400290430078 1 MVIS
400290430061 400290430085 1 MVIS
400300180052 400300180069 1 MVIS
400300180076 1 MVIS
400300180090 400300180110 1 MVIS
400340190014 400340190196 1 MVIS
400340190209 1 MVIS
400340190216 1 MVIS
400340190021 400340190223 1 MVIS
400340190189 400340190230 2 OPAT
400340190590 400340190709 1 MVIS
400340190716 1 MVIS
400340190723 1 MVIS
400340190603 400340190709 1 MVIS
400340190716 1 MVIS
400340190723 1 MVIS
400350300016 400350300023 1 MVIS
400350300030 1 MVIS
400350300047 400350300054 1 MVIS
400350470016 400350470023 1 MVIS
400360130011 400360130100 3 EROM
400360130028 400360130117 2 OPAT
400360130124 2 OPAT
400360130131 2 OPAT
400360130148 2 OPAT
400360130066 400360130155 4 STAZ
400360130162 4 STAZ
400360130179 4 STAZ
400380140010 400380140027 1 MVIS
400380140034 1 MVIS
400380140041 1 MVIS
HC-059I 07:41 Thursday, March 11, 2004 7
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-59IF2) - sorted by evntidx
EVNTIDX LINKIDX EVENTYPE
400380140010 400380140058 1 MVIS
400400190102 400400190157 1 MVIS
400400190119 400400190164 1 MVIS
400400190171 1 MVIS
400400190133 400400190140 6 OMED
400400190397 400400190400 6 OMED
400400190688 400400190695 6 OMED
400420120022 400420120053 1 MVIS
400420120060 1 MVIS
400420120077 1 MVIS
400420120084 1 MVIS
400420120091 1 MVIS
400420120104 1 MVIS
400420120135 400420120166 2 OPAT
400450280031 400450280106 1 MVIS
400450280113 1 MVIS
400460130017 400460130031 1 MVIS
400470180017 400470180093 1 MVIS
400470180106 1 MVIS
400470180113 1 MVIS
400470180199 400470180322 1 MVIS
400470180339 1 MVIS
400470180295 400470180353 1 MVIS
400480140128 400480140173 3 EROM
400490490014 400490490038 1 MVIS
HC-059I 07:41 Thursday, March 11, 2004 8
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-59IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
400010130037 400010130044 6 OMED
400010130068 400010130075 6 OMED
400190150069 400190150076 6 OMED
400190220069 400190220076 6 OMED
400400190133 400400190140 6 OMED
400400190397 400400190400 6 OMED
400400190688 400400190695 6 OMED
400520460018 400520460025 6 OMED
400850110048 400850110055 6 OMED
400850110182 400850110199 6 OMED
401790360016 401790360023 6 OMED
401790360105 401790360112 6 OMED
402010110027 402010110034 6 OMED
402010110041 402010110058 6 OMED
402010110154 402010110161 6 OMED
402010110178 402010110185 6 OMED
402010110229 402010110236 6 OMED
402010110243 402010110250 6 OMED
402160120043 402160120050 6 OMED
402640180013 402640180020 6 OMED
402640180037 402640180044 6 OMED
402640180171 402640180188 6 OMED
402640180260 402640180277 6 OMED
402640180335 402640180342 6 OMED
402760190024 402760190031 6 OMED
HC-059I 07:41 Thursday, March 11, 2004 9
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-59IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
402760190048 402760190055 6 OMED
402760190137 402760190144 6 OMED
402760190151 402760190168 6 OMED
402760190226 402760190233 6 OMED
402790140029 402790140036 6 OMED
402790140043 402790140050 6 OMED
402830160075 402830160082 6 OMED
402950100042 402950100059 6 OMED
402950100066 402950100073 6 OMED
402950100326 402950100333 6 OMED
402950100340 402950100357 6 OMED
402970130039 402970130046 6 OMED
402970130053 402970130060 6 OMED
403030100015 403030100022 6 OMED
403030100039 403030100046 6 OMED
403030100060 403030100077 6 OMED
403030100084 403030100091 6 OMED
403030100128 403030100135 6 OMED
403030100142 403030100159 6 OMED
403070180242 403070180259 6 OMED
403350240082 403350240099 6 OMED
403770150035 403770150042 6 OMED
403770150059 403770150066 6 OMED
403770150162 403770150179 6 OMED
403770150326 403770150333 6 OMED
HC-059I 07:41 Thursday, March 11, 2004 10
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-59IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
403770150340 403770150357 6 OMED
403780150127 403780150134 6 OMED
403980210032 403980210049 6 OMED
404010160012 404010160029 6 OMED
404010160194 404010160207 6 OMED
404070180032 404070180049 6 OMED
404070180056 404070180063 6 OMED
404070180138 404070180145 6 OMED
404070180152 404070180169 6 OMED
404220100029 404220100036 6 OMED
404220100245 404220100252 6 OMED
404220100269 404220100276 6 OMED
404230160284 404230160291 6 OMED
404230160955 404230160962 6 OMED
404400140156 404400140163 6 OMED
404910180053 404910180060 6 OMED
404910180142 404910180159 6 OMED
404910180166 404910180173 6 OMED
404910180320 404910180337 6 OMED
404910180344 404910180351 6 OMED
404930130037 404930130044 6 OMED
404930130051 404930130068 6 OMED
404930130277 404930130284 6 OMED
404930130291 404930130304 6 OMED
404930130380 404930130397 6 OMED
HC-059I 07:41 Thursday, March 11, 2004 11
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-59IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
404930130400 404930130417 6 OMED
404930200068 404930200075 6 OMED
404930200082 404930200099 6 OMED
404930200171 404930200188 6 OMED
404930200195 404930200208 6 OMED
404930200260 404930200277 6 OMED
404930200284 404930200291 6 OMED
404980100026 404980100033 6 OMED
405010120298 405010120301 6 OMED
405120250194 405120250207 6 OMED
405310150057 405310150064 6 OMED
405310150146 405310150153 6 OMED
405450650033 405450650040 6 OMED
405450650057 405450650064 6 OMED
405650150047 405650150054 6 OMED
405650150136 405650150143 6 OMED
405650150150 405650150167 6 OMED
405650150256 405650150263 6 OMED
406060140155 406060140162 6 OMED
406250160047 406250160054 6 OMED
406250160061 406250160078 6 OMED
406250160136 406250160143 6 OMED
406250160150 406250160167 6 OMED
406350190031 406350190048 6 OMED
406350190240 406350190257 6 OMED
HC-059I 07:41 Thursday, March 11, 2004 12
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by evntidx
Rx+event link file records (HC-59IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
406700120084 406700120091 6 OMED
406880180020 406880180037 6 OMED
406880180044 406880180051 6 OMED
406880180075 406880180082 6 OMED
406880180099 406880180102 6 OMED
407140260452 407140260469 6 OMED
407140260476 407140260483 6 OMED
407450410033 407450410040 6 OMED
407770250120 407770250137 6 OMED
407770250144 407770250151 6 OMED
407770250411 407770250428 6 OMED
407770250435 407770250442 6 OMED
408010130058 408010130065 6 OMED
408130110034 408130110041 6 OMED
408130110096 408130110109 6 OMED
408340290054 408340290061 6 OMED
408410190095 408410190108 6 OMED
408630170034 408630170041 6 OMED
409050280037 409050280044 6 OMED
409050280075 409050280082 6 OMED
HC-059I 07:41 Thursday, March 11, 2004 13
Sample SAS Job for Example D
sample print of work.pmedids - sorted by evntidx
work.rxlk records for omed events for insulin
EVNTIDX LINKIDX EVENTYPE
401790360016 401790360023 6 OMED
401790360105 401790360112 6 OMED
402010110027 402010110034 6 OMED
402010110154 402010110161 6 OMED
402010110229 402010110236 6 OMED
402640180037 402640180044 6 OMED
402640180171 402640180188 6 OMED
402640180260 402640180277 6 OMED
402760190048 402760190055 6 OMED
402760190137 402760190144 6 OMED
402760190226 402760190233 6 OMED
402790140029 402790140036 6 OMED
402950100042 402950100059 6 OMED
402950100340 402950100357 6 OMED
402970130039 402970130046 6 OMED
403030100015 403030100022 6 OMED
403030100060 403030100077 6 OMED
403030100128 403030100135 6 OMED
403770150035 403770150042 6 OMED
403770150326 403770150333 6 OMED
404070180056 404070180063 6 OMED
404070180138 404070180145 6 OMED
404220100029 404220100036 6 OMED
404220100245 404220100252 6 OMED
404910180142 404910180159 6 OMED
HC-059I 07:41 Thursday, March 11, 2004 14
Sample SAS Job for Example D
sample print of work.pmedids - sorted by evntidx
work.rxlk records for omed events for insulin
EVNTIDX LINKIDX EVENTYPE
404910180320 404910180337 6 OMED
404930130037 404930130044 6 OMED
404930130277 404930130284 6 OMED
404930130380 404930130397 6 OMED
404930200068 404930200075 6 OMED
404930200171 404930200188 6 OMED
404930200260 404930200277 6 OMED
405450650033 405450650040 6 OMED
405650150136 405650150143 6 OMED
406250160047 406250160054 6 OMED
406250160136 406250160143 6 OMED
406880180020 406880180037 6 OMED
406880180075 406880180082 6 OMED
407770250120 407770250137 6 OMED
407770250411 407770250428 6 OMED
409050280037 409050280044 6 OMED
410270260387 410270260394 6 OMED
410820200171 410820200188 6 OMED
410820200284 410820200291 6 OMED
411100120010 411100120027 6 OMED
411330390027 411330390034 6 OMED
411330390116 411330390123 6 OMED
411330390212 411330390229 6 OMED
411620190291 411620190304 6 OMED
411990930376 411990930383 6 OMED
HC-059I 07:41 Thursday, March 11, 2004 15
Sample SAS Job for Example D
sample print of work.pmedids - sorted by linkidx
Obs EVNTIDX LINKIDX EVENTYPE
1 401790360016 401790360023 6 OMED
2 401790360105 401790360112 6 OMED
3 402010110027 402010110034 6 OMED
4 402010110154 402010110161 6 OMED
5 402010110229 402010110236 6 OMED
6 402640180037 402640180044 6 OMED
7 402640180171 402640180188 6 OMED
8 402640180260 402640180277 6 OMED
9 402760190048 402760190055 6 OMED
10 402760190137 402760190144 6 OMED
11 402760190226 402760190233 6 OMED
12 402790140029 402790140036 6 OMED
13 402950100042 402950100059 6 OMED
14 402950100340 402950100357 6 OMED
15 402970130039 402970130046 6 OMED
16 403030100015 403030100022 6 OMED
17 403030100060 403030100077 6 OMED
18 403030100128 403030100135 6 OMED
19 403770150035 403770150042 6 OMED
20 403770150326 403770150333 6 OMED
21 404070180056 404070180063 6 OMED
22 404070180138 404070180145 6 OMED
23 404220100029 404220100036 6 OMED
24 404220100245 404220100252 6 OMED
25 404910180142 404910180159 6 OMED
26 404910180320 404910180337 6 OMED
27 404930130037 404930130044 6 OMED
28 404930130277 404930130284 6 OMED
29 404930130380 404930130397 6 OMED
30 404930200068 404930200075 6 OMED
31 404930200171 404930200188 6 OMED
32 404930200260 404930200277 6 OMED
33 405450650033 405450650040 6 OMED
34 405650150136 405650150143 6 OMED
35 406250160047 406250160054 6 OMED
36 406250160136 406250160143 6 OMED
37 406880180020 406880180037 6 OMED
38 406880180075 406880180082 6 OMED
39 407770250120 407770250137 6 OMED
40 407770250411 407770250428 6 OMED
41 409050280037 409050280044 6 OMED
42 410270260387 410270260394 6 OMED
43 410820200171 410820200188 6 OMED
44 410820200284 410820200291 6 OMED
45 411100120010 411100120027 6 OMED
46 411330390027 411330390034 6 OMED
47 411330390116 411330390123 6 OMED
48 411330390212 411330390229 6 OMED
49 411620190291 411620190304 6 OMED
50 411990930376 411990930383 6 OMED
HC-059I 07:41 Thursday, March 11, 2004 16
Sample SAS Job for Example D
sample print of unique linkidxs in work.pmedids
Obs LINKIDX
1 401790360023
2 401790360112
3 402010110034
4 402010110161
5 402010110236
6 402640180044
7 402640180188
8 402640180277
9 402760190055
10 402760190144
11 402760190233
12 402790140036
13 402950100059
14 402950100357
15 402970130046
16 403030100022
17 403030100077
18 403030100135
19 403770150042
20 403770150333
21 404070180063
22 404070180145
23 404220100036
24 404220100252
25 404910180159
26 404910180337
27 404930130044
28 404930130284
29 404930130397
30 404930200075
31 404930200188
32 404930200277
33 405450650040
34 405650150143
35 406250160054
36 406250160143
37 406880180037
38 406880180082
39 407770250137
40 407770250428
41 409050280044
42 410270260394
43 410820200188
44 410820200291
45 411100120027
46 411330390034
47 411330390123
48 411330390229
49 411620190304
50 411990930383
HC-059I 07:41 Thursday, March 11, 2004 17
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
401790360023 401790360023001 INSULIN NOVOLIN 50.60 2703.67
401790360023002 INSULIN NOVOLIN 50.60 2703.67
401790360023003 INSULIN NOVOLIN 50.60 2703.67
401790360023004 INSULIN NOVOLIN 50.60 2703.67
401790360112 401790360112001 INSULIN NOVOLIN 50.60 2703.67
401790360112002 INSULIN NOVOLIN 50.60 2703.67
401790360112003 INSULIN NOVOLIN 50.60 2703.67
402010110034 402010110034001 HUMULIN R (VIAL) 25.30 5928.25
402010110034002 HUMULIN R (VIAL) 25.30 5928.25
402010110161 402010110161001 HUMALOG (CARTRIDGE) 62.23 5928.25
402010110161002 HUMALOG (CARTRIDGE) 62.23 5928.25
402010110161003 HUMALOG (CARTRIDGE) 62.23 5928.25
402010110161004 HUMALOG (CARTRIDGE) 62.23 5928.25
402010110161005 HUMALOG (CARTRIDGE) 62.23 5928.25
402010110161006 HUMALOG (CARTRIDGE) 62.23 5928.25
402010110236 402010110236001 HUMULIN N (VIAL) 25.30 5928.25
402010110236002 HUMULIN N (VIAL) 25.30 5928.25
402010110236003 HUMULIN N (VIAL) 25.30 5928.25
402010110236004 HUMULIN N (VIAL) 25.30 5928.25
402640180044 402640180044001 NOVOLIN INSULIN 100.57 4740.96
402640180044002 NOVOLIN INSULIN 100.57 4740.96
402640180188 402640180188001 NOVOLIN INSULIN 100.57 4740.96
402640180188002 NOVOLIN INSULIN 100.57 4740.96
402640180188003 NOVOLIN INSULIN 100.57 4740.96
402640180188004 NOVOLIN INSULIN 100.57 4740.96
402640180188005 NOVOLIN INSULIN 100.57 4740.96
402640180188006 NOVOLIN INSULIN 100.57 4740.96
402640180277 402640180277001 NOVOLIN INSULIN 100.57 4740.96
402640180277002 NOVOLIN INSULIN 100.57 4740.96
402640180277003 NOVOLIN INSULIN 100.57 4740.96
402640180277004 NOVOLIN INSULIN 100.57 4740.96
402760190055 402760190055001 INSULIN NOVOLIN 106.08 12596.76
402760190055002 INSULIN NOVOLIN 106.08 12596.76
402760190055003 INSULIN NOVOLIN 106.08 12596.76
402760190055004 INSULIN NOVOLIN 106.08 12596.76
402760190144 402760190144001 INSULIN NOVOLIN 106.08 12596.76
402760190144002 INSULIN NOVOLIN 106.08 12596.76
402760190144003 INSULIN NOVOLIN 106.08 12596.76
402760190144004 INSULIN NOVOLIN 106.08 12596.76
HC-059I 07:41 Thursday, March 11, 2004 18
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
402760190233 402760190233001 INSULIN NOVOLIN 106.08 12596.76
402760190233002 INSULIN NOVOLIN 106.08 12596.76
402760190233003 INSULIN NOVOLIN 106.08 12596.76
402790140036 402790140036001 INSULIN NOVOLIN 106.08 11843.00
402790140036002 INSULIN NOVOLIN 106.08 11843.00
402790140036003 INSULIN NOVOLIN 106.08 11843.00
402950100059 402950100059001 NOVOLIN INSULIN 100.57 9121.94
402950100357 402950100357001 NOVOLIN INSULIN 100.57 9121.94
402970130046 402970130046001 NOVOLIN INSULIN 100.57 6340.94
402970130046002 NOVOLIN INSULIN 100.57 6340.94
402970130046003 NOVOLIN INSULIN 100.57 6340.94
402970130046004 NOVOLIN INSULIN 100.57 6340.94
402970130046005 NOVOLIN INSULIN 100.57 6340.94
402970130046006 NOVOLIN INSULIN 100.57 6340.94
402970130046007 NOVOLIN INSULIN 100.57 6340.94
402970130046008 NOVOLIN INSULIN 100.57 6340.94
403030100022 403030100022001 NOVOLIN INSULIN 100.57 7363.66
403030100077 403030100077001 NOVOLIN INSULIN 100.57 7363.66
403030100077002 NOVOLIN INSULIN 100.57 7363.66
403030100135 403030100135001 NOVOLIN INSULIN 100.57 7363.66
403030100135002 NOVOLIN INSULIN 100.57 7363.66
403770150042 403770150042001 NOVOLIN 70/30 (VIAL) 42.00 6340.55
403770150042002 NOVOLIN 70/30 (VIAL) 42.00 6340.55
403770150042003 NOVOLIN 70/30 (VIAL) 42.00 6340.55
403770150042004 NOVOLIN 70/30 (VIAL) 42.00 6340.55
403770150333 403770150333001 INSULIN NOVOLIN 106.08 6340.55
403770150333002 INSULIN NOVOLIN 106.08 6340.55
403770150333003 INSULIN NOVOLIN 106.08 6340.55
403770150333004 INSULIN NOVOLIN 106.08 6340.55
404070180063 404070180063001 INSULIN NOVOLIN 106.08 11774.97
404070180145 404070180145001 INSULIN NOVOLIN 106.08 11774.97
404220100036 404220100036001 HUMULIN R (VIAL) 77.99 11421.52
404220100252 404220100252001 HUMULIN R (VIAL) 27.99 11421.52
404220100252002 HUMULIN R (VIAL) 27.99 11421.52
404220100252003 HUMULIN R (VIAL) 27.99 11421.52
404220100252004 HUMULIN R (VIAL) 27.99 11421.52
HC-059I 07:41 Thursday, March 11, 2004 19
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
404220100252 404220100252005 HUMULIN R (VIAL) 27.99 11421.52
404910180159 404910180159001 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180159002 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180159003 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180159004 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180159005 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180159006 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180337 404910180337001 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180337002 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180337003 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180337004 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180337005 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180337006 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180337007 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180337008 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180337009 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404910180337010 RELION/NOVOLIN 70/30 (VIAL) 24.10 4323.14
404930130044 404930130044001 INSULIN NOVOLIN 106.08 2568.91
404930130284 404930130284001 INSULIN, HUMAN NPH 25.30 2568.91
404930130284002 NOVOLIN N (VIAL) 25.30 2568.91
404930130284003 INSULIN, HUMAN NPH 25.30 2568.91
404930130397 404930130397001 NOVOLIN N (VIAL) 25.30 2568.91
404930130397002 INSULIN, HUMAN NPH 25.30 2568.91
404930200075 404930200075001 NOVOLIN INSULIN 100.57 3190.97
404930200188 404930200188001 NOVOLIN 70/30 (VIAL) 25.30 3190.97
404930200188002 NOVOLIN 70/30 (VIAL) 25.30 3190.97
404930200188003 NOVOLIN 70/30 (VIAL) 25.30 3190.97
404930200188004 NOVOLIN 70/30 (VIAL) 25.30 3190.97
404930200277 404930200277001 NOVOLIN 70/30 (VIAL) 25.30 3190.97
404930200277002 NOVOLIN 70/30 (VIAL) 25.30 3190.97
404930200277003 NOVOLIN 70/30 (VIAL) 25.30 3190.97
405450650040 405450650040001 INSULIN NOVOLIN 50.60 6704.50
405450650040002 INSULIN NOVOLIN 50.60 6704.50
405650150143 405650150143001 INSULIN NOVOLIN 30.30 6899.91
405650150143002 INSULIN NOVOLIN 30.30 6899.91
405650150143003 INSULIN NOVOLIN 30.30 6899.91
405650150143004 INSULIN NOVOLIN 30.30 6899.91
405650150143005 INSULIN NOVOLIN 30.30 6899.91
HC-059I 07:41 Thursday, March 11, 2004 20
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
406250160054 406250160054001 NOVOLIN R (VIAL) 75.90 5118.49
406250160054002 NOVOLIN R (VIAL) 75.90 5118.49
406250160054003 NOVOLIN R (VIAL) 75.90 5118.49
406250160054004 NOVOLIN R (VIAL) 75.90 5118.49
406250160054005 NOVOLIN R (VIAL) 75.90 5118.49
406250160054006 NOVOLIN R (VIAL) 75.90 5118.49
406250160054007 NOVOLIN R (VIAL) 75.90 5118.49
406250160054008 NOVOLIN R (VIAL) 75.90 5118.49
406250160143 406250160143001 NOVOLIN N (VIAL) 75.90 5118.49
406250160143002 NOVOLIN N (VIAL) 75.90 5118.49
406880180037 406880180037001 NOVOLIN INSULIN 100.57 8986.10
406880180037002 NOVOLIN INSULIN 100.57 8986.10
406880180037003 NOVOLIN INSULIN 100.57 8986.10
406880180037004 NOVOLIN INSULIN 100.57 8986.10
406880180082 406880180082001 NOVOLIN INSULIN 100.57 8986.10
407770250137 407770250137001 HUMULIN 70/30 (VIAL) 50.60 6471.81
407770250137002 HUMULIN 70/30 (VIAL) 50.60 6471.81
407770250137003 HUMULIN 70/30 (VIAL) 50.60 6471.81
407770250137004 HUMULIN 70/30 (VIAL) 50.60 6471.81
407770250137005 HUMULIN 70/30 (VIAL) 50.60 6471.81
407770250137006 HUMULIN 70/30 (VIAL) 50.60 6471.81
407770250428 407770250428001 HUMULIN 70/30 (VIAL) 50.60 6471.81
407770250428002 HUMULIN 70/30 (VIAL) 50.60 6471.81
407770250428003 HUMULIN 70/30 (VIAL) 50.60 6471.81
407770250428004 HUMULIN 70/30 (VIAL) 50.60 6471.81
407770250428005 HUMULIN 70/30 (VIAL) 50.60 6471.81
409050280044 409050280044001 NOVOLIN INSULIN 100.57 5780.52
409050280044002 NOVOLIN INSULIN 100.57 5780.52
410270260394 410270260394001 INSULIN NOVOLIN 106.08 7819.48
410270260394002 INSULIN NOVOLIN 106.08 7819.48
410270260394003 INSULIN NOVOLIN 106.08 7819.48
410270260394004 INSULIN NOVOLIN 106.08 7819.48
410270260394005 INSULIN NOVOLIN 106.08 7819.48
410820200188 410820200188001 INSULIN NOVOLIN 50.60 10874.49
410820200291 410820200291001 INSULIN NOVOLIN 50.60 10874.49
410820200291002 INSULIN NOVOLIN 50.60 10874.49
410820200291003 INSULIN NOVOLIN 50.60 10874.49
410820200291004 INSULIN NOVOLIN 50.60 10874.49
411100120027 411100120027001 INSULIN NOVOLIN 106.08 10608.83
HC-059I 07:41 Thursday, March 11, 2004 21
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
411100120027 411100120027002 INSULIN NOVOLIN 106.08 10608.83
411100120027003 INSULIN NOVOLIN 106.08 10608.83
411330390034 411330390034001 INSULIN NOVOLIN 106.08 8575.06
411330390034002 INSULIN NOVOLIN 106.08 8575.06
411330390034003 INSULIN NOVOLIN 106.08 8575.06
411330390034004 INSULIN NOVOLIN 106.08 8575.06
411330390034005 INSULIN NOVOLIN 106.08 8575.06
411330390123 411330390123001 INSULIN NOVOLIN 106.08 8575.06
411330390123002 INSULIN NOVOLIN 106.08 8575.06
411330390123003 INSULIN NOVOLIN 106.08 8575.06
411330390123004 INSULIN NOVOLIN 106.08 8575.06
411330390123005 INSULIN NOVOLIN 106.08 8575.06
411330390123006 INSULIN NOVOLIN 106.08 8575.06
411330390123007 INSULIN NOVOLIN 106.08 8575.06
411330390123008 INSULIN NOVOLIN 106.08 8575.06
411330390229 411330390229001 INSULIN NOVOLIN 106.08 8575.06
411330390229002 INSULIN NOVOLIN 106.08 8575.06
411330390229003 INSULIN NOVOLIN 106.08 8575.06
411620190304 411620190304001 HUMULIN-NPH 21.13 4384.55
411620190304002 HUMULIN-NPH 21.13 4384.55
411620190304003 HUMULIN-NPH 21.13 4384.55
411620190304004 HUMULIN-NPH 21.13 4384.55
411620190304005 HUMULIN-NPH 21.13 4384.55
411620190304006 HUMULIN-NPH 21.13 4384.55
411620190304007 HUMULIN-NPH 21.13 4384.55
411620190304008 HUMULIN-NPH 21.13 4384.55
411990930383 411990930383001 INSULIN NOVOLIN 106.08 10433.90
411990930496 411990930496001 INSULIN NOVOLIN 106.08 10433.90
413130250074 413130250074001 INSULIN NOVOLIN 106.08 13555.55
413130250245 413130250245001 NOVOLIN INSULIN 100.57 13555.55
413130250447 413130250447001 NOVOLIN INSULIN 100.57 13555.55
413400110246 413400110246001 HUMALOG (VIAL) 95.40 8739.59
413400110246002 HUMALOG (VIAL) 143.10 8739.59
413400110246003 HUMALOG (VIAL) 95.40 8739.59
413400110246004 HUMALOG (VIAL) 95.40 8739.59
413400110246005 HUMALOG (VIAL) 95.40 8739.59
413400110246006 HUMALOG (VIAL) 143.10 8739.59
413400110246007 HUMALOG (VIAL) 143.10 8739.59
413400110246008 HUMALOG (VIAL) 95.40 8739.59
HC-059I 07:41 Thursday, March 11, 2004 22
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-059A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP01X PERWT01F
413400110513 413400110513001 HUMALOG (VIAL) 95.40 8739.59
413400110513002 HUMALOG (VIAL) 95.40 8739.59
413400110513003 HUMALOG (VIAL) 95.40 8739.59
413400110513004 HUMALOG (VIAL) 95.40 8739.59
413400110695 413400110695001 HUMULIN R (VIAL) 75.90 8739.59
413400110695002 HUMULIN R (VIAL) 75.90 8739.59
413520170024 413520170024001 NOVOLIN INSULIN 100.57 10292.15
413520170024002 NOVOLIN INSULIN 100.57 10292.15
413520170024003 NOVOLIN INSULIN 100.57 10292.15
HC-059I 07:41 Thursday, March 11, 2004 23
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
The MEANS Procedure
Analysis Variable : RXXP01X SUM OF PAYMENTS RXSF01X-RXOU01X(IMPUTED)
N Sum
--------------------
2130 156566.48
--------------------
HC-059I 07:41 Thursday, March 11, 2004 24
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
Weighted
The MEANS Procedure
Analysis Variable : RXXP01X SUM OF PAYMENTS RXSF01X-RXOU01X(IMPUTED)
N Sum
--------------------
2130 1346125461
--------------------
<< previous page
|