Weekend Workshops


Sunday, September 26, 2010
8:00am–12:00pm Andy Ravenna SAS® Enterprise Guide 4.2 – Getting to Know You
8:00am–12:00pm Ronald Fehd Reusable Programs and List Processing: Concepts and Development, Techniques and Tools
8:00am-12:00pm David A. Dickey Linear, Generalized, and Nonlinear Mixed Models
1:00pm–5:00pm Mike Kalt Moving to Release 9.2 of SAS/GRAPH® Software
1:00pm–5:00pm Frank DiIorio Using Dictionary Tables in Pharmaceutical Applications
1:00pm–5:00pm Art Carpenter Beginning PROC REPORT

Sunday, September 26, 2010

Sunday Morning, 8:00 am - 12:00 pm

Andy Ravenna SAS® Enterprise Guide 4.2 – Getting to Know You
Instructor:  Andy Ravenna

The latest release of SAS Enterprise Guide provides perhaps the quickest and slickest point-and-click version yet to access and analyze your data.  However, both longtime users of SAS as well as new users to SAS often don’t know where to begin.  Longtime users are accustomed to typing all of their code into the Program Editor window and hitting the Submit key.  New users are puzzled about where to get started and how to ‘make something happen’ such as creating a report.  This beginning tutorial introduces SAS Enterprise Guide 4.2 to both old and new users of SAS.  It focuses on the key points of a typical session: creating a project, accessing your data, building a query, and producing a report.  It also answers several common questions for first-time users, such as ‘Why can’t I sort my data?’ and ‘How can I copy a task from one project to another project?’.  Attendees receive enough information about this release that they can return to the office with the confidence to get started with SAS Enterprise Guide.

Pre-Requisite:  This beginning tutorial is written for users with no programming experience or SAS knowledge.  Attendees should be familiar with Windows and other software such as Microsoft Office or spreadsheet programs.

Intended Audience:  This tutorial introduces SAS Enterprise Guide 4.2 to both old and new users of SAS.  It focuses on the key points of a typical Enterprise Guide session at a beginner’s pace to build confidence.

Course Materials:  A copy of the slides or paper.

Andy Ravenna, a Technical Training Specialist V based in the New York regional office, is not only fluent in SAS programming but is also fluent in English and Spanish.  Ravenna holds a bachelor's degree in chemical engineering and a master's degree in applied mathematics (minor in statistics) from North Carolina State University, where SAS was born.  While there, he taught Algebra and Calculus for 3 years and received the Maltbie Award for Superior Teaching Ability.  Andy has been working at SAS since 1990 and teaching at SAS for the past 10 years.  His primary focus is in the core curriculum courses, such as SAS Programming 1 & 2: Essentials and Data Manipulation Techniques.  He also teaches more advanced courses like SAS SQL1: Essentials, SAS Macro Language 1 & 2: Essentials and Developing Macro Applications.  Andy has also picked up several of the SAS Business Analytics Courses including: Introduction to SAS Business Intelligence Applications for Reporting and Analysis, Accessing SAS from Microsoft Office Applications, and Creating, Distributing, and Using SAS Stored Processes.  Ravenna has developed course material for the SAS Enterprise Guide product and teaches most courses focusing on Enterprise Guide.  He also teaches Statistics 1: Introduction to ANOVA, Regression, and Logistic Regression.


Sunday Morning, 8:00 am - 12:00 pm

Ronald Fehd Reusable Programs and List Processing: Concepts and Development, Techniques and Tools
Instructor:  Ronald Fehd

This course covers the principles of writing, developing and consolidating reusable programs.  The goal is to make you a more valued and productive programmer or analyst.

At first, you will be shown how to move beyond simple "cut and paste" code into reusable code that handles repetitive tasks efficiently.

Next, you will learn how to look at the process used to write code.  This will allow you to develop the requirements documents usually needed but rarely provided by supervisors and clients.  It will also give you insight into how large-scale applications can be broken down into smaller, repeatable tasks.

Pre-Requisite:  Base SAS

Intended Audience:  Intermediate users and beginning programmers

Course Materials:  Copy of the slides, notes and programs (80 pages).  A link will be provided to download a zip file.

Ronald Fehd has a B.S. in Computer Science, and has attended SAS conferences since 1989.  Since 1997 he has presented over three dozen papers on macro usage, and list processing.  He is the macro maven on SAS-L to which he has posted over 5,000 messages.  In 2001 and 2003 he was voted Most Valuable SAS-L Contributor.  He has 22 years of SAS experience and is SAS HelpDesk at Centers for Disease Control in Atlanta, GA.


Sunday Morning, 8:00 am - 12:00 pm

Linear, Generalized, and Nonlinear Mixed Models
Instructor:  David A. Dickey

In this course we first review the ideas of fixed and random effects as well as REML estimation.  We review the historic approaches to such models in simple analysis of variance situations, touching on the estimation of variance components by the method of moments and their relationship to heritability calculations in genetics.  We show how REML estimation allows the extension of these computations to unbalanced mixed model cases, to repeated measures, and to random coefficients models.  We then discuss models in which the response is not normally distributed, conditional on the predictors.  Binomial and Poisson data are leading examples of these models.  In these models the mean and variance are often functions of the same parameter, for example, in the binomial case with n trials the mean number of successes is np and the variance of this number is np(1-p) so the mean and variance are linked to each other.  In practice, the estimated mean and variance may depart sufficiently from that relationship to require adjustments.  Such adjustments will be addressed as will the alternate strategy of changing to a more appropriate distribution when such departure from expected behavior is encountered.  Some such distributions, for example the zero inflated Poisson or ZIP distribution, require nonlinear models that, in cases of interest to us, also include random effects.  A ZIP model using PROC NLMIXED will be demonstrated.

Pre-Requisite:  Knowledge of multiple regression and analysis of variance techniques at the applied level, training at the advanced undergraduate or introductory graduate level.

Intended Audience:  Applications in the health sciences, biological and environmental sciences are most common though there is some interest in these models in finance.  The workshop will show lots of applications but will not go slowly.

Course Materials:  Copies of the slides (at minimum)

David A. Dickey is William Neal Reynolds Professor of Statistics at North Carolina State University where he has been since 1976.  In addition to his Statistics Department appointment, he is an instructor in NCSU’s Institute for Advanced Analytics and a member of NCSU’s Academy of Outstanding Teachers.  He is a Fellow of the American Statistical Association, a SAS Books by Users author, and a long time SAS contract instructor having taught short courses for SAS since 1981.  He has given presentations at numerous SUGI, SESUG, and American Statistical Association meetings as well as at other universities.  His area of research is time series.  Wayne Fuller and he developed the so-called “Dickey-Fuller test” for stationarity found in many time series texts and statistical software packages including the SAS ETS package.


Sunday Afternoon, 1:00 pm – 5:00 pm

Mike Kalt Moving to Release 9.2 of SAS/GRAPH® Software
Instructor:  Mike Kalt

Release 9.2 of SAS/GRAPH contains a number of new procedures and features that make it much easier to produce statistical graphics than in previous releases of the product.  This seminar will provide an overview of the changes and new features and show you how to create commonly-used statistical graphs with a minimum of effort.

Release 9.2 of SAS/GRAPH Software provides a number of new features and changes of interest to those producing statistical graphics. These include:

  • Changes in the default appearance of graphs, and more integration with ODS.
  • New procedures, such as GTILE and GKPI that produce tile charts and KPI charts.
  • A new set of procedures (SCGPLOT, SGPANEL, SGSCATTER, and SGRENDER) that more easily produce commonly used-statistical graphs than procedures such as GPLOT and GCHART.

The seminar will show you how to take advantage of the new features to more easily create statistical graphs in formats suitable for publication.  You will also learn how to make sure that output from any existing graphics applications does not change in appearance when you move to Release 9.2.

Pre-Requisite:  Experience using SAS/GRAPH software

Intended Audience:  Anyone with a basic knowledge of SAS and SAS/GRAPH who wants to take advantage of the latest features in SAS/GRAPH.

Course Materials:  A hardcopy of the slides used in the seminars will be provided.  The slides include all code used in the seminar.

Mike Kalt is a Technical Training Specialist in the Education Division at SAS, and teaches courses covering Base SAS, SAS/GRAPH, and the SAS Macro Language.  He has been with SAS since 1981.  Prior to joining the Education Division in 2003 he was a manager in the Technical Support Division and was responsible for customer support for SAS graphics products.  Mike has a BA from the University of Michigan and a PhD from the University of North Carolina in Political Science.


Sunday Afternoon, 1:00 pm – 5:00 pm

Using Dictionary Tables in Pharmaceutical Applications
Instructor:  Frank DiIorio

SDTM, ADaM and a host of other emerging standards have added complexity to the already challenging life of pharmaceutical industry programmers.  These standards are typically represented as metadata that describe the attributes of deliverables such as datasets and displays.

SAS dictionary tables are another, complementary metadata source.  These tables contain a wealth of information about a SAS session, describing contents of datasets and views, identifying macro variables, titles and footnotes, ODS destinations, and characteristics of external files.  The tables are useful in and of themselves (think “utility macros”).  And they become even more valuable to programmers who must ensure deliverables’ compliance with standards.

This workshop takes attendees on a tour of the more commonly used dictionary tables.  It:

  • Presents an overview of how the tables are created and maintained
  • Illustrates the relationships among the tables
  • Demonstrates different ways to view the tables’ contents
  • Identifies usage quirks and “features”
  • Gives examples of how they can be used for both generalized and pharma-specific applications

Pre-Requisite:  Basic knowledge of macro language and PROC SQL

Intended Audience:  Programmers, particularly those in health science companies, looking to develop general-purpose, metadata-driven tools.

Course Materials:  Copies of slides provided during class.  Programs, data, and other materials will be made available for download from CodeCrafters web site.

Frank DiIorio is President of CodeCrafters, Inc., a consulting firm specializing in pharmaceutical applications and SAS training.  A SAS programmer since 1975, he is the author of "SAS Applications Programming: A Gentle Introduction" and "Quick Start to Data Analysis with SAS."  He is a frequent speaker at local, regional, and international SAS conferences, presenting at last count over 200 papers and workshops.  Frank is past President of the SouthEast SAS Users Group, and was co-chair of its 1994 and 1996 conferences.  He continues to be active in the regional and local SAS user groups and was a co-founder of the Research Triangle CDISC Users Group.  A born and bred New Yorker, he lived in North Carolina from 1974 until 2008, when he returned to his Yankee roots, relocating to Philadelphia.


Sunday Afternoon, 1:00 pm – 5:00 pm

Art Carpenter Beginning PROC REPORT
Instructor:  Art Carpenter

Although PROC REPORT has been available since Version 6.07, the procedure is generally underutilized. One reason is that the syntax of the procedure is unique with the SAS System. Learning the basic structure in an organized way allows the programmer to easily transition from simple to increasingly more complex tables.

This Seminar will show how PROC REPORT works and thinks through a series of increasingly more complex examples. Examples will include:

  • An introduction to the basic syntax of the PROC step
  • Introduction to the COLMN, DEFINE, COMPUTE, BREAK, and RBREAK statements
  • The demonstration of addition of text to headers and value descriptions
  • The use of the DEFINE statement to form groups and columns
  • The generation of breaks before and after groups
  • The generation of breaks before and after the report
  • The use of ODS with PROC REPORT, including STYLES and traffic lighting

Pre-Requisite:  Basic understanding of the PROC and DATA step

Intended Audience:  Beginning to intermediate

Course Materials:  Course notes

Art Carpenter's publications list includes four books, and numerous papers and posters presented at SAS Global Forum, SUGI, and other user group conferences.  Art has been using SAS® since 1977 and has served in various leadership positions in local, regional, national, and international user groups.  He is a SAS Certified Advanced ProgrammerTM and through California Occidental Consultants he teaches SAS courses and provides contract SAS programming support nationwide.


Copyright © 2010 SouthEast SAS Users Group. All Rights Reserved.