METALIB Procedure

FOLDER or FOLDERID Statement

Specifies where new metadata is stored in SAS folders.

FOLDER <=> "/pathname" | FOLDERID <=> "identifier.identifier";

When you specify FOLDER= or FOLDERID=, you add or update the table definition in the specified SAS folder. The SASLibrary object remains in its original folder. Column, ForeignKey, Index, KeyAssociation, and UniqueKey objects are added or updated in the same folder as the specified PhysicalTable object.

If a table is defined in more than one folder, updating the table definition in all of the folders is recommended, and you must submit a PROC METALIB step for each folder. Using the SELECT= statement is recommended, to ensure that you update the correct table. If the table is defined in more than one folder, then you will see multiple table definitions in the Data Library Manager on the Plug-ins tab of SAS Management Console. The multiple table definitions will have the same name but will be in different SAS folder locations. Every table definition has a unique metadata identifier.

If you do not specify a folder or if the folder specification is not valid, and if table definitions exist in more than one folder, PROC METALIB updates the first table definition that is found for each table in the specified library. (If you submit SELECT=, PROC METALIB updates the specified table in the specified library.) If you do not specify a folder or if the folder specification is not valid, and if a table is new, PROC METALIB adds the new table definition to the SASLibrary object's folder.

FOLDER <=> "/pathname"

is a folder pathname in a SAS folder. The pathname begins with a forward slash. Here is an example:

folder="/Users/MyUserID/My Folder/Test";

FOLDERID <=> "identifier.identifier"

is the full 17-character metadata identifier of the Tree object that represents the folder. Using FOLDERID= is not recommended if you can use FOLDER=. The FOLDER= syntax is preferable because it shows the location of the folder in SAS Management Console.

Top of Page