Features

Data access and management

Map physical data structures to business terms in an easy-to-use interface.

Access data from virtually any data source, including multiple sources at once.

Define consistent business views of the data for relational tables and OLAP cubes.

Create one business view over disparate database management systems for a combined set of query attributes.

Combine data from multiple sources.

Control the size of result sets that can be returned to avoid long-running queries.

Capture consistent business rules, and specify allowable options and prompts for users.

Centrally manage metadata.

Create and manage repositories and prompts (including cascading prompts that use dynamically generated value lists), control the SAS Metadata Server, define access controls, and register and manage users and groups through a single interface.

Guided analysis and high-performance tools

Enable power users, programmers and analysts to perform more advanced types of analyses using .NET-based native Windows applications.

An enhanced user interface includes context-sensitive menus, toolbars and role-based user definitions.

Includes a large number of prebuilt tasks and task templates covering a variety of topics.

Create complex conditional processing faster with wizard-driven conditional flow logic capabilities.

Enhance programmer productivity with program editor features, such as autocomplete and integrated syntax.

Improve the efficiency of query-building processes with computed columns creation, filtering options and the ability to preview results.

View OLAP cubes from SAS or other vendors that support OLE DB for OLAP and the MDX standard.

Use slices of OLAP cubes for further analysis.

Easily incorporate geospatial data into analyses.

Query and subset data graphically from any accessible source or write SQL/MDX.

Package results into SAS Stored Processes for use in all SAS Business Intelligence interfaces and Microsoft Office to gain access to anything SAS can do, allowing work to be distributed without IT involvement while maintaining security.

Integrate with high-performance tools from SAS with the addition of the High-Performance Logistic and High-Performance Linear Regression tasks.

View all errors, warnings and notes generated, as well as related line numbers and a sample of the affected code, in a log summary window.

Identify potential internationalization issues in SAS programs and get substitution suggestions.

Add notes to a process flow or to specific objects in the process flow.

Includes the new .msi installer and application streaming support.

Microsoft Office integration

Wizard-driven report creation from within Microsoft Office tools.

Render reports created with SAS inside of Microsoft Office applications.

Refresh tables and charts automatically to get the latest view of information.

Manipulate pivot tables to illustrate multidimensional data from various sources.

Deliver graphics into Microsoft Outlook, Word, Excel or PowerPoint as ActiveX, GIF, JPEG or PNG formats.

Enable distribution of embedded results on demand using native Microsoft Office functionality.

Provide the ability to add SAS Stored Processes to a SharePoint page.

Guided analysis and model development for power users

Access SAS capabilities for data access, reporting and analytics directly from Microsoft Office tools, including Word, Excel, PowerPoint and Outlook.

Create wizard-driven reports within Microsoft Office tools.

View previously created results offline.

Use Microsoft Excel as an application instead of an ad hoc data store.

Access data from any centrally IT-defined enterprise data source and perform a "writeback" to source data using Microsoft Excel.

Refresh data at the click of a button from any central, IT-defined enterprise data source.

Cycle through data that exceeds Microsoft Excel's row limitations. Server-side optimization ensures large data sources are never transferred as one to the client.

Use all Microsoft Excel capabilities on the data displayed, while always having access to the latest view of information.

Embed intelligence and information derived from SAS into Microsoft Word and Excel.

Deliver results in multiple formats (PDF, RTF or HTML) in Microsoft Word or provide raw data (CSV) or HTML in Excel for further manipulation with Microsoft Office applications.

Manipulate pivot tables to illustrate multidimensional data from various sources.

Deliver graphics results directly into Microsoft Word, Excel, PowerPoint and Outlook in any of these formats: ActiveX, PDF, GIF, JPEG or PNG.

Refresh tables and charts automatically to get the latest view of information, pulling from current data that is centrally maintained.

Enable distribution of embedded results on demand using native Microsoft Office functionality.

Utilize the latest Microsoft Office ribbon-bar technology to logically group like items.

View visualizations and explorations created by SAS Visual Analytics in Microsoft Word, Excel and PowerPoint.

Render reports created with SAS Enterprise Guide in Microsoft Office.

Microsoft SharePoint integration

Add reports from SAS Stored Processes to SharePoint so users can monitor organizational performance.

Back to Top