metadata

Generate and maintain a metadata database with search capabilities.

%metadata (source = source datasets,
                          metadb =
metadata database library,
                          search
= search criteria,
                          task
= database management tasks,
                          output =
output report);

 

Where

Is Type...

And represents...

sourceC (200)A two level dataset name specification in the form of libname.dataname.  If only a one level libname is specified, all the data in that libname will be selected.
metadbC (200) A two level dataset name specification in the form of libname.dataname.  This is the dataset storing the meta data database.  If left blank, it will be the same location as source with the data name of metadb.  If only the libname is specified, it will store it in the metadb dataset at that location.
search C (20) Open text search criteria used in locating information in the metadata database.
taskC (200) The following tasks are applied from the source data to the metadata database.  The tasks include:
  • update (default)
  • delete
outputC (200 optional) The location of the output HTML report of the metadata database.  An example is metadb.html.

Details
The metadata utility capture all the metadata that is captured in PROC CONTENTS.  This includes all the dataset level attributes and variable attributes.  It stores this information in a centralized metadata database specified by the metadb parameter.  The metadata database will track data unique to each libname location so even if the same data exists in different libnames, they will be stored separately in the database.

The search criteria can be applied to capture when an open text criteria.  If the text search is case in-sensitive and can match any of the attributes stored in the metadata database.  A report can also be created documenting the metadata of all the data stored in the metadata database.  This will have an index of all the data at the top with hyperlinks to the detail variable attributes.

Example

%metadata (source = inlib.ae,
                          metadb=
outlib.metadb,
                          search=
adverse);

%metadata (source = inlib,
                          metadb=
outlib.metadb);

%metadata (metadb= outlib.metadb,
                         output=
c:\output\metadb.html);
 

    CDISC Builder - CDISC Data Tools Software,  Meta-Xceed Inc.© 2009
Bookmark and Share