1                                          The SAS System              13:50 Monday, August 15, 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.95 seconds
      cpu time            0.70 seconds
      

NOTE: AUTOEXEC processing beginning; file is C:\WorkRoom\Metadata\test 
      Macro\testing\saspgm\autoexec.sas.

NOTE: Libref COMDATA was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\WorkRoom\Metadata\test Macro\testing\saspgm

NOTE: AUTOEXEC processing completed.

1          /*--------------------------------------------------------------------------------	*
2          * program:     metadata3.sas                                   						*
3          * Description: Verify that import captures all attributes of the dataset 			*
4          *				 and associated variables.													*
5          * Parameters:  source = source datasets													*		 		
6          *              metadb = metadata database library 										*
7          *              search = search criteria 													*
8          *              task = database management tasks   										*
9          *              output = output report	                                      	   	*					
10         * By:          Nam Phuong, 8/2/2005														*
11         *---------------------------------------------------------------------------------	*/
12         libname mylib ".";
NOTE: Libname MYLIB refers to the same physical library as COMDATA.
NOTE: Libref MYLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\WorkRoom\Metadata\test Macro\testing\saspgm
13         
14         %metadata (source = mylib.ae,
15                    metadb = mylib.metadb,
16                    search = ,
17                    task = update,
18                    output = );

19                  data mylib.metadb;
20                     length libname $ 10 memname $200;
21                     if not missing(libname);
22                  run;

NOTE: Variable libname is uninitialized.
NOTE: Variable memname is uninitialized.
NOTE: The data set MYLIB.METADB has 0 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.09 seconds
2                                          The SAS System              13:50 Monday, August 15, 2005

      cpu time            0.04 seconds
      

23                  *** Remove the old metadata before updating ***;
24                     data mylib.metadb;
25                     set mylib.metadb;
26                        if compress(upcase(libname || '.' || memname)) = upcase("mylib.ae") then
26       ! delete;
27                     run;

NOTE: There were 0 observations read from the data set MYLIB.METADB.
NOTE: The data set MYLIB.METADB has 0 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

28         

29                     *** Capture the meta data for mylib.ae ***;
30                        proc contents data = mylib.ae noprint
31                           out=curdat;
32                        run;

NOTE: The data set WORK.CURDAT has 33 observations and 40 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.09 seconds
      cpu time            0.04 seconds
      

33         
34                        *** Appply the updates to the destination for mylib.ae ***;
35                        data mylib.metadb;
36                           set mylib.metadb curdat;
37                        run;

NOTE: There were 0 observations read from the data set MYLIB.METADB.
NOTE: There were 33 observations read from the data set WORK.CURDAT.
NOTE: The data set MYLIB.METADB has 33 observations and 40 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

NOTE: PROCEDURE DISPLAY used (Total process time):
      real time           0.84 seconds
      cpu time            0.32 seconds
      

38         

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
      real time           1.90 seconds
3                                          The SAS System              13:50 Monday, August 15, 2005

      cpu time            1.07 seconds