MEPS HC-126I: 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)
NOTE: This session is executing on the XP_PRO platform.
NOTE: SAS initialization used:
real time 1.46 seconds
cpu time 0.42 seconds
NOTE: AUTOEXEC processing beginning; file is C:\Program Files\SAS92\SASFoundation\9.2\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 ods rtf file = 'c:\sampleA.rtf' bodytitle;
NOTE: Writing RTF Body file: c:\sampleA.rtf
2
3 ods noproctitle;
4
5 OPTIONS LS=132 PS=59;
6
7 TITLE1 "HC-126I";
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.23 seconds
cpu time 0.00 seconds
28
29
*-------------------------------------------------------------------------------------
30 * Get condition records coded as asthma.
31
*-------------------------------------------------------------------------------------;
32 DATA ASCONDS;
33 SET IN.H128 (KEEP=CONDIDX CCCODEX);
34 IF CCCODEX="128";
35
36 RUN;
NOTE: There were 117342 observations read from the
data set IN.H128.
NOTE: The data set WORK.ASCONDS has 2420
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 5.40 seconds
cpu time 0.10 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 2420 observations read from the data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2420 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.15 seconds
cpu time 0.01 seconds
42
43 proc print data=asconds (obs=50);
44 title3 "sample print of work.asconds - sorted by condidx";
45 title4 "COND (H128) 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.53 seconds
cpu time 0.01 seconds
47
48 PROC SORT DATA=IN.H126IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: There were 342044 observations read from the data set IN.H126IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 342044 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 7.68 seconds
cpu time 0.59 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 342044 observations read from the
data set WORK.CLNK.
NOTE: There were 2420 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7669
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 1.09 seconds
cpu time 0.07 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 1.84 seconds
cpu time 0.01 seconds
64
65 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7669 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 7669
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
66
67 proc print data=asclnks (obs=50);
68 format eventype eventype.;
69 title3 "sample print of work.asclnks - sorted by
evntidx";
70 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.78 seconds
cpu time 0.00 seconds
71
72 DATA ASCLNKS;
73 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
74 BY EVNTIDX;
75 IF FIRST.EVNTIDX;
76 RUN;
NOTE: There were 7669 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7667
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
77
78 proc print data=asclnks (obs=50);
79 title3 "sample print of unique evntidxs from
work.asclnks";
80 format eventype eventype.;
81 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 1.06 seconds
cpu time 0.03 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.H126G (KEEP=EVNTIDX PERWT09F SEETLKPV);
88 IF PERWT09F > 0 & SEETLKPV NE 2;
89 RUN;
NOTE: There were 154599 observations read from the
data set IN.H126G.
NOTE: The data set WORK.MVIS has 149890
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 16.81 seconds
cpu time 0.26 seconds
90
91 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 149890 observations read from the
data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 149890
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.10 seconds
cpu time 0.14 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 7667 observations read from the
data set WORK.ASCLNKS.
NOTE: There were 149890 observations read from the
data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 2286
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 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-126G) 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.03 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.H126IF2 OUT=RXLK; BY EVNTIDX;
RUN;
NOTE: There were 61487 observations read from the
data set IN.H126IF2.
NOTE: SAS sort was used.
NOTE: The data set WORK.RXLK has 61487 observations
and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 1.12 seconds
cpu time 0.14 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-126IF2)";
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.07 seconds
cpu time 0.00 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 61487 observations read from the
data set WORK.RXLK.
NOTE: There were 2286 observations read from the
data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 2260
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
129
130 proc print data=pmedids (obs=50);
131 by evntidx;
132 id evntidx;
133 format eventype eventype.;
134 title3 "sample print of work.pmedids - sorted
by evntidx";
135 title4 "work.rxlk records for evntidxs in
work.asmvis";
136 run;
NOTE: There were 50 observations read from the data
set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed pages 12-13.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.07 seconds
cpu time 0.00 seconds
137
138 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: There were 2260 observations read from the
data set WORK.PMEDIDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.PMEDIDS has 2260
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 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.62 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 2260 observations read from the
data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 2160
observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
150
151 proc print data=pmedids (obs=50);
152 title3 "sample print of unique linkidxs in
work.pmedids";
153 run;
NOTE: There were 50 observations read from the data
set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
154
155
*-----------------------------------------------------------------------------------------
156 * Get PMED records linked to MVIS events which
were for asthma.
157
*-----------------------------------------------------------------------------------------;
158 PROC SORT DATA=IN.H126A OUT=PMED; BY LINKIDX;
RUN;
NOTE: There were 333629 observations read from the
data set IN.H126A.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.PMED has 333629
observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 34.71 seconds
cpu time 1.09 seconds
159
160 DATA MVPMEDS;
161 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP09X
PERWT09F RXNAME)
162 PMEDIDS (IN=A);
163 BY LINKIDX;
164 IF A;
165 RUN;
NOTE: There were 333629 observations read from the
data set WORK.PMED.
NOTE: There were 2160 observations read from the
data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 5649
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 1.25 seconds
cpu time 0.10 seconds
166
167 proc print data=mvpmeds (obs=200);
168 var rxrecidx rxname RXXP09X PERWT09F;
169 by linkidx;
170 id linkidx;
171 title3 "sample print of work.mvpmeds";
172 title4 "PMED (HC-126A) 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.23 seconds
cpu time 0.01 seconds
174
175 PROC MEANS DATA=MVPMEDS N SUM;
176 VAR RXXP09X;
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 5649 observations read from the
data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 22.
NOTE: PROCEDURE MEANS used (Total process time):
real time 2.46 seconds
cpu time 0.03 seconds
179
180 PROC MEANS DATA=MVPMEDS N SUM;
181 VAR RXXP09X;
182 WEIGHT PERWT09F;
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 5649 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.23 seconds
cpu time 0.06 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 1:23.95
cpu time 3.63 seconds
Return to Top
HC-126I. Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H128) records where cccodex=128
Obs |
CONDIDX |
CCCODEX |
1 |
400011010011 |
128 |
2 |
400011030011 |
128 |
3 |
400441010101 |
128 |
4 |
400501010021 |
128 |
5 |
400521010101 |
128 |
6 |
400841010091 |
128 |
7 |
400881020041 |
128 |
8 |
401051050011 |
128 |
9 |
401481020061 |
128 |
10 |
401601010041 |
128 |
11 |
401901010031 |
128 |
12 |
401911030011 |
128 |
13 |
402121010021 |
128 |
14 |
402121020011 |
128 |
15 |
402151010011 |
128 |
16 |
402151020041 |
128 |
17 |
402151030011 |
128 |
18 |
402271010011 |
128 |
19 |
402331020051 |
128 |
20 |
402361020011 |
128 |
21 |
402451030011 |
128 |
22 |
402841010081 |
128 |
23 |
403491040011 |
128 |
24 |
403601030011 |
128 |
25 |
403691020021 |
128 |
26 |
403691050021 |
128 |
27 |
403691060011 |
128 |
28 |
403701020061 |
128 |
29 |
403701020161 |
128 |
30 |
403751020061 |
128 |
31 |
403761020041 |
128 |
32 |
403831010041 |
128 |
33 |
403851020041 |
128 |
34 |
403881010081 |
128 |
35 |
403881020011 |
128 |
36 |
404001010031 |
128 |
37 |
404062010022 |
128 |
38 |
404122010032 |
128 |
39 |
404381030011 |
128 |
40 |
404401020041 |
128 |
41 |
404561010031 |
128 |
42 |
404581020011 |
128 |
43 |
404701010031 |
128 |
44 |
404891010031 |
128 |
45 |
405021050011 |
128 |
46 |
405021060011 |
128 |
47 |
405041010011 |
128 |
48 |
405191020011 |
128 |
49 |
405311040011 |
128 |
50 |
405391030011 |
128 |
Return to Top
HC-126I. Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
400011010011 |
400011010061 |
8 PMED |
400011010011 |
400011010101 |
8 PMED |
400011030011 |
400011030081 |
8 PMED |
400441010101 |
400441010411 |
8 PMED |
400501010021 |
400501010011 |
8 PMED |
400501010021 |
400501010051 |
8 PMED |
400501010021 |
400501010091 |
8 PMED |
400501010021 |
400501010121 |
8 PMED |
400521010101 |
400521010031 |
1 MVIS |
400521010101 |
400521010041 |
1 MVIS |
400521010101 |
400521010131 |
8 PMED |
400881020041 |
400881020021 |
1 MVIS |
400881020041 |
400881020031 |
1 MVIS |
400881020041 |
400881020041 |
1 MVIS |
400881020041 |
400881020051 |
8 PMED |
400881020041 |
400881020061 |
8 PMED |
400881020041 |
400881020071 |
8 PMED |
400881020041 |
400881020081 |
8 PMED |
400881020041 |
400881020091 |
1 MVIS |
400881020041 |
400881020101 |
1 MVIS |
400881020041 |
400881020111 |
8 PMED |
401051050011 |
401051050011 |
8 PMED |
401051050011 |
401051050031 |
8 PMED |
401601010041 |
401601010281 |
8 PMED |
401601010041 |
401601010311 |
8 PMED |
401601010041 |
401601010321 |
1 MVIS |
401601010041 |
401601010331 |
1 MVIS |
401601010041 |
401601010341 |
1 MVIS |
401601010041 |
401601010471 |
8 PMED |
401911030011 |
401911030011 |
1 MVIS |
401911030011 |
401911030021 |
1 MVIS |
401911030011 |
401911030031 |
1 MVIS |
401911030011 |
401911030041 |
1 MVIS |
401911030011 |
401911030051 |
1 MVIS |
401911030011 |
401911030091 |
8 PMED |
401911030011 |
401911030131 |
1 MVIS |
401911030011 |
401911030141 |
8 PMED |
402121020011 |
402121020011 |
3 EROM |
402121020011 |
402121020041 |
8 PMED |
402121020011 |
402121020051 |
8 PMED |
402121020011 |
402121020061 |
8 PMED |
402151010011 |
402151010041 |
8 PMED |
402151010011 |
402151010061 |
8 PMED |
402151030011 |
402151030051 |
8 PMED |
402331020051 |
402331020241 |
8 PMED |
402361020011 |
402361020021 |
8 PMED |
402841010081 |
402841010291 |
8 PMED |
403491040011 |
403491040041 |
8 PMED |
403491040011 |
403491040051 |
8 PMED |
403491040011 |
403491040061 |
1 MVIS |
403491040011 |
403491040091 |
8 PMED |
403491040011 |
403491040111 |
8 PMED |
403491040011 |
403491040121 |
8 PMED |
403601030011 |
403601030111 |
8 PMED |
403601030011 |
403601030121 |
8 PMED |
403601030011 |
403601030131 |
8 PMED |
403601030011 |
403601030141 |
8 PMED |
403691020021 |
403691020041 |
1 MVIS |
403691020021 |
403691020051 |
1 MVIS |
403691020021 |
403691020061 |
1 MVIS |
403691020021 |
403691020071 |
1 MVIS |
403691020021 |
403691020081 |
1 MVIS |
403691020021 |
403691020091 |
1 MVIS |
403691020021 |
403691020101 |
1 MVIS |
403691020021 |
403691020111 |
1 MVIS |
403691050021 |
403691050041 |
1 MVIS |
403691050021 |
403691050051 |
1 MVIS |
403691060011 |
403691060011 |
1 MVIS |
403691060011 |
403691060041 |
8 PMED |
403701020061 |
403701020141 |
8 PMED |
403701020061 |
403701020161 |
8 PMED |
403701020061 |
403701020291 |
8 PMED |
403701020061 |
403701020311 |
8 PMED |
403701020061 |
403701020351 |
8 PMED |
403751020061 |
403751020111 |
8 PMED |
Return to Top
HC-126I. Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
400011010011 |
400011010061 |
8 PMED |
2 |
400011010011 |
400011010101 |
8 PMED |
3 |
400011030011 |
400011030081 |
8 PMED |
4 |
400441010101 |
400441010411 |
8 PMED |
5 |
400501010021 |
400501010011 |
8 PMED |
6 |
400501010021 |
400501010051 |
8 PMED |
7 |
400501010021 |
400501010091 |
8 PMED |
8 |
400501010021 |
400501010121 |
8 PMED |
9 |
400521010101 |
400521010031 |
1 MVIS |
10 |
400521010101 |
400521010041 |
1 MVIS |
11 |
400521010101 |
400521010131 |
8 PMED |
12 |
400881020041 |
400881020021 |
1 MVIS |
13 |
400881020041 |
400881020031 |
1 MVIS |
14 |
400881020041 |
400881020041 |
1 MVIS |
15 |
400881020041 |
400881020051 |
8 PMED |
16 |
400881020041 |
400881020061 |
8 PMED |
17 |
400881020041 |
400881020071 |
8 PMED |
18 |
400881020041 |
400881020081 |
8 PMED |
19 |
400881020041 |
400881020091 |
1 MVIS |
20 |
400881020041 |
400881020101 |
1 MVIS |
21 |
400881020041 |
400881020111 |
8 PMED |
22 |
401051050011 |
401051050011 |
8 PMED |
23 |
401051050011 |
401051050031 |
8 PMED |
24 |
401601010041 |
401601010281 |
8 PMED |
25 |
401601010041 |
401601010311 |
8 PMED |
26 |
401601010041 |
401601010321 |
1 MVIS |
27 |
401601010041 |
401601010331 |
1 MVIS |
28 |
401601010041 |
401601010341 |
1 MVIS |
29 |
401601010041 |
401601010471 |
8 PMED |
30 |
401911030011 |
401911030011 |
1 MVIS |
31 |
401911030011 |
401911030021 |
1 MVIS |
32 |
401911030011 |
401911030031 |
1 MVIS |
33 |
401911030011 |
401911030041 |
1 MVIS |
34 |
401911030011 |
401911030051 |
1 MVIS |
35 |
401911030011 |
401911030091 |
8 PMED |
36 |
401911030011 |
401911030131 |
1 MVIS |
37 |
401911030011 |
401911030141 |
8 PMED |
38 |
402121020011 |
402121020011 |
3 EROM |
39 |
402121020011 |
402121020041 |
8 PMED |
40 |
402121020011 |
402121020051 |
8 PMED |
41 |
402121020011 |
402121020061 |
8 PMED |
42 |
402151010011 |
402151010041 |
8 PMED |
43 |
402151010011 |
402151010061 |
8 PMED |
44 |
402151030011 |
402151030051 |
8 PMED |
45 |
402331020051 |
402331020241 |
8 PMED |
46 |
402361020011 |
402361020021 |
8 PMED |
47 |
402841010081 |
402841010291 |
8 PMED |
48 |
403491040011 |
403491040041 |
8 PMED |
49 |
403491040011 |
403491040051 |
8 PMED |
50 |
403491040011 |
403491040061 |
1 MVIS |
Return to Top
HC-126I. Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
400011010061 |
8 PMED |
2 |
400011010101 |
8 PMED |
3 |
400011030081 |
8 PMED |
4 |
400441010411 |
8 PMED |
5 |
400501010011 |
8 PMED |
6 |
400501010051 |
8 PMED |
7 |
400501010091 |
8 PMED |
8 |
400501010121 |
8 PMED |
9 |
400521010031 |
1 MVIS |
10 |
400521010041 |
1 MVIS |
11 |
400521010131 |
8 PMED |
12 |
400881020021 |
1 MVIS |
13 |
400881020031 |
1 MVIS |
14 |
400881020041 |
1 MVIS |
15 |
400881020051 |
8 PMED |
16 |
400881020061 |
8 PMED |
17 |
400881020071 |
8 PMED |
18 |
400881020081 |
8 PMED |
19 |
400881020091 |
1 MVIS |
20 |
400881020101 |
1 MVIS |
21 |
400881020111 |
8 PMED |
22 |
401051050011 |
8 PMED |
23 |
401051050031 |
8 PMED |
24 |
401601010281 |
8 PMED |
25 |
401601010311 |
8 PMED |
26 |
401601010321 |
1 MVIS |
27 |
401601010331 |
1 MVIS |
28 |
401601010341 |
1 MVIS |
29 |
401601010471 |
8 PMED |
30 |
401911030011 |
1 MVIS |
31 |
401911030021 |
1 MVIS |
32 |
401911030031 |
1 MVIS |
33 |
401911030041 |
1 MVIS |
34 |
401911030051 |
1 MVIS |
35 |
401911030091 |
8 PMED |
36 |
401911030131 |
1 MVIS |
37 |
401911030141 |
8 PMED |
38 |
402121020011 |
3 EROM |
39 |
402121020041 |
8 PMED |
40 |
402121020051 |
8 PMED |
41 |
402121020061 |
8 PMED |
42 |
402151010041 |
8 PMED |
43 |
402151010061 |
8 PMED |
44 |
402151030051 |
8 PMED |
45 |
402331020241 |
8 PMED |
46 |
402361020021 |
8 PMED |
47 |
402841010291 |
8 PMED |
48 |
403491040041 |
8 PMED |
49 |
403491040051 |
8 PMED |
50 |
403491040061 |
1 MVIS |
Return to Top
HC-126I. Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are
non-telephone MVIS (HC-126G) events
Obs |
EVNTIDX |
EVENTYPE |
1 |
400521010031 |
1 MVIS |
2 |
400521010041 |
1 MVIS |
3 |
400881020021 |
1 MVIS |
4 |
400881020031 |
1 MVIS |
5 |
400881020041 |
1 MVIS |
6 |
400881020091 |
1 MVIS |
7 |
400881020101 |
1 MVIS |
8 |
401601010321 |
1 MVIS |
9 |
401601010331 |
1 MVIS |
10 |
401601010341 |
1 MVIS |
11 |
401911030011 |
1 MVIS |
12 |
401911030021 |
1 MVIS |
13 |
401911030031 |
1 MVIS |
14 |
401911030041 |
1 MVIS |
15 |
401911030051 |
1 MVIS |
16 |
401911030131 |
1 MVIS |
17 |
403491040061 |
1 MVIS |
18 |
403691020041 |
1 MVIS |
19 |
403691020051 |
1 MVIS |
20 |
403691020061 |
1 MVIS |
21 |
403691020071 |
1 MVIS |
22 |
403691020081 |
1 MVIS |
23 |
403691020091 |
1 MVIS |
24 |
403691020101 |
1 MVIS |
25 |
403691020111 |
1 MVIS |
26 |
403691050041 |
1 MVIS |
27 |
403691050051 |
1 MVIS |
28 |
403691060011 |
1 MVIS |
29 |
403751020221 |
1 MVIS |
30 |
403751020251 |
1 MVIS |
31 |
403751020261 |
1 MVIS |
32 |
403751020461 |
1 MVIS |
33 |
403751020471 |
1 MVIS |
34 |
403761020011 |
1 MVIS |
35 |
403761020021 |
1 MVIS |
36 |
403761020031 |
1 MVIS |
37 |
403761020181 |
1 MVIS |
38 |
403761020191 |
1 MVIS |
39 |
403761020201 |
1 MVIS |
40 |
403761020211 |
1 MVIS |
41 |
403761020451 |
1 MVIS |
42 |
404001010011 |
1 MVIS |
43 |
404381030071 |
1 MVIS |
44 |
404381030081 |
1 MVIS |
45 |
404381030091 |
1 MVIS |
46 |
404381030101 |
1 MVIS |
47 |
404401020211 |
1 MVIS |
48 |
404401020491 |
1 MVIS |
49 |
404401020541 |
1 MVIS |
50 |
404561010261 |
1 MVIS |
Return to Top
HC-126I. Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-126IF2)
EVNTIDX |
LINKIDX |
EVENTYPE |
400011010041 |
400011010051 |
1 MVIS |
400011010071 |
400011010091 |
1 MVIS |
400011020051 |
400011020061 |
1 MVIS |
400011020101 |
400011020151 |
1 MVIS |
400011020131 |
400011020161 |
1 MVIS |
400011020131 |
400011020171 |
1 MVIS |
400011030031 |
400011030071 |
1 MVIS |
400011030091 |
400011030151 |
1 MVIS |
400011030091 |
400011030161 |
1 MVIS |
400011030111 |
400011030171 |
1 MVIS |
400011030201 |
400011030251 |
1 MVIS |
400011030231 |
400011030261 |
1 MVIS |
400031010011 |
400031010021 |
5 DVIS |
400051020011 |
400051020051 |
1 MVIS |
400051020011 |
400051020061 |
1 MVIS |
400051020011 |
400051020071 |
1 MVIS |
400051020011 |
400051020081 |
1 MVIS |
400061010011 |
400061010051 |
5 DVIS |
400061010031 |
400061010061 |
1 MVIS |
400061010031 |
400061010071 |
1 MVIS |
400061010091 |
400061010101 |
1 MVIS |
400061010091 |
400061010111 |
1 MVIS |
400061020011 |
400061020041 |
5 DVIS |
400061020021 |
400061020051 |
5 DVIS |
400061020031 |
400061020061 |
1 MVIS |
400061020031 |
400061020071 |
1 MVIS |
400061020101 |
400061020111 |
1 MVIS |
400061040051 |
400061040041 |
1 MVIS |
400101010011 |
400101010071 |
1 MVIS |
400101010091 |
400101010161 |
1 MVIS |
400101020011 |
400101020061 |
4 STAZ |
400101030011 |
400101030051 |
1 MVIS |
400101030011 |
400101030061 |
1 MVIS |
400101030011 |
400101030071 |
1 MVIS |
400101030021 |
400101030051 |
1 MVIS |
400101030031 |
400101030061 |
1 MVIS |
400101030041 |
400101030061 |
1 MVIS |
400101030081 |
400101030091 |
1 MVIS |
400111020251 |
400111020281 |
1 MVIS |
400121010011 |
400121010021 |
1 MVIS |
400141010021 |
400141010031 |
1 MVIS |
400141040011 |
400141040021 |
3 EROM |
400151010011 |
400151010061 |
4 STAZ |
400151020051 |
400151020071 |
1 MVIS |
400151020051 |
400151020081 |
1 MVIS |
400151020051 |
400151020091 |
1 MVIS |
400151020061 |
400151020101 |
1 MVIS |
400171010041 |
400171010091 |
1 MVIS |
400171010081 |
400171010101 |
3 EROM |
400171010081 |
400171010111 |
3 EROM |
400171010081 |
400171010121 |
3 EROM |
400171010141 |
400171010151 |
1 MVIS |
400171020011 |
400171020041 |
1 MVIS |
400171020021 |
400171020041 |
1 MVIS |
400171020031 |
400171020041 |
1 MVIS |
400171020051 |
400171020081 |
1 MVIS |
400171030031 |
400171030061 |
1 MVIS |
400171030071 |
400171030111 |
1 MVIS |
400211010011 |
400211010061 |
3 EROM |
400211010101 |
400211010121 |
1 MVIS |
400211030031 |
400211030061 |
3 EROM |
400211030041 |
400211030071 |
1 MVIS |
400211030051 |
400211030081 |
1 MVIS |
400211050021 |
400211050031 |
1 MVIS |
400211060011 |
400211060051 |
1 MVIS |
400211060071 |
400211060061 |
3 EROM |
400211070011 |
400211070021 |
3 EROM |
400211070061 |
400211070081 |
1 MVIS |
400211070061 |
400211070091 |
1 MVIS |
400231010011 |
400231010041 |
3 EROM |
400231010021 |
400231010041 |
4 STAZ |
400231030091 |
400231030161 |
4 STAZ |
400241010031 |
400241010071 |
1 MVIS |
400241010031 |
400241010081 |
1 MVIS |
400241010091 |
400241010131 |
1 MVIS |
400241010091 |
400241010141 |
1 MVIS |
400241010091 |
400241010151 |
1 MVIS |
400241020021 |
400241020041 |
1 MVIS |
400251010011 |
400251010021 |
2 OPAT |
400251010011 |
400251010031 |
2 OPAT |
400251010011 |
400251010041 |
2 OPAT |
400281010121 |
400281010131 |
4 STAZ |
400281050011 |
400281050021 |
1 MVIS |
400281050031 |
400281050041 |
1 MVIS |
400281060011 |
400281060021 |
1 MVIS |
400281060011 |
400281060031 |
1 MVIS |
400281060011 |
400281060041 |
1 MVIS |
400281060051 |
400281060081 |
1 MVIS |
400281060051 |
400281060101 |
1 MVIS |
400281060071 |
400281060091 |
1 MVIS |
400291010031 |
400291010051 |
1 MVIS |
400291010041 |
400291010061 |
1 MVIS |
400291030011 |
400291030041 |
1 MVIS |
400291030021 |
400291030051 |
1 MVIS |
400291030031 |
400291030061 |
1 MVIS |
400291030071 |
400291030131 |
1 MVIS |
400291040041 |
400291040081 |
1 MVIS |
400291040051 |
400291040091 |
1 MVIS |
400291040061 |
400291040101 |
1 MVIS |
400311040011 |
400311040051 |
1 MVIS |
400311040011 |
400311040061 |
1 MVIS |
400311040021 |
400311040071 |
1 MVIS |
400311040021 |
400311040081 |
1 MVIS |
400311040021 |
400311040091 |
1 MVIS |
400311040021 |
400311040101 |
1 MVIS |
400311040021 |
400311040111 |
1 MVIS |
400311040021 |
400311040121 |
1 MVIS |
400311040021 |
400311040131 |
1 MVIS |
400311040021 |
400311040141 |
1 MVIS |
400311040021 |
400311040151 |
1 MVIS |
400311040021 |
400311040161 |
1 MVIS |
400311040021 |
400311040171 |
1 MVIS |
400311040031 |
400311040181 |
1 MVIS |
400311050021 |
400311050041 |
1 MVIS |
400311050021 |
400311050051 |
1 MVIS |
400311050021 |
400311050061 |
1 MVIS |
400311050021 |
400311050071 |
1 MVIS |
400311050021 |
400311050081 |
1 MVIS |
400311050021 |
400311050091 |
1 MVIS |
400311050021 |
400311050101 |
1 MVIS |
400311050021 |
400311050111 |
1 MVIS |
400351010031 |
400351010081 |
1 MVIS |
400351010031 |
400351010091 |
1 MVIS |
400361010011 |
400361010021 |
5 DVIS |
400361010031 |
400361010061 |
5 DVIS |
400361010031 |
400361010071 |
5 DVIS |
400371010011 |
400371010021 |
4 STAZ |
400371010011 |
400371010031 |
4 STAZ |
400371010091 |
400371010131 |
1 MVIS |
400371010091 |
400371010141 |
1 MVIS |
400371010091 |
400371010151 |
1 MVIS |
400371010091 |
400371010161 |
1 MVIS |
400381010071 |
400381010111 |
1 MVIS |
400381010071 |
400381010121 |
1 MVIS |
400381010071 |
400381010131 |
1 MVIS |
400381010141 |
400381010171 |
1 MVIS |
400381010141 |
400381010181 |
1 MVIS |
400391010041 |
400391010121 |
1 MVIS |
400391010041 |
400391010131 |
1 MVIS |
400391010151 |
400391010201 |
1 MVIS |
Return to Top
HC-126I. 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 |
400881020021 |
400881020061 |
1 MVIS |
400881020021 |
400881020071 |
1 MVIS |
400881020021 |
400881020081 |
1 MVIS |
400881020091 |
400881020111 |
1 MVIS |
401601010321 |
401601010441 |
1 MVIS |
401601010321 |
401601010451 |
1 MVIS |
401601010321 |
401601010471 |
1 MVIS |
401601010321 |
401601010491 |
1 MVIS |
401911030131 |
401911030141 |
1 MVIS |
401911030131 |
401911030151 |
1 MVIS |
403691020041 |
403691020131 |
1 MVIS |
403691020041 |
403691020141 |
1 MVIS |
403691020101 |
403691020151 |
1 MVIS |
403691020101 |
403691020161 |
1 MVIS |
403691050041 |
403691050061 |
1 MVIS |
403691050051 |
403691050071 |
1 MVIS |
403691060011 |
403691060031 |
1 MVIS |
403691060011 |
403691060041 |
1 MVIS |
403761020011 |
403761020051 |
1 MVIS |
403761020011 |
403761020061 |
1 MVIS |
403761020011 |
403761020071 |
1 MVIS |
403761020011 |
403761020081 |
1 MVIS |
403761020011 |
403761020091 |
1 MVIS |
403761020011 |
403761020101 |
1 MVIS |
403761020011 |
403761020111 |
1 MVIS |
403761020011 |
403761020121 |
1 MVIS |
403761020011 |
403761020131 |
1 MVIS |
403761020181 |
403761020261 |
1 MVIS |
403761020181 |
403761020271 |
1 MVIS |
403761020181 |
403761020281 |
1 MVIS |
403761020181 |
403761020291 |
1 MVIS |
403761020181 |
403761020301 |
1 MVIS |
403761020181 |
403761020311 |
1 MVIS |
403761020181 |
403761020321 |
1 MVIS |
403761020181 |
403761020331 |
1 MVIS |
403761020181 |
403761020341 |
1 MVIS |
403761020181 |
403761020351 |
1 MVIS |
403761020451 |
403761020541 |
1 MVIS |
403761020451 |
403761020551 |
1 MVIS |
403761020451 |
403761020561 |
1 MVIS |
404001010011 |
404001010021 |
1 MVIS |
405021050011 |
405021050051 |
1 MVIS |
405021050011 |
405021050061 |
1 MVIS |
405021050011 |
405021050071 |
1 MVIS |
405021060011 |
405021060031 |
1 MVIS |
405021060011 |
405021060041 |
1 MVIS |
405021060011 |
405021060051 |
1 MVIS |
405581010011 |
405581010031 |
1 MVIS |
405581010011 |
405581010041 |
1 MVIS |
405581010011 |
405581010051 |
1 MVIS |
Return to Top
HC-126I. Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx
Obs |
EVNTIDX |
LINKIDX |
EVENTYPE |
1 |
400881020021 |
400881020061 |
1 MVIS |
2 |
400881020021 |
400881020071 |
1 MVIS |
3 |
400881020021 |
400881020081 |
1 MVIS |
4 |
400881020091 |
400881020111 |
1 MVIS |
5 |
401601010321 |
401601010441 |
1 MVIS |
6 |
401601010321 |
401601010451 |
1 MVIS |
7 |
401601010321 |
401601010471 |
1 MVIS |
8 |
401601010321 |
401601010491 |
1 MVIS |
9 |
401911030131 |
401911030141 |
1 MVIS |
10 |
401911030131 |
401911030151 |
1 MVIS |
11 |
403691020041 |
403691020131 |
1 MVIS |
12 |
403691020041 |
403691020141 |
1 MVIS |
13 |
403691020101 |
403691020151 |
1 MVIS |
14 |
403691020101 |
403691020161 |
1 MVIS |
15 |
403691050041 |
403691050061 |
1 MVIS |
16 |
403691050051 |
403691050071 |
1 MVIS |
17 |
403691060011 |
403691060031 |
1 MVIS |
18 |
403691060011 |
403691060041 |
1 MVIS |
19 |
403761020011 |
403761020051 |
1 MVIS |
20 |
403761020011 |
403761020061 |
1 MVIS |
21 |
403761020011 |
403761020071 |
1 MVIS |
22 |
403761020011 |
403761020081 |
1 MVIS |
23 |
403761020011 |
403761020091 |
1 MVIS |
24 |
403761020011 |
403761020101 |
1 MVIS |
25 |
403761020011 |
403761020111 |
1 MVIS |
26 |
403761020011 |
403761020121 |
1 MVIS |
27 |
403761020011 |
403761020131 |
1 MVIS |
28 |
403761020181 |
403761020261 |
1 MVIS |
29 |
403761020181 |
403761020271 |
1 MVIS |
30 |
403761020181 |
403761020281 |
1 MVIS |
31 |
403761020181 |
403761020291 |
1 MVIS |
32 |
403761020181 |
403761020301 |
1 MVIS |
33 |
403761020181 |
403761020311 |
1 MVIS |
34 |
403761020181 |
403761020321 |
1 MVIS |
35 |
403761020181 |
403761020331 |
1 MVIS |
36 |
403761020181 |
403761020341 |
1 MVIS |
37 |
403761020181 |
403761020351 |
1 MVIS |
38 |
403761020451 |
403761020541 |
1 MVIS |
39 |
403761020451 |
403761020551 |
1 MVIS |
40 |
403761020451 |
403761020561 |
1 MVIS |
41 |
404001010011 |
404001010021 |
1 MVIS |
42 |
405021050011 |
405021050051 |
1 MVIS |
43 |
405021050011 |
405021050061 |
1 MVIS |
44 |
405021050011 |
405021050071 |
1 MVIS |
45 |
405021060011 |
405021060031 |
1 MVIS |
46 |
405021060011 |
405021060041 |
1 MVIS |
47 |
405021060011 |
405021060051 |
1 MVIS |
48 |
405581010011 |
405581010031 |
1 MVIS |
49 |
405581010011 |
405581010041 |
1 MVIS |
50 |
405581010011 |
405581010051 |
1 MVIS |
Return to Top
HC-126I. Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids
Obs |
LINKIDX |
1 |
400881020061 |
2 |
400881020071 |
3 |
400881020081 |
4 |
400881020111 |
5 |
401601010441 |
6 |
401601010451 |
7 |
401601010471 |
8 |
401601010491 |
9 |
401911030141 |
10 |
401911030151 |
11 |
403691020131 |
12 |
403691020141 |
13 |
403691020151 |
14 |
403691020161 |
15 |
403691050061 |
16 |
403691050071 |
17 |
403691060031 |
18 |
403691060041 |
19 |
403761020051 |
20 |
403761020061 |
21 |
403761020071 |
22 |
403761020081 |
23 |
403761020091 |
24 |
403761020101 |
25 |
403761020111 |
26 |
403761020121 |
27 |
403761020131 |
28 |
403761020261 |
29 |
403761020271 |
30 |
403761020281 |
31 |
403761020291 |
32 |
403761020301 |
33 |
403761020311 |
34 |
403761020321 |
35 |
403761020331 |
36 |
403761020341 |
37 |
403761020351 |
38 |
403761020541 |
39 |
403761020551 |
40 |
403761020561 |
41 |
404001010021 |
42 |
405021050051 |
43 |
405021050061 |
44 |
405021050071 |
45 |
405021060031 |
46 |
405021060041 |
47 |
405021060051 |
48 |
405581010031 |
49 |
405581010041 |
50 |
405581010051 |
Return to Top
HC-126I. Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-126A) records for unique linkidxs in work.pmedids
LINKIDX |
RXRECIDX |
RXNAME |
RXXP09X |
PERWT09F |
400881020061 |
400881020061001 |
ACIPHEX |
185.59 |
3579.012187 |
400881020061 |
400881020061002 |
ACIPHEX |
185.59 |
3579.012187 |
400881020071 |
400881020071001 |
SYMBICORT |
223.99 |
3579.012187 |
400881020071 |
400881020071002 |
SYMBICORT |
248.69 |
3579.012187 |
400881020081 |
400881020081001 |
SPIRIVA HANDIHLR |
175.00 |
3579.012187 |
400881020081 |
400881020081002 |
SPIRIVA HANDIHLR |
175.00 |
3579.012187 |
400881020111 |
400881020111001 |
ACIPHEX |
185.59 |
3579.012187 |
401601010441 |
401601010441001 |
METFORMIN HYDROCHLORIDE |
12.39 |
2051.235697 |
401601010441 |
401601010441002 |
METFORMIN HYDROCHLORIDE |
12.39 |
2051.235697 |
401601010441 |
401601010441003 |
METFORMIN HYDROCHLORIDE |
12.39 |
2051.235697 |
401601010451 |
401601010451001 |
LEVOTHYROXINE SODIUM |
15.44 |
2051.235697 |
401601010451 |
401601010451002 |
LEVOTHYROXINE SODIUM |
15.44 |
2051.235697 |
401601010451 |
401601010451003 |
LEVOTHYROXINE SODIUM |
15.44 |
2051.235697 |
401601010471 |
401601010471001 |
XOPENEX HFA |
53.33 |
2051.235697 |
401601010491 |
401601010491001 |
HYDROCHLOROTHIAZIDE |
8.65 |
2051.235697 |
401601010491 |
401601010491002 |
HYDROCHLOROTHIAZIDE |
8.35 |
2051.235697 |
401601010491 |
401601010491003 |
HYDROCHLOROTHIAZIDE |
8.35 |
2051.235697 |
401911030141 |
401911030141001 |
XOPENEX |
91.00 |
5621.646638 |
401911030151 |
401911030151001 |
AMOXICILLIN |
5.00 |
5621.646638 |
403691020131 |
403691020131001 |
PROVENTIL |
81.55 |
8028.260022 |
403691020131 |
403691020131002 |
PROVENTIL |
81.55 |
8028.260022 |
403691020131 |
403691020131003 |
PROVENTIL |
81.55 |
8028.260022 |
403691020131 |
403691020131004 |
PROVENTIL |
81.55 |
8028.260022 |
403691020131 |
403691020131005 |
PROVENTIL |
81.55 |
8028.260022 |
403691020141 |
403691020141001 |
NASACORT AQ |
89.74 |
8028.260022 |
403691020151 |
403691020151001 |
NASONEX |
88.20 |
8028.260022 |
403691020151 |
403691020151002 |
NASONEX |
88.20 |
8028.260022 |
403691020151 |
403691020151003 |
NASONEX |
88.20 |
8028.260022 |
403691020151 |
403691020151004 |
NASONEX |
88.20 |
8028.260022 |
403691020161 |
403691020161001 |
PROAIR HFA |
36.93 |
8028.260022 |
403691020161 |
403691020161002 |
PROAIR HFA |
36.93 |
8028.260022 |
403691020161 |
403691020161003 |
PROAIR HFA |
36.93 |
8028.260022 |
403691020161 |
403691020161004 |
PROAIR HFA |
36.93 |
8028.260022 |
403691020161 |
403691020161005 |
PROAIR HFA |
37.15 |
8028.260022 |
403691020161 |
403691020161006 |
PROAIR HFA |
37.15 |
8028.260022 |
403691050061 |
403691050061001 |
NUVARING |
60.43 |
14473.972430 |
403691050061 |
403691050061002 |
NUVARING |
60.43 |
14473.972430 |
403691050061 |
403691050061003 |
NUVARING |
60.43 |
14473.972430 |
403691050061 |
403691050061004 |
NUVARING |
60.43 |
14473.972430 |
403691050061 |
403691050061005 |
NUVARING |
60.43 |
14473.972430 |
403691050061 |
403691050061006 |
NUVARING |
60.43 |
14473.972430 |
403691050061 |
403691050061007 |
NUVARING |
60.43 |
14473.972430 |
403691050061 |
403691050061008 |
NUVARING |
60.43 |
14473.972430 |
403691050061 |
403691050061009 |
NUVARING |
60.43 |
14473.972430 |
403691050061 |
403691050061010 |
NUVARING |
60.43 |
14473.972430 |
403691050071 |
403691050071001 |
NASONEX |
98.48 |
14473.972430 |
403691050071 |
403691050071002 |
NASONEX |
98.48 |
14473.972430 |
403691050071 |
403691050071003 |
NASONEX |
98.48 |
14473.972430 |
403691050071 |
403691050071004 |
NASONEX |
98.48 |
14473.972430 |
403691060031 |
403691060031001 |
PROAIR HFA |
37.11 |
12142.929000 |
403691060031 |
403691060031002 |
PROAIR HFA |
37.11 |
12142.929000 |
403691060031 |
403691060031003 |
PROAIR HFA |
37.11 |
12142.929000 |
403691060031 |
403691060031004 |
PROAIR HFA |
37.11 |
12142.929000 |
403691060031 |
403691060031005 |
PROAIR HFA |
37.11 |
12142.929000 |
403691060041 |
403691060041001 |
SYMBICORT |
163.10 |
12142.929000 |
403691060041 |
403691060041002 |
SYMBICORT |
163.10 |
12142.929000 |
403691060041 |
403691060041003 |
SYMBICORT |
163.10 |
12142.929000 |
403761020051 |
403761020051001 |
ENALAPRIL MALEATE |
29.99 |
10495.656139 |
403761020051 |
403761020051002 |
ENALAPRIL MALEATE |
29.99 |
10495.656139 |
403761020051 |
403761020051003 |
ENALAPRIL MALEATE |
29.99 |
10495.656139 |
403761020061 |
403761020061001 |
LOVASTATIN |
195.99 |
10495.656139 |
403761020061 |
403761020061002 |
LOVASTATIN |
195.99 |
10495.656139 |
403761020061 |
403761020061003 |
LOVASTATIN |
69.99 |
10495.656139 |
403761020071 |
403761020071001 |
NEXIUM |
195.99 |
10495.656139 |
403761020071 |
403761020071002 |
NEXIUM |
195.99 |
10495.656139 |
403761020071 |
403761020071003 |
NEXIUM |
195.99 |
10495.656139 |
403761020081 |
403761020081001 |
PREMARIN |
66.99 |
10495.656139 |
403761020081 |
403761020081002 |
PREMARIN |
66.99 |
10495.656139 |
403761020081 |
403761020081003 |
PREMARIN |
66.99 |
10495.656139 |
403761020091 |
403761020091001 |
PREVACID |
192.99 |
10495.656139 |
403761020091 |
403761020091002 |
PREVACID |
192.99 |
10495.656139 |
403761020101 |
403761020101001 |
HYDROCHLOROTHIAZIDE |
10.99 |
10495.656139 |
403761020101 |
403761020101002 |
HYDROCHLOROTHIAZIDE |
10.99 |
10495.656139 |
403761020101 |
403761020101003 |
HYDROCHLOROTHIAZIDE |
10.99 |
10495.656139 |
403761020111 |
403761020111001 |
CELEBREX |
142.99 |
10495.656139 |
403761020111 |
403761020111002 |
CELEBREX |
142.99 |
10495.656139 |
403761020111 |
403761020111003 |
CELEBREX |
142.99 |
10495.656139 |
403761020121 |
403761020121001 |
FLUTICASONE PROPIONATE |
25.66 |
10495.656139 |
403761020131 |
403761020131001 |
ADVAIR DISKUS |
160.29 |
10495.656139 |
403761020261 |
403761020261001 |
ENALAPRIL MALEATE |
29.99 |
10495.656139 |
403761020261 |
403761020261002 |
ENALAPRIL MALEATE |
29.99 |
10495.656139 |
403761020261 |
403761020261003 |
ENALAPRIL MALEATE |
29.99 |
10495.656139 |
403761020261 |
403761020261004 |
ENALAPRIL MALEATE |
29.99 |
10495.656139 |
403761020261 |
403761020261005 |
ENALAPRIL MALEATE |
29.99 |
10495.656139 |
403761020261 |
403761020261006 |
ENALAPRIL MALEATE |
29.99 |
10495.656139 |
403761020271 |
403761020271001 |
LOVASTATIN |
69.99 |
10495.656139 |
403761020271 |
403761020271002 |
LOVASTATIN |
69.99 |
10495.656139 |
403761020271 |
403761020271003 |
LOVASTATIN |
69.99 |
10495.656139 |
403761020271 |
403761020271004 |
LOVASTATIN |
69.99 |
10495.656139 |
403761020271 |
403761020271005 |
LOVASTATIN |
69.99 |
10495.656139 |
403761020271 |
403761020271006 |
LOVASTATIN |
69.99 |
10495.656139 |
403761020281 |
403761020281001 |
NEXIUM |
195.99 |
10495.656139 |
403761020281 |
403761020281002 |
NEXIUM |
195.99 |
10495.656139 |
403761020281 |
403761020281003 |
NEXIUM |
195.99 |
10495.656139 |
403761020281 |
403761020281004 |
NEXIUM |
195.99 |
10495.656139 |
403761020281 |
403761020281005 |
NEXIUM |
195.99 |
10495.656139 |
403761020281 |
403761020281006 |
NEXIUM |
195.99 |
10495.656139 |
403761020291 |
403761020291001 |
PREMARIN |
66.99 |
10495.656139 |
403761020291 |
403761020291002 |
PREMARIN |
66.99 |
10495.656139 |
403761020291 |
403761020291003 |
PREMARIN |
66.99 |
10495.656139 |
403761020291 |
403761020291004 |
PREMARIN |
66.99 |
10495.656139 |
403761020291 |
403761020291005 |
PREMARIN |
66.99 |
10495.656139 |
403761020291 |
403761020291006 |
PREMARIN |
66.99 |
10495.656139 |
403761020301 |
403761020301001 |
PREVACID |
192.99 |
10495.656139 |
403761020311 |
403761020311001 |
HYDROCHLOROTHIAZIDE |
10.99 |
10495.656139 |
403761020311 |
403761020311002 |
HYDROCHLOROTHIAZIDE |
10.99 |
10495.656139 |
403761020311 |
403761020311003 |
HYDROCHLOROTHIAZIDE |
10.99 |
10495.656139 |
403761020311 |
403761020311004 |
HYDROCHLOROTHIAZIDE |
10.99 |
10495.656139 |
403761020311 |
403761020311005 |
HYDROCHLOROTHIAZIDE |
10.99 |
10495.656139 |
403761020311 |
403761020311006 |
HYDROCHLOROTHIAZIDE |
10.99 |
10495.656139 |
403761020321 |
403761020321001 |
CELEBREX |
142.99 |
10495.656139 |
403761020321 |
403761020321002 |
CELEBREX |
142.99 |
10495.656139 |
403761020321 |
403761020321003 |
CELEBREX |
142.99 |
10495.656139 |
403761020321 |
403761020321004 |
CELEBREX |
142.99 |
10495.656139 |
403761020321 |
403761020321005 |
CELEBREX |
142.99 |
10495.656139 |
403761020321 |
403761020321006 |
CELEBREX |
142.99 |
10495.656139 |
403761020331 |
403761020331001 |
FLUTICASONE PROPIONATE |
25.66 |
10495.656139 |
403761020331 |
403761020331002 |
FLUTICASONE PROPIONATE |
25.66 |
10495.656139 |
403761020331 |
403761020331003 |
FLUTICASONE PROPIONATE |
25.66 |
10495.656139 |
403761020341 |
403761020341001 |
ADVAIR DISKUS |
160.29 |
10495.656139 |
403761020341 |
403761020341002 |
ADVAIR DISKUS |
160.29 |
10495.656139 |
403761020341 |
403761020341003 |
ADVAIR DISKUS |
160.29 |
10495.656139 |
403761020351 |
403761020351001 |
PROVENTIL |
3.00 |
10495.656139 |
403761020351 |
403761020351002 |
PROVENTIL |
3.00 |
10495.656139 |
403761020351 |
403761020351003 |
PROVENTIL |
3.00 |
10495.656139 |
403761020541 |
403761020541001 |
LOVASTATIN |
36.72 |
10495.656139 |
403761020541 |
403761020541002 |
LOVASTATIN |
36.72 |
10495.656139 |
403761020541 |
403761020541003 |
LOVASTATIN |
36.72 |
10495.656139 |
403761020551 |
403761020551001 |
CELEBREX |
116.16 |
10495.656139 |
403761020551 |
403761020551002 |
CELEBREX |
116.16 |
10495.656139 |
403761020551 |
403761020551003 |
CELEBREX |
116.16 |
10495.656139 |
403761020551 |
403761020551004 |
CELEBREX |
116.16 |
10495.656139 |
403761020551 |
403761020551005 |
CELEBREX |
116.16 |
10495.656139 |
403761020561 |
403761020561001 |
PREMARIN |
51.52 |
10495.656139 |
403761020561 |
403761020561002 |
PREMARIN |
51.52 |
10495.656139 |
403761020561 |
403761020561003 |
PREMARIN |
51.52 |
10495.656139 |
404001010021 |
404001010021001 |
SYMBICORT |
190.13 |
2642.389748 |
405021050051 |
405021050051001 |
TAMIFLU |
138.66 |
6270.151842 |
405021050061 |
405021050061001 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061002 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061003 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061004 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061005 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061006 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061007 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050071 |
405021050071001 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071002 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071003 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071004 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071005 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071006 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071007 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021060031 |
405021060031001 |
TAMIFLU |
94.24 |
6386.244760 |
405021060041 |
405021060041001 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041002 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041003 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041004 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041005 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041006 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041007 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060051 |
405021060051001 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051002 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051003 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051004 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051005 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051006 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051007 |
FLOVENT HFA |
100.63 |
6386.244760 |
405581010031 |
405581010031001 |
LIPITOR |
106.24 |
8236.989502 |
405581010041 |
405581010041001 |
METFORMIN HYDROCHLORIDE |
95.00 |
8236.989502 |
405581010051 |
405581010051001 |
PREDNISONE |
9.89 |
8236.989502 |
405581010071 |
405581010071001 |
LIPITOR |
106.24 |
8236.989502 |
405581010071 |
405581010071002 |
LIPITOR |
106.24 |
8236.989502 |
405581010071 |
405581010071003 |
LIPITOR |
106.24 |
8236.989502 |
405581010071 |
405581010071004 |
LIPITOR |
106.24 |
8236.989502 |
405581010071 |
405581010071005 |
LIPITOR |
106.24 |
8236.989502 |
405581010071 |
405581010071006 |
LIPITOR |
106.24 |
8236.989502 |
405581010081 |
405581010081001 |
METFORMIN HYDROCHLORIDE |
95.00 |
8236.989502 |
405581010081 |
405581010081002 |
METFORMIN HYDROCHLORIDE |
95.00 |
8236.989502 |
405581010081 |
405581010081003 |
METFORMIN HYDROCHLORIDE |
95.00 |
8236.989502 |
405581010081 |
405581010081004 |
METFORMIN HYDROCHLORIDE |
95.00 |
8236.989502 |
405581010081 |
405581010081005 |
METFORMIN HYDROCHLORIDE |
95.00 |
8236.989502 |
405581010081 |
405581010081006 |
METFORMIN HYDROCHLORIDE |
95.00 |
8236.989502 |
405581010091 |
405581010091001 |
PREDNISONE |
14.55 |
8236.989502 |
405911050091 |
405911050091001 |
SINGULAIR |
128.99 |
7523.311904 |
405911050091 |
405911050091002 |
SINGULAIR |
128.99 |
7523.311904 |
405911050091 |
405911050091003 |
SINGULAIR |
128.99 |
7523.311904 |
405911050091 |
405911050091004 |
SINGULAIR |
135.99 |
7523.311904 |
405911050091 |
405911050091005 |
SINGULAIR |
135.99 |
7523.311904 |
405911050091 |
405911050091006 |
SINGULAIR |
128.99 |
7523.311904 |
405911050091 |
405911050091007 |
SINGULAIR |
128.99 |
7523.311904 |
405911050101 |
405911050101001 |
CLARITIN |
7.00 |
7523.311904 |
405911050101 |
405911050101002 |
CLARITIN |
7.00 |
7523.311904 |
405911050101 |
405911050101003 |
CLARITIN |
7.00 |
7523.311904 |
405911050101 |
405911050101004 |
CLARITIN |
7.00 |
7523.311904 |
405911050101 |
405911050101005 |
CLARITIN |
7.00 |
7523.311904 |
405911050101 |
405911050101006 |
CLARITIN |
7.00 |
7523.311904 |
405911050101 |
405911050101007 |
CLARITIN |
7.00 |
7523.311904 |
405911050111 |
405911050111001 |
ADVAIR DISKUS |
191.88 |
7523.311904 |
405911050111 |
405911050111002 |
ADVAIR DISKUS |
191.88 |
7523.311904 |
405911050111 |
405911050111003 |
ADVAIR DISKUS |
191.88 |
7523.311904 |
Return to Top
HC-126I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Analysis Variable: RXXP09X SUM OF PAYMENTS RXSF09X-RXOU09X(IMPUTED)
Return to Top
HC-126I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
Analysis Variable: RXXP09X SUM OF PAYMENTS RXSF09X-RXOU09X(IMPUTED)
Return to Top
NOTE: Copyright (c) 2002-2008 by SAS Institute
Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
NOTE: This session is executing on the XP_PRO
platform.
NOTE: SAS initialization used:
real time 0.62 seconds
cpu time 0.31 seconds
NOTE: AUTOEXEC processing beginning; file is
C:\Program Files\SAS92\SASFoundation\9.2\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 ods rtf file = 'c:\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-126I";
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.06 seconds
cpu time 0.01 seconds
26
27
*--------------------------------------------------------------------------------------
28 * Get condition records coded as asthma.
29
*--------------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H128 (KEEP=CONDIDX CCCODEX);
32 IF CCCODEX="128";
33 RUN;
NOTE: There were 117342 observations read from the
data set IN.H128.
NOTE: The data set WORK.ASCONDS has 2420
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 4.10 seconds
cpu time 0.07 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 2420 observations read from the
data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2420
observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.03 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 (H128) 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.H126IF1 OUT=CLNK; BY CONDIDX;
RUN;
NOTE: There were 342044 observations read from the
data set IN.H126IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 342044 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 12.60 seconds
cpu time 0.51 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 342044 observations read from the
data set WORK.CLNK.
NOTE: There were 2420 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7669
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 1.00 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.95 seconds
cpu time 0.01 seconds
61
62 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7669 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 7669
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
63
64 proc print data=asclnks (obs=50);
65 format eventype eventype.;
66 title3 "sample print of work.asclnks - sorted by
evntidx";
67 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 1.07 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 7669 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7667
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.62 seconds
cpu time 0.00 seconds
79
80
*-------------------------------------------------------------------------------
81 * Get PMED records linked to asthma condition
records.
82
*-------------------------------------------------------------------------------;
83 PROC SORT DATA=IN.H126A OUT=PMED; BY LINKIDX;
RUN;
NOTE: There were 333629 observations read from the
data set IN.H126A.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.PMED has 333629
observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 26.26 seconds
cpu time 1.12 seconds
84
85 DATA ASPMEDS;
86 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP09X
PERWT09F)
87 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX
RENAME=(EVNTIDX=LINKIDX));
88 BY LINKIDX;
89 IF INASCLNK & PERWT09F>0;
90 RUN;
NOTE: There were 333629 observations read from the
data set WORK.PMED.
NOTE: There were 7667 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 10436
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.12 seconds
91
92 proc print data=aspmeds (obs=300);
93 by linkidx;
94 id linkidx;
95 var rxrecidx rxname RXXP09X PERWT09F;
96 title3 "sample print of work.aspmeds";
97 title4 "PMED (HC-126A) 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.95 seconds
cpu time 0.03 seconds
99
100 PROC MEANS DATA=ASPMEDS N SUM;
101 VAR RXXP09X;
102 TITLE3 "Total Rx expenditures associated with
asthma";
103 RUN;
NOTE: Multiple concurrent threads will be used to
summarize data.
NOTE: There were 10436 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.29 seconds
cpu time 0.06 seconds
104
105 PROC MEANS DATA=ASPMEDS N SUM;
106 VAR RXXP09X;
107 WEIGHT PERWT09F;
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 10436 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.01 seconds
111
112 ods rtf close;
113
NOTE: SAS Institute Inc., SAS Campus Drive, Cary,
NC USA 27513-2414
NOTE: The SAS System used:
real time 49.76 seconds
cpu time 2.68 seconds
Return to Top
HC-126I. Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H128) records where cccodex=128
Obs |
CONDIDX |
CCCODEX |
1 |
400011010011 |
128 |
2 |
400011030011 |
128 |
3 |
400441010101 |
128 |
4 |
400501010021 |
128 |
5 |
400521010101 |
128 |
6 |
400841010091 |
128 |
7 |
400881020041 |
128 |
8 |
401051050011 |
128 |
9 |
401481020061 |
128 |
10 |
401601010041 |
128 |
11 |
401901010031 |
128 |
12 |
401911030011 |
128 |
13 |
402121010021 |
128 |
14 |
402121020011 |
128 |
15 |
402151010011 |
128 |
16 |
402151020041 |
128 |
17 |
402151030011 |
128 |
18 |
402271010011 |
128 |
19 |
402331020051 |
128 |
20 |
402361020011 |
128 |
21 |
402451030011 |
128 |
22 |
402841010081 |
128 |
23 |
403491040011 |
128 |
24 |
403601030011 |
128 |
25 |
403691020021 |
128 |
26 |
403691050021 |
128 |
27 |
403691060011 |
128 |
28 |
403701020061 |
128 |
29 |
403701020161 |
128 |
30 |
403751020061 |
128 |
31 |
403761020041 |
128 |
32 |
403831010041 |
128 |
33 |
403851020041 |
128 |
34 |
403881010081 |
128 |
35 |
403881020011 |
128 |
36 |
404001010031 |
128 |
37 |
404062010022 |
128 |
38 |
404122010032 |
128 |
39 |
404381030011 |
128 |
40 |
404401020041 |
128 |
41 |
404561010031 |
128 |
42 |
404581020011 |
128 |
43 |
404701010031 |
128 |
44 |
404891010031 |
128 |
45 |
405021050011 |
128 |
46 |
405021060011 |
128 |
47 |
405041010011 |
128 |
48 |
405191020011 |
128 |
49 |
405311040011 |
128 |
50 |
405391030011 |
128 |
Return to Top
HC-126I. Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
400011010011 |
400011010061 |
8 PMED |
400011010011 |
400011010101 |
8 PMED |
400011030011 |
400011030081 |
8 PMED |
400441010101 |
400441010411 |
8 PMED |
400501010021 |
400501010011 |
8 PMED |
400501010021 |
400501010051 |
8 PMED |
400501010021 |
400501010091 |
8 PMED |
400501010021 |
400501010121 |
8 PMED |
400521010101 |
400521010031 |
1 MVIS |
400521010101 |
400521010041 |
1 MVIS |
400521010101 |
400521010131 |
8 PMED |
400881020041 |
400881020021 |
1 MVIS |
400881020041 |
400881020031 |
1 MVIS |
400881020041 |
400881020041 |
1 MVIS |
400881020041 |
400881020051 |
8 PMED |
400881020041 |
400881020061 |
8 PMED |
400881020041 |
400881020071 |
8 PMED |
400881020041 |
400881020081 |
8 PMED |
400881020041 |
400881020091 |
1 MVIS |
400881020041 |
400881020101 |
1 MVIS |
400881020041 |
400881020111 |
8 PMED |
401051050011 |
401051050011 |
8 PMED |
401051050011 |
401051050031 |
8 PMED |
401601010041 |
401601010281 |
8 PMED |
401601010041 |
401601010311 |
8 PMED |
401601010041 |
401601010321 |
1 MVIS |
401601010041 |
401601010331 |
1 MVIS |
401601010041 |
401601010341 |
1 MVIS |
401601010041 |
401601010471 |
8 PMED |
401911030011 |
401911030011 |
1 MVIS |
401911030011 |
401911030021 |
1 MVIS |
401911030011 |
401911030031 |
1 MVIS |
401911030011 |
401911030041 |
1 MVIS |
401911030011 |
401911030051 |
1 MVIS |
401911030011 |
401911030091 |
8 PMED |
401911030011 |
401911030131 |
1 MVIS |
401911030011 |
401911030141 |
8 PMED |
402121020011 |
402121020011 |
3 EROM |
402121020011 |
402121020041 |
8 PMED |
402121020011 |
402121020051 |
8 PMED |
402121020011 |
402121020061 |
8 PMED |
402151010011 |
402151010041 |
8 PMED |
402151010011 |
402151010061 |
8 PMED |
402151030011 |
402151030051 |
8 PMED |
402331020051 |
402331020241 |
8 PMED |
402361020011 |
402361020021 |
8 PMED |
402841010081 |
402841010291 |
8 PMED |
403491040011 |
403491040041 |
8 PMED |
403491040011 |
403491040051 |
8 PMED |
403491040011 |
403491040061 |
1 MVIS |
403491040011 |
403491040091 |
8 PMED |
403491040011 |
403491040111 |
8 PMED |
403491040011 |
403491040121 |
8 PMED |
403601030011 |
403601030111 |
8 PMED |
403601030011 |
403601030121 |
8 PMED |
403601030011 |
403601030131 |
8 PMED |
403601030011 |
403601030141 |
8 PMED |
403691020021 |
403691020041 |
1 MVIS |
403691020021 |
403691020051 |
1 MVIS |
403691020021 |
403691020061 |
1 MVIS |
403691020021 |
403691020071 |
1 MVIS |
403691020021 |
403691020081 |
1 MVIS |
403691020021 |
403691020091 |
1 MVIS |
403691020021 |
403691020101 |
1 MVIS |
403691020021 |
403691020111 |
1 MVIS |
403691050021 |
403691050041 |
1 MVIS |
403691050021 |
403691050051 |
1 MVIS |
403691060011 |
403691060011 |
1 MVIS |
403691060011 |
403691060041 |
8 PMED |
403701020061 |
403701020141 |
8 PMED |
403701020061 |
403701020161 |
8 PMED |
403701020061 |
403701020291 |
8 PMED |
403701020061 |
403701020311 |
8 PMED |
403701020061 |
403701020351 |
8 PMED |
403751020061 |
403751020111 |
8 PMED |
Return to Top
HC-126I. Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
400011010011 |
400011010061 |
8 PMED |
2 |
400011010011 |
400011010101 |
8 PMED |
3 |
400011030011 |
400011030081 |
8 PMED |
4 |
400441010101 |
400441010411 |
8 PMED |
5 |
400501010021 |
400501010011 |
8 PMED |
6 |
400501010021 |
400501010051 |
8 PMED |
7 |
400501010021 |
400501010091 |
8 PMED |
8 |
400501010021 |
400501010121 |
8 PMED |
9 |
400521010101 |
400521010031 |
1 MVIS |
10 |
400521010101 |
400521010041 |
1 MVIS |
11 |
400521010101 |
400521010131 |
8 PMED |
12 |
400881020041 |
400881020021 |
1 MVIS |
13 |
400881020041 |
400881020031 |
1 MVIS |
14 |
400881020041 |
400881020041 |
1 MVIS |
15 |
400881020041 |
400881020051 |
8 PMED |
16 |
400881020041 |
400881020061 |
8 PMED |
17 |
400881020041 |
400881020071 |
8 PMED |
18 |
400881020041 |
400881020081 |
8 PMED |
19 |
400881020041 |
400881020091 |
1 MVIS |
20 |
400881020041 |
400881020101 |
1 MVIS |
21 |
400881020041 |
400881020111 |
8 PMED |
22 |
401051050011 |
401051050011 |
8 PMED |
23 |
401051050011 |
401051050031 |
8 PMED |
24 |
401601010041 |
401601010281 |
8 PMED |
25 |
401601010041 |
401601010311 |
8 PMED |
26 |
401601010041 |
401601010321 |
1 MVIS |
27 |
401601010041 |
401601010331 |
1 MVIS |
28 |
401601010041 |
401601010341 |
1 MVIS |
29 |
401601010041 |
401601010471 |
8 PMED |
30 |
401911030011 |
401911030011 |
1 MVIS |
31 |
401911030011 |
401911030021 |
1 MVIS |
32 |
401911030011 |
401911030031 |
1 MVIS |
33 |
401911030011 |
401911030041 |
1 MVIS |
34 |
401911030011 |
401911030051 |
1 MVIS |
35 |
401911030011 |
401911030091 |
8 PMED |
36 |
401911030011 |
401911030131 |
1 MVIS |
37 |
401911030011 |
401911030141 |
8 PMED |
38 |
402121020011 |
402121020011 |
3 EROM |
39 |
402121020011 |
402121020041 |
8 PMED |
40 |
402121020011 |
402121020051 |
8 PMED |
41 |
402121020011 |
402121020061 |
8 PMED |
42 |
402151010011 |
402151010041 |
8 PMED |
43 |
402151010011 |
402151010061 |
8 PMED |
44 |
402151030011 |
402151030051 |
8 PMED |
45 |
402331020051 |
402331020241 |
8 PMED |
46 |
402361020011 |
402361020021 |
8 PMED |
47 |
402841010081 |
402841010291 |
8 PMED |
48 |
403491040011 |
403491040041 |
8 PMED |
49 |
403491040011 |
403491040051 |
8 PMED |
50 |
403491040011 |
403491040061 |
1 MVIS |
Return to Top
HC-126I. Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
400011010061 |
8 PMED |
2 |
400011010101 |
8 PMED |
3 |
400011030081 |
8 PMED |
4 |
400441010411 |
8 PMED |
5 |
400501010011 |
8 PMED |
6 |
400501010051 |
8 PMED |
7 |
400501010091 |
8 PMED |
8 |
400501010121 |
8 PMED |
9 |
400521010031 |
1 MVIS |
10 |
400521010041 |
1 MVIS |
11 |
400521010131 |
8 PMED |
12 |
400881020021 |
1 MVIS |
13 |
400881020031 |
1 MVIS |
14 |
400881020041 |
1 MVIS |
15 |
400881020051 |
8 PMED |
16 |
400881020061 |
8 PMED |
17 |
400881020071 |
8 PMED |
18 |
400881020081 |
8 PMED |
19 |
400881020091 |
1 MVIS |
20 |
400881020101 |
1 MVIS |
21 |
400881020111 |
8 PMED |
22 |
401051050011 |
8 PMED |
23 |
401051050031 |
8 PMED |
24 |
401601010281 |
8 PMED |
25 |
401601010311 |
8 PMED |
26 |
401601010321 |
1 MVIS |
27 |
401601010331 |
1 MVIS |
28 |
401601010341 |
1 MVIS |
29 |
401601010471 |
8 PMED |
30 |
401911030011 |
1 MVIS |
31 |
401911030021 |
1 MVIS |
32 |
401911030031 |
1 MVIS |
33 |
401911030041 |
1 MVIS |
34 |
401911030051 |
1 MVIS |
35 |
401911030091 |
8 PMED |
36 |
401911030131 |
1 MVIS |
37 |
401911030141 |
8 PMED |
38 |
402121020011 |
3 EROM |
39 |
402121020041 |
8 PMED |
40 |
402121020051 |
8 PMED |
41 |
402121020061 |
8 PMED |
42 |
402151010041 |
8 PMED |
43 |
402151010061 |
8 PMED |
44 |
402151030051 |
8 PMED |
45 |
402331020241 |
8 PMED |
46 |
402361020021 |
8 PMED |
47 |
402841010291 |
8 PMED |
48 |
403491040041 |
8 PMED |
49 |
403491040051 |
8 PMED |
50 |
403491040061 |
1 MVIS |
Return to Top
HC-126I. Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-126A) records which link to condition
records coded as asthma
LINKIDX |
RXRECIDX |
RXNAME |
RXXP09X |
PERWT09F |
400011010061 |
400011010061001 |
ADVAIR DISKUS |
200.69 |
14251.111105 |
400011010101 |
400011010101001 |
ADVAIR DISKUS |
416.17 |
14251.111105 |
400011030081 |
400011030081001 |
PULMICORT RESPULES |
418.72 |
14803.089514 |
400011030081 |
400011030081002 |
PULMICORT RESPULES |
418.72 |
14803.089514 |
400011030081 |
400011030081003 |
PULMICORT RESPULES |
418.72 |
14803.089514 |
400441010411 |
400441010411001 |
MUCINEX |
19.99 |
17739.800407 |
400501010011 |
400501010011001 |
ADVAIR DISKU |
201.00 |
10588.753294 |
400501010011 |
400501010011002 |
ADVAIR DISKU |
201.00 |
10588.753294 |
400501010051 |
400501010051001 |
ADVAIR DISKU |
201.00 |
10588.753294 |
400501010051 |
400501010051002 |
ADVAIR DISKU |
194.37 |
10588.753294 |
400501010051 |
400501010051003 |
ADVAIR DISKU |
194.37 |
10588.753294 |
400501010051 |
400501010051004 |
ADVAIR DISKU |
201.00 |
10588.753294 |
400501010051 |
400501010051005 |
ADVAIR DISKU |
201.00 |
10588.753294 |
400501010051 |
400501010051006 |
ADVAIR DISKU |
201.00 |
10588.753294 |
400501010091 |
400501010091001 |
ADVAIR DISKU |
201.00 |
10588.753294 |
400501010091 |
400501010091002 |
ADVAIR DISKU |
201.00 |
10588.753294 |
400501010091 |
400501010091003 |
ADVAIR DISKU |
201.00 |
10588.753294 |
400501010091 |
400501010091004 |
ADVAIR DISKU |
201.00 |
10588.753294 |
400501010121 |
400501010121001 |
PROVENTIL |
81.55 |
10588.753294 |
400521010131 |
400521010131001 |
ADVAIR DISKUS |
154.72 |
4936.989686 |
400881020051 |
400881020051001 |
PROMETHAZINE DM |
5.00 |
3579.012187 |
400881020061 |
400881020061001 |
ACIPHEX |
185.59 |
3579.012187 |
400881020061 |
400881020061002 |
ACIPHEX |
185.59 |
3579.012187 |
400881020071 |
400881020071001 |
SYMBICORT |
223.99 |
3579.012187 |
400881020071 |
400881020071002 |
SYMBICORT |
248.69 |
3579.012187 |
400881020081 |
400881020081001 |
SPIRIVA HANDIHLR |
175.00 |
3579.012187 |
400881020081 |
400881020081002 |
SPIRIVA HANDIHLR |
175.00 |
3579.012187 |
400881020111 |
400881020111001 |
ACIPHEX |
185.59 |
3579.012187 |
401051050011 |
401051050011001 |
SINGULAIR |
352.35 |
13769.384013 |
401051050011 |
401051050011002 |
SINGULAIR |
352.35 |
13769.384013 |
401051050011 |
401051050011003 |
SINGULAIR |
352.35 |
13769.384013 |
401051050011 |
401051050011004 |
SINGULAIR |
352.35 |
13769.384013 |
401051050011 |
401051050011005 |
SINGULAIR |
352.35 |
13769.384013 |
401051050031 |
401051050031001 |
PULMICORT RESPULES |
179.48 |
13769.384013 |
401601010281 |
401601010281001 |
DIPHENHYDRAMINE HYDROCHLORIDE |
9.58 |
2051.235697 |
401601010281 |
401601010281002 |
COMPLETE ALLERGY |
1.31 |
2051.235697 |
401601010311 |
401601010311001 |
HALOPERIDOL |
62.36 |
2051.235697 |
401601010311 |
401601010311002 |
HALOPERIDOL |
1.10 |
2051.235697 |
401601010311 |
401601010311003 |
HALOPERIDOL |
17.13 |
2051.235697 |
401601010311 |
401601010311004 |
HALOPERIDOL |
80.24 |
2051.235697 |
401601010311 |
401601010311005 |
HALOPERIDOL |
68.63 |
2051.235697 |
401601010471 |
401601010471001 |
XOPENEX HFA |
53.33 |
2051.235697 |
401911030091 |
401911030091001 |
XOPENEX |
91.00 |
5621.646638 |
401911030091 |
401911030091002 |
XOPENEX |
91.00 |
5621.646638 |
401911030141 |
401911030141001 |
XOPENEX |
91.00 |
5621.646638 |
402121020041 |
402121020041001 |
PREDNISONE |
7.41 |
4514.743374 |
402121020051 |
402121020051001 |
VENTOLIN HFA |
74.02 |
4514.743374 |
402121020051 |
402121020051002 |
VENTOLIN HFA |
74.02 |
4514.743374 |
402121020051 |
402121020051003 |
VENTOLIN HFA |
74.02 |
4514.743374 |
402121020061 |
402121020061001 |
PREDNISONE |
1.67 |
4514.743374 |
402121020061 |
402121020061002 |
PREDNISONE |
1.67 |
4514.743374 |
402121020061 |
402121020061003 |
PREDNISONE |
1.67 |
4514.743374 |
402151010041 |
402151010041001 |
ALBUTEROL HFA |
19.72 |
10676.922942 |
402151010041 |
402151010041002 |
ALBUTEROL HFA |
19.72 |
10676.922942 |
402151010061 |
402151010061001 |
ALBUTEROL |
37.78 |
10676.922942 |
402151010061 |
402151010061002 |
ALBUTEROL |
37.78 |
10676.922942 |
402151030051 |
402151030051001 |
ALBUTEROL SULFATE |
5.75 |
6855.721593 |
402331020241 |
402331020241001 |
ALBUTEROL |
37.78 |
9726.350716 |
402361020021 |
402361020021001 |
ALBUTEROL |
37.78 |
34868.237549 |
402841010291 |
402841010291001 |
FEXOFENADINE HYDROCHLORIDE |
33.82 |
22027.463773 |
402841010291 |
402841010291002 |
FEXOFENADINE HYDROCHLORIDE |
33.82 |
22027.463773 |
402841010291 |
402841010291003 |
FEXOFENADINE HYDROCHLORIDE |
33.82 |
22027.463773 |
402841010291 |
402841010291004 |
FEXOFENADINE HYDROCHLORIDE |
33.82 |
22027.463773 |
402841010291 |
402841010291005 |
FEXOFENADINE HYDROCHLORIDE |
33.82 |
22027.463773 |
402841010291 |
402841010291006 |
FEXOFENADINE HYDROCHLORIDE |
31.46 |
22027.463773 |
403491040041 |
403491040041001 |
PULMICORT RESPULES |
179.48 |
2416.072308 |
403491040051 |
403491040051001 |
VENTOLIN HFA |
33.96 |
2416.072308 |
403491040091 |
403491040091001 |
VENTOLIN HFA |
33.96 |
2416.072308 |
403491040091 |
403491040091002 |
VENTOLIN HFA |
33.96 |
2416.072308 |
403491040091 |
403491040091003 |
VENTOLIN HFA |
33.96 |
2416.072308 |
403491040091 |
403491040091004 |
VENTOLIN HFA |
33.96 |
2416.072308 |
403491040091 |
403491040091005 |
VENTOLIN HFA |
33.96 |
2416.072308 |
403491040091 |
403491040091006 |
VENTOLIN HFA |
33.96 |
2416.072308 |
403491040111 |
403491040111001 |
PULMICORT RESPULES |
179.48 |
2416.072308 |
403491040121 |
403491040121001 |
VENTOLIN HFA |
33.96 |
2416.072308 |
403601030111 |
403601030111001 |
ADVAIR DISKUS |
162.99 |
7579.284306 |
403601030121 |
403601030121001 |
SINGULAIR |
110.22 |
7579.284306 |
403601030131 |
403601030131001 |
PROTONIX |
330.85 |
7579.284306 |
403601030141 |
403601030141001 |
CETIRIZINE HYDROCHLORIDE |
6.89 |
7579.284306 |
403691060041 |
403691060041001 |
SYMBICORT |
163.10 |
12142.929000 |
403691060041 |
403691060041002 |
SYMBICORT |
163.10 |
12142.929000 |
403691060041 |
403691060041003 |
SYMBICORT |
163.10 |
12142.929000 |
403701020141 |
403701020141001 |
SEREVENT DISKUS |
145.02 |
7724.717644 |
403701020141 |
403701020141002 |
SEREVENT DISKUS |
145.02 |
7724.717644 |
403701020141 |
403701020141003 |
SEREVENT DISKUS |
145.02 |
7724.717644 |
403701020161 |
403701020161001 |
SINGULAIR |
114.86 |
7724.717644 |
403701020161 |
403701020161002 |
SINGULAIR |
114.86 |
7724.717644 |
403701020161 |
403701020161003 |
SINGULAIR |
114.86 |
7724.717644 |
403701020291 |
403701020291001 |
ASTELIN |
87.13 |
7724.717644 |
403701020291 |
403701020291002 |
ASTELIN |
87.13 |
7724.717644 |
403701020311 |
403701020311001 |
SINGULAIR |
103.52 |
7724.717644 |
403701020311 |
403701020311002 |
SINGULAIR |
103.52 |
7724.717644 |
403701020351 |
403701020351001 |
ADVAIR DISKU |
190.00 |
7724.717644 |
403701020351 |
403701020351002 |
ADVAIR DISKU |
190.00 |
7724.717644 |
403701020351 |
403701020351003 |
ADVAIR DISKU |
190.00 |
7724.717644 |
403701020351 |
403701020351004 |
ADVAIR DISKU |
190.00 |
7724.717644 |
403701020351 |
403701020351005 |
ADVAIR DISKU |
190.00 |
7724.717644 |
403701020351 |
403701020351006 |
ADVAIR DISKU |
190.00 |
7724.717644 |
403751020111 |
403751020111001 |
ACTONEL |
93.72 |
5045.100521 |
403751020111 |
403751020111002 |
ACTONEL |
93.72 |
5045.100521 |
403751020111 |
403751020111003 |
ACTONEL |
93.72 |
5045.100521 |
403751020141 |
403751020141001 |
PROAIR HFA |
45.99 |
5045.100521 |
403751020141 |
403751020141002 |
PROAIR HFA |
45.99 |
5045.100521 |
403751020141 |
403751020141003 |
PROAIR HFA |
45.99 |
5045.100521 |
403751020201 |
403751020201001 |
ALBUTEROL |
37.78 |
5045.100521 |
403751020201 |
403751020201002 |
ALBUTEROL |
37.78 |
5045.100521 |
403751020201 |
403751020201003 |
ALBUTEROL |
37.78 |
5045.100521 |
403751020351 |
403751020351001 |
PROVENTIL HFA |
42.95 |
5045.100521 |
403751020351 |
403751020351002 |
PROVENTIL HFA |
42.95 |
5045.100521 |
403751020351 |
403751020351003 |
PROVENTIL HFA |
42.95 |
5045.100521 |
403751020351 |
403751020351004 |
PROVENTIL HFA |
42.95 |
5045.100521 |
403751020401 |
403751020401001 |
ALBUTEROL |
37.78 |
5045.100521 |
403751020401 |
403751020401002 |
ALBUTEROL |
37.78 |
5045.100521 |
403751020401 |
403751020401003 |
ALBUTEROL |
37.78 |
5045.100521 |
403751020401 |
403751020401004 |
ALBUTEROL |
37.78 |
5045.100521 |
403751020421 |
403751020421001 |
SPIRIVA |
511.70 |
5045.100521 |
403751020421 |
403751020421002 |
SPIRIVA |
511.70 |
5045.100521 |
403751020531 |
403751020531001 |
PROAIR HFA |
45.99 |
5045.100521 |
403751020531 |
403751020531002 |
PROAIR HFA |
45.99 |
5045.100521 |
403751020531 |
403751020531003 |
PROAIR HFA |
45.99 |
5045.100521 |
403751020531 |
403751020531004 |
PROAIR HFA |
45.99 |
5045.100521 |
403751020591 |
403751020591001 |
ALBUTEROL |
37.78 |
5045.100521 |
403751020591 |
403751020591002 |
ALBUTEROL |
37.78 |
5045.100521 |
403751020591 |
403751020591003 |
ALBUTEROL |
37.78 |
5045.100521 |
403751020591 |
403751020591004 |
ALBUTEROL |
37.78 |
5045.100521 |
403751020611 |
403751020611001 |
SPIRIVA |
493.54 |
5045.100521 |
403751020611 |
403751020611002 |
SPIRIVA |
493.54 |
5045.100521 |
403751020611 |
403751020611003 |
SPIRIVA |
493.54 |
5045.100521 |
403751020611 |
403751020611004 |
SPIRIVA |
493.64 |
5045.100521 |
403761020131 |
403761020131001 |
ADVAIR DISKUS |
160.29 |
10495.656139 |
403761020141 |
403761020141001 |
PROVENTIL HFA |
58.99 |
10495.656139 |
403761020341 |
403761020341001 |
ADVAIR DISKUS |
160.29 |
10495.656139 |
403761020341 |
403761020341002 |
ADVAIR DISKUS |
160.29 |
10495.656139 |
403761020341 |
403761020341003 |
ADVAIR DISKUS |
160.29 |
10495.656139 |
403761020351 |
403761020351001 |
PROVENTIL |
3.00 |
10495.656139 |
403761020351 |
403761020351002 |
PROVENTIL |
3.00 |
10495.656139 |
403761020351 |
403761020351003 |
PROVENTIL |
3.00 |
10495.656139 |
403761020591 |
403761020591001 |
PROVENTIL HFA |
58.99 |
10495.656139 |
403831010231 |
403831010231001 |
PROAIR HFA |
37.00 |
14958.062378 |
403851020031 |
403851020031001 |
ADVAIR |
141.92 |
17325.051907 |
403851020071 |
403851020071001 |
ADVAIR |
141.92 |
17325.051907 |
403851020071 |
403851020071002 |
ADVAIR |
141.92 |
17325.051907 |
403851020171 |
403851020171001 |
ADVAIR |
141.92 |
17325.051907 |
404001010021 |
404001010021001 |
SYMBICORT |
190.13 |
2642.389748 |
404001010041 |
404001010041001 |
SYMBICORT |
190.13 |
2642.389748 |
404001010081 |
404001010081001 |
SYMBICORT |
185.54 |
2642.389748 |
404062010182 |
404062010182001 |
ALBUTEROL |
37.78 |
7267.895202 |
404062010192 |
404062010192001 |
FLOVENT |
95.57 |
7267.895202 |
404122010512 |
404122010512001 |
VENTOLIN HFA |
41.80 |
4546.108410 |
404122010522 |
404122010522001 |
FLUTICASONE TOPICAL |
11.32 |
4546.108410 |
404381030041 |
404381030041001 |
VENTOLIN HFA |
34.17 |
2575.496786 |
404381030111 |
404381030111001 |
LORATADINE |
7.64 |
2575.496786 |
404381030111 |
404381030111002 |
LORATADINE |
7.64 |
2575.496786 |
404381030111 |
404381030111003 |
LORATADINE |
7.64 |
2575.496786 |
404381030191 |
404381030191001 |
VENTOLIN HFA |
34.17 |
2575.496786 |
404381030201 |
404381030201001 |
ADVAIR DISKUS |
158.56 |
2575.496786 |
404381030211 |
404381030211001 |
PROAIR HFA |
38.50 |
2575.496786 |
404381030241 |
404381030241001 |
ADVAIR DISKUS |
162.83 |
2575.496786 |
404381030251 |
404381030251001 |
VENTOLIN HFA |
34.17 |
2575.496786 |
404401020791 |
404401020791001 |
PROVENTIL |
14.11 |
14678.298853 |
404561010121 |
404561010121001 |
ADVAIR DISKUS |
425.28 |
25727.227319 |
404561010251 |
404561010251001 |
ADVAIR DISKUS |
425.28 |
25727.227319 |
404581020061 |
404581020061001 |
VENTOLIN HFA |
34.48 |
3429.039288 |
404581020071 |
404581020071001 |
FLOVENT HFA |
126.57 |
3429.039288 |
404701010031 |
404701010031001 |
FLOVENT |
95.57 |
7125.366836 |
404701010091 |
404701010091001 |
FLOVENT HFA |
138.57 |
7125.366836 |
404701010091 |
404701010091002 |
FLOVENT HFA |
138.57 |
7125.366836 |
404701010111 |
404701010111001 |
VENTOLIN HFA |
35.39 |
7125.366836 |
404701010141 |
404701010141001 |
FLOVENT HFA |
123.38 |
7125.366836 |
404891010411 |
404891010411001 |
PREDNISONE |
3.85 |
2825.304378 |
404891010491 |
404891010491001 |
ADVAIR DISKUS |
204.28 |
2825.304378 |
404891010491 |
404891010491002 |
ADVAIR DISKUS |
204.28 |
2825.304378 |
404891010501 |
404891010501001 |
QVAR |
71.71 |
2825.304378 |
404891010501 |
404891010501002 |
QVAR |
71.71 |
2825.304378 |
404891010681 |
404891010681001 |
ADVAIR DISKUS |
204.28 |
2825.304378 |
404891010681 |
404891010681002 |
ADVAIR DISKUS |
204.28 |
2825.304378 |
404891010681 |
404891010681003 |
ADVAIR DISKUS |
204.28 |
2825.304378 |
404891010681 |
404891010681004 |
ADVAIR DISKUS |
204.28 |
2825.304378 |
404891010691 |
404891010691001 |
VENTOLIN HFA |
33.99 |
2825.304378 |
404891010691 |
404891010691002 |
VENTOLIN HFA |
33.99 |
2825.304378 |
404891010691 |
404891010691003 |
VENTOLIN HFA |
33.99 |
2825.304378 |
404891010691 |
404891010691004 |
VENTOLIN HFA |
33.99 |
2825.304378 |
404891010691 |
404891010691005 |
VENTOLIN HFA |
33.99 |
2825.304378 |
405021050061 |
405021050061001 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061002 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061003 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061004 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061005 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061006 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050061 |
405021050061007 |
VENTOLIN HFA |
38.26 |
6270.151842 |
405021050071 |
405021050071001 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071002 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071003 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071004 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071005 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071006 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021050071 |
405021050071007 |
ADVAIR DISKUS |
213.29 |
6270.151842 |
405021060041 |
405021060041001 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041002 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041003 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041004 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041005 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041006 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060041 |
405021060041007 |
VENTOLIN HFA |
38.26 |
6386.244760 |
405021060051 |
405021060051001 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051002 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051003 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051004 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051005 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051006 |
FLOVENT HFA |
100.63 |
6386.244760 |
405021060051 |
405021060051007 |
FLOVENT HFA |
100.63 |
6386.244760 |
405041010031 |
405041010031001 |
HYPER-SAL |
63.49 |
9889.450465 |
405041010031 |
405041010031002 |
HYPER-SAL |
63.49 |
9889.450465 |
405041010031 |
405041010031003 |
HYPER-SAL |
63.49 |
9889.450465 |
405041010031 |
405041010031004 |
HYPER-SAL |
63.49 |
9889.450465 |
405191020051 |
405191020051001 |
PROAIR HFA |
76.28 |
9948.215667 |
405191020101 |
405191020101001 |
PROAIR HFA |
76.28 |
9948.215667 |
405561030031 |
405561030031001 |
PULMICORT FLEXHALER |
95.10 |
14066.833022 |
405561030041 |
405561030041001 |
ALBUTEROL |
37.78 |
14066.833022 |
405561030091 |
405561030091001 |
ALBUTEROL SULFATE |
102.18 |
14066.833022 |
405581010101 |
405581010101001 |
ALBUTEROL |
37.78 |
8236.989502 |
405581010101 |
405581010101002 |
ALBUTEROL |
37.78 |
8236.989502 |
405581010101 |
405581010101003 |
ALBUTEROL |
37.78 |
8236.989502 |
405581010101 |
405581010101004 |
ALBUTEROL |
37.78 |
8236.989502 |
405581010101 |
405581010101005 |
ALBUTEROL |
37.78 |
8236.989502 |
405581010101 |
405581010101006 |
ALBUTEROL |
37.78 |
8236.989502 |
405581010151 |
405581010151001 |
ALBUTEROL |
37.78 |
8236.989502 |
405581010151 |
405581010151002 |
ALBUTEROL |
37.78 |
8236.989502 |
405581010151 |
405581010151003 |
ALBUTEROL |
37.78 |
8236.989502 |
405911050071 |
405911050071001 |
ADVAIR DISKUS |
200.21 |
7523.311904 |
405911050071 |
405911050071002 |
ADVAIR DISKUS |
200.21 |
7523.311904 |
405911050071 |
405911050071003 |
ADVAIR DISKUS |
200.21 |
7523.311904 |
405911050111 |
405911050111001 |
ADVAIR DISKUS |
191.88 |
7523.311904 |
405911050111 |
405911050111002 |
ADVAIR DISKUS |
191.88 |
7523.311904 |
405911050111 |
405911050111003 |
ADVAIR DISKUS |
191.88 |
7523.311904 |
405911050111 |
405911050111004 |
ADVAIR DISKUS |
191.88 |
7523.311904 |
405911050111 |
405911050111005 |
ADVAIR DISKUS |
191.88 |
7523.311904 |
405911050111 |
405911050111006 |
ADVAIR DISKUS |
191.88 |
7523.311904 |
405911050111 |
405911050111007 |
ADVAIR DISKUS |
191.88 |
7523.311904 |
406061040011 |
406061040011001 |
ADVAIR DISKUS |
242.99 |
2997.679792 |
406061040011 |
406061040011002 |
ADVAIR DISKUS |
242.99 |
2997.679792 |
406061040021 |
406061040021001 |
ALBUTEROL HFA |
19.72 |
2997.679792 |
406061040021 |
406061040021002 |
ALBUTEROL HFA |
19.72 |
2997.679792 |
406061040052 |
406061040052001 |
ALBUTEROL HFA |
19.72 |
2997.679792 |
406061040052 |
406061040052002 |
ALBUTEROL HFA |
19.72 |
2997.679792 |
406061040052 |
406061040052003 |
ALBUTEROL HFA |
19.72 |
2997.679792 |
406061040052 |
406061040052004 |
ALBUTEROL HFA |
19.72 |
2997.679792 |
406111010211 |
406111010211001 |
SPIRIVA |
171.16 |
9985.706330 |
406111010211 |
406111010211002 |
SPIRIVA |
171.16 |
9985.706330 |
406111010211 |
406111010211003 |
SPIRIVA |
171.16 |
9985.706330 |
406111010211 |
406111010211004 |
SPIRIVA |
342.33 |
9985.706330 |
406111010211 |
406111010211005 |
SPIRIVA |
342.33 |
9985.706330 |
406111010211 |
406111010211006 |
SPIRIVA |
342.33 |
9985.706330 |
406111010211 |
406111010211007 |
SPIRIVA |
171.16 |
9985.706330 |
406111010211 |
406111010211008 |
SPIRIVA |
171.16 |
9985.706330 |
406111010231 |
406111010231001 |
SYMBICORT |
152.00 |
9985.706330 |
406111010241 |
406111010241001 |
PREDNISONE |
5.00 |
9985.706330 |
406111010241 |
406111010241002 |
PREDNISONE |
5.00 |
9985.706330 |
406111010241 |
406111010241003 |
PREDNISONE |
5.00 |
9985.706330 |
406111010241 |
406111010241004 |
PREDNISONE |
5.00 |
9985.706330 |
406111010431 |
406111010431001 |
SPIRIVA |
171.16 |
9985.706330 |
406111010431 |
406111010431002 |
SPIRIVA |
342.33 |
9985.706330 |
406381030081 |
406381030081001 |
ALBUTEROL-IPRATROPIUM BROMIDE |
95.16 |
8612.296225 |
406381030081 |
406381030081002 |
ALBUTEROL-IPRATROPIUM BROMIDE |
95.16 |
8612.296225 |
406381030091 |
406381030091001 |
ADVAIR DISKUS |
785.59 |
8612.296225 |
406381030131 |
406381030131001 |
METHYLPREDNISOLONE |
149.15 |
8612.296225 |
406381030251 |
406381030251001 |
ALBUTEROL-IPRATROPIUM BROMIDE |
95.52 |
8612.296225 |
406381030251 |
406381030251002 |
ALBUTEROL-IPRATROPIUM BROMIDE |
95.40 |
8612.296225 |
406381030261 |
406381030261001 |
ADVAIR DISKUS |
785.59 |
8612.296225 |
406381030261 |
406381030261002 |
ADVAIR DISKUS |
785.58 |
8612.296225 |
406381030271 |
406381030271001 |
PANTOPRAZOLE |
90.60 |
8612.296225 |
406381030271 |
406381030271002 |
PANTOPRAZOLE |
90.60 |
8612.296225 |
406381030281 |
406381030281001 |
FEXOFENADINE HYDROCHLORIDE |
108.57 |
8612.296225 |
406381030281 |
406381030281002 |
FEXOFENADINE HYDROCHLORIDE |
117.89 |
8612.296225 |
406381030291 |
406381030291001 |
SINGULAIR |
343.96 |
8612.296225 |
406381030291 |
406381030291002 |
SINGULAIR |
343.96 |
8612.296225 |
406381030301 |
406381030301001 |
METHYLPREDNISOLONE |
149.15 |
8612.296225 |
406381030301 |
406381030301002 |
METHYLPREDNISOLONE |
50.72 |
8612.296225 |
406421010271 |
406421010271001 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010271 |
406421010271002 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010271 |
406421010271003 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010271 |
406421010271004 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010271 |
406421010271005 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010271 |
406421010271006 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010301 |
406421010301001 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010301 |
406421010301002 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010301 |
406421010301003 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010301 |
406421010301004 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010301 |
406421010301005 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010301 |
406421010301006 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406421010391 |
406421010391001 |
ADVAIR DISKUS |
322.99 |
13623.186685 |
406551040041 |
406551040041001 |
ALBUTEROL SULFATE |
7.24 |
5843.794078 |
406551040041 |
406551040041002 |
ALBUTEROL SULFATE |
7.24 |
5843.794078 |
406551040041 |
406551040041003 |
ALBUTEROL SULFATE |
7.24 |
5843.794078 |
406551040051 |
406551040051001 |
BUDESONIDE |
140.49 |
5843.794078 |
406551040051 |
406551040051002 |
BUDESONIDE |
140.49 |
5843.794078 |
406551040051 |
406551040051003 |
BUDESONIDE |
140.49 |
5843.794078 |
406961010201 |
406961010201001 |
MIRTAZAPINE |
85.30 |
2239.634008 |
406961010201 |
406961010201002 |
MIRTAZAPINE |
85.30 |
2239.634008 |
406961010201 |
406961010201003 |
MIRTAZAPINE |
85.30 |
2239.634008 |
Return to Top
HC-126I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Analysis Variable: RXXP09X SUM OF PAYMENTS RXSF09X-RXOU09X(IMPUTED)
Return to Top
HC-126I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
Analysis Variable: RXXP09X SUM OF PAYMENTS RXSF09X-RXOU09X(IMPUTED)
Return to Top
NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
NOTE: This session is executing on the XP_PRO platform.
NOTE: SAS initialization used:
real time 0.62 seconds
cpu time 0.35 seconds
NOTE: AUTOEXEC processing beginning; file is
C:\Program Files\SAS92\SASFoundation\9.2\autoexec.sas.
NOTE: AUTOEXEC processing completed.
1 ods rtf file = 'c:\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-126I";
8 TITLE2 "Sample SAS Job for Example C";
9
10 LIBNAME IN "C:\Data";
NOTE: Libref IN was successfully assigned as
follows:
Engine: V9
Physical Name: C:\Data
11
12
*************************************************************************************
13 * Calculate the expenditures for medical visits
associated with asthma.
14
*************************************************************************************;
15 PROC FORMAT;
16 VALUE EVENTYPE
17 1 = "1 MVIS"
18 2 = "2 OPAT"
19 3 = "3 EROM"
20 4 = "4 STAZ"
21 5 = "5 DVIS"
22 6 = "6 OMED"
23 7 = "7 HVIS"
24 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
25 RUN;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds
26
27
*-----------------------------------------------------------------------------------
28 * Get conditions records coded as asthma.
29
*-----------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H128 (KEEP=CONDIDX CCCODEX);
32 IF CCCODEX="128";
33 RUN;
NOTE: There were 117342 observations read from the
data set IN.H128.
NOTE: The data set WORK.ASCONDS has 2420
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 4.06 seconds
cpu time 0.04 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 2420 observations read from the
data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2420
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 (H128) 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.07 seconds
cpu time 0.01 seconds
44
45 PROC SORT DATA=IN.H126IF1 OUT=CLNK; BY CONDIDX;
RUN;
NOTE: There were 342044 observations read from the
data set IN.H126IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 342044
observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 12.37 seconds
cpu time 0.59 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 342044 observations read from the
data set WORK.CLNK.
NOTE: There were 2420 observations read from the
data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7669
observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 1.18 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.04 seconds
cpu time 0.00 seconds
61
62 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: There were 7669 observations read from the
data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 7669
observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
63
64 proc print data=asclnks (obs=50);
65 format eventype eventype.;
66 title3 "sample print of work.asclnks - sorted by
evntidx";
67 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 1.03 seconds
cpu time 0.01 seconds
68
69 DATA ASCLNKS;
70 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
71 BY EVNTIDX;
72 IF FIRST.EVNTIDX;
73 RUN;
NOTE: There were 7669 observations read from the
data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 7667
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
74
75 proc print data=asclnks (obs=50);
76 format eventype eventype.;
77 title3 "sample print of unique evntidxs from
work.asclnks";
78 run;
NOTE: There were 50 observations read from the data
set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.10 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.H126G (KEEP=EVNTIDX PERWT09F SEETLKPV
OBXP09X);
85 IF PERWT09F > 0 & SEETLKPV NE 2;
86 RUN;
NOTE: There were 154599 observations read from the
data set IN.H126G.
NOTE: The data set WORK.MVIS has 149890
observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 12.10 seconds
cpu time 0.25 seconds
87
88 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: There were 149890 observations read from the
data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 149890
observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.07 seconds
cpu time 0.10 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 7667 observations read from the
data set WORK.ASCLNKS.
NOTE: There were 149890 observations read from the
data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 2286
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
99
100 proc print data=asmvis (obs=50);
101 format eventype eventype.;
102 title3 "sample print of work.asmvis";
103 title4 "unique evntidxs from work.asclnks that
are non-telephone MVIS (HC-126G) 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.03 seconds
cpu time 0.01 seconds
105
106 PROC MEANS DATA=ASMVIS N SUM;
107 VAR OBXP09X;
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 2286 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.07 seconds
cpu time 0.01 seconds
110
111 PROC MEANS DATA=ASMVIS N SUM;
112 VAR OBXP09X;
113 WEIGHT PERWT09F;
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 2286 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.07 seconds
cpu time 0.00 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 33.79 seconds
cpu time 1.96 seconds
Return to Top
HC-126I. Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx
COND (H128) records where cccodex=128
Obs |
CONDIDX |
CCCODEX |
1 |
400011010011 |
128 |
2 |
400011030011 |
128 |
3 |
400441010101 |
128 |
4 |
400501010021 |
128 |
5 |
400521010101 |
128 |
6 |
400841010091 |
128 |
7 |
400881020041 |
128 |
8 |
401051050011 |
128 |
9 |
401481020061 |
128 |
10 |
401601010041 |
128 |
11 |
401901010031 |
128 |
12 |
401911030011 |
128 |
13 |
402121010021 |
128 |
14 |
402121020011 |
128 |
15 |
402151010011 |
128 |
16 |
402151020041 |
128 |
17 |
402151030011 |
128 |
18 |
402271010011 |
128 |
19 |
402331020051 |
128 |
20 |
402361020011 |
128 |
21 |
402451030011 |
128 |
22 |
402841010081 |
128 |
23 |
403491040011 |
128 |
24 |
403601030011 |
128 |
25 |
403691020021 |
128 |
26 |
403691050021 |
128 |
27 |
403691060011 |
128 |
28 |
403701020061 |
128 |
29 |
403701020161 |
128 |
30 |
403751020061 |
128 |
31 |
403761020041 |
128 |
32 |
403831010041 |
128 |
33 |
403851020041 |
128 |
34 |
403881010081 |
128 |
35 |
403881020011 |
128 |
36 |
404001010031 |
128 |
37 |
404062010022 |
128 |
38 |
404122010032 |
128 |
39 |
404381030011 |
128 |
40 |
404401020041 |
128 |
41 |
404561010031 |
128 |
42 |
404581020011 |
128 |
43 |
404701010031 |
128 |
44 |
404891010031 |
128 |
45 |
405021050011 |
128 |
46 |
405021060011 |
128 |
47 |
405041010011 |
128 |
48 |
405191020011 |
128 |
49 |
405311040011 |
128 |
50 |
405391030011 |
128 |
Return to Top
HC-126I. Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX |
EVNTIDX |
EVENTYPE |
400011010011 |
400011010061 |
8 PMED |
400011010011 |
400011010101 |
8 PMED |
400011030011 |
400011030081 |
8 PMED |
400441010101 |
400441010411 |
8 PMED |
400501010021 |
400501010011 |
8 PMED |
400501010021 |
400501010051 |
8 PMED |
400501010021 |
400501010091 |
8 PMED |
400501010021 |
400501010121 |
8 PMED |
400521010101 |
400521010031 |
1 MVIS |
400521010101 |
400521010041 |
1 MVIS |
400521010101 |
400521010131 |
8 PMED |
400881020041 |
400881020021 |
1 MVIS |
400881020041 |
400881020031 |
1 MVIS |
400881020041 |
400881020041 |
1 MVIS |
400881020041 |
400881020051 |
8 PMED |
400881020041 |
400881020061 |
8 PMED |
400881020041 |
400881020071 |
8 PMED |
400881020041 |
400881020081 |
8 PMED |
400881020041 |
400881020091 |
1 MVIS |
400881020041 |
400881020101 |
1 MVIS |
400881020041 |
400881020111 |
8 PMED |
401051050011 |
401051050011 |
8 PMED |
401051050011 |
401051050031 |
8 PMED |
401601010041 |
401601010281 |
8 PMED |
401601010041 |
401601010311 |
8 PMED |
401601010041 |
401601010321 |
1 MVIS |
401601010041 |
401601010331 |
1 MVIS |
401601010041 |
401601010341 |
1 MVIS |
401601010041 |
401601010471 |
8 PMED |
401911030011 |
401911030011 |
1 MVIS |
401911030011 |
401911030021 |
1 MVIS |
401911030011 |
401911030031 |
1 MVIS |
401911030011 |
401911030041 |
1 MVIS |
401911030011 |
401911030051 |
1 MVIS |
401911030011 |
401911030091 |
8 PMED |
401911030011 |
401911030131 |
1 MVIS |
401911030011 |
401911030141 |
8 PMED |
402121020011 |
402121020011 |
3 EROM |
402121020011 |
402121020041 |
8 PMED |
402121020011 |
402121020051 |
8 PMED |
402121020011 |
402121020061 |
8 PMED |
402151010011 |
402151010041 |
8 PMED |
402151010011 |
402151010061 |
8 PMED |
402151030011 |
402151030051 |
8 PMED |
402331020051 |
402331020241 |
8 PMED |
402361020011 |
402361020021 |
8 PMED |
402841010081 |
402841010291 |
8 PMED |
403491040011 |
403491040041 |
8 PMED |
403491040011 |
403491040051 |
8 PMED |
403491040011 |
403491040061 |
1 MVIS |
403491040011 |
403491040091 |
8 PMED |
403491040011 |
403491040111 |
8 PMED |
403491040011 |
403491040121 |
8 PMED |
403601030011 |
403601030111 |
8 PMED |
403601030011 |
403601030121 |
8 PMED |
403601030011 |
403601030131 |
8 PMED |
403601030011 |
403601030141 |
8 PMED |
403691020021 |
403691020041 |
1 MVIS |
403691020021 |
403691020051 |
1 MVIS |
403691020021 |
403691020061 |
1 MVIS |
403691020021 |
403691020071 |
1 MVIS |
403691020021 |
403691020081 |
1 MVIS |
403691020021 |
403691020091 |
1 MVIS |
403691020021 |
403691020101 |
1 MVIS |
403691020021 |
403691020111 |
1 MVIS |
403691050021 |
403691050041 |
1 MVIS |
403691050021 |
403691050051 |
1 MVIS |
403691060011 |
403691060011 |
1 MVIS |
403691060011 |
403691060041 |
8 PMED |
403701020061 |
403701020141 |
8 PMED |
403701020061 |
403701020161 |
8 PMED |
403701020061 |
403701020291 |
8 PMED |
403701020061 |
403701020311 |
8 PMED |
403701020061 |
403701020351 |
8 PMED |
403751020061 |
403751020111 |
8 PMED |
Return to Top
HC-126I. Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx
Obs |
CONDIDX |
EVNTIDX |
EVENTYPE |
1 |
400011010011 |
400011010061 |
8 PMED |
2 |
400011010011 |
400011010101 |
8 PMED |
3 |
400011030011 |
400011030081 |
8 PMED |
4 |
400441010101 |
400441010411 |
8 PMED |
5 |
400501010021 |
400501010011 |
8 PMED |
6 |
400501010021 |
400501010051 |
8 PMED |
7 |
400501010021 |
400501010091 |
8 PMED |
8 |
400501010021 |
400501010121 |
8 PMED |
9 |
400521010101 |
400521010031 |
1 MVIS |
10 |
400521010101 |
400521010041 |
1 MVIS |
11 |
400521010101 |
400521010131 |
8 PMED |
12 |
400881020041 |
400881020021 |
1 MVIS |
13 |
400881020041 |
400881020031 |
1 MVIS |
14 |
400881020041 |
400881020041 |
1 MVIS |
15 |
400881020041 |
400881020051 |
8 PMED |
16 |
400881020041 |
400881020061 |
8 PMED |
17 |
400881020041 |
400881020071 |
8 PMED |
18 |
400881020041 |
400881020081 |
8 PMED |
19 |
400881020041 |
400881020091 |
1 MVIS |
20 |
400881020041 |
400881020101 |
1 MVIS |
21 |
400881020041 |
400881020111 |
8 PMED |
22 |
401051050011 |
401051050011 |
8 PMED |
23 |
401051050011 |
401051050031 |
8 PMED |
24 |
401601010041 |
401601010281 |
8 PMED |
25 |
401601010041 |
401601010311 |
8 PMED |
26 |
401601010041 |
401601010321 |
1 MVIS |
27 |
401601010041 |
401601010331 |
1 MVIS |
28 |
401601010041 |
401601010341 |
1 MVIS |
29 |
401601010041 |
401601010471 |
8 PMED |
30 |
401911030011 |
401911030011 |
1 MVIS |
31 |
401911030011 |
401911030021 |
1 MVIS |
32 |
401911030011 |
401911030031 |
1 MVIS |
33 |
401911030011 |
401911030041 |
1 MVIS |
34 |
401911030011 |
401911030051 |
1 MVIS |
35 |
401911030011 |
401911030091 |
8 PMED |
36 |
401911030011 |
401911030131 |
1 MVIS |
37 |
401911030011 |
401911030141 |
8 PMED |
38 |
402121020011 |
402121020011 |
3 EROM |
39 |
402121020011 |
402121020041 |
8 PMED |
40 |
402121020011 |
402121020051 |
8 PMED |
41 |
402121020011 |
402121020061 |
8 PMED |
42 |
402151010011 |
402151010041 |
8 PMED |
43 |
402151010011 |
402151010061 |
8 PMED |
44 |
402151030011 |
402151030051 |
8 PMED |
45 |
402331020051 |
402331020241 |
8 PMED |
46 |
402361020011 |
402361020021 |
8 PMED |
47 |
402841010081 |
402841010291 |
8 PMED |
48 |
403491040011 |
403491040041 |
8 PMED |
49 |
403491040011 |
403491040051 |
8 PMED |
50 |
403491040011 |
403491040061 |
1 MVIS |
Return to Top
HC-126I. Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks
Obs |
EVNTIDX |
EVENTYPE |
1 |
400011010061 |
8 PMED |
2 |
400011010101 |
8 PMED |
3 |
400011030081 |
8 PMED |
4 |
400441010411 |
8 PMED |
5 |
400501010011 |
8 PMED |
6 |
400501010051 |
8 PMED |
7 |
400501010091 |
8 PMED |
8 |
400501010121 |
8 PMED |
9 |
400521010031 |
1 MVIS |
10 |
400521010041 |
1 MVIS |
11 |
400521010131 |
8 PMED |
12 |
400881020021 |
1 MVIS |
13 |
400881020031 |
1 MVIS |
14 |
400881020041 |
1 MVIS |
15 |
400881020051 |
8 PMED |
16 |
400881020061 |
8 PMED |
17 |
400881020071 |
8 PMED |
18 |
400881020081 |
8 PMED |
19 |
400881020091 |
1 MVIS |
20 |
400881020101 |
1 MVIS |
21 |
400881020111 |
8 PMED |
22 |
401051050011 |
8 PMED |
23 |
401051050031 |
8 PMED |
24 |
401601010281 |
8 PMED |
25 |
401601010311 |
8 PMED |
26 |
401601010321 |
1 MVIS |
27 |
401601010331 |
1 MVIS |
28 |
401601010341 |
1 MVIS |
29 |
401601010471 |
8 PMED |
30 |
401911030011 |
1 MVIS |
31 |
401911030021 |
1 MVIS |
32 |
401911030031 |
1 MVIS |
33 |
401911030041 |
1 MVIS |
34 |
401911030051 |
1 MVIS |
35 |
401911030091 |
8 PMED |
36 |
401911030131 |
1 MVIS |
37 |
401911030141 |
8 PMED |
38 |
402121020011 |
3 EROM |
39 |
402121020041 |
8 PMED |
40 |
402121020051 |
8 PMED |
41 |
402121020061 |
8 PMED |
42 |
402151010041 |
8 PMED |
43 |
402151010061 |
8 PMED |
44 |
402151030051 |
8 PMED |
45 |
402331020241 |
8 PMED |
46 |
402361020021 |
8 PMED |
47 |
402841010291 |
8 PMED |
48 |
403491040041 |
8 PMED |
49 |
403491040051 |
8 PMED |
50 |
403491040061 |
1 MVIS |
Return to Top
HC-126I. Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are
non-telephone MVIS (HC-126G) events
Obs |
EVNTIDX |
EVENTYPE |
SEETLKPV |
OBXP09X |
PERWT09F |
1 |
400521010031 |
1 MVIS |
1 |
12.79 |
4936.99 |
2 |
400521010041 |
1 MVIS |
1 |
12.79 |
4936.99 |
3 |
400881020021 |
1 MVIS |
1 |
213.00 |
3579.01 |
4 |
400881020031 |
1 MVIS |
1 |
213.00 |
3579.01 |
5 |
400881020041 |
1 MVIS |
1 |
213.00 |
3579.01 |
6 |
400881020091 |
1 MVIS |
1 |
4164.52 |
3579.01 |
7 |
400881020101 |
1 MVIS |
1 |
0.00 |
3579.01 |
8 |
401601010321 |
1 MVIS |
1 |
20.03 |
2051.24 |
9 |
401601010331 |
1 MVIS |
1 |
42.84 |
2051.24 |
10 |
401601010341 |
1 MVIS |
1 |
61.85 |
2051.24 |
11 |
401911030011 |
1 MVIS |
1 |
107.00 |
5621.65 |
12 |
401911030021 |
1 MVIS |
1 |
357.64 |
5621.65 |
13 |
401911030031 |
1 MVIS |
1 |
357.64 |
5621.65 |
14 |
401911030041 |
1 MVIS |
1 |
357.64 |
5621.65 |
15 |
401911030051 |
1 MVIS |
1 |
357.64 |
5621.65 |
16 |
401911030131 |
1 MVIS |
1 |
357.64 |
5621.65 |
17 |
403491040061 |
1 MVIS |
1 |
0.00 |
2416.07 |
18 |
403691020041 |
1 MVIS |
1 |
74.09 |
8028.26 |
19 |
403691020051 |
1 MVIS |
1 |
74.09 |
8028.26 |
20 |
403691020061 |
1 MVIS |
1 |
74.09 |
8028.26 |
21 |
403691020071 |
1 MVIS |
1 |
459.04 |
8028.26 |
22 |
403691020081 |
1 MVIS |
1 |
742.00 |
8028.26 |
23 |
403691020091 |
1 MVIS |
1 |
61.81 |
8028.26 |
24 |
403691020101 |
1 MVIS |
1 |
117.03 |
8028.26 |
25 |
403691020111 |
1 MVIS |
1 |
84.62 |
8028.26 |
26 |
403691050041 |
1 MVIS |
1 |
81.00 |
14473.97 |
27 |
403691050051 |
1 MVIS |
1 |
155.00 |
14473.97 |
28 |
403691060011 |
1 MVIS |
1 |
97.71 |
12142.93 |
29 |
403751020221 |
1 MVIS |
1 |
87.34 |
5045.10 |
30 |
403751020251 |
1 MVIS |
1 |
87.34 |
5045.10 |
31 |
403751020261 |
1 MVIS |
1 |
54.61 |
5045.10 |
32 |
403751020461 |
1 MVIS |
1 |
37.81 |
5045.10 |
33 |
403751020471 |
1 MVIS |
1 |
34.19 |
5045.10 |
34 |
403761020011 |
1 MVIS |
1 |
59.55 |
10495.66 |
35 |
403761020021 |
1 MVIS |
1 |
59.55 |
10495.66 |
36 |
403761020031 |
1 MVIS |
1 |
59.55 |
10495.66 |
37 |
403761020181 |
1 MVIS |
1 |
122.00 |
10495.66 |
38 |
403761020191 |
1 MVIS |
1 |
242.00 |
10495.66 |
39 |
403761020201 |
1 MVIS |
1 |
114.40 |
10495.66 |
40 |
403761020211 |
1 MVIS |
1 |
114.40 |
10495.66 |
41 |
403761020451 |
1 MVIS |
1 |
78.50 |
10495.66 |
42 |
404001010011 |
1 MVIS |
1 |
301.27 |
2642.39 |
43 |
404381030071 |
1 MVIS |
1 |
204.02 |
2575.50 |
44 |
404381030081 |
1 MVIS |
1 |
153.79 |
2575.50 |
45 |
404381030091 |
1 MVIS |
1 |
153.79 |
2575.50 |
46 |
404381030101 |
1 MVIS |
1 |
204.02 |
2575.50 |
47 |
404401020211 |
1 MVIS |
1 |
52.58 |
14678.30 |
48 |
404401020491 |
1 MVIS |
1 |
94.16 |
14678.30 |
49 |
404401020541 |
1 MVIS |
1 |
104.82 |
14678.30 |
50 |
404561010261 |
1 MVIS |
1 |
84.07 |
25727.23 |
Return to Top
HC-126I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Analysis Variable: OBXP09X SUM OF OBSF09X - OBOT09X (IMPUTED)
Return to Top
HC-126I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
Analysis Variable: OBXP09X SUM OF OBSF09X - OBOT09X (IMPUTED)
Return to Top |