User manual SAS ENTERPRISEGUIDE 4.3 ADMINISTERING

[. . . ] Administering ® SAS Enterprise Guide 4. 3 ® SAS® Documentation The correct bibliographic citation for this manual is as follows: SAS Institute Inc. Administering SAS ® Enterprise Guide® 4. 3 Copyright © 2010, SAS Institute Inc. , Cary, NC, USA All rights reserved. For a hard-copy book: No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, or otherwise, without the prior written permission of the publisher, SAS Institute Inc. For a Web download or e-book:Your use of this publication shall be governed by the terms established by the vendor at the time you acquire this publication. [. . . ] For information about defining servers, see the Help for SAS Management Console. Managing Libraries About Libraries Libraries are collections of files that are stored on a server and accessed from SAS Enterprise Guide. Libraries give SAS Enterprise Guide users convenient access to their data on servers. When you add a metadata definition for a library through SAS Enterprise Guide Explorer or SAS Management Console, you make the metadata definition available to all the network SAS Enterprise Guide installations that have access to a specific metadata repository as well as all other applications that use the repository. The metadata definition for a library includes the path, engine, and other options for the library. The metadata definition corresponds to the information that is specified in a LIBNAME statement. Table definitions specify the tables and columns that are available within a library. You can create table definitions by using one of the following functions: · · · · using the Update Library Metadata function in SAS Enterprise Guide using the Register Tables function in SAS Management Console running the METALIB procedure in a SAS session (which synchronizes metadata with the physical contents of a library) using SAS Data Integration Studio to build a data warehouse You can include authorization settings for both library and table definitions, specifying which libraries and tables a user can access and whether the user can change the contents of a library. Note: Before you add a library, you must use SAS Management Console to add the server on which the library resides. Enter any associated options that you can specify in a LIBNAME statement. The LIBNAME options are stored on the client and then executed when a SAS Enterprise Guide application connects to the specified SAS server. For more information about SAS libraries, LIBNAME statements, and LIBNAME options, see SAS Language Reference: Dictionary. Understanding the Metadata LIBNAME Engine To understand how SAS Enterprise Guide assigns and accesses libraries, it is helpful to understand the metadata LIBNAME engine. The engine, also called the META engine, enables you to use a LIBNAME statement to reference a metadata definition for a library, rather than specifying the physical location of the library's tables. By default, the META engine provides read-only access to a library, which prevents the library contents from being different from the library metadata. 22 Chapter 4 · Managing Metadata Objects If you use the METAOUT=DATA option in the LIBNAME statement, the META engine can access tables that are not defined in metadata but that exist in the physical library. However, any metadata authorization settings that have been applied to tables or columns in the library are enforced. If a SAS program changes the contents of a library that uses the METAOUT=DATA option, you must synchronize the physical data and the metadata. To synchronize the data, you can use the Register Tables function in SAS Management Console, the METALIB procedure, or the Update Library Metadata task in SAS Enterprise Guide. Adding a Library To add a library, select File ð New ð Library and follow the prompts on each page of the Library Wizard. Depending on the options that you select in the wizard, the number of pages in the wizard and the page on which a specific option appears might change. Use the following information when completing the wizard: · On page 1 of the wizard, you must specify a name for the library. The name can be up to eight characters long and must not be duplicated on any server on which you are creating the library. On page 2 of the wizard, you must specify how the library is assigned. You must choose to assign the library by using one of the following: SAS Enterprise Guide specifies that SAS Enterprise Guide uses the metadata that is supplied in the wizard to assign the library by using the native engine. SAS Server specifies that the library is assigned in an autoexec statement or through the METAAUTOINIT system option. [. . . ] This capability does not provide a substitute for system security. Send Content to E-mail Recipient Roles OLAP, Analysis, Programming, Advanced Description If granted, the user can create or modify a wizard to distribute files by using e-mail. If not granted, the menu items E-mail Recipient and E-Mail Recipient as a Step in Project are removed. The user is not allowed to make any changes in existing e-mail distribution steps. 38 Chapter 6 · Administering Role-Based Settings Save to SAS Folder Roles OLAP, Analysis, Programming, Advanced Description If granted, allows the user to save projects and documents directly to SAS folders. Content Capabilities Create or Modify Advanced Query Roles Analysis, Programming, Advanced Description If granted, the user can create and modify advanced queries in projects. If not granted, the Query Builder menu item is removed, and the user is not allowed to make any changes to existing advanced queries. Create or Modify Data Join in Advanced Query Roles Analysis, Programming, Advanced Description The user can create or modify a table join in an advanced query. [. . . ]