1                                                          The SAS System                              10:33 Monday, August 15, 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.96 seconds
      cpu time            0.54 seconds
      

NOTE: AUTOEXEC processing beginning; file is C:\test\cdisc_test\saspgm\autoexec.sas.


NOTE: AUTOEXEC processing completed.

1          /*------------------------------------------------------------*
2          * program:     cdisc2.sas                                     *
3          * Description: Verify wild card selection with asterisk and   *
4          *              missing datname.                               *
5          * By:          Sy Truong, 9/15/2003                           *
6          *-------------------------------------------------------------*/
7          
8          libname templib '../data';
NOTE: Libref TEMPLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\test\cdisc_test\data
9          
10         *** Create some data to be selected ***;
11         data templib.cdisc2 (label="Demographics");
12         run;

NOTE: The data set TEMPLIB.CDISC2 has 1 observations and 0 variables.
NOTE: DATA statement used (Total process time):
      real time           0.10 seconds
      cpu time            0.09 seconds
      

13         
14         data templib.cdisc2_b (label="Demographics");
15         run;

NOTE: The data set TEMPLIB.CDISC2_B has 1 observations and 0 variables.
2                                       The SAS System            10:33 Monday, August 15, 2005

NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

16         
17         data templib.cdisc2_c (label="Demographics");
18         run;

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

19         
20         
21         *** Test wild card ***;
22         %cdisc(datlib=templib,datname=cdisc2_*);
NOTE: Libref _TEMPLIB was successfully assigned as follows: 
      Engine:        V8 
      Physical Name: C:\test\cdisc_test\saspgm

23               proc sort data = work.cdisc;
24                  by libname datname datlab variable case;
25               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
      

26         
27               proc format;
28                  *** Generate the comments for the CDISC evaluation case number ***;
29                  value casefmt
30                  1 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#1">1</a>'
31                  2 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#2">2</a>'
32                  3 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#3">3</a>'
33                  4 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#4">4</a>'
34                  5 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#5">5</a>'
35                  6 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#6">6</a>'
36                  7 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#7">7</a>'
37                  8 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#8">8</a>'
38                  9 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#9">9</a>'
39                  10 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#10">10</a>'
40                  11 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#11">11</a>'
41                  12 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#12">12</a>'
42                  13 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#13">13</a>'
3                                       The SAS System            10:33 Monday, August 15, 2005

43                  14 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#14">14</a>'
44                  15 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#15">15</a>'
45                  16 = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#16">16</a>';
NOTE: Format CASEFMT has been output.
46         
47                  *** Generate the format for the bookmark of variables ***;
48                  value $bookfmt
49                  ;
NOTE: Format $BOOKFMT has been output.
50         
51                  *** Generate the format for dataset linking ***;
52                  value $datfmt
53                  "AE" = '<a name="AE">AE</a><br>'
54                  "AE1" = '<a name="AE1">AE1</a><br>'
55                  "AE2" = '<a name="AE2">AE2</a><br>'
56                  "AE3" = '<a name="AE3">AE3</a><br>'
57                  "AETEST1" = '<a name="AETEST1">AETEST1</a><br>'
58                  "CDISC2" = '<a name="CDISC2">CDISC2</a><br>'
59                  "CDISC2_B" = '<a name="CDISC2_B">CDISC2_B</a><br>'
60                  "CDISC2_C" = '<a name="CDISC2_C">CDISC2_C</a><br>'
61                  "RELREC" = '<a name="RELREC">RELREC</a><br>'
62                  ;
NOTE: Format $DATFMT has been output.
63               run;

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

64         
65               data work.cdisc;
66                  set work.cdisc;
67                  by libname datname datlab variable case;
68         
69                  attrib datvar label="Dataset and Variable" length=$100 format=$bookfmt.;
70         
71                  if variable ne '' then
72                  datvar = compress(lowcase(datname) || "." || lowcase(variable));
73                  else datvar = lowcase(datname);
74         
75                  format case casefmt.;
76                  format datname $datfmt.;
77               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: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      
4                                       The SAS System            10:33 Monday, August 15, 2005


78         
79               *** Remove the special characters ***;
80               proc template;
81                  define style styles.test;
82                  parent=styles.default;
83                  style byline from titlesandfooters /
84                     protectspecialchars=off;
85                  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!
86               run;
NOTE: PROCEDURE TEMPLATE used (Total process time):
      real time           0.09 seconds
      cpu time            0.04 seconds
      

87         
88               proc sort data = work.cdisc;
89                  by libname datname datlab variable case;
90               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.01 seconds
      cpu time            0.00 seconds
      

91         
92               ods listing close;
93               ods html3 file="cdisc2.html" style=styles.test;
NOTE: Writing HTML3 Body file: cdisc2.html
94               proc report data = work.cdisc (drop=usrname datetime) nowd
95                  style(header)=[font_size=2]
96                  style(column)=[font_size=2];
97               by datname datlab;
98               column libname datvar label type length case comment;
99         
100              title1 height=2 "--- Findings from CDISC Evaluation ---";
101              footnote1 height=2 "Generated on: 08/15/2005, 10:33:55 am, Nguyen Thi Tra Nhi"
101      ! ;
102              footnote2 height=2 "Located at: C:\test\cdisc_test\data";
103              format datname $datfmt.;
104              run;

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

5                                       The SAS System            10:33 Monday, August 15, 2005

105              ods html3 close;
106              ods listing;
107        

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.40 seconds
      cpu time            0.57 seconds
      

108        
109        *** Test missing to capture all ***;
110        ***%cdisc(datlib=templib);
111        
112        
113        

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.64 seconds
      cpu time            1.26 seconds