1                                         The SAS System             15:16 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.12 seconds
      cpu time            0.15 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:     findrel5b.sas                                   *
3          * Description: Test searching where input datasets are not    *
4          *              specified.                                     *
5          * By:          Tuan Anh, 22/08/2005                           *
6          *-------------------------------------------------------------*/
7          libname data "..\data\findrel";
NOTE: Libref DATA was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: d:\My Projects\cdiscbuilder\testing\data\findrel
8          %findrel(data = data, dataset = , search=unique,output = d:\My
8        ! Projects\cdiscbuilder\testing\saspgm\findrel5b.html);

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

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

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

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

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

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

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

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

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

40                  footnote2 height=2 "Located at: d:\My Projects\cdiscbuilder\testing\saspgm";
41         
42                  proc report data = work.findrel (drop=usrname datetime) nowd
43                     style(header)=[font_size=2]
44                     style(column)=[font_size=2];
45                     by datname;
46                     column datvar label type length criteria;
47                  run;

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

48                  ods html3 close;
49                  ods listing;
50         
51         

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

NOTE: PROCEDURE DISPLAY used (Total process time):
      real time           1.06 seconds
      cpu time            0.29 seconds
      


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