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

Font Size:

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

The SAS System

NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to WESTAT INC, Site 0009005004.
NOTE: This session is executing on the XP_PRO platform.

NOTE: SAS 9.1.3 Service Pack 4

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

NOTE: AUTOEXEC processing beginning; file is C:\Program Files\SAS\SAS 9.1\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-110I";
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.00 seconds

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

NOTE: There were 94246 observations read from the data set IN.H112.
NOTE: The data set WORK.ASCONDS has 1879 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.28 seconds
cpu time 0.04 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 1879 observations read from the data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 1879 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.07 seconds
cpu time 0.00 seconds

42
43 proc print data=asconds (obs=50);
44 title3 "sample print of work.asconds - sorted by condidx";
45 title4 "COND (H112) 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.17 seconds
cpu time 0.03 seconds

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

NOTE: There were 302137 observations read from the data set IN.H110IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 302137 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 3.90 seconds
cpu time 0.28 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 302137 observations read from the data set WORK.CLNK.
NOTE: There were 1879 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 6602 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.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 0.43 seconds
cpu time 0.00 seconds

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

NOTE: There were 6602 observations read from the data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 6602 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.14 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 6602 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6597 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 0.04 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.H110G (KEEP=EVNTIDX PERWT07F SEETLKPV);
88 IF PERWT07F > 0 & SEETLKPV NE 2;
89 RUN;

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

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

NOTE: There were 132197 observations read from the data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 132197 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.17 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 6597 observations read from the data set WORK.ASCLNKS.
NOTE: There were 132197 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 2045 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

102
103 proc print data=asmvis (obs=50);
104 format eventype eventype.;
105 title3 "sample print of work.asmvis";
106 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-110G) 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.01 seconds

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

NOTE: There were 52885 observations read from the data set IN.H110IF2.
NOTE: SAS sort was used.
NOTE: The data set WORK.RXLK has 52885 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 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-110IF2)";
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.03 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 52885 observations read from the data set WORK.RXLK.
NOTE: There were 2045 observations read from the data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 1793 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 12-13.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

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

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

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

NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 14.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.03 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 1793 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1735 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

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

NOTE: There were 50 observations read from the data set WORK.PMEDIDS.
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.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.H110A OUT=PMED; BY LINKIDX; RUN;

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

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

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

166
167 proc print data=mvpmeds (obs=200);
168 var rxrecidx rxname RXXP07X PERWT07F;
169 by linkidx;
170 id linkidx;
171 title3 "sample print of work.mvpmeds";
172 title4 "PMED (HC-110A) 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.06 seconds
cpu time 0.03 seconds

174
175 PROC MEANS DATA=MVPMEDS N SUM;
176 VAR RXXP07X;
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 4729 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.12 seconds
cpu time 0.01 seconds

179
180 PROC MEANS DATA=MVPMEDS N SUM;
181 VAR RXXP07X;
182 WEIGHT PERWT07F;
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 4729 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.04 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 16.20 seconds
cpu time 1.74 seconds

Return to Top

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

Obs	CONDIDX	CCCODEX
1	600140260030	128
2	600250160011	128
3	600420150021	128
4	600730160010	128
5	601190220021	128
6	601200400010	128
7	601280520010	128
8	601320190057	128
9	601470310042	128
10	601510250029	128
11	601540680041	128
12	601590210031	128
13	601610270070	128
14	601720130135	128
15	601880440011	128
16	601880500011	128
17	602040160074	128
18	602090280120	128
19	602320110025	128
20	602410530021	128
21	602540340014	128
22	602630240034	128
23	602800190113	128
24	602800260037	128
25	602810160112	128
26	602850570028	128
27	602850640027	128
28	603020220037	128
29	603080180025	128
30	603140370012	128
31	603330280077	128
32	603330580019	128
33	603460450066	128
34	603460510022	128
35	603830390020	128
36	604010140032	128
37	604160650018	128
38	604240510022	128
39	604390530030	128
40	604440230087	128
41	604540290026	128
42	604570180068	128
43	604590140042	128
44	604640160020	128
45	604640300034	128
46	604710170023	128
47	604720210032	128
48	604770480018	128
49	604970100037	128
50	605040240062	128

Return to Top

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

CONDIDX	EVNTIDX	EVENTYPE
600420150021	600420150514	8 PMED
600730160010	600730160136	8 PMED
600730160010	600730160143	8 PMED
601200400010	601200400090	8 PMED
601200400010	601200400110	8 PMED
601280520010	601280520094	8 PMED
601320190057	601320190287	8 PMED
601320190057	601320190314	1 MVIS
601320190057	601320190321	1 MVIS
601320190057	601320190338	1 MVIS
601320190057	601320190403	8 PMED
601320190057	601320190458	8 PMED
601320190057	601320190465	8 PMED
601320190057	601320190472	8 PMED
601320190057	601320190496	1 MVIS
601320190057	601320190509	1 MVIS
601320190057	601320190516	1 MVIS
601320190057	601320190523	1 MVIS
601320190057	601320190530	1 MVIS
601320190057	601320190561	8 PMED
601320190057	601320190578	8 PMED
601470310042	601470310240	8 PMED
601470310042	601470310264	8 PMED
601470310042	601470310315	8 PMED
601470310042	601470310339	8 PMED
601510250029	601510250145	8 PMED
601510250029	601510250152	8 PMED
601510250029	601510250169	8 PMED
601510250029	601510250176	1 MVIS
601510250029	601510250183	8 PMED
601510250029	601510250190	8 PMED
601510250029	601510250203	8 PMED
601590210031	601590210047	8 PMED
601610270070	601610270456	8 PMED
601610270070	601610270463	8 PMED
601610270070	601610270723	1 MVIS
601610270070	601610270730	1 MVIS
601610270070	601610270747	1 MVIS
601610270070	601610270754	1 MVIS
601610270070	601610270898	8 PMED
601610270070	601610270918	8 PMED
601720130135	601720130851	8 PMED
601720130135	601720130882	8 PMED
601720130135	601720131296	8 PMED
601720130135	601720131309	8 PMED
601880440011	601880440100	1 MVIS
601880440011	601880440117	1 MVIS
601880440011	601880440124	1 MVIS
601880440011	601880440155	8 PMED
601880440011	601880440179	8 PMED
601880440011	601880440186	8 PMED
601880500011	601880500118	8 PMED
602040160074	602040160385	8 PMED
602090280120	602090280620	1 MVIS
602090280120	602090280637	1 MVIS
602090280120	602090280644	1 MVIS
602090280120	602090280651	1 MVIS
602320110025	602320110293	1 MVIS
602320110025	602320110351	8 PMED
602320110025	602320110440	8 PMED
602320110025	602320110464	8 PMED
602320110025	602320110508	8 PMED
602630240034	602630240221	8 PMED
602630240034	602630240252	8 PMED
602630240034	602630240269	8 PMED
602800190113	602800191214	3 EROM
602800190113	602800191310	8 PMED
602800190113	602800191365	8 PMED
602800190113	602800191478	1 MVIS
602800190113	602800191485	1 MVIS
602800190113	602800191865	8 PMED
602800260037	602800260362	1 MVIS
602800260037	602800260379	1 MVIS
602800260037	602800260386	3 EROM
602800260037	602800260393	4 STAZ

Return to Top

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

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	600420150021	600420150514	8 PMED
2	600730160010	600730160136	8 PMED
3	600730160010	600730160143	8 PMED
4	601200400010	601200400090	8 PMED
5	601200400010	601200400110	8 PMED
6	601280520010	601280520094	8 PMED
7	601320190057	601320190287	8 PMED
8	601320190057	601320190314	1 MVIS
9	601320190057	601320190321	1 MVIS
10	601320190057	601320190338	1 MVIS
11	601320190057	601320190403	8 PMED
12	601320190057	601320190458	8 PMED
13	601320190057	601320190465	8 PMED
14	601320190057	601320190472	8 PMED
15	601320190057	601320190496	1 MVIS
16	601320190057	601320190509	1 MVIS
17	601320190057	601320190516	1 MVIS
18	601320190057	601320190523	1 MVIS
19	601320190057	601320190530	1 MVIS
20	601320190057	601320190561	8 PMED
21	601320190057	601320190578	8 PMED
22	601470310042	601470310240	8 PMED
23	601470310042	601470310264	8 PMED
24	601470310042	601470310315	8 PMED
25	601470310042	601470310339	8 PMED
26	601510250029	601510250145	8 PMED
27	601510250029	601510250152	8 PMED
28	601510250029	601510250169	8 PMED
29	601510250029	601510250176	1 MVIS
30	601510250029	601510250183	8 PMED
31	601510250029	601510250190	8 PMED
32	601510250029	601510250203	8 PMED
33	601590210031	601590210047	8 PMED
34	601610270070	601610270456	8 PMED
35	601610270070	601610270463	8 PMED
36	601610270070	601610270723	1 MVIS
37	601610270070	601610270730	1 MVIS
38	601610270070	601610270747	1 MVIS
39	601610270070	601610270754	1 MVIS
40	601610270070	601610270898	8 PMED
41	601610270070	601610270918	8 PMED
42	601720130135	601720130851	8 PMED
43	601720130135	601720130882	8 PMED
44	601720130135	601720131296	8 PMED
45	601720130135	601720131309	8 PMED
46	601880440011	601880440100	1 MVIS
47	601880440011	601880440117	1 MVIS
48	601880440011	601880440124	1 MVIS
49	601880440011	601880440155	8 PMED
50	601880440011	601880440179	8 PMED

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	600420150514	8 PMED
2	600730160136	8 PMED
3	600730160143	8 PMED
4	601200400090	8 PMED
5	601200400110	8 PMED
6	601280520094	8 PMED
7	601320190287	8 PMED
8	601320190314	1 MVIS
9	601320190321	1 MVIS
10	601320190338	1 MVIS
11	601320190403	8 PMED
12	601320190458	8 PMED
13	601320190465	8 PMED
14	601320190472	8 PMED
15	601320190496	1 MVIS
16	601320190509	1 MVIS
17	601320190516	1 MVIS
18	601320190523	1 MVIS
19	601320190530	1 MVIS
20	601320190561	8 PMED
21	601320190578	8 PMED
22	601470310240	8 PMED
23	601470310264	8 PMED
24	601470310315	8 PMED
25	601470310339	8 PMED
26	601510250145	8 PMED
27	601510250152	8 PMED
28	601510250169	8 PMED
29	601510250176	1 MVIS
30	601510250183	8 PMED
31	601510250190	8 PMED
32	601510250203	8 PMED
33	601590210047	8 PMED
34	601610270456	8 PMED
35	601610270463	8 PMED
36	601610270723	1 MVIS
37	601610270730	1 MVIS
38	601610270747	1 MVIS
39	601610270754	1 MVIS
40	601610270898	8 PMED
41	601610270918	8 PMED
42	601720130851	8 PMED
43	601720130882	8 PMED
44	601720131296	8 PMED
45	601720131309	8 PMED
46	601880440100	1 MVIS
47	601880440117	1 MVIS
48	601880440124	1 MVIS
49	601880440155	8 PMED
50	601880440179	8 PMED

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	601320190314	1 MVIS
2	601320190321	1 MVIS
3	601320190338	1 MVIS
4	601320190496	1 MVIS
5	601320190509	1 MVIS
6	601320190516	1 MVIS
7	601320190523	1 MVIS
8	601320190530	1 MVIS
9	601510250176	1 MVIS
10	601610270723	1 MVIS
11	601610270730	1 MVIS
12	601610270747	1 MVIS
13	601610270754	1 MVIS
14	601880440100	1 MVIS
15	601880440117	1 MVIS
16	601880440124	1 MVIS
17	602090280620	1 MVIS
18	602090280637	1 MVIS
19	602090280644	1 MVIS
20	602090280651	1 MVIS
21	602320110293	1 MVIS
22	602800191478	1 MVIS
23	602800191485	1 MVIS
24	602800260362	1 MVIS
25	602800260379	1 MVIS
26	602800260622	1 MVIS
27	602800260646	1 MVIS
28	602800260660	1 MVIS
29	602800260800	1 MVIS
30	603020221359	1 MVIS
31	603020221366	1 MVIS
32	603080180428	1 MVIS
33	603460510187	1 MVIS
34	603830390106	1 MVIS
35	603830390113	1 MVIS
36	603830390120	1 MVIS
37	604160650084	1 MVIS
38	604160650091	1 MVIS
39	604160650135	1 MVIS
40	604240510507	1 MVIS
41	604240510514	1 MVIS
42	604390530215	1 MVIS
43	604390530222	1 MVIS
44	604390530239	1 MVIS
45	604390530246	1 MVIS
46	604720210356	1 MVIS
47	604720210483	1 MVIS
48	605040240532	1 MVIS
49	605040240549	1 MVIS
50	605300180443	1 MVIS

Return to Top

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

EVNTIDX	LINKIDX	EVENTYPE
600010290034	600010290089	1 MVIS
600040130117	600040130131	1 MVIS
600040130117	600040130148	1 MVIS
600040130117	600040130155	1 MVIS
600040130117	600040130162	1 MVIS
600040130124	600040130131	1 MVIS
600040130124	600040130148	1 MVIS
600040130124	600040130155	1 MVIS
600040130124	600040130162	1 MVIS
600040200100	600040200148	1 MVIS
600040200100	600040200155	1 MVIS
600070110238	600070110245	1 MVIS
600070110238	600070110252	1 MVIS
600070110238	600070110269	1 MVIS
600070110238	600070110276	1 MVIS
600070110238	600070110283	1 MVIS
600070280012	600070280036	1 MVIS
600070280012	600070280043	1 MVIS
600070280012	600070280050	1 MVIS
600070280067	600070280081	1 MVIS
600070280074	600070280098	1 MVIS
600070420067	600070420098	1 MVIS
600070580051	600070580075	1 MVIS
600080190106	600080190120	1 MVIS
600080190106	600080190137	1 MVIS
600080190106	600080190144	1 MVIS
600080190106	600080190151	1 MVIS
600110170178	600110170192	1 MVIS
600110170178	600110170205	1 MVIS
600110170178	600110170212	1 MVIS
600110170178	600110170229	1 MVIS
600110170178	600110170236	1 MVIS
600110170178	600110170243	1 MVIS
600110170178	600110170250	1 MVIS
600140190069	600140190090	1 MVIS
600140190076	600140190103	1 MVIS
600140190110	600140190134	1 MVIS
600140190127	600140190141	1 MVIS
600140260069	600140260076	1 MVIS
600140260069	600140260083	1 MVIS
600140260069	600140260090	1 MVIS
600170150565	600170150616	4 STAZ
600170150565	600170150623	4 STAZ
600170150565	600170150630	4 STAZ
600170150565	600170150647	4 STAZ
600170150596	600170150654	1 MVIS
600170150596	600170150661	1 MVIS
600170150596	600170150678	1 MVIS
600170150596	600170150685	1 MVIS
600170150596	600170150692	1 MVIS
600170150596	600170150705	1 MVIS
600170150596	600170150712	1 MVIS
600170150596	600170150729	1 MVIS
600170150596	600170150736	1 MVIS
600170150767	600170150849	1 MVIS
600170150774	600170150849	4 STAZ
600210100934	600210100989	1 MVIS
600220230373	600220230380	1 MVIS
600230110507	600230110552	1 MVIS
600270130043	600270130098	1 MVIS
600270130043	600270130101	1 MVIS
600270130043	600270130118	1 MVIS
600270370132	600270370194	1 MVIS
600270370214	600270370221	1 MVIS
600270370214	600270370238	1 MVIS
600280180046	600280180053	2 OPAT
600280320015	600280320046	1 MVIS
600280320022	600280320053	1 MVIS
600280490039	600280490077	1 MVIS
600280490046	600280490084	1 MVIS
600280550023	600280550030	1 MVIS
600280550061	600280550143	2 OPAT
600280550085	600280550150	1 MVIS
600290130123	600290130154	1 MVIS
600290130178	600290130192	1 MVIS
600300100049	600300100087	1 MVIS
600300270169	600300270227	1 MVIS
600300270183	600300270234	1 MVIS
600300270203	600300270241	1 MVIS
600300270210	600300270258	1 MVIS
600300270210	600300270265	1 MVIS
600350100010	600350100041	1 MVIS
600350100027	600350100058	3 EROM
600370280010	600370280034	5 DVIS
600380210015	600380210039	1 MVIS
600380210015	600380210046	1 MVIS
600380210022	600380210053	1 MVIS
600380210022	600380210060	1 MVIS
600380450022	600380450039	1 MVIS
600380450022	600380450046	1 MVIS
600390120051	600390120068	1 MVIS
600390590076	600390590090	1 MVIS
600400100480	600400100620	1 MVIS
600400101010	600400101072	1 MVIS
600400101010	600400101089	1 MVIS
600400101010	600400101096	1 MVIS
600400101010	600400101109	1 MVIS
600400101010	600400101116	1 MVIS
600400101010	600400101123	1 MVIS
600400101010	600400101130	1 MVIS
600400101010	600400101147	1 MVIS
600400101010	600400101154	1 MVIS
600400101010	600400101161	1 MVIS
600400101010	600400101178	1 MVIS
600400101010	600400101185	1 MVIS
600400101010	600400101192	1 MVIS
600400101010	600400101205	1 MVIS
600400101010	600400101212	1 MVIS
600420150336	600420150456	1 MVIS
600420150590	600420150761	1 MVIS
600420150590	600420150778	1 MVIS
600420150634	600420150785	1 MVIS
600440140064	600440140071	1 MVIS
600470460074	600470460081	1 MVIS
600490130402	600490130419	1 MVIS
600520180136	600520180198	1 MVIS
600520250516	600520250561	1 MVIS
600520250523	600520250578	1 MVIS
600520250643	600520250650	1 MVIS
600540170108	600540170139	5 DVIS
600570190982	600570191081	1 MVIS
600570191214	600570191245	1 MVIS
600570191290	600570191485	1 MVIS
600570191303	600570191492	1 MVIS
600570191327	600570191505	5 DVIS
600570260095	600570260146	1 MVIS
600590340138	600590340145	3 EROM
600590340138	600590340152	3 EROM
600610190646	600610190677	5 DVIS
600610260266	600610260280	1 MVIS
600610260266	600610260297	1 MVIS
600610260266	600610260300	1 MVIS
600610330071	600610330108	1 MVIS
600620120100	600620120124	5 DVIS
600620360100	600620360124	1 MVIS
600630170189	600630170223	3 EROM
600630170278	600630170312	1 MVIS
600630170285	600630170329	1 MVIS
600630170336	600630170343	1 MVIS
600630170336	600630170350	1 MVIS

Return to Top

HC-110I. 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
601510250176	601510250183	1 MVIS
601510250176	601510250190	1 MVIS
601510250176	601510250203	1 MVIS
601880440117	601880440155	1 MVIS
601880440117	601880440162	1 MVIS
601880440117	601880440179	1 MVIS
601880440117	601880440186	1 MVIS
602800260622	602800260704	1 MVIS
602800260622	602800260711	1 MVIS
602800260622	602800260728	1 MVIS
602800260622	602800260735	1 MVIS
602800260622	602800260742	1 MVIS
602800260622	602800260759	1 MVIS
602800260800	602800260848	1 MVIS
602800260800	602800260855	1 MVIS
603080180428	603080180459	1 MVIS
603080180428	603080180466	1 MVIS
603080180428	603080180473	1 MVIS
603460510187	603460510194	1 MVIS
603830390106	603830390137	1 MVIS
603830390106	603830390144	1 MVIS
604240510507	604240510521	1 MVIS
604240510514	604240510538	1 MVIS
604720210356	604720210414	1 MVIS
605510380195	605510380239	1 MVIS
605510380195	605510380246	1 MVIS
605510380195	605510380253	1 MVIS
605510380260	605510380284	1 MVIS
605510380260	605510380291	1 MVIS
605660121391	605660121428	1 MVIS
605660121391	605660121435	1 MVIS
605840370205	605840370212	1 MVIS
605840370205	605840370229	1 MVIS
605840370205	605840370236	1 MVIS
605840370250	605840370281	1 MVIS
605840370205	605840370298	1 MVIS
605840370301	605840370318	1 MVIS
607310102541	607310102630	1 MVIS
607990180122	607990180259	1 MVIS
607990180122	607990180266	1 MVIS
607990180122	607990180273	1 MVIS
607990180122	607990180280	1 MVIS
608720310070	608720310049	1 MVIS
608720310070	608720310056	1 MVIS
608720310087	608720310107	1 MVIS
608720310087	608720310114	1 MVIS
608720310087	608720310121	1 MVIS
608720310094	608720310138	1 MVIS
608780570042	608780570059	1 MVIS
610690470174	610690470218	1 MVIS

Return to Top

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

Obs	EVNTIDX	LINKIDX	EVENTYPE
1	601510250176	601510250183	1 MVIS
2	601510250176	601510250190	1 MVIS
3	601510250176	601510250203	1 MVIS
4	601880440117	601880440155	1 MVIS
5	601880440117	601880440162	1 MVIS
6	601880440117	601880440179	1 MVIS
7	601880440117	601880440186	1 MVIS
8	602800260622	602800260704	1 MVIS
9	602800260622	602800260711	1 MVIS
10	602800260622	602800260728	1 MVIS
11	602800260622	602800260735	1 MVIS
12	602800260622	602800260742	1 MVIS
13	602800260622	602800260759	1 MVIS
14	602800260800	602800260848	1 MVIS
15	602800260800	602800260855	1 MVIS
16	603080180428	603080180459	1 MVIS
17	603080180428	603080180466	1 MVIS
18	603080180428	603080180473	1 MVIS
19	603460510187	603460510194	1 MVIS
20	603830390106	603830390137	1 MVIS
21	603830390106	603830390144	1 MVIS
22	604240510507	604240510521	1 MVIS
23	604240510514	604240510538	1 MVIS
24	604720210356	604720210414	1 MVIS
25	605510380195	605510380239	1 MVIS
26	605510380195	605510380246	1 MVIS
27	605510380195	605510380253	1 MVIS
28	605510380260	605510380284	1 MVIS
29	605510380260	605510380291	1 MVIS
30	605660121391	605660121428	1 MVIS
31	605660121391	605660121435	1 MVIS
32	605840370205	605840370212	1 MVIS
33	605840370205	605840370229	1 MVIS
34	605840370205	605840370236	1 MVIS
35	605840370250	605840370281	1 MVIS
36	605840370250	605840370298	1 MVIS
37	605840370301	605840370318	1 MVIS
38	607310102541	607310102630	1 MVIS
39	607990180122	607990180259	1 MVIS
40	607990180122	607990180266	1 MVIS
41	607990180122	607990180273	1 MVIS
42	607990180122	607990180280	1 MVIS
43	608720310070	608720310049	1 MVIS
44	608720310070	608720310056	1 MVIS
45	608720310087	608720310107	1 MVIS
46	608720310087	608720310114	1 MVIS
47	608720310087	608720310121	1 MVIS
48	608720310094	608720310138	1 MVIS
49	608780570042	608780570059	1 MVIS
50	610690470174	610690470218	1 MVIS

Return to Top

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

Obs	LINKIDX
1	601510250183
2	601510250190
3	601510250203
4	601880440155
5	601880440162
6	601880440179
7	601880440186
8	602800260704
9	602800260711
10	602800260728
11	602800260735
12	602800260742
13	602800260759
14	602800260848
15	602800260855
16	603080180459
17	603080180466
18	603080180473
19	603460510194
20	603830390137
21	603830390144
22	604240510521
23	604240510538
24	604720210414
25	605510380239
26	605510380246
27	605510380253
28	605510380284
29	605510380291
30	605660121428
31	605660121435
32	605840370212
33	605840370229
34	605840370236
35	605840370281
36	605840370298
37	605840370318
38	607310102630
39	607990180259
40	607990180266
41	607990180273
42	607990180280
43	608720310049
44	608720310056
45	608720310107
46	608720310114
47	608720310121
48	608720310138
49	608780570059
50	610690470218

Return to Top

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

LINKIDX	RXRECIDX	RXNAME	RXXP07X	PERWT07F
601510250183	601510250183001	SINGULAIR (UNIT OF USE)	110.66	8732.59
601510250183	601510250183002	SINGULAIR (UNIT OF USE)	110.66	8732.59
601510250183	601510250183003	SINGULAIR (UNIT OF USE)	110.66	8732.59
601510250190	601510250190001	ALBUTEROL	23.41	8732.59
601510250190	601510250190002	ALBUTEROL	23.41	8732.59
601510250190	601510250190003	ALBUTEROL	23.41	8732.59
601510250203	601510250203001	ADVAIR DISK	186.06	8732.59
601510250203	601510250203002	ADVAIR DISK	186.06	8732.59
601510250203	601510250203003	ADVAIR DISK	186.06	8732.59
601880440155	601880440155001	ALBUTEROL	23.13	11208.77
601880440162	601880440162001	FLUTICASONE PROPIONATE	43.91	11208.77
601880440179	601880440179001	AEROCHAMBER	52.59	11208.77
601880440186	601880440186001	AEROCHAMBER	52.59	11208.77
602800260704	602800260704001	MUCINEX	28.73	2974.09
602800260704	602800260704002	MUCINEX	28.73	2974.09
602800260711	602800260711001	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260711	602800260711002	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260711	602800260711003	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260711	602800260711004	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260711	602800260711005	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260711	602800260711006	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260728	602800260728001	ATROVENT HFA	79.85	2974.09
602800260728	602800260728002	ATROVENT HFA	79.85	2974.09
602800260728	602800260728003	ATROVENT HFA	79.85	2974.09
602800260728	602800260728004	ATROVENT HFA	79.85	2974.09
602800260728	602800260728005	ATROVENT HFA	79.85	2974.09
602800260728	602800260728006	ATROVENT HFA	79.85	2974.09
602800260735	602800260735001	FLOVENT HFA	111.53	2974.09
602800260735	602800260735002	FLOVENT HFA	111.53	2974.09
602800260735	602800260735003	FLOVENT HFA	111.53	2974.09
602800260735	602800260735004	FLOVENT HFA	111.53	2974.09
602800260735	602800260735005	FLOVENT HFA	111.53	2974.09
602800260735	602800260735006	FLOVENT HFA	111.53	2974.09
602800260742	602800260742001	FORTEO (DISPOSABLE,RDNA ORIGIN)	694.26	2974.09
602800260742	602800260742002	FORTEO (DISPOSABLE,RDNA ORIGIN)	694.26	2974.09
602800260742	602800260742003	FORTEO (DISPOSABLE,RDNA ORIGIN)	694.26	2974.09
602800260742	602800260742004	FORTEO (DISPOSABLE,RDNA ORIGIN)	694.26	2974.09
602800260742	602800260742005	FORTEO (DISPOSABLE,RDNA ORIGIN)	694.26	2974.09
602800260742	602800260742006	FORTEO (DISPOSABLE,RDNA ORIGIN)	694.26	2974.09
602800260759	602800260759001	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260759	602800260759002	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260759	602800260759003	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260759	602800260759004	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260759	602800260759005	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260759	602800260759006	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260848	602800260848001	XOPENEX HFA (200 ACTUATIONS)	43.54	2974.09
602800260848	602800260848002	XOPENEX HFA (200 ACTUATIONS)	43.54	2974.09
602800260855	602800260855001	FLOVENT HFA	111.53	2974.09
602800260855	602800260855002	FLOVENT HFA	111.53	2974.09
603080180459	603080180459001	SPIRIVA (W/HANDIHALER)	125.76	11687.12
603080180459	603080180459002	SPIRIVA (W/HANDIHALER)	125.76	11687.12
603080180459	603080180459003	SPIRIVA (W/HANDIHALER)	125.76	11687.12
603080180466	603080180466001	ADVAIR DISKUS 250/50	183.68	11687.12
603080180466	603080180466002	ADVAIR DISKUS 250/50	183.68	11687.12
603080180466	603080180466003	ADVAIR DISKUS 250/50	183.68	11687.12
603080180473	603080180473001	ALBUTEROL	8.00	11687.12
603080180473	603080180473002	ALBUTEROL	8.00	11687.12
603080180473	603080180473003	ALBUTEROL	8.00	11687.12
603460510194	603460510194001	SINGULAIR	103.33	7717.80
603830390137	603830390137001	ALBUTEROL	12.89	6243.18
603830390137	603830390137002	ALBUTEROL	12.89	6243.18
603830390137	603830390137003	ALBUTEROL	20.54	6243.18
603830390144	603830390144001	SINGULAIR	103.33	6243.18
604240510521	604240510521001	NASONEX	79.51	11477.95
604240510538	604240510538001	PREDNISONE	4.83	11477.95
604720210414	604720210414001	ALBUTEROL	10.00	17999.36
605510380239	605510380239001	ASMANEX TWISTHALER (60-INHALATION)	96.06	10301.48
605510380246	605510380246001	PROAIR HFA	92.08	10301.48
605510380253	605510380253001	PREDNISONE	2.80	10301.48
605510380284	605510380284001	ADVAIR DISKUS 100/50	150.23	10301.48
605510380291	605510380291001	PREDNISONE	3.04	10301.48
605660121428	605660121428001	SINGULAIR (UNIT OF USE)	97.67	8924.35
605660121435	605660121435001	ALBUTEROL	18.46	8924.35
605840370212	605840370212001	ALBUTEROL	24.99	6961.73
605840370212	605840370212002	ALBUTEROL	24.99	6961.73
605840370229	605840370229001	ADVAIR	175.92	6961.73
605840370236	605840370236001	CIPRO HC	91.49	6961.73
605840370281	605840370281001	ALBUTEROL	31.43	6961.73
605840370281	605840370281002	ALBUTEROL	31.43	6961.73
605840370298	605840370298001	ADVAIR	175.92	6961.73
605840370298	605840370298002	ADVAIR	175.92	6961.73
605840370318	605840370318001	ALBUTEROL	24.99	6961.73
607310102630	607310102630001	PREDNISONE	2.95	24811.46
607990180259	607990180259001	NAPROXEN	20.42	3450.93
607990180259	607990180259002	NAPROXEN	20.42	3450.93
607990180259	607990180259003	NAPROXEN	20.42	3450.93
607990180259	607990180259004	NAPROXEN	20.42	3450.93
607990180259	607990180259005	NAPROXEN	20.42	3450.93
607990180266	607990180266001	PREVACID	583.17	3450.93
607990180266	607990180266002	PREVACID	583.17	3450.93
607990180266	607990180266003	PREVACID	583.17	3450.93
607990180266	607990180266004	PREVACID	583.17	3450.93
607990180266	607990180266005	PREVACID	583.17	3450.93
607990180273	607990180273001	IBUPROFEN	10.00	3450.93
607990180273	607990180273002	IBUPROFEN	10.00	3450.93
607990180273	607990180273003	IBUPROFEN	10.00	3450.93
607990180273	607990180273004	IBUPROFEN	10.00	3450.93
607990180273	607990180273005	IBUPROFEN	10.00	3450.93
607990180280	607990180280001	EFFEXOR-XR	100.86	3450.93
607990180280	607990180280002	EFFEXOR-XR	100.86	3450.93
607990180280	607990180280003	EFFEXOR-XR	100.86	3450.93
608720310049	608720310049001	ADVAIR DISKUS 500/50	240.00	3201.68
608720310049	608720310049002	ADVAIR DISKUS 500/50	240.00	3201.68
608720310056	608720310056001	FLUTICASONE PROPIONATE	43.92	3201.68
608720310056	608720310056002	FLUTICASONE PROPIONATE	41.42	3201.68
608720310107	608720310107001	ALBUTEROL SULFATE (25X3ML,LDPE)	20.88	3201.68
608720310107	608720310107002	ALBUTEROL SULFATE (25X3ML,LDPE)	20.88	3201.68
608720310107	608720310107003	ALBUTEROL SULFATE (25X3ML,LDPE)	20.88	3201.68
608720310107	608720310107004	ALBUTEROL SULFATE (25X3ML,LDPE)	20.88	3201.68
608720310107	608720310107005	ALBUTEROL SULFATE (25X3ML,LDPE)	20.88	3201.68
608720310114	608720310114001	FLUTICASONE PROPIONATE	41.42	3201.68
608720310107	608720310114002	FLUTICASONE PROPIONATE	41.42	3201.68
608720310107	608720310114003	FLUTICASONE PROPIONATE	40.00	3201.68
608720310107	608720310114004	FLUTICASONE PROPIONATE	41.42	3201.68
608720310107	608720310114005	FLUTICASONE PROPIONATE	40.00	3201.68
608720310121	608720310121001	ADVAIR DISKUS 500/50	240.00	3201.68
608720310121	608720310121002	ADVAIR DISKUS 500/50	240.00	3201.68
608720310121	608720310121003	ADVAIR DISKUS 500/50	240.00	3201.68
608720310121	608720310121004	ADVAIR DISKUS 500/50	240.00	3201.68
608720310121	608720310121005	ADVAIR DISKUS 500/50	240.00	3201.68
608720310138	608720310138001	SINGULAIR	103.33	3201.68
608720310138	608720310138002	SINGULAIR	103.33	3201.68
608780570059	608780570059001	PULMICORT RESPULES (5X6)	173.83	10095.32
610690470218	610690470218001	PEDIATAN D (SF,BUBBLEGUM)	25.95	5960.67
610690470218	610690470218002	PEDIATAN D (SF,BUBBLEGUM)	25.95	5960.67
610690470232	610690470232001	DERMA-SMOOTHE/FS (SCALP OIL)	36.77	5960.67
610690470249	610690470249001	SINGULAIR	125.52	5960.67
610690470256	610690470256001	FLOXIN	101.01	5960.67
610690470263	610690470263001	PRYTHOMYCIN	9.39	5960.67
610690470287	610690470287001	ENULOSE	2.56	5960.67
610690470307	610690470307001	XOPENEX HFA (200 ACTUATIONS)	86.42	5960.67
610690470307	610690470307002	XOPENEX HFA (200 ACTUATIONS)	86.42	5960.67
611060212185	611060212185001	GABAPENTIN	8.21	13778.38
611060212185	611060212185002	GABAPENTIN	8.15	13778.38
611060212185	611060212185003	GABAPENTIN	8.15	13778.38
611060212185	611060212185004	GABAPENTIN	5.06	13778.38
611060212185	611060212185005	GABAPENTIN	8.21	13778.38
611060212185	611060212185006	GABAPENTIN	8.09	13778.38
611060212192	611060212192001	FUROSEMIDE	8.00	13778.38
611060212192	611060212192002	FUROSEMIDE	8.00	13778.38
611060212192	611060212192003	FUROSEMIDE	8.00	13778.38
611060212192	611060212192004	FUROSEMIDE	8.00	13778.38
611060212192	611060212192005	FUROSEMIDE	8.00	13778.38
611060212192	611060212192006	FUROSEMIDE	8.00	13778.38
611060212212	611060212212001	PREVACID	145.79	13778.38
611060212212	611060212212002	PREVACID	145.79	13778.38
611060212212	611060212212003	PREVACID	145.79	13778.38
611060212212	611060212212004	PREVACID	145.79	13778.38
611060212212	611060212212005	PREVACID	145.79	13778.38
611060212212	611060212212006	PREVACID	145.79	13778.38
611060212229	611060212229001	PROPRANOLOL HCL	10.80	13778.38
611060212229	611060212229002	PROPRANOLOL HCL	10.80	13778.38
611060212229	611060212229003	PROPRANOLOL HCL	10.80	13778.38
611060212229	611060212229004	PROPRANOLOL HCL	10.80	13778.38
611060212229	611060212229005	PROPRANOLOL HCL	10.80	13778.38
611060212229	611060212229006	PROPRANOLOL HCL	10.80	13778.38
611060212243	611060212243001	PROAIR HFA	32.23	13778.38
611060212243	611060212243002	PROAIR HFA	30.00	13778.38
611060212243	611060212243003	PROAIR HFA	30.00	13778.38
611060212243	611060212243004	PROAIR HFA	32.23	13778.38
611060212243	611060212243005	PROAIR HFA	32.23	13778.38
611060212243	611060212243006	PROAIR HFA	30.00	13778.38
611060212250	611060212250001	LISINOPRIL	13.96	13778.38
611060212250	611060212250002	LISINOPRIL	13.96	13778.38
611060212250	611060212250003	LISINOPRIL	13.96	13778.38
611060212250	611060212250004	LISINOPRIL	13.96	13778.38
611060212250	611060212250005	LISINOPRIL	13.96	13778.38
611060212250	611060212250006	LISINOPRIL	13.96	13778.38
611060212267	611060212267001	CARBIDOPA/LEVODOPA	17.36	13778.38
611060212267	611060212267002	CARBIDOPA/LEVODOPA	17.36	13778.38
611060212267	611060212267003	CARBIDOPA/LEVODOPA	17.36	13778.38
611060212267	611060212267004	CARBIDOPA/LEVODOPA	17.36	13778.38
611060212267	611060212267005	CARBIDOPA/LEVODOPA	17.36	13778.38
611060212267	611060212267006	CARBIDOPA/LEVODOPA	17.36	13778.38
611060212274	611060212274001	ADVAIR DISKUS 100/50	144.52	13778.38
611060212274	611060212274002	ADVAIR DISKUS 100/50	144.52	13778.38
611060212274	611060212274003	ADVAIR DISKUS 100/50	144.52	13778.38
611060212274	611060212274004	ADVAIR DISKUS 100/50	144.52	13778.38
611060212274	611060212274005	ADVAIR DISKUS 100/50	144.52	13778.38
611060212274	611060212274006	ADVAIR DISKUS 100/50	144.52	13778.38
611060212281	611060212281001	VYTORIN	89.37	13778.38
611060212281	611060212281002	VYTORIN	89.37	13778.38
611060212281	611060212281003	VYTORIN	89.37	13778.38
611060212281	611060212281004	VYTORIN	89.37	13778.38
611060212281	611060212281005	VYTORIN	89.37	13778.38
611060212281	611060212281006	VYTORIN	89.37	13778.38
611060212298	611060212298001	FLUTICASONE PROPIONATE	40.76	13778.38
611060212298	611060212298002	FLUTICASONE PROPIONATE	40.76	13778.38
611060212298	611060212298003	FLUTICASONE PROPIONATE	40.76	13778.38
611060212298	611060212298004	FLUTICASONE PROPIONATE	40.76	13778.38
611060212298	611060212298005	FLUTICASONE PROPIONATE	40.76	13778.38
611060212298	611060212298006	FLUTICASONE PROPIONATE	40.76	13778.38
611060212301	611060212301001	FEXOFENADINE HCL (FILM-COATED)	40.86	13778.38
611060212301	611060212301002	FEXOFENADINE HCL (FILM-COATED)	40.86	13778.38
611060212301	611060212301003	FEXOFENADINE HCL (FILM-COATED)	40.86	13778.38
611060212301	611060212301004	FEXOFENADINE HCL (FILM-COATED)	40.86	13778.38
611060212301	611060212301005	FEXOFENADINE HCL (FILM-COATED)	40.86	13778.38
611060212301	611060212301006	FEXOFENADINE HCL (FILM-COATED)	40.86	13778.38
611060212318	611060212318001	FLOVENT HFA	111.53	13778.38
611460240064	611460240064001	PROAIR HFA	25.00	2401.79

Return to Top

HC-110I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Analysis Variable : RXXP07X SUM OF PAYMENTS RXSF07X-RXOU07X(IMPUTED)

N	Sum
4729	409852.29

Return to Top

HC-110I. Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
Analysis Variable : RXXP07X SUM OF PAYMENTS RXSF07X-RXOU07X(IMPUTED)

N	Sum
4729	3684494356

Return to Top

NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to WESTAT INC, Site 0009005004.
NOTE: This session is executing on the XP_PRO platform.

NOTE: SAS 9.1.3 Service Pack 4

NOTE: SAS initialization used:
real time 1.76 seconds
cpu time 0.21 seconds

NOTE: AUTOEXEC processing beginning; file is C:\Program Files\SAS\SAS 9.1\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-110I";
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.00 seconds

26
27 *--------------------------------------------------------------------------------------
28 * Get condition records coded as asthma.
29 *--------------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H112 (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 (H112) 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.15 seconds
cpu time 0.06 seconds

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

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

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

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

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

91
92 proc print data=aspmeds (obs=300);
93 by linkidx;
94 id linkidx;
95 var rxrecidx rxname RXXP07X PERWT07F;
96 title3 "sample print of work.aspmeds";
97 title4 "PMED (HC-110A) 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.18 seconds
cpu time 0.03 seconds

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

NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 9334 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.12 seconds
cpu time 0.01 seconds

104
105 PROC MEANS DATA=ASPMEDS N SUM;
106 VAR RXXP07X;
107 WEIGHT PERWT07F;
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 9334 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.06 seconds
cpu time 0.06 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 14.03 seconds
cpu time 1.98 seconds

Return to Top

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

Obs	CONDIDX	CCCODEX
1	600140260030	128
2	600250160011	128
3	600420150021	128
4	600730160010	128
5	601190220021	128
6	601200400010	128
7	601280520010	128
8	601320190057	128
9	601470310042	128
10	601510250029	128
11	601540680041	128
12	601590210031	128
13	601610270070	128
14	601720130135	128
15	601880440011	128
16	601880500011	128
17	602040160074	128
18	602090280120	128
19	602320110025	128
20	602410530021	128
21	602540340014	128
22	602630240034	128
23	602800190113	128
24	602800260037	128
25	602810160112	128
26	602850570028	128
27	602850640027	128
28	603020220037	128
29	603080180025	128
30	603140370012	128
31	603330280077	128
32	603330580019	128
33	603460450066	128
34	603460510022	128
35	603830390020	128
36	604010140032	128
37	604160650018	128
38	604240510022	128
39	604390530030	128
40	604440230087	128
41	604540290026	128
42	604570180068	128
43	604590140042	128
44	604640160020	128
45	604640300034	128
46	604710170023	128
47	604720210032	128
48	604770480018	128
49	604970100037	128
50	605040240062	128

Return to Top

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

CONDIDX	EVNTIDX	EVENTYPE
600420150021	600420150514	8 PMED
600730160010	600730160136	8 PMED
600730160010	600730160143	8 PMED
601200400010	601200400090	8 PMED
601200400010	601200400110	8 PMED
601280520010	601280520094	8 PMED
601320190057	601320190287	8 PMED
601320190057	601320190314	1 MVIS
601320190057	601320190321	1 MVIS
601320190057	601320190338	1 MVIS
601320190057	601320190403	8 PMED
601320190057	601320190458	8 PMED
601320190057	601320190465	8 PMED
601320190057	601320190472	8 PMED
601320190057	601320190496	1 MVIS
601320190057	601320190509	1 MVIS
601320190057	601320190516	1 MVIS
601320190057	601320190523	1 MVIS
601320190057	601320190530	1 MVIS
601320190057	601320190561	8 PMED
601320190057	601320190578	8 PMED
601470310042	601470310240	8 PMED
601470310042	601470310264	8 PMED
601470310042	601470310315	8 PMED
601470310042	601470310339	8 PMED
601510250029	601510250145	8 PMED
601510250029	601510250152	8 PMED
601510250029	601510250169	8 PMED
601510250029	601510250176	1 MVIS
601510250029	601510250183	8 PMED
601510250029	601510250190	8 PMED
601510250029	601510250203	8 PMED
601590210031	601590210047	8 PMED
601610270070	601610270456	8 PMED
601610270070	601610270463	8 PMED
601610270070	601610270723	1 MVIS
601610270070	601610270730	1 MVIS
601610270070	601610270747	1 MVIS
601610270070	601610270754	1 MVIS
601610270070	601610270898	8 PMED
601610270070	601610270918	8 PMED
601720130135	601720130851	8 PMED
601720130135	601720130882	8 PMED
601720130135	601720131296	8 PMED
601720130135	601720131309	8 PMED
601880440011	601880440100	1 MVIS
601880440011	601880440117	1 MVIS
601880440011	601880440124	1 MVIS
601880440011	601880440155	8 PMED
601880440011	601880440179	8 PMED
601880440011	601880440186	8 PMED
601880500011	601880500118	8 PMED
602040160074	602040160385	8 PMED
602090280120	602090280620	1 MVIS
602090280120	602090280637	1 MVIS
602090280120	602090280644	1 MVIS
602090280120	602090280651	1 MVIS
602320110025	602320110293	1 MVIS
602320110025	602320110351	8 PMED
602320110025	602320110440	8 PMED
602320110025	602320110464	8 PMED
602320110025	602320110508	8 PMED
602630240034	602630240221	8 PMED
602320110025	602630240252	8 PMED
602320110025	602630240269	8 PMED
602800190113	602800191214	3 EROM
602800190113	602800191310	8 PMED
602800190113	602800191365	8 PMED
602800190113	602800191478	1 MVIS
602800190113	602800191485	1 MVIS
602800190113	602800191865	8 PMED
602800260037	602800260362	1 MVIS
602800260037	602800260379	1 MVIS
602800260037	602800260386	3 EROM
602800260037	602800260393	4 STAZ

Return to Top

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

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	600420150021	600420150514	8 PMED
2	600730160010	600730160136	8 PMED
3	600730160010	600730160143	8 PMED
4	601200400010	601200400090	8 PMED
5	601200400010	601200400110	8 PMED
6	601280520010	601280520094	8 PMED
7	601320190057	601320190287	8 PMED
8	601320190057	601320190314	1 MVIS
9	601320190057	601320190321	1 MVIS
10	601320190057	601320190338	1 MVIS
11	601320190057	601320190403	8 PMED
12	601320190057	601320190458	8 PMED
13	601320190057	601320190465	8 PMED
14	601320190057	601320190472	8 PMED
15	601320190057	601320190496	1 MVIS
16	601320190057	601320190509	1 MVIS
17	601320190057	601320190516	1 MVIS
18	601320190057	601320190523	1 MVIS
19	601320190057	601320190530	1 MVIS
20	601320190057	601320190561	8 PMED
21	601320190057	601320190578	8 PMED
22	601470310042	601470310240	8 PMED
23	601470310042	601470310264	8 PMED
24	601470310042	601470310315	8 PMED
25	601470310042	601470310339	8 PMED
26	601510250029	601510250145	8 PMED
27	601510250029	601510250152	8 PMED
28	601510250029	601510250169	8 PMED
29	601510250029	601510250176	1 MVIS
30	601510250029	601510250183	8 PMED
31	601510250029	601510250190	8 PMED
32	601510250029	601510250203	8 PMED
33	601590210031	601590210047	8 PMED
34	601610270070	601610270456	8 PMED
35	601610270070	601610270463	8 PMED
36	601610270070	601610270723	1 MVIS
37	601610270070	601610270730	1 MVIS
38	601610270070	601610270747	1 MVIS
39	601610270070	601610270754	1 MVIS
40	601610270070	601610270898	8 PMED
41	601610270070	601610270918	8 PMED
42	601720130135	601720130851	8 PMED
43	601720130135	601720130882	8 PMED
44	601720130135	601720131296	8 PMED
45	601720130135	601720131309	8 PMED
46	601880440011	601880440100	1 MVIS
47	601880440011	601880440117	1 MVIS
48	601880440011	601880440124	1 MVIS
49	601880440011	601880440155	8 PMED
50	601880440011	601880440179	8 PMED

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	600420150514	8 PMED
2	600730160136	8 PMED
3	600730160143	8 PMED
4	601200400090	8 PMED
5	601200400110	8 PMED
6	601280520094	8 PMED
7	601320190287	8 PMED
8	601320190314	1 MVIS
9	601320190321	1 MVIS
10	601320190338	1 MVIS
11	601320190403	8 PMED
12	601320190458	8 PMED
13	601320190465	8 PMED
14	601320190472	8 PMED
15	601320190496	1 MVIS
16	601320190509	1 MVIS
17	601320190516	1 MVIS
18	601320190523	1 MVIS
19	601320190530	1 MVIS
20	601320190561	8 PMED
21	601320190578	8 PMED
22	601470310240	8 PMED
23	601470310264	8 PMED
24	601470310315	8 PMED
25	601470310339	8 PMED
26	601510250145	8 PMED
27	601510250152	8 PMED
28	601510250169	8 PMED
29	601510250176	1 MVIS
30	601510250183	8 PMED
31	601510250190	8 PMED
32	601510250203	8 PMED
33	601590210047	8 PMED
34	601610270456	8 PMED
35	601610270463	8 PMED
36	601610270723	1 MVIS
37	601610270730	1 MVIS
38	601610270747	1 MVIS
39	601610270754	1 MVIS
40	601610270898	8 PMED
41	601610270918	8 PMED
42	601720130851	8 PMED
43	601720130882	8 PMED
44	601720131296	8 PMED
45	601720131309	8 PMED
46	601880440100	1 MVIS
47	601880440117	1 MVIS
48	601880440124	1 MVIS
49	601880440155	8 PMED
50	601880440179	8 PMED

Return to Top

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

LINKIDX	RXRECIDX	RXNAME	RXXP07X	PERWT07F
600420150514	600420150514001	RHINOCORT NASAL SPRAY	80.34	5685.08
600420150514	600420150514002	RHINOCORT NASAL SPRAY	80.34	5685.08
600420150514	600420150514003	RHINOCORT NASAL SPRAY	80.34	5685.08
600420150514	600420150514004	RHINOCORT NASAL SPRAY	80.34	5685.08
600730160136	600730160136001	ALBUTEROL	12.13	7362.56
600730160143	600730160143001	ADVAIR DISKUS 100/50	144.46	7362.56
601200400090	601200400090001	SINGULAIR (UNIT OF USE)	60.00	9205.09
601200400090	601200400090002	SINGULAIR (UNIT OF USE)	60.00	9205.09
601200400090	601200400090003	SINGULAIR (UNIT OF USE)	60.00	9205.09
601200400090	601200400090004	SINGULAIR (UNIT OF USE)	60.00	9205.09
601200400090	601200400090005	SINGULAIR (UNIT OF USE)	60.00	9205.09
601200400090	601200400090006	SINGULAIR (UNIT OF USE)	60.00	9205.09
601200400090	601200400090007	SINGULAIR (UNIT OF USE)	60.00	9205.09
601200400110	601200400110001	SINGULAIR (UNIT OF USE)	60.00	9205.09
601200400110	601200400110002	SINGULAIR (UNIT OF USE)	97.55	9205.09
601200400110	601200400110003	SINGULAIR (UNIT OF USE)	60.00	9205.09
601200400110	601200400110004	SINGULAIR (UNIT OF USE)	60.00	9205.09
601200400110	601200400110005	SINGULAIR (UNIT OF USE)	60.00	9205.09
601200400110	601200400110006	SINGULAIR (UNIT OF USE)	97.55	9205.09
601280520094	601280520094001	ALBUTEROL	16.69	8522.73
601320190287	601320190287001	ALBUTEROL	6.00	4671.36
601320190403	601320190403001	ED-BRON G (ORANGE)	19.25	4671.36
601320190403	601320190403002	ED-BRON G (ORANGE)	19.25	4671.36
601320190403	601320190403003	ED-BRON G (ORANGE)	19.25	4671.36
601320190403	601320190403004	ED-BRON G (ORANGE)	19.25	4671.36
601320190403	601320190403005	ED-BRON G (ORANGE)	19.25	4671.36
601320190403	601320190403006	ED-BRON G (ORANGE)	19.25	4671.36
601320190458	601320190458001	SINGULAIR (UNIT OF USE)	98.28	4671.36
601320190458	601320190458002	SINGULAIR (UNIT OF USE)	98.28	4671.36
601320190458	601320190458003	SINGULAIR (UNIT OF USE)	98.28	4671.36
601320190458	601320190458004	SINGULAIR (UNIT OF USE)	98.28	4671.36
601320190458	601320190458005	SINGULAIR (UNIT OF USE)	98.28	4671.36
601320190465	601320190465001	ADVAIR DISKUS 500/50	246.64	4671.36
601320190465	601320190465002	ADVAIR DISKUS 500/50	246.64	4671.36
601320190465	601320190465003	ADVAIR DISKUS 500/50	246.64	4671.36
601320190465	601320190465004	ADVAIR DISKUS 500/50	246.64	4671.36
601320190465	601320190465005	ADVAIR DISKUS 500/50	246.64	4671.36
601320190472	601320190472001	PROMETHAZINE WITH CODEINE (GRAPE)	18.45	4671.36
601320190472	601320190472002	PROMETHAZINE WITH CODEINE (GRAPE)	18.45	4671.36
601320190472	601320190472003	PROMETHAZINE WITH CODEINE (GRAPE)	18.45	4671.36
601320190472	601320190472004	PROMETHAZINE WITH CODEINE (GRAPE)	18.45	4671.36
601320190472	601320190472005	PROMETHAZINE WITH CODEINE (GRAPE)	18.45	4671.36
601320190561	601320190561001	SINGULAIR (UNIT OF USE)	98.28	4671.36
601320190561	601320190561002	SINGULAIR (UNIT OF USE)	98.28	4671.36
601320190561	601320190561003	SINGULAIR (UNIT OF USE)	98.28	4671.36
601320190561	601320190561004	SINGULAIR (UNIT OF USE)	97.13	4671.36
601320190561	601320190561005	SINGULAIR (UNIT OF USE)	98.28	4671.36
601320190578	601320190578001	ADVAIR DISKUS 500/50	246.64	4671.36
601320190578	601320190578002	ADVAIR DISKUS 500/50	246.64	4671.36
601320190578	601320190578003	ADVAIR DISKUS 500/50	246.64	4671.36
601320190578	601320190578004	ADVAIR DISKUS 500/50	246.64	4671.36
601320190578	601320190578005	ADVAIR DISKUS 500/50	246.64	4671.36
601470310240	601470310240001	SINGULAIR	64.39	10895.28
601470310240	601470310240002	SINGULAIR	64.39	10895.28
601470310240	601470310240003	SINGULAIR	64.39	10895.28
601470310240	601470310240004	SINGULAIR	64.39	10895.28
601470310240	601470310240005	SINGULAIR	64.39	10895.28
601470310264	601470310264001	PROVENTIL	101.77	10895.28
601470310264	601470310264002	PROVENTIL	101.77	10895.28
601470310264	601470310264003	PROVENTIL	101.77	10895.28
601470310264	601470310264004	PROVENTIL	101.77	10895.28
601470310315	601470310315001	SINGULAIR	64.39	10895.28
601470310315	601470310315002	SINGULAIR	64.39	10895.28
601470310339	601470310339001	PROVENTIL	101.77	10895.28
601510250145	601510250145001	SINGULAIR (UNIT OF USE)	109.04	8732.59
601470310315	601510250145002	SINGULAIR (UNIT OF USE)	109.04	8732.59
601510250152	601510250152001	ALBUTEROL	20.27	8732.59
601510250152	601510250152002	ALBUTEROL	20.27	8732.59
601510250169	601510250169001	ADVAIR DISKUS 250/50	189.14	8732.59
601510250169	601510250169002	ADVAIR DISKUS 250/50	189.14	8732.59
601510250183	601510250183001	SINGULAIR (UNIT OF USE)	110.66	8732.59
601510250183	601510250183002	SINGULAIR (UNIT OF USE)	110.66	8732.59
601510250183	601510250183003	SINGULAIR (UNIT OF USE)	110.66	8732.59
601510250190	601510250190001	ALBUTEROL	23.41	8732.59
601510250190	601510250190002	ALBUTEROL	23.41	8732.59
601510250190	601510250190003	ALBUTEROL	23.41	8732.59
601510250203	601510250203001	ADVAIR DISK	186.06	8732.59
601510250203	601510250203002	ADVAIR DISK	186.06	8732.59
601510250203	601510250203003	ADVAIR DISK	186.06	8732.59
601590210047	601590210047001	ALBUTEROL	10.00	14889.05
601590210047	601590210047002	ALBUTEROL	10.00	14889.05
601590210047	601590210047003	ALBUTEROL	10.00	14889.05
601590210047	601590210047004	ALBUTEROL	10.00	14889.05
601590210047	601590210047005	ALBUTEROL	10.00	14889.05
601610270456	601610270456001	PROAIR HFA	34.13	17874.38
601610270456	601610270456002	PROAIR HFA	34.13	17874.38
601610270456	601610270456003	PROAIR HFA	34.13	17874.38
601610270456	601610270456004	PROAIR HFA	34.13	17874.38
601610270456	601610270456005	PROAIR HFA	34.13	17874.38
601610270463	601610270463001	ADVAIR DISKUS 250/50	181.13	17874.38
601610270463	601610270463002	ADVAIR DISKUS 250/50	181.13	17874.38
601610270463	601610270463003	ADVAIR DISKUS 250/50	181.13	17874.38
601610270463	601610270463004	ADVAIR DISKUS 250/50	181.13	17874.38
601610270463	601610270463005	ADVAIR DISKUS 250/50	181.13	17874.38
601610270898	601610270898001	PROAIR HFA	34.13	17874.38
601610270898	601610270898002	PROAIR HFA	34.13	17874.38
601610270898	601610270898003	PROAIR HFA	34.13	17874.38
601610270918	601610270918001	ADVAIR DISKUS 250/50	181.13	17874.38
601610270918	601610270918002	ADVAIR DISKUS 250/50	181.13	17874.38
601720130851	601720130851001	FLOVENT DISKUS	83.75	13085.00
601720130882	601720130882001	SEREVENT DISKUS	130.04	13085.00
601720131296	601720131296001	SEREVENT DISKUS	127.11	13085.00
601720131296	601720131296002	SEREVENT DISKUS	127.11	13085.00
601720131309	601720131309001	FLOVENT DISKUS	83.75	13085.00
601720131309	601720131309002	FLOVENT DISKUS	83.75	13085.00
601880440155	601880440155001	ALBUTEROL	23.13	11208.77
601880440179	601880440179001	AEROCHAMBER	52.59	11208.77
601880440186	601880440186001	AEROCHAMBER	52.59	11208.77
601880500118	601880500118001	ALBUTEROL	11.87	11956.55
602040160385	602040160385001	ADVAIR DISKUS 250/50	175.90	4369.50
602040160385	602040160385002	ADVAIR DISKUS 250/50	175.90	4369.50
602040160385	602040160385003	ADVAIR DISKUS 250/50	175.90	4369.50
602320110351	602320110351001	SINGULAIR (UNIT OF USE)	91.77	2450.49
602320110440	602320110440001	SINGULAIR (UNIT OF USE)	97.13	2450.49
602320110440	602320110440002	SINGULAIR (UNIT OF USE)	97.13	2450.49
602320110440	602320110440003	SINGULAIR (UNIT OF USE)	97.13	2450.49
602320110440	602320110440004	SINGULAIR (UNIT OF USE)	97.13	2450.49
602320110440	602320110440005	SINGULAIR (UNIT OF USE)	97.13	2450.49
602320110464	602320110464001	ALBUTEROL	13.70	2450.49
602320110508	602320110508001	SINGULAIR (UNIT OF USE)	97.13	2450.49
602320110508	602320110508002	SINGULAIR (UNIT OF USE)	97.13	2450.49
602320110508	602320110508003	SINGULAIR (UNIT OF USE)	97.13	2450.49
602320110508	602320110508004	SINGULAIR (UNIT OF USE)	97.13	2450.49
602320110508	602320110508005	SINGULAIR (UNIT OF USE)	97.13	2450.49
602630240221	602630240221001	SODIUM CHLORIDE	8.64	9104.25
602630240221	602630240221002	SODIUM CHLORIDE	8.64	9104.25
602630240252	602630240252001	SODIUM CHLORIDE	8.64	9104.25
602630240252	602630240252002	SODIUM CHLORIDE	8.64	9104.25
602630240252	602630240252003	SODIUM CHLORIDE	8.64	9104.25
602630240252	602630240252004	SODIUM CHLORIDE	8.64	9104.25
602630240252	602630240252005	SODIUM CHLORIDE	8.64	9104.25
602630240252	602630240252006	SODIUM CHLORIDE	8.64	9104.25
602630240269	602630240269001	ALBUTEROL	16.28	9104.25
602800191310	602800191310001	ALBUTEROL SULFATE (PF)	41.20	2005.96
602800191365	602800191365001	FLOVENT DISKUS	83.75	2005.96
602800191865	602800191865001	FLOVENT DISKUS	83.75	2005.96
602800191865	602800191865002	FLOVENT DISKUS	83.75	2005.96
602800191865	602800191865003	FLOVENT DISKUS	83.75	2005.96
602800191865	602800191865004	FLOVENT DISKUS	83.75	2005.96
602800191865	602800191865005	FLOVENT DISKUS	83.75	2005.96
602800191865	602800191865006	FLOVENT DISKUS	83.75	2005.96
602800260420	602800260420001	XOPENEX HFA	50.58	2974.09
602800260437	602800260437001	ATROVENT HFA	79.85	2974.09
602800260526	602800260526001	FLOVENT HFA	111.53	2974.09
602800260526	602800260526002	FLOVENT HFA	111.53	2974.09
602800260526	602800260526003	FLOVENT HFA	111.53	2974.09
602800260526	602800260526004	FLOVENT HFA	111.53	2974.09
602800260564	602800260564001	SINGULAIR	101.31	2974.09
602800260564	602800260564002	SINGULAIR	101.31	2974.09
602800260704	602800260704001	MUCINEX	28.73	2974.09
602800260704	602800260704002	MUCINEX	28.73	2974.09
602800260711	602800260711001	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260711	602800260711002	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260711	602800260711003	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260711	602800260711004	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260711	602800260711005	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260711	602800260711006	XOPENEX HFA (200 ACTUATIONS)	46.50	2974.09
602800260728	602800260728001	ATROVENT HFA	79.85	2974.09
602800260728	602800260728002	ATROVENT HFA	79.85	2974.09
602800260728	602800260728003	ATROVENT HFA	79.85	2974.09
602800260728	602800260728004	ATROVENT HFA	79.85	2974.09
602800260728	602800260728005	ATROVENT HFA	79.85	2974.09
602800260728	602800260728006	ATROVENT HFA	79.85	2974.09
602800260735	602800260735001	FLOVENT HFA	111.53	2974.09
602800260735	602800260735002	FLOVENT HFA	111.53	2974.09
602800260735	602800260735003	FLOVENT HFA	111.53	2974.09
602800260735	602800260735004	FLOVENT HFA	111.53	2974.09
602800260735	602800260735005	FLOVENT HFA	111.53	2974.09
602800260735	602800260735006	FLOVENT HFA	111.53	2974.09
602800260759	602800260759001	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260759	602800260759002	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260759	602800260759003	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260759	602800260759004	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260759	602800260759005	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260759	602800260759006	SINGULAIR (UNIT OF USE)	98.28	2974.09
602800260848	602800260848001	XOPENEX HFA (200 ACTUATIONS)	43.54	2974.09
602800260848	602800260848002	XOPENEX HFA (200 ACTUATIONS)	43.54	2974.09
602800260855	602800260855001	FLOVENT HFA	111.53	2974.09
602800260855	602800260855002	FLOVENT HFA	111.53	2974.09
602800260913	602800260913001	SINGULAIR	102.71	2974.09
602800260913	602800260913002	SINGULAIR	102.71	2974.09
602800260937	602800260937001	MUCINEX	28.73	2974.09
602800260937	602800260937002	MUCINEX	28.73	2974.09
602810160458	602810160458001	FLOVENT DISKUS	79.95	19496.91
603020221417	603020221417001	SINGULAIR (UNIT OF USE)	98.28	11266.94
603020221417	603020221417002	SINGULAIR (UNIT OF USE)	98.28	11266.94
603080180459	603080180459001	SPIRIVA (W/HANDIHALER)	125.76	11687.12
603080180459	603080180459002	SPIRIVA (W/HANDIHALER)	125.76	11687.12
603080180459	603080180459003	SPIRIVA (W/HANDIHALER)	125.76	11687.12
603080180466	603080180466001	ADVAIR DISKUS 250/50	183.68	11687.12
603080180466	603080180466002	ADVAIR DISKUS 250/50	183.68	11687.12
603080180466	603080180466003	ADVAIR DISKUS 250/50	183.68	11687.12
603080180473	603080180473001	ALBUTEROL	8.00	11687.12
603080180473	603080180473002	ALBUTEROL	8.00	11687.12
603080180473	603080180473003	ALBUTEROL	8.00	11687.12
603080180579	603080180579001	SPIRIVA (W/ HANDIHALER)	398.24	11687.12
603080180579	603080180579002	SPIRIVA (W/ HANDIHALER)	398.24	11687.12
603080180606	603080180606001	ADVAIR DISKUS 250/50	543.40	11687.12
603080180606	603080180606002	ADVAIR DISKUS 250/50	543.40	11687.12
603140370171	603140370171001	ALLEGRA	40.25	30689.19
603140370171	603140370171002	ALLEGRA	40.25	30689.19
603330280289	603330280289001	ALBUTEROL	20.00	4239.71
603330280289	603330280289002	ALBUTEROL	20.00	4239.71
603330280467	603330280467001	PROVENTIL HFA (M.D.I.)	36.51	4239.71
603330280467	603330280467002	PROVENTIL HFA (M.D.I.)	38.14	4239.71
603330280467	603330280467003	PROVENTIL HFA (M.D.I.)	36.51	4239.71
603330580502	603330580502001	ALBUTEROL HFA	64.15	5095.79
603330580519	603330580519001	ALBUTEROL SULFATE (PF)	13.55	5095.79
603330580831	603330580831001	SINGULAIR (UNIT OF USE)	100.99	5095.79
603330580831	603330580831002	SINGULAIR (UNIT OF USE)	100.99	5095.79
603330580831	603330580831003	SINGULAIR (UNIT OF USE)	100.99	5095.79
603460450237	603460450237001	ALBUTEROL	25.01	10283.95
603460450299	603460450299001	AMPHETAMINE SALT COMBO	35.17	10283.95
603460450299	603460450299002	AMPHETAMINE SALT COMBO	35.17	10283.95
603460450299	603460450299003	AMPHETAMINE SALT COMBO	35.17	10283.95
603460450299	603460450299004	AMPHETAMINE SALT COMBO	35.17	10283.95
603460450299	603460450299005	AMPHETAMINE SALT COMBO	35.17	10283.95
603460510132	603460510132001	ALBUTEROL	16.99	7717.80
603460510149	603460510149001	ALBUTEROL	5.50	7717.80
603460510156	603460510156001	PHARMAFLUR	5.10	7717.80
603460510163	603460510163001	NASACORT AQ	83.64	7717.80
603460510194	603460510194001	SINGULAIR	103.33	7717.80
603460510214	603460510214001	SINGULAIR	103.33	7717.80
603460510214	603460510214002	SINGULAIR	103.33	7717.80
603460510214	603460510214003	SINGULAIR	103.33	7717.80
603460510214	603460510214004	SINGULAIR	103.33	7717.80
603460510214	603460510214005	SINGULAIR	103.33	7717.80
603460510221	603460510221001	PULMICORT TURBUHALER	154.55	7717.80
603460510221	603460510221002	PULMICORT TURBUHALER	154.55	7717.80
603460510238	603460510238001	NASACORT AQ	83.64	7717.80
603460510245	603460510245001	ALBUTEROL	5.27	7717.80
603460510252	603460510252001	ALBUTEROL	26.25	7717.80
603460510252	603460510252002	ALBUTEROL	26.25	7717.80
603460510252	603460510252003	ALBUTEROL	26.25	7717.80
603460510252	603460510252004	ALBUTEROL	26.25	7717.80
603460510252	603460510252005	ALBUTEROL	26.25	7717.80
603830390137	603830390137001	ALBUTEROL	12.89	6243.18
603830390137	603830390137002	ALBUTEROL	12.89	6243.18
603830390137	603830390137003	ALBUTEROL	20.54	6243.18
603830390144	603830390144001	SINGULAIR	103.33	6243.18
604160650104	604160650104001	ZYRTEC	66.17	16140.79
604160650111	604160650111001	FLOVENT HFA	176.40	16140.79
604160650128	604160650128001	SINGULAIR	100.76	16140.79
604240510470	604240510470001	SINGULAIR (UNIT OF USE)	99.81	11477.95
604240510470	604240510470002	SINGULAIR (UNIT OF USE)	99.81	11477.95
604240510470	604240510470003	SINGULAIR (UNIT OF USE)	99.81	11477.95
604240510494	604240510494001	PULMICORT TURBUHALER	158.99	11477.95
604240510494	604240510494002	PULMICORT TURBUHALER	158.99	11477.95
604240510538	604240510538001	PREDNISONE	4.83	11477.95
604240510545	604240510545001	SINGULAIR (UNIT OF USE)	99.81	11477.95
604240510545	604240510545002	SINGULAIR (UNIT OF USE)	99.81	11477.95
604240510545	604240510545003	SINGULAIR (UNIT OF USE)	99.81	11477.95
604240510545	604240510545004	SINGULAIR (UNIT OF USE)	99.81	11477.95
604240510545	604240510545005	SINGULAIR (UNIT OF USE)	99.81	11477.95
604240510569	604240510569001	ALBUTEROL SULFATE (PF)	16.65	11477.95
604240510576	604240510576001	PULMICORT FLEXHALER	112.78	11477.95
604240510576	604240510576002	PULMICORT FLEXHALER	112.78	11477.95
604390530171	604390530171001	PULMICORT RESPULES (5X6)	140.70	6212.66
604390530277	604390530277001	ALBUTEROL	19.79	6212.66
604390530277	604390530277002	ALBUTEROL	19.79	6212.66
604390530284	604390530284001	FLOVENT HFA	77.20	6212.66
604440230291	604440230291001	ALBUTEROL HFA	19.80	8879.27
604440230291	604440230291002	ALBUTEROL HFA	19.80	8879.27
604590140524	604590140524001	ALBUTEROL	29.56	5007.82
604590140682	604590140682001	PROVENTIL HFA (M.D.I.)	36.51	5007.82
604590140682	604590140682002	PROVENTIL HFA (M.D.I.)	36.51	5007.82
604640300808	604640300808001	SINGULAIR (UNIT OF USE)	99.02	26532.10
604640301003	604640301003001	PROAIR HFA	92.08	26532.10
604640301027	604640301027001	SINGULAIR	99.06	26532.10
604640301027	604640301027002	SINGULAIR	99.06	26532.10
604640301027	604640301027003	SINGULAIR	99.06	26532.10
604640301027	604640301027004	SINGULAIR	99.06	26532.10
604640301027	604640301027005	SINGULAIR	99.06	26532.10
604640301027	604640301027006	SINGULAIR	99.06	26532.10
604640301027	604640301027007	SINGULAIR	99.06	26532.10
604640301027	604640301027008	SINGULAIR	99.06	26532.10
604710170325	604710170325001	QVAR	85.52	8294.27
604710170349	604710170349001	ALBUTEROL	12.20	8294.27
604720210414	604720210414001	ALBUTEROL	10.00	17999.36
605040240621	605040240621001	ALBUTEROL	19.79	14084.94
605040240621	605040240621002	ALBUTEROL	19.79	14084.94
605040240621	605040240621003	ALBUTEROL	19.79	14084.94
605040240621	605040240621004	ALBUTEROL	19.79	14084.94
605040240621	605040240621005	ALBUTEROL	19.79	14084.94
605040240645	605040240645001	SPIRIVA (W/ HANDIHALER)	134.81	14084.94
605040240645	605040240645002	SPIRIVA (W/ HANDIHALER)	134.81	14084.94
605040240645	605040240645003	SPIRIVA (W/ HANDIHALER)	134.81	14084.94
605040240645	605040240645004	SPIRIVA (W/ HANDIHALER)	134.81	14084.94
605040240645	605040240645005	SPIRIVA (W/ HANDIHALER)	134.81	14084.94
605060440040	605060440040001	ALBUTEROL	16.28	7415.09
605060440088	605060440088001	ALBUTEROL	18.44	7415.09
605060440095	605060440095001	ZYRTEC	66.42	7415.09
605060440122	605060440122001	ALBUTEROL	55.45	7415.09
605110140301	605110140301001	ALBUTEROL	16.28	19335.13
605300180501	605300180501001	ALBUTEROL	37.20	12382.50
605510380239	605510380239001	ASMANEX TWISTHALER (60-INHALATION)	96.06	10301.48
605510380246	605510380246001	PROAIR HFA	92.08	10301.48
605510380253	605510380253001	PREDNISONE	2.80	10301.48
605510380284	605510380284001	ADVAIR DISKUS 100/50	150.23	10301.48
605510380291	605510380291001	PREDNISONE	3.04	10301.48

Return to Top

HC-110I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Analysis Variable : RXXP07X SUM OF PAYMENTS RXSF07X-RXOU07X(IMPUTED)

N	Sum
9334	894282.90

Return to Top

HC-110I. Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
Analysis Variable : RXXP07X SUM OF PAYMENTS RXSF07X-RXOU07X(IMPUTED)

N	Sum
9334	8968375727

Return to Top

NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to WESTAT INC, Site 0009005004.
NOTE: This session is executing on the XP_PRO platform.

NOTE: SAS 9.1.3 Service Pack 4

NOTE: SAS initialization used:
real time 1.76 seconds
cpu time 0.21 seconds

NOTE: AUTOEXEC processing beginning; file is C:\Program Files\SAS\SAS 9.1\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-110I";
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.06 seconds
cpu time 0.00 seconds

26
27 *-----------------------------------------------------------------------------------
28 * Get conditions records coded as asthma.
29 *-----------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H112 (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 (H112) 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.21 seconds
cpu time 0.00 seconds

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

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

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

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

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

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

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

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

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.H110G (KEEP=EVNTIDX PERWT07F SEETLKPV OBXP07X);
85 IF PERWT07F > 0 & SEETLKPV NE 2;
86 RUN;

NOTE: There were 136673 observations read from the data set IN.H110G.
NOTE: The data set WORK.MVIS has 132197 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.07 seconds

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

NOTE: There were 132197 observations read from the data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 132197 observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.17 seconds
cpu time 0.06 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 6597 observations read from the data set WORK.ASCLNKS.
NOTE: There were 132197 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 2045 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 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-110G) events";
104 run;

105
106 PROC MEANS DATA=ASMVIS N SUM;
107 VAR OBXP07X;
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 2045 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.10 seconds
cpu time 0.03 seconds

110
111 PROC MEANS DATA=ASMVIS N SUM;
112 VAR OBXP07X;
113 WEIGHT PERWT07F;
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 2045 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.04 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 5.75 seconds
cpu time 0.98 seconds

Return to Top

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

Obs	CONDIDX	CCCODEX
1	600140260030	128
2	600250160011	128
3	600420150021	128
4	600730160010	128
5	601190220021	128
6	601200400010	128
7	601280520010	128
8	601320190057	128
9	601470310042	128
10	601510250029	128
11	601540680041	128
12	601590210031	128
13	601610270070	128
14	601720130135	128
15	601880440011	128
16	601880500011	128
17	602040160074	128
18	602090280120	128
19	602320110025	128
20	602410530021	128
21	602540340014	128
22	602630240034	128
23	602800190113	128
24	602800260037	128
25	602810160112	128
26	602850570028	128
27	602850640027	128
28	603020220037	128
29	603080180025	128
30	603140370012	128
31	603330280077	128
32	603330580019	128
33	603460450066	128
34	603460510022	128
35	603830390020	128
36	604010140032	128
37	604160650018	128
38	604240510022	128
39	604390530030	128
40	604440230087	128
41	604540290026	128
42	604570180068	128
43	604590140042	128
44	604640160020	128
45	604640300034	128
46	604710170023	128
47	604720210032	128
48	604770480018	128
49	604970100037	128
50	605040240062	128

Return to Top

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

CONDIDX	EVNTIDX	EVENTYPE
600420150021	600420150514	8 PMED
600730160010	600730160136	8 PMED
600730160010	600730160143	8 PMED
601200400010	601200400090	8 PMED
601200400010	601200400110	8 PMED
601280520010	601280520094	8 PMED
601320190057	601320190287	8 PMED
601320190057	601320190314	1 MVIS
601320190057	601320190321	1 MVIS
601320190057	601320190338	1 MVIS
601320190057	601320190403	8 PMED
601320190057	601320190458	8 PMED
601320190057	601320190465	8 PMED
601320190057	601320190472	8 PMED
601320190057	601320190496	1 MVIS
601320190057	601320190509	1 MVIS
601320190057	601320190516	1 MVIS
601320190057	601320190523	1 MVIS
601320190057	601320190530	1 MVIS
601320190057	601320190561	8 PMED
601320190057	601320190578	8 PMED
601470310042	601470310240	8 PMED
601470310042	601470310264	8 PMED
601470310042	601470310315	8 PMED
601470310042	601470310339	8 PMED
601510250029	601510250145	8 PMED
601510250029	601510250152	8 PMED
601510250029	601510250169	8 PMED
601510250029	601510250176	1 MVIS
601510250029	601510250183	8 PMED
601510250029	601510250190	8 PMED
601510250029	601510250203	8 PMED
601590210031	601590210047	8 PMED
601610270070	601610270456	8 PMED
601610270070	601610270463	8 PMED
601610270070	601610270723	1 MVIS
601610270070	601610270730	1 MVIS
601610270070	601610270747	1 MVIS
601610270070	601610270754	1 MVIS
601610270070	601610270898	8 PMED
601610270070	601610270918	8 PMED
601720130135	601720130851	8 PMED
601720130135	601720130882	8 PMED
601720130135	601720131296	8 PMED
601720130135	601720131309	8 PMED
601880440011	601880440100	1 MVIS
601880440011	601880440117	1 MVIS
601880440011	601880440124	1 MVIS
601880440011	601880440155	8 PMED
601880440011	601880440179	8 PMED
601880440011	601880440186	8 PMED
601880500011	601880500118	8 PMED
602040160074	602040160385	8 PMED
602090280120	602090280620	1 MVIS
602090280120	602090280637	1 MVIS
602090280120	602090280644	1 MVIS
602090280120	602090280651	1 MVIS
602320110025	602320110293	1 MVIS
602320110025	602320110351	8 PMED
602320110025	602320110440	8 PMED
602320110025	602320110464	8 PMED
602320110025	602320110508	8 PMED
602630240034	602630240221	8 PMED
602630240034	602630240252	8 PMED
602630240034	602630240269	8 PMED
602800190113	602800191214	3 EROM
602800190113	602800191310	8 PMED
602800190113	602800191365	8 PMED
602800190113	602800191478	1 MVIS
602800190113	602800191485	1 MVIS
602800190113	602800191865	8 PMED
602800260037	602800260362	1 MVIS
602800260037	602800260379	1 MVIS
602800260037	602800260386	3 EROM
602800260037	602800260393	4 STAZ

Return to Top

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

Obs	CONDIDX	EVNTIDX	EVENTYPE
1	600420150021	600420150514	8 PMED
2	600730160010	600730160136	8 PMED
3	600730160010	600730160143	8 PMED
4	601200400010	601200400090	8 PMED
5	601200400010	601200400110	8 PMED
6	601280520010	601280520094	8 PMED
7	601320190057	601320190287	8 PMED
8	601320190057	601320190314	1 MVIS
9	601320190057	601320190321	1 MVIS
10	601320190057	601320190338	1 MVIS
11	601320190057	601320190403	8 PMED
12	601320190057	601320190458	8 PMED
13	601320190057	601320190465	8 PMED
14	601320190057	601320190472	8 PMED
15	601320190057	601320190496	1 MVIS
16	601320190057	601320190509	1 MVIS
17	601320190057	601320190516	1 MVIS
18	601320190057	601320190523	1 MVIS
19	601320190057	601320190530	1 MVIS
20	601320190057	601320190561	8 PMED
21	601320190057	601320190578	8 PMED
22	601470310042	601470310240	8 PMED
23	601470310042	601470310264	8 PMED
24	601470310042	601470310315	8 PMED
25	601470310042	601470310339	8 PMED
26	601510250029	601510250145	8 PMED
27	601510250029	601510250152	8 PMED
28	601510250029	601510250169	8 PMED
29	601510250029	601510250176	1 MVIS
30	601510250029	601510250183	8 PMED
31	601510250029	601510250190	8 PMED
32	601510250029	601510250203	8 PMED
33	601590210031	601590210047	8 PMED
34	601610270070	601610270456	8 PMED
35	601610270070	601610270463	8 PMED
36	601610270070	601610270723	1 MVIS
37	601610270070	601610270730	1 MVIS
38	601610270070	601610270747	1 MVIS
39	601610270070	601610270754	1 MVIS
40	601610270070	601610270898	8 PMED
41	601610270070	601610270918	8 PMED
42	601720130135	601720130851	8 PMED
43	601720130135	601720130882	8 PMED
44	601720130135	601720131296	8 PMED
45	601720130135	601720131309	8 PMED
46	601880440011	601880440100	1 MVIS
47	601880440011	601880440117	1 MVIS
48	601880440011	601880440124	1 MVIS
49	601880440011	601880440155	8 PMED
50	601880440011	601880440179	8 PMED

Return to Top

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

Obs	EVNTIDX	EVENTYPE
1	600420150514	8 PMED
2	600730160136	8 PMED
3	600730160143	8 PMED
4	601200400090	8 PMED
5	601200400110	8 PMED
6	601280520094	8 PMED
7	601320190287	8 PMED
8	601320190314	1 MVIS
9	601320190321	1 MVIS
10	601320190338	1 MVIS
11	601320190403	8 PMED
12	601320190458	8 PMED
13	601320190465	8 PMED
14	601320190472	8 PMED
15	601320190496	1 MVIS
16	601320190509	1 MVIS
17	601320190516	1 MVIS
18	601320190523	1 MVIS
19	601320190530	1 MVIS
20	601320190561	8 PMED
21	601320190578	8 PMED
22	601470310240	8 PMED
23	601470310264	8 PMED
24	601470310315	8 PMED
25	601470310339	8 PMED
26	601510250145	8 PMED
27	601510250152	8 PMED
28	601510250169	8 PMED
29	601510250176	1 MVIS
30	601510250183	8 PMED
31	601510250190	8 PMED
32	601510250203	8 PMED
33	601590210047	8 PMED
34	601610270456	8 PMED
35	601610270463	8 PMED
36	601610270723	1 MVIS
37	601610270730	1 MVIS
38	601610270747	1 MVIS
39	601610270754	1 MVIS
40	601610270898	8 PMED
41	601610270918	8 PMED
42	601720130851	8 PMED
43	601720130882	8 PMED
44	601720131296	8 PMED
45	601720131309	8 PMED
46	601880440100	1 MVIS
47	601880440117	1 MVIS
48	601880440124	1 MVIS
49	601880440155	8 PMED
50	601880440179	8 PMED

Return to Top

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

Obs	EVNTIDX	EVENTYPE	SEETLKPV	OBXP07X	PERWT07F
1	601320190314	1 MVIS	1	39.80	4671.36
2	601320190321	1 MVIS	1	94.34	4671.36
3	601320190338	1 MVIS	1	26.27	4671.36
4	601320190496	1 MVIS	1	56.03	4671.36
5	601320190509	1 MVIS	1	56.03	4671.36
6	601320190516	1 MVIS	1	56.03	4671.36
7	601320190523	1 MVIS	1	95.34	4671.36
8	601320190530	1 MVIS	1	130.20	4671.36
9	601510250176	1 MVIS	1	56.56	8732.59
10	601610270723	1 MVIS	1	99.22	17874.38
11	601610270730	1 MVIS	1	62.50	17874.38
12	601610270747	1 MVIS	1	39.64	17874.38
13	601610270754	1 MVIS	1	58.44	17874.38
14	601880440100	1 MVIS	1	97.21	11208.77
15	601880440117	1 MVIS	1	158.81	11208.77
16	601880440124	1 MVIS	1	173.20	11208.77
17	602090280620	1 MVIS	1	55.51	14021.69
18	602090280637	1 MVIS	1	84.27	14021.69
19	602090280644	1 MVIS	1	55.51	14021.69
20	602090280651	1 MVIS	1	502.87	14021.69
21	602320110293	1 MVIS	1	56.03	2450.49
22	602800191478	1 MVIS	1	99.69	2005.96
23	602800191485	1 MVIS	1	65.19	2005.96
24	602800260362	1 MVIS	1	376.13	2974.09
25	602800260379	1 MVIS	1	99.76	2974.09
26	602800260622	1 MVIS	1	93.48	2974.09
27	602800260646	1 MVIS	1	99.76	2974.09
28	602800260660	1 MVIS	1	146.03	2974.09
29	602800260800	1 MVIS	1	81.34	2974.09
30	603020221359	1 MVIS	1	12.36	11266.94
31	603020221366	1 MVIS	1	40.35	11266.94
32	603080180428	1 MVIS	1	49.89	11687.12
33	603460510187	1 MVIS	1	126.62	7717.80
34	603830390106	1 MVIS	1	29.00	6243.18
35	603830390113	1 MVIS	1	23.58	6243.18
36	603830390120	1 MVIS	1	23.58	6243.18
37	604160650084	1 MVIS	1	15.00	16140.79
38	604160650091	1 MVIS	1	351.74	16140.79
39	604160650135	1 MVIS	1	1387.44	16140.79
40	604240510507	1 MVIS	1	470.92	11477.95
41	604240510514	1 MVIS	1	117.56	11477.95
42	604390530215	1 MVIS	1	25.83	6212.66
43	604390530222	1 MVIS	1	4.94	6212.66
44	604390530239	1 MVIS	1	0.00	6212.66
45	604390530246	1 MVIS	1	4.94	6212.66
46	604720210356	1 MVIS	1	86.35	17999.36
47	604720210483	1 MVIS	1	25.00	17999.36
48	605040240532	1 MVIS	1	205.00	14084.94
49	605040240549	1 MVIS	1	157.00	14084.94
50	605300180443	1 MVIS	1	302.00	12382.50

Return to Top

HC-110I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Analysis Variable : OBXP07X SUM OF OBSF07X - OBOT07X (IMPUTED)

N	Sum
2045	219906.41

Return to Top

HC-110I. Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
Analysis Variable : OBXP07X SUM OF OBSF07X - OBOT07X (IMPUTED)

N	Sum
2045	2065958051

Return to Top