1 The SAS System 09:50 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 1.89 seconds cpu time 2.18 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: cdisc102.sas * 3 * Description: Case #102. IE Units Codelist For IE domains, this identifies records 3 ! where value for [I/E Criterion Original Result]* 4 * is not found in Codelist [YESNO], limited to records where [I/E 4 ! Criterion Original Result is not null].* 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 options nofmterr; 10 *** Create some data to be selected ***; 11 data templib.IE(label="Inclusion/Exclusion Criteria Not Met"); 12 attrib STUDYID label="Study IdentifIEr" length=$100; 13 attrib DOMAIN label="Domain Abbreviation" length=$100; 14 attrib USUBJID label="Unique Subject IdentifIEr" length=$100; 15 attrib IESEQ label="Sequence Number" length=8; 16 attrib IEGRPID label="Group ID" length=$100; 17 attrib IESPID label="Sponsor-Defined IdentifIEr" length=$100; 18 attrib IETESTCD label="Question Short Name" length=$100; 19 attrib IETEST label="Question Name" length=$100; 20 attrib IECAT label="Category of Question" length=$100; 21 attrib IESCAT label="Subcategory for Question" length=$100; 22 attrib IEORRES label="I/E Criterion Original Result" format=$YN. length=$100; ____ ____ ____ 484 484 484 NOTE 484-185: Format $YN was not found or could not be loaded. 23 attrib IESTRESC label="I/E Criterion Result in Std Format" length=$100; 2 The SAS System 09:50 Wednesday, October 21, 2009 24 attrib VISITNUM label="Visit Number" length=8; 25 attrib VISIT label="Visit Name" length=$100; 26 attrib VISITDY label="Planned Study Day of Visit" length=8; 27 attrib IEDTC label="Date/Time of Finding" length=$100; 28 attrib IEDY label="Study Day of Finding" length=8; 29 30 STUDYID = 'test';DOMAIN = 'test';USUBJID = '123';IESEQ = 1;IEGRPID = 'test';IESPID = 30 ! 'test';IETESTCD = 'test';IETEST = 'test';IECAT = 'test';IESCAT = 'test';IEORRES = 'Y'; 31 ; 32 output; 33 STUDYID = 'test';DOMAIN = 'test';USUBJID = '123';IESEQ = 1;IEGRPID = 'test';IESPID = 33 ! 'test';IETESTCD = 'test';IETEST = 'test';IECAT = 'test';IESCAT = 'test';IEORRES = 'NA' 33 ! ; 34 ; 35 output; 36 STUDYID = 'test';DOMAIN = 'test';USUBJID = '456';IESEQ = 1;IEGRPID = 'test';IESPID = 36 ! 'test';IETESTCD = 'test';IETEST = 'test';IECAT = 'test';IESCAT = 'test';IEORRES = 'N'; 37 ; 38 output; 39 STUDYID = 'test';DOMAIN = 'test';USUBJID = '456';IESEQ = 1;IEGRPID = 'test';IESPID = 39 ! 'test';IETESTCD = 'test';IETEST = 'test';IECAT = 'test';IESCAT = 'test';IEORRES = 'U'; 40 ; 41 output; 42 STUDYID = 'test';DOMAIN = 'test';USUBJID = '789';IESEQ = 1;IEGRPID = 'test';IESPID = 42 ! 'test';IETESTCD = 'test';IETEST = 'test';IECAT = 'test';IESCAT = 'test';IEORRES = ''; 43 ; 44 output; 45 STUDYID = 'test';DOMAIN = 'test';USUBJID = '789';IESEQ = 1;IEGRPID = 'test';IESPID = 45 ! 'test';IETESTCD = 'test';IETEST = 'test';IECAT = 'test';IESCAT = 'test';IEORRES = 45 ! 'test'; 46 ; 47 output; 48 run; NOTE: Variable IESTRESC is uninitialized. NOTE: Variable VISITNUM is uninitialized. NOTE: Variable VISIT is uninitialized. NOTE: Variable VISITDY is uninitialized. NOTE: Variable IEDTC is uninitialized. NOTE: Variable IEDY is uninitialized. NOTE: The data set TEMPLIB.IE has 6 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.21 seconds cpu time 0.20 seconds 49 %cdisc(datlib=templib,datname=IE); 50 data misobs(keep=obsnum); 51 retain obsnum 0; 52 set templib.ie(keep=STUDYID); 53 obsnum=obsnum+1; 54 if missing(STUDYID) then 3 The SAS System 09:50 Wednesday, October 21, 2009 55 output; 56 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. 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 57 data misobs(keep=obsnum); 58 retain obsnum 0; 59 set templib.ie(keep=DOMAIN); 60 obsnum=obsnum+1; 61 if missing(DOMAIN) then 62 output; 63 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. 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 64 data misobs(keep=obsnum); 65 retain obsnum 0; 66 set templib.ie(keep=USUBJID); 67 obsnum=obsnum+1; 68 if missing(USUBJID) then 69 output; 70 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. 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 71 data misobs(keep=obsnum); 72 retain obsnum 0; 73 set templib.ie(keep=IESEQ); 74 obsnum=obsnum+1; 75 if missing(IESEQ) then 76 output; 77 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. 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 4 The SAS System 09:50 Wednesday, October 21, 2009 78 data misobs(keep=obsnum); 79 retain obsnum 0; 80 set templib.ie(keep=IETESTCD); 81 obsnum=obsnum+1; 82 if missing(IETESTCD) then 83 output; 84 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. 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 85 data misobs(keep=obsnum); 86 retain obsnum 0; 87 set templib.ie(keep=IETEST); 88 obsnum=obsnum+1; 89 if missing(IETEST) then 90 output; 91 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. 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 92 data misobs(keep=obsnum); 93 retain obsnum 0; 94 set templib.ie(keep=IECAT); 95 obsnum=obsnum+1; 96 if missing(IECAT) then 97 output; 98 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. 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 99 data misobs(keep=obsnum); 100 retain obsnum 0; 101 set templib.ie(keep=IEORRES); 102 obsnum=obsnum+1; 103 if missing(IEORRES) then 104 output; 5 The SAS System 09:50 Wednesday, October 21, 2009 105 run; NOTE: Format $YN was not found or could not be loaded. NOTE: There were 6 observations read from the data set TEMPLIB.IE. NOTE: The data set WORK.MISOBS has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 106 data misobs(keep=obsnum); 107 retain obsnum 0; 108 set templib.ie(keep=IESTRESC); 109 obsnum=obsnum+1; 110 if missing(IESTRESC) then 111 output; 112 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. NOTE: The data set WORK.MISOBS has 6 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 113 data _26; 114 retain obsnum 0; 115 set templib.ie(keep=VISITNUM); 116 obsnum = obsnum + 1; 117 attrib visitnumc length=$50; 118 visitnumc = compress(visitnum); 119 if index(visitnumc,'.') gt 0 then visitnumc = compress(scan(visitnumc,2,'.')); 120 if length(compress(visitnumc))>2 then output; 121 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 118:22 NOTE: There were 6 observations read from the data set TEMPLIB.IE. NOTE: The data set WORK._26 has 0 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 122 data _42; 123 retain obsnum 0; 124 set templib.ie(keep=IETEST); 125 obsnum = obsnum + 1; 126 if length(trim(left(IETEST))) > 40 then output; 127 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. 6 The SAS System 09:50 Wednesday, October 21, 2009 NOTE: The data set WORK._42 has 0 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 128 data _43(keep= obsnum IETESTCD status); 129 retain obsnum 0; 130 set templib.ie(keep=IETESTCD); 131 obsnum = obsnum + 1; 132 attrib status length=$50; 133 if length(trim(left(IETESTCD))) > 8 then do; 134 status = 'greater than 8 characters.'; 135 output; 136 end; 137 if substr(IETESTCD,1,1) in ('1','2','3','4','5','6','7','8','9','0') then do; 138 status = 'starts with a number.'; 139 output; 140 end; 141 spec = '~`@#$%^&*()-+={}|\][:";<>?,./'; 142 if index(IETESTCD,"'") gt 0 then do; 143 status = 'contains special character(s).'; 144 output; 145 end; 146 else do; 147 do i=1 to length(trim(left(IETESTCD))); 148 if index(spec,substr(IETESTCD,i,1)) gt 0 then do; 149 status = 'contains special character(s).'; 150 output; 151 end; 152 end; 153 end; 154 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. NOTE: The data set WORK._43 has 0 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 155 proc sort data=templib.ie out=ie nodupkey; 156 by usubjid; 157 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. NOTE: 3 observations with duplicate key values were deleted. NOTE: The data set WORK.IE has 3 observations and 17 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.07 seconds cpu time 0.07 seconds 7 The SAS System 09:50 Wednesday, October 21, 2009 NOTE: Table WORK._72 created, with 3 rows and 1 columns. 158 proc sort data=templib.ie out=ie nodupkey; 159 by usubjid visitnum visit; 160 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. NOTE: 3 observations with duplicate key values were deleted. NOTE: The data set WORK.IE has 3 observations and 17 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 161 data ie; 162 attrib total length=$100; 163 set ie; 164 total = trim(left(usubjid))||'+'||compress(visitnum)||'+'||trim(left(visit)); 165 put total=; 166 keep total; 167 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 164:44 NOTE: Format $YN was not found or could not be loaded. total=123+.+ total=456+.+ total=789+.+ NOTE: There were 3 observations read from the data set WORK.IE. NOTE: The data set WORK.IE has 3 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 168 data sv; 169 attrib total length=$100; 170 set templib.SV; 171 total = trim(left(usubjid))||'+'||compress(visitnum)||'+'||trim(left(visit)); 172 put total=; 173 keep total; 174 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 171:44 total=101+1+SCREEN total=101+2+DAY 1 total=101+2+WEEK 1 total=101+4+WEEK 2 total=101+4.1+ total=101+8+FOLLOW-UP 8 The SAS System 09:50 Wednesday, October 21, 2009 NOTE: There were 6 observations read from the data set TEMPLIB.SV. NOTE: The data set WORK.SV has 6 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Table WORK._73 created, with 3 rows and 1 columns. 175 proc sort data=templib.ie out=ie nodupkey; 176 by IETESTCD; 177 run; NOTE: There were 6 observations read from the data set TEMPLIB.IE. NOTE: 5 observations with duplicate key values were deleted. NOTE: The data set WORK.IE has 1 observations and 17 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 178 proc sort data=templib.TI out=ti nodupkey; 179 by IETESTCD; 180 run; NOTE: There were 1 observations read from the data set TEMPLIB.TI. NOTE: 0 observations with duplicate key values were deleted. NOTE: The data set WORK.TI has 1 observations and 8 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds NOTE: Table WORK._76 created, with 1 rows and 1 columns. 181 data _102; 182 retain obsnum 0; 183 set templib.ie; 184 obsnum = obsnum + 1; 185 if IEORRES not in ('N','Y','NA','U') and IEORRES ne '' then do; 186 output; 187 end; 188 run; NOTE: Format $YN was not found or could not be loaded. NOTE: There were 6 observations read from the data set TEMPLIB.IE. NOTE: The data set WORK._102 has 1 observations and 18 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 189 data _104; 9 The SAS System 09:50 Wednesday, October 21, 2009 190 retain obsnum 0; 191 set templib.ie; 192 obsnum = obsnum + 1; 193 if IEORRES ne IESTRESC then do; 194 output; 195 end; 196 run; NOTE: Format $YN was not found or could not be loaded. NOTE: There were 6 observations read from the data set TEMPLIB.IE. NOTE: The data set WORK._104 has 5 observations and 18 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 197 proc sort data=cdisc nodupkey; 198 by libname datname datlab variable length label type case comment; 199 run; NOTE: There were 39 observations read from the data set WORK.CDISC. NOTE: 0 observations with duplicate key values were deleted. NOTE: The data set WORK.CDISC has 39 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 39 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 39 observations and 11 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 203 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' 10 The SAS System 09:50 Wednesday, October 21, 2009 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' 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' 11 The SAS System 09:50 Wednesday, October 21, 2009 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' 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 12 The SAS System 09:50 Wednesday, October 21, 2009 322 323 *** Generate the format for the bookmark of variables ***; 324 value $bookfmt 325 "ie.studyid" = 'ie.studyid' 326 "ie.domain" = 'ie.domain' 327 "ie.usubjid" = 'ie.usubjid' 328 "ie.ieseq" = 'ie.ieseq' 329 "ie.iegrpid" = 'ie.iegrpid' 330 "ie.iespid" = 'ie.iespid' 331 "ie.ietestcd" = 'ie.ietestcd' 332 "ie.ietest" = 'ie.ietest' 333 "ie.iecat" = 'ie.iecat' 334 "ie.iescat" = 'ie.iescat' 335 "ie.ieorres" = 'ie.ieorres' 336 "ie.iestresc" = 'ie.iestresc' 337 "ie.visitnum" = 'ie.visitnum' 338 "ie.visit" = 'ie.visit' 339 "ie.visitdy" = 'ie.visitdy' 340 "ie.iedtc" = 'ie.iedtc' 341 "ie.iedy" = 'ie.iedy' 342 ; NOTE: Format $BOOKFMT has been output. 343 344 *** Generate the format for dataset linking ***; 345 value $datfmt 346 "ae" = 'ae
' 347 "ae3a" = 'ae3a
' 348 "cdisc10" = 'cdisc10
' 349 "cdisc11" = 'cdisc11
' 350 "cdisc14" = 'cdisc14
' 351 "cdisc15" = 'cdisc15
' 352 "cdisc18" = 'cdisc18
' 353 "cdisc2" = 'cdisc2
' 354 "cdisc21" = 'cdisc21
' 355 "cdisc2b_1" = 'cdisc2b_1
' 356 "cdisc2b_2" = 'cdisc2b_2
' 357 "cdisc2b_3" = 'cdisc2b_3
' 358 "cdisc2_b" = 'cdisc2_b
' 359 "cdisc2_c" = 'cdisc2_c
' 360 "cdisc4" = 'cdisc4
' 361 "cdisc5" = 'cdisc5
' 362 "cdisc6" = 'cdisc6
' 363 "cdisc7" = 'cdisc7
' 364 "cdisc8" = 'cdisc8
' 365 "cdisc9" = 'cdisc9
' 366 "ce" = 'ce
' 367 "cm" = 'cm
' 368 "co" = 'co
' 369 "da" = 'da
' 370 "dm" = 'dm
' 371 "ds" = 'ds
' 372 "dv" = 'dv
' 373 "eg" = 'eg
' 13 The SAS System 09:50 Wednesday, October 21, 2009 374 "ex" = 'ex
' 375 "fa" = 'fa
' 376 "ie" = 'ie
' 377 "lb" = 'lb
' 378 "mb" = 'mb
' 379 "mh" = 'mh
' 380 "ms" = 'ms
' 381 "notdm" = 'notdm
' 382 "pc" = 'pc
' 383 "pe" = 'pe
' 384 "pp" = 'pp
' 385 "qs" = 'qs
' 386 "relrec" = 'relrec
' 387 "sc" = 'sc
' 388 "se" = 'se
' 389 "su" = 'su
' 390 "supmh" = 'supmh
' 391 "suppae" = 'suppae
' 392 "suppp" = 'suppp
' 393 "supte" = 'supte
' 394 "supvs" = 'supvs
' 395 "sv" = 'sv
' 396 "ta" = 'ta
' 397 "te" = 'te
' 398 "ti" = 'ti
' 399 "ts" = 'ts
' 400 "tv" = 'tv
' 401 "vs" = 'vs
' 402 ; NOTE: Format $DATFMT has been output. 403 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.07 seconds cpu time 0.03 seconds 404 405 data work.cdisc; 406 set work.cdisc; 407 by libname datname datlab variable case; 408 409 attrib datvar label="Dataset and Variable" length=$100 format=$bookfmt.; 410 if variable ne '' then 411 datvar = compress(lowcase(datname) || "." || lowcase(variable)); 412 else datvar = lowcase(datname); 413 /*format case casefmt.;*/ 414 attrib charcase label = "Case Number" length = $10; 415 charcase = trim(left(put(case, best.))); 416 format charcase $casefmt.; 417 *format datname $datfmt.; 418 run; 14 The SAS System 09:50 Wednesday, October 21, 2009 NOTE: There were 39 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 39 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 419 420 *** Remove The Special Characters ******; 421 proc template; 422 define style styles.test/store=work.test; 423 parent=styles.default; 424 style byline from titlesandfooters / 425 protectspecialchars=off; 426 end; NOTE: STYLE 'Styles.Test' has been saved to: WORK.TEST 427 run; NOTE: PROCEDURE TEMPLATE used (Total process time): real time 0.09 seconds cpu time 0.03 seconds 428 429 proc sort data = work.cdisc; 430 by libname datname datlab variable case; 431 run; NOTE: There were 39 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 39 observations and 13 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 432 433 ods listing close; 434 ods html file='cdisc102.html' style=styles.mxistyle; NOTE: Writing HTML Body file: cdisc102.html 435 data work.ie (drop=usrname datetime); 436 set work.cdisc; 437 where lowcase(datname)=lowcase("ie"); 438 run; NOTE: There were 39 observations read from the data set WORK.CDISC. WHERE LOWCASE(datname)='ie'; NOTE: The data set WORK.IE has 39 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 439 data ie(drop=xxx); 440 set ie; 15 The SAS System 09:50 Wednesday, October 21, 2009 441 retain xxx 0; 442 if xxx = 2 then xxx = 1; 443 else xxx = xxx + 1; 444 yyy = compress(put(xxx,best.)); 445 run; NOTE: There were 39 observations read from the data set WORK.IE. NOTE: The data set WORK.IE has 39 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 446 447 %let newlab = %nrbquote(); 448 title1 height=2 ' Findings from CDISC Evaluation'; 449 title2 height=2 "Data Table Name = ie Data Table Label=&newlab"; 450 footnote1 height=2 "Generated on: 10/21/2009, 9:50:58 am, Administrator"; 451 footnote2 height=2 "Located at: C:\apache\htdocs\cdiscbuilder\data"; 452 proc report data = work.ie nowindows; 453 column obs libname datvar label type length charcase comment yyy; 454 define obs/computed 'Obs'; 455 define libname/width=20; 456 define datvar/width=50; 457 define label/width=50; 458 define type/width=20; 459 define length/width=50; 460 define comment/width=50; 461 define charcase/width=50; 462 define yyy/ noprint; 463 464 compute yyy; 465 if yyy = "2" then do; 466 call define (_row_,'style','STYLE=[BACKGROUND=cxFFFFCC]'); 467 end; 468 endcompute; 469 470 compute charcase; 471 if charcase='1' then call define 471 ! ('charcase','style','STYLE=[BACKGROUND=CXccffcc JUST=CENTER]'); 472 if charcase='2' then call define 472 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0030 JUST=CENTER]'); 473 if charcase='3' then call define 473 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0094 JUST=CENTER]'); 474 if charcase='4' then call define 474 ! ('charcase','style','STYLE=[BACKGROUND=CXcd00f8 JUST=CENTER]'); 475 if charcase='5' then call define 475 ! ('charcase','style','STYLE=[BACKGROUND=CXcd015c JUST=CENTER]'); 476 if charcase='6' then call define 476 ! ('charcase','style','STYLE=[BACKGROUND=CXcd01c0 JUST=CENTER]'); 477 if charcase='7' then call define 477 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0224 JUST=CENTER]'); 478 if charcase='8' then call define 16 The SAS System 09:50 Wednesday, October 21, 2009 478 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0288 JUST=CENTER]'); 479 if charcase='9' then call define 479 ! ('charcase','style','STYLE=[BACKGROUND=CXcd02ec JUST=CENTER]'); 480 if charcase='10' then call define 480 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0350 JUST=CENTER]'); 481 if charcase='11' then call define 481 ! ('charcase','style','STYLE=[BACKGROUND=CXcd03b4 JUST=CENTER]'); 482 if charcase='12' then call define 482 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0418 JUST=CENTER]'); 483 if charcase='13' then call define 483 ! ('charcase','style','STYLE=[BACKGROUND=CXcd047c JUST=CENTER]'); 484 if charcase='14' then call define 484 ! ('charcase','style','STYLE=[BACKGROUND=CXcd04e0 JUST=CENTER]'); 485 if charcase='15' then call define 485 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0544 JUST=CENTER]'); 486 if charcase='16' then call define 486 ! ('charcase','style','STYLE=[BACKGROUND=CXcd05a8 JUST=CENTER]'); 487 if charcase='17' then call define 487 ! ('charcase','style','STYLE=[BACKGROUND=CXcd060c JUST=CENTER]'); 488 if charcase='18' then call define 488 ! ('charcase','style','STYLE=[BACKGROUND=CXcd0670 JUST=CENTER]'); 489 if charcase='19' then call define 489 ! ('charcase','style','STYLE=[BACKGROUND=CXcd06d4 JUST=CENTER]'); 490 if charcase='20' then call define 490 ! ('charcase','style','STYLE=[BACKGROUND=CXffffcc JUST=CENTER]'); 491 if charcase='21' then call define 491 ! ('charcase','style','STYLE=[BACKGROUND=CX398C54 JUST=CENTER]'); 492 if charcase='22' then call define 492 ! ('charcase','style','STYLE=[BACKGROUND=CX398d1c JUST=CENTER]'); 493 if charcase='23' then call define 493 ! ('charcase','style','STYLE=[BACKGROUND=CX398d80 JUST=CENTER]'); 494 if charcase='24' then call define 494 ! ('charcase','style','STYLE=[BACKGROUND=CX398de4 JUST=CENTER]'); 495 if charcase='25' then call define 495 ! ('charcase','style','STYLE=[BACKGROUND=CX398e48 JUST=CENTER]'); 496 if charcase='26' then call define 496 ! ('charcase','style','STYLE=[BACKGROUND=CX398eac JUST=CENTER]'); 497 if charcase='27' then call define 497 ! ('charcase','style','STYLE=[BACKGROUND=CX398f10 JUST=CENTER]'); 498 if charcase='28' then call define 498 ! ('charcase','style','STYLE=[BACKGROUND=CX398f74 JUST=CENTER]'); 499 if charcase='29' then call define 499 ! ('charcase','style','STYLE=[BACKGROUND=CX398fd8 JUST=CENTER]'); 500 if charcase='30' then call define 500 ! ('charcase','style','STYLE=[BACKGROUND=CX39903c JUST=CENTER]'); 501 if charcase='31' then call define 501 ! ('charcase','style','STYLE=[BACKGROUND=CX3990a0 JUST=CENTER]'); 502 if charcase='32' then call define 502 ! ('charcase','style','STYLE=[BACKGROUND=CX399104 JUST=CENTER]'); 503 if charcase='33' then call define 503 ! ('charcase','style','STYLE=[BACKGROUND=CX399168 JUST=CENTER]'); 504 if charcase='34' then call define 504 ! ('charcase','style','STYLE=[BACKGROUND=CX3991cc JUST=CENTER]'); 17 The SAS System 09:50 Wednesday, October 21, 2009 505 if charcase='35' then call define 505 ! ('charcase','style','STYLE=[BACKGROUND=CX399230 JUST=CENTER]'); 506 if charcase='36' then call define 506 ! ('charcase','style','STYLE=[BACKGROUND=CX399294 JUST=CENTER]'); 507 if charcase='37' then call define 507 ! ('charcase','style','STYLE=[BACKGROUND=CX3992f8 JUST=CENTER]'); 508 if charcase='38' then call define 508 ! ('charcase','style','STYLE=[BACKGROUND=CX39935c JUST=CENTER]'); 509 if charcase='39' then call define 509 ! ('charcase','style','STYLE=[BACKGROUND=CXffcccc JUST=CENTER]'); 510 if charcase='40' then call define 510 ! ('charcase','style','STYLE=[BACKGROUND=CXffcd30 JUST=CENTER]'); 511 if charcase='41' then call define 511 ! ('charcase','style','STYLE=[BACKGROUND=CXffcd94 JUST=CENTER]'); 512 if charcase='42' then call define 512 ! ('charcase','style','STYLE=[BACKGROUND=CXffcdf8 JUST=CENTER]'); 513 if charcase='43' then call define 513 ! ('charcase','style','STYLE=[BACKGROUND=CXffce5c JUST=CENTER]'); 514 if charcase='44' then call define 514 ! ('charcase','style','STYLE=[BACKGROUND=CXffcec0 JUST=CENTER]'); 515 if charcase='45' then call define 515 ! ('charcase','style','STYLE=[BACKGROUND=CXffcf24 JUST=CENTER]'); 516 if charcase='46' then call define 516 ! ('charcase','style','STYLE=[BACKGROUND=CXffcf88 JUST=CENTER]'); 517 if charcase='47' then call define 517 ! ('charcase','style','STYLE=[BACKGROUND=CXffcfec JUST=CENTER]'); 518 if charcase='48' then call define 518 ! ('charcase','style','STYLE=[BACKGROUND=CXffd050 JUST=CENTER]'); 519 if charcase='49' then call define 519 ! ('charcase','style','STYLE=[BACKGROUND=CXffd0b4 JUST=CENTER]'); 520 if charcase='50' then call define 520 ! ('charcase','style','STYLE=[BACKGROUND=CXffd118 JUST=CENTER]'); 521 if charcase='51' then call define 521 ! ('charcase','style','STYLE=[BACKGROUND=CXffd17c JUST=CENTER]'); 522 if charcase='52' then call define 522 ! ('charcase','style','STYLE=[BACKGROUND=CXffd1e0 JUST=CENTER]'); 523 if charcase='53' then call define 523 ! ('charcase','style','STYLE=[BACKGROUND=CXffd244 JUST=CENTER]'); 524 if charcase='54' then call define 524 ! ('charcase','style','STYLE=[BACKGROUND=CXffd2a8 JUST=CENTER]'); 525 if charcase='55' then call define 525 ! ('charcase','style','STYLE=[BACKGROUND=CXffd30c JUST=CENTER]'); 526 if charcase='56' then call define 526 ! ('charcase','style','STYLE=[BACKGROUND=CXffd370 JUST=CENTER]'); 527 if charcase='57' then call define 527 ! ('charcase','style','STYLE=[BACKGROUND=CXffd3d4 JUST=CENTER]'); 528 if charcase='58' then call define 528 ! ('charcase','style','STYLE=[BACKGROUND=CXccccff JUST=CENTER]'); 529 if charcase='59' then call define 529 ! ('charcase','style','STYLE=[BACKGROUND=CXcccd63 JUST=CENTER]'); 530 if charcase='60' then call define 530 ! ('charcase','style','STYLE=[BACKGROUND=CXcccdc7 JUST=CENTER]'); 531 if charcase='61' then call define 18 The SAS System 09:50 Wednesday, October 21, 2009 531 ! ('charcase','style','STYLE=[BACKGROUND=CXccce2b JUST=CENTER]'); 532 if charcase='62' then call define 532 ! ('charcase','style','STYLE=[BACKGROUND=CXccce8f JUST=CENTER]'); 533 if charcase='63' then call define 533 ! ('charcase','style','STYLE=[BACKGROUND=CXcccef3 JUST=CENTER]'); 534 if charcase='64' then call define 534 ! ('charcase','style','STYLE=[BACKGROUND=CXcccf57 JUST=CENTER]'); 535 if charcase='65' then call define 535 ! ('charcase','style','STYLE=[BACKGROUND=CXcccfbb JUST=CENTER]'); 536 if charcase='66' then call define 536 ! ('charcase','style','STYLE=[BACKGROUND=CXccd01f JUST=CENTER]'); 537 if charcase='67' then call define 537 ! ('charcase','style','STYLE=[BACKGROUND=CXccd083 JUST=CENTER]'); 538 if charcase='68' then call define 538 ! ('charcase','style','STYLE=[BACKGROUND=CXccd0e7 JUST=CENTER]'); 539 if charcase='69' then call define 539 ! ('charcase','style','STYLE=[BACKGROUND=CXccd14b JUST=CENTER]'); 540 if charcase='70' then call define 540 ! ('charcase','style','STYLE=[BACKGROUND=CXccd1af JUST=CENTER]'); 541 if charcase='71' then call define 541 ! ('charcase','style','STYLE=[BACKGROUND=CXccd213 JUST=CENTER]'); 542 if charcase='72' then call define 542 ! ('charcase','style','STYLE=[BACKGROUND=CXccd277 JUST=CENTER]'); 543 if charcase='73' then call define 543 ! ('charcase','style','STYLE=[BACKGROUND=CXccd2db JUST=CENTER]'); 544 if charcase='74' then call define 544 ! ('charcase','style','STYLE=[BACKGROUND=CXccd33f JUST=CENTER]'); 545 if charcase='75' then call define 545 ! ('charcase','style','STYLE=[BACKGROUND=CXccd3a3 JUST=CENTER]'); 546 if charcase='76' then call define 546 ! ('charcase','style','STYLE=[BACKGROUND=CXccd407 JUST=CENTER]'); 547 if charcase='77' then call define 547 ! ('charcase','style','STYLE=[BACKGROUND=CX99ccff JUST=CENTER]'); 548 if charcase='78' then call define 548 ! ('charcase','style','STYLE=[BACKGROUND=CX99cd63 JUST=CENTER]'); 549 if charcase='79' then call define 549 ! ('charcase','style','STYLE=[BACKGROUND=CX99cdc7 JUST=CENTER]'); 550 if charcase='80' then call define 550 ! ('charcase','style','STYLE=[BACKGROUND=CX99ce2b JUST=CENTER]'); 551 if charcase='81' then call define 551 ! ('charcase','style','STYLE=[BACKGROUND=CX99ce8f JUST=CENTER]'); 552 if charcase='82' then call define 552 ! ('charcase','style','STYLE=[BACKGROUND=CX99cef3 JUST=CENTER]'); 553 if charcase='83' then call define 553 ! ('charcase','style','STYLE=[BACKGROUND=CX99cf57 JUST=CENTER]'); 554 if charcase='84' then call define 554 ! ('charcase','style','STYLE=[BACKGROUND=CX99cfbb JUST=CENTER]'); 555 if charcase='85' then call define 555 ! ('charcase','style','STYLE=[BACKGROUND=CX99d01f JUST=CENTER]'); 556 if charcase='86' then call define 556 ! ('charcase','style','STYLE=[BACKGROUND=CX99d083 JUST=CENTER]'); 557 if charcase='87' then call define 557 ! ('charcase','style','STYLE=[BACKGROUND=CX99d0e7 JUST=CENTER]'); 19 The SAS System 09:50 Wednesday, October 21, 2009 558 if charcase='88' then call define 558 ! ('charcase','style','STYLE=[BACKGROUND=CX99d14b JUST=CENTER]'); 559 if charcase='89' then call define 559 ! ('charcase','style','STYLE=[BACKGROUND=CX99d1af JUST=CENTER]'); 560 if charcase='90' then call define 560 ! ('charcase','style','STYLE=[BACKGROUND=CX99d213 JUST=CENTER]'); 561 if charcase='91' then call define 561 ! ('charcase','style','STYLE=[BACKGROUND=CX99d277 JUST=CENTER]'); 562 if charcase='92' then call define 562 ! ('charcase','style','STYLE=[BACKGROUND=CX99d2db JUST=CENTER]'); 563 if charcase='93' then call define 563 ! ('charcase','style','STYLE=[BACKGROUND=CX99d33f JUST=CENTER]'); 564 if charcase='94' then call define 564 ! ('charcase','style','STYLE=[BACKGROUND=CX99d3a3 JUST=CENTER]'); 565 if charcase='95' then call define 565 ! ('charcase','style','STYLE=[BACKGROUND=CX99d407 JUST=CENTER]'); 566 if charcase='96' then call define 566 ! ('charcase','style','STYLE=[BACKGROUND=CXffcc99 JUST=CENTER]'); 567 if charcase='97' then call define 567 ! ('charcase','style','STYLE=[BACKGROUND=CXffccfd JUST=CENTER]'); 568 if charcase='98' then call define 568 ! ('charcase','style','STYLE=[BACKGROUND=CXffcd61 JUST=CENTER]'); 569 if charcase='99' then call define 569 ! ('charcase','style','STYLE=[BACKGROUND=CXffcdc5 JUST=CENTER]'); 570 if charcase='100' then call define 570 ! ('charcase','style','STYLE=[BACKGROUND=CXffce29 JUST=CENTER]'); 571 if charcase='101' then call define 571 ! ('charcase','style','STYLE=[BACKGROUND=CXffce8d JUST=CENTER]'); 572 if charcase='102' then call define 572 ! ('charcase','style','STYLE=[BACKGROUND=CXffcef1 JUST=CENTER]'); 573 if charcase='103' then call define 573 ! ('charcase','style','STYLE=[BACKGROUND=CXffcf55 JUST=CENTER]'); 574 if charcase='104' then call define 574 ! ('charcase','style','STYLE=[BACKGROUND=CXffcfb9 JUST=CENTER]'); 575 if charcase='105' then call define 575 ! ('charcase','style','STYLE=[BACKGROUND=CXffd01d JUST=CENTER]'); 576 if charcase='106' then call define 576 ! ('charcase','style','STYLE=[BACKGROUND=CXffd081 JUST=CENTER]'); 577 if charcase='107' then call define 577 ! ('charcase','style','STYLE=[BACKGROUND=CXffd0e5 JUST=CENTER]'); 578 if charcase='108' then call define 578 ! ('charcase','style','STYLE=[BACKGROUND=CXffd149 JUST=CENTER]'); 579 if charcase='109' then call define 579 ! ('charcase','style','STYLE=[BACKGROUND=CXffd1ad JUST=CENTER]'); 580 if charcase='110' then call define 580 ! ('charcase','style','STYLE=[BACKGROUND=CXffd211 JUST=CENTER]'); 581 if charcase='111' then call define 581 ! ('charcase','style','STYLE=[BACKGROUND=CXffd275 JUST=CENTER]'); 582 if charcase='112' then call define 582 ! ('charcase','style','STYLE=[BACKGROUND=CXffd2d9 JUST=CENTER]'); 583 if charcase='113' then call define 583 ! ('charcase','style','STYLE=[BACKGROUND=CXffd33d JUST=CENTER]'); 584 endcomp; 20 The SAS System 09:50 Wednesday, October 21, 2009 585 586 compute obs; 587 dobs + 1; 588 obs = dobs; 589 endcompute; 590 run; NOTE: There were 39 observations read from the data set WORK.IE. NOTE: PROCEDURE REPORT used (Total process time): real time 0.17 seconds cpu time 0.06 seconds 591 run; 592 ods html close; 593 ods listing; NOTE: PROCEDURE DISPLAY used (Total process time): real time 4.38 seconds cpu time 3.76 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 6.70 seconds cpu time 6.31 seconds