An Introduction to Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®
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 talk provides basic information on how to use Base SAS®9 software to quickly and easily create multi-sheet Microsoft Excel workbooks that contain your SAS output using the ExcelXP ODS tagset (for Excel versions 2002 and later).
What You'll Learn
Generate multi-sheet Microsoft Excel workbooks containing just about any SAS procedure output.
Create an ODS style, and use it to produce attractive output.
Incorporate Excel features and functionality, including custom worksheet names, print headers and footers, AutoFilters and Excel formats.
The techniques that will be discussed require only Base SAS®9 software running on any operating system (Windows, UNIX, z/OS, etc.).
Who Should Attend
Anyone interested in creating multi-sheet Microsoft Excel workbooks containing SAS procedure output. All skill levels are welcome.
Vince DelGobbo is a Senior Systems Developer on the Web Tools team at SAS. He has developed the HTML formatting tools and the SAS Design-Time Controls. DelGobbo is working to create other new Web- and server-based technologies as well as ways to integrate SAS output with Microsoft Office. He has been a SAS software user since 1982, and joined SAS in 1992.