SAS^® Office Analytics

Features

Data access and management

• Access SAS capabilities for data access, reporting and analytics directly from Microsoft Office tools, including Word, Excel and PowerPoint from the Microsoft Outlook mail client and from the Microsoft SharePoint portal.
• Access data from any centrally IT-defined enterprise data source.
• Easy data access and integration without detailed knowledge of the database or SQL.
• Refresh data at the click of a button from any central enterprise data source defined by IT.
• Cycle through data that exceeds row limitations of Microsoft Excel. (Server-side optimization ensures that large data sources are never transferred as one to the client.)
• Includes SAS/ACCESS® Interface to PC Files for access to Microsoft Excel, Microsoft Access, dBase, Lotus, SPSS, JMP^® and Stata.
• Includes SAS/ACCESS Interface to ODBC for access to any ODBC-compliant data source.
• With the included SAS Stored Process Server, users can automate programs to run reports as scheduled or to facilitate users' on-demand updates of reports from within Outlook, SharePoint or links within Office files.

Powerful SAS^® Analytics

A wide range of powerful statistical analysis capabilities, including:

• Analysis of variance for analyzing experimental data.
• Regression to examine the relationship between a response variable and a set of explanatory variables.
• Categorical data analysis for investigating the association of data categories and the strength of the relationships.
• Multivariate analysis for modeling data with two or more response variables or for identifying relationships among variables.
• Survival analysis for measuring lifetime or time until an event.
• Cluster analysis, which places observations into groups based on similarity.
• Multiple imputation that lets you fill in missing values to generate complete data sets.

Graphics and reporting

• 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

• A native Windows application for programmers, analysts or advanced users.
• User interface includes context-sensitive menus, toolbars and role-based user definitions.
• Provides a large number of prebuilt tasks and task templates covering a wide variety of topics.
• Wizard-driven conditional flow logic capabilities for more rapid creation of complex conditional processing.
• Enhanced complex query with computed columns creation, filtering options and preview of results brings efficiency to the query-building process.
• View OLAP cubes from SAS or other vendors that support OLE DB for OLAP and the MDX standard.
• Package results into SAS Stored Processes that can be used 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.

Business metadata management for IT

• Map physical data structures to business terms in an easy-to-use interface.
• Combine data from multiple sources.
• Control the size of result sets that can be returned to avoid long-running queries.
• Centrally manage metadata.
• Create and manage prompts, including cascading prompts, that dynamically generate value lists and repositories, control the SAS Metadata Server, define access controls and register and manage users and groups through a single interface.