SESUG Proceedings 2014

These Proceedings are the official record of the 22nd Annual SouthEast SAS Users Group (SESUG) Conference held in Myrtle Beach, SC on October 19–21, 2014 at the Embassy Suites Myrtle Beach-Oceanfront Resort. 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 2014: The Proceedings of the SouthEast SAS Users Group, Myrtle Beach, SC, 2014

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 © 2014 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.

Application Development

Using SAS® software to shrink the Data used in Apache Flex® Application, Ahmed Al-Attar

%Destroy() a Macro With Permutations, Brandon Welch and James Vaughan

This is the Modern World: Simple, Overlooked SAS® Enhancements, Bruce Gilsen

DFAST & CCAR: One size does not fit all, Charyn Faenza

PROC RANK, PROC SUMMARY and PROC FORMAT Team Up and a Legend is Born!, Christianna Williams

Useful Tips for Building Your Own SAS® Cloud, Danny Hamrick

More Hash: Some Unusual Uses of the SAS Hash Object, Haikuo Bian, Carlos Jimenez and David Maddox

Your Database can do SAS too!, Harry Droogendyk

Moving Data and Results Between SAS® and Microsoft Excel, Harry Droogendyk

Before and After: Implementing a Robust Outlier Identification Routine using SAS®, Jack Shoemaker

SAS® Debugging 101, Kirk Paul Lafler

Top Ten SAS® Performance Tuning Techniques, Kirk Paul Lafler

The Power of SAS® Macro Programming – One Example, Milorad Stojanovic

The New Tradition: SAS® Clinical Data Integration, Vincent Amoruccio

Building Blocks

Hidden in plain sight: my top ten underpublicized enhancements in SAS ® Versions 9.2 and 9.3, Bruce Gilsen

SAS®, Excel®, and JMP® Connectivity — HOW, Charlie Shipp and Kirk Paul Lafler

PROC SQL for PROC SUMMARY Stalwarts, Christianna Williams

FORMATs Top Ten, Christianna Williams

A Non-Standard Report Card – Informing Parents About What Their Children Know, Daniel Ralyea

A Quick View of SAS Views, Elizabeth Axelrod

Combining Multiple Date-Ranged Historical Data Sets with Dissimilar Date Ranges into a Single Change History Data Set, Jim Moon

PROC TRANSPOSE® For Fun And Profit, John Cohen

The Nuances of Combining Hospital Data, Jontae Sanders, Charlotte Baker and Perry Brown

Move over MERGE, SQL and SORT. There is a faster game in town! #Hash Table, Karen Price

Point-and-Click Programming Using SAS® Enterprise Guide®, Kirk Paul Lafler and Mira Shapiro

Formatting Data with Metadata – Easy and Powerful, Leanne Tang

SAS® Macro Magic is not Cheesy Magic! Let the SAS Macros Do the Magic of Rewriting Your SAS Code, Robert Williams

Flat Pack Data: Converting and ZIPping SAS® Data for Delivery, Sarah Woodruff

The Power of PROC APPEND, Ted Logothetti

Coder’s Corner

Creating a Hyperbolic Graph Using the SAS® Annotate Facility, Bill Bland and Liza Thompson

Debugging SAS ® Code in a Macro, Bruce Gilsen

Using PROC FCOMP to Do Fuzzy Name and Address Matching, Christy Warner

Manage Variable Lists for Improved Readability and Modifiability, David Abbott

Integrating Data and Variables between SAS® and R via PROC IML: Enable Powerful Functionalities for Coding in SAS®, Feng Liu

How to Build a Data Dictionary – In One Easy Lesson, Gary Schlegelmilch

Hands Free: Automating Variable Name Re-Naming Prior to Export, John Cohen

Simple Rules to Remember When Working with Indexes, Kirk Paul Lafler

Interacting with SAS using Windows PowerShell ISE, Mayank Nautiyal

Let SAS® Do the Coding for You, Robert Williams

@/@@ This Text file. Importing Non-Standard Text Files using @,@@ and / Operators, Russell Woods

VBScript Driven Automation in SAS®: A Macro to Update the Text in a Microsoft® Word Document Template at Preset Bookmarks, Shayala Gibbs

Searching for (and Finding) a Needle in a Haystack: A Base Macro-Based SAS Search Tool to Facilitate Text Mining and Content Analysis through the Production of Color-Coded HTML Reports , Troy Hughes

Bulletproof Macros: Avoiding Macro Name Collisions, David H. Abbott

Hands On Workshop

SAS Enterprise Guide for Institutional Research and Other Data Scientists, Claudia McCann

A Tutorial on the SAS® Macro Language, John Cohen

Store and Recall Macros with SAS Macro Libraries, John Myers

Application Development Techniques Using PROC SQL, Kirk Paul Lafler

The DoW-Loop, Paul Dorfman and Lessia Shajenko

Reliably Robust: Best Practices for Automating Quality Assurance and Quality Control Methods into Software Design, Troy Hughes

Pharma and Healthcare

Time Series Mapping with SAS®: Visualizing Geographic Change over Time in the Health Insurance Industry, Barbara Okerson

You’ve used FREQ, but have you used SURVEYFREQ?, Charlotte Baker

A Comprehensive Automated Data Management System for Clinical Trials, Heather Eng, Jason Lyons and Theresa Sax

Using SAS® to Analyze the Impact of the Affordable Care Act, John Cohen and Meenal (Mona) Sinha

Using SAS/STAT to implement a multivariate adaptive outlier detection approach to distinguish outliers from extreme values, Paulo Macedo

Impact of Affordable Care Act on Pharmaceutical and Biotech Industry, Salil Parab

Evaluating and Mapping Stroke Hospitalization Costs in Florida, Shamarial Roberson and Charlotte Baker

SDTM What? ADaM Who? A Programmer’s Introduction to CDISC, Venita DePuy

Planning, Support, and Administration

Configurable SAS® Framework for managing SAS® OLAP Cube based Reporting System, Ahmed Al-Attar and Shadana Myers

Case Studies in Preparing Hadoop Big Data for Analytics, Doug Liming

SAS Metadata Querying and Reporting Made Easy: Using SAS Autocall Macros, Jiangtang Hu

A Review of “Free” Massive Open Online Content (MOOC) for SAS Learners, Kirk Paul Lafler

Google® Search Tips and Techniques for SAS® and JMP® Users, Kirk Paul Lafler and Charlie Shipp

Stretching Data Training Methods: A Case Study in Expanding SDTM Skills, Richard Addy

Managing and Measuring the Value of Big Data and Analytics Focused Projects, Rob Phelps

Calculating the Most Expensive Printing Jobs, Roger Goodwin, PMP

Securing SAS OLAP Cubes with Authorization Permissions and Member-Level Security, Stephen Overton

Debugging and Tuning SAS Stored Processes, Tricia Aanderud

Teaching SAS Using SAS OnDemand Web Editor and Enterprise Guide, Charlotte Baker and Perry Brown


Overview of Analysis of Covariance (ANCOVA) Using GLM in SAS, Abbas Tavakoli

Trash to Treasures: Salvaging Variables of Extremely Low Coverage for Modeling, Alec Zhixiao Lin

Design of Experiments (DOE) Using JMP®, Charlie Shipp

Analysis of Zero Inflated Longitudinal Data Using PROC NLMIXED, Delia Voronca and Mulugeta Gebregziabher

Using Regression Model to Predict Earthquake Magnitude and Ground Acceleration at South Carolina Coastal Plain (SCCP), Emad Gheibi, Sarah Gassman and Abbas Tavakoli

PROC MEANS for Disaggregating Statistics in SAS: One Input Data Set and One Output Data Set with Everything You Need, Imelda Go and Abbas Tavakoli

Exploring the Use of Negative Binomial Regression Modeling for Pediatric Peripheral Intravenous Catheterization, Jennifer Mann, Jason Brinkley and Pamela Larsen

To Foam or not to Foam: A Survival Analysis of the Foam Head that Forms when a Soda is Poured, Kate Phillips

Connect with SAS® Professionals Around the World with LinkedIn and, Kirk Paul Lafler and Charles Edwin Shipp

Evaluating Additivity of Health Effects of Exposure to Multiple Air Pollutants Given Only Summary Data, Laura Williams, Elizabeth Oesterling Owens and Jean-Jacques Dubois

Build your Metadata with PROC CONTENTS and ODS OUTPUT, Louise Hadden

A National Study of Health Services Utilization and Cost of Care with SAS: Analyses from the 2011 Medical Expenditure Panel Survey, Seungyoung Hwang

Reporting and Information Visualization/JMP

Design of Experiments (DOE) Using JMP®, Charlie Shipp

Secrets from a SAS(E9) Technical Support Guy: Combining the Power of the Output Deliver System with Microsoft Excel Worksheets, Chevell Parker

Tricks and Tips for Using the Bootstrap in JMP Pro 11, Jason Brinkley and Jennifer Mann

Build your Metadata with PROC CONTENTS and ODS OUTPUT, Louise Hadden

Where in the World Are SAS/GRAPH® Maps? An Exploration of the Old and New SAS® Mapping Capacities, Louise Hadden

Integrating SAS with JMP to Build an Interactive Application, Merve Gurlu

Penalizing your Models: An Overview of the Generalized Regression platform, Michael Crotty and Clay Barker

Web Scraping with JMP for Fun and Profit, Michael Hecht

Enhancements to Basic Patient Profiles, Scott Burroughs

Creating Health Maps Using SAS, Shamarial Roberson and Charlotte Baker

A Strip Plot Gets Jittered into a Beeswarm, Shane Rosanbalm

How To Make An Impressive Map of the United States with SAS/Graph® for Beginners, Sharon Avrunin-Becker

Dashboards with SAS Visual Analytics, Tricia Aanderud

Statistics and Data Analysis

Using SAS to Examine Mediator, Direct and Indirect Effects of Isolation and Fear on Social Support Using Baron& Kenny Combined with Bootstrapping Methods, Abbas Tavakoli and Sue Heiney

Don’t be binary! Tales of Non-binary Categorical Regression, Charlotte Baker

Maximizing Confidence and Coverage for a Nonparametric Upper Tolerance Limit on the Second Largest Order Statistic for a Fixed Number of Samples, Dennis Beal

Strimmed_t: A SAS® Macro for the Symmetric Trimmed t Test, Diep Nguyen, Anh Kellermann, Patricia Rodríguez de Gil, Eun Sook Kim and Jeffrey Kromrey

ANOVA_HOV: A SAS® Macro for Testing Homogeneity of Variance in One-Factor ANOVA Models, Diep Nguyen, Thanh Pham, Patricia Rodríguez de Gil, Tyler Hicks, Yan Wang, Isaac Li, Aarti Bellara, Jeanine Romano, Eun Sook Kim, Harold Holmes, Yi-Hsin Chen and Jeffrey Kromrey

Text Analytics using High Performance SAS Text Miner, Edward Jones

How does Q-matrix Misspecification Affect the Linear Logistic Test Model’s Parameter Estimates?, George MacDonald and Jeffrey Kromrey

Modeling Cognitive Processes of Learning with SAS® Procedures, Isaac Li, Yi-Hsin Chen, Chunhua Cao and Yan Wang

Power and Sample Size Computations, John Castellon

Gestational Diabetes Mellitus and changes in offspring’s weight during infancy: A longitudinal analysis, Marsha Samson, Olubunmi Orekoya, Dumbiri Onyeajam and Tushar Trivedi

Multilevel Models for Categorical Data using SAS® PROC GLIMMIX: The Basics, Mihaela Ene, Elizabeth Leighton, Genine Blue and Bethany Bell

Analyzing Multilevel Models with the GLIMMIX Procedure, Min Zhu

%DISCIT Macro: Pre-screening Continuous Variables for Subsequent Binary Logistic Fegression Analysis Through Visualization, Mohamed Anany

Using SAS to Create a p-value Resampling Distribution for a Statistical Test, Peter Wludyka and Carmen Smotherman

Making Comparisons Fair: How LS-Means Unify the Analysis of Linear Models, Weijie Cai

Annotation Utilizations in Customized SAS/Graph Bar Charts, Yong Liu, Hua Lu, Liang Wei, Xingyou Zhang, Paul Eke and James Holt