BASUG Quarterly Meeting Announcement

Want ultimate control of your ODS output?  Come and learn how from a SAS Institute ODS author!  With three presentations at the March 2010 BASUG Quarterly Meeting, Cynthia Zender, ODS expert and developer, will skillfully and gently demystify ODS.  You will learn about Templates, Styles, and Tagsets, and how they work with ODS in general.  See the abstracts for further details.

Immediately following the meeting, we will provide an informal light buffet lunch for all meeting attendees.  We hope you can stay for this opportunity to network and socialize with your fellow SAS users.

Please note our venue for this meeting!

 

Topic:

Ultimate Control With ODS

When:

Wednesday, March 10, 2010

8:15 AM – Noon

 

Where:

Microsoft New England Research & Development Center

One Memorial Drive                                                Note Location

Conference Center First Floor

Cambridge, MA 02142

(857) 453-6000

 

Directions:

Please visit: http://www.basug.org/directionsNERD.html

 

How:

Individual, On-Line Registration Required. No e-mail please.

 

Please visit: http://www.basug.org/register.php3, and register by Monday, March 8th.

 

(We have to provide a list of attendees to our host PRIOR to the meeting day.)  If you have not registered on-line by March 8th, you will need to bring a picture ID to show at the door.)

 

Contact:

If you have questions about the meeting please contact:

Sara Hickson (sara.hickson@yahoo.com) or
Brian Saper (
briansaper@yahoo.com)

 

Agenda

 

8:15-8:45

Sign-in and refreshments

8:45-9:00

Announcements

9:00-9:50

Markup 101

9:50-10:05

Break

10:05-10:55

Tiptoe Through the Templates

10:55-11:10

Break

11:10-12:00

Under the Hood: How to Use the ExcelXP Tagset

12:00-1:00

Informal buffet lunch (provided by BASUG)

 

Note: Times are approximate.

Please re-visit the BASUG website (www.basug.org) for updated information.

Bio and Abstracts

Cynthia Zender has been with SAS since 1996 as an instructor and course developer.  She currently serves as the Curriculum Manager for Report Writing and Output Delivery System education.  She has over 25 years of experience programming and reporting with SAS in a number of different industries such as Education, Public Utility, and Telecom.  Cynthia is a frequent speaker at SAS Global Forum and at regional SAS user groups.  She recently finished two graph related courses and is the co-author of the recently published SAS Press book, Output Delivery System: The Basics and Beyond (co-authored with Lauren Haworth and Michele Burlew).

Markup 101

Do you want to know what this "Markup" buzz is all about?  Does it surprise you to know that the concept of "marking up" text for computers has been around since 1969?  So what's all the excitement about?  And what does SAS have to do with it?

Tiptoe Through the Templates

Are you confused about the difference between style templates, table templates, tagset templates, and graph templates?  Do you wonder how they're all used with ODS?  This presentation provides an overview of all the different ODS template types and how they're used with the Output Delivery System.  This presentation will provide an overview and several concrete examples for each template type.

Under the Hood: How to Use the ExcelXP Tagset

This presentation provides a brief overview of the TAGSETS.EXCELXP destination.  Then, concrete examples of using the ODS destination, TAGSETS.EXCELXP, will be demonstrated.  Programs shown will include: using the ExcelXP suboption list; getting the ExcelXP internal help file to display in the SAS log; creating and naming multiple worksheet files; controlling when a new sheet starts; setting column width defaults; using an INI file to set defaults such as orientation or zoom level; sending Excel formats from SAS so that leading zeroes or decimal places are shown when the file opens in Excel.  In addition, some enhancements for the output will be demonstrated, such as performing traffic-lighting, setting column widths, supplying Excel header and footer information, and specifying Excel zoom level.  A link to the program code will be given out to attendees.

BASUG Membership

Keep your BASUG Membership up-to-date!  Print out a membership form from our website, and bring it with you to the meeting, along with your check.  (Please note that we discontinued Corporate Memberships in 2005.)  We provide only Individual Membership at $30 annually, on a calendar year basis.  For more information on our membership policy, or to print out a form visit: http://www.basug.org/basugj.shtml

 

Directions to Microsoft New England Research and Development Center

NOTE LOCATION

Please visit: http://www.basug.org/directionsNERD.html

 

BASUG Contacts

Mailing Address:

BASUG

P. O. Box 170253

Boston, MA 02117

 

To email our Webmaster: basugwm@basug.org