Products & Solutions / SAS Office Analytics for Midsize Business

SAS® Office Analytics for Midsize Business

Access the power of SAS from a familiar Microsoft Office environment

SAS Office Analytics for Midsize Business enables organizations that have invested deeply in Microsoft Office products (Excel, PowerPoint and Word) to obtain consistent views of data, automate report generation and add analytical insights while keeping information consumers within their interface comfort zone.

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

Benefits

  • Access a single, consistent view of data.
  • Make business users self-sufficient.
  • Get faster, better results with easy-to-use tools.
  • Free IT for more strategic tasks.
  • Satisfy corporate and governmental compliance regulations.

Read more

Features

  • Microsoft Office integration
  • Data access engines
  • Powerful SAS® Analytics
  • Guided analysis and model development for power users
  • Business metadata management for IT

Read more

Screenshot

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


Screenshots

How SAS® Is Different

SAS Office Analytics for Midsize Business gives small and midsize business users access to the market-leading statistical power of SAS, yielding insights that until now were only available to larger organizations. The solution:

  • Provides real-time access to data, enabling users to refresh data automatically, run queries and apply relevant filters to ensure that the most up-to-date information is readily available. 
  • Makes advanced analytics available to business users via SAS® Enterprise Guide®  and SAS/STAT ® software, which are both included with the solution.
  • Allows business analysts and users to remain in the comfort and familiarity of a Microsoft Office environment (Word, Excel or PowerPoint) as they produce management reports and manipulate results.
  • Requires minimal training -- users can quickly form fact-based decisions based on analytical insights to create competitive advantage. 

Benefits

  • Access a single, consistent view of data.

    Users can access and consolidate data from different operational systems to get a unified view of the most recent information. Instead of building their own data extracts, users can take the most recent data from operational systems and populate Excel, Word, PowerPoint files or SharePoint portals. No longer will they have different versions of the same report.

  • Make business users self-sufficient.

    By taking advantage of the proven capabilities of advanced SAS Analytics directly from familiar Microsoft Office applications, business users can get predictive insights rather than just summaries and basic graphs. So they can be assured of having the up-to-date information needed for accurate analysis, while eliminating problems associated with intermediate summarized data formats.

  • Get faster, better results with easy-to-use tools.

    An intuitive query interface lets users access large amounts of data and view results directly in Excel. Guided analysis lets them analyze data, schedule projects, share results and embed them into Office applications.

  • Free IT for more strategic tasks.

    Single, centralized data access and control ensures that users have appropriate access privileges and can react quickly to evolving business demands. Because users are self-sufficient, IT is freed from tedious maintenance and ad hoc query and reporting tasks.

  • Satisfy corporate and governmental compliance regulations.

    With SAS, you can produce repeatable results using validated data and pro­cesses that are easily documented and verified for corporate and govern­mental compliance. Imagine how much time can be saved – no more tracking down which report is the correct one.

Features

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.

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 environment
  • Microsoft Windows (32 bit): Windows XP Professional, Windows Vista*, Windows 7
  • Microsoft Windows x64 (64-bit): Windows XP Professional for x64, Windows Vista®  for x64, Windows 7 for x64
Supported Web browsers
  • Internet Explorer 7 and 8 on Windows XP Pro, Microsoft Server 2003 and 2008, and Windows Vista®
  • Internet Explorer 8 on Windows Server 2008 and Windows 7
  • Internet Explorer 9 on Windows Vista and Windows 7
  • Firefox 3.6 on Windows XP Pro, Microsoft Server 2008, Windows Vista* and Linux for x86 (SuSE and RHEL)
Web server environment
  • IBM WebSphere 7.0.0.13 on: AIX, Linux x64, Solaris (SPARC and x64), Windows x64, z/OS
  • JBoss EAP 4.3 on: AIX on Power, HP/UX on Itanium, Linux x64, Solaris (SPARC and x64), Windows x64
  • Oracle WebLogic 10gr3 and 11gr1 on: AIX on Power, HP/UX on Itanium, Linux x64, Solaris (SPARC and x64), Windows x64
Server environment
  • HP-UX on Itanium: 11iv3 (11.31)
  • HP-UX on PA-RISC: 11iv3 (11.31)
  • IBM AIX on POWER architectures: 6.1 and 7.1
  • IBM z/OS: V1R10 and higher
  • Linux (32-bit): Novell SuSE 10 and 11; RHEL 5 and 6
  • Linux x64 (64-bit): Novell SuSE 10 and 11; RHEL 5 and 6
  • Microsoft Windows (32-bit): Windows XP Professional, Windows Vista*, Windows 7, Windows Server 2003 family, Windows Server 2008 family
  • Microsoft Windows on x64 (64-bit): Windows XP Professional for x64, Windows Vista®  for x64, Windows 7 for x64, Windows Server 2003 family for x64, Windows Server 2008 family for x64
  • Solaris on SPARC: Version 10 Update 8
  • Solaris on x64 (x64-86): Version 10 Update 8

* NOTE: Windows Vista Editions that are supported include Enterprise, Business and Ultimate

Ready to learn more?

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