MEPS HC-118I: Attachment 2. Sample SAS Jobs for Linking Example

Font Size:

MEPS HC-118I: Attachment 2
Sample SAS Jobs for Linking Example| << previous page

The SAS System

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
Licensed to WESTAT INC, Site 70006348.
NOTE: This session is executing on the XP_PRO platform.

NOTE: SAS initialization used:
real time 0.68 seconds
cpu time 0.40 seconds

NOTE: AUTOEXEC processing beginning; file is C:\Program Files\SAS92\SASFoundation\9.2\autoexec.sas.

NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

I:\SASTRACE\TRACE92\

NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.03 seconds

NOTE: AUTOEXEC processing completed.

1 ods rtf file = 'c:\sampleA.rtf' bodytitle;
NOTE: Writing RTF Body file: c:\sampleA.rtf
2
3 ods noproctitle;
4
5 OPTIONS LS=132 PS=59;
6
7 TITLE1 "HC-118I";
8 TITLE2 "Sample SAS Job for Example A";
9
10 LIBNAME IN "C:\Data";
NOTE: Libref IN was successfully assigned as follows:
Engine: V9
Physical Name: C:\Data
11
12 ************************************************************************************************
13 * Calculate the expenditures for prescribed medicines associated with medical visits for asthma.
14 ************************************************************************************************;
15
16 PROC FORMAT;
17 VALUE EVENTYPE
18 1 = "1 MVIS"
19 2 = "2 OPAT"
20 3 = "3 EROM"
21 4 = "4 STAZ"
22 5 = "5 DVIS"
23 6 = "6 OMED"
24 7 = "7 HVIS"
25 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
26
27 RUN;

NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.09 seconds
cpu time 0.03 seconds

28
29 *-------------------------------------------------------------------------------------
30 * Get condition records coded as asthma.
31 *-------------------------------------------------------------------------------------;
32 DATA ASCONDS;
33 SET IN.H120 (KEEP=CONDIDX CCCODEX);
34 IF CCCODEX="128";
35
36 RUN;

NOTE: There were 102169 observations read from the data set IN.H120.
NOTE: The data set WORK.ASCONDS has 2100 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.46 seconds
cpu time 0.01 seconds

37
38 *------------------------------------------------------------------------------------
39 * Get the events linked to each of the asthma condition records.
40 *------------------------------------------------------------------------------------;
41 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;

NOTE: There were 2100 observations read from the data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2100 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

42
43 proc print data=asconds (obs=50);
44 title3 "sample print of work.asconds - sorted by condidx";
45 title4 "COND (H120) records where cccodex=128";
46 run;

NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.25 seconds
cpu time 0.03 seconds

47
48 PROC SORT DATA=IN.H118IF1 OUT=CLNK; BY CONDIDX; RUN;

NOTE: There were 294294 observations read from the data set IN.H118IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 294294 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 5.07 seconds
cpu time 0.31 seconds

49
50 DATA ASCLNKS;
51 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
52 ASCONDS(IN=INASCOND KEEP=CONDIDX);
53 BY CONDIDX;
54 IF INCLNK & INASCOND;
55 RUN;

NOTE: There were 294294 observations read from the data set WORK.CLNK.
NOTE: There were 2100 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 6546 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds

56
57 proc print data=asclnks (obs=75);
58 by condidx;
59 id condidx;
60 format eventype eventype.;
61 title3 "sample print of work.asclnks - sorted by condidx";
62 title4 "events linked to asthma condition records";
63 run;

NOTE: There were 75 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.73 seconds
cpu time 0.03 seconds

64
65 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;

NOTE: There were 6546 observations read from the data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 6546 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

66
67 proc print data=asclnks (obs=50);
68 format eventype eventype.;
69 title3 "sample print of work.asclnks - sorted by evntidx";
70 run;

NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.20 seconds
cpu time 0.01 seconds

71
72 DATA ASCLNKS;
73 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
74 BY EVNTIDX;
75 IF FIRST.EVNTIDX;
76 RUN;

NOTE: There were 6546 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6543 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

77
78 proc print data=asclnks (obs=50);
79 title3 "sample print of unique evntidxs from work.asclnks";
80 format eventype eventype.;
81 run;

NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

82
83 *--------------------------------------------------------------------------------------------
84 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
85 *--------------------------------------------------------------------------------------------;
86 DATA MVIS;
87 SET IN.H118G (KEEP=EVNTIDX PERWT08F SEETLKPV);
88 IF PERWT08F > 0 & SEETLKPV NE 2;
89 RUN;

NOTE: There were 136460 observations read from the data set IN.H118G.
NOTE: The data set WORK.MVIS has 132104 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 1.31 seconds
cpu time 0.07 seconds

90
91 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;

NOTE: There were 132104 observations read from the data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 132104 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.06 seconds
cpu time 0.09 seconds

92
93 *---------------------------------------------------------------------------------------------
94 * Identify MVIS events which were for asthma.
95 *---------------------------------------------------------------------------------------------;
96 DATA ASMVIS;
97 MERGE ASCLNKS (IN=INASCLNK)
98 MVIS (IN=INMVIS KEEP=EVNTIDX);
99 BY EVNTIDX;
100 IF INASCLNK & INMVIS;
101 RUN;

NOTE: There were 6543 observations read from the data set WORK.ASCLNKS.
NOTE: There were 132104 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1842 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

102
103 proc print data=asmvis (obs=50);
104 format eventype eventype.;
105 title3 "sample print of work.asmvis";
106 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-118G) events";
107 run;

NOTE: There were 50 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.20 seconds
cpu time 0.00 seconds

108
109 *-------------------------------------------------------------------------------------
110 * Get PMED IDs linked to the MVIS events which were for asthma.
111 *-------------------------------------------------------------------------------------;
112 PROC SORT DATA=IN.H118IF2 OUT=RXLK; BY EVNTIDX; RUN;

NOTE: There were 54857 observations read from the data set IN.H118IF2.
NOTE: SAS sort was used.
NOTE: The data set WORK.RXLK has 54857 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.15 seconds
cpu time 0.04 seconds

113
114 proc print data=rxlk (obs=140);
115 by evntidx;
116 id evntidx;
117 var linkidx eventype;
118 format eventype eventype.;
119 title3 "sample print of work.rxlk - sorted by evntidx";
120 title4 "Rx+event link file records (HC-118IF2)";
121 run;

NOTE: There were 140 observations read from the data set WORK.RXLK.
NOTE: The PROCEDURE PRINT printed pages 7-11.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.37 seconds
cpu time 0.01 seconds

122
123 DATA PMEDIDS;
124 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
125 ASMVIS(IN=INASMVIS KEEP=EVNTIDX);
126 BY EVNTIDX;
127 IF INRXLK & INASMVIS;
128 RUN;

NOTE: There were 54857 observations read from the data set WORK.RXLK.
NOTE: There were 1842 observations read from the data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 1894 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

129
130 proc print data=pmedids (obs=50);
131 by evntidx;
132 id evntidx;
133 format eventype eventype.;
134 title3 "sample print of work.pmedids - sorted by evntidx";
135 title4 "work.rxlk records for evntidxs in work.asmvis";
136 run;

NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed pages 12-13.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds

137
138 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;

NOTE: There were 1894 observations read from the data set WORK.PMEDIDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.PMEDIDS has 1894 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

139
140 proc print data=pmedids (obs=50);
141 format eventype eventype.;
142 title3 "sample print of work.pmedids - sorted by linkidx";
143 run;

NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 14.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

144
145 DATA PMEDIDS;
146 SET PMEDIDS (KEEP=LINKIDX);
147 BY LINKIDX;
148 IF FIRST.LINKIDX;
149 RUN;

NOTE: There were 1894 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1794 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

150
151 proc print data=pmedids (obs=50);
152 title3 "sample print of unique linkidxs in work.pmedids";
153 run;

NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds

154
155 *-----------------------------------------------------------------------------------------
156 * Get PMED records linked to MVIS events which were for asthma.
157 *-----------------------------------------------------------------------------------------;
158 PROC SORT DATA=IN.H118A OUT=PMED; BY LINKIDX; RUN;

NOTE: There were 293379 observations read from the data set IN.H118A.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.PMED has 293379 observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 10.82 seconds
cpu time 0.64 seconds

159
160 DATA MVPMEDS;
161 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP08X PERWT08F RXNAME)
162 PMEDIDS (IN=A);
163 BY LINKIDX;
164 IF A;
165 RUN;

NOTE: There were 293379 observations read from the data set WORK.PMED.
NOTE: There were 1794 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 4544 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.09 seconds

166
167 proc print data=mvpmeds (obs=200);
168 var rxrecidx rxname RXXP08X PERWT08F;
169 by linkidx;
170 id linkidx;
171 title3 "sample print of work.mvpmeds";
172 title4 "PMED (HC-118A) records for unique linkidxs in work.pmedids";
173 run;

NOTE: There were 200 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE PRINT printed pages 16-21.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.67 seconds
cpu time 0.01 seconds

174
175 PROC MEANS DATA=MVPMEDS N SUM;
176 VAR RXXP08X;
177 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
178 RUN;

NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 4544 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 22.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.34 seconds
cpu time 0.03 seconds

179
180 PROC MEANS DATA=MVPMEDS N SUM;
181 VAR RXXP08X;
182 WEIGHT PERWT08F;
183 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
184 TITLE5 "Weighted";
185 RUN;

NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 4544 observations read from the data set WORK.MVPMEDS.
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.13 seconds
cpu time 0.01 seconds

186
187 ods rtf close;
188

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 23.70 seconds
cpu time 2.45 seconds

Return to Top

HC-118I. Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H120) records where cccodex=128

Obs	CONDIDX	CCCODEX
1	700121030011	128
2	700251010031	128
3	700251030011	128
4	700271030011	128
5	700271040031	128
6	700271050061	128
7	700351020091	128
8	700481010071	128
9	700701040051	128
10	700991010041	128
11	701131060041	128
12	701461010041	128
13	701641030011	128
14	701971030021	128
15	701981010011	128
16	702051030011	128
17	702151010051	128
18	702291010041	128
19	702421050011	128
20	702441010071	128
21	702441010181	128
22	702731030022	128
23	702751020041	128
24	702761010011	128
25	702831010061	128
26	702851010021	128
27	702901010041	128
28	702901010061	128
29	702981040031	128
30	703041010021	128
31	703121010051	128
32	703141010031	128
33	703261010041	128
34	703341030011	128
35	703341040011	128
36	703461030011	128
37	703561020021	128
38	703601010051	128
39	703601030023	128
40	703651030011	128
41	703741010041	128
42	703821030011	128
43	703881010031	128
44	703951010021	128
45	704101010051	128
46	704171010061	128
47	704281010051	128
48	704281020011	128
49	704311050011	128
50	704641040011	128

Return to Top

HC-118I. Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records

CONDIDX	EVNTIDX	EVENTYPE
700121030011	700121030041	8 PMED
700121030011	700121030061	8 PMED
700121030011	700121030081	8 PMED
700251030011	700251030161	1 MVIS
700251030011	700251030171	1 MVIS
700251030011	700251030181	1 MVIS
700251030011	700251030191	8 PMED
700251030011	700251030211	8 PMED
700251030011	700251030271	8 PMED
700251030011	700251030311	8 PMED
700271040031	700271040081	8 PMED
700271050061	700271050131	1 MVIS
700271050061	700271050151	8 PMED
700351020091	700351020421	1 MVIS
700351020091	700351020481	8 PMED
700351020091	700351020571	1 MVIS
700351020091	700351020601	8 PMED
700351020091	700351020611	8 PMED
700351020091	700351020651	8 PMED
700351020091	700351020671	8 PMED
700481010071	700481010271	1 MVIS
700481010071	700481010291	1 MVIS
700481010071	700481010311	8 PMED
700481010071	700481010371	8 PMED
700481010071	700481010441	8 PMED
700481010071	700481010521	8 PMED
700701040051	700701040121	3 EROM
700701040051	700701040131	8 PMED
700991010041	700991010201	8 PMED
700991010041	700991010261	8 PMED
701131060041	701131060711	1 MVIS
701131060041	701131060761	8 PMED
701131060041	701131060771	8 PMED
701461010041	701461010071	8 PMED
701461010041	701461010081	8 PMED
701461010041	701461010091	8 PMED
701461010041	701461010101	8 PMED
701461010041	701461010111	8 PMED
701461010041	701461010121	8 PMED
701461010041	701461010131	8 PMED
701461010041	701461010141	8 PMED
701461010041	701461010151	8 PMED
701641030011	701641030091	1 MVIS
701641030011	701641030101	8 PMED
701981010011	701981010061	1 MVIS
701981010011	701981010081	8 PMED
701981010011	701981010121	8 PMED
702051030011	702051030081	8 PMED
702151010051	702151010121	1 MVIS
702151010051	702151010131	1 MVIS
702151010051	702151010141	1 MVIS
702151010051	702151010151	8 PMED
702291010041	702291010191	8 PMED
702421050011	702421050181	8 PMED
702421050011	702421050191	8 PMED
702421050011	702421050201	8 PMED
702421050011	702421050211	8 PMED
702441010071	702441010891	8 PMED
702441010071	702441010981	1 MVIS
702441010071	702441011001	1 MVIS
702441010071	702441011131	8 PMED
702441010181	702441010831	8 PMED
702441010181	702441010901	8 PMED
702441010181	702441010991	1 MVIS
702441010181	702441011051	8 PMED
702441010181	702441011171	8 PMED
702751020041	702751020331	8 PMED
702751020041	702751020371	1 MVIS
702751020041	702751020431	8 PMED
702751020041	702751020501	8 PMED
702761010011	702761010071	8 PMED
702761010011	702761010081	8 PMED
702761010011	702761010101	8 PMED
702761010011	702761010111	8 PMED
702761010011	702761010121	8 PMED

Return to Top

HC-118I. Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	700121030011	700121030041	8 PMED
2	700121030011	700121030061	8 PMED
3	700121030011	700121030081	8 PMED
4	700251030011	700251030161	1 MVIS
5	700251030011	700251030171	1 MVIS
6	700251030011	700251030181	1 MVIS
7	700251030011	700251030191	8 PMED
8	700251030011	700251030211	8 PMED
9	700251030011	700251030271	8 PMED
10	700251030011	700251030311	8 PMED
11	700271040031	700271040081	8 PMED
12	700271050061	700271050131	1 MVIS
13	700271050061	700271050151	8 PMED
14	700351020091	700351020421	1 MVIS
15	700351020091	700351020481	8 PMED
16	700351020091	700351020571	1 MVIS
17	700351020091	700351020601	8 PMED
18	700351020091	700351020611	8 PMED
19	700351020091	700351020651	8 PMED
20	700351020091	700351020671	8 PMED
21	700481010071	700481010271	1 MVIS
22	700481010071	700481010291	1 MVIS
23	700481010071	700481010311	8 PMED
24	700481010071	700481010371	8 PMED
25	700481010071	700481010441	8 PMED
26	700481010071	700481010521	8 PMED
27	700701040051	700701040121	3 EROM
28	700701040051	700701040131	8 PMED
29	700991010041	700991010201	8 PMED
30	700991010041	700991010261	8 PMED
31	701131060041	701131060711	1 MVIS
32	701131060041	701131060761	8 PMED
33	701131060041	701131060771	8 PMED
34	701461010041	701461010071	8 PMED
35	701461010041	701461010081	8 PMED
36	701461010041	701461010091	8 PMED
37	701461010041	701461010101	8 PMED
38	701461010041	701461010111	8 PMED
39	701461010041	701461010121	8 PMED
40	701461010041	701461010131	8 PMED
41	701461010041	701461010141	8 PMED
42	701461010041	701461010151	8 PMED
43	701641030011	701641030091	1 MVIS
44	701641030011	701641030101	8 PMED
45	701981010011	701981010061	1 MVIS
46	701981010011	701981010081	8 PMED
47	701981010011	701981010121	8 PMED
48	702051030011	702051030081	8 PMED
49	702151010051	702151010121	1 MVIS
50	702151010051	702151010131	1 MVIS

Return to Top

HC-118I. Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks

Obs	EVNTIDX	EVENTYPE
1	700121030041	8 PMED
2	700121030061	8 PMED
3	700121030081	8 PMED
4	700251030161	1 MVIS
5	700251030171	1 MVIS
6	700251030181	1 MVIS
7	700251030191	8 PMED
8	700251030211	8 PMED
9	700251030271	8 PMED
10	700251030311	8 PMED
11	700271040081	8 PMED
12	700271050131	1 MVIS
13	700271050151	8 PMED
14	700351020421	1 MVIS
15	700351020481	8 PMED
16	700351020571	1 MVIS
17	700351020601	8 PMED
18	700351020611	8 PMED
19	700351020651	8 PMED
20	700351020671	8 PMED
21	700481010271	1 MVIS
22	700481010291	1 MVIS
23	700481010311	8 PMED
24	700481010371	8 PMED
25	700481010441	8 PMED
26	700481010521	8 PMED
27	700701040121	3 EROM
28	700701040131	8 PMED
29	700991010201	8 PMED
30	700991010261	8 PMED
31	701131060711	1 MVIS
32	701131060761	8 PMED
33	701131060771	8 PMED
34	701461010071	8 PMED
35	701461010081	8 PMED
36	701461010091	8 PMED
37	701461010101	8 PMED
38	701461010111	8 PMED
39	701461010121	8 PMED
40	701461010131	8 PMED
41	701461010141	8 PMED
42	701461010151	8 PMED
43	701641030091	1 MVIS
44	701641030101	8 PMED
45	701981010061	1 MVIS
46	701981010081	8 PMED
47	701981010121	8 PMED
48	702051030081	8 PMED
49	702151010121	1 MVIS
50	702151010131	1 MVIS

Return to Top

HC-118I. Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-118G) events

Obs	EVNTIDX	EVENTYPE
1	700251030161	1 MVIS
2	700251030171	1 MVIS
3	700251030181	1 MVIS
4	700271050131	1 MVIS
5	700351020421	1 MVIS
6	700351020571	1 MVIS
7	700481010271	1 MVIS
8	700481010291	1 MVIS
9	701131060711	1 MVIS
10	701981010061	1 MVIS
11	702151010121	1 MVIS
12	702151010131	1 MVIS
13	702151010141	1 MVIS
14	702441010981	1 MVIS
15	702441010991	1 MVIS
16	702441011001	1 MVIS
17	702751020371	1 MVIS
18	702761010141	1 MVIS
19	703121010201	1 MVIS
20	703121010211	1 MVIS
21	703121010221	1 MVIS
22	703261010331	1 MVIS
23	703261010341	1 MVIS
24	703261010421	1 MVIS
25	703561020011	1 MVIS
26	703601010211	1 MVIS
27	703651030231	1 MVIS
28	704281020371	1 MVIS
29	704281020381	1 MVIS
30	704641040031	1 MVIS
31	704781020461	1 MVIS
32	704781020471	1 MVIS
33	704921020241	1 MVIS
34	705121020401	1 MVIS
35	705121020421	1 MVIS
36	705551030041	1 MVIS
37	705671010351	1 MVIS
38	705671010361	1 MVIS
39	705751020271	1 MVIS
40	705841011771	1 MVIS
41	705841011781	1 MVIS
42	705841012341	1 MVIS
43	706601010231	1 MVIS
44	706601010241	1 MVIS
45	706601010251	1 MVIS
46	706601010261	1 MVIS
47	706801010391	1 MVIS
48	706801010401	1 MVIS
49	706801010411	1 MVIS
50	706801010421	1 MVIS

Return to Top

HC-118I. Sample SAS Job for Example A
sample print of work.rxlk - sorted by evntidx
Rx+event link file records (HC-118IF2)

EVNTIDX	LINKIDX	EVENTYPE
700011020241	700011020321	1 MVIS
700011040071	700011040081	1 MVIS
700041030031	700041030041	1 MVIS
700082010092	700082010152	1 MVIS
700082010092	700082010162	1 MVIS
700091010201	700091010261	1 MVIS
700091010201	700091010271	1 MVIS
700101030111	700101030141	1 MVIS
700101030131	700101030151	1 MVIS
700111010251	700111010301	1 MVIS
700111010281	700111010311	3 EROM
700161010061	700161010081	1 MVIS
700161010091	700161010101	1 MVIS
700161010091	700161010111	1 MVIS
700161010131	700161010141	1 MVIS
700161020081	700161020101	1 MVIS
700161020141	700161020151	1 MVIS
700161020141	700161020161	1 MVIS
700161020141	700161020171	1 MVIS
700211010201	700211010211	1 MVIS
700211010201	700211010221	1 MVIS
700211010201	700211010231	1 MVIS
700211030161	700211030201	1 MVIS
700211030161	700211030211	1 MVIS
700211030231	700211030241	1 MVIS
700211030231	700211030251	1 MVIS
700221010391	700221010441	1 MVIS
700221010391	700221010451	1 MVIS
700221010391	700221010461	1 MVIS
700221020021	700221020051	3 EROM
700251010131	700251010181	1 MVIS
700251010141	700251010191	2 OPAT
700251010141	700251010201	2 OPAT
700251010871	700251010921	1 MVIS
700251010871	700251010931	1 MVIS
700251010871	700251010941	1 MVIS
700251010911	700251010941	1 MVIS
700251010911	700251010951	1 MVIS
700251020011	700251020031	1 MVIS
700251020011	700251020041	1 MVIS
700251020051	700251020061	1 MVIS
700251020071	700251020081	1 MVIS
700251030161	700251030191	1 MVIS
700251030161	700251030201	1 MVIS
700251030161	700251030211	1 MVIS
700251030221	700251030261	1 MVIS
700251030241	700251030271	1 MVIS
700251030241	700251030281	1 MVIS
700251030241	700251030291	1 MVIS
700251030241	700251030301	1 MVIS
700251030241	700251030311	1 MVIS
700271020041	700271020051	3 EROM
700271050071	700271050081	1 MVIS
700271050071	700271050091	1 MVIS
700271050071	700271050101	1 MVIS
700271050131	700271050151	1 MVIS
700271060111	700271060131	1 MVIS
700271060111	700271060141	1 MVIS
700281030131	700281030141	3 EROM
700281040101	700281040111	1 MVIS
700281050031	700281050041	3 EROM
700291010142	700291010152	3 EROM
700321010231	700321010331	1 MVIS
700321010241	700321010341	5 DVIS
700321020531	700321020551	1 MVIS
700321020531	700321020561	1 MVIS
700331010141	700331010181	5 DVIS
700331010141	700331010191	5 DVIS
700331010151	700331010201	1 MVIS
700331010151	700331010211	1 MVIS
700331010151	700331010221	1 MVIS
700331010151	700331010231	1 MVIS
700331010151	700331010241	1 MVIS
700341020271	700341020291	1 MVIS
700341020281	700341020301	1 MVIS
700341020311	700341020361	1 MVIS
700341020321	700341020371	1 MVIS
700341020321	700341020381	1 MVIS
700341020321	700341020391	1 MVIS
700351020321	700351020431	1 MVIS
700351020321	700351020441	1 MVIS
700351020321	700351020451	1 MVIS
700351020321	700351020461	1 MVIS
700351020321	700351020471	1 MVIS
700351020321	700351020481	1 MVIS
700351020331	700351020491	3 EROM
700351020421	700351020501	1 MVIS
700351020421	700351020511	1 MVIS
700351020571	700351020601	1 MVIS
700351020571	700351020611	1 MVIS
700361010291	700361010381	1 MVIS
700361010351	700361010391	1 MVIS
700361010351	700361010401	1 MVIS
700361010431	700361010441	1 MVIS
700361010431	700361010451	1 MVIS
700361020271	700361020301	1 MVIS
700361020281	700361020311	1 MVIS
700361020411	700361020591	1 MVIS
700361020421	700361020601	1 MVIS
700361020461	700361020611	1 MVIS
700361020461	700361020621	1 MVIS
700361020461	700361020631	1 MVIS
700361020491	700361020641	1 MVIS
700361020571	700361020651	2 OPAT
700371010431	700371010451	1 MVIS
700371010541	700371010551	1 MVIS
700371010541	700371010561	1 MVIS
700371010541	700371010571	1 MVIS
700371010541	700371010581	1 MVIS
700371010541	700371010591	1 MVIS
700371010541	700371010601	1 MVIS
700371010541	700371010611	1 MVIS
700371010541	700371010621	1 MVIS
700431010681	700431010751	1 MVIS
700431010681	700431010761	1 MVIS
700431010681	700431010771	1 MVIS
700431010681	700431010781	1 MVIS
700431010681	700431010791	1 MVIS
700461010121	700461010131	1 MVIS
700501010111	700501010151	4 STAZ
700501030201	700501030291	1 MVIS
700531010371	700531010391	1 MVIS
700531010481	700531010471	1 MVIS
700531010561	700531010621	1 MVIS
700531010561	700531010631	1 MVIS
700531010561	700531010641	1 MVIS
700531030081	700531030091	1 MVIS
700671020371	700671020391	1 MVIS
700691020051	700691020061	1 MVIS
700701030101	700701030121	5 DVIS
700701030111	700701030121	5 DVIS
700701040091	700701040101	3 EROM
700701040091	700701040111	3 EROM
700701040121	700701040131	3 EROM
700731010061	700731010071	1 MVIS
700731010061	700731010081	1 MVIS
700731010091	700731010101	1 MVIS
700751010221	700751010241	1 MVIS
700751010221	700751010251	1 MVIS
700751010221	700751010261	1 MVIS

Return to Top

HC-118I. Sample SAS Job for Example A
sample print of work.pmedids - sorted by evntidx
work.rxlk records for evntidxs in work.asmvis

EVNTIDX	LINKIDX	EVENTYPE
700251030161	700251030191	1 MVIS
700251030161	700251030201	1 MVIS
700251030161	700251030211	1 MVIS
700271050131	700271050151	1 MVIS
700351020421	700351020501	1 MVIS
700351020421	700351020511	1 MVIS
700351020571	700351020601	1 MVIS
700351020571	700351020611	1 MVIS
701981010061	701981010071	1 MVIS
701981010061	701981010081	1 MVIS
701981010061	701981010091	1 MVIS
701981010061	701981010101	1 MVIS
702151010121	702151010151	1 MVIS
702151010131	702151010151	1 MVIS
703121010201	703121010241	1 MVIS
703121010201	703121010251	1 MVIS
703121010201	703121010261	1 MVIS
703121010201	703121010271	1 MVIS
703121010201	703121010281	1 MVIS
703121010201	703121010291	1 MVIS
703121010201	703121010301	1 MVIS
703121010201	703121010311	1 MVIS
703121010201	703121010321	1 MVIS
703121010201	703121010331	1 MVIS
703121010201	703121010341	1 MVIS
703261010331	703261010361	1 MVIS
703261010331	703261010371	1 MVIS
703261010331	703261010381	1 MVIS
703261010331	703261010391	1 MVIS
703261010331	703261010401	1 MVIS
703261010331	703261010411	1 MVIS
703261010341	703261010361	1 MVIS
703261010341	703261010371	1 MVIS
703261010341	703261010381	1 MVIS
703261010341	703261010391	1 MVIS
703261010341	703261010401	1 MVIS
703261010341	703261010411	1 MVIS
703261010421	703261010451	1 MVIS
703261010421	703261010461	1 MVIS
703261010421	703261010471	1 MVIS
703261010421	703261010481	1 MVIS
703561020011	703561020021	1 MVIS
703561020011	703561020031	1 MVIS
703601010211	703601010231	1 MVIS
704281020371	704281020411	1 MVIS
704281020381	704281020421	1 MVIS
704641040031	704641040041	1 MVIS
704781020461	704781020481	1 MVIS
704921020241	704921020251	1 MVIS
705121020401	705121020431	1 MVIS

Return to Top

HC-118I. Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx

Obs	EVNTIDX	LINKIDX	EVENTYPE
1	700251030161	700251030191	1 MVIS
2	700251030161	700251030201	1 MVIS
3	700251030161	700251030211	1 MVIS
4	700271050131	700271050151	1 MVIS
5	700351020421	700351020501	1 MVIS
6	700351020421	700351020511	1 MVIS
7	700351020571	700351020601	1 MVIS
8	700351020571	700351020611	1 MVIS
9	701981010061	701981010071	1 MVIS
10	701981010061	701981010081	1 MVIS
11	701981010061	701981010091	1 MVIS
12	701981010061	701981010101	1 MVIS
13	702151010121	702151010151	1 MVIS
14	702151010131	702151010151	1 MVIS
15	703121010201	703121010241	1 MVIS
16	703121010201	703121010251	1 MVIS
17	703121010201	703121010261	1 MVIS
18	703121010201	703121010271	1 MVIS
19	703121010201	703121010281	1 MVIS
20	703121010201	703121010291	1 MVIS
21	703121010201	703121010301	1 MVIS
22	703121010201	703121010311	1 MVIS
23	703121010201	703121010321	1 MVIS
24	703121010201	703121010331	1 MVIS
25	703121010201	703121010341	1 MVIS
26	703261010331	703261010361	1 MVIS
27	703261010341	703261010361	1 MVIS
28	703261010331	703261010371	1 MVIS
29	703261010341	703261010371	1 MVIS
30	703261010331	703261010381	1 MVIS
31	703261010341	703261010381	1 MVIS
32	703261010331	703261010391	1 MVIS
33	703261010341	703261010391	1 MVIS
34	703261010331	703261010401	1 MVIS
35	703261010341	703261010401	1 MVIS
36	703261010331	703261010411	1 MVIS
37	703261010341	703261010411	1 MVIS
38	703261010421	703261010451	1 MVIS
39	703261010421	703261010461	1 MVIS
40	703261010421	703261010471	1 MVIS
41	703261010421	703261010481	1 MVIS
42	703561020011	703561020021	1 MVIS
43	703561020011	703561020031	1 MVIS
44	703601010211	703601010231	1 MVIS
45	704281020371	704281020411	1 MVIS
46	704281020381	704281020421	1 MVIS
47	704641040031	704641040041	1 MVIS
48	704781020461	704781020481	1 MVIS
49	704921020241	704921020251	1 MVIS
50	705121020401	705121020431	1 MVIS

Return to Top

HC-118I. Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids

Obs	LINKIDX
1	700251030191
2	700251030201
3	700251030211
4	700271050151
5	700351020501
6	700351020511
7	700351020601
8	700351020611
9	701981010071
10	701981010081
11	701981010091
12	701981010101
13	702151010151
14	703121010241
15	703121010251
16	703121010261
17	703121010271
18	703121010281
19	703121010291
20	703121010301
21	703121010311
22	703121010321
23	703121010331
24	703121010341
25	703261010361
26	703261010371
27	703261010381
28	703261010391
29	703261010401
30	703261010411
31	703261010451
32	703261010461
33	703261010471
34	703261010481
35	703561020021
36	703561020031
37	703601010231
38	704281020411
39	704281020421
40	704641040041
41	704781020481
42	704921020251
43	705121020431
44	705121020441
45	705551030051
46	705671010381
47	705671010391
48	705841012191
49	705841012591
50	705841012601

Return to Top

HC-118I. Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-118A) records for unique linkidxs in work.pmedids

LINKIDX	RXRECIDX	RXNAME	RXXP08X	PERWT08F
700251030191	700251030191001	XOPENEX (PF)	84.87	3160.81
700251030201	700251030201001	ZYRTEC	6.44	3160.81
700251030201	700251030201002	ZYRTEC	6.44	3160.81
700251030211	700251030211001	FLOVENT DISKUS	120.85	3160.81
700271050151	700271050151001	XOPENEX HFA (200 ACTUATIONS)	52.63	1840.44
700351020501	700351020501001	SPIRIVA (W/ HANDIHALER)	147.06	9219.77
700351020511	700351020511001	ALBUTEROL	34.85	9219.77
700351020601	700351020601001	SYMBICORT	170.29	9219.77
700351020601	700351020601002	SYMBICORT	170.29	9219.77
700351020611	700351020611001	SPIRIVA (W/ HANDIHALER)	147.06	9219.77
700351020611	700351020611002	SPIRIVA (W/ HANDIHALER)	147.06	9219.77
700351020611	700351020611003	SPIRIVA (W/ HANDIHALER)	147.06	9219.77
700351020611	700351020611004	SPIRIVA (W/ HANDIHALER)	147.06	9219.77
701981010071	701981010071001	METHYLPREDNISOLONE	10.75	9361.57
701981010081	701981010081001	PROAIR HFA	32.34	9361.57
701981010091	701981010091001	AMOXICILLIN	9.80	9361.57
701981010101	701981010101001	ALBUTEROL	22.02	9361.57
702151010151	702151010151001	SYMBICORT	189.80	10837.01
702151010151	702151010151002	SYMBICORT	189.80	10837.01
703121010241	703121010241001	PREVACID	330.04	2675.14
703121010241	703121010241002	PREVACID	330.04	2675.14
703121010241	703121010241003	PREVACID	330.04	2675.14
703121010241	703121010241004	PREVACID	330.04	2675.14
703121010241	703121010241005	PREVACID	330.04	2675.14
703121010251	703121010251001	HYDROCHLOROTHIAZIDE	7.50	2675.14
703121010251	703121010251002	HYDROCHLOROTHIAZIDE	7.50	2675.14
703121010251	703121010251003	HYDROCHLOROTHIAZIDE	7.50	2675.14
703121010251	703121010251004	HYDROCHLOROTHIAZIDE	7.50	2675.14
703121010251	703121010251005	HYDROCHLOROTHIAZIDE	7.50	2675.14
703121010261	703121010261001	IBUPROFEN	13.20	2675.14
703121010261	703121010261002	IBUPROFEN	13.20	2675.14
703121010261	703121010261003	IBUPROFEN	13.20	2675.14
703121010261	703121010261004	IBUPROFEN	13.20	2675.14
703121010261	703121010261005	IBUPROFEN	13.20	2675.14
703121010271	703121010271001	FUROSEMIDE	7.07	2675.14
703121010271	703121010271002	FUROSEMIDE	7.57	2675.14
703121010271	703121010271003	FUROSEMIDE	7.57	2675.14
703121010271	703121010271004	FUROSEMIDE	7.57	2675.14
703121010271	703121010271005	FUROSEMIDE	7.57	2675.14
703121010281	703121010281001	TERBUTALINE SULFATE	26.21	2675.14
703121010281	703121010281002	TERBUTALINE SULFATE	26.21	2675.14
703121010281	703121010281003	TERBUTALINE SULFATE	28.21	2675.14
703121010281	703121010281004	TERBUTALINE SULFATE	28.21	2675.14
703121010281	703121010281005	TERBUTALINE SULFATE	28.21	2675.14
703121010291	703121010291001	EXTENDED PHENYTOIN SODIUM	35.09	2675.14
703121010291	703121010291002	EXTENDED PHENYTOIN SODIUM	35.09	2675.14
703121010291	703121010291003	EXTENDED PHENYTOIN SODIUM	35.09	2675.14
703121010291	703121010291004	EXTENDED PHENYTOIN SODIUM	35.09	2675.14
703121010291	703121010291005	EXTENDED PHENYTOIN SODIUM	35.09	2675.14
703121010301	703121010301001	CENESTIN (FILM-COATED)	50.16	2675.14
703121010301	703121010301002	CENESTIN (FILM-COATED)	50.16	2675.14
703121010301	703121010301003	CENESTIN (FILM-COATED)	53.16	2675.14
703121010301	703121010301004	CENESTIN (FILM-COATED)	53.16	2675.14
703121010301	703121010301005	CENESTIN (FILM-COATED)	53.16	2675.14
703121010311	703121010311001	AMITRIPTYLINE HCL (FILM COATED)	9.19	2675.14
703121010311	703121010311002	AMITRIPTYLINE HCL (FILM COATED)	9.19	2675.14
703121010311	703121010311003	AMITRIPTYLINE HCL (FILM COATED)	9.69	2675.14
703121010311	703121010311004	AMITRIPTYLINE HCL (FILM COATED)	9.69	2675.14
703121010311	703121010311005	AMITRIPTYLINE HCL (FILM COATED)	9.69	2675.14
703121010321	703121010321001	ALBUTEROL SULFATE (PF)	43.94	2675.14
703121010321	703121010321002	ALBUTEROL SULFATE (PF)	43.94	2675.14
703121010321	703121010321003	ALBUTEROL SULFATE (PF)	43.94	2675.14
703121010321	703121010321004	ALBUTEROL SULFATE (PF)	43.94	2675.14
703121010321	703121010321005	ALBUTEROL SULFATE (PF)	43.94	2675.14
703121010331	703121010331001	IPRATROPIUM BROMIDE (PF)	521.53	2675.14
703121010331	703121010331002	IPRATROPIUM BROMIDE (PF)	521.53	2675.14
703121010331	703121010331003	IPRATROPIUM BROMIDE (PF)	521.53	2675.14
703121010331	703121010331004	IPRATROPIUM BROMIDE (PF)	521.53	2675.14
703121010331	703121010331005	IPRATROPIUM BROMIDE (PF)	521.53	2675.14
703121010341	703121010341001	CEFDINIR	72.05	2675.14
703121010341	703121010341002	CEFDINIR	72.05	2675.14
703121010341	703121010341003	CEFDINIR	72.05	2675.14
703121010341	703121010341004	CEFDINIR	72.05	2675.14
703121010341	703121010341005	CEFDINIR	72.05	2675.14
703261010361	703261010361001	ADVAIR DISKUS 100/50	149.34	3783.89
703261010361	703261010361002	ADVAIR DISKUS 100/50	149.34	3783.89
703261010361	703261010361003	ADVAIR DISKUS 100/50	149.34	3783.89
703261010361	703261010361004	ADVAIR DISKUS 100/50	149.34	3783.89
703261010361	703261010361005	ADVAIR DISKUS 100/50	149.34	3783.89
703261010361	703261010361006	ADVAIR DISKUS 100/50	155.89	3783.89
703261010361	703261010361007	ADVAIR DISKUS 100/50	155.89	3783.89
703261010371	703261010371001	NIASPAN	109.20	3783.89
703261010371	703261010371002	NIASPAN	109.20	3783.89
703261010371	703261010371003	NIASPAN	109.20	3783.89
703261010371	703261010371004	NIASPAN	109.20	3783.89
703261010371	703261010371005	NIASPAN	109.20	3783.89
703261010371	703261010371006	NIASPAN	109.20	3783.89
703261010371	703261010371007	NIASPAN	109.20	3783.89
703261010381	703261010381001	CRESTOR	97.63	3783.89
703261010381	703261010381002	CRESTOR	97.63	3783.89
703261010381	703261010381003	CRESTOR	97.63	3783.89
703261010381	703261010381004	CRESTOR	97.63	3783.89
703261010381	703261010381005	CRESTOR	102.42	3783.89
703261010381	703261010381006	CRESTOR	102.42	3783.89
703261010381	703261010381007	CRESTOR	102.42	3783.89
703261010391	703261010391001	ATENOLOL	3.09	3783.89
703261010391	703261010391002	ATENOLOL	3.09	3783.89
703261010391	703261010391003	ATENOLOL	3.09	3783.89
703261010391	703261010391004	ATENOLOL	3.09	3783.89
703261010391	703261010391005	ATENOLOL	3.09	3783.89
703261010391	703261010391006	ATENOLOL	3.09	3783.89
703261010391	703261010391007	ATENOLOL	3.09	3783.89
703261010401	703261010401001	TRICOR	38.13	3783.89
703261010401	703261010401002	TRICOR	38.13	3783.89
703261010401	703261010401003	TRICOR	38.13	3783.89
703261010401	703261010401004	TRICOR	38.13	3783.89
703261010401	703261010401005	TRICOR	38.13	3783.89
703261010401	703261010401006	TRICOR	38.13	3783.89
703261010401	703261010401007	TRICOR	38.13	3783.89
703261010411	703261010411001	CLOBETASOL PROPIONATE	41.84	3783.89
703261010411	703261010411002	CLOBETASOL PROPIONATE	41.84	3783.89
703261010411	703261010411003	CLOBETASOL PROPIONATE	41.84	3783.89
703261010411	703261010411004	CLOBETASOL PROPIONATE	41.84	3783.89
703261010411	703261010411005	CLOBETASOL PROPIONATE	41.84	3783.89
703261010411	703261010411006	CLOBETASOL PROPIONATE	41.84	3783.89
703261010411	703261010411007	CLOBETASOL PROPIONATE	41.84	3783.89
703261010451	703261010451001	ADVAIR DISKUS 100/50	155.89	3783.89
703261010451	703261010451002	ADVAIR DISKUS 100/50	155.89	3783.89
703261010451	703261010451003	ADVAIR DISKUS 100/50	155.89	3783.89
703261010461	703261010461001	CRESTOR	102.42	3783.89
703261010461	703261010461002	CRESTOR	102.42	3783.89
703261010461	703261010461003	CRESTOR	102.42	3783.89
703261010471	703261010471001	ATENOLOL	3.09	3783.89
703261010471	703261010471002	ATENOLOL	3.09	3783.89
703261010471	703261010471003	ATENOLOL	3.09	3783.89
703261010481	703261010481001	TRICOR	38.13	3783.89
703261010481	703261010481002	TRICOR	38.13	3783.89
703261010481	703261010481003	TRICOR	38.13	3783.89
703561020021	703561020021001	PROAIR HFA	20.00	3379.73
703561020031	703561020031001	SYMBICORT	167.04	3379.73
703601010231	703601010231001	ALBUTEROL	22.02	10819.95
704281020411	704281020411001	ALBUTEROL	19.18	12968.13
704281020421	704281020421001	FLOVENT HFA	112.25	12968.13
704641040041	704641040041001	AZITHROMYCIN	10.00	5978.43
704781020481	704781020481001	ALBUTEROL	25.86	15276.22
704921020251	704921020251001	SODIUM CHLORIDE	19.95	25608.94
705121020431	705121020431001	FLOVENT HFA (WITH DOSE COUNTER)	85.64	10239.60
705121020441	705121020441001	PROAIR HFA	32.08	10239.60
705551030051	705551030051001	AEROCHAMBER	37.29	5229.16
705671010381	705671010381001	PREDNISONE	2.95	3682.77
705671010391	705671010391001	APAP/HYDROCODONE BITARTRATE	65.08	3682.77
705671010391	705671010391002	APAP/HYDROCODONE BITARTRATE	65.08	3682.77
705671010391	705671010391003	APAP/HYDROCODONE BITARTRATE	62.66	3682.77
705671010391	705671010391004	APAP/HYDROCODONE BITARTRATE	62.66	3682.77
705671010391	705671010391005	APAP/HYDROCODONE BITARTRATE	62.66	3682.77
705841012191	705841012191001	AZITHROMYCIN (FILM-COATED)	10.00	9597.15
705841012191	705841012191002	AZITHROMYCIN (FILM-COATED)	10.00	9597.15
705841012591	705841012591001	SINGULAIR (UNIT OF USE)	104.97	9597.15
705841012601	705841012601001	DOXYCYCLINE HYCLATE	10.00	9597.15
706801010701	706801010701001	SINGULAIR (UNIT OF USE)	285.42	8658.20
706801010711	706801010711001	PROVENTIL HFA (M.D.I.)	68.82	8658.20
706801010721	706801010721001	ADVAIR DISKUS 250/50	509.58	8658.20
706801010731	706801010731001	FEXOFENADINE HYDROCHLORIDE (FILM-COATED)	94.84	8658.20
706801010741	706801010741001	VERAMYST	222.47	8658.20
706851020441	706851020441001	ENALAPRIL MALEATE (WHITE)	5.51	4170.41
706851020441	706851020441002	ENALAPRIL MALEATE (WHITE)	5.51	4170.41
706851020441	706851020441003	ENALAPRIL MALEATE (WHITE)	5.51	4170.41
706851020451	706851020451001	GABAPENTIN	89.15	4170.41
706851020471	706851020471001	LANTUS	87.21	4170.41
706851020471	706851020471002	LANTUS	82.45	4170.41
706851020471	706851020471003	LANTUS	82.45	4170.41
707581030192	707581030192001	PROAIR HFA	32.08	7974.13
707581030202	707581030202001	ADVAIR DISKUS 250/50	190.96	7974.13
707691010121	707691010121001	ATENOLOL	4.00	4330.61
707691010131	707691010131001	FOLIC ACID	0.50	4330.61
707691010141	707691010141001	COL-RITE	1.00	4330.61
707791021211	707791021211001	TOPROL XL	29.84	30500.24
707791021211	707791021211002	TOPROL XL	29.84	30500.24
707791021211	707791021211003	TOPROL XL	29.84	30500.24
707791021221	707791021221001	PLAVIX (FILM-COATED)	141.80	30500.24
707791021221	707791021221002	PLAVIX (FILM-COATED)	141.80	30500.24
707791021221	707791021221003	PLAVIX (FILM-COATED)	62.58	30500.24
707791021231	707791021231001	BENICAR (FILM-COATED)	112.26	30500.24
707791021231	707791021231002	BENICAR (FILM-COATED)	57.13	30500.24
707791021231	707791021231003	BENICAR (FILM-COATED)	57.13	30500.24
708051010441	708051010441001	ASMANEX TWISTHALER (60-INHALATION)	487.12	5401.55
708051010451	708051010451001	VERAMYST	80.60	5401.55
708771020521	708771020521001	AZITHROMYCIN (3X6,UNIT OF USE)	10.00	6965.39
708771020531	708771020531001	PREDNISONE	6.33	6965.39
708771020671	708771020671001	SMZ-TMP	10.00	6965.39
709351020661	709351020661001	SYMBICORT	1214.83	10509.88
709351020661	709351020661002	SYMBICORT	1214.83	10509.88
709351020671	709351020671001	PROAIR HFA	339.67	10509.88
710161010091	710161010091001	SINGULAIR (UNIT OF USE)	104.97	9884.72
710161010101	710161010101001	ADVAIR DISKUS 250/50	190.96	9884.72
710161010101	710161010101002	ADVAIR DISKUS 250/50	190.96	9884.72
710161010111	710161010111001	ALBUTEROL	22.02	9884.72
711011010361	711011010361001	FLOVENT DISKUS	120.85	12581.93
711011010371	711011010371001	ALBUTEROL	44.04	12581.93
711861030391	711861030391001	ALBUTEROL SULFATE (VIAL)	11.93	10238.30
711861030391	711861030391002	ALBUTEROL SULFATE (VIAL)	11.93	10238.30
711861030401	711861030401001	SINGULAIR (UNIT OF USE)	104.97	10238.30
711861030401	711861030401002	SINGULAIR (UNIT OF USE)	104.97	10238.30
711861030401	711861030401003	SINGULAIR (UNIT OF USE)	104.97	10238.30
712041011011	712041011011001	NEXIUM (UNIT OF USE)	465.75	8322.43
712041011021	712041011021001	PLAVIX (FILM-COATED)	415.98	8322.43
712041011031	712041011031001	METFORMIN HYDROCHLORIDE (FILM-COATED)	11.98	8322.43
712041011041	712041011041001	DARVOCET-N 100	34.17	8322.43
712041011051	712041011051001	ADVAIR DISKUS 500/50	752.50	8322.43
712041011061	712041011061001	LISINOPRIL	21.72	8322.43

Return to Top

HC-118I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Analysis Variable : RXXP08X SUM OF PAYMENTS RXSF08X-RXOU08X(IMPUTED)

N	Sum
4544	364559.18

Return to Top

HC-118I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
Analysis Variable : RXXP08X SUM OF PAYMENTS RXSF08X-RXOU08X(IMPUTED)

N	Sum
4544	3180147225

Return to Top

NOTE: SAS initialization used:
real time 0.71 seconds
cpu time 0.45 seconds

NOTE: AUTOEXEC processing beginning; file is C:\Program Files\SAS92\SASFoundation\9.2\autoexec.sas.

NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

I:\SASTRACE\TRACE92\

NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.01 seconds

NOTE: AUTOEXEC processing completed.

1 ods rtf file = 'c:\sampleB.rtf' bodytitle;
NOTE: Writing RTF Body file: c:\sampleB.rtf
2
3 ods noproctitle;
4
5 OPTIONS LS=132 PS=59;
6
7 TITLE1 "HC-118I";
8 TITLE2 "Sample SAS Job for Example B";
9
10 LIBNAME IN "C:\Data";
NOTE: Libref IN was successfully assigned as follows:
Engine: V9
Physical Name: C:\Data
11
12 **************************************************************************************
13 * Calculate the expenditures for prescribed medicines associated with asthma.
14 **************************************************************************************;
15 PROC FORMAT;
16 VALUE EVENTYPE
17 1 = "1 MVIS"
18 2 = "2 OPAT"
19 3 = "3 EROM"
20 4 = "4 STAZ"
21 5 = "5 DVIS"
22 6 = "6 OMED"
23 7 = "7 HVIS"
24 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
25 RUN;

NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.09 seconds
cpu time 0.01 seconds

26
27 *--------------------------------------------------------------------------------------
28 * Get condition records coded as asthma.
29 *--------------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H120 (KEEP=CONDIDX CCCODEX);
32 IF CCCODEX="128";
33 RUN;

34
35 *--------------------------------------------------------------------------
36 * Get the events linked to each of the asthma condition records.
37 *--------------------------------------------------------------------------;
38 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;

39
40 proc print data=asconds (obs=50);
41 title3 "sample print of work.asconds - sorted by condidx";
42 title4 "COND (H120) records where cccodex=128";
43 run;

NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.06 seconds
cpu time 0.03 seconds

44
45 PROC SORT DATA=IN.H118IF1 OUT=CLNK; BY CONDIDX; RUN;

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;

53
54 proc print data=asclnks (obs=75);
55 by condidx;
56 id condidx;
57 format eventype eventype.;
58 title3 "sample print of work.asclnks - sorted by condidx";
59 title4 "events linked to asthma condition records";
60 run;

NOTE: There were 75 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used (Total process time):
real time 1.18 seconds
cpu time 0.01 seconds

61
62 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;

63
64 proc print data=asclnks (obs=50);
65 format eventype eventype.;
66 title3 "sample print of work.asclnks - sorted by evntidx";
67 run;

NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

68
69 DATA ASCLNKS;
70 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
71 BY EVNTIDX;
72 IF FIRST.EVNTIDX;
73 RUN;

74
75 proc print data=asclnks (obs=50);
76 format eventype eventype.;
77 title3 "sample print of unique evntidxs from work.asclnks";
78 run;

NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

79
80 *-------------------------------------------------------------------------------
81 * Get PMED records linked to asthma condition records.
82 *-------------------------------------------------------------------------------;
83 PROC SORT DATA=IN.H118A OUT=PMED; BY LINKIDX; RUN;

84
85 DATA ASPMEDS;
86 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP08X PERWT08F)
87 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX RENAME=(EVNTIDX=LINKIDX));
88 BY LINKIDX;
89 IF INASCLNK & PERWT08F>0;
90 RUN;

NOTE: There were 293379 observations read from the data set WORK.PMED.
NOTE: There were 6543 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 9502 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.11 seconds
cpu time 0.10 seconds

91
92 proc print data=aspmeds (obs=300);
93 by linkidx;
94 id linkidx;
95 var rxrecidx rxname RXXP08X PERWT08F;
96 title3 "sample print of work.aspmeds";
97 title4 "PMED (HC-118A) records which link to condition records coded as asthma";
98 run;

NOTE: There were 300 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE PRINT printed pages 6-14.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.73 seconds
cpu time 0.03 seconds

99
100 PROC MEANS DATA=ASPMEDS N SUM;
101 VAR RXXP08X;
102 TITLE3 "Total Rx expenditures associated with asthma";
103 RUN;

NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 9502 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 15.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.25 seconds
cpu time 0.01 seconds

104
105 PROC MEANS DATA=ASPMEDS N SUM;
106 VAR RXXP08X;
107 WEIGHT PERWT08F;
108 TITLE3 "Total Rx expenditures associated with asthma";
109 TITLE5 "Weighted";
110 RUN;

NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 9502 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 16.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.11 seconds
cpu time 0.03 seconds

111
112 ods rtf close;
113

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 18.73 seconds
cpu time 2.14 seconds

Return to Top

HC-118I. Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H120) records where cccodex=128

Obs	CONDIDX	CCCODEX
1	700121030011	128
2	700251010031	128
3	700251030011	128
4	700271030011	128
5	700271040031	128
6	700271050061	128
7	700351020091	128
8	700481010071	128
9	700701040051	128
10	700991010041	128
11	701131060041	128
12	701461010041	128
13	701641030011	128
14	701971030021	128
15	701981010011	128
16	702051030011	128
17	702151010051	128
18	702291010041	128
19	702421050011	128
20	702441010071	128
21	702441010181	128
22	702731030022	128
23	702751020041	128
24	702761010011	128
25	702831010061	128
26	702851010021	128
27	702901010041	128
28	702901010061	128
29	702981040031	128
30	703041010021	128
31	703121010051	128
32	703141010031	128
33	703261010041	128
34	703341030011	128
35	703341040011	128
36	703461030011	128
37	703561020021	128
38	703601010051	128
39	703601030023	128
40	703651030011	128
41	703741010041	128
42	703821030011	128
43	703881010031	128
44	703951010021	128
45	704101010051	128
46	704171010061	128
47	704281010051	128
48	704281020011	128
49	704311050011	128
50	704641040011	128

Return to Top

HC-118I. Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records

CONDIDX	EVNTIDX	EVENTYPE
700121030011	700121030041	8 PMED
700121030011	700121030061	8 PMED
700121030011	700121030081	8 PMED
700251030011	700251030161	1 MVIS
700251030011	700251030171	1 MVIS
700251030011	700251030181	1 MVIS
700251030011	700251030191	8 PMED
700251030011	700251030211	8 PMED
700251030011	700251030271	8 PMED
700251030011	700251030311	8 PMED
700271040031	700271040081	8 PMED
700271050061	700271050131	1 MVIS
700271050061	700271050151	8 PMED
700351020091	700351020421	1 MVIS
700351020091	700351020481	8 PMED
700351020091	700351020571	1 MVIS
700351020091	700351020601	8 PMED
700351020091	700351020611	8 PMED
700351020091	700351020651	8 PMED
700351020091	700351020671	8 PMED
700481010071	700481010271	1 MVIS
700481010071	700481010291	1 MVIS
700481010071	700481010311	8 PMED
700481010071	700481010371	8 PMED
700481010071	700481010441	8 PMED
700481010071	700481010521	8 PMED
700701040051	700701040121	3 EROM
700701040051	700701040131	8 PMED
700991010041	700991010201	8 PMED
700991010041	700991010261	8 PMED
701131060041	701131060711	1 MVIS
701131060041	701131060761	8 PMED
701131060041	701131060771	8 PMED
701461010041	701461010071	8 PMED
701461010041	701461010081	8 PMED
701461010041	701461010091	8 PMED
701461010041	701461010101	8 PMED
701461010041	701461010111	8 PMED
701461010041	701461010121	8 PMED
701461010041	701461010131	8 PMED
701461010041	701461010141	8 PMED
701461010041	701461010151	8 PMED
701641030011	701641030091	1 MVIS
701641030011	701641030101	8 PMED
701981010011	701981010061	1 MVIS
701981010011	701981010081	8 PMED
701981010011	701981010121	8 PMED
702051030011	702051030081	8 PMED
702151010051	702151010121	1 MVIS
702151010051	702151010131	1 MVIS
702151010051	702151010141	1 MVIS
702151010051	702151010151	8 PMED
702291010041	702291010191	8 PMED
702421050011	702421050181	8 PMED
702421050011	702421050191	8 PMED
702421050011	702421050201	8 PMED
702421050011	702421050211	8 PMED
702441010071	702441010891	8 PMED
702441010071	702441010981	1 MVIS
702441010071	702441011001	1 MVIS
702441010071	702441011131	8 PMED
702441010181	702441010831	8 PMED
702441010181	702441010901	8 PMED
702441010181	702441010991	1 MVIS
702441010181	702441011051	8 PMED
702441010181	702441011171	8 PMED
702751020041	702751020331	8 PMED
702751020041	702751020371	1 MVIS
702751020041	702751020431	8 PMED
702751020041	702751020501	8 PMED
702761010011	702761010071	8 PMED
702761010011	702761010081	8 PMED
702761010011	702761010101	8 PMED
702761010011	702761010111	8 PMED
702761010011	702761010121	8 PMED

Return to Top

HC-118I. Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	700121030011	700121030041	8 PMED
2	700121030011	700121030061	8 PMED
3	700121030011	700121030081	8 PMED
4	700251030011	700251030161	1 MVIS
5	700251030011	700251030171	1 MVIS
6	700251030011	700251030181	1 MVIS
7	700251030011	700251030191	8 PMED
8	700251030011	700251030211	8 PMED
9	700251030011	700251030271	8 PMED
10	700251030011	700251030311	8 PMED
11	700271040031	700271040081	8 PMED
12	700271050061	700271050131	1 MVIS
13	700271050061	700271050151	8 PMED
14	700351020091	700351020421	1 MVIS
15	700351020091	700351020481	8 PMED
16	700351020091	700351020571	1 MVIS
17	700351020091	700351020601	8 PMED
18	700351020091	700351020611	8 PMED
19	700351020091	700351020651	8 PMED
20	700351020091	700351020671	8 PMED
21	700481010071	700481010271	1 MVIS
22	700481010071	700481010291	1 MVIS
23	700481010071	700481010311	8 PMED
24	700481010071	700481010371	8 PMED
25	700481010071	700481010441	8 PMED
26	700481010071	700481010521	8 PMED
27	700701040051	700701040121	3 EROM
28	700701040051	700701040131	8 PMED
29	700991010041	700991010201	8 PMED
30	700991010041	700991010261	8 PMED
31	701131060041	701131060711	1 MVIS
32	701131060041	701131060761	8 PMED
33	701131060041	701131060771	8 PMED
34	701461010041	701461010071	8 PMED
35	701461010041	701461010081	8 PMED
36	701461010041	701461010091	8 PMED
37	701461010041	701461010101	8 PMED
38	701461010041	701461010111	8 PMED
39	701461010041	701461010121	8 PMED
40	701461010041	701461010131	8 PMED
41	701461010041	701461010141	8 PMED
42	701461010041	701461010151	8 PMED
43	701641030011	701641030091	1 MVIS
44	701641030011	701641030101	8 PMED
45	701981010011	701981010061	1 MVIS
46	701981010011	701981010081	8 PMED
47	701981010011	701981010121	8 PMED
48	702051030011	702051030081	8 PMED
49	702151010051	702151010121	1 MVIS
50	702151010051	702151010131	1 MVIS

Return to Top

HC-118I. Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks

Obs	EVNTIDX	EVENTYPE
1	700121030041	8 PMED
2	700121030061	8 PMED
3	700121030081	8 PMED
4	700251030161	1 MVIS
5	700251030171	1 MVIS
6	700251030181	1 MVIS
7	700251030191	8 PMED
8	700251030211	8 PMED
9	700251030271	8 PMED
10	700251030311	8 PMED
11	700271040081	8 PMED
12	700271050131	1 MVIS
13	700271050151	8 PMED
14	700351020421	1 MVIS
15	700351020481	8 PMED
16	700351020571	1 MVIS
17	700351020601	8 PMED
18	700351020611	8 PMED
19	700351020651	8 PMED
20	700351020671	8 PMED
21	700481010271	1 MVIS
22	700481010291	1 MVIS
23	700481010311	8 PMED
24	700481010371	8 PMED
25	700481010441	8 PMED
26	700481010521	8 PMED
27	700701040121	3 EROM
28	700701040131	8 PMED
29	700991010201	8 PMED
30	700991010261	8 PMED
31	701131060711	1 MVIS
32	701131060761	8 PMED
33	701131060771	8 PMED
34	701461010071	8 PMED
35	701461010081	8 PMED
36	701461010091	8 PMED
37	701461010101	8 PMED
38	701461010111	8 PMED
39	701461010121	8 PMED
40	701461010131	8 PMED
41	701461010141	8 PMED
42	701461010151	8 PMED
43	701641030091	1 MVIS
44	701641030101	8 PMED
45	701981010061	1 MVIS
46	701981010081	8 PMED
47	701981010121	8 PMED
48	702051030081	8 PMED
49	702151010121	1 MVIS
50	702151010131	1 MVIS

Return to Top

HC-118I. Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-118A) records which link to condition records coded as asthma

LINKIDX	RXRECIDX	RXNAME	RXXP08X	PERWT08F
700121030041	700121030041001	ADVAIR DISKUS 100/50	148.71	4062.46
700121030061	700121030061001	ADVAIR DISKUS 100/50	148.71	4062.46
700121030081	700121030081001	ADVAIR DISKUS 100/50	155.22	4062.46
700121030081	700121030081002	ADVAIR DISKUS 100/50	155.22	4062.46
700121030081	700121030081003	ADVAIR DISKUS 100/50	155.22	4062.46
700251030191	700251030191001	XOPENEX (PF)	84.87	3160.81
700251030211	700251030211001	FLOVENT DISKUS	120.85	3160.81
700251030271	700251030271001	XOPENEX (PF)	157.14	3160.81
700251030271	700251030271002	XOPENEX (PF)	157.14	3160.81
700251030271	700251030271003	XOPENEX (PF)	157.14	3160.81
700251030311	700251030311001	ALBUTEROL	20.99	3160.81
700251030311	700251030311002	ALBUTEROL	20.99	3160.81
700271040081	700271040081001	PROVERA	32.36	1048.23
700271050151	700271050151001	XOPENEX HFA (200 ACTUATIONS)	52.63	1840.44
700351020481	700351020481001	TEMAZEPAM	5.57	9219.77
700351020481	700351020481002	TEMAZEPAM	5.57	9219.77
700351020481	700351020481003	TEMAZEPAM	5.57	9219.77
700351020481	700351020481004	TEMAZEPAM	5.57	9219.77
700351020481	700351020481005	TEMAZEPAM	5.57	9219.77
700351020601	700351020601001	SYMBICORT	170.29	9219.77
700351020601	700351020601002	SYMBICORT	170.29	9219.77
700351020611	700351020611001	SPIRIVA (W/ HANDIHALER)	147.06	9219.77
700351020611	700351020611002	SPIRIVA (W/ HANDIHALER)	147.06	9219.77
700351020611	700351020611003	SPIRIVA (W/ HANDIHALER)	147.06	9219.77
700351020611	700351020611004	SPIRIVA (W/ HANDIHALER)	147.06	9219.77
700351020651	700351020651001	ALBUTEROL	34.85	9219.77
700351020651	700351020651002	ALBUTEROL	34.85	9219.77
700351020651	700351020651003	ALBUTEROL	34.85	9219.77
700351020651	700351020651004	ALBUTEROL	34.85	9219.77
700351020671	700351020671001	SPIRIVA (W/ HANDIHALER)	147.06	9219.77
700351020671	700351020671002	SPIRIVA (W/ HANDIHALER)	147.06	9219.77
700481010311	700481010311001	PROVENTIL HFA (M.D.I.)	113.33	9913.13
700481010311	700481010311002	PROVENTIL HFA (M.D.I.)	113.33	9913.13
700481010371	700481010371001	FLOVENT HFA (WITH DOSE COUNTER)	243.38	9913.13
700481010371	700481010371002	FLOVENT HFA (WITH DOSE COUNTER)	243.38	9913.13
700481010441	700481010441001	PROVENTIL HFA (M.D.I.)	113.33	9913.13
700481010441	700481010441002	PROVENTIL HFA (M.D.I.)	113.33	9913.13
700481010521	700481010521001	FLOVENT HFA (WITH DOSE COUNTER)	243.38	9913.13
700481010521	700481010521002	FLOVENT HFA (WITH DOSE COUNTER)	243.38	9913.13
700701040131	700701040131001	APAP	2.85	3794.45
700991010201	700991010201001	COMBIVENT	190.22	13330.21
700991010201	700991010201002	COMBIVENT	190.22	13330.21
700991010201	700991010201003	COMBIVENT	190.22	13330.21
700991010201	700991010201004	COMBIVENT	190.22	13330.21
700991010201	700991010201005	COMBIVENT	190.22	13330.21
700991010261	700991010261001	COMBIVENT	207.17	13330.21
700991010261	700991010261002	COMBIVENT	206.31	13330.21
700991010261	700991010261003	COMBIVENT	206.92	13330.21
700991010261	700991010261004	COMBIVENT	206.92	13330.21
700991010261	700991010261005	COMBIVENT	206.92	13330.21
701131060761	701131060761001	ALBUTEROL	51.56	13503.65
701131060761	701131060761002	ALBUTEROL	50.22	13503.65
701131060761	701131060761003	ALBUTEROL	50.22	13503.65
701131060771	701131060771001	FLOVENT HFA	181.78	13503.65
701131060771	701131060771002	FLOVENT HFA	181.78	13503.65
701131060771	701131060771003	FLOVENT HFA	181.78	13503.65
701131060771	701131060771004	FLOVENT HFA	184.88	13503.65
701131060771	701131060771005	FLOVENT HFA	181.78	13503.65
701461010071	701461010071001	ALBUTEROL	19.46	7744.44
701461010071	701461010071002	ALBUTEROL	19.46	7744.44
701461010071	701461010071003	ALBUTEROL	19.46	7744.44
701461010081	701461010081001	SINGULAIR (UNIT OF USE)	36.44	7744.44
701461010081	701461010081002	SINGULAIR	30.00	7744.44
701461010081	701461010081003	SINGULAIR	30.00	7744.44
701461010091	701461010091001	DUONEB (VIAL,U.D.)	38.03	7744.44
701461010091	701461010091002	DUONEB (VIAL,U.D.)	38.03	7744.44
701461010091	701461010091003	DUONEB (VIAL,U.D.)	38.03	7744.44
701461010101	701461010101001	ALBUTEROL	19.46	7744.44
701461010101	701461010101002	ALBUTEROL	19.46	7744.44
701461010101	701461010101003	ALBUTEROL	19.46	7744.44
701461010101	701461010101004	ALBUTEROL	19.46	7744.44
701461010101	701461010101005	ALBUTEROL	19.46	7744.44
701461010101	701461010101006	ALBUTEROL	19.46	7744.44
701461010111	701461010111001	SINGULAIR (UNIT OF USE)	36.44	7744.44
701461010111	701461010111002	SINGULAIR (UNIT OF USE)	36.44	7744.44
701461010111	701461010111003	SINGULAIR (UNIT OF USE)	36.44	7744.44
701461010111	701461010111004	SINGULAIR	30.00	7744.44
701461010111	701461010111005	SINGULAIR	30.00	7744.44
701461010111	701461010111006	SINGULAIR	30.00	7744.44
701461010121	701461010121001	DUONEB (VIAL,U.D.)	38.03	7744.44
701461010121	701461010121002	DUONEB (VIAL,U.D.)	38.03	7744.44
701461010121	701461010121003	DUONEB (VIAL,U.D.)	38.03	7744.44
701461010121	701461010121004	DUONEB (VIAL,U.D.)	38.03	7744.44
701461010121	701461010121005	DUONEB (VIAL,U.D.)	38.03	7744.44
701461010121	701461010121006	DUONEB (VIAL,U.D.)	38.03	7744.44
701461010131	701461010131001	ALBUTEROL	22.02	7744.44
701461010131	701461010131002	ALBUTEROL	22.02	7744.44
701461010141	701461010141001	SINGULAIR (UNIT OF USE)	36.44	7744.44
701461010141	701461010141002	SINGULAIR	30.00	7744.44
701461010151	701461010151001	DUONEB (VIAL,U.D.)	38.03	7744.44
701461010151	701461010151002	DUONEB (VIAL,U.D.)	38.03	7744.44
701981010081	701981010081001	PROAIR HFA	32.34	9361.57
701981010121	701981010121001	PROAIR HFA	32.34	9361.57
702051030081	702051030081001	ALBUTEROL SULFATE (PF)	11.08	4810.46
702151010151	702151010151001	SYMBICORT	189.80	10837.01
702151010151	702151010151002	SYMBICORT	189.80	10837.01
702291010191	702291010191001	ADVAIR DISKUS 250/50	186.45	5300.32
702421050181	702421050181001	ALBUTEROL	22.99	4630.20
702421050181	702421050181002	ALBUTEROL	22.99	4630.20
702421050181	702421050181003	ALBUTEROL	22.99	4630.20
702421050181	702421050181004	ALBUTEROL	22.99	4630.20
702421050191	702421050191001	TESSALON PERLES	28.88	4630.20
702421050191	702421050191002	TESSALON PERLES	28.88	4630.20
702421050191	702421050191003	TESSALON PERLES	28.88	4630.20
702421050201	702421050201001	ALBUTEROL	22.99	4630.20
702421050201	702421050201002	ALBUTEROL	22.99	4630.20
702421050201	702421050201003	ALBUTEROL	22.99	4630.20
702421050211	702421050211001	FLOVENT HFA (WITH DOSE COUNTER)	113.09	4630.20
702421050211	702421050211002	FLOVENT HFA (WITH DOSE COUNTER)	113.09	4630.20
702421050211	702421050211003	FLOVENT HFA (WITH DOSE COUNTER)	113.09	4630.20
702441010831	702441010831001	PREDNISONE	2.81	14716.20
702441010831	702441010831002	PREDNISONE	2.81	14716.20
702441010891	702441010891001	ADVAIR DISKUS 250/50	190.96	14716.20
702441010891	702441010891002	ADVAIR DISKUS 250/50	190.96	14716.20
702441010901	702441010901001	ALBUTEROL SULFATE (PF)	15.00	14716.20
702441011051	702441011051001	PREDNISONE	2.12	14716.20
702441011131	702441011131001	ADVAIR DISKUS 250/50	190.96	14716.20
702441011131	702441011131002	ADVAIR DISKUS 250/50	190.96	14716.20
702441011171	702441011171001	TUSSIONEX PENNKINETIC	126.52	14716.20
702751020331	702751020331001	ALBUTEROL	19.28	9972.49
702751020331	702751020331002	ALBUTEROL	22.02	9972.49
702751020431	702751020431001	ALBUTEROL	19.28	9972.49
702751020501	702751020501001	ALBUTEROL	19.28	9972.49
702751020501	702751020501002	ALBUTEROL	22.02	9972.49
702761010071	702761010071001	ADVAIR DISKUS 500/50	150.00	17419.15
702761010081	702761010081001	SINGULAIR (UNIT OF USE)	104.51	17419.15
702761010101	702761010101001	ADVAIR DISKUS 500/50	264.93	17419.15
702761010101	702761010101002	ADVAIR DISKUS 500/50	264.93	17419.15
702761010111	702761010111001	PREDNISONE	10.00	17419.15
702761010121	702761010121001	ZYRTEC	25.00	17419.15
702761010121	702761010121002	ZYRTEC	71.93	17419.15
702761010131	702761010131001	SINGULAIR	326.81	17419.15
702761010131	702761010131002	SINGULAIR	326.81	17419.15
702831011061	702831011061001	ADVAIR HFA	251.36	9248.17
702831011061	702831011061002	ADVAIR HFA	251.36	9248.17
702831011061	702831011061003	ADVAIR HFA	264.93	9248.17
702831011061	702831011061004	ADVAIR HFA	264.93	9248.17
702831011061	702831011061005	ADVAIR HFA	264.93	9248.17
702831011081	702831011081001	ALBUTEROL	19.46	9248.17
702831011081	702831011081002	ALBUTEROL	19.46	9248.17
702831011081	702831011081003	ALBUTEROL	19.46	9248.17
702901010251	702901010251001	ALBUTEROL	26.65	2565.23
702901010251	702901010251002	ALBUTEROL	26.65	2565.23
702901010251	702901010251003	ALBUTEROL	26.65	2565.23
702901010251	702901010251004	ALBUTEROL	26.65	2565.23
702901010251	702901010251005	ALBUTEROL	26.65	2565.23
702901010261	702901010261001	ADVAIR DISKUS 500/50	254.33	2565.23
702901010261	702901010261002	ADVAIR DISKUS 500/50	254.33	2565.23
702901010261	702901010261003	ADVAIR DISKUS 500/50	254.33	2565.23
702901010261	702901010261004	ADVAIR DISKUS 500/50	254.33	2565.23
702901010261	702901010261005	ADVAIR DISKUS 500/50	268.06	2565.23
702901010271	702901010271001	SPIRIVA (W/ HANDIHALER)	149.04	2565.23
703041010501	703041010501001	SINGULAIR (UNIT OF USE)	326.81	11530.29
703041010501	703041010501002	SINGULAIR (UNIT OF USE)	326.81	11530.29
703041010511	703041010511001	SEREVENT DISKUS	311.95	11530.29
703041010511	703041010511002	SEREVENT DISKUS	311.95	11530.29
703041010601	703041010601001	SINGULAIR (UNIT OF USE)	326.81	11530.29
703121010321	703121010321001	ALBUTEROL SULFATE (PF)	43.94	2675.14
703121010321	703121010321002	ALBUTEROL SULFATE (PF)	43.94	2675.14
703121010321	703121010321003	ALBUTEROL SULFATE (PF)	43.94	2675.14
703121010321	703121010321004	ALBUTEROL SULFATE (PF)	43.94	2675.14
703121010321	703121010321005	ALBUTEROL SULFATE (PF)	43.94	2675.14
703121010331	703121010331001	IPRATROPIUM BROMIDE (PF)	521.53	2675.14
703121010331	703121010331002	IPRATROPIUM BROMIDE (PF)	521.53	2675.14
703121010331	703121010331003	IPRATROPIUM BROMIDE (PF)	521.53	2675.14
703121010331	703121010331004	IPRATROPIUM BROMIDE (PF)	521.53	2675.14
703121010331	703121010331005	IPRATROPIUM BROMIDE (PF)	521.53	2675.14
703121010451	703121010451001	ALBUTEROL SULFATE (PF)	40.00	2675.14
703121010451	703121010451002	ALBUTEROL SULFATE (PF)	40.00	2675.14
703121010451	703121010451003	ALBUTEROL SULFATE (PF)	40.00	2675.14
703121010451	703121010451004	ALBUTEROL SULFATE (PF)	40.00	2675.14
703141010471	703141010471001	PROAIR HFA	96.24	19159.04
703261010261	703261010261001	ADVAIR DISKUS 100/50	149.34	3783.89
703261010361	703261010361001	ADVAIR DISKUS 100/50	149.34	3783.89
703261010361	703261010361002	ADVAIR DISKUS 100/50	149.34	3783.89
703261010361	703261010361003	ADVAIR DISKUS 100/50	149.34	3783.89
703261010361	703261010361004	ADVAIR DISKUS 100/50	149.34	3783.89
703261010361	703261010361005	ADVAIR DISKUS 100/50	149.34	3783.89
703261010361	703261010361006	ADVAIR DISKUS 100/50	155.89	3783.89
703261010361	703261010361007	ADVAIR DISKUS 100/50	155.89	3783.89
703261010451	703261010451001	ADVAIR DISKUS 100/50	155.89	3783.89
703261010451	703261010451002	ADVAIR DISKUS 100/50	155.89	3783.89
703261010451	703261010451003	ADVAIR DISKUS 100/50	155.89	3783.89
703341030141	703341030141001	SINGULAIR	107.82	4891.94
703341030141	703341030141002	SINGULAIR	107.82	4891.94
703341030141	703341030141003	SINGULAIR	107.82	4891.94
703341030141	703341030141004	SINGULAIR	107.82	4891.94
703341030141	703341030141005	SINGULAIR	107.82	4891.94
703341030141	703341030141006	SINGULAIR	107.82	4891.94
703341030151	703341030151001	ALBUTEROL SULFATE	11.48	4891.94
703341030151	703341030151002	ALBUTEROL SULFATE	11.48	4891.94
703341030151	703341030151003	ALBUTEROL SULFATE	11.48	4891.94
703341030151	703341030151004	ALBUTEROL SULFATE	11.48	4891.94
703341030151	703341030151005	ALBUTEROL SULFATE	11.48	4891.94
703341030151	703341030151006	ALBUTEROL SULFATE	11.48	4891.94
703341030161	703341030161001	PULMICORT RESPULES (5X6)	373.22	4891.94
703341030161	703341030161002	PULMICORT RESPULES (5X6)	373.22	4891.94
703341030161	703341030161003	PULMICORT RESPULES (5X6)	373.22	4891.94
703341030161	703341030161004	PULMICORT RESPULES (5X6)	373.22	4891.94
703341030161	703341030161005	PULMICORT RESPULES (5X6)	373.22	4891.94
703341030161	703341030161006	PULMICORT RESPULES (5X6)	373.22	4891.94
703341040101	703341040101001	SINGULAIR (UNIT OF USE)	102.38	6236.38
703341040101	703341040101002	SINGULAIR (UNIT OF USE)	102.38	6236.38
703341040101	703341040101003	SINGULAIR (UNIT OF USE)	102.38	6236.38
703341040101	703341040101004	SINGULAIR (UNIT OF USE)	102.38	6236.38
703341040101	703341040101005	SINGULAIR (UNIT OF USE)	102.38	6236.38
703341040101	703341040101006	SINGULAIR (UNIT OF USE)	102.38	6236.38
703341040111	703341040111001	PULMICORT RESPULES (5X6)	373.22	6236.38
703341040111	703341040111002	PULMICORT RESPULES (5X6)	373.22	6236.38
703341040111	703341040111003	PULMICORT RESPULES (5X6)	373.22	6236.38
703341040111	703341040111004	PULMICORT RESPULES (5X6)	373.22	6236.38
703341040111	703341040111005	PULMICORT RESPULES (5X6)	373.22	6236.38
703341040111	703341040111006	PULMICORT RESPULES (5X6)	373.22	6236.38
703341040121	703341040121001	ALBUTEROL SULFATE	18.99	6236.38
703341040121	703341040121002	ALBUTEROL SULFATE	18.99	6236.38
703341040121	703341040121003	ALBUTEROL SULFATE	18.99	6236.38
703341040121	703341040121004	ALBUTEROL SULFATE	18.99	6236.38
703341040121	703341040121005	ALBUTEROL SULFATE	18.99	6236.38
703341040121	703341040121006	ALBUTEROL SULFATE	18.99	6236.38
703561020021	703561020021001	PROAIR HFA	20.00	3379.73
703561020031	703561020031001	SYMBICORT	167.04	3379.73
703601010171	703601010171001	SPIRIVA (W/HANDIHALER)	146.81	10819.95
703601010191	703601010191001	ALBUTEROL	26.99	10819.95
703601010231	703601010231001	ALBUTEROL	22.02	10819.95
703651030201	703651030201001	ALBUTEROL SULFATE HFA	29.54	10572.43
703651030251	703651030251001	ALBUTEROL SULFATE HFA	29.54	10572.43
703651030251	703651030251002	ALBUTEROL SULFATE HFA	29.54	10572.43
703651030261	703651030261001	PREDNISONE	5.74	10572.43
703651030261	703651030261002	PREDNISONE	5.74	10572.43
703651030331	703651030331001	SINGULAIR (UNIT OF USE)	111.53	10572.43
703651030331	703651030331002	SINGULAIR (UNIT OF USE)	111.53	10572.43
703651030331	703651030331003	SINGULAIR (UNIT OF USE)	111.53	10572.43
703651030331	703651030331004	SINGULAIR (UNIT OF USE)	111.53	10572.43
703651030331	703651030331005	SINGULAIR (UNIT OF USE)	111.53	10572.43
703821030052	703821030052001	SINGULAIR (UNIT OF USE)	103.85	6538.26
703821030092	703821030092001	SINGULAIR (UNIT OF USE)	103.85	6538.26
703821030092	703821030092002	SINGULAIR (UNIT OF USE)	103.85	6538.26
703821030092	703821030092003	SINGULAIR (UNIT OF USE)	103.85	6538.26
703821030092	703821030092004	SINGULAIR (UNIT OF USE)	103.85	6538.26
703821030092	703821030092005	SINGULAIR (UNIT OF USE)	103.85	6538.26
703821030092	703821030092006	SINGULAIR (UNIT OF USE)	103.85	6538.26
703821030102	703821030102001	PROAIR HFA	38.50	6538.26
703821030102	703821030102002	PROAIR HFA	38.50	6538.26
703881010231	703881010231001	ADVAIR DISKUS 100/50	155.95	8001.77
703881010231	703881010231002	ADVAIR DISKUS 100/50	155.95	8001.77
703881010231	703881010231003	ADVAIR DISKUS 100/50	155.95	8001.77
704101010421	704101010421001	IPRATROPIUM BROMIDE (WITH METERED SPRAY PUMP)	20.75	7324.60
704281010831	704281010831001	PROAIR HFA	34.45	15545.99
704281010831	704281010831002	PROAIR HFA	39.22	15545.99
704281010831	704281010831003	PROAIR HFA	39.22	15545.99
704281020411	704281020411001	ALBUTEROL	19.18	12968.13
704281020421	704281020421001	FLOVENT HFA	112.25	12968.13
704311050131	704311050131001	ALBUTEROL	19.46	7093.50
704311050141	704311050141001	PULMICORT RESPULES (5X6)	178.74	7093.50
704641040051	704641040051001	ALBUTEROL SULFATE	10.99	5978.43
704641040051	704641040051002	ALBUTEROL SULFATE	10.99	5978.43
704781020201	704781020201001	FLOVENT HFA	115.26	15276.22
704781020211	704781020211001	SINGULAIR (UNIT OF USE)	106.53	15276.22
704781020341	704781020341001	FLOVENT HFA	365.06	15276.22
704781020481	704781020481001	ALBUTEROL	25.86	15276.22
704781020491	704781020491001	PULMICORT FLEXHALER	123.27	15276.22
704921020251	704921020251001	SODIUM CHLORIDE	19.95	25608.94
704961020371	704961020371001	ADVAIR DISKUS 100/50	157.24	2200.26
704961020501	704961020501001	ADVAIR DISKUS 100/50	157.24	2200.26
704961020611	704961020611001	PROAIR HFA	30.00	2200.26
704961020611	704961020611002	PROAIR HFA	30.00	2200.26
704961020611	704961020611003	PROAIR HFA	30.00	2200.26
704961020611	704961020611004	PROAIR HFA	30.00	2200.26
704961020621	704961020621001	SPIRIVA (W/ HANDIHALER)	150.82	2200.26
705121020431	705121020431001	FLOVENT HFA (WITH DOSE COUNTER)	85.64	10239.60
705121020441	705121020441001	PROAIR HFA	32.08	10239.60
705551030051	705551030051001	AEROCHAMBER	37.29	5229.16
705671010311	705671010311001	SINGULAIR	30.00	3682.77
705671010321	705671010321001	ADVAIR DISKUS 250/50	381.92	3682.77
705671010381	705671010381001	PREDNISONE	2.95	3682.77
705671010441	705671010441001	ACCOLATE	271.15	3682.77
705671010451	705671010451001	ADVAIR DISKUS 100/50	471.73	3682.77
705711010351	705711010351001	ALBUTEROL	27.15	5454.32
705751020311	705751020311001	IPRATROPIUM BROMIDE (VIAL,PF)	31.50	7097.32
705751020311	705751020311002	IPRATROPIUM BROMIDE (VIAL,PF)	31.50	7097.32
705751020461	705751020461001	ALBUTEROL SULFATE (VIAL)	23.85	7097.32
705751020461	705751020461002	ALBUTEROL SULFATE (VIAL)	11.93	7097.32
705751020481	705751020481001	ADVAIR DISKUS 500/50	250.83	7097.32
705751020481	705751020481002	ADVAIR DISKUS 500/50	250.83	7097.32
705751020481	705751020481003	ADVAIR DISKUS 500/50	752.50	7097.32
705841012181	705841012181001	PREDNISONE	10.00	9597.15
705841012181	705841012181002	PREDNISONE	10.00	9597.15
705841012241	705841012241001	SINGULAIR (UNIT OF USE)	104.97	9597.15
705841012241	705841012241002	SINGULAIR (UNIT OF USE)	104.97	9597.15
705841012241	705841012241003	SINGULAIR (UNIT OF USE)	104.97	9597.15
705841012241	705841012241004	SINGULAIR (UNIT OF USE)	104.97	9597.15
705841012241	705841012241005	SINGULAIR (UNIT OF USE)	104.97	9597.15
705841012241	705841012241006	SINGULAIR (UNIT OF USE)	104.97	9597.15
706111020641	706111020641001	ADVAIR DISKUS 250/50	190.96	6402.33
706111020641	706111020641002	ADVAIR DISKUS 250/50	190.96	6402.33
706111020641	706111020641003	ADVAIR DISKUS 250/50	190.96	6402.33
706111020641	706111020641004	ADVAIR DISKUS 250/50	190.96	6402.33
706111020641	706111020641005	ADVAIR DISKUS 250/50	190.96	6402.33
706141010841	706141010841001	SPIRIVA	463.67	9565.65
706141010841	706141010841002	SPIRIVA	463.67	9565.65

Return to Top

HC-118I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Analysis Variable : RXXP08X SUM OF PAYMENTS RXSF08X-RXOU08X(IMPUTED)

N	Sum
9502	973811.50

Return to Top

HC-118I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
Analysis Variable : RXXP08X SUM OF PAYMENTS RXSF08X-RXOU08X(IMPUTED)

N	Sum
9502	10805849221

Return to Top

NOTE: SAS initialization used:
real time 0.64 seconds
cpu time 0.42 seconds

NOTE: AUTOEXEC processing beginning; file is C:\Program Files\SAS92\SASFoundation\9.2\autoexec.sas.

NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

I:\SASTRACE\TRACE92\

NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.01 seconds

NOTE: AUTOEXEC processing completed.

1 ods rtf file = 'c:\sampleC.rtf' bodytitle;
NOTE: Writing RTF Body file: c:\sampleC.rtf
2
3 ods noproctitle;
4
5 OPTIONS LS=132 PS=59;
6
7 TITLE1 "HC-118I";
8 TITLE2 "Sample SAS Job for Example C";
9
10 LIBNAME IN "C:\Data";
NOTE: Libref IN was successfully assigned as follows:
Engine: V9
Physical Name: C:\Data
11
12 *************************************************************************************
13 * Calculate the expenditures for medical visits associated with asthma.
14 *************************************************************************************;
15 PROC FORMAT;
16 VALUE EVENTYPE
17 1 = "1 MVIS"
18 2 = "2 OPAT"
19 3 = "3 EROM"
20 4 = "4 STAZ"
21 5 = "5 DVIS"
22 6 = "6 OMED"
23 7 = "7 HVIS"
24 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
25 RUN;

NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.07 seconds
cpu time 0.01 seconds

26
27 *-----------------------------------------------------------------------------------
28 * Get conditions records coded as asthma.
29 *-----------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H120 (KEEP=CONDIDX CCCODEX);
32 IF CCCODEX="128";
33 RUN;

34
35 *------------------------------------------------------------------------------------
36 * Get the events linked to each of the asthma condition records.
37 *------------------------------------------------------------------------------------;
38 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;

39
40 proc print data=asconds (obs=50);
41 title3 "sample print of work.asconds - sorted by condidx";
42 title4 "COND (H120) records where cccodex=128";
43 run;

NOTE: There were 50 observations read from the data set WORK.ASCONDS.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds

44
45 PROC SORT DATA=IN.H118IF1 OUT=CLNK; BY CONDIDX; RUN;

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 75 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.62 seconds
cpu time 0.00 seconds

61
62 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;

63
64 proc print data=asclnks (obs=50);
65 format eventype eventype.;
66 title3 "sample print of work.asclnks - sorted by evntidx";
67 run;

NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds

68
69 DATA ASCLNKS;
70 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
71 BY EVNTIDX;
72 IF FIRST.EVNTIDX;
73 RUN;

74
75 proc print data=asclnks (obs=50);
76 format eventype eventype.;
77 title3 "sample print of unique evntidxs from work.asclnks";
78 run;

NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds

79
80 *--------------------------------------------------------------------------------------------
81 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
82 *--------------------------------------------------------------------------------------------;
83 DATA MVIS;
84 SET IN.H118G (KEEP=EVNTIDX PERWT08F SEETLKPV OBXP08X);
85 IF PERWT08F > 0 & SEETLKPV NE 2;
86 RUN;

NOTE: There were 136460 observations read from the data set IN.H118G.
NOTE: The data set WORK.MVIS has 132104 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.09 seconds

87
88 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;

NOTE: There were 132104 observations read from the data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 132104 observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.07 seconds
cpu time 0.14 seconds

89
90 *-------------------------------------------------------------------------------------
91 * Identify MVIS events which were for asthma.
92 *-------------------------------------------------------------------------------------;
93 DATA ASMVIS;
94 MERGE ASCLNKS (IN=INASCLNK)
95 MVIS (IN=INMVIS);
96 BY EVNTIDX;
97 IF INASCLNK & INMVIS;
98 RUN;

NOTE: There were 6543 observations read from the data set WORK.ASCLNKS.
NOTE: There were 132104 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1842 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.15 seconds
cpu time 0.03 seconds

99
100 proc print data=asmvis (obs=50);
101 format eventype eventype.;
102 title3 "sample print of work.asmvis";
103 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-118G) events";
104 run;

NOTE: There were 50 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.56 seconds
cpu time 0.01 seconds

105
106 PROC MEANS DATA=ASMVIS N SUM;
107 VAR OBXP08X;
108 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
109 RUN;

NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 1842 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 7.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.14 seconds
cpu time 0.00 seconds

110
111 PROC MEANS DATA=ASMVIS N SUM;
112 VAR OBXP08X;
113 WEIGHT PERWT08F;
114 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
115 TITLE5 "Weighted";
116 RUN;

NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 1842 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 8.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.09 seconds
cpu time 0.01 seconds

117
118 ods rtf close;
119
120

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 5.93 seconds
cpu time 1.48 seconds

Return to Top

HC-118I. Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx

Obs	CONDIDX	CCCODEX
1	700121030011	128
2	700251010031	128
3	700251030011	128
4	700271030011	128
5	700271040031	128
6	700271050061	128
7	700351020091	128
8	700481010071	128
9	700701040051	128
10	700991010041	128
11	701131060041	128
12	701461010041	128
13	701641030011	128
14	701971030021	128
15	701981010011	128
16	702051030011	128
17	702151010051	128
18	702291010041	128
19	702421050011	128
20	702441010071	128
21	702441010181	128
22	702731030022	128
23	702751020041	128
24	702761010011	128
25	702831010061	128
26	702851010021	128
27	702901010041	128
28	702901010061	128
29	702981040031	128
30	703041010021	128
31	703121010051	128
32	703141010031	128
33	703261010041	128
34	703341030011	128
35	703341040011	128
36	703461030011	128
37	703561020021	128
38	703601010051	128
39	703601030023	128
40	703651030011	128
41	703741010041	128
42	703821030011	128
43	703881010031	128
44	703951010021	128
45	704101010051	128
46	704171010061	128
47	704281010051	128
48	704281020011	128
49	704311050011	128
50	704641040011	128

Return to Top

HC-118I. Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records

CONDIDX	EVNTIDX	EVENTYPE
700121030011	700121030041	8 PMED
700121030011	700121030061	8 PMED
700121030011	700121030081	8 PMED
700251030011	700251030161	1 MVIS
700251030011	700251030171	1 MVIS
700251030011	700251030181	1 MVIS
700251030011	700251030191	8 PMED
700251030011	700251030211	8 PMED
700251030011	700251030271	8 PMED
700251030011	700251030311	8 PMED
700271040031	700271040081	8 PMED
700271050061	700271050131	1 MVIS
700271050061	700271050151	8 PMED
700351020091	700351020421	1 MVIS
700351020091	700351020481	8 PMED
700351020091	700351020571	1 MVIS
700351020091	700351020601	8 PMED
700351020091	700351020611	8 PMED
700351020091	700351020651	8 PMED
700351020091	700351020671	8 PMED
700481010071	700481010271	1 MVIS
700481010071	700481010291	1 MVIS
700481010071	700481010311	8 PMED
700481010071	700481010371	8 PMED
700481010071	700481010441	8 PMED
700481010071	700481010521	8 PMED
700701040051	700701040121	3 EROM
700701040051	700701040131	8 PMED
700991010041	700991010201	8 PMED
700991010041	700991010261	8 PMED
701131060041	701131060711	1 MVIS
701131060041	701131060761	8 PMED
701131060041	701131060771	8 PMED
701461010041	701461010071	8 PMED
701461010041	701461010081	8 PMED
701461010041	701461010091	8 PMED
701461010041	701461010101	8 PMED
701461010041	701461010111	8 PMED
701461010041	701461010121	8 PMED
701461010041	701461010131	8 PMED
701461010041	701461010141	8 PMED
701461010041	701461010151	8 PMED
701641030011	701641030091	1 MVIS
701641030011	701641030101	8 PMED
701981010011	701981010061	1 MVIS
701981010011	701981010081	8 PMED
701981010011	701981010121	8 PMED
702051030011	702051030081	8 PMED
702151010051	702151010121	1 MVIS
702151010051	702151010131	1 MVIS
702151010051	702151010141	1 MVIS
702151010051	702151010151	8 PMED
702291010041	702291010191	8 PMED
702421050011	702421050181	8 PMED
702421050011	702421050191	8 PMED
702421050011	702421050201	8 PMED
702421050011	702421050211	8 PMED
702441010071	702441010891	8 PMED
702441010071	702441010981	1 MVIS
702441010071	702441011001	1 MVIS
702441010071	702441011131	8 PMED
702441010181	702441010831	8 PMED
702441010181	702441010901	8 PMED
702441010181	702441010991	1 MVIS
702441010181	702441011051	8 PMED
702441010181	702441011171	8 PMED
702751020041	702751020331	8 PMED
702751020041	702751020371	1 MVIS
702751020041	702751020431	8 PMED
702751020041	702751020501	8 PMED
702761010011	702761010071	8 PMED
702761010011	702761010081	8 PMED
702761010011	702761010101	8 PMED
702761010011	702761010111	8 PMED
702761010011	702761010121	8 PMED

Return to Top

HC-118I. Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	700121030011	700121030041	8 PMED
2	700121030011	700121030061	8 PMED
3	700121030011	700121030081	8 PMED
4	700251030011	700251030161	1 MVIS
5	700251030011	700251030171	1 MVIS
6	700251030011	700251030181	1 MVIS
7	700251030011	700251030191	8 PMED
8	700251030011	700251030211	8 PMED
9	700251030011	700251030271	8 PMED
10	700251030011	700251030311	8 PMED
11	700271040031	700271040081	8 PMED
12	700271050061	700271050131	1 MVIS
13	700271050061	700271050151	8 PMED
14	700351020091	700351020421	1 MVIS
15	700351020091	700351020481	8 PMED
16	700351020091	700351020571	1 MVIS
17	700351020091	700351020601	8 PMED
18	700351020091	700351020611	8 PMED
19	700351020091	700351020651	8 PMED
20	700351020091	700351020671	8 PMED
21	700481010071	700481010271	1 MVIS
22	700481010071	700481010291	1 MVIS
23	700481010071	700481010311	8 PMED
24	700481010071	700481010371	8 PMED
25	700481010071	700481010441	8 PMED
26	700481010071	700481010521	8 PMED
27	700701040051	700701040121	3 EROM
28	700701040051	700701040131	8 PMED
29	700991010041	700991010201	8 PMED
30	700991010041	700991010261	8 PMED
31	701131060041	701131060711	1 MVIS
32	701131060041	701131060761	8 PMED
33	701131060041	701131060771	8 PMED
34	701461010041	701461010071	8 PMED
35	701461010041	701461010081	8 PMED
36	701461010041	701461010091	8 PMED
37	701461010041	701461010101	8 PMED
38	701461010041	701461010111	8 PMED
39	701461010041	701461010121	8 PMED
40	701461010041	701461010131	8 PMED
41	701461010041	701461010141	8 PMED
42	701461010041	701461010151	8 PMED
43	701641030011	701641030091	1 MVIS
44	701641030011	701641030101	8 PMED
45	701981010011	701981010061	1 MVIS
46	701981010011	701981010081	8 PMED
47	701981010011	701981010121	8 PMED
48	702051030011	702051030081	8 PMED
49	702151010051	702151010121	1 MVIS
50	702151010051	702151010131	1 MVIS

Return to Top

HC-118I. Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks

Obs	EVNTIDX	EVENTYPE
1	700121030041	8 PMED
2	700121030061	8 PMED
3	700121030081	8 PMED
4	700251030161	1 MVIS
5	700251030171	1 MVIS
6	700251030181	1 MVIS
7	700251030191	8 PMED
8	700251030211	8 PMED
9	700251030271	8 PMED
10	700251030311	8 PMED
11	700271040081	8 PMED
12	700271050131	1 MVIS
13	700271050151	8 PMED
14	700351020421	1 MVIS
15	700351020481	8 PMED
16	700351020571	1 MVIS
17	700351020601	8 PMED
18	700351020611	8 PMED
19	700351020651	8 PMED
20	700351020671	8 PMED
21	700481010271	1 MVIS
22	700481010291	1 MVIS
23	700481010311	8 PMED
24	700481010371	8 PMED
25	700481010441	8 PMED
26	700481010521	8 PMED
27	700701040121	3 EROM
28	700701040131	8 PMED
29	700991010201	8 PMED
30	700991010261	8 PMED
31	701131060711	1 MVIS
32	701131060761	8 PMED
33	701131060771	8 PMED
34	701461010071	8 PMED
35	701461010081	8 PMED
36	701461010091	8 PMED
37	701461010101	8 PMED
38	701461010111	8 PMED
39	701461010121	8 PMED
40	701461010131	8 PMED
41	701461010141	8 PMED
42	701461010151	8 PMED
43	701641030091	1 MVIS
44	701641030101	8 PMED
45	701981010061	1 MVIS
46	701981010081	8 PMED
47	701981010121	8 PMED
48	702051030081	8 PMED
49	702151010121	1 MVIS
50	702151010131	1 MVIS

Return to Top

HC-118I. Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-118G) events

Obs	EVNTIDX	EVENTYPE	SEETLKPV	OBXP08X	PERWT08F
1	700251030161	1 MVIS	1	121.50	3160.81
2	700251030171	1 MVIS	1	37.64	3160.81
3	700251030181	1 MVIS	1	37.64	3160.81
4	700271050131	1 MVIS	1	99.16	1840.44
5	700351020421	1 MVIS	1	76.00	9219.77
6	700351020571	1 MVIS	1	188.03	9219.77
7	700481010271	1 MVIS	1	186.89	9913.13
8	700481010291	1 MVIS	1	246.06	9913.13
9	701131060711	1 MVIS	1	50.63	13503.65
10	701981010061	1 MVIS	1	158.30	9361.57
11	702151010121	1 MVIS	1	1569.17	10837.01
12	702151010131	1 MVIS	1	178.28	10837.01
13	702151010141	1 MVIS	1	48.00	10837.01
14	702441010981	1 MVIS	1	191.00	14716.20
15	702441010991	1 MVIS	1	165.00	14716.20
16	702441011001	1 MVIS	1	242.00	14716.20
17	702751020371	1 MVIS	1	100.57	9972.49
18	702761010141	1 MVIS	1	134.40	17419.15
19	703121010201	1 MVIS	1	63.26	2675.14
20	703121010211	1 MVIS	1	63.26	2675.14
21	703121010221	1 MVIS	1	63.26	2675.14
22	703261010331	1 MVIS	1	85.68	3783.89
23	703261010341	1 MVIS	1	194.02	3783.89
24	703261010421	1 MVIS	1	1330.83	3783.89
25	703561020011	1 MVIS	1	75.00	3379.73
26	703601010211	1 MVIS	1	0.00	10819.95
27	703651030231	1 MVIS	1	124.00	10572.43
28	704281020371	1 MVIS	1	79.14	12968.13
29	704281020381	1 MVIS	1	79.14	12968.13
30	704641040031	1 MVIS	1	189.00	5978.43
31	704781020461	1 MVIS	1	64.31	15276.22
32	704781020471	1 MVIS	1	64.31	15276.22
33	704921020241	1 MVIS	1	107.55	25608.94
34	705121020401	1 MVIS	1	95.00	10239.60
35	705121020421	1 MVIS	1	163.14	10239.60
36	705551030041	1 MVIS	1	17.42	5229.16
37	705671010351	1 MVIS	1	98.00	3682.77
38	705671010361	1 MVIS	1	65.00	3682.77
39	705751020271	1 MVIS	1	215.00	7097.32
40	705841011771	1 MVIS	1	161.28	9597.15
41	705841011781	1 MVIS	1	57.00	9597.15
42	705841012341	1 MVIS	1	46.80	9597.15
43	706601010231	1 MVIS	1	88.56	9964.53
44	706601010241	1 MVIS	1	82.77	9964.53
45	706601010251	1 MVIS	1	88.56	9964.53
46	706601010261	1 MVIS	1	14.19	9964.53
47	706801010391	1 MVIS	1	53.40	8658.20
48	706801010401	1 MVIS	1	53.40	8658.20
49	706801010411	1 MVIS	1	85.60	8658.20
50	706801010421	1 MVIS	1	85.60	8658.20

Return to Top

HC-118I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Analysis Variable : OBXP08X SUM OF OBSF08X - OBOT08X (IMPUTED)

N	Sum
1842	239434.27

Return to Top

HC-118I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
Analysis Variable : OBXP08X SUM OF OBSF08X - OBOT08X (IMPUTED)

N	Sum
1842	2398721545

Return to Top

MEPS HOME . CONTACT MEPS . MEPS FAQ . MEPS SITE MAP . MEPS PRIVACY POLICY . ACCESSIBILITY . VIEWERS & PLAYERS . COPYRIGHT

Connect With Us

To sign up for updates or to access your subscriber preferences, please enter your email address below.

5600 Fishers Lane
Rockville, MD 20857
Telephone: (301) 427-1364

Connect With Us

Sign up for Email Updates

Agency for Healthcare Research and Quality