SESUG Proceedings 2010
These Proceedings are the official record of the 18th annual SouthEast SAS Users Group (SESUG) Conference held in Savannah, GA on September 26 – 28, 2010 at the Hyatt Regency Savannah. Neither SAS Institute Inc. nor SESUG is responsible for the accuracy or originality of this material.
The correct bibliographic citation for this publication is as follows:
SESUG 2010: The Proceedings of the SouthEast SAS Users Group, Savannah, GA, 2010
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. ® indicates USA registration. Other brand and product names are trademarks of their respective companies.
Copyright © 2010 by the SouthEast SAS Users Group.
Published in the USA
Papers are made available by the Institute for Advanced Analytics as a courtesy to the SESUG community. The Institute is not responsible for the accuracy or originality of this material.
%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
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
SAS® TIPS FOR INSTITUTIONAL RESEARCHERS TO TRACK STUDENT OUTCOMES EFFICIENTLY, Vijayalakshmi Sampath
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
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
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
If you Have Programming Standards, Please Raise Your Hand: An Everyman’s Guide, Dianne Louise Rhodes
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
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
TIPS AND TRICKS OF EFFICIENT SAS® PROGRAMMING FOR SDTM DATA, Eric Qi, Fikret Karahoda
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
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
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