• Print  |
  • Feedback  |

Knowledge Base
Papers Topic List 

SAS Technical Papers

Integration with Microsoft Office

Date Title File Size
March 2009 More Tips and Tricks for Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS (PDF)
Transferring SAS data and analytical results between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This paper explains how to use the XML support in Base SAS®9 software to create multi-sheet Microsoft Excel workbooks (for Excel versions 2002 and later).		 868 KB
March 2008 What’s New in the 4.2 releases of SAS Enterprise Guide and the SAS Add-In for Microsoft Office (PDF)
This paper introduces some of the highlights, including a revamped user interface (UI) in SAS Enterprise Guide, the ability to open SAS Reports from the SAS Add-In, a new PROC REPORT-based wizard, and much more.		 740 KB
March 2008 Tips and Tricks for Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS (PDF)
This paper discusses using the XML support in Base SAS 9.1 software to create multi-sheet Microsoft Excel workbooks (versions 2002 and later). You will learn step-by-step techniques for quickly and easily creating attractive multi-sheet Excel workbooks that contain your SAS output. The information presented is new for 2008.		 528 KB
November 2007 Turbo-Charging Spreadsheets: Accessing SAS Forecast Server from Microsoft Excel (PDF)
This technical white paper shows how SAS Forecast Server can be accessed from Microsoft Excel using three new forecasting wizards in SAS Add-In for Microsoft Office. SAS Add-In for Microsoft Office leverages the power of SAS analytics, reporting and data access directly from Microsoft Office applications.		 1.1 MB
April 2007 Creating Multi-Sheet Excel Workbooks the Easy Way with SAS (PDF)
This paper discusses using the new XML support in Base SAS 9.1 software to create multi-sheet Microsoft Excel workbooks (versions 2002 and later). You will learn step-by-step techniques for quickly and easily creating attractive multi-sheet Excel workbooks that contain your SAS output.		 330 KB
April 2007 ODS and Office Integration (PDF)
Find out how ODS styles can be used in new ways when they are combined with tagsets. Watch as a simple example grows into new ideas on how to use styles and tagsets. See how easy it is to create a new destination and style that do just what you need.		 468 KB