1 The SAS System 09:44 Wednesday, October 21, 2009
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to SY TRUONG, Site 0051884001.
NOTE: This session is executing on the XP_PRO platform.
NOTE: (E9BX04) SAS 9.1.3 SP 4
NOTE: SAS initialization used:
real time 0.65 seconds
cpu time 0.67 seconds
NOTE: AUTOEXEC processing beginning; file is C:\apache\htdocs\cdiscbuilder\saspgm\autoexec.sas.
NOTE: Libref _CDISC_ was successfully assigned as follows:
Engine: V9
Physical Name: C:\apache\htdocs\cdiscbuilder\saspgm
NOTE: AUTOEXEC processing completed.
1 /*------------------------------------------------------------*
2 * program: cdisc65.sas *
3 * Description: Case #65. Code List Found For All domains, this identifies records
3 ! where *
4 * values are not found in the study-specific codelist attached to a
4 ! variable.*
5 * By: Sy Truong, 10/14/2009 *
6 *-------------------------------------------------------------*/
7
8 libname templib '../data';
NOTE: Libref TEMPLIB was successfully assigned as follows:
Engine: V9
Physical Name: C:\apache\htdocs\cdiscbuilder\data
9
10 proc format library=work;
11 value $chtoch 'F' = 'Female'
12 'M' = 'Male'
13 ;
NOTE: Format $CHTOCH has been output.
14 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds
15
16 data templib.ae;
17 attrib STUDYID length=$7 label="Study Identifier";
18 attrib DOMAIN length=$2 label="Domain Abbreviation";
19 attrib USUBJID length=$14 label="Unique Subject Identifier";
2 The SAS System 09:44 Wednesday, October 21, 2009
20 attrib AESEQ length=8 label="Sequence Number";
21 attrib AETERM length=$25 label="Reported Term for the Adverse Event";
22 attrib AEMODIFY length=$9 label="Modified Reported Term";
23 attrib AEDECOD length=$18 label="Dictionary-Derived Term";
24 attrib AEBODSYS length=$52 label="Body System or Organ Class";
25 attrib AESEV length=$8 label="Severity/Intensity";
26 attrib AESER length=$1 label="Serious Event";
27 attrib AEACN length=$30 label="Action Taken with Study Treatment";
28 attrib AEREL length=$16 label="Causality";
29 attrib AECONTRT length=$1 label="Concomitant or Additional Trtmnt Given";
30 attrib AESTDTC length=$10 label="Start Date/Time of Adverse Event";
31 attrib AEENDTC length=$10 label="End Date/Time of Adverse Event";
32 attrib AESTDY length=8 label="Study Day of Start of Adverse Event";
33 attrib AEENDY length=8 label="Study Day of End of Adverse Event";
34 attrib AEENRF length=$5 label="End Relative to Reference Period";
35 attrib varcode length=$5 label="Variable has format code" format=$chtoch.;
36
37 STUDYID="CDISC01";
38 DOMAIN="AE";
39 USUBJID="CDISC01.100008";
40 AESEQ=1;
41 AETERM="AGITATED";
42 AEMODIFY="AGITATION";
43 AEDECOD="Agitation";
44 AEBODSYS="Psychiatric disorders";
45 AESEV="MILD";
46 AESER="N";
47 AEACN="DOSE NOT CHANGED";
48 AEREL="POSSIBLY RELATED";
49 AECONTRT="";
50 AESTDTC="2003-05";
51 AEENDTC="";
52 AESTDY=3;
53 AEENDY=.;
54 AEENRF="AFTER";
55 varcode='F';
56
57 output;
58 STUDYID="CDISC01";
59 DOMAIN="AE";
60 USUBJID="CDISC01.100008";
61 AESEQ=2;
62 AETERM="ANXIETY";
63 AEMODIFY="";
64 AEDECOD="Anxiety";
65 AEBODSYS="Psychiatric disorders";
66 AESEV="MODERATE";
67 AESER="N";
68 AEACN="DOSE NOT CHANGED";
69 AEREL="POSSIBLY RELATED";
70 AECONTRT="";
71 AESTDTC="2003-05-13";
72 AEENDTC="";
3 The SAS System 09:44 Wednesday, October 21, 2009
73 AESTDY=15;
74 AEENDY=.;
75 AEENRF="AFTER";
76 varcode='M';
77 output;
78 STUDYID="CDISC01";
79 DOMAIN="AE";
80 USUBJID="CDISC01.100008";
81 AESEQ=3;
82 AETERM="DECREASED APPETITE";
83 AEMODIFY="";
84 AEDECOD="Decreased appetite";
85 AEBODSYS="Metabolism and nutrition disorders";
86 AESEV="MILD";
87 AESER="N";
88 AEACN="DOSE NOT CHANGED";
89 AEREL="POSSIBLY RELATED";
90 AECONTRT="";
91 AESTDTC="2003-08-19";
92 AEENDTC="2003-09-15";
93 AESTDY=113;
94 AEENDY=140;
95 AEENRF="";
96 varcode="FM";
97 output;
98 STUDYID="CDISC01";
99 DOMAIN="AE";
100 USUBJID="CDISC01.100014";
101 AESEQ=1;
102 AETERM="DIARRHEA";
103 AEMODIFY="";
104 AEDECOD="Diarrhoea";
105 AEBODSYS="Gastrointestinal disorders";
106 AESEV="MILD";
107 AESER="N";
108 AEACN="DOSE NOT CHANGED";
109 AEREL="NOT RELATED";
110 AECONTRT="";
111 AESTDTC="2004-01-06";
112 AEENDTC="";
113 AESTDY=84;
114 AEENDY=.;
115 AEENRF="AFTER";
116 output;
117 run;
NOTE: The data set TEMPLIB.AE has 4 observations and 19 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds
118 %cdisc(datlib=templib,datname=ae);
4 The SAS System 09:44 Wednesday, October 21, 2009
119 data misobs(keep=obsnum);
120 retain obsnum 0;
121 set templib.ae(keep=STUDYID);
122 obsnum=obsnum+1;
123 if missing(STUDYID) then
124 output;
125 run;
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: The data set WORK.MISOBS has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
126 data misobs(keep=obsnum);
127 retain obsnum 0;
128 set templib.ae(keep=DOMAIN);
129 obsnum=obsnum+1;
130 if missing(DOMAIN) then
131 output;
132 run;
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: The data set WORK.MISOBS has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
133 data misobs(keep=obsnum);
134 retain obsnum 0;
135 set templib.ae(keep=USUBJID);
136 obsnum=obsnum+1;
137 if missing(USUBJID) then
138 output;
139 run;
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: The data set WORK.MISOBS has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
140 data misobs(keep=obsnum);
141 retain obsnum 0;
142 set templib.ae(keep=AESEQ);
143 obsnum=obsnum+1;
144 if missing(AESEQ) then
145 output;
146 run;
5 The SAS System 09:44 Wednesday, October 21, 2009
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: The data set WORK.MISOBS has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
147 data misobs(keep=obsnum);
148 retain obsnum 0;
149 set templib.ae(keep=AETERM);
150 obsnum=obsnum+1;
151 if missing(AETERM) then
152 output;
153 run;
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: The data set WORK.MISOBS has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
154 data misobs(keep=obsnum);
155 retain obsnum 0;
156 set templib.ae(keep=AEDECOD);
157 obsnum=obsnum+1;
158 if missing(AEDECOD) then
159 output;
160 run;
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: The data set WORK.MISOBS has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
161 data _23;
162 retain obsnum 0;
163 set templib.ae(keep=AETERM AEDECOD);
164 obsnum = obsnum + 1;
165 if AETERM ne '' and AEDECOD= '' then output;
166 run;
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: The data set WORK._23 has 0 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
167 data _29;
6 The SAS System 09:44 Wednesday, October 21, 2009
168 retain obsnum 0;
169 set templib.ae(keep=AESTDY AEENDY);
170 obsnum = obsnum + 1;
171 if AESTDY ne . and AEENDY ne . and AESTDY gt AEENDY then output;
172 run;
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: The data set WORK._29 has 0 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
173 data _30;
174 retain obsnum 0;
175 set templib.ae(keep=AESTDTC AEENDTC);
176 obsnum = obsnum + 1;
177 run;
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: The data set WORK._30 has 4 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
178 data _30;
179 set _30;
180 if AESTDTC ne "" and AEENDTC ne "" and input(AESTDTC,is8601da.) gt
180 ! input(AEENDTC,is8601da.) then output;
181 run;
NOTE: There were 2 observations read from the data set WORK._30.
NOTE: The data set WORK._30 has 0 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
182 data _33;
183 retain obsnum 0;
184 set templib.ae(keep=AEENRF);
185 obsnum = obsnum + 1;
186 if AEENRF ne '' and upcase(AEENRF) not in
186 ! ('','BEFORE','DURING','AFTER','DURING/AFTER','U') then output;
187 run;
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: The data set WORK._33 has 0 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
7 The SAS System 09:44 Wednesday, October 21, 2009
188 data _46;
189 retain obsnum 0;
190 set templib.ae(keep=AEENDTC AEENRF );
191 obsnum = obsnum + 1;
192 if AEENDTC = '' and AEENRF = '' then output;
193 run;
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: The data set WORK._46 has 0 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
194 proc sort data=templib.ae out=ae nodupkey;
195 by usubjid;
196 run;
NOTE: There were 4 observations read from the data set TEMPLIB.AE.
NOTE: 2 observations with duplicate key values were deleted.
NOTE: The data set WORK.AE has 2 observations and 19 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
NOTE: Table WORK._72 created, with 2 rows and 1 columns.
197 proc sort data=cdisc nodupkey;
198 by libname datname datlab variable length label type case comment;
199 run;
NOTE: There were 7 observations read from the data set WORK.CDISC.
NOTE: 0 observations with duplicate key values were deleted.
NOTE: The data set WORK.CDISC has 7 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
200 proc sort data = work.cdisc;
201 by libname datname datlab variable case;
202 run;
NOTE: There were 7 observations read from the data set WORK.CDISC.
NOTE: The data set WORK.CDISC has 7 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
203
8 The SAS System 09:44 Wednesday, October 21, 2009
204 proc format;
205 *** Generate the comments for the CDISC evaluation case number ***;
206 value $casefmt
207 '1' = '1'
208 '2' = '2'
209 '3' = '3'
210 '4' = '4'
211 '5' = '5'
212 '6' = '6'
213 '7' = '7'
214 '8' = '8'
215 '9' = '9'
216 '10' = '10'
217 '11' = '11'
218 '12' = '12'
219 '13' = '13'
220 '14' = '14'
221 '15' = '15'
222 '16' = '16'
223 '17' = '17'
224 '18' = '18'
225 '19' = '19'
226 '20' = '20'
227 '21' = '21'
228 '22' = '22'
229 '23' = '23'
230 '24' = '24'
231 '25' = '25'
232 '26' = '26'
233 '27' = '27'
234 '28' = '28'
235 '29' = '29'
236 '30' = '30'
237 '31' = '31'
238 '32' = '32'
239 '33' = '33'
240 '34' = '34'
241 '35' = '35'
242 '36' = '36'
243 '37' = '37'
244 '38' = '38'
245 '39' = '39'
246 '40' = '40'
247 '41' = '41'
248 '42' = '42'
249 '43' = '43'
250 '44' = '44'
251 '45' = '45'
252 '46' = '46'
253 '47' = '47'
254 '48' = '48'
255 '49' = '49'
256 '50' = '50'
9 The SAS System 09:44 Wednesday, October 21, 2009
257 '51' = '51'
258 '52' = '52'
259 '53' = '53'
260 '54' = '54'
261 '55' = '55'
262 '56' = '56'
263 '57' = '57'
264 '58' = '58'
265 '59' = '59'
266 '60' = '60'
267 '61' = '61'
268 '62' = '62'
269 '63' = '63'
270 '64' = '64'
271 '65' = '65'
272 '66' = '66'
273 '67' = '67'
274 '68' = '68'
275 '69' = '69'
276 '70' = '70'
277 '71' = '71'
278 '72' = '72'
279 '73' = '73'
280 '74' = '74'
281 '75' = '75'
282 '76' = '76'
283 '77' = '77'
284 '78' = '78'
285 '79' = '79'
286 '80' = '80'
287 '81' = '81'
288 '82' = '82'
289 '83' = '83'
290 '84' = '84'
291 '85' = '85'
292 '86' = '86'
293 '87' = '87'
294 '88' = '88'
295 '89' = '89'
296 '90' = '90'
297 '91' = '91'
298 '92' = '92'
299 '93' = '93'
300 '94' = '94'
301 '95' = '95'
302 '96' = '96'
303 '97' = '97'
304 '98' = '98'
305 '99' = '99'
306 '100' = '100'
307 '101' = '101'
308 '102' = '102'
309 '103' = '103'
10 The SAS System 09:44 Wednesday, October 21, 2009
310 '104' = '104'
311 '105' = '105'
312 '106' = '106'
313 '107' = '107'
314 '108' = '108'
315 '109' = '109'
316 '110' = '110'
317 '111' = '111'
318 '112' = '112'
319 '113' = '113';
NOTE: Format $CASEFMT has been output.
320
321
322
323 *** Generate the format for the bookmark of variables ***;
324 value $bookfmt
325 "ae.studyid" = 'ae.studyid'
326 "ae.domain" = 'ae.domain'
327 "ae.usubjid" = 'ae.usubjid'
328 "ae.aeseq" = 'ae.aeseq'
329 "ae.aeterm" = 'ae.aeterm'
330 "ae.aemodify" = 'ae.aemodify'
331 "ae.aedecod" = 'ae.aedecod'
332 "ae.aebodsys" = 'ae.aebodsys'
333 "ae.aesev" = 'ae.aesev'
334 "ae.aeser" = 'ae.aeser'
335 "ae.aeacn" = 'ae.aeacn'
336 "ae.aerel" = 'ae.aerel'
337 "ae.aecontrt" = 'ae.aecontrt'
338 "ae.aestdtc" = 'ae.aestdtc'
339 "ae.aeendtc" = 'ae.aeendtc'
340 "ae.aestdy" = 'ae.aestdy'
341 "ae.aeendy" = 'ae.aeendy'
342 "ae.aeenrf" = 'ae.aeenrf'
343 "ae.varcode" = 'ae.varcode'
344 ;
NOTE: Format $BOOKFMT has been output.
345
346 *** Generate the format for dataset linking ***;
347 value $datfmt
348 "ae" = 'ae
'
349 "ae3a" = 'ae3a
'
350 "cdisc10" = 'cdisc10
'
351 "cdisc11" = 'cdisc11
'
352 "cdisc14" = 'cdisc14
'
353 "cdisc15" = 'cdisc15
'
354 "cdisc18" = 'cdisc18
'
355 "cdisc2" = 'cdisc2
'
356 "cdisc21" = 'cdisc21
'
357 "cdisc2b_1" = 'cdisc2b_1
'
358 "cdisc2b_2" = 'cdisc2b_2
'
359 "cdisc2b_3" = 'cdisc2b_3
'
360 "cdisc2_b" = 'cdisc2_b
'
11 The SAS System 09:44 Wednesday, October 21, 2009
361 "cdisc2_c" = 'cdisc2_c
'
362 "cdisc4" = 'cdisc4
'
363 "cdisc5" = 'cdisc5
'
364 "cdisc6" = 'cdisc6
'
365 "cdisc7" = 'cdisc7
'
366 "cdisc8" = 'cdisc8
'
367 "cdisc9" = 'cdisc9
'
368 "ce" = 'ce
'
369 "cm" = 'cm
'
370 "co" = 'co
'
371 "da" = 'da
'
372 "dm" = 'dm
'
373 "ds" = 'ds
'
374 "dv" = 'dv
'
375 "eg" = 'eg
'
376 "ex" = 'ex
'
377 "fa" = 'fa
'
378 "ie" = 'ie
'
379 "lb" = 'lb
'
380 "mb" = 'mb
'
381 "mh" = 'mh
'
382 "ms" = 'ms
'
383 "notdm" = 'notdm
'
384 "pc" = 'pc
'
385 "pe" = 'pe
'
386 "pp" = 'pp
'
387 "qs" = 'qs
'
388 "relrec" = 'relrec
'
389 "sc" = 'sc
'
390 "se" = 'se
'
391 "su" = 'su
'
392 "supmh" = 'supmh
'
393 "suppae" = 'suppae
'
394 "suppp" = 'suppp
'
395 "supte" = 'supte
'
396 "supvs" = 'supvs
'
397 "sv" = 'sv
'
398 "ta" = 'ta
'
399 "te" = 'te
'
400 "ti" = 'ti
'
401 "ts" = 'ts
'
402 "tv" = 'tv
'
403 "vs" = 'vs
'
404 ;
NOTE: Format $DATFMT has been output.
405 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
406
12 The SAS System 09:44 Wednesday, October 21, 2009
407 data work.cdisc;
408 set work.cdisc;
409 by libname datname datlab variable case;
410
411 attrib datvar label="Dataset and Variable" length=$100 format=$bookfmt.;
412 if variable ne '' then
413 datvar = compress(lowcase(datname) || "." || lowcase(variable));
414 else datvar = lowcase(datname);
415 /*format case casefmt.;*/
416 attrib charcase label = "Case Number" length = $10;
417 charcase = trim(left(put(case, best.)));
418 format charcase $casefmt.;
419 *format datname $datfmt.;
420 run;
NOTE: There were 7 observations read from the data set WORK.CDISC.
NOTE: The data set WORK.CDISC has 7 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
421
422 *** Remove The Special Characters ******;
423 proc template;
424 define style styles.test/store=work.test;
425 parent=styles.default;
426 style byline from titlesandfooters /
427 protectspecialchars=off;
428 end;
NOTE: STYLE 'Styles.Test' has been saved to: WORK.TEST
429 run;
NOTE: PROCEDURE TEMPLATE used (Total process time):
real time 0.07 seconds
cpu time 0.03 seconds
430
431 proc sort data = work.cdisc;
432 by libname datname datlab variable case;
433 run;
NOTE: There were 7 observations read from the data set WORK.CDISC.
NOTE: The data set WORK.CDISC has 7 observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
434
435 ods listing close;
436 ods html file='cdisc65.html' style=styles.mxistyle;
NOTE: Writing HTML Body file: cdisc65.html
13 The SAS System 09:44 Wednesday, October 21, 2009
437 data work.ae (drop=usrname datetime);
438 set work.cdisc;
439 where lowcase(datname)=lowcase("ae");
440 run;
NOTE: There were 7 observations read from the data set WORK.CDISC.
WHERE LOWCASE(datname)='ae';
NOTE: The data set WORK.AE has 7 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
441 data ae(drop=xxx);
442 set ae;
443 retain xxx 0;
444 if xxx = 2 then xxx = 1;
445 else xxx = xxx + 1;
446 yyy = compress(put(xxx,best.));
447 run;
NOTE: There were 7 observations read from the data set WORK.AE.
NOTE: The data set WORK.AE has 7 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
448
449 %let newlab = %nrbquote();
450 title1 height=2 ' Findings from CDISC Evaluation';
451 title2 height=2 "Data Table Name = ae Data Table Label=&newlab";
452 footnote1 height=2 "Generated on: 10/21/2009, 9:44:10 am, Administrator";
453 footnote2 height=2 "Located at: C:\apache\htdocs\cdiscbuilder\data";
454 proc report data = work.ae nowindows;
455 column obs libname datvar label type length charcase comment yyy;
456 define obs/computed 'Obs';
457 define libname/width=20;
458 define datvar/width=50;
459 define label/width=50;
460 define type/width=20;
461 define length/width=50;
462 define comment/width=50;
463 define charcase/width=50;
464 define yyy/ noprint;
465
466 compute yyy;
467 if yyy = "2" then do;
468 call define (_row_,'style','STYLE=[BACKGROUND=cxFFFFCC]');
469 end;
470 endcompute;
471
472 compute charcase;
14 The SAS System 09:44 Wednesday, October 21, 2009
473 if charcase='1' then call define
473 ! ('charcase','style','STYLE=[BACKGROUND=CXccffcc JUST=CENTER]');
474 if charcase='2' then call define
474 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0030 JUST=CENTER]');
475 if charcase='3' then call define
475 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0094 JUST=CENTER]');
476 if charcase='4' then call define
476 ! ('charcase','style','STYLE=[BACKGROUND=CXcd00f8 JUST=CENTER]');
477 if charcase='5' then call define
477 ! ('charcase','style','STYLE=[BACKGROUND=CXcd015c JUST=CENTER]');
478 if charcase='6' then call define
478 ! ('charcase','style','STYLE=[BACKGROUND=CXcd01c0 JUST=CENTER]');
479 if charcase='7' then call define
479 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0224 JUST=CENTER]');
480 if charcase='8' then call define
480 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0288 JUST=CENTER]');
481 if charcase='9' then call define
481 ! ('charcase','style','STYLE=[BACKGROUND=CXcd02ec JUST=CENTER]');
482 if charcase='10' then call define
482 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0350 JUST=CENTER]');
483 if charcase='11' then call define
483 ! ('charcase','style','STYLE=[BACKGROUND=CXcd03b4 JUST=CENTER]');
484 if charcase='12' then call define
484 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0418 JUST=CENTER]');
485 if charcase='13' then call define
485 ! ('charcase','style','STYLE=[BACKGROUND=CXcd047c JUST=CENTER]');
486 if charcase='14' then call define
486 ! ('charcase','style','STYLE=[BACKGROUND=CXcd04e0 JUST=CENTER]');
487 if charcase='15' then call define
487 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0544 JUST=CENTER]');
488 if charcase='16' then call define
488 ! ('charcase','style','STYLE=[BACKGROUND=CXcd05a8 JUST=CENTER]');
489 if charcase='17' then call define
489 ! ('charcase','style','STYLE=[BACKGROUND=CXcd060c JUST=CENTER]');
490 if charcase='18' then call define
490 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0670 JUST=CENTER]');
491 if charcase='19' then call define
491 ! ('charcase','style','STYLE=[BACKGROUND=CXcd06d4 JUST=CENTER]');
492 if charcase='20' then call define
492 ! ('charcase','style','STYLE=[BACKGROUND=CXffffcc JUST=CENTER]');
493 if charcase='21' then call define
493 ! ('charcase','style','STYLE=[BACKGROUND=CX398C54 JUST=CENTER]');
494 if charcase='22' then call define
494 ! ('charcase','style','STYLE=[BACKGROUND=CX398d1c JUST=CENTER]');
495 if charcase='23' then call define
495 ! ('charcase','style','STYLE=[BACKGROUND=CX398d80 JUST=CENTER]');
496 if charcase='24' then call define
496 ! ('charcase','style','STYLE=[BACKGROUND=CX398de4 JUST=CENTER]');
497 if charcase='25' then call define
497 ! ('charcase','style','STYLE=[BACKGROUND=CX398e48 JUST=CENTER]');
498 if charcase='26' then call define
498 ! ('charcase','style','STYLE=[BACKGROUND=CX398eac JUST=CENTER]');
499 if charcase='27' then call define
15 The SAS System 09:44 Wednesday, October 21, 2009
499 ! ('charcase','style','STYLE=[BACKGROUND=CX398f10 JUST=CENTER]');
500 if charcase='28' then call define
500 ! ('charcase','style','STYLE=[BACKGROUND=CX398f74 JUST=CENTER]');
501 if charcase='29' then call define
501 ! ('charcase','style','STYLE=[BACKGROUND=CX398fd8 JUST=CENTER]');
502 if charcase='30' then call define
502 ! ('charcase','style','STYLE=[BACKGROUND=CX39903c JUST=CENTER]');
503 if charcase='31' then call define
503 ! ('charcase','style','STYLE=[BACKGROUND=CX3990a0 JUST=CENTER]');
504 if charcase='32' then call define
504 ! ('charcase','style','STYLE=[BACKGROUND=CX399104 JUST=CENTER]');
505 if charcase='33' then call define
505 ! ('charcase','style','STYLE=[BACKGROUND=CX399168 JUST=CENTER]');
506 if charcase='34' then call define
506 ! ('charcase','style','STYLE=[BACKGROUND=CX3991cc JUST=CENTER]');
507 if charcase='35' then call define
507 ! ('charcase','style','STYLE=[BACKGROUND=CX399230 JUST=CENTER]');
508 if charcase='36' then call define
508 ! ('charcase','style','STYLE=[BACKGROUND=CX399294 JUST=CENTER]');
509 if charcase='37' then call define
509 ! ('charcase','style','STYLE=[BACKGROUND=CX3992f8 JUST=CENTER]');
510 if charcase='38' then call define
510 ! ('charcase','style','STYLE=[BACKGROUND=CX39935c JUST=CENTER]');
511 if charcase='39' then call define
511 ! ('charcase','style','STYLE=[BACKGROUND=CXffcccc JUST=CENTER]');
512 if charcase='40' then call define
512 ! ('charcase','style','STYLE=[BACKGROUND=CXffcd30 JUST=CENTER]');
513 if charcase='41' then call define
513 ! ('charcase','style','STYLE=[BACKGROUND=CXffcd94 JUST=CENTER]');
514 if charcase='42' then call define
514 ! ('charcase','style','STYLE=[BACKGROUND=CXffcdf8 JUST=CENTER]');
515 if charcase='43' then call define
515 ! ('charcase','style','STYLE=[BACKGROUND=CXffce5c JUST=CENTER]');
516 if charcase='44' then call define
516 ! ('charcase','style','STYLE=[BACKGROUND=CXffcec0 JUST=CENTER]');
517 if charcase='45' then call define
517 ! ('charcase','style','STYLE=[BACKGROUND=CXffcf24 JUST=CENTER]');
518 if charcase='46' then call define
518 ! ('charcase','style','STYLE=[BACKGROUND=CXffcf88 JUST=CENTER]');
519 if charcase='47' then call define
519 ! ('charcase','style','STYLE=[BACKGROUND=CXffcfec JUST=CENTER]');
520 if charcase='48' then call define
520 ! ('charcase','style','STYLE=[BACKGROUND=CXffd050 JUST=CENTER]');
521 if charcase='49' then call define
521 ! ('charcase','style','STYLE=[BACKGROUND=CXffd0b4 JUST=CENTER]');
522 if charcase='50' then call define
522 ! ('charcase','style','STYLE=[BACKGROUND=CXffd118 JUST=CENTER]');
523 if charcase='51' then call define
523 ! ('charcase','style','STYLE=[BACKGROUND=CXffd17c JUST=CENTER]');
524 if charcase='52' then call define
524 ! ('charcase','style','STYLE=[BACKGROUND=CXffd1e0 JUST=CENTER]');
525 if charcase='53' then call define
525 ! ('charcase','style','STYLE=[BACKGROUND=CXffd244 JUST=CENTER]');
16 The SAS System 09:44 Wednesday, October 21, 2009
526 if charcase='54' then call define
526 ! ('charcase','style','STYLE=[BACKGROUND=CXffd2a8 JUST=CENTER]');
527 if charcase='55' then call define
527 ! ('charcase','style','STYLE=[BACKGROUND=CXffd30c JUST=CENTER]');
528 if charcase='56' then call define
528 ! ('charcase','style','STYLE=[BACKGROUND=CXffd370 JUST=CENTER]');
529 if charcase='57' then call define
529 ! ('charcase','style','STYLE=[BACKGROUND=CXffd3d4 JUST=CENTER]');
530 if charcase='58' then call define
530 ! ('charcase','style','STYLE=[BACKGROUND=CXccccff JUST=CENTER]');
531 if charcase='59' then call define
531 ! ('charcase','style','STYLE=[BACKGROUND=CXcccd63 JUST=CENTER]');
532 if charcase='60' then call define
532 ! ('charcase','style','STYLE=[BACKGROUND=CXcccdc7 JUST=CENTER]');
533 if charcase='61' then call define
533 ! ('charcase','style','STYLE=[BACKGROUND=CXccce2b JUST=CENTER]');
534 if charcase='62' then call define
534 ! ('charcase','style','STYLE=[BACKGROUND=CXccce8f JUST=CENTER]');
535 if charcase='63' then call define
535 ! ('charcase','style','STYLE=[BACKGROUND=CXcccef3 JUST=CENTER]');
536 if charcase='64' then call define
536 ! ('charcase','style','STYLE=[BACKGROUND=CXcccf57 JUST=CENTER]');
537 if charcase='65' then call define
537 ! ('charcase','style','STYLE=[BACKGROUND=CXcccfbb JUST=CENTER]');
538 if charcase='66' then call define
538 ! ('charcase','style','STYLE=[BACKGROUND=CXccd01f JUST=CENTER]');
539 if charcase='67' then call define
539 ! ('charcase','style','STYLE=[BACKGROUND=CXccd083 JUST=CENTER]');
540 if charcase='68' then call define
540 ! ('charcase','style','STYLE=[BACKGROUND=CXccd0e7 JUST=CENTER]');
541 if charcase='69' then call define
541 ! ('charcase','style','STYLE=[BACKGROUND=CXccd14b JUST=CENTER]');
542 if charcase='70' then call define
542 ! ('charcase','style','STYLE=[BACKGROUND=CXccd1af JUST=CENTER]');
543 if charcase='71' then call define
543 ! ('charcase','style','STYLE=[BACKGROUND=CXccd213 JUST=CENTER]');
544 if charcase='72' then call define
544 ! ('charcase','style','STYLE=[BACKGROUND=CXccd277 JUST=CENTER]');
545 if charcase='73' then call define
545 ! ('charcase','style','STYLE=[BACKGROUND=CXccd2db JUST=CENTER]');
546 if charcase='74' then call define
546 ! ('charcase','style','STYLE=[BACKGROUND=CXccd33f JUST=CENTER]');
547 if charcase='75' then call define
547 ! ('charcase','style','STYLE=[BACKGROUND=CXccd3a3 JUST=CENTER]');
548 if charcase='76' then call define
548 ! ('charcase','style','STYLE=[BACKGROUND=CXccd407 JUST=CENTER]');
549 if charcase='77' then call define
549 ! ('charcase','style','STYLE=[BACKGROUND=CX99ccff JUST=CENTER]');
550 if charcase='78' then call define
550 ! ('charcase','style','STYLE=[BACKGROUND=CX99cd63 JUST=CENTER]');
551 if charcase='79' then call define
551 ! ('charcase','style','STYLE=[BACKGROUND=CX99cdc7 JUST=CENTER]');
552 if charcase='80' then call define
17 The SAS System 09:44 Wednesday, October 21, 2009
552 ! ('charcase','style','STYLE=[BACKGROUND=CX99ce2b JUST=CENTER]');
553 if charcase='81' then call define
553 ! ('charcase','style','STYLE=[BACKGROUND=CX99ce8f JUST=CENTER]');
554 if charcase='82' then call define
554 ! ('charcase','style','STYLE=[BACKGROUND=CX99cef3 JUST=CENTER]');
555 if charcase='83' then call define
555 ! ('charcase','style','STYLE=[BACKGROUND=CX99cf57 JUST=CENTER]');
556 if charcase='84' then call define
556 ! ('charcase','style','STYLE=[BACKGROUND=CX99cfbb JUST=CENTER]');
557 if charcase='85' then call define
557 ! ('charcase','style','STYLE=[BACKGROUND=CX99d01f JUST=CENTER]');
558 if charcase='86' then call define
558 ! ('charcase','style','STYLE=[BACKGROUND=CX99d083 JUST=CENTER]');
559 if charcase='87' then call define
559 ! ('charcase','style','STYLE=[BACKGROUND=CX99d0e7 JUST=CENTER]');
560 if charcase='88' then call define
560 ! ('charcase','style','STYLE=[BACKGROUND=CX99d14b JUST=CENTER]');
561 if charcase='89' then call define
561 ! ('charcase','style','STYLE=[BACKGROUND=CX99d1af JUST=CENTER]');
562 if charcase='90' then call define
562 ! ('charcase','style','STYLE=[BACKGROUND=CX99d213 JUST=CENTER]');
563 if charcase='91' then call define
563 ! ('charcase','style','STYLE=[BACKGROUND=CX99d277 JUST=CENTER]');
564 if charcase='92' then call define
564 ! ('charcase','style','STYLE=[BACKGROUND=CX99d2db JUST=CENTER]');
565 if charcase='93' then call define
565 ! ('charcase','style','STYLE=[BACKGROUND=CX99d33f JUST=CENTER]');
566 if charcase='94' then call define
566 ! ('charcase','style','STYLE=[BACKGROUND=CX99d3a3 JUST=CENTER]');
567 if charcase='95' then call define
567 ! ('charcase','style','STYLE=[BACKGROUND=CX99d407 JUST=CENTER]');
568 if charcase='96' then call define
568 ! ('charcase','style','STYLE=[BACKGROUND=CXffcc99 JUST=CENTER]');
569 if charcase='97' then call define
569 ! ('charcase','style','STYLE=[BACKGROUND=CXffccfd JUST=CENTER]');
570 if charcase='98' then call define
570 ! ('charcase','style','STYLE=[BACKGROUND=CXffcd61 JUST=CENTER]');
571 if charcase='99' then call define
571 ! ('charcase','style','STYLE=[BACKGROUND=CXffcdc5 JUST=CENTER]');
572 if charcase='100' then call define
572 ! ('charcase','style','STYLE=[BACKGROUND=CXffce29 JUST=CENTER]');
573 if charcase='101' then call define
573 ! ('charcase','style','STYLE=[BACKGROUND=CXffce8d JUST=CENTER]');
574 if charcase='102' then call define
574 ! ('charcase','style','STYLE=[BACKGROUND=CXffcef1 JUST=CENTER]');
575 if charcase='103' then call define
575 ! ('charcase','style','STYLE=[BACKGROUND=CXffcf55 JUST=CENTER]');
576 if charcase='104' then call define
576 ! ('charcase','style','STYLE=[BACKGROUND=CXffcfb9 JUST=CENTER]');
577 if charcase='105' then call define
577 ! ('charcase','style','STYLE=[BACKGROUND=CXffd01d JUST=CENTER]');
578 if charcase='106' then call define
578 ! ('charcase','style','STYLE=[BACKGROUND=CXffd081 JUST=CENTER]');
18 The SAS System 09:44 Wednesday, October 21, 2009
579 if charcase='107' then call define
579 ! ('charcase','style','STYLE=[BACKGROUND=CXffd0e5 JUST=CENTER]');
580 if charcase='108' then call define
580 ! ('charcase','style','STYLE=[BACKGROUND=CXffd149 JUST=CENTER]');
581 if charcase='109' then call define
581 ! ('charcase','style','STYLE=[BACKGROUND=CXffd1ad JUST=CENTER]');
582 if charcase='110' then call define
582 ! ('charcase','style','STYLE=[BACKGROUND=CXffd211 JUST=CENTER]');
583 if charcase='111' then call define
583 ! ('charcase','style','STYLE=[BACKGROUND=CXffd275 JUST=CENTER]');
584 if charcase='112' then call define
584 ! ('charcase','style','STYLE=[BACKGROUND=CXffd2d9 JUST=CENTER]');
585 if charcase='113' then call define
585 ! ('charcase','style','STYLE=[BACKGROUND=CXffd33d JUST=CENTER]');
586 endcomp;
587
588 compute obs;
589 dobs + 1;
590 obs = dobs;
591 endcompute;
592 run;
NOTE: There were 7 observations read from the data set WORK.AE.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.15 seconds
cpu time 0.06 seconds
593 run;
594 ods html close;
595 ods listing;
NOTE: PROCEDURE DISPLAY used (Total process time):
real time 3.12 seconds
cpu time 2.71 seconds
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 3.98 seconds
cpu time 3.53 seconds