1 The SAS System 15:00 Monday, August 22, 2005 NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead. NOTE: All registry changes will be lost at the end of the session. WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, you will not see registry customizations during this session. NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead. NOTE: All profile changes will be lost at the end of the session. NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) 9.1 (TS1M3) Licensed to META-XCEED INC, Site 0035729001. NOTE: This session is executing on the XP_HOME platform. NOTE: SAS initialization used: real time 0.86 seconds cpu time 0.59 seconds NOTE: AUTOEXEC processing beginning; file is C:\test\cdisc_test\testing\saspgm\autoexec.sas. NOTE: AUTOEXEC processing completed. 1 /*------------------------------------------------------------* 2 * program: cdisc15.sas * 3 * Description: Verify SEQ values of case #13 * 4 * By: Sy Truong, 9/19/2003 * 5 *-------------------------------------------------------------*/ 6 7 libname templib '../data'; NOTE: Libref TEMPLIB was successfully assigned as follows: Engine: V9 Physical Name: C:\test\cdisc_test\testing\data 8 /* 9 data templib.cdisc15a; 10 attrib USUBJID length=$8 label="Subjet ID"; 11 attrib AE length=$40 label="Adverse Event"; 12 attrib AESEQ length=8 label="Adverse Event Sequence"; 13 14 usubjid = '101'; 15 ae = "Happy"; 16 aeseq = 1; 17 output; 18 19 usubjid = '102'; 20 ae = "Happy"; 21 aeseq = 1; 22 output; 23 24 usubjid = '101'; 2 The SAS System 15:00 Monday, August 22, 2005 25 ae = "Happy"; 26 aeseq = 2; 27 output; 28 run; 29 30 %cdisc(datlib=templib,datname=cdisc15a); 31 */ 32 data templib.cdisc15; 33 attrib USUBJID length=$8 label="Subjet ID"; 34 attrib AE length=$40 label="Adverse Event"; 35 attrib AESEQ length=8 label="Adverse Event Sequence"; 36 37 usubjid = '101'; 38 ae = "Happy"; 39 aeseq = 1; 40 output; 41 42 usubjid = '101'; 43 ae = "Happy"; 44 aeseq = 1; 45 output; 46 47 usubjid = '101'; 48 ae = "Happy"; 49 aeseq = 2; 50 output; 51 run; NOTE: The data set TEMPLIB.CDISC15 has 3 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.06 seconds 52 53 %cdisc(datlib=templib,datname=cdisc15); NOTE: Libref _TEMPLIB was successfully assigned as follows: Engine: V8 Physical Name: C:\test\cdisc_test\testing\saspgm NOTE: Table WORK.TEST13 created, with 2 rows and 3 columns. 54 proc sort data = work.cdisc; 55 by libname datname datlab variable case; 56 run; NOTE: There were 4 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 4 observations and 11 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 3 The SAS System 15:00 Monday, August 22, 2005 57 58 proc format; 59 *** Generate the comments for the CDISC evaluation case number ***; 60 value casefmt 61 1 = '1' 62 2 = '2' 63 3 = '3' 64 4 = '4' 65 5 = '5' 66 6 = '6' 67 7 = '7' 68 8 = '8' 69 9 = '9' 70 10 = '10' 71 11 = '11' 72 12 = '12' 73 13 = '13' 74 14 = '14' 75 15 = '15' 76 16 = '16'; NOTE: Format CASEFMT has been output. 77 78 *** Generate the format for the bookmark of variables ***; 79 value $bookfmt 80 "cdisc15.usubjid" = 'cdisc15.usubjid' 81 "cdisc15.ae" = 'cdisc15.ae' 82 "cdisc15.aeseq" = 'cdisc15.aeseq' 83 ; NOTE: Format $BOOKFMT has been output. 84 85 *** Generate the format for dataset linking ***; 86 value $datfmt 87 "AE" = 'AE
' 88 "CDISC15" = 'CDISC15
' 89 "CDISC15A" = 'CDISC15A
' 90 "CDISC15B" = 'CDISC15B
' 91 ; NOTE: Format $DATFMT has been output. 92 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.04 seconds cpu time 0.00 seconds 93 94 data work.cdisc; 95 set work.cdisc; 96 by libname datname datlab variable case; 4 The SAS System 15:00 Monday, August 22, 2005 97 98 attrib datvar label="Dataset and Variable" length=$100 format=$bookfmt.; 99 100 if variable ne '' then 101 datvar = compress(lowcase(datname) || "." || lowcase(variable)); 102 else datvar = lowcase(datname); 103 104 format case casefmt.; 105 format datname $datfmt.; 106 run; NOTE: There were 4 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 4 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 107 108 *** Remove the special characters ***; 109 proc template; 110 define style styles.test; 111 parent=styles.default; 112 style byline from titlesandfooters / 113 protectspecialchars=off; 114 end; NOTE: Overwriting existing template/link: Styles.Test NOTE: STYLE 'Styles.Test' has been saved to: SASUSER.TEMPLAT 115 run; NOTE: PROCEDURE TEMPLATE used (Total process time): real time 0.07 seconds cpu time 0.03 seconds 116 117 proc sort data = work.cdisc; 118 by libname datname datlab variable case; 119 run; NOTE: There were 4 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 4 observations and 12 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 120 121 ods listing close; 122 filename temp "cdisc15.html"; 123 ods html3 file=temp; NOTE: Writing HTML3 Body file: TEMP 5 The SAS System 15:00 Monday, August 22, 2005 124 proc report data = work.cdisc (drop=usrname datetime) nowd 125 style(header)=[font_size=2] 126 style(column)=[font_size=2]; 127 by datname datlab; 128 column libname datvar label type length case comment; 129 130 title1 height=2 "--- Findings from CDISC Evaluation ---"; 131 footnote1 height=2 "Generated on: 08/22/2005, 3:00:35 pm, Nguyen Thi Tra Nhi" 131 ! ; 132 footnote2 height=2 "Located at: C:\test\cdisc_test\testing\data"; 133 format datname $datfmt.; 134 run; NOTE: There were 4 observations read from the data set WORK.CDISC. NOTE: PROCEDURE REPORT used (Total process time): real time 0.12 seconds cpu time 0.03 seconds 135 ods html3 close; 136 ods listing; 137 NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead. NOTE: All profile changes will be lost at the end of the session. NOTE: PROCEDURE DISPLAY used (Total process time): real time 1.42 seconds cpu time 0.54 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 2.46 seconds cpu time 1.21 seconds