MEPS HC-118I: Attachment 2
Sample SAS Jobs for Linking Example| << previous
page
The SAS System
NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
Licensed to WESTAT INC, Site 70006348.
NOTE: This session is executing on the XP_PRO platform.
NOTE: SAS initialization used:
real time 0.68 seconds
cpu time 0.40 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.00 seconds
cpu time 0.00 seconds
I:\SASTRACE\TRACE92\
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.03 seconds
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-118I";
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.09 seconds
cpu time 0.03 seconds
28
29
*-------------------------------------------------------------------------------------
30 * Get condition records coded as asthma.
31
*-------------------------------------------------------------------------------------;
32 DATA ASCONDS;
33 SET IN.H120 (KEEP=CONDIDX CCCODEX);
34 IF CCCODEX="128";
35
36 RUN;
NOTE: There were 102169 observations read from the
data set IN.H120.
NOTE: The data set WORK.ASCONDS has 2100
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.46 seconds
cpu time 0.01 seconds
37
38
*------------------------------------------------------------------------------------
39 * Get the events linked to each of the asthma
condition records.
40
*------------------------------------------------------------------------------------;
41 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 2100 observations read from the
data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2100
observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
42
43 proc print data=asconds (obs=50);
44 title3 "sample print of work.asconds - sorted by
condidx";
45 title4 "COND (H120) 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.25 seconds
cpu time 0.03 seconds
47
48 PROC SORT DATA=IN.H118IF1 OUT=CLNK; BY CONDIDX;
RUN;
NOTE: There were 294294 observations read from the
data set IN.H118IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 294294
observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 5.07 seconds
cpu time 0.31 seconds
49
50 DATA ASCLNKS;
51 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX
EVENTYPE)
52 ASCONDS(IN=INASCOND KEEP=CONDIDX);
53 BY CONDIDX;
54 IF INCLNK & INASCOND;
55 RUN;
NOTE: There were 294294 observations read from the
data set WORK.CLNK.
NOTE: There were 2100 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 6546
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds
56
57 proc print data=asclnks (obs=75);
58 by condidx;
59 id condidx;
60 format eventype eventype.;
61 title3 "sample print of work.asclnks - sorted by
condidx";
62 title4 "events linked to asthma condition
records";
63 run;
NOTE: There were 75 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.73 seconds
cpu time 0.03 seconds
64
65 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 6546 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 6546
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
66
67 proc print data=asclnks (obs=50);
68 format eventype eventype.;
69 title3 "sample print of work.asclnks - sorted by
evntidx";
70 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.20 seconds
cpu time 0.01 seconds
71
72 DATA ASCLNKS;
73 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
74 BY EVNTIDX;
75 IF FIRST.EVNTIDX;
76 RUN;
NOTE: There were 6546 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6543
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 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.H118G (KEEP=EVNTIDX PERWT08F SEETLKPV);
88 IF PERWT08F > 0 & SEETLKPV NE 2;
89 RUN;
NOTE: There were 136460 observations read from the
data set IN.H118G.
NOTE: The data set WORK.MVIS has 132104
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 1.31 seconds
cpu time 0.07 seconds
90
91 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 132104 observations read from the
data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 132104
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.06 seconds
cpu time 0.09 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 6543 observations read from the
data set WORK.ASCLNKS.
NOTE: There were 132104 observations read from the
data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1842
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.03 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-118G) 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.20 seconds
cpu time 0.00 seconds
108
109
*-------------------------------------------------------------------------------------
110 * Get PMED IDs linked to the MVIS events which
were for asthma.
111
*-------------------------------------------------------------------------------------;
112 PROC SORT DATA=IN.H118IF2 OUT=RXLK; BY EVNTIDX;
RUN;
NOTE: There were 54857 observations read from the
data set IN.H118IF2.
NOTE: SAS sort was used.
NOTE: The data set WORK.RXLK has 54857 observations
and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.15 seconds
cpu time 0.04 seconds
113
114 proc print data=rxlk (obs=140);
115 by evntidx;
116 id evntidx;
117 var linkidx eventype;
118 format eventype eventype.;
119 title3 "sample print of work.rxlk - sorted by
evntidx";
120 title4 "Rx+event link file records
(HC-118IF2)";
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.37 seconds
cpu time 0.01 seconds
122
123 DATA PMEDIDS;
124 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX
EVENTYPE)
125 ASMVIS(IN=INASMVIS KEEP=EVNTIDX);
126 BY EVNTIDX;
127 IF INRXLK & INASMVIS;
128 RUN;
NOTE: There were 54857 observations read from the
data set WORK.RXLK.
NOTE: There were 1842 observations read from the
data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 1894
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
129
130 proc print data=pmedids (obs=50);
131 by evntidx;
132 id evntidx;
133 format eventype eventype.;
134 title3 "sample print of work.pmedids - sorted
by evntidx";
135 title4 "work.rxlk records for evntidxs in
work.asmvis";
136 run;
NOTE: There were 50 observations read from the data
set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed pages 12-13.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
137
138 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 1894 observations read from the
data set WORK.PMEDIDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.PMEDIDS has 1894
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 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.00 seconds
144
145 DATA PMEDIDS;
146 SET PMEDIDS (KEEP=LINKIDX);
147 BY LINKIDX;
148 IF FIRST.LINKIDX;
149 RUN;
NOTE: There were 1894 observations read from the
data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1794
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.03 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.H118A OUT=PMED; BY LINKIDX;
RUN;
NOTE: There were 293379 observations read from the
data set IN.H118A.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.PMED has 293379
observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 10.82 seconds
cpu time 0.64 seconds
159
160 DATA MVPMEDS;
161 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP08X
PERWT08F RXNAME)
162 PMEDIDS (IN=A);
163 BY LINKIDX;
164 IF A;
165 RUN;
NOTE: There were 293379 observations read from the
data set WORK.PMED.
NOTE: There were 1794 observations read from the
data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 4544
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.09 seconds
166
167 proc print data=mvpmeds (obs=200);
168 var rxrecidx rxname RXXP08X PERWT08F;
169 by linkidx;
170 id linkidx;
171 title3 "sample print of work.mvpmeds";
172 title4 "PMED (HC-118A) 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.67 seconds
cpu time 0.01 seconds
174
175 PROC MEANS DATA=MVPMEDS N SUM;
176 VAR RXXP08X;
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 4544 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.34 seconds
cpu time 0.03 seconds
179
180 PROC MEANS DATA=MVPMEDS N SUM;
181 VAR RXXP08X;
182 WEIGHT PERWT08F;
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 4544 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.13 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 23.70 seconds
cpu time 2.45 seconds
Return to Top
HC-118I. Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H120) records where cccodex=128
Obs |
CONDIDX |
CCCODEX |
1 |
700121030011 |
128 |
2 |
700251010031 |
128 |
3 |
700251030011 |
128 |
4 |
700271030011 |
128 |
5 |
700271040031 |
128 |
6 |
700271050061 |
128 |
7 |
700351020091 |
128 |
8 |
700481010071 |
128 |
9 |
700701040051 |
128 |
10 |
700991010041 |
128 |
11 |
701131060041 |
128 |
12 |
701461010041 |
128 |
13 |
701641030011 |
128 |
14 |
701971030021 |
128 |
15 |
701981010011 |
128 |
16 |
702051030011 |
128 |
17 |
702151010051 |
128 |
18 |
702291010041 |
128 |
19 |
702421050011 |
128 |
20 |
702441010071 |
128 |
21 |
702441010181 |
128 |
22 |
702731030022 |
128 |
23 |
702751020041 |
128 |
24 |
702761010011 |
128 |
25 |
702831010061 |
128 |
26 |
702851010021 |
128 |
27 |
702901010041 |
128 |
28 |
702901010061 |
128 |
29 |
702981040031 |
128 |
30 |
703041010021 |
128 |
31 |
703121010051 |
128 |
32 |
703141010031 |
128 |
33 |
703261010041 |
128 |
34 |
703341030011 |
128 |
35 |
703341040011 |
128 |
36 |
703461030011 |
128 |
37 |
703561020021 |
128 |
38 |
703601010051 |
128 |
39 |
703601030023 |
128 |
40 |
703651030011 |
128 |
41 |
703741010041 |
128 |
42 |
703821030011 |
128 |
43 |
703881010031 |
128 |
44 |
703951010021 |
128 |
45 |
704101010051 |
128 |
46 |
704171010061 |
128 |
47 |
704281010051 |
128 |
48 |
704281020011 |
128 |
49 |
704311050011 |
128 |
50 |
704641040011 |
128 |
Return to Top
HC-118I. Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
700121030011 |
700121030041 |
8 PMED |
700121030011 |
700121030061 |
8 PMED |
700121030011 |
700121030081 |
8 PMED |
700251030011 |
700251030161 |
1 MVIS |
700251030011 |
700251030171 |
1 MVIS |
700251030011 |
700251030181 |
1 MVIS |
700251030011 |
700251030191 |
8 PMED |
700251030011 |
700251030211 |
8 PMED |
700251030011 |
700251030271 |
8 PMED |
700251030011 |
700251030311 |
8 PMED |
700271040031 |
700271040081 |
8 PMED |
700271050061 |
700271050131 |
1 MVIS |
700271050061 |
700271050151 |
8 PMED |
700351020091 |
700351020421 |
1 MVIS |
700351020091 |
700351020481 |
8 PMED |
700351020091 |
700351020571 |
1 MVIS |
700351020091 |
700351020601 |
8 PMED |
700351020091 |
700351020611 |
8 PMED |
700351020091 |
700351020651 |
8 PMED |
700351020091 |
700351020671 |
8 PMED |
700481010071 |
700481010271 |
1 MVIS |
700481010071 |
700481010291 |
1 MVIS |
700481010071 |
700481010311 |
8 PMED |
700481010071 |
700481010371 |
8 PMED |
700481010071 |
700481010441 |
8 PMED |
700481010071 |
700481010521 |
8 PMED |
700701040051 |
700701040121 |
3 EROM |
700701040051 |
700701040131 |
8 PMED |
700991010041 |
700991010201 |
8 PMED |
700991010041 |
700991010261 |
8 PMED |
701131060041 |
701131060711 |
1 MVIS |
701131060041 |
701131060761 |
8 PMED |
701131060041 |
701131060771 |
8 PMED |
701461010041 |
701461010071 |
8 PMED |
701461010041 |
701461010081 |
8 PMED |
701461010041 |
701461010091 |
8 PMED |
701461010041 |
701461010101 |
8 PMED |
701461010041 |
701461010111 |
8 PMED |
701461010041 |
701461010121 |
8 PMED |
701461010041 |
701461010131 |
8 PMED |
701461010041 |
701461010141 |
8 PMED |
701461010041 |
701461010151 |
8 PMED |
701641030011 |
701641030091 |
1 MVIS |
701641030011 |
701641030101 |
8 PMED |
701981010011 |
701981010061 |
1 MVIS |
701981010011 |
701981010081 |
8 PMED |
701981010011 |
701981010121 |
8 PMED |
702051030011 |
702051030081 |
8 PMED |
702151010051 |
702151010121 |
1 MVIS |
702151010051 |
702151010131 |
1 MVIS |
702151010051 |
702151010141 |
1 MVIS |
702151010051 |
702151010151 |
8 PMED |
702291010041 |
702291010191 |
8 PMED |
702421050011 |
702421050181 |
8 PMED |
702421050011 |
702421050191 |
8 PMED |
702421050011 |
702421050201 |
8 PMED |
702421050011 |
702421050211 |
8 PMED |
702441010071 |
702441010891 |
8 PMED |
702441010071 |
702441010981 |
1 MVIS |
702441010071 |
702441011001 |
1 MVIS |
702441010071 |
702441011131 |
8 PMED |
702441010181 |
702441010831 |
8 PMED |
702441010181 |
702441010901 |
8 PMED |
702441010181 |
702441010991 |
1 MVIS |
702441010181 |
702441011051 |
8 PMED |
702441010181 |
702441011171 |
8 PMED |
702751020041 |
702751020331 |
8 PMED |
702751020041 |
702751020371 |
1 MVIS |
702751020041 |
702751020431 |
8 PMED |
702751020041 |
702751020501 |
8 PMED |
702761010011 |
702761010071 |
8 PMED |
702761010011 |
702761010081 |
8 PMED |
702761010011 |
702761010101 |
8 PMED |
702761010011 |
702761010111 |
8 PMED |
702761010011 |
702761010121 |
8 PMED |
Return to Top
HC-118I. Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
700121030011 |
700121030041 |
8 PMED |
2 |
700121030011 |
700121030061 |
8 PMED |
3 |
700121030011 |
700121030081 |
8 PMED |
4 |
700251030011 |
700251030161 |
1 MVIS |
5 |
700251030011 |
700251030171 |
1 MVIS |
6 |
700251030011 |
700251030181 |
1 MVIS |
7 |
700251030011 |
700251030191 |
8 PMED |
8 |
700251030011 |
700251030211 |
8 PMED |
9 |
700251030011 |
700251030271 |
8 PMED |
10 |
700251030011 |
700251030311 |
8 PMED |
11 |
700271040031 |
700271040081 |
8 PMED |
12 |
700271050061 |
700271050131 |
1 MVIS |
13 |
700271050061 |
700271050151 |
8 PMED |
14 |
700351020091 |
700351020421 |
1 MVIS |
15 |
700351020091 |
700351020481 |
8 PMED |
16 |
700351020091 |
700351020571 |
1 MVIS |
17 |
700351020091 |
700351020601 |
8 PMED |
18 |
700351020091 |
700351020611 |
8 PMED |
19 |
700351020091 |
700351020651 |
8 PMED |
20 |
700351020091 |
700351020671 |
8 PMED |
21 |
700481010071 |
700481010271 |
1 MVIS |
22 |
700481010071 |
700481010291 |
1 MVIS |
23 |
700481010071 |
700481010311 |
8 PMED |
24 |
700481010071 |
700481010371 |
8 PMED |
25 |
700481010071 |
700481010441 |
8 PMED |
26 |
700481010071 |
700481010521 |
8 PMED |
27 |
700701040051 |
700701040121 |
3 EROM |
28 |
700701040051 |
700701040131 |
8 PMED |
29 |
700991010041 |
700991010201 |
8 PMED |
30 |
700991010041 |
700991010261 |
8 PMED |
31 |
701131060041 |
701131060711 |
1 MVIS |
32 |
701131060041 |
701131060761 |
8 PMED |
33 |
701131060041 |
701131060771 |
8 PMED |
34 |
701461010041 |
701461010071 |
8 PMED |
35 |
701461010041 |
701461010081 |
8 PMED |
36 |
701461010041 |
701461010091 |
8 PMED |
37 |
701461010041 |
701461010101 |
8 PMED |
38 |
701461010041 |
701461010111 |
8 PMED |
39 |
701461010041 |
701461010121 |
8 PMED |
40 |
701461010041 |
701461010131 |
8 PMED |
41 |
701461010041 |
701461010141 |
8 PMED |
42 |
701461010041 |
701461010151 |
8 PMED |
43 |
701641030011 |
701641030091 |
1 MVIS |
44 |
701641030011 |
701641030101 |
8 PMED |
45 |
701981010011 |
701981010061 |
1 MVIS |
46 |
701981010011 |
701981010081 |
8 PMED |
47 |
701981010011 |
701981010121 |
8 PMED |
48 |
702051030011 |
702051030081 |
8 PMED |
49 |
702151010051 |
702151010121 |
1 MVIS |
50 |
702151010051 |
702151010131 |
1 MVIS |
Return to Top
HC-118I. Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
700121030041 |
8 PMED |
2 |
700121030061 |
8 PMED |
3 |
700121030081 |
8 PMED |
4 |
700251030161 |
1 MVIS |
5 |
700251030171 |
1 MVIS |
6 |
700251030181 |
1 MVIS |
7 |
700251030191 |
8 PMED |
8 |
700251030211 |
8 PMED |
9 |
700251030271 |
8 PMED |
10 |
700251030311 |
8 PMED |
11 |
700271040081 |
8 PMED |
12 |
700271050131 |
1 MVIS |
13 |
700271050151 |
8 PMED |
14 |
700351020421 |
1 MVIS |
15 |
700351020481 |
8 PMED |
16 |
700351020571 |
1 MVIS |
17 |
700351020601 |
8 PMED |
18 |
700351020611 |
8 PMED |
19 |
700351020651 |
8 PMED |
20 |
700351020671 |
8 PMED |
21 |
700481010271 |
1 MVIS |
22 |
700481010291 |
1 MVIS |
23 |
700481010311 |
8 PMED |
24 |
700481010371 |
8 PMED |
25 |
700481010441 |
8 PMED |
26 |
700481010521 |
8 PMED |
27 |
700701040121 |
3 EROM |
28 |
700701040131 |
8 PMED |
29 |
700991010201 |
8 PMED |
30 |
700991010261 |
8 PMED |
31 |
701131060711 |
1 MVIS |
32 |
701131060761 |
8 PMED |
33 |
701131060771 |
8 PMED |
34 |
701461010071 |
8 PMED |
35 |
701461010081 |
8 PMED |
36 |
701461010091 |
8 PMED |
37 |
701461010101 |
8 PMED |
38 |
701461010111 |
8 PMED |
39 |
701461010121 |
8 PMED |
40 |
701461010131 |
8 PMED |
41 |
701461010141 |
8 PMED |
42 |
701461010151 |
8 PMED |
43 |
701641030091 |
1 MVIS |
44 |
701641030101 |
8 PMED |
45 |
701981010061 |
1 MVIS |
46 |
701981010081 |
8 PMED |
47 |
701981010121 |
8 PMED |
48 |
702051030081 |
8 PMED |
49 |
702151010121 |
1 MVIS |
50 |
702151010131 |
1 MVIS |
Return to Top
HC-118I. Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are
non-telephone MVIS (HC-118G) events
Obs |
EVNTIDX |
EVENTYPE |
1 |
700251030161 |
1 MVIS |
2 |
700251030171 |
1 MVIS |
3 |
700251030181 |
1 MVIS |
4 |
700271050131 |
1 MVIS |
5 |
700351020421 |
1 MVIS |
6 |
700351020571 |
1 MVIS |
7 |
700481010271 |
1 MVIS |
8 |
700481010291 |
1 MVIS |
9 |
701131060711 |
1 MVIS |
10 |
701981010061 |
1 MVIS |
11 |
702151010121 |
1 MVIS |
12 |
702151010131 |
1 MVIS |
13 |
702151010141 |
1 MVIS |
14 |
702441010981 |
1 MVIS |
15 |
702441010991 |
1 MVIS |
16 |
702441011001 |
1 MVIS |
17 |
702751020371 |
1 MVIS |
18 |
702761010141 |
1 MVIS |
19 |
703121010201 |
1 MVIS |
20 |
703121010211 |
1 MVIS |
21 |
703121010221 |
1 MVIS |
22 |
703261010331 |
1 MVIS |
23 |
703261010341 |
1 MVIS |
24 |
703261010421 |
1 MVIS |
25 |
703561020011 |
1 MVIS |
26 |
703601010211 |
1 MVIS |
27 |
703651030231 |
1 MVIS |
28 |
704281020371 |
1 MVIS |
29 |
704281020381 |
1 MVIS |
30 |
704641040031 |
1 MVIS |
31 |
704781020461 |
1 MVIS |
32 |
704781020471 |
1 MVIS |
33 |
704921020241 |
1 MVIS |
34 |
705121020401 |
1 MVIS |
35 |
705121020421 |
1 MVIS |
36 |
705551030041 |
1 MVIS |
37 |
705671010351 |
1 MVIS |
38 |
705671010361 |
1 MVIS |
39 |
705751020271 |
1 MVIS |
40 |
705841011771 |
1 MVIS |
41 |
705841011781 |
1 MVIS |
42 |
705841012341 |
1 MVIS |
43 |
706601010231 |
1 MVIS |
44 |
706601010241 |
1 MVIS |
45 |
706601010251 |
1 MVIS |
46 |
706601010261 |
1 MVIS |
47 |
706801010391 |
1 MVIS |
48 |
706801010401 |
1 MVIS |
49 |
706801010411 |
1 MVIS |
50 |
706801010421 |
1 MVIS |
Return to Top
HC-118I. Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-118IF2)
EVNTIDX |
LINKIDX |
EVENTYPE |
700011020241 |
700011020321 |
1 MVIS |
700011040071 |
700011040081 |
1 MVIS |
700041030031 |
700041030041 |
1 MVIS |
700082010092 |
700082010152 |
1 MVIS |
700082010092 |
700082010162 |
1 MVIS |
700091010201 |
700091010261 |
1 MVIS |
700091010201 |
700091010271 |
1 MVIS |
700101030111 |
700101030141 |
1 MVIS |
700101030131 |
700101030151 |
1 MVIS |
700111010251 |
700111010301 |
1 MVIS |
700111010281 |
700111010311 |
3 EROM |
700161010061 |
700161010081 |
1 MVIS |
700161010091 |
700161010101 |
1 MVIS |
700161010091 |
700161010111 |
1 MVIS |
700161010131 |
700161010141 |
1 MVIS |
700161020081 |
700161020101 |
1 MVIS |
700161020141 |
700161020151 |
1 MVIS |
700161020141 |
700161020161 |
1 MVIS |
700161020141 |
700161020171 |
1 MVIS |
700211010201 |
700211010211 |
1 MVIS |
700211010201 |
700211010221 |
1 MVIS |
700211010201 |
700211010231 |
1 MVIS |
700211030161 |
700211030201 |
1 MVIS |
700211030161 |
700211030211 |
1 MVIS |
700211030231 |
700211030241 |
1 MVIS |
700211030231 |
700211030251 |
1 MVIS |
700221010391 |
700221010441 |
1 MVIS |
700221010391 |
700221010451 |
1 MVIS |
700221010391 |
700221010461 |
1 MVIS |
700221020021 |
700221020051 |
3 EROM |
700251010131 |
700251010181 |
1 MVIS |
700251010141 |
700251010191 |
2 OPAT |
700251010141 |
700251010201 |
2 OPAT |
700251010871 |
700251010921 |
1 MVIS |
700251010871 |
700251010931 |
1 MVIS |
700251010871 |
700251010941 |
1 MVIS |
700251010911 |
700251010941 |
1 MVIS |
700251010911 |
700251010951 |
1 MVIS |
700251020011 |
700251020031 |
1 MVIS |
700251020011 |
700251020041 |
1 MVIS |
700251020051 |
700251020061 |
1 MVIS |
700251020071 |
700251020081 |
1 MVIS |
700251030161 |
700251030191 |
1 MVIS |
700251030161 |
700251030201 |
1 MVIS |
700251030161 |
700251030211 |
1 MVIS |
700251030221 |
700251030261 |
1 MVIS |
700251030241 |
700251030271 |
1 MVIS |
700251030241 |
700251030281 |
1 MVIS |
700251030241 |
700251030291 |
1 MVIS |
700251030241 |
700251030301 |
1 MVIS |
700251030241 |
700251030311 |
1 MVIS |
700271020041 |
700271020051 |
3 EROM |
700271050071 |
700271050081 |
1 MVIS |
700271050071 |
700271050091 |
1 MVIS |
700271050071 |
700271050101 |
1 MVIS |
700271050131 |
700271050151 |
1 MVIS |
700271060111 |
700271060131 |
1 MVIS |
700271060111 |
700271060141 |
1 MVIS |
700281030131 |
700281030141 |
3 EROM |
700281040101 |
700281040111 |
1 MVIS |
700281050031 |
700281050041 |
3 EROM |
700291010142 |
700291010152 |
3 EROM |
700321010231 |
700321010331 |
1 MVIS |
700321010241 |
700321010341 |
5 DVIS |
700321020531 |
700321020551 |
1 MVIS |
700321020531 |
700321020561 |
1 MVIS |
700331010141 |
700331010181 |
5 DVIS |
700331010141 |
700331010191 |
5 DVIS |
700331010151 |
700331010201 |
1 MVIS |
700331010151 |
700331010211 |
1 MVIS |
700331010151 |
700331010221 |
1 MVIS |
700331010151 |
700331010231 |
1 MVIS |
700331010151 |
700331010241 |
1 MVIS |
700341020271 |
700341020291 |
1 MVIS |
700341020281 |
700341020301 |
1 MVIS |
700341020311 |
700341020361 |
1 MVIS |
700341020321 |
700341020371 |
1 MVIS |
700341020321 |
700341020381 |
1 MVIS |
700341020321 |
700341020391 |
1 MVIS |
700351020321 |
700351020431 |
1 MVIS |
700351020321 |
700351020441 |
1 MVIS |
700351020321 |
700351020451 |
1 MVIS |
700351020321 |
700351020461 |
1 MVIS |
700351020321 |
700351020471 |
1 MVIS |
700351020321 |
700351020481 |
1 MVIS |
700351020331 |
700351020491 |
3 EROM |
700351020421 |
700351020501 |
1 MVIS |
700351020421 |
700351020511 |
1 MVIS |
700351020571 |
700351020601 |
1 MVIS |
700351020571 |
700351020611 |
1 MVIS |
700361010291 |
700361010381 |
1 MVIS |
700361010351 |
700361010391 |
1 MVIS |
700361010351 |
700361010401 |
1 MVIS |
700361010431 |
700361010441 |
1 MVIS |
700361010431 |
700361010451 |
1 MVIS |
700361020271 |
700361020301 |
1 MVIS |
700361020281 |
700361020311 |
1 MVIS |
700361020411 |
700361020591 |
1 MVIS |
700361020421 |
700361020601 |
1 MVIS |
700361020461 |
700361020611 |
1 MVIS |
700361020461 |
700361020621 |
1 MVIS |
700361020461 |
700361020631 |
1 MVIS |
700361020491 |
700361020641 |
1 MVIS |
700361020571 |
700361020651 |
2 OPAT |
700371010431 |
700371010451 |
1 MVIS |
700371010541 |
700371010551 |
1 MVIS |
700371010541 |
700371010561 |
1 MVIS |
700371010541 |
700371010571 |
1 MVIS |
700371010541 |
700371010581 |
1 MVIS |
700371010541 |
700371010591 |
1 MVIS |
700371010541 |
700371010601 |
1 MVIS |
700371010541 |
700371010611 |
1 MVIS |
700371010541 |
700371010621 |
1 MVIS |
700431010681 |
700431010751 |
1 MVIS |
700431010681 |
700431010761 |
1 MVIS |
700431010681 |
700431010771 |
1 MVIS |
700431010681 |
700431010781 |
1 MVIS |
700431010681 |
700431010791 |
1 MVIS |
700461010121 |
700461010131 |
1 MVIS |
700501010111 |
700501010151 |
4 STAZ |
700501030201 |
700501030291 |
1 MVIS |
700531010371 |
700531010391 |
1 MVIS |
700531010481 |
700531010471 |
1 MVIS |
700531010561 |
700531010621 |
1 MVIS |
700531010561 |
700531010631 |
1 MVIS |
700531010561 |
700531010641 |
1 MVIS |
700531030081 |
700531030091 |
1 MVIS |
700671020371 |
700671020391 |
1 MVIS |
700691020051 |
700691020061 |
1 MVIS |
700701030101 |
700701030121 |
5 DVIS |
700701030111 |
700701030121 |
5 DVIS |
700701040091 |
700701040101 |
3 EROM |
700701040091 |
700701040111 |
3 EROM |
700701040121 |
700701040131 |
3 EROM |
700731010061 |
700731010071 |
1 MVIS |
700731010061 |
700731010081 |
1 MVIS |
700731010091 |
700731010101 |
1 MVIS |
700751010221 |
700751010241 |
1 MVIS |
700751010221 |
700751010251 |
1 MVIS |
700751010221 |
700751010261 |
1 MVIS |
Return to Top
HC-118I. 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 |
700251030161 |
700251030191 |
1 MVIS |
700251030161 |
700251030201 |
1 MVIS |
700251030161 |
700251030211 |
1 MVIS |
700271050131 |
700271050151 |
1 MVIS |
700351020421 |
700351020501 |
1 MVIS |
700351020421 |
700351020511 |
1 MVIS |
700351020571 |
700351020601 |
1 MVIS |
700351020571 |
700351020611 |
1 MVIS |
701981010061 |
701981010071 |
1 MVIS |
701981010061 |
701981010081 |
1 MVIS |
701981010061 |
701981010091 |
1 MVIS |
701981010061 |
701981010101 |
1 MVIS |
702151010121 |
702151010151 |
1 MVIS |
702151010131 |
702151010151 |
1 MVIS |
703121010201 |
703121010241 |
1 MVIS |
703121010201 |
703121010251 |
1 MVIS |
703121010201 |
703121010261 |
1 MVIS |
703121010201 |
703121010271 |
1 MVIS |
703121010201 |
703121010281 |
1 MVIS |
703121010201 |
703121010291 |
1 MVIS |
703121010201 |
703121010301 |
1 MVIS |
703121010201 |
703121010311 |
1 MVIS |
703121010201 |
703121010321 |
1 MVIS |
703121010201 |
703121010331 |
1 MVIS |
703121010201 |
703121010341 |
1 MVIS |
703261010331 |
703261010361 |
1 MVIS |
703261010331 |
703261010371 |
1 MVIS |
703261010331 |
703261010381 |
1 MVIS |
703261010331 |
703261010391 |
1 MVIS |
703261010331 |
703261010401 |
1 MVIS |
703261010331 |
703261010411 |
1 MVIS |
703261010341 |
703261010361 |
1 MVIS |
703261010341 |
703261010371 |
1 MVIS |
703261010341 |
703261010381 |
1 MVIS |
703261010341 |
703261010391 |
1 MVIS |
703261010341 |
703261010401 |
1 MVIS |
703261010341 |
703261010411 |
1 MVIS |
703261010421 |
703261010451 |
1 MVIS |
703261010421 |
703261010461 |
1 MVIS |
703261010421 |
703261010471 |
1 MVIS |
703261010421 |
703261010481 |
1 MVIS |
703561020011 |
703561020021 |
1 MVIS |
703561020011 |
703561020031 |
1 MVIS |
703601010211 |
703601010231 |
1 MVIS |
704281020371 |
704281020411 |
1 MVIS |
704281020381 |
704281020421 |
1 MVIS |
704641040031 |
704641040041 |
1 MVIS |
704781020461 |
704781020481 |
1 MVIS |
704921020241 |
704921020251 |
1 MVIS |
705121020401 |
705121020431 |
1 MVIS |
Return to Top
HC-118I. Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx
Obs |
EVNTIDX |
LINKIDX |
EVENTYPE |
1 |
700251030161 |
700251030191 |
1 MVIS |
2 |
700251030161 |
700251030201 |
1 MVIS |
3 |
700251030161 |
700251030211 |
1 MVIS |
4 |
700271050131 |
700271050151 |
1 MVIS |
5 |
700351020421 |
700351020501 |
1 MVIS |
6 |
700351020421 |
700351020511 |
1 MVIS |
7 |
700351020571 |
700351020601 |
1 MVIS |
8 |
700351020571 |
700351020611 |
1 MVIS |
9 |
701981010061 |
701981010071 |
1 MVIS |
10 |
701981010061 |
701981010081 |
1 MVIS |
11 |
701981010061 |
701981010091 |
1 MVIS |
12 |
701981010061 |
701981010101 |
1 MVIS |
13 |
702151010121 |
702151010151 |
1 MVIS |
14 |
702151010131 |
702151010151 |
1 MVIS |
15 |
703121010201 |
703121010241 |
1 MVIS |
16 |
703121010201 |
703121010251 |
1 MVIS |
17 |
703121010201 |
703121010261 |
1 MVIS |
18 |
703121010201 |
703121010271 |
1 MVIS |
19 |
703121010201 |
703121010281 |
1 MVIS |
20 |
703121010201 |
703121010291 |
1 MVIS |
21 |
703121010201 |
703121010301 |
1 MVIS |
22 |
703121010201 |
703121010311 |
1 MVIS |
23 |
703121010201 |
703121010321 |
1 MVIS |
24 |
703121010201 |
703121010331 |
1 MVIS |
25 |
703121010201 |
703121010341 |
1 MVIS |
26 |
703261010331 |
703261010361 |
1 MVIS |
27 |
703261010341 |
703261010361 |
1 MVIS |
28 |
703261010331 |
703261010371 |
1 MVIS |
29 |
703261010341 |
703261010371 |
1 MVIS |
30 |
703261010331 |
703261010381 |
1 MVIS |
31 |
703261010341 |
703261010381 |
1 MVIS |
32 |
703261010331 |
703261010391 |
1 MVIS |
33 |
703261010341 |
703261010391 |
1 MVIS |
34 |
703261010331 |
703261010401 |
1 MVIS |
35 |
703261010341 |
703261010401 |
1 MVIS |
36 |
703261010331 |
703261010411 |
1 MVIS |
37 |
703261010341 |
703261010411 |
1 MVIS |
38 |
703261010421 |
703261010451 |
1 MVIS |
39 |
703261010421 |
703261010461 |
1 MVIS |
40 |
703261010421 |
703261010471 |
1 MVIS |
41 |
703261010421 |
703261010481 |
1 MVIS |
42 |
703561020011 |
703561020021 |
1 MVIS |
43 |
703561020011 |
703561020031 |
1 MVIS |
44 |
703601010211 |
703601010231 |
1 MVIS |
45 |
704281020371 |
704281020411 |
1 MVIS |
46 |
704281020381 |
704281020421 |
1 MVIS |
47 |
704641040031 |
704641040041 |
1 MVIS |
48 |
704781020461 |
704781020481 |
1 MVIS |
49 |
704921020241 |
704921020251 |
1 MVIS |
50 |
705121020401 |
705121020431 |
1 MVIS |
Return to Top
HC-118I. Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids
Obs |
LINKIDX |
1 |
700251030191 |
2 |
700251030201 |
3 |
700251030211 |
4 |
700271050151 |
5 |
700351020501 |
6 |
700351020511 |
7 |
700351020601 |
8 |
700351020611 |
9 |
701981010071 |
10 |
701981010081 |
11 |
701981010091 |
12 |
701981010101 |
13 |
702151010151 |
14 |
703121010241 |
15 |
703121010251 |
16 |
703121010261 |
17 |
703121010271 |
18 |
703121010281 |
19 |
703121010291 |
20 |
703121010301 |
21 |
703121010311 |
22 |
703121010321 |
23 |
703121010331 |
24 |
703121010341 |
25 |
703261010361 |
26 |
703261010371 |
27 |
703261010381 |
28 |
703261010391 |
29 |
703261010401 |
30 |
703261010411 |
31 |
703261010451 |
32 |
703261010461 |
33 |
703261010471 |
34 |
703261010481 |
35 |
703561020021 |
36 |
703561020031 |
37 |
703601010231 |
38 |
704281020411 |
39 |
704281020421 |
40 |
704641040041 |
41 |
704781020481 |
42 |
704921020251 |
43 |
705121020431 |
44 |
705121020441 |
45 |
705551030051 |
46 |
705671010381 |
47 |
705671010391 |
48 |
705841012191 |
49 |
705841012591 |
50 |
705841012601 |
Return to Top
HC-118I. Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-118A) records for unique linkidxs in work.pmedids
LINKIDX |
RXRECIDX |
RXNAME |
RXXP08X |
PERWT08F |
700251030191 |
700251030191001 |
XOPENEX (PF) |
84.87 |
3160.81 |
700251030201 |
700251030201001 |
ZYRTEC |
6.44 |
3160.81 |
700251030201 |
700251030201002 |
ZYRTEC |
6.44 |
3160.81 |
700251030211 |
700251030211001 |
FLOVENT DISKUS |
120.85 |
3160.81 |
700271050151 |
700271050151001 |
XOPENEX HFA (200 ACTUATIONS) |
52.63 |
1840.44 |
700351020501 |
700351020501001 |
SPIRIVA (W/ HANDIHALER) |
147.06 |
9219.77 |
700351020511 |
700351020511001 |
ALBUTEROL |
34.85 |
9219.77 |
700351020601 |
700351020601001 |
SYMBICORT |
170.29 |
9219.77 |
700351020601 |
700351020601002 |
SYMBICORT |
170.29 |
9219.77 |
700351020611 |
700351020611001 |
SPIRIVA (W/ HANDIHALER) |
147.06 |
9219.77 |
700351020611 |
700351020611002 |
SPIRIVA (W/ HANDIHALER) |
147.06 |
9219.77 |
700351020611 |
700351020611003 |
SPIRIVA (W/ HANDIHALER) |
147.06 |
9219.77 |
700351020611 |
700351020611004 |
SPIRIVA (W/ HANDIHALER) |
147.06 |
9219.77 |
701981010071 |
701981010071001 |
METHYLPREDNISOLONE |
10.75 |
9361.57 |
701981010081 |
701981010081001 |
PROAIR HFA |
32.34 |
9361.57 |
701981010091 |
701981010091001 |
AMOXICILLIN |
9.80 |
9361.57 |
701981010101 |
701981010101001 |
ALBUTEROL |
22.02 |
9361.57 |
702151010151 |
702151010151001 |
SYMBICORT |
189.80 |
10837.01 |
702151010151 |
702151010151002 |
SYMBICORT |
189.80 |
10837.01 |
703121010241 |
703121010241001 |
PREVACID |
330.04 |
2675.14 |
703121010241 |
703121010241002 |
PREVACID |
330.04 |
2675.14 |
703121010241 |
703121010241003 |
PREVACID |
330.04 |
2675.14 |
703121010241 |
703121010241004 |
PREVACID |
330.04 |
2675.14 |
703121010241 |
703121010241005 |
PREVACID |
330.04 |
2675.14 |
703121010251 |
703121010251001 |
HYDROCHLOROTHIAZIDE |
7.50 |
2675.14 |
703121010251 |
703121010251002 |
HYDROCHLOROTHIAZIDE |
7.50 |
2675.14 |
703121010251 |
703121010251003 |
HYDROCHLOROTHIAZIDE |
7.50 |
2675.14 |
703121010251 |
703121010251004 |
HYDROCHLOROTHIAZIDE |
7.50 |
2675.14 |
703121010251 |
703121010251005 |
HYDROCHLOROTHIAZIDE |
7.50 |
2675.14 |
703121010261 |
703121010261001 |
IBUPROFEN |
13.20 |
2675.14 |
703121010261 |
703121010261002 |
IBUPROFEN |
13.20 |
2675.14 |
703121010261 |
703121010261003 |
IBUPROFEN |
13.20 |
2675.14 |
703121010261 |
703121010261004 |
IBUPROFEN |
13.20 |
2675.14 |
703121010261 |
703121010261005 |
IBUPROFEN |
13.20 |
2675.14 |
703121010271 |
703121010271001 |
FUROSEMIDE |
7.07 |
2675.14 |
703121010271 |
703121010271002 |
FUROSEMIDE |
7.57 |
2675.14 |
703121010271 |
703121010271003 |
FUROSEMIDE |
7.57 |
2675.14 |
703121010271 |
703121010271004 |
FUROSEMIDE |
7.57 |
2675.14 |
703121010271 |
703121010271005 |
FUROSEMIDE |
7.57 |
2675.14 |
703121010281 |
703121010281001 |
TERBUTALINE SULFATE |
26.21 |
2675.14 |
703121010281 |
703121010281002 |
TERBUTALINE SULFATE |
26.21 |
2675.14 |
703121010281 |
703121010281003 |
TERBUTALINE SULFATE |
28.21 |
2675.14 |
703121010281 |
703121010281004 |
TERBUTALINE SULFATE |
28.21 |
2675.14 |
703121010281 |
703121010281005 |
TERBUTALINE SULFATE |
28.21 |
2675.14 |
703121010291 |
703121010291001 |
EXTENDED PHENYTOIN SODIUM |
35.09 |
2675.14 |
703121010291 |
703121010291002 |
EXTENDED PHENYTOIN SODIUM |
35.09 |
2675.14 |
703121010291 |
703121010291003 |
EXTENDED PHENYTOIN SODIUM |
35.09 |
2675.14 |
703121010291 |
703121010291004 |
EXTENDED PHENYTOIN SODIUM |
35.09 |
2675.14 |
703121010291 |
703121010291005 |
EXTENDED PHENYTOIN SODIUM |
35.09 |
2675.14 |
703121010301 |
703121010301001 |
CENESTIN (FILM-COATED) |
50.16 |
2675.14 |
703121010301 |
703121010301002 |
CENESTIN (FILM-COATED) |
50.16 |
2675.14 |
703121010301 |
703121010301003 |
CENESTIN (FILM-COATED) |
53.16 |
2675.14 |
703121010301 |
703121010301004 |
CENESTIN (FILM-COATED) |
53.16 |
2675.14 |
703121010301 |
703121010301005 |
CENESTIN (FILM-COATED) |
53.16 |
2675.14 |
703121010311 |
703121010311001 |
AMITRIPTYLINE HCL (FILM COATED) |
9.19 |
2675.14 |
703121010311 |
703121010311002 |
AMITRIPTYLINE HCL (FILM COATED) |
9.19 |
2675.14 |
703121010311 |
703121010311003 |
AMITRIPTYLINE HCL (FILM COATED) |
9.69 |
2675.14 |
703121010311 |
703121010311004 |
AMITRIPTYLINE HCL (FILM COATED) |
9.69 |
2675.14 |
703121010311 |
703121010311005 |
AMITRIPTYLINE HCL (FILM COATED) |
9.69 |
2675.14 |
703121010321 |
703121010321001 |
ALBUTEROL SULFATE (PF) |
43.94 |
2675.14 |
703121010321 |
703121010321002 |
ALBUTEROL SULFATE (PF) |
43.94 |
2675.14 |
703121010321 |
703121010321003 |
ALBUTEROL SULFATE (PF) |
43.94 |
2675.14 |
703121010321 |
703121010321004 |
ALBUTEROL SULFATE (PF) |
43.94 |
2675.14 |
703121010321 |
703121010321005 |
ALBUTEROL SULFATE (PF) |
43.94 |
2675.14 |
703121010331 |
703121010331001 |
IPRATROPIUM BROMIDE (PF) |
521.53 |
2675.14 |
703121010331 |
703121010331002 |
IPRATROPIUM BROMIDE (PF) |
521.53 |
2675.14 |
703121010331 |
703121010331003 |
IPRATROPIUM BROMIDE (PF) |
521.53 |
2675.14 |
703121010331 |
703121010331004 |
IPRATROPIUM BROMIDE (PF) |
521.53 |
2675.14 |
703121010331 |
703121010331005 |
IPRATROPIUM BROMIDE (PF) |
521.53 |
2675.14 |
703121010341 |
703121010341001 |
CEFDINIR |
72.05 |
2675.14 |
703121010341 |
703121010341002 |
CEFDINIR |
72.05 |
2675.14 |
703121010341 |
703121010341003 |
CEFDINIR |
72.05 |
2675.14 |
703121010341 |
703121010341004 |
CEFDINIR |
72.05 |
2675.14 |
703121010341 |
703121010341005 |
CEFDINIR |
72.05 |
2675.14 |
703261010361 |
703261010361001 |
ADVAIR DISKUS 100/50 |
149.34 |
3783.89 |
703261010361 |
703261010361002 |
ADVAIR DISKUS 100/50 |
149.34 |
3783.89 |
703261010361 |
703261010361003 |
ADVAIR DISKUS 100/50 |
149.34 |
3783.89 |
703261010361 |
703261010361004 |
ADVAIR DISKUS 100/50 |
149.34 |
3783.89 |
703261010361 |
703261010361005 |
ADVAIR DISKUS 100/50 |
149.34 |
3783.89 |
703261010361 |
703261010361006 |
ADVAIR DISKUS 100/50 |
155.89 |
3783.89 |
703261010361 |
703261010361007 |
ADVAIR DISKUS 100/50 |
155.89 |
3783.89 |
703261010371 |
703261010371001 |
NIASPAN |
109.20 |
3783.89 |
703261010371 |
703261010371002 |
NIASPAN |
109.20 |
3783.89 |
703261010371 |
703261010371003 |
NIASPAN |
109.20 |
3783.89 |
703261010371 |
703261010371004 |
NIASPAN |
109.20 |
3783.89 |
703261010371 |
703261010371005 |
NIASPAN |
109.20 |
3783.89 |
703261010371 |
703261010371006 |
NIASPAN |
109.20 |
3783.89 |
703261010371 |
703261010371007 |
NIASPAN |
109.20 |
3783.89 |
703261010381 |
703261010381001 |
CRESTOR |
97.63 |
3783.89 |
703261010381 |
703261010381002 |
CRESTOR |
97.63 |
3783.89 |
703261010381 |
703261010381003 |
CRESTOR |
97.63 |
3783.89 |
703261010381 |
703261010381004 |
CRESTOR |
97.63 |
3783.89 |
703261010381 |
703261010381005 |
CRESTOR |
102.42 |
3783.89 |
703261010381 |
703261010381006 |
CRESTOR |
102.42 |
3783.89 |
703261010381 |
703261010381007 |
CRESTOR |
102.42 |
3783.89 |
703261010391 |
703261010391001 |
ATENOLOL |
3.09 |
3783.89 |
703261010391 |
703261010391002 |
ATENOLOL |
3.09 |
3783.89 |
703261010391 |
703261010391003 |
ATENOLOL |
3.09 |
3783.89 |
703261010391 |
703261010391004 |
ATENOLOL |
3.09 |
3783.89 |
703261010391 |
703261010391005 |
ATENOLOL |
3.09 |
3783.89 |
703261010391 |
703261010391006 |
ATENOLOL |
3.09 |
3783.89 |
703261010391 |
703261010391007 |
ATENOLOL |
3.09 |
3783.89 |
703261010401 |
703261010401001 |
TRICOR |
38.13 |
3783.89 |
703261010401 |
703261010401002 |
TRICOR |
38.13 |
3783.89 |
703261010401 |
703261010401003 |
TRICOR |
38.13 |
3783.89 |
703261010401 |
703261010401004 |
TRICOR |
38.13 |
3783.89 |
703261010401 |
703261010401005 |
TRICOR |
38.13 |
3783.89 |
703261010401 |
703261010401006 |
TRICOR |
38.13 |
3783.89 |
703261010401 |
703261010401007 |
TRICOR |
38.13 |
3783.89 |
703261010411 |
703261010411001 |
CLOBETASOL PROPIONATE |
41.84 |
3783.89 |
703261010411 |
703261010411002 |
CLOBETASOL PROPIONATE |
41.84 |
3783.89 |
703261010411 |
703261010411003 |
CLOBETASOL PROPIONATE |
41.84 |
3783.89 |
703261010411 |
703261010411004 |
CLOBETASOL PROPIONATE |
41.84 |
3783.89 |
703261010411 |
703261010411005 |
CLOBETASOL PROPIONATE |
41.84 |
3783.89 |
703261010411 |
703261010411006 |
CLOBETASOL PROPIONATE |
41.84 |
3783.89 |
703261010411 |
703261010411007 |
CLOBETASOL PROPIONATE |
41.84 |
3783.89 |
703261010451 |
703261010451001 |
ADVAIR DISKUS 100/50 |
155.89 |
3783.89 |
703261010451 |
703261010451002 |
ADVAIR DISKUS 100/50 |
155.89 |
3783.89 |
703261010451 |
703261010451003 |
ADVAIR DISKUS 100/50 |
155.89 |
3783.89 |
703261010461 |
703261010461001 |
CRESTOR |
102.42 |
3783.89 |
703261010461 |
703261010461002 |
CRESTOR |
102.42 |
3783.89 |
703261010461 |
703261010461003 |
CRESTOR |
102.42 |
3783.89 |
703261010471 |
703261010471001 |
ATENOLOL |
3.09 |
3783.89 |
703261010471 |
703261010471002 |
ATENOLOL |
3.09 |
3783.89 |
703261010471 |
703261010471003 |
ATENOLOL |
3.09 |
3783.89 |
703261010481 |
703261010481001 |
TRICOR |
38.13 |
3783.89 |
703261010481 |
703261010481002 |
TRICOR |
38.13 |
3783.89 |
703261010481 |
703261010481003 |
TRICOR |
38.13 |
3783.89 |
703561020021 |
703561020021001 |
PROAIR HFA |
20.00 |
3379.73 |
703561020031 |
703561020031001 |
SYMBICORT |
167.04 |
3379.73 |
703601010231 |
703601010231001 |
ALBUTEROL |
22.02 |
10819.95 |
704281020411 |
704281020411001 |
ALBUTEROL |
19.18 |
12968.13 |
704281020421 |
704281020421001 |
FLOVENT HFA |
112.25 |
12968.13 |
704641040041 |
704641040041001 |
AZITHROMYCIN |
10.00 |
5978.43 |
704781020481 |
704781020481001 |
ALBUTEROL |
25.86 |
15276.22 |
704921020251 |
704921020251001 |
SODIUM CHLORIDE |
19.95 |
25608.94 |
705121020431 |
705121020431001 |
FLOVENT HFA (WITH DOSE COUNTER) |
85.64 |
10239.60 |
705121020441 |
705121020441001 |
PROAIR HFA |
32.08 |
10239.60 |
705551030051 |
705551030051001 |
AEROCHAMBER |
37.29 |
5229.16 |
705671010381 |
705671010381001 |
PREDNISONE |
2.95 |
3682.77 |
705671010391 |
705671010391001 |
APAP/HYDROCODONE BITARTRATE |
65.08 |
3682.77 |
705671010391 |
705671010391002 |
APAP/HYDROCODONE BITARTRATE |
65.08 |
3682.77 |
705671010391 |
705671010391003 |
APAP/HYDROCODONE BITARTRATE |
62.66 |
3682.77 |
705671010391 |
705671010391004 |
APAP/HYDROCODONE BITARTRATE |
62.66 |
3682.77 |
705671010391 |
705671010391005 |
APAP/HYDROCODONE BITARTRATE |
62.66 |
3682.77 |
705841012191 |
705841012191001 |
AZITHROMYCIN (FILM-COATED) |
10.00 |
9597.15 |
705841012191 |
705841012191002 |
AZITHROMYCIN (FILM-COATED) |
10.00 |
9597.15 |
705841012591 |
705841012591001 |
SINGULAIR (UNIT OF USE) |
104.97 |
9597.15 |
705841012601 |
705841012601001 |
DOXYCYCLINE HYCLATE |
10.00 |
9597.15 |
706801010701 |
706801010701001 |
SINGULAIR (UNIT OF USE) |
285.42 |
8658.20 |
706801010711 |
706801010711001 |
PROVENTIL HFA (M.D.I.) |
68.82 |
8658.20 |
706801010721 |
706801010721001 |
ADVAIR DISKUS 250/50 |
509.58 |
8658.20 |
706801010731 |
706801010731001 |
FEXOFENADINE HYDROCHLORIDE
(FILM-COATED) |
94.84 |
8658.20 |
706801010741 |
706801010741001 |
VERAMYST |
222.47 |
8658.20 |
706851020441 |
706851020441001 |
ENALAPRIL MALEATE (WHITE) |
5.51 |
4170.41 |
706851020441 |
706851020441002 |
ENALAPRIL MALEATE (WHITE) |
5.51 |
4170.41 |
706851020441 |
706851020441003 |
ENALAPRIL MALEATE (WHITE) |
5.51 |
4170.41 |
706851020451 |
706851020451001 |
GABAPENTIN |
89.15 |
4170.41 |
706851020471 |
706851020471001 |
LANTUS |
87.21 |
4170.41 |
706851020471 |
706851020471002 |
LANTUS |
82.45 |
4170.41 |
706851020471 |
706851020471003 |
LANTUS |
82.45 |
4170.41 |
707581030192 |
707581030192001 |
PROAIR HFA |
32.08 |
7974.13 |
707581030202 |
707581030202001 |
ADVAIR DISKUS 250/50 |
190.96 |
7974.13 |
707691010121 |
707691010121001 |
ATENOLOL |
4.00 |
4330.61 |
707691010131 |
707691010131001 |
FOLIC ACID |
0.50 |
4330.61 |
707691010141 |
707691010141001 |
COL-RITE |
1.00 |
4330.61 |
707791021211 |
707791021211001 |
TOPROL XL |
29.84 |
30500.24 |
707791021211 |
707791021211002 |
TOPROL XL |
29.84 |
30500.24 |
707791021211 |
707791021211003 |
TOPROL XL |
29.84 |
30500.24 |
707791021221 |
707791021221001 |
PLAVIX (FILM-COATED) |
141.80 |
30500.24 |
707791021221 |
707791021221002 |
PLAVIX (FILM-COATED) |
141.80 |
30500.24 |
707791021221 |
707791021221003 |
PLAVIX (FILM-COATED) |
62.58 |
30500.24 |
707791021231 |
707791021231001 |
BENICAR (FILM-COATED) |
112.26 |
30500.24 |
707791021231 |
707791021231002 |
BENICAR (FILM-COATED) |
57.13 |
30500.24 |
707791021231 |
707791021231003 |
BENICAR (FILM-COATED) |
57.13 |
30500.24 |
708051010441 |
708051010441001 |
ASMANEX TWISTHALER
(60-INHALATION) |
487.12 |
5401.55 |
708051010451 |
708051010451001 |
VERAMYST |
80.60 |
5401.55 |
708771020521 |
708771020521001 |
AZITHROMYCIN (3X6,UNIT OF USE) |
10.00 |
6965.39 |
708771020531 |
708771020531001 |
PREDNISONE |
6.33 |
6965.39 |
708771020671 |
708771020671001 |
SMZ-TMP |
10.00 |
6965.39 |
709351020661 |
709351020661001 |
SYMBICORT |
1214.83 |
10509.88 |
709351020661 |
709351020661002 |
SYMBICORT |
1214.83 |
10509.88 |
709351020671 |
709351020671001 |
PROAIR HFA |
339.67 |
10509.88 |
710161010091 |
710161010091001 |
SINGULAIR (UNIT OF USE) |
104.97 |
9884.72 |
710161010101 |
710161010101001 |
ADVAIR DISKUS 250/50 |
190.96 |
9884.72 |
710161010101 |
710161010101002 |
ADVAIR DISKUS 250/50 |
190.96 |
9884.72 |
710161010111 |
710161010111001 |
ALBUTEROL |
22.02 |
9884.72 |
711011010361 |
711011010361001 |
FLOVENT DISKUS |
120.85 |
12581.93 |
711011010371 |
711011010371001 |
ALBUTEROL |
44.04 |
12581.93 |
711861030391 |
711861030391001 |
ALBUTEROL SULFATE (VIAL) |
11.93 |
10238.30 |
711861030391 |
711861030391002 |
ALBUTEROL SULFATE (VIAL) |
11.93 |
10238.30 |
711861030401 |
711861030401001 |
SINGULAIR (UNIT OF USE) |
104.97 |
10238.30 |
711861030401 |
711861030401002 |
SINGULAIR (UNIT OF USE) |
104.97 |
10238.30 |
711861030401 |
711861030401003 |
SINGULAIR (UNIT OF USE) |
104.97 |
10238.30 |
712041011011 |
712041011011001 |
NEXIUM (UNIT OF USE) |
465.75 |
8322.43 |
712041011021 |
712041011021001 |
PLAVIX (FILM-COATED) |
415.98 |
8322.43 |
712041011031 |
712041011031001 |
METFORMIN HYDROCHLORIDE
(FILM-COATED) |
11.98 |
8322.43 |
712041011041 |
712041011041001 |
DARVOCET-N 100 |
34.17 |
8322.43 |
712041011051 |
712041011051001 |
ADVAIR DISKUS 500/50 |
752.50 |
8322.43 |
712041011061 |
712041011061001 |
LISINOPRIL |
21.72 |
8322.43 |
Return to Top
HC-118I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Analysis Variable : RXXP08X SUM OF PAYMENTS RXSF08X-RXOU08X(IMPUTED)
Return to Top
HC-118I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits
(excluding telephone) for asthma
Weighted
Analysis Variable : RXXP08X SUM OF PAYMENTS RXSF08X-RXOU08X(IMPUTED)
Return to Top
NOTE: Copyright (c) 2002-2008 by SAS Institute
Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
Licensed to WESTAT INC, Site 70006348.
NOTE: This session is executing on the XP_PRO
platform.
NOTE: SAS initialization used:
real time 0.71 seconds
cpu time 0.45 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.01 seconds
cpu time 0.01 seconds
I:\SASTRACE\TRACE92\
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.01 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-118I";
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.09 seconds
cpu time 0.01 seconds
26
27
*--------------------------------------------------------------------------------------
28 * Get condition records coded as asthma.
29
*--------------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H120 (KEEP=CONDIDX CCCODEX);
32 IF CCCODEX="128";
33 RUN;
NOTE: There were 102169 observations read from the
data set IN.H120.
NOTE: The data set WORK.ASCONDS has 2100
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 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 2100 observations read from the
data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2100
observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
39
40 proc print data=asconds (obs=50);
41 title3 "sample print of work.asconds - sorted by
condidx";
42 title4 "COND (H120) records where cccodex=128";
43 run;
NOTE: There were 50 observations read from the data
set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.06 seconds
cpu time 0.03 seconds
44
45 PROC SORT DATA=IN.H118IF1 OUT=CLNK; BY CONDIDX;
RUN;
NOTE: There were 294294 observations read from the
data set IN.H118IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 294294
observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 5.62 seconds
cpu time 0.34 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 294294 observations read from the
data set WORK.CLNK.
NOTE: There were 2100 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 6546
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.07 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 1.18 seconds
cpu time 0.01 seconds
61
62 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 6546 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 6546
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
63
64 proc print data=asclnks (obs=50);
65 format eventype eventype.;
66 title3 "sample print of work.asclnks - sorted by
evntidx";
67 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 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 6546 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6543
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
74
75 proc print data=asclnks (obs=50);
76 format eventype eventype.;
77 title3 "sample print of unique evntidxs from
work.asclnks";
78 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
79
80
*-------------------------------------------------------------------------------
81 * Get PMED records linked to asthma condition
records.
82
*-------------------------------------------------------------------------------;
83 PROC SORT DATA=IN.H118A OUT=PMED; BY LINKIDX;
RUN;
NOTE: There were 293379 observations read from the
data set IN.H118A.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.PMED has 293379
observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 8.75 seconds
cpu time 0.65 seconds
84
85 DATA ASPMEDS;
86 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP08X
PERWT08F)
87 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX
RENAME=(EVNTIDX=LINKIDX));
88 BY LINKIDX;
89 IF INASCLNK & PERWT08F>0;
90 RUN;
NOTE: There were 293379 observations read from the
data set WORK.PMED.
NOTE: There were 6543 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 9502
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.11 seconds
cpu time 0.10 seconds
91
92 proc print data=aspmeds (obs=300);
93 by linkidx;
94 id linkidx;
95 var rxrecidx rxname RXXP08X PERWT08F;
96 title3 "sample print of work.aspmeds";
97 title4 "PMED (HC-118A) 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.73 seconds
cpu time 0.03 seconds
99
100 PROC MEANS DATA=ASPMEDS N SUM;
101 VAR RXXP08X;
102 TITLE3 "Total Rx expenditures associated with
asthma";
103 RUN;
NOTE: Multiple concurrent threads will be used to
summarize data.
NOTE: There were 9502 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.25 seconds
cpu time 0.01 seconds
104
105 PROC MEANS DATA=ASPMEDS N SUM;
106 VAR RXXP08X;
107 WEIGHT PERWT08F;
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 9502 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.11 seconds
cpu time 0.03 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.73 seconds
cpu time 2.14 seconds
Return to Top
HC-118I. Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H120) records where cccodex=128
Obs |
CONDIDX |
CCCODEX |
1 |
700121030011 |
128 |
2 |
700251010031 |
128 |
3 |
700251030011 |
128 |
4 |
700271030011 |
128 |
5 |
700271040031 |
128 |
6 |
700271050061 |
128 |
7 |
700351020091 |
128 |
8 |
700481010071 |
128 |
9 |
700701040051 |
128 |
10 |
700991010041 |
128 |
11 |
701131060041 |
128 |
12 |
701461010041 |
128 |
13 |
701641030011 |
128 |
14 |
701971030021 |
128 |
15 |
701981010011 |
128 |
16 |
702051030011 |
128 |
17 |
702151010051 |
128 |
18 |
702291010041 |
128 |
19 |
702421050011 |
128 |
20 |
702441010071 |
128 |
21 |
702441010181 |
128 |
22 |
702731030022 |
128 |
23 |
702751020041 |
128 |
24 |
702761010011 |
128 |
25 |
702831010061 |
128 |
26 |
702851010021 |
128 |
27 |
702901010041 |
128 |
28 |
702901010061 |
128 |
29 |
702981040031 |
128 |
30 |
703041010021 |
128 |
31 |
703121010051 |
128 |
32 |
703141010031 |
128 |
33 |
703261010041 |
128 |
34 |
703341030011 |
128 |
35 |
703341040011 |
128 |
36 |
703461030011 |
128 |
37 |
703561020021 |
128 |
38 |
703601010051 |
128 |
39 |
703601030023 |
128 |
40 |
703651030011 |
128 |
41 |
703741010041 |
128 |
42 |
703821030011 |
128 |
43 |
703881010031 |
128 |
44 |
703951010021 |
128 |
45 |
704101010051 |
128 |
46 |
704171010061 |
128 |
47 |
704281010051 |
128 |
48 |
704281020011 |
128 |
49 |
704311050011 |
128 |
50 |
704641040011 |
128 |
Return to Top
HC-118I. Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
700121030011 |
700121030041 |
8 PMED |
700121030011 |
700121030061 |
8 PMED |
700121030011 |
700121030081 |
8 PMED |
700251030011 |
700251030161 |
1 MVIS |
700251030011 |
700251030171 |
1 MVIS |
700251030011 |
700251030181 |
1 MVIS |
700251030011 |
700251030191 |
8 PMED |
700251030011 |
700251030211 |
8 PMED |
700251030011 |
700251030271 |
8 PMED |
700251030011 |
700251030311 |
8 PMED |
700271040031 |
700271040081 |
8 PMED |
700271050061 |
700271050131 |
1 MVIS |
700271050061 |
700271050151 |
8 PMED |
700351020091 |
700351020421 |
1 MVIS |
700351020091 |
700351020481 |
8 PMED |
700351020091 |
700351020571 |
1 MVIS |
700351020091 |
700351020601 |
8 PMED |
700351020091 |
700351020611 |
8 PMED |
700351020091 |
700351020651 |
8 PMED |
700351020091 |
700351020671 |
8 PMED |
700481010071 |
700481010271 |
1 MVIS |
700481010071 |
700481010291 |
1 MVIS |
700481010071 |
700481010311 |
8 PMED |
700481010071 |
700481010371 |
8 PMED |
700481010071 |
700481010441 |
8 PMED |
700481010071 |
700481010521 |
8 PMED |
700701040051 |
700701040121 |
3 EROM |
700701040051 |
700701040131 |
8 PMED |
700991010041 |
700991010201 |
8 PMED |
700991010041 |
700991010261 |
8 PMED |
701131060041 |
701131060711 |
1 MVIS |
701131060041 |
701131060761 |
8 PMED |
701131060041 |
701131060771 |
8 PMED |
701461010041 |
701461010071 |
8 PMED |
701461010041 |
701461010081 |
8 PMED |
701461010041 |
701461010091 |
8 PMED |
701461010041 |
701461010101 |
8 PMED |
701461010041 |
701461010111 |
8 PMED |
701461010041 |
701461010121 |
8 PMED |
701461010041 |
701461010131 |
8 PMED |
701461010041 |
701461010141 |
8 PMED |
701461010041 |
701461010151 |
8 PMED |
701641030011 |
701641030091 |
1 MVIS |
701641030011 |
701641030101 |
8 PMED |
701981010011 |
701981010061 |
1 MVIS |
701981010011 |
701981010081 |
8 PMED |
701981010011 |
701981010121 |
8 PMED |
702051030011 |
702051030081 |
8 PMED |
702151010051 |
702151010121 |
1 MVIS |
702151010051 |
702151010131 |
1 MVIS |
702151010051 |
702151010141 |
1 MVIS |
702151010051 |
702151010151 |
8 PMED |
702291010041 |
702291010191 |
8 PMED |
702421050011 |
702421050181 |
8 PMED |
702421050011 |
702421050191 |
8 PMED |
702421050011 |
702421050201 |
8 PMED |
702421050011 |
702421050211 |
8 PMED |
702441010071 |
702441010891 |
8 PMED |
702441010071 |
702441010981 |
1 MVIS |
702441010071 |
702441011001 |
1 MVIS |
702441010071 |
702441011131 |
8 PMED |
702441010181 |
702441010831 |
8 PMED |
702441010181 |
702441010901 |
8 PMED |
702441010181 |
702441010991 |
1 MVIS |
702441010181 |
702441011051 |
8 PMED |
702441010181 |
702441011171 |
8 PMED |
702751020041 |
702751020331 |
8 PMED |
702751020041 |
702751020371 |
1 MVIS |
702751020041 |
702751020431 |
8 PMED |
702751020041 |
702751020501 |
8 PMED |
702761010011 |
702761010071 |
8 PMED |
702761010011 |
702761010081 |
8 PMED |
702761010011 |
702761010101 |
8 PMED |
702761010011 |
702761010111 |
8 PMED |
702761010011 |
702761010121 |
8 PMED |
Return to Top
HC-118I. Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
700121030011 |
700121030041 |
8 PMED |
2 |
700121030011 |
700121030061 |
8 PMED |
3 |
700121030011 |
700121030081 |
8 PMED |
4 |
700251030011 |
700251030161 |
1 MVIS |
5 |
700251030011 |
700251030171 |
1 MVIS |
6 |
700251030011 |
700251030181 |
1 MVIS |
7 |
700251030011 |
700251030191 |
8 PMED |
8 |
700251030011 |
700251030211 |
8 PMED |
9 |
700251030011 |
700251030271 |
8 PMED |
10 |
700251030011 |
700251030311 |
8 PMED |
11 |
700271040031 |
700271040081 |
8 PMED |
12 |
700271050061 |
700271050131 |
1 MVIS |
13 |
700271050061 |
700271050151 |
8 PMED |
14 |
700351020091 |
700351020421 |
1 MVIS |
15 |
700351020091 |
700351020481 |
8 PMED |
16 |
700351020091 |
700351020571 |
1 MVIS |
17 |
700351020091 |
700351020601 |
8 PMED |
18 |
700351020091 |
700351020611 |
8 PMED |
19 |
700351020091 |
700351020651 |
8 PMED |
20 |
700351020091 |
700351020671 |
8 PMED |
21 |
700481010071 |
700481010271 |
1 MVIS |
22 |
700481010071 |
700481010291 |
1 MVIS |
23 |
700481010071 |
700481010311 |
8 PMED |
24 |
700481010071 |
700481010371 |
8 PMED |
25 |
700481010071 |
700481010441 |
8 PMED |
26 |
700481010071 |
700481010521 |
8 PMED |
27 |
700701040051 |
700701040121 |
3 EROM |
28 |
700701040051 |
700701040131 |
8 PMED |
29 |
700991010041 |
700991010201 |
8 PMED |
30 |
700991010041 |
700991010261 |
8 PMED |
31 |
701131060041 |
701131060711 |
1 MVIS |
32 |
701131060041 |
701131060761 |
8 PMED |
33 |
701131060041 |
701131060771 |
8 PMED |
34 |
701461010041 |
701461010071 |
8 PMED |
35 |
701461010041 |
701461010081 |
8 PMED |
36 |
701461010041 |
701461010091 |
8 PMED |
37 |
701461010041 |
701461010101 |
8 PMED |
38 |
701461010041 |
701461010111 |
8 PMED |
39 |
701461010041 |
701461010121 |
8 PMED |
40 |
701461010041 |
701461010131 |
8 PMED |
41 |
701461010041 |
701461010141 |
8 PMED |
42 |
701461010041 |
701461010151 |
8 PMED |
43 |
701641030011 |
701641030091 |
1 MVIS |
44 |
701641030011 |
701641030101 |
8 PMED |
45 |
701981010011 |
701981010061 |
1 MVIS |
46 |
701981010011 |
701981010081 |
8 PMED |
47 |
701981010011 |
701981010121 |
8 PMED |
48 |
702051030011 |
702051030081 |
8 PMED |
49 |
702151010051 |
702151010121 |
1 MVIS |
50 |
702151010051 |
702151010131 |
1 MVIS |
Return to Top
HC-118I. Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
700121030041 |
8 PMED |
2 |
700121030061 |
8 PMED |
3 |
700121030081 |
8 PMED |
4 |
700251030161 |
1 MVIS |
5 |
700251030171 |
1 MVIS |
6 |
700251030181 |
1 MVIS |
7 |
700251030191 |
8 PMED |
8 |
700251030211 |
8 PMED |
9 |
700251030271 |
8 PMED |
10 |
700251030311 |
8 PMED |
11 |
700271040081 |
8 PMED |
12 |
700271050131 |
1 MVIS |
13 |
700271050151 |
8 PMED |
14 |
700351020421 |
1 MVIS |
15 |
700351020481 |
8 PMED |
16 |
700351020571 |
1 MVIS |
17 |
700351020601 |
8 PMED |
18 |
700351020611 |
8 PMED |
19 |
700351020651 |
8 PMED |
20 |
700351020671 |
8 PMED |
21 |
700481010271 |
1 MVIS |
22 |
700481010291 |
1 MVIS |
23 |
700481010311 |
8 PMED |
24 |
700481010371 |
8 PMED |
25 |
700481010441 |
8 PMED |
26 |
700481010521 |
8 PMED |
27 |
700701040121 |
3 EROM |
28 |
700701040131 |
8 PMED |
29 |
700991010201 |
8 PMED |
30 |
700991010261 |
8 PMED |
31 |
701131060711 |
1 MVIS |
32 |
701131060761 |
8 PMED |
33 |
701131060771 |
8 PMED |
34 |
701461010071 |
8 PMED |
35 |
701461010081 |
8 PMED |
36 |
701461010091 |
8 PMED |
37 |
701461010101 |
8 PMED |
38 |
701461010111 |
8 PMED |
39 |
701461010121 |
8 PMED |
40 |
701461010131 |
8 PMED |
41 |
701461010141 |
8 PMED |
42 |
701461010151 |
8 PMED |
43 |
701641030091 |
1 MVIS |
44 |
701641030101 |
8 PMED |
45 |
701981010061 |
1 MVIS |
46 |
701981010081 |
8 PMED |
47 |
701981010121 |
8 PMED |
48 |
702051030081 |
8 PMED |
49 |
702151010121 |
1 MVIS |
50 |
702151010131 |
1 MVIS |
Return to Top
HC-118I. Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-118A) records which link to condition
records coded as asthma
LINKIDX |
RXRECIDX |
RXNAME |
RXXP08X |
PERWT08F |
700121030041 |
700121030041001 |
ADVAIR DISKUS 100/50 |
148.71 |
4062.46 |
700121030061 |
700121030061001 |
ADVAIR DISKUS 100/50 |
148.71 |
4062.46 |
700121030081 |
700121030081001 |
ADVAIR DISKUS 100/50 |
155.22 |
4062.46 |
700121030081 |
700121030081002 |
ADVAIR DISKUS 100/50 |
155.22 |
4062.46 |
700121030081 |
700121030081003 |
ADVAIR DISKUS 100/50 |
155.22 |
4062.46 |
700251030191 |
700251030191001 |
XOPENEX (PF) |
84.87 |
3160.81 |
700251030211 |
700251030211001 |
FLOVENT DISKUS |
120.85 |
3160.81 |
700251030271 |
700251030271001 |
XOPENEX (PF) |
157.14 |
3160.81 |
700251030271 |
700251030271002 |
XOPENEX (PF) |
157.14 |
3160.81 |
700251030271 |
700251030271003 |
XOPENEX (PF) |
157.14 |
3160.81 |
700251030311 |
700251030311001 |
ALBUTEROL |
20.99 |
3160.81 |
700251030311 |
700251030311002 |
ALBUTEROL |
20.99 |
3160.81 |
700271040081 |
700271040081001 |
PROVERA |
32.36 |
1048.23 |
700271050151 |
700271050151001 |
XOPENEX HFA
(200 ACTUATIONS) |
52.63 |
1840.44 |
700351020481 |
700351020481001 |
TEMAZEPAM |
5.57 |
9219.77 |
700351020481 |
700351020481002 |
TEMAZEPAM |
5.57 |
9219.77 |
700351020481 |
700351020481003 |
TEMAZEPAM |
5.57 |
9219.77 |
700351020481 |
700351020481004 |
TEMAZEPAM |
5.57 |
9219.77 |
700351020481 |
700351020481005 |
TEMAZEPAM |
5.57 |
9219.77 |
700351020601 |
700351020601001 |
SYMBICORT |
170.29 |
9219.77 |
700351020601 |
700351020601002 |
SYMBICORT |
170.29 |
9219.77 |
700351020611 |
700351020611001 |
SPIRIVA (W/ HANDIHALER) |
147.06 |
9219.77 |
700351020611 |
700351020611002 |
SPIRIVA (W/ HANDIHALER) |
147.06 |
9219.77 |
700351020611 |
700351020611003 |
SPIRIVA (W/ HANDIHALER) |
147.06 |
9219.77 |
700351020611 |
700351020611004 |
SPIRIVA (W/ HANDIHALER) |
147.06 |
9219.77 |
700351020651 |
700351020651001 |
ALBUTEROL |
34.85 |
9219.77 |
700351020651 |
700351020651002 |
ALBUTEROL |
34.85 |
9219.77 |
700351020651 |
700351020651003 |
ALBUTEROL |
34.85 |
9219.77 |
700351020651 |
700351020651004 |
ALBUTEROL |
34.85 |
9219.77 |
700351020671 |
700351020671001 |
SPIRIVA (W/ HANDIHALER) |
147.06 |
9219.77 |
700351020671 |
700351020671002 |
SPIRIVA (W/ HANDIHALER) |
147.06 |
9219.77 |
700481010311 |
700481010311001 |
PROVENTIL HFA (M.D.I.) |
113.33 |
9913.13 |
700481010311 |
700481010311002 |
PROVENTIL HFA (M.D.I.) |
113.33 |
9913.13 |
700481010371 |
700481010371001 |
FLOVENT HFA
(WITH DOSE COUNTER) |
243.38 |
9913.13 |
700481010371 |
700481010371002 |
FLOVENT HFA
(WITH DOSE COUNTER) |
243.38 |
9913.13 |
700481010441 |
700481010441001 |
PROVENTIL HFA (M.D.I.) |
113.33 |
9913.13 |
700481010441 |
700481010441002 |
PROVENTIL HFA (M.D.I.) |
113.33 |
9913.13 |
700481010521 |
700481010521001 |
FLOVENT HFA
(WITH DOSE COUNTER) |
243.38 |
9913.13 |
700481010521 |
700481010521002 |
FLOVENT HFA
(WITH DOSE COUNTER) |
243.38 |
9913.13 |
700701040131 |
700701040131001 |
APAP |
2.85 |
3794.45 |
700991010201 |
700991010201001 |
COMBIVENT |
190.22 |
13330.21 |
700991010201 |
700991010201002 |
COMBIVENT |
190.22 |
13330.21 |
700991010201 |
700991010201003 |
COMBIVENT |
190.22 |
13330.21 |
700991010201 |
700991010201004 |
COMBIVENT |
190.22 |
13330.21 |
700991010201 |
700991010201005 |
COMBIVENT |
190.22 |
13330.21 |
700991010261 |
700991010261001 |
COMBIVENT |
207.17 |
13330.21 |
700991010261 |
700991010261002 |
COMBIVENT |
206.31 |
13330.21 |
700991010261 |
700991010261003 |
COMBIVENT |
206.92 |
13330.21 |
700991010261 |
700991010261004 |
COMBIVENT |
206.92 |
13330.21 |
700991010261 |
700991010261005 |
COMBIVENT |
206.92 |
13330.21 |
701131060761 |
701131060761001 |
ALBUTEROL |
51.56 |
13503.65 |
701131060761 |
701131060761002 |
ALBUTEROL |
50.22 |
13503.65 |
701131060761 |
701131060761003 |
ALBUTEROL |
50.22 |
13503.65 |
701131060771 |
701131060771001 |
FLOVENT HFA |
181.78 |
13503.65 |
701131060771 |
701131060771002 |
FLOVENT HFA |
181.78 |
13503.65 |
701131060771 |
701131060771003 |
FLOVENT HFA |
181.78 |
13503.65 |
701131060771 |
701131060771004 |
FLOVENT HFA |
184.88 |
13503.65 |
701131060771 |
701131060771005 |
FLOVENT HFA |
181.78 |
13503.65 |
701461010071 |
701461010071001 |
ALBUTEROL |
19.46 |
7744.44 |
701461010071 |
701461010071002 |
ALBUTEROL |
19.46 |
7744.44 |
701461010071 |
701461010071003 |
ALBUTEROL |
19.46 |
7744.44 |
701461010081 |
701461010081001 |
SINGULAIR (UNIT OF USE) |
36.44 |
7744.44 |
701461010081 |
701461010081002 |
SINGULAIR |
30.00 |
7744.44 |
701461010081 |
701461010081003 |
SINGULAIR |
30.00 |
7744.44 |
701461010091 |
701461010091001 |
DUONEB (VIAL,U.D.) |
38.03 |
7744.44 |
701461010091 |
701461010091002 |
DUONEB (VIAL,U.D.) |
38.03 |
7744.44 |
701461010091 |
701461010091003 |
DUONEB (VIAL,U.D.) |
38.03 |
7744.44 |
701461010101 |
701461010101001 |
ALBUTEROL |
19.46 |
7744.44 |
701461010101 |
701461010101002 |
ALBUTEROL |
19.46 |
7744.44 |
701461010101 |
701461010101003 |
ALBUTEROL |
19.46 |
7744.44 |
701461010101 |
701461010101004 |
ALBUTEROL |
19.46 |
7744.44 |
701461010101 |
701461010101005 |
ALBUTEROL |
19.46 |
7744.44 |
701461010101 |
701461010101006 |
ALBUTEROL |
19.46 |
7744.44 |
701461010111 |
701461010111001 |
SINGULAIR (UNIT OF USE) |
36.44 |
7744.44 |
701461010111 |
701461010111002 |
SINGULAIR (UNIT OF USE) |
36.44 |
7744.44 |
701461010111 |
701461010111003 |
SINGULAIR (UNIT OF USE) |
36.44 |
7744.44 |
701461010111 |
701461010111004 |
SINGULAIR |
30.00 |
7744.44 |
701461010111 |
701461010111005 |
SINGULAIR |
30.00 |
7744.44 |
701461010111 |
701461010111006 |
SINGULAIR |
30.00 |
7744.44 |
701461010121 |
701461010121001 |
DUONEB (VIAL,U.D.) |
38.03 |
7744.44 |
701461010121 |
701461010121002 |
DUONEB (VIAL,U.D.) |
38.03 |
7744.44 |
701461010121 |
701461010121003 |
DUONEB (VIAL,U.D.) |
38.03 |
7744.44 |
701461010121 |
701461010121004 |
DUONEB (VIAL,U.D.) |
38.03 |
7744.44 |
701461010121 |
701461010121005 |
DUONEB (VIAL,U.D.) |
38.03 |
7744.44 |
701461010121 |
701461010121006 |
DUONEB (VIAL,U.D.) |
38.03 |
7744.44 |
701461010131 |
701461010131001 |
ALBUTEROL |
22.02 |
7744.44 |
701461010131 |
701461010131002 |
ALBUTEROL |
22.02 |
7744.44 |
701461010141 |
701461010141001 |
SINGULAIR (UNIT OF USE) |
36.44 |
7744.44 |
701461010141 |
701461010141002 |
SINGULAIR |
30.00 |
7744.44 |
701461010151 |
701461010151001 |
DUONEB (VIAL,U.D.) |
38.03 |
7744.44 |
701461010151 |
701461010151002 |
DUONEB (VIAL,U.D.) |
38.03 |
7744.44 |
701981010081 |
701981010081001 |
PROAIR HFA |
32.34 |
9361.57 |
701981010121 |
701981010121001 |
PROAIR HFA |
32.34 |
9361.57 |
702051030081 |
702051030081001 |
ALBUTEROL SULFATE (PF) |
11.08 |
4810.46 |
702151010151 |
702151010151001 |
SYMBICORT |
189.80 |
10837.01 |
702151010151 |
702151010151002 |
SYMBICORT |
189.80 |
10837.01 |
702291010191 |
702291010191001 |
ADVAIR DISKUS 250/50 |
186.45 |
5300.32 |
702421050181 |
702421050181001 |
ALBUTEROL |
22.99 |
4630.20 |
702421050181 |
702421050181002 |
ALBUTEROL |
22.99 |
4630.20 |
702421050181 |
702421050181003 |
ALBUTEROL |
22.99 |
4630.20 |
702421050181 |
702421050181004 |
ALBUTEROL |
22.99 |
4630.20 |
702421050191 |
702421050191001 |
TESSALON PERLES |
28.88 |
4630.20 |
702421050191 |
702421050191002 |
TESSALON PERLES |
28.88 |
4630.20 |
702421050191 |
702421050191003 |
TESSALON PERLES |
28.88 |
4630.20 |
702421050201 |
702421050201001 |
ALBUTEROL |
22.99 |
4630.20 |
702421050201 |
702421050201002 |
ALBUTEROL |
22.99 |
4630.20 |
702421050201 |
702421050201003 |
ALBUTEROL |
22.99 |
4630.20 |
702421050211 |
702421050211001 |
FLOVENT HFA
(WITH DOSE COUNTER) |
113.09 |
4630.20 |
702421050211 |
702421050211002 |
FLOVENT HFA
(WITH DOSE COUNTER) |
113.09 |
4630.20 |
702421050211 |
702421050211003 |
FLOVENT HFA
(WITH DOSE COUNTER) |
113.09 |
4630.20 |
702441010831 |
702441010831001 |
PREDNISONE |
2.81 |
14716.20 |
702441010831 |
702441010831002 |
PREDNISONE |
2.81 |
14716.20 |
702441010891 |
702441010891001 |
ADVAIR DISKUS 250/50 |
190.96 |
14716.20 |
702441010891 |
702441010891002 |
ADVAIR DISKUS 250/50 |
190.96 |
14716.20 |
702441010901 |
702441010901001 |
ALBUTEROL SULFATE (PF) |
15.00 |
14716.20 |
702441011051 |
702441011051001 |
PREDNISONE |
2.12 |
14716.20 |
702441011131 |
702441011131001 |
ADVAIR DISKUS 250/50 |
190.96 |
14716.20 |
702441011131 |
702441011131002 |
ADVAIR DISKUS 250/50 |
190.96 |
14716.20 |
702441011171 |
702441011171001 |
TUSSIONEX PENNKINETIC |
126.52 |
14716.20 |
702751020331 |
702751020331001 |
ALBUTEROL |
19.28 |
9972.49 |
702751020331 |
702751020331002 |
ALBUTEROL |
22.02 |
9972.49 |
702751020431 |
702751020431001 |
ALBUTEROL |
19.28 |
9972.49 |
702751020501 |
702751020501001 |
ALBUTEROL |
19.28 |
9972.49 |
702751020501 |
702751020501002 |
ALBUTEROL |
22.02 |
9972.49 |
702761010071 |
702761010071001 |
ADVAIR DISKUS 500/50 |
150.00 |
17419.15 |
702761010081 |
702761010081001 |
SINGULAIR (UNIT OF USE) |
104.51 |
17419.15 |
702761010101 |
702761010101001 |
ADVAIR DISKUS 500/50 |
264.93 |
17419.15 |
702761010101 |
702761010101002 |
ADVAIR DISKUS 500/50 |
264.93 |
17419.15 |
702761010111 |
702761010111001 |
PREDNISONE |
10.00 |
17419.15 |
702761010121 |
702761010121001 |
ZYRTEC |
25.00 |
17419.15 |
702761010121 |
702761010121002 |
ZYRTEC |
71.93 |
17419.15 |
702761010131 |
702761010131001 |
SINGULAIR |
326.81 |
17419.15 |
702761010131 |
702761010131002 |
SINGULAIR |
326.81 |
17419.15 |
702831011061 |
702831011061001 |
ADVAIR HFA |
251.36 |
9248.17 |
702831011061 |
702831011061002 |
ADVAIR HFA |
251.36 |
9248.17 |
702831011061 |
702831011061003 |
ADVAIR HFA |
264.93 |
9248.17 |
702831011061 |
702831011061004 |
ADVAIR HFA |
264.93 |
9248.17 |
702831011061 |
702831011061005 |
ADVAIR HFA |
264.93 |
9248.17 |
702831011081 |
702831011081001 |
ALBUTEROL |
19.46 |
9248.17 |
702831011081 |
702831011081002 |
ALBUTEROL |
19.46 |
9248.17 |
702831011081 |
702831011081003 |
ALBUTEROL |
19.46 |
9248.17 |
702901010251 |
702901010251001 |
ALBUTEROL |
26.65 |
2565.23 |
702901010251 |
702901010251002 |
ALBUTEROL |
26.65 |
2565.23 |
702901010251 |
702901010251003 |
ALBUTEROL |
26.65 |
2565.23 |
702901010251 |
702901010251004 |
ALBUTEROL |
26.65 |
2565.23 |
702901010251 |
702901010251005 |
ALBUTEROL |
26.65 |
2565.23 |
702901010261 |
702901010261001 |
ADVAIR DISKUS 500/50 |
254.33 |
2565.23 |
702901010261 |
702901010261002 |
ADVAIR DISKUS 500/50 |
254.33 |
2565.23 |
702901010261 |
702901010261003 |
ADVAIR DISKUS 500/50 |
254.33 |
2565.23 |
702901010261 |
702901010261004 |
ADVAIR DISKUS 500/50 |
254.33 |
2565.23 |
702901010261 |
702901010261005 |
ADVAIR DISKUS 500/50 |
268.06 |
2565.23 |
702901010271 |
702901010271001 |
SPIRIVA (W/ HANDIHALER) |
149.04 |
2565.23 |
703041010501 |
703041010501001 |
SINGULAIR (UNIT OF USE) |
326.81 |
11530.29 |
703041010501 |
703041010501002 |
SINGULAIR (UNIT OF USE) |
326.81 |
11530.29 |
703041010511 |
703041010511001 |
SEREVENT DISKUS |
311.95 |
11530.29 |
703041010511 |
703041010511002 |
SEREVENT DISKUS |
311.95 |
11530.29 |
703041010601 |
703041010601001 |
SINGULAIR (UNIT OF USE) |
326.81 |
11530.29 |
703121010321 |
703121010321001 |
ALBUTEROL SULFATE (PF) |
43.94 |
2675.14 |
703121010321 |
703121010321002 |
ALBUTEROL SULFATE (PF) |
43.94 |
2675.14 |
703121010321 |
703121010321003 |
ALBUTEROL SULFATE (PF) |
43.94 |
2675.14 |
703121010321 |
703121010321004 |
ALBUTEROL SULFATE (PF) |
43.94 |
2675.14 |
703121010321 |
703121010321005 |
ALBUTEROL SULFATE (PF) |
43.94 |
2675.14 |
703121010331 |
703121010331001 |
IPRATROPIUM BROMIDE (PF) |
521.53 |
2675.14 |
703121010331 |
703121010331002 |
IPRATROPIUM BROMIDE (PF) |
521.53 |
2675.14 |
703121010331 |
703121010331003 |
IPRATROPIUM BROMIDE (PF) |
521.53 |
2675.14 |
703121010331 |
703121010331004 |
IPRATROPIUM BROMIDE (PF) |
521.53 |
2675.14 |
703121010331 |
703121010331005 |
IPRATROPIUM BROMIDE (PF) |
521.53 |
2675.14 |
703121010451 |
703121010451001 |
ALBUTEROL SULFATE (PF) |
40.00 |
2675.14 |
703121010451 |
703121010451002 |
ALBUTEROL SULFATE (PF) |
40.00 |
2675.14 |
703121010451 |
703121010451003 |
ALBUTEROL SULFATE (PF) |
40.00 |
2675.14 |
703121010451 |
703121010451004 |
ALBUTEROL SULFATE (PF) |
40.00 |
2675.14 |
703141010471 |
703141010471001 |
PROAIR HFA |
96.24 |
19159.04 |
703261010261 |
703261010261001 |
ADVAIR DISKUS 100/50 |
149.34 |
3783.89 |
703261010361 |
703261010361001 |
ADVAIR DISKUS 100/50 |
149.34 |
3783.89 |
703261010361 |
703261010361002 |
ADVAIR DISKUS 100/50 |
149.34 |
3783.89 |
703261010361 |
703261010361003 |
ADVAIR DISKUS 100/50 |
149.34 |
3783.89 |
703261010361 |
703261010361004 |
ADVAIR DISKUS 100/50 |
149.34 |
3783.89 |
703261010361 |
703261010361005 |
ADVAIR DISKUS 100/50 |
149.34 |
3783.89 |
703261010361 |
703261010361006 |
ADVAIR DISKUS 100/50 |
155.89 |
3783.89 |
703261010361 |
703261010361007 |
ADVAIR DISKUS 100/50 |
155.89 |
3783.89 |
703261010451 |
703261010451001 |
ADVAIR DISKUS 100/50 |
155.89 |
3783.89 |
703261010451 |
703261010451002 |
ADVAIR DISKUS 100/50 |
155.89 |
3783.89 |
703261010451 |
703261010451003 |
ADVAIR DISKUS 100/50 |
155.89 |
3783.89 |
703341030141 |
703341030141001 |
SINGULAIR |
107.82 |
4891.94 |
703341030141 |
703341030141002 |
SINGULAIR |
107.82 |
4891.94 |
703341030141 |
703341030141003 |
SINGULAIR |
107.82 |
4891.94 |
703341030141 |
703341030141004 |
SINGULAIR |
107.82 |
4891.94 |
703341030141 |
703341030141005 |
SINGULAIR |
107.82 |
4891.94 |
703341030141 |
703341030141006 |
SINGULAIR |
107.82 |
4891.94 |
703341030151 |
703341030151001 |
ALBUTEROL SULFATE |
11.48 |
4891.94 |
703341030151 |
703341030151002 |
ALBUTEROL SULFATE |
11.48 |
4891.94 |
703341030151 |
703341030151003 |
ALBUTEROL SULFATE |
11.48 |
4891.94 |
703341030151 |
703341030151004 |
ALBUTEROL SULFATE |
11.48 |
4891.94 |
703341030151 |
703341030151005 |
ALBUTEROL SULFATE |
11.48 |
4891.94 |
703341030151 |
703341030151006 |
ALBUTEROL SULFATE |
11.48 |
4891.94 |
703341030161 |
703341030161001 |
PULMICORT RESPULES (5X6) |
373.22 |
4891.94 |
703341030161 |
703341030161002 |
PULMICORT RESPULES (5X6) |
373.22 |
4891.94 |
703341030161 |
703341030161003 |
PULMICORT RESPULES (5X6) |
373.22 |
4891.94 |
703341030161 |
703341030161004 |
PULMICORT RESPULES (5X6) |
373.22 |
4891.94 |
703341030161 |
703341030161005 |
PULMICORT RESPULES (5X6) |
373.22 |
4891.94 |
703341030161 |
703341030161006 |
PULMICORT RESPULES (5X6) |
373.22 |
4891.94 |
703341040101 |
703341040101001 |
SINGULAIR (UNIT OF USE) |
102.38 |
6236.38 |
703341040101 |
703341040101002 |
SINGULAIR (UNIT OF USE) |
102.38 |
6236.38 |
703341040101 |
703341040101003 |
SINGULAIR (UNIT OF USE) |
102.38 |
6236.38 |
703341040101 |
703341040101004 |
SINGULAIR (UNIT OF USE) |
102.38 |
6236.38 |
703341040101 |
703341040101005 |
SINGULAIR (UNIT OF USE) |
102.38 |
6236.38 |
703341040101 |
703341040101006 |
SINGULAIR (UNIT OF USE) |
102.38 |
6236.38 |
703341040111 |
703341040111001 |
PULMICORT RESPULES (5X6) |
373.22 |
6236.38 |
703341040111 |
703341040111002 |
PULMICORT RESPULES (5X6) |
373.22 |
6236.38 |
703341040111 |
703341040111003 |
PULMICORT RESPULES (5X6) |
373.22 |
6236.38 |
703341040111 |
703341040111004 |
PULMICORT RESPULES (5X6) |
373.22 |
6236.38 |
703341040111 |
703341040111005 |
PULMICORT RESPULES (5X6) |
373.22 |
6236.38 |
703341040111 |
703341040111006 |
PULMICORT RESPULES (5X6) |
373.22 |
6236.38 |
703341040121 |
703341040121001 |
ALBUTEROL SULFATE |
18.99 |
6236.38 |
703341040121 |
703341040121002 |
ALBUTEROL SULFATE |
18.99 |
6236.38 |
703341040121 |
703341040121003 |
ALBUTEROL SULFATE |
18.99 |
6236.38 |
703341040121 |
703341040121004 |
ALBUTEROL SULFATE |
18.99 |
6236.38 |
703341040121 |
703341040121005 |
ALBUTEROL SULFATE |
18.99 |
6236.38 |
703341040121 |
703341040121006 |
ALBUTEROL SULFATE |
18.99 |
6236.38 |
703561020021 |
703561020021001 |
PROAIR HFA |
20.00 |
3379.73 |
703561020031 |
703561020031001 |
SYMBICORT |
167.04 |
3379.73 |
703601010171 |
703601010171001 |
SPIRIVA (W/HANDIHALER) |
146.81 |
10819.95 |
703601010191 |
703601010191001 |
ALBUTEROL |
26.99 |
10819.95 |
703601010231 |
703601010231001 |
ALBUTEROL |
22.02 |
10819.95 |
703651030201 |
703651030201001 |
ALBUTEROL SULFATE HFA |
29.54 |
10572.43 |
703651030251 |
703651030251001 |
ALBUTEROL SULFATE HFA |
29.54 |
10572.43 |
703651030251 |
703651030251002 |
ALBUTEROL SULFATE HFA |
29.54 |
10572.43 |
703651030261 |
703651030261001 |
PREDNISONE |
5.74 |
10572.43 |
703651030261 |
703651030261002 |
PREDNISONE |
5.74 |
10572.43 |
703651030331 |
703651030331001 |
SINGULAIR (UNIT OF USE) |
111.53 |
10572.43 |
703651030331 |
703651030331002 |
SINGULAIR (UNIT OF USE) |
111.53 |
10572.43 |
703651030331 |
703651030331003 |
SINGULAIR (UNIT OF USE) |
111.53 |
10572.43 |
703651030331 |
703651030331004 |
SINGULAIR (UNIT OF USE) |
111.53 |
10572.43 |
703651030331 |
703651030331005 |
SINGULAIR (UNIT OF USE) |
111.53 |
10572.43 |
703821030052 |
703821030052001 |
SINGULAIR (UNIT OF USE) |
103.85 |
6538.26 |
703821030092 |
703821030092001 |
SINGULAIR (UNIT OF USE) |
103.85 |
6538.26 |
703821030092 |
703821030092002 |
SINGULAIR (UNIT OF USE) |
103.85 |
6538.26 |
703821030092 |
703821030092003 |
SINGULAIR (UNIT OF USE) |
103.85 |
6538.26 |
703821030092 |
703821030092004 |
SINGULAIR (UNIT OF USE) |
103.85 |
6538.26 |
703821030092 |
703821030092005 |
SINGULAIR (UNIT OF USE) |
103.85 |
6538.26 |
703821030092 |
703821030092006 |
SINGULAIR (UNIT OF USE) |
103.85 |
6538.26 |
703821030102 |
703821030102001 |
PROAIR HFA |
38.50 |
6538.26 |
703821030102 |
703821030102002 |
PROAIR HFA |
38.50 |
6538.26 |
703881010231 |
703881010231001 |
ADVAIR DISKUS 100/50 |
155.95 |
8001.77 |
703881010231 |
703881010231002 |
ADVAIR DISKUS 100/50 |
155.95 |
8001.77 |
703881010231 |
703881010231003 |
ADVAIR DISKUS 100/50 |
155.95 |
8001.77 |
704101010421 |
704101010421001 |
IPRATROPIUM BROMIDE
(WITH METERED SPRAY PUMP) |
20.75 |
7324.60 |
704281010831 |
704281010831001 |
PROAIR HFA |
34.45 |
15545.99 |
704281010831 |
704281010831002 |
PROAIR HFA |
39.22 |
15545.99 |
704281010831 |
704281010831003 |
PROAIR HFA |
39.22 |
15545.99 |
704281020411 |
704281020411001 |
ALBUTEROL |
19.18 |
12968.13 |
704281020421 |
704281020421001 |
FLOVENT HFA |
112.25 |
12968.13 |
704311050131 |
704311050131001 |
ALBUTEROL |
19.46 |
7093.50 |
704311050141 |
704311050141001 |
PULMICORT RESPULES (5X6) |
178.74 |
7093.50 |
704641040051 |
704641040051001 |
ALBUTEROL SULFATE |
10.99 |
5978.43 |
704641040051 |
704641040051002 |
ALBUTEROL SULFATE |
10.99 |
5978.43 |
704781020201 |
704781020201001 |
FLOVENT HFA |
115.26 |
15276.22 |
704781020211 |
704781020211001 |
SINGULAIR (UNIT OF USE) |
106.53 |
15276.22 |
704781020341 |
704781020341001 |
FLOVENT HFA |
365.06 |
15276.22 |
704781020481 |
704781020481001 |
ALBUTEROL |
25.86 |
15276.22 |
704781020491 |
704781020491001 |
PULMICORT FLEXHALER |
123.27 |
15276.22 |
704921020251 |
704921020251001 |
SODIUM CHLORIDE |
19.95 |
25608.94 |
704961020371 |
704961020371001 |
ADVAIR DISKUS 100/50 |
157.24 |
2200.26 |
704961020501 |
704961020501001 |
ADVAIR DISKUS 100/50 |
157.24 |
2200.26 |
704961020611 |
704961020611001 |
PROAIR HFA |
30.00 |
2200.26 |
704961020611 |
704961020611002 |
PROAIR HFA |
30.00 |
2200.26 |
704961020611 |
704961020611003 |
PROAIR HFA |
30.00 |
2200.26 |
704961020611 |
704961020611004 |
PROAIR HFA |
30.00 |
2200.26 |
704961020621 |
704961020621001 |
SPIRIVA (W/ HANDIHALER) |
150.82 |
2200.26 |
705121020431 |
705121020431001 |
FLOVENT HFA
(WITH DOSE COUNTER) |
85.64 |
10239.60 |
705121020441 |
705121020441001 |
PROAIR HFA |
32.08 |
10239.60 |
705551030051 |
705551030051001 |
AEROCHAMBER |
37.29 |
5229.16 |
705671010311 |
705671010311001 |
SINGULAIR |
30.00 |
3682.77 |
705671010321 |
705671010321001 |
ADVAIR DISKUS 250/50 |
381.92 |
3682.77 |
705671010381 |
705671010381001 |
PREDNISONE |
2.95 |
3682.77 |
705671010441 |
705671010441001 |
ACCOLATE |
271.15 |
3682.77 |
705671010451 |
705671010451001 |
ADVAIR DISKUS 100/50 |
471.73 |
3682.77 |
705711010351 |
705711010351001 |
ALBUTEROL |
27.15 |
5454.32 |
705751020311 |
705751020311001 |
IPRATROPIUM BROMIDE
(VIAL,PF) |
31.50 |
7097.32 |
705751020311 |
705751020311002 |
IPRATROPIUM BROMIDE
(VIAL,PF) |
31.50 |
7097.32 |
705751020461 |
705751020461001 |
ALBUTEROL SULFATE (VIAL) |
23.85 |
7097.32 |
705751020461 |
705751020461002 |
ALBUTEROL SULFATE (VIAL) |
11.93 |
7097.32 |
705751020481 |
705751020481001 |
ADVAIR DISKUS 500/50 |
250.83 |
7097.32 |
705751020481 |
705751020481002 |
ADVAIR DISKUS 500/50 |
250.83 |
7097.32 |
705751020481 |
705751020481003 |
ADVAIR DISKUS 500/50 |
752.50 |
7097.32 |
705841012181 |
705841012181001 |
PREDNISONE |
10.00 |
9597.15 |
705841012181 |
705841012181002 |
PREDNISONE |
10.00 |
9597.15 |
705841012241 |
705841012241001 |
SINGULAIR (UNIT OF USE) |
104.97 |
9597.15 |
705841012241 |
705841012241002 |
SINGULAIR (UNIT OF USE) |
104.97 |
9597.15 |
705841012241 |
705841012241003 |
SINGULAIR (UNIT OF USE) |
104.97 |
9597.15 |
705841012241 |
705841012241004 |
SINGULAIR (UNIT OF USE) |
104.97 |
9597.15 |
705841012241 |
705841012241005 |
SINGULAIR (UNIT OF USE) |
104.97 |
9597.15 |
705841012241 |
705841012241006 |
SINGULAIR (UNIT OF USE) |
104.97 |
9597.15 |
706111020641 |
706111020641001 |
ADVAIR DISKUS 250/50 |
190.96 |
6402.33 |
706111020641 |
706111020641002 |
ADVAIR DISKUS 250/50 |
190.96 |
6402.33 |
706111020641 |
706111020641003 |
ADVAIR DISKUS 250/50 |
190.96 |
6402.33 |
706111020641 |
706111020641004 |
ADVAIR DISKUS 250/50 |
190.96 |
6402.33 |
706111020641 |
706111020641005 |
ADVAIR DISKUS 250/50 |
190.96 |
6402.33 |
706141010841 |
706141010841001 |
SPIRIVA |
463.67 |
9565.65 |
706141010841 |
706141010841002 |
SPIRIVA |
463.67 |
9565.65 |
Return to Top
HC-118I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Analysis Variable : RXXP08X SUM OF PAYMENTS RXSF08X-RXOU08X(IMPUTED)
Return to Top
HC-118I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
Analysis Variable : RXXP08X SUM OF PAYMENTS RXSF08X-RXOU08X(IMPUTED)
Return to Top
NOTE: Copyright (c) 2002-2008 by SAS Institute
Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
Licensed to WESTAT INC, Site 70006348.
NOTE: This session is executing on the XP_PRO
platform.
NOTE: SAS initialization used:
real time 0.64 seconds
cpu time 0.42 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.01 seconds
cpu time 0.01 seconds
I:\SASTRACE\TRACE92\
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.01 seconds
NOTE: AUTOEXEC processing completed.
1 ods rtf file = 'c:\sampleC.rtf' bodytitle;
NOTE: Writing RTF Body file: c:\sampleC.rtf
2
3 ods noproctitle;
4
5 OPTIONS LS=132 PS=59;
6
7 TITLE1 "HC-118I";
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.07 seconds
cpu time 0.01 seconds
26
27
*-----------------------------------------------------------------------------------
28 * Get conditions records coded as asthma.
29
*-----------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H120 (KEEP=CONDIDX CCCODEX);
32 IF CCCODEX="128";
33 RUN;
NOTE: There were 102169 observations read from the
data set IN.H120.
NOTE: The data set WORK.ASCONDS has 2100
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
34
35
*------------------------------------------------------------------------------------
36 * Get the events linked to each of the asthma
condition records.
37
*------------------------------------------------------------------------------------;
38 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: There were 2100 observations read from the
data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2100
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 (H120) 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.01 seconds
44
45 PROC SORT DATA=IN.H118IF1 OUT=CLNK; BY CONDIDX;
RUN;
NOTE: There were 294294 observations read from the
data set IN.H118IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 294294
observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 2.23 seconds
cpu time 0.31 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 294294 observations read from the
data set WORK.CLNK.
NOTE: There were 2100 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 6546
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.07 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.62 seconds
cpu time 0.00 seconds
61
62 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 6546 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 6546
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.04 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 6546 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6543
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
74
75 proc print data=asclnks (obs=50);
76 format eventype eventype.;
77 title3 "sample print of unique evntidxs from
work.asclnks";
78 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.04 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.H118G (KEEP=EVNTIDX PERWT08F SEETLKPV
OBXP08X);
85 IF PERWT08F > 0 & SEETLKPV NE 2;
86 RUN;
NOTE: There were 136460 observations read from the
data set IN.H118G.
NOTE: The data set WORK.MVIS has 132104
observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.09 seconds
87
88 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 132104 observations read from the
data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 132104
observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.07 seconds
cpu time 0.14 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 6543 observations read from the
data set WORK.ASCLNKS.
NOTE: There were 132104 observations read from the
data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1842
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.15 seconds
cpu time 0.03 seconds
99
100 proc print data=asmvis (obs=50);
101 format eventype eventype.;
102 title3 "sample print of work.asmvis";
103 title4 "unique evntidxs from work.asclnks that
are non-telephone MVIS (HC-118G) 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.56 seconds
cpu time 0.01 seconds
105
106 PROC MEANS DATA=ASMVIS N SUM;
107 VAR OBXP08X;
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 1842 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.14 seconds
cpu time 0.00 seconds
110
111 PROC MEANS DATA=ASMVIS N SUM;
112 VAR OBXP08X;
113 WEIGHT PERWT08F;
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 1842 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.09 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 5.93 seconds
cpu time 1.48 seconds
Return to Top
HC-118I. Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx
Obs |
CONDIDX |
CCCODEX |
1 |
700121030011 |
128 |
2 |
700251010031 |
128 |
3 |
700251030011 |
128 |
4 |
700271030011 |
128 |
5 |
700271040031 |
128 |
6 |
700271050061 |
128 |
7 |
700351020091 |
128 |
8 |
700481010071 |
128 |
9 |
700701040051 |
128 |
10 |
700991010041 |
128 |
11 |
701131060041 |
128 |
12 |
701461010041 |
128 |
13 |
701641030011 |
128 |
14 |
701971030021 |
128 |
15 |
701981010011 |
128 |
16 |
702051030011 |
128 |
17 |
702151010051 |
128 |
18 |
702291010041 |
128 |
19 |
702421050011 |
128 |
20 |
702441010071 |
128 |
21 |
702441010181 |
128 |
22 |
702731030022 |
128 |
23 |
702751020041 |
128 |
24 |
702761010011 |
128 |
25 |
702831010061 |
128 |
26 |
702851010021 |
128 |
27 |
702901010041 |
128 |
28 |
702901010061 |
128 |
29 |
702981040031 |
128 |
30 |
703041010021 |
128 |
31 |
703121010051 |
128 |
32 |
703141010031 |
128 |
33 |
703261010041 |
128 |
34 |
703341030011 |
128 |
35 |
703341040011 |
128 |
36 |
703461030011 |
128 |
37 |
703561020021 |
128 |
38 |
703601010051 |
128 |
39 |
703601030023 |
128 |
40 |
703651030011 |
128 |
41 |
703741010041 |
128 |
42 |
703821030011 |
128 |
43 |
703881010031 |
128 |
44 |
703951010021 |
128 |
45 |
704101010051 |
128 |
46 |
704171010061 |
128 |
47 |
704281010051 |
128 |
48 |
704281020011 |
128 |
49 |
704311050011 |
128 |
50 |
704641040011 |
128 |
Return to Top
HC-118I. Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
700121030011 |
700121030041 |
8 PMED |
700121030011 |
700121030061 |
8 PMED |
700121030011 |
700121030081 |
8 PMED |
700251030011 |
700251030161 |
1 MVIS |
700251030011 |
700251030171 |
1 MVIS |
700251030011 |
700251030181 |
1 MVIS |
700251030011 |
700251030191 |
8 PMED |
700251030011 |
700251030211 |
8 PMED |
700251030011 |
700251030271 |
8 PMED |
700251030011 |
700251030311 |
8 PMED |
700271040031 |
700271040081 |
8 PMED |
700271050061 |
700271050131 |
1 MVIS |
700271050061 |
700271050151 |
8 PMED |
700351020091 |
700351020421 |
1 MVIS |
700351020091 |
700351020481 |
8 PMED |
700351020091 |
700351020571 |
1 MVIS |
700351020091 |
700351020601 |
8 PMED |
700351020091 |
700351020611 |
8 PMED |
700351020091 |
700351020651 |
8 PMED |
700351020091 |
700351020671 |
8 PMED |
700481010071 |
700481010271 |
1 MVIS |
700481010071 |
700481010291 |
1 MVIS |
700481010071 |
700481010311 |
8 PMED |
700481010071 |
700481010371 |
8 PMED |
700481010071 |
700481010441 |
8 PMED |
700481010071 |
700481010521 |
8 PMED |
700701040051 |
700701040121 |
3 EROM |
700701040051 |
700701040131 |
8 PMED |
700991010041 |
700991010201 |
8 PMED |
700991010041 |
700991010261 |
8 PMED |
701131060041 |
701131060711 |
1 MVIS |
701131060041 |
701131060761 |
8 PMED |
701131060041 |
701131060771 |
8 PMED |
701461010041 |
701461010071 |
8 PMED |
701461010041 |
701461010081 |
8 PMED |
701461010041 |
701461010091 |
8 PMED |
701461010041 |
701461010101 |
8 PMED |
701461010041 |
701461010111 |
8 PMED |
701461010041 |
701461010121 |
8 PMED |
701461010041 |
701461010131 |
8 PMED |
701461010041 |
701461010141 |
8 PMED |
701461010041 |
701461010151 |
8 PMED |
701641030011 |
701641030091 |
1 MVIS |
701641030011 |
701641030101 |
8 PMED |
701981010011 |
701981010061 |
1 MVIS |
701981010011 |
701981010081 |
8 PMED |
701981010011 |
701981010121 |
8 PMED |
702051030011 |
702051030081 |
8 PMED |
702151010051 |
702151010121 |
1 MVIS |
702151010051 |
702151010131 |
1 MVIS |
702151010051 |
702151010141 |
1 MVIS |
702151010051 |
702151010151 |
8 PMED |
702291010041 |
702291010191 |
8 PMED |
702421050011 |
702421050181 |
8 PMED |
702421050011 |
702421050191 |
8 PMED |
702421050011 |
702421050201 |
8 PMED |
702421050011 |
702421050211 |
8 PMED |
702441010071 |
702441010891 |
8 PMED |
702441010071 |
702441010981 |
1 MVIS |
702441010071 |
702441011001 |
1 MVIS |
702441010071 |
702441011131 |
8 PMED |
702441010181 |
702441010831 |
8 PMED |
702441010181 |
702441010901 |
8 PMED |
702441010181 |
702441010991 |
1 MVIS |
702441010181 |
702441011051 |
8 PMED |
702441010181 |
702441011171 |
8 PMED |
702751020041 |
702751020331 |
8 PMED |
702751020041 |
702751020371 |
1 MVIS |
702751020041 |
702751020431 |
8 PMED |
702751020041 |
702751020501 |
8 PMED |
702761010011 |
702761010071 |
8 PMED |
702761010011 |
702761010081 |
8 PMED |
702761010011 |
702761010101 |
8 PMED |
702761010011 |
702761010111 |
8 PMED |
702761010011 |
702761010121 |
8 PMED |
Return to Top
HC-118I. Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
700121030011 |
700121030041 |
8 PMED |
2 |
700121030011 |
700121030061 |
8 PMED |
3 |
700121030011 |
700121030081 |
8 PMED |
4 |
700251030011 |
700251030161 |
1 MVIS |
5 |
700251030011 |
700251030171 |
1 MVIS |
6 |
700251030011 |
700251030181 |
1 MVIS |
7 |
700251030011 |
700251030191 |
8 PMED |
8 |
700251030011 |
700251030211 |
8 PMED |
9 |
700251030011 |
700251030271 |
8 PMED |
10 |
700251030011 |
700251030311 |
8 PMED |
11 |
700271040031 |
700271040081 |
8 PMED |
12 |
700271050061 |
700271050131 |
1 MVIS |
13 |
700271050061 |
700271050151 |
8 PMED |
14 |
700351020091 |
700351020421 |
1 MVIS |
15 |
700351020091 |
700351020481 |
8 PMED |
16 |
700351020091 |
700351020571 |
1 MVIS |
17 |
700351020091 |
700351020601 |
8 PMED |
18 |
700351020091 |
700351020611 |
8 PMED |
19 |
700351020091 |
700351020651 |
8 PMED |
20 |
700351020091 |
700351020671 |
8 PMED |
21 |
700481010071 |
700481010271 |
1 MVIS |
22 |
700481010071 |
700481010291 |
1 MVIS |
23 |
700481010071 |
700481010311 |
8 PMED |
24 |
700481010071 |
700481010371 |
8 PMED |
25 |
700481010071 |
700481010441 |
8 PMED |
26 |
700481010071 |
700481010521 |
8 PMED |
27 |
700701040051 |
700701040121 |
3 EROM |
28 |
700701040051 |
700701040131 |
8 PMED |
29 |
700991010041 |
700991010201 |
8 PMED |
30 |
700991010041 |
700991010261 |
8 PMED |
31 |
701131060041 |
701131060711 |
1 MVIS |
32 |
701131060041 |
701131060761 |
8 PMED |
33 |
701131060041 |
701131060771 |
8 PMED |
34 |
701461010041 |
701461010071 |
8 PMED |
35 |
701461010041 |
701461010081 |
8 PMED |
36 |
701461010041 |
701461010091 |
8 PMED |
37 |
701461010041 |
701461010101 |
8 PMED |
38 |
701461010041 |
701461010111 |
8 PMED |
39 |
701461010041 |
701461010121 |
8 PMED |
40 |
701461010041 |
701461010131 |
8 PMED |
41 |
701461010041 |
701461010141 |
8 PMED |
42 |
701461010041 |
701461010151 |
8 PMED |
43 |
701641030011 |
701641030091 |
1 MVIS |
44 |
701641030011 |
701641030101 |
8 PMED |
45 |
701981010011 |
701981010061 |
1 MVIS |
46 |
701981010011 |
701981010081 |
8 PMED |
47 |
701981010011 |
701981010121 |
8 PMED |
48 |
702051030011 |
702051030081 |
8 PMED |
49 |
702151010051 |
702151010121 |
1 MVIS |
50 |
702151010051 |
702151010131 |
1 MVIS |
Return to Top
HC-118I. Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
700121030041 |
8 PMED |
2 |
700121030061 |
8 PMED |
3 |
700121030081 |
8 PMED |
4 |
700251030161 |
1 MVIS |
5 |
700251030171 |
1 MVIS |
6 |
700251030181 |
1 MVIS |
7 |
700251030191 |
8 PMED |
8 |
700251030211 |
8 PMED |
9 |
700251030271 |
8 PMED |
10 |
700251030311 |
8 PMED |
11 |
700271040081 |
8 PMED |
12 |
700271050131 |
1 MVIS |
13 |
700271050151 |
8 PMED |
14 |
700351020421 |
1 MVIS |
15 |
700351020481 |
8 PMED |
16 |
700351020571 |
1 MVIS |
17 |
700351020601 |
8 PMED |
18 |
700351020611 |
8 PMED |
19 |
700351020651 |
8 PMED |
20 |
700351020671 |
8 PMED |
21 |
700481010271 |
1 MVIS |
22 |
700481010291 |
1 MVIS |
23 |
700481010311 |
8 PMED |
24 |
700481010371 |
8 PMED |
25 |
700481010441 |
8 PMED |
26 |
700481010521 |
8 PMED |
27 |
700701040121 |
3 EROM |
28 |
700701040131 |
8 PMED |
29 |
700991010201 |
8 PMED |
30 |
700991010261 |
8 PMED |
31 |
701131060711 |
1 MVIS |
32 |
701131060761 |
8 PMED |
33 |
701131060771 |
8 PMED |
34 |
701461010071 |
8 PMED |
35 |
701461010081 |
8 PMED |
36 |
701461010091 |
8 PMED |
37 |
701461010101 |
8 PMED |
38 |
701461010111 |
8 PMED |
39 |
701461010121 |
8 PMED |
40 |
701461010131 |
8 PMED |
41 |
701461010141 |
8 PMED |
42 |
701461010151 |
8 PMED |
43 |
701641030091 |
1 MVIS |
44 |
701641030101 |
8 PMED |
45 |
701981010061 |
1 MVIS |
46 |
701981010081 |
8 PMED |
47 |
701981010121 |
8 PMED |
48 |
702051030081 |
8 PMED |
49 |
702151010121 |
1 MVIS |
50 |
702151010131 |
1 MVIS |
Return to Top
HC-118I. Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-118G) events
Obs |
EVNTIDX |
EVENTYPE |
SEETLKPV |
OBXP08X |
PERWT08F |
1 |
700251030161 |
1 MVIS |
1 |
121.50 |
3160.81 |
2 |
700251030171 |
1 MVIS |
1 |
37.64 |
3160.81 |
3 |
700251030181 |
1 MVIS |
1 |
37.64 |
3160.81 |
4 |
700271050131 |
1 MVIS |
1 |
99.16 |
1840.44 |
5 |
700351020421 |
1 MVIS |
1 |
76.00 |
9219.77 |
6 |
700351020571 |
1 MVIS |
1 |
188.03 |
9219.77 |
7 |
700481010271 |
1 MVIS |
1 |
186.89 |
9913.13 |
8 |
700481010291 |
1 MVIS |
1 |
246.06 |
9913.13 |
9 |
701131060711 |
1 MVIS |
1 |
50.63 |
13503.65 |
10 |
701981010061 |
1 MVIS |
1 |
158.30 |
9361.57 |
11 |
702151010121 |
1 MVIS |
1 |
1569.17 |
10837.01 |
12 |
702151010131 |
1 MVIS |
1 |
178.28 |
10837.01 |
13 |
702151010141 |
1 MVIS |
1 |
48.00 |
10837.01 |
14 |
702441010981 |
1 MVIS |
1 |
191.00 |
14716.20 |
15 |
702441010991 |
1 MVIS |
1 |
165.00 |
14716.20 |
16 |
702441011001 |
1 MVIS |
1 |
242.00 |
14716.20 |
17 |
702751020371 |
1 MVIS |
1 |
100.57 |
9972.49 |
18 |
702761010141 |
1 MVIS |
1 |
134.40 |
17419.15 |
19 |
703121010201 |
1 MVIS |
1 |
63.26 |
2675.14 |
20 |
703121010211 |
1 MVIS |
1 |
63.26 |
2675.14 |
21 |
703121010221 |
1 MVIS |
1 |
63.26 |
2675.14 |
22 |
703261010331 |
1 MVIS |
1 |
85.68 |
3783.89 |
23 |
703261010341 |
1 MVIS |
1 |
194.02 |
3783.89 |
24 |
703261010421 |
1 MVIS |
1 |
1330.83 |
3783.89 |
25 |
703561020011 |
1 MVIS |
1 |
75.00 |
3379.73 |
26 |
703601010211 |
1 MVIS |
1 |
0.00 |
10819.95 |
27 |
703651030231 |
1 MVIS |
1 |
124.00 |
10572.43 |
28 |
704281020371 |
1 MVIS |
1 |
79.14 |
12968.13 |
29 |
704281020381 |
1 MVIS |
1 |
79.14 |
12968.13 |
30 |
704641040031 |
1 MVIS |
1 |
189.00 |
5978.43 |
31 |
704781020461 |
1 MVIS |
1 |
64.31 |
15276.22 |
32 |
704781020471 |
1 MVIS |
1 |
64.31 |
15276.22 |
33 |
704921020241 |
1 MVIS |
1 |
107.55 |
25608.94 |
34 |
705121020401 |
1 MVIS |
1 |
95.00 |
10239.60 |
35 |
705121020421 |
1 MVIS |
1 |
163.14 |
10239.60 |
36 |
705551030041 |
1 MVIS |
1 |
17.42 |
5229.16 |
37 |
705671010351 |
1 MVIS |
1 |
98.00 |
3682.77 |
38 |
705671010361 |
1 MVIS |
1 |
65.00 |
3682.77 |
39 |
705751020271 |
1 MVIS |
1 |
215.00 |
7097.32 |
40 |
705841011771 |
1 MVIS |
1 |
161.28 |
9597.15 |
41 |
705841011781 |
1 MVIS |
1 |
57.00 |
9597.15 |
42 |
705841012341 |
1 MVIS |
1 |
46.80 |
9597.15 |
43 |
706601010231 |
1 MVIS |
1 |
88.56 |
9964.53 |
44 |
706601010241 |
1 MVIS |
1 |
82.77 |
9964.53 |
45 |
706601010251 |
1 MVIS |
1 |
88.56 |
9964.53 |
46 |
706601010261 |
1 MVIS |
1 |
14.19 |
9964.53 |
47 |
706801010391 |
1 MVIS |
1 |
53.40 |
8658.20 |
48 |
706801010401 |
1 MVIS |
1 |
53.40 |
8658.20 |
49 |
706801010411 |
1 MVIS |
1 |
85.60 |
8658.20 |
50 |
706801010421 |
1 MVIS |
1 |
85.60 |
8658.20 |
Return to Top
HC-118I. Sample SAS Job for Example C
Total medical visit expenditures (excluding
telephone) associated with asthma
Analysis Variable : OBXP08X SUM OF OBSF08X - OBOT08X (IMPUTED)
Return to Top
HC-118I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
Analysis Variable : OBXP08X SUM OF OBSF08X - OBOT08X (IMPUTED)
Return to Top
|