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

Loading Metadata to the IRS Research Compliance Data Warehouse (CDW) Website: From Excel Spreadsheet to SQL Server Relational Database Using SAS Macro and PROC SQL, Robin Rappaport

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

An Exact Implicit Enumeration Algorithm for Variable Selection in Multiple Linear Regression Models Using Information Criteria, Dennis Beal

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=”http://analytics.ncsu.edu/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