The SAS System 08:55 Friday, June 8, 2001
NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 6.12 TS025
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC, Site 0026405003.
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-016I";
4 TITLE2 'Sample SAS Job for Example A';
5
6 LIBNAME IN 'D:\';
NOTE: Libref IN was successfully assigned as follows:
Engine: V603
Physical Name: D:\
7
8 ************************************************************************************************
9 * Calculate the expenditures for prescribed medicines associated with medical visits for asthma.
10 ************************************************************************************************;
11
12 PROC FORMAT;
13 VALUE EVENTYPE
14 1 = "1 MVIS"
15 2 = "2 OPAT"
16 3 = "3 EROM"
17 4 = "4 STAZ"
18 5 = "5 DVIS"
19 6 = "6 OMED"
20 7 = "7 HVIS"
21 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
22
23 RUN;
NOTE: The PROCEDURE FORMAT used 0.22 seconds.
24
25 *-------------------------------------------------------------------------------------
26 * Get condition records coded as asthma.
27 *-------------------------------------------------------------------------------------;
28 DATA ASCONDS;
29 SET IN.H18 (KEEP=CONDIDX CCCODEX);
30 IF CCCODEX="128";
31
32 RUN;
NOTE: The data set WORK.ASCONDS has 1763 observations and 2 variables.
NOTE: The DATA statement used 11.85 seconds.
33
34 *------------------------------------------------------------------------------------
35 * Get the events linked to each of the asthma condition records.
36 *------------------------------------------------------------------------------------;
37 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
2 The SAS System 08:55 Friday, June 8, 2001
NOTE: The data set WORK.ASCONDS has 1763 observations and 2 variables.
NOTE: The PROCEDURE SORT used 0.22 seconds.
38
39 proc print data=asconds (obs=50);
40 title3 "sample print of work.asconds - sorted by condidx";
41 title4 "COND (H18) records where cccodex=128";
42 run;
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: The PROCEDURE PRINT used 0.22 seconds.
43
44 PROC SORT DATA=IN.H16IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: The data set WORK.CLNK has 310651 observations and 5 variables.
NOTE: The PROCEDURE SORT used 19.12 seconds.
45
46 DATA ASCLNKS;
47 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
48 ASCONDS(IN=INASCOND KEEP=CONDIDX);
49 BY CONDIDX;
50 IF INCLNK & INASCOND;
51 RUN;
NOTE: The data set WORK.ASCLNKS has 6789 observations and 3 variables.
NOTE: The DATA statement used 4.55 seconds.
52
53 proc print data=asclnks (obs=75);
54 by condidx;
55 id condidx;
56 format eventype eventype.;
57 title3 "sample print of work.asclnks - sorted by condidx";
58 title4 "events linked to asthma condition records";
59 run;
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: The PROCEDURE PRINT used 0.22 seconds.
60
61 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: The data set WORK.ASCLNKS has 6789 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.16 seconds.
62
63 proc print data=asclnks (obs=50);
64 format eventype eventype.;
65 title3 "sample print of work.asclnks - sorted by evntidx";
3 The SAS System 08:55 Friday, June 8, 2001
66 run;
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
67
68 DATA ASCLNKS;
69 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
70 BY EVNTIDX;
71 IF FIRST.EVNTIDX;
72 RUN;
NOTE: The data set WORK.ASCLNKS has 6751 observations and 2 variables.
NOTE: The DATA statement used 0.17 seconds.
73
74 proc print data=asclnks (obs=50);
75 title3 "sample print of unique evntidxs from work.asclnks";
76 format eventype eventype.;
77 run;
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
78
79 *--------------------------------------------------------------------------------------------
80 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
81 *--------------------------------------------------------------------------------------------;
82 DATA MVIS;
83 SET IN.HC16GF1 (KEEP=EVNTIDX WTDPER97 SEETLKPV);
84 IF WTDPER97 > 0 & SEETLKPV NE 2;
85 RUN;
NOTE: The data set WORK.MVIS has 142119 observations and 3 variables.
NOTE: The DATA statement used 15.69 seconds.
86
87 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: The data set WORK.MVIS has 142119 observations and 3 variables.
NOTE: The PROCEDURE SORT used 3.79 seconds.
88
89 *---------------------------------------------------------------------------------------------
90 * Identify MVIS events which were for asthma.
91 *---------------------------------------------------------------------------------------------;
92 DATA ASMVIS;
93 MERGE ASCLNKS (IN=INASCLNK)
94 MVIS (IN=INMVIS KEEP=EVNTIDX);
95 BY EVNTIDX;
96 IF INASCLNK & INMVIS;
97 RUN;
4 The SAS System 08:55 Friday, June 8, 2001
NOTE: The data set WORK.ASMVIS has 2245 observations and 2 variables.
NOTE: The DATA statement used 0.82 seconds.
98
99 proc print data=asmvis (obs=50);
100 format eventype eventype.;
101 title3 "sample print of work.asmvis";
102 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-016G) events";
103 run;
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: The PROCEDURE PRINT used 0.16 seconds.
104
105 *-------------------------------------------------------------------------------------
106 * Get PMED IDs linked to the MVIS events which were for asthma.
107 *-------------------------------------------------------------------------------------;
108 PROC SORT DATA=IN.H16IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: The data set WORK.RXLK has 60020 observations and 5 variables.
NOTE: The PROCEDURE SORT used 2.97 seconds.
109
110 proc print data=rxlk (obs=140);
111 by evntidx;
112 id evntidx;
113 var linkidx eventype;
114 format eventype eventype.;
115 title3 "sample print of work.rxlk - sorted by eventidx";
116 title4 "Rx+event link file records (HC-16IF2)";
117 run;
NOTE: The PROCEDURE PRINT printed pages 7-11.
NOTE: The PROCEDURE PRINT used 0.16 seconds.
118
119 DATA PMEDIDS;
120 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
121 ASMVIS(IN=INASMVIS KEEP=EVNTIDX);
122 BY EVNTIDX;
123 IF INRXLK & INASMVIS;
124 RUN;
NOTE: The data set WORK.PMEDIDS has 1683 observations and 3 variables.
NOTE: The DATA statement used 0.39 seconds.
125
126 proc print data=pmedids (obs=50);
127 by evntidx;
128 id evntidx;
129 format eventype eventype.;
5 The SAS System 08:55 Friday, June 8, 2001
130 title3 "sample print of work.pmedids - sorted by evntidx";
131 title4 "work.rxlk records for evntidxs in work.asmvis";
132 run;
NOTE: The PROCEDURE PRINT printed pages 12-13.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
133
134 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: The data set WORK.PMEDIDS has 1683 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.0 seconds.
135
136 proc print data=pmedids (obs=50);
137 format eventype eventype.;
138 title3 "sample print of work.pmedids - sorted by linkidx";
139 run;
NOTE: The PROCEDURE PRINT printed page 14.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
140
141 DATA PMEDIDS;
142 SET PMEDIDS (KEEP=LINKIDX);
143 BY LINKIDX;
144 IF FIRST.LINKIDX;
145 RUN;
NOTE: The data set WORK.PMEDIDS has 1584 observations and 1 variables.
NOTE: The DATA statement used 0.05 seconds.
146
147 proc print data=pmedids (obs=50);
148 title3 "sample print of unique linkidxs in work.pmedids";
149 run;
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
150
151 *-----------------------------------------------------------------------------------------
152 * Get PMED records linked to MVIS events which were for asthma.
153 *-----------------------------------------------------------------------------------------;
154 PROC SORT DATA=IN.H16A OUT=PMED; BY LINKIDX; RUN;
NOTE: The data set WORK.PMED has 234532 observations and 54 variables.
NOTE: The PROCEDURE SORT used 1 minute 36.34 seconds.
155
156 DATA MVPMEDS;
6 The SAS System 08:55 Friday, June 8, 2001
157 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP97X WTDPER97 RXNAME)
158 PMEDIDS (IN=A);
159 BY LINKIDX;
160 IF A;
161 RUN;
NOTE: The data set WORK.MVPMEDS has 3611 observations and 5 variables.
NOTE: The DATA statement used 25.71 seconds.
162
163 proc print data=mvpmeds (obs=200);
164 var rxrecidx rxname RXXP97X WTDPER97;
165 by linkidx;
166 id linkidx;
167 title3 "sample print of work.mvpmeds";
168 title4 "PMED (HC-016A) records for unique linkidxs in work.pmedids";
169 run;
NOTE: The PROCEDURE PRINT printed pages 16-21.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
170
171 PROC MEANS DATA=MVPMEDS N SUM;
172 VAR RXXP97X;
173 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
174 RUN;
NOTE: The PROCEDURE MEANS printed page 22.
NOTE: The PROCEDURE MEANS used 0.27 seconds.
175
176 PROC MEANS DATA=MVPMEDS N SUM;
177 VAR RXXP97X;
178 WEIGHT WTDPER97;
179 TITLE3 "Total Rx expenditures associated with medical visits (excluding telephone) for asthma";
180 TITLE5 "Weighted";
181 RUN;
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
182
183
184
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-016I 08:55 Friday, June 8, 2001 1
Sample SAS Job for Example A
sample print of work.asconds - sorted by condidx
COND (H18) records where cccodex=128
OBS CONDIDX CCCODEX
1 000040320014 128
2 000050480022 128
3 000050480038 128
4 000200350110 128
5 000650110054 128
6 000670240039 128
7 000850580014 128
8 000980120017 128
9 001170160082 128
10 001660130011 128
11 001660370019 128
12 001660440018 128
13 001830490013 128
14 001860600013 128
15 001900110024 128
16 002360270026 128
17 002400120025 128
18 002550290027 128
19 003050120030 128
20 003210280044 128
21 003210280135 128
22 003320230104 128
23 003370680016 128
24 003430100019 128
25 003470170019 128
26 003540170016 128
27 003620170023 128
28 003620310015 128
29 003660480029 128
30 003770240045 128
31 004060270035 128
32 004060340103 128
33 004160280015 128
34 004170230124 128
35 004370110021 128
36 004500450016 128
37 004630460039 128
38 004670210023 128
39 004840520061 128
40 005030330030 128
41 005060320036 128
42 005070320015 128
43 005260160028 128
44 005300270020 128
45 005670410030 128
46 005690210026 128
47 005710290049 128
48 005720150043 128
49 005720150093 128
50 005720390063 128
HC-016I 08:55 Friday, June 8, 2001 2
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
000050480022 000050480059 1 MVIS
000050480066 1 MVIS
000050480073 8 PMED
000050480038 000050480080 8 PMED
000050480097 8 PMED
000200350110 000200350300 1 MVIS
000200350317 1 MVIS
000200350444 8 PMED
000200350475 8 PMED
000200350502 8 PMED
000200350519 8 PMED
000650110054 000650110735 8 PMED
000650110766 1 MVIS
000650110855 4 STAZ
000650110906 8 PMED
000670240039 000670240239 1 MVIS
000670240246 1 MVIS
000670240253 8 PMED
000670240260 8 PMED
000670240277 8 PMED
000670240284 8 PMED
000980120017 000980120070 8 PMED
000980120094 1 MVIS
000980120107 8 PMED
000980120114 8 PMED
001660440018 001660440028 1 MVIS
001660440100 8 PMED
001860600013 001860600064 1 MVIS
001860600071 8 PMED
001860600095 8 PMED
001860600108 8 PMED
001860600122 1 MVIS
001860600146 8 PMED
001860600160 8 PMED
001860600191 8 PMED
001860600211 8 PMED
001860600228 8 PMED
002360270026 002360270229 1 MVIS
002360270236 1 MVIS
002360270243 1 MVIS
002360270250 1 MVIS
HC-016I 08:55 Friday, June 8, 2001 3
Sample SAS Job for Example A
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
002360270026 002360270274 8 PMED
002360270298 8 PMED
002360270318 8 PMED
002360270349 8 PMED
002360270356 8 PMED
002360270387 8 PMED
002360270445 8 PMED
002550290027 002550290309 8 PMED
002550290316 8 PMED
002550290323 1 MVIS
002550290330 8 PMED
003050120030 003050120408 8 PMED
003050120460 1 MVIS
003050120477 1 MVIS
003050120559 8 PMED
003050120580 8 PMED
003050120597 8 PMED
003050120600 8 PMED
003050120617 8 PMED
003320230104 003320230183 8 PMED
003540170016 003540170255 8 PMED
003540170522 8 PMED
003540170604 8 PMED
003540170611 8 PMED
003540170628 8 PMED
003620310015 003620310090 1 MVIS
003620310127 8 PMED
003620310141 1 MVIS
003620310172 8 PMED
003620310216 1 MVIS
003620310223 8 PMED
003660480029 003660480132 1 MVIS
003660480149 1 MVIS
003660480156 8 PMED
HC-016I 08:55 Friday, June 8, 2001 4
Sample SAS Job for Example A
sample print of work.asclnks - sorted by evntidx
OBS CONDIDX EVNTIDX EVENTYPE
1 000050480022 000050480059 1 MVIS
2 000050480022 000050480066 1 MVIS
3 000050480022 000050480073 8 PMED
4 000050480038 000050480080 8 PMED
5 000050480038 000050480097 8 PMED
6 000200350110 000200350300 1 MVIS
7 000200350110 000200350317 1 MVIS
8 000200350110 000200350444 8 PMED
9 000200350110 000200350475 8 PMED
10 000200350110 000200350502 8 PMED
11 000200350110 000200350519 8 PMED
12 000650110054 000650110735 8 PMED
13 000650110054 000650110766 1 MVIS
14 000650110054 000650110855 4 STAZ
15 000650110054 000650110906 8 PMED
16 000670240039 000670240239 1 MVIS
17 000670240039 000670240246 1 MVIS
18 000670240039 000670240253 8 PMED
19 000670240039 000670240260 8 PMED
20 000670240039 000670240277 8 PMED
21 000670240039 000670240284 8 PMED
22 000980120017 000980120070 8 PMED
23 000980120017 000980120094 1 MVIS
24 000980120017 000980120107 8 PMED
25 000980120017 000980120114 8 PMED
26 001660440018 001660440028 1 MVIS
27 001660440018 001660440100 8 PMED
28 001860600013 001860600064 1 MVIS
29 001860600013 001860600071 8 PMED
30 001860600013 001860600095 8 PMED
31 001860600013 001860600108 8 PMED
32 001860600013 001860600122 1 MVIS
33 001860600013 001860600146 8 PMED
34 001860600013 001860600160 8 PMED
35 001860600013 001860600191 8 PMED
36 001860600013 001860600211 8 PMED
37 001860600013 001860600228 8 PMED
38 002360270026 002360270229 1 MVIS
39 002360270026 002360270236 1 MVIS
40 002360270026 002360270243 1 MVIS
41 002360270026 002360270250 1 MVIS
42 002360270026 002360270274 8 PMED
43 002360270026 002360270298 8 PMED
44 002360270026 002360270318 8 PMED
45 002360270026 002360270349 8 PMED
46 002360270026 002360270356 8 PMED
47 002360270026 002360270387 8 PMED
48 002360270026 002360270445 8 PMED
49 002550290027 002550290309 8 PMED
50 002550290027 002550290316 8 PMED
HC-016I 08:55 Friday, June 8, 2001 5
Sample SAS Job for Example A
sample print of unique evntidxs from work.asclnks
OBS EVNTIDX EVENTYPE
1 000050480059 1 MVIS
2 000050480066 1 MVIS
3 000050480073 8 PMED
4 000050480080 8 PMED
5 000050480097 8 PMED
6 000200350300 1 MVIS
7 000200350317 1 MVIS
8 000200350444 8 PMED
9 000200350475 8 PMED
10 000200350502 8 PMED
11 000200350519 8 PMED
12 000650110735 8 PMED
13 000650110766 1 MVIS
14 000650110855 4 STAZ
15 000650110906 8 PMED
16 000670240239 1 MVIS
17 000670240246 1 MVIS
18 000670240253 8 PMED
19 000670240260 8 PMED
20 000670240277 8 PMED
21 000670240284 8 PMED
22 000980120070 8 PMED
23 000980120094 1 MVIS
24 000980120107 8 PMED
25 000980120114 8 PMED
26 001660440028 1 MVIS
27 001660440100 8 PMED
28 001860600064 1 MVIS
29 001860600071 8 PMED
30 001860600095 8 PMED
31 001860600108 8 PMED
32 001860600122 1 MVIS
33 001860600146 8 PMED
34 001860600160 8 PMED
35 001860600191 8 PMED
36 001860600211 8 PMED
37 001860600228 8 PMED
38 002360270229 1 MVIS
39 002360270236 1 MVIS
40 002360270243 1 MVIS
41 002360270250 1 MVIS
42 002360270274 8 PMED
43 002360270298 8 PMED
44 002360270318 8 PMED
45 002360270349 8 PMED
46 002360270356 8 PMED
47 002360270387 8 PMED
48 002360270445 8 PMED
49 002550290309 8 PMED
50 002550290316 8 PMED
HC-016I 08:55 Friday, June 8, 2001 6
Sample SAS Job for Example A
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-016G) events
OBS EVNTIDX EVENTYPE
1 000050480059 1 MVIS
2 000050480066 1 MVIS
3 000200350300 1 MVIS
4 000200350317 1 MVIS
5 000650110766 1 MVIS
6 000670240239 1 MVIS
7 000670240246 1 MVIS
8 000980120094 1 MVIS
9 001660440028 1 MVIS
10 001860600064 1 MVIS
11 001860600122 1 MVIS
12 002360270229 1 MVIS
13 002360270236 1 MVIS
14 002360270243 1 MVIS
15 002360270250 1 MVIS
16 002550290323 1 MVIS
17 003050120460 1 MVIS
18 003050120477 1 MVIS
19 003620310090 1 MVIS
20 003620310141 1 MVIS
21 003620310216 1 MVIS
22 003660480132 1 MVIS
23 003660480149 1 MVIS
24 004060270664 1 MVIS
25 004170230312 1 MVIS
26 004500450049 1 MVIS
27 004500450056 1 MVIS
28 004630460176 1 MVIS
29 004630460183 1 MVIS
30 004630460190 1 MVIS
31 004670210063 1 MVIS
32 004670210070 1 MVIS
33 004670210087 1 MVIS
34 004840520243 1 MVIS
35 004840520250 1 MVIS
36 004840520274 1 MVIS
37 004840520281 1 MVIS
38 004840520298 1 MVIS
39 004840520301 1 MVIS
40 004840520318 1 MVIS
41 004840520325 1 MVIS
42 006760120156 1 MVIS
43 006960390514 1 MVIS
44 006960390538 1 MVIS
45 007030280762 1 MVIS
46 007030281063 1 MVIS
47 007030281070 1 MVIS
48 007030281183 1 MVIS
49 007210140434 1 MVIS
50 007210140441 1 MVIS
HC-016I 08:55 Friday, June 8, 2001 7
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-16IF2)
EVNTIDX LINKIDX EVENTYPE
000020250058 000020250065 1 MVIS
000020320065 000020320072 1 MVIS
000020320109 000020320116 1 MVIS
000020490161 000020490178 1 MVIS
000030220550 000030220567 4 STAZ
000030220574 4 STAZ
000030220581 4 STAZ
000030220598 4 STAZ
000040550013 000040550020 2 OPAT
000050110120 000050110151 1 MVIS
000050110226 000050110257 1 MVIS
000050170333 000050170460 3 EROM
000050170477 3 EROM
000050170408 000050170484 1 MVIS
000050170580 000050170768 1 MVIS
000050170597 000050170775 1 MVIS
000050170782 1 MVIS
000050170648 000050170768 2 OPAT
000050170655 000050170768 2 OPAT
000050170693 000050170799 1 MVIS
000050170720 000050170802 1 MVIS
000050170819 1 MVIS
000050170737 000050170826 1 MVIS
000050170833 1 MVIS
000050170744 000050170840 1 MVIS
000050170857 1 MVIS
000050170751 000050170864 3 EROM
000050171069 000050171103 1 MVIS
000050171110 1 MVIS
000050171127 1 MVIS
HC-016I 08:55 Friday, June 8, 2001 8
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-16IF2)
EVNTIDX LINKIDX EVENTYPE
000050240100 000050240148 3 EROM
000050240155 000050240179 1 MVIS
000050240162 000050240186 5 DVIS
000050240193 000050240213 1 MVIS
000050240220 1 MVIS
000050240206 000050240237 1 MVIS
000050310042 000050310059 1 MVIS
000050310066 000050310148 1 MVIS
000050310131 000050310148 2 OPAT
000050310155 2 OPAT
000050310162 2 OPAT
000050480011 000050480028 1 MVIS
000050480035 1 MVIS
000050480059 000050480073 1 MVIS
000050480066 000050480080 1 MVIS
000050480097 1 MVIS
000060180163 000060180290 4 STAZ
000060180303 4 STAZ
000060180310 4 STAZ
000060180327 4 STAZ
000060180334 4 STAZ
000060180170 000060180303 4 STAZ
000060180310 4 STAZ
000060180327 4 STAZ
000060180334 4 STAZ
000060180252 000060180269 6 OMED
000060180276 000060180283 6 OMED
000060180341 000060180512 1 MVIS
000060180529 1 MVIS
000060180536 1 MVIS
000060180492 000060180505 6 OMED
000070240264 000070240315 1 MVIS
HC-016I 08:55 Friday, June 8, 2001 9
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-16IF2)
EVNTIDX LINKIDX EVENTYPE
000070240264 000070240322 1 MVIS
000070240339 1 MVIS
000070240346 1 MVIS
000070240353 1 MVIS
000070240360 1 MVIS
000100150357 000100150395 5 DVIS
000100150408 5 DVIS
000100150422 000100150460 1 MVIS
000100150439 000100150477 1 MVIS
000100150484 1 MVIS
000100150446 000100150477 1 MVIS
000100150484 1 MVIS
000100150491 1 MVIS
000100150511 000100150528 6 OMED
000100220213 000100220244 1 MVIS
000100220251 1 MVIS
000100220268 1 MVIS
000100220275 1 MVIS
000100220299 000100220319 1 MVIS
000100220326 1 MVIS
000100220333 1 MVIS
000100220340 1 MVIS
000100220357 1 MVIS
000100220364 1 MVIS
000100220302 000100220326 1 MVIS
000100220340 1 MVIS
000100220364 1 MVIS
000110110093 000110110120 1 MVIS
000110110137 000110110315 1 MVIS
000110110271 000110110322 1 MVIS
000110110295 000110110322 2 OPAT
000110120129 000110120218 1 MVIS
000110290174 000110290181 5 DVIS
000120190069 000120190083 3 EROM
HC-016I 08:55 Friday, June 8, 2001 10
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-16IF2)
EVNTIDX LINKIDX EVENTYPE
000120190069 000120190090 3 EROM
000120260045 000120260052 4 STAZ
000120260069 4 STAZ
000120260076 4 STAZ
000130190362 000130190468 1 MVIS
000130190475 000130190468 1 MVIS
000130190622 000130190677 1 MVIS
000130190684 1 MVIS
000150220386 000150220502 3 EROM
000150220519 3 EROM
000180730041 000180730089 2 OPAT
000200110211 000200110204 1 MVIS
000200280184 000200280191 3 EROM
000200280204 3 EROM
000200350160 000200350386 5 DVIS
000200350184 000200350393 1 MVIS
000200350204 000200350413 1 MVIS
000200350211 000200350420 3 EROM
000200350242 000200350437 1 MVIS
000200350300 000200350444 1 MVIS
000200350475 1 MVIS
000200350348 000200350482 1 MVIS
000200350355 000200350499 1 MVIS
000200350406 000200350413 1 MVIS
000200350526 000200350595 1 MVIS
000200350557 000200350608 1 MVIS
000230160229 000230160243 1 MVIS
000230160250 1 MVIS
HC-016I 08:55 Friday, June 8, 2001 11
Sample SAS Job for Example A
sample print of work.rxlk - sorted by eventidx
Rx+event link file records (HC-16IF2)
EVNTIDX LINKIDX EVENTYPE
000230230072 000230230089 1 MVIS
000240120016 000240120136 1 MVIS
000240120143 1 MVIS
000240120150 1 MVIS
000240120167 1 MVIS
000240120174 1 MVIS
000240120181 1 MVIS
000240120085 000240120198 1 MVIS
000240120105 000240120198 1 MVIS
000240120129 000240120136 4 STAZ
000240120143 4 STAZ
000240130104 000240130111 6 OMED
000240370015 000240370022 1 MVIS
000240370039 1 MVIS
000310100133 000310100157 3 EROM
000310100164 000310100171 1 MVIS
HC-016I 08:55 Friday, June 8, 2001 12
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
000050480059 000050480073 1 MVIS
000050480066 000050480080 1 MVIS
000050480097 1 MVIS
000200350300 000200350444 1 MVIS
000200350475 1 MVIS
000650110766 000650110906 1 MVIS
000670240239 000670240253 1 MVIS
000670240260 1 MVIS
000670240277 1 MVIS
000670240284 1 MVIS
000980120094 000980120107 1 MVIS
001660440028 001660440100 1 MVIS
001660440117 1 MVIS
001860600064 001860600071 1 MVIS
001860600088 1 MVIS
001860600095 1 MVIS
001860600108 1 MVIS
001860600115 1 MVIS
001860600122 001860600146 1 MVIS
001860600153 1 MVIS
001860600160 1 MVIS
001860600177 1 MVIS
001860600184 1 MVIS
002360270229 002360270274 1 MVIS
002360270281 1 MVIS
002550290323 002550290330 1 MVIS
003050120477 003050120559 1 MVIS
003050120566 1 MVIS
003050120573 1 MVIS
003050120580 1 MVIS
003620310141 003620310172 1 MVIS
003660480132 003660480156 1 MVIS
003660480163 1 MVIS
003660480149 003660480170 1 MVIS
HC-016I 08:55 Friday, June 8, 2001 13
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
004060270664 004060270671 1 MVIS
004060270688 1 MVIS
004060270695 1 MVIS
004060270708 1 MVIS
004170230312 004170230343 1 MVIS
004500450049 004500450032 1 MVIS
004500450056 004500450032 1 MVIS
004670210063 004670210094 1 MVIS
004840520243 004840520349 1 MVIS
006760120156 006760120187 1 MVIS
006760120194 1 MVIS
006960390514 006960390576 1 MVIS
007030280762 007030280899 1 MVIS
007030280902 1 MVIS
007030280919 1 MVIS
007030280926 1 MVIS
HC-016I 08:55 Friday, June 8, 2001 14
Sample SAS Job for Example A
sample print of work.pmedids - sorted by linkidx
OBS EVNTIDX LINKIDX EVENTYPE
1 000050480059 000050480073 1 MVIS
2 000050480066 000050480080 1 MVIS
3 000050480066 000050480097 1 MVIS
4 000200350300 000200350444 1 MVIS
5 000200350300 000200350475 1 MVIS
6 000650110766 000650110906 1 MVIS
7 000670240239 000670240253 1 MVIS
8 000670240239 000670240260 1 MVIS
9 000670240239 000670240277 1 MVIS
10 000670240239 000670240284 1 MVIS
11 000980120094 000980120107 1 MVIS
12 001660440028 001660440100 1 MVIS
13 001660440028 001660440117 1 MVIS
14 001860600064 001860600071 1 MVIS
15 001860600064 001860600088 1 MVIS
16 001860600064 001860600095 1 MVIS
17 001860600064 001860600108 1 MVIS
18 001860600064 001860600115 1 MVIS
19 001860600122 001860600146 1 MVIS
20 001860600122 001860600153 1 MVIS
21 001860600122 001860600160 1 MVIS
22 001860600122 001860600177 1 MVIS
23 001860600122 001860600184 1 MVIS
24 002360270229 002360270274 1 MVIS
25 002360270229 002360270281 1 MVIS
26 002550290323 002550290330 1 MVIS
27 003050120477 003050120559 1 MVIS
28 003050120477 003050120566 1 MVIS
29 003050120477 003050120573 1 MVIS
30 003050120477 003050120580 1 MVIS
31 003620310141 003620310172 1 MVIS
32 003660480132 003660480156 1 MVIS
33 003660480132 003660480163 1 MVIS
34 003660480149 003660480170 1 MVIS
35 004060270664 004060270671 1 MVIS
36 004060270664 004060270688 1 MVIS
37 004060270664 004060270695 1 MVIS
38 004060270664 004060270708 1 MVIS
39 004170230312 004170230343 1 MVIS
40 004500450049 004500450032 1 MVIS
41 004500450056 004500450032 1 MVIS
42 004670210063 004670210094 1 MVIS
43 004840520243 004840520349 1 MVIS
44 006760120156 006760120187 1 MVIS
45 006760120156 006760120194 1 MVIS
46 006960390514 006960390576 1 MVIS
47 007030280762 007030280899 1 MVIS
48 007030280762 007030280902 1 MVIS
49 007030280762 007030280919 1 MVIS
50 007030280762 007030280926 1 MVIS
HC-016I 08:55 Friday, June 8, 2001 15
Sample SAS Job for Example A
sample print of unique linkidxs in work.pmedids
OBS LINKIDX
1 000050480073
2 000050480080
3 000050480097
4 000200350444
5 000200350475
6 000650110906
7 000670240253
8 000670240260
9 000670240277
10 000670240284
11 000980120107
12 001660440100
13 001660440117
14 001860600071
15 001860600088
16 001860600095
17 001860600108
18 001860600115
19 001860600146
20 001860600153
21 001860600160
22 001860600177
23 001860600184
24 002360270274
25 002360270281
26 002550290330
27 003050120559
28 003050120566
29 003050120573
30 003050120580
31 003620310172
32 003660480156
33 003660480163
34 003660480170
35 004060270671
36 004060270688
37 004060270695
38 004060270708
39 004170230343
40 004500450032
41 004670210094
42 004840520349
43 006760120187
44 006760120194
45 006960390576
46 007030280899
47 007030280902
48 007030280919
49 007030280926
50 007030280933
HC-016I 08:55 Friday, June 8, 2001 16
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
000050480073 000050480073001 AMOXICILLIN 6.86 5750.52
000050480073002 AMOXICILLIN 6.86 5750.52
000050480080 000050480080001 ALBUTEROL 18.69 5750.52
000050480080002 ALBUTEROL 18.69 5750.52
000050480097 000050480097001 PEDIAPRED 7.56 5750.52
000200350444 000200350444001 VANCERIL 32.59 4878.72
000200350475 000200350475001 PROVENTIL HFA 29.48 4878.72
000650110906 000650110906001 CORTISPORIN 32.98 9499.40
000670240253 000670240253001 AMOXICILLIN 250/5ML 14.12 3696.38
000670240260 000670240260001 CROMOLYN 20MG/2ML 42.00 3696.38
000670240277 000670240277001 ALBUTEROL 0.5% 20.25 3696.38
000670240284 000670240284001 PRELONE 15MG/5ML SYRUP*480 ML 43.17 3696.38
000980120107 000980120107001 THEOPHYLLINE 30.42 8256.38
000980120107002 THEOPHYLLINE 30.42 8256.38
000980120107003 THEOPHYLLINE 30.42 8256.38
000980120107004 THEOPHYLLINE 30.42 8256.38
000980120107005 THEOPHYLLINE 30.42 8256.38
000980120107006 THEOPHYLLINE 30.42 8256.38
000980120107007 THEOPHYLLINE 30.42 8256.38
001660440100 001660440100001 VENTOLIN 54.98 10815.33
001660440100002 VENTOLIN 54.98 10815.33
001660440100003 VENTOLIN 54.98 10815.33
001660440117 001660440117001 BACTRIM-DS 12.38 10815.33
001860600071 001860600071001 THEO-DUR 35.65 13491.42
001860600088 001860600088001 HYZAAR 54.60 13491.42
001860600088002 HYZAAR 54.60 13491.42
001860600095 001860600095001 ALBUTEROL 11.86 13491.42
001860600095002 ALBUTEROL 11.86 13491.42
001860600095003 ALBUTEROL 11.86 13491.42
001860600108 001860600108001 AEROBID 56.80 13491.42
001860600108002 AEROBID 56.80 13491.42
001860600108003 AEROBID 56.80 13491.42
HC-016I 08:55 Friday, June 8, 2001 17
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
001860600115 001860600115001 NORVASC 30.15 13491.42
001860600115002 NORVASC 30.15 13491.42
001860600115003 NORVASC 30.15 13491.42
001860600115004 NORVASC 30.15 13491.42
001860600115005 NORVASC 30.15 13491.42
001860600146 001860600146001 THEO-DUR 35.65 13491.42
001860600146002 THEO-DUR 35.65 13491.42
001860600146003 THEO-DUR 35.65 13491.42
001860600146004 THEO-DUR 35.65 13491.42
001860600146005 THEO-DUR 35.65 13491.42
001860600153 001860600153001 HYZAAR 56.35 13491.42
001860600153002 HYZAAR 56.35 13491.42
001860600153003 HYZAAR 57.55 13491.42
001860600153004 HYZAAR 56.35 13491.42
001860600153005 HYZAAR 52.93 13491.42
001860600160 001860600160001 ALBUTEROL 5.92 13491.42
001860600160002 ALBUTEROL 5.92 13491.42
001860600160003 ALBUTEROL 5.92 13491.42
001860600160004 ALBUTEROL 5.92 13491.42
001860600160005 ALBUTEROL 5.92 13491.42
001860600177 001860600177001 AEROBID 56.80 13491.42
001860600177002 AEROBID 56.80 13491.42
001860600177003 AEROBID 56.80 13491.42
001860600177004 AEROBID 56.80 13491.42
001860600177005 AEROBID 56.80 13491.42
001860600184 001860600184001 NORVASC 30.15 13491.42
001860600184002 NORVASC 30.15 13491.42
001860600184003 NORVASC 30.15 13491.42
001860600184004 NORVASC 30.15 13491.42
001860600184005 NORVASC 30.15 13491.42
002360270274 002360270274001 ALBUTEROL 14.60 9769.91
002360270281 002360270281001 PREMPRO 20.51 9769.91
002360270281002 PREMPRO 20.51 9769.91
002550290330 002550290330001 PREDNISONE 12.49 14080.51
003050120559 003050120559001 ZITHROMAX 37.31 4941.63
003050120566 003050120566001 ZESTRIL 84.54 4941.63
003050120573 003050120573001 VERAPAMIL HCL SR 122.80 4941.63
003050120573002 VERAPAMIL HCL SR 122.80 4941.63
HC-016I 08:55 Friday, June 8, 2001 18
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
003050120580 003050120580001 DELTASONE 0.29 4941.63
003620310172 003620310172001 CLARITIN 58.75 4140.07
003660480156 003660480156001 ALBUTEROL 16.98 1097.88
003660480163 003660480163001 TRIMOX 11.39 1097.88
003660480170 003660480170001 PREDNISONE 7.08 1097.88
004060270671 004060270671001 HABITROL 21MG PATCH 56.82 2303.92
004060270671002 HABITROL 21MG PATCH 56.82 2303.92
004060270688 004060270688001 PROMETHAZINE/CODEINE 13.49 2303.92
004060270695 004060270695001 BIAXIN 40.29 2303.92
004060270708 004060270708001 PREDNISONE 6.98 2303.92
004170230343 004170230343001 HISTINEX DM 9.28 10636.31
004170230343002 HISTINEX DM 9.37 10636.31
004500450032 004500450032001 INHALER 31.02 7954.54
004500450032002 INHALER 31.02 7954.54
004500450032003 INHALER 31.02 7954.54
004670210094 004670210094001 ALBUTEROL 7.19 12912.96
004670210094002 ALBUTEROL 7.19 12912.96
004670210094003 ALBUTEROL 7.19 12912.96
004670210094004 ALBUTEROL 7.19 12912.96
004840520349 004840520349001 BRONCHO SALINE 9.45 1734.86
004840520349002 BRONCHO SALINE 9.45 1734.86
004840520349003 BRONCHO SALINE 9.45 1734.86
004840520349004 BRONCHO SALINE 9.45 1734.86
004840520349005 BRONCHO SALINE 9.45 1734.86
006760120187 006760120187001 ALBUTEROL 19.69 5122.63
006760120194 006760120194001 -9 6.25 5122.63
006760120194002 -9 6.25 5122.63
006960390576 006960390576001 ALBUTEROL 26.49 1580.88
006960390576002 ALBUTEROL 26.49 1580.88
006960390576003 ALBUTEROL 26.49 1580.88
006960390576004 ALBUTEROL 26.49 1580.88
006960390576005 ALBUTEROL 26.49 1580.88
006960390576006 ALBUTEROL 26.49 1580.88
006960390576007 ALBUTEROL 26.49 1580.88
HC-016I 08:55 Friday, June 8, 2001 19
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
007030280899 007030280899001 AZMACORT 40.23 6223.48
007030280902 007030280902001 RELAFEN 65.98 6223.48
007030280902002 RELAFEN 65.98 6223.48
007030280902003 RELAFEN 65.98 6223.48
007030280919 007030280919001 TILADE 26.26 6223.48
007030280926 007030280926001 SEREVENT INHALER 55.48 6223.48
007030280933 007030280933001 PHRENILIN 8.04 6223.48
007030281169 007030281169001 GUAIFENESIN LA 12.42 6223.48
007030281176 007030281176001 PREDNISONE 12.27 6223.48
007030281176002 PREDNISONE 12.27 6223.48
007030281190 007030281190001 NOLAMINE 18.77 6223.48
007640120815 007640120815001 METHYLPREDNISOLONE 9.08 6906.32
007640120822 007640120822001 AZMACORT 40.54 6906.32
007640120839 007640120839001 CLINDAMYCIN 16.99 6906.32
007870290328 007870290328001 VERAPAMIL 180MG SR 31.69 10376.27
007870290328002 VERAPAMIL 180MG SR 31.69 10376.27
007870290328003 VERAPAMIL 180MG SR 31.69 10376.27
007870290328004 VERAPAMIL 180MG SR 31.69 10376.27
007870290335 007870290335001 PAXIL 20MG TABLETS 58.99 10376.27
007950160807 007950160807001 FUROSEMIDE 4.89 4655.28
007950160807002 FUROSEMIDE 4.89 4655.28
007950160807003 FUROSEMIDE 4.89 4655.28
007950160807004 FUROSEMIDE 4.89 4655.28
007950160807005 FUROSEMIDE 4.89 4655.28
007950160807006 FUROSEMIDE 4.89 4655.28
007950160821 007950160821001 SLO-BID 13.52 4655.28
007950160821002 SLO-BID 13.52 4655.28
007950160821003 SLO-BID 81.15 4655.28
007950160821004 SLO-BID 81.15 4655.28
007950160821005 SLO-BID 13.52 4655.28
007950160821006 SLO-BID 81.15 4655.28
007950160838 007950160838001 LANOXIN 6.27 4655.28
007950160838002 LANOXIN 5.50 4655.28
HC-016I 08:55 Friday, June 8, 2001 20
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
007950160852 007950160852001 POTASSIUM CHLORID 10.69 4655.28
007950160934 007950160934001 SULFAMETH/TRIMETH 5.13 4655.28
007950160934002 SULFAMETH/TRIMETH 5.13 4655.28
008540420281 008540420281001 CLARITIN 62.49 23783.33
008540420298 008540420298001 ALBUTEROL 21.41 23783.33
008580330096 008580330096001 ALBUTEROL 87.74 4805.32
008580330096002 ALBUTEROL 87.74 4805.32
008600260194 008600260194001 CIPRO 500MG 54.35 8648.82
009780360459 009780360459001 ALBUTEROL 9.89 10194.95
009780360459002 ALBUTEROL 9.89 10194.95
009780360459003 ALBUTEROL 9.89 10194.95
009780360466 009780360466001 AUGMENTIN 145.99 10194.95
009780360473 009780360473001 HYDROPHILIC 10.35 10194.95
009780360480 009780360480001 ALBUTEROL 26.94 10194.95
009780360497 009780360497001 ALBUTEROL INHALER 18.95 10194.95
009780360497002 ALBUTEROL INHALER 18.95 10194.95
009780360500 009780360500001 LIQUID PRED 67.84 10194.95
009780360500002 LIQUID PRED 67.84 10194.95
009780360517 009780360517001 FLONASE NASAL SPRAY 42.77 10194.95
009780360524 009780360524001 INSPIREASE 26.50 10194.95
009780360555 009780360555001 PREDNISONE 4.25 10194.95
009910150101 009910150101001 SECONDARY SET 30.24 5316.23
009910150101002 SECONDARY SET 30.24 5316.23
009910150101003 SECONDARY SET 30.24 5316.23
010900170741 010900170741001 PREDNISONE 4.75 7319.51
010900170950 010900170950001 VANCENASE AQ NASAL S 53.00 7319.51
010900170950002 VANCENASE AQ NASAL S 53.00 7319.51
011400270139 011400270139001 VASOTEC 36.60 3993.36
011400270191 011400270191001 HYDROCHLORTHIAZIDE 5.98 3993.36
HC-016I 08:55 Friday, June 8, 2001 21
Sample SAS Job for Example A
sample print of work.mvpmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
011400270204 011400270204001 POTASSIUM CL 8.99 3993.36
011400270211 011400270211001 VASOTEC 66.76 3993.36
011400270228 011400270228001 TIAZAC 63.29 3993.36
012060320213 012060320213001 INTAL INHALER 42.90 506.65
012060320213002 INTAL INHALER 42.90 506.65
012060320213003 INTAL INHALER 42.90 506.65
012060320220 012060320220001 PROVENTIL 5.00 506.65
012060320220002 PROVENTIL 5.00 506.65
012060320220003 PROVENTIL 5.00 506.65
012060550156 012060550156001 AMOXICILLIN 10.18 433.76
012060550156002 AMOXICILLIN 10.18 433.76
012080171145 012080171145001 THICK-IT 8.58 6713.27
012080171145002 THICK-IT 8.58 6713.27
012080171145003 THICK-IT 8.58 6713.27
012080171145004 THICK-IT 8.58 6713.27
012080171152 012080171152001 BRETHINE 121.68 6713.27
012080171152002 BRETHINE 121.68 6713.27
012080171152003 BRETHINE 121.68 6713.27
012080171152004 BRETHINE 121.68 6713.27
012080171169 012080171169001 AEROBID INHALER 58.76 6713.27
012080171169002 AEROBID INHALER 58.76 6713.27
012080171169003 AEROBID INHALER 58.76 6713.27
012080171169004 AEROBID INHALER 58.76 6713.27
012080171176 012080171176001 ATROVENT INHALER 29.96 6713.27
012080171176002 ATROVENT INHALER 29.96 6713.27
012080171176003 ATROVENT INHALER 29.96 6713.27
012080171176004 ATROVENT INHALER 29.96 6713.27
012080171183 012080171183001 ALBUTERAL INHALER 62.52 6713.27
012080171183002 ALBUTERAL INHALER 62.52 6713.27
012080171183003 ALBUTERAL INHALER 62.52 6713.27
012080171183004 ALBUTERAL INHALER 62.52 6713.27
012260410098 012260410098001 PROMETHAZINE VC 5.36 7490.09
012260410101 012260410101001 ALBUTEROL 5.72 7490.09
012260410118 012260410118001 AMOXICILLIN 14.60 7490.09
HC-016I 08:55 Friday, June 8, 2001 22
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Analysis Variable : RXXP97X SUM OF PAYMENTS RXSF97X-RXOU97X(IMPUTED)
N Sum
------------------
3611 116979.44
------------------
HC-016I 08:55 Friday, June 8, 2001 23
Sample SAS Job for Example A
Total Rx expenditures associated with medical visits (excluding telephone) for asthma
Weighted
Analysis Variable : RXXP97X SUM OF PAYMENTS RXSF97X-RXOU97X(IMPUTED)
N Sum
------------------
3611 778395095
------------------
1 The SAS System 15:34 Thursday, June 7, 2001
NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 6.12 TS025
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC, Site 0026405003.
1 OPTIONS LS=132 PS=59;
2
3 TITLE1 "HC-016I";
4 TITLE2 'Sample SAS Job for Example B';
5
6 LIBNAME IN 'D:\';
NOTE: Libref IN was successfully assigned as follows:
Engine: V603
Physical Name: D:\
7
8 **************************************************************************************
9 * Calculate the expenditures for prescribed medicines associated with asthma.
10 **************************************************************************************;
11 PROC FORMAT;
12 VALUE EVENTYPE
13 1 = "1 MVIS"
14 2 = "2 OPAT"
15 3 = "3 EROM"
16 4 = "4 STAZ"
17 5 = "5 DVIS"
18 6 = "6 OMED"
19 7 = "7 HVIS"
20 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
21 RUN;
NOTE: The PROCEDURE FORMAT used 0.33 seconds.
22
23 *--------------------------------------------------------------------------------------
24 * Get condition records coded as asthma.
25 *--------------------------------------------------------------------------------------;
26 DATA ASCONDS;
27 SET IN.H18 (KEEP=CONDIDX CCCODEX);
28 IF CCCODEX="128";
29 RUN;
NOTE: The data set WORK.ASCONDS has 1763 observations and 2 variables.
NOTE: The DATA statement used 28.28 seconds.
30
31 *--------------------------------------------------------------------------
32 * Get the events linked to each of the asthma condition records.
33 *--------------------------------------------------------------------------;
34 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: The data set WORK.ASCONDS has 1763 observations and 2 variables.
NOTE: The PROCEDURE SORT used 0.44 seconds.
2 The SAS System 15:34 Thursday, June 7, 2001
35
36 proc print data=asconds (obs=50);
37 title3 "sample print of work.asconds - sorted by condidx";
38 title4 "COND (H18) records where cccodex=128";
39 run;
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: The PROCEDURE PRINT used 0.44 seconds.
40
41 PROC SORT DATA=IN.H16IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: The data set WORK.CLNK has 310651 observations and 5 variables.
NOTE: The PROCEDURE SORT used 53.22 seconds.
42
43 DATA ASCLNKS;
44 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
45 ASCONDS(IN=INASCOND KEEP=CONDIDX);
46 BY CONDIDX;
47 IF INCLNK & INASCOND;
48 RUN;
NOTE: The data set WORK.ASCLNKS has 6789 observations and 3 variables.
NOTE: The DATA statement used 16.64 seconds.
49
50 proc print data=asclnks (obs=75);
51 by condidx;
52 id condidx;
53 format eventype eventype.;
54 title3 "sample print of work.asclnks - sorted by condidx";
55 title4 "events linked to asthma condition records";
56 run;
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: The PROCEDURE PRINT used 0.44 seconds.
57
58 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: The data set WORK.ASCLNKS has 6789 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.77 seconds.
59
60 proc print data=asclnks (obs=50);
61 format eventype eventype.;
62 title3 "sample print of work.asclnks - sorted by evntidx";
63 run;
NOTE: The PROCEDURE PRINT printed page 4.
3 The SAS System 15:34 Thursday, June 7, 2001
NOTE: The PROCEDURE PRINT used 0.05 seconds.
64
65 DATA ASCLNKS;
66 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
67 BY EVNTIDX;
68 IF FIRST.EVNTIDX;
69 RUN;
NOTE: The data set WORK.ASCLNKS has 6751 observations and 2 variables.
NOTE: The DATA statement used 0.48 seconds.
70
71 proc print data=asclnks (obs=50);
72 format eventype eventype.;
73 title3 "sample print of unique evntidxs from work.asclnks";
74 run;
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: The PROCEDURE PRINT used 0.11 seconds.
75
76 *-------------------------------------------------------------------------------
77 * Get PMED records linked to asthma condition records.
78 *-------------------------------------------------------------------------------;
79 PROC SORT DATA=IN.H16A OUT=PMED; BY LINKIDX; RUN;
NOTE: The data set WORK.PMED has 234532 observations and 54 variables.
NOTE: The PROCEDURE SORT used 2 minutes 39.28 seconds.
80
81 DATA ASPMEDS;
82 MERGE PMED (KEEP=LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97)
83 ASCLNKS (IN=INASCLNK KEEP=EVNTIDX RENAME=(EVNTIDX=LINKIDX));
84 BY LINKIDX;
85 IF INASCLNK & WTDPER97>0;
86 RUN;
NOTE: The data set WORK.ASPMEDS has 8642 observations and 5 variables.
NOTE: The DATA statement used 28.73 seconds.
87
88 proc print data=aspmeds (obs=300);
89 by linkidx;
90 id linkidx;
91 var rxrecidx rxname RXXP97X WTDPER97;
92 title3 "sample print of work.aspmeds";
93 title4 "PMED (HC-016A) records which link to condition records coded as asthma";
94 run;
NOTE: The PROCEDURE PRINT printed pages 6-14.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
4 The SAS System 15:34 Thursday, June 7, 2001
95
96 PROC MEANS DATA=ASPMEDS N SUM;
97 VAR RXXP97X;
98 TITLE3 "Total Rx expenditures associated with asthma";
99 RUN;
NOTE: The PROCEDURE MEANS printed page 15.
NOTE: The PROCEDURE MEANS used 0.32 seconds.
100
101 PROC MEANS DATA=ASPMEDS N SUM;
102 VAR RXXP97X;
103 WEIGHT WTDPER97;
104 TITLE3 "Total Rx expenditures associated with asthma";
105 TITLE5 "Weighted";
106 RUN;
NOTE: The PROCEDURE MEANS printed page 16.
NOTE: The PROCEDURE MEANS used 0.05 seconds.
107
108
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-016I 15:34 Thursday, June 7, 2001 1
Sample SAS Job for Example B
sample print of work.asconds - sorted by condidx
COND (H18) records where cccodex=128
OBS CONDIDX CCCODEX
1 000040320014 128
2 000050480022 128
3 000050480038 128
4 000200350110 128
5 000650110054 128
6 000670240039 128
7 000850580014 128
8 000980120017 128
9 001170160082 128
10 001660130011 128
11 001660370019 128
12 001660440018 128
13 001830490013 128
14 001860600013 128
15 001900110024 128
16 002360270026 128
17 002400120025 128
18 002550290027 128
19 003050120030 128
20 003210280044 128
21 003210280135 128
22 003320230104 128
23 003370680016 128
24 003430100019 128
25 003470170019 128
26 003540170016 128
27 003620170023 128
28 003620310015 128
29 003660480029 128
30 003770240045 128
31 004060270035 128
32 004060340103 128
33 004160280015 128
34 004170230124 128
35 004370110021 128
36 004500450016 128
37 004630460039 128
38 004670210023 128
39 004840520061 128
40 005030330030 128
41 005060320036 128
42 005070320015 128
43 005260160028 128
44 005300270020 128
45 005670410030 128
46 005690210026 128
47 005710290049 128
48 005720150043 128
49 005720150093 128
50 005720390063 128
HC-016I 15:34 Thursday, June 7, 2001 2
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
000050480022 000050480059 1 MVIS
000050480066 1 MVIS
000050480073 8 PMED
000050480038 000050480080 8 PMED
000050480097 8 PMED
000200350110 000200350300 1 MVIS
000200350317 1 MVIS
000200350444 8 PMED
000200350475 8 PMED
000200350502 8 PMED
000200350519 8 PMED
000650110054 000650110735 8 PMED
000650110766 1 MVIS
000650110855 4 STAZ
000650110906 8 PMED
000670240039 000670240239 1 MVIS
000670240246 1 MVIS
000670240253 8 PMED
000670240260 8 PMED
000670240277 8 PMED
000670240284 8 PMED
000980120017 000980120070 8 PMED
000980120094 1 MVIS
000980120107 8 PMED
000980120114 8 PMED
001660440018 001660440028 1 MVIS
001660440100 8 PMED
001860600013 001860600064 1 MVIS
001860600071 8 PMED
001860600095 8 PMED
001860600108 8 PMED
001860600122 1 MVIS
001860600146 8 PMED
001860600160 8 PMED
001860600191 8 PMED
001860600211 8 PMED
001860600228 8 PMED
002360270026 002360270229 1 MVIS
002360270236 1 MVIS
002360270243 1 MVIS
002360270250 1 MVIS
HC-016I 15:34 Thursday, June 7, 2001 3
Sample SAS Job for Example B
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
002360270026 002360270274 8 PMED
002360270298 8 PMED
002360270318 8 PMED
002360270349 8 PMED
002360270356 8 PMED
002360270387 8 PMED
002360270445 8 PMED
002550290027 002550290309 8 PMED
002550290316 8 PMED
002550290323 1 MVIS
002550290330 8 PMED
003050120030 003050120408 8 PMED
003050120460 1 MVIS
003050120477 1 MVIS
003050120559 8 PMED
003050120580 8 PMED
003050120597 8 PMED
003050120600 8 PMED
003050120617 8 PMED
003320230104 003320230183 8 PMED
003540170016 003540170255 8 PMED
003540170522 8 PMED
003540170604 8 PMED
003540170611 8 PMED
003540170628 8 PMED
003620310015 003620310090 1 MVIS
003620310127 8 PMED
003620310141 1 MVIS
003620310172 8 PMED
003620310216 1 MVIS
003620310223 8 PMED
003660480029 003660480132 1 MVIS
003660480149 1 MVIS
003660480156 8 PMED
HC-016I
15:34 Thursday, June 7, 2001 4
Sample SAS Job for Example B
sample print of work.asclnks - sorted by evntidx
OBS CONDIDX EVNTIDX EVENTYPE
1 000050480022 000050480059 1 MVIS
2 000050480022 000050480066 1 MVIS
3 000050480022 000050480073 8 PMED
4 000050480038 000050480080 8 PMED
5 000050480038 000050480097 8 PMED
6 000200350110 000200350300 1 MVIS
7 000200350110 000200350317 1 MVIS
8 000200350110 000200350444 8 PMED
9 000200350110 000200350475 8 PMED
10 000200350110 000200350502 8 PMED
11 000200350110 000200350519 8 PMED
12 000650110054 000650110735 8 PMED
13 000650110054 000650110766 1 MVIS
14 000650110054 000650110855 4 STAZ
15 000650110054 000650110906 8 PMED
16 000670240039 000670240239 1 MVIS
17 000670240039 000670240246 1 MVIS
18 000670240039 000670240253 8 PMED
19 000670240039 000670240260 8 PMED
20 000670240039 000670240277 8 PMED
21 000670240039 000670240284 8 PMED
22 000980120017 000980120070 8 PMED
23 000980120017 000980120094 1 MVIS
24 000980120017 000980120107 8 PMED
25 000980120017 000980120114 8 PMED
26 001660440018 001660440028 1 MVIS
27 001660440018 001660440100 8 PMED
28 001860600013 001860600064 1 MVIS
29 001860600013 001860600071 8 PMED
30 001860600013 001860600095 8 PMED
31 001860600013 001860600108 8 PMED
32 001860600013 001860600122 1 MVIS
33 001860600013 001860600146 8 PMED
34 001860600013 001860600160 8 PMED
35 001860600013 001860600191 8 PMED
36 001860600013 001860600211 8 PMED
37 001860600013 001860600228 8 PMED
38 002360270026 002360270229 1 MVIS
39 002360270026 002360270236 1 MVIS
40 002360270026 002360270243 1 MVIS
41 002360270026 002360270250 1 MVIS
42 002360270026 002360270274 8 PMED
43 002360270026 002360270298 8 PMED
44 002360270026 002360270318 8 PMED
45 002360270026 002360270349 8 PMED
46 002360270026 002360270356 8 PMED
47 002360270026 002360270387 8 PMED
48 002360270026 002360270445 8 PMED
49 002550290027 002550290309 8 PMED
50 002550290027 002550290316 8 PMED
HC-016I 15:34 Thursday, June 7, 2001 5
Sample SAS Job for Example B
sample print of unique evntidxs from work.asclnks
OBS EVNTIDX EVENTYPE
1 000050480059 1 MVIS
2 000050480066 1 MVIS
3 000050480073 8 PMED
4 000050480080 8 PMED
5 000050480097 8 PMED
6 000200350300 1 MVIS
7 000200350317 1 MVIS
8 000200350444 8 PMED
9 000200350475 8 PMED
10 000200350502 8 PMED
11 000200350519 8 PMED
12 000650110735 8 PMED
13 000650110766 1 MVIS
14 000650110855 4 STAZ
15 000650110906 8 PMED
16 000670240239 1 MVIS
17 000670240246 1 MVIS
18 000670240253 8 PMED
19 000670240260 8 PMED
20 000670240277 8 PMED
21 000670240284 8 PMED
22 000980120070 8 PMED
23 000980120094 1 MVIS
24 000980120107 8 PMED
25 000980120114 8 PMED
26 001660440028 1 MVIS
27 001660440100 8 PMED
28 001860600064 1 MVIS
29 001860600071 8 PMED
30 001860600095 8 PMED
31 001860600108 8 PMED
32 001860600122 1 MVIS
33 001860600146 8 PMED
34 001860600160 8 PMED
35 001860600191 8 PMED
36 001860600211 8 PMED
37 001860600228 8 PMED
38 002360270229 1 MVIS
39 002360270236 1 MVIS
40 002360270243 1 MVIS
41 002360270250 1 MVIS
42 002360270274 8 PMED
43 002360270298 8 PMED
44 002360270318 8 PMED
45 002360270349 8 PMED
46 002360270356 8 PMED
47 002360270387 8 PMED
48 002360270445 8 PMED
49 002550290309 8 PMED
50 002550290316 8 PMED
HC-016I 15:34 Thursday, June 7, 2001 6
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-016A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
000050480073 000050480073001 AMOXICILLIN 6.86 5750.52
000050480073002 AMOXICILLIN 6.86 5750.52
000050480080 000050480080001 ALBUTEROL 18.69 5750.52
000050480080002 ALBUTEROL 18.69 5750.52
000050480097 000050480097001 PEDIAPRED 7.56 5750.52
000200350444 000200350444001 VANCERIL 32.59 4878.72
000200350475 000200350475001 PROVENTIL HFA 29.48 4878.72
000200350502 000200350502001 VANCERIL 52.78 4878.72
000200350519 000200350519001 SERVENT 53.73 4878.72
000650110735 000650110735001 NORVASC 37.82 9499.40
000650110906 000650110906001 CORTISPORIN 32.98 9499.40
000670240253 000670240253001 AMOXICILLIN 250/5ML 14.12 3696.38
000670240260 000670240260001 CROMOLYN 20MG/2ML 42.00 3696.38
000670240277 000670240277001 ALBUTEROL 0.5% 20.25 3696.38
000670240284 000670240284001 PRELONE 15MG/5ML SYRUP*480 ML 43.17 3696.38
000980120070 000980120070001 THEOPHYLLINE 16.21 8256.38
000980120107 000980120107001 THEOPHYLLINE 30.42 8256.38
000980120107002 THEOPHYLLINE 30.42 8256.38
000980120107003 THEOPHYLLINE 30.42 8256.38
000980120107004 THEOPHYLLINE 30.42 8256.38
000980120107005 THEOPHYLLINE 30.42 8256.38
000980120107006 THEOPHYLLINE 30.42 8256.38
000980120107007 THEOPHYLLINE 30.42 8256.38
000980120114 000980120114001 THEOPHYLLINE 30.44 8256.38
000980120114002 THEOPHYLLINE 30.44 8256.38
000980120114003 THEOPHYLLINE 30.44 8256.38
001660440100 001660440100001 VENTOLIN 54.98 10815.33
001660440100002 VENTOLIN 54.98 10815.33
001660440100003 VENTOLIN 54.98 10815.33
001860600071 001860600071001 THEO-DUR 35.65 13491.42
001860600095 001860600095001 ALBUTEROL 11.86 13491.42
HC-016I 15:34 Thursday, June 7, 2001 7
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-016A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
001860600095 001860600095002 ALBUTEROL 11.86 13491.42
001860600095003 ALBUTEROL 11.86 13491.42
001860600108 001860600108001 AEROBID 56.80 13491.42
001860600108002 AEROBID 56.80 13491.42
001860600108003 AEROBID 56.80 13491.42
001860600146 001860600146001 THEO-DUR 35.65 13491.42
001860600146002 THEO-DUR 35.65 13491.42
001860600146003 THEO-DUR 35.65 13491.42
001860600146004 THEO-DUR 35.65 13491.42
001860600146005 THEO-DUR 35.65 13491.42
001860600160 001860600160001 ALBUTEROL 5.92 13491.42
001860600160002 ALBUTEROL 5.92 13491.42
001860600160003 ALBUTEROL 5.92 13491.42
001860600160004 ALBUTEROL 5.92 13491.42
001860600160005 ALBUTEROL 5.92 13491.42
001860600191 001860600191001 THEO-DUR 35.65 13491.42
001860600191002 THEO-DUR 35.65 13491.42
001860600191003 THEO-DUR 35.65 13491.42
001860600211 001860600211001 ALBUTEROL 6.86 13491.42
001860600211002 ALBUTEROL 6.86 13491.42
001860600211003 ALBUTEROL 6.86 13491.42
001860600228 001860600228001 AEROBID 56.80 13491.42
001860600228002 AEROBID 56.80 13491.42
001860600228003 AEROBID 56.80 13491.42
002360270274 002360270274001 ALBUTEROL 14.60 9769.91
002360270298 002360270298001 THEO-24 14.30 9769.91
002360270298002 THEO-24 14.30 9769.91
002360270318 002360270318001 PROVENTIL HFA 32.99 9769.91
002360270318002 PROVENTIL HFA 32.99 9769.91
002360270318003 PROVENTIL HFA 32.99 9769.91
002360270318004 PROVENTIL HFA 32.99 9769.91
002360270349 002360270349001 ALBUTEROL SULFATE 6.60 9769.91
002360270349002 ALBUTEROL SULFATE 6.60 9769.91
002360270356 002360270356001 VANCERIL 31.03 9769.91
002360270356002 VANCERIL 31.03 9769.91
002360270356003 VANCERIL 31.03 9769.91
002360270356004 VANCERIL 31.03 9769.91
HC-016I 15:34 Thursday, June 7, 2001 8
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-016A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
002360270387 002360270387001 THEO-24 14.30 9769.91
002360270445 002360270445001 PROVENTIL HFA 32.99 9769.91
002550290309 002550290309001 VENTOLIN 23.97 14080.51
002550290309002 VENTOLIN 23.97 14080.51
002550290316 002550290316001 AZMACORT 45.46 14080.51
002550290330 002550290330001 PREDNISONE 12.49 14080.51
003050120408 003050120408001 DIFIL-G 20.23 4941.63
003050120408002 DIFIL-G 20.23 4941.63
003050120559 003050120559001 ZITHROMAX 37.31 4941.63
003050120580 003050120580001 DELTASONE 0.29 4941.63
003050120597 003050120597001 ALBUTEROL 52.50 4941.63
003050120597002 ALBUTEROL 52.50 4941.63
003050120597003 ALBUTEROL 26.25 4941.63
003050120597004 ALBUTEROL 52.50 4941.63
003050120600 003050120600001 BIAXIN 79.87 4941.63
003050120617 003050120617001 AZMACORT 55.69 4941.63
003320230183 003320230183001 DYPHYLLIN-GG200-200 9.48 3758.32
003540170255 003540170255001 AZMACORT 87.33 6893.59
003540170522 003540170522001 AZMACORT 100.24 6893.59
003540170522002 AZMACORT 81.58 6893.59
003540170522003 AZMACORT 100.24 6893.59
003540170522004 AZMACORT 100.24 6893.59
003540170522005 AZMACORT 100.24 6893.59
003540170522006 AZMACORT 81.58 6893.59
003540170604 003540170604001 AZMACORT 104.12 6893.59
003540170611 003540170611001 SEREVENT 64.78 6893.59
003540170628 003540170628001 ALBUTEROL 28.11 6893.59
003540170628002 ALBUTEROL 28.11 6893.59
003540170628003 ALBUTEROL 28.11 6893.59
003620310127 003620310127001 AMOXICILLIN 3.93 4140.07
003620310127002 AMOXICILLIN 3.93 4140.07
HC-016I 15:34 Thursday, June 7, 2001 9
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-016A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
003620310172 003620310172001 CLARITIN 58.75 4140.07
003620310223 003620310223001 VANCENASE AQ 60.49 4140.07
003620310223002 VANCENASE AQ 60.49 4140.07
003660480156 003660480156001 ALBUTEROL 16.98 1097.88
003660480170 003660480170001 PREDNISONE 7.08 1097.88
003660480187 003660480187001 AZMACORT INHALER 55.69 1097.88
003660480194 003660480194001 ALBUTEROL INHALATION 23.31 1097.88
003660480207 003660480207001 FLOVENT 150.60 1097.88
003660480214 003660480214001 VANCERIL INHALER 63.59 1097.88
003660480221 003660480221001 INTAL NEBULIZER SOL 46.07 1097.88
003770240551 003770240551001 ALBUTEROL 20.69 5215.67
003770240568 003770240568001 AZMACORT 43.69 5215.67
003770240664 003770240664001 PROVENTIL 28.49 5215.67
003770240671 003770240671001 AZMACORT 53.49 5215.67
004060270671 004060270671001 HABITROL 21MG PATCH 56.82 2303.92
004060270671002 HABITROL 21MG PATCH 56.82 2303.92
004060270688 004060270688001 PROMETHAZINE/CODEINE 13.49 2303.92
004060270695 004060270695001 BIAXIN 40.29 2303.92
004060270708 004060270708001 PREDNISONE 6.98 2303.92
004060340188 004060340188001 PREDNISONE 20.96 1200.73
004060340195 004060340195001 AEROBID 56.80 1200.73
004060340208 004060340208001 PROVENTIL INHALER 26.50 1200.73
004170230343 004170230343001 HISTINEX DM 9.28 10636.31
004170230343002 HISTINEX DM 9.37 10636.31
004170230367 004170230367001 BENZTROPINE 4.92 10636.31
004170230367002 BENZTROPINE 4.92 10636.31
004370110077 004370110077001 ALBUTEROL 18.99 5603.40
HC-016I 15:34 Thursday, June 7, 2001 10
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-016A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
004500450025 004500450025001 INHALER 31.02 7954.54
004500450032 004500450032001 INHALER 31.02 7954.54
004500450032002 INHALER 31.02 7954.54
004500450032003 INHALER 31.02 7954.54
004500450063 004500450063001 INHALER 31.02 7954.54
004670210094 004670210094001 ALBUTEROL 7.19 12912.96
004670210094002 ALBUTEROL 7.19 12912.96
004670210094003 ALBUTEROL 7.19 12912.96
004670210094004 ALBUTEROL 7.19 12912.96
004670210107 004670210107001 CROMOLYN 36.35 12912.96
004670210107002 CROMOLYN 36.35 12912.96
004670210114 004670210114001 ALBUTEROL SULFATE 17.59 12912.96
004670210114002 ALBUTEROL SULFATE 17.59 12912.96
004670210121 004670210121001 ALBUTEROL 32.60 12912.96
004840520349 004840520349001 BRONCHO SALINE 9.45 1734.86
004840520349002 BRONCHO SALINE 9.45 1734.86
004840520349003 BRONCHO SALINE 9.45 1734.86
004840520349004 BRONCHO SALINE 9.45 1734.86
004840520349005 BRONCHO SALINE 9.45 1734.86
005690210145 005690210145001 AZMACORT 57.72 3665.85
005690210145002 AZMACORT 57.72 3665.85
005690210145003 AZMACORT 57.72 3665.85
005690210145004 AZMACORT 57.72 3665.85
005720390121 005720390121001 DIFIL-G 20.23 2311.34
006760120187 006760120187001 ALBUTEROL 19.69 5122.63
006760120194 006760120194001 -9 6.25 5122.63
006760120194002 -9 6.25 5122.63
006960390456 006960390456001 CROLOM 45.49 1580.88
006960390456002 CROLOM 45.49 1580.88
006960390576 006960390576001 ALBUTEROL 26.49 1580.88
006960390576002 ALBUTEROL 26.49 1580.88
006960390576003 ALBUTEROL 26.49 1580.88
006960390576004 ALBUTEROL 26.49 1580.88
006960390576005 ALBUTEROL 26.49 1580.88
006960390576006 ALBUTEROL 26.49 1580.88
006960390576007 ALBUTEROL 26.49 1580.88
HC-016I 15:34 Thursday, June 7, 2001 11
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-016A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
006960390583 006960390583001 CROLOM 45.49 1580.88
006960390583002 CROLOM 45.49 1580.88
006960390583003 CROLOM 45.49 1580.88
006960390583004 CROLOM 45.49 1580.88
006960390583005 CROLOM 45.49 1580.88
006960390658 006960390658001 ALBUTEROL 21.70 1580.88
006960390665 006960390665001 CROLOM 45.49 1580.88
006960390665002 CROLOM 45.49 1580.88
006960390689 006960390689001 VENTOLIN 25.18 1580.88
006960390689002 VENTOLIN 25.04 1580.88
006960460963 006960460963001 CROLOM 45.49 3453.25
006960460963002 CROLOM 45.49 3453.25
006960460963003 CROLOM 45.49 3453.25
006960460963004 CROLOM 45.49 3453.25
006960460970 006960460970001 ALBUTEROL 26.49 3453.25
006960460970002 ALBUTEROL 26.49 3453.25
006960460970003 ALBUTEROL 26.49 3453.25
006960460970004 ALBUTEROL 26.49 3453.25
006960461086 006960461086001 CROLOM 45.49 3453.25
006960461086002 CROLOM 45.49 3453.25
006960461093 006960461093001 ALBUTEROL 26.49 3453.25
006960461093002 ALBUTEROL 26.49 3453.25
007030280899 007030280899001 AZMACORT 40.23 6223.48
007030280919 007030280919001 TILADE 26.26 6223.48
007030280926 007030280926001 SEREVENT INHALER 55.48 6223.48
007030281176 007030281176001 PREDNISONE 12.27 6223.48
007030281176002 PREDNISONE 12.27 6223.48
007030281227 007030281227001 ALBUTEROL 16.73 6223.48
007210140338 007210140338001 SEREVENT 52.93 5215.00
007210140369 007210140369001 PROVENTIL 36.95 5215.00
007210140763 007210140763001 SEREVENT 52.93 5215.00
007210140763002 SEREVENT 52.93 5215.00
007210140763003 SEREVENT 52.93 5215.00
HC-016I 15:34 Thursday, June 7, 2001 12
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-016A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
007210140770 007210140770001 VANCERIL INHALER 63.59 5215.00
007330320040 007330320040001 PROVENTIL 50.60 6009.06
007330320040002 PROVENTIL 50.60 6009.06
007330320040003 PROVENTIL 50.60 6009.06
007330320040004 PROVENTIL 50.60 6009.06
007330320057 007330320057001 PROVENTIL 50.60 6009.06
007330320057002 PROVENTIL 50.60 6009.06
007330320057003 PROVENTIL 50.60 6009.06
007330320064 007330320064001 PROVENTIL 50.60 6009.06
007640120815 007640120815001 METHYLPREDNISOLONE 9.08 6906.32
007640120822 007640120822001 AZMACORT 40.54 6906.32
007870290373 007870290373001 NUTRACORT 21.10 10376.27
007870290373002 NUTRACORT 19.50 10376.27
007870290373003 NUTRACORT 21.10 10376.27
007870290373004 NUTRACORT 21.10 10376.27
007870290380 007870290380001 ALBUTEROL 90MCG 21.41 10376.27
007870290380002 ALBUTEROL 90MCG 21.41 10376.27
007870290380003 ALBUTEROL 90MCG 21.41 10376.27
007870290380004 ALBUTEROL 90MCG 21.41 10376.27
007950160636 007950160636001 PROVENTIL 26.65 4655.28
007950160814 007950160814001 ALBUTEROL 18.29 4655.28
007950160821 007950160821001 SLO-BID 13.52 4655.28
007950160821002 SLO-BID 13.52 4655.28
007950160821003 SLO-BID 81.15 4655.28
007950160821004 SLO-BID 81.15 4655.28
007950160821005 SLO-BID 13.52 4655.28
007950160821006 SLO-BID 81.15 4655.28
007950160965 007950160965001 PROVENTIL 26.48 4655.28
007950160996 007950160996001 UNI-DUR ER 37.77 4655.28
007950160996002 UNI-DUR ER 37.77 4655.28
008510200220 008510200220001 PROPOXYPHENE 62.50 2741.96
008510200244 008510200244001 PREDNISONE 6.69 2741.96
008510200268 008510200268001 INHALER 31.02 2741.96
HC-016I 15:34 Thursday, June 7, 2001 13
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-016A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
008540420298 008540420298001 ALBUTEROL 21.41 23783.33
008580330096 008580330096001 ALBUTEROL 87.74 4805.32
008580330096002 ALBUTEROL 87.74 4805.32
008850120241 008850120241001 HUMIBID L.A. 28.85 3756.00
008850120241002 HUMIBID L.A. 28.85 3756.00
008850120272 008850120272001 ALBUTEROL 262.50 3756.00
008850120272002 ALBUTEROL 262.50 3756.00
008850120272003 ALBUTEROL 262.50 3756.00
008850120316 008850120316001 VOLMAX 10.22 3756.00
008850120316002 VOLMAX 10.22 3756.00
008850120330 008850120330001 LASIX 8.49 3756.00
008850120392 008850120392001 AZMACORT 57.72 3756.00
008850120405 008850120405001 HUMIBID L.A. 28.85 3756.00
008850120405002 HUMIBID L.A. 28.85 3756.00
008850120405003 HUMIBID L.A. 28.85 3756.00
008850120405004 HUMIBID L.A. 28.85 3756.00
008850120412 008850120412001 DELTASONE 4.99 3756.00
008850120429 008850120429001 IPRATROPIUM 5.00 3756.00
008850120429002 IPRATROPIUM 5.00 3756.00
008850120429003 IPRATROPIUM 264.00 3756.00
008850120429004 IPRATROPIUM 5.00 3756.00
008850120429005 IPRATROPIUM 264.00 3756.00
008850120429006 IPRATROPIUM 5.00 3756.00
008850120443 008850120443001 TC3 5.00 3756.00
008850120443002 TC3 5.00 3756.00
008850120443003 TC3 5.00 3756.00
008850120443004 TC3 5.00 3756.00
008850120443005 TC3 5.00 3756.00
008850120443006 TC3 5.00 3756.00
008850120450 008850120450001 CO-GESIC 8.79 3756.00
008850120450002 CO-GESIC 8.99 3756.00
008850120450003 CO-GESIC 8.99 3756.00
008850120450004 CO-GESIC 8.99 3756.00
008850120450005 CO-GESIC 8.99 3756.00
008850120450006 CO-GESIC 8.79 3756.00
008850120467 008850120467001 NEBULIZER 77.38 3756.00
008850120467002 NEBULIZER 77.38 3756.00
HC-016I 15:34 Thursday, June 7, 2001 14
Sample SAS Job for Example B
sample print of work.aspmeds
PMED (HC-016A) records which link to condition records coded as asthma
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
008850120467 008850120467003 NEBULIZER 77.38 3756.00
008850120467004 NEBULIZER 77.38 3756.00
008850120467005 NEBULIZER 77.38 3756.00
008850120467006 NEBULIZER 77.38 3756.00
008850120474 008850120474001 VOLMAX 41.44 3756.00
008850120474002 VOLMAX 62.15 3756.00
008850120474003 VOLMAX 62.15 3756.00
008850120474004 VOLMAX 62.15 3756.00
008850120481 008850120481001 LANOXIN 13.52 3756.00
008850120481002 LANOXIN 13.52 3756.00
008850120481003 LANOXIN 13.52 3756.00
008850120498 008850120498001 LASIX 8.49 3756.00
008850120498002 LASIX 8.49 3756.00
008850120525 008850120525001 AZMACORT 57.72 3756.00
008850120525002 AZMACORT 57.72 3756.00
008850120525003 AZMACORT 57.72 3756.00
008850120525004 AZMACORT 57.72 3756.00
008900290248 008900290248001 ATROVENT INHALER 32.29 4277.52
008900290248002 ATROVENT INHALER 32.29 4277.52
008900290255 008900290255001 VENTOLIN 33.75 4277.52
008900290255002 VENTOLIN 33.75 4277.52
008900290313 008900290313001 ATROVENT INHALER 32.29 4277.52
008900290313002 ATROVENT INHALER 32.29 4277.52
008900290313003 ATROVENT INHALER 32.29 4277.52
008900290313004 ATROVENT INHALER 32.29 4277.52
008900290313005 ATROVENT INHALER 32.29 4277.52
008900290344 008900290344001 ALBUTEROL 24.91 4277.52
008900290344002 ALBUTEROL 24.91 4277.52
008900290344003 ALBUTEROL 24.91 4277.52
008900290344004 ALBUTEROL 24.91 4277.52
008900290344005 ALBUTEROL 24.91 4277.52
008900290382 008900290382001 ALBUTEROL 15.71 4277.52
008900290399 008900290399001 IPRATROPIUM BROMIDE 67.50 4277.52
008950100347 008950100347001 THEO-DUR 12.63 9858.80
008950100347002 THEO-DUR 12.63 9858.80
HC-016I 15:34 Thursday, June 7, 2001 15
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Analysis Variable : RXXP97X SUM OF PAYMENTS RXSF97X-RXOU97X(IMPUTED)
N Sum
------------------
8642 299142.55
------------------
HC-016I 15:34 Thursday, June 7, 2001 16
Sample SAS Job for Example B
Total Rx expenditures associated with asthma
Weighted
Analysis Variable : RXXP97X SUM OF PAYMENTS RXSF97X-RXOU97X(IMPUTED)
N Sum
------------------
8642 2094307091
------------------
1 The SAS System 15:34 Thursday, June 7, 2001
NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 6.12 TS025
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC, Site 0026405003.
1
2 OPTIONS LS=132 PS=59;
3
4 TITLE1 "HC-016I";
5 TITLE2 'Sample SAS Job for Example C';
6
7 LIBNAME IN 'D:\';
NOTE: Libref IN was successfully assigned as follows:
Engine: V603
Physical Name: D:\
8
9 *************************************************************************************
10 * Calculate the expenditures for medical visits associated with asthma.
11 *************************************************************************************;
12 PROC FORMAT;
13 VALUE EVENTYPE
14 1 = "1 MVIS"
15 2 = "2 OPAT"
16 3 = "3 EROM"
17 4 = "4 STAZ"
18 5 = "5 DVIS"
19 6 = "6 OMED"
20 7 = "7 HVIS"
21 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
22 RUN;
NOTE: The PROCEDURE FORMAT used 0.77 seconds.
23
24 *-----------------------------------------------------------------------------------
25 * Get conditions records coded as asthma.
26 *-----------------------------------------------------------------------------------;
27 DATA ASCONDS;
28 SET IN.H18 (KEEP=CONDIDX CCCODEX);
29 IF CCCODEX="128";
30 RUN;
NOTE: The data set WORK.ASCONDS has 1763 observations and 2 variables.
NOTE: The DATA statement used 44.04 seconds.
31
32 *------------------------------------------------------------------------------------
33 * Get the events linked to each of the asthma condition records.
34 *------------------------------------------------------------------------------------;
35 PROC SORT DATA=ASCONDS; BY CONDIDX; RUN;
NOTE: The data set WORK.ASCONDS has 1763 observations and 2 variables.
NOTE: The PROCEDURE SORT used 0.66 seconds.
2 The SAS System 15:34 Thursday, June 7, 2001
36
37 proc print data=asconds (obs=50);
38 title3 "sample print of work.asconds - sorted by condidx";
39 title4 "COND (HC-018) records where cccodex=128";
40 run;
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: The PROCEDURE PRINT used 0.44 seconds.
41
42 PROC SORT DATA=IN.H16IF1 OUT=CLNK; BY CONDIDX; RUN;
NOTE: The data set WORK.CLNK has 310651 observations and 5 variables.
NOTE: The PROCEDURE SORT used 46.29 seconds.
43
44 DATA ASCLNKS;
45 MERGE CLNK (IN=INCLNK KEEP=CONDIDX EVNTIDX EVENTYPE)
46 ASCONDS(IN=INASCOND KEEP=CONDIDX);
47 BY CONDIDX;
48 IF INCLNK & INASCOND;
49 RUN;
NOTE: The data set WORK.ASCLNKS has 6789 observations and 3 variables.
NOTE: The DATA statement used 26.85 seconds.
50
51 proc print data=asclnks (obs=75);
52 by condidx;
53 id condidx;
54 format eventype eventype.;
55 title3 "sample print of work.asclnks - sorted by condidx";
56 title4 "events linked to asthma condition records";
57 run;
NOTE: The PROCEDURE PRINT printed pages 2-3.
NOTE: The PROCEDURE PRINT used 0.7 seconds.
58
59 PROC SORT DATA=ASCLNKS; BY EVNTIDX; RUN;
NOTE: The data set WORK.ASCLNKS has 6789 observations and 3 variables.
NOTE: The PROCEDURE SORT used 1.59 seconds.
60
61 proc print data=asclnks (obs=50);
62 format eventype eventype.;
63 title3 "sample print of work.asclnks - sorted by evntidx";
64 run;
3 The SAS System 15:34 Thursday, June 7, 2001
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
65
66 DATA ASCLNKS;
67 SET ASCLNKS (KEEP=EVNTIDX EVENTYPE);
68 BY EVNTIDX;
69 IF FIRST.EVNTIDX;
70 RUN;
NOTE: The data set WORK.ASCLNKS has 6751 observations and 2 variables.
NOTE: The DATA statement used 1.27 seconds.
71
72 proc print data=asclnks (obs=50);
73 format eventype eventype.;
74 title3 "sample print of unique evntidxs from work.asclnks";
75 run;
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
76
77 *--------------------------------------------------------------------------------------------
78 * Get non-telephone office based visits (i.e. MVIS events) for persons with positive weights.
79 *--------------------------------------------------------------------------------------------;
80 DATA MVIS;
81 SET IN.HC16GF1 (KEEP=EVNTIDX WTDPER97 SEETLKPV OBXP97X);
82 IF WTDPER97 > 0 & SEETLKPV NE 2;
83 RUN;
NOTE: The data set WORK.MVIS has 142119 observations and 4 variables.
NOTE: The DATA statement used 49.53 seconds.
84
85 PROC SORT DATA=MVIS; BY EVNTIDX; RUN;
NOTE: The data set WORK.MVIS has 142119 observations and 4 variables.
NOTE: The PROCEDURE SORT used 20.64 seconds.
86
87 *-------------------------------------------------------------------------------------
88 * Identify MVIS events which were for asthma.
89 *-------------------------------------------------------------------------------------;
90 DATA ASMVIS;
91 MERGE ASCLNKS (IN=INASCLNK)
92 MVIS (IN=INMVIS);
93 BY EVNTIDX;
94 IF INASCLNK & INMVIS;
95 RUN;
NOTE: The data set WORK.ASMVIS has 2245 observations and 5 variables.
4 The SAS System 15:34 Thursday, June 7, 2001
NOTE: The DATA statement used 6.15 seconds.
96
97 proc print data=asmvis (obs=50);
98 format eventype eventype.;
99 title3 "sample print of work.asmvis";
100 title4 "unique evntidxs from work.asclnks that are non-telephone MVIS (HC-016G) events";
101 run;
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: The PROCEDURE PRINT used 0.27 seconds.
102
103 PROC MEANS DATA=ASMVIS N SUM;
104 VAR OBXP97X;
105 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
106 RUN;
NOTE: The PROCEDURE MEANS printed page 7.
NOTE: The PROCEDURE MEANS used 0.28 seconds.
107
108 PROC MEANS DATA=ASMVIS SUM;
109 VAR OBXP97X;
110 WEIGHT WTDPER97;
111 TITLE3 "Total medical visit expenditures (excluding telephone) associated with asthma";
112 TITLE5 "Weighted";
113 RUN;
NOTE: The PROCEDURE MEANS printed page 8.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
114
115
116
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-016I 15:34 Thursday, June 7, 2001 1
Sample SAS Job for Example C
sample print of work.asconds - sorted by condidx
COND (HC-018) records where cccodex=128
OBS CONDIDX CCCODEX
1 000040320014 128
2 000050480022 128
3 000050480038 128
4 000200350110 128
5 000650110054 128
6 000670240039 128
7 000850580014 128
8 000980120017 128
9 001170160082 128
10 001660130011 128
11 001660370019 128
12 001660440018 128
13 001830490013 128
14 001860600013 128
15 001900110024 128
16 002360270026 128
17 002400120025 128
18 002550290027 128
19 003050120030 128
20 003210280044 128
21 003210280135 128
22 003320230104 128
23 003370680016 128
24 003430100019 128
25 003470170019 128
26 003540170016 128
27 003620170023 128
28 003620310015 128
29 003660480029 128
30 003770240045 128
31 004060270035 128
32 004060340103 128
33 004160280015 128
34 004170230124 128
35 004370110021 128
36 004500450016 128
37 004630460039 128
38 004670210023 128
39 004840520061 128
40 005030330030 128
41 005060320036 128
42 005070320015 128
43 005260160028 128
44 005300270020 128
45 005670410030 128
46 005690210026 128
47 005710290049 128
48 005720150043 128
49 005720150093 128
50 005720390063 128
HC-016I 15:34 Thursday, June 7, 2001 2
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
000050480022 000050480059 1 MVIS
000050480066 1 MVIS
000050480073 8 PMED
000050480038 000050480080 8 PMED
000050480097 8 PMED
000200350110 000200350300 1 MVIS
000200350317 1 MVIS
000200350444 8 PMED
000200350475 8 PMED
000200350502 8 PMED
000200350519 8 PMED
000650110054 000650110735 8 PMED
000650110766 1 MVIS
000650110855 4 STAZ
000650110906 8 PMED
000670240039 000670240239 1 MVIS
000670240246 1 MVIS
000670240253 8 PMED
000670240260 8 PMED
000670240277 8 PMED
000670240284 8 PMED
000980120017 000980120070 8 PMED
000980120094 1 MVIS
000980120107 8 PMED
000980120114 8 PMED
001660440018 001660440028 1 MVIS
001660440100 8 PMED
001860600013 001860600064 1 MVIS
001860600071 8 PMED
001860600095 8 PMED
001860600108 8 PMED
001860600122 1 MVIS
001860600146 8 PMED
001860600160 8 PMED
001860600191 8 PMED
001860600211 8 PMED
001860600228 8 PMED
002360270026 002360270229 1 MVIS
002360270236 1 MVIS
002360270243 1 MVIS
002360270250 1 MVIS
HC-016I 15:34 Thursday, June 7, 2001 3
Sample SAS Job for Example C
sample print of work.asclnks - sorted by condidx
events linked to asthma condition records
CONDIDX EVNTIDX EVENTYPE
002360270026 002360270274 8 PMED
002360270298 8 PMED
002360270318 8 PMED
002360270349 8 PMED
002360270356 8 PMED
002360270387 8 PMED
002360270445 8 PMED
002550290027 002550290309 8 PMED
002550290316 8 PMED
002550290323 1 MVIS
002550290330 8 PMED
003050120030 003050120408 8 PMED
003050120460 1 MVIS
003050120477 1 MVIS
003050120559 8 PMED
003050120580 8 PMED
003050120597 8 PMED
003050120600 8 PMED
003050120617 8 PMED
003320230104 003320230183 8 PMED
003540170016 003540170255 8 PMED
003540170522 8 PMED
003540170604 8 PMED
003540170611 8 PMED
003540170628 8 PMED
003620310015 003620310090 1 MVIS
003620310127 8 PMED
003620310141 1 MVIS
003620310172 8 PMED
003620310216 1 MVIS
003620310223 8 PMED
003660480029 003660480132 1 MVIS
003660480149 1 MVIS
003660480156 8 PMED
HC-016I 15:34 Thursday, June 7, 2001 4
Sample SAS Job for Example C
sample print of work.asclnks - sorted by evntidx
OBS CONDIDX EVNTIDX EVENTYPE
1 000050480022 000050480059 1 MVIS
2 000050480022 000050480066 1 MVIS
3 000050480022 000050480073 8 PMED
4 000050480038 000050480080 8 PMED
5 000050480038 000050480097 8 PMED
6 000200350110 000200350300 1 MVIS
7 000200350110 000200350317 1 MVIS
8 000200350110 000200350444 8 PMED
9 000200350110 000200350475 8 PMED
10 000200350110 000200350502 8 PMED
11 000200350110 000200350519 8 PMED
12 000650110054 000650110735 8 PMED
13 000650110054 000650110766 1 MVIS
14 000650110054 000650110855 4 STAZ
15 000650110054 000650110906 8 PMED
16 000670240039 000670240239 1 MVIS
17 000670240039 000670240246 1 MVIS
18 000670240039 000670240253 8 PMED
19 000670240039 000670240260 8 PMED
20 000670240039 000670240277 8 PMED
21 000670240039 000670240284 8 PMED
22 000980120017 000980120070 8 PMED
23 000980120017 000980120094 1 MVIS
24 000980120017 000980120107 8 PMED
25 000980120017 000980120114 8 PMED
26 001660440018 001660440028 1 MVIS
27 001660440018 001660440100 8 PMED
28 001860600013 001860600064 1 MVIS
29 001860600013 001860600071 8 PMED
30 001860600013 001860600095 8 PMED
31 001860600013 001860600108 8 PMED
32 001860600013 001860600122 1 MVIS
33 001860600013 001860600146 8 PMED
34 001860600013 001860600160 8 PMED
35 001860600013 001860600191 8 PMED
36 001860600013 001860600211 8 PMED
37 001860600013 001860600228 8 PMED
38 002360270026 002360270229 1 MVIS
39 002360270026 002360270236 1 MVIS
40 002360270026 002360270243 1 MVIS
41 002360270026 002360270250 1 MVIS
42 002360270026 002360270274 8 PMED
43 002360270026 002360270298 8 PMED
44 002360270026 002360270318 8 PMED
45 002360270026 002360270349 8 PMED
46 002360270026 002360270356 8 PMED
47 002360270026 002360270387 8 PMED
48 002360270026 002360270445 8 PMED
49 002550290027 002550290309 8 PMED
50 002550290027 002550290316 8 PMED
HC-016I 15:34 Thursday, June 7, 2001 5
Sample SAS Job for Example C
sample print of unique evntidxs from work.asclnks
OBS EVNTIDX EVENTYPE
1 000050480059 1 MVIS
2 000050480066 1 MVIS
3 000050480073 8 PMED
4 000050480080 8 PMED
5 000050480097 8 PMED
6 000200350300 1 MVIS
7 000200350317 1 MVIS
8 000200350444 8 PMED
9 000200350475 8 PMED
10 000200350502 8 PMED
11 000200350519 8 PMED
12 000650110735 8 PMED
13 000650110766 1 MVIS
14 000650110855 4 STAZ
15 000650110906 8 PMED
16 000670240239 1 MVIS
17 000670240246 1 MVIS
18 000670240253 8 PMED
19 000670240260 8 PMED
20 000670240277 8 PMED
21 000670240284 8 PMED
22 000980120070 8 PMED
23 000980120094 1 MVIS
24 000980120107 8 PMED
25 000980120114 8 PMED
26 001660440028 1 MVIS
27 001660440100 8 PMED
28 001860600064 1 MVIS
29 001860600071 8 PMED
30 001860600095 8 PMED
31 001860600108 8 PMED
32 001860600122 1 MVIS
33 001860600146 8 PMED
34 001860600160 8 PMED
35 001860600191 8 PMED
36 001860600211 8 PMED
37 001860600228 8 PMED
38 002360270229 1 MVIS
39 002360270236 1 MVIS
40 002360270243 1 MVIS
41 002360270250 1 MVIS
42 002360270274 8 PMED
43 002360270298 8 PMED
44 002360270318 8 PMED
45 002360270349 8 PMED
46 002360270356 8 PMED
47 002360270387 8 PMED
48 002360270445 8 PMED
49 002550290309 8 PMED
50 002550290316 8 PMED
HC-016I 15:34 Thursday, June 7, 2001 6
Sample SAS Job for Example C
sample print of work.asmvis
unique evntidxs from work.asclnks that are non-telephone MVIS (HC-016G) events
OBS EVNTIDX EVENTYPE SEETLKPV OBXP97X WTDPER97
1 000050480059 1 MVIS 1 34.50 5750.52
2 000050480066 1 MVIS 1 21.56 5750.52
3 000200350300 1 MVIS 1 33.00 4878.72
4 000200350317 1 MVIS 1 49.11 4878.72
5 000650110766 1 MVIS 1 51.00 9499.40
6 000670240239 1 MVIS 1 30.00 3696.38
7 000670240246 1 MVIS 1 30.00 3696.38
8 000980120094 1 MVIS 1 40.00 8256.38
9 001660440028 1 MVIS 1 19.21 10815.33
10 001860600064 1 MVIS 1 49.00 13491.42
11 001860600122 1 MVIS 1 259.00 13491.42
12 002360270229 1 MVIS 1 85.00 9769.91
13 002360270236 1 MVIS 1 16.00 9769.91
14 002360270243 1 MVIS 1 98.10 9769.91
15 002360270250 1 MVIS 1 71.77 9769.91
16 002550290323 1 MVIS 1 81.60 14080.51
17 003050120460 1 MVIS 1 50.40 4941.63
18 003050120477 1 MVIS 1 10.00 4941.63
19 003620310090 1 MVIS 1 55.00 4140.07
20 003620310141 1 MVIS 1 4.58 4140.07
21 003620310216 1 MVIS 1 32.09 4140.07
22 003660480132 1 MVIS 1 154.82 1097.88
23 003660480149 1 MVIS 1 43.58 1097.88
24 004060270664 1 MVIS 1 55.00 2303.92
25 004170230312 1 MVIS 1 34.42 10636.31
26 004500450049 1 MVIS 1 111.60 7954.54
27 004500450056 1 MVIS 1 111.60 7954.54
28 004630460176 1 MVIS 1 15.00 3485.58
29 004630460183 1 MVIS 1 35.00 3485.58
30 004630460190 1 MVIS 1 26.37 3485.58
31 004670210063 1 MVIS 1 33.50 12912.96
32 004670210070 1 MVIS 1 112.50 12912.96
33 004670210087 1 MVIS 1 33.50 12912.96
34 004840520243 1 MVIS 1 65.00 1734.86
35 004840520250 1 MVIS 1 40.00 1734.86
36 004840520274 1 MVIS 1 55.02 1734.86
37 004840520281 1 MVIS 1 21.97 1734.86
38 004840520298 1 MVIS 1 40.00 1734.86
39 004840520301 1 MVIS 1 40.00 1734.86
40 004840520318 1 MVIS 1 40.00 1734.86
41 004840520325 1 MVIS 1 40.00 1734.86
42 006760120156 1 MVIS 1 93.00 5122.63
43 006960390514 1 MVIS 1 27.23 1580.88
44 006960390538 1 MVIS 1 35.00 1580.88
45 007030280762 1 MVIS 1 30.00 6223.48
46 007030281063 1 MVIS 1 33.66 6223.48
47 007030281070 1 MVIS 1 22.00 6223.48
48 007030281183 1 MVIS 1 103.22 6223.48
49 007210140434 1 MVIS 1 10.00 5215.00
50 007210140441 1 MVIS 1 10.00 5215.00
HC-016I 15:34 Thursday, June 7, 2001 7
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Analysis Variable : OBXP97X SUM OF OBSF97X-OBOT97X (IMPUTED)
N Sum
------------------
2245 142568.95
------------------
HC-016I 15:34 Thursday, June 7, 2001 8
Sample SAS Job for Example C
Total medical visit expenditures (excluding telephone) associated with asthma
Weighted
Analysis Variable : OBXP97X SUM OF OBSF97X-OBOT97X (IMPUTED)
Sum
------------
938863539
------------
1 The SAS System 10:13 Friday, June 8, 2001
NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 6.12 TS025
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC, Site 0026405003.
1
2 OPTIONS LS=132 PS=59;
3
4 TITLE1 "HC-016I";
5 TITLE2 'Sample SAS Job for Example D';
6
7 LIBNAME IN 'D:\';
NOTE: Libref IN was successfully assigned as follows:
Engine: V603
Physical Name: D:\
8 **************************************************************************************
9 * Calculate the expenditures for prescribed medicines associated
10 * with insulin reported by the household as an other medical expense.
11 **************************************************************************************;
12
13 PROC FORMAT;
14 VALUE EVENTYPE
15 1 = "1 MVIS"
16 2 = "2 OPAT"
17 3 = "3 EROM"
18 4 = "4 STAZ"
19 5 = "5 DVIS"
20 6 = "6 OMED"
21 7 = "7 HVIS"
22 8 = "8 PMED";
NOTE: Format EVENTYPE has been output.
23
24 VALUE OMTYPE
25 -9 = '-9 NOT ASCERTAINED'
26 -8 = '-8 DK'
27 -7 = '-7 REFUSED'
28 -1 = '-1 INAPPLICABLE'
29 1 = '1 GLASSES OR CONTACT LENSES'
30 2 = '2 INSULIN'
31 3 = '3 DIABETIC EQUIPMENT/SUPPLIES'
32 4 = '4 AMBULANCE SERVICES'
33 5 = '5 ORTHOPEDIC ITEMS'
34 6 = '6 HEARING DEVICES'
35 7 = '7 PROSTHESIS'
36 8 = '8 BATHROOM AIDS'
37 9 = '9 MEDICAL EQUIPMENT'
38 10 = '10 DISPOSABLE SUPPLIES'
39 11 = '11 ALTERATIONS/MODIFICATIONS'
40 91 = '91 OTHER'
41 ;
NOTE: Format OMTYPE has been output.
42 RUN;
NOTE: The PROCEDURE FORMAT used 0.27 seconds.
2 The SAS System 10:13 Friday, June 8, 2001
43
44 *-------------------------------------------------------------------------------------
45 * Get other medical records for insulin for persons with positive weights.
46 *-------------------------------------------------------------------------------------;
47
48 DATA OMED;
49 SET IN.HC16CF1 (KEEP=EVNTIDX WTDPER97 OMTYPEX);
50 IF WTDPER97 > 0 & OMTYPEX = 2;
51 RUN;
NOTE: The data set WORK.OMED has 599 observations and 3 variables.
NOTE: The DATA statement used 1.37 seconds.
52
53 proc print data=omed (obs=100);
54 var evntidx OMTYPEX WTDPER97;
55 format OMTYPEX omtype.;
56 title3 "sample print of OMED (HC-016C) records where OMTYPEX=2";
57 run;
NOTE: The PROCEDURE PRINT printed pages 1-2.
NOTE: The PROCEDURE PRINT used 0.22 seconds.
58
59 *-------------------------------------------------------------------------------------
60 * Get PMED IDs linked to the OMED events which were for insulin.
61 *-------------------------------------------------------------------------------------;
62
63 PROC SORT DATA=IN.H16IF2 OUT=RXLK; BY EVNTIDX; RUN;
NOTE: The data set WORK.RXLK has 60020 observations and 5 variables.
NOTE: The PROCEDURE SORT used 6.04 seconds.
64
65 proc print data=rxlk (obs=150);
66 by evntidx;
67 id evntidx;
68 var linkidx eventype;
69 format eventype eventype.;
70 title3 "sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx";
71 run;
NOTE: The PROCEDURE PRINT printed pages 3-7.
NOTE: The PROCEDURE PRINT used 0.33 seconds.
72
73 data omedrxlk;
74 set rxlk (where=(eventype=6));
75 run;
NOTE: The data set WORK.OMEDRXLK has 1165 observations and 5 variables.
NOTE: The DATA statement used 1.05 seconds.
3 The SAS System 10:13 Friday, June 8, 2001
76 proc print data=omedrxlk (obs=120);
77 by evntidx;
78 id evntidx;
79 var linkidx eventype;
80 format eventype eventype.;
81 title3 "sample print of work.omedrxlk - sorted by eventidx";
82 title4 "Rx+event link file records (HC-16IF2) where eventype=6 (omed)";
83 run;
NOTE: The PROCEDURE PRINT printed pages 8-12.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
84
85 DATA PMEDIDS;
86 MERGE RXLK (IN=INRXLK KEEP=EVNTIDX LINKIDX EVENTYPE)
87 OMED (IN=INOMED KEEP=EVNTIDX);
88 BY EVNTIDX;
89 IF INRXLK & INOMED;
90 RUN;
NOTE: The data set WORK.PMEDIDS has 575 observations and 3 variables.
NOTE: The DATA statement used 0.93 seconds.
91
92 proc print data=pmedids (obs=50);
93 by evntidx;
94 id evntidx;
95 format eventype eventype.;
96 title3 "sample print of work.pmedids - sorted by evntidx";
97 title4 "work.rxlk records for omed events for insulin";
98 run;
NOTE: The PROCEDURE PRINT printed pages 13-14.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
99
100 PROC SORT DATA=PMEDIDS; BY LINKIDX; RUN;
NOTE: The data set WORK.PMEDIDS has 575 observations and 3 variables.
NOTE: The PROCEDURE SORT used 0.05 seconds.
101
102 proc print data=pmedids (obs=50);
103 format eventype eventype.;
104 title3 "sample print of work.pmedids - sorted by linkidx";
105 run;
NOTE: The PROCEDURE PRINT printed page 15.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
106
4 The SAS System 10:13 Friday, June 8, 2001
107 DATA PMEDIDS;
108 SET PMEDIDS (KEEP=LINKIDX);
109 BY LINKIDX;
110 IF FIRST.LINKIDX;
111 KEEP LINKIDX;
112 RUN;
NOTE: The data set WORK.PMEDIDS has 575 observations and 1 variables.
NOTE: The DATA statement used 0.22 seconds.
113
114 proc print data=pmedids (obs=50);
115 title3 "sample print of unique linkidxs in work.pmedids";
116 run;
NOTE: The PROCEDURE PRINT printed page 16.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
117
118
119 *------------------------------------------------------------------------------------
120 * Get PMED records for OMED event which were for insulin.
121 *------------------------------------------------------------------------------------;
122 PROC SORT DATA=IN.H16A OUT=PMED; BY LINKIDX; RUN;
NOTE: The data set WORK.PMED has 234532 observations and 54 variables.
NOTE: The PROCEDURE SORT used 1 minute 49.29 seconds.
123
124 DATA OMPMEDS;
125 MERGE PMED (KEEP=LINKIDX RXRECIDX RXXP97X WTDPER97 RXNAME)
126 PMEDIDS (IN=A);
127 BY LINKIDX;
128 IF A & WTDPER97>0;
129 RUN;
NOTE: The data set WORK.OMPMEDS has 2154 observations and 5 variables.
NOTE: The DATA statement used 26.53 seconds.
130
131 proc print data=ompmeds (obs=200);
132 by linkidx;
133 id linkidx;
134 var rxrecidx rxname RXXP97X WTDPER97;
135 title3 "sample print of work.pmeds";
136 title4 "PMED (HC-016A) records for unique linkidxs in work.pmedids";
137 run;
NOTE: The PROCEDURE PRINT printed pages 17-22.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
138
5 The SAS System 10:13 Friday, June 8, 2001
139 PROC MEANS DATA=OMPMEDS N SUM;
140 VAR RXXP97X;
141 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
142 RUN;
NOTE: The PROCEDURE MEANS printed page 23.
NOTE: The PROCEDURE MEANS used 0.17 seconds.
143
144 PROC MEANS DATA=OMPMEDS N SUM;
145 VAR RXXP97X;
146 WEIGHT WTDPER97;
147 TITLE3 "Total Rx expenditures associated with other medical expenses for insulin";
148 TITLE5 "Weighted";
149 RUN;
NOTE: The PROCEDURE MEANS printed page 24.
NOTE: The PROCEDURE MEANS used 0.0 seconds.
150
151
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
HC-016I 10:13 Friday, June 8, 2001 1
Sample SAS Job for Example D
sample print of OMED (HC-016C) records where OMTYPEX=2
OBS EVNTIDX OMTYPEX WTDPER97
1 000060180276 2 INSULIN 2886.87
2 000320280256 2 INSULIN 9715.75
3 000650110886 2 INSULIN 9499.40
4 000650111132 2 INSULIN 9499.40
5 001130170407 2 INSULIN 5775.05
6 001420270418 2 INSULIN 7922.72
7 001420270449 2 INSULIN 7922.72
8 001650120269 2 INSULIN 7062.68
9 001650120536 2 INSULIN 7062.68
10 001990260441 2 INSULIN 6143.05
11 003080260157 2 INSULIN 8317.81
12 003080260188 2 INSULIN 8317.81
13 003280130531 2 INSULIN 6051.64
14 003280130853 2 INSULIN 6051.64
15 003750110183 2 INSULIN 1776.96
16 003910200251 2 INSULIN 5012.96
17 003910200340 2 INSULIN 5012.96
18 004430180473 2 INSULIN 6467.89
19 004430180668 2 INSULIN 6467.89
20 004560270131 2 INSULIN 2994.87
21 004710120119 2 INSULIN 12418.25
22 004710120188 2 INSULIN 12418.25
23 004710120291 2 INSULIN 12418.25
24 004710290099 2 INSULIN 6252.84
25 004710290171 2 INSULIN 6252.84
26 004880240473 2 INSULIN 6885.96
27 004880240579 2 INSULIN 6885.96
28 004980171030 2 INSULIN 11061.77
29 006930160222 2 INSULIN 2705.97
30 006930160417 2 INSULIN 2705.97
31 007080180658 2 INSULIN 8486.02
32 007170110094 2 INSULIN 4239.57
33 007440120775 2 INSULIN 3755.10
34 007900110090 2 INSULIN 13117.47
35 007920190286 2 INSULIN 5860.25
36 008040200136 2 INSULIN 3099.07
37 008310250237 2 INSULIN 7363.37
38 008690140533 2 INSULIN 7049.45
39 008690140622 2 INSULIN 7049.45
40 008850290309 2 INSULIN 5816.85
41 009640240385 2 INSULIN 11260.52
42 009640240614 2 INSULIN 11260.52
43 010030150219 2 INSULIN 3209.30
44 010360120854 2 INSULIN 15029.21
45 010790190792 2 INSULIN 6185.94
46 010790190963 2 INSULIN 6185.94
47 010860180210 2 INSULIN 6115.77
48 010950150157 2 INSULIN 2157.55
49 012070100454 2 INSULIN 3755.07
50 012260100170 2 INSULIN 9896.89
51 012670240156 2 INSULIN 1495.78
52 013290160256 2 INSULIN 7388.94
53 013290160352 2 INSULIN 7388.94
HC-016I 10:13 Friday, June 8, 2001 2
Sample SAS Job for Example D
sample print of OMED (HC-016C) records where OMTYPEX=2
OBS EVNTIDX OMTYPEX WTDPER97
54 013540110348 2 INSULIN 7671.79
55 013540110451 2 INSULIN 7671.79
56 013540110742 2 INSULIN 7671.79
57 013620180718 2 INSULIN 5357.54
58 013680140359 2 INSULIN 2596.00
59 013680140424 2 INSULIN 2596.00
60 013840110521 2 INSULIN 14168.60
61 014330100368 2 INSULIN 6439.33
62 014330100464 2 INSULIN 6439.33
63 015900180808 2 INSULIN 7385.89
64 015900180891 2 INSULIN 7385.89
65 016160131063 2 INSULIN 3241.90
66 016350200373 2 INSULIN 1965.33
67 016350200640 2 INSULIN 1965.33
68 016390330445 2 INSULIN 3112.24
69 016520480077 2 INSULIN 6722.22
70 016860270712 2 INSULIN 7051.02
71 017550200330 2 INSULIN 7507.19
72 017550200385 2 INSULIN 7507.19
73 017770100509 2 INSULIN 5243.27
74 017770100674 2 INSULIN 5243.27
75 018350120155 2 INSULIN 1852.38
76 018650133570 2 INSULIN 2002.43
77 018650133830 2 INSULIN 2002.43
78 018900290189 2 INSULIN 7783.39
79 018900290209 2 INSULIN 7783.39
80 019090260187 2 INSULIN 11676.01
81 019140190294 2 INSULIN 1659.06
82 019580120399 2 INSULIN 4039.58
83 019580120700 2 INSULIN 4039.58
84 020520130250 2 INSULIN 8390.90
85 020520130394 2 INSULIN 8390.90
86 020520130534 2 INSULIN 8390.90
87 020750120221 2 INSULIN 1936.85
88 020750120310 2 INSULIN 1936.85
89 021040110380 2 INSULIN 6060.77
90 021040110602 2 INSULIN 6060.77
91 022720300498 2 INSULIN 4998.57
92 022860230558 2 INSULIN 6461.53
93 022910170168 2 INSULIN 2116.91
94 022910170202 2 INSULIN 2116.91
95 023170240696 2 INSULIN 6136.92
96 023180210319 2 INSULIN 3316.31
97 023420120390 2 INSULIN 3493.68
98 023420120554 2 INSULIN 3493.68
99 024840170639 2 INSULIN 9344.85
100 025450260612 2 INSULIN 16468.14
HC-016I 10:13 Friday, June 8, 2001 3
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
000020250058 000020250065 1 MVIS
000020320065 000020320072 1 MVIS
000020320109 000020320116 1 MVIS
000020490161 000020490178 1 MVIS
000030220550 000030220567 4 STAZ
000030220574 4 STAZ
000030220581 4 STAZ
000030220598 4 STAZ
000040550013 000040550020 2 OPAT
000050110120 000050110151 1 MVIS
000050110226 000050110257 1 MVIS
000050170333 000050170460 3 EROM
000050170477 3 EROM
000050170408 000050170484 1 MVIS
000050170580 000050170768 1 MVIS
000050170597 000050170775 1 MVIS
000050170782 1 MVIS
000050170648 000050170768 2 OPAT
000050170655 000050170768 2 OPAT
000050170693 000050170799 1 MVIS
000050170720 000050170802 1 MVIS
000050170819 1 MVIS
000050170737 000050170826 1 MVIS
000050170833 1 MVIS
000050170744 000050170840 1 MVIS
000050170857 1 MVIS
000050170751 000050170864 3 EROM
000050171069 000050171103 1 MVIS
000050171110 1 MVIS
000050171127 1 MVIS
HC-016I 10:13 Friday, June 8, 2001 4
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
000050240100 000050240148 3 EROM
000050240155 000050240179 1 MVIS
000050240162 000050240186 5 DVIS
000050240193 000050240213 1 MVIS
000050240220 1 MVIS
000050240206 000050240237 1 MVIS
000050310042 000050310059 1 MVIS
000050310066 000050310148 1 MVIS
000050310131 000050310148 2 OPAT
000050310155 2 OPAT
000050310162 2 OPAT
000050480011 000050480028 1 MVIS
000050480035 1 MVIS
000050480059 000050480073 1 MVIS
000050480066 000050480080 1 MVIS
000050480097 1 MVIS
000060180163 000060180290 4 STAZ
000060180303 4 STAZ
000060180310 4 STAZ
000060180327 4 STAZ
000060180334 4 STAZ
000060180170 000060180303 4 STAZ
000060180310 4 STAZ
000060180327 4 STAZ
000060180334 4 STAZ
000060180252 000060180269 6 OMED
000060180276 000060180283 6 OMED
000060180341 000060180512 1 MVIS
000060180529 1 MVIS
000060180536 1 MVIS
000060180492 000060180505 6 OMED
000070240264 000070240315 1 MVIS
000070240322 1 MVIS
HC-016I 10:13 Friday, June 8, 2001 5
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
000070240264 000070240339 1 MVIS
000070240346 1 MVIS
000070240353 1 MVIS
000070240360 1 MVIS
000100150357 000100150395 5 DVIS
000100150408 5 DVIS
000100150422 000100150460 1 MVIS
000100150439 000100150477 1 MVIS
000100150484 1 MVIS
000100150446 000100150477 1 MVIS
000100150484 1 MVIS
000100150491 1 MVIS
000100150511 000100150528 6 OMED
000100220213 000100220244 1 MVIS
000100220251 1 MVIS
000100220268 1 MVIS
000100220275 1 MVIS
000100220299 000100220319 1 MVIS
000100220326 1 MVIS
000100220333 1 MVIS
000100220340 1 MVIS
000100220357 1 MVIS
000100220364 1 MVIS
000100220302 000100220326 1 MVIS
000100220340 1 MVIS
000100220364 1 MVIS
000110110093 000110110120 1 MVIS
000110110137 000110110315 1 MVIS
000110110271 000110110322 1 MVIS
000110110295 000110110322 2 OPAT
000110120129 000110120218 1 MVIS
000110290174 000110290181 5 DVIS
000120190069 000120190083 3 EROM
000120190090 3 EROM
HC-016I 10:13 Friday, June 8, 2001 6
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
000120260045 000120260052 4 STAZ
000120260069 4 STAZ
000120260076 4 STAZ
000130190362 000130190468 1 MVIS
000130190475 000130190468 1 MVIS
000130190622 000130190677 1 MVIS
000130190684 1 MVIS
000150220386 000150220502 3 EROM
000150220519 3 EROM
000180730041 000180730089 2 OPAT
000200110211 000200110204 1 MVIS
000200280184 000200280191 3 EROM
000200280204 3 EROM
000200350160 000200350386 5 DVIS
000200350184 000200350393 1 MVIS
000200350204 000200350413 1 MVIS
000200350211 000200350420 3 EROM
000200350242 000200350437 1 MVIS
000200350300 000200350444 1 MVIS
000200350475 1 MVIS
000200350348 000200350482 1 MVIS
000200350355 000200350499 1 MVIS
000200350406 000200350413 1 MVIS
000200350526 000200350595 1 MVIS
000200350557 000200350608 1 MVIS
000230160229 000230160243 1 MVIS
000230160250 1 MVIS
000230230072 000230230089 1 MVIS
000240120016 000240120136 1 MVIS
HC-016I 10:13 Friday, June 8, 2001 7
Sample SAS Job for Example D
sample print of Rx+event link file records (HC-10IF2) - sorted by eventidx
EVNTIDX LINKIDX EVENTYPE
000240120016 000240120143 1 MVIS
000240120150 1 MVIS
000240120167 1 MVIS
000240120174 1 MVIS
000240120181 1 MVIS
000240120085 000240120198 1 MVIS
000240120105 000240120198 1 MVIS
000240120129 000240120136 4 STAZ
000240120143 4 STAZ
000240130104 000240130111 6 OMED
000240370015 000240370022 1 MVIS
000240370039 1 MVIS
000310100133 000310100157 3 EROM
000310100164 000310100171 1 MVIS
000310100188 1 MVIS
000310230120 000310230144 1 MVIS
000310230151 000310230168 1 MVIS
000320280105 000320280112 1 MVIS
000320280256 000320280263 6 OMED
000320280270 000320280287 6 OMED
000340100216 000340100261 1 MVIS
000340100223 000340100278 4 STAZ
000340100285 4 STAZ
000340100230 000340100292 2 OPAT
HC-016I 10:13 Friday, June 8, 2001 8
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-16IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
000060180252 000060180269 6 OMED
000060180276 000060180283 6 OMED
000060180492 000060180505 6 OMED
000100150511 000100150528 6 OMED
000240130104 000240130111 6 OMED
000320280256 000320280263 6 OMED
000320280270 000320280287 6 OMED
000430190326 000430190333 6 OMED
000460110671 000460110688 6 OMED
000650110886 000650110893 6 OMED
000650111132 000650111149 6 OMED
000650111156 000650111163 6 OMED
000920100399 000920100402 6 OMED
001130170407 001130170414 6 OMED
001130170421 001130170438 6 OMED
001280210174 001280210181 6 OMED
001420270418 001420270425 6 OMED
001420270449 001420270456 6 OMED
001420270463 001420270470 6 OMED
001650120269 001650120276 6 OMED
001650120536 001650120543 6 OMED
001650120550 001650120567 6 OMED
001990260441 001990260458 6 OMED
003080260157 003080260164 6 OMED
003080260188 003080260195 6 OMED
HC-016I 10:13 Friday, June 8, 2001 9
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-16IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
003080260208 003080260215 6 OMED
003280130531 003280130548 6 OMED
003280130651 003280130668 6 OMED
003280130853 003280130860 6 OMED
003280130877 003280130884 6 OMED
003300180273 003300180280 6 OMED
003300180297 003300180300 6 OMED
003440190118 003440190125 6 OMED
003440190194 003440190207 6 OMED
003750110183 003750110190 6 OMED
003910200251 003910200268 6 OMED
003910200340 003910200357 6 OMED
003910200364 003910200371 6 OMED
003970160492 003970160505 6 OMED
004430180473 004430180480 6 OMED
004430180668 004430180675 6 OMED
004430180808 004430180815 6 OMED
004560270131 004560270148 6 OMED
004710120119 004710120126 6 OMED
004710120133 004710120140 6 OMED
004710120188 004710120195 6 OMED
004710120291 004710120304 6 OMED
004710120311 004710120328 6 OMED
004710290099 004710290102 6 OMED
004710290119 004710290126 6 OMED
HC-016I 10:13 Friday, June 8, 2001 10
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-16IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
004710290171 004710290188 6 OMED
004710290253 004710290260 6 OMED
004880240473 004880240480 6 OMED
004880240531 004880240548 6 OMED
004880240579 004880240586 6 OMED
004980171030 004980171047 6 OMED
004980171338 004980171345 6 OMED
006030180350 006030180367 6 OMED
006930160222 006930160239 6 OMED
006930160417 006930160424 6 OMED
006930160431 006930160448 6 OMED
007080180658 007080180665 6 OMED
007170110094 007170110107 6 OMED
007170110114 007170110121 6 OMED
007440120775 007440120782 6 OMED
007440120799 007440120802 6 OMED
007900110090 007900110103 6 OMED
007900110110 007900110127 6 OMED
007920190286 007920190293 6 OMED
008040200136 008040200143 6 OMED
008040200150 008040200167 6 OMED
008310250237 008310250244 6 OMED
008690140533 008690140540 6 OMED
008690140622 008690140639 6 OMED
008850290309 008850290316 6 OMED
HC-016I 10:13 Friday, June 8, 2001 11
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-16IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
008850290323 008850290330 6 OMED
009640240614 009640240621 6 OMED
010030150219 010030150226 6 OMED
010230140886 010230140893 6 OMED
010360120854 010360120861 6 OMED
010360120878 010360120885 6 OMED
010790190792 010790190805 6 OMED
010790190963 010790190970 6 OMED
010790190987 010790190994 6 OMED
010860180210 010860180227 6 OMED
010860180525 010860180532 6 OMED
010950150157 010950150164 6 OMED
011510200461 011510200478 6 OMED
012070100454 012070100461 6 OMED
012070100601 012070100618 6 OMED
012200270294 012200270307 6 OMED
012260100156 012260100163 6 OMED
012670240156 012670240163 6 OMED
012670240170 012670240187 6 OMED
013290160256 013290160263 6 OMED
013290160352 013290160369 6 OMED
013540110348 013540110355 6 OMED
013540110451 013540110468 6 OMED
013540110475 013540110482 6 OMED
013540110742 013540110759 6 OMED
HC-016I 10:13 Friday, June 8, 2001 12
Sample SAS Job for Example D
sample print of work.omedrxlk - sorted by eventidx
Rx+event link file records (HC-16IF2) where eventype=6 (omed)
EVNTIDX LINKIDX EVENTYPE
013540110766 013540110773 6 OMED
013620180612 013620180629 6 OMED
013680140359 013680140366 6 OMED
013680140424 013680140431 6 OMED
013680140448 013680140455 6 OMED
013840110521 013840110538 6 OMED
013840110583 013840110590 6 OMED
013940160090 013940160103 6 OMED
014330100368 014330100375 6 OMED
014330100464 014330100471 6 OMED
014330100488 014330100495 6 OMED
015900180808 015900180815 6 OMED
015900180891 015900180904 6 OMED
015900180911 015900180928 6 OMED
016160131063 016160131070 6 OMED
016160131087 016160131094 6 OMED
016350200373 016350200380 6 OMED
016350200640 016350200657 6 OMED
016350200664 016350200671 6 OMED
016390330445 016390330452 6 OMED
HC-016I 10:13 Friday, June 8, 2001 13
Sample SAS Job for Example D
sample print of work.pmedids - sorted by evntidx
work.rxlk records for omed events for insulin
EVNTIDX LINKIDX EVENTYPE
000060180276 000060180283 6 OMED
000320280256 000320280263 6 OMED
000650110886 000650110893 6 OMED
000650111132 000650111149 6 OMED
001130170407 001130170414 6 OMED
001420270418 001420270425 6 OMED
001420270449 001420270456 6 OMED
001650120269 001650120276 6 OMED
001650120536 001650120543 6 OMED
001990260441 001990260458 6 OMED
003080260157 003080260164 6 OMED
003080260188 003080260195 6 OMED
003280130531 003280130548 6 OMED
003280130853 003280130860 6 OMED
003750110183 003750110190 6 OMED
003910200251 003910200268 6 OMED
003910200340 003910200357 6 OMED
004430180473 004430180480 6 OMED
004430180668 004430180675 6 OMED
004560270131 004560270148 6 OMED
004710120119 004710120126 6 OMED
004710120188 004710120195 6 OMED
004710120291 004710120304 6 OMED
004710290099 004710290102 6 OMED
004710290171 004710290188 6 OMED
HC-016I 10:13 Friday, June 8, 2001 14
Sample SAS Job for Example D
sample print of work.pmedids - sorted by evntidx
work.rxlk records for omed events for insulin
EVNTIDX LINKIDX EVENTYPE
004880240473 004880240480 6 OMED
004880240579 004880240586 6 OMED
004980171030 004980171047 6 OMED
006930160222 006930160239 6 OMED
006930160417 006930160424 6 OMED
007080180658 007080180665 6 OMED
007170110094 007170110107 6 OMED
007440120775 007440120782 6 OMED
007900110090 007900110103 6 OMED
007920190286 007920190293 6 OMED
008040200136 008040200143 6 OMED
008310250237 008310250244 6 OMED
008690140533 008690140540 6 OMED
008690140622 008690140639 6 OMED
008850290309 008850290316 6 OMED
009640240614 009640240621 6 OMED
010030150219 010030150226 6 OMED
010360120854 010360120861 6 OMED
010790190792 010790190805 6 OMED
010790190963 010790190970 6 OMED
010860180210 010860180227 6 OMED
010950150157 010950150164 6 OMED
012070100454 012070100461 6 OMED
012670240156 012670240163 6 OMED
013290160256 013290160263 6 OMED
HC-016I 10:13 Friday, June 8, 2001 15
Sample SAS Job for Example D
sample print of work.pmedids - sorted by linkidx
OBS EVNTIDX LINKIDX EVENTYPE
1 000060180276 000060180283 6 OMED
2 000320280256 000320280263 6 OMED
3 000650110886 000650110893 6 OMED
4 000650111132 000650111149 6 OMED
5 001130170407 001130170414 6 OMED
6 001420270418 001420270425 6 OMED
7 001420270449 001420270456 6 OMED
8 001650120269 001650120276 6 OMED
9 001650120536 001650120543 6 OMED
10 001990260441 001990260458 6 OMED
11 003080260157 003080260164 6 OMED
12 003080260188 003080260195 6 OMED
13 003280130531 003280130548 6 OMED
14 003280130853 003280130860 6 OMED
15 003750110183 003750110190 6 OMED
16 003910200251 003910200268 6 OMED
17 003910200340 003910200357 6 OMED
18 004430180473 004430180480 6 OMED
19 004430180668 004430180675 6 OMED
20 004560270131 004560270148 6 OMED
21 004710120119 004710120126 6 OMED
22 004710120188 004710120195 6 OMED
23 004710120291 004710120304 6 OMED
24 004710290099 004710290102 6 OMED
25 004710290171 004710290188 6 OMED
26 004880240473 004880240480 6 OMED
27 004880240579 004880240586 6 OMED
28 004980171030 004980171047 6 OMED
29 006930160222 006930160239 6 OMED
30 006930160417 006930160424 6 OMED
31 007080180658 007080180665 6 OMED
32 007170110094 007170110107 6 OMED
33 007440120775 007440120782 6 OMED
34 007900110090 007900110103 6 OMED
35 007920190286 007920190293 6 OMED
36 008040200136 008040200143 6 OMED
37 008310250237 008310250244 6 OMED
38 008690140533 008690140540 6 OMED
39 008690140622 008690140639 6 OMED
40 008850290309 008850290316 6 OMED
41 009640240614 009640240621 6 OMED
42 010030150219 010030150226 6 OMED
43 010360120854 010360120861 6 OMED
44 010790190792 010790190805 6 OMED
45 010790190963 010790190970 6 OMED
46 010860180210 010860180227 6 OMED
47 010950150157 010950150164 6 OMED
48 012070100454 012070100461 6 OMED
49 012670240156 012670240163 6 OMED
50 013290160256 013290160263 6 OMED
HC-016I 10:13 Friday, June 8, 2001 16
Sample SAS Job for Example D
sample print of unique linkidxs in work.pmedids
OBS LINKIDX
1 000060180283
2 000320280263
3 000650110893
4 000650111149
5 001130170414
6 001420270425
7 001420270456
8 001650120276
9 001650120543
10 001990260458
11 003080260164
12 003080260195
13 003280130548
14 003280130860
15 003750110190
16 003910200268
17 003910200357
18 004430180480
19 004430180675
20 004560270148
21 004710120126
22 004710120195
23 004710120304
24 004710290102
25 004710290188
26 004880240480
27 004880240586
28 004980171047
29 006930160239
30 006930160424
31 007080180665
32 007170110107
33 007440120782
34 007900110103
35 007920190293
36 008040200143
37 008310250244
38 008690140540
39 008690140639
40 008850290316
41 009640240621
42 010030150226
43 010360120861
44 010790190805
45 010790190970
46 010860180227
47 010950150164
48 012070100461
49 012670240163
50 013290160263
HC-016I 10:13 Friday, June 8, 2001 17
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
000060180283 000060180283001 REGULAR INSULIN 18.03 2886.87
000320280263 000320280263001 L- REG INSULIN 24.94 9715.75
000320280263002 L- REG INSULIN 24.94 9715.75
000320280263003 L- REG INSULIN 24.94 9715.75
000320280263004 L- REG INSULIN 24.94 9715.75
000650110893 000650110893001 HUMULIN N 19.84 9499.40
000650110893002 HUMULIN N 19.84 9499.40
000650110893003 HUMULIN N 19.84 9499.40
000650110893004 HUMULIN N 19.84 9499.40
000650110893005 HUMULIN N 19.84 9499.40
000650110893006 HUMULIN N 19.84 9499.40
000650110893007 HUMULIN N 19.84 9499.40
000650111149 000650111149001 HUMULIN R 19.84 9499.40
000650111149002 HUMULIN R 19.84 9499.40
000650111149003 HUMULIN R 19.84 9499.40
001130170414 001130170414001 L- REG INSULIN 24.94 5775.05
001420270425 001420270425001 REGULAR INSULIN 18.03 7922.72
001420270425002 REGULAR INSULIN 18.03 7922.72
001420270425003 REGULAR INSULIN 18.03 7922.72
001420270425004 REGULAR INSULIN 18.03 7922.72
001420270456 001420270456001 REGULAR INSULIN 18.03 7922.72
001650120276 001650120276001 L- REG INSULIN 24.94 7062.68
001650120276002 L- REG INSULIN 24.94 7062.68
001650120276003 L- REG INSULIN 24.94 7062.68
001650120276004 L- REG INSULIN 24.94 7062.68
001650120276005 L- REG INSULIN 24.94 7062.68
001650120276006 L- REG INSULIN 24.94 7062.68
001650120543 001650120543001 REGULAR INSULIN 18.03 7062.68
001650120543002 REGULAR INSULIN 18.03 7062.68
001650120543003 REGULAR INSULIN 18.03 7062.68
001650120543004 REGULAR INSULIN 18.03 7062.68
001990260458 001990260458001 L- REG INSULIN 24.94 6143.05
001990260458002 L- REG INSULIN 24.94 6143.05
001990260458003 L- REG INSULIN 24.94 6143.05
001990260458004 L- REG INSULIN 24.94 6143.05
001990260458005 L- REG INSULIN 24.94 6143.05
001990260458006 L- REG INSULIN 24.94 6143.05
001990260458007 L- REG INSULIN 24.94 6143.05
003080260164 003080260164001 REGULAR INSULIN 18.03 8317.81
HC-016I 10:13 Friday, June 8, 2001 18
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
003080260164 003080260164002 REGULAR INSULIN 18.03 8317.81
003080260164003 REGULAR INSULIN 18.03 8317.81
003080260164004 REGULAR INSULIN 18.03 8317.81
003080260164005 REGULAR INSULIN 18.03 8317.81
003080260164006 REGULAR INSULIN 18.03 8317.81
003080260195 003080260195001 L- REG INSULIN 24.94 8317.81
003080260195002 L- REG INSULIN 24.94 8317.81
003280130548 003280130548001 L- REG INSULIN 24.94 6051.64
003280130548002 L- REG INSULIN 24.94 6051.64
003280130548003 L- REG INSULIN 24.94 6051.64
003280130548004 L- REG INSULIN 24.94 6051.64
003280130548005 L- REG INSULIN 24.94 6051.64
003280130548006 L- REG INSULIN 24.94 6051.64
003280130548007 L- REG INSULIN 24.94 6051.64
003280130548008 L- REG INSULIN 24.94 6051.64
003280130548009 L- REG INSULIN 24.94 6051.64
003280130548010 L- REG INSULIN 24.94 6051.64
003280130548011 L- REG INSULIN 24.94 6051.64
003280130548012 L- REG INSULIN 24.94 6051.64
003280130548013 L- REG INSULIN 24.94 6051.64
003280130548014 L- REG INSULIN 24.94 6051.64
003280130548015 L- REG INSULIN 24.94 6051.64
003280130548016 L- REG INSULIN 24.94 6051.64
003280130860 003280130860001 L- REG INSULIN 24.94 6051.64
003750110190 003750110190001 L- REG INSULIN 24.94 1776.96
003750110190002 L- REG INSULIN 24.94 1776.96
003910200268 003910200268001 L- REG INSULIN 24.94 5012.96
003910200268002 L- REG INSULIN 24.94 5012.96
003910200268003 L- REG INSULIN 24.94 5012.96
003910200268004 L- REG INSULIN 24.94 5012.96
003910200357 003910200357001 L- REG INSULIN 24.94 5012.96
003910200357002 L- REG INSULIN 24.94 5012.96
004430180480 004430180480001 HUMULIN R 17.11 6467.89
004430180675 004430180675001 HUMULIN R 34.99 6467.89
004430180675002 HUMULIN R 34.99 6467.89
004430180675003 HUMULIN R 35.10 6467.89
004430180675004 HUMULIN R 35.10 6467.89
004430180675005 HUMULIN R 35.10 6467.89
004430180675006 HUMULIN R 35.10 6467.89
004560270148 004560270148001 L- REG INSULIN 24.94 2994.87
HC-016I 10:13 Friday, June 8, 2001 19
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
004560270148 004560270148002 L- REG INSULIN 24.94 2994.87
004560270148003 L- REG INSULIN 24.94 2994.87
004560270148004 L- REG INSULIN 24.94 2994.87
004710120126 004710120126001 L- REG INSULIN 24.94 12418.25
004710120126002 L- REG INSULIN 24.94 12418.25
004710120195 004710120195001 L- REG INSULIN 24.94 12418.25
004710120195002 L- REG INSULIN 24.94 12418.25
004710120195003 L- REG INSULIN 24.94 12418.25
004710120195004 L- REG INSULIN 24.94 12418.25
004710120195005 L- REG INSULIN 24.94 12418.25
004710120304 004710120304001 L- REG INSULIN 24.94 12418.25
004710120304002 L- REG INSULIN 24.94 12418.25
004710120304003 L- REG INSULIN 24.94 12418.25
004710290102 004710290102001 L- REG INSULIN 24.94 6252.84
004710290188 004710290188001 L- REG INSULIN 24.94 6252.84
004710290188002 L- REG INSULIN 24.94 6252.84
004710290188003 L- REG INSULIN 24.94 6252.84
004710290188004 L- REG INSULIN 24.94 6252.84
004710290188005 L- REG INSULIN 24.94 6252.84
004880240480 004880240480001 L- REG INSULIN 24.94 6885.96
004880240480002 L- REG INSULIN 24.94 6885.96
004880240480003 L- REG INSULIN 24.94 6885.96
004880240480004 L- REG INSULIN 24.94 6885.96
004880240586 004880240586001 L- REG INSULIN 24.94 6885.96
004980171047 004980171047001 L- REG INSULIN 24.94 11061.77
004980171047002 L- REG INSULIN 24.94 11061.77
004980171047003 L- REG INSULIN 24.94 11061.77
004980171047004 L- REG INSULIN 24.94 11061.77
004980171047005 L- REG INSULIN 24.94 11061.77
006930160239 006930160239001 REGULAR INSULIN 18.03 2705.97
006930160239002 REGULAR INSULIN 18.03 2705.97
006930160239003 REGULAR INSULIN 18.03 2705.97
006930160239004 REGULAR INSULIN 18.03 2705.97
006930160239005 REGULAR INSULIN 18.03 2705.97
006930160424 006930160424001 HUMULIN 70/30 35.18 2705.97
006930160424002 HUMULIN 70/30 35.18 2705.97
006930160424003 HUMULIN 70/30 35.18 2705.97
007080180665 007080180665001 LIL REG U-100 19.71 8486.02
HC-016I 10:13 Friday, June 8, 2001 20
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
007080180665 007080180665002 LIL REG U-100 19.71 8486.02
007080180665003 LIL REG U-100 19.71 8486.02
007080180665004 LIL REG U-100 19.71 8486.02
007080180665005 LIL REG U-100 19.71 8486.02
007080180665006 LIL REG U-100 19.71 8486.02
007080180665007 LIL REG U-100 19.71 8486.02
007080180665008 LIL REG U-100 19.71 8486.02
007170110107 007170110107001 L- REG INSULIN 24.94 4239.57
007440120782 007440120782001 HUMULIN 70/30 79.36 3755.10
007900110103 007900110103001 L- REG INSULIN 24.94 13117.47
007900110103002 L- REG INSULIN 24.94 13117.47
007900110103003 L- REG INSULIN 24.94 13117.47
007900110103004 L- REG INSULIN 24.94 13117.47
007920190293 007920190293001 L- REG INSULIN 24.94 5860.25
007920190293002 L- REG INSULIN 24.94 5860.25
008040200143 008040200143001 L- REG INSULIN 24.94 3099.07
008040200143002 L- REG INSULIN 24.94 3099.07
008040200143003 L- REG INSULIN 24.94 3099.07
008310250244 008310250244001 NOVOLIN R 34.68 7363.37
008690140540 008690140540001 HUMULIN N 19.84 7049.45
008690140639 008690140639001 BD PLASTIPAK 119.04 7049.45
008690140639002 HUMULIN R 19.84 7049.45
008690140639003 BD PLASTIPAK 119.04 7049.45
008690140639004 BD PLASTIPAK 119.04 7049.45
008850290316 008850290316001 INSULIN NOVOLIN 70/30*10ML 56.79 5816.85
008850290316002 INSULIN NOVOLIN 70/30*10ML 56.79 5816.85
008850290316003 INSULIN NOVOLIN 70/30*10ML 56.79 5816.85
009640240621 009640240621001 REGULAR INSULIN 18.03 11260.52
009640240621002 REGULAR INSULIN 18.03 11260.52
009640240621003 REGULAR INSULIN 18.03 11260.52
009640240621004 REGULAR INSULIN 18.03 11260.52
009640240621005 REGULAR INSULIN 18.03 11260.52
009640240621006 REGULAR INSULIN 18.03 11260.52
009640240621007 REGULAR INSULIN 18.03 11260.52
009640240621008 REGULAR INSULIN 18.03 11260.52
009640240621009 REGULAR INSULIN 18.03 11260.52
010030150226 010030150226001 HUMULIN 70/30 39.68 3209.30
010030150226002 HUMULIN 70/30 39.68 3209.30
HC-016I 10:13 Friday, June 8, 2001 21
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
010030150226 010030150226003 HUMULIN 70/30 39.68 3209.30
010030150226004 HUMULIN 70/30 39.68 3209.30
010030150226005 HUMULIN 70/30 39.68 3209.30
010030150226006 HUMULIN 70/30 39.68 3209.30
010030150226007 HUMULIN 70/30 39.68 3209.30
010030150226008 HUMULIN 70/30 39.68 3209.30
010030150226009 HUMULIN 70/30 39.68 3209.30
010030150226010 HUMULIN 70/30 39.68 3209.30
010030150226011 HUMULIN 70/30 39.68 3209.30
010360120861 010360120861001 L- REG INSULIN 24.94 15029.21
010360120861002 L- REG INSULIN 24.94 15029.21
010360120861003 L- REG INSULIN 24.94 15029.21
010790190805 010790190805001 REGULAR INSULIN 18.03 6185.94
010790190970 010790190970001 REGULAR INSULIN 18.03 6185.94
010860180227 010860180227001 L- REG INSULIN 24.94 6115.77
010860180227002 L- REG INSULIN 24.94 6115.77
010950150164 010950150164001 L- REG INSULIN 24.94 2157.55
012070100461 012070100461001 REGULAR INSULIN 18.03 3755.07
012670240163 012670240163001 L- REG INSULIN 24.94 1495.78
012670240163002 L- REG INSULIN 24.94 1495.78
012670240163003 L- REG INSULIN 24.94 1495.78
012670240163004 L- REG INSULIN 24.94 1495.78
013290160263 013290160263001 REGULAR INSULIN 18.03 7388.94
013290160263002 REGULAR INSULIN 18.03 7388.94
013290160263003 REGULAR INSULIN 18.03 7388.94
013290160369 013290160369001 REGULAR INSULIN 18.03 7388.94
013540110355 013540110355001 NOVOLIN 70/30 20.49 7671.79
013540110355002 NOVOLIN 70/30 18.98 7671.79
013540110355003 NOVOLIN 70/30 20.49 7671.79
013540110468 013540110468001 NOVOLIN 70/30 20.49 7671.79
013540110468002 NOVOLIN 70/30 20.49 7671.79
013540110468003 NOVOLIN 70/30 20.49 7671.79
013540110468004 NOVOLIN 70/30 20.49 7671.79
013540110468005 NOVOLIN 70/30 20.49 7671.79
013540110759 013540110759001 NOVOLIN 70/30 18.98 7671.79
013540110759002 NOVOLIN 70/30 18.98 7671.79
013540110759003 NOVOLIN 70/30 18.98 7671.79
HC-016I 10:13 Friday, June 8, 2001 22
Sample SAS Job for Example D
sample print of work.pmeds
PMED (HC-016A) records for unique linkidxs in work.pmedids
LINKIDX RXRECIDX RXNAME RXXP97X WTDPER97
013680140366 013680140366001 HUMULIN N 42.35 2596.00
013680140431 013680140431001 L- REG INSULIN 24.94 2596.00
013680140431002 L- REG INSULIN 24.94 2596.00
013680140431003 L- REG INSULIN 24.94 2596.00
013840110538 013840110538001 REGULAR INSULIN 18.03 14168.60
013840110538002 REGULAR INSULIN 18.03 14168.60
014330100375 014330100375001 REGULAR INSULIN 18.03 6439.33
014330100375002 REGULAR INSULIN 18.03 6439.33
HC-016I 10:13 Friday, June 8, 2001 23
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
Analysis Variable : RXXP97X SUM OF PAYMENTS RXSF97X-RXOU97X(IMPUTED)
N Sum
------------------
2154 61021.41
------------------
HC-016I 10:13 Friday, June 8, 2001 24
Sample SAS Job for Example D
Total Rx expenditures associated with other medical expenses for insulin
Weighted
Analysis Variable : RXXP97X SUM OF PAYMENTS RXSF97X-RXOU97X(IMPUTED)
N Sum
------------------
2154 429352761
------------------
|