With SAS Enterprise Guide 4.1 as your primary client and SAS 9.1.3 SP4 on the back-end server, the following library definition steps will give you the most commonly requested feature set that includes:
- metadata security of library
- metadata security of individual tables (if desired)
- ability to see physical tables which do not have metadata definitions
- ablility to create, overwrite, and delete tables
In other words, the library will use a "view through" META engine which surfaces tables with metadata as well as physical tables on the OS whose table metadata has not been imported.
It will honor library metadata security, table metadata security (where present), and ultimately OS security. It will allow full-functionality of read/write/delete with appropriate permissions
To define a new library in EG:
Use the Enterprise Guide Explorer from Tools. Expand your server.
Click File ► New ► Library.
Follow the wizard and on step 2, select Metadata Library Engine and clear Show only tables with metadata table definitions.
To redefine existing library in EG:
Use the Enterprise Guide Explorer from Tools. Expand your server. Expand Libraries. If the library is YELLOW, right-click it and select Unassign.
Right-click again and select Properties. On the Assignment tab, select Metadata Library Engine and clear Show only tables with metadata table definitions.
Using SAS® Management Console:
If the library does not exist, complete the New Library wizard of the Data Library Management plug-in. Right-click the library and select Properties. Select the Extended Attributes tab, then click New.
- For Field Name, enter: AssignMode (case-sensitive)
- For Value, enter: 2
Click
OK to exit.
Table Metadata Warning
If you do have table metadata imported that is used in any SAS client that utilizes column metadata (like Information Map Studio or SAS® Data Integration Studio), you can cause a disconnect between the column metadata and the physical structure of the table.
Example:
If a library is implemented with the method above, and the metadata for table TEST exists and defines variables X and Y, a SAS Enterprise Guide user has the ability to overwrite the table and remove X and Y. This overwrite will NOT update the metadata. If this happens and a user of IMS or DIS tries to access TEST, they will experience an error.
Recommendation:
Option 1: Do not import table metadata to your library.
Options 2: If you are a SAS Enterprise Guide user and you structurally change a dataset, ensure that you update the metadata with the following code:
Proc metalib;
Omr (library="library name" Metarepository="Foundation");
* Uncomment one line below;
* Update_rule=(delete); /* syncs entire directory */
* Select ("table name"); /* syncs one table */
Report;
Run;
Setting a library as Pre-assigned
Any library can be set to pre-assigned. Setting the library to "Pre-assigned" means that you do not have to manually "activate" the library in the Server List before using it (by either double-clicking it, or right-clicking and choosing Assign).
First, your workspace server (or SAS® Stored Process server for SAS® Stored Process access) must be started with the METAAUTOINIT option.
In the SAS Management Console under "Server Manager", fully expand and select the lowest level of your server. Right-click and select Properties. Select the Options tab.
On the Object Server Parameters line specify: METAAUTOINIT.
The library can be set to pre-assigned using the SAS Management Console.
In the Data Library Management plug-in, right-click on the library and select Properties. Go to the Options tab, click Advanced Options; on the Pre-Assign tab, click the Library is Pre-Assigned checkbox.
Operating System and Release Information
SAS System | SAS Enterprise Guide | Microsoft Windows XP Professional | 4.1 | | 9.1 TS1M3 SP1 | |
Microsoft Windows 2000 Professional | 4.1 | | 9.1 TS1M3 SP1 | |
Microsoft Windows NT Workstation | 4.1 | | 9.1 TS1M3 SP1 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.