Mindmajix

Assigning a SAS Data Library

This demonstration shows you, how to use the SAS Management Console to define a data library.

Screenshot_1206

  1. Invoke SAS Management Console by selecting Start Ð All Programs Ð SAS Ð SAS Management Console 1.
  1. Select the BIArchitecture metadata profile then select Screenshot_1207.

Screenshot_1208

       3. Enter the username and password provided by the instructor.

Screenshot_1209  The values shown above will be different than those used in class.

The SAS Management Console opens:

Screenshot_1210

Define a SAS Data Library

      4. Expand the Data Library Manager plug-in.

      5. Right-click on SAS Libraries and select New Library from the pop-up. The New Library Wizard opens.

      6. Select SAS Base Engine Library as the type of library to define.

Screenshot_1211

Select Screenshot_1212

      7. Specify Orion Star Gold Library as the Name of the new library.

Screenshot_1213

Select Screenshot_1212

      8. Specify the properties of this library:

       a.  Type orgold in the Libref field.

Screenshot_1214

     b. Select Screenshot_1215 to add a new path to the list of available items

        c. In the New Path Specification window, select Screenshot_1216.

Screenshot_1217

The Screenshot_1216 button allows you to browse the machine where the SAS Management Console is running. If the path is located on a different server, it must be typed in manually.

     d. In the Browse window, navigate to C:\Workshop\winsas\sbip\Orion_Star_15AUG03\orgold.

Screenshot_1218

Select Screenshot_1207

      e. Select Screenshot_1207 in the New Path Specification

      f. Verify that this path is now in the Selected items list.

Screenshot_1219

Select Screenshot_1212

     9. If prompted, select SASMain as the SAS Application server

Screenshot_1220

Select Screenshot_1212

     10. Review the settings:

Screenshot_1221

Select Screenshot_1223

     11. The new library should now appear in the display area of SAS Management.

Screenshot_1224     12. To view the LIBNAME statement that will be created from the metadata, right-click Orion Star Gold Library and select Display Libname….

Screenshot_1225

Select Screenshot_1207

Register Metadata for ExistingTables

When you create metadata to define a library in the SAS Management Console, you define the library only and not tables.

To import metadata to define an existing data source, use the Source Designer.

SourceDesigner

The Source Designer is a wizard-driven interface that enables you to define the physical layout of existing tables using a data dictionary or metadata information from the source system.

The result of running the Source Designer successfully is a metadata registration that describes the data source.

Screenshot_1226

Register Metadata for Existing Tables

This demonstration shows how to register the metadata for the tables in the Source Tables Library.

  1. To invoke the Source Designer, right-click Orion Star Gold  Library and select Import Tables….
  2. Select SASMain as the server to connect to, because it is the server where the data resides.

Screenshot_1227     3. Enter the user name and password provided by the instructor.

Screenshot_1228

Select Screenshot_1207

    4. Because the wizard was invoked from the library, you want to import tables for, accept the defaults by selecting Screenshot_1212

Screenshot_1229

     5. Select Screenshot_1230to select all the available tables.

Screenshot_1231

Select Screenshot_1212

     6. Review the settings

Screenshot_1232

Select Screenshot_1223

      7. The tables are now listed in the display area of SAS Management Console

Screenshot_1233

Set the Authorization Level for the New Library

The metadata about libraries and tables are available to all users by default; however, access to the data within a table is not. Permissions must be added for the desired users or group of users to be able to view the data within a specific table or all tables in a specific library.

      8. To set permissions for all tables in the new library, right-click Orion Star Gold Library and select Properties.

      9. When the Properties window opens, select Authorization.

Screenshot_1234

      10. On the Authorization tab, grant the Read permission to the PUBLIC group by selecting the appropriate checkbox.

Screenshot_1235

       11. Select Screenshot_1207 to save the changes.

       12. Select File Ð Exit to close SAS Management


 

0 Responses on Assigning a SAS Data Library"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.