Products & Solutions / Office Analytics

SAS® Office Analytics

Seamless access to the power of SAS® Analytics in familiar Microsoft Office environments

SAS Office Analytics connects analytics data with Microsoft Office products (Excel, PowerPoint, Word and Outlook) to produce consistent views of data, automate reporting and add analytical insights while keeping information consumers within their interface comfort zone.

It revolutionizes the world of business intelligence by enabling business users to fully engage the power of SAS for data access, reporting and analytics directly from Microsoft Office via integrated menus and toolbars.

Benefits

  • Access powerful SAS Analytics via Microsoft Office applications.
  • Create and share reports with anyone,anywhere.
  • Liberate IT by centralizing data access and control.
  • Achieve greater productivity through high-performance computing.

Read more

Features

  • Data access and management
  • Guided analysis and high-performance tools
  • Microsoft Office integration
  • Guided analysis and model development for power users
  • Microsoft SharePoint integration

Read more

Screenshot

Seamless integration with Microsoft Office gives you easy access to SAS tasks, charts and statistics.


Screenshots

How SAS® Is Different

Only SAS Office Analytics provides the ability to:

  • Access data in real time, enabling you to refresh data automatically, run queries and apply relevant filters to ensure that the most up-to-date information is readily available.
  • Easily access the market-leading statistical power of SAS Analytics via SAS® Enterprise Guide® and SAS/STAT® software, which are included.
  • Produce analytic reports or manipulate results without leaving the comfort of Microsoft Office applications.
  • Create data access paths and statistical routines that lead to greater analytical insights, fact-based decisions and a greater competitive advantage, with minimal training required.
  • Publish reports and/or share Microsoft Office files with executive management and information consumers through various Microsoft Office applications.

Benefits

  • Access powerful SAS Analytics via Microsoft Office applications. An intuitive point-and-click interface lets business users access and analyze large amounts of data and view results directly in familiar Microsoft Office applications – e.g., Word, Excel, PowerPoint and SharePoint. Guided analysis via built-in tasks and visual process flows means even SAS novices can quickly perform sophisticated analyses, schedule projects, share results and easily embed outputs for repeated use.
  • Create and share reports with anyone,anywhere. Create and distribute custom wizards as needed, and deliver information through an established publishing framework. You can also publish dynamic, interactive content – including data visualizations created in SAS Visual Analytics – to Microsoft Office and Web users.
  • Liberate IT by centralizing data access and control. Centralized access to corporate data enables IT to ensure that users have appropriate access privileges, while empowering them to react quickly to evolving business demands. Performance and audit reports enable proactive compliance with data governance rules. And because the software enables users to be more self-sufficient, IT is free to focus on more strategic initiatives.
  • Achieve greater productivity through high-performance computing. Integration with high-performance tools from SAS enables greater productivity. Jobs can be optimized for your environment, and auto-detection of the grid environment saves time and enables you to get results sooner.

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.

Screenshots

Screenshot
Seamless integration with Microsoft Office gives you easy access to SAS tasks, charts and statistics.

View Screenshot

Screenshot
View KPIs, reports and graphs from Microsoft SharePoint.

View Screenshot

Screenshot
View KPIs, reports and graphs from Microsoft Outlook.

View Screenshot

Screenshot
Access to analytic and statistical information is quick and easy for any type of business user.

View Screenshot

System Requirements

Client Tier
  • Microsoft Windows (64-bit): Windows 7* x64 SP1; Windows 8** x64
Middle Tier
  • HP/UX on Itanium
  • IBM AIX on POWER
  • Linux x64 (x86-64)
  • Microsoft Windows x64 (x86-64)
  • Solaris (SPARC and x64)
Supported Web Browsers
  • Internet Explorer 9: Windows 7 (32-bit and x64 32-bit Web browsers)
  • Internet Explorer 10: Windows 7 and Windows 8 (32-bit and x64 32-bit Web browsers)
  • Firefox 6 and up: Windows 7 and Windows 8 (32-bit and x64 32-bit Web browsers); Linux x64: RHEL 6 and SLES 11 (32-bit Web browsers)
  • Chrome 15 and up: Windows 7 and Windows 8 (32-bit and x64 32-bit Web browsers); Linux x64: RHEL 6.1 and SLES 11 SP 1 (32-bit Web browsers)

You can also review the Third-Party Support page for details about requirements of third-party software for use with SAS 9.4.

Host Platforms/Server Tier
  • HP/UX on Itanium: 11iv3 (11.31)
  • IBM AIX R64 on POWER architecture 7.1
  • IBM z/OS: V1R11 and higher
  • Linux x64 (64-bit): Novell SuSE 11 SP1; Red Hat Enterprise Linux 6.1; Oracle Linux 6.1
  • Microsoft Windows on x64 (64-bit):
    Desktop: Windows 7* x64 SP1; Windows 8** x64
    Server: Windows Server 2008 x64 SP2 Family; Windows Server 2008 R2 SP1 Family; Windows Server 2012 Family
  • Solaris on SPARC: Version 10 Update 9
  • Solaris on x64 (x64-86): Version 10 Update 9; Version 11

* NOTE: Windows 7 supported editions are: Professional, Ultimate and Enterprise.
** NOTE: Supported editions include: Windows 8, Windows 8 Pro, Windows 8 Enterprise.

Please consult your local SAS sales representative if you have questions about your platform requirements. Also, for more detailed information, please visit our support site at http://support.sas.com/resources/sysreq/.

Ready to learn more?

Call us at 1-800-727-0025 (US and Canada) or request more information.