What's New in SAS Enterprise Guide 5.1

Overview

SAS Enterprise Guide 5.1 includes the following new features and enhancements:
  • new 64-bit SAS Enterprise Guide application
  • new Data Explorer tool that you can use to view a SAS data set without adding the data set to your project
  • enhancements to the Query Builder, including reusable query templates and support for subqueries
  • new features for editing programs
  • new features in the OLAP Analyzer, including the ability to adjust values in a write-enabled OLAP cube
  • improved support for grid computing
  • support for parallel execution of tasks
  • enhancements to stored processes
  • enhancements to SAS tasks
  • new default style for SAS Report and HTML results
  • general enhancements
You can run SAS Enterprise Guide on either a SAS 9.2 or SAS 9.3 server.

New 64-bit SAS Enterprise Guide Application

SAS Enterprise Guide 5.1 is now available as either a 32-bit or a 64-bit application. If you are using a 32-bit Microsoft Windows operating system, then you must use the 32-bit version of SAS Enterprise Guide. If you are using a 64-bit Windows operating system, then you can run either the 32-bit or the 64-bit version of SAS Enterprise Guide.
Note: In the 64-bit version of SAS Enterprise Guide, you cannot open Microsoft Exchange or Microsoft Access data or send files by using e-mail applications that support the Messaging Application Programming Interface (MAPI). If you need these features, install the 32-bit version of SAS Enterprise Guide.

New Data Explorer Tool

The new Data Explorer tool enables you to perform the following tasks:
  • Create a custom view of your data by selecting columns to include in the view, creating a filter, and sorting your data.
  • Quickly calculate basic charts and statistics for each column in a SAS data set.
  • Add a data exploration view to your project.

Enhancements to the Query Builder

  • Query templates enable you to save the settings for your specific query to a template that you can use again.
  • Subqueries enable you to use the results from one query as the input for another query.
  • You can use the Automatically surround query expressions with parentheses option to ensure that each expression in a filter is evaluated as a single condition.

New Features for Editing Programs

  • You can use the new Web links in the syntax help window to get additional help when you are writing or editing a SAS program.
  • The autocompletion feature in the program editor can now complete SAS data set and SAS data set column names.

Enhancements to the OLAP Analyzer

  • If you are using an OLAP server that supports write-enabled cubes, then you can use the OLAP Analyzer to adjust values in the cube.
  • You can change the format of measures that are displayed in the OLAP Analyzer.
  • The OLAP Analyzer interface has been updated to display cube views in view groups. Each view group can contain multiple views of the cube.
  • The ESRI map interface has been updated with new navigation and drawing tools.
  • Search functionality has been added to the Cube Manager and the MDX Editor.

Improved Support for Grid Computing

SAS Enterprise Guide 5.1 has a new option that enables SAS Enterprise Guide to run tasks in a SAS grid computing environment. You can use this option at the project level or for an individual task.

Support for Parallel Execution of Tasks

SAS Enterprise Guide 5.1 has a new option that allows parallel execution of tasks on the same server. You can use this option at the project level or for an individual task.

Enhancements to Stored Processes

In SAS Enterprise Guide, you can create stored processes that are compatible with SAS 9.2 or stored processes that run only on SAS 9.3 servers. These enhancements are for stored processes that you run on SAS 9.3 servers:
  • You can hide a stored process. When you select this option, the stored process is not available in the client application where a user might run it.
  • The execution options have changed in the Create New Stored Process Wizard and in the Stored Process Manager.
  • For data sources and data targets, you now have the option of creating a data table to use as a data source or data target. For stored processes that are compatible with SAS 9.2, you can create only generic (byte-stream) data or an XML stream as the data source or data target.

Enhancements to SAS Tasks

  • The new Show an ODS Statistical Graph task is available in both SAS Enterprise Guide and the SAS Add-In for Microsoft Office. In this task, you select the graph definition (SGD file) to use for a selected data source. The graph definition can be created in SAS Enterprise Guide.
  • In the Tile Chart task, you can now create a separate chart for each unique value of the specified BY variable.

New Default Style for SAS Report and HTML Results

HtmlBlue is the new default style for SAS Report and HTML results.

General Enhancements

  • You can suppress the GOPTIONS statement that is automatically added to the SAS code that SAS Enterprise Guide generates by using the new Suppress graph option statement in generated code option.
  • You can now refresh a SAS Web Report Studio report from within SAS Enterprise Guide.
  • You can export a data file as a Microsoft Excel Open XML Workbook (*.xlsx) file.