SAS ETL Studio CaseStudy – Create a Logical Grouping and Adding a Library Definition

Recommended by 0 users

This demonstration shows how to create a logical grouping in the Custom tree view to organize your warehouse metadata. It also shows how to create a library definition and store it in the new logical group.


  1. Invoke SAS ETL Studio by selecting Start Ð All Programs Ð SAS Ð SAS ETL Studio 1.
  2. Select the metadata profile BIArchitecture, then select Screenshot_1207


     3. If prompted, enter the username and password provided by the instructor.


Select Screenshot_1207

The SAS ETL Studio desktop opens:


Select Screenshot_1207 to close the Tip Of The Day window.

The first step in using SAS ETL Studio to build the Orion Star marketing data mart is to create groups in the Custom tree view. These groups are simply logical groupings of the metadata that comprise the repository. There is no corresponding physical file structure for the groups that are created. The groups can be defined using whatever logical grouping is relevant to your organization.

      4. Select the Custom tab in the tree view area of SAS ETL

      5. Select Screenshot_1285 to expand the Foundation repository.

The Foundation repository already has an Ungrouped group, which already contains several items. These were created during the configuration of the SAS Intelligence Architecture. Do not delete these files, as some will be used in future demonstrations and exercises.

     6. Right-click Foundation and select New Group from the pop-up menu. The default name of the new group is Untitled.


      7. Rename the new group to Libraries.

          a. Right-click on the Untitled group.

          b. Select Rename from the pop-up menu.

          c. Type Libraries as the new name for the group.


Add a Library Definition

      8. From the Custom tab in the tree view area of the SAS ETL Studio desktop, select File Ð New Object….

      9. In the New Object Wizard, select Library type, then Screenshot_1212


      10. Under SAS Libraries, choose SAS Base Engine Library, then select Screenshot_1212


      11. Type Target Tables Library in the Name field and select Screenshot_1212


      12. Type Target in the Libref field, select BASE in the Engine field (default), then click  Screenshot_1215to define a new path because what you want is not in the list of available items.


      13. Choose Screenshot_1216 to select the path C:\Workshop\winsas\sbiovr\DataMarts. The DataMarts directory does not exist and must be created on the operating system. This can be done from the Browse window by selecting Screenshot_1276


      Remember: Using the Screenshot_1216  button only 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.

The path must physically exist on the operating system.

      14. Select Screenshot_1207 to close the Browse window. Verify the path selected above is now in the Selected items list.


Select Screenshot_1212

      15. Select SASMain as the server, then Screenshot_1212


      16. Review the information and select Screenshot_1223


The library definition is added to the Ungrouped group.



      17. Move the new library to the Libraries group using one of the methods below:

  • Click on Target Tables  Library, drag-and-drop it on top of the Libraries group.
  • Right-click on Target Tables  Library, select Group, expand Foundation, select Libraries, select Screenshot_1207









0 Responses on SAS ETL Studio CaseStudy – Create a Logical Grouping and Adding a Library Definition"

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.