SAS® Add-In for Microsoft Office
What is SAS Add-In for Microsoft Office? The SAS Add-In for Microsoft Office enables business users to transparently leverage the power of SAS analytics, reporting and data access directly from Microsoft Office via integrated menus and toolbars.
Why is SAS Add-In for Microsoft Office important? SAS Add-In for Microsoft Office revolutionizes the world of business intelligence. It provides easy access to SAS' broad and deep set of analytic, reporting and data access functionality from within the Microsoft Office environment including Word, Excel and Power Point.
For whom is SAS Add-In for Microsoft Office designed? The SAS Add-In for Microsoft Office is designed for business users, analysts, and decision makers who want to view, analyze and share business intelligence directly from Microsoft Office.
Key Benefits
- Gives business users self-sufficient access to powerful SAS analytics from within Microsoft Office. SAS Add-In for Microsoft Office provides a self-sufficient, automated way to populate and maintain MS Office spreadsheets, reports, documents and presentations with information from corporate data stores or intelligence gained as the result of advanced analytics. It is the only add-in that provides access to such powerful analytics from within Microsoft Office.
- Makes consistent enterprise data from multiple platforms easily available to business users. Users can be given broad access to all relevant data sources, even data repositories larger than those allowed by Excel, from within Microsoft Office without custom interfaces or frequent IT intervention. Users can access and switch between any enterprise data source and control the amount of data that is loaded into their Excel applications.
- Offers extensive integration into Microsoft Office as part of a comprehensive Enterprise Intelligence Platform. SAS is the only vendor with extensive integration into Microsoft Office as part of a wider interoperable suite of business intelligence tools with a common server platform, common metadata and a common management framework. This eliminates information silos and enables users to easily share consistent information and results with others.
Key Features
- Customized analysis and reporting. IT and business analysts can, visually via SAS Enterprise Guide or programmatically with other SAS components, create programs that execute advanced analytics, conduct sophisticated analyses or simply display data to produce charts and tables that can be shared with users. These programs can be easily accessed using a customizable "SAS Favorites" menu.
- Data management. SAS Add-In for Microsoft Office enables Excel users to access and view SAS data sources or any data source available from your SAS server, and analyze this data with SAS’ high-end analytics. Via an intuitive query interface that returns results directly into Microsoft Office spreadsheets, users can preview and query large amounts of any data type supported by SAS servers. Users can also switch dynamically between multiple data sources, enabling them to run multiple tasks with different data sources from within one worksheet or document. A SAS navigation toolbar within Microsoft Office allows users to navigate easily through data sources too large for the row application limit of Excel.
For a complete list of key benefits and features, refer to the SAS Add-In for Microsoft Office fact sheet. ![]()



