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 2.05 seconds
cpu time 0.21 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-144I";
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.01 seconds
cpu time 0.01 seconds
28
29
*-------------------------------------------------------------------------------------
30 * Get condition records coded as asthma.
31
*-------------------------------------------------------------------------------------;
32 DATA ASCONDS;
33 SET IN.H146 (KEEP=CONDIDX CCCODEX);
34 IF CCCODEX="128";
35
36 RUN;
NOTE: There were 108619 observations read from the
data set IN.H146.
NOTE: The data set WORK.ASCONDS has 2327
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 3.30 seconds
cpu time 0.03 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 2327 observations read from the
data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2327
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 (H146) 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.26 seconds
cpu time 0.07 seconds
47
48 PROC SORT DATA=IN.H144IF1 OUT=CLNK; BY CONDIDX;
RUN;
NOTE: There were 306663 observations read from the
data set IN.H144IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 306663
observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 3.18 seconds
cpu time 0.40 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 306663 observations read from the
data set WORK.CLNK.
NOTE: There were 2327 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7004
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.09 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.04 seconds
cpu time 0.01 seconds
64
65 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7004 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 7004
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 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.00 seconds
cpu time 0.00 seconds
71
72 DATA ASCLNKS;
73 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
74 BY EVNTIDX;
75 IF FIRST.EVNTIDX;
76 RUN;
NOTE: There were 7004 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6998
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 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.01 seconds
cpu time 0.01 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.H144G (KEEP=EVNTIDX PERWT11F SEETLKPV);
88 IF PERWT11F > 0 & SEETLKPV NE 2;
89 RUN;
NOTE: There were 134311 observations read from the
data set IN.H144G.
NOTE: The data set WORK.MVIS has 130464
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 11.20 seconds
cpu time 0.18 seconds
90
91 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 130464 observations read from the
data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 130464
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.07 seconds
cpu time 0.12 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 6998 observations read from the
data set WORK.ASCLNKS.
NOTE: There were 130464 observations read from the
data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1858
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 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-144G) 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.01 seconds
cpu time 0.01 seconds
108
109
*-------------------------------------------------------------------------------------
110 * Get PMED IDs linked to the MVIS events which
were for asthma.
111
*-------------------------------------------------------------------------------------;
112 PROC SORT DATA=IN.H144IF2 OUT=RXLK; BY EVNTIDX;
RUN;
NOTE: There were 56713 observations read from the
data set IN.H144IF2.
NOTE: SAS sort was used.
NOTE: The data set WORK.RXLK has 56713 observations
and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.64 seconds
cpu time 0.07 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-144IF2)";
121 run;
NOTE: There were 140 observations read from the
data set WORK.RXLK.
NOTE: The PROCEDURE PRINT printed pages 7-11.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.03 seconds
cpu time 0.03 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 56713 observations read from the
data set WORK.RXLK.
NOTE: There were 1858 observations read from the
data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 1996
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 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 12-13.
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 1996 observations read from the
data set WORK.PMEDIDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.PMEDIDS has 1996
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 14.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
144
145 DATA PMEDIDS;
146 SET PMEDIDS (KEEP=LINKIDX);
147 BY LINKIDX;
148 IF FIRST.LINKIDX;
149 RUN;
NOTE: There were 1996 observations read from the
data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1910
observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 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 15.
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.H144A OUT=PMED; BY LINKIDX;
RUN;
NOTE: There were 313747 observations read from the
data set IN.H144A.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.PMED has 313747
observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 8.38 seconds
cpu time 0.50 seconds
159
160 DATA MVPMEDS;
161 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP11X
PERWT11F RXNAME)
162 PMEDIDS (IN=A);
163 BY LINKIDX;
164 IF A;
165 RUN;
NOTE: There were 313747 observations read from the
data set WORK.PMED.
NOTE: There were 1910 observations read from the
data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 5023
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.10 seconds
166
167 proc print data=mvpmeds (obs=200);
168 var rxrecidx rxname RXXP11X PERWT11F;
169 by linkidx;
170 id linkidx;
171 title3 "sample print of work.mvpmeds";
172 title4 "PMED (HC-144A) 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 16-21.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
174
175 PROC MEANS DATA=MVPMEDS N SUM;
176 VAR RXXP11X;
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 5023 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.12 seconds
cpu time 0.04 seconds
179
180 PROC MEANS DATA=MVPMEDS N SUM;
181 VAR RXXP11X;
182 WEIGHT PERWT11F;
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 5023 observations read from the
data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.04 seconds
cpu time 0.01 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 32.77 seconds
cpu time 2.38 seconds
Return to Top
HC-144I. Sample SAS Job for Example A - sample print of work.asconds, sorted by condidx
COND (H146) 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 |
100671010071 |
128 |
10 |
100671020041 |
128 |
11 |
100861020041 |
128 |
12 |
101171050011 |
128 |
13 |
101231030011 |
128 |
14 |
101311020041 |
128 |
15 |
101371010051 |
128 |
16 |
101671020011 |
128 |
17 |
101831050011 |
128 |
18 |
101841020091 |
128 |
19 |
101841030031 |
128 |
20 |
101841030061 |
128 |
21 |
101981020061 |
128 |
22 |
101981030051 |
128 |
23 |
101981040031 |
128 |
24 |
101981050011 |
128 |
25 |
102061010011 |
128 |
26 |
102061040011 |
128 |
27 |
102291020011 |
128 |
28 |
102331020021 |
128 |
29 |
102361030011 |
128 |
30 |
102361040011 |
128 |
31 |
102421010041 |
128 |
32 |
102442010032 |
128 |
33 |
102451010021 |
128 |
34 |
102451030011 |
128 |
35 |
102531020011 |
128 |
36 |
102781020031 |
128 |
37 |
102891010051 |
128 |
38 |
102891020021 |
128 |
39 |
102991050011 |
128 |
40 |
102991060011 |
128 |
41 |
103031010041 |
128 |
42 |
103051020011 |
128 |
43 |
103101010031 |
128 |
44 |
103151020011 |
128 |
45 |
103371010011 |
128 |
46 |
103581010041 |
128 |
47 |
103611020011 |
128 |
48 |
103691010021 |
128 |
49 |
103701010091 |
128 |
50 |
103851040011 |
128 |
Return to Top
HC-144I. Sample SAS Job for Example A - sample print of work.asclnks, sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
100121010051 |
100121010111 |
8 PMED |
100121010051 |
100121010151 |
8 PMED |
100121010051 |
100121010201 |
8 PMED |
100121010051 |
100121010231 |
8 PMED |
100171010021 |
100171010231 |
8 PMED |
100171010021 |
100171010271 |
8 PMED |
100431010021 |
100431010201 |
8 PMED |
100431010021 |
100431010271 |
8 PMED |
100431030011 |
100431030281 |
8 PMED |
100431030011 |
100431030311 |
2 OPAT |
100431030011 |
100431030321 |
1 MVIS |
100431030011 |
100431030331 |
8 PMED |
100431030011 |
100431030351 |
8 PMED |
100431040011 |
100431040231 |
8 PMED |
100431040011 |
100431040321 |
8 PMED |
100431040011
| 100431040341 |
1 MVIS |
100431040011
| 100431040361 |
2 OPAT |
100431040011
| 100431040371 |
8 PMED |
100441010031
| 100441010181 |
8 PMED |
100441010031
| 100441010191 |
8 PMED |
100441010031
| 100441010201 |
8 PMED |
100441010031
| 100441010211 |
1 MVIS |
100531020041 |
100531020361 |
8 PMED |
100531020041 |
100531020511 |
8 PMED |
100531020041 |
100531020521 |
8 PMED |
100531020041 |
100531020531 |
8 PMED |
100531040011 |
100531040021 |
8 PMED |
100531040011 |
100531040031 |
1 MVIS |
100531040011 |
100531040051 |
8 PMED |
100531040011 |
100531040091 |
8 PMED |
100671010071 |
100671010511 |
8 PMED |
100671010071 |
100671010521 |
8 PMED |
100671010071 |
100671010531 |
8 PMED |
100671010071 |
100671010681 |
8 PMED |
100671010071 |
100671010701 |
2 OPAT |
100671010071 |
100671010811 |
8 PMED |
100671010071 |
100671010821 |
8 PMED |
100671010071 |
100671010831 |
8 PMED |
100671020041 |
100671020291 |
1 MVIS |
100671020041 |
100671020301 |
1 MVIS |
100671020041 |
100671020311 |
1 MVIS |
100671020041 |
100671020371 |
8 PMED |
100671020041 |
100671020401 |
8 PMED |
100671020041 |
100671020411 |
8 PMED |
100671020041 |
100671020601 |
8 PMED |
100671020041 |
100671020611 |
8 PMED |
100861020041 |
100861020131 |
1 MVIS |
100861020041 |
100861020141 |
8 PMED |
100861020041 |
100861020151 |
8 PMED |
100861020041 |
100861020181 |
8 PMED |
100861020041 |
100861020221 |
1 MVIS |
100861020041 |
100861020241 |
8 PMED |
100861020041 |
100861020291 |
8 PMED |
100861020041 |
100861020371 |
1 MVIS |
100861020041 |
100861020391 |
8 PMED |
100861020041 |
100861020411 |
8 PMED |
100861020041 |
100861020451 |
8 PMED |
100861020041 |
100861020461 |
8 PMED |
100861020041 |
100861020511 |
1 MVIS |
100861020041 |
100861020521 |
1 MVIS |
101231030011 |
101231030121 |
8 PMED |
101371010051 |
101371010481 |
8 PMED |
101671020011 |
101671020201 |
1 MVIS |
101671020011 |
101671020211 |
8 PMED |
101831050011 |
101831050031 |
8 PMED |
101841020091 |
101841020381 |
8 PMED |
101841020091 |
101841020411 |
2 OPAT |
101841020091 |
101841020421 |
2 OPAT |
101841020091 |
101841020521 |
8 PMED |
101841020091 |
101841020551 |
8 PMED |
101841020091 |
101841020691 |
8 PMED |
101841020091 |
101841020721 |
8 PMED |
101841020091 |
101841020731 |
8 PMED |
101841020091 |
101841020761 |
8 PMED |
101841020091 |
101841020791 |
2 OPAT |
Return to Top
HC-144I. Sample SAS Job for Example A - sample print of work.asclnks, sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
100121010051 |
100121010111 |
8 PMED |
2 |
100121010051 |
100121010151 |
8 PMED |
3 |
100121010051 |
100121010201 |
8 PMED |
4 |
100121010051 |
100121010231 |
8 PMED |
5 |
100171010021 |
100171010231 |
8 PMED |
6 |
100171010021 |
100171010271 |
8 PMED |
7 |
100431010021 |
100431010201 |
8 PMED |
8 |
100431010021 |
100431010271 |
8 PMED |
9 |
100431030011 |
100431030281 |
8 PMED |
10 |
100431030011 |
100431030311 |
2 OPAT |
11 |
100431030011 |
100431030321 |
1 MVIS |
12 |
100431030011 |
100431030331 |
8 PMED |
13 |
100431030011 |
100431030351 |
8 PMED |
14 |
100431040011 |
100431040231 |
8 PMED |
15 |
100431040011 |
100431040321 |
8 PMED |
16 |
100431040011 |
100431040341 |
1 MVIS |
17 |
100431040011 |
100431040361 |
2 OPAT |
18 |
100431040011 |
100431040371 |
8 PMED |
19 |
100441010031 |
100441010181 |
8 PMED |
20 |
100441010031 |
100441010191 |
8 PMED |
21 |
100441010031 |
100441010201 |
8 PMED |
22 |
100441010031 |
100441010211 |
1 MVIS |
23 |
100531020041 |
100531020361 |
8 PMED |
24 |
100531020041 |
100531020511 |
8 PMED |
25 |
100531020041 |
100531020521 |
8 PMED |
26 |
100531020041 |
100531020531 |
8 PMED |
27 |
100531040011 |
100531040021 |
8 PMED |
28 |
100531040011 |
100531040031 |
1 MVIS |
29 |
100531040011 |
100531040051 |
8 PMED |
30 |
100531040011 |
100531040091 |
8 PMED |
31 |
100671010071 |
100671010511 |
8 PMED |
32 |
100671010071 |
100671010521 |
8 PMED |
33 |
100671010071 |
100671010531 |
8 PMED |
34 |
100671010071 |
100671010681 |
8 PMED |
35 |
100671010071 |
100671010701 |
2 OPAT |
36 |
100671010071 |
100671010811 |
8 PMED |
37 |
100671010071 |
100671010821 |
8 PMED |
38 |
100671010071 |
100671010831 |
8 PMED |
39 |
100671020041 |
100671020291 |
1 MVIS |
40 |
100671020041 |
100671020301 |
1 MVIS |
41 |
100671020041 |
100671020311 |
1 MVIS |
42 |
100671020041 |
100671020371 |
8 PMED |
43 |
100671020041 |
100671020401 |
8 PMED |
44 |
100671020041 |
100671020411 |
8 PMED |
45 |
100671020041 |
100671020601 |
8 PMED |
46 |
100671020041 |
100671020611 |
8 PMED |
47 |
100861020041 |
100861020131 |
1 MVIS |
48 |
100861020041 |
100861020141 |
8 PMED |
49 |
100861020041 |
100861020151 |
8 PMED |
50 |
100861020041 |
100861020181 |
8 PMED |
Return to Top
HC-144I. Sample SAS Job for Example A - sample print of unique evntidxs from work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
100121010111 |
8 PMED |
2 |
100121010151 |
8 PMED |
3 |
100121010201 |
8 PMED |
4 |
100121010231 |
8 PMED |
5 |
100171010231 |
8 PMED |
6 |
100171010271 |
8 PMED |
7 |
100431010201 |
8 PMED |
8 |
100431010271 |
8 PMED |
9 |
100431030281 |
8 PMED |
10 |
100431030311 |
2 OPAT |
11 |
100431030321 |
1 MVIS |
12 |
100431030331 |
8 PMED |
13 |
100431030351 |
8 PMED |
14 |
100431040231 |
8 PMED |
15 |
100431040321 |
8 PMED |
16 |
100431040341 |
1 MVIS |
17 |
100431040361 |
2 OPAT |
18 |
100431040371 |
8 PMED |
19 |
100441010181 |
8 PMED |
20 |
100441010191 |
8 PMED |
21 |
100441010201 |
8 PMED |
22 |
100441010211 |
1 MVIS |
23 |
100531020361 |
8 PMED |
24 |
100531020511 |
8 PMED |
25 |
100531020521 |
8 PMED |
26 |
100531020531 |
8 PMED |
27 |
100531040021 |
8 PMED |
28 |
100531040031 |
1 MVIS |
29 |
100531040051 |
8 PMED |
30 |
100531040091 |
8 PMED |
31 |
100671010511 |
8 PMED |
32 |
100671010521 |
8 PMED |
33 |
100671010531 |
8 PMED |
34 |
100671010681 |
8 PMED |
35 |
100671010701 |
2 OPAT |
36 |
100671010811 |
8 PMED |
37 |
100671010821 |
8 PMED |
38 |
100671010831 |
8 PMED |
39 |
100671020291 |
1 MVIS |
40 |
100671020301 |
1 MVIS |
41 |
100671020311 |
1 MVIS |
42 |
100671020371 |
8 PMED |
43 |
100671020401 |
8 PMED |
44 |
100671020411 |
8 PMED |
45 |
100671020601 |
8 PMED |
46 |
100671020611 |
8 PMED |
47 |
100861020131 |
1 MVIS |
48 |
100861020141 |
8 PMED |
49 |
100861020151 |
8 PMED |
50 |
100861020181 |
8 PMED |
Return to Top
HC-144I. Sample SAS Job for Example A - sample print of work.asmvis unique evntidxs
from work.asclnks that are non-telephone MVIS (HC-144G) events
Obs |
EVNTIDX |
EVENTYPE |
1 |
100431030321 |
1 MVIS |
2 |
100431040341 |
1 MVIS |
3 |
100441010211 |
1 MVIS |
4 |
100531040031 |
1 MVIS |
5 |
100671020291 |
1 MVIS |
6 |
100671020301 |
1 MVIS |
7 |
100671020311 |
1 MVIS |
8 |
100861020131 |
1 MVIS |
9 |
100861020221 |
1 MVIS |
10 |
100861020371 |
1 MVIS |
11 |
100861020511 |
1 MVIS |
12 |
100861020521 |
1 MVIS |
13 |
101671020201 |
1 MVIS |
14 |
101841030191 |
1 MVIS |
15 |
102361030121 |
1 MVIS |
16 |
102442010182 |
1 MVIS |
17 |
102451010121 |
1 MVIS |
18 |
103581010591 |
1 MVIS |
19 |
104011010381 |
1 MVIS |
20 |
104601040181 |
1 MVIS |
21 |
104601050361 |
1 MVIS |
22 |
104601050371 |
1 MVIS |
23 |
104601050381 |
1 MVIS |
24 |
104801010201 |
1 MVIS |
25 |
104801010211 |
1 MVIS |
26 |
104801010221 |
1 MVIS |
27 |
104801010321 |
1 MVIS |
28 |
104841010461 |
1 MVIS |
29 |
104841010471 |
1 MVIS |
30 |
105241020971 |
1 MVIS |
31 |
105241020981 |
1 MVIS |
32 |
105241020991 |
1 MVIS |
33 |
105241021001 |
1 MVIS |
34 |
105241021011 |
1 MVIS |
35 |
105241021201 |
1 MVIS |
36 |
105241040441 |
1 MVIS |
37 |
105721010861 |
1 MVIS |
38 |
105721010871 |
1 MVIS |
39 |
105721010881 |
1 MVIS |
40 |
106121010081 |
1 MVIS |
41 |
106181070081 |
1 MVIS |
42 |
106771030011 |
1 MVIS |
43 |
106951010031 |
1 MVIS |
44 |
107031040021 |
1 MVIS |
45 |
107031040061 |
1 MVIS |
46 |
107251040112 |
1 MVIS |
47 |
108351020521 |
1 MVIS |
48 |
108411010251 |
1 MVIS |
49 |
108851010011 |
1 MVIS |
50 |
109001050131 |
1 MVIS |
Return to Top
HC-144I. Sample SAS Job for Example A - sample print of work.rxlk, sorted by evntidx
Rx+event link file records (HC-144IF2)
EVNTIDX |
LINKIDX |
EVENTYPE |
100071040041 |
100071040051 |
1 MVIS |
100071040041 |
100071040061 |
1 MVIS |
100081020021 |
100081020031 |
1 MVIS |
100081020051 |
100081020061 |
1 MVIS |
100081020051 |
100081020071 |
1 MVIS |
100121020701 |
100121020921 |
1 MVIS |
100121020701 |
100121020931 |
1 MVIS |
100121020761 |
100121020941 |
1 MVIS |
100121020781 |
100121020951 |
1 MVIS |
100121020831 |
100121020961 |
1 MVIS |
100121020841 |
100121020971 |
1 MVIS |
100121020851 |
100121020971 |
1 MVIS |
100121020851 |
100121020981 |
1 MVIS |
100121020891 |
100121020991 |
1 MVIS |
100141020021 |
100141020061 |
1 MVIS |
100161020111 |
100161020151 |
5 DVIS |
100161040081 |
100161040111 |
1 MVIS |
100161040081 |
100161040121 |
1 MVIS |
100161040081 |
100161040131 |
1 MVIS |
100161050151 |
100161050201 |
1 MVIS |
100161050171 |
100161050211 |
1 MVIS |
100161060021 |
100161060051 |
3 EROM |
100161060021 |
100161060061 |
3 EROM |
100161060121 |
100161060141 |
1 MVIS |
100161060131 |
100161060151 |
3 EROM |
100171010241 |
100171010261 |
1 MVIS |
100171010241 |
100171010271 |
1 MVIS |
100211030111 |
100211030151 |
1 MVIS |
100301010111 |
100301010151 |
1 MVIS |
100301010161 |
100301010181 |
1 MVIS |
100301010221 |
100301010231 |
1 MVIS |
100301010221 |
100301010251 |
1 MVIS |
100301010221 |
100301010281 |
1 MVIS |
100301020061 |
100301020071 |
1 MVIS |
100301020061 |
100301020081 |
1 MVIS |
100301030071 |
100301030081 |
1 MVIS |
100301040071 |
100301040111 |
1 MVIS |
100301040081 |
100301040121 |
4 STAZ |
100301040131 |
100301040141 |
1 MVIS |
100331010271 |
100331010341 |
1 MVIS |
100331030481 |
100331030501 |
1 MVIS |
100341010081 |
100341010111 |
1 MVIS |
100341010121 |
100341010131 |
1 MVIS |
100341020052 |
100341020092 |
1 MVIS |
100341020102 |
100341020162 |
3 EROM |
100341020102 |
100341020172 |
3 EROM |
100341020202 |
100341020222 |
1 MVIS |
100351010071 |
100351010081 |
1 MVIS |
100351020011 |
100351020021 |
1 MVIS |
100351030061 |
100351030071 |
1 MVIS |
100351030061 |
100351030081 |
1 MVIS |
100351030091 |
100351030101 |
1 MVIS |
100351030091 |
100351030111 |
1 MVIS |
100351040181 |
100351040191 |
1 MVIS |
100351040181 |
100351040201 |
1 MVIS |
100391020011 |
100391020021 |
3 EROM |
100391020011 |
100391020031 |
3 EROM |
100401010401 |
100401010471 |
1 MVIS |
100401010411 |
100401010481 |
1 MVIS |
100401010411 |
100401010491 |
1 MVIS |
100401010411 |
100401010501 |
1 MVIS |
100401010411 |
100401010511 |
1 MVIS |
100401010411 |
100401010521 |
1 MVIS |
100401010411 |
100401010531 |
1 MVIS |
100401010411 |
100401010541 |
1 MVIS |
100401010411 |
100401010551 |
1 MVIS |
100401010411 |
100401010561 |
1 MVIS |
100401010411 |
100401010571 |
1 MVIS |
100401010411 |
100401010581 |
1 MVIS |
100401010411 |
100401010591 |
1 MVIS |
100401010411 |
100401010601 |
1 MVIS |
100401010411 |
100401010611 |
1 MVIS |
100401010411 |
100401010621 |
1 MVIS |
100401010411 |
100401010631 |
1 MVIS |
100401010411 |
100401010641 |
1 MVIS |
100401010411 |
100401010651 |
1 MVIS |
100401010411 |
100401010661 |
1 MVIS |
100401010411 |
100401010671 |
1 MVIS |
100401010411 |
100401010681 |
1 MVIS |
100401011031 |
100401011051 |
2 OPAT |
100401011031 |
100401011061 |
2 OPAT |
100401011031 |
100401011071 |
2 OPAT |
100401011031 |
100401011081 |
2 OPAT |
100401011031 |
100401011091 |
2 OPAT |
100401011031 |
100401011101 |
2 OPAT |
100401011031 |
100401011111 |
2 OPAT |
100401011031 |
100401011121 |
2 OPAT |
100401011031 |
100401011131 |
2 OPAT |
100401011031 |
100401011141 |
2 OPAT |
100401011031 |
100401011151 |
2 OPAT |
100401011031 |
100401011161 |
2 OPAT |
100431010151 |
100431010191 |
3 EROM |
100431010231 |
100431010271 |
1 MVIS |
100431010231 |
100431010281 |
1 MVIS |
100431010241 |
100431010291 |
1 MVIS |
100431010251 |
100431010301 |
5 DVIS |
100431010231 |
100431010311 |
5 DVIS |
100431010231 |
100431010321 |
5 DVIS |
100431010231 |
100431010331 |
5 DVIS |
100431020141 |
100431020151 |
1 MVIS |
100431010231 |
100431030191 |
1 MVIS |
100431010231 |
100431030201 |
1 MVIS |
100431030251 |
100431030271 |
1 MVIS |
100431030251 |
100431030281 |
1 MVIS |
100431030321 |
100431030331 |
1 MVIS |
100431030321 |
100431030341 |
1 MVIS |
100431030321 |
100431030351 |
1 MVIS |
100431040191 |
100431040221 |
1 MVIS |
100431040191 |
100431040231 |
1 MVIS |
100431040291 |
100431040321 |
1 MVIS |
100431040291 |
100431040331 |
1 MVIS |
100431040341 |
100431040371 |
1 MVIS |
100431040351 |
100431040381 |
1 MVIS |
100441010011 |
100441010041 |
1 MVIS |
100441010011 |
100441010071 |
1 MVIS |
100441010011 |
100441010081 |
1 MVIS |
100441010121 |
100441010131 |
1 MVIS |
100461030111 |
100461030211 |
1 MVIS |
100471010172 |
100471010212 |
1 MVIS |
100471020032 |
100471020042 |
5 DVIS |
100491020211 |
100491020221 |
3 EROM |
100531020371 |
100531020431 |
1 MVIS |
100531020371 |
100531020441 |
1 MVIS |
100531020371 |
100531020451 |
1 MVIS |
100531020371 |
100531020461 |
1 MVIS |
100531020391 |
100531020471 |
1 MVIS |
100531020391 |
100531020481 |
1 MVIS |
100531020391 |
100531020491 |
1 MVIS |
100531020391 |
100531020501 |
1 MVIS |
100531020751 |
100531020861 |
1 MVIS |
100531020751 |
100531020871 |
1 MVIS |
100531020751 |
100531020881 |
1 MVIS |
100531020751 |
100531020891 |
1 MVIS |
100531020761 |
100531020901 |
1 MVIS |
100531020761 |
100531020911 |
1 MVIS |
100531020761 |
100531020921 |
1 MVIS |
100531020761 |
100531020931 |
1 MVIS |
100531020811 |
100531020861 |
1 MVIS |
100531020811 |
100531020871 |
1 MVIS |
100531020811 |
100531020891 |
1 MVIS |
Return to Top
HC-144I. 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 |
100431030321 |
100431030331 |
1 MVIS |
100431030321 |
100431030341 |
1 MVIS |
100431030321 |
100431030351 |
1 MVIS |
100431040341 |
100431040371 |
1 MVIS |
100531040031 |
100531040051 |
1 MVIS |
100671020291 |
100671020371 |
1 MVIS |
100671020291 |
100671020381 |
1 MVIS |
100671020291 |
100671020391 |
1 MVIS |
100861020131 | 100861020141
1 MVIS |
100861020131 |
100861020151 |
1 MVIS |
100861020131 |
100861020161 |
1 MVIS |
100861020131 |
100861020171 |
1 MVIS |
100861020131 |
100861020181 |
1 MVIS |
100861020131 |
100861020191 |
1 MVIS |
100861020131 |
100861020201 |
1 MVIS |
100861020131 |
100861020211 |
1 MVIS |
100861020221 |
100861020231 |
1 MVIS |
100861020221 |
100861020241 |
1 MVIS |
100861020221 |
100861020251 |
1 MVIS |
100861020221 |
100861020261 |
1 MVIS |
100861020221 |
100861020271 |
1 MVIS |
100861020221 |
100861020281 |
1 MVIS |
100861020221 |
100861020291 |
1 MVIS |
100861020221 |
100861020301 |
1 MVIS |
100861020371 |
100861020381 |
1 MVIS |
100861020371 |
100861020391 |
1 MVIS |
100861020371 |
100861020401 |
1 MVIS |
100861020371 |
100861020411 |
1 MVIS |
100861020371 |
100861020421 |
1 MVIS |
100861020371 |
100861020431 |
1 MVIS |
100861020371 |
100861020441 |
1 MVIS |
100861020371 |
100861020451 |
1 MVIS |
100861020371 |
100861020461 |
1 MVIS |
100861020371 |
100861020471 |
1 MVIS |
100861020371 |
100861020481 |
1 MVIS |
100861020371 |
100861020501 |
1 MVIS |
101671020201 |
101671020211 |
1 MVIS |
101841030191 |
101841030201 |
1 MVIS |
101841030191 |
101841030211 |
1 MVIS |
101841030191 |
101841030221 |
1 MVIS |
101841030191 |
101841030231 |
1 MVIS |
101841030191 |
101841030241 |
1 MVIS |
101841030191 |
101841030251 |
1 MVIS |
102361030121 |
102361030141 |
1 MVIS |
102361030121 |
102361030151 |
1 MVIS |
102361030121 |
102361030161 |
1 MVIS |
102442010182 |
102442010192 |
1 MVIS |
102442010182 |
102442010202 |
1 MVIS |
102451010121 |
102451010141 |
1 MVIS |
102451010121 |
102451010151 |
1 MVIS |
Return to Top
HC-144I. Sample SAS Job for Example A - sample print of work.pmedids, sorted by linkidx
Obs |
EVNTIDX |
LINKIDX |
EVENTYPE |
1 |
100431030321 |
100431030331 |
1 MVIS |
2 |
100431030321 |
100431030341 |
1 MVIS |
3 |
100431030321 |
100431030351 |
1 MVIS |
4 |
100431040341 |
100431040371 |
1 MVIS |
5 |
100531040031 |
100531040051 |
1 MVIS |
6 |
100671020291 |
100671020371 |
1 MVIS |
7 |
100671020291 |
100671020381 |
1 MVIS |
8 |
100671020291 |
100671020391 |
1 MVIS |
9 |
100861020131 |
100861020141 |
1 MVIS |
10 |
100861020131 |
100861020151 |
1 MVIS |
11 |
100861020131 |
100861020161 |
1 MVIS |
12 |
100861020131 |
100861020171 |
1 MVIS |
13 |
100861020131 |
100861020181 |
1 MVIS |
14 |
100861020131 |
100861020191 |
1 MVIS |
15 |
100861020131 |
100861020201 |
1 MVIS |
16 |
100861020131 |
100861020211 |
1 MVIS |
17 |
100861020221 |
100861020231 |
1 MVIS |
18 |
100861020221 |
100861020241 |
1 MVIS |
19 |
100861020221 |
100861020251 |
1 MVIS |
20 |
100861020221 |
100861020261 |
1 MVIS |
21 |
100861020221 |
100861020271 |
1 MVIS |
22 |
100861020221 |
100861020281 |
1 MVIS |
23 |
100861020221 |
100861020291 |
1 MVIS |
24 |
100861020221 |
100861020301 |
1 MVIS |
25 |
100861020371 |
100861020381 |
1 MVIS |
26 |
100861020371 |
100861020391 |
1 MVIS |
27 |
100861020371 |
100861020401 |
1 MVIS |
28 |
100861020371 |
100861020411 |
1 MVIS |
29 |
100861020371 |
100861020421 |
1 MVIS |
30 |
100861020371 |
100861020431 |
1 MVIS |
31 |
100861020371 |
100861020441 |
1 MVIS |
32 |
100861020371 |
100861020451 |
1 MVIS |
33 |
100861020371 |
100861020461 |
1 MVIS |
34 |
100861020371 |
100861020471 |
1 MVIS |
35 |
100861020371 |
100861020481 |
1 MVIS |
36 |
100861020371 |
100861020501 |
1 MVIS |
37 |
101671020201 |
101671020211 |
1 MVIS |
38 |
101841030191 |
101841030201 |
1 MVIS |
39 |
101841030191 |
101841030211 |
1 MVIS |
40 |
101841030191 |
101841030221 |
1 MVIS |
41 |
101841030191 |
101841030231 |
1 MVIS |
42 |
101841030191 |
101841030241 |
1 MVIS |
43 |
101841030191 |
101841030251 |
1 MVIS |
44 |
102361030121 |
102361030141 |
1 MVIS |
45 |
102361030121 |
102361030151 |
1 MVIS |
46 |
102361030121 |
102361030161 |
1 MVIS |
47 |
102442010182 |
102442010192 |
1 MVIS |
48 |
102442010182 |
102442010202 |
1 MVIS |
49 |
102451010121 |
102451010141 |
1 MVIS |
50 |
102451010121 |
102451010151 |
1 MVIS |
Return to Top
HC-144I. Sample SAS Job for Example A - sample print of unique linkidxs in work.pmedids
Obs |
LINKIDX |
1 |
100431030331 |
2 |
100431030341 |
3 |
100431030351 |
4 |
100431040371 |
5 |
100531040051 |
6 |
100671020371 |
7 |
100671020381 |
8 |
100671020391 |
9 |
100861020141 |
10 |
100861020151 |
11 |
100861020161 |
12 |
100861020171 |
13 |
100861020181 |
14 |
100861020191 |
15 |
100861020201 |
16 |
100861020211 |
17 |
100861020231 |
18 |
100861020241 |
19 |
100861020251 |
20 |
100861020261 |
21 |
100861020271 |
22 |
100861020281 |
23 |
100861020291 |
24 |
100861020301 |
25 |
100861020381 |
26 |
100861020391 |
27 |
100861020401 |
28 |
100861020411 |
29 |
100861020421 |
30 |
100861020431 |
31 |
100861020441 |
32 |
100861020451 |
33 |
100861020461 |
34 |
100861020471 |
35 |
100861020481 |
36 |
100861020501 |
37 |
101671020211 |
38 |
101841030201 |
39 |
101841030211 |
40 |
101841030221 |
41 |
101841030231 |
42 |
101841030241 |
43 |
101841030251 |
44 |
102361030141 |
45 |
102361030151 |
46 |
102361030161 |
47 |
102442010192 |
48 |
102442010202 |
49 |
102451010141 |
50 |
102451010151 |
Return to Top
HC-144I. Sample SAS Job for Example A - sample print of work.mvpmeds PMED (HC-144A) records
for unique linkidxs in work.pmedids
LINKIDX |
RXRECIDX |
RXNAME |
RXXP11X |
PERWT11F |
100431030331 |
100431030331001 |
ALBUTEROL |
28.21 |
15760.520887 |
100431030341 |
100431030341001 |
CEFPROZIL |
37.64 |
15760.520887 |
100431030351 |
100431030351001 |
BUDESONIDE |
188.99 |
15760.520887 |
100431040371 |
100431040371001 |
PREDNISOLONE |
9.76 |
24198.068878 |
100531040051 |
100531040051001 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051002 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051003 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051004 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051005 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051006 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051007 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051008 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051009 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051010 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051011 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051012 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100671020371 |
100671020371001 |
Albuterol |
25.68 |
22181.886622 |
100671020371 |
100671020371002 |
Albuterol |
25.68 |
22181.886622 |
100671020371 |
100671020371003 |
Albuterol |
25.68 |
22181.886622 |
100671020371 |
100671020371004 |
Albuterol |
25.68 |
22181.886622 |
100671020371 |
100671020371005 |
Albuterol |
25.68 |
22181.886622 |
100671020381 |
100671020381001 |
BYSTOLIC |
148.00 |
22181.886622 |
100671020381 |
100671020381002 |
BYSTOLIC |
148.00 |
22181.886622 |
100671020381 |
100671020381003 |
BYSTOLIC |
98.00 |
22181.886622 |
100671020381 |
100671020381004 |
BYSTOLIC |
98.00 |
22181.886622 |
100671020381 |
100671020381005 |
BYSTOLIC |
98.00 |
22181.886622 |
100671020391 |
100671020391001 |
AMLODIPINE |
15.00 |
22181.886622 |
100671020391 |
100671020391002 |
AMLODIPINE |
15.00 |
22181.886622 |
100671020391 |
100671020391003 |
AMLODIPINE |
15.00 |
22181.886622 |
100671020391 |
100671020391004 |
AMLODIPINE |
15.00 |
22181.886622 |
100671020391 |
100671020391005 |
AMLODIPINE |
15.00 |
22181.886622 |
100861020141 |
100861020141001 |
LORATADINE |
4.90 |
5684.039049 |
100861020151 |
100861020151001 |
SINGULAIR |
143.99 |
5684.039049 |
100861020161 |
100861020161001 |
LIPITOR |
155.10 |
5684.039049 |
100861020171 |
100861020171001 |
JANUVIA |
202.62 |
5684.039049 |
100861020181 |
100861020181001 |
ADVAIR DISKU |
298.13 |
5684.039049 |
100861020191 |
100861020191001 |
ZETIA |
117.56 |
5684.039049 |
100861020201 |
100861020201001 |
LEVOTHYROXIN |
20.50 |
5684.039049 |
100861020211 |
100861020211001 |
CYCLOBENZAPR |
4.82 |
5684.039049 |
100861020231 |
100861020231001 |
LORATADINE |
4.78 |
5684.039049 |
100861020231 |
100861020231002 |
LORATADINE |
4.78 |
5684.039049
|
100861020241 |
100861020241001 |
SINGULAIR |
143.99 |
5684.039049 |
100861020241 |
100861020241002 |
SINGULAIR |
153.93 |
5684.039049 |
100861020251 |
100861020251001 |
METFORMIN |
5.26 |
5684.039049 |
100861020251 |
100861020251002 |
METFORMIN |
197.80 |
5684.039049 |
100861020261 |
100861020261001 |
GLIMEPIRIDE |
6.56 |
5684.039049 |
100861020261 |
100861020261002 |
GLIMEPIRIDE |
4.53 |
5684.039049 |
100861020271 |
100861020271001 |
JANUVIA |
217.67 |
5684.039049 |
100861020271 |
100861020271002 |
JANUVIA |
217.69 |
5684.039049 |
100861020281 |
100861020281001 |
LEVOTHYROXIN |
20.30 |
5684.039049 |
100861020281 |
100861020281002 |
LEVOTHYROXIN |
23.50 |
5684.039049 |
100861020291 |
100861020291001 |
AMOX/K CLAV |
20.00 |
5684.039049 |
100861020301 |
100861020301001 |
LISINOPRIL |
5.86 |
5684.039049 |
100861020381 |
100861020381001 |
LORATADINE |
4.78 |
5684.039049 |
100861020381 |
100861020381002 |
LORATADINE |
4.78 |
5684.039049 |
100861020381 |
100861020381003 |
LORATADINE |
4.78 |
5684.039049 |
100861020391 |
100861020391001 |
SINGULAIR |
153.93 |
5684.039049 |
100861020391 |
100861020391002 |
SINGULAIR |
153.93 |
5684.039049 |
100861020391 |
100861020391003 |
SINGULAIR |
153.93 |
5684.039049 |
100861020401 |
100861020401001 |
LIPITOR |
155.10 |
5684.039049 |
100861020401 |
100861020401002 |
LIPITOR |
155.10 |
5684.039049 |
100861020401 |
100861020401003 |
LIPITOR |
155.10 |
5684.039049 |
100861020411 |
100861020411001 |
METFORMIN |
6.40 |
5684.039049 |
100861020411 |
100861020411002 |
METFORMIN |
6.40 |
5684.039049 |
100861020411 |
100861020411003 |
METFORMIN |
6.40 |
5684.039049 |
100861020421 |
100861020421001 |
GLIMEPIRIDE |
6.56 |
5684.039049 |
100861020421 |
100861020421002 |
GLIMEPIRIDE |
4.53 |
5684.039049 |
100861020421 |
100861020421003 |
GLIMEPIRIDE |
6.56 |
5684.039049 |
100861020431 |
100861020431001 |
EPIDRIN |
12.89 |
5684.039049 |
100861020431 |
100861020431002 |
EPIDRIN |
12.89 |
5684.039049 |
100861020431 |
100861020431003 |
EPIDRIN |
12.89 |
5684.039049 |
100861020441 |
100861020441001 |
JANUVIA |
217.69 |
5684.039049 |
100861020441 |
100861020441002 |
JANUVIA |
217.69 |
5684.039049 |
100861020441 |
100861020441003 |
JANUVIA |
217.69 |
5684.039049 |
100861020451 |
100861020451001 |
PROAIR HFA |
42.68 |
5684.039049 |
100861020451 |
100861020451002 |
PROAIR HFA |
42.68 |
5684.039049 |
100861020451 |
100861020451003 |
PROAIR HFA |
42.68 |
5684.039049 |
100861020461 |
100861020461001 |
ADVAIR DISKU |
307.01 |
5684.039049 |
100861020461 |
100861020461002 |
ADVAIR DISKU |
307.01 |
5684.039049 |
100861020461 |
100861020461003 |
ADVAIR DISKU |
307.01 |
5684.039049 |
100861020471 |
100861020471001 |
LEVOTHYROXIN |
23.50 |
5684.039049 |
100861020471 |
100861020471002 |
LEVOTHYROXIN |
23.50 |
5684.039049 |
100861020471 |
100861020471003 |
LEVOTHYROXIN |
23.50 |
5684.039049 |
100861020481 |
100861020481001 |
CYCLOBENZAPR |
4.82 |
5684.039049 |
100861020481 |
100861020481002 |
CYCLOBENZAPR |
4.74 |
5684.039049 |
100861020481 |
100861020481003 |
CYCLOBENZAPR |
4.74 |
5684.039049 |
100861020501 |
100861020501001 |
LISINOPRIL |
5.86 |
5684.039049 |
100861020501 |
100861020501002 |
LISINOPRIL |
5.86 |
5684.039049 |
100861020501 |
100861020501003 |
LISINOPRIL |
5.86 |
5684.039049 |
101671020211 |
101671020211001 |
Advair |
200.10 |
18399.520261 |
101671020211 |
101671020211002 |
Advair |
200.10 |
18399.520261 |
101671020211 |
101671020211003 |
Advair |
200.10 |
18399.520261 |
101671020211 |
101671020211004 |
Advair |
200.10 |
18399.520261 |
101671020211 |
101671020211005 |
Advair |
200.10 |
18399.520261 |
101671020211 |
101671020211006 |
Advair |
200.10 |
18399.520261 |
101841030201 |
101841030201001 |
TRI-VITAMIN |
6.65 |
3531.737599 |
101841030201 |
101841030201002 |
TRI-VITAMIN |
6.65 |
3531.737599 |
101841030201 |
101841030201003 |
TRI-VITAMIN |
6.65 |
3531.737599 |
101841030201 |
101841030201004 |
TRI-VITAMIN |
6.65 |
3531.737599 |
101841030211 |
101841030211001 |
SALINE NASAL |
3.22 |
3531.737599 |
101841030211 |
101841030211002 |
SALINE NASAL |
3.22 |
3531.737599 |
101841030221 |
101841030221001 |
CHLD IBUPROF |
7.68 |
3531.737599 |
101841030231 |
101841030231001 |
FERROUS SULF |
6.40 |
3531.737599 |
101841030231 |
101841030231002 |
FERROUS SULF |
6.40 |
3531.737599 |
101841030231 |
101841030231003 |
FERROUS SULF |
6.40 |
3531.737599 |
101841030241 |
101841030241001 |
FLUTICASONE |
32.16 |
3531.737599 |
101841030241 |
101841030241002 |
FLUTICASONE |
32.24 |
3531.737599 |
101841030251 |
101841030251001 |
ALBUTEROL |
4.00 |
3531.737599 |
102361030141 |
102361030141001 |
PROAIR HFA |
38.98 |
16688.717984 |
102361030151 |
102361030151001 |
PREDNISONE |
1.66 |
16688.717984 |
102361030161 |
102361030161001 |
AZITHROMYCIN |
12.79 |
16688.717984 |
102442010192 |
102442010192001 |
proventil |
20.00 |
9663.838427 |
102442010202 |
102442010202001 |
QVAR |
100.14 |
9663.838427 |
102451010141 |
102451010141001 |
PROAIR HFA |
38.49 |
16986.298195 |
102451010141 |
102451010141002 |
PROAIR HFA |
38.49 |
16986.298195 |
102451010141 |
102451010141003 |
PROAIR HFA |
38.49 |
16986.298195 |
102451010141 |
102451010141004 |
PROAIR HFA |
38.32 |
16986.298195 |
102451010151 |
102451010151001 |
SINGULAIR |
373.30 |
16986.298195 |
104601040211 |
104601040211001 |
ADVAIR DISKU |
177.68 |
10121.908938 |
104601040211 |
104601040211002 |
ADVAIR DISKU |
177.68 |
10121.908938 |
104601040221 |
104601040221001 |
LEVOCETIRIZI |
78.21 |
10121.908938 |
104601040221 |
104601040221002 |
LEVOCETIRIZI |
71.12 |
10121.908938 |
104601040231 |
104601040231001 |
LANSOPRAZOLE |
120.75 |
10121.908938 |
104601040231 |
104601040231002 |
LANSOPRAZOLE |
120.75 |
10121.908938 |
104601050421 |
104601050421001 |
AMOXICILLIN |
11.50 |
12853.001484 |
104801010341 |
104801010341001 |
TRAZODONE |
2.73 |
4027.465897 |
104801010341 |
104801010341002 |
TRAZODONE |
2.73 |
4027.465897 |
104801010351 |
104801010351001 |
ZANAFLEX |
136.83 |
4027.465897 |
104801010351 |
104801010351002 |
ZANAFLEX |
136.83 |
4027.465897 |
104841010501 |
104841010501001 |
SYMBICORT |
223.62 |
20342.976240 |
104841010501 |
104841010501002 |
SYMBICORT |
223.62 |
20342.976240 |
104841010501 |
104841010501003 |
SYMBICORT |
223.62 |
20342.976240 |
104841010501 |
104841010501004 |
SYMBICORT |
223.62 |
20342.976240 |
104841010501 |
104841010501005 |
SYMBICORT |
223.62 |
20342.976240 |
104841010511 |
104841010511001 |
PROAIR HFA |
37.85 |
20342.976240 |
104841010511 |
104841010511002 |
PROAIR HFA |
37.85 |
20342.976240 |
104841010511 |
104841010511003 |
PROAIR HFA |
37.85 |
20342.976240 |
104841010511 |
104841010511004 |
PROAIR HFA |
37.85 |
20342.976240 |
104841010511 |
104841010511005 |
PROAIR HFA |
37.85 |
20342.976240 |
104841010521 |
104841010521001 |
Albuterol |
60.49 |
20342.976240 |
104841010521 |
104841010521002 |
Albuterol |
60.49 |
20342.976240 |
104841010521 |
104841010521003 |
Albuterol |
60.49 |
20342.976240 |
104841010521 |
104841010521004 |
Albuterol |
60.49 |
20342.976240 |
104841010521 |
104841010521005 |
Albuterol |
60.49 |
20342.976240 |
104841010531 |
104841010531001 |
TOPIRAMATE |
99.32 |
20342.976240 |
104841010531 |
104841010531002 |
TOPIRAMATE |
99.32 |
20342.976240 |
104841010531 |
104841010531003 |
TOPIRAMATE |
99.32 |
20342.976240 |
104841010541 |
104841010541001 |
MELOXICAM |
8.00 |
20342.976240 |
104841010541 |
104841010541002 |
MELOXICAM |
8.00 |
20342.976240 |
105241021041 |
105241021041001 |
DIGOXIN |
4.00 |
10112.153351 |
105241021041 |
105241021041002 |
DIGOXIN |
4.00 |
10112.153351 |
105241021041 |
105241021041003 |
DIGOXIN |
4.00 |
10112.153351 |
105241021041 |
105241021041004 |
DIGOXIN |
4.00 |
10112.153351 |
105241021051 |
105241021051001 |
LEXAPRO |
34.92 |
10112.153351 |
105241021061 |
105241021061001 |
WARFARIN |
24.63 |
10112.153351 |
105241021061 |
105241021061002 |
WARFARIN |
24.63 |
10112.153351 |
105241021061 |
105241021061003 |
WARFARIN |
24.63 |
10112.153351 |
105241021061 |
105241021061004 |
WARFARIN |
24.63 |
10112.153351 |
105241021071 |
105241021071001 |
KLOR-CON M20 |
21.35 |
10112.153351 |
105241021071 |
105241021071002 |
KLOR-CON M20 |
21.35 |
10112.153351 |
105241021081 |
105241021081001 |
Nasal Decongestant 0.05% Spray |
42.24 |
10112.153351 |
105241021091 |
105241021091001 |
CLONAZEPAM |
1.87 |
10112.153351 |
105241021091 |
105241021091002 |
CLONAZEPAM |
1.87 |
10112.153351 |
105241021091 |
105241021091003 |
CLONAZEPAM |
1.87 |
10112.153351 |
105241021091 |
105241021091004 |
CLONAZEPAM |
1.87 |
10112.153351 |
105241021091 |
105241021091005 |
CLONAZEPAM |
1.87 |
10112.153351 |
105241021091 |
105241021091006 |
CLONAZEPAM |
1.87 |
10112.153351 |
105241021091 |
105241021091007 |
CLONAZEPAM |
1.87 |
10112.153351 |
105241021091 |
105241021091008 |
CLONAZEPAM |
1.87 |
10112.153351 |
105241021091 |
105241021091009 |
CLONAZEPAM |
1.87 |
10112.153351 |
105241021101 |
105241021101001 |
ASMANEX 120 |
211.90 |
10112.153351 |
105241021101 |
105241021101002 |
ASMANEX 120 |
211.90 |
10112.153351 |
105241021101 |
105241021101003 |
ASMANEX 120 |
211.90 |
10112.153351 |
105241021101 |
105241021101004 |
ASMANEX 120 |
211.90 |
10112.153351 |
105241021101 |
105241021101005 |
ASMANEX 120 |
211.90 |
10112.153351 |
105241021101 |
105241021101006 |
ASMANEX 120 |
211.90 |
10112.153351 |
105241021101 |
105241021101007 |
ASMANEX 120 |
211.90 |
10112.153351 |
105241021101 |
105241021101008 |
ASMANEX 120 |
211.90 |
10112.153351 |
105241021111 |
105241021111001 |
METOPROLOL |
28.13 |
10112.153351 |
105241021111 |
105241021111002 |
METOPROLOL |
28.13 |
10112.153351 |
105241021121 |
105241021121001 |
ISOSORB MONO |
15.38 |
10112.153351 |
105241021121 |
105241021121002 |
ISOSORB MONO |
15.38 |
10112.153351 |
105241021121 |
105241021121003 |
ISOSORB MONO |
15.38 |
10112.153351 |
105241021121 |
105241021121004 |
ISOSORB MONO |
15.38 |
10112.153351 |
105241021121 |
105241021121005 |
ISOSORB MONO |
15.38 |
10112.153351 |
105241021121 |
105241021121006 |
ISOSORB MONO |
15.38 |
10112.153351 |
105241021121 |
105241021121007 |
ISOSORB MONO |
15.38 |
10112.153351 |
105241021131 |
105241021131001 |
FUROSEMIDE |
21.19 |
10112.153351 |
105241021131 |
105241021131002 |
FUROSEMIDE |
10.00 |
10112.153351 |
105241021141 |
105241021141001 |
LISINOPRIL |
10.62 |
10112.153351 |
105241021141 |
105241021141002 |
LISINOPRIL |
10.62 |
10112.153351 |
105241021141 |
105241021141003 |
LISINOPRIL |
10.62 |
10112.153351 |
105241021151 |
105241021151001 |
FLUTICASONE |
8.24 |
10112.153351 |
105241021151 |
105241021151002 |
FLUTICASONE |
8.24 |
10112.153351 |
105241021151 |
105241021151003 |
FLUTICASONE |
8.24 |
10112.153351 |
105241021151 |
105241021151004 |
FLUTICASONE |
8.24 |
10112.153351 |
105241021161 |
105241021161001 |
METOPROLOL |
277.90 |
10112.153351 |
105241021161 |
105241021161002 |
METOPROLOL |
277.90 |
10112.153351 |
105241021171 |
105241021171001 |
ADVAIR DISKU |
287.20 |
10112.153351 |
105241021171 |
105241021171002 |
ADVAIR DISKU |
287.20 |
10112.153351 |
Return to Top
HC-144I. Sample SAS Job for Example A - Total Rx expenditures associated with medical
visits (excluding telephone) for asthma, analysis variable: RXXP11X SUM OF PAYMENTS RXSF11X-RXOU11X(IMPUTED)
N |
Sum |
5023 |
426067.16 |
Return to Top
HC-144I. Sample SAS Job for Example A - Total Rx expenditures associated with medical
visits (excluding telephone) for asthma, weighted analysis variable: RXXP11X SUM OF PAYMENTS RXSF11X-RXOU11X(IMPUTED)
N |
Sum |
5023 |
4491412403 |
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.90 seconds
cpu time 0.12 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-144I";
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.04 seconds
cpu time 0.03 seconds
26
27
*--------------------------------------------------------------------------------------
28 * Get condition records coded as asthma.
29
*--------------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H146 (KEEP=CONDIDX CCCODEX);
32 IF CCCODEX="128";
33 RUN;
NOTE: There were 108619 observations read from the
data set IN.H146.
NOTE: The data set WORK.ASCONDS has 2327
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 3.22 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 23270 observations read from the
data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2327
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 (H146) 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.04 seconds
44
45 PROC SORT DATA=IN.H144IF1 OUT=CLNK; BY CONDIDX;
RUN;
NOTE: There were 306663 observations read from the
data set IN.H144IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 306663
observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 3.05 seconds
cpu time 0.43 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 306663 observations read from the
data set WORK.CLNK.
NOTE: There were 2327 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7004
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.09 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.01 seconds
61
62 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7004 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 7004
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 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 7004 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6998
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 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.00 seconds
cpu time 0.00 seconds
79
80
*-------------------------------------------------------------------------------
81 * Get PMED records linked to asthma condition
records.
82
*-------------------------------------------------------------------------------;
83 PROC SORT DATA=IN.H144A OUT=PMED; BY LINKIDX;
RUN;
NOTE: There were 313747 observations read from the
data set IN.H144A.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.PMED has 313747
observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 7.58 seconds
cpu time 0.60 seconds
84
85 DATA ASPMEDS;
86 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP11X
PERWT11F)
87 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX
RENAME=(EVNTIDX=LINKIDX));
88 BY LINKIDX;
89 IF INASCLNK & PERWT11F>0;
90 RUN;
NOTE: There were 313747 observations read from the
data set WORK.PMED.
NOTE: There were 6998 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 10349
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.12 seconds
91
92 proc print data=aspmeds (obs=300);
93 by linkidx;
94 id linkidx;
95 var rxrecidx rxname RXXP11X PERWT11F;
96 title3 "sample print of work.aspmeds";
97 title4 "PMED (HC-144A) 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.04 seconds
cpu time 0.03 seconds
99
100 PROC MEANS DATA=ASPMEDS N SUM;
101 VAR RXXP11X;
102 TITLE3 "Total Rx expenditures associated with
asthma";
103 RUN;
NOTE: Multiple concurrent threads will be used to
summarize data.
NOTE: There were 10349 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 RXXP11X;
107 WEIGHT PERWT11F;
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 10349 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 18.17 seconds
cpu time 1.84 seconds
Return to Top
HC-144I. Sample SAS Job for Example B - sample print of work.asconds, sorted by condidx
COND (H146) 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 |
100671010071 |
128 |
10 |
100671020041 |
128 |
11 |
100861020041 |
128 |
12 |
101171050011 |
128 |
13 |
101231030011 |
128 |
14 |
101311020041 |
128 |
15 |
101371010051 |
128 |
16 |
101671020011 |
128 |
17 |
101831050011 |
128 |
18 |
101841020091 |
128 |
19 |
101841030031 |
128 |
20 |
101841030061 |
128 |
21 |
101981020061 |
128 |
22 |
101981030051 |
128 |
23 |
101981040031 |
128 |
24 |
101981050011 |
128 |
25 |
102061010011 |
128 |
26 |
102061040011 |
128 |
27 |
102291020011 |
128 |
28 |
102331020021 |
128 |
29 |
102361030011 |
128 |
30 |
102361040011 |
128 |
31 |
102421010041 |
128 |
32 |
102442010032 |
128 |
33 |
102451010021 |
128 |
34 |
102451030011 |
128 |
35 |
102531020011 |
128 |
36 |
102781020031 |
128 |
37 |
102891010051 |
128 |
38 |
102891020021 |
128 |
39 |
102991050011 |
128 |
40 |
102991060011 |
128 |
41 |
103031010041 |
128 |
42 |
103051020011 |
128 |
43 |
103101010031 |
128 |
44 |
103151020011 |
128 |
45 |
103371010011 |
128 |
46 |
103581010041 |
128 |
47 |
103611020011 |
128 |
48 |
103691010021 |
128 |
49 |
103701010091 |
128 |
50 |
103851040011 |
128 |
Return to Top
HC-144I. Sample SAS Job for Example B - sample print of work.asclnks, sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
100121010051 |
100121010111 |
8 PMED |
100121010051 |
100121010151 |
8 PMED |
100121010051 |
100121010201 |
8 PMED |
100121010051 |
100121010231 |
8 PMED |
100171010021 |
100171010231 |
8 PMED |
100171010021 |
100171010271 |
8 PMED |
100431010021 |
100431010201 |
8 PMED |
100171010021 |
100431010271 |
8 PMED |
100431030011 |
100431030281 |
8 PMED |
100431030011 |
100431030311 |
2 OPAT |
100431030011 |
100431030321 |
1 MVIS |
100431030011 |
100431030331 |
8 PMED |
100431030011 |
100431030351 |
8 PMED |
100431040011 |
100431040231 |
8 PMED |
100431040011 |
100431040321 |
8 PMED |
100431040011 |
100431040341 |
1 MVIS |
100431040011 |
100431040361 |
2 OPAT |
100431040011 |
100431040371 |
8 PMED |
100441010031 |
100441010181 |
8 PMED |
100441010031 |
100441010191 |
8 PMED |
100441010031 |
100441010201 |
8 PMED |
100441010031 |
100441010211 |
1 MVIS |
100531020041 |
100531020361 |
8 PMED |
100531020041 |
100531020511 |
8 PMED |
100531020041 |
100531020521 |
8 PMED |
100531020041 |
100531020531 |
8 PMED |
100531040011 |
100531040021 |
8 PMED |
100531040011 |
100531040031 |
1 MVIS |
100531040011 |
100531040051 |
8 PMED |
100531040011 |
100531040091 |
8 PMED |
100671010071 |
100671010511 |
8 PMED |
100671010071 |
100671010521 |
8 PMED |
100671010071 |
100671010531 |
8 PMED |
100671010071 |
100671010681 |
8 PMED |
100671010071 |
100671010701 |
2 OPAT |
100671010071 |
100671010811 |
8 PMED |
100671010071 |
100671010821 |
8 PMED |
100671010071 |
100671010831 |
8 PMED |
100671020041 |
100671020291 |
1 MVIS |
100671020041 |
100671020301 |
1 MVIS |
100671020041 |
100671020311 |
1 MVIS |
100671020041 |
100671020371 |
8 PMED |
100671020041 |
100671020401 |
8 PMED |
100671020041 |
100671020411 |
8 PMED |
100671020041 |
100671020601 |
8 PMED |
100671020041 |
100671020611 |
8 PMED |
100861020041 |
100861020131 |
1 MVIS |
100861020041 |
100861020141 |
8 PMED |
100861020041 |
100861020151 |
8 PMED |
100861020041 |
100861020181 |
8 PMED |
100861020041 |
100861020221 |
1 MVIS |
100861020041 |
100861020241 |
8 PMED |
100861020041 |
100861020291 |
8 PMED |
100861020041 |
100861020371 |
1 MVIS |
100861020041 |
100861020391 |
8 PMED |
100861020041 |
100861020411 |
8 PMED |
100861020041 |
100861020451 |
8 PMED |
100861020041 |
100861020461 |
8 PMED |
100861020041 |
100861020511 |
1 MVIS |
100861020041 |
100861020521 |
1 MVIS |
101231030011 |
101231030121 |
8 PMED |
101371010051 |
101371010481 |
8 PMED |
101671020011 |
101671020201 |
1 MVIS |
101671020011 |
101671020211 |
8 PMED |
101831050011 |
101831050031 |
8 PMED |
101841020091 |
101841020381 |
8 PMED |
101841020091 |
101841020411 |
2 OPAT |
101841020091 |
101841020421 |
2 OPAT |
101841020091 |
101841020521 |
8 PMED |
101841020091 |
101841020551 |
8 PMED |
101841020091 |
101841020691 |
8 PMED |
101841020091 |
101841020721 |
8 PMED |
101841020091 |
101841020731 |
8 PMED |
101841020091 |
101841020761 |
8 PMED |
101841020091 |
101841020791 |
2 OPAT |
Return to Top
HC-144I. Sample SAS Job for Example B - sample print of work.asclnks, sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
100121010051 |
100121010111 |
8 PMED |
2 |
100121010051 |
100121010151 |
8 PMED |
3 |
100121010051 |
100121010201 |
8 PMED |
4 |
100121010051 |
100121010231 |
8 PMED |
5 |
100171010021 |
100171010231 |
8 PMED |
6 |
100171010021 |
100171010271 |
8 PMED |
7 |
100431010021 |
100431010201 |
8 PMED |
8 |
100431010021 |
100431010271 |
8 PMED |
9 |
100431030011 |
100431030281 |
8 PMED |
10 |
100431030011 |
100431030311 |
2 OPAT |
11 |
100431030011 |
100431030321 |
1 MVIS |
12 |
100431030011 |
100431030331 |
8 PMED |
13 |
100431030011 |
100431030351 |
8 PMED |
14 |
100431040011 |
100431040231 |
8 PMED |
15 |
100431040011 |
100431040321 |
8 PMED |
16 |
100431040011 |
100431040341 |
1 MVIS |
17 |
100431040011 |
100431040361 |
2 OPAT |
18 |
100431040011 |
100431040371 |
8 PMED |
19 |
100441010031 |
100441010181 |
8 PMED |
20 |
100441010031 |
100441010191 |
8 PMED |
21 |
100441010031 |
100441010201 |
8 PMED |
22 |
100441010031 |
100441010211 |
1 MVIS |
23 |
100531020041 |
100531020361 |
8 PMED |
24 |
100531020041 |
100531020511 |
8 PMED |
25 |
100531020041 |
100531020521 |
8 PMED |
26 |
100531020041 |
100531020531 |
8 PMED |
27 |
100531040011 |
100531040021 |
8 PMED |
28 |
100531040011 |
100531040031 |
1 MVIS |
29 |
100531040011 |
100531040051 |
8 PMED |
30 |
100531040011 |
100531040091 |
8 PMED |
31 |
100671010071 |
100671010511 |
8 PMED |
32 |
100671010071 |
100671010521 |
8 PMED |
33 |
100671010071 |
100671010531 |
8 PMED |
34 |
100671010071 |
100671010681 |
8 PMED |
35 |
100671010071 |
100671010701 |
2 OPAT |
36 |
100671010071 |
100671010811 |
8 PMED |
37 |
100671010071 |
100671010821 |
8 PMED |
38 |
100671010071 |
100671010831 |
8 PMED |
39 |
100671020041 |
100671020291 |
1 MVIS |
40 |
100671020041 |
100671020301 |
1 MVIS |
41 |
100671020041 |
100671020311 |
1 MVIS |
42 |
100671020041 |
100671020371 |
8 PMED |
43 |
100671020041 |
100671020401 |
8 PMED |
44 |
100671020041 |
100671020411 |
8 PMED |
45 |
100671020041 |
100671020601 |
8 PMED |
46 |
100671020041 |
100671020611 |
8 PMED |
47 |
100861020041 |
100861020131 |
1 MVIS |
48 |
100861020041 |
100861020141 |
8 PMED |
49 |
100861020041 |
100861020151 |
8 PMED |
50 |
100861020041 |
100861020181 |
8 PMED |
Return to Top
HC-144I. Sample SAS Job for Example B - sample print of unique evntidxs from
work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
100121010111 |
8 PMED |
2 |
100121010151 |
8 PMED |
3 |
100121010201 |
8 PMED |
4 |
100121010231 |
8 PMED |
5 |
100171010231 |
8 PMED |
6 |
100171010271 |
8 PMED |
7 |
100431010201 |
8 PMED |
8 |
100431010271 |
8 PMED |
9 |
100431030281 |
8 PMED |
10 |
100431030311 |
2 OPAT |
11 |
100431030321 |
1 MVIS |
12 |
100431030331 |
8 PMED |
13 |
100431030351 |
8 PMED |
14 |
100431040231 |
8 PMED |
15 |
100431040321 |
8 PMED |
16 |
100431040341 |
1 MVIS |
17 |
100431040361 |
2 OPAT |
18 |
100431040371 |
8 PMED |
19 |
100441010181 |
8 PMED |
20 |
100441010191 |
8 PMED |
21 |
100441010201 |
8 PMED |
22 |
100441010211 |
1 MVIS |
23 |
100531020361 |
8 PMED |
24 |
100531020511 |
8 PMED |
25 |
100531020521 |
8 PMED |
26 |
100531020531 |
8 PMED |
27 |
100531040021 |
8 PMED |
28 |
100531040031 |
1 MVIS |
29 |
100531040051 |
8 PMED |
30 |
100531040091 |
8 PMED |
31 |
100671010511 |
8 PMED |
32 |
100671010521 |
8 PMED |
33 |
100671010531 |
8 PMED |
34 |
100671010681 |
8 PMED |
35 |
100671010701 |
2 OPAT |
36 |
100671010811 |
8 PMED |
37 |
100671010821 |
8 PMED |
38 |
100671010831 |
8 PMED |
39 |
100671020291 |
1 MVIS |
40 |
100671020301 |
1 MVIS |
41 |
100671020311 |
1 MVIS |
42 |
100671020371 |
8 PMED |
43 |
100671020401 |
8 PMED |
44 |
100671020411 |
8 PMED |
45 |
100671020601 |
8 PMED |
46 |
100671020611 |
8 PMED |
47 |
100861020131 |
1 MVIS |
48 |
100861020141 |
8 PMED |
49 |
100861020151 |
8 PMED |
50 |
100861020181 |
8 PMED |
Return to Top
HC-144I. Sample SAS Job for Example B - sample print of work.aspmeds PMED (HC-144A) records
which link to condition records coded as asthma
LINKIDX |
RXRECIDX |
RXNAME |
RXXP11X |
PERWT11F |
100121010111 |
100121010111001 |
COMBIVENT |
472.04 |
15410.497988 |
100121010111 |
100121010111002 |
COMBIVENT |
472.04 |
15410.497988 |
100121010151 |
100121010151001 |
COMBIVENT |
472.04 |
15410.497988 |
100121010201 |
100121010201001 |
COMBIVENT |
472.04 |
15410.497988 |
100121010201 |
100121010201002 |
COMBIVENT |
472.04 |
15410.497988 |
100121010201 |
100121010201003 |
COMBIVENT |
472.04 |
15410.497988 |
100121010201 |
100121010201004 |
COMBIVENT |
472.04 |
15410.497988 |
100121010201 |
100121010201005 |
COMBIVENT |
472.04 |
15410.497988 |
100121010231 |
100121010231001 |
COMBIVENT |
528.45 |
15410.497988 |
100121010231 |
100121010231002 |
COMBIVENT |
528.45 |
15410.497988 |
100121010231 |
100121010231003 |
COMBIVENT |
528.45 |
15410.497988 |
100121010231 |
100121010231004 |
COMBIVENT |
591.62 |
15410.497988 |
100121010231 |
100121010231005 |
COMBIVENT |
591.62 |
15410.497988 |
100171010231 |
100171010231001 |
ADVAIR DISKU |
235.38 |
11412.260194 |
100171010231 |
100171010231002 |
ADVAIR DISKU |
235.91 |
11412.260194 |
100171010231 |
100171010231003 |
ADVAIR DISKU |
235.91 |
11412.260194 |
100171010231 |
100171010231004 |
ADVAIR DISKU |
235.91 |
11412.260194 |
100171010231 |
100171010231005 |
ADVAIR DISKU |
235.91 |
11412.260194 |
100171010271 |
100171010271001 |
ADVAIR DISKU |
242.40 |
11412.260194 |
100431010201 |
100431010201001 |
ADVAIR DISKU |
182.97 |
17531.434658 |
100431010271 |
100431010271001 |
ADVAIR DISKU |
142.68 |
17531.434658 |
100431010271 |
100431010271002 |
ADVAIR DISKU |
182.97 |
17531.434658 |
100431030281 |
100431030281001 |
PREDNISOLONE |
7.00 |
15760.520887 |
100431030331 |
100431030331001 |
ALBUTEROL |
28.21 |
15760.520887 |
100431030351 |
100431030351001 |
BUDESONIDE |
188.99 |
15760.520887 |
100431040231 |
100431040231001 |
SILDEC PE-DM |
6.02 |
24198.068878 |
100431040321 |
100431040321001 |
ALBUTEROL |
34.86 |
24198.068878 |
100431040321 |
100431040321002 |
ALBUTEROL |
34.86 |
24198.068878 |
100431040371 |
100431040371001 |
PREDNISOLONE |
9.76 |
24198.068878 |
100441010181 |
100441010181001 |
PULMO-AIDE |
60.00 |
2346.180578 |
100441010191 |
100441010191001 |
VENTOLIN HFA |
51.99 |
2346.180578 |
100441010201 |
100441010201001 |
SYMBICORT |
220.61 |
2346.180578 |
100531020361 |
100531020361001 |
VENTOLIN HFA |
26.21 |
2895.143262 |
100531020361 |
100531020361002 |
VENTOLIN HFA |
26.21 |
2895.143262 |
100531020511 |
100531020511001 |
VENTOLIN HFA |
26.21 |
2895.143262 |
100531020511 |
100531020511002 |
VENTOLIN HFA |
26.21 |
2895.143262 |
100531020511 |
100531020511003 |
VENTOLIN HFA |
26.52 |
2895.143262 |
100531020511 |
100531020511004 |
VENTOLIN HFA |
26.52 |
2895.143262 |
100531020521 |
100531020521001 |
ADVAIR DISKU |
88.29 |
2895.143262 |
100531020521 |
100531020521002 |
ADVAIR DISKU |
88.29 |
2895.143262 |
100531020521 |
100531020521003 |
ADVAIR DISKU |
88.29 |
2895.143262 |
100531020521 |
100531020521004 |
ADVAIR DISKU |
88.29 |
2895.143262 |
100531020531 |
100531020531001 |
SINGULAIR |
59.79 |
2895.143262 |
100531020531 |
100531020531002 |
SINGULAIR |
59.79 |
2895.143262 |
100531020531 |
100531020531003 |
SINGULAIR |
59.79 |
2895.143262 |
100531020531 |
100531020531004 |
SINGULAIR |
59.79 |
2895.143262 |
100531040021 |
100531040021001 |
VENTOLIN HFA |
53.04 |
3003.827686 |
100531040021 |
100531040021002 |
VENTOLIN HFA |
53.04 |
3003.827686 |
100531040021 |
100531040021003 |
VENTOLIN HFA |
53.04 |
3003.827686 |
100531040051 |
100531040051001 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051002 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051003 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051004 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051005 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051006 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051007 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051008 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051009 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051010 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051011 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040051 |
100531040051012 |
VENTOLIN HFA |
38.07 |
3003.827686 |
100531040091 |
100531040091001 |
VENTOLIN HFA |
37.01 |
3003.827686 |
100531040091 |
100531040091002 |
VENTOLIN HFA |
37.01 |
3003.827686 |
100671010511 |
100671010511001 |
SEREVENT DIS |
173.62 |
16602.023865 |
100671010511 |
100671010511002 |
SEREVENT DIS |
173.62 |
16602.023865 |
100671010511 |
100671010511003 |
SEREVENT DIS |
173.62 |
16602.023865 |
100671010511 |
100671010511004 |
SEREVENT DIS |
173.62 |
16602.023865 |
100671010511 |
100671010511005 |
SEREVENT DIS |
173.62 |
16602.023865 |
100671010521 |
100671010521001 |
BUDESONIDE |
315.07 |
16602.023865 |
100671010521 |
100671010521002 |
BUDESONIDE |
270.78 |
16602.023865 |
100671010521 |
100671010521003 |
BUDESONIDE |
239.10 |
16602.023865 |
100671010521 |
100671010521004 |
BUDESONIDE |
239.10 |
16602.023865 |
100671010521 |
100671010521005 |
BUDESONIDE |
291.40 |
16602.023865 |
100671010531 |
100671010531001 |
ALBUTEROL |
18.60 |
16602.023865 |
100671010521 |
100671010531002 |
ALBUTEROL |
22.90 |
16602.023865 |
100671010521 |
100671010531003 |
ALBUTEROL |
22.90 |
16602.023865 |
100671010521 |
100671010531004 |
ALBUTEROL |
22.90 |
16602.023865 |
100671010521 |
100671010531005 |
ALBUTEROL |
18.60 |
16602.023865 |
100671010681 |
100671010681001 |
ALBUTEROL |
208.63 |
16602.023865 |
100671010681 |
100671010681002 |
ALBUTEROL |
208.63 |
16602.023865 |
100671010681 |
100671010681003 |
ALBUTEROL |
208.63 |
16602.023865 |
100671010811 |
100671010811001 |
SEREVENT DIS |
40.00 |
16602.023865 |
100671010811 |
100671010811002 |
SEREVENT DIS |
40.00 |
16602.023865 |
100671010811 |
100671010811003 |
SEREVENT DIS |
40.00 |
16602.023865 |
100671010811 |
100671010811004 |
SEREVENT DIS |
40.00 |
16602.023865 |
100671010821 |
100671010821001 |
BUDESONIDE |
296.68 |
16602.023865 |
100671010821 |
100671010821002 |
BUDESONIDE |
284.83 |
16602.023865 |
100671010821 |
100671010821003 |
BUDESONIDE |
284.83 |
16602.023865 |
100671010821 |
100671010821004 |
BUDESONIDE |
253.15 |
16602.023865 |
100671010831 |
100671010831001 |
ALBUTEROL |
208.63 |
16602.023865 |
100671010831 |
100671010831002 |
ALBUTEROL |
208.63 |
16602.023865 |
100671010831 |
100671010831003 |
ALBUTEROL |
208.63 |
16602.023865 |
100671020371 |
100671020371001 |
Albuterol |
25.68 |
22181.886622 |
100671020371 |
100671020371002 |
Albuterol |
25.68 |
22181.886622 |
100671020371 |
100671020371003 |
Albuterol |
25.68 |
22181.886622 |
100671020371 |
100671020371004 |
Albuterol |
25.68 |
22181.886622 |
100671020371 |
100671020371005 |
Albuterol |
25.68 |
22181.886622 |
100671020401 |
100671020401001 |
SPIRIVA |
227.98 |
22181.886622 |
100671020401 |
100671020401002 |
SPIRIVA |
248.38 |
22181.886622 |
100671020411 |
100671020411001 |
SYMBICORT |
377.35 |
22181.886622 |
100671020411 |
100671020411002 |
SYMBICORT |
377.35 |
22181.886622 |
100671020411 |
100671020411003 |
SYMBICORT |
377.35 |
22181.886622 |
100671020411 |
100671020411004 |
SYMBICORT |
377.35 |
22181.886622 |
100671020411 |
100671020411005 |
SYMBICORT |
377.35 |
22181.886622 |
100671020601 |
100671020601001 |
SPIRIVA |
576.20 |
22181.886622 |
100671020601 |
100671020601002 |
SPIRIVA |
576.20 |
22181.886622 |
100671020601 |
100671020601003 |
SPIRIVA |
576.20 |
22181.886622 |
100671020601 |
100671020601004 |
SPIRIVA |
576.20 |
22181.886622 |
100671020611 |
100671020611001 |
SYMBICORT |
377.35 |
22181.886622 |
100671020601 |
100671020611002 |
SYMBICORT |
377.35 |
22181.886622 |
100671020601 |
100671020611003 |
SYMBICORT |
377.35 |
22181.886622 |
100671020601 |
100671020611004 |
SYMBICORT |
377.35 |
22181.886622 |
100861020141 |
100861020141001 |
LORATADINE |
4.90 |
5684.039049 |
100861020151 |
100861020151001 |
SINGULAIR |
143.99 |
5684.039049 |
100861020181 |
100861020181001 |
ADVAIR DISKU |
298.13 |
5684.039049 |
100861020241 |
100861020241001 |
SINGULAIR |
143.99 |
5684.039049 |
100861020241 |
100861020241002 |
SINGULAIR |
153.93 |
5684.039049 |
100861020291 |
100861020291001 |
AMOX/K CLAV |
20.00 |
5684.039049 |
100861020391 |
100861020391001 |
SINGULAIR |
153.93 |
5684.039049 |
100861020391 |
100861020391002 |
SINGULAIR |
153.93 |
5684.039049 |
100861020391 |
100861020391003 |
SINGULAIR |
153.93 |
5684.039049 |
100861020411 |
100861020411001 |
METFORMIN |
6.40 |
5684.039049 |
100861020411 |
100861020411002 |
METFORMIN |
6.40 |
5684.039049 |
100861020411 |
100861020411003 |
METFORMIN |
6.40 |
5684.039049 |
100861020451 |
100861020451001 |
PROAIR HFA |
42.68 |
5684.039049 |
100861020451 |
100861020451002 |
PROAIR HFA |
42.68 |
5684.039049 |
100861020451 |
100861020451003 |
PROAIR HFA |
42.68 |
5684.039049 |
100861020461 |
100861020461001 |
ADVAIR DISKU |
307.01 |
5684.039049 |
100861020461 |
100861020461002 |
ADVAIR DISKU |
307.01 |
5684.039049 |
100861020461 |
100861020461003 |
ADVAIR DISKU |
307.01 |
5684.039049 |
101231030121 |
101231030121001 |
Albuterol |
66.75 |
14137.147831 |
101371010481 |
101371010481001 |
Albuterol 90mcg (Ventolin) Aerosol |
7.00 |
2790.187377 |
101671020211 |
101671020211001 |
Advair |
200.10 |
18399.520261 |
101671020211 |
101671020211002 |
Advair |
200.10 |
18399.520261 |
101671020211 |
101671020211003 |
Advair |
200.10 |
18399.520261 |
101671020211 |
101671020211004 |
Advair |
200.10 |
18399.520261 |
101671020211 |
101671020211005 |
Advair |
200.10 |
18399.520261 |
101671020211 |
101671020211006 |
Advair |
200.10 |
18399.520261 |
101831050031 |
101831050031001 |
SINGULAIR |
170.70 |
4481.061057 |
101671020211 |
101831050031002 |
SINGULAIR |
165.99 |
4481.061057 |
101671020211 |
101831050031003 |
SINGULAIR |
154.99 |
4481.061057 |
101671020211 |
101831050031004 |
SINGULAIR |
165.99 |
4481.061057 |
101841020381 |
101841020381001 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020521 |
101841020521001 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020521 |
101841020521002 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020521 |
101841020521003 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020551 |
101841020551001 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020551 |
101841020551002 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020551 |
101841020551003 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020691 |
101841020691001 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020691 |
101841020691002 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020691 |
101841020691003 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020721 |
101841020721001 |
FLUTICASONE |
32.24 |
2661.284010 |
101841020721 |
101841020721002 |
FLUTICASONE |
32.24 |
2661.284010 |
101841020721 |
101841020721003 |
FLUTICASONE |
32.24 |
2661.284010 |
101841020721 |
101841020721004 |
FLUTICASONE |
32.24 |
2661.284010 |
101841020731 |
101841020731001 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020731 |
101841020731002 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020731 |
101841020731003 |
Ventolin HFA |
13.95 |
2661.284010 |
101841020761 |
101841020761001 |
SINGULAIR |
125.71 |
2661.284010 |
101841020761 |
101841020761002 |
SINGULAIR |
137.81 |
2661.284010 |
101841020761 |
101841020761003 |
SINGULAIR |
137.81 |
2661.284010 |
101841030211 |
101841030211001 |
SALINE NASAL |
3.22 |
3531.737599 |
101841030211 |
101841030211002 |
SALINE NASAL |
3.22 |
3531.737599 |
101841030241 |
101841030241001 |
FLUTICASONE |
32.16 |
3531.737599 |
101841030241 |
101841030241002 |
FLUTICASONE |
32.24 |
3531.737599 |
101841030251 |
101841030251001 |
ALBUTEROL |
4.00 |
3531.737599 |
101841030301 |
101841030301001 |
ALBUTEROL |
4.00 |
3531.737599 |
101841030301 |
101841030301002 |
ALBUTEROL |
12.80 |
3531.737599 |
101841030301 |
101841030301003 |
ALBUTEROL |
12.80 |
3531.737599 |
101841030301 |
101841030301004 |
ALBUTEROL |
12.80 |
3531.737599 |
101841030331 |
101841030331001 |
SINGULAIR |
148.01 |
3531.737599 |
101841030331 |
101841030331002 |
SINGULAIR |
148.01 |
3531.737599 |
101841030341 |
101841030341001 |
FLOVENT HFA |
107.57 |
3531.737599 |
101841030341 |
101841030341002 |
FLOVENT HFA |
105.65 |
3531.737599 |
101841030341 |
101841030341003 |
FLOVENT HFA |
107.57 |
3531.737599 |
102061010071 |
102061010071001 |
ADVAIR DISKU |
177.69 |
9457.398981 |
102061010081 |
102061010081001 |
ADVAIR DISKU |
177.69 |
9457.398981 |
102061040151 |
102061040151001 |
ALBUTEROL |
10.38 |
8857.206471 |
102061040151 |
102061040151002 |
ALBUTEROL |
10.38 |
8857.206471 |
102291020101 |
102291020101001 |
Albuterol Sulfate |
75.51 |
11009.454983 |
102331020321 |
102331020321001 |
PROAIR HFA |
52.99 |
25550.818294 |
102361030141 |
102361030141001 |
PROAIR HFA |
38.98 |
16688.717984 |
102361030151 |
102361030151001 |
PREDNISONE |
1.66 |
16688.717984 |
102361030161 |
102361030161001 |
AZITHROMYCIN |
12.79 |
16688.717984 |
102421010231 |
102421010231001 |
COMBIVENT |
313.77 |
2849.223082 |
102421010231 |
102421010231002 |
COMBIVENT |
313.77 |
2849.223082 |
102421010231 |
102421010231003 |
COMBIVENT |
313.77 |
2849.223082 |
102421010271 |
102421010271001 |
ADVAIR |
54.99 |
2849.223082 |
102421010271 |
102421010271002 |
ADVAIR |
54.99 |
2849.223082 |
102421010271 |
102421010271003 |
ADVAIR |
54.99 |
2849.223082 |
102421010271 |
102421010271004 |
ADVAIR |
54.99 |
2849.223082 |
102421010401 |
102421010401001 |
PROVENTIL HFA |
36.72 |
2849.223082 |
102421010401 |
102421010401002 |
PROVENTIL HFA |
36.72 |
2849.223082 |
102421010401 |
102421010401003 |
PROVENTIL HFA |
31.96 |
2849.223082 |
102421010401 |
102421010401004 |
PROVENTIL HFA |
31.96 |
2849.223082 |
102421010471 |
102421010471001 |
ADVAIR |
60.00 |
2849.223082 |
102421010471 |
102421010471002 |
ADVAIR |
60.00 |
2849.223082 |
102421010471 |
102421010471003 |
ADVAIR DISKUS |
60.00 |
2849.223082 |
102421010471 |
102421010471004 |
ADVAIR DISKUS |
60.00 |
2849.223082 |
102442010192 |
102442010192001 |
proventil |
20.00 |
9663.838427 |
102442010202 |
102442010202001 |
QVAR |
100.14 |
9663.838427 |
102451010101 |
102451010101001 |
PROAIR HFA |
30.00 |
16986.298195 |
102451010101 |
102451010101002 |
PROAIR HFA |
38.49 |
16986.298195 |
102451010111 |
102451010111001 |
SINGULAIR |
339.68 |
16986.298195 |
102451010141 |
102451010141001 |
PROAIR HFA |
38.49 |
16986.298195 |
102451010141 |
102451010141002 |
PROAIR HFA |
38.49 |
16986.298195 |
102451010141 |
102451010141003 |
PROAIR HFA |
38.49 |
16986.298195 |
102451010141 |
102451010141004 |
PROAIR HFA |
38.32 |
16986.298195 |
102451010151 |
102451010151001 |
SINGULAIR |
373.30 |
16986.298195 |
102451010161 |
102451010161001 |
PROAIR HFA |
38.32 |
16986.298195 |
102451010161 |
102451010161002 |
PROAIR HFA |
30.00 |
16986.298195 |
102451010161 |
102451010161003 |
PROAIR HFA |
30.00 |
16986.298195 |
102451010171 |
102451010171001 |
SINGULAIR |
397.67 |
16986.298195 |
102531020271 |
102531020271001 |
ADVAIR HFA |
295.78 |
23546.114105 |
102781020271 |
102781020271001 |
SYMBICORT |
209.50 |
12872.436195 |
102781020271 |
102781020271002 |
SYMBICORT |
209.13 |
12872.436195 |
102781020331 |
102781020331001 |
Albuterol |
60.49 |
12872.436195 |
102781020331 |
102781020331002 |
Albuterol |
60.49 |
12872.436195 |
102781020331 |
102781020331003 |
Albuterol |
60.49 |
12872.436195 |
102781020331 |
102781020331004 |
Albuterol |
60.49 |
12872.436195 |
102891020041 |
102891020041001 |
VENTOLIN HFA |
37.49 |
2000.026751 |
102891020051 |
102891020051001 |
ADVAIR DISKU |
184.00 |
2000.026751 |
102991050091 |
102991050091001 |
PROVENTIL HFA |
36.72 |
5714.140416 |
102991050091 |
102991050091002 |
PROVENTIL HFA |
36.72 |
5714.140416 |
102991060091 |
102991060091001 |
MULTIVITAMIN |
2.42 |
4575.712714 |
102991060091 |
102991060091002 |
MULTIVITAMIN |
2.42 |
4575.712714 |
102991060091 |
102991060091003 |
MULTIVITAMIN |
2.42 |
4575.712714 |
103101010411 |
103101010411001 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010411 |
103101010411002 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010411 |
103101010411003 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010411 |
103101010411004 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010411 |
103101010411005 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010411 |
103101010411006 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010411 |
103101010411007 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010411 |
103101010411008 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010411 |
103101010411009 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010411 |
103101010411010 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010411 |
103101010411011 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010411 |
103101010411012 |
Albuterol 90mcg (Ventolin) Aerosol |
45.25 |
10928.136096 |
103101010431 |
103101010431001 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103101010431 |
103101010431002 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103101010431 |
103101010431003 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103101010431 |
103101010431004 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103101010431 |
103101010431005 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103101010431 |
103101010431006 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103101010431 |
103101010431007 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103101010431 |
103101010431008 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103101010431 |
103101010431009 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103101010431 |
103101010431010 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103101010431 |
103101010431011 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103101010431 |
103101010431012 |
MOMETASONE FUROATE |
39.34 |
10928.136096 |
103371010331 |
103371010331001 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103101010431 |
103371010331002 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010431 |
103371010431001 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010431 |
103371010431002 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010431 |
103371010431003 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010431 |
103371010431004 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010431 |
103371010431005 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010431 |
103371010431006 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010431 |
103371010431007 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010451 |
103371010451001 |
LORATADINE-D |
5.79 |
6405.174784 |
103371010451 |
103371010451002 |
LORATADINE-D |
5.79 |
6405.174784 |
103371010451 |
103371010451003 |
LORATADINE-D |
5.79 |
6405.174784 |
103371010451 |
103371010451004 |
LORATADINE-D |
5.79 |
6405.174784 |
103371010451 |
103371010451005 |
LORATADINE-D |
5.79 |
6405.174784 |
103371010541 |
103371010541001 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010541 |
103371010541002 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010541 |
103371010541003 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010541 |
103371010541004 |
ADVAIR DISKU |
227.99 |
6405.174784 |
103371010561 |
103371010561001 |
LORATADINE-D |
5.79 |
6405.174784 |
103371010561 |
103371010561002 |
LORATADINE-D |
5.79 |
6405.174784 |
103371010561 |
103371010561003 |
LORATADINE-D |
5.79 |
6405.174784 |
103371010561 |
103371010561004 |
LORATADINE-D |
5.79 |
6405.174784 |
103581010631 |
103581010631001 |
QVAR |
88.93 |
10035.253919 |
103581010661 |
103581010661001 |
Albuterol |
60.49 |
10035.253919 |
103581010661 |
103581010661002 |
Albuterol |
60.49 |
10035.253919 |
103581010811 |
103581010811001 |
PROAIR HFA |
37.61 |
10035.253919 |
103701010231 |
103701010231001 |
SYMBICORT |
211.05 |
14916.079260 |
103701010231 |
103701010231002 |
SYMBICORT |
211.05 |
14916.079260 |
103701010231 |
103701010231003 |
SYMBICORT |
211.05 |
14916.079260 |
103701010231 |
103701010231004 |
SYMBICORT |
105.11 |
14916.079260 |
103701010231 |
103701010231005 |
SYMBICORT |
211.05 |
14916.079260 |
103701010231 |
103701010231006 |
SYMBICORT |
211.05 |
14916.079260 |
103851040102 |
103851040102001 |
PREDNISONE |
2.64 |
14149.156705 |
103851040202 |
103851040202001 |
SYMBICORT |
178.48 |
14149.156705 |
103851040202 |
103851040202002 |
SYMBICORT |
178.48 |
14149.156705 |
103851040202 |
103851040202003 |
SYMBICORT |
178.48 |
14149.156705 |
103851040202 |
103851040202004 |
SYMBICORT |
178.48 |
14149.156705 |
103851040202 |
103851040202005 |
SYMBICORT |
178.48 |
14149.156705 |
103861010251 |
103861010251001 |
ALLEGRA |
62.73 |
7789.062469 |
103861010251 |
103861010251002 |
ALLEGRA |
62.73 |
7789.062469 |
104011010251 |
104011010251001 |
Albuterol 90mcg (Ventolin) Aerosol |
7.00 |
4351.198513 |
104011010421 |
104011010421001 |
PROVENTIL HFA |
36.72 |
4351.198513 |
104011010421 |
104011010421002 |
PROVENTIL HFA |
36.72 |
4351.198513 |
104011010541 |
104011010541001 |
PROVENTIL HFA |
36.72 |
4351.198513 |
104011010541 |
104011010541002 |
PROVENTIL HFA |
36.72 |
4351.198513 |
104251010371 |
104251010371001 |
Albuterol |
19.00 |
36282.551033 |
104251010371 |
104251010371002 |
Albuterol |
19.00 |
36282.551033 |
104251010381 |
104251010381001 |
ADVAIR DISKU |
232.78 |
36282.551033 |
Return to Top
HC-144I. Sample SAS Job for Example B - Total Rx expenditures associated with asthma,
analysis variable: RXXP11X SUM OF PAYMENTS RXSF11X-RXOU11X(IMPUTED)
N |
Sum |
10349 |
1397673.25 |
Return to Top
HC-144I. Sample SAS Job for Example B - Total Rx expenditures associated with asthma,
weighted analysis variable: RXXP11X SUM OF PAYMENTS RXSF11X-RXOU11X(IMPUTED)
N |
Sum |
10349 |
14313079052 |
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.93 seconds
cpu time 0.20 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:\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-144I";
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.01 seconds
cpu time 0.01 seconds
26
27
*-----------------------------------------------------------------------------------
28 * Get conditions records coded as asthma.
29
*-----------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H146 (KEEP=CONDIDX CCCODEX);
32 IF CCCODEX="128";
33 RUN;
NOTE: There were 108619 observations read from the
data set IN.H146.
NOTE: The data set WORK.ASCONDS has 2327
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 3.27 seconds
cpu time 0.06 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 2327 observations read from the
data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2327
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 (H146) 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.04 seconds
44
45 PROC SORT DATA=IN.H144IF1 OUT=CLNK; BY CONDIDX;
RUN;
NOTE: There were 306663 observations read from the
data set IN.H144IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 306663
observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 3.02 seconds
cpu time 0.45 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 306663 observations read from the
data set WORK.CLNK.
NOTE: There were 2327 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7004
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.09 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 7004 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 7004
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 7004 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6998
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 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.00 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.H144G (KEEP=EVNTIDX PERWT11F SEETLKPV
OBXP110X);
85 IF PERWT11F > 0 & SEETLKPV NE 2;
86 RUN;
NOTE: There were 134311 observations read from the
data set IN.H144G.
NOTE: The data set WORK.MVIS has 130464
observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 9.59 seconds
cpu time 0.20 seconds
87
88 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 130464 observations read from the
data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 130464
observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.09 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 6998 observations read from the
data set WORK.ASCLNKS.
NOTE: There were 130464 observations read from the
data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1858
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 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-144G) 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 OBXP11X;
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 1858 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.03 seconds
cpu time 0.03 seconds
110
111 PROC MEANS DATA=ASMVIS N SUM;
112 VAR OBXP11X;
113 WEIGHT PERWT11F;
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 1858 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 20.00 seconds
cpu time 1.45 seconds
Return to Top
HC-144I. Sample SAS Job for Example C - sample print of work.asconds, sorted by condidx
COND (H146) 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 |
100671010071 |
128 |
10 |
100671020041 |
128 |
11 |
100861020041 |
128 |
12 |
101171050011 |
128 |
13 |
101231030011 |
128 |
14 |
101311020041 |
128 |
15 |
101371010051 |
128 |
16 |
101671020011 |
128 |
17 |
101831050011 |
128 |
18 |
101841020091 |
128 |
19 |
101841030031 |
128 |
20 |
101841030061 |
128 |
21 |
101981020061 |
128 |
22 |
101981030051 |
128 |
23 |
101981040031 |
128 |
24 |
101981050011 |
128 |
25 |
102061010011 |
128 |
26 |
102061040011 |
128 |
27 |
102291020011 |
128 |
28 |
102331020021 |
128 |
29 |
102361030011 |
128 |
30 |
102361040011 |
128 |
31 |
102421010041 |
128 |
32 |
102442010032 |
128 |
33 |
102451010021 |
128 |
34 |
102451030011 |
128 |
35 |
102531020011 |
128 |
36 |
102781020031 |
128 |
37 |
102891010051 |
128 |
38 |
102891020021 |
128 |
39 |
102991050011 |
128 |
40 |
102991060011 |
128 |
41 |
103031010041 |
128 |
42 |
103051020011 |
128 |
43 |
103101010031 |
128 |
44 |
103151020011 |
128 |
45 |
103371010011 |
128 |
46 |
103581010041 |
128 |
47 |
103611020011 |
128 |
48 |
103691010021 |
128 |
49 |
103701010091 |
128 |
50 |
103851040011 |
128 |
Return to Top
HC-144I. Sample SAS Job for Example C - sample print of work.asclnks, sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
100121010051 |
100121010111 |
8 PMED |
100121010051 |
100121010151 |
8 PMED |
100121010051 |
100121010201 |
8 PMED |
100121010051 |
100121010231 |
8 PMED |
100171010021 |
100171010231 |
8 PMED |
100171010021 |
100171010271 |
8 PMED |
100431010021 |
100431010201 |
8 PMED |
100431010021 |
100431010271 |
8 PMED |
100431030011 |
100431030281 |
8 PMED |
100431030011 |
100431030311 |
2 OPAT |
100431030011 |
100431030321 |
1 MVIS |
100431030011 |
100431030331 |
8 PMED |
100431030011 |
100431030351 |
8 PMED |
100431040011 |
100431040231 |
8 PMED |
100431040011 |
100431040321 |
8 PMED |
100431040011 |
100431040341 |
1 MVIS |
100431040011 |
100431040361 |
2 OPAT |
100431040011 |
100431040371 |
8 PMED |
100441010031 |
100441010181 |
8 PMED |
100441010031 |
100441010191 |
8 PMED |
100441010031 |
100441010201 |
8 PMED |
100441010031 |
100441010211 |
1 MVIS |
100531020041 |
100531020361 |
8 PMED |
100531020041 |
100531020511 |
8 PMED |
100531020041 |
100531020521 |
8 PMED |
100531020041 |
100531020531 |
8 PMED |
100531040011 |
100531040021 |
8 PMED |
100531040011 |
100531040031 |
1 MVIS |
100531040011 |
100531040051 |
8 PMED |
100531040011 |
100531040091 |
8 PMED |
100671010071 |
100671010511 |
8 PMED |
100671010071 |
100671010521 |
8 PMED |
100671010071 |
100671010531 |
8 PMED |
100671010071 |
100671010681 |
8 PMED |
100671010071 |
100671010701 |
2 OPAT |
100671010071 |
100671010811 |
8 PMED |
100671010071 |
100671010821 |
8 PMED |
100671010071 |
100671010831 |
8 PMED |
100671020041 |
100671020291 |
1 MVIS |
100671020041 |
100671020301 |
1 MVIS |
100671020041 |
100671020311 |
1 MVIS |
100671020041 |
100671020371 |
8 PMED |
100671020041 |
100671020401 |
8 PMED |
100671020041 |
100671020411 |
8 PMED |
100671020041 |
100671020601 |
8 PMED |
100671020041 |
100671020611 |
8 PMED |
100861020041 |
100861020131 |
1 MVIS |
100861020041 |
100861020141 |
8 PMED |
100861020041 |
100861020151 |
8 PMED |
100861020041 |
100861020181 |
8 PMED |
100861020041 |
100861020221 |
1 MVIS |
100861020041 |
100861020241 |
8 PMED |
100861020041 |
100861020291 |
8 PMED |
100861020041 |
100861020371 |
1 MVIS |
100861020041 |
100861020391 |
8 PMED |
100861020041 |
100861020411 |
8 PMED |
100861020041 |
100861020451 |
8 PMED |
100861020041 |
100861020461 |
8 PMED |
100861020041 |
100861020511 |
1 MVIS |
100861020041 |
100861020521 |
1 MVIS |
101231030011 |
101231030121 |
8 PMED |
101371010051 |
101371010481 |
8 PMED |
101671020011 |
101671020201 |
1 MVIS |
101671020011 |
101671020211 |
8 PMED |
101831050011 |
101831050031 |
8 PMED |
101841020091 |
101841020381 |
8 PMED |
101841020091 |
101841020411 |
2 OPAT |
101841020091 |
101841020421 |
2 OPAT |
101841020091 |
101841020521 |
8 PMED |
101841020091 |
101841020551 |
8 PMED |
101841020091 |
101841020691 |
8 PMED |
101841020091 |
101841020721 |
8 PMED |
101841020091 |
101841020731 |
8 PMED |
101841020091 |
101841020761 |
8 PMED |
101841020091 |
101841020791 |
2 OPAT |
Return to Top
HC-144I. Sample SAS Job for Example C - sample print of work.asclnks, sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
100121010051 |
100121010111 |
8 PMED |
2 |
100121010051 |
100121010151 |
8 PMED |
3 |
100121010051 |
100121010201 |
8 PMED |
4 |
100121010051 |
100121010231 |
8 PMED |
5 |
100171010021 |
100171010231 |
8 PMED |
6 |
100171010021 |
100171010271 |
8 PMED |
7 |
100431010021 |
100431010201 |
8 PMED |
8 |
100431010021 |
100431010271 |
8 PMED |
9 |
100431030011 |
100431030281 |
8 PMED |
10 |
100431030011 |
100431030311 |
2 OPAT |
11 |
100431030011 |
100431030321 |
1 MVIS |
12 |
100431030011 |
100431030331 |
8 PMED |
13 |
100431030011 |
100431030351 |
8 PMED |
14 |
100431040011 |
100431040231 |
8 PMED |
15 |
100431040011 |
100431040321 |
8 PMED |
16 |
100431040011 |
100431040341 |
1 MVIS |
17 |
100431040011 |
100431040361 |
2 OPAT |
18 |
100431040011 |
100431040371 |
8 PMED |
19 |
100441010031 |
100441010181 |
8 PMED |
20 |
100441010031 |
100441010191 |
8 PMED |
21 |
100441010031 |
100441010201 |
8 PMED |
22 |
100441010031 |
100441010211 |
1 MVIS |
23 |
100531020041 |
100531020361 |
8 PMED |
24 |
100531020041 |
100531020511 |
8 PMED |
25 |
100531020041 |
100531020521 |
8 PMED |
26 |
100531020041 |
100531020531 |
8 PMED |
27 |
100531040011 |
100531040021 |
8 PMED |
28 |
100531040011 |
100531040031 |
1 MVIS |
29 |
100531040011 |
100531040051 |
8 PMED |
30 |
100531040011 |
100531040091 |
8 PMED |
31 |
100671010071 |
100671010511 |
8 PMED |
32 |
100671010071 |
100671010521 |
8 PMED |
33 |
100671010071 |
100671010531 |
8 PMED |
34 |
100671010071 |
100671010681 |
8 PMED |
35 |
100671010071 |
100671010701 |
2 OPAT |
36 |
100671010071 |
100671010811 |
8 PMED |
37 |
100671010071 |
100671010821 |
8 PMED |
38 |
100671010071 |
100671010831 |
8 PMED |
39 |
100671020041 |
100671020291 |
1 MVIS |
40 |
100671020041 |
100671020301 |
1 MVIS |
41 |
100671020041 |
100671020311 |
1 MVIS |
42 |
100671020041 |
100671020371 |
8 PMED |
43 |
100671020041 |
100671020401 |
8 PMED |
44 |
100671020041 |
100671020411 |
8 PMED |
45 |
100671020041 |
100671020601 |
8 PMED |
46 |
100671020041 |
100671020611 |
8 PMED |
47 |
100861020041 |
100861020131 |
1 MVIS |
48 |
100861020041 |
100861020141 |
8 PMED |
49 |
100861020041 |
100861020151 |
8 PMED |
50 |
100861020041 |
100861020181 |
8 PMED |
Return to Top
HC-144I. Sample SAS Job for Example C - sample print of unique evntidxs from work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
100121010111 |
8 PMED |
2 |
100121010151 |
8 PMED |
3 |
100121010201 |
8 PMED |
4 |
100121010231 |
8 PMED |
5 |
100171010231 |
8 PMED |
6 |
100171010271 |
8 PMED |
7 |
100431010201 |
8 PMED |
8 |
100431010271 |
8 PMED |
9 |
100431030281 |
8 PMED |
10 |
100431030311 |
2 OPAT |
11 |
100431030321 |
1 MVIS |
12 |
100431030331 |
8 PMED |
13 |
100431030351 |
8 PMED |
14 |
100431040231 |
8 PMED |
15 |
100431040321 |
8 PMED |
16 |
100431040341 |
1 MVIS |
17 |
100431040361 |
2 OPAT |
18 |
100431040371 |
8 PMED |
19 |
100441010181 |
8 PMED |
20 |
100441010191 |
8 PMED |
21 |
100441010201 |
8 PMED |
22 |
100441010211 |
1 MVIS |
23 |
100531020361 |
8 PMED |
24 |
100531020511 |
8 PMED |
25 |
100531020521 |
8 PMED |
26 |
100531020531 |
8 PMED |
27 |
100531040021 |
8 PMED |
28 |
100531040031 |
1 MVIS |
29 |
100531040051 |
8 PMED |
30 |
100531040091 |
8 PMED |
31 |
100671010511 |
8 PMED |
32 |
100671010521 |
8 PMED |
33 |
100671010531 |
8 PMED |
34 |
100671010681 |
8 PMED |
35 |
100671010701 |
2 OPAT |
36 |
100671010811 |
8 PMED |
37 |
100671010821 |
8 PMED |
38 |
100671010831 |
8 PMED |
39 |
100671020291 |
1 MVIS |
40 |
100671020301 |
1 MVIS |
41 |
100671020311 |
1 MVIS |
42 |
100671020371 |
8 PMED |
43 |
100671020401 |
8 PMED |
44 |
100671020411 |
8 PMED |
45 |
100671020601 |
8 PMED |
46 |
100671020611 |
8 PMED |
47 |
100861020131 |
1 MVIS |
48 |
100861020141 |
8 PMED |
49 |
100861020151 |
8 PMED |
50 |
100861020181 |
8 PMED |
Return to Top
HC-144I. Sample SAS Job for Example C - sample print of work.asmvis unique evntidxs from
work.asclnks that are non-telephone MVIS (HC-144G) events
Obs |
EVNTIDX |
EVENTYPE |
SEETLKPV |
OBXP11X |
PERWT11F |
1 |
100431030321 |
1 MVIS |
1 |
105.76 |
15760.52 |
2 |
100431040341 |
1 MVIS |
1 |
105.76 |
24198.07 |
3 |
100441010211 |
1 MVIS |
1 |
110.00 |
2346.18 |
4 |
100531040031 |
1 MVIS |
1 |
101.50 |
3003.83 |
5 |
100671020291 |
1 MVIS |
1 |
308.00 |
22181.89 |
6 |
100671020301 |
1 MVIS |
1 |
0.00 |
22181.89 |
7 |
100671020311 |
1 MVIS |
1 |
0.00 |
22181.89 |
8 |
100861020131 |
1 MVIS |
1 |
70.00 |
5684.04 |
9 |
100861020221 |
1 MVIS |
1 |
52.00 |
5684.04 |
10 |
100861020371 |
1 MVIS |
1 |
17.55 |
5684.04 |
11 |
100861020511 |
1 MVIS |
1 |
17.55 |
5684.04 |
12 |
100861020521 |
1 MVIS |
1 |
149.52 |
5684.04 |
13 |
101671020201 |
1 MVIS |
1 |
367.12 |
18399.52 |
14 |
101841030191 |
1 MVIS |
1 |
0.00 |
3531.74 |
15 |
102361030121 |
1 MVIS |
1 |
151.91 |
16688.72 |
16 |
102442010182 |
1 MVIS |
1 |
50.00 |
9663.84 |
17 |
102451010121 |
1 MVIS |
1 |
65.00 |
16986.30 |
18 |
103581010591 |
1 MVIS |
1 |
168.76 |
10035.25 |
19 |
104011010381 |
1 MVIS |
1 |
80.93 |
4351.20 |
20 |
104601040181 |
1 MVIS |
1 |
202.55 |
10121.91 |
21 |
104601050361 |
1 MVIS |
1 |
111.33 |
12853.00 |
22 |
104601050371 |
1 MVIS |
1 |
111.33 |
12853.00 |
23 |
104601050381 |
1 MVIS |
1 |
74.22 |
12853.00 |
24 |
104801010201 |
1 MVIS |
1 |
134.73 |
4027.47 |
25 |
104801010211 |
1 MVIS |
1 |
134.73 |
4027.47 |
26 |
104801010221 |
1 MVIS |
1 |
134.73 |
4027.47 |
27 |
104801010321 |
1 MVIS |
1 |
117.51 |
4027.47 |
28 |
104841010461 |
1 MVIS |
1 |
423.00 |
20342.98 |
29 |
104841010471 |
1 MVIS |
1 |
0.00 |
20342.98 |
30 |
105241020971 |
1 MVIS |
1 |
105.22 |
10112.15 |
31 |
105241020981 |
1 MVIS |
1 |
339.92 |
10112.15 |
32 |
105241020991 |
1 MVIS |
1 |
105.22 |
10112.15 |
33 |
105241021001 |
1 MVIS |
1 |
0.00 |
10112.15 |
34 |
105241021011 |
1 MVIS |
1 |
3670.80 |
10112.15 |
35 |
105241021201 |
1 MVIS |
1 |
105.22 |
10112.15 |
36 |
105241040441 |
1 MVIS |
1 |
25.00 |
10083.91 |
37 |
105721010861 |
1 MVIS |
1 |
89.80 |
17196.20 |
38 |
105721010871 |
1 MVIS |
1 |
89.80 |
17196.20 |
39 |
105721010881 |
1 MVIS |
1 |
89.80 |
17196.20 |
40 |
106121010081 |
1 MVIS |
1 |
102.45 |
2293.70 |
41 |
106181070081 |
1 MVIS |
1 |
80.01 |
5811.61 |
42 |
106771030011 |
1 MVIS |
1 |
8.80 |
9013.37 |
43 |
106951010031 |
1 MVIS |
1 |
99.00 |
21524.42 |
44 |
107031040021 |
1 MVIS |
1 |
121.49 |
7348.41 |
45 |
107031040061 |
1 MVIS |
1 |
121.49 |
7348.41 |
46 |
107251040112 |
1 MVIS |
1 |
60.42 |
12885.00 |
47 |
108351020521 |
1 MVIS |
1 |
75.97 |
22246.49 |
48 |
108411010251 |
1 MVIS |
1 |
2405.15 |
3190.04 |
49 |
108851010011 |
1 MVIS |
1 |
157.25 |
3906.54 |
50 |
109001050131 |
1 MVIS |
1 |
122.84 |
23352.22 |
Return to Top
HC-144I. Sample SAS Job for Example C - Total medical visit expenditures (excluding telephone)
associated with asthma analysis variable: OBXP11X SUM OF OBSF11X - OBOT11X (IMPUTED)
N |
Sum |
1858 |
281565.16 |
Return to Top
HC-144I. Sample SAS Job for Example C - Total medical visit expenditures (excluding telephone)
associated with asthma, weighted analysis variable: OBXP11X SUM OF OBSXF11X - OBOT11X (IMPUTED)
N |
Sum |
1858 |
2996204062 |
Return to Top
|