Resources

SAS Technical Papers » Microsoft Office Integration

Papers Topic List 
Date Title
April 2016 Building Interactive Microsoft Excel Worksheets with SAS Office Analytics (PDF)
This paper demonstrates how to open SAS Visual Analytics report into Excel to combine the power of SAS with familiar Microsoft Excel functionality.
April 2016 Infographics Powered by SASŪ Visual Analytics and SASŪ Office Analytics (PDF)
This paper looks at how SASŪ Office Analytics enables a Microsoft Office user to create infographics for all occasions.
May 2015 Take Your Data Analysis and Reporting to the Next Level by Combining SAS® Office Analytics, SAS® Visual Analytics, and SAS® Studio (PDF)
This paper discusses how the interoperability of SAS® Office Analytics, SAS® Visual Analytics, and SAS® Studio can be used to take your analysis and reporting to the next level.
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).
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.