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

Font Size:

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

The SAS System

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

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

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

NOTE: AUTOEXEC processing completed.

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

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

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

NOTE: There were 117342 observations read from the data set IN.H128.
NOTE: The data set WORK.ASCONDS has 2420 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 5.40 seconds
cpu time 0.10 seconds

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

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

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

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

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

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

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

NOTE: There were 342044 observations read from the data set WORK.CLNK.
NOTE: There were 2420 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7669 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 1.09 seconds
cpu time 0.07 seconds

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

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

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

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

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

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

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

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

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

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

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

NOTE: There were 154599 observations read from the data set IN.H126G.
NOTE: The data set WORK.MVIS has 149890 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 16.81 seconds
cpu time 0.26 seconds

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

NOTE: There were 333629 observations read from the data set WORK.PMED.
NOTE: There were 2160 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.MVPMEDS has 5649 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 1.25 seconds
cpu time 0.10 seconds

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

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

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

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

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

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

186
187 ods rtf close;
188

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

Return to Top

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

Obs	CONDIDX	CCCODEX
1	400011010011	128
2	400011030011	128
3	400441010101	128
4	400501010021	128
5	400521010101	128
6	400841010091	128
7	400881020041	128
8	401051050011	128
9	401481020061	128
10	401601010041	128
11	401901010031	128
12	401911030011	128
13	402121010021	128
14	402121020011	128
15	402151010011	128
16	402151020041	128
17	402151030011	128
18	402271010011	128
19	402331020051	128
20	402361020011	128
21	402451030011	128
22	402841010081	128
23	403491040011	128
24	403601030011	128
25	403691020021	128
26	403691050021	128
27	403691060011	128
28	403701020061	128
29	403701020161	128
30	403751020061	128
31	403761020041	128
32	403831010041	128
33	403851020041	128
34	403881010081	128
35	403881020011	128
36	404001010031	128
37	404062010022	128
38	404122010032	128
39	404381030011	128
40	404401020041	128
41	404561010031	128
42	404581020011	128
43	404701010031	128
44	404891010031	128
45	405021050011	128
46	405021060011	128
47	405041010011	128
48	405191020011	128
49	405311040011	128
50	405391030011	128

Return to Top

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

CONDIDX	EVNTIDX	EVENTYPE
400011010011	400011010061	8 PMED
400011010011	400011010101	8 PMED
400011030011	400011030081	8 PMED
400441010101	400441010411	8 PMED
400501010021	400501010011	8 PMED
400501010021	400501010051	8 PMED
400501010021	400501010091	8 PMED
400501010021	400501010121	8 PMED
400521010101	400521010031	1 MVIS
400521010101	400521010041	1 MVIS
400521010101	400521010131	8 PMED
400881020041	400881020021	1 MVIS
400881020041	400881020031	1 MVIS
400881020041	400881020041	1 MVIS
400881020041	400881020051	8 PMED
400881020041	400881020061	8 PMED
400881020041	400881020071	8 PMED
400881020041	400881020081	8 PMED
400881020041	400881020091	1 MVIS
400881020041	400881020101	1 MVIS
400881020041	400881020111	8 PMED
401051050011	401051050011	8 PMED
401051050011	401051050031	8 PMED
401601010041	401601010281	8 PMED
401601010041	401601010311	8 PMED
401601010041	401601010321	1 MVIS
401601010041	401601010331	1 MVIS
401601010041	401601010341	1 MVIS
401601010041	401601010471	8 PMED
401911030011	401911030011	1 MVIS
401911030011	401911030021	1 MVIS
401911030011	401911030031	1 MVIS
401911030011	401911030041	1 MVIS
401911030011	401911030051	1 MVIS
401911030011	401911030091	8 PMED
401911030011	401911030131	1 MVIS
401911030011	401911030141	8 PMED
402121020011	402121020011	3 EROM
402121020011	402121020041	8 PMED
402121020011	402121020051	8 PMED
402121020011	402121020061	8 PMED
402151010011	402151010041	8 PMED
402151010011	402151010061	8 PMED
402151030011	402151030051	8 PMED
402331020051	402331020241	8 PMED
402361020011	402361020021	8 PMED
402841010081	402841010291	8 PMED
403491040011	403491040041	8 PMED
403491040011	403491040051	8 PMED
403491040011	403491040061	1 MVIS
403491040011	403491040091	8 PMED
403491040011	403491040111	8 PMED
403491040011	403491040121	8 PMED
403601030011	403601030111	8 PMED
403601030011	403601030121	8 PMED
403601030011	403601030131	8 PMED
403601030011	403601030141	8 PMED
403691020021	403691020041	1 MVIS
403691020021	403691020051	1 MVIS
403691020021	403691020061	1 MVIS
403691020021	403691020071	1 MVIS
403691020021	403691020081	1 MVIS
403691020021	403691020091	1 MVIS
403691020021	403691020101	1 MVIS
403691020021	403691020111	1 MVIS
403691050021	403691050041	1 MVIS
403691050021	403691050051	1 MVIS
403691060011	403691060011	1 MVIS
403691060011	403691060041	8 PMED
403701020061	403701020141	8 PMED
403701020061	403701020161	8 PMED
403701020061	403701020291	8 PMED
403701020061	403701020311	8 PMED
403701020061	403701020351	8 PMED
403751020061	403751020111	8 PMED

Return to Top

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

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	400011010011	400011010061	8 PMED
2	400011010011	400011010101	8 PMED
3	400011030011	400011030081	8 PMED
4	400441010101	400441010411	8 PMED
5	400501010021	400501010011	8 PMED
6	400501010021	400501010051	8 PMED
7	400501010021	400501010091	8 PMED
8	400501010021	400501010121	8 PMED
9	400521010101	400521010031	1 MVIS
10	400521010101	400521010041	1 MVIS
11	400521010101	400521010131	8 PMED
12	400881020041	400881020021	1 MVIS
13	400881020041	400881020031	1 MVIS
14	400881020041	400881020041	1 MVIS
15	400881020041	400881020051	8 PMED
16	400881020041	400881020061	8 PMED
17	400881020041	400881020071	8 PMED
18	400881020041	400881020081	8 PMED
19	400881020041	400881020091	1 MVIS
20	400881020041	400881020101	1 MVIS
21	400881020041	400881020111	8 PMED
22	401051050011	401051050011	8 PMED
23	401051050011	401051050031	8 PMED
24	401601010041	401601010281	8 PMED
25	401601010041	401601010311	8 PMED
26	401601010041	401601010321	1 MVIS
27	401601010041	401601010331	1 MVIS
28	401601010041	401601010341	1 MVIS
29	401601010041	401601010471	8 PMED
30	401911030011	401911030011	1 MVIS
31	401911030011	401911030021	1 MVIS
32	401911030011	401911030031	1 MVIS
33	401911030011	401911030041	1 MVIS
34	401911030011	401911030051	1 MVIS
35	401911030011	401911030091	8 PMED
36	401911030011	401911030131	1 MVIS
37	401911030011	401911030141	8 PMED
38	402121020011	402121020011	3 EROM
39	402121020011	402121020041	8 PMED
40	402121020011	402121020051	8 PMED
41	402121020011	402121020061	8 PMED
42	402151010011	402151010041	8 PMED
43	402151010011	402151010061	8 PMED
44	402151030011	402151030051	8 PMED
45	402331020051	402331020241	8 PMED
46	402361020011	402361020021	8 PMED
47	402841010081	402841010291	8 PMED
48	403491040011	403491040041	8 PMED
49	403491040011	403491040051	8 PMED
50	403491040011	403491040061	1 MVIS

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	400011010061	8 PMED
2	400011010101	8 PMED
3	400011030081	8 PMED
4	400441010411	8 PMED
5	400501010011	8 PMED
6	400501010051	8 PMED
7	400501010091	8 PMED
8	400501010121	8 PMED
9	400521010031	1 MVIS
10	400521010041	1 MVIS
11	400521010131	8 PMED
12	400881020021	1 MVIS
13	400881020031	1 MVIS
14	400881020041	1 MVIS
15	400881020051	8 PMED
16	400881020061	8 PMED
17	400881020071	8 PMED
18	400881020081	8 PMED
19	400881020091	1 MVIS
20	400881020101	1 MVIS
21	400881020111	8 PMED
22	401051050011	8 PMED
23	401051050031	8 PMED
24	401601010281	8 PMED
25	401601010311	8 PMED
26	401601010321	1 MVIS
27	401601010331	1 MVIS
28	401601010341	1 MVIS
29	401601010471	8 PMED
30	401911030011	1 MVIS
31	401911030021	1 MVIS
32	401911030031	1 MVIS
33	401911030041	1 MVIS
34	401911030051	1 MVIS
35	401911030091	8 PMED
36	401911030131	1 MVIS
37	401911030141	8 PMED
38	402121020011	3 EROM
39	402121020041	8 PMED
40	402121020051	8 PMED
41	402121020061	8 PMED
42	402151010041	8 PMED
43	402151010061	8 PMED
44	402151030051	8 PMED
45	402331020241	8 PMED
46	402361020021	8 PMED
47	402841010291	8 PMED
48	403491040041	8 PMED
49	403491040051	8 PMED
50	403491040061	1 MVIS

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	400521010031	1 MVIS
2	400521010041	1 MVIS
3	400881020021	1 MVIS
4	400881020031	1 MVIS
5	400881020041	1 MVIS
6	400881020091	1 MVIS
7	400881020101	1 MVIS
8	401601010321	1 MVIS
9	401601010331	1 MVIS
10	401601010341	1 MVIS
11	401911030011	1 MVIS
12	401911030021	1 MVIS
13	401911030031	1 MVIS
14	401911030041	1 MVIS
15	401911030051	1 MVIS
16	401911030131	1 MVIS
17	403491040061	1 MVIS
18	403691020041	1 MVIS
19	403691020051	1 MVIS
20	403691020061	1 MVIS
21	403691020071	1 MVIS
22	403691020081	1 MVIS
23	403691020091	1 MVIS
24	403691020101	1 MVIS
25	403691020111	1 MVIS
26	403691050041	1 MVIS
27	403691050051	1 MVIS
28	403691060011	1 MVIS
29	403751020221	1 MVIS
30	403751020251	1 MVIS
31	403751020261	1 MVIS
32	403751020461	1 MVIS
33	403751020471	1 MVIS
34	403761020011	1 MVIS
35	403761020021	1 MVIS
36	403761020031	1 MVIS
37	403761020181	1 MVIS
38	403761020191	1 MVIS
39	403761020201	1 MVIS
40	403761020211	1 MVIS
41	403761020451	1 MVIS
42	404001010011	1 MVIS
43	404381030071	1 MVIS
44	404381030081	1 MVIS
45	404381030091	1 MVIS
46	404381030101	1 MVIS
47	404401020211	1 MVIS
48	404401020491	1 MVIS
49	404401020541	1 MVIS
50	404561010261	1 MVIS

Return to Top

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

EVNTIDX	LINKIDX	EVENTYPE
400011010041	400011010051	1 MVIS
400011010071	400011010091	1 MVIS
400011020051	400011020061	1 MVIS
400011020101	400011020151	1 MVIS
400011020131	400011020161	1 MVIS
400011020131	400011020171	1 MVIS
400011030031	400011030071	1 MVIS
400011030091	400011030151	1 MVIS
400011030091	400011030161	1 MVIS
400011030111	400011030171	1 MVIS
400011030201	400011030251	1 MVIS
400011030231	400011030261	1 MVIS
400031010011	400031010021	5 DVIS
400051020011	400051020051	1 MVIS
400051020011	400051020061	1 MVIS
400051020011	400051020071	1 MVIS
400051020011	400051020081	1 MVIS
400061010011	400061010051	5 DVIS
400061010031	400061010061	1 MVIS
400061010031	400061010071	1 MVIS
400061010091	400061010101	1 MVIS
400061010091	400061010111	1 MVIS
400061020011	400061020041	5 DVIS
400061020021	400061020051	5 DVIS
400061020031	400061020061	1 MVIS
400061020031	400061020071	1 MVIS
400061020101	400061020111	1 MVIS
400061040051	400061040041	1 MVIS
400101010011	400101010071	1 MVIS
400101010091	400101010161	1 MVIS
400101020011	400101020061	4 STAZ
400101030011	400101030051	1 MVIS
400101030011	400101030061	1 MVIS
400101030011	400101030071	1 MVIS
400101030021	400101030051	1 MVIS
400101030031	400101030061	1 MVIS
400101030041	400101030061	1 MVIS
400101030081	400101030091	1 MVIS
400111020251	400111020281	1 MVIS
400121010011	400121010021	1 MVIS
400141010021	400141010031	1 MVIS
400141040011	400141040021	3 EROM
400151010011	400151010061	4 STAZ
400151020051	400151020071	1 MVIS
400151020051	400151020081	1 MVIS
400151020051	400151020091	1 MVIS
400151020061	400151020101	1 MVIS
400171010041	400171010091	1 MVIS
400171010081	400171010101	3 EROM
400171010081	400171010111	3 EROM
400171010081	400171010121	3 EROM
400171010141	400171010151	1 MVIS
400171020011	400171020041	1 MVIS
400171020021	400171020041	1 MVIS
400171020031	400171020041	1 MVIS
400171020051	400171020081	1 MVIS
400171030031	400171030061	1 MVIS
400171030071	400171030111	1 MVIS
400211010011	400211010061	3 EROM
400211010101	400211010121	1 MVIS
400211030031	400211030061	3 EROM
400211030041	400211030071	1 MVIS
400211030051	400211030081	1 MVIS
400211050021	400211050031	1 MVIS
400211060011	400211060051	1 MVIS
400211060071	400211060061	3 EROM
400211070011	400211070021	3 EROM
400211070061	400211070081	1 MVIS
400211070061	400211070091	1 MVIS
400231010011	400231010041	3 EROM
400231010021	400231010041	4 STAZ
400231030091	400231030161	4 STAZ
400241010031	400241010071	1 MVIS
400241010031	400241010081	1 MVIS
400241010091	400241010131	1 MVIS
400241010091	400241010141	1 MVIS
400241010091	400241010151	1 MVIS
400241020021	400241020041	1 MVIS
400251010011	400251010021	2 OPAT
400251010011	400251010031	2 OPAT
400251010011	400251010041	2 OPAT
400281010121	400281010131	4 STAZ
400281050011	400281050021	1 MVIS
400281050031	400281050041	1 MVIS
400281060011	400281060021	1 MVIS
400281060011	400281060031	1 MVIS
400281060011	400281060041	1 MVIS
400281060051	400281060081	1 MVIS
400281060051	400281060101	1 MVIS
400281060071	400281060091	1 MVIS
400291010031	400291010051	1 MVIS
400291010041	400291010061	1 MVIS
400291030011	400291030041	1 MVIS
400291030021	400291030051	1 MVIS
400291030031	400291030061	1 MVIS
400291030071	400291030131	1 MVIS
400291040041	400291040081	1 MVIS
400291040051	400291040091	1 MVIS
400291040061	400291040101	1 MVIS
400311040011	400311040051	1 MVIS
400311040011	400311040061	1 MVIS
400311040021	400311040071	1 MVIS
400311040021	400311040081	1 MVIS
400311040021	400311040091	1 MVIS
400311040021	400311040101	1 MVIS
400311040021	400311040111	1 MVIS
400311040021	400311040121	1 MVIS
400311040021	400311040131	1 MVIS
400311040021	400311040141	1 MVIS
400311040021	400311040151	1 MVIS
400311040021	400311040161	1 MVIS
400311040021	400311040171	1 MVIS
400311040031	400311040181	1 MVIS
400311050021	400311050041	1 MVIS
400311050021	400311050051	1 MVIS
400311050021	400311050061	1 MVIS
400311050021	400311050071	1 MVIS
400311050021	400311050081	1 MVIS
400311050021	400311050091	1 MVIS
400311050021	400311050101	1 MVIS
400311050021	400311050111	1 MVIS
400351010031	400351010081	1 MVIS
400351010031	400351010091	1 MVIS
400361010011	400361010021	5 DVIS
400361010031	400361010061	5 DVIS
400361010031	400361010071	5 DVIS
400371010011	400371010021	4 STAZ
400371010011	400371010031	4 STAZ
400371010091	400371010131	1 MVIS
400371010091	400371010141	1 MVIS
400371010091	400371010151	1 MVIS
400371010091	400371010161	1 MVIS
400381010071	400381010111	1 MVIS
400381010071	400381010121	1 MVIS
400381010071	400381010131	1 MVIS
400381010141	400381010171	1 MVIS
400381010141	400381010181	1 MVIS
400391010041	400391010121	1 MVIS
400391010041	400391010131	1 MVIS
400391010151	400391010201	1 MVIS

Return to Top

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

EVNTIDX	LINKIDX	EVENTYPE
400881020021	400881020061	1 MVIS
400881020021	400881020071	1 MVIS
400881020021	400881020081	1 MVIS
400881020091	400881020111	1 MVIS
401601010321	401601010441	1 MVIS
401601010321	401601010451	1 MVIS
401601010321	401601010471	1 MVIS
401601010321	401601010491	1 MVIS
401911030131	401911030141	1 MVIS
401911030131	401911030151	1 MVIS
403691020041	403691020131	1 MVIS
403691020041	403691020141	1 MVIS
403691020101	403691020151	1 MVIS
403691020101	403691020161	1 MVIS
403691050041	403691050061	1 MVIS
403691050051	403691050071	1 MVIS
403691060011	403691060031	1 MVIS
403691060011	403691060041	1 MVIS
403761020011	403761020051	1 MVIS
403761020011	403761020061	1 MVIS
403761020011	403761020071	1 MVIS
403761020011	403761020081	1 MVIS
403761020011	403761020091	1 MVIS
403761020011	403761020101	1 MVIS
403761020011	403761020111	1 MVIS
403761020011	403761020121	1 MVIS
403761020011	403761020131	1 MVIS
403761020181	403761020261	1 MVIS
403761020181	403761020271	1 MVIS
403761020181	403761020281	1 MVIS
403761020181	403761020291	1 MVIS
403761020181	403761020301	1 MVIS
403761020181	403761020311	1 MVIS
403761020181	403761020321	1 MVIS
403761020181	403761020331	1 MVIS
403761020181	403761020341	1 MVIS
403761020181	403761020351	1 MVIS
403761020451	403761020541	1 MVIS
403761020451	403761020551	1 MVIS
403761020451	403761020561	1 MVIS
404001010011	404001010021	1 MVIS
405021050011	405021050051	1 MVIS
405021050011	405021050061	1 MVIS
405021050011	405021050071	1 MVIS
405021060011	405021060031	1 MVIS
405021060011	405021060041	1 MVIS
405021060011	405021060051	1 MVIS
405581010011	405581010031	1 MVIS
405581010011	405581010041	1 MVIS
405581010011	405581010051	1 MVIS

Return to Top

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

Obs	EVNTIDX	LINKIDX	EVENTYPE
1	400881020021	400881020061	1 MVIS
2	400881020021	400881020071	1 MVIS
3	400881020021	400881020081	1 MVIS
4	400881020091	400881020111	1 MVIS
5	401601010321	401601010441	1 MVIS
6	401601010321	401601010451	1 MVIS
7	401601010321	401601010471	1 MVIS
8	401601010321	401601010491	1 MVIS
9	401911030131	401911030141	1 MVIS
10	401911030131	401911030151	1 MVIS
11	403691020041	403691020131	1 MVIS
12	403691020041	403691020141	1 MVIS
13	403691020101	403691020151	1 MVIS
14	403691020101	403691020161	1 MVIS
15	403691050041	403691050061	1 MVIS
16	403691050051	403691050071	1 MVIS
17	403691060011	403691060031	1 MVIS
18	403691060011	403691060041	1 MVIS
19	403761020011	403761020051	1 MVIS
20	403761020011	403761020061	1 MVIS
21	403761020011	403761020071	1 MVIS
22	403761020011	403761020081	1 MVIS
23	403761020011	403761020091	1 MVIS
24	403761020011	403761020101	1 MVIS
25	403761020011	403761020111	1 MVIS
26	403761020011	403761020121	1 MVIS
27	403761020011	403761020131	1 MVIS
28	403761020181	403761020261	1 MVIS
29	403761020181	403761020271	1 MVIS
30	403761020181	403761020281	1 MVIS
31	403761020181	403761020291	1 MVIS
32	403761020181	403761020301	1 MVIS
33	403761020181	403761020311	1 MVIS
34	403761020181	403761020321	1 MVIS
35	403761020181	403761020331	1 MVIS
36	403761020181	403761020341	1 MVIS
37	403761020181	403761020351	1 MVIS
38	403761020451	403761020541	1 MVIS
39	403761020451	403761020551	1 MVIS
40	403761020451	403761020561	1 MVIS
41	404001010011	404001010021	1 MVIS
42	405021050011	405021050051	1 MVIS
43	405021050011	405021050061	1 MVIS
44	405021050011	405021050071	1 MVIS
45	405021060011	405021060031	1 MVIS
46	405021060011	405021060041	1 MVIS
47	405021060011	405021060051	1 MVIS
48	405581010011	405581010031	1 MVIS
49	405581010011	405581010041	1 MVIS
50	405581010011	405581010051	1 MVIS

Return to Top

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

Obs	LINKIDX
1	400881020061
2	400881020071
3	400881020081
4	400881020111
5	401601010441
6	401601010451
7	401601010471
8	401601010491
9	401911030141
10	401911030151
11	403691020131
12	403691020141
13	403691020151
14	403691020161
15	403691050061
16	403691050071
17	403691060031
18	403691060041
19	403761020051
20	403761020061
21	403761020071
22	403761020081
23	403761020091
24	403761020101
25	403761020111
26	403761020121
27	403761020131
28	403761020261
29	403761020271
30	403761020281
31	403761020291
32	403761020301
33	403761020311
34	403761020321
35	403761020331
36	403761020341
37	403761020351
38	403761020541
39	403761020551
40	403761020561
41	404001010021
42	405021050051
43	405021050061
44	405021050071
45	405021060031
46	405021060041
47	405021060051
48	405581010031
49	405581010041
50	405581010051

Return to Top

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

LINKIDX	RXRECIDX	RXNAME	RXXP09X	PERWT09F
400881020061	400881020061001	ACIPHEX	185.59	3579.012187
400881020061	400881020061002	ACIPHEX	185.59	3579.012187
400881020071	400881020071001	SYMBICORT	223.99	3579.012187
400881020071	400881020071002	SYMBICORT	248.69	3579.012187
400881020081	400881020081001	SPIRIVA HANDIHLR	175.00	3579.012187
400881020081	400881020081002	SPIRIVA HANDIHLR	175.00	3579.012187
400881020111	400881020111001	ACIPHEX	185.59	3579.012187
401601010441	401601010441001	METFORMIN HYDROCHLORIDE	12.39	2051.235697
401601010441	401601010441002	METFORMIN HYDROCHLORIDE	12.39	2051.235697
401601010441	401601010441003	METFORMIN HYDROCHLORIDE	12.39	2051.235697
401601010451	401601010451001	LEVOTHYROXINE SODIUM	15.44	2051.235697
401601010451	401601010451002	LEVOTHYROXINE SODIUM	15.44	2051.235697
401601010451	401601010451003	LEVOTHYROXINE SODIUM	15.44	2051.235697
401601010471	401601010471001	XOPENEX HFA	53.33	2051.235697
401601010491	401601010491001	HYDROCHLOROTHIAZIDE	8.65	2051.235697
401601010491	401601010491002	HYDROCHLOROTHIAZIDE	8.35	2051.235697
401601010491	401601010491003	HYDROCHLOROTHIAZIDE	8.35	2051.235697
401911030141	401911030141001	XOPENEX	91.00	5621.646638
401911030151	401911030151001	AMOXICILLIN	5.00	5621.646638
403691020131	403691020131001	PROVENTIL	81.55	8028.260022
403691020131	403691020131002	PROVENTIL	81.55	8028.260022
403691020131	403691020131003	PROVENTIL	81.55	8028.260022
403691020131	403691020131004	PROVENTIL	81.55	8028.260022
403691020131	403691020131005	PROVENTIL	81.55	8028.260022
403691020141	403691020141001	NASACORT AQ	89.74	8028.260022
403691020151	403691020151001	NASONEX	88.20	8028.260022
403691020151	403691020151002	NASONEX	88.20	8028.260022
403691020151	403691020151003	NASONEX	88.20	8028.260022
403691020151	403691020151004	NASONEX	88.20	8028.260022
403691020161	403691020161001	PROAIR HFA	36.93	8028.260022
403691020161	403691020161002	PROAIR HFA	36.93	8028.260022
403691020161	403691020161003	PROAIR HFA	36.93	8028.260022
403691020161	403691020161004	PROAIR HFA	36.93	8028.260022
403691020161	403691020161005	PROAIR HFA	37.15	8028.260022
403691020161	403691020161006	PROAIR HFA	37.15	8028.260022
403691050061	403691050061001	NUVARING	60.43	14473.972430
403691050061	403691050061002	NUVARING	60.43	14473.972430
403691050061	403691050061003	NUVARING	60.43	14473.972430
403691050061	403691050061004	NUVARING	60.43	14473.972430
403691050061	403691050061005	NUVARING	60.43	14473.972430
403691050061	403691050061006	NUVARING	60.43	14473.972430
403691050061	403691050061007	NUVARING	60.43	14473.972430
403691050061	403691050061008	NUVARING	60.43	14473.972430
403691050061	403691050061009	NUVARING	60.43	14473.972430
403691050061	403691050061010	NUVARING	60.43	14473.972430
403691050071	403691050071001	NASONEX	98.48	14473.972430
403691050071	403691050071002	NASONEX	98.48	14473.972430
403691050071	403691050071003	NASONEX	98.48	14473.972430
403691050071	403691050071004	NASONEX	98.48	14473.972430
403691060031	403691060031001	PROAIR HFA	37.11	12142.929000
403691060031	403691060031002	PROAIR HFA	37.11	12142.929000
403691060031	403691060031003	PROAIR HFA	37.11	12142.929000
403691060031	403691060031004	PROAIR HFA	37.11	12142.929000
403691060031	403691060031005	PROAIR HFA	37.11	12142.929000
403691060041	403691060041001	SYMBICORT	163.10	12142.929000
403691060041	403691060041002	SYMBICORT	163.10	12142.929000
403691060041	403691060041003	SYMBICORT	163.10	12142.929000
403761020051	403761020051001	ENALAPRIL MALEATE	29.99	10495.656139
403761020051	403761020051002	ENALAPRIL MALEATE	29.99	10495.656139
403761020051	403761020051003	ENALAPRIL MALEATE	29.99	10495.656139
403761020061	403761020061001	LOVASTATIN	195.99	10495.656139
403761020061	403761020061002	LOVASTATIN	195.99	10495.656139
403761020061	403761020061003	LOVASTATIN	69.99	10495.656139
403761020071	403761020071001	NEXIUM	195.99	10495.656139
403761020071	403761020071002	NEXIUM	195.99	10495.656139
403761020071	403761020071003	NEXIUM	195.99	10495.656139
403761020081	403761020081001	PREMARIN	66.99	10495.656139
403761020081	403761020081002	PREMARIN	66.99	10495.656139
403761020081	403761020081003	PREMARIN	66.99	10495.656139
403761020091	403761020091001	PREVACID	192.99	10495.656139
403761020091	403761020091002	PREVACID	192.99	10495.656139
403761020101	403761020101001	HYDROCHLOROTHIAZIDE	10.99	10495.656139
403761020101	403761020101002	HYDROCHLOROTHIAZIDE	10.99	10495.656139
403761020101	403761020101003	HYDROCHLOROTHIAZIDE	10.99	10495.656139
403761020111	403761020111001	CELEBREX	142.99	10495.656139
403761020111	403761020111002	CELEBREX	142.99	10495.656139
403761020111	403761020111003	CELEBREX	142.99	10495.656139
403761020121	403761020121001	FLUTICASONE PROPIONATE	25.66	10495.656139
403761020131	403761020131001	ADVAIR DISKUS	160.29	10495.656139
403761020261	403761020261001	ENALAPRIL MALEATE	29.99	10495.656139
403761020261	403761020261002	ENALAPRIL MALEATE	29.99	10495.656139
403761020261	403761020261003	ENALAPRIL MALEATE	29.99	10495.656139
403761020261	403761020261004	ENALAPRIL MALEATE	29.99	10495.656139
403761020261	403761020261005	ENALAPRIL MALEATE	29.99	10495.656139
403761020261	403761020261006	ENALAPRIL MALEATE	29.99	10495.656139
403761020271	403761020271001	LOVASTATIN	69.99	10495.656139
403761020271	403761020271002	LOVASTATIN	69.99	10495.656139
403761020271	403761020271003	LOVASTATIN	69.99	10495.656139
403761020271	403761020271004	LOVASTATIN	69.99	10495.656139
403761020271	403761020271005	LOVASTATIN	69.99	10495.656139
403761020271	403761020271006	LOVASTATIN	69.99	10495.656139
403761020281	403761020281001	NEXIUM	195.99	10495.656139
403761020281	403761020281002	NEXIUM	195.99	10495.656139
403761020281	403761020281003	NEXIUM	195.99	10495.656139
403761020281	403761020281004	NEXIUM	195.99	10495.656139
403761020281	403761020281005	NEXIUM	195.99	10495.656139
403761020281	403761020281006	NEXIUM	195.99	10495.656139
403761020291	403761020291001	PREMARIN	66.99	10495.656139
403761020291	403761020291002	PREMARIN	66.99	10495.656139
403761020291	403761020291003	PREMARIN	66.99	10495.656139
403761020291	403761020291004	PREMARIN	66.99	10495.656139
403761020291	403761020291005	PREMARIN	66.99	10495.656139
403761020291	403761020291006	PREMARIN	66.99	10495.656139
403761020301	403761020301001	PREVACID	192.99	10495.656139
403761020311	403761020311001	HYDROCHLOROTHIAZIDE	10.99	10495.656139
403761020311	403761020311002	HYDROCHLOROTHIAZIDE	10.99	10495.656139
403761020311	403761020311003	HYDROCHLOROTHIAZIDE	10.99	10495.656139
403761020311	403761020311004	HYDROCHLOROTHIAZIDE	10.99	10495.656139
403761020311	403761020311005	HYDROCHLOROTHIAZIDE	10.99	10495.656139
403761020311	403761020311006	HYDROCHLOROTHIAZIDE	10.99	10495.656139
403761020321	403761020321001	CELEBREX	142.99	10495.656139
403761020321	403761020321002	CELEBREX	142.99	10495.656139
403761020321	403761020321003	CELEBREX	142.99	10495.656139
403761020321	403761020321004	CELEBREX	142.99	10495.656139
403761020321	403761020321005	CELEBREX	142.99	10495.656139
403761020321	403761020321006	CELEBREX	142.99	10495.656139
403761020331	403761020331001	FLUTICASONE PROPIONATE	25.66	10495.656139
403761020331	403761020331002	FLUTICASONE PROPIONATE	25.66	10495.656139
403761020331	403761020331003	FLUTICASONE PROPIONATE	25.66	10495.656139
403761020341	403761020341001	ADVAIR DISKUS	160.29	10495.656139
403761020341	403761020341002	ADVAIR DISKUS	160.29	10495.656139
403761020341	403761020341003	ADVAIR DISKUS	160.29	10495.656139
403761020351	403761020351001	PROVENTIL	3.00	10495.656139
403761020351	403761020351002	PROVENTIL	3.00	10495.656139
403761020351	403761020351003	PROVENTIL	3.00	10495.656139
403761020541	403761020541001	LOVASTATIN	36.72	10495.656139
403761020541	403761020541002	LOVASTATIN	36.72	10495.656139
403761020541	403761020541003	LOVASTATIN	36.72	10495.656139
403761020551	403761020551001	CELEBREX	116.16	10495.656139
403761020551	403761020551002	CELEBREX	116.16	10495.656139
403761020551	403761020551003	CELEBREX	116.16	10495.656139
403761020551	403761020551004	CELEBREX	116.16	10495.656139
403761020551	403761020551005	CELEBREX	116.16	10495.656139
403761020561	403761020561001	PREMARIN	51.52	10495.656139
403761020561	403761020561002	PREMARIN	51.52	10495.656139
403761020561	403761020561003	PREMARIN	51.52	10495.656139
404001010021	404001010021001	SYMBICORT	190.13	2642.389748
405021050051	405021050051001	TAMIFLU	138.66	6270.151842
405021050061	405021050061001	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061002	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061003	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061004	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061005	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061006	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061007	VENTOLIN HFA	38.26	6270.151842
405021050071	405021050071001	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071002	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071003	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071004	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071005	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071006	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071007	ADVAIR DISKUS	213.29	6270.151842
405021060031	405021060031001	TAMIFLU	94.24	6386.244760
405021060041	405021060041001	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041002	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041003	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041004	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041005	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041006	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041007	VENTOLIN HFA	38.26	6386.244760
405021060051	405021060051001	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051002	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051003	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051004	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051005	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051006	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051007	FLOVENT HFA	100.63	6386.244760
405581010031	405581010031001	LIPITOR	106.24	8236.989502
405581010041	405581010041001	METFORMIN HYDROCHLORIDE	95.00	8236.989502
405581010051	405581010051001	PREDNISONE	9.89	8236.989502
405581010071	405581010071001	LIPITOR	106.24	8236.989502
405581010071	405581010071002	LIPITOR	106.24	8236.989502
405581010071	405581010071003	LIPITOR	106.24	8236.989502
405581010071	405581010071004	LIPITOR	106.24	8236.989502
405581010071	405581010071005	LIPITOR	106.24	8236.989502
405581010071	405581010071006	LIPITOR	106.24	8236.989502
405581010081	405581010081001	METFORMIN HYDROCHLORIDE	95.00	8236.989502
405581010081	405581010081002	METFORMIN HYDROCHLORIDE	95.00	8236.989502
405581010081	405581010081003	METFORMIN HYDROCHLORIDE	95.00	8236.989502
405581010081	405581010081004	METFORMIN HYDROCHLORIDE	95.00	8236.989502
405581010081	405581010081005	METFORMIN HYDROCHLORIDE	95.00	8236.989502
405581010081	405581010081006	METFORMIN HYDROCHLORIDE	95.00	8236.989502
405581010091	405581010091001	PREDNISONE	14.55	8236.989502
405911050091	405911050091001	SINGULAIR	128.99	7523.311904
405911050091	405911050091002	SINGULAIR	128.99	7523.311904
405911050091	405911050091003	SINGULAIR	128.99	7523.311904
405911050091	405911050091004	SINGULAIR	135.99	7523.311904
405911050091	405911050091005	SINGULAIR	135.99	7523.311904
405911050091	405911050091006	SINGULAIR	128.99	7523.311904
405911050091	405911050091007	SINGULAIR	128.99	7523.311904
405911050101	405911050101001	CLARITIN	7.00	7523.311904
405911050101	405911050101002	CLARITIN	7.00	7523.311904
405911050101	405911050101003	CLARITIN	7.00	7523.311904
405911050101	405911050101004	CLARITIN	7.00	7523.311904
405911050101	405911050101005	CLARITIN	7.00	7523.311904
405911050101	405911050101006	CLARITIN	7.00	7523.311904
405911050101	405911050101007	CLARITIN	7.00	7523.311904
405911050111	405911050111001	ADVAIR DISKUS	191.88	7523.311904
405911050111	405911050111002	ADVAIR DISKUS	191.88	7523.311904
405911050111	405911050111003	ADVAIR DISKUS	191.88	7523.311904

Return to Top

HC-126I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Analysis Variable: RXXP09X SUM OF PAYMENTS RXSF09X-RXOU09X(IMPUTED)

N	Sum
5649	496431.27

Return to Top

HC-126I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
Analysis Variable: RXXP09X SUM OF PAYMENTS RXSF09X-RXOU09X(IMPUTED)

N	Sum
5649	3473465099

Return to Top

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

NOTE: SAS initialization used:
real time 0.62 seconds
cpu time 0.31 seconds

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

NOTE: AUTOEXEC processing completed.

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

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

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

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

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

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

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 0.95 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 1.07 seconds
cpu time 0.00 seconds

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

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

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

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

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

NOTE: There were 333629 observations read from the data set WORK.PMED.
NOTE: There were 7667 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 10436 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.12 seconds

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

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

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

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

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

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

111
112 ods rtf close;
113

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

Return to Top

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

Obs	CONDIDX	CCCODEX
1	400011010011	128
2	400011030011	128
3	400441010101	128
4	400501010021	128
5	400521010101	128
6	400841010091	128
7	400881020041	128
8	401051050011	128
9	401481020061	128
10	401601010041	128
11	401901010031	128
12	401911030011	128
13	402121010021	128
14	402121020011	128
15	402151010011	128
16	402151020041	128
17	402151030011	128
18	402271010011	128
19	402331020051	128
20	402361020011	128
21	402451030011	128
22	402841010081	128
23	403491040011	128
24	403601030011	128
25	403691020021	128
26	403691050021	128
27	403691060011	128
28	403701020061	128
29	403701020161	128
30	403751020061	128
31	403761020041	128
32	403831010041	128
33	403851020041	128
34	403881010081	128
35	403881020011	128
36	404001010031	128
37	404062010022	128
38	404122010032	128
39	404381030011	128
40	404401020041	128
41	404561010031	128
42	404581020011	128
43	404701010031	128
44	404891010031	128
45	405021050011	128
46	405021060011	128
47	405041010011	128
48	405191020011	128
49	405311040011	128
50	405391030011	128

Return to Top

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

CONDIDX	EVNTIDX	EVENTYPE
400011010011	400011010061	8 PMED
400011010011	400011010101	8 PMED
400011030011	400011030081	8 PMED
400441010101	400441010411	8 PMED
400501010021	400501010011	8 PMED
400501010021	400501010051	8 PMED
400501010021	400501010091	8 PMED
400501010021	400501010121	8 PMED
400521010101	400521010031	1 MVIS
400521010101	400521010041	1 MVIS
400521010101	400521010131	8 PMED
400881020041	400881020021	1 MVIS
400881020041	400881020031	1 MVIS
400881020041	400881020041	1 MVIS
400881020041	400881020051	8 PMED
400881020041	400881020061	8 PMED
400881020041	400881020071	8 PMED
400881020041	400881020081	8 PMED
400881020041	400881020091	1 MVIS
400881020041	400881020101	1 MVIS
400881020041	400881020111	8 PMED
401051050011	401051050011	8 PMED
401051050011	401051050031	8 PMED
401601010041	401601010281	8 PMED
401601010041	401601010311	8 PMED
401601010041	401601010321	1 MVIS
401601010041	401601010331	1 MVIS
401601010041	401601010341	1 MVIS
401601010041	401601010471	8 PMED
401911030011	401911030011	1 MVIS
401911030011	401911030021	1 MVIS
401911030011	401911030031	1 MVIS
401911030011	401911030041	1 MVIS
401911030011	401911030051	1 MVIS
401911030011	401911030091	8 PMED
401911030011	401911030131	1 MVIS
401911030011	401911030141	8 PMED
402121020011	402121020011	3 EROM
402121020011	402121020041	8 PMED
402121020011	402121020051	8 PMED
402121020011	402121020061	8 PMED
402151010011	402151010041	8 PMED
402151010011	402151010061	8 PMED
402151030011	402151030051	8 PMED
402331020051	402331020241	8 PMED
402361020011	402361020021	8 PMED
402841010081	402841010291	8 PMED
403491040011	403491040041	8 PMED
403491040011	403491040051	8 PMED
403491040011	403491040061	1 MVIS
403491040011	403491040091	8 PMED
403491040011	403491040111	8 PMED
403491040011	403491040121	8 PMED
403601030011	403601030111	8 PMED
403601030011	403601030121	8 PMED
403601030011	403601030131	8 PMED
403601030011	403601030141	8 PMED
403691020021	403691020041	1 MVIS
403691020021	403691020051	1 MVIS
403691020021	403691020061	1 MVIS
403691020021	403691020071	1 MVIS
403691020021	403691020081	1 MVIS
403691020021	403691020091	1 MVIS
403691020021	403691020101	1 MVIS
403691020021	403691020111	1 MVIS
403691050021	403691050041	1 MVIS
403691050021	403691050051	1 MVIS
403691060011	403691060011	1 MVIS
403691060011	403691060041	8 PMED
403701020061	403701020141	8 PMED
403701020061	403701020161	8 PMED
403701020061	403701020291	8 PMED
403701020061	403701020311	8 PMED
403701020061	403701020351	8 PMED
403751020061	403751020111	8 PMED

Return to Top

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

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	400011010011	400011010061	8 PMED
2	400011010011	400011010101	8 PMED
3	400011030011	400011030081	8 PMED
4	400441010101	400441010411	8 PMED
5	400501010021	400501010011	8 PMED
6	400501010021	400501010051	8 PMED
7	400501010021	400501010091	8 PMED
8	400501010021	400501010121	8 PMED
9	400521010101	400521010031	1 MVIS
10	400521010101	400521010041	1 MVIS
11	400521010101	400521010131	8 PMED
12	400881020041	400881020021	1 MVIS
13	400881020041	400881020031	1 MVIS
14	400881020041	400881020041	1 MVIS
15	400881020041	400881020051	8 PMED
16	400881020041	400881020061	8 PMED
17	400881020041	400881020071	8 PMED
18	400881020041	400881020081	8 PMED
19	400881020041	400881020091	1 MVIS
20	400881020041	400881020101	1 MVIS
21	400881020041	400881020111	8 PMED
22	401051050011	401051050011	8 PMED
23	401051050011	401051050031	8 PMED
24	401601010041	401601010281	8 PMED
25	401601010041	401601010311	8 PMED
26	401601010041	401601010321	1 MVIS
27	401601010041	401601010331	1 MVIS
28	401601010041	401601010341	1 MVIS
29	401601010041	401601010471	8 PMED
30	401911030011	401911030011	1 MVIS
31	401911030011	401911030021	1 MVIS
32	401911030011	401911030031	1 MVIS
33	401911030011	401911030041	1 MVIS
34	401911030011	401911030051	1 MVIS
35	401911030011	401911030091	8 PMED
36	401911030011	401911030131	1 MVIS
37	401911030011	401911030141	8 PMED
38	402121020011	402121020011	3 EROM
39	402121020011	402121020041	8 PMED
40	402121020011	402121020051	8 PMED
41	402121020011	402121020061	8 PMED
42	402151010011	402151010041	8 PMED
43	402151010011	402151010061	8 PMED
44	402151030011	402151030051	8 PMED
45	402331020051	402331020241	8 PMED
46	402361020011	402361020021	8 PMED
47	402841010081	402841010291	8 PMED
48	403491040011	403491040041	8 PMED
49	403491040011	403491040051	8 PMED
50	403491040011	403491040061	1 MVIS

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	400011010061	8 PMED
2	400011010101	8 PMED
3	400011030081	8 PMED
4	400441010411	8 PMED
5	400501010011	8 PMED
6	400501010051	8 PMED
7	400501010091	8 PMED
8	400501010121	8 PMED
9	400521010031	1 MVIS
10	400521010041	1 MVIS
11	400521010131	8 PMED
12	400881020021	1 MVIS
13	400881020031	1 MVIS
14	400881020041	1 MVIS
15	400881020051	8 PMED
16	400881020061	8 PMED
17	400881020071	8 PMED
18	400881020081	8 PMED
19	400881020091	1 MVIS
20	400881020101	1 MVIS
21	400881020111	8 PMED
22	401051050011	8 PMED
23	401051050031	8 PMED
24	401601010281	8 PMED
25	401601010311	8 PMED
26	401601010321	1 MVIS
27	401601010331	1 MVIS
28	401601010341	1 MVIS
29	401601010471	8 PMED
30	401911030011	1 MVIS
31	401911030021	1 MVIS
32	401911030031	1 MVIS
33	401911030041	1 MVIS
34	401911030051	1 MVIS
35	401911030091	8 PMED
36	401911030131	1 MVIS
37	401911030141	8 PMED
38	402121020011	3 EROM
39	402121020041	8 PMED
40	402121020051	8 PMED
41	402121020061	8 PMED
42	402151010041	8 PMED
43	402151010061	8 PMED
44	402151030051	8 PMED
45	402331020241	8 PMED
46	402361020021	8 PMED
47	402841010291	8 PMED
48	403491040041	8 PMED
49	403491040051	8 PMED
50	403491040061	1 MVIS

Return to Top

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

LINKIDX	RXRECIDX	RXNAME	RXXP09X	PERWT09F
400011010061	400011010061001	ADVAIR DISKUS	200.69	14251.111105
400011010101	400011010101001	ADVAIR DISKUS	416.17	14251.111105
400011030081	400011030081001	PULMICORT RESPULES	418.72	14803.089514
400011030081	400011030081002	PULMICORT RESPULES	418.72	14803.089514
400011030081	400011030081003	PULMICORT RESPULES	418.72	14803.089514
400441010411	400441010411001	MUCINEX	19.99	17739.800407
400501010011	400501010011001	ADVAIR DISKU	201.00	10588.753294
400501010011	400501010011002	ADVAIR DISKU	201.00	10588.753294
400501010051	400501010051001	ADVAIR DISKU	201.00	10588.753294
400501010051	400501010051002	ADVAIR DISKU	194.37	10588.753294
400501010051	400501010051003	ADVAIR DISKU	194.37	10588.753294
400501010051	400501010051004	ADVAIR DISKU	201.00	10588.753294
400501010051	400501010051005	ADVAIR DISKU	201.00	10588.753294
400501010051	400501010051006	ADVAIR DISKU	201.00	10588.753294
400501010091	400501010091001	ADVAIR DISKU	201.00	10588.753294
400501010091	400501010091002	ADVAIR DISKU	201.00	10588.753294
400501010091	400501010091003	ADVAIR DISKU	201.00	10588.753294
400501010091	400501010091004	ADVAIR DISKU	201.00	10588.753294
400501010121	400501010121001	PROVENTIL	81.55	10588.753294
400521010131	400521010131001	ADVAIR DISKUS	154.72	4936.989686
400881020051	400881020051001	PROMETHAZINE DM	5.00	3579.012187
400881020061	400881020061001	ACIPHEX	185.59	3579.012187
400881020061	400881020061002	ACIPHEX	185.59	3579.012187
400881020071	400881020071001	SYMBICORT	223.99	3579.012187
400881020071	400881020071002	SYMBICORT	248.69	3579.012187
400881020081	400881020081001	SPIRIVA HANDIHLR	175.00	3579.012187
400881020081	400881020081002	SPIRIVA HANDIHLR	175.00	3579.012187
400881020111	400881020111001	ACIPHEX	185.59	3579.012187
401051050011	401051050011001	SINGULAIR	352.35	13769.384013
401051050011	401051050011002	SINGULAIR	352.35	13769.384013
401051050011	401051050011003	SINGULAIR	352.35	13769.384013
401051050011	401051050011004	SINGULAIR	352.35	13769.384013
401051050011	401051050011005	SINGULAIR	352.35	13769.384013
401051050031	401051050031001	PULMICORT RESPULES	179.48	13769.384013
401601010281	401601010281001	DIPHENHYDRAMINE HYDROCHLORIDE	9.58	2051.235697
401601010281	401601010281002	COMPLETE ALLERGY	1.31	2051.235697
401601010311	401601010311001	HALOPERIDOL	62.36	2051.235697
401601010311	401601010311002	HALOPERIDOL	1.10	2051.235697
401601010311	401601010311003	HALOPERIDOL	17.13	2051.235697
401601010311	401601010311004	HALOPERIDOL	80.24	2051.235697
401601010311	401601010311005	HALOPERIDOL	68.63	2051.235697
401601010471	401601010471001	XOPENEX HFA	53.33	2051.235697
401911030091	401911030091001	XOPENEX	91.00	5621.646638
401911030091	401911030091002	XOPENEX	91.00	5621.646638
401911030141	401911030141001	XOPENEX	91.00	5621.646638
402121020041	402121020041001	PREDNISONE	7.41	4514.743374
402121020051	402121020051001	VENTOLIN HFA	74.02	4514.743374
402121020051	402121020051002	VENTOLIN HFA	74.02	4514.743374
402121020051	402121020051003	VENTOLIN HFA	74.02	4514.743374
402121020061	402121020061001	PREDNISONE	1.67	4514.743374
402121020061	402121020061002	PREDNISONE	1.67	4514.743374
402121020061	402121020061003	PREDNISONE	1.67	4514.743374
402151010041	402151010041001	ALBUTEROL HFA	19.72	10676.922942
402151010041	402151010041002	ALBUTEROL HFA	19.72	10676.922942
402151010061	402151010061001	ALBUTEROL	37.78	10676.922942
402151010061	402151010061002	ALBUTEROL	37.78	10676.922942
402151030051	402151030051001	ALBUTEROL SULFATE	5.75	6855.721593
402331020241	402331020241001	ALBUTEROL	37.78	9726.350716
402361020021	402361020021001	ALBUTEROL	37.78	34868.237549
402841010291	402841010291001	FEXOFENADINE HYDROCHLORIDE	33.82	22027.463773
402841010291	402841010291002	FEXOFENADINE HYDROCHLORIDE	33.82	22027.463773
402841010291	402841010291003	FEXOFENADINE HYDROCHLORIDE	33.82	22027.463773
402841010291	402841010291004	FEXOFENADINE HYDROCHLORIDE	33.82	22027.463773
402841010291	402841010291005	FEXOFENADINE HYDROCHLORIDE	33.82	22027.463773
402841010291	402841010291006	FEXOFENADINE HYDROCHLORIDE	31.46	22027.463773
403491040041	403491040041001	PULMICORT RESPULES	179.48	2416.072308
403491040051	403491040051001	VENTOLIN HFA	33.96	2416.072308
403491040091	403491040091001	VENTOLIN HFA	33.96	2416.072308
403491040091	403491040091002	VENTOLIN HFA	33.96	2416.072308
403491040091	403491040091003	VENTOLIN HFA	33.96	2416.072308
403491040091	403491040091004	VENTOLIN HFA	33.96	2416.072308
403491040091	403491040091005	VENTOLIN HFA	33.96	2416.072308
403491040091	403491040091006	VENTOLIN HFA	33.96	2416.072308
403491040111	403491040111001	PULMICORT RESPULES	179.48	2416.072308
403491040121	403491040121001	VENTOLIN HFA	33.96	2416.072308
403601030111	403601030111001	ADVAIR DISKUS	162.99	7579.284306
403601030121	403601030121001	SINGULAIR	110.22	7579.284306
403601030131	403601030131001	PROTONIX	330.85	7579.284306
403601030141	403601030141001	CETIRIZINE HYDROCHLORIDE	6.89	7579.284306
403691060041	403691060041001	SYMBICORT	163.10	12142.929000
403691060041	403691060041002	SYMBICORT	163.10	12142.929000
403691060041	403691060041003	SYMBICORT	163.10	12142.929000
403701020141	403701020141001	SEREVENT DISKUS	145.02	7724.717644
403701020141	403701020141002	SEREVENT DISKUS	145.02	7724.717644
403701020141	403701020141003	SEREVENT DISKUS	145.02	7724.717644
403701020161	403701020161001	SINGULAIR	114.86	7724.717644
403701020161	403701020161002	SINGULAIR	114.86	7724.717644
403701020161	403701020161003	SINGULAIR	114.86	7724.717644
403701020291	403701020291001	ASTELIN	87.13	7724.717644
403701020291	403701020291002	ASTELIN	87.13	7724.717644
403701020311	403701020311001	SINGULAIR	103.52	7724.717644
403701020311	403701020311002	SINGULAIR	103.52	7724.717644
403701020351	403701020351001	ADVAIR DISKU	190.00	7724.717644
403701020351	403701020351002	ADVAIR DISKU	190.00	7724.717644
403701020351	403701020351003	ADVAIR DISKU	190.00	7724.717644
403701020351	403701020351004	ADVAIR DISKU	190.00	7724.717644
403701020351	403701020351005	ADVAIR DISKU	190.00	7724.717644
403701020351	403701020351006	ADVAIR DISKU	190.00	7724.717644
403751020111	403751020111001	ACTONEL	93.72	5045.100521
403751020111	403751020111002	ACTONEL	93.72	5045.100521
403751020111	403751020111003	ACTONEL	93.72	5045.100521
403751020141	403751020141001	PROAIR HFA	45.99	5045.100521
403751020141	403751020141002	PROAIR HFA	45.99	5045.100521
403751020141	403751020141003	PROAIR HFA	45.99	5045.100521
403751020201	403751020201001	ALBUTEROL	37.78	5045.100521
403751020201	403751020201002	ALBUTEROL	37.78	5045.100521
403751020201	403751020201003	ALBUTEROL	37.78	5045.100521
403751020351	403751020351001	PROVENTIL HFA	42.95	5045.100521
403751020351	403751020351002	PROVENTIL HFA	42.95	5045.100521
403751020351	403751020351003	PROVENTIL HFA	42.95	5045.100521
403751020351	403751020351004	PROVENTIL HFA	42.95	5045.100521
403751020401	403751020401001	ALBUTEROL	37.78	5045.100521
403751020401	403751020401002	ALBUTEROL	37.78	5045.100521
403751020401	403751020401003	ALBUTEROL	37.78	5045.100521
403751020401	403751020401004	ALBUTEROL	37.78	5045.100521
403751020421	403751020421001	SPIRIVA	511.70	5045.100521
403751020421	403751020421002	SPIRIVA	511.70	5045.100521
403751020531	403751020531001	PROAIR HFA	45.99	5045.100521
403751020531	403751020531002	PROAIR HFA	45.99	5045.100521
403751020531	403751020531003	PROAIR HFA	45.99	5045.100521
403751020531	403751020531004	PROAIR HFA	45.99	5045.100521
403751020591	403751020591001	ALBUTEROL	37.78	5045.100521
403751020591	403751020591002	ALBUTEROL	37.78	5045.100521
403751020591	403751020591003	ALBUTEROL	37.78	5045.100521
403751020591	403751020591004	ALBUTEROL	37.78	5045.100521
403751020611	403751020611001	SPIRIVA	493.54	5045.100521
403751020611	403751020611002	SPIRIVA	493.54	5045.100521
403751020611	403751020611003	SPIRIVA	493.54	5045.100521
403751020611	403751020611004	SPIRIVA	493.64	5045.100521
403761020131	403761020131001	ADVAIR DISKUS	160.29	10495.656139
403761020141	403761020141001	PROVENTIL HFA	58.99	10495.656139
403761020341	403761020341001	ADVAIR DISKUS	160.29	10495.656139
403761020341	403761020341002	ADVAIR DISKUS	160.29	10495.656139
403761020341	403761020341003	ADVAIR DISKUS	160.29	10495.656139
403761020351	403761020351001	PROVENTIL	3.00	10495.656139
403761020351	403761020351002	PROVENTIL	3.00	10495.656139
403761020351	403761020351003	PROVENTIL	3.00	10495.656139
403761020591	403761020591001	PROVENTIL HFA	58.99	10495.656139
403831010231	403831010231001	PROAIR HFA	37.00	14958.062378
403851020031	403851020031001	ADVAIR	141.92	17325.051907
403851020071	403851020071001	ADVAIR	141.92	17325.051907
403851020071	403851020071002	ADVAIR	141.92	17325.051907
403851020171	403851020171001	ADVAIR	141.92	17325.051907
404001010021	404001010021001	SYMBICORT	190.13	2642.389748
404001010041	404001010041001	SYMBICORT	190.13	2642.389748
404001010081	404001010081001	SYMBICORT	185.54	2642.389748
404062010182	404062010182001	ALBUTEROL	37.78	7267.895202
404062010192	404062010192001	FLOVENT	95.57	7267.895202
404122010512	404122010512001	VENTOLIN HFA	41.80	4546.108410
404122010522	404122010522001	FLUTICASONE TOPICAL	11.32	4546.108410
404381030041	404381030041001	VENTOLIN HFA	34.17	2575.496786
404381030111	404381030111001	LORATADINE	7.64	2575.496786
404381030111	404381030111002	LORATADINE	7.64	2575.496786
404381030111	404381030111003	LORATADINE	7.64	2575.496786
404381030191	404381030191001	VENTOLIN HFA	34.17	2575.496786
404381030201	404381030201001	ADVAIR DISKUS	158.56	2575.496786
404381030211	404381030211001	PROAIR HFA	38.50	2575.496786
404381030241	404381030241001	ADVAIR DISKUS	162.83	2575.496786
404381030251	404381030251001	VENTOLIN HFA	34.17	2575.496786
404401020791	404401020791001	PROVENTIL	14.11	14678.298853
404561010121	404561010121001	ADVAIR DISKUS	425.28	25727.227319
404561010251	404561010251001	ADVAIR DISKUS	425.28	25727.227319
404581020061	404581020061001	VENTOLIN HFA	34.48	3429.039288
404581020071	404581020071001	FLOVENT HFA	126.57	3429.039288
404701010031	404701010031001	FLOVENT	95.57	7125.366836
404701010091	404701010091001	FLOVENT HFA	138.57	7125.366836
404701010091	404701010091002	FLOVENT HFA	138.57	7125.366836
404701010111	404701010111001	VENTOLIN HFA	35.39	7125.366836
404701010141	404701010141001	FLOVENT HFA	123.38	7125.366836
404891010411	404891010411001	PREDNISONE	3.85	2825.304378
404891010491	404891010491001	ADVAIR DISKUS	204.28	2825.304378
404891010491	404891010491002	ADVAIR DISKUS	204.28	2825.304378
404891010501	404891010501001	QVAR	71.71	2825.304378
404891010501	404891010501002	QVAR	71.71	2825.304378
404891010681	404891010681001	ADVAIR DISKUS	204.28	2825.304378
404891010681	404891010681002	ADVAIR DISKUS	204.28	2825.304378
404891010681	404891010681003	ADVAIR DISKUS	204.28	2825.304378
404891010681	404891010681004	ADVAIR DISKUS	204.28	2825.304378
404891010691	404891010691001	VENTOLIN HFA	33.99	2825.304378
404891010691	404891010691002	VENTOLIN HFA	33.99	2825.304378
404891010691	404891010691003	VENTOLIN HFA	33.99	2825.304378
404891010691	404891010691004	VENTOLIN HFA	33.99	2825.304378
404891010691	404891010691005	VENTOLIN HFA	33.99	2825.304378
405021050061	405021050061001	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061002	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061003	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061004	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061005	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061006	VENTOLIN HFA	38.26	6270.151842
405021050061	405021050061007	VENTOLIN HFA	38.26	6270.151842
405021050071	405021050071001	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071002	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071003	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071004	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071005	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071006	ADVAIR DISKUS	213.29	6270.151842
405021050071	405021050071007	ADVAIR DISKUS	213.29	6270.151842
405021060041	405021060041001	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041002	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041003	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041004	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041005	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041006	VENTOLIN HFA	38.26	6386.244760
405021060041	405021060041007	VENTOLIN HFA	38.26	6386.244760
405021060051	405021060051001	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051002	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051003	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051004	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051005	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051006	FLOVENT HFA	100.63	6386.244760
405021060051	405021060051007	FLOVENT HFA	100.63	6386.244760
405041010031	405041010031001	HYPER-SAL	63.49	9889.450465
405041010031	405041010031002	HYPER-SAL	63.49	9889.450465
405041010031	405041010031003	HYPER-SAL	63.49	9889.450465
405041010031	405041010031004	HYPER-SAL	63.49	9889.450465
405191020051	405191020051001	PROAIR HFA	76.28	9948.215667
405191020101	405191020101001	PROAIR HFA	76.28	9948.215667
405561030031	405561030031001	PULMICORT FLEXHALER	95.10	14066.833022
405561030041	405561030041001	ALBUTEROL	37.78	14066.833022
405561030091	405561030091001	ALBUTEROL SULFATE	102.18	14066.833022
405581010101	405581010101001	ALBUTEROL	37.78	8236.989502
405581010101	405581010101002	ALBUTEROL	37.78	8236.989502
405581010101	405581010101003	ALBUTEROL	37.78	8236.989502
405581010101	405581010101004	ALBUTEROL	37.78	8236.989502
405581010101	405581010101005	ALBUTEROL	37.78	8236.989502
405581010101	405581010101006	ALBUTEROL	37.78	8236.989502
405581010151	405581010151001	ALBUTEROL	37.78	8236.989502
405581010151	405581010151002	ALBUTEROL	37.78	8236.989502
405581010151	405581010151003	ALBUTEROL	37.78	8236.989502
405911050071	405911050071001	ADVAIR DISKUS	200.21	7523.311904
405911050071	405911050071002	ADVAIR DISKUS	200.21	7523.311904
405911050071	405911050071003	ADVAIR DISKUS	200.21	7523.311904
405911050111	405911050111001	ADVAIR DISKUS	191.88	7523.311904
405911050111	405911050111002	ADVAIR DISKUS	191.88	7523.311904
405911050111	405911050111003	ADVAIR DISKUS	191.88	7523.311904
405911050111	405911050111004	ADVAIR DISKUS	191.88	7523.311904
405911050111	405911050111005	ADVAIR DISKUS	191.88	7523.311904
405911050111	405911050111006	ADVAIR DISKUS	191.88	7523.311904
405911050111	405911050111007	ADVAIR DISKUS	191.88	7523.311904
406061040011	406061040011001	ADVAIR DISKUS	242.99	2997.679792
406061040011	406061040011002	ADVAIR DISKUS	242.99	2997.679792
406061040021	406061040021001	ALBUTEROL HFA	19.72	2997.679792
406061040021	406061040021002	ALBUTEROL HFA	19.72	2997.679792
406061040052	406061040052001	ALBUTEROL HFA	19.72	2997.679792
406061040052	406061040052002	ALBUTEROL HFA	19.72	2997.679792
406061040052	406061040052003	ALBUTEROL HFA	19.72	2997.679792
406061040052	406061040052004	ALBUTEROL HFA	19.72	2997.679792
406111010211	406111010211001	SPIRIVA	171.16	9985.706330
406111010211	406111010211002	SPIRIVA	171.16	9985.706330
406111010211	406111010211003	SPIRIVA	171.16	9985.706330
406111010211	406111010211004	SPIRIVA	342.33	9985.706330
406111010211	406111010211005	SPIRIVA	342.33	9985.706330
406111010211	406111010211006	SPIRIVA	342.33	9985.706330
406111010211	406111010211007	SPIRIVA	171.16	9985.706330
406111010211	406111010211008	SPIRIVA	171.16	9985.706330
406111010231	406111010231001	SYMBICORT	152.00	9985.706330
406111010241	406111010241001	PREDNISONE	5.00	9985.706330
406111010241	406111010241002	PREDNISONE	5.00	9985.706330
406111010241	406111010241003	PREDNISONE	5.00	9985.706330
406111010241	406111010241004	PREDNISONE	5.00	9985.706330
406111010431	406111010431001	SPIRIVA	171.16	9985.706330
406111010431	406111010431002	SPIRIVA	342.33	9985.706330
406381030081	406381030081001	ALBUTEROL-IPRATROPIUM BROMIDE	95.16	8612.296225
406381030081	406381030081002	ALBUTEROL-IPRATROPIUM BROMIDE	95.16	8612.296225
406381030091	406381030091001	ADVAIR DISKUS	785.59	8612.296225
406381030131	406381030131001	METHYLPREDNISOLONE	149.15	8612.296225
406381030251	406381030251001	ALBUTEROL-IPRATROPIUM BROMIDE	95.52	8612.296225
406381030251	406381030251002	ALBUTEROL-IPRATROPIUM BROMIDE	95.40	8612.296225
406381030261	406381030261001	ADVAIR DISKUS	785.59	8612.296225
406381030261	406381030261002	ADVAIR DISKUS	785.58	8612.296225
406381030271	406381030271001	PANTOPRAZOLE	90.60	8612.296225
406381030271	406381030271002	PANTOPRAZOLE	90.60	8612.296225
406381030281	406381030281001	FEXOFENADINE HYDROCHLORIDE	108.57	8612.296225
406381030281	406381030281002	FEXOFENADINE HYDROCHLORIDE	117.89	8612.296225
406381030291	406381030291001	SINGULAIR	343.96	8612.296225
406381030291	406381030291002	SINGULAIR	343.96	8612.296225
406381030301	406381030301001	METHYLPREDNISOLONE	149.15	8612.296225
406381030301	406381030301002	METHYLPREDNISOLONE	50.72	8612.296225
406421010271	406421010271001	ADVAIR DISKUS	322.99	13623.186685
406421010271	406421010271002	ADVAIR DISKUS	322.99	13623.186685
406421010271	406421010271003	ADVAIR DISKUS	322.99	13623.186685
406421010271	406421010271004	ADVAIR DISKUS	322.99	13623.186685
406421010271	406421010271005	ADVAIR DISKUS	322.99	13623.186685
406421010271	406421010271006	ADVAIR DISKUS	322.99	13623.186685
406421010301	406421010301001	ADVAIR DISKUS	322.99	13623.186685
406421010301	406421010301002	ADVAIR DISKUS	322.99	13623.186685
406421010301	406421010301003	ADVAIR DISKUS	322.99	13623.186685
406421010301	406421010301004	ADVAIR DISKUS	322.99	13623.186685
406421010301	406421010301005	ADVAIR DISKUS	322.99	13623.186685
406421010301	406421010301006	ADVAIR DISKUS	322.99	13623.186685
406421010391	406421010391001	ADVAIR DISKUS	322.99	13623.186685
406551040041	406551040041001	ALBUTEROL SULFATE	7.24	5843.794078
406551040041	406551040041002	ALBUTEROL SULFATE	7.24	5843.794078
406551040041	406551040041003	ALBUTEROL SULFATE	7.24	5843.794078
406551040051	406551040051001	BUDESONIDE	140.49	5843.794078
406551040051	406551040051002	BUDESONIDE	140.49	5843.794078
406551040051	406551040051003	BUDESONIDE	140.49	5843.794078
406961010201	406961010201001	MIRTAZAPINE	85.30	2239.634008
406961010201	406961010201002	MIRTAZAPINE	85.30	2239.634008
406961010201	406961010201003	MIRTAZAPINE	85.30	2239.634008

Return to Top

HC-126I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Analysis Variable: RXXP09X SUM OF PAYMENTS RXSF09X-RXOU09X(IMPUTED)

N	Sum
10436	1175931.86

Return to Top

HC-126I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
Analysis Variable: RXXP09X SUM OF PAYMENTS RXSF09X-RXOU09X(IMPUTED)

N	Sum
10436	11030532968

Return to Top

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

NOTE: SAS initialization used:
real time 0.62 seconds
cpu time 0.35 seconds

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

NOTE: AUTOEXEC processing completed.

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

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

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

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

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

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

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 1.04 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 1.03 seconds
cpu time 0.01 seconds

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

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

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

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

NOTE: There were 154599 observations read from the data set IN.H126G.
NOTE: The data set WORK.MVIS has 149890 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 12.10 seconds
cpu time 0.25 seconds

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

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

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

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

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

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

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

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

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

117
118 ods rtf close;
119
120

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

Return to Top

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

Obs	CONDIDX	CCCODEX
1	400011010011	128
2	400011030011	128
3	400441010101	128
4	400501010021	128
5	400521010101	128
6	400841010091	128
7	400881020041	128
8	401051050011	128
9	401481020061	128
10	401601010041	128
11	401901010031	128
12	401911030011	128
13	402121010021	128
14	402121020011	128
15	402151010011	128
16	402151020041	128
17	402151030011	128
18	402271010011	128
19	402331020051	128
20	402361020011	128
21	402451030011	128
22	402841010081	128
23	403491040011	128
24	403601030011	128
25	403691020021	128
26	403691050021	128
27	403691060011	128
28	403701020061	128
29	403701020161	128
30	403751020061	128
31	403761020041	128
32	403831010041	128
33	403851020041	128
34	403881010081	128
35	403881020011	128
36	404001010031	128
37	404062010022	128
38	404122010032	128
39	404381030011	128
40	404401020041	128
41	404561010031	128
42	404581020011	128
43	404701010031	128
44	404891010031	128
45	405021050011	128
46	405021060011	128
47	405041010011	128
48	405191020011	128
49	405311040011	128
50	405391030011	128

Return to Top

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

CONDIDX	EVNTIDX	EVENTYPE
400011010011	400011010061	8 PMED
400011010011	400011010101	8 PMED
400011030011	400011030081	8 PMED
400441010101	400441010411	8 PMED
400501010021	400501010011	8 PMED
400501010021	400501010051	8 PMED
400501010021	400501010091	8 PMED
400501010021	400501010121	8 PMED
400521010101	400521010031	1 MVIS
400521010101	400521010041	1 MVIS
400521010101	400521010131	8 PMED
400881020041	400881020021	1 MVIS
400881020041	400881020031	1 MVIS
400881020041	400881020041	1 MVIS
400881020041	400881020051	8 PMED
400881020041	400881020061	8 PMED
400881020041	400881020071	8 PMED
400881020041	400881020081	8 PMED
400881020041	400881020091	1 MVIS
400881020041	400881020101	1 MVIS
400881020041	400881020111	8 PMED
401051050011	401051050011	8 PMED
401051050011	401051050031	8 PMED
401601010041	401601010281	8 PMED
401601010041	401601010311	8 PMED
401601010041	401601010321	1 MVIS
401601010041	401601010331	1 MVIS
401601010041	401601010341	1 MVIS
401601010041	401601010471	8 PMED
401911030011	401911030011	1 MVIS
401911030011	401911030021	1 MVIS
401911030011	401911030031	1 MVIS
401911030011	401911030041	1 MVIS
401911030011	401911030051	1 MVIS
401911030011	401911030091	8 PMED
401911030011	401911030131	1 MVIS
401911030011	401911030141	8 PMED
402121020011	402121020011	3 EROM
402121020011	402121020041	8 PMED
402121020011	402121020051	8 PMED
402121020011	402121020061	8 PMED
402151010011	402151010041	8 PMED
402151010011	402151010061	8 PMED
402151030011	402151030051	8 PMED
402331020051	402331020241	8 PMED
402361020011	402361020021	8 PMED
402841010081	402841010291	8 PMED
403491040011	403491040041	8 PMED
403491040011	403491040051	8 PMED
403491040011	403491040061	1 MVIS
403491040011	403491040091	8 PMED
403491040011	403491040111	8 PMED
403491040011	403491040121	8 PMED
403601030011	403601030111	8 PMED
403601030011	403601030121	8 PMED
403601030011	403601030131	8 PMED
403601030011	403601030141	8 PMED
403691020021	403691020041	1 MVIS
403691020021	403691020051	1 MVIS
403691020021	403691020061	1 MVIS
403691020021	403691020071	1 MVIS
403691020021	403691020081	1 MVIS
403691020021	403691020091	1 MVIS
403691020021	403691020101	1 MVIS
403691020021	403691020111	1 MVIS
403691050021	403691050041	1 MVIS
403691050021	403691050051	1 MVIS
403691060011	403691060011	1 MVIS
403691060011	403691060041	8 PMED
403701020061	403701020141	8 PMED
403701020061	403701020161	8 PMED
403701020061	403701020291	8 PMED
403701020061	403701020311	8 PMED
403701020061	403701020351	8 PMED
403751020061	403751020111	8 PMED

Return to Top

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

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	400011010011	400011010061	8 PMED
2	400011010011	400011010101	8 PMED
3	400011030011	400011030081	8 PMED
4	400441010101	400441010411	8 PMED
5	400501010021	400501010011	8 PMED
6	400501010021	400501010051	8 PMED
7	400501010021	400501010091	8 PMED
8	400501010021	400501010121	8 PMED
9	400521010101	400521010031	1 MVIS
10	400521010101	400521010041	1 MVIS
11	400521010101	400521010131	8 PMED
12	400881020041	400881020021	1 MVIS
13	400881020041	400881020031	1 MVIS
14	400881020041	400881020041	1 MVIS
15	400881020041	400881020051	8 PMED
16	400881020041	400881020061	8 PMED
17	400881020041	400881020071	8 PMED
18	400881020041	400881020081	8 PMED
19	400881020041	400881020091	1 MVIS
20	400881020041	400881020101	1 MVIS
21	400881020041	400881020111	8 PMED
22	401051050011	401051050011	8 PMED
23	401051050011	401051050031	8 PMED
24	401601010041	401601010281	8 PMED
25	401601010041	401601010311	8 PMED
26	401601010041	401601010321	1 MVIS
27	401601010041	401601010331	1 MVIS
28	401601010041	401601010341	1 MVIS
29	401601010041	401601010471	8 PMED
30	401911030011	401911030011	1 MVIS
31	401911030011	401911030021	1 MVIS
32	401911030011	401911030031	1 MVIS
33	401911030011	401911030041	1 MVIS
34	401911030011	401911030051	1 MVIS
35	401911030011	401911030091	8 PMED
36	401911030011	401911030131	1 MVIS
37	401911030011	401911030141	8 PMED
38	402121020011	402121020011	3 EROM
39	402121020011	402121020041	8 PMED
40	402121020011	402121020051	8 PMED
41	402121020011	402121020061	8 PMED
42	402151010011	402151010041	8 PMED
43	402151010011	402151010061	8 PMED
44	402151030011	402151030051	8 PMED
45	402331020051	402331020241	8 PMED
46	402361020011	402361020021	8 PMED
47	402841010081	402841010291	8 PMED
48	403491040011	403491040041	8 PMED
49	403491040011	403491040051	8 PMED
50	403491040011	403491040061	1 MVIS

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	400011010061	8 PMED
2	400011010101	8 PMED
3	400011030081	8 PMED
4	400441010411	8 PMED
5	400501010011	8 PMED
6	400501010051	8 PMED
7	400501010091	8 PMED
8	400501010121	8 PMED
9	400521010031	1 MVIS
10	400521010041	1 MVIS
11	400521010131	8 PMED
12	400881020021	1 MVIS
13	400881020031	1 MVIS
14	400881020041	1 MVIS
15	400881020051	8 PMED
16	400881020061	8 PMED
17	400881020071	8 PMED
18	400881020081	8 PMED
19	400881020091	1 MVIS
20	400881020101	1 MVIS
21	400881020111	8 PMED
22	401051050011	8 PMED
23	401051050031	8 PMED
24	401601010281	8 PMED
25	401601010311	8 PMED
26	401601010321	1 MVIS
27	401601010331	1 MVIS
28	401601010341	1 MVIS
29	401601010471	8 PMED
30	401911030011	1 MVIS
31	401911030021	1 MVIS
32	401911030031	1 MVIS
33	401911030041	1 MVIS
34	401911030051	1 MVIS
35	401911030091	8 PMED
36	401911030131	1 MVIS
37	401911030141	8 PMED
38	402121020011	3 EROM
39	402121020041	8 PMED
40	402121020051	8 PMED
41	402121020061	8 PMED
42	402151010041	8 PMED
43	402151010061	8 PMED
44	402151030051	8 PMED
45	402331020241	8 PMED
46	402361020021	8 PMED
47	402841010291	8 PMED
48	403491040041	8 PMED
49	403491040051	8 PMED
50	403491040061	1 MVIS

Return to Top

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

Obs	EVNTIDX	EVENTYPE	SEETLKPV	OBXP09X	PERWT09F
1	400521010031	1 MVIS	1	12.79	4936.99
2	400521010041	1 MVIS	1	12.79	4936.99
3	400881020021	1 MVIS	1	213.00	3579.01
4	400881020031	1 MVIS	1	213.00	3579.01
5	400881020041	1 MVIS	1	213.00	3579.01
6	400881020091	1 MVIS	1	4164.52	3579.01
7	400881020101	1 MVIS	1	0.00	3579.01
8	401601010321	1 MVIS	1	20.03	2051.24
9	401601010331	1 MVIS	1	42.84	2051.24
10	401601010341	1 MVIS	1	61.85	2051.24
11	401911030011	1 MVIS	1	107.00	5621.65
12	401911030021	1 MVIS	1	357.64	5621.65
13	401911030031	1 MVIS	1	357.64	5621.65
14	401911030041	1 MVIS	1	357.64	5621.65
15	401911030051	1 MVIS	1	357.64	5621.65
16	401911030131	1 MVIS	1	357.64	5621.65
17	403491040061	1 MVIS	1	0.00	2416.07
18	403691020041	1 MVIS	1	74.09	8028.26
19	403691020051	1 MVIS	1	74.09	8028.26
20	403691020061	1 MVIS	1	74.09	8028.26
21	403691020071	1 MVIS	1	459.04	8028.26
22	403691020081	1 MVIS	1	742.00	8028.26
23	403691020091	1 MVIS	1	61.81	8028.26
24	403691020101	1 MVIS	1	117.03	8028.26
25	403691020111	1 MVIS	1	84.62	8028.26
26	403691050041	1 MVIS	1	81.00	14473.97
27	403691050051	1 MVIS	1	155.00	14473.97
28	403691060011	1 MVIS	1	97.71	12142.93
29	403751020221	1 MVIS	1	87.34	5045.10
30	403751020251	1 MVIS	1	87.34	5045.10
31	403751020261	1 MVIS	1	54.61	5045.10
32	403751020461	1 MVIS	1	37.81	5045.10
33	403751020471	1 MVIS	1	34.19	5045.10
34	403761020011	1 MVIS	1	59.55	10495.66
35	403761020021	1 MVIS	1	59.55	10495.66
36	403761020031	1 MVIS	1	59.55	10495.66
37	403761020181	1 MVIS	1	122.00	10495.66
38	403761020191	1 MVIS	1	242.00	10495.66
39	403761020201	1 MVIS	1	114.40	10495.66
40	403761020211	1 MVIS	1	114.40	10495.66
41	403761020451	1 MVIS	1	78.50	10495.66
42	404001010011	1 MVIS	1	301.27	2642.39
43	404381030071	1 MVIS	1	204.02	2575.50
44	404381030081	1 MVIS	1	153.79	2575.50
45	404381030091	1 MVIS	1	153.79	2575.50
46	404381030101	1 MVIS	1	204.02	2575.50
47	404401020211	1 MVIS	1	52.58	14678.30
48	404401020491	1 MVIS	1	94.16	14678.30
49	404401020541	1 MVIS	1	104.82	14678.30
50	404561010261	1 MVIS	1	84.07	25727.23

Return to Top

HC-126I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Analysis Variable: OBXP09X SUM OF OBSF09X - OBOT09X (IMPUTED)

N	Sum
2286	317970.49

Return to Top

HC-126I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
Analysis Variable: OBXP09X SUM OF OBSF09X - OBOT09X (IMPUTED)

N	Sum
2286	2794538598

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