Managing Table Metadata

Creating Table Metadata for a New Library

When you first register a SAS library, it has no related table metadata. You can add this metadata by using the Register Tables wizard in SAS Management Console (see Overview of Managing Table Metadata), or by using PROC METALIB. Before you can successfully run PROC METALIB code, you must have Create, ReadMetadata, and WriteMetadata access to the library metadata object.

The following example shows how to use PROC METALIB to create initial table definitions for the tables in a library. The REPORT statement causes the procedure to write information to SAS output about the table definitions that it creates.

proc metalib;
omr (library="sas91 lib2" repname="Meta Proc repos" );
report;
run;

The report that this code writes would resemble the following sample.

                                The METALIB Procedure
  
                           Summary Report for Library sas91 lib2
                                Repository Meta Proc repos
                                         17MAR2005

                                 Metadata Summary Statistics

                             Total tables analyzed           2
                             Tables Updated                  0
                             Tables Added                    2
                             Tables matching data source     0
                             Tables not found                0


 ------------------------------------------------------------------------------------
                                       Tables Added
 ------------------------------------------------------------------------------------


 Metadata Name                     Metadata ID          SAS Name

 COUNTRY                           A5HJ58JU.AX001LPV    COUNTRY
 POSTAL                            A5HJ58JU.AX001LPW    POSTAL

Top of Page