NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
NOTE: This session is executing on the XP_PRO platform.
NOTE: SAS 9.1.3 Service Pack 4
NOTE: SAS initialization used:
real time 5.59 seconds
cpu time 1.26 seconds
NOTE: AUTOEXEC processing beginning; file is I:\WW3\APPLIC~1\SAS\FOUNDA~1.3\sas\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-102I";
4 TITLE2 "Sample SAS Job for Example A";
5
6 LIBNAME IN "C:\Data";
NOTE: Libref IN was successfully assigned as follows:
Engine: V9
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 (Total process time):
real time 0.09 seconds
cpu time 0.00 seconds
24
25 *-------------------------------------------------------------------------------------
26 * Get condition records coded as asthma.
27 *-------------------------------------------------------------------------------------;
28 DATA ASCONDS;
29 SET IN.H104 (KEEP=CONDIDX CCCODEX);
30 IF CCCODEX="128";
31
32 RUN;
NOTE: There were 105166 observations read from the data set IN.H104.
NOTE: The data set WORK.ASCONDS has 1990 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.26 seconds
cpu time 0.12 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 1990 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1990 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.06 seconds
cpu time 0.03 seconds
38
39 proc print data=asconds (obs=50);
40 title3 "sample print of work.asconds - sorted by condidx";
41 title4 "COND (H104) records where cccodex=128";
42 run;
NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.12 seconds
cpu time 0.00 seconds
43
44 PROC SORT DATA=IN.H102IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 350780 observations read from the data set IN.H102IF1.
NOTE: The data set WORK.CLNK has 350780 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1.95 seconds
cpu time 0.85 seconds
45
46 DATA ASCLNKS;
47 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
48 ASCONDS(IN=INASCOND KEEP=CONDIDX);
49 BY CONDIDX;
50 IF INCLNK & INASCOND;
51 RUN;
NOTE: There were 350780 observations read from the data set WORK.CLNK.
NOTE: There were 1990 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7984 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 1.43 seconds
cpu time 0.39 seconds
52
53 proc print data=asclnks (obs=75);
54 by condidx;
55 id condidx;
56 format eventype eventype.;
57 title3 "sample print of work.asclnks - sorted by condidx";
58 title4 "events linked to asthma condition records";
59 run;
NOTE: There were 75 observations read from the data set WORK.ASCLNKS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.07 seconds
cpu time 0.01 seconds
60
61 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7984 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7984 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 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: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
67
68 DATA ASCLNKS;
69 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
70 BY EVNTIDX;
71 IF FIRST.EVNTIDX;
72 RUN;
NOTE: There were 7984 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7978 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 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: PROCEDURE PRINT used (Total process time):
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.H102G (KEEP=EVNTIDX PERWT06F SEETLKPV);
84 IF PERWT06F > 0 & SEETLKPV NE 2;
85 RUN;
NOTE: There were 155502 observations read from the data set IN.H102G.
NOTE: The data set WORK.MVIS has 151007 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 1.28 seconds
cpu time 0.26 seconds
86
87 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 151007 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 151007 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.21 seconds
cpu time 0.17 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;
NOTE: There were 7978 observations read from the data set WORK.ASCLNKS.
NOTE: There were 151007 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 2320 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.18 seconds
98
99 proc print data=asmvis (obs=50);
100 format eventype eventype.;
101 title3 "sample print of work.asmvis";
102 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-102G) events";
103 run;
NOTE: There were 50 observations read from the data set WORK.ASMVIS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.28 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.H102IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: There were 61068 observations read from the data set IN.H102IF2.
NOTE: The data set WORK.RXLK has 61068 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.14 seconds
cpu time 0.10 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-102IF2)";
117 run;
NOTE: There were 140 observations read from the data set WORK.RXLK.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
118
119 DATA PMEDIDS;
120 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
121 ASMVIS(IN=INASMVIS KEEP=EVNTIDX);
122 BY EVNTIDX;
123 IF INRXLK & INASMVIS;
124 RUN;
NOTE: There were 61068 observations read from the data set WORK.RXLK.
NOTE: There were 2320 observations read from the data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 2353 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.06 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: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
133
134 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 2353 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 2353 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
135
136 proc print data=pmedids (obs=50);
137 format eventype eventype.;
138 title3 "sample print of work.pmedids - sorted by linkidx";
139 run;
NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: PROCEDURE PRINT used (Total process time):
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;
NOTE: There were 2353 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 2240 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 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: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
150
151 *-----------------------------------------------------------------------------------------
152 * Get PMED records linked to MVIS events which were for asthma.
153 *-----------------------------------------------------------------------------------------;
154 PROC SORT DATA=IN.H102A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 341994 observations read from the data set IN.H102A.
NOTE: The data set WORK.PMED has 341994 observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 16.06 seconds
cpu time 2.84 seconds
155
156 DATA MVPMEDS;
157 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP06X PERWT06F RXNAME)
158 PMEDIDS (IN=A);
159 BY LINKIDX;
160 IF A;
161 RUN;
NOTE: There were 341994 observations read from the data set WORK.PMED.
NOTE: There were 2240 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 6040 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.42 seconds
cpu time 0.42 seconds
162
163 proc print data=mvpmeds (obs=200);
164 var rxrecidx rxname RXXP06X PERWT06F;
165 by linkidx;
166 id linkidx;
167 title3 "sample print of work.mvpmeds";
168 title4 "PMED (HC-102A) records for unique linkidxs in work.pmedids";
169 run;
NOTE: There were 200 observations read from the data set WORK.MVPMEDS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
170
171 PROC MEANS DATA=MVPMEDS N SUM;
172 VAR RXXP06X;
173 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
174 RUN;
NOTE: There were 6040 observations read from the data set WORK.MVPMEDS.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.15 seconds
cpu time 0.03 seconds
175
176 PROC MEANS DATA=MVPMEDS N SUM;
177 VAR RXXP06X;
178 WEIGHT PERWT06F;
179 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
180 TITLE5 "Weighted";
181 RUN;
NOTE: There were 6040 observations read from the data set WORK.MVPMEDS.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
HC-102I 13:16 Friday, September 19, 2008 1
Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H104) records where cccodex=128
Obs CCCODEX CONDIDX
1 128 300180180093
2 128 300230580049
3 128 300400300014
4 128 300490270010
5 128 300600350034
6 128 300610290019
7 128 300680130051
8 128 300830210012
9 128 300910450025
10 128 301170420016
11 128 301320230021
12 128 301470290031
13 128 302050190018
14 128 302050330038
15 128 302050330050
16 128 302070200083
17 128 302170520040
18 128 302560570015
19 128 302740680016
20 128 302850140023
21 128 302920640046
22 128 302950160019
23 128 302950230018
24 128 302980530024
25 128 303290290060
26 128 303350230045
27 128 303510370015
28 128 303600490028
29 128 303670100066
30 128 303730200010
31 128 303760240088
32 128 303760240204
33 128 303780330060
34 128 303780400075
35 128 303930110039
36 128 304140140175
37 128 304220290013
38 128 304220360012
39 128 304250390016
40 128 304280150074
41 128 304540490089
42 128 304550430109
43 128 304570200013
44 128 304620150092
45 128 304620270080
46 128 304710110124
47 128 304740470017
48 128 304840230070
49 128 305110240030
50 128 305260250057
HC-102I 13:16 Friday, September 19, 2008 2
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
300180180093 300180180418 8 PMED
300180180521 8 PMED
300180180610 1 MVIS
300230580049 300230580090 3 EROM
300230580103 3 EROM
300230580110 3 EROM
300230580141 1 MVIS
300230580158 8 PMED
300400300014 300400300031 3 EROM
300400300048 8 PMED
300400300055 8 PMED
300400300062 8 PMED
300600350034 300600350206 1 MVIS
300610290019 300610290292 1 MVIS
300610290305 1 MVIS
300610290312 1 MVIS
300610290336 8 PMED
300610290350 8 PMED
300610290367 8 PMED
300610290374 8 PMED
300610290398 8 PMED
300610290418 1 MVIS
300610290456 8 PMED
300680130051 300680130196 8 PMED
300680130209 8 PMED
300680130230 8 PMED
300680130247 8 PMED
300910450025 300910450099 8 PMED
300910450102 8 PMED
300910450164 8 PMED
300910450171 8 PMED
301170420016 301170420048 8 PMED
301170420062 8 PMED
301320230021 301320230287 8 PMED
301320230383 8 PMED
301320230390 8 PMED
301320230472 8 PMED
301320230489 8 PMED
301470290031 301470290097 1 MVIS
301470290100 1 MVIS
HC-102I 13:16 Friday, September 19, 2008 3
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
301470290031 301470290124 8 PMED
302050190018 302050190016 8 PMED
302050190023 8 PMED
302050330038 302050330054 1 MVIS
302050330078 3 EROM
302050330092 8 PMED
302050330112 8 PMED
302050330050 302050330085 8 PMED
302070200083 302070200148 8 PMED
302070200155 8 PMED
302170520040 302170520033 8 PMED
302560570015 302560570125 8 PMED
302920640046 302920640123 1 MVIS
302920640130 8 PMED
302920640147 8 PMED
302950230018 302950230057 8 PMED
302950230115 8 PMED
303290290060 303290290117 8 PMED
303290290148 8 PMED
303350230045 303350230445 8 PMED
303350230558 8 PMED
303350230572 1 MVIS
303350230589 1 MVIS
303350230596 1 MVIS
303350230623 8 PMED
303350230630 8 PMED
303350230661 8 PMED
303350230678 8 PMED
303350230705 8 PMED
303350230729 8 PMED
303350230801 8 PMED
303350230825 8 PMED
303350230849 8 PMED
303510370015 303510370359 8 PMED
303510370366 8 PMED
HC-102I 13:16 Friday, September 19, 2008 4
Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx
Obs EVNTIDX EVENTYPE CONDIDX
1 300180180418 8 PMED 300180180093
2 300180180521 8 PMED 300180180093
3 300180180610 1 MVIS 300180180093
4 300230580090 3 EROM 300230580049
5 300230580103 3 EROM 300230580049
6 300230580110 3 EROM 300230580049
7 300230580141 1 MVIS 300230580049
8 300230580158 8 PMED 300230580049
9 300400300031 3 EROM 300400300014
10 300400300048 8 PMED 300400300014
11 300400300055 8 PMED 300400300014
12 300400300062 8 PMED 300400300014
13 300600350206 1 MVIS 300600350034
14 300610290292 1 MVIS 300610290019
15 300610290305 1 MVIS 300610290019
16 300610290312 1 MVIS 300610290019
17 300610290336 8 PMED 300610290019
18 300610290350 8 PMED 300610290019
19 300610290367 8 PMED 300610290019
20 300610290374 8 PMED 300610290019
21 300610290398 8 PMED 300610290019
22 300610290418 1 MVIS 300610290019
23 300610290456 8 PMED 300610290019
24 300680130196 8 PMED 300680130051
25 300680130209 8 PMED 300680130051
26 300680130230 8 PMED 300680130051
27 300680130247 8 PMED 300680130051
28 300910450099 8 PMED 300910450025
29 300910450102 8 PMED 300910450025
30 300910450164 8 PMED 300910450025
31 300910450171 8 PMED 300910450025
32 301170420048 8 PMED 301170420016
33 301170420062 8 PMED 301170420016
34 301320230287 8 PMED 301320230021
35 301320230383 8 PMED 301320230021
36 301320230390 8 PMED 301320230021
37 301320230472 8 PMED 301320230021
38 301320230489 8 PMED 301320230021
39 301470290097 1 MVIS 301470290031
40 301470290100 1 MVIS 301470290031
41 301470290124 8 PMED 301470290031
42 302050190016 8 PMED 302050190018
43 302050190023 8 PMED 302050190018
44 302050330054 1 MVIS 302050330038
45 302050330078 3 EROM 302050330038
46 302050330085 8 PMED 302050330050
47 302050330092 8 PMED 302050330038
48 302050330112 8 PMED 302050330038
49 302070200148 8 PMED 302070200083
50 302070200155 8 PMED 302070200083
HC-102I 13:16 Friday, September 19, 2008 5
Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 300180180418 8 PMED
2 300180180521 8 PMED
3 300180180610 1 MVIS
4 300230580090 3 EROM
5 300230580103 3 EROM
6 300230580110 3 EROM
7 300230580141 1 MVIS
8 300230580158 8 PMED
9 300400300031 3 EROM
10 300400300048 8 PMED
11 300400300055 8 PMED
12 300400300062 8 PMED
13 300600350206 1 MVIS
14 300610290292 1 MVIS
15 300610290305 1 MVIS
16 300610290312 1 MVIS
17 300610290336 8 PMED
18 300610290350 8 PMED
19 300610290367 8 PMED
20 300610290374 8 PMED
21 300610290398 8 PMED
22 300610290418 1 MVIS
23 300610290456 8 PMED
24 300680130196 8 PMED
25 300680130209 8 PMED
26 300680130230 8 PMED
27 300680130247 8 PMED
28 300910450099 8 PMED
29 300910450102 8 PMED
30 300910450164 8 PMED
31 300910450171 8 PMED
32 301170420048 8 PMED
33 301170420062 8 PMED
34 301320230287 8 PMED
35 301320230383 8 PMED
36 301320230390 8 PMED
37 301320230472 8 PMED
38 301320230489 8 PMED
39 301470290097 1 MVIS
40 301470290100 1 MVIS
41 301470290124 8 PMED
42 302050190016 8 PMED
43 302050190023 8 PMED
44 302050330054 1 MVIS
45 302050330078 3 EROM
46 302050330085 8 PMED
47 302050330092 8 PMED
48 302050330112 8 PMED
49 302070200148 8 PMED
50 302070200155 8 PMED
HC-102I 13:16 Friday, September 19, 2008 6
Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-102G) events
Obs EVNTIDX EVENTYPE
1 300180180610 1 MVIS
2 300230580141 1 MVIS
3 300600350206 1 MVIS
4 300610290292 1 MVIS
5 300610290305 1 MVIS
6 300610290312 1 MVIS
7 301470290097 1 MVIS
8 301470290100 1 MVIS
9 302050330054 1 MVIS
10 302920640123 1 MVIS
11 303350230572 1 MVIS
12 303350230589 1 MVIS
13 303670100336 1 MVIS
14 303760240669 1 MVIS
15 303760240683 1 MVIS
16 303760240690 1 MVIS
17 303760240703 1 MVIS
18 303760240710 1 MVIS
19 303760240734 1 MVIS
20 303780330350 1 MVIS
21 303780330367 1 MVIS
22 303780330381 1 MVIS
23 303780330398 1 MVIS
24 303780330401 1 MVIS
25 303780400158 1 MVIS
26 303780400223 1 MVIS
27 304140140813 1 MVIS
28 304140140820 1 MVIS
29 304140140837 1 MVIS
30 304140140844 1 MVIS
31 304140140851 1 MVIS
32 304140140868 1 MVIS
33 304140141501 1 MVIS
34 304140141518 1 MVIS
35 304140141525 1 MVIS
36 304140141532 1 MVIS
37 304140141549 1 MVIS
38 304140141690 1 MVIS
39 304140141703 1 MVIS
40 304140141710 1 MVIS
41 304140141727 1 MVIS
42 304140141734 1 MVIS
43 304140141741 1 MVIS
44 304140141758 1 MVIS
45 304140141765 1 MVIS
46 304140141772 1 MVIS
47 304140141789 1 MVIS
48 304220360147 1 MVIS
49 304250390218 1 MVIS
50 304280150687 1 MVIS
HC-102I 13:16 Friday, September 19, 2008 7
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-102IF2)
EVNTIDX LINKIDX EVENTYPE
300020190021 300020190045 3 EROM
300020190052 3 EROM
300020190069 3 EROM
300020190076 3 EROM
300020190083 3 EROM
300020190090 3 EROM
300020190110 300020190189 1 MVIS
300020190196 1 MVIS
300020190209 1 MVIS
300020190216 1 MVIS
300020190223 1 MVIS
300040270167 300040270181 1 MVIS
300040270201 300040270225 1 MVIS
300040270232 1 MVIS
300050150559 300050150686 1 MVIS
300050150693 1 MVIS
300050150706 1 MVIS
300050150713 1 MVIS
300050150720 1 MVIS
300050150737 1 MVIS
300050150744 1 MVIS
300050150751 1 MVIS
300050150768 1 MVIS
300050150775 1 MVIS
300060360081 300060360098 2 OPAT
300080830080 300080830100 1 MVIS
300080830117 1 MVIS
300080830097 300080830100 1 MVIS
300080830117 1 MVIS
300090130169 300090130203 1 MVIS
300090130258 300090130272 1 MVIS
300100100332 300100100363 1 MVIS
300110100771 300110101161 1 MVIS
300110101178 1 MVIS
300110100795 300110101161 1 MVIS
300110101178 1 MVIS
HC-102I 13:16 Friday, September 19, 2008 8
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-102IF2)
EVNTIDX LINKIDX EVENTYPE
300110100808 300110101161 1 MVIS
300110101178 1 MVIS
300110100815 300110101161 1 MVIS
300110101178 1 MVIS
300110100822 300110101161 1 MVIS
300110101178 1 MVIS
300110101003 300110101185 1 MVIS
300110101109 300110101192 3 EROM
300110101205 3 EROM
300110101116 300110101161 3 EROM
300110101178 3 EROM
300110101185 3 EROM
300110101212 3 EROM
300110101229 3 EROM
300110101236 3 EROM
300110101243 3 EROM
300110101250 3 EROM
300110101267 3 EROM
300110101274 3 EROM
300110101281 3 EROM
300110101123 300110101281 4 STAZ
300130290174 300130290181 1 MVIS
300130290201 300130290249 5 DVIS
300160270162 300160270193 1 MVIS
300160270179 300160270206 1 MVIS
300160270186 300160270213 5 DVIS
300160270220 5 DVIS
300160270237 5 DVIS
300160270244 5 DVIS
300160270268 300160270302 1 MVIS
300170230131 300170230179 2 OPAT
300170230237 300170230244 1 MVIS
300170470179 300170470186 1 MVIS
HC-102I 13:16 Friday, September 19, 2008 9
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-102IF2)
EVNTIDX LINKIDX EVENTYPE
300170470193 300170470206 3 EROM
300180180590 300180180843 3 EROM
300180180665 300180180867 1 MVIS
300200190054 300200190061 1 MVIS
300200310094 300200310107 1 MVIS
300200310121 300200310138 1 MVIS
300200310145 1 MVIS
300200310152 300200310190 1 MVIS
300200490048 300200490055 1 MVIS
300210180201 300210180218 1 MVIS
300210180225 1 MVIS
300210180232 1 MVIS
300230410103 300230410110 1 MVIS
300230410127 1 MVIS
300230580110 300230580158 3 EROM
300230580141 300230580165 1 MVIS
300250110050 300250110067 1 MVIS
300260210032 300260210049 1 MVIS
300260210056 1 MVIS
300260420035 300260420042 1 MVIS
300270110015 300270110039 1 MVIS
300270130020 300270130037 4 STAZ
300280150332 300280150387 1 MVIS
300280150394 1 MVIS
300280150452 300280150534 1 MVIS
300280150510 300280150541 1 MVIS
300280150558 1 MVIS
300280150565 1 MVIS
300280220205 300280220274 1 MVIS
HC-102I 13:16 Friday, September 19, 2008 10
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-102IF2)
EVNTIDX LINKIDX EVENTYPE
300280220212 300280220281 1 MVIS
300280220363 300280220630 1 MVIS
300280220476 300280220647 4 STAZ
300280390387 300280390414 1 MVIS
300280390438 300280390490 1 MVIS
300280390503 1 MVIS
300280460116 300280460154 1 MVIS
300320170391 300320170411 1 MVIS
300320170473 300320170548 1 MVIS
300320170555 1 MVIS
300320170562 1 MVIS
300320170579 1 MVIS
300320170586 1 MVIS
300320170593 1 MVIS
300320170606 1 MVIS
300320170613 300320170637 1 MVIS
300320310113 300320310120 1 MVIS
300340260019 300340260026 1 MVIS
300340340183 300340340227 1 MVIS
300340340234 1 MVIS
300360250228 300360250259 1 MVIS
300360250266 1 MVIS
300370170926 300370171070 4 STAZ
300370171094 4 STAZ
300370240039 300370240053 1 MVIS
300370240060 1 MVIS
300380271006 300380271082 1 MVIS
300380271099 1 MVIS
300380271044 300380271102 1 MVIS
300400160048 300400160062 3 EROM
300400300031 300400300048 3 EROM
HC-102I 13:16 Friday, September 19, 2008 11
Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-102IF2)
EVNTIDX LINKIDX EVENTYPE
300400300031 300400300055 3 EROM
300400300062 3 EROM
300410130222 300410130253 1 MVIS
300410130284 300410130335 1 MVIS
300410130342 1 MVIS
300410130304 300410130359 1 MVIS
300420180111 300420180128 1 MVIS
300420180142 300420180313 1 MVIS
300430120071 300430120095 5 DVIS
300430120108 5 DVIS
300430290184 300430290228 1 MVIS
HC-102I 13:16 Friday, September 19, 2008 12
Sample SAS Job for Example A
sample print of work.pmedids - sorted by evntidx
work.rxlk records for evntidxs in work.asmvis
EVNTIDX EVENTYPE LINKIDX
300230580141 1 MVIS 300230580165
300600350206 1 MVIS 300600350244
301470290097 1 MVIS 301470290117
1 MVIS 301470290124
302050330054 1 MVIS 302050330085
302920640123 1 MVIS 302920640130
1 MVIS 302920640147
303350230572 1 MVIS 303350230616
1 MVIS 303350230623
303780330350 1 MVIS 303780330425
303780330398 1 MVIS 303780330449
1 MVIS 303780330456
1 MVIS 303780330463
303780330401 1 MVIS 303780330470
303780400158 1 MVIS 303780400172
1 MVIS 303780400189
1 MVIS 303780400196
303780400223 1 MVIS 303780400247
1 MVIS 303780400254
304140140813 1 MVIS 304140141309
1 MVIS 304140141316
1 MVIS 304140141323
1 MVIS 304140141330
1 MVIS 304140141347
1 MVIS 304140141354
1 MVIS 304140141361
1 MVIS 304140141378
1 MVIS 304140141385
1 MVIS 304140141392
1 MVIS 304140141405
1 MVIS 304140141412
1 MVIS 304140141429
304140141501 1 MVIS 304140141885
1 MVIS 304140141892
1 MVIS 304140141905
1 MVIS 304140141912
1 MVIS 304140141929
HC-102I 13:16 Friday, September 19, 2008 13
Sample SAS Job for Example A
sample print of work.pmedids - sorted by evntidx
work.rxlk records for evntidxs in work.asmvis
EVNTIDX EVENTYPE LINKIDX
304140141501 1 MVIS 304140141936
1 MVIS 304140141943
1 MVIS 304140141950
1 MVIS 304140141967
1 MVIS 304140141974
1 MVIS 304140141981
1 MVIS 304140141998
1 MVIS 304140142004
1 MVIS 304140142011
304140141690 1 MVIS 304140141892
1 MVIS 304140141905
1 MVIS 304140141912
1 MVIS 304140141943
HC-102I 13:16 Friday, September 19, 2008 14
Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx
Obs EVNTIDX EVENTYPE LINKIDX
1 300230580141 1 MVIS 300230580165
2 300600350206 1 MVIS 300600350244
3 301470290097 1 MVIS 301470290117
4 301470290097 1 MVIS 301470290124
5 302050330054 1 MVIS 302050330085
6 302920640123 1 MVIS 302920640130
7 302920640123 1 MVIS 302920640147
8 303350230572 1 MVIS 303350230616
9 303350230572 1 MVIS 303350230623
10 303780330350 1 MVIS 303780330425
11 303780330398 1 MVIS 303780330449
12 303780330398 1 MVIS 303780330456
13 303780330398 1 MVIS 303780330463
14 303780330401 1 MVIS 303780330470
15 303780400158 1 MVIS 303780400172
16 303780400158 1 MVIS 303780400189
17 303780400158 1 MVIS 303780400196
18 303780400223 1 MVIS 303780400247
19 303780400223 1 MVIS 303780400254
20 304140140813 1 MVIS 304140141309
21 304140140813 1 MVIS 304140141316
22 304140140813 1 MVIS 304140141323
23 304140140813 1 MVIS 304140141330
24 304140140813 1 MVIS 304140141347
25 304140140813 1 MVIS 304140141354
26 304140140813 1 MVIS 304140141361
27 304140140813 1 MVIS 304140141378
28 304140140813 1 MVIS 304140141385
29 304140140813 1 MVIS 304140141392
30 304140140813 1 MVIS 304140141405
31 304140140813 1 MVIS 304140141412
32 304140140813 1 MVIS 304140141429
33 304140141501 1 MVIS 304140141885
34 304140141501 1 MVIS 304140141892
35 304140141690 1 MVIS 304140141892
36 304140141501 1 MVIS 304140141905
37 304140141690 1 MVIS 304140141905
38 304140141501 1 MVIS 304140141912
39 304140141690 1 MVIS 304140141912
40 304140141501 1 MVIS 304140141929
41 304140141501 1 MVIS 304140141936
42 304140141501 1 MVIS 304140141943
43 304140141690 1 MVIS 304140141943
44 304140141501 1 MVIS 304140141950
45 304140141690 1 MVIS 304140141950
46 304140141501 1 MVIS 304140141967
47 304140141690 1 MVIS 304140141967
48 304140141501 1 MVIS 304140141974
49 304140141501 1 MVIS 304140141981
50 304140141501 1 MVIS 304140141998
HC-102I 13:16 Friday, September 19, 2008 15
Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids
Obs LINKIDX
1 300230580165
2 300600350244
3 301470290117
4 301470290124
5 302050330085
6 302920640130
7 302920640147
8 303350230616
9 303350230623
10 303780330425
11 303780330449
12 303780330456
13 303780330463
14 303780330470
15 303780400172
16 303780400189
17 303780400196
18 303780400247
19 303780400254
20 304140141309
21 304140141316
22 304140141323
23 304140141330
24 304140141347
25 304140141354
26 304140141361
27 304140141378
28 304140141385
29 304140141392
30 304140141405
31 304140141412
32 304140141429
33 304140141885
34 304140141892
35 304140141905
36 304140141912
37 304140141929
38 304140141936
39 304140141943
40 304140141950
41 304140141967
42 304140141974
43 304140141981
44 304140141998
45 304140142004
46 304140142011
47 304140142035
48 305110240177
49 305110240184
50 305110240191
HC-102I 13:16 Friday, September 19, 2008 16
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-102A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
300230580165 300230580165001 SINGULAIR 92.12 4647.878284
300600350244 300600350244001 AMOXICILLIN (RASPBERRY-STRAWBERRY) 12.18 5451.825282
301470290117 301470290117001 AZITHROMYCIN 30.64 4964.901754
301470290124 301470290124001 BRETHINE 44.75 4964.901754
302050330085 302050330085001 PULMICORT RESPULES (5X6) 300.88 4355.758139
302920640130 302920640130001 ALBUTEROL SULFATE (VIAL) 25.58 1436.909526
302920640147 302920640147001 PULMICORT RESPULES (5X6) 304.70 1436.909526
303350230616 303350230616001 ZITHROMAX 34.22 8363.548295
303350230623 303350230623001 METHYLPREDNISOLONE 8.66 8363.548295
303350230623002 METHYLPREDNISOLONE 8.66 8363.548295
303780330425 303780330425001 PREDNISONE (PEPPERMINT-VANILLA) 26.41 15296.326798
303780330425002 PREDNISONE (PEPPERMINT-VANILLA) 26.41 15296.326798
303780330449 303780330449001 RESPI-TANN (DYE-FREE,CHERRY) 55.65 15296.326798
303780330456 303780330456001 HALOBETASOL 108.99 15296.326798
303780330463 303780330463001 CORTANE-B 62.15 15296.326798
303780330470 303780330470001 HISDEC 5.69 15296.326798
303780400172 303780400172001 HISDEC 8.82 10940.657155
303780400189 303780400189001 ALBUTEROL INHALER 20.29 10940.657155
303780400189002 ALBUTEROL INHALER 20.29 10940.657155
303780400196 303780400196001 FLOVENT 134.00 10940.657155
303780400196002 FLOVENT 134.00 10940.657155
303780400247 303780400247001 PREDNISONE (PEPPERMINT-VANILLA) 26.41 10940.657155
303780400254 303780400254001 SINGULAIR 93.76 10940.657155
304140141309 304140141309001 APAP/HYDROCODONE BITARTRATE 55.79 4183.222652
304140141309002 APAP/HYDROCODONE BITARTRATE 55.79 4183.222652
304140141309003 APAP/HYDROCODONE BITARTRATE 55.79 4183.222652
304140141309004 APAP/HYDROCODONE BITARTRATE 55.79 4183.222652
304140141309005 APAP/HYDROCODONE BITARTRATE 55.79 4183.222652
304140141309006 APAP/HYDROCODONE BITARTRATE 55.79 4183.222652
HC-102I 13:16 Friday, September 19, 2008 17
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-102A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
304140141316 304140141316001 NAPROXEN 5.05 4183.222652
304140141316002 NAPROXEN 5.05 4183.222652
304140141316003 NAPROXEN 5.05 4183.222652
304140141316004 NAPROXEN 5.05 4183.222652
304140141316005 NAPROXEN 5.05 4183.222652
304140141316006 NAPROXEN 5.05 4183.222652
304140141323 304140141323001 ALBUTEROL 14.67 4183.222652
304140141323002 ALBUTEROL 14.67 4183.222652
304140141323003 ALBUTEROL 14.67 4183.222652
304140141323004 ALBUTEROL 14.67 4183.222652
304140141323005 ALBUTEROL 14.67 4183.222652
304140141323006 ALBUTEROL 14.67 4183.222652
304140141330 304140141330001 GEN ROBITUSSIN 9.99 4183.222652
304140141330002 GEN ROBITUSSIN 9.99 4183.222652
304140141330003 GEN ROBITUSSIN 9.99 4183.222652
304140141330004 GEN ROBITUSSIN 9.99 4183.222652
304140141330005 GEN ROBITUSSIN 9.99 4183.222652
304140141330006 GEN ROBITUSSIN 9.99 4183.222652
304140141347 304140141347001 FENTANYL 53.41 4183.222652
304140141347002 FENTANYL 53.41 4183.222652
304140141347003 FENTANYL 53.41 4183.222652
304140141347004 FENTANYL 53.41 4183.222652
304140141347005 FENTANYL 53.41 4183.222652
304140141347006 FENTANYL 53.41 4183.222652
304140141354 304140141354001 OXYCONTIN 3.31 4183.222652
304140141354002 OXYCONTIN 198.49 4183.222652
304140141354003 OXYCONTIN 693.44 4183.222652
304140141354004 OXYCONTIN 3.31 4183.222652
304140141354005 OXYCONTIN 693.44 4183.222652
304140141354006 OXYCONTIN 3.31 4183.222652
304140141361 304140141361001 HYDROCHLOROTHIAZIDE 6.70 4183.222652
304140141361002 HYDROCHLOROTHIAZIDE 6.70 4183.222652
304140141361003 HYDROCHLOROTHIAZIDE 6.70 4183.222652
304140141361004 HYDROCHLOROTHIAZIDE 6.70 4183.222652
304140141361005 HYDROCHLOROTHIAZIDE 6.70 4183.222652
304140141361006 HYDROCHLOROTHIAZIDE 6.70 4183.222652
304140141378 304140141378001 POTASSIUM 8.26 4183.222652
304140141378002 POTASSIUM 8.26 4183.222652
304140141378003 POTASSIUM 8.26 4183.222652
304140141378004 POTASSIUM 8.26 4183.222652
304140141378005 POTASSIUM 8.26 4183.222652
304140141378006 POTASSIUM 8.26 4183.222652
HC-102I 13:16 Friday, September 19, 2008 18
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-102A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
304140141385 304140141385001 DICAL-D 24.80 4183.222652
304140141385002 DICAL-D 24.80 4183.222652
304140141385003 DICAL-D 24.80 4183.222652
304140141385004 DICAL-D 24.80 4183.222652
304140141385005 DICAL-D 24.80 4183.222652
304140141385006 DICAL-D 24.80 4183.222652
304140141392 304140141392001 ATENOLOL 6.30 4183.222652
304140141405 304140141405001 OXYCONTIN 693.44 4183.222652
304140141405002 OXYCONTIN 5.87 4183.222652
304140141405003 OXYCONTIN 693.44 4183.222652
304140141405004 OXYCONTIN 5.87 4183.222652
304140141405005 OXYCONTIN 5.87 4183.222652
304140141405006 OXYCONTIN 5.87 4183.222652
304140141412 304140141412001 LIPITOR 212.51 4183.222652
304140141412002 LIPITOR 212.51 4183.222652
304140141412003 LIPITOR 212.51 4183.222652
304140141412004 LIPITOR 212.51 4183.222652
304140141412005 LIPITOR 212.51 4183.222652
304140141412006 LIPITOR 212.51 4183.222652
304140141429 304140141429001 BUMEX 54.01 4183.222652
304140141429002 BUMEX 54.01 4183.222652
304140141429003 BUMEX 54.01 4183.222652
304140141429004 BUMEX 54.01 4183.222652
304140141429005 BUMEX 54.01 4183.222652
304140141429006 BUMEX 54.01 4183.222652
304140141885 304140141885001 VICODIN 9.75 4183.222652
304140141885002 VICODIN 9.75 4183.222652
304140141885003 VICODIN 9.75 4183.222652
304140141885004 VICODIN 9.75 4183.222652
304140141885005 VICODIN 9.75 4183.222652
304140141892 304140141892001 NAPROXEN 35.78 4183.222652
304140141892002 NAPROXEN 35.78 4183.222652
304140141892003 NAPROXEN 35.78 4183.222652
304140141892004 NAPROXEN 35.78 4183.222652
304140141892005 NAPROXEN 35.78 4183.222652
304140141905 304140141905001 ALBUTEROL 10.38 4183.222652
304140141905002 ALBUTEROL 10.38 4183.222652
304140141912 304140141912001 GEN ROBITUSSIN 9.99 4183.222652
304140141912002 GEN ROBITUSSIN 9.99 4183.222652
304140141929 304140141929001 FENTANYL PATCH 65.95 4183.222652
HC-102I 13:16 Friday, September 19, 2008 19
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-102A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
304140141929 304140141929002 FENTANYL PATCH 65.95 4183.222652
304140141929003 FENTANYL PATCH 65.95 4183.222652
304140141929004 FENTANYL PATCH 65.95 4183.222652
304140141929005 FENTANYL PATCH 65.95 4183.222652
304140141936 304140141936001 HYDROCHLOROTHIAZIDE 8.00 4183.222652
304140141936002 HYDROCHLOROTHIAZIDE 8.00 4183.222652
304140141936003 HYDROCHLOROTHIAZIDE 8.00 4183.222652
304140141936004 HYDROCHLOROTHIAZIDE 8.00 4183.222652
304140141936005 HYDROCHLOROTHIAZIDE 8.00 4183.222652
304140141943 304140141943001 POTASSIUM 8.26 4183.222652
304140141943002 POTASSIUM 8.26 4183.222652
304140141943003 POTASSIUM 8.26 4183.222652
304140141943004 POTASSIUM 8.26 4183.222652
304140141943005 POTASSIUM 8.26 4183.222652
304140141950 304140141950001 CALCIUM 2.98 4183.222652
304140141950002 CALCIUM 2.98 4183.222652
304140141950003 CALCIUM 2.98 4183.222652
304140141950004 CALCIUM 2.98 4183.222652
304140141950005 CALCIUM 2.98 4183.222652
304140141967 304140141967001 BUMEX 54.01 4183.222652
304140141967002 BUMEX 54.01 4183.222652
304140141967003 BUMEX 54.01 4183.222652
304140141967004 BUMEX 54.01 4183.222652
304140141967005 BUMEX 54.01 4183.222652
304140141974 304140141974001 ASPIRIN 2.26 4183.222652
304140141974002 ASPIRIN 2.26 4183.222652
304140141974003 ASPIRIN 2.26 4183.222652
304140141974004 ASPIRIN 2.26 4183.222652
304140141974005 ASPIRIN 2.26 4183.222652
304140141981 304140141981001 OXYCONTIN 3.31 4183.222652
304140141981002 OXYCONTIN 198.49 4183.222652
304140141981003 OXYCONTIN 693.44 4183.222652
304140141981004 OXYCONTIN 198.49 4183.222652
304140141981005 OXYCONTIN 3.31 4183.222652
304140141998 304140141998001 LIPITOR 212.51 4183.222652
304140141998002 LIPITOR 212.51 4183.222652
304140141998003 LIPITOR 212.51 4183.222652
304140141998004 LIPITOR 212.51 4183.222652
304140141998005 LIPITOR 212.51 4183.222652
304140142004 304140142004001 ATENOLOL 6.30 4183.222652
304140142004002 ATENOLOL 6.30 4183.222652
HC-102I 13:16 Friday, September 19, 2008 20
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-102A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
304140142004 304140142004003 ATENOLOL 6.30 4183.222652
304140142004004 ATENOLOL 6.30 4183.222652
304140142004005 ATENOLOL 6.30 4183.222652
304140142011 304140142011001 BENADRYL 3.71 4183.222652
304140142011002 BENADRYL 3.71 4183.222652
304140142035 304140142035001 INDERAL LA 64.11 4183.222652
304140142035002 INDERAL LA 64.11 4183.222652
304140142035003 INDERAL LA 64.11 4183.222652
304140142035004 INDERAL LA 64.11 4183.222652
304140142035005 INDERAL LA 64.11 4183.222652
305110240177 305110240177001 LEVAQUIN 122.83 7058.848102
305110240177002 LEVAQUIN 122.83 7058.848102
305110240184 305110240184001 NYSTATIN 131.31 7058.848102
305110240191 305110240191001 TUSSIONEX 26.93 7058.848102
305110240204 305110240204001 PREDNISONE 2.08 7058.848102
305110240211 305110240211001 ZYRTEC 63.10 7058.848102
305110240273 305110240273001 NEXIUM 45.00 7058.848102
305110240273002 NEXIUM 45.00 7058.848102
305540110670 305540110670001 APAP/OXYCODONE 178.78 5433.128858
305540110670002 APAP/OXYCODONE 214.16 5433.128858
305540110670003 APAP/OXYCODONE 178.78 5433.128858
305540110670004 APAP/OXYCODONE 214.16 5433.128858
305540110670005 APAP/OXYCODONE 214.16 5433.128858
305540110670006 APAP/OXYCODONE 214.16 5433.128858
305540110687 305540110687001 CORTANE-B 32.10 5433.128858
305540110687002 CORTANE-B 38.17 5433.128858
305540110687003 CORTANE-B 72.45 5433.128858
305540110687004 CORTANE-B 115.26 5433.128858
305540110930 305540110930001 APAP/OXYCODONE 45.78 5433.128858
305540110930002 APAP/OXYCODONE 178.78 5433.128858
305540110930003 APAP/OXYCODONE 43.85 5433.128858
305540110930004 APAP/OXYCODONE 45.78 5433.128858
305540110930005 APAP/OXYCODONE 43.85 5433.128858
305540110954 305540110954001 PREVACID 138.00 5433.128858
305540110954002 PREVACID 138.00 5433.128858
305540110954003 PREVACID 138.00 5433.128858
305540110954004 PREVACID 138.00 5433.128858
HC-102I 13:16 Friday, September 19, 2008 21
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-102A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
305540110954 305540110954005 PREVACID 138.00 5433.128858
305540110961 305540110961001 DIOVAN HCT (CAPLET) 122.26 5433.128858
305540110961002 DIOVAN HCT (CAPLET) 122.26 5433.128858
305540110961003 DIOVAN HCT (CAPLET) 122.26 5433.128858
305540110961004 DIOVAN HCT (CAPLET) 122.26 5433.128858
305540110961005 DIOVAN HCT (CAPLET) 122.26 5433.128858
305540110978 305540110978001 VERAPAMIL HCL (FILM-COATED) 17.24 5433.128858
305540110978002 VERAPAMIL HCL (FILM-COATED) 17.24 5433.128858
305540110978003 VERAPAMIL HCL (FILM-COATED) 17.24 5433.128858
305540110978004 VERAPAMIL HCL (FILM-COATED) 17.24 5433.128858
305540110978005 VERAPAMIL HCL (FILM-COATED) 17.24 5433.128858
HC-102I 13:16 Friday, September 19, 2008 22
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
The MEANS Procedure
Analysis Variable : RXXP06X SUM OF PAYMENTS RXSF06X-RXOU06X(IMPUTED)
N Sum
--------------------
6040 421540.16
--------------------
HC-102I 13:16 Friday, September 19, 2008 23
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP06X SUM OF PAYMENTS RXSF06X-RXOU06X(IMPUTED)
N Sum
--------------------
6040 3521652073
--------------------
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
NOTE: This session is executing on the XP_PRO platform.
NOTE: SAS 9.1.3 Service Pack 4
NOTE: SAS initialization used:
real time 4.95 seconds
cpu time 1.17 seconds
NOTE: AUTOEXEC processing beginning; file is I:\WW3\APPLIC~1\SAS\FOUNDA~1.3\sas\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-102I";
4 TITLE2 "Sample SAS Job for Example B";
5
6 LIBNAME IN "C:\Data";
NOTE: Libref IN was successfully assigned as follows:
Engine: V9
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 (Total process time):
real time 0.09 seconds
cpu time 0.00 seconds
22
23 *--------------------------------------------------------------------------------------
24 * Get condition records coded as asthma.
25 *--------------------------------------------------------------------------------------;
26 DATA ASCONDS;
27 SET IN.H104 (KEEP=CONDIDX CCCODEX);
28 IF CCCODEX="128";
29 RUN;
NOTE: There were 105166 observations read from the data set IN.H104.
NOTE: The data set WORK.ASCONDS has 1990 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.26 seconds
cpu time 0.09 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 1990 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1990 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds
35
36 proc print data=asconds (obs=50);
37 title3 "sample print of work.asconds - sorted by condidx";
38 title4 "COND (H104) records where cccodex=128";
39 run;
NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.11 seconds
cpu time 0.00 seconds
40
41 PROC SORT DATA=IN.H102IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 350780 observations read from the data set IN.H102IF1.
NOTE: The data set WORK.CLNK has 350780 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 5.79 seconds
cpu time 1.10 seconds
42
43 DATA ASCLNKS;
44 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
45 ASCONDS(IN=INASCOND KEEP=CONDIDX);
46 BY CONDIDX;
47 IF INCLNK & INASCOND;
48 RUN;
NOTE: There were 350780 observations read from the data set WORK.CLNK.
NOTE: There were 1990 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7984 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 1.59 seconds
cpu time 0.39 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: PROCEDURE PRINT used (Total process time):
real time 0.07 seconds
cpu time 0.00 seconds
57
58 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7984 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7984 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
59
60 proc print data=asclnks (obs=50);
61 format eventype eventype.;
62 title3 "sample print of work.asclnks - sorted by evntidx";
63 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: PROCEDURE PRINT used (Total process time):
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 7984 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7978 observations and 2 variables.
NOTE: DATA statement used (Total process time):
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: PROCEDURE PRINT used (Total process time):
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.H102A OUT=PMED; BY LINKIDX; RUN;
NOTE: There were 341994 observations read from the data set IN.H102A.
NOTE: The data set WORK.PMED has 341994 observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 24.48 seconds
cpu time 3.79 seconds
80
81 DATA ASPMEDS;
82 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F)
83 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX RENAME=(EVNTIDX=LINKIDX));
84 BY LINKIDX;
85 IF INASCLNK & PERWT06F>0;
86 RUN;
NOTE: There were 341994 observations read from the data set WORK.PMED.
NOTE: There were 7978 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 11833 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.67 seconds
cpu time 0.48 seconds
87
88 proc print data=aspmeds (obs=300);
89 by linkidx;
90 id linkidx;
91 var rxrecidx rxname RXXP06X PERWT06F;
92 title3 "sample print of work.aspmeds";
93 title4 "PMED (HC-102A) records which link to condition records coded as asthma";
94 run;
NOTE: There were 300 observations read from the data set WORK.ASPMEDS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
95
96 PROC MEANS DATA=ASPMEDS N SUM;
97 VAR RXXP06X;
98 TITLE3 "Total Rx expenditures associated with asthma";
99 RUN;
NOTE: There were 11833 observations read from the data set WORK.ASPMEDS.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.14 seconds
cpu time 0.03 seconds
100
101 PROC MEANS DATA=ASPMEDS N SUM;
102 VAR RXXP06X;
103 WEIGHT PERWT06F;
104 TITLE3 "Total Rx expenditures associated with asthma";
105 TITLE5 "Weighted";
106 RUN;
NOTE: There were 11833 observations read from the data set WORK.ASPMEDS.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
HC-102I 12:34 Wednesday, September 24, 2008 1
Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H104) records where cccodex=128
Obs CCCODEX CONDIDX
1 128 300180180093
2 128 300230580049
3 128 300400300014
4 128 300490270010
5 128 300600350034
6 128 300610290019
7 128 300680130051
8 128 300830210012
9 128 300910450025
10 128 301170420016
11 128 301320230021
12 128 301470290031
13 128 302050190018
14 128 302050330038
15 128 302050330050
16 128 302070200083
17 128 302170520040
18 128 302560570015
19 128 302740680016
20 128 302850140023
21 128 302920640046
22 128 302950160019
23 128 302950230018
24 128 302980530024
25 128 303290290060
26 128 303350230045
27 128 303510370015
28 128 303600490028
29 128 303670100066
30 128 303730200010
31 128 303760240088
32 128 303760240204
33 128 303780330060
34 128 303780400075
35 128 303930110039
36 128 304140140175
37 128 304220290013
38 128 304220360012
39 128 304250390016
40 128 304280150074
41 128 304540490089
42 128 304550430109
43 128 304570200013
44 128 304620150092
45 128 304620270080
46 128 304710110124
47 128 304740470017
48 128 304840230070
49 128 305110240030
50 128 305260250057
HC-102I 12:34 Wednesday, September 24, 2008 2
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
300180180093 300180180418 8 PMED
300180180521 8 PMED
300180180610 1 MVIS
300230580049 300230580090 3 EROM
300230580103 3 EROM
300230580110 3 EROM
300230580141 1 MVIS
300230580158 8 PMED
300400300014 300400300031 3 EROM
300400300048 8 PMED
300400300055 8 PMED
300400300062 8 PMED
300600350034 300600350206 1 MVIS
300610290019 300610290292 1 MVIS
300610290305 1 MVIS
300610290312 1 MVIS
300610290336 8 PMED
300610290350 8 PMED
300610290367 8 PMED
300610290374 8 PMED
300610290398 8 PMED
300610290418 1 MVIS
300610290456 8 PMED
300680130051 300680130196 8 PMED
300680130209 8 PMED
300680130230 8 PMED
300680130247 8 PMED
300910450025 300910450099 8 PMED
300910450102 8 PMED
300910450164 8 PMED
300910450171 8 PMED
301170420016 301170420048 8 PMED
301170420062 8 PMED
301320230021 301320230287 8 PMED
301320230383 8 PMED
301320230390 8 PMED
301320230472 8 PMED
301320230489 8 PMED
301470290031 301470290097 1 MVIS
301470290100 1 MVIS
HC-102I 12:34 Wednesday, September 24, 2008 3
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
301470290031 301470290124 8 PMED
302050190018 302050190016 8 PMED
302050190023 8 PMED
302050330038 302050330054 1 MVIS
302050330078 3 EROM
302050330092 8 PMED
302050330112 8 PMED
302050330050 302050330085 8 PMED
302070200083 302070200148 8 PMED
302070200155 8 PMED
302170520040 302170520033 8 PMED
302560570015 302560570125 8 PMED
302920640046 302920640123 1 MVIS
302920640130 8 PMED
302920640147 8 PMED
302950230018 302950230057 8 PMED
302950230115 8 PMED
303290290060 303290290117 8 PMED
303290290148 8 PMED
303350230045 303350230445 8 PMED
303350230558 8 PMED
303350230572 1 MVIS
303350230589 1 MVIS
303350230596 1 MVIS
303350230623 8 PMED
303350230630 8 PMED
303350230661 8 PMED
303350230678 8 PMED
303350230705 8 PMED
303350230729 8 PMED
303350230801 8 PMED
303350230825 8 PMED
303350230849 8 PMED
303510370015 303510370359 8 PMED
303510370366 8 PMED
HC-102I 12:34 Wednesday, September 24, 2008 4
Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx
Obs EVNTIDX EVENTYPE CONDIDX
1 300180180418 8 PMED 300180180093
2 300180180521 8 PMED 300180180093
3 300180180610 1 MVIS 300180180093
4 300230580090 3 EROM 300230580049
5 300230580103 3 EROM 300230580049
6 300230580110 3 EROM 300230580049
7 300230580141 1 MVIS 300230580049
8 300230580158 8 PMED 300230580049
9 300400300031 3 EROM 300400300014
10 300400300048 8 PMED 300400300014
11 300400300055 8 PMED 300400300014
12 300400300062 8 PMED 300400300014
13 300600350206 1 MVIS 300600350034
14 300610290292 1 MVIS 300610290019
15 300610290305 1 MVIS 300610290019
16 300610290312 1 MVIS 300610290019
17 300610290336 8 PMED 300610290019
18 300610290350 8 PMED 300610290019
19 300610290367 8 PMED 300610290019
20 300610290374 8 PMED 300610290019
21 300610290398 8 PMED 300610290019
22 300610290418 1 MVIS 300610290019
23 300610290456 8 PMED 300610290019
24 300680130196 8 PMED 300680130051
25 300680130209 8 PMED 300680130051
26 300680130230 8 PMED 300680130051
27 300680130247 8 PMED 300680130051
28 300910450099 8 PMED 300910450025
29 300910450102 8 PMED 300910450025
30 300910450164 8 PMED 300910450025
31 300910450171 8 PMED 300910450025
32 301170420048 8 PMED 301170420016
33 301170420062 8 PMED 301170420016
34 301320230287 8 PMED 301320230021
35 301320230383 8 PMED 301320230021
36 301320230390 8 PMED 301320230021
37 301320230472 8 PMED 301320230021
38 301320230489 8 PMED 301320230021
39 301470290097 1 MVIS 301470290031
40 301470290100 1 MVIS 301470290031
41 301470290124 8 PMED 301470290031
42 302050190016 8 PMED 302050190018
43 302050190023 8 PMED 302050190018
44 302050330054 1 MVIS 302050330038
45 302050330078 3 EROM 302050330038
46 302050330085 8 PMED 302050330050
47 302050330092 8 PMED 302050330038
48 302050330112 8 PMED 302050330038
49 302070200148 8 PMED 302070200083
50 302070200155 8 PMED 302070200083
HC-102I 12:34 Wednesday, September 24, 2008 5
Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 300180180418 8 PMED
2 300180180521 8 PMED
3 300180180610 1 MVIS
4 300230580090 3 EROM
5 300230580103 3 EROM
6 300230580110 3 EROM
7 300230580141 1 MVIS
8 300230580158 8 PMED
9 300400300031 3 EROM
10 300400300048 8 PMED
11 300400300055 8 PMED
12 300400300062 8 PMED
13 300600350206 1 MVIS
14 300610290292 1 MVIS
15 300610290305 1 MVIS
16 300610290312 1 MVIS
17 300610290336 8 PMED
18 300610290350 8 PMED
19 300610290367 8 PMED
20 300610290374 8 PMED
21 300610290398 8 PMED
22 300610290418 1 MVIS
23 300610290456 8 PMED
24 300680130196 8 PMED
25 300680130209 8 PMED
26 300680130230 8 PMED
27 300680130247 8 PMED
28 300910450099 8 PMED
29 300910450102 8 PMED
30 300910450164 8 PMED
31 300910450171 8 PMED
32 301170420048 8 PMED
33 301170420062 8 PMED
34 301320230287 8 PMED
35 301320230383 8 PMED
36 301320230390 8 PMED
37 301320230472 8 PMED
38 301320230489 8 PMED
39 301470290097 1 MVIS
40 301470290100 1 MVIS
41 301470290124 8 PMED
42 302050190016 8 PMED
43 302050190023 8 PMED
44 302050330054 1 MVIS
45 302050330078 3 EROM
46 302050330085 8 PMED
47 302050330092 8 PMED
48 302050330112 8 PMED
49 302070200148 8 PMED
50 302070200155 8 PMED
HC-102I 12:34 Wednesday, September 24, 2008 6
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-102A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
300180180418 300180180418001 ALBUTEROL 40.35 12968.377500
300180180521 300180180521001 ALBUTEROL 40.35 12968.377500
300180180521002 ALBUTEROL 40.35 12968.377500
300180180521003 ALBUTEROL 40.35 12968.377500
300180180521004 ALBUTEROL 40.35 12968.377500
300180180521005 ALBUTEROL 40.35 12968.377500
300180180521006 ALBUTEROL 40.35 12968.377500
300230580158 300230580158001 ALBUTEROL INHALER 20.29 4647.878284
300400300048 300400300048001 TYLENOL W/CODEINE 16.87 12833.583932
300400300055 300400300055001 ADVAIR 156.28 12833.583932
300400300062 300400300062001 ALBUTEROL INHALER 20.29 12833.583932
300610290336 300610290336001 ADVAIR DISKUS 500/50 221.50 15210.808650
300610290350 300610290350001 PREDNISONE 24.61 15210.808650
300610290367 300610290367001 LEVAQUIN (FILM-COATED) 149.65 15210.808650
300610290367002 LEVAQUIN (FILM-COATED) 142.74 15210.808650
300610290374 300610290374001 VERAPAMIL HCL (WHITE) 20.53 15210.808650
300610290398 300610290398001 RANITIDINE HCL (USP,FILM-COATED) 5.66 15210.808650
300610290456 300610290456001 ADVAIR DISKUS 500/50 221.50 15210.808650
300680130196 300680130196001 ALBUTEROL 21.41 9848.748255
300680130209 300680130209001 NEBULIZER 77.38 9848.748255
300680130230 300680130230001 NEBULIZER 77.38 9848.748255
300680130230002 NEBULIZER 77.38 9848.748255
300680130247 300680130247001 ALBUTEROL 21.41 9848.748255
300910450099 300910450099001 ADVAIR DISKUS 250/50 128.25 11450.817965
300910450102 300910450102001 ALBUTEROL INHALER 39.85 11450.817965
300910450164 300910450164001 ADVAIR DISKUS 250/50 156.99 11450.817965
300910450171 300910450171001 ALBUTEROL INHALER 39.85 11450.817965
301170420048 301170420048001 MONTELUKAST 20.99 5319.852372
HC-102I 12:34 Wednesday, September 24, 2008 7
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-102A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
301170420062 301170420062001 MONTELUKAST 34.50 5319.852372
301170420062002 MONTELUKAST 34.50 5319.852372
301170420062003 MONTELUKAST 34.50 5319.852372
301320230287 301320230287001 ADVAIR DISKUS 500/50 40.00 11412.095230
301320230383 301320230383001 ALBUTEROL 58.00 11412.095230
301320230383002 ALBUTEROL 58.00 11412.095230
301320230383003 ALBUTEROL 58.00 11412.095230
301320230383004 ALBUTEROL 58.00 11412.095230
301320230383005 ALBUTEROL 58.00 11412.095230
301320230383006 ALBUTEROL 58.00 11412.095230
301320230390 301320230390001 ADVAIR DISKUS 500/50 40.00 11412.095230
301320230390002 ADVAIR DISKUS 500/50 50.00 11412.095230
301320230390003 ADVAIR DISKUS 500/50 40.00 11412.095230
301320230390004 ADVAIR DISKUS 500/50 50.00 11412.095230
301320230390005 ADVAIR DISKUS 500/50 50.00 11412.095230
301320230390006 ADVAIR DISKUS 500/50 50.00 11412.095230
301320230472 301320230472001 ALBUTEROL 58.00 11412.095230
301320230472002 ALBUTEROL 58.00 11412.095230
301320230472003 ALBUTEROL 58.00 11412.095230
301320230472004 ALBUTEROL 58.00 11412.095230
301320230472005 ALBUTEROL 58.00 11412.095230
301320230489 301320230489001 ADVAIR DISKUS 500/50 50.00 11412.095230
301320230489002 ADVAIR DISKUS 500/50 50.00 11412.095230
301320230489003 ADVAIR DISKUS 500/50 50.00 11412.095230
301320230489004 ADVAIR DISKUS 500/50 40.00 11412.095230
301320230489005 ADVAIR DISKUS 500/50 40.00 11412.095230
301470290124 301470290124001 BRETHINE 44.75 4964.901754
302050190016 302050190016001 SINGULAIR 268.62 4031.282387
302050190023 302050190023001 ADVAIR 60.00 4031.282387
302050330085 302050330085001 PULMICORT RESPULES (5X6) 300.88 4355.758139
302050330092 302050330092001 ALBUTEROL SULFATE (VIAL) 72.60 4355.758139
302050330112 302050330112001 SINGULAIR 93.18 4355.758139
302070200148 302070200148001 ALBUTEROL 42.82 10908.320492
302070200155 302070200155001 ADVAIR 60.00 10908.320492
302170520033 302170520033001 ALBUTEROL INHALER 20.00 5816.613473
HC-102I 12:34 Wednesday, September 24, 2008 8
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-102A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
302560570125 302560570125001 ALBUTEROL INHALER 20.29 3765.112064
302560570125002 ALBUTEROL INHALER 20.29 3765.112064
302560570125003 ALBUTEROL INHALER 20.29 3765.112064
302920640130 302920640130001 ALBUTEROL SULFATE (VIAL) 25.58 1436.909526
302920640147 302920640147001 PULMICORT RESPULES (5X6) 304.70 1436.909526
302950230057 302950230057001 ALBUTEROL 22.21 1393.187889
302950230115 302950230115001 ALBUTEROL 20.00 1393.187889
302950230115002 ALBUTEROL 20.00 1393.187889
303290290117 303290290117001 ALBUTEROL 21.41 10369.068910
303290290117002 ALBUTEROL 21.41 10369.068910
303290290117003 ALBUTEROL 21.41 10369.068910
303290290117004 ALBUTEROL 21.41 10369.068910
303290290117005 ALBUTEROL 21.41 10369.068910
303290290117006 ALBUTEROL 21.41 10369.068910
303290290117007 ALBUTEROL 21.41 10369.068910
303290290117008 ALBUTEROL 21.41 10369.068910
303290290148 303290290148001 ALBUTEROL 21.41 10369.068910
303290290148002 ALBUTEROL 21.41 10369.068910
303350230445 303350230445001 SINGULAIR 50.00 8363.548295
303350230558 303350230558001 METHYLPREDNISOLONE 8.66 8363.548295
303350230623 303350230623001 METHYLPREDNISOLONE 8.66 8363.548295
303350230623002 METHYLPREDNISOLONE 8.66 8363.548295
303350230630 303350230630001 LEVAQUIN 122.83 8363.548295
303350230661 303350230661001 ZYRTEC-D 50.00 8363.548295
303350230661002 ZYRTEC-D 50.00 8363.548295
303350230678 303350230678001 ACCOLATE 60.00 8363.548295
303350230678002 ACCOLATE 60.00 8363.548295
303350230705 303350230705001 ADVAIR DISKUS 50.00 8363.548295
303350230705002 ADVAIR DISKUS 50.00 8363.548295
303350230729 303350230729001 SINGULAIR 50.00 8363.548295
303350230729002 SINGULAIR 50.00 8363.548295
303350230801 303350230801001 ACCOLATE 60.00 8363.548295
303350230825 303350230825001 ADVAIR 60.00 8363.548295
HC-102I 12:34 Wednesday, September 24, 2008 9
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-102A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
303350230849 303350230849001 SINGULAIR 268.62 8363.548295
303510370359 303510370359001 ALLEGRA 63.33 28465.212955
303510370366 303510370366001 ACCOLATE 91.78 28465.212955
303510370373 303510370373001 ADVAIR 100/50 131.26 28465.212955
303510370506 303510370506001 ALLEGRA 63.33 28465.212955
303510370506002 ALLEGRA 63.33 28465.212955
303510370506003 ALLEGRA 63.33 28465.212955
303510370506004 ALLEGRA 63.33 28465.212955
303510370513 303510370513001 ADVAIR 100/50 131.26 28465.212955
303510370513002 ADVAIR 100/50 131.26 28465.212955
303510370513003 ADVAIR 100/50 131.26 28465.212955
303510370513004 ADVAIR 100/50 131.26 28465.212955
303510370513005 ADVAIR 100/50 131.26 28465.212955
303510370520 303510370520001 ALBUTEROL 26.49 28465.212955
303600490508 303600490508001 SINGULAIR 101.59 12279.713756
303600490515 303600490515001 XOPENEX (PF) 206.87 12279.713756
303600490522 303600490522001 PULMICORT RESPULES (5X6) 292.41 12279.713756
303730200785 303730200785001 SINGULAIR 50.00 9373.619859
303760241004 303760241004001 PULMICORT RESPULES (5X6) 136.31 11627.747676
303760241326 303760241326001 PULMICORT RESPULES (5X6) 136.31 11627.747676
303760241333 303760241333001 ALBUTEROL SULFATE 7.05 11627.747676
303760241782 303760241782001 ALBUTEROL INHALER 39.85 11627.747676
303760241802 303760241802001 ALBUTEROL 8.20 11627.747676
303760241802002 ALBUTEROL 8.20 11627.747676
303780330312 303780330312001 FLOVENT 134.00 15296.326798
303780330329 303780330329001 DUONEB 101.89 15296.326798
303780330425 303780330425001 PREDNISONE (PEPPERMINT-VANILLA) 26.41 15296.326798
303780330425002 PREDNISONE (PEPPERMINT-VANILLA) 26.41 15296.326798
303780330449 303780330449001 RESPI-TANN (DYE-FREE,CHERRY) 55.65 15296.326798
HC-102I 12:34 Wednesday, September 24, 2008 10
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-102A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
303780330470 303780330470001 HISDEC 5.69 15296.326798
303780330494 303780330494001 FLOVENT 134.00 15296.326798
303780330494002 FLOVENT 134.00 15296.326798
303780330494003 FLOVENT 134.00 15296.326798
303780330494004 FLOVENT 134.00 15296.326798
303780330507 303780330507001 SINGULAIR 92.12 15296.326798
303780330507002 SINGULAIR 92.12 15296.326798
303780330507003 SINGULAIR 92.12 15296.326798
303780330507004 SINGULAIR 92.12 15296.326798
303780330514 303780330514001 DUONEB 101.89 15296.326798
303780330514002 DUONEB 101.89 15296.326798
303780330545 303780330545001 FLOVENT 134.00 15296.326798
303780330545002 FLOVENT 134.00 15296.326798
303780330545003 FLOVENT 134.00 15296.326798
303780330545004 FLOVENT 134.00 15296.326798
303780330545005 FLOVENT 134.00 15296.326798
303780330552 303780330552001 SINGULAIR 92.12 15296.326798
303780330552002 SINGULAIR 92.12 15296.326798
303780330552003 SINGULAIR 92.12 15296.326798
303780330552004 SINGULAIR 92.12 15296.326798
303780330552005 SINGULAIR 92.12 15296.326798
303780400189 303780400189001 ALBUTEROL INHALER 20.29 10940.657155
303780400189002 ALBUTEROL INHALER 20.29 10940.657155
303780400196 303780400196001 FLOVENT 134.00 10940.657155
303780400196002 FLOVENT 134.00 10940.657155
303780400247 303780400247001 PREDNISONE (PEPPERMINT-VANILLA) 26.41 10940.657155
303780400254 303780400254001 SINGULAIR 93.76 10940.657155
303780400285 303780400285001 FLOVENT 134.00 10940.657155
303780400285002 FLOVENT 134.00 10940.657155
303780400285003 FLOVENT 134.00 10940.657155
303780400285004 FLOVENT 134.00 10940.657155
303780400292 303780400292001 ALBUTEROL INHALER 20.29 10940.657155
303780400292002 ALBUTEROL INHALER 20.29 10940.657155
303780400312 303780400312001 FLOVENT 134.00 10940.657155
303780400312002 FLOVENT 134.00 10940.657155
303780400312003 FLOVENT 134.00 10940.657155
303780400312004 FLOVENT 134.00 10940.657155
HC-102I 12:34 Wednesday, September 24, 2008 11
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-102A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
303780400312 303780400312005 FLOVENT 134.00 10940.657155
303780400329 303780400329001 SINGULAIR 100.07 10940.657155
303780400329002 SINGULAIR 93.76 10940.657155
303780400329003 SINGULAIR 93.76 10940.657155
303780400329004 SINGULAIR 100.07 10940.657155
303780400329005 SINGULAIR 100.07 10940.657155
304140141905 304140141905001 ALBUTEROL 10.38 4183.222652
304140141905002 ALBUTEROL 10.38 4183.222652
304220360161 304220360161001 ALBUTEROL 23.87 9512.286566
304220360178 304220360178001 FEXOFENADINE HCL (FILM-COATED) 70.00 9512.286566
304220360192 304220360192001 ADVAIR DISKUS 250/50 165.46 9512.286566
304220360205 304220360205001 ALBUTEROL INHALER 39.85 9512.286566
304220360250 304220360250001 ADVAIR DISKUS 250/50 165.46 9512.286566
304250390181 304250390181001 PROAIR HFA 36.72 9947.658537
304250390198 304250390198001 SINGULAIR 60.00 9947.658537
304250390201 304250390201001 ALBUTEROL 21.41 9947.658537
304250390201002 ALBUTEROL 21.41 9947.658537
304250390201003 ALBUTEROL 21.41 9947.658537
304250390201004 ALBUTEROL 21.41 9947.658537
304250390201005 ALBUTEROL 21.41 9947.658537
304250390201006 ALBUTEROL 21.41 9947.658537
304250390270 304250390270001 PROAIR HFA 36.72 9947.658537
304250390270002 PROAIR HFA 36.72 9947.658537
304250390270003 PROAIR HFA 36.72 9947.658537
304280150803 304280150803001 UNIPHYL 76.67 2041.042916
304280150810 304280150810001 ACCOLATE 91.78 2041.042916
304540490171 304540490171001 SINGULAIR 115.00 7360.381187
304540490171002 SINGULAIR 115.00 7360.381187
304540490171003 SINGULAIR 115.00 7360.381187
304550430330 304550430330001 SINGULAIR 313.62 15036.548864
304550430330002 SINGULAIR 313.62 15036.548864
304550430347 304550430347001 ZYRTEC 250.21 15036.548864
304550430347002 ZYRTEC 250.21 15036.548864
HC-102I 12:34 Wednesday, September 24, 2008 12
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-102A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
304550430354 304550430354001 ALBUTEROL 10.08 15036.548864
304550430354002 ALBUTEROL 10.08 15036.548864
304550430436 304550430436001 SINGULAIR 313.62 15036.548864
304550430436002 SINGULAIR 313.62 15036.548864
304550430443 304550430443001 FLOVENT HFA 75.39 15036.548864
304550430450 304550430450001 ZYRTEC 250.21 15036.548864
304550430467 304550430467001 ALBUTEROL 13.30 15036.548864
304550430467002 ALBUTEROL 13.30 15036.548864
304570200190 304570200190001 ALBUTEROL 29.79 11350.343698
304570200190002 ALBUTEROL 29.79 11350.343698
304570200190003 ALBUTEROL 29.79 11350.343698
304620270136 304620270136001 ALBUTEROL INHALER 20.29 2468.223760
304620270136002 ALBUTEROL INHALER 20.29 2468.223760
304620270136003 ALBUTEROL INHALER 20.29 2468.223760
304710110277 304710110277001 ADVAIR DISKUS 250/50 167.16 21312.814106
304710110277002 ADVAIR DISKUS 250/50 167.16 21312.814106
304710110277003 ADVAIR DISKUS 250/50 167.16 21312.814106
304710110277004 ADVAIR DISKUS 250/50 167.16 21312.814106
304710110284 304710110284001 ALBUTEROL INHALER 20.29 21312.814106
304840230176 304840230176001 ALBUTEROL INHALER 39.85 9631.606717
304840230183 304840230183001 BANOPHEN 13.60 9631.606717
305110240177 305110240177001 LEVAQUIN 122.83 7058.848102
305110240177002 LEVAQUIN 122.83 7058.848102
305110240184 305110240184001 NYSTATIN 131.31 7058.848102
305110240191 305110240191001 TUSSIONEX 26.93 7058.848102
305110240204 305110240204001 PREDNISONE 2.08 7058.848102
305110240211 305110240211001 ZYRTEC 63.10 7058.848102
305110240228 305110240228001 NITROFURANTOIN MONOHYDRATE/MACROCRY 17.72 7058.848102
305110240273 305110240273001 NEXIUM 45.00 7058.848102
305110240273002 NEXIUM 45.00 7058.848102
305350110091 305350110091001 XOPENEX (PF) 193.05 21980.022493
HC-102I 12:34 Wednesday, September 24, 2008 13
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-102A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
305460360485 305460360485001 ALBUTEROL 12.00 880.195850
305490400160 305490400160001 SINGULAIR 96.46 2498.826598
305490400160002 SINGULAIR 96.46 2498.826598
305490400160003 SINGULAIR 96.46 2498.826598
305490400177 305490400177001 ADVAIR 250/50 156.72 2498.826598
305490400177002 ADVAIR 250/50 156.72 2498.826598
305540110581 305540110581001 ALBUTEROL 9.14 5433.128858
305540110721 305540110721001 SINGULAIR (UNIT OF USE) 94.64 5433.128858
305540110721002 SINGULAIR (UNIT OF USE) 94.62 5433.128858
305540110721003 SINGULAIR (UNIT OF USE) 94.64 5433.128858
305540110721004 SINGULAIR (UNIT OF USE) 94.62 5433.128858
305540110721005 SINGULAIR (UNIT OF USE) 94.62 5433.128858
305540110721006 SINGULAIR (UNIT OF USE) 99.26 5433.128858
305540110776 305540110776001 ALBUTEROL 9.14 5433.128858
305540110776002 ALBUTEROL 9.15 5433.128858
305540110776003 ALBUTEROL 9.15 5433.128858
305540110776004 ALBUTEROL 9.15 5433.128858
305540110776005 ALBUTEROL 9.15 5433.128858
305540110776006 ALBUTEROL 9.15 5433.128858
305540110776007 ALBUTEROL 9.15 5433.128858
305540110776008 ALBUTEROL 9.85 5433.128858
305540110776009 ALBUTEROL 9.14 5433.128858
305540110776010 ALBUTEROL 9.14 5433.128858
305540110776011 ALBUTEROL 9.85 5433.128858
305540110776012 ALBUTEROL 9.85 5433.128858
305540110783 305540110783001 ADVAIR DISKUS 500/50 228.88 5433.128858
305540110783002 ADVAIR DISKUS 500/50 228.88 5433.128858
305540110783003 ADVAIR DISKUS 500/50 228.88 5433.128858
305540110783004 ADVAIR DISKUS 500/50 231.64 5433.128858
305540110783005 ADVAIR DISKUS 500/50 231.64 5433.128858
305540110783006 ADVAIR DISKUS 500/50 231.64 5433.128858
305540110947 305540110947001 SINGULAIR (UNIT OF USE) 94.62 5433.128858
305540110947002 SINGULAIR (UNIT OF USE) 94.62 5433.128858
305540110947003 SINGULAIR (UNIT OF USE) 94.62 5433.128858
305540110947004 SINGULAIR (UNIT OF USE) 94.62 5433.128858
305540110947005 SINGULAIR (UNIT OF USE) 94.62 5433.128858
305540110992 305540110992001 ALBUTEROL 20.29 5433.128858
305540110992002 ALBUTEROL 20.29 5433.128858
305540110992003 ALBUTEROL 20.29 5433.128858
305540110992004 ALBUTEROL 20.29 5433.128858
305540110992005 ALBUTEROL 20.29 5433.128858
HC-102I 12:34 Wednesday, September 24, 2008 14
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-102A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP06X PERWT06F
305540111008 305540111008001 ADVAIR DISKUS 500/50 231.64 5433.128858
305540111008002 ADVAIR DISKUS 500/50 231.64 5433.128858
305540111008003 ADVAIR DISKUS 500/50 231.64 5433.128858
305540111008004 ADVAIR DISKUS 500/50 231.64 5433.128858
305540111008005 ADVAIR DISKUS 500/50 231.64 5433.128858
306360110037 306360110037001 AZITHROMYCIN 35.05 32183.001677
306360110037002 AZITHROMYCIN 35.05 32183.001677
306360110044 306360110044001 BRONCHO SALINE 8.01 32183.001677
306360110044002 BRONCHO SALINE 8.01 32183.001677
306460410116 306460410116001 ALBUTEROL 19.88 879.246999
306460410116002 ALBUTEROL 19.88 879.246999
306460410116003 ALBUTEROL 19.88 879.246999
306460410116004 ALBUTEROL 19.88 879.246999
306460410123 306460410123001 FLOVENT 82.79 879.246999
306460410123002 FLOVENT 82.79 879.246999
306460410123003 FLOVENT 82.79 879.246999
306460410123004 FLOVENT 82.79 879.246999
306460410130 306460410130001 NASONEX (SCENT-FREE MIST) 75.00 879.246999
306460410130002 NASONEX (SCENT-FREE MIST) 75.00 879.246999
306460410130003 NASONEX (SCENT-FREE MIST) 75.00 879.246999
306460410130004 NASONEX (SCENT-FREE MIST) 75.00 879.246999
306460410154 306460410154001 ALBUTEROL 19.88 879.246999
306460410154002 ALBUTEROL 19.88 879.246999
306460410154003 ALBUTEROL 19.88 879.246999
306460410154004 ALBUTEROL 19.88 879.246999
306460410161 306460410161001 FLOVENT 82.79 879.246999
306460410161002 FLOVENT 82.79 879.246999
306460410161003 FLOVENT 82.79 879.246999
306670130108 306670130108001 COMBIVENT 99.53 9908.423151
306670130115 306670130115001 ADVAIR 250/50 160.83 9908.423151
306670130153 306670130153001 COMBIVENT 99.53 9908.423151
306670130153002 COMBIVENT 99.53 9908.423151
306670130153003 COMBIVENT 99.53 9908.423151
HC-102I 12:34 Wednesday, September 24, 2008 15
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
The MEANS Procedure
Analysis Variable : RXXP06X SUM OF PAYMENTS RXSF06X-RXOU06X(IMPUTED)
N Sum
---------------------
11833 950523.19
---------------------
HC-102I 12:34 Wednesday, September 24, 2008 16
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : RXXP06X SUM OF PAYMENTS RXSF06X-RXOU06X(IMPUTED)
N Sum
---------------------
11833 8762417566
---------------------
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
NOTE: This session is executing on the XP_PRO platform.
NOTE: SAS 9.1.3 Service Pack 4
NOTE: SAS initialization used:
real time 4.98 seconds
cpu time 1.15 seconds
NOTE: AUTOEXEC processing beginning; file is I:\WW3\APPLIC~1\SAS\FOUNDA~1.3\sas\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-102I";
4 TITLE2 "Sample SAS Job for Example C";
5
6 LIBNAME IN "C:\Data";
NOTE: Libref IN was successfully assigned as follows:
Engine: V9
Physical Name: C:\Data
7
8 *************************************************************************************
9 * Calculate the expenditures for medical visits associated with asthma.
10 *************************************************************************************;
11 PROC FORMAT;
12 VALUE EVENTYPE
13 1 = "1 MVIS"
14 2 = "2 OPAT"
15 3 = "3 EROM"
16 4 = "4 STAZ"
17 5 = "5 DVIS"
18 6 = "6 OMED"
19 7 = "7 HVIS"
20 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
21 RUN;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.07 seconds
cpu time 0.00 seconds
22
23 *-----------------------------------------------------------------------------------
24 * Get conditions records coded as asthma.
25 *-----------------------------------------------------------------------------------;
26 DATA ASCONDS;
27 SET IN.H104 (KEEP=CONDIDX CCCODEX);
28 IF CCCODEX="128";
29 RUN;
NOTE: There were 105166 observations read from the data set IN.H104.
NOTE: The data set WORK.ASCONDS has 1990 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 1.07 seconds
cpu time 0.17 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 1990 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCONDS has 1990 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds
35
36 proc print data=asconds (obs=50);
37 title3 "sample print of work.asconds - sorted by condidx";
38 title4 "COND (H104) records where cccodex=128";
39 run;
NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.12 seconds
cpu time 0.03 seconds
40
41 PROC SORT DATA=IN.H102IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 350780 observations read from the data set IN.H102IF1.
NOTE: The data set WORK.CLNK has 350780 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 7.46 seconds
cpu time 1.07 seconds
42
43 DATA ASCLNKS;
44 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
45 ASCONDS(IN=INASCOND KEEP=CONDIDX);
46 BY CONDIDX;
47 IF INCLNK & INASCOND;
48 RUN;
NOTE: There were 350780 observations read from the data set WORK.CLNK.
NOTE: There were 1990 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7984 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 1.84 seconds
cpu time 0.40 seconds
49
50 proc print data=asclnks (obs=75);
51 by condidx;
52 id condidx;
53 format eventype eventype.;
54 title3 "sample print of work.asclnks - sorted by condidx";
55 title4 "events linked to asthma condition records";
56 run;
NOTE: There were 75 observations read from the data set WORK.ASCLNKS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.06 seconds
cpu time 0.01 seconds
57
58 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7984 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7984 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
59
60 proc print data=asclnks (obs=50);
61 format eventype eventype.;
62 title3 "sample print of work.asclnks - sorted by evntidx";
63 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: PROCEDURE PRINT used (Total process time):
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 7984 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7978 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
70
71 proc print data=asclnks (obs=50);
72 format eventype eventype.;
73 title3 "sample print of unique evntidxs from work.asclnks";
74 run;
NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
75
76 *--------------------------------------------------------------------------------------------
77 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
78 *--------------------------------------------------------------------------------------------;
79 DATA MVIS;
80 SET IN.H102G (KEEP=EVNTIDX PERWT06F SEETLKPV OBXP06X);
81 IF PERWT06F > 0 & SEETLKPV NE 2;
82 RUN;
NOTE: There were 155502 observations read from the data set IN.H102G.
NOTE: The data set WORK.MVIS has 151007 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 1.64 seconds
cpu time 0.45 seconds
83
84 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 151007 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.MVIS has 151007 observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.29 seconds
cpu time 0.28 seconds
85
86 *-------------------------------------------------------------------------------------
87 * Identify MVIS events which were for asthma.
88 *-------------------------------------------------------------------------------------;
89 DATA ASMVIS;
90 MERGE ASCLNKS (IN=INASCLNK)
91 MVIS (IN=INMVIS);
92 BY EVNTIDX;
93 IF INASCLNK & INMVIS;
94 RUN;
NOTE: There were 7978 observations read from the data set WORK.ASCLNKS.
NOTE: There were 151007 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 2320 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.21 seconds
cpu time 0.20 seconds
95
96 proc print data=asmvis (obs=50);
97 format eventype eventype.;
98 title3 "sample print of work.asmvis";
99 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-102G) events";
100 run;
NOTE: There were 50 observations read from the data set WORK.ASMVIS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
101
102 PROC MEANS DATA=ASMVIS N SUM;
103 VAR OBXP06X;
104 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
105 RUN;
NOTE: There were 2320 observations read from the data set WORK.ASMVIS.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.10 seconds
cpu time 0.03 seconds
106
107 PROC MEANS DATA=ASMVIS N SUM;
108 VAR OBXP06X;
109 WEIGHT PERWT06F;
110 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
111 TITLE5 "Weighted";
112 RUN;
NOTE: There were 2320 observations read from the data set WORK.ASMVIS.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
HC-102I 12:37 Wednesday, September 24, 2008 1
Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx
COND (H104) records where cccodex=128
Obs CCCODEX CONDIDX
1 128 300180180093
2 128 300230580049
3 128 300400300014
4 128 300490270010
5 128 300600350034
6 128 300610290019
7 128 300680130051
8 128 300830210012
9 128 300910450025
10 128 301170420016
11 128 301320230021
12 128 301470290031
13 128 302050190018
14 128 302050330038
15 128 302050330050
16 128 302070200083
17 128 302170520040
18 128 302560570015
19 128 302740680016
20 128 302850140023
21 128 302920640046
22 128 302950160019
23 128 302950230018
24 128 302980530024
25 128 303290290060
26 128 303350230045
27 128 303510370015
28 128 303600490028
29 128 303670100066
30 128 303730200010
31 128 303760240088
32 128 303760240204
33 128 303780330060
34 128 303780400075
35 128 303930110039
36 128 304140140175
37 128 304220290013
38 128 304220360012
39 128 304250390016
40 128 304280150074
41 128 304540490089
42 128 304550430109
43 128 304570200013
44 128 304620150092
45 128 304620270080
46 128 304710110124
47 128 304740470017
48 128 304840230070
49 128 305110240030
50 128 305260250057
HC-102I 12:37 Wednesday, September 24, 2008 2
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
300180180093 300180180418 8 PMED
300180180521 8 PMED
300180180610 1 MVIS
300230580049 300230580090 3 EROM
300230580103 3 EROM
300230580110 3 EROM
300230580141 1 MVIS
300230580158 8 PMED
300400300014 300400300031 3 EROM
300400300048 8 PMED
300400300055 8 PMED
300400300062 8 PMED
300600350034 300600350206 1 MVIS
300610290019 300610290292 1 MVIS
300610290305 1 MVIS
300610290312 1 MVIS
300610290336 8 PMED
300610290350 8 PMED
300610290367 8 PMED
300610290374 8 PMED
300610290398 8 PMED
300610290418 1 MVIS
300610290456 8 PMED
300680130051 300680130196 8 PMED
300680130209 8 PMED
300680130230 8 PMED
300680130247 8 PMED
300910450025 300910450099 8 PMED
300910450102 8 PMED
300910450164 8 PMED
300910450171 8 PMED
301170420016 301170420048 8 PMED
301170420062 8 PMED
301320230021 301320230287 8 PMED
301320230383 8 PMED
301320230390 8 PMED
301320230472 8 PMED
301320230489 8 PMED
301470290031 301470290097 1 MVIS
301470290100 1 MVIS
HC-102I 12:37 Wednesday, September 24, 2008 3
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
301470290031 301470290124 8 PMED
302050190018 302050190016 8 PMED
302050190023 8 PMED
302050330038 302050330054 1 MVIS
302050330078 3 EROM
302050330092 8 PMED
302050330112 8 PMED
302050330050 302050330085 8 PMED
302070200083 302070200148 8 PMED
302070200155 8 PMED
302170520040 302170520033 8 PMED
302560570015 302560570125 8 PMED
302920640046 302920640123 1 MVIS
302920640130 8 PMED
302920640147 8 PMED
302950230018 302950230057 8 PMED
302950230115 8 PMED
303290290060 303290290117 8 PMED
303290290148 8 PMED
303350230045 303350230445 8 PMED
303350230558 8 PMED
303350230572 1 MVIS
303350230589 1 MVIS
303350230596 1 MVIS
303350230623 8 PMED
303350230630 8 PMED
303350230661 8 PMED
303350230678 8 PMED
303350230705 8 PMED
303350230729 8 PMED
303350230801 8 PMED
303350230825 8 PMED
303350230849 8 PMED
303510370015 303510370359 8 PMED
303510370366 8 PMED
HC-102I 12:37 Wednesday, September 24, 2008 4
Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx
Obs EVNTIDX EVENTYPE CONDIDX
1 300180180418 8 PMED 300180180093
2 300180180521 8 PMED 300180180093
3 300180180610 1 MVIS 300180180093
4 300230580090 3 EROM 300230580049
5 300230580103 3 EROM 300230580049
6 300230580110 3 EROM 300230580049
7 300230580141 1 MVIS 300230580049
8 300230580158 8 PMED 300230580049
9 300400300031 3 EROM 300400300014
10 300400300048 8 PMED 300400300014
11 300400300055 8 PMED 300400300014
12 300400300062 8 PMED 300400300014
13 300600350206 1 MVIS 300600350034
14 300610290292 1 MVIS 300610290019
15 300610290305 1 MVIS 300610290019
16 300610290312 1 MVIS 300610290019
17 300610290336 8 PMED 300610290019
18 300610290350 8 PMED 300610290019
19 300610290367 8 PMED 300610290019
20 300610290374 8 PMED 300610290019
21 300610290398 8 PMED 300610290019
22 300610290418 1 MVIS 300610290019
23 300610290456 8 PMED 300610290019
24 300680130196 8 PMED 300680130051
25 300680130209 8 PMED 300680130051
26 300680130230 8 PMED 300680130051
27 300680130247 8 PMED 300680130051
28 300910450099 8 PMED 300910450025
29 300910450102 8 PMED 300910450025
30 300910450164 8 PMED 300910450025
31 300910450171 8 PMED 300910450025
32 301170420048 8 PMED 301170420016
33 301170420062 8 PMED 301170420016
34 301320230287 8 PMED 301320230021
35 301320230383 8 PMED 301320230021
36 301320230390 8 PMED 301320230021
37 301320230472 8 PMED 301320230021
38 301320230489 8 PMED 301320230021
39 301470290097 1 MVIS 301470290031
40 301470290100 1 MVIS 301470290031
41 301470290124 8 PMED 301470290031
42 302050190016 8 PMED 302050190018
43 302050190023 8 PMED 302050190018
44 302050330054 1 MVIS 302050330038
45 302050330078 3 EROM 302050330038
46 302050330085 8 PMED 302050330050
47 302050330092 8 PMED 302050330038
48 302050330112 8 PMED 302050330038
49 302070200148 8 PMED 302070200083
50 302070200155 8 PMED 302070200083
HC-102I 12:37 Wednesday, September 24, 2008 5
Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks
Obs EVNTIDX EVENTYPE
1 300180180418 8 PMED
2 300180180521 8 PMED
3 300180180610 1 MVIS
4 300230580090 3 EROM
5 300230580103 3 EROM
6 300230580110 3 EROM
7 300230580141 1 MVIS
8 300230580158 8 PMED
9 300400300031 3 EROM
10 300400300048 8 PMED
11 300400300055 8 PMED
12 300400300062 8 PMED
13 300600350206 1 MVIS
14 300610290292 1 MVIS
15 300610290305 1 MVIS
16 300610290312 1 MVIS
17 300610290336 8 PMED
18 300610290350 8 PMED
19 300610290367 8 PMED
20 300610290374 8 PMED
21 300610290398 8 PMED
22 300610290418 1 MVIS
23 300610290456 8 PMED
24 300680130196 8 PMED
25 300680130209 8 PMED
26 300680130230 8 PMED
27 300680130247 8 PMED
28 300910450099 8 PMED
29 300910450102 8 PMED
30 300910450164 8 PMED
31 300910450171 8 PMED
32 301170420048 8 PMED
33 301170420062 8 PMED
34 301320230287 8 PMED
35 301320230383 8 PMED
36 301320230390 8 PMED
37 301320230472 8 PMED
38 301320230489 8 PMED
39 301470290097 1 MVIS
40 301470290100 1 MVIS
41 301470290124 8 PMED
42 302050190016 8 PMED
43 302050190023 8 PMED
44 302050330054 1 MVIS
45 302050330078 3 EROM
46 302050330085 8 PMED
47 302050330092 8 PMED
48 302050330112 8 PMED
49 302070200148 8 PMED
50 302070200155 8 PMED
HC-102I 12:37 Wednesday, September 24, 2008 6
Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-102G) events
Obs EVNTIDX EVENTYPE SEETLKPV OBXP06X PERWT06F
1 300180180610 1 MVIS 1 76.00 12968.38
2 300230580141 1 MVIS 1 80.33 4647.88
3 300600350206 1 MVIS 1 88.00 5451.83
4 300610290292 1 MVIS 1 71.43 15210.81
5 300610290305 1 MVIS 1 82.50 15210.81
6 300610290312 1 MVIS 1 38.63 15210.81
7 301470290097 1 MVIS 1 34.21 4964.90
8 301470290100 1 MVIS 1 32.23 4964.90
9 302050330054 1 MVIS 1 42.00 4355.76
10 302920640123 1 MVIS 1 71.97 1436.91
11 303350230572 1 MVIS 1 24.00 8363.55
12 303350230589 1 MVIS 1 83.00 8363.55
13 303670100336 1 MVIS 1 27.03 3728.65
14 303760240669 1 MVIS 1 55.00 11627.75
15 303760240683 1 MVIS 1 55.00 11627.75
16 303760240690 1 MVIS 1 89.00 11627.75
17 303760240703 1 MVIS 1 55.00 11627.75
18 303760240710 1 MVIS 1 106.00 11627.75
19 303760240734 1 MVIS 1 55.00 11627.75
20 303780330350 1 MVIS 1 40.70 15296.33
21 303780330367 1 MVIS 1 29.67 15296.33
22 303780330381 1 MVIS 1 567.11 15296.33
23 303780330398 1 MVIS 1 76.53 15296.33
24 303780330401 1 MVIS 1 264.70 15296.33
25 303780400158 1 MVIS 1 40.70 10940.66
26 303780400223 1 MVIS 1 55.38 10940.66
27 304140140813 1 MVIS 1 82.21 4183.22
28 304140140820 1 MVIS 1 0.00 4183.22
29 304140140837 1 MVIS 1 76.50 4183.22
30 304140140844 1 MVIS 1 0.00 4183.22
31 304140140851 1 MVIS 1 64.00 4183.22
32 304140140868 1 MVIS 1 55.63 4183.22
33 304140141501 1 MVIS 1 64.00 4183.22
34 304140141518 1 MVIS 1 100.17 4183.22
35 304140141525 1 MVIS 1 0.00 4183.22
36 304140141532 1 MVIS 1 55.63 4183.22
37 304140141549 1 MVIS 1 150.51 4183.22
38 304140141690 1 MVIS 1 7.23 4183.22
39 304140141703 1 MVIS 1 236.43 4183.22
40 304140141710 1 MVIS 1 0.00 4183.22
41 304140141727 1 MVIS 1 5.49 4183.22
42 304140141734 1 MVIS 1 182.02 4183.22
43 304140141741 1 MVIS 1 55.63 4183.22
44 304140141758 1 MVIS 1 0.00 4183.22
45 304140141765 1 MVIS 1 128.39 4183.22
46 304140141772 1 MVIS 1 64.00 4183.22
47 304140141789 1 MVIS 1 55.63 4183.22
48 304220360147 1 MVIS 1 112.38 9512.29
49 304250390218 1 MVIS 1 60.00 9947.66
50 304280150687 1 MVIS 1 81.58 2041.04
HC-102I 12:37 Wednesday, September 24, 2008 7
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
The MEANS Procedure
Analysis Variable : OBXP06X SUM OF OBSF06X - OBOT06X (IMPUTED)
N Sum
--------------------
2320 257001.56
--------------------
HC-102I 12:37 Wednesday, September 24, 2008 8
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
The MEANS Procedure
Analysis Variable : OBXP06X SUM OF OBSF06X - OBOT06X (IMPUTED)
N Sum
--------------------
2320 1993563032
--------------------
--------------------
<< previous page