Home  >  Blog  >   SAS BI

Overview of the SAS Add-In for Microsoft Office - SAS BI

Rating: 4
  
 
2670
  1. Share:
SAS BI Articles

SAS Add-In for Microsoft Office

The sas add-in for Microsoft Office is a Component Object Model (COM) add-in that extends Microsoft Office by enabling the user to harness the power of SAS analytics and access SAS data sources from within Microsoft Word and Microsoft Excel.
You can use the SAS add-in to execute stored processes dynamically and embed the results in your documents and spreadsheets.
Within Excel, you can use the SAS add-in to

  • access and view SAS data sources
  • access and view any other data source that is available from your SAS server
  • analyze SAS or Excel data using analytic tasks.

Why Is the SASAdd-In for Microsoft Office Important?

There are many business users who can benefit from the power of SAS analytics, but they are not comfortable working in a traditional programming environment.
The SAS Add-In brings SAS analytics, data access, and SAS content to the Microsoft Office environment.
These business users are already familiar with Excel and Word and use the products daily. The ability to run SAS programs within these programs provides tremendous flexibility and functionality.

Capabilities

With the SAS Add-In for Microsoft Office, you can

  • embed SAS reports and analytics into Microsoft Office applications using stored processes
  • exchange data between SAS servers and Microsoft Office
  • manipulate results and distribute them with existing Microsoft Office functionality.

                                              Checkout SAS BI Interview Questions

Requirements

The following are the system requirements for installing and using the SAS Add-in for Microsoft Office:

  • Windows NT 4, Windows 2000, Windows XP
  • Office 2000 or greater
  • SAS Add-In for Microsoft Office.

MindMajix Youtube Channel

Interaction with SAS Application Servers

The SAS Add-In for Microsoft Office can use different types of application servers:

The SAS Add-In for Microsoft Office does not interact with the SAS OLAP Server. Microsoft Excel can access sas olap cubes using the pivot table functionality built into Excel.

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

About Author

Vinod M is a Big data expert writer at Mindmajix and contributes in-depth articles on various Big Data Technologies. He also has experience in writing for Docker, Hadoop, Microservices, Commvault, and few BI tools. You can be in touch with him via LinkedIn and Twitter.

read more
Recommended Courses

1 / 15