SESUG Proceedings 2012
These Proceedings are the official record of the 20th Annual SouthEast SAS Users Group (SESUG) Conference held in Durham, NC on October 14–16, 2012 at the Sheraton Imperial Hotel and Convention 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 2012: The Proceedings of the SouthEast SAS Users Group, Durham, NC, 2012
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 © 2012 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
Lost in Space? Methodology for a Guided Drill-Through Analysis Out of the Wormhole, Stephen Overton
SAS Stored Processes: The Swiss Army Knife of the SAS BI Toolset, Patricia Aanderud
Leveraging SQL Return Codes When Querying Relational Databases, John Bentley
A SAS Programming Framework for Data Extraction Using Perl Regular Expression: The First Wave, Jiangtang Hu
Using Dictionary Tables to Profile SAS Datasets, Phillip Julian
Through the DoW-Loop, One Statement at a Time, Paul Dorfman
Make Macros Safe for Others to Use: Eliminate Unexpected Side Effects, David Abbott
ODS Output Datasets that Work for You, Stuart Long
Proc Summary Options Beyond The Basics, Susmita Pattnaik
Inventory Your Files Using SAS, Brian Varney
“There’s an App for That”: It’s Called SAS® ODS! Mobile Data Entry and Reporting via SAS ODS, Michael Drutar
The Elephant in the Room: Running Hadoop on SAS & Greenplum, Christopher Stephens
Coder’s Tips and Tricks
SAS® Macros and the SAS® DATASETS Procedure – An Automated Approach to Dataset Management and Manipulation, Christopher Alexander
An email macro: Exploring metadata in EG and user credentials in Linux to automate email notifications, Jason Baucom
PRXCHANGE: Accept No Substitutions, Ken Borowiak
Labels: What They Are and How To Use Them, David Chapman
A Closer Look at PROC SQL’s FEEDBACK Option, Ken Borowiak
A three-piece suite to address the worth and girth of expanding a data set, Phil d’Almada
Fitting Bayesian hierarchical multinomial logit models in PROC MCMC, Jacob Fisher
Fatal Witlessness: Appending Datasets! WARNING! This may cause truncation of data!, Arunim Gupta
An Introduction to Criteria-based Deduplication of Records, Elizabeth Heath
Hidden Biases Using SAS Dates, Steve James
Programmatic Automation of Categorizing and Listing Specific Clinical Terms, Ravi Kankipati
A PROC MEANS Primer, David Kerman
A Winning Combination: Generation of Listing and Descriptive Statistics Table in One Report, Chenille Lloyd
Manage Hierarchical or Associated Data With The RETAIN Statement, Alan Mann
What’s in a FILENAME?, Heidi Markovitz
Let’s Play a Game: A SAS Program for Creating a Word Search Matrix, Robert Matthews
Minimum Level of Documentation for Ad Hoc Report Programming, Robert McCurdy
Learning PROC SQL the DATA Step Way, Meghal Parikh
An In-Line View to a SQL, Darry Putnam
Schedule Impossible: Using ODS and PROC REPORT to Create a Schedule Visualization, Jeffrey Reiss
Introducing the FINDIT Macro: An Efficient Tool for Simultaneously Searching Several Free-Text Fields Using Multiple Keywords, LaTonia Richardson
A Handy New SAS® Tool for Comparing Dynamic Datasets, LaTonia Richardson
Securing Your SAS Systems – A Simple Step to Identify Users, Leanne Tang
Display, Group or Order: Using Proc Report to Create Clinical Trials Outputs, Sally Walczak
Encoding the Password – A low maintenance way to secure your data access, Leanne Tang
We Can Import It For You Wholesale: How to Use SAS Macros to Import Hundreds of Excel Files, Matthew Gyory
Beyond “If then” – Three Techniques for Cleaning Character Variables from Write-in Questions, Yusheng Zhai
Discover JMP
Run JMP as a virtual application – Changing How the Game Is Played, Hui Di
SPC Data Visualization of Seasonal and Financial Data Using JMP®, Annie Dudley Zangi
Getting to the Good Part of Data Analysis: Data Access, Manipulation, and Customization Using JMP®, Audrey Ventura
Hands-on Workshops
Getting Up to Speed with PROC REPORT, Kimberly LeBouton
Quick Results with ODS Graphics Designer, Sanjay Matange
The Armchair Quarterback: Writing SAS® Code for the Perfect Pivot (Table, That Is), Peter Eberhardt
FREQ Out – Exploring Your Data the Old School Way, Stephanie Thompson
How to Perform and Interpret Chi-Square and T-Tests, Jennifer Waller
Queries, Joins, and WHERE Clauses. Oh My!! Demystifying PROC SQL, Christianna Williams
Launching Off: Intro Tutorials
Using SAS® Enterprise Guide® to Coax Your Excel Data In To SAS®, Mira Shapiro
Reducing Big Data to Manageable Proportions, Sigurd Hermansen
Quick Hits – My favorite SAS tricks, Marje Fecht
Building the Better Macro: Best Practices for the Design of Reliable, Effective Tools, Frank DiIorio
Why Did SAS® Say That? What Common DATA Step and Macro Messages Are Trying to Tell You, Kevin Russell
Review That You Can Do: A Guide for Systematic Review of Complex Data, Lesa Caves
HELP, My SAS® Program isn’t Working: Where to Turn When You Need Help, Kimberly LeBouton
Pharma and Healthcare
The SDTM Programming Toolkit, David Scocca
Knowing When To Start, Where You Are, and How Far You Need To Go: Customized Software Tracks Project Workflow, Deliverables, and Communication, Eric Vandervort
A CareerView Mirror: Another Perspective on Your Work and Career Planning, Bill Donovan
An Introduction to the Clinical Standards Toolkit, Mike Molter
A SAS Macro Approach to Assign CTCAE Grades to Laboratory Adverse Experiences, Mei Dey
Developing a Complete Picture of Patient Safety in Clinical Trials, Richard Zink
A Standard SAS Program for Corroborating OpenCDISC Error Messages, John R. Gerlach
Generating SUPPQUAL Domains from SDTM-Plus Domains, John R. Gerlach
Planning and Administration
Serving SAS®: A Visual Guide to SAS Servers, Gregory Nelson
SAS Enterprise Business Intelligence (EBI) Deployment Projects in the Federal Sector: Best Practices, Jennifer Parks
Getting to Know an Undocumented SAS Environment, Brian Varney
Best Practices for Managing and Monitoring SAS® Data Management Solutions, Gregory Nelson
Gotcha – Hidden Workplace and Career Traps to Avoid, Steve Noga
Posters
Running SAS on the Grid, Margaret Crevar
A Visual Approach to Monitoring Case Report Form Submission During Clinical Trials, Rebecca Horney
A Corporate SAS® Community of Support, Barbara Okerson
Do You Have Too Much Class?, Janet Willis
Using Macro to simplify to Calculate Multi-Rater Observation Agreement, Abbas Tavakoli
Mastering the Basics: Preventing Problems by Understanding How SAS® Works, Imelda Go
A SAS Users Guide to Regular Expressions When the Data Resides in Oracle, Kunal Agnihotri
Using Windows Batch Files to Sequentially Execute Sets of SAS Programs Efficiently, Matthew Psioda
SAS Programming tips and techniques for Data Mapping, Sheetal Nisal
PROC TTEST® (Old Friend), What Are You Trying to Tell Us?, Jeffrey Kromrey
SAS macro to obtain reference values based on estimation of the lower and upper percentiles via quantile regression, Neeta Shenvi
A Randomization Test SAS Program for Making Treatment Effects Inferences for Extensions and Variations of ABAB Single-Case Experimental Designs, Patricia Rodriguez de Gil
Spatial Analysis of Gastric Cancer in Costa Rica using SAS, So Young Park
Extend the Power of SAS® to Use Callable VBS and VBA Code Files Stored in External Libraries to Control Excel Formatting Routines, William E. Benjamin Jr.
Array, Hurray, Array; Consolidate or Expand Your Input Data Stream Using Arrays, William E. Benjamin Jr.
Evaluating effectiveness of management interventions in a hospital using SAS® Text Miner, Anil Kumar Pantangi
MIXED_FIT: A SAS Macro to Assess Model Fit and Adequacy for Two-Level Linear Models, Mihaela Ene
Using Dictionary Tables to Profile SAS Datasets, Phillip Julian
Reporting and Information Visualization
Get Your “Fast Pass” to Building Business Intelligence with SAS® and Google Analytics, Patricia Aanderud
Converting from SAS/GRAPH(R) to ODS Graphics, Jim Horne
Pulling Data from Ellucian-Banner ODS with SAS-EG: Not only fast but fun as well!, Claudia McCann
Don’t Avoid It, Exploit It: Using Annotate to Enhance Graphical Output, Sarah Mikol
Enhance your SAS/Intrnet application with jQuery and Google Earth, David Mintz
Do SAS® users read books? Using SAS graphics to enhance survey research, Barbara Okerson
Mobile Business Applications: Delivering SAS Dashboards To Mobile Devices via MMS, Ben Robbins
Data merging and Exploration to identify association of Epidemiological outbreaks with Environmental factors, Neeta Shenvi
Using Design Principles to Make ODS Template Decisions, Helen Smith
Diverse Report Generation With PROC REPORT, Chris Speck
Creating a Heatmap Visualization of 150 Million GPS Points on Roadway Maps via SAS, Shih-Ching Wu
Using SAS/GRAPH® to Create Visualizations That Also Support Tactile and Auditory Interaction, Ed Summers
Using Axes Options to Stretch the Limits of SAS® Graph Template Language, Perry Watts
Together at Last: Spatial Analysis and SAS® Mapping, Darrell Massengill
Statistics and Data Analysis
Compare MIXED and GLMMIX to Analyze Breast Cancer Longitudinal Study, Abbas Tavakoli
Random Effects Simulation for Sample Size Calculations Using SAS, Matthew Psioda
The Effects of Q-Matrix Mis-Specification when Employing Proc NLMIXED: A Simulation Study, George MacDonald
Decision-Making using the Analytic Hierarchy Process (AHP) and SAS/IML®, Melvin Alexander
SAS Procedures for Analyzing Survey Data, Pushpal Mukhopadhyay
A SAS macro to compute effect size (Cohen’s d) and its confidence interval from raw survey data, Rajendra Kadel
Sample Size Determination for a Nonparametric Upper Tolerance Limit for any Order Statistic, Dennis Beal
Difference Estimation versus Mean per Unit Methods for Skewed Populations: A Simulation Study, John Chantis
K-Nearest Neighbor Classification and Regression using SAS, Liang Xie
Where Should I Dig? What to do Before Mining Your Data, Stephanie Thompson
The Keouk County CAFO Study: A Complementary Analysis Using Classification Trees in SAS® Enterprise Miner™, Leonard Gordon
Multiple Imputation for Ordinal Variables: A Comparison of SUDAAN’s PROC HOTDECK vs. PROC MI, Kimberly Ault
Tips, Tricks, and Strategies for Mixed Modeling with SAS/STAT® Procedures, Kathleen Kiernan
Transporter Room
Linking Medical Records to Medics in Cyberspace, Sigurd Hermansen
SAS Server Pages, ‹?sas and ‹?sas=, Richard DeVenezia
The ADDR-PEEK-POKE Capsule: Transporting Data Within Memory and Between Memory and the PDV, Paul Dorfman