Tuesday, 26 January 2010

NOTE: Creating Multi-sheet Microsoft Excel Workbooks

The fourth seminar in SAS's SAS Talks series was held last week. I need to get myself onto the right distribution list because I didn't find out about it until after the event :(

This event was lead by SAS's Vince DelGobbo and focused on providing an introduction to creating multi-sheet Microsoft Excel workbooks with SAS. It's a topic that Vince has presented at various forums before, e.g. PharmaSUG 2007, SUGI 31 and NESUG 09, but still contemporary nonetheless.

Vince described how to use the ExcelXP ODS tagset to create multi-sheet Microsoft Excel workbooks using almost any SAS procedure and incorporating Excel features and functionality such as worksheet names, headers & footers and AutoFilters. All of this is available with just SAS/BASE (on any operating system, not just Windows).

You can find more information at http://www.sas.com/reg/gen/corp/867226. Hopefully a video will be available soon. In the meantime, check-out Vince's SUGI 31 paper.