Registering a Table Using SAS Management Console

Overview of Registering a Table

After you create your data tables, you must register them in a SAS Metadata Repository so that the SAS Model Manager can locate them. SAS Model Manager can add data tables from the SAS Metadata Repository that are registered in SAS Management Console. You register tables in SAS Management Console in the Data Library Manager, Libraries folder.

How to Register a Table

The Register Tables wizard guides you through the process of importing and registering a SAS table in the SAS Metadata Repository. Each library type has a different Register Tables wizard that is called from the Data Library Manager.
Note: The Register Tables wizard is not available on UNIX platforms.
To import and register a table into a SAS Management Console Data Library:
  1. Copy the .sas7bdat file for your table into the directory path on the Workspace server that you provided in the Path Specification data field of the New Library Wizard. For more information, see Create Model Manager Libraries in SAS Management Console.
  2. Start SAS Management Console, and connect to the SAS Metadata Repository that contains your new SAS Library.
  3. In the SAS Management Console tree, expand the following folders:
    Environment Managementthen selectData Library Managerthen selectLibraries
  4. Right-click the SAS Library name that you want to import your table into, and then select Register Tables from the pop-up menu. The Register Tables wizard window appears.
    Register Tables Select a SAS Library
  5. Verify that the information that is displayed in the Select a SAS Library page is correct, and then click Next.
  6. If prompted, enter your SAS user ID and password to log on to your SAS server.
  7. The Default Application Server dialog box might appear if the selected folder location is User Folders or if a default application server has not been previously selected. Select your SAS server, click Test Connection to verify that the connection to the server is successful, and then click OK.
    Default Application Server Selection
  8. The Define Tables and Select Folder Location page is displayed. Select the table or tables that you want to register, and then click Next.
    Register Tables Selection Window
  9. Click Finish.
The metadata for the imported table is written into the SAS Metadata Repository and is associated with the selected SAS Library.
New Library Table Display
Note: You must create folders with appropriate access permissions so that users can manage their models, create reports, and publish model updates. If a SAS Model Manager user does not have the appropriate permissions to access a folder, then the tables and libraries are not listed in the Data Sources perspective of SAS Model Manager. For more information about creating a folder and setting permissions, see the SAS Management Console Help.

See Also

Create Model Manager Libraries in SAS Management Console
Copyright © SAS Institute Inc. All rights reserved.