1                                                          The SAS System                           10:59 Wednesday, August 17, 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.82 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:     cdisc2b.sas                                    *
3          * Description: Verify input multiple datasets                 *
4          * By:          Sy Truong, 9/15/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.cdisc2b_1 (label="Demographics");
11            usubjid='';
12            b=2;
13            c=3;
14         run;

NOTE: The data set TEMPLIB.CDISC2B_1 has 1 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.15 seconds
      cpu time            0.07 seconds
      

15         
16         data templib.cdisc2b_2 (label="Demographics");
17            a=1;
2                                       The SAS System         10:59 Wednesday, August 17, 2005

18            b=2;
19            c=3;
20         run;

NOTE: The data set TEMPLIB.CDISC2B_2 has 1 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

21         
22         data templib.cdisc2b_3 (label="Demographics");
23            a=1;
24            b=2;
25            c=3;
26         run;

NOTE: The data set TEMPLIB.CDISC2B_3 has 1 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

27         
28         
29         *** Test multiple datasets to capture all ***;
30         %cdisc (datlib=templib, datname= cdisc2b_1 cdisc2b_2 cdisc2b_3);
NOTE: Libref _TEMPLIB was successfully assigned as follows: 
      Engine:        V8 
      Physical Name: C:\test\cdisc_test\testing\saspgm

31               proc sort data = work.cdisc;
32                  by libname datname datlab variable case;
33               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 (Total process time):
      real time           0.06 seconds
      cpu time            0.01 seconds
      

34         
35               proc format;
36                  *** Generate the comments for the CDISC evaluation case number ***;
37                  value casefmt
38                  1 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#1">1</a>'
39                  2 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#2">2</a>'
40                  3 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#3">3</a>'
41                  4 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#4">4</a>'
42                  5 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#5">5</a>'
3                                       The SAS System         10:59 Wednesday, August 17, 2005

43                  6 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#6">6</a>'
44                  7 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#7">7</a>'
45                  8 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#8">8</a>'
46                  9 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#9">9</a>'
47                  10 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#10">10</a>'
48                  11 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#11">11</a>'
49                  12 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#12">12</a>'
50                  13 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#13">13</a>'
51                  14 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#14">14</a>'
52                  15 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#15">15</a>'
53                  16 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#16">16</a>';
NOTE: Format CASEFMT has been output.
54         
55                  *** Generate the format for the bookmark of variables ***;
56                  value $bookfmt
57                  "cdisc2b_1.usubjid" = '<a name="cdisc2b_1.usubjid">cdisc2b_1.usubjid</a>'
58                  "cdisc2b_1.b" = '<a name="cdisc2b_1.b">cdisc2b_1.b</a>'
59                  "cdisc2b_1.c" = '<a name="cdisc2b_1.c">cdisc2b_1.c</a>'
60                  "cdisc2b_2.a" = '<a name="cdisc2b_2.a">cdisc2b_2.a</a>'
61                  "cdisc2b_2.b" = '<a name="cdisc2b_2.b">cdisc2b_2.b</a>'
62                  "cdisc2b_2.c" = '<a name="cdisc2b_2.c">cdisc2b_2.c</a>'
63                  "cdisc2b_3.a" = '<a name="cdisc2b_3.a">cdisc2b_3.a</a>'
64                  "cdisc2b_3.b" = '<a name="cdisc2b_3.b">cdisc2b_3.b</a>'
65                  "cdisc2b_3.c" = '<a name="cdisc2b_3.c">cdisc2b_3.c</a>'
66                  ;
NOTE: Format $BOOKFMT has been output.
67         
68                  *** Generate the format for dataset linking ***;
69                  value $datfmt
70                  "AE" = '<a name="AE">AE</a><br>'
71                  "AE1" = '<a name="AE1">AE1</a><br>'
72                  "AE2" = '<a name="AE2">AE2</a><br>'
73                  "AE3" = '<a name="AE3">AE3</a><br>'
74                  "AE3A" = '<a name="AE3A">AE3A</a><br>'
75                  "AETEST1" = '<a name="AETEST1">AETEST1</a><br>'
76                  "CDISC10" = '<a name="CDISC10">CDISC10</a><br>'
77                  "CDISC11" = '<a name="CDISC11">CDISC11</a><br>'
78                  "CDISC12A" = '<a name="CDISC12A">CDISC12A</a><br>'
79                  "CDISC13A" = '<a name="CDISC13A">CDISC13A</a><br>'
80                  "CDISC14" = '<a name="CDISC14">CDISC14</a><br>'
81                  "CDISC15A" = '<a name="CDISC15A">CDISC15A</a><br>'
82                  "CDISC15B" = '<a name="CDISC15B">CDISC15B</a><br>'
83                  "CDISC18" = '<a name="CDISC18">CDISC18</a><br>'
84                  "CDISC2" = '<a name="CDISC2">CDISC2</a><br>'
85                  "CDISC21" = '<a name="CDISC21">CDISC21</a><br>'
86                  "CDISC2B_1" = '<a name="CDISC2B_1">CDISC2B_1</a><br>'
87                  "CDISC2B_2" = '<a name="CDISC2B_2">CDISC2B_2</a><br>'
88                  "CDISC2B_3" = '<a name="CDISC2B_3">CDISC2B_3</a><br>'
89                  "CDISC2_B" = '<a name="CDISC2_B">CDISC2_B</a><br>'
90                  "CDISC2_C" = '<a name="CDISC2_C">CDISC2_C</a><br>'
91                  "CDISC3A" = '<a name="CDISC3A">CDISC3A</a><br>'
4                                       The SAS System         10:59 Wednesday, August 17, 2005

92                  "CDISC3B" = '<a name="CDISC3B">CDISC3B</a><br>'
93                  "CDISC4" = '<a name="CDISC4">CDISC4</a><br>'
94                  "CDISC5" = '<a name="CDISC5">CDISC5</a><br>'
95                  "CDISC6" = '<a name="CDISC6">CDISC6</a><br>'
96                  "CDISC7" = '<a name="CDISC7">CDISC7</a><br>'
97                  "CDISC8" = '<a name="CDISC8">CDISC8</a><br>'
98                  "CDISC9" = '<a name="CDISC9">CDISC9</a><br>'
99                  "CM" = '<a name="CM">CM</a><br>'
100                 "DM" = '<a name="DM">DM</a><br>'
101                 "NOTDM" = '<a name="NOTDM">NOTDM</a><br>'
102                 "RELREC" = '<a name="RELREC">RELREC</a><br>'
103                 ;
NOTE: Format $DATFMT has been output.
104              run;

NOTE: PROCEDURE FORMAT used (Total process time):
      real time           0.17 seconds
      cpu time            0.00 seconds
      

105        
106              data work.cdisc;
107                 set work.cdisc;
108                 by libname datname datlab variable case;
109        
110                 attrib datvar label="Dataset and Variable" length=$100 format=$bookfmt.;
111        
112                 if variable ne '' then
113                 datvar = compress(lowcase(datname) || "." || lowcase(variable));
114                 else datvar = lowcase(datname);
115        
116                 format case casefmt.;
117                 format datname $datfmt.;
118              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: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

119        
120              *** Remove the special characters ***;
121              proc template;
122                 define style styles.test;
123                 parent=styles.default;
124                 style byline from titlesandfooters /
125                    protectspecialchars=off;
126                 end;
ERROR: Template 'Styles.Test' was unable to write to template store!
ERROR: Template 'Styles.Test' was unable to write to template store!
ERROR: Template 'Styles.Test' was unable to write to template store!
5                                       The SAS System         10:59 Wednesday, August 17, 2005

127              run;
NOTE: PROCEDURE TEMPLATE used (Total process time):
      real time           0.07 seconds
      cpu time            0.06 seconds
      

128        
129              proc sort data = work.cdisc;
130                 by libname datname datlab variable case;
131              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 (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

132        
133              ods listing close;
134              filename temp "cdisc2b.html";
135              ods html3 file=temp;
NOTE: Writing HTML3 Body file: TEMP
136              proc report data = work.cdisc (drop=usrname datetime) nowd
137                 style(header)=[font_size=2]
138                 style(column)=[font_size=2];
139              by datname datlab;
140              column libname datvar label type length case comment;
141        
142              title1 height=2 "--- Findings from CDISC Evaluation ---";
143              footnote1 height=2 "Generated on: 08/17/2005, 10:59:18 am, Nguyen Thi Tra Nhi"
143      ! ;
144              footnote2 height=2 "Located at: C:\test\cdisc_test\testing\data";
145              format datname $datfmt.;
146              run;

NOTE: There were 10 observations read from the data set WORK.CDISC.
NOTE: PROCEDURE REPORT used (Total process time):
      real time           0.14 seconds
      cpu time            0.09 seconds
      

147              ods html3 close;
148              ods listing;
149        

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.39 seconds
6                                       The SAS System         10:59 Wednesday, August 17, 2005

      cpu time            0.56 seconds
      

150        

ERROR: Errors printed on page 4.
ERROR: Errors printed on page 4.
ERROR: Errors printed on page 4.

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
      real time           2.50 seconds
      cpu time            1.28 seconds