Assigning Libraries :: SAS(R) Studio 3.5: Administrator's Guide, Second Edition

When you create a library by using SAS Environment Manager or SAS Management Console, the library is defined on the SAS Metadata Server, and the library assignment is shared across SAS servers. In SAS Studio, access to registered libraries is determined in part by the method that is used to assign those libraries.

In SAS Management Console, you can assign a library by using the AssignMode extended attribute. To view the extended attributes in SAS Management Console, right-click the library name and select Properties. In the Properties dialog box, click the Extended Attributes tab.

SAS Enterprise Guide supports values of 0–4 for the AssignMode attribute. However, SAS Studio supports only these values for the AssignMode attribute:

1 – The library is assigned using the META engine. When you specify this value, the METAOUT= option is set to ALL. You can read, create, update, and delete observations in an existing physical table that is defined in metadata. You cannot create or delete a physical table, or alter a physical table’s columns. This is the default behavior.
2 – The library is assigned using the META engine. When you specify this value, the METAOUT= option is set to DATA. You can read, create, alter, update, and delete a physical table. The user can access any table, regardless of whether it has been defined in the repository.
4 – The library is assigned using the META engine. You can read, update, alter, and delete a physical table that is defined in metadata. You can also create and delete physical tables that are not in metadata, but you cannot read or update the new tables until they are defined in metadata. This value is similar to METAOUT=DATA, except tables and columns that are not defined in the repository are not visible.

To share library assignments between SAS Studio and SAS Enterprise Guide, you must specify 1, 2, or 4 for the AssignMode attribute.