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

Font Size:

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

The SAS System

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
NOTE: This session is executing on the W32_VSPRO platform.

NOTE: SAS initialization used:
real time 1.29 seconds
cpu time 0.09 seconds

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

NOTE: AUTOEXEC processing completed.

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

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

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

NOTE: There were 102306 observations read from the data set IN.H137.
NOTE: The data set WORK.ASCONDS has 2130 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 2.65 seconds
cpu time 0.01 seconds

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

NOTE: There were 128246 observations read from the data set IN.H135G.
NOTE: The data set WORK.MVIS has 124823 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 8.50 seconds
cpu time 0.15 seconds

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

NOTE: There were 301032 observations read from the data set WORK.PMED.
NOTE: There were 1725 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 4676 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds

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

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

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

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

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

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

186
187 ods rtf close;
188

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

Return to Top

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

Obs	CONDIDX	CCCODEX
1	100121010051	128
2	100171010021	128
3	100431010021	128
4	100431030011	128
5	100431040011	128
6	100441010031	128
7	100531020041	128
8	100531040011	128
9	100661010021	128
10	100671010071	128
11	100671020041	128
12	100861020041	128
13	101311020041	128
14	101371010051	128
15	101541020041	128
16	101831050011	128
17	101841020091	128
18	101981020061	128
19	101981030051	128
20	101981040031	128
21	101981050011	128
22	102061010011	128
23	102061040011	128
24	102291020011	128
25	102361030011	128
26	102361040011	128
27	102421010041	128
28	102442010032	128
29	102451010021	128
30	102451030011	128
31	102531020011	128
32	102591050011	128
33	102601010071	128
34	102691010111	128
35	102691020091	128
36	102692030012	128
37	102781020031	128
38	102891010051	128
39	102891020021	128
40	102991060011	128
41	103051020011	128
42	103101010031	128
43	103131010111	128
44	103311010051	128
45	103331010021	128
46	103371010011	128
47	103581010041	128
48	103691010021	128
49	103851030011	128
50	103851040011	128

Return to Top

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

CONDIDX	EVNTIDX	EVENTYPE
100121010051	100121010051	8 PMED
100121010051	100121010111	8 PMED
100121010051	100121010151	8 PMED
100171010021	100171010091	8 PMED
100171010021	100171010161	8 PMED
100171010021	100171010181	1 MVIS
100431010021	100431010121	8 PMED
100431030011	100431030011	1 MVIS
100431030011	100431030021	8 PMED
100431030011	100431030031	8 PMED
100431030011	100431030051	8 PMED
100431030011	100431030071	1 MVIS
100431030011	100431030091	8 PMED
100431030011	100431030101	8 PMED
100431030011	100431030111	8 PMED
100431030011	100431030121	8 PMED
100431030011	100431030171	8 PMED
100431040011	100431040011	1 MVIS
100431040011	100431040021	1 MVIS
100431040011	100431040031	8 PMED
100431040011	100431040041	8 PMED
100431040011	100431040051	8 PMED
100431040011	100431040061	8 PMED
100431040011	100431040071	8 PMED
100431040011	100431040081	8 PMED
100431040011	100431040091	1 MVIS
100431040011	100431040101	1 MVIS
100431040011	100431040111	1 MVIS
100431040011	100431040131	8 PMED
100431040011	100431040141	8 PMED
100431040011	100431040151	8 PMED
100431040011	100431040161	8 PMED
100431040011	100431040171	1 MVIS
100431040011	100431040201	1 MVIS
100431040011	100431040211	1 MVIS
100431040011	100431040231	8 PMED
100431040011	100431040241	8 PMED
100431040011	100431040251	8 PMED
100431040011	100431040271	8 PMED
100441010031	100441010031	2 OPAT
100441010031	100441010091	8 PMED
100441010031	100441010101	8 PMED
100441010031	100441010111	8 PMED
100531020041	100531020361	8 PMED
100531040011	100531040021	8 PMED
100661010021	100661010021	8 PMED
100661010021	100661010041	8 PMED
100671010071	100671010171	8 PMED
100671010071	100671010181	8 PMED
100671010071	100671010191	8 PMED
100671010071	100671010401	8 PMED
100671010071	100671010411	8 PMED
100671010071	100671010421	8 PMED
100671010071	100671010511	8 PMED
100671010071	100671010521	8 PMED
100671010071	100671010531	8 PMED
100671020041	100671020371	8 PMED
100671020041	100671020411	8 PMED
100861020041	100861020011	1 MVIS
100861020041	100861020031	8 PMED
100861020041	100861020091	8 PMED
100861020041	100861020101	8 PMED
100861020041	100861020111	1 MVIS
100861020041	100861020141	8 PMED
100861020041	100861020151	8 PMED
101371010051	101371010261	1 MVIS
101371010051	101371010341	8 PMED
101371010051	101371010381	8 PMED
101541020041	101541020011	1 MVIS
101841020091	101841020381	8 PMED
101841020091	101841020401	2 OPAT
102061010011	102061010071	8 PMED
102061040011	102061040011	1 MVIS
102061040011	102061040021	1 MVIS
102061040011	102061040031	3 EROM

Return to Top

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

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	100121010051	100121010051	8 PMED
2	100121010051	100121010111	8 PMED
3	100121010051	100121010151	8 PMED
4	100171010021	100171010091	8 PMED
5	100171010021	100171010161	8 PMED
6	100171010021	100171010181	1 MVIS
7	100431010021	100431010121	8 PMED
8	100431030011	100431030011	1 MVIS
9	100431030011	100431030021	8 PMED
10	100431030011	100431030031	8 PMED
11	100431030011	100431030051	8 PMED
12	100431030011	100431030071	1 MVIS
13	100431030011	100431030091	8 PMED
14	100431030011	100431030101	8 PMED
15	100431030011	100431030111	8 PMED
16	100431030011	100431030121	8 PMED
17	100431030011	100431030171	8 PMED
18	100431040011	100431040011	1 MVIS
19	100431040011	100431040021	1 MVIS
20	100431040011	100431040031	8 PMED
21	100431040011	100431040041	8 PMED
22	100431040011	100431040051	8 PMED
23	100431040011	100431040061	8 PMED
24	100431040011	100431040071	8 PMED
25	100431040011	100431040081	8 PMED
26	100431040011	100431040091	1 MVIS
27	100431040011	100431040101	1 MVIS
28	100431040011	100431040111	1 MVIS
29	100431040011	100431040131	8 PMED
30	100431040011	100431040141	8 PMED
31	100431040011	100431040151	8 PMED
32	100431040011	100431040161	8 PMED
33	100431040011	100431040171	1 MVIS
34	100431040011	100431040201	1 MVIS
35	100431040011	100431040211	1 MVIS
36	100431040011	100431040231	8 PMED
37	100431040011	100431040241	8 PMED
38	100431040011	100431040251	8 PMED
39	100431040011	100431040271	8 PMED
40	100441010031	100441010031	2 OPAT
41	100441010031	100441010091	8 PMED
42	100441010031	100441010101	8 PMED
43	100441010031	100441010111	8 PMED
44	100531020041	100531020361	8 PMED
45	100531040011	100531040021	8 PMED
46	100661010021	100661010021	8 PMED
47	100661010021	100661010041	8 PMED
48	100671010071	100671010171	8 PMED
49	100671010071	100671010181	8 PMED
50	100671010071	100671010191	8 PMED

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	100121010051	8 PMED
2	100121010111	8 PMED
3	100121010151	8 PMED
4	100171010091	8 PMED
5	100171010161	8 PMED
6	100171010181	1 MVIS
7	100431010121	8 PMED
8	100431030011	1 MVIS
9	100431030021	8 PMED
10	100431030031	8 PMED
11	100431030051	8 PMED
12	100431030071	1 MVIS
13	100431030091	8 PMED
14	100431030101	8 PMED
15	100431030111	8 PMED
16	100431030121	8 PMED
17	100431030171	8 PMED
18	100431040011	1 MVIS
19	100431040021	1 MVIS
20	100431040031	8 PMED
21	100431040041	8 PMED
22	100431040051	8 PMED
23	100431040061	8 PMED
24	100431040071	8 PMED
25	100431040081	8 PMED
26	100431040091	1 MVIS
27	100431040101	1 MVIS
28	100431040111	1 MVIS
29	100431040131	8 PMED
30	100431040141	8 PMED
31	100431040151	8 PMED
32	100431040161	8 PMED
33	100431040171	1 MVIS
34	100431040201	1 MVIS
35	100431040211	1 MVIS
36	100431040231	8 PMED
37	100431040241	8 PMED
38	100431040251	8 PMED
39	100431040271	8 PMED
40	100441010031	2 OPAT
41	100441010091	8 PMED
42	100441010101	8 PMED
43	100441010111	8 PMED
44	100531020361	8 PMED
45	100531040021	8 PMED
46	100661010021	8 PMED
47	100661010041	8 PMED
48	100671010171	8 PMED
49	100671010181	8 PMED
50	100671010191	8 PMED

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	100171010181	1 MVIS
2	100431030011	1 MVIS
3	100431030071	1 MVIS
4	100431040011	1 MVIS
5	100431040021	1 MVIS
6	100431040091	1 MVIS
7	100431040101	1 MVIS
8	100431040111	1 MVIS
9	100431040171	1 MVIS
10	100431040201	1 MVIS
11	100431040211	1 MVIS
12	100861020011	1 MVIS
13	100861020111	1 MVIS
14	101371010261	1 MVIS
15	101541020011	1 MVIS
16	102061040011	1 MVIS
17	102061040021	1 MVIS
18	102291020061	1 MVIS
19	102451010081	1 MVIS
20	102451030011	1 MVIS
21	102531020051	1 MVIS
22	102601010131	1 MVIS
23	102601010141	1 MVIS
24	102601010151	1 MVIS
25	102601010161	1 MVIS
26	102691010101	1 MVIS
27	102781020141	1 MVIS
28	102781020151	1 MVIS
29	102991060021	1 MVIS
30	103051020041	1 MVIS
31	103051020051	1 MVIS
32	103051020061	1 MVIS
33	103051020131	1 MVIS
34	103581010011	1 MVIS
35	103581010561	1 MVIS
36	103581010571	1 MVIS
37	103581010581	1 MVIS
38	103921030071	1 MVIS
39	103921030081	1 MVIS
40	103921030091	1 MVIS
41	103921030101	1 MVIS
42	103921030111	1 MVIS
43	103921030121	1 MVIS
44	103921030131	1 MVIS
45	103921030141	1 MVIS
46	103921030151	1 MVIS
47	103921030161	1 MVIS
48	103921030171	1 MVIS
49	103921030181	1 MVIS
50	103921030191	1 MVIS

Return to Top

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

EVNTIDX	LINKIDX	EVENTYPE
100071010011	100071010031	1 MVIS
100071010021	100071010041	1 MVIS
100071010071	100071010081	1 MVIS
100071020041	100071020061	1 MVIS
100071020051	100071020071	1 MVIS
100091010171	100091010121	4 STAZ
100091010171	100091010131	4 STAZ
100091010181	100091010191	4 STAZ
100091010181	100091010201	4 STAZ
100091010181	100091010211	4 STAZ
100091010181	100091010221	4 STAZ
100091010181	100091010231	4 STAZ
100091010181	100091010241	4 STAZ
100091010181	100091010251	4 STAZ
100091010181	100091010261	4 STAZ
100091010181	100091010271	4 STAZ
100121010091	100121010111	1 MVIS
100121010091	100121010121	1 MVIS
100121010091	100121010131	1 MVIS
100121010091	100121010151	1 MVIS
100121010091	100121010161	1 MVIS
100121010091	100121010171	1 MVIS
100121020171	100121020301	1 MVIS
100121020181	100121020311	1 MVIS
100121020231	100121020321	1 MVIS
100161010011	100161010021	1 MVIS
100161010311	100161010321	4 STAZ
100161010311	100161010331	4 STAZ
100161050011	100161050031	1 MVIS
100161050021	100161050041	3 EROM
100161050021	100161050051	3 EROM
100161050061	100161050111	3 EROM
100161050061	100161050121	3 EROM
100171010031	100171010041	1 MVIS
100171010031	100171010051	1 MVIS
100171010171	100171010191	5 DVIS
100191020081	100191020201	1 MVIS
100211010081	100211010091	4 STAZ
100211010081	100211010101	4 STAZ
100261030021	100261030031	1 MVIS
100301010011	100301010041	3 EROM
100301010051	100301010071	1 MVIS
100301010051	100301010081	1 MVIS
100301010051	100301010091	1 MVIS
100301010101	100301010121	1 MVIS
100301010101	100301010131	1 MVIS
100301010101	100301010141	1 MVIS
100301020011	100301020031	1 MVIS
100301020011	100301020041	1 MVIS
100301030011	100301030021	1 MVIS
100301030031	100301030051	1 MVIS
100301030031	100301030061	1 MVIS
100301040011	100301040021	1 MVIS
100301040011	100301040031	1 MVIS
100301040051	100301040061	5 DVIS
100331010031	100331010051	1 MVIS
100331010041	100331010061	1 MVIS
100331010041	100331010071	1 MVIS
100331010041	100331010081	1 MVIS
100331010091	100331010121	1 MVIS
100331010091	100331010131	1 MVIS
100331010091	100331010141	1 MVIS
100331010091	100331010151	1 MVIS
100331010091	100331010161	1 MVIS
100331010171	100331010241	5 DVIS
100331010201	100331010251	1 MVIS
100331030011	100331030021	1 MVIS
100331030011	100331030031	1 MVIS
100331030011	100331030041	1 MVIS
100331030011	100331030051	1 MVIS
100331030011	100331030061	1 MVIS
100331030011	100331030071	1 MVIS
100331030011	100331030081	1 MVIS
100331030011	100331030091	1 MVIS
100331030101	100331030121	1 MVIS
100331030101	100331030131	1 MVIS
100331030101	100331030141	1 MVIS
100331030101	100331030151	1 MVIS
100331030101	100331030161	1 MVIS
100331030101	100331030171	1 MVIS
100331030101	100331030181	1 MVIS
100331030101	100331030191	1 MVIS
100331030201	100331030381	1 MVIS
100331030211	100331030371	1 MVIS
100331030211	100331030381	1 MVIS
100331030211	100331030391	1 MVIS
100331030211	100331030401	1 MVIS
100331030211	100331030411	1 MVIS
100331030211	100331030421	1 MVIS
100331030211	100331030431	1 MVIS
100331030211	100331030441	1 MVIS
100331030211	100331030451	1 MVIS
100331030211	100331030461	1 MVIS
100331030221	100331030371	1 MVIS
100331030221	100331030381	1 MVIS
100331030221	100331030391	1 MVIS
100331030221	100331030401	1 MVIS
100331030221	100331030411	1 MVIS
100331030221	100331030421	1 MVIS
100331030221	100331030431	1 MVIS
100331030221	100331030441	1 MVIS
100331030221	100331030451	1 MVIS
100331030221	100331030461	1 MVIS
100331030231	100331030381	1 MVIS
100331030301	100331030381	1 MVIS
100331030301	100331030391	1 MVIS
100331030301	100331030401	1 MVIS
100331030301	100331030411	1 MVIS
100331030301	100331030421	1 MVIS
100331030301	100331030431	1 MVIS
100331030301	100331030441	1 MVIS
100331030301	100331030451	1 MVIS
100331030301	100331030461	1 MVIS
100331030301	100331030471	1 MVIS
100341010011	100341010021	1 MVIS
100341010011	100341010031	1 MVIS
100341010061	100341010071	1 MVIS
100341030061	100341030141	1 MVIS
100351010011	100351010021	1 MVIS
100351010011	100351010031	1 MVIS
100351010041	100351010051	1 MVIS
100351010041	100351010061	1 MVIS
100351030011	100351030051	1 MVIS
100351040011	100351040021	1 MVIS
100351040011	100351040031	1 MVIS
100351040011	100351040041	1 MVIS
100351040051	100351040061	1 MVIS
100351040051	100351040071	1 MVIS
100351040081	100351040141	1 MVIS
100351040081	100351040151	1 MVIS
100351040131	100351040171	4 STAZ
100391010011	100391010051	1 MVIS
100391010011	100391010061	1 MVIS
100391010021	100391010031	1 MVIS
100391010021	100391010041	1 MVIS
100401010431	100401010691	5 DVIS
100401020011	100401020031	1 MVIS
100401020011	100401020041	1 MVIS
100401020011	100401020051	1 MVIS
100401020011	100401020061	1 MVIS

Return to Top

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

EVNTIDX	LINKIDX	EVENTYPE
100431030011	100431030021	1 MVIS
100431030011	100431030031	1 MVIS
100431030071	100431030101	1 MVIS
100431030071	100431030121	1 MVIS
100431040011	100431040031	1 MVIS
100431040011	100431040041	1 MVIS
100431040021	100431040031	1 MVIS
100431040021	100431040041	1 MVIS
100431040201	100431040251	1 MVIS
100431040201	100431040261	1 MVIS
100431040201	100431040271	1 MVIS
100431040211	100431040251	1 MVIS
100431040211	100431040261	1 MVIS
100861020011	100861020021	1 MVIS
100861020011	100861020031	1 MVIS
100861020011	100861020041	1 MVIS
100861020011	100861020051	1 MVIS
100861020011	100861020061	1 MVIS
100861020011	100861020071	1 MVIS
100861020011	100861020081	1 MVIS
100861020011	100861020091	1 MVIS
100861020011	100861020101	1 MVIS
101371010261	101371010341	1 MVIS
101541020011	101541020021	1 MVIS
101541020011	101541020031	1 MVIS
101541020011	101541020041	1 MVIS
101541020011	101541020051	1 MVIS
101541020011	101541020061	1 MVIS
102061040011	102061040041	1 MVIS
102061040021	102061040041	1 MVIS
102291020061	102291020091	1 MVIS
102451030011	102451030071	1 MVIS
102531020051	102531020061	1 MVIS
102601010131	102601010281	1 MVIS
102601010131	102601010291	1 MVIS
102601010131	102601010301	1 MVIS
102601010131	102601010311	1 MVIS
102781020141	102781020161	1 MVIS
102781020151	102781020171	1 MVIS
102781020151	102781020181	1 MVIS
102991060021	102991060031	1 MVIS
102991060021	102991060041	1 MVIS
102991060021	102991060051	1 MVIS
103051020041	103051020081	1 MVIS
103051020041	103051020091	1 MVIS
103581010011	103581010041	1 MVIS
103581010011	103581010051	1 MVIS
103581010011	103581010061	1 MVIS
103581010011	103581010071	1 MVIS
103581010011	103581010081	1 MVIS

Return to Top

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

Obs	EVNTIDX	LINKIDX	EVENTYPE
1	100431030011	100431030021	1 MVIS
2	100431030011	100431030031	1 MVIS
3	100431030071	100431030101	1 MVIS
4	100431030071	100431030121	1 MVIS
5	100431040011	100431040031	1 MVIS
6	100431040021	100431040031	1 MVIS
7	100431040011	100431040041	1 MVIS
8	100431040021	100431040041	1 MVIS
9	100431040201	100431040251	1 MVIS
10	100431040211	100431040251	1 MVIS
11	100431040201	100431040261	1 MVIS
12	100431040211	100431040261	1 MVIS
13	100431040201	100431040271	1 MVIS
14	100861020011	100861020021	1 MVIS
15	100861020011	100861020031	1 MVIS
16	100861020011	100861020041	1 MVIS
17	100861020011	100861020051	1 MVIS
18	100861020011	100861020061	1 MVIS
19	100861020011	100861020071	1 MVIS
20	100861020011	100861020081	1 MVIS
21	100861020011	100861020091	1 MVIS
22	100861020011	100861020101	1 MVIS
23	101371010261	101371010341	1 MVIS
24	101541020011	101541020021	1 MVIS
25	101541020011	101541020031	1 MVIS
26	101541020011	101541020041	1 MVIS
27	101541020011	101541020051	1 MVIS
28	101541020011	101541020061	1 MVIS
29	102061040011	102061040041	1 MVIS
30	102061040021	102061040041	1 MVIS
31	102291020061	102291020091	1 MVIS
32	102451030011	102451030071	1 MVIS
33	102531020051	102531020061	1 MVIS
34	102601010131	102601010281	1 MVIS
35	102601010131	102601010291	1 MVIS
36	102601010131	102601010301	1 MVIS
37	102601010131	102601010311	1 MVIS
38	102781020141	102781020161	1 MVIS
39	102781020151	102781020171	1 MVIS
40	102781020151	102781020181	1 MVIS
41	102991060021	102991060031	1 MVIS
42	102991060021	102991060041	1 MVIS
43	102991060021	102991060051	1 MVIS
44	103051020041	103051020081	1 MVIS
45	103051020041	103051020091	1 MVIS
46	103581010011	103581010041	1 MVIS
47	103581010011	103581010051	1 MVIS
48	103581010011	103581010061	1 MVIS
49	103581010011	103581010071	1 MVIS
50	103581010011	103581010081	1 MVIS

Return to Top

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

Obs	LINKIDX
1	100431030021
2	100431030031
3	100431030101
4	100431030121
5	100431040031
6	100431040041
7	100431040251
8	100431040261
9	100431040271
10	100861020021
11	100861020031
12	100861020041
13	100861020051
14	100861020061
15	100861020071
16	100861020081
17	100861020091
18	100861020101
19	101371010341
20	101541020021
21	101541020031
22	101541020041
23	101541020051
24	101541020061
25	102061040041
26	102291020091
27	102451030071
28	102531020061
29	102601010281
30	102601010291
31	102601010301
32	102601010311
33	102781020161
34	102781020171
35	102781020181
36	102991060031
37	102991060041
38	102991060051
39	103051020081
40	103051020091
41	103581010041
42	103581010051
43	103581010061
44	103581010071
45	103581010081
46	103581010091
47	103581010621
48	103581010631
49	103581010641
50	103581010651

Return to Top

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

LINKIDX	RXRECIDX	RXNAME	RXXP10X	PERWT10F
100431030021	100431030021001	AZITHROMYCIN	26.76	13273.138854
100431030031	100431030031001	PREDNISOLONE	9.69	13273.138854
100431030101	100431030101001	AZITHROMYCIN	30.82	13273.138854
100431030101	100431030101002	AZITHROMYCIN	62.41	13273.138854
100431030121	100431030121001	PREDNISONE	3.17	13273.138854
100431040031	100431040031001	AZITHROMYCIN	26.76	24678.499660
100431040031	100431040031002	AZITHROMYCIN	26.76	24678.499660
100431040041	100431040041001	PREDNISONE	2.57	24678.499660
100431040251	100431040251001	PREDNISONE	2.57	24678.499660
100431040251	100431040251002	PREDNISONE	2.53	24678.499660
100431040261	100431040261001	CEFPROZIL	38.51	24678.499660
100431040261	100431040261002	CEFPROZIL	36.71	24678.499660
100431040271	100431040271001	XOPENEX HFA	51.28	24678.499660
100861020021	100861020021001	LORATADINE	5.92	4351.170836
100861020031	100861020031001	SINGULAIR	118.20	4351.170836
100861020041	100861020041001	LIPITOR	132.19	4351.170836
100861020051	100861020051001	METFORMIN	5.00	4351.170836
100861020061	100861020061001	GLIMEPIRIDE	5.02	4351.170836
100861020071	100861020071001	ISOMETH/APAP	18.42	4351.170836
100861020081	100861020081001	JANUVIA	184.21	4351.170836
100861020091	100861020091001	PROAIR HFA	38.28	4351.170836
100861020101	100861020101001	ADVAIR DISKU	281.37	4351.170836
101371010341	101371010341001	PREDNISONE	12.02	3246.386814
101541020021	101541020021001	BENAZEPRIL	15.00	6213.899262
101541020021	101541020021002	BENAZEPRIL	15.00	6213.899262
101541020031	101541020031001	GLIPIZIDE	7.88	6213.899262
101541020031	101541020031002	GLIPIZIDE	7.88	6213.899262
101541020031	101541020031003	GLIPIZIDE	4.00	6213.899262
101541020031	101541020031004	GLIPIZIDE	4.00	6213.899262
101541020031	101541020031005	GLIPIZIDE	4.00	6213.899262
101541020041	101541020041001	TRILIPIX	121.00	6213.899262
101541020041	101541020041002	TRILIPIX	121.00	6213.899262
101541020041	101541020041003	TRILIPIX	121.00	6213.899262
101541020041	101541020041004	TRILIPIX	121.00	6213.899262
101541020041	101541020041005	TRILIPIX	121.00	6213.899262
101541020051	101541020051001	SIMCOR	65.95	6213.899262
101541020051	101541020051002	SIMCOR	65.95	6213.899262
101541020051	101541020051003	SIMCOR	65.95	6213.899262
101541020051	101541020051004	SIMCOR	65.95	6213.899262
101541020051	101541020051005	SIMCOR	65.95	6213.899262
101541020061	101541020061001	BYSTOLIC	62.00	6213.899262
101541020061	101541020061002	BYSTOLIC	62.00	6213.899262
102061040041	102061040041001	Albuterol	0.22	9038.830355
102291020091	102291020091001	Proventil HFA	43.16	10983.991425
102451030071	102451030071001	CONCERTA	148.49	18569.059372
102451030071	102451030071002	CONCERTA	158.65	18569.059372
102531020061	102531020061001	MAXALT	139.29	25782.763549
102601010281	102601010281001	GLIMEPIRIDE	4.13	10351.477283
102601010281	102601010281002	GLIMEPIRIDE	4.13	10351.477283
102601010281	102601010281003	GLIMEPIRIDE	4.13	10351.477283
102601010281	102601010281004	GLIMEPIRIDE	4.13	10351.477283
102601010281	102601010281005	GLIMEPIRIDE	4.13	10351.477283
102601010281	102601010281006	GLIMEPIRIDE	4.13	10351.477283
102601010291	102601010291001	SIMVASTATIN	9.93	10351.477283
102601010291	102601010291002	SIMVASTATIN	9.93	10351.477283
102601010291	102601010291003	SIMVASTATIN	9.93	10351.477283
102601010291	102601010291004	SIMVASTATIN	9.93	10351.477283
102601010291	102601010291005	SIMVASTATIN	9.93	10351.477283
102601010291	102601010291006	SIMVASTATIN	9.93	10351.477283
102601010301	102601010301001	LISINOPRIL	5.23	10351.477283
102601010301	102601010301002	LISINOPRIL	5.23	10351.477283
102601010301	102601010301003	LISINOPRIL	5.23	10351.477283
102601010301	102601010301004	LISINOPRIL	5.23	10351.477283
102601010301	102601010301005	LISINOPRIL	5.23	10351.477283
102601010301	102601010301006	LISINOPRIL	5.23	10351.477283
102601010311	102601010311001	AMLODIPINE	11.00	10351.477283
102601010311	102601010311002	AMLODIPINE	11.00	10351.477283
102601010311	102601010311003	AMLODIPINE	11.00	10351.477283
102601010311	102601010311004	AMLODIPINE	11.00	10351.477283
102601010311	102601010311005	AMLODIPINE	10.00	10351.477283
102601010311	102601010311006	AMLODIPINE	10.00	10351.477283
102601010311	102601010311007	AMLODIPINE	10.00	10351.477283
102781020161	102781020161001	Albuterol	0.15	12143.586784
102781020171	102781020171001	AZITHROMYCIN	10.00	12143.586784
102781020181	102781020181001	METOPROLOL TART	4.00	12143.586784
102991060031	102991060031001	PREDNISOLONE	13.00	7322.175449
102991060041	102991060041001	THERA-M	6.50	7322.175449
102991060051	102991060051001	ED-A-HIST DM	5.00	7322.175449
103051020081	103051020081001	CIPROFLOXACN	4.00	4878.457322
103051020091	103051020091001	Advair Diskus	197.47	4878.457322
103051020091	103051020091002	Advair Diskus	197.47	4878.457322
103581010041	103581010041001	NOVOLIN N	53.24	5132.990088
103581010051	103581010051001	INSULIN SYRG	24.00	5132.990088
103581010061	103581010061001	Albuterol	21.42	5132.990088
103581010061	103581010061002	Albuterol	21.42	5132.990088
103581010071	103581010071001	PROAIR HFA	37.66	5132.990088
103581010081	103581010081001	SIMVASTATIN	5.00	5132.990088
103581010091	103581010091001	LISINOPRIL	10.00	5132.990088
103581010621	103581010621001	SIMVASTATIN	5.00	5132.990088
103581010631	103581010631001	QVAR	62.93	5132.990088
103581010631	103581010631002	QVAR	62.93	5132.990088
103581010641	103581010641001	RELION HUMULIN N U	25.00	5132.990088
103581010641	103581010641002	RELION HUMULIN N U	25.00	5132.990088
103581010641	103581010641003	RELION HUMULIN N U	25.00	5132.990088
103581010641	103581010641004	RELION HUMULIN N U	25.00	5132.990088
103581010651	103581010651001	RELION HUMULIN R U	25.00	5132.990088
103581010651	103581010651002	RELION HUMULIN R U	25.00	5132.990088
103581010651	103581010651003	RELION HUMULIN R U	25.00	5132.990088
103581010651	103581010651004	RELION HUMULIN R U	25.00	5132.990088
103581010651	103581010651005	RELION HUMULIN R U	25.00	5132.990088
103581010651	103581010651006	RELION HUMULIN R U	25.00	5132.990088
103921030301	103921030301001	SINGULAIR	131.00	5614.573780
103921030301	103921030301002	SINGULAIR	131.00	5614.573780
103921030301	103921030301003	SINGULAIR	131.00	5614.573780
103921030301	103921030301004	SINGULAIR	96.00	5614.573780
103921030301	103921030301005	SINGULAIR	96.00	5614.573780
103921030301	103921030301006	SINGULAIR	96.00	5614.573780
103921030311	103921030311001	DEHISTINE	10.00	5614.573780
103921030311	103921030311002	DEHISTINE	10.00	5614.573780
103921030311	103921030311003	DEHISTINE	10.00	5614.573780
103921030311	103921030311004	DEHISTINE	10.00	5614.573780
103921030311	103921030311005	DEHISTINE	10.00	5614.573780
103921030311	103921030311006	DEHISTINE	10.00	5614.573780
104011010031	104011010031001	Albuterol So4 (CFC-F) Oral	43.60	5825.587735
104011010041	104011010041001	Aspirin	11.75	5825.587735
104011010051	104011010051001	CLONIDINE	22.03	5825.587735
104011010061	104011010061001	PLAVIX	99.45	5825.587735
104011010071	104011010071001	Hydrochlorothiazide	12.12	5825.587735
104011010081	104011010081001	HYDROCODONE	23.99	5825.587735
104011010091	104011010091001	METOPROLOL TART	14.40	5825.587735
104011010101	104011010101001	NITROSTAT	13.97	5825.587735
104011010111	104011010111001	RANITIDINE	6.47	5825.587735
104011010121	104011010121001	Simvastatin	24.00	5825.587735
104251010131	104251010131001	LEVAQUIN	189.79	28225.544125
104801010111	104801010111001	OXAPROZIN	25.67	5272.855579
104801010111	104801010111002	OXAPROZIN	25.67	5272.855579
104801010111	104801010111003	OXAPROZIN	25.67	5272.855579
104801010111	104801010111004	OXAPROZIN	25.67	5272.855579
104801010121	104801010121001	SUSTIVA	540.77	5272.855579
104801010121	104801010121002	SUSTIVA	540.77	5272.855579
104801010121	104801010121003	SUSTIVA	572.44	5272.855579
104801010121	104801010121004	SUSTIVA	572.44	5272.855579
104801010131	104801010131001	LIPITOR	94.40	5272.855579
104801010131	104801010131002	LIPITOR	94.40	5272.855579
104801010131	104801010131003	LIPITOR	94.40	5272.855579
104801010131	104801010131004	LIPITOR	94.40	5272.855579
104801010141	104801010141001	TRUVADA	1003.89	5272.855579
104801010141	104801010141002	TRUVADA	1003.89	5272.855579
104801010141	104801010141003	TRUVADA	1003.89	5272.855579
104801010141	104801010141004	TRUVADA	1003.89	5272.855579
104801010151	104801010151001	MAG OXIDE	8.00	5272.855579
104801010151	104801010151002	MAG OXIDE	8.00	5272.855579
104801010151	104801010151003	MAG OXIDE	8.00	5272.855579
104801010151	104801010151004	MAG OXIDE	8.00	5272.855579
104801010161	104801010161001	SMZ/TMP DS	10.78	5272.855579
104801010161	104801010161002	SMZ/TMP DS	10.78	5272.855579
104801010161	104801010161003	SMZ/TMP DS	10.78	5272.855579
104801010161	104801010161004	SMZ/TMP DS	5.70	5272.855579
104801010171	104801010171001	TRAZODONE	9.73	5272.855579
104801010171	104801010171002	TRAZODONE	9.73	5272.855579
104801010171	104801010171003	TRAZODONE	9.73	5272.855579
104801010171	104801010171004	TRAZODONE	9.73	5272.855579
104841010131	104841010131001	PENICILLN VK	15.00	21302.144846
104841010141	104841010141001	AMOXICILLIN	4.00	21302.144846
104841010151	104841010151001	PREDNISONE	2.00	21302.144846
104841010151	104841010151002	PREDNISONE	2.00	21302.144846
104841010151	104841010151003	PREDNISONE	2.00	21302.144846
104841010151	104841010151004	PREDNISONE	2.00	21302.144846
104841010151	104841010151005	PREDNISONE	2.00	21302.144846
104841010151	104841010151006	PREDNISONE	2.00	21302.144846
104841010161	104841010161001	IBUPROFEN	4.00	21302.144846
104911020031	104911020031001	VENTOLIN HFA	31.95	4101.910391
104911020041	104911020041001	QVAR	90.35	4101.910391
105071030021	105071030021001	VENTOLIN HFA	32.62	9722.976894
105071030021	105071030021002	VENTOLIN HFA	42.09	9722.976894
105241020141	105241020141001	PREDNISONE	1.23	9332.386190
105241020141	105241020141002	PREDNISONE	1.23	9332.386190
105241020141	105241020141003	PREDNISONE	1.23	9332.386190
105241020571	105241020571001	SOD CHLORIDE	13.78	9332.386190
105241020571	105241020571002	SOD CHLORIDE	13.78	9332.386190
105241020571	105241020571003	SOD CHLORIDE	13.78	9332.386190
105241020571	105241020571004	SOD CHLORIDE	13.78	9332.386190
105241020571	105241020571005	SOD CHLORIDE	13.78	9332.386190
105241020571	105241020571006	SOD CHLORIDE	13.78	9332.386190
105241020581	105241020581001	ASMANEX 60	115.87	9332.386190
105241020831	105241020831001	DIGOXIN	10.04	9332.386190
105241020831	105241020831002	DIGOXIN	10.04	9332.386190
105241020841	105241020841001	LEXAPRO	81.74	9332.386190
105241020841	105241020841002	LEXAPRO	81.74	9332.386190
105241020851	105241020851001	WARFARIN	21.04	9332.386190
105241020851	105241020851002	WARFARIN	21.04	9332.386190
105241020861	105241020861001	KLOR-CON M20	18.23	9332.386190
105241020861	105241020861002	KLOR-CON M20	29.89	9332.386190
105241020871	105241020871001	SOD CHLORIDE	13.78	9332.386190
105241020871	105241020871002	SOD CHLORIDE	13.78	9332.386190
105241020871	105241020871003	SOD CHLORIDE	13.78	9332.386190
105241020881	105241020881001	CLONAZEPAM	2.26	9332.386190
105241020881	105241020881002	CLONAZEPAM	2.26	9332.386190
105241020881	105241020881003	CLONAZEPAM	2.26	9332.386190
105241020881	105241020881004	CLONAZEPAM	2.26	9332.386190
105241020891	105241020891001	ASMANEX 60	115.87	9332.386190
105241020891	105241020891002	ASMANEX 60	115.87	9332.386190
105241020891	105241020891003	ASMANEX 60	120.50	9332.386190
105241020901	105241020901001	METOPROLOL	307.83	9332.386190
105241020901	105241020901002	METOPROLOL	307.83	9332.386190
105241020911	105241020911001	FUROSEMIDE	5.00	9332.386190
105241020911	105241020911002	FUROSEMIDE	5.00	9332.386190
105241020921	105241020921001	LISINOPRIL	10.06	9332.386190
105241020931	105241020931001	FLUTICASONE	54.19	9332.386190
105241020931	105241020931002	FLUTICASONE	54.19	9332.386190

Return to Top

HC-135I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Analysis Variable: RXXP10X SUM OF PAYMENTS RXSF10X-RXOU10X(IMPUTED)

N	Sum
4676	393427.76

Return to Top

HC-135I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
Analysis Variable: RXXP10X SUM OF PAYMENTS RXSF10X-RXOU10X(IMPUTED)

N	Sum
4676	4419617818

Return to Top

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
NOTE: This session is executing on the W32_VSPRO platform.

NOTE: SAS initialization used:
real time 1.46 seconds
cpu time 0.14 seconds

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

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

NOTE: AUTOEXEC processing completed.

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

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

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

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 (H137) records where cccodex=128";
43 run;

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

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

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;

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;

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.01 seconds
cpu time 0.01 seconds

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

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

NOTE: There were 301032 observations read from the data set WORK.PMED.
NOTE: There were 6680 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 10115 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.07 seconds

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

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

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

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

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

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

111
112 ods rtf close;
113

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

Return to Top

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

Obs	CONDIDX	CCCODEX
1	100121010051	128
2	100171010021	128
3	100431010021	128
4	100431030011	128
5	100431040011	128
6	100441010031	128
7	100531020041	128
8	100531040011	128
9	100661010021	128
10	100671010071	128
11	100671020041	128
12	100861020041	128
13	101311020041	128
14	101371010051	128
15	101541020041	128
16	101831050011	128
17	101841020091	128
18	101981020061	128
19	101981030051	128
20	101981040031	128
21	101981050011	128
22	102061010011	128
23	102061040011	128
24	102291020011	128
25	102361030011	128
26	102361040011	128
27	102421010041	128
28	102442010032	128
29	102451010021	128
30	102451030011	128
31	102531020011	128
32	102591050011	128
33	102601010071	128
34	102691010111	128
35	102691020091	128
36	102692030012	128
37	102781020031	128
38	102891010051	128
39	102891020021	128
40	102991060011	128
41	103051020011	128
42	103101010031	128
43	103131010111	128
44	103311010051	128
45	103331010021	128
46	103371010011	128
47	103581010041	128
48	103691010021	128
49	103851030011	128
50	103851040011	128

Return to Top

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

CONDIDX	EVNTIDX	EVENTYPE
100121010051	100121010051	8 PMED
100121010051	100121010111	8 PMED
100121010051	100121010151	8 PMED
100171010021	100171010091	8 PMED
100171010021	100171010161	8 PMED
100171010021	100171010181	1 MVIS
100431010021	100431010121	8 PMED
100431030011	100431030011	1 MVIS
100431030011	100431030021	8 PMED
100431030011	100431030031	8 PMED
100431030011	100431030051	8 PMED
100431030011	100431030071	1 MVIS
100431030011	100431030091	8 PMED
100431030011	100431030101	8 PMED
100431030011	100431030111	8 PMED
100431030011	100431030121	8 PMED
100431030011	100431030171	8 PMED
100431040011	100431040011	1 MVIS
100431040011	100431040021	1 MVIS
100431040011	100431040031	8 PMED
100431040011	100431040041	8 PMED
100431040011	100431040051	8 PMED
100431040011	100431040061	8 PMED
100431040011	100431040071	8 PMED
100431040011	100431040081	8 PMED
100431040011	100431040091	1 MVIS
100431040011	100431040101	1 MVIS
100431040011	100431040111	1 MVIS
100431040011	100431040131	8 PMED
100431040011	100431040141	8 PMED
100431040011	100431040151	8 PMED
100431040011	100431040161	8 PMED
100431040011	100431040171	1 MVIS
100431040011	100431040201	1 MVIS
100431040011	100431040211	1 MVIS
100431040011	100431040231	8 PMED
100431040011	100431040241	8 PMED
100431040011	100431040251	8 PMED
100431040011	100431040271	8 PMED
100441010031	100441010031	2 OPAT
100441010031	100441010091	8 PMED
100441010031	100441010101	8 PMED
100441010031	100441010111	8 PMED
100531020041	100531020361	8 PMED
100531040011	100531040021	8 PMED
100661010021	100661010021	8 PMED
100661010021	100661010041	8 PMED
100671010071	100671010171	8 PMED
100671010071	100671010181	8 PMED
100671010071	100671010191	8 PMED
100671010071	100671010401	8 PMED
100671010071	100671010411	8 PMED
100671010071	100671010421	8 PMED
100671010071	100671010511	8 PMED
100671010071	100671010521	8 PMED
100671010071	100671010531	8 PMED
100671020041	100671020371	8 PMED
100671020041	100671020411	8 PMED
100861020041	100861020011	1 MVIS
100861020041	100861020031	8 PMED
100861020041	100861020091	8 PMED
100861020041	100861020101	8 PMED
100861020041	100861020111	1 MVIS
100861020041	100861020141	8 PMED
100861020041	100861020151	8 PMED
101371010051	101371010261	1 MVIS
101371010051	101371010341	8 PMED
101371010051	101371010381	8 PMED
101541020041	101541020011	1 MVIS
101841020091	101841020381	8 PMED
101841020091	101841020401	2 OPAT
102061010011	102061010071	8 PMED
102061040011	102061040011	1 MVIS
102061040011	102061040021	1 MVIS
102061040011	102061040031	3 EROM

Return to Top

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

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	100121010051	100121010051	8 PMED
2	100121010051	100121010111	8 PMED
3	100121010051	100121010151	8 PMED
4	100171010021	100171010091	8 PMED
5	100171010021	100171010161	8 PMED
6	100171010021	100171010181	1 MVIS
7	100431010021	100431010121	8 PMED
8	100431030011	100431030011	1 MVIS
9	100431030011	100431030021	8 PMED
10	100431030011	100431030031	8 PMED
11	100431030011	100431030051	8 PMED
12	100431030011	100431030071	1 MVIS
13	100431030011	100431030091	8 PMED
14	100431030011	100431030101	8 PMED
15	100431030011	100431030111	8 PMED
16	100431030011	100431030121	8 PMED
17	100431030011	100431030171	8 PMED
18	100431040011	100431040011	1 MVIS
19	100431040011	100431040021	1 MVIS
20	100431040011	100431040031	8 PMED
21	100431040011	100431040041	8 PMED
22	100431040011	100431040051	8 PMED
23	100431040011	100431040061	8 PMED
24	100431040011	100431040071	8 PMED
25	100431040011	100431040081	8 PMED
26	100431040011	100431040091	1 MVIS
27	100431040011	100431040101	1 MVIS
28	100431040011	100431040111	1 MVIS
29	100431040011	100431040131	8 PMED
30	100431040011	100431040141	8 PMED
31	100431040011	100431040151	8 PMED
32	100431040011	100431040161	8 PMED
33	100431040011	100431040171	1 MVIS
34	100431040011	100431040201	1 MVIS
35	100431040011	100431040211	1 MVIS
36	100431040011	100431040231	8 PMED
37	100431040011	100431040241	8 PMED
38	100431040011	100431040251	8 PMED
39	100431040011	100431040271	8 PMED
40	100441010031	100441010031	2 OPAT
41	100441010031	100441010091	8 PMED
42	100441010031	100441010101	8 PMED
43	100441010031	100441010111	8 PMED
44	100531020041	100531020361	8 PMED
45	100531040011	100531040021	8 PMED
46	100661010021	100661010021	8 PMED
47	100661010021	100661010041	8 PMED
48	100671010071	100671010171	8 PMED
49	100671010071	100671010181	8 PMED
50	100671010071	100671010191	8 PMED

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	100121010051	8 PMED
2	100121010111	8 PMED
3	100121010151	8 PMED
4	100171010091	8 PMED
5	100171010161	8 PMED
6	100171010181	1 MVIS
7	100431010121	8 PMED
8	100431030011	1 MVIS
9	100431030021	8 PMED
10	100431030031	8 PMED
11	100431030051	8 PMED
12	100431030071	1 MVIS
13	100431030091	8 PMED
14	100431030101	8 PMED
15	100431030111	8 PMED
16	100431030121	8 PMED
17	100431030171	8 PMED
18	100431040011	1 MVIS
19	100431040021	1 MVIS
20	100431040031	8 PMED
21	100431040041	8 PMED
22	100431040051	8 PMED
23	100431040061	8 PMED
24	100431040071	8 PMED
25	100431040081	8 PMED
26	100431040091	1 MVIS
27	100431040101	1 MVIS
28	100431040111	1 MVIS
29	100431040131	8 PMED
30	100431040141	8 PMED
31	100431040151	8 PMED
32	100431040161	8 PMED
33	100431040171	1 MVIS
34	100431040201	1 MVIS
35	100431040211	1 MVIS
36	100431040231	8 PMED
37	100431040241	8 PMED
38	100431040251	8 PMED
39	100431040271	8 PMED
40	100441010031	2 OPAT
41	100441010091	8 PMED
42	100441010101	8 PMED
43	100441010111	8 PMED
44	100531020361	8 PMED
45	100531040021	8 PMED
46	100661010021	8 PMED
47	100661010041	8 PMED
48	100671010171	8 PMED
49	100671010181	8 PMED
50	100671010191	8 PMED

Return to Top

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

LINKIDX	RXRECIDX	RXNAME	RXXP10X	PERWT10F
100121010051	100121010051001	COMBIVENT	137.84	18100.455246
100121010111	100121010111001	COMBIVENT	137.84	18100.455246
100121010151	100121010151001	ALBUTEROL/ IPRATROP	60.00	18100.455246
100121010151	100121010151002	ALBUTEROL/ IPRATROP	60.00	18100.455246
100171010091	100171010091001	ADVAIR DISKU	255.87	8879.035173
100171010161	100171010161001	ADVAIR DISKU	223.84	8879.035173
100171010161	100171010161002	ADVAIR DISKU	222.14	8879.035173
100171010161	100171010161003	ADVAIR DISKU	222.14	8879.035173
100171010161	100171010161004	ADVAIR DISKU	222.14	8879.035173
100171010161	100171010161005	ADVAIR DISKU	222.14	8879.035173
100171010161	100171010161006	ADVAIR DISKU	222.14	8879.035173
100431010121	100431010121001	ADVAIR DISKU	168.35	17348.405237
100431030021	100431030021001	AZITHROMYCIN	26.76	13273.138854
100431030031	100431030031001	PREDNISOLONE	9.69	13273.138854
100431030051	100431030051001	Proventil	63.16	13273.138854
100431030091	100431030091001	ADVAIR DISKU	168.85	13273.138854
100431030091	100431030091002	ADVAIR DISKU	168.85	13273.138854
100431030101	100431030101001	AZITHROMYCIN	30.82	13273.138854
100431030101	100431030101002	AZITHROMYCIN	62.41	13273.138854
100431030111	100431030111001	SINGULAIR	103.31	13273.138854
100431030121	100431030121001	PREDNISONE	3.17	13273.138854
100431030171	100431030171001	SINGULAIR	127.60	13273.138854
100431040031	100431040031001	AZITHROMYCIN	26.76	24678.499660
100431040031	100431040031002	AZITHROMYCIN	26.76	24678.499660
100431040041	100431040041001	PREDNISONE	2.57	24678.499660
100431040051	100431040051001	ALBUTEROL	28.59	24678.499660
100431040061	100431040061001	SINGULAIR	116.26	24678.499660
100431040071	100431040071001	ADVAIR HFA	209.80	24678.499660
100431040081	100431040081001	PREDNISOLONE	8.59	24678.499660
100431040081	100431040081002	PREDNISOLONE	7.49	24678.499660
100431040131	100431040131001	ALBUTEROL	45.19	24678.499660
100431040131	100431040131002	ALBUTEROL	45.19	24678.499660
100431040141	100431040141001	PREDNISOLONE	8.70	24678.499660
100431040141	100431040141002	PREDNISOLONE	5.36	24678.499660
100431040151	100431040151001	AZITHROMYCIN	30.82	24678.499660
100431040161	100431040161001	CEFPROZIL	42.26	24678.499660
100431040231	100431040231001	SILDEC PE-DM	8.50	24678.499660
100431040241	100431040241001	PREDNISOLONE	5.11	24678.499660
100431040241	100431040241002	PREDNISOLONE	5.11	24678.499660
100431040241	100431040241003	PREDNISOLONE	5.11	24678.499660
100431040241	100431040241004	PREDNISOLONE	5.11	24678.499660
100431040251	100431040251001	PREDNISONE	2.57	24678.499660
100431040251	100431040251002	PREDNISONE	2.53	24678.499660
100431040271	100431040271001	XOPENEX HFA	51.28	24678.499660
100441010091	100441010091001	Nebulizer MCD	122.50	2595.895845
100441010101	100441010101001	VENTOLIN HFA	36.75	2595.895845
100441010111	100441010111001	symbicort	198.90	2595.895845
100531020361	100531020361001	VENTOLIN HFA	26.21	2606.397192
100531020361	100531020361002	VENTOLIN HFA	26.21	2606.397192
100531020361	100531020361003	VENTOLIN HFA	26.21	2606.397192
100531020361	100531020361004	VENTOLIN HFA	26.21	2606.397192
100531040021	100531040021001	VENTOLIN HFA	26.21	2386.032526
100531040021	100531040021002	VENTOLIN HFA	26.21	2386.032526
100661010021	100661010021001	PROAIR HFA	43.27	5887.992178
100661010021	100661010021002	PROAIR HFA	43.27	5887.992178
100661010021	100661010021003	PROAIR HFA	43.27	5887.992178
100661010021	100661010021004	PROAIR HFA	43.27	5887.992178
100661010021	100661010021005	PROAIR HFA	43.27	5887.992178
100661010041	100661010041001	PROAIR HFA	43.27	5887.992178
100661010041	100661010041002	PROAIR HFA	43.27	5887.992178
100661010041	100661010041003	PROAIR HFA	43.27	5887.992178
100661010041	100661010041004	PROAIR HFA	43.27	5887.992178
100661010041	100661010041005	PROAIR HFA	43.27	5887.992178
100661010041	100661010041006	PROAIR HFA	43.27	5887.992178
100671010171	100671010171001	SEREVENT DIS	153.48	24396.424175
100671010171	100671010171002	SEREVENT DIS	153.48	24396.424175
100671010181	100671010181001	BUDESONIDE	338.72	24396.424175
100671010181	100671010181002	BUDESONIDE	338.72	24396.424175
100671010191	100671010191001	ALBUTEROL	180.38	24396.424175
100671010191	100671010191002	ALBUTEROL	33.30	24396.424175
100671010401	100671010401001	SEREVENT DIS	153.48	24396.424175
100671010401	100671010401002	SEREVENT DIS	153.48	24396.424175
100671010401	100671010401003	SEREVENT DIS	153.48	24396.424175
100671010401	100671010401004	SEREVENT DIS	153.48	24396.424175
100671010401	100671010401005	SEREVENT DIS	153.48	24396.424175
100671010401	100671010401006	SEREVENT DIS	153.48	24396.424175
100671010401	100671010401007	SEREVENT DIS	153.48	24396.424175
100671010401	100671010401008	SEREVENT DIS	153.48	24396.424175
100671010411	100671010411001	BUDESONIDE	361.99	24396.424175
100671010411	100671010411002	BUDESONIDE	361.99	24396.424175
100671010411	100671010411003	BUDESONIDE	361.99	24396.424175
100671010411	100671010411004	BUDESONIDE	361.99	24396.424175
100671010411	100671010411005	BUDESONIDE	361.99	24396.424175
100671010411	100671010411006	BUDESONIDE	361.99	24396.424175
100671010411	100671010411007	BUDESONIDE	361.99	24396.424175
100671010411	100671010411008	BUDESONIDE	361.99	24396.424175
100671010421	100671010421001	FORADIL	152.29	24396.424175
100671010421	100671010421002	FORADIL	152.29	24396.424175
100671010421	100671010421003	FORADIL	152.29	24396.424175
100671010421	100671010421004	FORADIL	152.29	24396.424175
100671010421	100671010421005	FORADIL	152.29	24396.424175
100671010421	100671010421006	FORADIL	152.29	24396.424175
100671010421	100671010421007	FORADIL	152.29	24396.424175
100671010421	100671010421008	FORADIL	152.29	24396.424175
100671010511	100671010511001	SEREVENT DIS	153.48	24396.424175
100671010511	100671010511002	SEREVENT DIS	153.48	24396.424175
100671010511	100671010511003	SEREVENT DIS	153.48	24396.424175
100671010521	100671010521001	BUDESONIDE	361.99	24396.424175
100671010521	100671010521002	BUDESONIDE	361.99	24396.424175
100671010521	100671010521003	BUDESONIDE	361.99	24396.424175
100671010531	100671010531001	FORADIL	152.29	24396.424175
100671010531	100671010531002	FORADIL	152.29	24396.424175
100671010531	100671010531003	FORADIL	152.29	24396.424175
100671020371	100671020371001	Albuterol HFA Inhaler	3.95	22773.498225
100671020371	100671020371002	Albuterol HFA Inhaler	3.95	22773.498225
100671020371	100671020371003	Albuterol HFA Inhaler	3.95	22773.498225
100671020411	100671020411001	SYMBICORT	198.38	22773.498225
100671020411	100671020411002	SYMBICORT	198.38	22773.498225
100671020411	100671020411003	SYMBICORT	198.38	22773.498225
100861020031	100861020031001	SINGULAIR	118.20	4351.170836
100861020091	100861020091001	PROAIR HFA	38.28	4351.170836
100861020101	100861020101001	ADVAIR DISKU	281.37	4351.170836
100861020141	100861020141001	LORATADINE	5.68	4351.170836
100861020151	100861020151001	SINGULAIR	131.20	4351.170836
101371010341	101371010341001	PREDNISONE	12.02	3246.386814
101371010381	101371010381001	ALBUTEROL	4.34	3246.386814
101841020381	101841020381001	VENTOLIN HFA	32.07	2967.805342
102061010071	102061010071001	Advair Diskus	283.51	8819.829268
102061040041	102061040041001	Albuterol	0.22	9038.830355
102291020041	102291020041001	Albuterol	6.63	10983.991425
102291020091	102291020091001	Proventil HFA	43.16	10983.991425
102421010061	102421010061001	THEOPHYLLINE	9.06	2961.197824
102421010061	102421010061002	THEOPHYLLINE	9.06	2961.197824
102421010231	102421010231001	COMBIVENT	121.70	2961.197824
102421010271	102421010271001	Advair Diskus	283.51	2961.197824
102451010031	102451010031001	PROAIR HFA	37.18	16538.634650
102451010031	102451010031002	PROAIR HFA	37.11	16538.634650
102451010041	102451010041001	SINGULAIR	116.33	16538.634650
102451010041	102451010041002	SINGULAIR	124.02	16538.634650
102451010041	102451010041003	SINGULAIR	122.55	16538.634650
102451010061	102451010061001	PROAIR HFA	38.72	16538.634650
102451010071	102451010071001	SINGULAIR	328.81	16538.634650
102451010101	102451010101001	PROAIR HFA	39.17	16538.634650
102451010101	102451010101002	PROAIR HFA	38.72	16538.634650
102451010111	102451010111001	SINGULAIR	281.96	16538.634650
102451030081	102451030081001	VENTOLIN HFA	34.76	18569.059372
102451030181	102451030181001	VENTOLIN HFA	34.76	18569.059372
102591050021	102591050021001	Proventil HFA	43.16	6529.909545
102591050021	102591050021002	Proventil HFA	43.16	6529.909545
102781020131	102781020131001	SYMBICORT	196.79	12143.586784
102781020131	102781020131002	SYMBICORT	196.79	12143.586784
102781020131	102781020131003	SYMBICORT	196.79	12143.586784
102781020161	102781020161001	Albuterol	0.15	12143.586784
102781020171	102781020171001	AZITHROMYCIN	10.00	12143.586784
102781020181	102781020181001	METOPROLOL TART	4.00	12143.586784
102991060031	102991060031001	PREDNISOLONE	13.00	7322.175449
102991060041	102991060041001	THERA-M	6.50	7322.175449
102991060051	102991060051001	ED-A-HIST DM	5.00	7322.175449
102991060071	102991060071001	PREDNISONE	11.99	7322.175449
102991060081	102991060081001	DEX-TUSS	15.00	7322.175449
103051020091	103051020091001	Advair Diskus	197.47	4878.457322
103051020091	103051020091002	Advair Diskus	197.47	4878.457322
103101010201	103101010201001	Albuterol Sulfate	19.45	8742.529512
103101010201	103101010201002	Albuterol Sulfate	19.45	8742.529512
103101010201	103101010201003	Albuterol Sulfate	19.45	8742.529512
103101010201	103101010201004	Albuterol Sulfate	19.45	8742.529512
103101010201	103101010201005	Albuterol Sulfate	19.45	8742.529512
103101010201	103101010201006	Albuterol Sulfate	19.45	8742.529512
103101010201	103101010201007	Albuterol Sulfate	19.45	8742.529512
103101010201	103101010201008	Albuterol Sulfate	19.45	8742.529512
103101010281	103101010281001	Mometasone Furoate	29.08	8742.529512
103101010281	103101010281002	Mometasone Furoate	46.76	8742.529512
103311010051	103311010051001	PREDNISONE	8.80	5457.718057
103331010011	103331010011001	ADVAIR DISKU	169.00	10257.343898
103331010031	103331010031001	ADVAIR DISKU	169.00	10257.343898
103371010211	103371010211001	ADVAIR DISKU	60.00	5401.221154
103371010211	103371010211002	ADVAIR DISKU	60.00	5401.221154
103371010211	103371010211003	ADVAIR DISKU	60.00	5401.221154
103371010211	103371010211004	ADVAIR DISKU	144.00	5401.221154
103371010211	103371010211005	ADVAIR DISKU	144.00	5401.221154
103371010211	103371010211006	ADVAIR DISKU	144.00	5401.221154
103371010211	103371010211007	ADVAIR DISKU	144.00	5401.221154
103371010331	103371010331001	ADVAIR DISKU	144.00	5401.221154
103371010331	103371010331002	ADVAIR DISKU	144.00	5401.221154
103371010331	103371010331003	ADVAIR DISKU	144.00	5401.221154
103371010331	103371010331004	ADVAIR DISKU	144.00	5401.221154
103581010061	103581010061001	Albuterol	21.42	5132.990088
103581010061	103581010061002	Albuterol	21.42	5132.990088
103581010071	103581010071001	PROAIR HFA	37.66	5132.990088
103581010291	103581010291001	Albuterol	1.19	5132.990088
103581010291	103581010291002	Albuterol	1.19	5132.990088
103581010291	103581010291003	Albuterol	1.19	5132.990088
103581010291	103581010291004	Albuterol	1.19	5132.990088
103581010291	103581010291005	Albuterol	1.19	5132.990088
103581010291	103581010291006	Albuterol	1.19	5132.990088
103581010301	103581010301001	PROAIR HFA	37.66	5132.990088
103581010301	103581010301002	PROAIR HFA	37.66	5132.990088
103581010301	103581010301003	PROAIR HFA	37.66	5132.990088
103581010301	103581010301004	PROAIR HFA	37.66	5132.990088
103581010301	103581010301005	PROAIR HFA	37.66	5132.990088
103581010301	103581010301006	PROAIR HFA	37.66	5132.990088
103581010631	103581010631001	QVAR	62.93	5132.990088
103581010631	103581010631002	QVAR	62.93	5132.990088
103581010661	103581010661001	Albuterol	21.42	5132.990088
103581010661	103581010661002	Albuterol	21.42	5132.990088
103581010661	103581010661003	Albuterol	21.42	5132.990088
103581010661	103581010661004	Albuterol	21.42	5132.990088
103861010251	103861010251001	ALLEGRA	62.28	11629.199486
103861010251	103861010251002	ALLEGRA	62.28	11629.199486
103861010251	103861010251003	ALLEGRA	62.28	11629.199486
103861010251	103861010251004	ALLEGRA	62.28	11629.199486
103921030301	103921030301001	SINGULAIR	131.00	5614.573780
103921030301	103921030301002	SINGULAIR	131.00	5614.573780
103921030301	103921030301003	SINGULAIR	131.00	5614.573780
103921030301	103921030301004	SINGULAIR	96.00	5614.573780
103921030301	103921030301005	SINGULAIR	96.00	5614.573780
103921030301	103921030301006	SINGULAIR	96.00	5614.573780
103921030311	103921030311001	DEHISTINE	10.00	5614.573780
103921030311	103921030311002	DEHISTINE	10.00	5614.573780
103921030311	103921030311003	DEHISTINE	10.00	5614.573780
103921030311	103921030311004	DEHISTINE	10.00	5614.573780
103921030311	103921030311005	DEHISTINE	10.00	5614.573780
103921030311	103921030311006	DEHISTINE	10.00	5614.573780
104011010031	104011010031001	Albuterol So4 (CFC-F) Oral	43.60	5825.587735
104011010151	104011010151001	Albuterol So4 (CFC-F) Oral	43.60	5825.587735
104011010151	104011010151002	Albuterol So4 (CFC-F) Oral	43.60	5825.587735
104011010151	104011010151003	Albuterol So4 (CFC-F) Oral	43.60	5825.587735
104011010251	104011010251001	Albuterol So4 (CFC-F) Oral	43.60	5825.587735
104011010251	104011010251002	Albuterol So4 (CFC-F) Oral	43.60	5825.587735
104011010251	104011010251003	Albuterol So4 (CFC-F) Oral	43.60	5825.587735
104011010251	104011010251004	Albuterol So4 (CFC-F) Oral	43.60	5825.587735
104251010111	104251010111001	PREDNISONE	4.00	28225.544125
104251010111	104251010111002	PREDNISONE	4.27	28225.544125
104251010121	104251010121001	ALBUTEROL	47.79	28225.544125
104251010121	104251010121002	ALBUTEROL	47.79	28225.544125
104251010121	104251010121003	ALBUTEROL	47.79	28225.544125
104251010121	104251010121004	ALBUTEROL	47.79	28225.544125
104251010131	104251010131001	LEVAQUIN	189.79	28225.544125
104511010021	104511010021001	Advair Diskus	197.47	16835.579968
104511010111	104511010111001	Advair Diskus	283.51	16835.579968
104511010111	104511010111002	Advair Diskus	283.51	16835.579968
104511010191	104511010191001	Advair Diskus	283.51	16835.579968
104511010191	104511010191002	Advair Diskus	283.51	16835.579968
104511010191	104511010191003	Advair Diskus	283.51	16835.579968
104511010191	104511010191004	Advair Diskus	283.51	16835.579968
104601040031	104601040031001	Albuterol HFA	1.27	9565.906815
104601050331	104601050331001	FLUCONAZOLE	8.00	15974.771412
104841010051	104841010051001	SYMBICORT	196.00	21302.144846
104841010051	104841010051002	SYMBICORT	196.00	21302.144846
104841010051	104841010051003	SYMBICORT	196.00	21302.144846
104841010061	104841010061001	PROAIR HFA	38.00	21302.144846
104841010061	104841010061002	PROAIR HFA	38.00	21302.144846
104841010061	104841010061003	PROAIR HFA	38.00	21302.144846
104841010071	104841010071001	SINGULAIR	125.00	21302.144846
104841010071	104841010071002	SINGULAIR	125.00	21302.144846
104841010071	104841010071003	SINGULAIR	130.00	21302.144846
104841010151	104841010151001	PREDNISONE	2.00	21302.144846
104841010151	104841010151002	PREDNISONE	2.00	21302.144846
104841010151	104841010151003	PREDNISONE	2.00	21302.144846
104841010151	104841010151004	PREDNISONE	2.00	21302.144846
104841010151	104841010151005	PREDNISONE	2.00	21302.144846
104841010151	104841010151006	PREDNISONE	2.00	21302.144846
104841010191	104841010191001	SYMBICORT	196.00	21302.144846
104841010191	104841010191002	SYMBICORT	196.00	21302.144846
104841010191	104841010191003	SYMBICORT	196.00	21302.144846
104841010191	104841010191004	SYMBICORT	196.00	21302.144846
104841010191	104841010191005	SYMBICORT	196.00	21302.144846
104841010191	104841010191006	SYMBICORT	196.00	21302.144846
104841010201	104841010201001	PROAIR HFA	38.00	21302.144846
104841010211	104841010211001	ALBUTEROL	43.00	21302.144846
104841010211	104841010211002	ALBUTEROL	43.00	21302.144846
104841010211	104841010211003	ALBUTEROL	43.00	21302.144846
104841010301	104841010301001	SYMBICORT	196.00	21302.144846
104841010301	104841010301002	SYMBICORT	196.00	21302.144846
104841010301	104841010301003	SYMBICORT	196.00	21302.144846
104841010301	104841010301004	SYMBICORT	196.00	21302.144846
104841010311	104841010311001	PROAIR HFA	38.00	21302.144846
104841010311	104841010311002	PROAIR HFA	38.00	21302.144846
104841010311	104841010311003	PROAIR HFA	38.00	21302.144846
104841010311	104841010311004	PROAIR HFA	38.00	21302.144846
104841010321	104841010321001	SINGULAIR	125.00	21302.144846
104841010321	104841010321002	SINGULAIR	125.00	21302.144846
104841010321	104841010321003	SINGULAIR	125.00	21302.144846
104841010321	104841010321004	SINGULAIR	125.00	21302.144846
104841010331	104841010331001	Albuterol HFA	1.27	21302.144846
104841010331	104841010331002	Albuterol HFA	1.27	21302.144846
104841010331	104841010331003	Albuterol	1.19	21302.144846
104911020031	104911020031001	VENTOLIN HFA	31.95	4101.910391
104911020041	104911020041001	QVAR	90.35	4101.910391
105071030021	105071030021001	VENTOLIN HFA	32.62	9722.976894
105071030021	105071030021002	VENTOLIN HFA	42.09	9722.976894
105071030101	105071030101001	VENTOLIN HFA	32.62	9722.976894
105071030151	105071030151001	VENTOLIN HFA	32.00	9722.976894
105101010181	105101010181001	ALBUTEROL	10.00	4661.361420
105191040021	105191040021001	FLOVENT HFA	97.87	11869.090160
105241020141	105241020141001	PREDNISONE	1.23	9332.386190
105241020141	105241020141002	PREDNISONE	1.23	9332.386190
105241020141	105241020141003	PREDNISONE	1.23	9332.386190
105241020191	105241020191001	SOD CHLORIDE	13.78	9332.386190
105241020191	105241020191002	SOD CHLORIDE	13.78	9332.386190
105241020191	105241020191003	SOD CHLORIDE	13.78	9332.386190
105241020211	105241020211001	ASMANEX 60	135.07	9332.386190
105241020211	105241020211002	ASMANEX 60	115.87	9332.386190
105241020211	105241020211003	ASMANEX 60	115.87	9332.386190
105241020571	105241020571001	SOD CHLORIDE	13.78	9332.386190
105241020571	105241020571002	SOD CHLORIDE	13.78	9332.386190
105241020571	105241020571003	SOD CHLORIDE	13.78	9332.386190
105241020571	105241020571004	SOD CHLORIDE	13.78	9332.386190
105241020571	105241020571005	SOD CHLORIDE	13.78	9332.386190
105241020571	105241020571006	SOD CHLORIDE	13.78	9332.386190

Return to Top

HC-135I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Analysis Variable: RXXP10X SUM OF PAYMENTS RXSF10X-RXOU10X(IMPUTED)

N	Sum
10115	1133276.08

Return to Top

HC-135I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
Analysis Variable: RXXP10X SUM OF PAYMENTS RXSF10X-RXOU10X(IMPUTED)

N	Sum
10115	12262768008

Return to Top

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
NOTE: This session is executing on the W32_VSPRO platform.

NOTE: SAS initialization used:
real time 1.31 seconds
cpu time 0.13 seconds

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

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

NOTE: AUTOEXEC processing completed.

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

NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds

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

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 (H137) records where cccodex=128";
43 run;

44
45 PROC SORT DATA=IN.H135IF1 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;

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.00 seconds
cpu time 0.00 seconds

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

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

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

NOTE: There were 128246 observations read from the data set IN.H135G.
NOTE: The data set WORK.MVIS has 124823 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 8.42 seconds
cpu time 0.17 seconds

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

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

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

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

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

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

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

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

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

117
118 ods rtf close;
119
120

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

Return to Top

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

Obs	CONDIDX	CCCODEX
1	100121010051	128
2	100171010021	128
3	100431010021	128
4	100431030011	128
5	100431040011	128
6	100441010031	128
7	100531020041	128
8	100531040011	128
9	100661010021	128
10	100671010071	128
11	100671020041	128
12	100861020041	128
13	101311020041	128
14	101371010051	128
15	101541020041	128
16	101831050011	128
17	101841020091	128
18	101981020061	128
19	101981030051	128
20	101981040031	128
21	101981050011	128
22	102061010011	128
23	102061040011	128
24	102291020011	128
25	102361030011	128
26	102361040011	128
27	102421010041	128
28	102442010032	128
29	102451010021	128
30	102451030011	128
31	102531020011	128
32	102591050011	128
33	102601010071	128
34	102691010111	128
35	102691020091	128
36	102692030012	128
37	102781020031	128
38	102891010051	128
39	102891020021	128
40	102991060011	128
41	103051020011	128
42	103101010031	128
43	103131010111	128
44	103311010051	128
45	103331010021	128
46	103371010011	128
47	103581010041	128
48	103691010021	128
49	103851030011	128
50	103851040011	128

Return to Top

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

CONDIDX	EVNTIDX	EVENTYPE
100121010051	100121010051	8 PMED
100121010051	100121010111	8 PMED
100121010051	100121010151	8 PMED
100171010021	100171010091	8 PMED
100171010021	100171010161	8 PMED
100171010021	100171010181	1 MVIS
100431010021	100431010121	8 PMED
100431030011	100431030011	1 MVIS
100431030011	100431030021	8 PMED
100431030011	100431030031	8 PMED
100431030011	100431030051	8 PMED
100431030011	100431030071	1 MVIS
100431030011	100431030091	8 PMED
100431030011	100431030101	8 PMED
100431030011	100431030111	8 PMED
100431030011	100431030121	8 PMED
100431030011	100431030171	8 PMED
100431040011	100431040011	1 MVIS
100431040011	100431040021	1 MVIS
100431040011	100431040031	8 PMED
100431040011	100431040041	8 PMED
100431040011	100431040051	8 PMED
100431040011	100431040061	8 PMED
100431040011	100431040071	8 PMED
100431040011	100431040081	8 PMED
100431040011	100431040091	1 MVIS
100431040011	100431040101	1 MVIS
100431040011	100431040111	1 MVIS
100431040011	100431040131	8 PMED
100431040011	100431040141	8 PMED
100431040011	100431040151	8 PMED
100431040011	100431040161	8 PMED
100431040011	100431040171	1 MVIS
100431040011	100431040201	1 MVIS
100431040011	100431040211	1 MVIS
100431040011	100431040231	8 PMED
100431040011	100431040241	8 PMED
100431040011	100431040251	8 PMED
100431040011	100431040271	8 PMED
100441010031	100441010031	2 OPAT
100441010031	100441010091	8 PMED
100441010031	100441010101	8 PMED
100441010031	100441010111	8 PMED
100531020041	100531020361	8 PMED
100531040011	100531040021	8 PMED
100661010021	100661010021	8 PMED
100661010021	100661010041	8 PMED
100671010071	100671010171	8 PMED
100671010071	100671010181	8 PMED
100671010071	100671010191	8 PMED
100671010071	100671010401	8 PMED
100671010071	100671010411	8 PMED
100671010071	100671010421	8 PMED
100671010071	100671010511	8 PMED
100671010071	100671010521	8 PMED
100671010071	100671010531	8 PMED
100671020041	100671020371	8 PMED
100671020041	100671020411	8 PMED
100861020041	100861020011	1 MVIS
100861020041	100861020031	8 PMED
100861020041	100861020091	8 PMED
100861020041	100861020101	8 PMED
100861020041	100861020111	1 MVIS
100861020041	100861020141	8 PMED
100861020041	100861020151	8 PMED
101371010051	101371010261	1 MVIS
101371010051	101371010341	8 PMED
101371010051	101371010381	8 PMED
101541020041	101541020011	1 MVIS
101841020091	101841020381	8 PMED
101841020091	101841020401	2 OPAT
102061010011	102061010071	8 PMED
102061040011	102061040011	1 MVIS
102061040011	102061040021	1 MVIS
102061040011	102061040031	3 EROM

Return to Top

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

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	100121010051	100121010051	8 PMED
2	100121010051	100121010111	8 PMED
3	100121010051	100121010151	8 PMED
4	100171010021	100171010091	8 PMED
5	100171010021	100171010161	8 PMED
6	100171010021	100171010181	1 MVIS
7	100431010021	100431010121	8 PMED
8	100431030011	100431030011	1 MVIS
9	100431030011	100431030021	8 PMED
10	100431030011	100431030031	8 PMED
11	100431030011	100431030051	8 PMED
12	100431030011	100431030071	1 MVIS
13	100431030011	100431030091	8 PMED
14	100431030011	100431030101	8 PMED
15	100431030011	100431030111	8 PMED
16	100431030011	100431030121	8 PMED
17	100431030011	100431030171	8 PMED
18	100431040011	100431040011	1 MVIS
19	100431040011	100431040021	1 MVIS
20	100431040011	100431040031	8 PMED
21	100431040011	100431040041	8 PMED
22	100431040011	100431040051	8 PMED
23	100431040011	100431040061	8 PMED
24	100431040011	100431040071	8 PMED
25	100431040011	100431040081	8 PMED
26	100431040011	100431040091	1 MVIS
27	100431040011	100431040101	1 MVIS
28	100431040011	100431040111	1 MVIS
29	100431040011	100431040131	8 PMED
30	100431040011	100431040141	8 PMED
31	100431040011	100431040151	8 PMED
32	100431040011	100431040161	8 PMED
33	100431040011	100431040171	1 MVIS
34	100431040011	100431040201	1 MVIS
35	100431040011	100431040211	1 MVIS
36	100431040011	100431040231	8 PMED
37	100431040011	100431040241	8 PMED
38	100431040011	100431040251	8 PMED
39	100431040011	100431040271	8 PMED
40	100441010031	100441010031	2 OPAT
41	100441010031	100441010091	8 PMED
42	100441010031	100441010101	8 PMED
43	100441010031	100441010111	8 PMED
44	100531020041	100531020361	8 PMED
45	100531040011	100531040021	8 PMED
46	100661010021	100661010021	8 PMED
47	100661010021	100661010041	8 PMED
48	100671010071	100671010171	8 PMED
49	100671010071	100671010181	8 PMED
50	100671010071	100671010191	8 PMED

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	100121010051	8 PMED
2	100121010111	8 PMED
3	100121010151	8 PMED
4	100171010091	8 PMED
5	100171010161	8 PMED
6	100171010181	1 MVIS
7	100431010121	8 PMED
8	100431030011	1 MVIS
9	100431030021	8 PMED
10	100431030031	8 PMED
11	100431030051	8 PMED
12	100431030071	1 MVIS
13	100431030091	8 PMED
14	100431030101	8 PMED
15	100431030111	8 PMED
16	100431030121	8 PMED
17	100431030171	8 PMED
18	100431040011	1 MVIS
19	100431040021	1 MVIS
20	100431040031	8 PMED
21	100431040041	8 PMED
22	100431040051	8 PMED
23	100431040061	8 PMED
24	100431040071	8 PMED
25	100431040081	8 PMED
26	100431040091	1 MVIS
27	100431040101	1 MVIS
28	100431040111	1 MVIS
29	100431040131	8 PMED
30	100431040141	8 PMED
31	100431040151	8 PMED
32	100431040161	8 PMED
33	100431040171	1 MVIS
34	100431040201	1 MVIS
35	100431040211	1 MVIS
36	100431040231	8 PMED
37	100431040241	8 PMED
38	100431040251	8 PMED
39	100431040271	8 PMED
40	100441010031	2 OPAT
41	100441010091	8 PMED
42	100441010101	8 PMED
43	100441010111	8 PMED
44	100531020361	8 PMED
45	100531040021	8 PMED
46	100661010021	8 PMED
47	100661010041	8 PMED
48	100671010171	8 PMED
49	100671010181	8 PMED
50	100671010191	8 PMED

Return to Top

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

Obs	EVNTIDX	EVENTYPE	SEETLKPV	OBXP10X	PERWT10F
1	100171010181	1 MVIS	1	75.00	8879.04
2	100431030011	1 MVIS	1	95.81	13273.14
3	100431030071	1 MVIS	1	95.81	13273.14
4	100431040011	1 MVIS	1	98.61	24678.50
5	100431040021	1 MVIS	1	96.94	24678.50
6	100431040091	1 MVIS	1	77.61	24678.50
7	100431040101	1 MVIS	1	98.64	24678.50
8	100431040111	1 MVIS	1	95.81	24678.50
9	100431040171	1 MVIS	1	120.46	24678.50
10	100431040201	1 MVIS	1	98.61	24678.50
11	100431040211	1 MVIS	1	95.81	24678.50
12	100861020011	1 MVIS	1	72.97	4351.17
13	100861020111	1 MVIS	1	72.97	4351.17
14	101371010261	1 MVIS	1	54.28	3246.39
15	101541020011	1 MVIS	1	75.00	6213.90
16	102061040011	1 MVIS	1	90.92	9038.83
17	102061040021	1 MVIS	1	75.78	9038.83
18	102291020061	1 MVIS	1	77.69	10983.99
19	102451010081	1 MVIS	1	98.64	16538.63
20	102451030011	1 MVIS	1	63.85	18569.06
21	102531020051	1 MVIS	1	110.74	25782.76
22	102601010131	1 MVIS	1	35.00	10351.48
23	102601010141	1 MVIS	1	14.71	10351.48
24	102601010151	1 MVIS	1	26.00	10351.48
25	102601010161	1 MVIS	1	26.00	10351.48
26	102691010101	1 MVIS	1	371.64	6355.08
27	102781020141	1 MVIS	1	61.73	12143.59
28	102781020151	1 MVIS	1	61.73	12143.59
29	102991060021	1 MVIS	1	128.00	7322.18
30	103051020041	1 MVIS	1	5.79	4878.46
31	103051020051	1 MVIS	1	5.79	4878.46
32	103051020061	1 MVIS	1	79.75	4878.46
33	103051020131	1 MVIS	1	37.64	4878.46
34	103581010011	1 MVIS	1	75.00	5132.99
35	103581010561	1 MVIS	1	464.00	5132.99
36	103581010571	1 MVIS	1	464.00	5132.99
37	103581010581	1 MVIS	1	68.00	5132.99
38	103921030071	1 MVIS	1	10.00	5614.57
39	103921030081	1 MVIS	1	10.00	5614.57
40	103921030091	1 MVIS	1	10.00	5614.57
41	103921030101	1 MVIS	1	51.98	5614.57
42	103921030111	1 MVIS	1	10.00	5614.57
43	103921030121	1 MVIS	1	10.00	5614.57
44	103921030131	1 MVIS	1	77.53	5614.57
45	103921030141	1 MVIS	1	10.00	5614.57
46	103921030151	1 MVIS	1	10.00	5614.57
47	103921030161	1 MVIS	1	10.00	5614.57
48	103921030171	1 MVIS	1	10.00	5614.57
49	103921030181	1 MVIS	1	76.24	5614.57
50	103921030191	1 MVIS	1	10.00	5614.57

Return to Top

HC-135I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Analysis Variable: OBXP10X SUM OF OBSF10X - OBOT10X (IMPUTED)

N	Sum
1879	276362.08

Return to Top

HC-135I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
Analysis Variable: OBXP10X SUM OF OBSF10X - OBOT10X (IMPUTED)

N	Sum
1879	3084914239

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