Exploring SAS Enterprise Guide - SAS BI

SAS Enterprise Guide 3: The Interface

A new Welcome Window allows users to do many things, including:

  • open an existing project
  • create a new project
  • create a new SAS program
  • view the SAS Enterprise Guide tutorial.

The Interface

The SAS Enterprise Guide interface has

  • updated menus and toolbars
  • a reorganized task list
  • a new process flow

Code

Using the Workspace

The SAS Enterprise Guide workspace can have up to eight separate windows, which can be docked or undocked.

Using the Workspace

The View toolbar has toggle icons for each of these sas enterprise guide windows and several other settings for working with the interface.

The Maximize Workspace button changes the size of the active window to fill the entire SAS Enterprise Guide workspace.

Minimizing Workspace Windows

Each window has a push-pin icon that helps manage your workspace.
When you select Pin , the windows will fold up and retreat into the edges of the workspace.
To expand a hidden window, move your mouse over the window name. The window is displayed until you move your mouse out of the window.
To unhide a window that you have hidden, select Pin.

Exploring SAS Enterprise Guide 3

This demonstration explores interface and functionality of SAS Enterprise Guide.

Exploring SAS Enterprise Guide 3

Select Start Ð All Programs Ð SAS Ð Enterprise Guide 3.0 to invoke SAS Enterprise Guide.
Select New Project in the Welcome window.
 
SAS Enterprise Guide

Because this is the first time SAS Enterprise Guide has been run on this computer, there is no current default server. Select Yes in the message box to open the Options window so that you can change the default server.

SAS Enterprise

a. Select Administration from the list in the left side of the Options window.
The Options window allows many other options to be set.
b. Make sure ITConfig Metadata Repository is the active repository.
c. Select SASMain as the default server.

Administration

Select Ok to save the changes and close the Options window.

MindMajix Youtube Channel

Run a Stored Process

Select View Ð Stored Process List to access the Stored Process window.
      a. Expand Training.
           b. Locate Orion Customer List

Related Article: SAS BI Interview Questions & Answers

Stored Process List

c. Right-click on the stored process and select Add to Project.
5. In the Process Flow window, right-click on the stored process and select Run this Stored Process.

Process Flow

6. Because this stored process has a parameter, a window prompts you for the value.

Orion Customer List

Select Run
A HTML output item is added to the Process Flow window and the HTML report is displayed.

Process Flow

To view the log, right-click on the stored process and select Open Log.

Project

When done viewing the report, close the HTML window and Log window if opened (select ).
Add Data to the Active Project
7. To add data to the project from the Orion Star data libraries, select File Ð Open Ð From SAS Server/Binder.
8. Select Servers Ð SASMain.

SAS Server

If prompted for credentials, enter the user ID and password provided by the instructor, and deselect Remember these credentials.

Credentials

Select Open

9. Double-click Libraries to view the libraries assigned to this server.
10. Double-click Target Tables Library.
11. Select OrderFact.

SAS Server

Select Open
12. The table is added to the Project and opened, however, no data is displayed in SAS EnterpriseGuide.

Project Flow

Close the table by selecting 

Set Permissions to View the Data in the OrderFact Table

13. Select Start Ð All Programs Ð SAS Ð SAS Management Console to invoke the SAS Management Console. Log in using the BIArchitecture metadata profile and the username and password provided by the instructor.

Screenshot_1496

14. Expand the Data Library Manager and SAS Libraries.
15. Right-click on Target Tables  Library and select Properties.
16. Select the Authorization tab.
17. Grant the Read permission to the PUBLIC group by selecting the appropriate check box.

Target Tables

Setting permissions on the library will apply that permission to all tables that are currently in the library as well as those that may be added in the future. Permissions can also be granted on individual tables within a library.
18. Select Ok
19. Close the SAS management console by selecting File Ð Exit.
20. Return to SAS Enterprise Guide and re-open the OrderFact table by double-clicking the icon in the Process flow window – data should now be displayed.

Process Flow

Run One-Way Frequencies Task on the OrderFact Table

21. Make sure the OrderFact table is the active data source (selected), then select One-Way Frequencies from the Describe section of the Task List window.
22. When the task dialog opens, assign Order_Type to the Analysis variables role using drag and drop.

One Way Frequencies

23. Use drag and drop to assign Order_Year to the Group analysis by role.

One Way Frequencies

24. Select Statistics in the navigation list on the left to change the statistics in the Select Frequencies and percentages from the Frequency table options.

One Way Frequencies

25. Select Run
The results return to the SAS Enterprise Guide application as an HTML page.

Process Flow

26. When done viewing, close the HTML page (select ).

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