Printable Spreadsheets Made Easy: Utilizing the SAS Excel XP Tagset

The SAS System offers myriad techniques for reporting on data within Microsoft Excel. Depending on the task at hand SAS Access or the Output Delivery System (ODS) might be good choices; Dynamic Data Exchange (DDE) or the old standby, Comma-Separated Values (CSV). This paper describes a method of creating multi-tab, print-ready reports using the Excel XP tagset available in version 9.1. This feature of Base SAS can greatly minimize the manual and repetitious task of preparing headers, footers, and various other formatting needs.