Font Size:

MEPS HC-144I: Attachment 2

Sample SAS Jobs for Linking Example

The SAS System

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

NOTE: SAS initialization used:
real time 2.05 seconds
cpu time 0.21 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-144I";
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.01 seconds
cpu time 0.01 seconds

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

NOTE: There were 108619 observations read from the data set IN.H146.
NOTE: The data set WORK.ASCONDS has 2327 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 3.30 seconds
cpu time 0.03 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 2327 observations read from the data set WORK.ASCONDS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCONDS has 2327 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

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

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

NOTE: There were 306663 observations read from the data set IN.H144IF1.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.CLNK has 306663 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 3.18 seconds
cpu time 0.40 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 306663 observations read from the data set WORK.CLNK.
NOTE: There were 2327 observations read from the data set WORK.ASCONDS.
NOTE: The data set WORK.ASCLNKS has 7004 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.09 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.04 seconds
cpu time 0.01 seconds

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

NOTE: There were 7004 observations read from the data set WORK.ASCLNKS.
NOTE: SAS sort was used.
NOTE: The data set WORK.ASCLNKS has 7004 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 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.00 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 7004 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASCLNKS has 6998 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.01 seconds
cpu time 0.01 seconds

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

NOTE: There were 134311 observations read from the data set IN.H144G.
NOTE: The data set WORK.MVIS has 130464 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 11.20 seconds
cpu time 0.18 seconds

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

NOTE: There were 130464 observations read from the data set WORK.MVIS.
NOTE: SAS threaded sort was used.
NOTE: The data set WORK.MVIS has 130464 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.07 seconds
cpu time 0.12 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 6998 observations read from the data set WORK.ASCLNKS.
NOTE: There were 130464 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1858 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 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-144G) 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.01 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.H144IF2 OUT=RXLK; BY EVNTIDX; RUN;

NOTE: There were 56713 observations read from the data set IN.H144IF2.
NOTE: SAS sort was used.
NOTE: The data set WORK.RXLK has 56713 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.64 seconds
cpu time 0.07 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-144IF2)";
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.03 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 56713 observations read from the data set WORK.RXLK.
NOTE: There were 1858 observations read from the data set WORK.ASMVIS.
NOTE: The data set WORK.PMEDIDS has 1996 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.00 seconds
cpu time 0.00 seconds

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

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

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

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

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

NOTE: There were 1996 observations read from the data set WORK.PMEDIDS.
NOTE: The data set WORK.PMEDIDS has 1910 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.00 seconds
cpu time 0.00 seconds

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

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

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

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

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

174
175 PROC MEANS DATA=MVPMEDS N SUM;
176 VAR RXXP11X;
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 5023 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.04 seconds

179
180 PROC MEANS DATA=MVPMEDS N SUM;
181 VAR RXXP11X;
182 WEIGHT PERWT11F;
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 5023 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.01 seconds

186
187 ods rtf close;
188

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

Return to Top

HC-144I. Sample SAS Job for Example A - sample print of work.asconds, sorted by condidx COND (H146) records where cccodex=128
Obs	CONDIDX	CCCODEX
1	100121010051	128
2	100171010021	128
3	100431010021	128
4	100431030011	128
5	100431040011	128
6	100441010031	128
7	100531020041	128
8	100531040011	128
9	100671010071	128
10	100671020041	128
11	100861020041	128
12	101171050011	128
13	101231030011	128
14	101311020041	128
15	101371010051	128
16	101671020011	128
17	101831050011	128
18	101841020091	128
19	101841030031	128
20	101841030061	128
21	101981020061	128
22	101981030051	128
23	101981040031	128
24	101981050011	128
25	102061010011	128
26	102061040011	128
27	102291020011	128
28	102331020021	128
29	102361030011	128
30	102361040011	128
31	102421010041	128
32	102442010032	128
33	102451010021	128
34	102451030011	128
35	102531020011	128
36	102781020031	128
37	102891010051	128
38	102891020021	128
39	102991050011	128
40	102991060011	128
41	103031010041	128
42	103051020011	128
43	103101010031	128
44	103151020011	128
45	103371010011	128
46	103581010041	128
47	103611020011	128
48	103691010021	128
49	103701010091	128
50	103851040011	128

Return to Top

HC-144I. Sample SAS Job for Example A - sample print of work.asclnks, sorted by condidx events linked to asthma condition records
CONDIDX	EVNTIDX	EVENTYPE
100121010051	100121010111	8 PMED
100121010051	100121010151	8 PMED
100121010051	100121010201	8 PMED
100121010051	100121010231	8 PMED
100171010021	100171010231	8 PMED
100171010021	100171010271	8 PMED
100431010021	100431010201	8 PMED
100431010021	100431010271	8 PMED
100431030011	100431030281	8 PMED
100431030011	100431030311	2 OPAT
100431030011	100431030321	1 MVIS
100431030011	100431030331	8 PMED
100431030011	100431030351	8 PMED
100431040011	100431040231	8 PMED
100431040011	100431040321	8 PMED
100431040011	100431040341	1 MVIS
100431040011	100431040361	2 OPAT
100431040011	100431040371	8 PMED
100441010031	100441010181	8 PMED
100441010031	100441010191	8 PMED
100441010031	100441010201	8 PMED
100441010031	100441010211	1 MVIS
100531020041	100531020361	8 PMED
100531020041	100531020511	8 PMED
100531020041	100531020521	8 PMED
100531020041	100531020531	8 PMED
100531040011	100531040021	8 PMED
100531040011	100531040031	1 MVIS
100531040011	100531040051	8 PMED
100531040011	100531040091	8 PMED
100671010071	100671010511	8 PMED
100671010071	100671010521	8 PMED
100671010071	100671010531	8 PMED
100671010071	100671010681	8 PMED
100671010071	100671010701	2 OPAT
100671010071	100671010811	8 PMED
100671010071	100671010821	8 PMED
100671010071	100671010831	8 PMED
100671020041	100671020291	1 MVIS
100671020041	100671020301	1 MVIS
100671020041	100671020311	1 MVIS
100671020041	100671020371	8 PMED
100671020041	100671020401	8 PMED
100671020041	100671020411	8 PMED
100671020041	100671020601	8 PMED
100671020041	100671020611	8 PMED
100861020041	100861020131	1 MVIS
100861020041	100861020141	8 PMED
100861020041	100861020151	8 PMED
100861020041	100861020181	8 PMED
100861020041	100861020221	1 MVIS
100861020041	100861020241	8 PMED
100861020041	100861020291	8 PMED
100861020041	100861020371	1 MVIS
100861020041	100861020391	8 PMED
100861020041	100861020411	8 PMED
100861020041	100861020451	8 PMED
100861020041	100861020461	8 PMED
100861020041	100861020511	1 MVIS
100861020041	100861020521	1 MVIS
101231030011	101231030121	8 PMED
101371010051	101371010481	8 PMED
101671020011	101671020201	1 MVIS
101671020011	101671020211	8 PMED
101831050011	101831050031	8 PMED
101841020091	101841020381	8 PMED
101841020091	101841020411	2 OPAT
101841020091	101841020421	2 OPAT
101841020091	101841020521	8 PMED
101841020091	101841020551	8 PMED
101841020091	101841020691	8 PMED
101841020091	101841020721	8 PMED
101841020091	101841020731	8 PMED
101841020091	101841020761	8 PMED
101841020091	101841020791	2 OPAT

Return to Top

HC-144I. Sample SAS Job for Example A - sample print of work.asclnks, sorted by evntidx
Obs	CONDIDX	EVNTIDX	EVENTYPE
1	100121010051	100121010111	8 PMED
2	100121010051	100121010151	8 PMED
3	100121010051	100121010201	8 PMED
4	100121010051	100121010231	8 PMED
5	100171010021	100171010231	8 PMED
6	100171010021	100171010271	8 PMED
7	100431010021	100431010201	8 PMED
8	100431010021	100431010271	8 PMED
9	100431030011	100431030281	8 PMED
10	100431030011	100431030311	2 OPAT
11	100431030011	100431030321	1 MVIS
12	100431030011	100431030331	8 PMED
13	100431030011	100431030351	8 PMED
14	100431040011	100431040231	8 PMED
15	100431040011	100431040321	8 PMED
16	100431040011	100431040341	1 MVIS
17	100431040011	100431040361	2 OPAT
18	100431040011	100431040371	8 PMED
19	100441010031	100441010181	8 PMED
20	100441010031	100441010191	8 PMED
21	100441010031	100441010201	8 PMED
22	100441010031	100441010211	1 MVIS
23	100531020041	100531020361	8 PMED
24	100531020041	100531020511	8 PMED
25	100531020041	100531020521	8 PMED
26	100531020041	100531020531	8 PMED
27	100531040011	100531040021	8 PMED
28	100531040011	100531040031	1 MVIS
29	100531040011	100531040051	8 PMED
30	100531040011	100531040091	8 PMED
31	100671010071	100671010511	8 PMED
32	100671010071	100671010521	8 PMED
33	100671010071	100671010531	8 PMED
34	100671010071	100671010681	8 PMED
35	100671010071	100671010701	2 OPAT
36	100671010071	100671010811	8 PMED
37	100671010071	100671010821	8 PMED
38	100671010071	100671010831	8 PMED
39	100671020041	100671020291	1 MVIS
40	100671020041	100671020301	1 MVIS
41	100671020041	100671020311	1 MVIS
42	100671020041	100671020371	8 PMED
43	100671020041	100671020401	8 PMED
44	100671020041	100671020411	8 PMED
45	100671020041	100671020601	8 PMED
46	100671020041	100671020611	8 PMED
47	100861020041	100861020131	1 MVIS
48	100861020041	100861020141	8 PMED
49	100861020041	100861020151	8 PMED
50	100861020041	100861020181	8 PMED

Return to Top

HC-144I. Sample SAS Job for Example A - sample print of unique evntidxs from work.asclnks
Obs	EVNTIDX	EVENTYPE
1	100121010111	8 PMED
2	100121010151	8 PMED
3	100121010201	8 PMED
4	100121010231	8 PMED
5	100171010231	8 PMED
6	100171010271	8 PMED
7	100431010201	8 PMED
8	100431010271	8 PMED
9	100431030281	8 PMED
10	100431030311	2 OPAT
11	100431030321	1 MVIS
12	100431030331	8 PMED
13	100431030351	8 PMED
14	100431040231	8 PMED
15	100431040321	8 PMED
16	100431040341	1 MVIS
17	100431040361	2 OPAT
18	100431040371	8 PMED
19	100441010181	8 PMED
20	100441010191	8 PMED
21	100441010201	8 PMED
22	100441010211	1 MVIS
23	100531020361	8 PMED
24	100531020511	8 PMED
25	100531020521	8 PMED
26	100531020531	8 PMED
27	100531040021	8 PMED
28	100531040031	1 MVIS
29	100531040051	8 PMED
30	100531040091	8 PMED
31	100671010511	8 PMED
32	100671010521	8 PMED
33	100671010531	8 PMED
34	100671010681	8 PMED
35	100671010701	2 OPAT
36	100671010811	8 PMED
37	100671010821	8 PMED
38	100671010831	8 PMED
39	100671020291	1 MVIS
40	100671020301	1 MVIS
41	100671020311	1 MVIS
42	100671020371	8 PMED
43	100671020401	8 PMED
44	100671020411	8 PMED
45	100671020601	8 PMED
46	100671020611	8 PMED
47	100861020131	1 MVIS
48	100861020141	8 PMED
49	100861020151	8 PMED
50	100861020181	8 PMED

Return to Top

HC-144I. Sample SAS Job for Example A - sample print of work.asmvis unique evntidxs from work.asclnks that are non-telephone MVIS (HC-144G) events
Obs	EVNTIDX	EVENTYPE
1	100431030321	1 MVIS
2	100431040341	1 MVIS
3	100441010211	1 MVIS
4	100531040031	1 MVIS
5	100671020291	1 MVIS
6	100671020301	1 MVIS
7	100671020311	1 MVIS
8	100861020131	1 MVIS
9	100861020221	1 MVIS
10	100861020371	1 MVIS
11	100861020511	1 MVIS
12	100861020521	1 MVIS
13	101671020201	1 MVIS
14	101841030191	1 MVIS
15	102361030121	1 MVIS
16	102442010182	1 MVIS
17	102451010121	1 MVIS
18	103581010591	1 MVIS
19	104011010381	1 MVIS
20	104601040181	1 MVIS
21	104601050361	1 MVIS
22	104601050371	1 MVIS
23	104601050381	1 MVIS
24	104801010201	1 MVIS
25	104801010211	1 MVIS
26	104801010221	1 MVIS
27	104801010321	1 MVIS
28	104841010461	1 MVIS
29	104841010471	1 MVIS
30	105241020971	1 MVIS
31	105241020981	1 MVIS
32	105241020991	1 MVIS
33	105241021001	1 MVIS
34	105241021011	1 MVIS
35	105241021201	1 MVIS
36	105241040441	1 MVIS
37	105721010861	1 MVIS
38	105721010871	1 MVIS
39	105721010881	1 MVIS
40	106121010081	1 MVIS
41	106181070081	1 MVIS
42	106771030011	1 MVIS
43	106951010031	1 MVIS
44	107031040021	1 MVIS
45	107031040061	1 MVIS
46	107251040112	1 MVIS
47	108351020521	1 MVIS
48	108411010251	1 MVIS
49	108851010011	1 MVIS
50	109001050131	1 MVIS

Return to Top

HC-144I. Sample SAS Job for Example A - sample print of work.rxlk, sorted by evntidx Rx+event link file records (HC-144IF2)
EVNTIDX	LINKIDX	EVENTYPE
100071040041	100071040051	1 MVIS
100071040041	100071040061	1 MVIS
100081020021	100081020031	1 MVIS
100081020051	100081020061	1 MVIS
100081020051	100081020071	1 MVIS
100121020701	100121020921	1 MVIS
100121020701	100121020931	1 MVIS
100121020761	100121020941	1 MVIS
100121020781	100121020951	1 MVIS
100121020831	100121020961	1 MVIS
100121020841	100121020971	1 MVIS
100121020851	100121020971	1 MVIS
100121020851	100121020981	1 MVIS
100121020891	100121020991	1 MVIS
100141020021	100141020061	1 MVIS
100161020111	100161020151	5 DVIS
100161040081	100161040111	1 MVIS
100161040081	100161040121	1 MVIS
100161040081	100161040131	1 MVIS
100161050151	100161050201	1 MVIS
100161050171	100161050211	1 MVIS
100161060021	100161060051	3 EROM
100161060021	100161060061	3 EROM
100161060121	100161060141	1 MVIS
100161060131	100161060151	3 EROM
100171010241	100171010261	1 MVIS
100171010241	100171010271	1 MVIS
100211030111	100211030151	1 MVIS
100301010111	100301010151	1 MVIS
100301010161	100301010181	1 MVIS
100301010221	100301010231	1 MVIS
100301010221	100301010251	1 MVIS
100301010221	100301010281	1 MVIS
100301020061	100301020071	1 MVIS
100301020061	100301020081	1 MVIS
100301030071	100301030081	1 MVIS
100301040071	100301040111	1 MVIS
100301040081	100301040121	4 STAZ
100301040131	100301040141	1 MVIS
100331010271	100331010341	1 MVIS
100331030481	100331030501	1 MVIS
100341010081	100341010111	1 MVIS
100341010121	100341010131	1 MVIS
100341020052	100341020092	1 MVIS
100341020102	100341020162	3 EROM
100341020102	100341020172	3 EROM
100341020202	100341020222	1 MVIS
100351010071	100351010081	1 MVIS
100351020011	100351020021	1 MVIS
100351030061	100351030071	1 MVIS
100351030061	100351030081	1 MVIS
100351030091	100351030101	1 MVIS
100351030091	100351030111	1 MVIS
100351040181	100351040191	1 MVIS
100351040181	100351040201	1 MVIS
100391020011	100391020021	3 EROM
100391020011	100391020031	3 EROM
100401010401	100401010471	1 MVIS
100401010411	100401010481	1 MVIS
100401010411	100401010491	1 MVIS
100401010411	100401010501	1 MVIS
100401010411	100401010511	1 MVIS
100401010411	100401010521	1 MVIS
100401010411	100401010531	1 MVIS
100401010411	100401010541	1 MVIS
100401010411	100401010551	1 MVIS
100401010411	100401010561	1 MVIS
100401010411	100401010571	1 MVIS
100401010411	100401010581	1 MVIS
100401010411	100401010591	1 MVIS
100401010411	100401010601	1 MVIS
100401010411	100401010611	1 MVIS
100401010411	100401010621	1 MVIS
100401010411	100401010631	1 MVIS
100401010411	100401010641	1 MVIS
100401010411	100401010651	1 MVIS
100401010411	100401010661	1 MVIS
100401010411	100401010671	1 MVIS
100401010411	100401010681	1 MVIS
100401011031	100401011051	2 OPAT
100401011031	100401011061	2 OPAT
100401011031	100401011071	2 OPAT
100401011031	100401011081	2 OPAT
100401011031	100401011091	2 OPAT
100401011031	100401011101	2 OPAT
100401011031	100401011111	2 OPAT
100401011031	100401011121	2 OPAT
100401011031	100401011131	2 OPAT
100401011031	100401011141	2 OPAT
100401011031	100401011151	2 OPAT
100401011031	100401011161	2 OPAT
100431010151	100431010191	3 EROM
100431010231	100431010271	1 MVIS
100431010231	100431010281	1 MVIS
100431010241	100431010291	1 MVIS
100431010251	100431010301	5 DVIS
100431010231	100431010311	5 DVIS
100431010231	100431010321	5 DVIS
100431010231	100431010331	5 DVIS
100431020141	100431020151	1 MVIS
100431010231	100431030191	1 MVIS
100431010231	100431030201	1 MVIS
100431030251	100431030271	1 MVIS
100431030251	100431030281	1 MVIS
100431030321	100431030331	1 MVIS
100431030321	100431030341	1 MVIS
100431030321	100431030351	1 MVIS
100431040191	100431040221	1 MVIS
100431040191	100431040231	1 MVIS
100431040291	100431040321	1 MVIS
100431040291	100431040331	1 MVIS
100431040341	100431040371	1 MVIS
100431040351	100431040381	1 MVIS
100441010011	100441010041	1 MVIS
100441010011	100441010071	1 MVIS
100441010011	100441010081	1 MVIS
100441010121	100441010131	1 MVIS
100461030111	100461030211	1 MVIS
100471010172	100471010212	1 MVIS
100471020032	100471020042	5 DVIS
100491020211	100491020221	3 EROM
100531020371	100531020431	1 MVIS
100531020371	100531020441	1 MVIS
100531020371	100531020451	1 MVIS
100531020371	100531020461	1 MVIS
100531020391	100531020471	1 MVIS
100531020391	100531020481	1 MVIS
100531020391	100531020491	1 MVIS
100531020391	100531020501	1 MVIS
100531020751	100531020861	1 MVIS
100531020751	100531020871	1 MVIS
100531020751	100531020881	1 MVIS
100531020751	100531020891	1 MVIS
100531020761	100531020901	1 MVIS
100531020761	100531020911	1 MVIS
100531020761	100531020921	1 MVIS
100531020761	100531020931	1 MVIS
100531020811	100531020861	1 MVIS
100531020811	100531020871	1 MVIS
100531020811	100531020891	1 MVIS

Return to Top

100861020141

HC-144I. 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
100431030321	100431030331	1 MVIS
100431030321	100431030341	1 MVIS
100431030321	100431030351	1 MVIS
100431040341	100431040371	1 MVIS
100531040031	100531040051	1 MVIS
100671020291	100671020371	1 MVIS
100671020291	100671020381	1 MVIS
100671020291	100671020391	1 MVIS
100861020131	1 MVIS
100861020131	100861020151	1 MVIS
100861020131	100861020161	1 MVIS
100861020131	100861020171	1 MVIS
100861020131	100861020181	1 MVIS
100861020131	100861020191	1 MVIS
100861020131	100861020201	1 MVIS
100861020131	100861020211	1 MVIS
100861020221	100861020231	1 MVIS
100861020221	100861020241	1 MVIS
100861020221	100861020251	1 MVIS
100861020221	100861020261	1 MVIS
100861020221	100861020271	1 MVIS
100861020221	100861020281	1 MVIS
100861020221	100861020291	1 MVIS
100861020221	100861020301	1 MVIS
100861020371	100861020381	1 MVIS
100861020371	100861020391	1 MVIS
100861020371	100861020401	1 MVIS
100861020371	100861020411	1 MVIS
100861020371	100861020421	1 MVIS
100861020371	100861020431	1 MVIS
100861020371	100861020441	1 MVIS
100861020371	100861020451	1 MVIS
100861020371	100861020461	1 MVIS
100861020371	100861020471	1 MVIS
100861020371	100861020481	1 MVIS
100861020371	100861020501	1 MVIS
101671020201	101671020211	1 MVIS
101841030191	101841030201	1 MVIS
101841030191	101841030211	1 MVIS
101841030191	101841030221	1 MVIS
101841030191	101841030231	1 MVIS
101841030191	101841030241	1 MVIS
101841030191	101841030251	1 MVIS
102361030121	102361030141	1 MVIS
102361030121	102361030151	1 MVIS
102361030121	102361030161	1 MVIS
102442010182	102442010192	1 MVIS
102442010182	102442010202	1 MVIS
102451010121	102451010141	1 MVIS
102451010121	102451010151	1 MVIS

Return to Top

HC-144I. Sample SAS Job for Example A - sample print of work.pmedids, sorted by linkidx
Obs	EVNTIDX	LINKIDX	EVENTYPE
1	100431030321	100431030331	1 MVIS
2	100431030321	100431030341	1 MVIS
3	100431030321	100431030351	1 MVIS
4	100431040341	100431040371	1 MVIS
5	100531040031	100531040051	1 MVIS
6	100671020291	100671020371	1 MVIS
7	100671020291	100671020381	1 MVIS
8	100671020291	100671020391	1 MVIS
9	100861020131	100861020141	1 MVIS
10	100861020131	100861020151	1 MVIS
11	100861020131	100861020161	1 MVIS
12	100861020131	100861020171	1 MVIS
13	100861020131	100861020181	1 MVIS
14	100861020131	100861020191	1 MVIS
15	100861020131	100861020201	1 MVIS
16	100861020131	100861020211	1 MVIS
17	100861020221	100861020231	1 MVIS
18	100861020221	100861020241	1 MVIS
19	100861020221	100861020251	1 MVIS
20	100861020221	100861020261	1 MVIS
21	100861020221	100861020271	1 MVIS
22	100861020221	100861020281	1 MVIS
23	100861020221	100861020291	1 MVIS
24	100861020221	100861020301	1 MVIS
25	100861020371	100861020381	1 MVIS
26	100861020371	100861020391	1 MVIS
27	100861020371	100861020401	1 MVIS
28	100861020371	100861020411	1 MVIS
29	100861020371	100861020421	1 MVIS
30	100861020371	100861020431	1 MVIS
31	100861020371	100861020441	1 MVIS
32	100861020371	100861020451	1 MVIS
33	100861020371	100861020461	1 MVIS
34	100861020371	100861020471	1 MVIS
35	100861020371	100861020481	1 MVIS
36	100861020371	100861020501	1 MVIS
37	101671020201	101671020211	1 MVIS
38	101841030191	101841030201	1 MVIS
39	101841030191	101841030211	1 MVIS
40	101841030191	101841030221	1 MVIS
41	101841030191	101841030231	1 MVIS
42	101841030191	101841030241	1 MVIS
43	101841030191	101841030251	1 MVIS
44	102361030121	102361030141	1 MVIS
45	102361030121	102361030151	1 MVIS
46	102361030121	102361030161	1 MVIS
47	102442010182	102442010192	1 MVIS
48	102442010182	102442010202	1 MVIS
49	102451010121	102451010141	1 MVIS
50	102451010121	102451010151	1 MVIS

Return to Top

HC-144I. Sample SAS Job for Example A - sample print of unique linkidxs in work.pmedids
Obs	LINKIDX
1	100431030331
2	100431030341
3	100431030351
4	100431040371
5	100531040051
6	100671020371
7	100671020381
8	100671020391
9	100861020141
10	100861020151
11	100861020161
12	100861020171
13	100861020181
14	100861020191
15	100861020201
16	100861020211
17	100861020231
18	100861020241
19	100861020251
20	100861020261
21	100861020271
22	100861020281
23	100861020291
24	100861020301
25	100861020381
26	100861020391
27	100861020401
28	100861020411
29	100861020421
30	100861020431
31	100861020441
32	100861020451
33	100861020461
34	100861020471
35	100861020481
36	100861020501
37	101671020211
38	101841030201
39	101841030211
40	101841030221
41	101841030231
42	101841030241
43	101841030251
44	102361030141
45	102361030151
46	102361030161
47	102442010192
48	102442010202
49	102451010141
50	102451010151

Return to Top

HC-144I. Sample SAS Job for Example A - sample print of work.mvpmeds PMED (HC-144A) records for unique linkidxs in work.pmedids
LINKIDX	RXRECIDX	RXNAME	RXXP11X	PERWT11F
100431030331	100431030331001	ALBUTEROL	28.21	15760.520887
100431030341	100431030341001	CEFPROZIL	37.64	15760.520887
100431030351	100431030351001	BUDESONIDE	188.99	15760.520887
100431040371	100431040371001	PREDNISOLONE	9.76	24198.068878
100531040051	100531040051001	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051002	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051003	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051004	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051005	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051006	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051007	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051008	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051009	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051010	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051011	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051012	VENTOLIN HFA	38.07	3003.827686
100671020371	100671020371001	Albuterol	25.68	22181.886622
100671020371	100671020371002	Albuterol	25.68	22181.886622
100671020371	100671020371003	Albuterol	25.68	22181.886622
100671020371	100671020371004	Albuterol	25.68	22181.886622
100671020371	100671020371005	Albuterol	25.68	22181.886622
100671020381	100671020381001	BYSTOLIC	148.00	22181.886622
100671020381	100671020381002	BYSTOLIC	148.00	22181.886622
100671020381	100671020381003	BYSTOLIC	98.00	22181.886622
100671020381	100671020381004	BYSTOLIC	98.00	22181.886622
100671020381	100671020381005	BYSTOLIC	98.00	22181.886622
100671020391	100671020391001	AMLODIPINE	15.00	22181.886622
100671020391	100671020391002	AMLODIPINE	15.00	22181.886622
100671020391	100671020391003	AMLODIPINE	15.00	22181.886622
100671020391	100671020391004	AMLODIPINE	15.00	22181.886622
100671020391	100671020391005	AMLODIPINE	15.00	22181.886622
100861020141	100861020141001	LORATADINE	4.90	5684.039049
100861020151	100861020151001	SINGULAIR	143.99	5684.039049
100861020161	100861020161001	LIPITOR	155.10	5684.039049
100861020171	100861020171001	JANUVIA	202.62	5684.039049
100861020181	100861020181001	ADVAIR DISKU	298.13	5684.039049
100861020191	100861020191001	ZETIA	117.56	5684.039049
100861020201	100861020201001	LEVOTHYROXIN	20.50	5684.039049
100861020211	100861020211001	CYCLOBENZAPR	4.82	5684.039049
100861020231	100861020231001	LORATADINE	4.78	5684.039049
100861020231	100861020231002	LORATADINE	4.78	5684.039049
100861020241	100861020241001	SINGULAIR	143.99	5684.039049
100861020241	100861020241002	SINGULAIR	153.93	5684.039049
100861020251	100861020251001	METFORMIN	5.26	5684.039049
100861020251	100861020251002	METFORMIN	197.80	5684.039049
100861020261	100861020261001	GLIMEPIRIDE	6.56	5684.039049
100861020261	100861020261002	GLIMEPIRIDE	4.53	5684.039049
100861020271	100861020271001	JANUVIA	217.67	5684.039049
100861020271	100861020271002	JANUVIA	217.69	5684.039049
100861020281	100861020281001	LEVOTHYROXIN	20.30	5684.039049
100861020281	100861020281002	LEVOTHYROXIN	23.50	5684.039049
100861020291	100861020291001	AMOX/K CLAV	20.00	5684.039049
100861020301	100861020301001	LISINOPRIL	5.86	5684.039049
100861020381	100861020381001	LORATADINE	4.78	5684.039049
100861020381	100861020381002	LORATADINE	4.78	5684.039049
100861020381	100861020381003	LORATADINE	4.78	5684.039049
100861020391	100861020391001	SINGULAIR	153.93	5684.039049
100861020391	100861020391002	SINGULAIR	153.93	5684.039049
100861020391	100861020391003	SINGULAIR	153.93	5684.039049
100861020401	100861020401001	LIPITOR	155.10	5684.039049
100861020401	100861020401002	LIPITOR	155.10	5684.039049
100861020401	100861020401003	LIPITOR	155.10	5684.039049
100861020411	100861020411001	METFORMIN	6.40	5684.039049
100861020411	100861020411002	METFORMIN	6.40	5684.039049
100861020411	100861020411003	METFORMIN	6.40	5684.039049
100861020421	100861020421001	GLIMEPIRIDE	6.56	5684.039049
100861020421	100861020421002	GLIMEPIRIDE	4.53	5684.039049
100861020421	100861020421003	GLIMEPIRIDE	6.56	5684.039049
100861020431	100861020431001	EPIDRIN	12.89	5684.039049
100861020431	100861020431002	EPIDRIN	12.89	5684.039049
100861020431	100861020431003	EPIDRIN	12.89	5684.039049
100861020441	100861020441001	JANUVIA	217.69	5684.039049
100861020441	100861020441002	JANUVIA	217.69	5684.039049
100861020441	100861020441003	JANUVIA	217.69	5684.039049
100861020451	100861020451001	PROAIR HFA	42.68	5684.039049
100861020451	100861020451002	PROAIR HFA	42.68	5684.039049
100861020451	100861020451003	PROAIR HFA	42.68	5684.039049
100861020461	100861020461001	ADVAIR DISKU	307.01	5684.039049
100861020461	100861020461002	ADVAIR DISKU	307.01	5684.039049
100861020461	100861020461003	ADVAIR DISKU	307.01	5684.039049
100861020471	100861020471001	LEVOTHYROXIN	23.50	5684.039049
100861020471	100861020471002	LEVOTHYROXIN	23.50	5684.039049
100861020471	100861020471003	LEVOTHYROXIN	23.50	5684.039049
100861020481	100861020481001	CYCLOBENZAPR	4.82	5684.039049
100861020481	100861020481002	CYCLOBENZAPR	4.74	5684.039049
100861020481	100861020481003	CYCLOBENZAPR	4.74	5684.039049
100861020501	100861020501001	LISINOPRIL	5.86	5684.039049
100861020501	100861020501002	LISINOPRIL	5.86	5684.039049
100861020501	100861020501003	LISINOPRIL	5.86	5684.039049
101671020211	101671020211001	Advair	200.10	18399.520261
101671020211	101671020211002	Advair	200.10	18399.520261
101671020211	101671020211003	Advair	200.10	18399.520261
101671020211	101671020211004	Advair	200.10	18399.520261
101671020211	101671020211005	Advair	200.10	18399.520261
101671020211	101671020211006	Advair	200.10	18399.520261
101841030201	101841030201001	TRI-VITAMIN	6.65	3531.737599
101841030201	101841030201002	TRI-VITAMIN	6.65	3531.737599
101841030201	101841030201003	TRI-VITAMIN	6.65	3531.737599
101841030201	101841030201004	TRI-VITAMIN	6.65	3531.737599
101841030211	101841030211001	SALINE NASAL	3.22	3531.737599
101841030211	101841030211002	SALINE NASAL	3.22	3531.737599
101841030221	101841030221001	CHLD IBUPROF	7.68	3531.737599
101841030231	101841030231001	FERROUS SULF	6.40	3531.737599
101841030231	101841030231002	FERROUS SULF	6.40	3531.737599
101841030231	101841030231003	FERROUS SULF	6.40	3531.737599
101841030241	101841030241001	FLUTICASONE	32.16	3531.737599
101841030241	101841030241002	FLUTICASONE	32.24	3531.737599
101841030251	101841030251001	ALBUTEROL	4.00	3531.737599
102361030141	102361030141001	PROAIR HFA	38.98	16688.717984
102361030151	102361030151001	PREDNISONE	1.66	16688.717984
102361030161	102361030161001	AZITHROMYCIN	12.79	16688.717984
102442010192	102442010192001	proventil	20.00	9663.838427
102442010202	102442010202001	QVAR	100.14	9663.838427
102451010141	102451010141001	PROAIR HFA	38.49	16986.298195
102451010141	102451010141002	PROAIR HFA	38.49	16986.298195
102451010141	102451010141003	PROAIR HFA	38.49	16986.298195
102451010141	102451010141004	PROAIR HFA	38.32	16986.298195
102451010151	102451010151001	SINGULAIR	373.30	16986.298195
104601040211	104601040211001	ADVAIR DISKU	177.68	10121.908938
104601040211	104601040211002	ADVAIR DISKU	177.68	10121.908938
104601040221	104601040221001	LEVOCETIRIZI	78.21	10121.908938
104601040221	104601040221002	LEVOCETIRIZI	71.12	10121.908938
104601040231	104601040231001	LANSOPRAZOLE	120.75	10121.908938
104601040231	104601040231002	LANSOPRAZOLE	120.75	10121.908938
104601050421	104601050421001	AMOXICILLIN	11.50	12853.001484
104801010341	104801010341001	TRAZODONE	2.73	4027.465897
104801010341	104801010341002	TRAZODONE	2.73	4027.465897
104801010351	104801010351001	ZANAFLEX	136.83	4027.465897
104801010351	104801010351002	ZANAFLEX	136.83	4027.465897
104841010501	104841010501001	SYMBICORT	223.62	20342.976240
104841010501	104841010501002	SYMBICORT	223.62	20342.976240
104841010501	104841010501003	SYMBICORT	223.62	20342.976240
104841010501	104841010501004	SYMBICORT	223.62	20342.976240
104841010501	104841010501005	SYMBICORT	223.62	20342.976240
104841010511	104841010511001	PROAIR HFA	37.85	20342.976240
104841010511	104841010511002	PROAIR HFA	37.85	20342.976240
104841010511	104841010511003	PROAIR HFA	37.85	20342.976240
104841010511	104841010511004	PROAIR HFA	37.85	20342.976240
104841010511	104841010511005	PROAIR HFA	37.85	20342.976240
104841010521	104841010521001	Albuterol	60.49	20342.976240
104841010521	104841010521002	Albuterol	60.49	20342.976240
104841010521	104841010521003	Albuterol	60.49	20342.976240
104841010521	104841010521004	Albuterol	60.49	20342.976240
104841010521	104841010521005	Albuterol	60.49	20342.976240
104841010531	104841010531001	TOPIRAMATE	99.32	20342.976240
104841010531	104841010531002	TOPIRAMATE	99.32	20342.976240
104841010531	104841010531003	TOPIRAMATE	99.32	20342.976240
104841010541	104841010541001	MELOXICAM	8.00	20342.976240
104841010541	104841010541002	MELOXICAM	8.00	20342.976240
105241021041	105241021041001	DIGOXIN	4.00	10112.153351
105241021041	105241021041002	DIGOXIN	4.00	10112.153351
105241021041	105241021041003	DIGOXIN	4.00	10112.153351
105241021041	105241021041004	DIGOXIN	4.00	10112.153351
105241021051	105241021051001	LEXAPRO	34.92	10112.153351
105241021061	105241021061001	WARFARIN	24.63	10112.153351
105241021061	105241021061002	WARFARIN	24.63	10112.153351
105241021061	105241021061003	WARFARIN	24.63	10112.153351
105241021061	105241021061004	WARFARIN	24.63	10112.153351
105241021071	105241021071001	KLOR-CON M20	21.35	10112.153351
105241021071	105241021071002	KLOR-CON M20	21.35	10112.153351
105241021081	105241021081001	Nasal Decongestant 0.05% Spray	42.24	10112.153351
105241021091	105241021091001	CLONAZEPAM	1.87	10112.153351
105241021091	105241021091002	CLONAZEPAM	1.87	10112.153351
105241021091	105241021091003	CLONAZEPAM	1.87	10112.153351
105241021091	105241021091004	CLONAZEPAM	1.87	10112.153351
105241021091	105241021091005	CLONAZEPAM	1.87	10112.153351
105241021091	105241021091006	CLONAZEPAM	1.87	10112.153351
105241021091	105241021091007	CLONAZEPAM	1.87	10112.153351
105241021091	105241021091008	CLONAZEPAM	1.87	10112.153351
105241021091	105241021091009	CLONAZEPAM	1.87	10112.153351
105241021101	105241021101001	ASMANEX 120	211.90	10112.153351
105241021101	105241021101002	ASMANEX 120	211.90	10112.153351
105241021101	105241021101003	ASMANEX 120	211.90	10112.153351
105241021101	105241021101004	ASMANEX 120	211.90	10112.153351
105241021101	105241021101005	ASMANEX 120	211.90	10112.153351
105241021101	105241021101006	ASMANEX 120	211.90	10112.153351
105241021101	105241021101007	ASMANEX 120	211.90	10112.153351
105241021101	105241021101008	ASMANEX 120	211.90	10112.153351
105241021111	105241021111001	METOPROLOL	28.13	10112.153351
105241021111	105241021111002	METOPROLOL	28.13	10112.153351
105241021121	105241021121001	ISOSORB MONO	15.38	10112.153351
105241021121	105241021121002	ISOSORB MONO	15.38	10112.153351
105241021121	105241021121003	ISOSORB MONO	15.38	10112.153351
105241021121	105241021121004	ISOSORB MONO	15.38	10112.153351
105241021121	105241021121005	ISOSORB MONO	15.38	10112.153351
105241021121	105241021121006	ISOSORB MONO	15.38	10112.153351
105241021121	105241021121007	ISOSORB MONO	15.38	10112.153351
105241021131	105241021131001	FUROSEMIDE	21.19	10112.153351
105241021131	105241021131002	FUROSEMIDE	10.00	10112.153351
105241021141	105241021141001	LISINOPRIL	10.62	10112.153351
105241021141	105241021141002	LISINOPRIL	10.62	10112.153351
105241021141	105241021141003	LISINOPRIL	10.62	10112.153351
105241021151	105241021151001	FLUTICASONE	8.24	10112.153351
105241021151	105241021151002	FLUTICASONE	8.24	10112.153351
105241021151	105241021151003	FLUTICASONE	8.24	10112.153351
105241021151	105241021151004	FLUTICASONE	8.24	10112.153351
105241021161	105241021161001	METOPROLOL	277.90	10112.153351
105241021161	105241021161002	METOPROLOL	277.90	10112.153351
105241021171	105241021171001	ADVAIR DISKU	287.20	10112.153351
105241021171	105241021171002	ADVAIR DISKU	287.20	10112.153351

Return to Top

HC-144I. Sample SAS Job for Example A - Total Rx expenditures associated with medical visits (excluding telephone) for asthma, analysis variable: RXXP11X SUM OF PAYMENTS RXSF11X-RXOU11X(IMPUTED)
N	Sum
5023	426067.16

Return to Top

HC-144I. Sample SAS Job for Example A - Total Rx expenditures associated with medical visits (excluding telephone) for asthma, weighted analysis variable: RXXP11X SUM OF PAYMENTS RXSF11X-RXOU11X(IMPUTED)
N	Sum
5023	4491412403

Return to Top

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

NOTE: SAS initialization used:
real time 1.90 seconds
cpu time 0.12 seconds

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

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

NOTE: AUTOEXEC processing completed.

1 ods rtf file = 'c:\sampleB.rtf' bodytitle;
NOTE: Writing RTF Body file: c:\sampleB.rtf
2
3 ods noproctitle;
4
5 OPTIONS LS=132 PS=59;
6
7 TITLE1 "HC-144I";
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.04 seconds
cpu time 0.03 seconds

26
27 *--------------------------------------------------------------------------------------
28 * Get condition records coded as asthma.
29 *--------------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H146 (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;

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

39
40 proc print data=asconds (obs=50);
41 title3 "sample print of work.asconds - sorted by condidx";
42 title4 "COND (H146) 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.04 seconds

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

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

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

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

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

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

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

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

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

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

NOTE: There were 313747 observations read from the data set WORK.PMED.
NOTE: There were 6998 observations read from the data set WORK.ASCLNKS.
NOTE: The data set WORK.ASPMEDS has 10349 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 RXXP11X PERWT11F;
96 title3 "sample print of work.aspmeds";
97 title4 "PMED (HC-144A) 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.04 seconds
cpu time 0.03 seconds

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

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

104
105 PROC MEANS DATA=ASPMEDS N SUM;
106 VAR RXXP11X;
107 WEIGHT PERWT11F;
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 10349 observations read from the data set WORK.ASPMEDS.
NOTE: The PROCEDURE MEANS printed page 16.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

111
112 ods rtf close;
113

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

Return to Top

HC-144I. Sample SAS Job for Example B - sample print of work.asconds, sorted by condidx COND (H146) records where cccodex=128
Obs	CONDIDX	CCCODEX
1	100121010051	128
2	100171010021	128
3	100431010021	128
4	100431030011	128
5	100431040011	128
6	100441010031	128
7	100531020041	128
8	100531040011	128
9	100671010071	128
10	100671020041	128
11	100861020041	128
12	101171050011	128
13	101231030011	128
14	101311020041	128
15	101371010051	128
16	101671020011	128
17	101831050011	128
18	101841020091	128
19	101841030031	128
20	101841030061	128
21	101981020061	128
22	101981030051	128
23	101981040031	128
24	101981050011	128
25	102061010011	128
26	102061040011	128
27	102291020011	128
28	102331020021	128
29	102361030011	128
30	102361040011	128
31	102421010041	128
32	102442010032	128
33	102451010021	128
34	102451030011	128
35	102531020011	128
36	102781020031	128
37	102891010051	128
38	102891020021	128
39	102991050011	128
40	102991060011	128
41	103031010041	128
42	103051020011	128
43	103101010031	128
44	103151020011	128
45	103371010011	128
46	103581010041	128
47	103611020011	128
48	103691010021	128
49	103701010091	128
50	103851040011	128

Return to Top

HC-144I. Sample SAS Job for Example B - sample print of work.asclnks, sorted by condidx events linked to asthma condition records
CONDIDX	EVNTIDX	EVENTYPE
100121010051	100121010111	8 PMED
100121010051	100121010151	8 PMED
100121010051	100121010201	8 PMED
100121010051	100121010231	8 PMED
100171010021	100171010231	8 PMED
100171010021	100171010271	8 PMED
100431010021	100431010201	8 PMED
100171010021	100431010271	8 PMED
100431030011	100431030281	8 PMED
100431030011	100431030311	2 OPAT
100431030011	100431030321	1 MVIS
100431030011	100431030331	8 PMED
100431030011	100431030351	8 PMED
100431040011	100431040231	8 PMED
100431040011	100431040321	8 PMED
100431040011	100431040341	1 MVIS
100431040011	100431040361	2 OPAT
100431040011	100431040371	8 PMED
100441010031	100441010181	8 PMED
100441010031	100441010191	8 PMED
100441010031	100441010201	8 PMED
100441010031	100441010211	1 MVIS
100531020041	100531020361	8 PMED
100531020041	100531020511	8 PMED
100531020041	100531020521	8 PMED
100531020041	100531020531	8 PMED
100531040011	100531040021	8 PMED
100531040011	100531040031	1 MVIS
100531040011	100531040051	8 PMED
100531040011	100531040091	8 PMED
100671010071	100671010511	8 PMED
100671010071	100671010521	8 PMED
100671010071	100671010531	8 PMED
100671010071	100671010681	8 PMED
100671010071	100671010701	2 OPAT
100671010071	100671010811	8 PMED
100671010071	100671010821	8 PMED
100671010071	100671010831	8 PMED
100671020041	100671020291	1 MVIS
100671020041	100671020301	1 MVIS
100671020041	100671020311	1 MVIS
100671020041	100671020371	8 PMED
100671020041	100671020401	8 PMED
100671020041	100671020411	8 PMED
100671020041	100671020601	8 PMED
100671020041	100671020611	8 PMED
100861020041	100861020131	1 MVIS
100861020041	100861020141	8 PMED
100861020041	100861020151	8 PMED
100861020041	100861020181	8 PMED
100861020041	100861020221	1 MVIS
100861020041	100861020241	8 PMED
100861020041	100861020291	8 PMED
100861020041	100861020371	1 MVIS
100861020041	100861020391	8 PMED
100861020041	100861020411	8 PMED
100861020041	100861020451	8 PMED
100861020041	100861020461	8 PMED
100861020041	100861020511	1 MVIS
100861020041	100861020521	1 MVIS
101231030011	101231030121	8 PMED
101371010051	101371010481	8 PMED
101671020011	101671020201	1 MVIS
101671020011	101671020211	8 PMED
101831050011	101831050031	8 PMED
101841020091	101841020381	8 PMED
101841020091	101841020411	2 OPAT
101841020091	101841020421	2 OPAT
101841020091	101841020521	8 PMED
101841020091	101841020551	8 PMED
101841020091	101841020691	8 PMED
101841020091	101841020721	8 PMED
101841020091	101841020731	8 PMED
101841020091	101841020761	8 PMED
101841020091	101841020791	2 OPAT

Return to Top

HC-144I. Sample SAS Job for Example B - sample print of work.asclnks, sorted by evntidx
Obs	CONDIDX	EVNTIDX	EVENTYPE
1	100121010051	100121010111	8 PMED
2	100121010051	100121010151	8 PMED
3	100121010051	100121010201	8 PMED
4	100121010051	100121010231	8 PMED
5	100171010021	100171010231	8 PMED
6	100171010021	100171010271	8 PMED
7	100431010021	100431010201	8 PMED
8	100431010021	100431010271	8 PMED
9	100431030011	100431030281	8 PMED
10	100431030011	100431030311	2 OPAT
11	100431030011	100431030321	1 MVIS
12	100431030011	100431030331	8 PMED
13	100431030011	100431030351	8 PMED
14	100431040011	100431040231	8 PMED
15	100431040011	100431040321	8 PMED
16	100431040011	100431040341	1 MVIS
17	100431040011	100431040361	2 OPAT
18	100431040011	100431040371	8 PMED
19	100441010031	100441010181	8 PMED
20	100441010031	100441010191	8 PMED
21	100441010031	100441010201	8 PMED
22	100441010031	100441010211	1 MVIS
23	100531020041	100531020361	8 PMED
24	100531020041	100531020511	8 PMED
25	100531020041	100531020521	8 PMED
26	100531020041	100531020531	8 PMED
27	100531040011	100531040021	8 PMED
28	100531040011	100531040031	1 MVIS
29	100531040011	100531040051	8 PMED
30	100531040011	100531040091	8 PMED
31	100671010071	100671010511	8 PMED
32	100671010071	100671010521	8 PMED
33	100671010071	100671010531	8 PMED
34	100671010071	100671010681	8 PMED
35	100671010071	100671010701	2 OPAT
36	100671010071	100671010811	8 PMED
37	100671010071	100671010821	8 PMED
38	100671010071	100671010831	8 PMED
39	100671020041	100671020291	1 MVIS
40	100671020041	100671020301	1 MVIS
41	100671020041	100671020311	1 MVIS
42	100671020041	100671020371	8 PMED
43	100671020041	100671020401	8 PMED
44	100671020041	100671020411	8 PMED
45	100671020041	100671020601	8 PMED
46	100671020041	100671020611	8 PMED
47	100861020041	100861020131	1 MVIS
48	100861020041	100861020141	8 PMED
49	100861020041	100861020151	8 PMED
50	100861020041	100861020181	8 PMED

Return to Top

HC-144I. Sample SAS Job for Example B - sample print of unique evntidxs from work.asclnks
Obs	EVNTIDX	EVENTYPE
1	100121010111	8 PMED
2	100121010151	8 PMED
3	100121010201	8 PMED
4	100121010231	8 PMED
5	100171010231	8 PMED
6	100171010271	8 PMED
7	100431010201	8 PMED
8	100431010271	8 PMED
9	100431030281	8 PMED
10	100431030311	2 OPAT
11	100431030321	1 MVIS
12	100431030331	8 PMED
13	100431030351	8 PMED
14	100431040231	8 PMED
15	100431040321	8 PMED
16	100431040341	1 MVIS
17	100431040361	2 OPAT
18	100431040371	8 PMED
19	100441010181	8 PMED
20	100441010191	8 PMED
21	100441010201	8 PMED
22	100441010211	1 MVIS
23	100531020361	8 PMED
24	100531020511	8 PMED
25	100531020521	8 PMED
26	100531020531	8 PMED
27	100531040021	8 PMED
28	100531040031	1 MVIS
29	100531040051	8 PMED
30	100531040091	8 PMED
31	100671010511	8 PMED
32	100671010521	8 PMED
33	100671010531	8 PMED
34	100671010681	8 PMED
35	100671010701	2 OPAT
36	100671010811	8 PMED
37	100671010821	8 PMED
38	100671010831	8 PMED
39	100671020291	1 MVIS
40	100671020301	1 MVIS
41	100671020311	1 MVIS
42	100671020371	8 PMED
43	100671020401	8 PMED
44	100671020411	8 PMED
45	100671020601	8 PMED
46	100671020611	8 PMED
47	100861020131	1 MVIS
48	100861020141	8 PMED
49	100861020151	8 PMED
50	100861020181	8 PMED

Return to Top

HC-144I. Sample SAS Job for Example B - sample print of work.aspmeds PMED (HC-144A) records which link to condition records coded as asthma
LINKIDX	RXRECIDX	RXNAME	RXXP11X	PERWT11F
100121010111	100121010111001	COMBIVENT	472.04	15410.497988
100121010111	100121010111002	COMBIVENT	472.04	15410.497988
100121010151	100121010151001	COMBIVENT	472.04	15410.497988
100121010201	100121010201001	COMBIVENT	472.04	15410.497988
100121010201	100121010201002	COMBIVENT	472.04	15410.497988
100121010201	100121010201003	COMBIVENT	472.04	15410.497988
100121010201	100121010201004	COMBIVENT	472.04	15410.497988
100121010201	100121010201005	COMBIVENT	472.04	15410.497988
100121010231	100121010231001	COMBIVENT	528.45	15410.497988
100121010231	100121010231002	COMBIVENT	528.45	15410.497988
100121010231	100121010231003	COMBIVENT	528.45	15410.497988
100121010231	100121010231004	COMBIVENT	591.62	15410.497988
100121010231	100121010231005	COMBIVENT	591.62	15410.497988
100171010231	100171010231001	ADVAIR DISKU	235.38	11412.260194
100171010231	100171010231002	ADVAIR DISKU	235.91	11412.260194
100171010231	100171010231003	ADVAIR DISKU	235.91	11412.260194
100171010231	100171010231004	ADVAIR DISKU	235.91	11412.260194
100171010231	100171010231005	ADVAIR DISKU	235.91	11412.260194
100171010271	100171010271001	ADVAIR DISKU	242.40	11412.260194
100431010201	100431010201001	ADVAIR DISKU	182.97	17531.434658
100431010271	100431010271001	ADVAIR DISKU	142.68	17531.434658
100431010271	100431010271002	ADVAIR DISKU	182.97	17531.434658
100431030281	100431030281001	PREDNISOLONE	7.00	15760.520887
100431030331	100431030331001	ALBUTEROL	28.21	15760.520887
100431030351	100431030351001	BUDESONIDE	188.99	15760.520887
100431040231	100431040231001	SILDEC PE-DM	6.02	24198.068878
100431040321	100431040321001	ALBUTEROL	34.86	24198.068878
100431040321	100431040321002	ALBUTEROL	34.86	24198.068878
100431040371	100431040371001	PREDNISOLONE	9.76	24198.068878
100441010181	100441010181001	PULMO-AIDE	60.00	2346.180578
100441010191	100441010191001	VENTOLIN HFA	51.99	2346.180578
100441010201	100441010201001	SYMBICORT	220.61	2346.180578
100531020361	100531020361001	VENTOLIN HFA	26.21	2895.143262
100531020361	100531020361002	VENTOLIN HFA	26.21	2895.143262
100531020511	100531020511001	VENTOLIN HFA	26.21	2895.143262
100531020511	100531020511002	VENTOLIN HFA	26.21	2895.143262
100531020511	100531020511003	VENTOLIN HFA	26.52	2895.143262
100531020511	100531020511004	VENTOLIN HFA	26.52	2895.143262
100531020521	100531020521001	ADVAIR DISKU	88.29	2895.143262
100531020521	100531020521002	ADVAIR DISKU	88.29	2895.143262
100531020521	100531020521003	ADVAIR DISKU	88.29	2895.143262
100531020521	100531020521004	ADVAIR DISKU	88.29	2895.143262
100531020531	100531020531001	SINGULAIR	59.79	2895.143262
100531020531	100531020531002	SINGULAIR	59.79	2895.143262
100531020531	100531020531003	SINGULAIR	59.79	2895.143262
100531020531	100531020531004	SINGULAIR	59.79	2895.143262
100531040021	100531040021001	VENTOLIN HFA	53.04	3003.827686
100531040021	100531040021002	VENTOLIN HFA	53.04	3003.827686
100531040021	100531040021003	VENTOLIN HFA	53.04	3003.827686
100531040051	100531040051001	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051002	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051003	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051004	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051005	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051006	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051007	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051008	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051009	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051010	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051011	VENTOLIN HFA	38.07	3003.827686
100531040051	100531040051012	VENTOLIN HFA	38.07	3003.827686
100531040091	100531040091001	VENTOLIN HFA	37.01	3003.827686
100531040091	100531040091002	VENTOLIN HFA	37.01	3003.827686
100671010511	100671010511001	SEREVENT DIS	173.62	16602.023865
100671010511	100671010511002	SEREVENT DIS	173.62	16602.023865
100671010511	100671010511003	SEREVENT DIS	173.62	16602.023865
100671010511	100671010511004	SEREVENT DIS	173.62	16602.023865
100671010511	100671010511005	SEREVENT DIS	173.62	16602.023865
100671010521	100671010521001	BUDESONIDE	315.07	16602.023865
100671010521	100671010521002	BUDESONIDE	270.78	16602.023865
100671010521	100671010521003	BUDESONIDE	239.10	16602.023865
100671010521	100671010521004	BUDESONIDE	239.10	16602.023865
100671010521	100671010521005	BUDESONIDE	291.40	16602.023865
100671010531	100671010531001	ALBUTEROL	18.60	16602.023865
100671010521	100671010531002	ALBUTEROL	22.90	16602.023865
100671010521	100671010531003	ALBUTEROL	22.90	16602.023865
100671010521	100671010531004	ALBUTEROL	22.90	16602.023865
100671010521	100671010531005	ALBUTEROL	18.60	16602.023865
100671010681	100671010681001	ALBUTEROL	208.63	16602.023865
100671010681	100671010681002	ALBUTEROL	208.63	16602.023865
100671010681	100671010681003	ALBUTEROL	208.63	16602.023865
100671010811	100671010811001	SEREVENT DIS	40.00	16602.023865
100671010811	100671010811002	SEREVENT DIS	40.00	16602.023865
100671010811	100671010811003	SEREVENT DIS	40.00	16602.023865
100671010811	100671010811004	SEREVENT DIS	40.00	16602.023865
100671010821	100671010821001	BUDESONIDE	296.68	16602.023865
100671010821	100671010821002	BUDESONIDE	284.83	16602.023865
100671010821	100671010821003	BUDESONIDE	284.83	16602.023865
100671010821	100671010821004	BUDESONIDE	253.15	16602.023865
100671010831	100671010831001	ALBUTEROL	208.63	16602.023865
100671010831	100671010831002	ALBUTEROL	208.63	16602.023865
100671010831	100671010831003	ALBUTEROL	208.63	16602.023865
100671020371	100671020371001	Albuterol	25.68	22181.886622
100671020371	100671020371002	Albuterol	25.68	22181.886622
100671020371	100671020371003	Albuterol	25.68	22181.886622
100671020371	100671020371004	Albuterol	25.68	22181.886622
100671020371	100671020371005	Albuterol	25.68	22181.886622
100671020401	100671020401001	SPIRIVA	227.98	22181.886622
100671020401	100671020401002	SPIRIVA	248.38	22181.886622
100671020411	100671020411001	SYMBICORT	377.35	22181.886622
100671020411	100671020411002	SYMBICORT	377.35	22181.886622
100671020411	100671020411003	SYMBICORT	377.35	22181.886622
100671020411	100671020411004	SYMBICORT	377.35	22181.886622
100671020411	100671020411005	SYMBICORT	377.35	22181.886622
100671020601	100671020601001	SPIRIVA	576.20	22181.886622
100671020601	100671020601002	SPIRIVA	576.20	22181.886622
100671020601	100671020601003	SPIRIVA	576.20	22181.886622
100671020601	100671020601004	SPIRIVA	576.20	22181.886622
100671020611	100671020611001	SYMBICORT	377.35	22181.886622
100671020601	100671020611002	SYMBICORT	377.35	22181.886622
100671020601	100671020611003	SYMBICORT	377.35	22181.886622
100671020601	100671020611004	SYMBICORT	377.35	22181.886622
100861020141	100861020141001	LORATADINE	4.90	5684.039049
100861020151	100861020151001	SINGULAIR	143.99	5684.039049
100861020181	100861020181001	ADVAIR DISKU	298.13	5684.039049
100861020241	100861020241001	SINGULAIR	143.99	5684.039049
100861020241	100861020241002	SINGULAIR	153.93	5684.039049
100861020291	100861020291001	AMOX/K CLAV	20.00	5684.039049
100861020391	100861020391001	SINGULAIR	153.93	5684.039049
100861020391	100861020391002	SINGULAIR	153.93	5684.039049
100861020391	100861020391003	SINGULAIR	153.93	5684.039049
100861020411	100861020411001	METFORMIN	6.40	5684.039049
100861020411	100861020411002	METFORMIN	6.40	5684.039049
100861020411	100861020411003	METFORMIN	6.40	5684.039049
100861020451	100861020451001	PROAIR HFA	42.68	5684.039049
100861020451	100861020451002	PROAIR HFA	42.68	5684.039049
100861020451	100861020451003	PROAIR HFA	42.68	5684.039049
100861020461	100861020461001	ADVAIR DISKU	307.01	5684.039049
100861020461	100861020461002	ADVAIR DISKU	307.01	5684.039049
100861020461	100861020461003	ADVAIR DISKU	307.01	5684.039049
101231030121	101231030121001	Albuterol	66.75	14137.147831
101371010481	101371010481001	Albuterol 90mcg (Ventolin) Aerosol	7.00	2790.187377
101671020211	101671020211001	Advair	200.10	18399.520261
101671020211	101671020211002	Advair	200.10	18399.520261
101671020211	101671020211003	Advair	200.10	18399.520261
101671020211	101671020211004	Advair	200.10	18399.520261
101671020211	101671020211005	Advair	200.10	18399.520261
101671020211	101671020211006	Advair	200.10	18399.520261
101831050031	101831050031001	SINGULAIR	170.70	4481.061057
101671020211	101831050031002	SINGULAIR	165.99	4481.061057
101671020211	101831050031003	SINGULAIR	154.99	4481.061057
101671020211	101831050031004	SINGULAIR	165.99	4481.061057
101841020381	101841020381001	Ventolin HFA	13.95	2661.284010
101841020521	101841020521001	Ventolin HFA	13.95	2661.284010
101841020521	101841020521002	Ventolin HFA	13.95	2661.284010
101841020521	101841020521003	Ventolin HFA	13.95	2661.284010
101841020551	101841020551001	Ventolin HFA	13.95	2661.284010
101841020551	101841020551002	Ventolin HFA	13.95	2661.284010
101841020551	101841020551003	Ventolin HFA	13.95	2661.284010
101841020691	101841020691001	Ventolin HFA	13.95	2661.284010
101841020691	101841020691002	Ventolin HFA	13.95	2661.284010
101841020691	101841020691003	Ventolin HFA	13.95	2661.284010
101841020721	101841020721001	FLUTICASONE	32.24	2661.284010
101841020721	101841020721002	FLUTICASONE	32.24	2661.284010
101841020721	101841020721003	FLUTICASONE	32.24	2661.284010
101841020721	101841020721004	FLUTICASONE	32.24	2661.284010
101841020731	101841020731001	Ventolin HFA	13.95	2661.284010
101841020731	101841020731002	Ventolin HFA	13.95	2661.284010
101841020731	101841020731003	Ventolin HFA	13.95	2661.284010
101841020761	101841020761001	SINGULAIR	125.71	2661.284010
101841020761	101841020761002	SINGULAIR	137.81	2661.284010
101841020761	101841020761003	SINGULAIR	137.81	2661.284010
101841030211	101841030211001	SALINE NASAL	3.22	3531.737599
101841030211	101841030211002	SALINE NASAL	3.22	3531.737599
101841030241	101841030241001	FLUTICASONE	32.16	3531.737599
101841030241	101841030241002	FLUTICASONE	32.24	3531.737599
101841030251	101841030251001	ALBUTEROL	4.00	3531.737599
101841030301	101841030301001	ALBUTEROL	4.00	3531.737599
101841030301	101841030301002	ALBUTEROL	12.80	3531.737599
101841030301	101841030301003	ALBUTEROL	12.80	3531.737599
101841030301	101841030301004	ALBUTEROL	12.80	3531.737599
101841030331	101841030331001	SINGULAIR	148.01	3531.737599
101841030331	101841030331002	SINGULAIR	148.01	3531.737599
101841030341	101841030341001	FLOVENT HFA	107.57	3531.737599
101841030341	101841030341002	FLOVENT HFA	105.65	3531.737599
101841030341	101841030341003	FLOVENT HFA	107.57	3531.737599
102061010071	102061010071001	ADVAIR DISKU	177.69	9457.398981
102061010081	102061010081001	ADVAIR DISKU	177.69	9457.398981
102061040151	102061040151001	ALBUTEROL	10.38	8857.206471
102061040151	102061040151002	ALBUTEROL	10.38	8857.206471
102291020101	102291020101001	Albuterol Sulfate	75.51	11009.454983
102331020321	102331020321001	PROAIR HFA	52.99	25550.818294
102361030141	102361030141001	PROAIR HFA	38.98	16688.717984
102361030151	102361030151001	PREDNISONE	1.66	16688.717984
102361030161	102361030161001	AZITHROMYCIN	12.79	16688.717984
102421010231	102421010231001	COMBIVENT	313.77	2849.223082
102421010231	102421010231002	COMBIVENT	313.77	2849.223082
102421010231	102421010231003	COMBIVENT	313.77	2849.223082
102421010271	102421010271001	ADVAIR	54.99	2849.223082
102421010271	102421010271002	ADVAIR	54.99	2849.223082
102421010271	102421010271003	ADVAIR	54.99	2849.223082
102421010271	102421010271004	ADVAIR	54.99	2849.223082
102421010401	102421010401001	PROVENTIL HFA	36.72	2849.223082
102421010401	102421010401002	PROVENTIL HFA	36.72	2849.223082
102421010401	102421010401003	PROVENTIL HFA	31.96	2849.223082
102421010401	102421010401004	PROVENTIL HFA	31.96	2849.223082
102421010471	102421010471001	ADVAIR	60.00	2849.223082
102421010471	102421010471002	ADVAIR	60.00	2849.223082
102421010471	102421010471003	ADVAIR DISKUS	60.00	2849.223082
102421010471	102421010471004	ADVAIR DISKUS	60.00	2849.223082
102442010192	102442010192001	proventil	20.00	9663.838427
102442010202	102442010202001	QVAR	100.14	9663.838427
102451010101	102451010101001	PROAIR HFA	30.00	16986.298195
102451010101	102451010101002	PROAIR HFA	38.49	16986.298195
102451010111	102451010111001	SINGULAIR	339.68	16986.298195
102451010141	102451010141001	PROAIR HFA	38.49	16986.298195
102451010141	102451010141002	PROAIR HFA	38.49	16986.298195
102451010141	102451010141003	PROAIR HFA	38.49	16986.298195
102451010141	102451010141004	PROAIR HFA	38.32	16986.298195
102451010151	102451010151001	SINGULAIR	373.30	16986.298195
102451010161	102451010161001	PROAIR HFA	38.32	16986.298195
102451010161	102451010161002	PROAIR HFA	30.00	16986.298195
102451010161	102451010161003	PROAIR HFA	30.00	16986.298195
102451010171	102451010171001	SINGULAIR	397.67	16986.298195
102531020271	102531020271001	ADVAIR HFA	295.78	23546.114105
102781020271	102781020271001	SYMBICORT	209.50	12872.436195
102781020271	102781020271002	SYMBICORT	209.13	12872.436195
102781020331	102781020331001	Albuterol	60.49	12872.436195
102781020331	102781020331002	Albuterol	60.49	12872.436195
102781020331	102781020331003	Albuterol	60.49	12872.436195
102781020331	102781020331004	Albuterol	60.49	12872.436195
102891020041	102891020041001	VENTOLIN HFA	37.49	2000.026751
102891020051	102891020051001	ADVAIR DISKU	184.00	2000.026751
102991050091	102991050091001	PROVENTIL HFA	36.72	5714.140416
102991050091	102991050091002	PROVENTIL HFA	36.72	5714.140416
102991060091	102991060091001	MULTIVITAMIN	2.42	4575.712714
102991060091	102991060091002	MULTIVITAMIN	2.42	4575.712714
102991060091	102991060091003	MULTIVITAMIN	2.42	4575.712714
103101010411	103101010411001	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010411	103101010411002	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010411	103101010411003	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010411	103101010411004	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010411	103101010411005	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010411	103101010411006	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010411	103101010411007	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010411	103101010411008	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010411	103101010411009	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010411	103101010411010	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010411	103101010411011	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010411	103101010411012	Albuterol 90mcg (Ventolin) Aerosol	45.25	10928.136096
103101010431	103101010431001	MOMETASONE FUROATE	39.34	10928.136096
103101010431	103101010431002	MOMETASONE FUROATE	39.34	10928.136096
103101010431	103101010431003	MOMETASONE FUROATE	39.34	10928.136096
103101010431	103101010431004	MOMETASONE FUROATE	39.34	10928.136096
103101010431	103101010431005	MOMETASONE FUROATE	39.34	10928.136096
103101010431	103101010431006	MOMETASONE FUROATE	39.34	10928.136096
103101010431	103101010431007	MOMETASONE FUROATE	39.34	10928.136096
103101010431	103101010431008	MOMETASONE FUROATE	39.34	10928.136096
103101010431	103101010431009	MOMETASONE FUROATE	39.34	10928.136096
103101010431	103101010431010	MOMETASONE FUROATE	39.34	10928.136096
103101010431	103101010431011	MOMETASONE FUROATE	39.34	10928.136096
103101010431	103101010431012	MOMETASONE FUROATE	39.34	10928.136096
103371010331	103371010331001	ADVAIR DISKU	227.99	6405.174784
103101010431	103371010331002	ADVAIR DISKU	227.99	6405.174784
103371010431	103371010431001	ADVAIR DISKU	227.99	6405.174784
103371010431	103371010431002	ADVAIR DISKU	227.99	6405.174784
103371010431	103371010431003	ADVAIR DISKU	227.99	6405.174784
103371010431	103371010431004	ADVAIR DISKU	227.99	6405.174784
103371010431	103371010431005	ADVAIR DISKU	227.99	6405.174784
103371010431	103371010431006	ADVAIR DISKU	227.99	6405.174784
103371010431	103371010431007	ADVAIR DISKU	227.99	6405.174784
103371010451	103371010451001	LORATADINE-D	5.79	6405.174784
103371010451	103371010451002	LORATADINE-D	5.79	6405.174784
103371010451	103371010451003	LORATADINE-D	5.79	6405.174784
103371010451	103371010451004	LORATADINE-D	5.79	6405.174784
103371010451	103371010451005	LORATADINE-D	5.79	6405.174784
103371010541	103371010541001	ADVAIR DISKU	227.99	6405.174784
103371010541	103371010541002	ADVAIR DISKU	227.99	6405.174784
103371010541	103371010541003	ADVAIR DISKU	227.99	6405.174784
103371010541	103371010541004	ADVAIR DISKU	227.99	6405.174784
103371010561	103371010561001	LORATADINE-D	5.79	6405.174784
103371010561	103371010561002	LORATADINE-D	5.79	6405.174784
103371010561	103371010561003	LORATADINE-D	5.79	6405.174784
103371010561	103371010561004	LORATADINE-D	5.79	6405.174784
103581010631	103581010631001	QVAR	88.93	10035.253919
103581010661	103581010661001	Albuterol	60.49	10035.253919
103581010661	103581010661002	Albuterol	60.49	10035.253919
103581010811	103581010811001	PROAIR HFA	37.61	10035.253919
103701010231	103701010231001	SYMBICORT	211.05	14916.079260
103701010231	103701010231002	SYMBICORT	211.05	14916.079260
103701010231	103701010231003	SYMBICORT	211.05	14916.079260
103701010231	103701010231004	SYMBICORT	105.11	14916.079260
103701010231	103701010231005	SYMBICORT	211.05	14916.079260
103701010231	103701010231006	SYMBICORT	211.05	14916.079260
103851040102	103851040102001	PREDNISONE	2.64	14149.156705
103851040202	103851040202001	SYMBICORT	178.48	14149.156705
103851040202	103851040202002	SYMBICORT	178.48	14149.156705
103851040202	103851040202003	SYMBICORT	178.48	14149.156705
103851040202	103851040202004	SYMBICORT	178.48	14149.156705
103851040202	103851040202005	SYMBICORT	178.48	14149.156705
103861010251	103861010251001	ALLEGRA	62.73	7789.062469
103861010251	103861010251002	ALLEGRA	62.73	7789.062469
104011010251	104011010251001	Albuterol 90mcg (Ventolin) Aerosol	7.00	4351.198513
104011010421	104011010421001	PROVENTIL HFA	36.72	4351.198513
104011010421	104011010421002	PROVENTIL HFA	36.72	4351.198513
104011010541	104011010541001	PROVENTIL HFA	36.72	4351.198513
104011010541	104011010541002	PROVENTIL HFA	36.72	4351.198513
104251010371	104251010371001	Albuterol	19.00	36282.551033
104251010371	104251010371002	Albuterol	19.00	36282.551033
104251010381	104251010381001	ADVAIR DISKU	232.78	36282.551033

Return to Top

HC-144I. Sample SAS Job for Example B - Total Rx expenditures associated with asthma, analysis variable: RXXP11X SUM OF PAYMENTS RXSF11X-RXOU11X(IMPUTED)
N	Sum
10349	1397673.25

Return to Top

HC-144I. Sample SAS Job for Example B - Total Rx expenditures associated with asthma, weighted analysis variable: RXXP11X SUM OF PAYMENTS RXSF11X-RXOU11X(IMPUTED)
N	Sum
10349	14313079052

Return to Top

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

NOTE: SAS initialization used:
real time 1.93 seconds
cpu time 0.20 seconds

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

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

NOTE: AUTOEXEC processing completed.

1 ods rtf file = 'c:\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-144I";
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.01 seconds
cpu time 0.01 seconds

26
27 *-----------------------------------------------------------------------------------
28 * Get conditions records coded as asthma.
29 *-----------------------------------------------------------------------------------;
30 DATA ASCONDS;
31 SET IN.H146 (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 (H146) records where cccodex=128";
43 run;

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

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

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

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

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

NOTE: There were 50 observations read from the data set WORK.ASCLNKS.
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 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;

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

NOTE: There were 134311 observations read from the data set IN.H144G.
NOTE: The data set WORK.MVIS has 130464 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 9.59 seconds
cpu time 0.20 seconds

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

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

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

NOTE: There were 6998 observations read from the data set WORK.ASCLNKS.
NOTE: There were 130464 observations read from the data set WORK.MVIS.
NOTE: The data set WORK.ASMVIS has 1858 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-144G) events";
104 run;

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

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

110
111 PROC MEANS DATA=ASMVIS N SUM;
112 VAR OBXP11X;
113 WEIGHT PERWT11F;
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 1858 observations read from the data set WORK.ASMVIS.
NOTE: The PROCEDURE MEANS printed page 8.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

117
118 ods rtf close;
119
120

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

Return to Top

HC-144I. Sample SAS Job for Example C - sample print of work.asconds, sorted by condidx COND (H146) records where cccodex=128
Obs	CONDIDX	CCCODEX
1	100121010051	128
2	100171010021	128
3	100431010021	128
4	100431030011	128
5	100431040011	128
6	100441010031	128
7	100531020041	128
8	100531040011	128
9	100671010071	128
10	100671020041	128
11	100861020041	128
12	101171050011	128
13	101231030011	128
14	101311020041	128
15	101371010051	128
16	101671020011	128
17	101831050011	128
18	101841020091	128
19	101841030031	128
20	101841030061	128
21	101981020061	128
22	101981030051	128
23	101981040031	128
24	101981050011	128
25	102061010011	128
26	102061040011	128
27	102291020011	128
28	102331020021	128
29	102361030011	128
30	102361040011	128
31	102421010041	128
32	102442010032	128
33	102451010021	128
34	102451030011	128
35	102531020011	128
36	102781020031	128
37	102891010051	128
38	102891020021	128
39	102991050011	128
40	102991060011	128
41	103031010041	128
42	103051020011	128
43	103101010031	128
44	103151020011	128
45	103371010011	128
46	103581010041	128
47	103611020011	128
48	103691010021	128
49	103701010091	128
50	103851040011	128

Return to Top

HC-144I. Sample SAS Job for Example C - sample print of work.asclnks, sorted by condidx events linked to asthma condition records
CONDIDX	EVNTIDX	EVENTYPE
100121010051	100121010111	8 PMED
100121010051	100121010151	8 PMED
100121010051	100121010201	8 PMED
100121010051	100121010231	8 PMED
100171010021	100171010231	8 PMED
100171010021	100171010271	8 PMED
100431010021	100431010201	8 PMED
100431010021	100431010271	8 PMED
100431030011	100431030281	8 PMED
100431030011	100431030311	2 OPAT
100431030011	100431030321	1 MVIS
100431030011	100431030331	8 PMED
100431030011	100431030351	8 PMED
100431040011	100431040231	8 PMED
100431040011	100431040321	8 PMED
100431040011	100431040341	1 MVIS
100431040011	100431040361	2 OPAT
100431040011	100431040371	8 PMED
100441010031	100441010181	8 PMED
100441010031	100441010191	8 PMED
100441010031	100441010201	8 PMED
100441010031	100441010211	1 MVIS
100531020041	100531020361	8 PMED
100531020041	100531020511	8 PMED
100531020041	100531020521	8 PMED
100531020041	100531020531	8 PMED
100531040011	100531040021	8 PMED
100531040011	100531040031	1 MVIS
100531040011	100531040051	8 PMED
100531040011	100531040091	8 PMED
100671010071	100671010511	8 PMED
100671010071	100671010521	8 PMED
100671010071	100671010531	8 PMED
100671010071	100671010681	8 PMED
100671010071	100671010701	2 OPAT
100671010071	100671010811	8 PMED
100671010071	100671010821	8 PMED
100671010071	100671010831	8 PMED
100671020041	100671020291	1 MVIS
100671020041	100671020301	1 MVIS
100671020041	100671020311	1 MVIS
100671020041	100671020371	8 PMED
100671020041	100671020401	8 PMED
100671020041	100671020411	8 PMED
100671020041	100671020601	8 PMED
100671020041	100671020611	8 PMED
100861020041	100861020131	1 MVIS
100861020041	100861020141	8 PMED
100861020041	100861020151	8 PMED
100861020041	100861020181	8 PMED
100861020041	100861020221	1 MVIS
100861020041	100861020241	8 PMED
100861020041	100861020291	8 PMED
100861020041	100861020371	1 MVIS
100861020041	100861020391	8 PMED
100861020041	100861020411	8 PMED
100861020041	100861020451	8 PMED
100861020041	100861020461	8 PMED
100861020041	100861020511	1 MVIS
100861020041	100861020521	1 MVIS
101231030011	101231030121	8 PMED
101371010051	101371010481	8 PMED
101671020011	101671020201	1 MVIS
101671020011	101671020211	8 PMED
101831050011	101831050031	8 PMED
101841020091	101841020381	8 PMED
101841020091	101841020411	2 OPAT
101841020091	101841020421	2 OPAT
101841020091	101841020521	8 PMED
101841020091	101841020551	8 PMED
101841020091	101841020691	8 PMED
101841020091	101841020721	8 PMED
101841020091	101841020731	8 PMED
101841020091	101841020761	8 PMED
101841020091	101841020791	2 OPAT

Return to Top

HC-144I. Sample SAS Job for Example C - sample print of work.asclnks, sorted by evntidx
Obs	CONDIDX	EVNTIDX	EVENTYPE
1	100121010051	100121010111	8 PMED
2	100121010051	100121010151	8 PMED
3	100121010051	100121010201	8 PMED
4	100121010051	100121010231	8 PMED
5	100171010021	100171010231	8 PMED
6	100171010021	100171010271	8 PMED
7	100431010021	100431010201	8 PMED
8	100431010021	100431010271	8 PMED
9	100431030011	100431030281	8 PMED
10	100431030011	100431030311	2 OPAT
11	100431030011	100431030321	1 MVIS
12	100431030011	100431030331	8 PMED
13	100431030011	100431030351	8 PMED
14	100431040011	100431040231	8 PMED
15	100431040011	100431040321	8 PMED
16	100431040011	100431040341	1 MVIS
17	100431040011	100431040361	2 OPAT
18	100431040011	100431040371	8 PMED
19	100441010031	100441010181	8 PMED
20	100441010031	100441010191	8 PMED
21	100441010031	100441010201	8 PMED
22	100441010031	100441010211	1 MVIS
23	100531020041	100531020361	8 PMED
24	100531020041	100531020511	8 PMED
25	100531020041	100531020521	8 PMED
26	100531020041	100531020531	8 PMED
27	100531040011	100531040021	8 PMED
28	100531040011	100531040031	1 MVIS
29	100531040011	100531040051	8 PMED
30	100531040011	100531040091	8 PMED
31	100671010071	100671010511	8 PMED
32	100671010071	100671010521	8 PMED
33	100671010071	100671010531	8 PMED
34	100671010071	100671010681	8 PMED
35	100671010071	100671010701	2 OPAT
36	100671010071	100671010811	8 PMED
37	100671010071	100671010821	8 PMED
38	100671010071	100671010831	8 PMED
39	100671020041	100671020291	1 MVIS
40	100671020041	100671020301	1 MVIS
41	100671020041	100671020311	1 MVIS
42	100671020041	100671020371	8 PMED
43	100671020041	100671020401	8 PMED
44	100671020041	100671020411	8 PMED
45	100671020041	100671020601	8 PMED
46	100671020041	100671020611	8 PMED
47	100861020041	100861020131	1 MVIS
48	100861020041	100861020141	8 PMED
49	100861020041	100861020151	8 PMED
50	100861020041	100861020181	8 PMED

Return to Top

HC-144I. Sample SAS Job for Example C - sample print of unique evntidxs from work.asclnks
Obs	EVNTIDX	EVENTYPE
1	100121010111	8 PMED
2	100121010151	8 PMED
3	100121010201	8 PMED
4	100121010231	8 PMED
5	100171010231	8 PMED
6	100171010271	8 PMED
7	100431010201	8 PMED
8	100431010271	8 PMED
9	100431030281	8 PMED
10	100431030311	2 OPAT
11	100431030321	1 MVIS
12	100431030331	8 PMED
13	100431030351	8 PMED
14	100431040231	8 PMED
15	100431040321	8 PMED
16	100431040341	1 MVIS
17	100431040361	2 OPAT
18	100431040371	8 PMED
19	100441010181	8 PMED
20	100441010191	8 PMED
21	100441010201	8 PMED
22	100441010211	1 MVIS
23	100531020361	8 PMED
24	100531020511	8 PMED
25	100531020521	8 PMED
26	100531020531	8 PMED
27	100531040021	8 PMED
28	100531040031	1 MVIS
29	100531040051	8 PMED
30	100531040091	8 PMED
31	100671010511	8 PMED
32	100671010521	8 PMED
33	100671010531	8 PMED
34	100671010681	8 PMED
35	100671010701	2 OPAT
36	100671010811	8 PMED
37	100671010821	8 PMED
38	100671010831	8 PMED
39	100671020291	1 MVIS
40	100671020301	1 MVIS
41	100671020311	1 MVIS
42	100671020371	8 PMED
43	100671020401	8 PMED
44	100671020411	8 PMED
45	100671020601	8 PMED
46	100671020611	8 PMED
47	100861020131	1 MVIS
48	100861020141	8 PMED
49	100861020151	8 PMED
50	100861020181	8 PMED

Return to Top

HC-144I. Sample SAS Job for Example C - sample print of work.asmvis unique evntidxs from work.asclnks that are non-telephone MVIS (HC-144G) events
Obs	EVNTIDX	EVENTYPE	SEETLKPV	OBXP11X	PERWT11F
1	100431030321	1 MVIS	1	105.76	15760.52
2	100431040341	1 MVIS	1	105.76	24198.07
3	100441010211	1 MVIS	1	110.00	2346.18
4	100531040031	1 MVIS	1	101.50	3003.83
5	100671020291	1 MVIS	1	308.00	22181.89
6	100671020301	1 MVIS	1	0.00	22181.89
7	100671020311	1 MVIS	1	0.00	22181.89
8	100861020131	1 MVIS	1	70.00	5684.04
9	100861020221	1 MVIS	1	52.00	5684.04
10	100861020371	1 MVIS	1	17.55	5684.04
11	100861020511	1 MVIS	1	17.55	5684.04
12	100861020521	1 MVIS	1	149.52	5684.04
13	101671020201	1 MVIS	1	367.12	18399.52
14	101841030191	1 MVIS	1	0.00	3531.74
15	102361030121	1 MVIS	1	151.91	16688.72
16	102442010182	1 MVIS	1	50.00	9663.84
17	102451010121	1 MVIS	1	65.00	16986.30
18	103581010591	1 MVIS	1	168.76	10035.25
19	104011010381	1 MVIS	1	80.93	4351.20
20	104601040181	1 MVIS	1	202.55	10121.91
21	104601050361	1 MVIS	1	111.33	12853.00
22	104601050371	1 MVIS	1	111.33	12853.00
23	104601050381	1 MVIS	1	74.22	12853.00
24	104801010201	1 MVIS	1	134.73	4027.47
25	104801010211	1 MVIS	1	134.73	4027.47
26	104801010221	1 MVIS	1	134.73	4027.47
27	104801010321	1 MVIS	1	117.51	4027.47
28	104841010461	1 MVIS	1	423.00	20342.98
29	104841010471	1 MVIS	1	0.00	20342.98
30	105241020971	1 MVIS	1	105.22	10112.15
31	105241020981	1 MVIS	1	339.92	10112.15
32	105241020991	1 MVIS	1	105.22	10112.15
33	105241021001	1 MVIS	1	0.00	10112.15
34	105241021011	1 MVIS	1	3670.80	10112.15
35	105241021201	1 MVIS	1	105.22	10112.15
36	105241040441	1 MVIS	1	25.00	10083.91
37	105721010861	1 MVIS	1	89.80	17196.20
38	105721010871	1 MVIS	1	89.80	17196.20
39	105721010881	1 MVIS	1	89.80	17196.20
40	106121010081	1 MVIS	1	102.45	2293.70
41	106181070081	1 MVIS	1	80.01	5811.61
42	106771030011	1 MVIS	1	8.80	9013.37
43	106951010031	1 MVIS	1	99.00	21524.42
44	107031040021	1 MVIS	1	121.49	7348.41
45	107031040061	1 MVIS	1	121.49	7348.41
46	107251040112	1 MVIS	1	60.42	12885.00
47	108351020521	1 MVIS	1	75.97	22246.49
48	108411010251	1 MVIS	1	2405.15	3190.04
49	108851010011	1 MVIS	1	157.25	3906.54
50	109001050131	1 MVIS	1	122.84	23352.22

Return to Top

HC-144I. Sample SAS Job for Example C - Total medical visit expenditures (excluding telephone) associated with asthma analysis variable: OBXP11X SUM OF OBSF11X - OBOT11X (IMPUTED)
N	Sum
1858	281565.16

Return to Top

HC-144I. Sample SAS Job for Example C - Total medical visit expenditures (excluding telephone) associated with asthma, weighted analysis variable: OBXP11X SUM OF OBSXF11X - OBOT11X (IMPUTED)
N	Sum
1858	2996204062

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

MEPS HC-144I: Attachment 2

Sample SAS Jobs for Linking Example

Connect With Us

Sign up for Email Updates

Agency for Healthcare Research and Quality