1 The SAS System 14:48 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.78 seconds cpu time 0.54 seconds NOTE: AUTOEXEC processing beginning; file is C:\test\cdisc_test\testing\saspgm\autoexec.sas. NOTE: AUTOEXEC processing completed. 1 /*------------------------------------------------------------* 2 * program: cdisc12.sas * 3 * Description: Verify dataset names of case #10 * 4 * By: Sy Truong, 9/18/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 *** Create some data to be selected ***; 10 data templib.cdisc12a (label="Does Not Match");; 11 attrib race length=8 label="Race"; 12 attrib sex length=$8 label="Sex"; 13 attrib newvar length=$8 label="Wrong Label"; 14 run; 15 16 %cdisc(datlib=templib,datname=cdisc12a); 17 18 *** Create some data to be selected ***; 19 data templib.dm (label="Demo Does Not Match");; 20 attrib race length=8 label="Race"; 21 attrib sex length=$8 label="Sex"; 22 attrib newvar length=$8 label="Wrong Label"; 23 run; 24 2 The SAS System 14:48 Monday, August 22, 2005 25 %cdisc(datlib=templib,datname=dm); 26 27 *** Create some data to be selected ***; 28 data templib.cm (label="Concomitant Medications");; 29 attrib race length=8 label="Race"; 30 attrib sex length=$8 label="Sex"; 31 attrib newvar length=$8 label="Wrong Label"; 32 run; 33 34 %cdisc(datlib=templib,datname=cm); 35 */ 36 37 *** Create some data to be selected ***; 38 data templib.ae (label="test");; 39 attrib race length=8 label="Race"; 40 attrib sex length=$8 label="Sex"; 41 attrib newvar length=$8 label="Wrong Label"; 42 run; NOTE: Variable race is uninitialized. NOTE: Variable sex is uninitialized. NOTE: Variable newvar is uninitialized. NOTE: The data set TEMPLIB.AE has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.07 seconds 43 44 %cdisc(datlib=templib,datname=ae); NOTE: Libref _TEMPLIB was successfully assigned as follows: Engine: V8 Physical Name: C:\test\cdisc_test\testing\saspgm 45 proc sort data = work.cdisc; 46 by libname datname datlab variable case; 47 run; NOTE: There were 6 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 6 observations and 11 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.03 seconds 48 49 proc format; 50 *** Generate the comments for the CDISC evaluation case number ***; 51 value casefmt 52 1 = '1' 53 2 = '2' 3 The SAS System 14:48 Monday, August 22, 2005 54 3 = '3' 55 4 = '4' 56 5 = '5' 57 6 = '6' 58 7 = '7' 59 8 = '8' 60 9 = '9' 61 10 = '10' 62 11 = '11' 63 12 = '12' 64 13 = '13' 65 14 = '14' 66 15 = '15' 67 16 = '16'; NOTE: Format CASEFMT has been output. 68 69 *** Generate the format for the bookmark of variables ***; 70 value $bookfmt 71 "ae.race" = 'ae.race' 72 "ae.sex" = 'ae.sex' 73 "ae.newvar" = 'ae.newvar' 74 ; NOTE: Format $BOOKFMT has been output. 75 76 *** Generate the format for dataset linking ***; 77 value $datfmt 78 "AE" = 'AE
' 79 ; NOTE: Format $DATFMT has been output. 80 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.14 seconds cpu time 0.00 seconds 81 82 data work.cdisc; 83 set work.cdisc; 84 by libname datname datlab variable case; 85 86 attrib datvar label="Dataset and Variable" length=$100 format=$bookfmt.; 87 88 if variable ne '' then 89 datvar = compress(lowcase(datname) || "." || lowcase(variable)); 90 else datvar = lowcase(datname); 91 92 format case casefmt.; 93 format datname $datfmt.; 94 run; 4 The SAS System 14:48 Monday, August 22, 2005 NOTE: There were 6 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 6 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 95 96 *** Remove the special characters ***; 97 proc template; 98 define style styles.test; 99 parent=styles.default; 100 style byline from titlesandfooters / 101 protectspecialchars=off; 102 end; NOTE: Overwriting existing template/link: Styles.Test NOTE: STYLE 'Styles.Test' has been saved to: SASUSER.TEMPLAT 103 run; NOTE: PROCEDURE TEMPLATE used (Total process time): real time 0.06 seconds cpu time 0.06 seconds 104 105 proc sort data = work.cdisc; 106 by libname datname datlab variable case; 107 run; NOTE: There were 6 observations read from the data set WORK.CDISC. NOTE: The data set WORK.CDISC has 6 observations and 12 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 108 109 ods listing close; 110 filename temp "cdisc12.html"; 111 ods html3 file=temp; NOTE: Writing HTML3 Body file: TEMP 112 proc report data = work.cdisc (drop=usrname datetime) nowd 113 style(header)=[font_size=2] 114 style(column)=[font_size=2]; 115 by datname datlab; 116 column libname datvar label type length case comment; 117 118 title1 height=2 "--- Findings from CDISC Evaluation ---"; 119 footnote1 height=2 "Generated on: 08/22/2005, 2:48:53 pm, Nguyen Thi Tra Nhi" 119 ! ; 120 footnote2 height=2 "Located at: C:\test\cdisc_test\testing\data"; 121 format datname $datfmt.; 5 The SAS System 14:48 Monday, August 22, 2005 122 run; NOTE: There were 6 observations read from the data set WORK.CDISC. NOTE: PROCEDURE REPORT used (Total process time): real time 0.10 seconds cpu time 0.04 seconds 123 ods html3 close; 124 ods listing; 125 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.37 seconds cpu time 0.60 seconds 126 NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 2.34 seconds cpu time 1.26 seconds