AKSUG 2011 One Day Conference
2011 One Day Conference in Anchorage Alaska
The Alaska SAS Users Group will be holding a one day SAS users group conference in Anchorage on September 7, 2011. A dozen presentations will be made on topics related to Output and Productivity. Two internationally recognized SAS speakers, Vince DelGobbo and Cynthia Zender, will be joining us for this event. Join us. Read the announcement or down load it here.
The AKSUG one-day conference is a unique opportunity to learn from our invited speakers and interact with fellow SAS users from around Alaska.
The $50 fee for a day of training is the best bargain around and can help justify your travel expense to attend.
- 1 Opening Keynote - SAS® Enterprise Guide®
- 2 Closing Keynote - ODS Essentials
- 3 Introduction to the Output Delivery System
- 4 Creating Multi-Sheet Microsoft Excel Workbooks
- 5 ODS Graphics
- 6 Using PROC GMAP to Map Alaskan Vital Statistics
- 7 Writing to RTF Using ODS
- 8 Introduction to the MEANS/SUMMARY Procedure
- 9 Automate a SAS Program by Using the Macro Language
- 10 Accessing and Summarizing Data Using PROC SQL
- 11 Create and Take Advantage of User Defined Formats
- 12 Speaker Bios
- 13 Registration and More Information
Opening Keynote - SAS® Enterprise Guide®
TITLE: You Want ME to use SAS® Enterprise Guide® ??
ABSTRACT:Starting with SAS®9, one copy of SAS Enterprise Guide is included with each PC SAS license. At some sites, desktop PC SAS licenses are being replaced with a single server-based SAS license and desktop versions of Enterprise Guide. This presentation will introduce you to the Enterprise Guide product, and provide you with some good reasons why you should consider using it.
Closing Keynote - ODS Essentials
TITLE: The Greatest Hits: ODS Essentials Every User Should Know
ABSTRACT: Discover that there’s an option or destination or feature that has you singing its praises because the feature boosted your reports to the next level.
This presentation covers some of the essential features and options of ODS that every user needs to know to be productive. This presentation will show you concrete code examples of the ODS “Greatest Hits”. Come to this presentation and learn some of the essential reasons why ODS and Base SAS rock!
Introduction to the Output Delivery System
TITLE: Getting Started With ODS
ABSTRACT:Are you new to SAS®9 or just new to ODS? This presentation provides an overview of ODS basic processing. It covers the basic "sandwich" technique for invoking ODS and creating an report from procedure results. In addition, it shows the basic types of report output that can be created with ODS and opened with popular applications, such as a web browser (for ODS HTML files), Adobe Acrobat Reader (for ODS PDF files), a word processor, such as Microsoft Word (for ODS RTF files) or Microsoft Excel (for ODS CSV, ODS HTML and ODS TAGSETS.EXCELXP files). As a bonus, the presentation also shows the use of STYLE= override syntax for PROC REPORT, PROC PRINT and PROC TABULATE to customize cells in ODS report output created by these procedures.
Creating Multi-Sheet Microsoft Excel Workbooks
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 talk provides basic information on how to use Base SAS 9 software to create multi-sheet 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 ExcelXP 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!
TITLE: Introduction to ODS Graphics for the Non-Statistician
ABSTRACT: Are you a History, English, or other Humanities major who’s stumbled into SAS programming? Are you a business analyst or report analyst whose statistical knowledge ends with mean, median, percentiles and standard deviation? Don't know a fitted loess curve from a survival estimate? Need to produce some series plots and bar charts and maybe the occasional box plot? Don't Panic! This presentation is for you!
This presentation illustrates how to use the new SG procedures, in particular, SGPLOT and SGPANEL to produce simple plots and bar charts. Once you know the basics of the SGPLOT statements to produce single graphs, learning SGPANEL to created paneled output will be a cinch. Through concrete examples, this paper will guide you through the basics of producing and customizing simple graphs using the new SG procedures. In addition, use of the ODS GRAPHICS statement for setting graph options will be covered. (Note: The SGSCATTER and SGRENDER procedures fall outside the scope of this presentation.)
Using PROC GMAP to Map Alaskan Vital Statistics
TITLE: Mapping Vital Statistics
ABSTRACT: Maps provide a unique way to visualize data and illustrate disparities across geographic areas. This presentation will focus on the SAS procedure PROC GMAP and how it can be used to create various data driven maps of Alaska.
Writing to RTF Using ODS
TITLE: Specializing Rich Text Format (RTF) output for publication in MSWord via the Output Delivery System (ODS): Trials, Tribulations, and Lessons Learned
ABSTRACT: This presentation is a discussion of Allen's learning and discovery process as he has been working on ODS/RTF aspects of a SAS program that creates XML output via the tagsets.ExcelXP tagset, some PNG graphic files, and uses a fair amount of macro coding to accomplish some tasks. In short, there will be topics of interest for everyone. Allen will discuss what the code is doing and why --- and that might prompt questions/answers that could help each of us in our own work.
Introduction to the MEANS/SUMMARY Procedure
TITLE: The MEANS/SUMMARY Procedure: Getting Started
ABSTRACT: The MEANS/SUMMARY procedure is a workhorse for most data analysts. It is used to create tables of summary statistics as well as complex summary data sets. The user has a great many options which can be used to customize what the procedure is to produce. Unfortunately most analysts rely on only a few of the simpler basic ways of setting up the PROC step, never realizing that a number of less commonly used options and statements exist that can greatly simplify the procedure code, the analysis steps, and the resulting output.
This tutorial begins with the basic statements of the MEANS/SUMMARY procedure and follows up with introductions to a number of important and useful options and statements that can provide the analyst with much needed tools. With this practical knowledge, you can greatly enhance the usability of the procedure and then you too will be doing more with MEANS/SUMMARY.
Automate a SAS Program by Using the Macro Language
TITLE: Manual to Automatic: Changing Your Program’s Transmission
ABSTRACT: You have successfully created a SAS® program that processes data and generates reports for a series items in the data. The program itself works fine, but the problem is that each time the program is executed, it must be manually modified specifically for that run. Perhaps the analysis variable changes or perhaps the name of the report’s PDF file must reflect the name of the incoming data set. Making manual changes once in awhile is bothersome, but not onerous. But if find yourself making a great many of these manual changes, the process becomes both tedious and error prone.
Through the use of the macro language, SAS has the power make the necessary changes to your program on the fly, automatically, without manual intervention. Learning how to convert a program from one that needs manual modifications to one that adjusts and runs automatically is not difficult. Not difficult that is, if you know the steps. This paper walks you through the steps, that you can follow, to convert your program’s transmission from manual to automatic.
Accessing and Summarizing Data Using PROC SQL
TITLE: Talking to Your Data in its Own Language: Why PROC SQL?
ABSTRACT: Many SAS users draw on large databases created using Structured Query Language (SQL). In this presentation, you’ll learn how the SQL procedure in SAS can facilitate your work with these databases, and how you can speed up many operations by implementing them in PROC SQL. The PROC offers intuitive methods of aggregate arithmetic and merging datasets. You can also use PROC SQL to generate quick reports.
Create and Take Advantage of User Defined Formats
TITLE: Building and Using User Defined Formats
ABSTRACT: Formats are powerful tools within the SAS System. They can be used to change how information is brought into SAS, how it is displayed, and can even be used to reshape the data itself. The Base SAS product comes with a great many predefined formats and it is even possible for you to create your own specialized formats.
This paper will very briefly review the use of formats in general and will then cover a number of aspects dealing with user generated formats. Since formats themselves have a number of uses that are not at first apparent to the new user, we will also look at some of the broader application of formats. Topics include; building formats from data sets, using picture formats, transformations using formats, value translations, and using formats to perform table look-ups.
Allen Bingham is employed as the Chief Biometrician for the Division of Sport Fish for the Alaska Department of Fish and Game (ADF&G) in Anchorage, Alaska. His primary job duties include the supervision of all research, analysis, and statistical reporting of the Biometrics Unit in the Division of Sport Fish, an integrated part of its effective program of resource management.
Art Carpenter, an independent consultant and statistician located in Anchorage, has been a SAS user since 1977. He has written four books and numerous papers, posters, and workshops at various SAS conferences. He has served in various leadership roles for local, regional, national, and international users groups, including conference chair and executive board member of SAS Global Forum.
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.
Andy Jessen is a Research Analyst for the Bureau of Vital Statistics within the Division of Public Health. He has used SAS for 4 years and is experienced in many SAS procedures and output options including proc report, proc tabulate, proc format, and ODS. Outside of work, Andy serves on a board of directors for an arts organization and skates with his wife and daughter.
Pat Moore is an independent consultant and statistician located in Juneau. He ran his first SAS program in 1986 while working on his doctorate. He retired from academia this past July after a 25-year career as a business professor and institutional researcher. He still teaches statistics as an adjunct instructor for the University of Alaska Southeast. When not engaged in SAS consulting, he runs a small custom coffee-roasting business with his wife and son, and serves as president of the Juneau Amateur Radio Club.
Cynthia Zender has been with SAS since 1996 as an instructor and course developer. She currently serves as the Curriculum Manager for the Report Writing and Output Delivery System curriculum. Cynthia is a frequent speaker at SAS Global Forum and at regional SAS user groups. Cynthia is a SAS Certified Professional, with over 25 years of experience programming and reporting with SAS. Prior to joining SAS, she worked with a variety of industries (including education, public utilities, and telecom), using SAS for application development and report writing.
Registration and More Information
On-line registration is now open at: https://www.123signup.com/event?id=cznyp. Although we have a PAY AT THE DOOR option, everyone needs to register on-line so that we can provide you with the lunch option of your choice. Credit cards will only be accepted on-line, and if paying by check make it payable to Charles Utermohle.
Please register by September 5 so that we can get the meals ordered and print the necessary conference materials.
The conference will occur at the Gorsuch Commons at UAA starting at 8 AM to 4:30 PM. Parking is available in the adjacent UAA visitor lot next to Bragaw Road for $10 for the day payable in cash, coin, or credit card.
E-mail Art Carpenter for more information or to be placed on the e-mail list for announcements about this or other AKSUG meetings.