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

Automating SAS/Graph Axis Ranges: Using a macro to produce easily read major tick mark increments based on the data to be graphed, Rick Edwards

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

A GUI-based utility macro for creating a version controlled project directory structure and copying in standard tools and template files, Hisham Madi

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


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

Integration of Scientific Writing into an Applied Biostatistics and SAS Programming Course for Pharmaceutical Sciences Graduate Students, Daniel Hertz

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

Let the Data Paint the Picture: Data-Driven, Interactive and Animated Visualizations Using SAS®, Java and the Processing Graphics Library, Patrick Hall

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