1                                          The SAS System              13:51 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           1.07 seconds
      cpu time            0.67 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:     metadata4.sas                                   						*
3          * Description: Verify updates to existing specified metadata database.				*
4          * Parameters:  source = source datasets													*		 		
5          *              metadb = metadata database library 										*
6          *              search = search criteria 													*
7          *              task = database management tasks   										*
8          *              output = output report	                                      	   	*					
9          * By:          Nam Phuong, 8/2/2005														*
10         *---------------------------------------------------------------------------------	*/
11         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
12         
13         %metadata (source = mylib.elig,
14                    metadb = mylib.metadb,
15                    search = ,
16                    task = update,
17                    output = );

18                  *** Remove the old metadata before updating ***;
19                     data mylib.metadb;
20                     set mylib.metadb;
21                        if compress(upcase(libname || '.' || memname)) = upcase("mylib.elig") then
21       !  delete;
22                     run;

NOTE: There were 33 observations read from the data set MYLIB.METADB.
NOTE: The data set MYLIB.METADB has 33 observations and 40 variables.
NOTE: DATA statement used (Total process time):
      real time           0.10 seconds
2                                          The SAS System              13:51 Monday, August 15, 2005

      cpu time            0.03 seconds
      

23         

24                     *** Capture the meta data for mylib.elig ***;
25                        proc contents data = mylib.elig noprint
26                           out=curdat;
27                        run;

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

28         
29                        *** Appply the updates to the destination for mylib.elig ***;
30                        data mylib.metadb;
31                           set mylib.metadb curdat;
32                        run;

NOTE: There were 33 observations read from the data set MYLIB.METADB.
NOTE: There were 29 observations read from the data set WORK.CURDAT.
NOTE: The data set MYLIB.METADB has 62 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           21.85 seconds
      cpu time            0.31 seconds
      

33         

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