1                                          The SAS System              13:58 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.18 seconds
      cpu time            0.68 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:     metadata5.sas                                   						*
3          * Description: Verify the deletion of metadata for specified data.					*
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 = delete,
17                    output = );

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

NOTE: There were 62 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.12 seconds
2                                          The SAS System              13:58 Monday, August 15, 2005

      cpu time            0.03 seconds
      

23         

NOTE: PROCEDURE DISPLAY used (Total process time):
      real time           21.90 seconds
      cpu time            0.26 seconds
      

24         

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