We always register the table and Libraray in SAS management Console. But I do not know why I am doing this activity and whats the benefits of doing this activity.
it is a requirement to register tables in the metadata libraries when one of your applications will require metadata for tables. Such as SAS Data Integration and SAS Visual Analytics. What SAS Client applications are in use by you users?
It is best practice to set up libraries in SMC so they are available to all SAS users in all SAS environments. You can avoid registering tables for most SAS products and this is my preferred option. Some SAS products like SAS DI and SAS VA require table registration though.
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.
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.
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.
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?
This documentation also includes information on DBMS, pre-assigned etc libraries.
Does this help a bit?
Another benefit to registering tables in metadata, so that they can be used by metadata centric applications like SAS Data Integration Studio etc, is to be able to answer lineage questions - such as where is this table used downstream and where does it come from upstream. Features such as SAS DI Studio Impact Analysis, the BI Lineage Plug-in and the Relationship Reporting Tools all rely on metadata to be able to provide these valuable insights.
Of course once they are registered in metadata they need to be maintained in metadata (such as updating metadata when the table structure changes). For this reason, if you are not using metadata centric applications, and do not need the various benefits already mentioned in this thread, you may decide not to register them in metadata. For example some sites may have some free-for-all libraries for SAS Enterprise Guide users where the turnover in tables and table structures is so high that, given those tables might only be used by those EG users, the administrators avoid the overhead of maintaining metadata registrations for those tables.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.