SAS Office Analytics for Midsize Business

Microsoft Office integration

• Access SAS capabilities for data access, reporting and analytics directly from Microsoft Office tools, including Word, Excel, PowerPoint and Outlook.
  Use wizard-driven report creation within Microsoft Office tools.
• Provide offline viewing of previously created results.
• 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 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.
• Use all the capabilities of Microsoft Excel on the data displayed, but retain the ability to always access the latest view of information.
• Embed intelligence and information derived from SAS into Microsoft Word and Excel.
• Deliver results as a PDF, RTF or HTML with Microsoft Word, raw data (CSV) or HTML into Excel for further manipulation with native Microsoft Office functionality.
• 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 cur­rent data that is centrally maintained.
• Enable distribution of embedded results on demand using native Microsoft Office functionality.
• Render reports created with SAS^® Enterprise Guide inside of Microsoft Office.

Data access engines

• Access data directly, easily and securely with native interfaces. Use the solution's data access capabilities, including:
  • SAS/ACCESS^® Interface to PC Files for access to Microsoft Excel, Microsoft Access, dBase, Lotus, SPSS, JMP^® and Stata.
  • SAS/ACCESS Interface to ODBC for access to any ODBC-compliant data source.

Powerful SAS^® Analytics

• Includes a wide range of powerful statistical analysis capabilities. These include:
  • 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 imputations, which let you fill in missing values to generate complete data sets.

Guided analysis and model development for power users

• Provides a .NET-based native Windows application to programmers, analysts and advanced users.
• Includes an enhanced user interface with context-sensitive menus, toolbars and role-based user definitions.
• Has a large number of prebuilt tasks and task templates that cover a wide variety of topics.
• Offers wizard-driven conditional flow logic capabilities for more rapid creation of complex, conditional processing.
• Provides enhanced complex query with computed columns creation, filtering options and results preview to make the query-building process more efficient.
• View OLAP cubes from SAS or other vendors that support OLE DB for OLAP and the MDX standard.
• Analyze further using slices of OLAP cubes.
• Easily incorporates geospatial data into analyses.
• Query and subset data graphically from any accessible source or write SQL/MDX.
• Package results into SAS Stored Processes that can be used in all SAS Business Intelligence interfaces and Microsoft Office. This provides secure access to anything SAS can do, and allows work to be distributed without IT involvement.

Business metadata management for IT

• 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.
• Combine data from multiple sources.
• Define consistent business views of data for relational tables and OLAP cubes.
• Create one business view over disparate database management systems for a combined set of query attributes.
• Control the size of result sets that can be returned to avoid long-running queries.
• Centrally manage metadata, define access controls, and register and manage users and groups through a single interface.