1 The SAS System 16:07 Monday, August 22, 2005 NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0) Licensed to META-XCEED INC, Site 0035729001. NOTE: This session is executing on the WIN_PRO platform. NOTE: SAS initialization used: real time 1.26 seconds cpu time 0.31 seconds NOTE: AUTOEXEC processing beginning; file is C:\test\cdisc_test\testing\saspgm\autoexec.sas. NOTE: AUTOEXEC processing completed. 1 /*------------------------------------------------------------* 2 * program: cdisc18.sas * 3 * Description: Verify the require fields of case #16 * 4 * By: Anh Bui, 04/05/2005 * 5 *-------------------------------------------------------------*/ 6 7 libname templib '../data'; NOTE: Libref TEMPLIB was successfully assigned as follows: Engine: V8 Physical Name: C:\test\cdisc_test\testing\data 8 ***%include "cdisc.sas"; 9 data templib.cdisc21 (label="Verify Case #17"); 10 attrib 11 var1 label="Gender (Female/Male)" length=$6 12 var2 label="Sex (Female/Male)" length=$10 13 var3 label="Gender (Female/Male)" length=6 14 var4 label="Sex (Female/Male)" length=$6 15 var5 label="Condition 1 (1/0)" length=8 16 var6 label="Condition 2 (1/0)" length=6 17 var7 label="Condition 3 (Y/N)" length=$8 18 var8 label="Condition 4 (Y/N)" length=8; 19 run; NOTE: Variable var1 is uninitialized. NOTE: Variable var2 is uninitialized. NOTE: Variable var3 is uninitialized. NOTE: Variable var4 is uninitialized. NOTE: Variable var5 is uninitialized. NOTE: Variable var6 is uninitialized. NOTE: Variable var7 is uninitialized. NOTE: Variable var8 is uninitialized. NOTE: The data set TEMPLIB.CDISC21 has 1 observations and 8 variables. NOTE: DATA statement used: real time 0.39 seconds 2 The SAS System 16:07 Monday, August 22, 2005 cpu time 0.01 seconds 20 21 %cdisc(datlib=templib,datname=cdisc21); NOTE: Libref _TEMPLIB was successfully assigned as follows: Engine: V8 Physical Name: C:\test\cdisc_test\testing\saspgm comment=Variables VAR1, VAR4 and variables VAR2, VAR3 have same parenthesis values, but they are not same types or lengths comment=Variables VAR1, VAR4 and variables VAR2, VAR3 have same parenthesis values, but they are not same types or lengths comment=Variables VAR1, VAR4 and variables VAR2, VAR3 have same parenthesis values, but they are not same types or lengths comment=Variables VAR1, VAR4 and variables VAR2, VAR3 have same parenthesis values, but they are not same types or lengths comment=Variable VAR5 and variable VAR6 have same parenthesis values, but they are not same types or lengths comment=Variable VAR5 and variable VAR6 have same parenthesis values, but they are not same types or lengths comment=Variable VAR7 and variable VAR8 have same parenthesis values, but they are not same types or lengths comment=Variable VAR7 and variable VAR8 have same parenthesis values, but they are not same types or lengths 22 proc sort data = work.cdisc; 23 by libname datname datlab variable case; 24 run; NOTE: There were 10 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 10 observations and 11 variables. NOTE: PROCEDURE SORT used: real time 0.04 seconds cpu time 0.00 seconds 25 26 proc format; 27 *** Generate the comments for the CDISC evaluation case number ***; 28 value casefmt 29 1 = '1' 30 2 = '2' 31 3 = '3' 32 4 = '4' 33 5 = '5' 34 6 = '6' 35 7 = '7' 36 8 = '8' 37 9 = '9' 38 10 = '10' 39 11 = '11' 3 The SAS System 16:07 Monday, August 22, 2005 40 12 = '12' 41 13 = '13' 42 14 = '14' 43 15 = '15' 44 16 = '16'; NOTE: Format CASEFMT has been output. 45 46 *** Generate the format for the bookmark of variables ***; 47 value $bookfmt 48 "cdisc21.var1" = 'cdisc21.var1' 49 "cdisc21.var2" = 'cdisc21.var2' 50 "cdisc21.var3" = 'cdisc21.var3' 51 "cdisc21.var4" = 'cdisc21.var4' 52 "cdisc21.var5" = 'cdisc21.var5' 53 "cdisc21.var6" = 'cdisc21.var6' 54 "cdisc21.var7" = 'cdisc21.var7' 55 "cdisc21.var8" = 'cdisc21.var8' 56 ; NOTE: Format $BOOKFMT has been output. 57 58 *** Generate the format for dataset linking ***; 59 value $datfmt 60 "AE" = 'AE
' 61 "CDISC15" = 'CDISC15
' 62 "CDISC15A" = 'CDISC15A
' 63 "CDISC15B" = 'CDISC15B
' 64 "CDISC21" = 'CDISC21
' 65 ; NOTE: Format $DATFMT has been output. 66 run; NOTE: PROCEDURE FORMAT used: real time 0.07 seconds cpu time 0.00 seconds 67 68 data work.cdisc; 69 set work.cdisc; 70 by libname datname datlab variable case; 71 72 attrib datvar label="Dataset and Variable" length=$100 format=$bookfmt.; 73 74 if variable ne '' then 75 datvar = compress(lowcase(datname) || "." || lowcase(variable)); 76 else datvar = lowcase(datname); 77 78 format case casefmt.; 79 format datname $datfmt.; 80 run; 4 The SAS System 16:07 Monday, August 22, 2005 NOTE: There were 10 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 10 observations and 12 variables. NOTE: DATA statement used: real time 0.03 seconds cpu time 0.00 seconds 81 82 *** Remove the special characters ***; 83 proc template; 84 define style styles.test; 85 parent=styles.default; 86 style byline from titlesandfooters / 87 protectspecialchars=off; 88 end; NOTE: Overwriting existing template/link: Styles.Test NOTE: STYLE 'Styles.Test' has been saved to: SASUSER.TEMPLAT 89 run; NOTE: PROCEDURE TEMPLATE used: real time 0.51 seconds cpu time 0.01 seconds 90 91 proc sort data = work.cdisc; 92 by libname datname datlab variable case; 93 run; NOTE: There were 10 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 10 observations and 12 variables. NOTE: PROCEDURE SORT used: real time 0.01 seconds cpu time 0.00 seconds 94 95 ods listing close; 96 filename temp "cdisc18.html"; 97 ods html file=temp; NOTE: Writing HTML Body file: TEMP 98 proc report data = work.cdisc (drop=usrname datetime) nowd 99 style(header)=[font_size=2] 100 style(column)=[font_size=2]; 101 by datname datlab; 102 column libname datvar label type length case comment; 103 define comment /display width=200; 104 title1 height=2 "--- Findings from CDISC Evaluation ---"; 105 footnote1 height=2 "Generated on: 08/22/2005, 4:07:27 pm, Nguyen Thi Tra Nhi" 105 ! ; 106 footnote2 height=2 "Located at: C:\test\cdisc_test\testing\data"; 107 format datname $datfmt.; 5 The SAS System 16:07 Monday, August 22, 2005 108 run; NOTE: There were 10 observations read from the data set WORK.CDISC. NOTE: PROCEDURE REPORT used: real time 1.01 seconds cpu time 0.04 seconds 109 ods html close; 110 ods listing; 111 NOTE: PROCEDURE DISPLAY used: real time 4.59 seconds cpu time 0.40 seconds 112 NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 6.67 seconds cpu time 1.07 seconds