Academic Sections
   Beyond the Basics

Bob Bolen & Erik Larsen

Beyond the Basics papers should articulate advanced programming concepts and SAS functionality.  Papers accepted to this section should address a broad spectrum of advanced SAS Foundation topics including ODS, Macro, and sophisticated, efficient PROC and DATA Step programming, SAS® Enterprise Guide®, RDBMS data and the reporting and analytics provided by the SAS Business Intelligence suite.

These papers will provide the knowledge needed to implement enhanced techniques and take advantage of the many possibilities afforded by SAS software.

Title Author(s)
%whatChanged: A Tool for the Well-Behaved Macro Frank DiIorio
While You Were Sleeping, SAS® Was Hard At Work Andrea Wainwright-Zimmerman
Which SASAUTOS Macros Are Available To My SAS® Session Harry Droogendyk
QC Your SAS® and RDBMS Data Using Dictionary Tables Harry Droogendyk
SAS/Data Integration Studio® – Creating and Using a Generated Transformation Jeff Dyson
ExcelXP on Steroids: Adding Custom Options To The ExcelXP Tagset Mike Molter
Mobile Macros - Get Up to Speed Somewhere New Fast Patricia Hettinger
SAS® and Relational Databases: What You Must Know Patricia Hettinger
A Serious Look Macro Quoting Ian Whitlock
The Path, The Whole Path, And Nothing But the Path, So Help Me Windows Art Carpenter
ODS Layout for RTF - A custom tagset Richard A. DeVenezia
The DoW-Loop Unrolled Paul M. Dorfman
PROC_CODEBOOK, Automating the Review and Documentation of SAS® Files James Terry


   Coders’ Corner

Joy Smith & Sarah Woodruff

Do you have an intriguing or innovative piece of SAS code to share?  Have you written a creative solution to a problem that other SAS users could benefit from seeing in action?  Is there a useful SAS option or technique that you find is underutilized?  These are just the sort of ideas to be explored in Coders’ Corner.  With 10-minute presentation time slots, this fast-paced, dynamic section is just the place to share a bit of your savvy.  Whether you are a SAS veteran using this as an opportunity to share a smaller scale idea or a relative newcomer who has found a fresh perspective, you want to make a submission to Coders’ Corner.  The full range of SAS applications and levels of experience can be explored here.

Title Author(s)
A View Toward Performance Ed Heaton
Using SAS® to Produce Report-Ready Summaries of Likert-Type Survey Data: PROC TABULATE, Output Delivery System, PROC TEMPLATE Imelda Go
Recoding “ALL THAT APPLY” Variables from Handhelds and Portable Computers Wafa Handley, Barbara Bibb, Lilia Filippenko, Jay Levinsohn, Donna Medeiros
Making Sense of Census Data Robert S. Matthews
By Your Command: Executing Windows DLLs from SAS® Enterprise Guide Darryl Putnam
How to run an error check to stop SAS® Dan Blanchette
%RESTRUCT - SAS® macro with Proc Univariate Milorad Stojanovic
IF and %IF You Don't Understand Ian Whitlock
Automation of Data Updates: A Case Study Carry Croghan
Using DICTIONARY Views to Eliminate Tedious Visual Review Christine Davies
Application Dispatcher: Some Tweaks and Tricks Carol Martell
Bars and Lines: A Quick Introduction to PROC GBARLINE Garland D. Maddox
Which Job Sent *THAT* Error Message - How to Generate a Lookup List From Your Metadata Robert Janka
Your Friendly Neighborhood Webcrawler: A Guide to Crawling the Web with SAS® James Cox
SAS® Abbreviations Are Your Friends; Use a Template Method to Code! Elizabeth Ceranowski


   Foundations and Fundamentals

Deborah Skinner & Peter Eberhardt

SAS basics are not just about Base SAS anymore.

Papers in the Foundations and Fundamentals section are 50 minute tutorial style papers which focus on a topic or feature, stepping the audience through the techniques needed to understand the topic.  Papers from both Base SAS and Enterprise Guide are welcomed.

Examples of topics include:

  1. Exploiting features of the SAS System, such as functions and statements
  2. Data step fundamentals, such as missover vs. truncover
  3. Coding for efficiencies to improve processing performance
  4. Tricks to using the SAS Enterprise Guide prompt system

Title Author(s)
Take Control: Understanding and Controlling Your Do-Loops Sarah A. Woodruff, Toby Dunn
Building the Better Macro: Best Practices for the Design of Reliable, Effective Tools Frank DiIorio
The Data Step; Your Key To Successful Data Processing In SAS® Don Kros
SAS® Formats: Effective and Efficient Harry Droogendyk
Fun with Functions Yogini Thakkar
Merging into Hash: Some Practical Examples of Converting MERGE Statements into Hash Objects Ying Liu
The MEANS/SUMMARY Procedure: Getting Started Art Carpenter
Leave Your Bad Code Behind: 50 Ways to Make Your SAS® Code Execute More Efficiently William E. Benjamin Jr
Know What Your Business Client Wants: An Introduction to how analytics is used to understand loyalty program in the hospitality industry Tracy Li-moshenko
It’s Five O’Clock Somewhere!!! Handling Dates And Times In SAS® Toby Dunn, Sarah A. Woodruff
Evolve from a Carpenter’s Apprentice to a Master Woodworker: Creating a Plan for Your Reports and Avoiding Common Pitfalls in REPORT Procedure Coding Allison Booth
SAS® Programmer's Paradise: New Goodies in SAS® Enterprise Guide® 4.3 Stephen Slocum
Point-and-Click Programming Using SAS® Enterprise Guide® Mira Shapiro, Kirk P. Lafler


   Hands-On Workshops

Ilene Brill & Harry Droogendyk

Hands-On Workshops (HOW) is a unique section in which subject area experts walk through a presentation and a series of guided exercises to teach aspects of SAS products or concepts.  If you are a good communicator with a knack for explaining concepts clearly and have the ability to develop exercises that drive home the learnings, we want you!

HOW sessions are seventy-five minutes long consisting of a combination of lecture and hands-on activities for attendees.  The room will be equipped with PCs, each accommodating 2 participants.

HOW topics can include Base SAS procedures and concepts, ODS, Macro, Enterprise Guide, SAS Graphics or any of the BI platform capabilities.  We are open to new suggestions and welcome your ideas and proposals for consideration.

Title Author(s)
Statistical Analysis - The First Steps Jennifer Waller
Macro Quoting - How and Why Ian Whitlock
PROC TABULATE: Doing More Art Carpenter
SAS/GRAPH® Elements You Should Know – Even If You Do Not Use SAS/GRAPH® Art Carpenter
Two Guys on Hash Paul M. Dorfman, Peter Eberhardt
How To Use Proc SQL select into for List Processing Ronald Fehd
Traffic Lighting Your Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS® Vince DelGobbo


   Planning and Support

Peter Eberhardt

As SAS professionals our primary concern tends to be the quality the programs we write and the results we provide.  However, in order for us to do our job properly a lot of work has to be done behind the scenes – the planning and administration of the site.  This section will bring this behind the scenes work to the foreground.  Among the topics of interest are:

  • Recruiting and Hiring qualified staff
  • Training and skill development
  • SAS Certification
  • SAS Server deployment planning and administration
  • Project Management
If you have best practices on these or other planning and administration areas you want to share we have the forum available to you.

Title Author(s)
If you Have Programming Standards, Please Raise Your Hand: An Everyman’s Guide Dianne Louise Rhodes
Supporting SAS® Whether You Are a User or Not Panel Discussion with: Robert Jackson, Stephanie R. Thompson, and others T.B.D.
If You Can’t Learn It From A Book, Why Are You Reading This? Steve Noga
At Your Service: Your Roadmap to Support from SAS® Kathy Council
SAS-L and Beyond Joe Kelley



Carol Martell

The Poster Section spans all topic areas. Posters should be self-explanatory.  While there will be a one-hour time slot when the authors are available to discuss their posters with conference attendees, your poster will more often be viewed in your absence.  Posters are on display throughout the entire conference, allowing people to review the ideas in a quiet, self-paced environment.  The best posters use images, graphs, colors and tables to convey ideas and present methodologies in a creative and visually entertaining manner.

Title Author(s)
Using SAS® to Examine Missing Data in Psychometric Research JoAnne Herman, Elizabeth Register, Abbas Tavakoli
SAS® Maps as Tools to Display and Clarify Healthcare Outcomes Barbara B. Okerson
LAG Function Combined with Conditional Functions – Useful in Identifying Differences in Like Data Andrew Hummel
Solving Kenken Puzzles - By Not Playing John R. Gerlach
ES_ANOVA: A SAS® Macro for Computing Point and Interval Estimates of Effect Sizes Associated with Analysis of Variance Models Jeffrey D. Kromrey, Bethany A. Bell
How to Monitor “Don’t Know” and “Refusal” Non-responses in a Large National Survey - Using Simple SAS® Macros, a Few PROCs, and Data Steps. Mariah Cheng, Timothy Monbureau
Proc Report Data = Subject.Event_Chronology; Christina Carty, Elizabeth Spence
Guide to ODS Graphics Editor in SAS® 9.2 Mirjana Stojanovic
Customizing Saved Proc Import Code Carolyn D. Williams
Fitting multivariate random-effects models using SAS® PROC GLIMMIX Lei Li
A SAS/AF® Application for Organizing the Data Management Activities of the CHIMES Follow Up Study Emily A. Mixon, Valisa R. Brown, Karen B. Fowler
Technique of Using PROC SQL Hui-Ping Chen
Analysis and Visual Review of Error Matrices in SAS® Stat Studios Robert Seffrin
Sample Size Calculation to Evaluate Mediation Analysis Rajendra Kadel
Developing a Telco Revenue Forecasting and Device Optimization Analytics Tool Lan Guan
The SAS® User Group Community Activity Don Kros
Using Dictionary Tables to Explore SAS® Datasets Phillip Julian


   Reporting and Information Visualization

Barbara Okerson & Andrea Wainwright-Zimmerman

Over the years SAS® has made significant advances in the tools available for reporting and data visualization.  Whether you use the latest SAS products such as BI or Enterprise Guide or use traditional products like Base SAS, SAS/GRAPH, and ODS, here's your opportunity to share with us how you've been able to visualize and present data in your applications and reports.  Topics appropriate to this section include, but are not limited to:

  • Customized reports, graphics, and maps
  • Business intelligence dashboards/balanced scorecards
  • SAS to Excel and other Microsoft products
  • Customization of ODS output including ODS statistical graphics output
  • SAS Visual Data Discovery tools for visual analytics, visual querying and data filtering
  • SAS integration with Google Earth and GPS data
All papers MUST include a display of the system or results and should include some programming code and indicate SAS version required.

Title Author(s)
Business intelligence 2.0: Are we there yet? Greg Nelson
Using Linux Shell Commands, vi Editor, and Base SAS® to Parse through Log Files and Gather Log-information Fuad J. Foty
Distance mapping in health and health care: SAS® as a tool for health geomatics Barbara B. Okerson
SAS® Proc Report and ODS ExcelXP Tagsets to Produce Customized Excel Output Without DDE Mira Shapiro
ODS RTF TEXT My New Best Friend! Brian Spruell
SBSBOXPLOT: A SAS® Macro for Generating Side-by-Side Boxplots Jason A. Schoeneberger, Grant B. Morgan, Bethany A. Bell
Yes! SAS® ExcelXP WILL NOT Create a Microsoft Excel® Graph; But SAS® Users Can Command Microsoft Excel® to Automatically Create Graphs From SAS® ExcelXP William E. Benjamin Jr
Geocoding Crashes in Limbo Carol Martell, Daniel Levitt
Producing Maps Using SAS® Enterprise Guide® Harmon L. Jolley
Model Visualization Using JMP®, SAS®, and Excel Jon Weisz
The Systems Development Life Cycle (SDLC) as a Standard: Beyond the Documentation Dianne Louise Rhodes
Introduction to Graphics Using SAS/GRAPH® Software Mike Kalt


   Statistics and Data Analysis

Venita DePuy Bowden & Kim LeBouton

Here is your chance to share some interesting analyses, unusual statistical methodology, or new twists on old favorites!  Section attendees have a range of statistical backgrounds and are from various industries, so basic to complex applications used in the academic or business world are welcome.  Applications using SAS/Stat, SAS/ETS, SAS/OR, JMP, or SAS Enterprise Miner that facilitate the analysis of categorical, longitudinal, censored data or large genetic data arrays are a great fit for this section.

Title Author(s)
A Taste of ADaM Beilei Xu, Changhong Shi
Detecting Medicaid Data Anomalies Using Data Mining Techniques Aran J. Canes, Qiling Shi, Shenjun Zhu
SAS® Macros for Estimating the Attributable Benefit of an Optimal Treatment Regime Jason S. Brinkley
Potential Change in Reliability Measures Based on Decreased Sample Size for the Census Coverage Measurement Survey Vincent T. Mule
A SAS® Macro to Compute Added Predictive Ability of New Markers Predicting a Dichotomous Outcome Kevin Kennedy, Michael Pencina
Using SAS® Text Miner 4.1 to create a term list for patients with PTSD within the VA Matthew R. Richardson, Stephen L. Luther, Donald Berndt
A Macro for Calculating Summary Statistics on Left Censored Environmental Data using the Kaplan-Meier Method Dennis J. Beal
Using SAS® PROC CLUSTER to Determine University Benchmarking Peers Elayne Reiss, Sandra Archer, Robert L. Armacost, Ying Sun, Yun Fu
Developing a Model for Person Estimation in Puerto Rico for the 2010 Census Coverage Measurement Program Colt S. Viehdorfer
Stationarity Testing in High Frequency Seasonal Time Series David A. Dickey
The Graph Template Language and the Statistical Graphics Procedures - An Example-Driven Introduction Warren Kuhfeld
Take a Whirlwind Tour Around SAS® 9.2 Diane Hatcher
The Next Generation: SAS/STAT® 9.22 Phil Gibbs


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