What is SAS?

SAS, an acronym for Science Analysis Systems, is a sophisticated software tool developed and maintained by the SAS group. Its primary function is to process 'raw' Level 0 data, which is provided in LDF format, converting this data into Level 1 data that is ready for analysis. During this conversion process, event data is meticulously reconstructed and classified, distinguishing gamma-rays from charged particles.

The software is organized and distributed as top-level container packages, also known as \"source code toolkits.\" These packages, such as GlastRelease and ScienceTools, encompass the core of the SAS software. Additionally, application packages like Gleam and Likelihood are included within the SAS software suite, enhancing its analytical capabilities.

Each component of SAS software is structured within a directory of the main CVS repository, with the version of each package defining the software release. It's important to note that the SConscript file is the only document that explicitly specifies the versions of each package included in a release.

One of the key uses of SAS is for statistical analysis, which is an integral part of the data analysis process. The software's analytical prowess is not limited to raw data transformation but extends to the interpretation of data through the use of statistical tools and concepts, such as correlation coefficients and statistical significance.

SAS Plugins for Excel

Features of the SAS Add-In for Microsoft Office

The SAS Add-In for Microsoft Office enhances productivity by enabling users to conduct analyses, generate reports, and access SAS content directly within Microsoft Excel, Word, PowerPoint, and Outlook. This integration allows for seamless sharing of SAS content among users. Furthermore, the add-in provides the capability to access SAS Visual Analytics reports across the Microsoft Office suite, making it a versatile tool for data analysis and visualization.

Utilizing the SAS Add-In in Excel

To leverage SAS analytics within Microsoft Excel, users can utilize the SAS Add-In for Microsoft Office. This component object model add-in is easily accessed from the SAS tab in the Ribbon, under the Tools group, and assistance is available through the Help for SAS Add-In for Microsoft Office. It simplifies the process of running analyses and generating reports, streamlining the workflow for those who rely on both SAS and Excel for data processing and analysis.

Integration Benefits of SAS and Excel

The integration of SAS with Excel offers numerous benefits, as they complement each other effectively. SAS excels in handling big data and high-performance analytics, while Excel provides a familiar interface for viewing summarized data. This combination ensures that users can perform high-end analysis while also benefiting from the automatic documentation of work that SAS provides. The collaboration between the two platforms is not competitive but rather synergistic, enhancing the capabilities of both SAS and Excel users.

Common Use Cases

• S

  
  Use case 1: Embedding visual insights from SAS Viya into Excel reports for enhanced data presentation
• S

  
  Use case 2: Directly interacting with and manipulating SAS data within Excel to apply native Excel features for further analysis
• S

  
  Use case 3: Utilizing augmented analytics tools within Excel for advanced data exploration and identifying factors that impact customer satisfaction
• S

  
  Use case 4: Accessing up-to-date SAS Viya dashboards from within Excel to facilitate organizational collaboration
• S

  
  Use case 5: Filtering, sorting, and inserting SAS data into Excel spreadsheets to perform high-performance analytics on large datasets

Frequently Asked Questions

What is the SAS Add-In for Microsoft Office and what features does it offer?

The SAS Add-In for Microsoft Office is an add-in for Microsoft Office that enables users to run analyses, generate reports, and share SAS content directly within Office applications. It facilitates integration with Excel, providing access to the Data Warehouse and allowing for efficient big data analysis.

How can I install the SAS Add-In for Microsoft Office in Excel, and what are the system requirements?

The SAS Add-In for Microsoft Office can be downloaded from the SAS website and requires administrative access to install. It is only available for Windows, and if you are off campus, you must connect to the campus VPN to download the add-in.

What version of the SAS Add-In for Microsoft Office is currently available, and which SAS versions is it compatible with?

The latest version is SAS Add-In 8.3 for Microsoft Office, which is compatible with SAS 9.4 and SAS Viya 3.5.

Where can I find help and additional resources for the SAS Add-In for Microsoft Office?

Help for the SAS Add-In for Microsoft Office is accessible from the SAS tab in the Ribbon. Additional resources such as documentation, training courses, books, hot fixes, and blogs and communities are available on the SAS website.

Is there technical support available for the SAS Add-In for Microsoft Office?

Yes, technical support for the SAS Add-In for Microsoft Office is available from SAS.