MEPS HC-135I: Attachment 2
Sample SAS Jobs for Linking Example
The SAS System
NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
NOTE: This session is executing on the W32_VSPRO platform.
NOTE: SAS initialization used:
real time 1.29 seconds
cpu time 0.09 seconds
NOTE: AUTOEXEC processing beginning; file is
C:\Program Files\SAS92\SASFoundation\9.2\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 ods rtf file = 'c:\sampleA.rtf' bodytitle;
NOTE: Writing RTF Body file: c:\sampleA.rtf
2
3 ods noproctitle;
4
5 OPTIONS LS=132 PS=59;
6
7 TITLE1 "HC-135I";
8 TITLE2 "Sample SAS Job for Example A";
9
10 LIBNAME IN "C:\Data";
NOTE: Libref IN was successfully assigned as follows:
Engine: V9
Physical Name: C:\Data
11
12
************************************************************************************************
13 * Calculate the expenditures for prescribed
medicines associated with medical visits for asthma.
14
************************************************************************************************;|
15
16 PROC FORMAT;
17 VALUE EVENTYPE
18 1 = "1 MVIS"
19 2 = "2 OPAT"
20 3 = "3 EROM"
21 4 = "4 STAZ"
22 5 = "5 DVIS"
23 6 = "6 OMED"
24 7 = "7 HVIS"
25 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
26
27 RUN;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds
28
29
*-------------------------------------------------------------------------------------
30 * Get condition records coded as asthma.
31
*-------------------------------------------------------------------------------------;
32 DATA ASCONDS;
33 SET IN.H137 (KEEP=CONDIDX CCCODEX);
34 IF CCCODEX="128";
35
36 RUN;
NOTE: There were 102306 observations read from the
data set IN.H137.
NOTE: The data set WORK.ASCONDS has 2130
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 2.65 seconds
cpu time 0.01 seconds
37
38
*------------------------------------------------------------------------------------
39 * Get the events linked to each of the asthma
condition records.
40
*------------------------------------------------------------------------------------;
41 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 2130 observations read from the
data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2130
observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
42
43 proc print data=asconds (obs=50);
44 title3 "sample print of work.asconds - sorted by
condidx";
45 title4 "COND (H137) records where cccodex=128";
46 run;
NOTE: There were 50 observations read from the data
set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.06 seconds
cpu time 0.01 seconds
47
48 PROC SORT DATA=IN.H135IF1 OUT=CLNK; BY CONDIDX;
RUN;
NOTE: There were 292498 observations read from the
data set IN.H135IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 292498
observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 3.13 seconds
cpu time 0.31 seconds
49
50 DATA ASCLNKS;
51 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX
EVENTYPE)
52 ASCONDS(IN=INASCOND KEEP=CONDIDX);
53 BY CONDIDX;
54 IF INCLNK & INASCOND;
55 RUN;
NOTE: There were 292498 observations read from the
data set WORK.CLNK.
NOTE: There were 2130 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 6686
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds
56
57 proc print data=asclnks (obs=75);
58 by condidx;
59 id condidx;
60 format eventype eventype.;
61 title3 "sample print of work.asclnks - sorted by
condidx";
62 title4 "events linked to asthma condition
records";
63 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 (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
64
65 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 6686 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 6686
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
66
67 proc print data=asclnks (obs=50);
68 format eventype eventype.;
69 title3 "sample print of work.asclnks - sorted by
evntidx";
70 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
71
72 DATA ASCLNKS;
73 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
74 BY EVNTIDX;
75 IF FIRST.EVNTIDX;
76 RUN;
NOTE: There were 6686 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6680
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
77
78 proc print data=asclnks (obs=50);
79 title3 "sample print of unique evntidxs from
work.asclnks";
80 format eventype eventype.;
81 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
82
83
*--------------------------------------------------------------------------------------------
84 * Get non-telephone office based visits (i.e.
MVIS events) for persons with positive weights.
85
*--------------------------------------------------------------------------------------------;
86 DATA MVIS;
87 SET IN.H135G (KEEP=EVNTIDX PERWT10F SEETLKPV);
88 IF PERWT10F > 0 & SEETLKPV NE 2;
89 RUN;
NOTE: There were 128246 observations read from the
data set IN.H135G.
NOTE: The data set WORK.MVIS has 124823
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 8.50 seconds
cpu time 0.15 seconds
90
91 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 124823 observations read from the
data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 124823
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.07 seconds
92
93
*---------------------------------------------------------------------------------------------
94 * Identify MVIS events which were for asthma.
95
*---------------------------------------------------------------------------------------------;
96 DATA ASMVIS;
97 MERGE ASCLNKS (IN=INASCLNK)
98 MVIS (IN=INMVIS KEEP=EVNTIDX);
99 BY EVNTIDX;
100 IF INASCLNK & INMVIS;
101 RUN;
NOTE: There were 6680 observations read from the
data set WORK.ASCLNKS.
NOTE: There were 124823 observations read from the
data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1879
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
102
103 proc print data=asmvis (obs=50);
104 format eventype eventype.;
105 title3 "sample print of work.asmvis";
106 title4 "unique evntidxs from work.asclnks that
are non-telephone MVIS (HC-135G) events";
107 run;
NOTE: There were 50 observations read from the data
set WORK.ASMVIS.
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
108
109
*-------------------------------------------------------------------------------------
110 * Get PMED IDs linked to the MVIS events which
were for asthma.
111
*-------------------------------------------------------------------------------------;
112 PROC SORT DATA=IN.H135IF2 OUT=RXLK; BY EVNTIDX;
RUN;
NOTE: There were 52953 observations read from the
data set IN.H135IF2.
NOTE: SAS sort was used.
NOTE: The data set WORK.RXLK has 52953 observations
and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.59 seconds
cpu time 0.04 seconds
113
114 proc print data=rxlk (obs=140);
115 by evntidx;
116 id evntidx;
117 var linkidx eventype;
118 format eventype eventype.;
119 title3 "sample print of work.rxlk - sorted by
evntidx";
120 title4 "Rx+event link file records
(HC-135IF2)";
121 run;
NOTE: There were 140 observations read from the
data set WORK.RXLK.
NOTE: The PROCEDURE PRINT printed pages 7-10.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
122
123 DATA PMEDIDS;
124 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX
EVENTYPE)
125 ASMVIS(IN=INASMVIS KEEP=EVNTIDX);
126 BY EVNTIDX;
127 IF INRXLK & INASMVIS;
128 RUN;
NOTE: There were 52953 observations read from the
data set WORK.RXLK.
NOTE: There were 1879 observations read from the
data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 1809
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
129
130 proc print data=pmedids (obs=50);
131 by evntidx;
132 id evntidx;
133 format eventype eventype.;
134 title3 "sample print of work.pmedids - sorted
by evntidx";
135 title4 "work.rxlk records for evntidxs in
work.asmvis";
136 run;
NOTE: There were 50 observations read from the data
set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed pages 11-12.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
137
138 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 1809 observations read from the
data set WORK.PMEDIDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.PMEDIDS has 1809
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
139
140 proc print data=pmedids (obs=50);
141 format eventype eventype.;
142 title3 "sample print of work.pmedids - sorted
by linkidx";
143 run;
NOTE: There were 50 observations read from the data
set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 13.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
144
145 DATA PMEDIDS;
146 SET PMEDIDS (KEEP=LINKIDX);
147 BY LINKIDX;
148 IF FIRST.LINKIDX;
149 RUN;
NOTE: There were 1809 observations read from the
data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1725
observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
150
151 proc print data=pmedids (obs=50);
152 title3 "sample print of unique linkidxs in
work.pmedids";
153 run;
NOTE: There were 50 observations read from the data
set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 14.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
154
155
*-----------------------------------------------------------------------------------------
156 * Get PMED records linked to MVIS events which
were for asthma.
157
*-----------------------------------------------------------------------------------------;
158 PROC SORT DATA=IN.H135A OUT=PMED; BY LINKIDX;
RUN;
NOTE: There were 301032 observations read from the
data set IN.H135A.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.PMED has 301032
observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 7.34 seconds
cpu time 0.51 seconds
159
160 DATA MVPMEDS;
161 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP10X
PERWT10F RXNAME)
162 PMEDIDS (IN=A);
163 BY LINKIDX;
164 IF A;
165 RUN;
NOTE: There were 301032 observations read from the
data set WORK.PMED.
NOTE: There were 1725 observations read from the
data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 4676
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds
166
167 proc print data=mvpmeds (obs=200);
168 var rxrecidx rxname RXXP10X PERWT10F;
169 by linkidx;
170 id linkidx;
171 title3 "sample print of work.mvpmeds";
172 title4 "PMED (HC-135A) records for unique
linkidxs in work.pmedids";
173 run;
NOTE: There were 200 observations read from the
data set WORK.MVPMEDS.
NOTE: The PROCEDURE PRINT printed pages 15-20.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
174
175 PROC MEANS DATA=MVPMEDS N SUM;
176 VAR RXXP10X;
177 TITLE3 "Total Rx expenditures associated with
medical visits (excluding telephone) for asthma";
178 RUN;
NOTE: Multiple concurrent threads will be used to
summarize data.
NOTE: There were 4676 observations read from the
data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 21.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds
179
180 PROC MEANS DATA=MVPMEDS N SUM;
181 VAR RXXP10X;
182 WEIGHT PERWT10F;
183 TITLE3 "Total Rx expenditures associated with
medical visits (excluding telephone) for asthma";
184 TITLE5 "Weighted";
185 RUN;
NOTE: Multiple concurrent threads will be used to
summarize data.
NOTE: There were 4676 observations read from the
data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 22.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
186
187 ods rtf close;
188
NOTE: SAS Institute Inc., SAS Campus Drive, Cary,
NC USA 27513-2414
NOTE: The SAS System used:
real time 25.81 seconds
cpu time 1.62 seconds
Return to Top
HC-135I. Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H137) records where cccodex=128
Obs |
CONDIDX |
CCCODEX |
1 |
100121010051 |
128 |
2 |
100171010021 |
128 |
3 |
100431010021 |
128 |
4 |
100431030011 |
128 |
5 |
100431040011 |
128 |
6 |
100441010031 |
128 |
7 |
100531020041 |
128 |
8 |
100531040011 |
128 |
9 |
100661010021 |
128 |
10 |
100671010071 |
128 |
11 |
100671020041 |
128 |
12 |
100861020041 |
128 |
13 |
101311020041 |
128 |
14 |
101371010051 |
128 |
15 |
101541020041 |
128 |
16 |
101831050011 |
128 |
17 |
101841020091 |
128 |
18 |
101981020061 |
128 |
19 |
101981030051 |
128 |
20 |
101981040031 |
128 |
21 |
101981050011 |
128 |
22 |
102061010011 |
128 |
23 |
102061040011 |
128 |
24 |
102291020011 |
128 |
25 |
102361030011 |
128 |
26 |
102361040011 |
128 |
27 |
102421010041 |
128 |
28 |
102442010032 |
128 |
29 |
102451010021 |
128 |
30 |
102451030011 |
128 |
31 |
102531020011 |
128 |
32 |
102591050011 |
128 |
33 |
102601010071 |
128 |
34 |
102691010111 |
128 |
35 |
102691020091 |
128 |
36 |
102692030012 |
128 |
37 |
102781020031 |
128 |
38 |
102891010051 |
128 |
39 |
102891020021 |
128 |
40 |
102991060011 |
128 |
41 |
103051020011 |
128 |
42 |
103101010031 |
128 |
43 |
103131010111 |
128 |
44 |
103311010051 |
128 |
45 |
103331010021 |
128 |
46 |
103371010011 |
128 |
47 |
103581010041 |
128 |
48 |
103691010021 |
128 |
49 |
103851030011 |
128 |
50 |
103851040011 |
128 |
Return to Top
HC-135I. Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
100121010051 |
100121010051 |
8 PMED |
100121010051 |
100121010111 |
8 PMED |
100121010051 |
100121010151 |
8 PMED |
100171010021 |
100171010091 |
8 PMED |
100171010021 |
100171010161 |
8 PMED |
100171010021 |
100171010181 |
1 MVIS |
100431010021 |
100431010121 |
8 PMED |
100431030011 |
100431030011 |
1 MVIS |
100431030011 |
100431030021 |
8 PMED |
100431030011 |
100431030031 |
8 PMED |
100431030011 |
100431030051 |
8 PMED |
100431030011 |
100431030071 |
1 MVIS |
100431030011 |
100431030091 |
8 PMED |
100431030011 |
100431030101 |
8 PMED |
100431030011 |
100431030111 |
8 PMED |
100431030011 |
100431030121 |
8 PMED |
100431030011 |
100431030171 |
8 PMED |
100431040011 |
100431040011 |
1 MVIS |
100431040011 |
100431040021 |
1 MVIS |
100431040011 |
100431040031 |
8 PMED |
100431040011 |
100431040041 |
8 PMED |
100431040011 |
100431040051 |
8 PMED |
100431040011 |
100431040061 |
8 PMED |
100431040011 |
100431040071 |
8 PMED |
100431040011 |
100431040081 |
8 PMED |
100431040011 |
100431040091 |
1 MVIS |
100431040011 |
100431040101 |
1 MVIS |
100431040011 |
100431040111 |
1 MVIS |
100431040011 |
100431040131 |
8 PMED |
100431040011 |
100431040141 |
8 PMED |
100431040011 |
100431040151 |
8 PMED |
100431040011 |
100431040161 |
8 PMED |
100431040011 |
100431040171 |
1 MVIS |
100431040011 |
100431040201 |
1 MVIS |
100431040011 |
100431040211 |
1 MVIS |
100431040011 |
100431040231 |
8 PMED |
100431040011 |
100431040241 |
8 PMED |
100431040011 |
100431040251 |
8 PMED |
100431040011 |
100431040271 |
8 PMED |
100441010031 |
100441010031 |
2 OPAT |
100441010031 |
100441010091 |
8 PMED |
100441010031 |
100441010101 |
8 PMED |
100441010031 |
100441010111 |
8 PMED |
100531020041 |
100531020361 |
8 PMED |
100531040011 |
100531040021 |
8 PMED |
100661010021 |
100661010021 |
8 PMED |
100661010021 |
100661010041 |
8 PMED |
100671010071 |
100671010171 |
8 PMED |
100671010071 |
100671010181 |
8 PMED |
100671010071 |
100671010191 |
8 PMED |
100671010071 |
100671010401 |
8 PMED |
100671010071 |
100671010411 |
8 PMED |
100671010071 |
100671010421 |
8 PMED |
100671010071 |
100671010511 |
8 PMED |
100671010071 |
100671010521 |
8 PMED |
100671010071 |
100671010531 |
8 PMED |
100671020041 |
100671020371 |
8 PMED |
100671020041 |
100671020411 |
8 PMED |
100861020041 |
100861020011 |
1 MVIS |
100861020041 |
100861020031 |
8 PMED |
100861020041 |
100861020091 |
8 PMED |
100861020041 |
100861020101 |
8 PMED |
100861020041 |
100861020111 |
1 MVIS |
100861020041 |
100861020141 |
8 PMED |
100861020041 |
100861020151 |
8 PMED |
101371010051 |
101371010261 |
1 MVIS |
101371010051 |
101371010341 |
8 PMED |
101371010051 |
101371010381 |
8 PMED |
101541020041 |
101541020011 |
1 MVIS |
101841020091 |
101841020381 |
8 PMED |
101841020091 |
101841020401 |
2 OPAT |
102061010011 |
102061010071 |
8 PMED |
102061040011 |
102061040011 |
1 MVIS |
102061040011 |
102061040021 |
1 MVIS |
102061040011 |
102061040031 |
3 EROM |
Return to Top
HC-135I. Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
100121010051 |
100121010051 |
8 PMED |
2 |
100121010051 |
100121010111 |
8 PMED |
3 |
100121010051 |
100121010151 |
8 PMED |
4 |
100171010021 |
100171010091 |
8 PMED |
5 |
100171010021 |
100171010161 |
8 PMED |
6 |
100171010021 |
100171010181 |
1 MVIS |
7 |
100431010021 |
100431010121 |
8 PMED |
8 |
100431030011 |
100431030011 |
1 MVIS |
9 |
100431030011 |
100431030021 |
8 PMED |
10 |
100431030011 |
100431030031 |
8 PMED |
11 |
100431030011 |
100431030051 |
8 PMED |
12 |
100431030011 |
100431030071 |
1 MVIS |
13 |
100431030011 |
100431030091 |
8 PMED |
14 |
100431030011 |
100431030101 |
8 PMED |
15 |
100431030011 |
100431030111 |
8 PMED |
16 |
100431030011 |
100431030121 |
8 PMED |
17 |
100431030011 |
100431030171 |
8 PMED |
18 |
100431040011 |
100431040011 |
1 MVIS |
19 |
100431040011 |
100431040021 |
1 MVIS |
20 |
100431040011 |
100431040031 |
8 PMED |
21 |
100431040011 |
100431040041 |
8 PMED |
22 |
100431040011 |
100431040051 |
8 PMED |
23 |
100431040011 |
100431040061 |
8 PMED |
24 |
100431040011 |
100431040071 |
8 PMED |
25 |
100431040011 |
100431040081 |
8 PMED |
26 |
100431040011 |
100431040091 |
1 MVIS |
27 |
100431040011 |
100431040101 |
1 MVIS |
28 |
100431040011 |
100431040111 |
1 MVIS |
29 |
100431040011 |
100431040131 |
8 PMED |
30 |
100431040011 |
100431040141 |
8 PMED |
31 |
100431040011 |
100431040151 |
8 PMED |
32 |
100431040011 |
100431040161 |
8 PMED |
33 |
100431040011 |
100431040171 |
1 MVIS |
34 |
100431040011 |
100431040201 |
1 MVIS |
35 |
100431040011 |
100431040211 |
1 MVIS |
36 |
100431040011 |
100431040231 |
8 PMED |
37 |
100431040011 |
100431040241 |
8 PMED |
38 |
100431040011 |
100431040251 |
8 PMED |
39 |
100431040011 |
100431040271 |
8 PMED |
40 |
100441010031 |
100441010031 |
2 OPAT |
41 |
100441010031 |
100441010091 |
8 PMED |
42 |
100441010031 |
100441010101 |
8 PMED |
43 |
100441010031 |
100441010111 |
8 PMED |
44 |
100531020041 |
100531020361 |
8 PMED |
45 |
100531040011 |
100531040021 |
8 PMED |
46 |
100661010021 |
100661010021 |
8 PMED |
47 |
100661010021 |
100661010041 |
8 PMED |
48 |
100671010071 |
100671010171 |
8 PMED |
49 |
100671010071 |
100671010181 |
8 PMED |
50 |
100671010071 |
100671010191 |
8 PMED |
Return to Top HC-135I. Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
100121010051 |
8 PMED |
2 |
100121010111 |
8 PMED |
3 |
100121010151 |
8 PMED |
4 |
100171010091 |
8 PMED |
5 |
100171010161 |
8 PMED |
6 |
100171010181 |
1 MVIS |
7 |
100431010121 |
8 PMED |
8 |
100431030011 |
1 MVIS |
9 |
100431030021 |
8 PMED |
10 |
100431030031 |
8 PMED |
11 |
100431030051 |
8 PMED |
12 |
100431030071 |
1 MVIS |
13 |
100431030091 |
8 PMED |
14 |
100431030101 |
8 PMED |
15 |
100431030111 |
8 PMED |
16 |
100431030121 |
8 PMED |
17 |
100431030171 |
8 PMED |
18 |
100431040011 |
1 MVIS |
19 |
100431040021 |
1 MVIS |
20 |
100431040031 |
8 PMED |
21 |
100431040041 |
8 PMED |
22 |
100431040051 |
8 PMED |
23 |
100431040061 |
8 PMED |
24 |
100431040071 |
8 PMED |
25 |
100431040081 |
8 PMED |
26 |
100431040091 |
1 MVIS |
27 |
100431040101 |
1 MVIS |
28 |
100431040111 |
1 MVIS |
29 |
100431040131 |
8 PMED |
30 |
100431040141 |
8 PMED |
31 |
100431040151 |
8 PMED |
32 |
100431040161 |
8 PMED |
33 |
100431040171 |
1 MVIS |
34 |
100431040201 |
1 MVIS |
35 |
100431040211 |
1 MVIS |
36 |
100431040231 |
8 PMED |
37 |
100431040241 |
8 PMED |
38 |
100431040251 |
8 PMED |
39 |
100431040271 |
8 PMED |
40 |
100441010031 |
2 OPAT |
41 |
100441010091 |
8 PMED |
42 |
100441010101 |
8 PMED |
43 |
100441010111 |
8 PMED |
44 |
100531020361 |
8 PMED |
45 |
100531040021 |
8 PMED |
46 |
100661010021 |
8 PMED |
47 |
100661010041 |
8 PMED |
48 |
100671010171 |
8 PMED |
49 |
100671010181 |
8 PMED |
50 |
100671010191 |
8 PMED |
Return to Top
HC-135I. Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-135G) events
Obs |
EVNTIDX |
EVENTYPE |
1 |
100171010181 |
1 MVIS |
2 |
100431030011 |
1 MVIS |
3 |
100431030071 |
1 MVIS |
4 |
100431040011 |
1 MVIS |
5 |
100431040021 |
1 MVIS |
6 |
100431040091 |
1 MVIS |
7 |
100431040101 |
1 MVIS |
8 |
100431040111 |
1 MVIS |
9 |
100431040171 |
1 MVIS |
10 |
100431040201 |
1 MVIS |
11 |
100431040211 |
1 MVIS |
12 |
100861020011 |
1 MVIS |
13 |
100861020111 |
1 MVIS |
14 |
101371010261 |
1 MVIS |
15 |
101541020011 |
1 MVIS |
16 |
102061040011 |
1 MVIS |
17 |
102061040021 |
1 MVIS |
18 |
102291020061 |
1 MVIS |
19 |
102451010081 |
1 MVIS |
20 |
102451030011 |
1 MVIS |
21 |
102531020051 |
1 MVIS |
22 |
102601010131 |
1 MVIS |
23 |
102601010141 |
1 MVIS |
24 |
102601010151 |
1 MVIS |
25 |
102601010161 |
1 MVIS |
26 |
102691010101 |
1 MVIS |
27 |
102781020141 |
1 MVIS |
28 |
102781020151 |
1 MVIS |
29 |
102991060021 |
1 MVIS |
30 |
103051020041 |
1 MVIS |
31 |
103051020051 |
1 MVIS |
32 |
103051020061 |
1 MVIS |
33 |
103051020131 |
1 MVIS |
34 |
103581010011 |
1 MVIS |
35 |
103581010561 |
1 MVIS |
36 |
103581010571 |
1 MVIS |
37 |
103581010581 |
1 MVIS |
38 |
103921030071 |
1 MVIS |
39 |
103921030081 |
1 MVIS |
40 |
103921030091 |
1 MVIS |
41 |
103921030101 |
1 MVIS |
42 |
103921030111 |
1 MVIS |
43 |
103921030121 |
1 MVIS |
44 |
103921030131 |
1 MVIS |
45 |
103921030141 |
1 MVIS |
46 |
103921030151 |
1 MVIS |
47 |
103921030161 |
1 MVIS |
48 |
103921030171 |
1 MVIS |
49 |
103921030181 |
1 MVIS |
50 |
103921030191 |
1 MVIS |
Return to Top
HC-135I. Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-135IF2)
EVNTIDX |
LINKIDX |
EVENTYPE |
100071010011 |
100071010031 |
1 MVIS |
100071010021 |
100071010041 |
1 MVIS |
100071010071 |
100071010081 |
1 MVIS |
100071020041 |
100071020061 |
1 MVIS |
100071020051 |
100071020071 |
1 MVIS |
100091010171 |
100091010121 |
4 STAZ |
100091010171 |
100091010131 |
4 STAZ |
100091010181 |
100091010191 |
4 STAZ |
100091010181 |
100091010201 |
4 STAZ |
100091010181 |
100091010211 |
4 STAZ |
100091010181 |
100091010221 |
4 STAZ |
100091010181 |
100091010231 |
4 STAZ |
100091010181 |
100091010241 |
4 STAZ |
100091010181 |
100091010251 |
4 STAZ |
100091010181 |
100091010261 |
4 STAZ |
100091010181 |
100091010271 |
4 STAZ |
100121010091 |
100121010111 |
1 MVIS |
100121010091 |
100121010121 |
1 MVIS |
100121010091 |
100121010131 |
1 MVIS |
100121010091 |
100121010151 |
1 MVIS |
100121010091 |
100121010161 |
1 MVIS |
100121010091 |
100121010171 |
1 MVIS |
100121020171 |
100121020301 |
1 MVIS |
100121020181 |
100121020311 |
1 MVIS |
100121020231 |
100121020321 |
1 MVIS |
100161010011 |
100161010021 |
1 MVIS |
100161010311 |
100161010321 |
4 STAZ |
100161010311 |
100161010331 |
4 STAZ |
100161050011 |
100161050031 |
1 MVIS |
100161050021 |
100161050041 |
3 EROM |
100161050021 |
100161050051 |
3 EROM |
100161050061 |
100161050111 |
3 EROM |
100161050061 |
100161050121 |
3 EROM |
100171010031 |
100171010041 |
1 MVIS |
100171010031 |
100171010051 |
1 MVIS |
100171010171 |
100171010191 |
5 DVIS |
100191020081 |
100191020201 |
1 MVIS |
100211010081 |
100211010091 |
4 STAZ |
100211010081 |
100211010101 |
4 STAZ |
100261030021 |
100261030031 |
1 MVIS |
100301010011 |
100301010041 |
3 EROM |
100301010051 |
100301010071 |
1 MVIS |
100301010051 |
100301010081 |
1 MVIS |
100301010051 |
100301010091 |
1 MVIS |
100301010101 |
100301010121 |
1 MVIS |
100301010101 |
100301010131 |
1 MVIS |
100301010101 |
100301010141 |
1 MVIS |
100301020011 |
100301020031 |
1 MVIS |
100301020011 |
100301020041 |
1 MVIS |
100301030011 |
100301030021 |
1 MVIS |
100301030031 |
100301030051 |
1 MVIS |
100301030031 |
100301030061 |
1 MVIS |
100301040011 |
100301040021 |
1 MVIS |
100301040011 |
100301040031 |
1 MVIS |
100301040051 |
100301040061 |
5 DVIS |
100331010031 |
100331010051 |
1 MVIS |
100331010041 |
100331010061 |
1 MVIS |
100331010041 |
100331010071 |
1 MVIS |
100331010041 |
100331010081 |
1 MVIS |
100331010091 |
100331010121 |
1 MVIS |
100331010091 |
100331010131 |
1 MVIS |
100331010091 |
100331010141 |
1 MVIS |
100331010091 |
100331010151 |
1 MVIS |
100331010091 |
100331010161 |
1 MVIS |
100331010171 |
100331010241 |
5 DVIS |
100331010201 |
100331010251 |
1 MVIS |
100331030011 |
100331030021 |
1 MVIS |
100331030011 |
100331030031 |
1 MVIS |
100331030011 |
100331030041 |
1 MVIS |
100331030011 |
100331030051 |
1 MVIS |
100331030011 |
100331030061 |
1 MVIS |
100331030011 |
100331030071 |
1 MVIS |
100331030011 |
100331030081 |
1 MVIS |
100331030011 |
100331030091 |
1 MVIS |
100331030101 |
100331030121 |
1 MVIS |
100331030101 |
100331030131 |
1 MVIS |
100331030101 |
100331030141 |
1 MVIS |
100331030101 |
100331030151 |
1 MVIS |
100331030101 |
100331030161 |
1 MVIS |
100331030101 |
100331030171 |
1 MVIS |
100331030101 |
100331030181 |
1 MVIS |
100331030101 |
100331030191 |
1 MVIS |
100331030201 |
100331030381 |
1 MVIS |
100331030211 |
100331030371 |
1 MVIS |
100331030211 |
100331030381 |
1 MVIS |
100331030211 |
100331030391 |
1 MVIS |
100331030211 |
100331030401 |
1 MVIS |
100331030211 |
100331030411 |
1 MVIS |
100331030211 |
100331030421 |
1 MVIS |
100331030211 |
100331030431 |
1 MVIS |
100331030211 |
100331030441 |
1 MVIS |
100331030211 |
100331030451 |
1 MVIS |
100331030211 |
100331030461 |
1 MVIS |
100331030221 |
100331030371 |
1 MVIS |
100331030221 |
100331030381 |
1 MVIS |
100331030221 |
100331030391 |
1 MVIS |
100331030221 |
100331030401 |
1 MVIS |
100331030221 |
100331030411 |
1 MVIS |
100331030221 |
100331030421 |
1 MVIS |
100331030221 |
100331030431 |
1 MVIS |
100331030221 |
100331030441 |
1 MVIS |
100331030221 |
100331030451 |
1 MVIS |
100331030221 |
100331030461 |
1 MVIS |
100331030231 |
100331030381 |
1 MVIS |
100331030301 |
100331030381 |
1 MVIS |
100331030301 |
100331030391 |
1 MVIS |
100331030301 |
100331030401 |
1 MVIS |
100331030301 |
100331030411 |
1 MVIS |
100331030301 |
100331030421 |
1 MVIS |
100331030301 |
100331030431 |
1 MVIS |
100331030301 |
100331030441 |
1 MVIS |
100331030301 |
100331030451 |
1 MVIS |
100331030301 |
100331030461 |
1 MVIS |
100331030301 |
100331030471 |
1 MVIS |
100341010011 |
100341010021 |
1 MVIS |
100341010011 |
100341010031 |
1 MVIS |
100341010061 |
100341010071 |
1 MVIS |
100341030061 |
100341030141 |
1 MVIS |
100351010011 |
100351010021 |
1 MVIS |
100351010011 |
100351010031 |
1 MVIS |
100351010041 |
100351010051 |
1 MVIS |
100351010041 |
100351010061 |
1 MVIS |
100351030011 |
100351030051 |
1 MVIS |
100351040011 |
100351040021 |
1 MVIS |
100351040011 |
100351040031 |
1 MVIS |
100351040011 |
100351040041 |
1 MVIS |
100351040051 |
100351040061 |
1 MVIS |
100351040051 |
100351040071 |
1 MVIS |
100351040081 |
100351040141 |
1 MVIS |
100351040081 |
100351040151 |
1 MVIS |
100351040131 |
100351040171 |
4 STAZ |
100391010011 |
100391010051 |
1 MVIS |
100391010011 |
100391010061 |
1 MVIS |
100391010021 |
100391010031 |
1 MVIS |
100391010021 |
100391010041 |
1 MVIS |
100401010431 |
100401010691 |
5 DVIS |
100401020011 |
100401020031 |
1 MVIS |
100401020011 |
100401020041 |
1 MVIS |
100401020011 |
100401020051 |
1 MVIS |
100401020011 |
100401020061 |
1 MVIS |
Return to Top
HC-135I. 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 |
100431030011 |
100431030021 |
1 MVIS |
100431030011 |
100431030031 |
1 MVIS |
100431030071 |
100431030101 |
1 MVIS |
100431030071 |
100431030121 |
1 MVIS |
100431040011 |
100431040031 |
1 MVIS |
100431040011 |
100431040041 |
1 MVIS |
100431040021 |
100431040031 |
1 MVIS |
100431040021 |
100431040041 |
1 MVIS |
100431040201 |
100431040251 |
1 MVIS |
100431040201 |
100431040261 |
1 MVIS |
100431040201 |
100431040271 |
1 MVIS |
100431040211 |
100431040251 |
1 MVIS |
100431040211 |
100431040261 |
1 MVIS |
100861020011 |
100861020021 |
1 MVIS |
100861020011 |
100861020031 |
1 MVIS |
100861020011 |
100861020041 |
1 MVIS |
100861020011 |
100861020051 |
1 MVIS |
100861020011 |
100861020061 |
1 MVIS |
100861020011 |
100861020071 |
1 MVIS |
100861020011 |
100861020081 |
1 MVIS |
100861020011 |
100861020091 |
1 MVIS |
100861020011 |
100861020101 |
1 MVIS |
101371010261 |
101371010341 |
1 MVIS |
101541020011 |
101541020021 |
1 MVIS |
101541020011 |
101541020031 |
1 MVIS |
101541020011 |
101541020041 |
1 MVIS |
101541020011 |
101541020051 |
1 MVIS |
101541020011 |
101541020061 |
1 MVIS |
102061040011 |
102061040041 |
1 MVIS |
102061040021 |
102061040041 |
1 MVIS |
102291020061 |
102291020091 |
1 MVIS |
102451030011 |
102451030071 |
1 MVIS |
102531020051 |
102531020061 |
1 MVIS |
102601010131 |
102601010281 |
1 MVIS |
102601010131 |
102601010291 |
1 MVIS |
102601010131 |
102601010301 |
1 MVIS |
102601010131 |
102601010311 |
1 MVIS |
102781020141 |
102781020161 |
1 MVIS |
102781020151 |
102781020171 |
1 MVIS |
102781020151 |
102781020181 |
1 MVIS |
102991060021 |
102991060031 |
1 MVIS |
102991060021 |
102991060041 |
1 MVIS |
102991060021 |
102991060051 |
1 MVIS |
103051020041 |
103051020081 |
1 MVIS |
103051020041 |
103051020091 |
1 MVIS |
103581010011 |
103581010041 |
1 MVIS |
103581010011 |
103581010051 |
1 MVIS |
103581010011 |
103581010061 |
1 MVIS |
103581010011 |
103581010071 |
1 MVIS |
103581010011 |
103581010081 |
1 MVIS |
Return to Top
HC-135I. Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx
Obs |
EVNTIDX |
LINKIDX |
EVENTYPE |
1 |
100431030011 |
100431030021 |
1 MVIS |
2 |
100431030011 |
100431030031 |
1 MVIS |
3 |
100431030071 |
100431030101 |
1 MVIS |
4 |
100431030071 |
100431030121 |
1 MVIS |
5 |
100431040011 |
100431040031 |
1 MVIS |
6 |
100431040021 |
100431040031 |
1 MVIS |
7 |
100431040011 |
100431040041 |
1 MVIS |
8 |
100431040021 |
100431040041 |
1 MVIS |
9 |
100431040201 |
100431040251 |
1 MVIS |
10 |
100431040211 |
100431040251 |
1 MVIS |
11 |
100431040201 |
100431040261 |
1 MVIS |
12 |
100431040211 |
100431040261 |
1 MVIS |
13 |
100431040201 |
100431040271 |
1 MVIS |
14 |
100861020011 |
100861020021 |
1 MVIS |
15 |
100861020011 |
100861020031 |
1 MVIS |
16 |
100861020011 |
100861020041 |
1 MVIS |
17 |
100861020011 |
100861020051 |
1 MVIS |
18 |
100861020011 |
100861020061 |
1 MVIS |
19 |
100861020011 |
100861020071 |
1 MVIS |
20 |
100861020011 |
100861020081 |
1 MVIS |
21 |
100861020011 |
100861020091 |
1 MVIS |
22 |
100861020011 |
100861020101 |
1 MVIS |
23 |
101371010261 |
101371010341 |
1 MVIS |
24 |
101541020011 |
101541020021 |
1 MVIS |
25 |
101541020011 |
101541020031 |
1 MVIS |
26 |
101541020011 |
101541020041 |
1 MVIS |
27 |
101541020011 |
101541020051 |
1 MVIS |
28 |
101541020011 |
101541020061 |
1 MVIS |
29 |
102061040011 |
102061040041 |
1 MVIS |
30 |
102061040021 |
102061040041 |
1 MVIS |
31 |
102291020061 |
102291020091 |
1 MVIS |
32 |
102451030011 |
102451030071 |
1 MVIS |
33 |
102531020051 |
102531020061 |
1 MVIS |
34 |
102601010131 |
102601010281 |
1 MVIS |
35 |
102601010131 |
102601010291 |
1 MVIS |
36 |
102601010131 |
102601010301 |
1 MVIS |
37 |
102601010131 |
102601010311 |
1 MVIS |
38 |
102781020141 |
102781020161 |
1 MVIS |
39 |
102781020151 |
102781020171 |
1 MVIS |
40 |
102781020151 |
102781020181 |
1 MVIS |
41 |
102991060021 |
102991060031 |
1 MVIS |
42 |
102991060021 |
102991060041 |
1 MVIS |
43 |
102991060021 |
102991060051 |
1 MVIS |
44 |
103051020041 |
103051020081 |
1 MVIS |
45 |
103051020041 |
103051020091 |
1 MVIS |
46 |
103581010011 |
103581010041 |
1 MVIS |
47 |
103581010011 |
103581010051 |
1 MVIS |
48 |
103581010011 |
103581010061 |
1 MVIS |
49 |
103581010011 |
103581010071 |
1 MVIS |
50 |
103581010011 |
103581010081 |
1 MVIS |
Return to Top
HC-135I. Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids
Obs |
LINKIDX |
1 |
100431030021 |
2 |
100431030031 |
3 |
100431030101 |
4 |
100431030121 |
5 |
100431040031 |
6 |
100431040041 |
7 |
100431040251 |
8 |
100431040261 |
9 |
100431040271 |
10 |
100861020021 |
11 |
100861020031 |
12 |
100861020041 |
13 |
100861020051 |
14 |
100861020061 |
15 |
100861020071 |
16 |
100861020081 |
17 |
100861020091 |
18 |
100861020101 |
19 |
101371010341 |
20 |
101541020021 |
21 |
101541020031 |
22 |
101541020041 |
23 |
101541020051 |
24 |
101541020061 |
25 |
102061040041 |
26 |
102291020091 |
27 |
102451030071 |
28 |
102531020061 |
29 |
102601010281 |
30 |
102601010291 |
31 |
102601010301 |
32 |
102601010311 |
33 |
102781020161 |
34 |
102781020171 |
35 |
102781020181 |
36 |
102991060031 |
37 |
102991060041 |
38 |
102991060051 |
39 |
103051020081 |
40 |
103051020091 |
41 |
103581010041 |
42 |
103581010051 |
43 |
103581010061 |
44 |
103581010071 |
45 |
103581010081 |
46 |
103581010091 |
47 |
103581010621 |
48 |
103581010631 |
49 |
103581010641 |
50 |
103581010651 |
Return to Top
HC-135I. Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-135A) records for unique linkidxs in work.pmedids
LINKIDX |
RXRECIDX |
RXNAME |
RXXP10X |
PERWT10F |
100431030021 |
100431030021001 |
AZITHROMYCIN |
26.76 |
13273.138854 |
100431030031 |
100431030031001 |
PREDNISOLONE |
9.69 |
13273.138854 |
100431030101 |
100431030101001 |
AZITHROMYCIN |
30.82 |
13273.138854 |
100431030101 |
100431030101002 |
AZITHROMYCIN |
62.41 |
13273.138854 |
100431030121 |
100431030121001 |
PREDNISONE |
3.17 |
13273.138854 |
100431040031 |
100431040031001 |
AZITHROMYCIN |
26.76 |
24678.499660 |
100431040031 |
100431040031002 |
AZITHROMYCIN |
26.76 |
24678.499660 |
100431040041 |
100431040041001 |
PREDNISONE |
2.57 |
24678.499660 |
100431040251 |
100431040251001 |
PREDNISONE |
2.57 |
24678.499660 |
100431040251 |
100431040251002 |
PREDNISONE |
2.53 |
24678.499660 |
100431040261 |
100431040261001 |
CEFPROZIL |
38.51 |
24678.499660 |
100431040261 |
100431040261002 |
CEFPROZIL |
36.71 |
24678.499660 |
100431040271 |
100431040271001 |
XOPENEX HFA |
51.28 |
24678.499660 |
100861020021 |
100861020021001 |
LORATADINE |
5.92 |
4351.170836 |
100861020031 |
100861020031001 |
SINGULAIR |
118.20 |
4351.170836 |
100861020041 |
100861020041001 |
LIPITOR |
132.19 |
4351.170836 |
100861020051 |
100861020051001 |
METFORMIN |
5.00 |
4351.170836 |
100861020061 |
100861020061001 |
GLIMEPIRIDE |
5.02 |
4351.170836 |
100861020071 |
100861020071001 |
ISOMETH/APAP |
18.42 |
4351.170836 |
100861020081 |
100861020081001 |
JANUVIA |
184.21 |
4351.170836 |
100861020091 |
100861020091001 |
PROAIR HFA |
38.28 |
4351.170836 |
100861020101 |
100861020101001 |
ADVAIR DISKU |
281.37 |
4351.170836 |
101371010341 |
101371010341001 |
PREDNISONE |
12.02 |
3246.386814 |
101541020021 |
101541020021001 |
BENAZEPRIL |
15.00 |
6213.899262 |
101541020021 |
101541020021002 |
BENAZEPRIL |
15.00 |
6213.899262 |
101541020031 |
101541020031001 |
GLIPIZIDE |
7.88 |
6213.899262 |
101541020031 |
101541020031002 |
GLIPIZIDE |
7.88 |
6213.899262 |
101541020031 |
101541020031003 |
GLIPIZIDE |
4.00 |
6213.899262 |
101541020031 |
101541020031004 |
GLIPIZIDE |
4.00 |
6213.899262 |
101541020031 |
101541020031005 |
GLIPIZIDE |
4.00 |
6213.899262 |
101541020041 |
101541020041001 |
TRILIPIX |
121.00 |
6213.899262 |
101541020041 |
101541020041002 |
TRILIPIX |
121.00 |
6213.899262 |
101541020041 |
101541020041003 |
TRILIPIX |
121.00 |
6213.899262 |
101541020041 |
101541020041004 |
TRILIPIX |
121.00 |
6213.899262 |
101541020041 |
101541020041005 |
TRILIPIX |
121.00 |
6213.899262 |
101541020051 |
101541020051001 |
SIMCOR |
65.95 |
6213.899262 |
101541020051 |
101541020051002 |
SIMCOR |
65.95 |
6213.899262 |
101541020051 |
101541020051003 |
SIMCOR |
65.95 |
6213.899262 |
101541020051 |
101541020051004 |
SIMCOR |
65.95 |
6213.899262 |
101541020051 |
101541020051005 |
SIMCOR |
65.95 |
6213.899262 |
101541020061 |
101541020061001 |
BYSTOLIC |
62.00 |
6213.899262 |
101541020061 |
101541020061002 |
BYSTOLIC |
62.00 |
6213.899262 |
102061040041 |
102061040041001 |
Albuterol |
0.22 |
9038.830355 |
102291020091 |
102291020091001 |
Proventil HFA |
43.16 |
10983.991425 |
102451030071 |
102451030071001 |
CONCERTA |
148.49 |
18569.059372 |
102451030071 |
102451030071002 |
CONCERTA |
158.65 |
18569.059372 |
102531020061 |
102531020061001 |
MAXALT |
139.29 |
25782.763549 |
102601010281 |
102601010281001 |
GLIMEPIRIDE |
4.13 |
10351.477283 |
102601010281 |
102601010281002 |
GLIMEPIRIDE |
4.13 |
10351.477283 |
102601010281 |
102601010281003 |
GLIMEPIRIDE |
4.13 |
10351.477283 |
102601010281 |
102601010281004 |
GLIMEPIRIDE |
4.13 |
10351.477283 |
102601010281 |
102601010281005 |
GLIMEPIRIDE |
4.13 |
10351.477283 |
102601010281 |
102601010281006 |
GLIMEPIRIDE |
4.13 |
10351.477283 |
102601010291 |
102601010291001 |
SIMVASTATIN |
9.93 |
10351.477283 |
102601010291 |
102601010291002 |
SIMVASTATIN |
9.93 |
10351.477283 |
102601010291 |
102601010291003 |
SIMVASTATIN |
9.93 |
10351.477283 |
102601010291 |
102601010291004 |
SIMVASTATIN |
9.93 |
10351.477283 |
102601010291 |
102601010291005 |
SIMVASTATIN |
9.93 |
10351.477283 |
102601010291 |
102601010291006 |
SIMVASTATIN |
9.93 |
10351.477283 |
102601010301 |
102601010301001 |
LISINOPRIL |
5.23 |
10351.477283 |
102601010301 |
102601010301002 |
LISINOPRIL |
5.23 |
10351.477283 |
102601010301 |
102601010301003 |
LISINOPRIL |
5.23 |
10351.477283 |
102601010301 |
102601010301004 |
LISINOPRIL |
5.23 |
10351.477283 |
102601010301 |
102601010301005 |
LISINOPRIL |
5.23 |
10351.477283 |
102601010301 |
102601010301006 |
LISINOPRIL |
5.23 |
10351.477283 |
102601010311 |
102601010311001 |
AMLODIPINE |
11.00 |
10351.477283 |
102601010311 |
102601010311002 |
AMLODIPINE |
11.00 |
10351.477283 |
102601010311 |
102601010311003 |
AMLODIPINE |
11.00 |
10351.477283 |
102601010311 |
102601010311004 |
AMLODIPINE |
11.00 |
10351.477283 |
102601010311 |
102601010311005 |
AMLODIPINE |
10.00 |
10351.477283 |
102601010311 |
102601010311006 |
AMLODIPINE |
10.00 |
10351.477283 |
102601010311 |
102601010311007 |
AMLODIPINE |
10.00 |
10351.477283 |
102781020161 |
102781020161001 |
Albuterol |
0.15 |
12143.586784 |
102781020171 |
102781020171001 |
AZITHROMYCIN |
10.00 |
12143.586784 |
102781020181 |
102781020181001 |
METOPROLOL TART |
4.00 |
12143.586784 |
102991060031 |
102991060031001 |
PREDNISOLONE |
13.00 |
7322.175449 |
102991060041 |
102991060041001 |
THERA-M |
6.50 |
7322.175449 |
102991060051 |
102991060051001 |
ED-A-HIST DM |
5.00 |
7322.175449 |
103051020081 |
103051020081001 |
CIPROFLOXACN |
4.00 |
4878.457322 |
103051020091 |
103051020091001 |
Advair Diskus |
197.47 |
4878.457322 |
103051020091 |
103051020091002 |
Advair Diskus |
197.47 |
4878.457322 |
103581010041 |
103581010041001 |
NOVOLIN N |
53.24 |
5132.990088 |
103581010051 |
103581010051001 |
INSULIN SYRG |
24.00 |
5132.990088 |
103581010061 |
103581010061001 |
Albuterol |
21.42 |
5132.990088 |
103581010061 |
103581010061002 |
Albuterol |
21.42 |
5132.990088 |
103581010071 |
103581010071001 |
PROAIR HFA |
37.66 |
5132.990088 |
103581010081 |
103581010081001 |
SIMVASTATIN |
5.00 |
5132.990088 |
103581010091 |
103581010091001 |
LISINOPRIL |
10.00 |
5132.990088 |
103581010621 |
103581010621001 |
SIMVASTATIN |
5.00 |
5132.990088 |
103581010631 |
103581010631001 |
QVAR |
62.93 |
5132.990088 |
103581010631 |
103581010631002 |
QVAR |
62.93 |
5132.990088 |
103581010641 |
103581010641001 |
RELION HUMULIN N U |
25.00 |
5132.990088 |
103581010641 |
103581010641002 |
RELION HUMULIN N U |
25.00 |
5132.990088 |
103581010641 |
103581010641003 |
RELION HUMULIN N U |
25.00 |
5132.990088 |
103581010641 |
103581010641004 |
RELION HUMULIN N U |
25.00 |
5132.990088 |
103581010651 |
103581010651001 |
RELION HUMULIN R U |
25.00 |
5132.990088 |
103581010651 |
103581010651002 |
RELION HUMULIN R U |
25.00 |
5132.990088 |
103581010651 |
103581010651003 |
RELION HUMULIN R U |
25.00 |
5132.990088 |
103581010651 |
103581010651004 |
RELION HUMULIN R U |
25.00 |
5132.990088 |
103581010651 |
103581010651005 |
RELION HUMULIN R U |
25.00 |
5132.990088 |
103581010651 |
103581010651006 |
RELION HUMULIN R U |
25.00 |
5132.990088 |
103921030301 |
103921030301001 |
SINGULAIR |
131.00 |
5614.573780 |
103921030301 |
103921030301002 |
SINGULAIR |
131.00 |
5614.573780 |
103921030301 |
103921030301003 |
SINGULAIR |
131.00 |
5614.573780 |
103921030301 |
103921030301004 |
SINGULAIR |
96.00 |
5614.573780 |
103921030301 |
103921030301005 |
SINGULAIR |
96.00 |
5614.573780 |
103921030301 |
103921030301006 |
SINGULAIR |
96.00 |
5614.573780 |
103921030311 |
103921030311001 |
DEHISTINE |
10.00 |
5614.573780 |
103921030311 |
103921030311002 |
DEHISTINE |
10.00 |
5614.573780 |
103921030311 |
103921030311003 |
DEHISTINE |
10.00 |
5614.573780 |
103921030311 |
103921030311004 |
DEHISTINE |
10.00 |
5614.573780 |
103921030311 |
103921030311005 |
DEHISTINE |
10.00 |
5614.573780 |
103921030311 |
103921030311006 |
DEHISTINE |
10.00 |
5614.573780 |
104011010031 |
104011010031001 |
Albuterol So4 (CFC-F)
Oral |
43.60 |
5825.587735 |
104011010041 |
104011010041001 |
Aspirin |
11.75 |
5825.587735 |
104011010051 |
104011010051001 |
CLONIDINE |
22.03 |
5825.587735 |
104011010061 |
104011010061001 |
PLAVIX |
99.45 |
5825.587735 |
104011010071 |
104011010071001 |
Hydrochlorothiazide |
12.12 |
5825.587735 |
104011010081 |
104011010081001 |
HYDROCODONE |
23.99 |
5825.587735 |
104011010091 |
104011010091001 |
METOPROLOL TART |
14.40 |
5825.587735 |
104011010101 |
104011010101001 |
NITROSTAT |
13.97 |
5825.587735 |
104011010111 |
104011010111001 |
RANITIDINE |
6.47 |
5825.587735 |
104011010121 |
104011010121001 |
Simvastatin |
24.00 |
5825.587735 |
104251010131 |
104251010131001 |
LEVAQUIN |
189.79 |
28225.544125 |
104801010111 |
104801010111001 |
OXAPROZIN |
25.67 |
5272.855579 |
104801010111 |
104801010111002 |
OXAPROZIN |
25.67 |
5272.855579 |
104801010111 |
104801010111003 |
OXAPROZIN |
25.67 |
5272.855579 |
104801010111 |
104801010111004 |
OXAPROZIN |
25.67 |
5272.855579 |
104801010121 |
104801010121001 |
SUSTIVA |
540.77 |
5272.855579 |
104801010121 |
104801010121002 |
SUSTIVA |
540.77 |
5272.855579 |
104801010121 |
104801010121003 |
SUSTIVA |
572.44 |
5272.855579 |
104801010121 |
104801010121004 |
SUSTIVA |
572.44 |
5272.855579 |
104801010131 |
104801010131001 |
LIPITOR |
94.40 |
5272.855579 |
104801010131 |
104801010131002 |
LIPITOR |
94.40 |
5272.855579 |
104801010131 |
104801010131003 |
LIPITOR |
94.40 |
5272.855579 |
104801010131 |
104801010131004 |
LIPITOR |
94.40 |
5272.855579 |
104801010141 |
104801010141001 |
TRUVADA |
1003.89 |
5272.855579 |
104801010141 |
104801010141002 |
TRUVADA |
1003.89 |
5272.855579 |
104801010141 |
104801010141003 |
TRUVADA |
1003.89 |
5272.855579 |
104801010141 |
104801010141004 |
TRUVADA |
1003.89 |
5272.855579 |
104801010151 |
104801010151001 |
MAG OXIDE |
8.00 |
5272.855579 |
104801010151 |
104801010151002 |
MAG OXIDE |
8.00 |
5272.855579 |
104801010151 |
104801010151003 |
MAG OXIDE |
8.00 |
5272.855579 |
104801010151 |
104801010151004 |
MAG OXIDE |
8.00 |
5272.855579 |
104801010161 |
104801010161001 |
SMZ/TMP DS |
10.78 |
5272.855579 |
104801010161 |
104801010161002 |
SMZ/TMP DS |
10.78 |
5272.855579 |
104801010161 |
104801010161003 |
SMZ/TMP DS |
10.78 |
5272.855579 |
104801010161 |
104801010161004 |
SMZ/TMP DS |
5.70 |
5272.855579 |
104801010171 |
104801010171001 |
TRAZODONE |
9.73 |
5272.855579 |
104801010171 |
104801010171002 |
TRAZODONE |
9.73 |
5272.855579 |
104801010171 |
104801010171003 |
TRAZODONE |
9.73 |
5272.855579 |
104801010171 |
104801010171004 |
TRAZODONE |
9.73 |
5272.855579 |
104841010131 |
104841010131001 |
PENICILLN VK |
15.00 |
21302.144846 |
104841010141 |
104841010141001 |
AMOXICILLIN |
4.00 |
21302.144846 |
104841010151 |
104841010151001 |
PREDNISONE |
2.00 |
21302.144846 |
104841010151 |
104841010151002 |
PREDNISONE |
2.00 |
21302.144846 |
104841010151 |
104841010151003 |
PREDNISONE |
2.00 |
21302.144846 |
104841010151 |
104841010151004 |
PREDNISONE |
2.00 |
21302.144846 |
104841010151 |
104841010151005 |
PREDNISONE |
2.00 |
21302.144846 |
104841010151 |
104841010151006 |
PREDNISONE |
2.00 |
21302.144846 |
104841010161 |
104841010161001 |
IBUPROFEN |
4.00 |
21302.144846 |
104911020031 |
104911020031001 |
VENTOLIN HFA |
31.95 |
4101.910391 |
104911020041 |
104911020041001 |
QVAR |
90.35 |
4101.910391 |
105071030021 |
105071030021001 |
VENTOLIN HFA |
32.62 |
9722.976894 |
105071030021 |
105071030021002 |
VENTOLIN HFA |
42.09 |
9722.976894 |
105241020141 |
105241020141001 |
PREDNISONE |
1.23 |
9332.386190 |
105241020141 |
105241020141002 |
PREDNISONE |
1.23 |
9332.386190 |
105241020141 |
105241020141003 |
PREDNISONE |
1.23 |
9332.386190 |
105241020571 |
105241020571001 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020571 |
105241020571002 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020571 |
105241020571003 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020571 |
105241020571004 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020571 |
105241020571005 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020571 |
105241020571006 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020581 |
105241020581001 |
ASMANEX 60 |
115.87 |
9332.386190 |
105241020831 |
105241020831001 |
DIGOXIN |
10.04 |
9332.386190 |
105241020831 |
105241020831002 |
DIGOXIN |
10.04 |
9332.386190 |
105241020841 |
105241020841001 |
LEXAPRO |
81.74 |
9332.386190 |
105241020841 |
105241020841002 |
LEXAPRO |
81.74 |
9332.386190 |
105241020851 |
105241020851001 |
WARFARIN |
21.04 |
9332.386190 |
105241020851 |
105241020851002 |
WARFARIN |
21.04 |
9332.386190 |
105241020861 |
105241020861001 |
KLOR-CON M20 |
18.23 |
9332.386190 |
105241020861 |
105241020861002 |
KLOR-CON M20 |
29.89 |
9332.386190 |
105241020871 |
105241020871001 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020871 |
105241020871002 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020871 |
105241020871003 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020881 |
105241020881001 |
CLONAZEPAM |
2.26 |
9332.386190 |
105241020881 |
105241020881002 |
CLONAZEPAM |
2.26 |
9332.386190 |
105241020881 |
105241020881003 |
CLONAZEPAM |
2.26 |
9332.386190 |
105241020881 |
105241020881004 |
CLONAZEPAM |
2.26 |
9332.386190 |
105241020891 |
105241020891001 |
ASMANEX 60 |
115.87 |
9332.386190 |
105241020891 |
105241020891002 |
ASMANEX 60 |
115.87 |
9332.386190 |
105241020891 |
105241020891003 |
ASMANEX 60 |
120.50 |
9332.386190 |
105241020901 |
105241020901001 |
METOPROLOL |
307.83 |
9332.386190 |
105241020901 |
105241020901002 |
METOPROLOL |
307.83 |
9332.386190 |
105241020911 |
105241020911001 |
FUROSEMIDE |
5.00 |
9332.386190 |
105241020911 |
105241020911002 |
FUROSEMIDE |
5.00 |
9332.386190 |
105241020921 |
105241020921001 |
LISINOPRIL |
10.06 |
9332.386190 |
105241020931 |
105241020931001 |
FLUTICASONE |
54.19 |
9332.386190 |
105241020931 |
105241020931002 |
FLUTICASONE |
54.19 |
9332.386190 |
Return to Top
HC-135I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Analysis Variable: RXXP10X SUM OF PAYMENTS RXSF10X-RXOU10X(IMPUTED)
Return to Top
HC-135I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
Analysis Variable: RXXP10X SUM OF PAYMENTS RXSF10X-RXOU10X(IMPUTED)
Return to Top
NOTE: Copyright (c) 2002-2008 by SAS Institute
Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
NOTE: This session is executing on the W32_VSPRO
platform.
NOTE: SAS initialization used:
real time 1.46 seconds
cpu time 0.14 seconds
NOTE: AUTOEXEC processing beginning; file is
C:\Program Files\SAS92\SASFoundation\9.2\autoexec.sas.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
NOTE: AUTOEXEC processing completed.
1 ods rtf file = 'c:\sampleB.rtf' bodytitle;
NOTE: Writing RTF Body file: c:\sampleB.rtf
2
3 ods noproctitle;
4
5 OPTIONS LS=132 PS=59;
6
7 TITLE1 "HC-135I";
8 TITLE2 "Sample SAS Job for Example B";
9
10 LIBNAME IN "C:\Data";
NOTE: Libref IN was successfully assigned as
follows:
Engine: V9
Physical Name: C:\Data
11
12
**************************************************************************************
13 * Calculate the expenditures for prescribed
medicines associated with asthma.
14
**************************************************************************************;
15 PROC FORMAT;
16 VALUE EVENTYPE
17 1 = "1 MVIS"
18 2 = "2 OPAT"
19 3 = "3 EROM"
20 4 = "4 STAZ"
21 5 = "5 DVIS"
22 6 = "6 OMED"
23 7 = "7 HVIS"
24 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
25 RUN;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
26
27
*--------------------------------------------------------------------------------------
28 * Get condition records coded as asthma.
29
*--------------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H137 (KEEP=CONDIDX CCCODEX);
32 IF CCCODEX="128";
33 RUN;
NOTE: There were 102306 observations read from the
data set IN.H137.
NOTE: The data set WORK.ASCONDS has 2130
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 2.68 seconds
cpu time 0.09 seconds
34
35
*--------------------------------------------------------------------------
36 * Get the events linked to each of the asthma
condition records.
37
*--------------------------------------------------------------------------;
38 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 2130 observations read from the
data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2130
observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
39
40 proc print data=asconds (obs=50);
41 title3 "sample print of work.asconds - sorted by
condidx";
42 title4 "COND (H137) records where cccodex=128";
43 run;
NOTE: There were 50 observations read from the data
set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds
44
45 PROC SORT DATA=IN.H135IF1 OUT=CLNK; BY CONDIDX;
RUN;
NOTE: There were 292498 observations read from the
data set IN.H135IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 292498
observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 3.07 seconds
cpu time 0.20 seconds
46
47 DATA ASCLNKS;
48 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX
EVENTYPE)
49 ASCONDS(IN=INASCOND KEEP=CONDIDX);
50 BY CONDIDX;
51 IF INCLNK & INASCOND;
52 RUN;
NOTE: There were 292498 observations read from the
data set WORK.CLNK.
NOTE: There were 2130 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 6686
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
53
54 proc print data=asclnks (obs=75);
55 by condidx;
56 id condidx;
57 format eventype eventype.;
58 title3 "sample print of work.asclnks - sorted by
condidx";
59 title4 "events linked to asthma condition
records";
60 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 (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
61
62 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 6686 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 6686
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
63
64 proc print data=asclnks (obs=50);
65 format eventype eventype.;
66 title3 "sample print of work.asclnks - sorted by
evntidx";
67 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
68
69 DATA ASCLNKS;
70 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
71 BY EVNTIDX;
72 IF FIRST.EVNTIDX;
73 RUN;
NOTE: There were 6686 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6680
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
74
75 proc print data=asclnks (obs=50);
76 format eventype eventype.;
77 title3 "sample print of unique evntidxs from
work.asclnks";
78 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
79
80
*-------------------------------------------------------------------------------
81 * Get PMED records linked to asthma condition
records.
82
*-------------------------------------------------------------------------------;
83 PROC SORT DATA=IN.H135A OUT=PMED; BY LINKIDX;
RUN;
NOTE: There were 301032 observations read from the
data set IN.H135A.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.PMED has 301032
observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 7.54 seconds
cpu time 0.40 seconds
84
85 DATA ASPMEDS;
86 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP10X
PERWT10F)
87 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX
RENAME=(EVNTIDX=LINKIDX));
88 BY LINKIDX;
89 IF INASCLNK & PERWT10F>0;
90 RUN;
NOTE: There were 301032 observations read from the
data set WORK.PMED.
NOTE: There were 6680 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 10115
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.07 seconds
91
92 proc print data=aspmeds (obs=300);
93 by linkidx;
94 id linkidx;
95 var rxrecidx rxname RXXP10X PERWT10F;
96 title3 "sample print of work.aspmeds";
97 title4 "PMED (HC-135A) records which link to
condition records coded as asthma";
98 run;
NOTE: There were 300 observations read from the
data set WORK.ASPMEDS.
NOTE: The PROCEDURE PRINT printed pages 6-14.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
99
100 PROC MEANS DATA=ASPMEDS N SUM;
101 VAR RXXP10X;
102 TITLE3 "Total Rx expenditures associated with
asthma";
103 RUN;
NOTE: Multiple concurrent threads will be used to
summarize data.
NOTE: There were 10115 observations read from the
data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 15.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
104
105 PROC MEANS DATA=ASPMEDS N SUM;
106 VAR RXXP10X;
107 WEIGHT PERWT10F;
108 TITLE3 "Total Rx expenditures associated with
asthma";
109 TITLE5 "Weighted";
110 RUN;
NOTE: Multiple concurrent threads will be used to
summarize data.
NOTE: There were 10115 observations read from the
data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 16.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
111
112 ods rtf close;
113
NOTE: SAS Institute Inc., SAS Campus Drive, Cary,
NC USA 27513-2414
NOTE: The SAS System used:
real time 16.67 seconds
cpu time 1.26 seconds
Return to Top
HC-135I. Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H137) records where cccodex=128
Obs |
CONDIDX |
CCCODEX |
1 |
100121010051 |
128 |
2 |
100171010021 |
128 |
3 |
100431010021 |
128 |
4 |
100431030011 |
128 |
5 |
100431040011 |
128 |
6 |
100441010031 |
128 |
7 |
100531020041 |
128 |
8 |
100531040011 |
128 |
9 |
100661010021 |
128 |
10 |
100671010071 |
128 |
11 |
100671020041 |
128 |
12 |
100861020041 |
128 |
13 |
101311020041 |
128 |
14 |
101371010051 |
128 |
15 |
101541020041 |
128 |
16 |
101831050011 |
128 |
17 |
101841020091 |
128 |
18 |
101981020061 |
128 |
19 |
101981030051 |
128 |
20 |
101981040031 |
128 |
21 |
101981050011 |
128 |
22 |
102061010011 |
128 |
23 |
102061040011 |
128 |
24 |
102291020011 |
128 |
25 |
102361030011 |
128 |
26 |
102361040011 |
128 |
27 |
102421010041 |
128 |
28 |
102442010032 |
128 |
29 |
102451010021 |
128 |
30 |
102451030011 |
128 |
31 |
102531020011 |
128 |
32 |
102591050011 |
128 |
33 |
102601010071 |
128 |
34 |
102691010111 |
128 |
35 |
102691020091 |
128 |
36 |
102692030012 |
128 |
37 |
102781020031 |
128 |
38 |
102891010051 |
128 |
39 |
102891020021 |
128 |
40 |
102991060011 |
128 |
41 |
103051020011 |
128 |
42 |
103101010031 |
128 |
43 |
103131010111 |
128 |
44 |
103311010051 |
128 |
45 |
103331010021 |
128 |
46 |
103371010011 |
128 |
47 |
103581010041 |
128 |
48 |
103691010021 |
128 |
49 |
103851030011 |
128 |
50 |
103851040011 |
128 |
Return to Top
HC-135I. Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
100121010051 |
100121010051 |
8 PMED |
100121010051 |
100121010111 |
8 PMED |
100121010051 |
100121010151 |
8 PMED |
100171010021 |
100171010091 |
8 PMED |
100171010021 |
100171010161 |
8 PMED |
100171010021 |
100171010181 |
1 MVIS |
100431010021 |
100431010121 |
8 PMED |
100431030011 |
100431030011 |
1 MVIS |
100431030011 |
100431030021 |
8 PMED |
100431030011 |
100431030031 |
8 PMED |
100431030011 |
100431030051 |
8 PMED |
100431030011 |
100431030071 |
1 MVIS |
100431030011 |
100431030091 |
8 PMED |
100431030011 |
100431030101 |
8 PMED |
100431030011 |
100431030111 |
8 PMED |
100431030011 |
100431030121 |
8 PMED |
100431030011 |
100431030171 |
8 PMED |
100431040011 |
100431040011 |
1 MVIS |
100431040011 |
100431040021 |
1 MVIS |
100431040011 |
100431040031 |
8 PMED |
100431040011 |
100431040041 |
8 PMED |
100431040011 |
100431040051 |
8 PMED |
100431040011 |
100431040061 |
8 PMED |
100431040011 |
100431040071 |
8 PMED |
100431040011 |
100431040081 |
8 PMED |
100431040011 |
100431040091 |
1 MVIS |
100431040011 |
100431040101 |
1 MVIS |
100431040011 |
100431040111 |
1 MVIS |
100431040011 |
100431040131 |
8 PMED |
100431040011 |
100431040141 |
8 PMED |
100431040011 |
100431040151 |
8 PMED |
100431040011 |
100431040161 |
8 PMED |
100431040011 |
100431040171 |
1 MVIS |
100431040011 |
100431040201 |
1 MVIS |
100431040011 |
100431040211 |
1 MVIS |
100431040011 |
100431040231 |
8 PMED |
100431040011 |
100431040241 |
8 PMED |
100431040011 |
100431040251 |
8 PMED |
100431040011 |
100431040271 |
8 PMED |
100441010031 |
100441010031 |
2 OPAT |
100441010031 |
100441010091 |
8 PMED |
100441010031 |
100441010101 |
8 PMED |
100441010031 |
100441010111 |
8 PMED |
100531020041 |
100531020361 |
8 PMED |
100531040011 |
100531040021 |
8 PMED |
100661010021 |
100661010021 |
8 PMED |
100661010021 |
100661010041 |
8 PMED |
100671010071 |
100671010171 |
8 PMED |
100671010071 |
100671010181 |
8 PMED |
100671010071 |
100671010191 |
8 PMED |
100671010071 |
100671010401 |
8 PMED |
100671010071 |
100671010411 |
8 PMED |
100671010071 |
100671010421 |
8 PMED |
100671010071 |
100671010511 |
8 PMED |
100671010071 |
100671010521 |
8 PMED |
100671010071 |
100671010531 |
8 PMED |
100671020041 |
100671020371 |
8 PMED |
100671020041 |
100671020411 |
8 PMED |
100861020041 |
100861020011 |
1 MVIS |
100861020041 |
100861020031 |
8 PMED |
100861020041 |
100861020091 |
8 PMED |
100861020041 |
100861020101 |
8 PMED |
100861020041 |
100861020111 |
1 MVIS |
100861020041 |
100861020141 |
8 PMED |
100861020041 |
100861020151 |
8 PMED |
101371010051 |
101371010261 |
1 MVIS |
101371010051 |
101371010341 |
8 PMED |
101371010051 |
101371010381 |
8 PMED |
101541020041 |
101541020011 |
1 MVIS |
101841020091 |
101841020381 |
8 PMED |
101841020091 |
101841020401 |
2 OPAT |
102061010011 |
102061010071 |
8 PMED |
102061040011 |
102061040011 |
1 MVIS |
102061040011 |
102061040021 |
1 MVIS |
102061040011 |
102061040031 |
3 EROM |
Return to Top
HC-135I. Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
100121010051 |
100121010051 |
8 PMED |
2 |
100121010051 |
100121010111 |
8 PMED |
3 |
100121010051 |
100121010151 |
8 PMED |
4 |
100171010021 |
100171010091 |
8 PMED |
5 |
100171010021 |
100171010161 |
8 PMED |
6 |
100171010021 |
100171010181 |
1 MVIS |
7 |
100431010021 |
100431010121 |
8 PMED |
8 |
100431030011 |
100431030011 |
1 MVIS |
9 |
100431030011 |
100431030021 |
8 PMED |
10 |
100431030011 |
100431030031 |
8 PMED |
11 |
100431030011 |
100431030051 |
8 PMED |
12 |
100431030011 |
100431030071 |
1 MVIS |
13 |
100431030011 |
100431030091 |
8 PMED |
14 |
100431030011 |
100431030101 |
8 PMED |
15 |
100431030011 |
100431030111 |
8 PMED |
16 |
100431030011 |
100431030121 |
8 PMED |
17 |
100431030011 |
100431030171 |
8 PMED |
18 |
100431040011 |
100431040011 |
1 MVIS |
19 |
100431040011 |
100431040021 |
1 MVIS |
20 |
100431040011 |
100431040031 |
8 PMED |
21 |
100431040011 |
100431040041 |
8 PMED |
22 |
100431040011 |
100431040051 |
8 PMED |
23 |
100431040011 |
100431040061 |
8 PMED |
24 |
100431040011 |
100431040071 |
8 PMED |
25 |
100431040011 |
100431040081 |
8 PMED |
26 |
100431040011 |
100431040091 |
1 MVIS |
27 |
100431040011 |
100431040101 |
1 MVIS |
28 |
100431040011 |
100431040111 |
1 MVIS |
29 |
100431040011 |
100431040131 |
8 PMED |
30 |
100431040011 |
100431040141 |
8 PMED |
31 |
100431040011 |
100431040151 |
8 PMED |
32 |
100431040011 |
100431040161 |
8 PMED |
33 |
100431040011 |
100431040171 |
1 MVIS |
34 |
100431040011 |
100431040201 |
1 MVIS |
35 |
100431040011 |
100431040211 |
1 MVIS |
36 |
100431040011 |
100431040231 |
8 PMED |
37 |
100431040011 |
100431040241 |
8 PMED |
38 |
100431040011 |
100431040251 |
8 PMED |
39 |
100431040011 |
100431040271 |
8 PMED |
40 |
100441010031 |
100441010031 |
2 OPAT |
41 |
100441010031 |
100441010091 |
8 PMED |
42 |
100441010031 |
100441010101 |
8 PMED |
43 |
100441010031 |
100441010111 |
8 PMED |
44 |
100531020041 |
100531020361 |
8 PMED |
45 |
100531040011 |
100531040021 |
8 PMED |
46 |
100661010021 |
100661010021 |
8 PMED |
47 |
100661010021 |
100661010041 |
8 PMED |
48 |
100671010071 |
100671010171 |
8 PMED |
49 |
100671010071 |
100671010181 |
8 PMED |
50 |
100671010071 |
100671010191 |
8 PMED |
Return to Top
HC-135I. Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
100121010051 |
8 PMED |
2 |
100121010111 |
8 PMED |
3 |
100121010151 |
8 PMED |
4 |
100171010091 |
8 PMED |
5 |
100171010161 |
8 PMED |
6 |
100171010181 |
1 MVIS |
7 |
100431010121 |
8 PMED |
8 |
100431030011 |
1 MVIS |
9 |
100431030021 |
8 PMED |
10 |
100431030031 |
8 PMED |
11 |
100431030051 |
8 PMED |
12 |
100431030071 |
1 MVIS |
13 |
100431030091 |
8 PMED |
14 |
100431030101 |
8 PMED |
15 |
100431030111 |
8 PMED |
16 |
100431030121 |
8 PMED |
17 |
100431030171 |
8 PMED |
18 |
100431040011 |
1 MVIS |
19 |
100431040021 |
1 MVIS |
20 |
100431040031 |
8 PMED |
21 |
100431040041 |
8 PMED |
22 |
100431040051 |
8 PMED |
23 |
100431040061 |
8 PMED |
24 |
100431040071 |
8 PMED |
25 |
100431040081 |
8 PMED |
26 |
100431040091 |
1 MVIS |
27 |
100431040101 |
1 MVIS |
28 |
100431040111 |
1 MVIS |
29 |
100431040131 |
8 PMED |
30 |
100431040141 |
8 PMED |
31 |
100431040151 |
8 PMED |
32 |
100431040161 |
8 PMED |
33 |
100431040171 |
1 MVIS |
34 |
100431040201 |
1 MVIS |
35 |
100431040211 |
1 MVIS |
36 |
100431040231 |
8 PMED |
37 |
100431040241 |
8 PMED |
38 |
100431040251 |
8 PMED |
39 |
100431040271 |
8 PMED |
40 |
100441010031 |
2 OPAT |
41 |
100441010091 |
8 PMED |
42 |
100441010101 |
8 PMED |
43 |
100441010111 |
8 PMED |
44 |
100531020361 |
8 PMED |
45 |
100531040021 |
8 PMED |
46 |
100661010021 |
8 PMED |
47 |
100661010041 |
8 PMED |
48 |
100671010171 |
8 PMED |
49 |
100671010181 |
8 PMED |
50 |
100671010191 |
8 PMED |
Return to Top
HC-135I. Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-135A) records which link to condition records coded as asthma
LINKIDX |
RXRECIDX |
RXNAME |
RXXP10X |
PERWT10F |
100121010051 |
100121010051001 |
COMBIVENT |
137.84 |
18100.455246 |
100121010111 |
100121010111001 |
COMBIVENT |
137.84 |
18100.455246 |
100121010151 |
100121010151001 |
ALBUTEROL/ IPRATROP |
60.00 |
18100.455246 |
100121010151 |
100121010151002 |
ALBUTEROL/ IPRATROP |
60.00 |
18100.455246 |
100171010091 |
100171010091001 |
ADVAIR DISKU |
255.87 |
8879.035173 |
100171010161 |
100171010161001 |
ADVAIR DISKU |
223.84 |
8879.035173 |
100171010161 |
100171010161002 |
ADVAIR DISKU |
222.14 |
8879.035173 |
100171010161 |
100171010161003 |
ADVAIR DISKU |
222.14 |
8879.035173 |
100171010161 |
100171010161004 |
ADVAIR DISKU |
222.14 |
8879.035173 |
100171010161 |
100171010161005 |
ADVAIR DISKU |
222.14 |
8879.035173 |
100171010161 |
100171010161006 |
ADVAIR DISKU |
222.14 |
8879.035173 |
100431010121 |
100431010121001 |
ADVAIR DISKU |
168.35 |
17348.405237 |
100431030021 |
100431030021001 |
AZITHROMYCIN |
26.76 |
13273.138854 |
100431030031 |
100431030031001 |
PREDNISOLONE |
9.69 |
13273.138854 |
100431030051 |
100431030051001 |
Proventil |
63.16 |
13273.138854 |
100431030091 |
100431030091001 |
ADVAIR DISKU |
168.85 |
13273.138854 |
100431030091 |
100431030091002 |
ADVAIR DISKU |
168.85 |
13273.138854 |
100431030101 |
100431030101001 |
AZITHROMYCIN |
30.82 |
13273.138854 |
100431030101 |
100431030101002 |
AZITHROMYCIN |
62.41 |
13273.138854 |
100431030111 |
100431030111001 |
SINGULAIR |
103.31 |
13273.138854 |
100431030121 |
100431030121001 |
PREDNISONE |
3.17 |
13273.138854 |
100431030171 |
100431030171001 |
SINGULAIR |
127.60 |
13273.138854 |
100431040031 |
100431040031001 |
AZITHROMYCIN |
26.76 |
24678.499660 |
100431040031 |
100431040031002 |
AZITHROMYCIN |
26.76 |
24678.499660 |
100431040041 |
100431040041001 |
PREDNISONE |
2.57 |
24678.499660 |
100431040051 |
100431040051001 |
ALBUTEROL |
28.59 |
24678.499660 |
100431040061 |
100431040061001 |
SINGULAIR |
116.26 |
24678.499660 |
100431040071 |
100431040071001 |
ADVAIR HFA |
209.80 |
24678.499660 |
100431040081 |
100431040081001 |
PREDNISOLONE |
8.59 |
24678.499660 |
100431040081 |
100431040081002 |
PREDNISOLONE |
7.49 |
24678.499660 |
100431040131 |
100431040131001 |
ALBUTEROL |
45.19 |
24678.499660 |
100431040131 |
100431040131002 |
ALBUTEROL |
45.19 |
24678.499660 |
100431040141 |
100431040141001 |
PREDNISOLONE |
8.70 |
24678.499660 |
100431040141 |
100431040141002 |
PREDNISOLONE |
5.36 |
24678.499660 |
100431040151 |
100431040151001 |
AZITHROMYCIN |
30.82 |
24678.499660 |
100431040161 |
100431040161001 |
CEFPROZIL |
42.26 |
24678.499660 |
100431040231 |
100431040231001 |
SILDEC PE-DM |
8.50 |
24678.499660 |
100431040241 |
100431040241001 |
PREDNISOLONE |
5.11 |
24678.499660 |
100431040241 |
100431040241002 |
PREDNISOLONE |
5.11 |
24678.499660 |
100431040241 |
100431040241003 |
PREDNISOLONE |
5.11 |
24678.499660 |
100431040241 |
100431040241004 |
PREDNISOLONE |
5.11 |
24678.499660 |
100431040251 |
100431040251001 |
PREDNISONE |
2.57 |
24678.499660 |
100431040251 |
100431040251002 |
PREDNISONE |
2.53 |
24678.499660 |
100431040271 |
100431040271001 |
XOPENEX HFA |
51.28 |
24678.499660 |
100441010091 |
100441010091001 |
Nebulizer MCD |
122.50 |
2595.895845 |
100441010101 |
100441010101001 |
VENTOLIN HFA |
36.75 |
2595.895845 |
100441010111 |
100441010111001 |
symbicort |
198.90 |
2595.895845 |
100531020361 |
100531020361001 |
VENTOLIN HFA |
26.21 |
2606.397192 |
100531020361 |
100531020361002 |
VENTOLIN HFA |
26.21 |
2606.397192 |
100531020361 |
100531020361003 |
VENTOLIN HFA |
26.21 |
2606.397192 |
100531020361 |
100531020361004 |
VENTOLIN HFA |
26.21 |
2606.397192 |
100531040021 |
100531040021001 |
VENTOLIN HFA |
26.21 |
2386.032526 |
100531040021 |
100531040021002 |
VENTOLIN HFA |
26.21 |
2386.032526 |
100661010021 |
100661010021001 |
PROAIR HFA |
43.27 |
5887.992178 |
100661010021 |
100661010021002 |
PROAIR HFA |
43.27 |
5887.992178 |
100661010021 |
100661010021003 |
PROAIR HFA |
43.27 |
5887.992178 |
100661010021 |
100661010021004 |
PROAIR HFA |
43.27 |
5887.992178 |
100661010021 |
100661010021005 |
PROAIR HFA |
43.27 |
5887.992178 |
100661010041 |
100661010041001 |
PROAIR HFA |
43.27 |
5887.992178 |
100661010041 |
100661010041002 |
PROAIR HFA |
43.27 |
5887.992178 |
100661010041 |
100661010041003 |
PROAIR HFA |
43.27 |
5887.992178 |
100661010041 |
100661010041004 |
PROAIR HFA |
43.27 |
5887.992178 |
100661010041 |
100661010041005 |
PROAIR HFA |
43.27 |
5887.992178 |
100661010041 |
100661010041006 |
PROAIR HFA |
43.27 |
5887.992178 |
100671010171 |
100671010171001 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010171 |
100671010171002 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010181 |
100671010181001 |
BUDESONIDE |
338.72 |
24396.424175 |
100671010181 |
100671010181002 |
BUDESONIDE |
338.72 |
24396.424175 |
100671010191 |
100671010191001 |
ALBUTEROL |
180.38 |
24396.424175 |
100671010191 |
100671010191002 |
ALBUTEROL |
33.30 |
24396.424175 |
100671010401 |
100671010401001 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010401 |
100671010401002 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010401 |
100671010401003 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010401 |
100671010401004 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010401 |
100671010401005 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010401 |
100671010401006 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010401 |
100671010401007 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010401 |
100671010401008 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010411 |
100671010411001 |
BUDESONIDE |
361.99 |
24396.424175 |
100671010411 |
100671010411002 |
BUDESONIDE |
361.99 |
24396.424175 |
100671010411 |
100671010411003 |
BUDESONIDE |
361.99 |
24396.424175 |
100671010411 |
100671010411004 |
BUDESONIDE |
361.99 |
24396.424175 |
100671010411 |
100671010411005 |
BUDESONIDE |
361.99 |
24396.424175 |
100671010411 |
100671010411006 |
BUDESONIDE |
361.99 |
24396.424175 |
100671010411 |
100671010411007 |
BUDESONIDE |
361.99 |
24396.424175 |
100671010411 |
100671010411008 |
BUDESONIDE |
361.99 |
24396.424175 |
100671010421 |
100671010421001 |
FORADIL |
152.29 |
24396.424175 |
100671010421 |
100671010421002 |
FORADIL |
152.29 |
24396.424175 |
100671010421 |
100671010421003 |
FORADIL |
152.29 |
24396.424175 |
100671010421 |
100671010421004 |
FORADIL |
152.29 |
24396.424175 |
100671010421 |
100671010421005 |
FORADIL |
152.29 |
24396.424175 |
100671010421 |
100671010421006 |
FORADIL |
152.29 |
24396.424175 |
100671010421 |
100671010421007 |
FORADIL |
152.29 |
24396.424175 |
100671010421 |
100671010421008 |
FORADIL |
152.29 |
24396.424175 |
100671010511 |
100671010511001 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010511 |
100671010511002 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010511 |
100671010511003 |
SEREVENT DIS |
153.48 |
24396.424175 |
100671010521 |
100671010521001 |
BUDESONIDE |
361.99 |
24396.424175 |
100671010521 |
100671010521002 |
BUDESONIDE |
361.99 |
24396.424175 |
100671010521 |
100671010521003 |
BUDESONIDE |
361.99 |
24396.424175 |
100671010531 |
100671010531001 |
FORADIL |
152.29 |
24396.424175 |
100671010531 |
100671010531002 |
FORADIL |
152.29 |
24396.424175 |
100671010531 |
100671010531003 |
FORADIL |
152.29 |
24396.424175 |
100671020371 |
100671020371001 |
Albuterol HFA Inhaler |
3.95 |
22773.498225 |
100671020371 |
100671020371002 |
Albuterol HFA Inhaler |
3.95 |
22773.498225 |
100671020371 |
100671020371003 |
Albuterol HFA Inhaler |
3.95 |
22773.498225 |
100671020411 |
100671020411001 |
SYMBICORT |
198.38 |
22773.498225 |
100671020411 |
100671020411002 |
SYMBICORT |
198.38 |
22773.498225 |
100671020411 |
100671020411003 |
SYMBICORT |
198.38 |
22773.498225 |
100861020031 |
100861020031001 |
SINGULAIR |
118.20 |
4351.170836 |
100861020091 |
100861020091001 |
PROAIR HFA |
38.28 |
4351.170836 |
100861020101 |
100861020101001 |
ADVAIR DISKU |
281.37 |
4351.170836 |
100861020141 |
100861020141001 |
LORATADINE |
5.68 |
4351.170836 |
100861020151 |
100861020151001 |
SINGULAIR |
131.20 |
4351.170836 |
101371010341 |
101371010341001 |
PREDNISONE |
12.02 |
3246.386814 |
101371010381 |
101371010381001 |
ALBUTEROL |
4.34 |
3246.386814 |
101841020381 |
101841020381001 |
VENTOLIN HFA |
32.07 |
2967.805342 |
102061010071 |
102061010071001 |
Advair Diskus |
283.51 |
8819.829268 |
102061040041 |
102061040041001 |
Albuterol |
0.22 |
9038.830355 |
102291020041 |
102291020041001 |
Albuterol |
6.63 |
10983.991425 |
102291020091 |
102291020091001 |
Proventil HFA |
43.16 |
10983.991425 |
102421010061 |
102421010061001 |
THEOPHYLLINE |
9.06 |
2961.197824 |
102421010061 |
102421010061002 |
THEOPHYLLINE |
9.06 |
2961.197824 |
102421010231 |
102421010231001 |
COMBIVENT |
121.70 |
2961.197824 |
102421010271 |
102421010271001 |
Advair Diskus |
283.51 |
2961.197824 |
102451010031 |
102451010031001 |
PROAIR HFA |
37.18 |
16538.634650 |
102451010031 |
102451010031002 |
PROAIR HFA |
37.11 |
16538.634650 |
102451010041 |
102451010041001 |
SINGULAIR |
116.33 |
16538.634650 |
102451010041 |
102451010041002 |
SINGULAIR |
124.02 |
16538.634650 |
102451010041 |
102451010041003 |
SINGULAIR |
122.55 |
16538.634650 |
102451010061 |
102451010061001 |
PROAIR HFA |
38.72 |
16538.634650 |
102451010071 |
102451010071001 |
SINGULAIR |
328.81 |
16538.634650 |
102451010101 |
102451010101001 |
PROAIR HFA |
39.17 |
16538.634650 |
102451010101 |
102451010101002 |
PROAIR HFA |
38.72 |
16538.634650 |
102451010111 |
102451010111001 |
SINGULAIR |
281.96 |
16538.634650 |
102451030081 |
102451030081001 |
VENTOLIN HFA |
34.76 |
18569.059372 |
102451030181 |
102451030181001 |
VENTOLIN HFA |
34.76 |
18569.059372 |
102591050021 |
102591050021001 |
Proventil HFA |
43.16 |
6529.909545 |
102591050021 |
102591050021002 |
Proventil HFA |
43.16 |
6529.909545 |
102781020131 |
102781020131001 |
SYMBICORT |
196.79 |
12143.586784 |
102781020131 |
102781020131002 |
SYMBICORT |
196.79 |
12143.586784 |
102781020131 |
102781020131003 |
SYMBICORT |
196.79 |
12143.586784 |
102781020161 |
102781020161001 |
Albuterol |
0.15 |
12143.586784 |
102781020171 |
102781020171001 |
AZITHROMYCIN |
10.00 |
12143.586784 |
102781020181 |
102781020181001 |
METOPROLOL TART |
4.00 |
12143.586784 |
102991060031 |
102991060031001 |
PREDNISOLONE |
13.00 |
7322.175449 |
102991060041 |
102991060041001 |
THERA-M |
6.50 |
7322.175449 |
102991060051 |
102991060051001 |
ED-A-HIST DM |
5.00 |
7322.175449 |
102991060071 |
102991060071001 |
PREDNISONE |
11.99 |
7322.175449 |
102991060081 |
102991060081001 |
DEX-TUSS |
15.00 |
7322.175449 |
103051020091 |
103051020091001 |
Advair Diskus |
197.47 |
4878.457322 |
103051020091 |
103051020091002 |
Advair Diskus |
197.47 |
4878.457322 |
103101010201 |
103101010201001 |
Albuterol Sulfate |
19.45 |
8742.529512 |
103101010201 |
103101010201002 |
Albuterol Sulfate |
19.45 |
8742.529512 |
103101010201 |
103101010201003 |
Albuterol Sulfate |
19.45 |
8742.529512 |
103101010201 |
103101010201004 |
Albuterol Sulfate |
19.45 |
8742.529512 |
103101010201 |
103101010201005 |
Albuterol Sulfate |
19.45 |
8742.529512 |
103101010201 |
103101010201006 |
Albuterol Sulfate |
19.45 |
8742.529512 |
103101010201 |
103101010201007 |
Albuterol Sulfate |
19.45 |
8742.529512 |
103101010201 |
103101010201008 |
Albuterol Sulfate |
19.45 |
8742.529512 |
103101010281 |
103101010281001 |
Mometasone Furoate |
29.08 |
8742.529512 |
103101010281 |
103101010281002 |
Mometasone Furoate |
46.76 |
8742.529512 |
103311010051 |
103311010051001 |
PREDNISONE |
8.80 |
5457.718057 |
103331010011 |
103331010011001 |
ADVAIR DISKU |
169.00 |
10257.343898 |
103331010031 |
103331010031001 |
ADVAIR DISKU |
169.00 |
10257.343898 |
103371010211 |
103371010211001 |
ADVAIR DISKU |
60.00 |
5401.221154 |
103371010211 |
103371010211002 |
ADVAIR DISKU |
60.00 |
5401.221154 |
103371010211 |
103371010211003 |
ADVAIR DISKU |
60.00 |
5401.221154 |
103371010211 |
103371010211004 |
ADVAIR DISKU |
144.00 |
5401.221154 |
103371010211 |
103371010211005 |
ADVAIR DISKU |
144.00 |
5401.221154 |
103371010211 |
103371010211006 |
ADVAIR DISKU |
144.00 |
5401.221154 |
103371010211 |
103371010211007 |
ADVAIR DISKU |
144.00 |
5401.221154 |
103371010331 |
103371010331001 |
ADVAIR DISKU |
144.00 |
5401.221154 |
103371010331 |
103371010331002 |
ADVAIR DISKU |
144.00 |
5401.221154 |
103371010331 |
103371010331003 |
ADVAIR DISKU |
144.00 |
5401.221154 |
103371010331 |
103371010331004 |
ADVAIR DISKU |
144.00 |
5401.221154 |
103581010061 |
103581010061001 |
Albuterol |
21.42 |
5132.990088 |
103581010061 |
103581010061002 |
Albuterol |
21.42 |
5132.990088 |
103581010071 |
103581010071001 |
PROAIR HFA |
37.66 |
5132.990088 |
103581010291 |
103581010291001 |
Albuterol |
1.19 |
5132.990088 |
103581010291 |
103581010291002 |
Albuterol |
1.19 |
5132.990088 |
103581010291 |
103581010291003 |
Albuterol |
1.19 |
5132.990088 |
103581010291 |
103581010291004 |
Albuterol |
1.19 |
5132.990088 |
103581010291 |
103581010291005 |
Albuterol |
1.19 |
5132.990088 |
103581010291 |
103581010291006 |
Albuterol |
1.19 |
5132.990088 |
103581010301 |
103581010301001 |
PROAIR HFA |
37.66 |
5132.990088 |
103581010301 |
103581010301002 |
PROAIR HFA |
37.66 |
5132.990088 |
103581010301 |
103581010301003 |
PROAIR HFA |
37.66 |
5132.990088 |
103581010301 |
103581010301004 |
PROAIR HFA |
37.66 |
5132.990088 |
103581010301 |
103581010301005 |
PROAIR HFA |
37.66 |
5132.990088 |
103581010301 |
103581010301006 |
PROAIR HFA |
37.66 |
5132.990088 |
103581010631 |
103581010631001 |
QVAR |
62.93 |
5132.990088 |
103581010631 |
103581010631002 |
QVAR |
62.93 |
5132.990088 |
103581010661 |
103581010661001 |
Albuterol |
21.42 |
5132.990088 |
103581010661 |
103581010661002 |
Albuterol |
21.42 |
5132.990088 |
103581010661 |
103581010661003 |
Albuterol |
21.42 |
5132.990088 |
103581010661 |
103581010661004 |
Albuterol |
21.42 |
5132.990088 |
103861010251 |
103861010251001 |
ALLEGRA |
62.28 |
11629.199486 |
103861010251 |
103861010251002 |
ALLEGRA |
62.28 |
11629.199486 |
103861010251 |
103861010251003 |
ALLEGRA |
62.28 |
11629.199486 |
103861010251 |
103861010251004 |
ALLEGRA |
62.28 |
11629.199486 |
103921030301 |
103921030301001 |
SINGULAIR |
131.00 |
5614.573780 |
103921030301 |
103921030301002 |
SINGULAIR |
131.00 |
5614.573780 |
103921030301 |
103921030301003 |
SINGULAIR |
131.00 |
5614.573780 |
103921030301 |
103921030301004 |
SINGULAIR |
96.00 |
5614.573780 |
103921030301 |
103921030301005 |
SINGULAIR |
96.00 |
5614.573780 |
103921030301 |
103921030301006 |
SINGULAIR |
96.00 |
5614.573780 |
103921030311 |
103921030311001 |
DEHISTINE |
10.00 |
5614.573780 |
103921030311 |
103921030311002 |
DEHISTINE |
10.00 |
5614.573780 |
103921030311 |
103921030311003 |
DEHISTINE |
10.00 |
5614.573780 |
103921030311 |
103921030311004 |
DEHISTINE |
10.00 |
5614.573780 |
103921030311 |
103921030311005 |
DEHISTINE |
10.00 |
5614.573780 |
103921030311 |
103921030311006 |
DEHISTINE |
10.00 |
5614.573780 |
104011010031 |
104011010031001 |
Albuterol So4 (CFC-F)
Oral |
43.60 |
5825.587735 |
104011010151 |
104011010151001 |
Albuterol So4 (CFC-F)
Oral |
43.60 |
5825.587735 |
104011010151 |
104011010151002 |
Albuterol So4 (CFC-F)
Oral |
43.60 |
5825.587735 |
104011010151 |
104011010151003 |
Albuterol So4 (CFC-F)
Oral |
43.60 |
5825.587735 |
104011010251 |
104011010251001 |
Albuterol So4 (CFC-F)
Oral |
43.60 |
5825.587735 |
104011010251 |
104011010251002 |
Albuterol So4 (CFC-F)
Oral |
43.60 |
5825.587735 |
104011010251 |
104011010251003 |
Albuterol So4 (CFC-F)
Oral |
43.60 |
5825.587735 |
104011010251 |
104011010251004 |
Albuterol So4 (CFC-F)
Oral |
43.60 |
5825.587735 |
104251010111 |
104251010111001 |
PREDNISONE |
4.00 |
28225.544125 |
104251010111 |
104251010111002 |
PREDNISONE |
4.27 |
28225.544125 |
104251010121 |
104251010121001 |
ALBUTEROL |
47.79 |
28225.544125 |
104251010121 |
104251010121002 |
ALBUTEROL |
47.79 |
28225.544125 |
104251010121 |
104251010121003 |
ALBUTEROL |
47.79 |
28225.544125 |
104251010121 |
104251010121004 |
ALBUTEROL |
47.79 |
28225.544125 |
104251010131 |
104251010131001 |
LEVAQUIN |
189.79 |
28225.544125 |
104511010021 |
104511010021001 |
Advair Diskus |
197.47 |
16835.579968 |
104511010111 |
104511010111001 |
Advair Diskus |
283.51 |
16835.579968 |
104511010111 |
104511010111002 |
Advair Diskus |
283.51 |
16835.579968 |
104511010191 |
104511010191001 |
Advair Diskus |
283.51 |
16835.579968 |
104511010191 |
104511010191002 |
Advair Diskus |
283.51 |
16835.579968 |
104511010191 |
104511010191003 |
Advair Diskus |
283.51 |
16835.579968 |
104511010191 |
104511010191004 |
Advair Diskus |
283.51 |
16835.579968 |
104601040031 |
104601040031001 |
Albuterol HFA |
1.27 |
9565.906815 |
104601050331 |
104601050331001 |
FLUCONAZOLE |
8.00 |
15974.771412 |
104841010051 |
104841010051001 |
SYMBICORT |
196.00 |
21302.144846 |
104841010051 |
104841010051002 |
SYMBICORT |
196.00 |
21302.144846 |
104841010051 |
104841010051003 |
SYMBICORT |
196.00 |
21302.144846 |
104841010061 |
104841010061001 |
PROAIR HFA |
38.00 |
21302.144846 |
104841010061 |
104841010061002 |
PROAIR HFA |
38.00 |
21302.144846 |
104841010061 |
104841010061003 |
PROAIR HFA |
38.00 |
21302.144846 |
104841010071 |
104841010071001 |
SINGULAIR |
125.00 |
21302.144846 |
104841010071 |
104841010071002 |
SINGULAIR |
125.00 |
21302.144846 |
104841010071 |
104841010071003 |
SINGULAIR |
130.00 |
21302.144846 |
104841010151 |
104841010151001 |
PREDNISONE |
2.00 |
21302.144846 |
104841010151 |
104841010151002 |
PREDNISONE |
2.00 |
21302.144846 |
104841010151 |
104841010151003 |
PREDNISONE |
2.00 |
21302.144846 |
104841010151 |
104841010151004 |
PREDNISONE |
2.00 |
21302.144846 |
104841010151 |
104841010151005 |
PREDNISONE |
2.00 |
21302.144846 |
104841010151 |
104841010151006 |
PREDNISONE |
2.00 |
21302.144846 |
104841010191 |
104841010191001 |
SYMBICORT |
196.00 |
21302.144846 |
104841010191 |
104841010191002 |
SYMBICORT |
196.00 |
21302.144846 |
104841010191 |
104841010191003 |
SYMBICORT |
196.00 |
21302.144846 |
104841010191 |
104841010191004 |
SYMBICORT |
196.00 |
21302.144846 |
104841010191 |
104841010191005 |
SYMBICORT |
196.00 |
21302.144846 |
104841010191 |
104841010191006 |
SYMBICORT |
196.00 |
21302.144846 |
104841010201 |
104841010201001 |
PROAIR HFA |
38.00 |
21302.144846 |
104841010211 |
104841010211001 |
ALBUTEROL |
43.00 |
21302.144846 |
104841010211 |
104841010211002 |
ALBUTEROL |
43.00 |
21302.144846 |
104841010211 |
104841010211003 |
ALBUTEROL |
43.00 |
21302.144846 |
104841010301 |
104841010301001 |
SYMBICORT |
196.00 |
21302.144846 |
104841010301 |
104841010301002 |
SYMBICORT |
196.00 |
21302.144846 |
104841010301 |
104841010301003 |
SYMBICORT |
196.00 |
21302.144846 |
104841010301 |
104841010301004 |
SYMBICORT |
196.00 |
21302.144846 |
104841010311 |
104841010311001 |
PROAIR HFA |
38.00 |
21302.144846 |
104841010311 |
104841010311002 |
PROAIR HFA |
38.00 |
21302.144846 |
104841010311 |
104841010311003 |
PROAIR HFA |
38.00 |
21302.144846 |
104841010311 |
104841010311004 |
PROAIR HFA |
38.00 |
21302.144846 |
104841010321 |
104841010321001 |
SINGULAIR |
125.00 |
21302.144846 |
104841010321 |
104841010321002 |
SINGULAIR |
125.00 |
21302.144846 |
104841010321 |
104841010321003 |
SINGULAIR |
125.00 |
21302.144846 |
104841010321 |
104841010321004 |
SINGULAIR |
125.00 |
21302.144846 |
104841010331 |
104841010331001 |
Albuterol HFA |
1.27 |
21302.144846 |
104841010331 |
104841010331002 |
Albuterol HFA |
1.27 |
21302.144846 |
104841010331 |
104841010331003 |
Albuterol |
1.19 |
21302.144846 |
104911020031 |
104911020031001 |
VENTOLIN HFA |
31.95 |
4101.910391 |
104911020041 |
104911020041001 |
QVAR |
90.35 |
4101.910391 |
105071030021 |
105071030021001 |
VENTOLIN HFA |
32.62 |
9722.976894 |
105071030021 |
105071030021002 |
VENTOLIN HFA |
42.09 |
9722.976894 |
105071030101 |
105071030101001 |
VENTOLIN HFA |
32.62 |
9722.976894 |
105071030151 |
105071030151001 |
VENTOLIN HFA |
32.00 |
9722.976894 |
105101010181 |
105101010181001 |
ALBUTEROL |
10.00 |
4661.361420 |
105191040021 |
105191040021001 |
FLOVENT HFA |
97.87 |
11869.090160 |
105241020141 |
105241020141001 |
PREDNISONE |
1.23 |
9332.386190 |
105241020141 |
105241020141002 |
PREDNISONE |
1.23 |
9332.386190 |
105241020141 |
105241020141003 |
PREDNISONE |
1.23 |
9332.386190 |
105241020191 |
105241020191001 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020191 |
105241020191002 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020191 |
105241020191003 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020211 |
105241020211001 |
ASMANEX 60 |
135.07 |
9332.386190 |
105241020211 |
105241020211002 |
ASMANEX 60 |
115.87 |
9332.386190 |
105241020211 |
105241020211003 |
ASMANEX 60 |
115.87 |
9332.386190 |
105241020571 |
105241020571001 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020571 |
105241020571002 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020571 |
105241020571003 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020571 |
105241020571004 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020571 |
105241020571005 |
SOD CHLORIDE |
13.78 |
9332.386190 |
105241020571 |
105241020571006 |
SOD CHLORIDE |
13.78 |
9332.386190 |
Return to Top
HC-135I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Analysis Variable: RXXP10X SUM OF PAYMENTS RXSF10X-RXOU10X(IMPUTED)
Return to Top
HC-135I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
Analysis Variable: RXXP10X SUM OF PAYMENTS RXSF10X-RXOU10X(IMPUTED)
Return to Top
NOTE: Copyright (c) 2002-2008 by SAS Institute
Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
NOTE: This session is executing on the W32_VSPRO
platform.
NOTE: SAS initialization used:
real time 1.31 seconds
cpu time 0.13 seconds
NOTE: AUTOEXEC processing beginning; file is
C:\Program Files\SAS92\SASFoundation\9.2\autoexec.sas.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
NOTE: AUTOEXEC processing completed.
1 ods rtf file = 'c:\sampleC.rtf' bodytitle;
NOTE: Writing RTF Body file: c:\sampleC.rtf
2
3 ods noproctitle;
4
5 OPTIONS LS=132 PS=59;
6
7 TITLE1 "HC-135I";
8 TITLE2 "Sample SAS Job for Example C";
9
10 LIBNAME IN "C:\Data";
NOTE: Libref IN was successfully assigned as
follows:
Engine: V9
Physical Name: C:\Data
11
12
*************************************************************************************
13 * Calculate the expenditures for medical visits
associated with asthma.
14
*************************************************************************************;
15 PROC FORMAT;
16 VALUE EVENTYPE
17 1 = "1 MVIS"
18 2 = "2 OPAT"
19 3 = "3 EROM"
20 4 = "4 STAZ"
21 5 = "5 DVIS"
22 6 = "6 OMED"
23 7 = "7 HVIS"
24 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
25 RUN;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds
26
27
*-----------------------------------------------------------------------------------
28 * Get conditions records coded as asthma.
29
*-----------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H137 (KEEP=CONDIDX CCCODEX);
32 IF CCCODEX="128";
33 RUN;
NOTE: There were 102306 observations read from the
data set IN.H137.
NOTE: The data set WORK.ASCONDS has 2130
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 2.63 seconds
cpu time 0.03 seconds
34
35
*------------------------------------------------------------------------------------
36 * Get the events linked to each of the asthma
condition records.
37
*------------------------------------------------------------------------------------;
38 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 2130 observations read from the
data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2130
observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
39
40 proc print data=asconds (obs=50);
41 title3 "sample print of work.asconds - sorted by
condidx";
42 title4 "COND (H137) records where cccodex=128";
43 run;
NOTE: There were 50 observations read from the data
set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.06 seconds
cpu time 0.03 seconds
44
45 PROC SORT DATA=IN.H135IF1 OUT=CLNK; BY CONDIDX;
RUN;
NOTE: There were 292498 observations read from the
data set IN.H135IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 292498
observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 3.07 seconds
cpu time 0.28 seconds
46
47 DATA ASCLNKS;
48 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX
EVENTYPE)
49 ASCONDS(IN=INASCOND KEEP=CONDIDX);
50 BY CONDIDX;
51 IF INCLNK & INASCOND;
52 RUN;
NOTE: There were 292498 observations read from the
data set WORK.CLNK.
NOTE: There were 2130 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 6686
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
53
54 proc print data=asclnks (obs=75);
55 by condidx;
56 id condidx;
57 format eventype eventype.;
58 title3 "sample print of work.asclnks - sorted by
condidx";
59 title4 "events linked to asthma condition
records";
60 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 (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
61
62 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 6686 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 6686
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
63
64 proc print data=asclnks (obs=50);
65 format eventype eventype.;
66 title3 "sample print of work.asclnks - sorted by
evntidx";
67 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
68
69 DATA ASCLNKS;
70 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
71 BY EVNTIDX;
72 IF FIRST.EVNTIDX;
73 RUN;
NOTE: There were 6686 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6680
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
74
75 proc print data=asclnks (obs=50);
76 format eventype eventype.;
77 title3 "sample print of unique evntidxs from
work.asclnks";
78 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
79
80
*--------------------------------------------------------------------------------------------
81 * Get non-telephone office based visits (i.e.
MVIS events) for persons with positive weights.
82
*--------------------------------------------------------------------------------------------;
83 DATA MVIS;
84 SET IN.H135G (KEEP=EVNTIDX PERWT10F SEETLKPV
OBXP10X);
85 IF PERWT10F > 0 & SEETLKPV NE 2;
86 RUN;
NOTE: There were 128246 observations read from the
data set IN.H135G.
NOTE: The data set WORK.MVIS has 124823
observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 8.42 seconds
cpu time 0.17 seconds
87
88 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 124823 observations read from the
data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 124823
observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.12 seconds
89
90
*-------------------------------------------------------------------------------------
91 * Identify MVIS events which were for asthma.
92
*-------------------------------------------------------------------------------------;
93 DATA ASMVIS;
94 MERGE ASCLNKS (IN=INASCLNK)
95 MVIS (IN=INMVIS);
96 BY EVNTIDX;
97 IF INASCLNK & INMVIS;
98 RUN;
NOTE: There were 6680 observations read from the
data set WORK.ASCLNKS.
NOTE: There were 124823 observations read from the
data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1879
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
99
100 proc print data=asmvis (obs=50);
101 format eventype eventype.;
102 title3 "sample print of work.asmvis";
103 title4 "unique evntidxs from work.asclnks that
are non-telephone MVIS (HC-135G) events";
104 run;
NOTE: There were 50 observations read from the data
set WORK.ASMVIS.
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
105
106 PROC MEANS DATA=ASMVIS N SUM;
107 VAR OBXP10X;
108 TITLE3 "Total medical visit expenditures
(excluding telephone) associated with asthma";
109 RUN;
NOTE: Multiple concurrent threads will be used to
summarize data.
NOTE: There were 1879 observations read from the
data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 7.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
110
111 PROC MEANS DATA=ASMVIS N SUM;
112 VAR OBXP10X;
113 WEIGHT PERWT10F;
114 TITLE3 "Total medical visit expenditures
(excluding telephone) associated with asthma";
115 TITLE5 "Weighted";
116 RUN;
NOTE: Multiple concurrent threads will be used to
summarize data.
NOTE: There were 1879 observations read from the
data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 8.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
117
118 ods rtf close;
119
120
NOTE: SAS Institute Inc., SAS Campus Drive, Cary,
NC USA 27513-2414
NOTE: The SAS System used:
real time 17.19 seconds
cpu time 1.01 seconds
Return to Top
HC-135I. Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx
COND (H137) records where cccodex=128
Obs |
CONDIDX |
CCCODEX |
1 |
100121010051 |
128 |
2 |
100171010021 |
128 |
3 |
100431010021 |
128 |
4 |
100431030011 |
128 |
5 |
100431040011 |
128 |
6 |
100441010031 |
128 |
7 |
100531020041 |
128 |
8 |
100531040011 |
128 |
9 |
100661010021 |
128 |
10 |
100671010071 |
128 |
11 |
100671020041 |
128 |
12 |
100861020041 |
128 |
13 |
101311020041 |
128 |
14 |
101371010051 |
128 |
15 |
101541020041 |
128 |
16 |
101831050011 |
128 |
17 |
101841020091 |
128 |
18 |
101981020061 |
128 |
19 |
101981030051 |
128 |
20 |
101981040031 |
128 |
21 |
101981050011 |
128 |
22 |
102061010011 |
128 |
23 |
102061040011 |
128 |
24 |
102291020011 |
128 |
25 |
102361030011 |
128 |
26 |
102361040011 |
128 |
27 |
102421010041 |
128 |
28 |
102442010032 |
128 |
29 |
102451010021 |
128 |
30 |
102451030011 |
128 |
31 |
102531020011 |
128 |
32 |
102591050011 |
128 |
33 |
102601010071 |
128 |
34 |
102691010111 |
128 |
35 |
102691020091 |
128 |
36 |
102692030012 |
128 |
37 |
102781020031 |
128 |
38 |
102891010051 |
128 |
39 |
102891020021 |
128 |
40 |
102991060011 |
128 |
41 |
103051020011 |
128 |
42 |
103101010031 |
128 |
43 |
103131010111 |
128 |
44 |
103311010051 |
128 |
45 |
103331010021 |
128 |
46 |
103371010011 |
128 |
47 |
103581010041 |
128 |
48 |
103691010021 |
128 |
49 |
103851030011 |
128 |
50 |
103851040011 |
128 |
Return to Top
HC-135I. Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
100121010051 |
100121010051 |
8 PMED |
100121010051 |
100121010111 |
8 PMED |
100121010051 |
100121010151 |
8 PMED |
100171010021 |
100171010091 |
8 PMED |
100171010021 |
100171010161 |
8 PMED |
100171010021 |
100171010181 |
1 MVIS |
100431010021 |
100431010121 |
8 PMED |
100431030011 |
100431030011 |
1 MVIS |
100431030011 |
100431030021 |
8 PMED |
100431030011 |
100431030031 |
8 PMED |
100431030011 |
100431030051 |
8 PMED |
100431030011 |
100431030071 |
1 MVIS |
100431030011 |
100431030091 |
8 PMED |
100431030011 |
100431030101 |
8 PMED |
100431030011 |
100431030111 |
8 PMED |
100431030011 |
100431030121 |
8 PMED |
100431030011 |
100431030171 |
8 PMED |
100431040011 |
100431040011 |
1 MVIS |
100431040011 |
100431040021 |
1 MVIS |
100431040011 |
100431040031 |
8 PMED |
100431040011 |
100431040041 |
8 PMED |
100431040011 |
100431040051 |
8 PMED |
100431040011 |
100431040061 |
8 PMED |
100431040011 |
100431040071 |
8 PMED |
100431040011 |
100431040081 |
8 PMED |
100431040011 |
100431040091 |
1 MVIS |
100431040011 |
100431040101 |
1 MVIS |
100431040011 |
100431040111 |
1 MVIS |
100431040011 |
100431040131 |
8 PMED |
100431040011 |
100431040141 |
8 PMED |
100431040011 |
100431040151 |
8 PMED |
100431040011 |
100431040161 |
8 PMED |
100431040011 |
100431040171 |
1 MVIS |
100431040011 |
100431040201 |
1 MVIS |
100431040011 |
100431040211 |
1 MVIS |
100431040011 |
100431040231 |
8 PMED |
100431040011 |
100431040241 |
8 PMED |
100431040011 |
100431040251 |
8 PMED |
100431040011 |
100431040271 |
8 PMED |
100441010031 |
100441010031 |
2 OPAT |
100441010031 |
100441010091 |
8 PMED |
100441010031 |
100441010101 |
8 PMED |
100441010031 |
100441010111 |
8 PMED |
100531020041 |
100531020361 |
8 PMED |
100531040011 |
100531040021 |
8 PMED |
100661010021 |
100661010021 |
8 PMED |
100661010021 |
100661010041 |
8 PMED |
100671010071 |
100671010171 |
8 PMED |
100671010071 |
100671010181 |
8 PMED |
100671010071 |
100671010191 |
8 PMED |
100671010071 |
100671010401 |
8 PMED |
100671010071 |
100671010411 |
8 PMED |
100671010071 |
100671010421 |
8 PMED |
100671010071 |
100671010511 |
8 PMED |
100671010071 |
100671010521 |
8 PMED |
100671010071 |
100671010531 |
8 PMED |
100671020041 |
100671020371 |
8 PMED |
100671020041 |
100671020411 |
8 PMED |
100861020041 |
100861020011 |
1 MVIS |
100861020041 |
100861020031 |
8 PMED |
100861020041 |
100861020091 |
8 PMED |
100861020041 |
100861020101 |
8 PMED |
100861020041 |
100861020111 |
1 MVIS |
100861020041 |
100861020141 |
8 PMED |
100861020041 |
100861020151 |
8 PMED |
101371010051 |
101371010261 |
1 MVIS |
101371010051 |
101371010341 |
8 PMED |
101371010051 |
101371010381 |
8 PMED |
101541020041 |
101541020011 |
1 MVIS |
101841020091 |
101841020381 |
8 PMED |
101841020091 |
101841020401 |
2 OPAT |
102061010011 |
102061010071 |
8 PMED |
102061040011 |
102061040011 |
1 MVIS |
102061040011 |
102061040021 |
1 MVIS |
102061040011 |
102061040031 |
3 EROM |
Return to Top
HC-135I. Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
100121010051 |
100121010051 |
8 PMED |
2 |
100121010051 |
100121010111 |
8 PMED |
3 |
100121010051 |
100121010151 |
8 PMED |
4 |
100171010021 |
100171010091 |
8 PMED |
5 |
100171010021 |
100171010161 |
8 PMED |
6 |
100171010021 |
100171010181 |
1 MVIS |
7 |
100431010021 |
100431010121 |
8 PMED |
8 |
100431030011 |
100431030011 |
1 MVIS |
9 |
100431030011 |
100431030021 |
8 PMED |
10 |
100431030011 |
100431030031 |
8 PMED |
11 |
100431030011 |
100431030051 |
8 PMED |
12 |
100431030011 |
100431030071 |
1 MVIS |
13 |
100431030011 |
100431030091 |
8 PMED |
14 |
100431030011 |
100431030101 |
8 PMED |
15 |
100431030011 |
100431030111 |
8 PMED |
16 |
100431030011 |
100431030121 |
8 PMED |
17 |
100431030011 |
100431030171 |
8 PMED |
18 |
100431040011 |
100431040011 |
1 MVIS |
19 |
100431040011 |
100431040021 |
1 MVIS |
20 |
100431040011 |
100431040031 |
8 PMED |
21 |
100431040011 |
100431040041 |
8 PMED |
22 |
100431040011 |
100431040051 |
8 PMED |
23 |
100431040011 |
100431040061 |
8 PMED |
24 |
100431040011 |
100431040071 |
8 PMED |
25 |
100431040011 |
100431040081 |
8 PMED |
26 |
100431040011 |
100431040091 |
1 MVIS |
27 |
100431040011 |
100431040101 |
1 MVIS |
28 |
100431040011 |
100431040111 |
1 MVIS |
29 |
100431040011 |
100431040131 |
8 PMED |
30 |
100431040011 |
100431040141 |
8 PMED |
31 |
100431040011 |
100431040151 |
8 PMED |
32 |
100431040011 |
100431040161 |
8 PMED |
33 |
100431040011 |
100431040171 |
1 MVIS |
34 |
100431040011 |
100431040201 |
1 MVIS |
35 |
100431040011 |
100431040211 |
1 MVIS |
36 |
100431040011 |
100431040231 |
8 PMED |
37 |
100431040011 |
100431040241 |
8 PMED |
38 |
100431040011 |
100431040251 |
8 PMED |
39 |
100431040011 |
100431040271 |
8 PMED |
40 |
100441010031 |
100441010031 |
2 OPAT |
41 |
100441010031 |
100441010091 |
8 PMED |
42 |
100441010031 |
100441010101 |
8 PMED |
43 |
100441010031 |
100441010111 |
8 PMED |
44 |
100531020041 |
100531020361 |
8 PMED |
45 |
100531040011 |
100531040021 |
8 PMED |
46 |
100661010021 |
100661010021 |
8 PMED |
47 |
100661010021 |
100661010041 |
8 PMED |
48 |
100671010071 |
100671010171 |
8 PMED |
49 |
100671010071 |
100671010181 |
8 PMED |
50 |
100671010071 |
100671010191 |
8 PMED |
Return to Top
HC-135I. Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
100121010051 |
8 PMED |
2 |
100121010111 |
8 PMED |
3 |
100121010151 |
8 PMED |
4 |
100171010091 |
8 PMED |
5 |
100171010161 |
8 PMED |
6 |
100171010181 |
1 MVIS |
7 |
100431010121 |
8 PMED |
8 |
100431030011 |
1 MVIS |
9 |
100431030021 |
8 PMED |
10 |
100431030031 |
8 PMED |
11 |
100431030051 |
8 PMED |
12 |
100431030071 |
1 MVIS |
13 |
100431030091 |
8 PMED |
14 |
100431030101 |
8 PMED |
15 |
100431030111 |
8 PMED |
16 |
100431030121 |
8 PMED |
17 |
100431030171 |
8 PMED |
18 |
100431040011 |
1 MVIS |
19 |
100431040021 |
1 MVIS |
20 |
100431040031 |
8 PMED |
21 |
100431040041 |
8 PMED |
22 |
100431040051 |
8 PMED |
23 |
100431040061 |
8 PMED |
24 |
100431040071 |
8 PMED |
25 |
100431040081 |
8 PMED |
26 |
100431040091 |
1 MVIS |
27 |
100431040101 |
1 MVIS |
28 |
100431040111 |
1 MVIS |
29 |
100431040131 |
8 PMED |
30 |
100431040141 |
8 PMED |
31 |
100431040151 |
8 PMED |
32 |
100431040161 |
8 PMED |
33 |
100431040171 |
1 MVIS |
34 |
100431040201 |
1 MVIS |
35 |
100431040211 |
1 MVIS |
36 |
100431040231 |
8 PMED |
37 |
100431040241 |
8 PMED |
38 |
100431040251 |
8 PMED |
39 |
100431040271 |
8 PMED |
40 |
100441010031 |
2 OPAT |
41 |
100441010091 |
8 PMED |
42 |
100441010101 |
8 PMED |
43 |
100441010111 |
8 PMED |
44 |
100531020361 |
8 PMED |
45 |
100531040021 |
8 PMED |
46 |
100661010021 |
8 PMED |
47 |
100661010041 |
8 PMED |
48 |
100671010171 |
8 PMED |
49 |
100671010181 |
8 PMED |
50 |
100671010191 |
8 PMED |
Return to Top
HC-135I. Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-135G) events
Obs |
EVNTIDX |
EVENTYPE |
SEETLKPV |
OBXP10X |
PERWT10F |
1 |
100171010181 |
1 MVIS |
1 |
75.00 |
8879.04 |
2 |
100431030011 |
1 MVIS |
1 |
95.81 |
13273.14 |
3 |
100431030071 |
1 MVIS |
1 |
95.81 |
13273.14 |
4 |
100431040011 |
1 MVIS |
1 |
98.61 |
24678.50 |
5 |
100431040021 |
1 MVIS |
1 |
96.94 |
24678.50 |
6 |
100431040091 |
1 MVIS |
1 |
77.61 |
24678.50 |
7 |
100431040101 |
1 MVIS |
1 |
98.64 |
24678.50 |
8 |
100431040111 |
1 MVIS |
1 |
95.81 |
24678.50 |
9 |
100431040171 |
1 MVIS |
1 |
120.46 |
24678.50 |
10 |
100431040201 |
1 MVIS |
1 |
98.61 |
24678.50 |
11 |
100431040211 |
1 MVIS |
1 |
95.81 |
24678.50 |
12 |
100861020011 |
1 MVIS |
1 |
72.97 |
4351.17 |
13 |
100861020111 |
1 MVIS |
1 |
72.97 |
4351.17 |
14 |
101371010261 |
1 MVIS |
1 |
54.28 |
3246.39 |
15 |
101541020011 |
1 MVIS |
1 |
75.00 |
6213.90 |
16 |
102061040011 |
1 MVIS |
1 |
90.92 |
9038.83 |
17 |
102061040021 |
1 MVIS |
1 |
75.78 |
9038.83 |
18 |
102291020061 |
1 MVIS |
1 |
77.69 |
10983.99 |
19 |
102451010081 |
1 MVIS |
1 |
98.64 |
16538.63 |
20 |
102451030011 |
1 MVIS |
1 |
63.85 |
18569.06 |
21 |
102531020051 |
1 MVIS |
1 |
110.74 |
25782.76 |
22 |
102601010131 |
1 MVIS |
1 |
35.00 |
10351.48 |
23 |
102601010141 |
1 MVIS |
1 |
14.71 |
10351.48 |
24 |
102601010151 |
1 MVIS |
1 |
26.00 |
10351.48 |
25 |
102601010161 |
1 MVIS |
1 |
26.00 |
10351.48 |
26 |
102691010101 |
1 MVIS |
1 |
371.64 |
6355.08 |
27 |
102781020141 |
1 MVIS |
1 |
61.73 |
12143.59 |
28 |
102781020151 |
1 MVIS |
1 |
61.73 |
12143.59 |
29 |
102991060021 |
1 MVIS |
1 |
128.00 |
7322.18 |
30 |
103051020041 |
1 MVIS |
1 |
5.79 |
4878.46 |
31 |
103051020051 |
1 MVIS |
1 |
5.79 |
4878.46 |
32 |
103051020061 |
1 MVIS |
1 |
79.75 |
4878.46 |
33 |
103051020131 |
1 MVIS |
1 |
37.64 |
4878.46 |
34 |
103581010011 |
1 MVIS |
1 |
75.00 |
5132.99 |
35 |
103581010561 |
1 MVIS |
1 |
464.00 |
5132.99 |
36 |
103581010571 |
1 MVIS |
1 |
464.00 |
5132.99 |
37 |
103581010581 |
1 MVIS |
1 |
68.00 |
5132.99 |
38 |
103921030071 |
1 MVIS |
1 |
10.00 |
5614.57 |
39 |
103921030081 |
1 MVIS |
1 |
10.00 |
5614.57 |
40 |
103921030091 |
1 MVIS |
1 |
10.00 |
5614.57 |
41 |
103921030101 |
1 MVIS |
1 |
51.98 |
5614.57 |
42 |
103921030111 |
1 MVIS |
1 |
10.00 |
5614.57 |
43 |
103921030121 |
1 MVIS |
1 |
10.00 |
5614.57 |
44 |
103921030131 |
1 MVIS |
1 |
77.53 |
5614.57 |
45 |
103921030141 |
1 MVIS |
1 |
10.00 |
5614.57 |
46 |
103921030151 |
1 MVIS |
1 |
10.00 |
5614.57 |
47 |
103921030161 |
1 MVIS |
1 |
10.00 |
5614.57 |
48 |
103921030171 |
1 MVIS |
1 |
10.00 |
5614.57 |
49 |
103921030181 |
1 MVIS |
1 |
76.24 |
5614.57 |
50 |
103921030191 |
1 MVIS |
1 |
10.00 |
5614.57 |
Return to Top
HC-135I. Sample SAS Job for Example C
Total medical visit expenditures (excluding
telephone) associated with asthma
Analysis Variable: OBXP10X SUM OF OBSF10X - OBOT10X (IMPUTED)
Return to Top
HC-135I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
Analysis Variable: OBXP10X SUM OF OBSF10X - OBOT10X (IMPUTED)
Return to Top
|