SESUG Proceedings 2011
These Proceedings are the official record of the 19th Annual Southeast SAS Users Group (SESUG) Conference held in Alexandria, VA on October 23–25, 2011 at the Hilton Alexandria Mark Center. 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 2011: The Proceedings of the Southeast SAS Users Group, Alexandria, VA, 2011
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 © 2011 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.
Beyond the Basics
Analyst Beware: Five Dangerous Data Step Coding Traps, David Abbott
SAS Macro Dynamics: from Simple Basics to Powerful Invocations, Rick Andrews
PIPE Dreams: Yet Another Tool for Dynamic Programming, Scott Burroughs
Using Recursion for More Convenient Macros, Nate Derby
From Obscurity to Utility: ADDR, PEEK, and POKE as DATA Step Programming Tools, Paul Dorfman
Creating Stored Processes with Dynamic, Cascading Prompts, Harry Droogendyk
Condensed and Sparse Indexes for Sorted SAS Datasets, Mark Keintz
An Introduction to SAS Hash Programming Techniques, Kirk Paul Lafler
SAS Programming Tips and Techniques, Kirk Paul Lafler
The SAS Magical Dictionary Tour, Linda Libeg
ExcelXP on Steroids: Adding Custom Options to the ExcelXP Tagset, Michael Molter
Build Excel-Like Pivot Table Using PROC SQL and PROC TRANSPOSE, Mai Nguyen, Shane Trahan, Inga Allred and Nick Kinsey
Using SAS Variable Lists Effectively, Howard Schreier
Becoming a Better Programmer with SAS Enterprise Guide 4.3, Kate Schwarz
Paperless Report Generation and Distribution, George Sharrard
Combining External PDF Files by Integrating SAS and Adobe® Acrobat, Brandon Welch and Ryan Burns
PROC COMPARE — Worth Another Look!, Christianna Williams
Coders’ Corner
The Last Line, Brandon Barrett and Binoy Varghese
Show Me The Folder, Brandon Barrett and Binoy Varghese
The Little Engine That Could: Using LIBNAME Engine Options to Enhance Data Transfers Between SAS and Microsoft Excel Files, William Benjamin Jr
Three Easy Ways around Nonexistent or Empty Datasets, Spencer Childress and Brandon Welch
Use Your Cores! An Introduction to Multi-core Processing with SAS, Erik Dilts
Arrays – Data Step Efficiency, Harry Droogendyk
SAS Formats: Effective and Efficient, Harry Droogendyk
Macros for Two-Sample Hypothesis Tests, Jinson Erinjeri
Counting the Ways to Count in SAS, Imelda Go
Be Bold with Proc Compare and %RTFTable, Patricia Guldin
Can you decipher the code? If you can, maybe you can break it, Jay Iyengar
SAS Programming Guidelines, Lois Levin
Proc Format, a Speedy Alternative to Sort/Merge, Claudine Lougee and Jenine Milum
Identifying, Tracking, and Analyzing Patterns in Finite Concurrent and Sequential Events using SAS, Vijayalakshmi Sampath
RDPLOT: A SAS Macro for Generating Regression Discontinuity Plots, Jason Schoeneberger
Smoothing Scaled Score Distributions from a Standardized Test using PROC GENMOD, Jonathan Steinberg and Tim Moses
Intelligent Proc Sort Nodupkey, Andrea Wainwright-Zimmerman
How variable-dependent macros can help you, Mindy Wang
Using SAS to Report Data in XML Format, Qin Wang
Windows PowerShell Commands and Scripts for SAS Programmers, Adeline Wilcox
Locally Visible, Remote Data and Format!, Hsiwei Yu and brian deitch
Our Adverse Event Review Reports Generated All in ODS Report Writing Interface, Sijian Zhang
Creating a Stored Macro Facility in 10 Minutes, Erik Larsen
strong>Hands-On Workshops
Creating Stylish Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS, Vince DelGobbo
Two Guys On Hash, Paul Dorfman
SAS Enterprise Guide 4.3: Finally a Programmer’s Tool, Marje Fecht and Rupinder Dhillon
Ready to Become Really Productive Using PROC SQL?, Sunil Gupta
Output Delivery System (ODS) – Simply the Basics, Kirk Paul Lafler
Easier than You Think: Creating Maps with SAS Enterprise Guide, Stephanie Thompson
JMP
JMP Analytics Applied in Diagnostic Radiology and Neurosurgery Trauma Research, Melvin Alexander
Evaluating Consumer Price Behavior Using JMP, Josh Klick
JMPing in: A SAS Programmer’s look at JMP, Barbara Okerson
Create compelling visualizations with geographic data and JMP 9, Jeff Perkinson
Making Your SAS Data JMP Through Hoops, Mira Shapiro
Posters
Practical Approaches to Counting in SAS: How to Get Started When You Don’t Know Where to Begin, Sharon Avrunin-Becker
MV_META: A SAS Macro for Multivariate Meta-Analysis, Julie Gloudemans, Corina Owens and Jeffery Kromrey
Using SAS to Streamline Periodic Reporting of Summary Statistics: Proc Format, Proc Freq, Proc Means,and Output Delivery System, Berwyn Gonzalvo
SoScatter Plots Using PROC SGPLOT for that Thursday Presentation, Sharon Hirabayashi
A Coding Practice for Preparing Adaptive Multistage Testing, Yung-chen Hsu
Using Dictionary Tables to Profile SAS Datasets, Phillip Julian
Using SAS to Ease the Proofing of Messy Text, Richard La Valley and Nat Wooding
A Macro to Change Windows Filenames, Daniel Levitt
Permutated-block randomization with varying block sizes using SAS Proc Plan, Lei Li
Business Intelligence and Analytics: Complements within a Decision Support Culture, Alan Mann, Emile Barnes and Albert Briggs
Proc CDISC: Implementation and Assessments, Sheetal Nisal and Shilpa Edupganti
Breastfeeding in Developing Countries: A Case Study of Nepalese Children/a>, Paerwen Paerhate
CI_MEDIATE: A SAS Macro for Computing Point and Interval Estimates of Effect Sizes Associated with Mediation Analysis, Thanh Pham, Eun Kyeng Baek, Merlande Petit-Bois and Jeffrey Kro
Coping with Job Loss, Dianne Rhodes
MISSING_ITEMS: A SAS Macro for Missing Data Imputation in Summative Response Scales, Patricia Rodriguez de Gil and Jeffrey Kromrey
Using SAS to Examine Aging Expectation (ERA-38) for Older Adults , Abbas Tavakoli and Julie Freelove-Charton
Using SAS GTL to Visualize Your Data when there is Too Much of it to Visualize, Perry Watts and Nate Derby
Time Series Regression: Using Proc GPLOT and Proc REG Together to Make One Great Graph, William Zupko
Does SAS Distance Measurement Differ from ArcGIS Distance Measurement?, Imam Xierali
Reporting and Information Visualization
Printable Spreadsheets Made Easy: Utilizing the SAS Excel XP Tagset, Rick Andrews
Graphing a Progression of Time Series Plots, Nate Derby, Laura Vo and Perry Watts
Introduction to ODS Graphics for the Non-Statistician, Mike Kalt
A PICTURE is Worth Alot of PUTS, Carol Martell
Quick and Dirty Formatted Excel Workbooks Without DDE or ODS, Andrea Wainwright-Zimmerman
Using SAS GTL to Visualize Your Data when there is Too Much of it to Visualize, Perry Watts and Nate Derby
SAS Code to Export and Create Pivot Tables in Excel 2007, Robert Williams
Statistics and Data Analysis
Eyes on the Road: A Methodology for Analyzing Complex Eye-Tracking Data, Mary Anne Bertola and Stacy Balk
Proc MIXED – Right Options to get Right Output, Shilpa Edupganti and Sheetal Nisal
Time Series Analysis: Separating Overlapping Events, M. Scott Elliott
Scatterplots: Basics, enhancements, problems and solutions, Peter Flom
Tailoring Logistic Regression Model Analyses with the ODDSRATIO Statement in PROC LOGISTIC, Taylor Lewis
Linear Logistic Test Model: Using SAS to Simulate the Decomposition of Item Difficulty by Algorithm, Sample Size, Cognitive Component and Time to Convergence, George MacDonald and Jeffrey Kromrey
Analysis of a Complex Survey Data, Varma Nadimpalli
PROC SURVEY Says!: Selecting and Analyzing Stratified Samples, Darryl Putnam
On Deck: SAS/STAT® 9.3, Robert Rodriguez
Acknowledging the Unknown: A SAS Macro for Investigating Omitted Variable Bias in Two-Level Linear Models, Jason Schoeneberger, Bethany Bell and Jeffrey Kromrey
Find Potential Fraud Leads Using Data Mining Techniques, Qiling Shi
Data Simulation for Evaluating Statistical Methods in SAS®, Rick Wicklin
Step by Step
Wandering Cross Reference Lines in PROC GPLOT, Sharon Avrunin-Becker
In Lockstep with the DoW-Loop, Paul Dorfman
Let’s Give’em Something to TOC About: Transforming the Table of Contents of Your PDF File, Bari Lawhorn
Introduction to SAS Macro Language, John Myers
Misquoting Jane Austen in the Name of Quality, Deborah Posner
Fuzzy matching – Is there a silver bullet?, Milorad Stojanovic
TWhy the Bell Tolls 108 times? Stepping Through Time with SAS, Peter Eberhardt and Yunbo (Jenny) Sun
A Step by Step Approach to Preparing for a SAS Intelligence Platform Environment Deployment/Migration, Brian Varney
href=”../sesug/2011/SS15.Woodruff.pdf”>Keeping Up Appearances: Turning Specifications into SAS Format Libraries and Statements, Sarah Woodruff
Government and Health Care Apps
Healthcare Provider Cost Reporting Information System, Kim Andrews
Creating Correlated Variable Tables Dynamically, John Barrow and Aref Dajani
Macro Design and Usage in a Multi-Tier Architecture for ETL and Google Visualization API Integration, Manuel Figallo-Monge
Let SAS Do the Downloading: Using Macros to Generate FTP Script Files, Arthur Furnia
Fighting Fraud in a Pre-Payment Environment, Greg Henderson
ODS PDF and RTF application development , Benno Kurch and Shirish Nalavade
Development of a SAS Macro for Automated Data Cleaning of Major Outcomes of Interest in Hematopoietic Cell Transplantation, Peigang Li, Min Chen and Zhiwei Wang
Analysis of a Binary Outcome Variable Using the FREQ and LOGISTIC Procedures, Arthur Li
My annual reporting is requiring a full staff – Help!, Erin Lynch
A General-Purpose SAS Report Portal for the Web, Craig Ray
Assign Overpayment to Insurance Data with Adjustments, Qiling Shi
Automatization of Patient Characteristics Report/a>, Mirjana Stojanovic
Categorizing the Degradation State of Aircraft Generators using Rank Order Statistics and SAS CLUSTER Procedure, Tsung-hsun Tsai
Tips for Merging SAS/GRAPH® Output into Microsoft PowerPoint, Ferrell Drewry
Using SAS® to Create Custom Healthcare Graphics, Barbara Okerson