Registering a Table

Before you can register a table in a library, you must be logged on to SAS Environment Manager using an ID that can register libraries. You must also assign the library definition to a SAS Application Server. If you are registering tables for a SAS LASR library, previously registered tables might be included in the list of available tables. If you attempt to register these tables again, the registration will fail, although the table is still registered with the library. You can register a table with a library in three ways:

Register a Table from the List of Libraries

In the Libraries module, right-click the library that should contain the table. Select Register Table from the pop-up menu. The Register Tables dialog box appears.
The default location for data tables is My Folder for the current user. Click Browse to select another location.

The location is where the metadata for the table is stored. The tables that are being registered are retrieved from the location specified in the Location field in the library definition.
Select tables to register from the Available tables list.
Select these options as needed:

Enable case-sensitive DBMS object names

specifies whether case-sensitive names for tables and columns are supported in the metadata that you are about to generate for tables in the current library. If the check box is deselected, no support is provided. If the check box is selected, support is provided.

Enable special characters within DBMS object names

specifies whether special characters in names for tables and columns are supported in the metadata that you are about to generate for tables in the current library. If the check box is deselected, no support is provided. If the check box is selected, support is provided.
Click OK to register the selected tables.

Register a Table from a Library’s Properties Page

From the Libraries module, double-click an entry to open the Properties page for the library.
Click the page title (Basic Properties) and select Tables from the list of property pages. The list of tables registered to the library appears.
Click the Register Tables icon to register a table. The Register Tables dialog box appears.
The default location for data tables is My Folder for the current user. Click Browse to select another location.
Select tables to register from the Available tables list.
Select these options as needed:
- Enable case-sensitive DBMS object names
- Enable special characters within DBMS object names
Click OK to register the selected tables.

Register a Table from the Folders Module

Use the side menu to open the Folders module.
Navigate in the Folders tree until you locate the library that should contain the table.
Right-click the library entry and select Register Tables from the menu.
The default location for data tables is My Folder for the current user. Click Browse to select another location.
Select tables to register from the Available tables list.
Select these options as needed:
- Enable case-sensitive DBMS object names
- Enable special characters within DBMS object names
Click OK to register the selected tables.