Hi,
The reason for creating libraries and tables in Metadata (and other objects for that matter), is to
A) give you a single point of control for your entire SAS environment, and
B) have a great opportunity to set up permissions and "bringing in" your data/third party data.
Ad A:
SAS Management Console is your main administration tool (I am leaving it at main admin tool and am disregarding the Env Manager here).
This client is a single point of control client for admins. Single point of control means, you don't have to go from machine to machine to maintain, update etc. No matter how many machines you have in your environment, you can administer it all from this one client.
Now ...
In order to actually get this single point of control functionality, all your data has to be created
and registered in metadata. This includes users, groups, roles, permissions, folders - and
libraries and tables.
By creating libraries in metadata, and by registering tables in metadata, you can grant and
deny permissions to groups and users.
Ad B:
To give you one example (there are many more):
Users assign libname statements in SAS w/out using metadata. The libname statement points to
a path on the OS (am focusing on OS only right now and won't consider any DBMS, ERP etc).
With this, you have all data sets on this location available to you.
You probably use OS permissions to secure access, or, you create many folders to "spread out"
your tables to get your permission set up integrated, or, you might just have a set up where
all users can access all tables.
The easier and best way (I am saying "best" cause I am in big favor of metadata 🙂 ) is to create a
library in SASMC, and then, during the registration process, register only the tables that you would
like to have in that certain library.
This might make it easier for you because you can create libraries and folders based on, example,
BUs, depts etc. Register the tables for the BUs, create groups for each BU, and then apply permissions
to have a full "metadata circle".
So to describe it full circle:
By creating libraries and by registering tables you not only create a set up for you that
is maintained easily, in addition it gives you great flexibility with permissions.
You can find some additional information on libraries in metadata on this site:
What Does It Mean to Assign a Library?
http://support.sas.com/documentation/cdl/en/bidsag/69848/HTML/default/viewer.htm#n0vuopkmrlxhg4n1h86fd3w16kj2.htm
This documentation also includes information on DBMS, pre-assigned etc libraries.
Does this help a bit?
Thanks
Anja
... View more