METALIB Procedure

Example 6: Specifying a Folder for the Metadata

Features:

FOLDER= statement

PROC METALIB creates table definitions in the same folder as the specified library definition unless you specify a different folder with the FOLDER= or FOLDERID= statement. The default location for a library definition is the

Shared
                  Data

folder. If you choose to create table definitions in more than one folder, be aware that you must run PROC METALIB on each folder to update the metadata. PROC METALIB maintains a separate set of table definitions for each folder.

If a library named baselib is defined in /My Folder/test, the following PROC METALIB statement registers the Class table in /My Folder/test.The FOLDER= statement is not necessary because the library is already located in /My Folder/test.

proc metalib;
   omr(library=baselib);
   select (class);  
run;

To create metadata for the Class table in a different folder, use the FOLDER= or FOLDERID= statement.The FOLDER= statement specifies a different folder location than the one in which the library is located. The folder must exist. PROC METALIB does not create it for you. There will be two table definitions for the Class table in library baselib. One definition is associated with the /My Folder/test location, and one definition is associated with the /Shared Data/Export location.

proc metalib;
      omr(library=baselib);
      folder=”/Shared Data/Export”;
      select (class); 
run;

If a library named oraclelib is defined in /Shared Data, the following request creates table definitions in /My Folder/Oracle.This request assumes the /My Folder/Oracle folder already exists. PROC METALIB returns an error if a folder of the specified name cannot be found in the specified location.

proc metalib;
		omr(library=oraclelib);
		folder="/User Folders/MyUserId/My Folder/Oracle";
run;