• Home
  • Blog
  • SAS BI
  • SAS ETL Studio CaseStudy – Create a Logical Grouping and Adding a Library Definition in SAS BI

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

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.

Metadata

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

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

Login

MindMajix Youtube Channel

Select ok

The SAS ETL Studio desktop opens:

SAS ETL Studio desktop

Select 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 + 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.

New Group

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.

Rename

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 Next

Select Library

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

SAS Base Engine Library

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

Target Tables Library

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

Select BASE in the Engine field (default)

                                      Checkout SAS BI Interview Questions

13. Choose Browse to select the path Create/edit report The DataMarts directory does not exist and must be created on the operating system. This can be done from the Browse window by selecting Browse

Browsing option

Remember: Using the Browse  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 to close the Browse window. Verify the path selected above is now in the Selected items list.

Selected items list

Select Next
15. Select SASMain as the server, then Next

Select SASMain

16. Review the information and select Finish

Review the information

The library definition is added to the Ungrouped group.

Library definition

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 ok

Select Group

About Author

Vinod M is a Big data expert writer at Mindmajix and contributes in-depth articles on various Big Data Technologies. He also has experience in writing for Docker, Hadoop, Microservices, Commvault, and few BI tools. You can be in touch with him via LinkedIn and Twitter.

read less
  1. Share:
SAS BI Articles