1                                         The SAS System             15:17 Monday, August 22, 2005

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.14 seconds
      cpu time            0.10 seconds
      

NOTE: AUTOEXEC processing beginning; file is d:\My 
      Projects\cdiscbuilder\testing\saspgm\autoexec.sas.

NOTE: Libref _TEMPLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: d:\My Projects\cdiscbuilder\sashelp
NOTE: Libref _TEMPLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: d:\My Projects\cdiscbuilder\sashelp
NOTE: Libref _TEMPLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: d:\My Projects\cdiscbuilder\sashelp

NOTE: AUTOEXEC processing completed.

1          /*------------------------------------------------------------*
2          * program:     findrel6a.sas                                   *
3          * Description: Test searching with default search criteria.   *
4          * By:          Tuan Anh, 22/08/2005                           *
5          *-------------------------------------------------------------*/
6          libname data "..\data\findrel";
NOTE: Libref DATA was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: d:\My Projects\cdiscbuilder\testing\data\findrel
7          %findrel(data = data, dataset = co, output = d:\My
7        ! Projects\cdiscbuilder\testing\saspgm\findrel6a.html);

8                proc sort data = work.findrel;
9                   by datname variable label;
10               run;

NOTE: There were 1 observations read from the data set WORK.FINDREL.
NOTE: The data set WORK.FINDREL has 1 observations and 8 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

11         
12               data work.findrel;
13                  set work.findrel;
2                                         The SAS System             15:17 Monday, August 22, 2005

14                  by datname variable label;
15         
16                  attrib datvar label="Dataset and Variable" length=$100;
17         
18                  if variable ne '' then
19                  datvar = compress(lowcase(datname) || "." || lowcase(variable));
20                  else datvar = lowcase(datname);
21               run;

NOTE: There were 1 observations read from the data set WORK.FINDREL.
NOTE: The data set WORK.FINDREL has 1 observations and 9 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

22         
23               *** Remove the special characters ***;
24               proc template;
25                  define style styles.test;
26                  parent=styles.default;
27                  style byline from titlesandfooters /
28                     protectspecialchars=off;
29                  end;
NOTE: Overwriting existing template/link: Styles.Test
NOTE: STYLE 'Styles.Test' has been saved to: SASUSER.TEMPLAT
30               run;
NOTE: PROCEDURE TEMPLATE used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

31         
32               proc sort data = work.findrel;
33                  by datname datvar;
34               run;

NOTE: There were 1 observations read from the data set WORK.FINDREL.
NOTE: The data set WORK.FINDREL has 1 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

35                  ods listing close;
36                  ods html3 file="d:\My Projects\cdiscbuilder\testing\saspgm\findrel6a.html"
36       ! style=styles.test;
NOTE: Writing HTML3 Body file: d:\My Projects\cdiscbuilder\testing\saspgm\findrel6a.html
37                  title1 '--- Find Variables That are Potential Related Records Used with Macro
37       ! %findrel ---';
38                  footnote1 height=2 "Generated on: 08/22/2005,  3:17:38 pm, Bui Nguyen Tuan
38       ! Anh";
39                  footnote2 height=2 "Located at: d:\My Projects\cdiscbuilder\testing\saspgm";
3                                         The SAS System             15:17 Monday, August 22, 2005

40         
41                  proc report data = work.findrel (drop=usrname datetime) nowd
42                     style(header)=[font_size=2]
43                     style(column)=[font_size=2];
44                     by datname;
45                     column datvar label type length criteria;
46                  run;

NOTE: There were 1 observations read from the data set WORK.FINDREL.
NOTE: PROCEDURE REPORT used (Total process time):
      real time           0.06 seconds
      cpu time            0.00 seconds
      

47                  ods html3 close;
48                  ods listing;
49         
50         

51                  systask command ' "d:\My Projects\cdiscbuilder\testing\saspgm\findrel6a.html"
51       ! ';

NOTE: PROCEDURE DISPLAY used (Total process time):
      real time           0.95 seconds
      cpu time            0.21 seconds
      


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