Virginia SAS Users Group

Our Next Meeting: November 7th, 2011:

Getting the Most from the SAS Format Facility
– Andrew Karp, Sierra Information Services
PROC MEANS: The Basics and Beyond
– Andrew Karp, Sierra Information Services
Using SAS to create Custom Graphics
– Barbara Okerson, HMC

The meeting will be held from 9 AM to 2 PM at the Tuckahoe Public Library

Click on image above for directions

For more information about Andrew Karp’s presentations click here

Special thanks to our Corporate Partner SunTrust for sponsoring this meeting!

Title: An Introduction to Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way With SAS®

Abstract: 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 workshop provides basic information on how to use Base SAS®9 software to create multi-sheet Microsoft Excel workbooks (for Excel versions 2002 and later). You will learn techniques for quickly and easily creating attractive, multi-sheet Excel workbooks that contain your SAS output using the ExcelXP ODS tagset. The techniques that are presented in this talk can be used regardless of the platform on which SAS software is installed. You can even use them on a mainframe! More in-depth information on this topic will also be presented as time permits.

Bio: Vince DelGobbo is a Senior Systems Developer in the Web Tools group at SAS. This group is responsible for developing the SAS/IntrNet Application Dispatcher and SAS Stored Processes. He is the developer for the HTML Formatting Tools and the SAS Design-Time Controls, and is developing other new Web- and server-based technologies, as well as integrating SAS output with Microsoft Office. He is also involved in the development of the ExcelXP ODS tagset. Vince has been a SAS Software user since 1982, and joined SAS in 1992.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

The hand-outs for the Hands-on Workshop can be downloaded below:
Powerpoint Presentation

Introduction to ExcelXP Tagsets Handout

Vince DelGobbo’s ExcelXP Tagset Paper Index

You can view a recording of a previous presentation by clicking the “View Now” link on this page:
An Introduction to Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®

Special thanks to our Corporate Partners SunTrust, Smith Hanley, and TEK Systems for sponsoring this meeting!

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. (r) indicates USA registration.