Search Results

Your search for paper sesug returned the following results.

Copyright Information

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

The Institute’s Dr. David Dickey and Andrea Villanes presented separate work at SESUG 2013 in St. Pete Beach, Florida. Dr. Dickey, a professor of statistics who teaches students in the Master of Science in Analytics (MSA) program, delivered an overview of data mining methods titled Finding the Gold in Your Data. Ms. Villanes, a research associate with the Institute, presented work based on her master’s thesis titled Analytical Approach for Bot Cheating Detection in a Massive Multiplayer Online Racing Game. All of the published papers from the SESUG annual meetings are made available online by the Institute as a courtesy to the SAS user community. The archive contains over 1700 papers presented since 1999.

Copyright Information

These Proceedings are the official record of the 21th Annual SouthEast SAS Users Group (SESUG) Conference held in St. Pete Beach, FL on October 20–23, 2012 at the TradeWinds Island Grand. 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 2013: The Proceedings of the SouthEast SAS Users Group, St. Pete Beach, FL, 2013

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

Back to Basics

Ten Things You Should Know About PROC FORMAT, Jack Shoemaker

Tailoring Proc Summary for More Efficient Summarizations, Bill Parman

Basketball Analytics: Optimizing the Official Basketball Box-Score (Play-by-Play), William Cade

A Few Usefull Tips When Working with SAS®, Milorad Stojanovic

Help! I Need to Report a Crime! Why is PROC REPORT So Hard to Use?, Dessa Overstreet

Repetitive Tasks and Dynamic Lists: Where to Find What You Need and How to Use It, Richard Addy

Chi-Square and T-Tests Using SAS®: Performance and Interpretation, Jennifer Waller and Maribeth Johnson

Transitioning from Batch and Interactive SAS to SAS Enterprise Guide, Brian Varney

A Quick and Gentle Introduction to PROC SQL, Shane Rosanbalm and Sam Gillett

Lost in Translation: A Statistician’s (Basic) Perspective of PROC LIFETEST, Alexandra Buck

Going from Zero to Report Ready with PROC TABULATE, Rachel Straney

Submitting SAS® Code on the Side, Vince DelGobbo

Data Entry in SAS® Strategy Management: A New, Better User (and Manager) Experience, David Shubert

Looking for an Event in a Haystack?, Maya Barton and Rita Slater

Beyond the Basics

5 Simple Steps to Improve the Performance of your Clinical Trials Table Programs using Base SAS® Software, Sally Walczak

Data Review Information: N-Levels or Cardinality Ratio, Ronald Fehd

Data in the Doughnut Hole: Using SAS® to Report on What is NOT There, Sarah Woodruff

EG and SAS: WORK-ing together, Bruce Albriton

Use SAS® to create equal sized geographical clusters of people, Josh Young

PEEKing at Roadway Segments, Carol Martell

Reading Data from Microsoft Word Documents: It’s Easier Than You Think, John Bentley

Your Opinion Counts: Using Twitter to Poll Conference Attendees, Peter Eberhardt and Matt Malczewski

Taming a Spreadsheet Importation Monster, Nat Wooding

Small Sample Equating: Best Practices using a SAS Macro, Anna Kurtz and Andrew Dwyer

Computing Counts for CONSORT Diagrams: Three Alternatives, David Abbott

Averaging Numerous Repeated Measures in SAS Using DO LOOPS and MACROS: A Demonstration Using Dietary Recall Data, Kendra Jones and Kyla Shelton

A Novel Approach to Code Generation for Data Validation and Editing using Excel and SAS, Mai Nguyen, Katherine mason and Shane Trahan

Same Data Different Attributes: Cloning Issues with Data Sets, Brian Varney

Finding the Gold in your Data – an Introduction to Data Mining, David Dickey

List Processing With SAS: A Comprehensive Survey, Jiangtang Hu

Black Belt

Solving Samurai Sudoku Puzzles – A First Attempt, John R Gerlach

Pre-conference seminar: Advanced Macro Design, Ronald Fehd

Big Data in the Warehouse – Quality is King and SAS Can Do It All, Ted Shelly

Binning Bombs When You’re Not a Bomb Maker: A Code-Free Methodology to Standardize, Categorize, and Denormalize Categorical Data, Troy Martin Hughes

Introducing the New ADAPTIVEREG Procedure for Adaptive Regression, Weijie Cai

Hands On Workshops

SAS® Enterprise Guide® 5.1: A Powerful Environment for Programmers, Too!, Rupinder Dhillon

Know Thy Data: Techniques for Data Exploration, Andrew Kuligowski and Charu Shankar

A Row is a Row is a Row, or is it? A Hands-on Guide to Transposing Data, Christianna Williams

How To DOW, Paul Dorfman

How to Use ARRAYs and DO Loops: Do I DO OVER or Do I DO i?, Jennifer Waller

Introduction to Interactive Drill Down Reports on the Web, Michael Sadof and Louis Semidey

The Armchair Quarterback: Writing SAS® Code for the Perfect Pivot (Table, That Is), Peter Eberhardt

Extend the Power of SAS® to Use Callable VBS and VBA Code Files Stored in External Libraries to Control Excel Formatting Routines, William Benjamin

Give the Power of SAS® to Excel Users Without Making Them Write SAS Code, William Benjamin

Planning and Administration

Survey of Big Data Solutions using SAS(r) Technologies, Jack Shoemaker

Rebuilding SAS Web Application for Web Report Studio 4.3, Ranjit Singh

The Many Hats of a SAS Administrator: An Insider’s Guide on Becoming an Indispensable Asset in Your Organization, Jennifer Parks

The Hitchhiker’s Guide to Github: SAS Programming Go Social, Jiangtang Hu

Your Analytics project is going to fail… Ask me why, Adam Hood and Martin Young

A Practical Approach to Process Improvement Using Parallel Processing, Viraj Kumbhakarna

Parallel processing techniques for performance improvement for SAS processes: Part II, Viraj Kumbhakarna

I heart SAS Users, Joanne Ellwood

The Disk Detective: A Tool Set for Windows SAS© Administrators, Darryl Putnam

A Hitchhiker’s guide for performance assessment & benchmarking SAS® applications, Viraj Kumbhakarna

Increasing College Tuition and Its Impacts on Student Loans, Harjanto Djunaidi and Monica Djunaidi

SAS Enterprise Business Intelligence Deployment Projects in the Federal Sector, Jenni Parks

Reporting and Information Visualization

Analytical modeling and content analysis mapping with SAS, Nancy Landreville

Not Enough Time To Catch Extreme Observations? Flag and Report with Macros and Arrays, Jamelle Simmons

Automating Visual Data Mining Using Bihistograms, the SAS Annotate Facility and SAS Macros, Forrestt Severtson

Seven Steps to a SAS EBI Proof-of-Concept Project, Sheryl Weise

Seamless Dynamic Web (and Smart Device!) Reporting with SAS®, DJ Penix

Instant Disaggregation: Using the macro language to provide reports with parallel structure across different subsets of the data set, Daniel Ralyea

Case Study: Migrating an Existing SAS Process to Run on the SAS Intelligence Platform, Joseph Urbi

Mobile Reporting at University of Central Florida, Carlos Piemonti

Experiences in Using Academic Data for BI Dashboard Development, Evangeline Collado and Michelle Parente

Uncovering Patterns in Textual Data with SAS Visual Analytics and SAS Text Analytics, Meera Venkataramani

How to Replicate Excel Stacked Area Graphs in SAS, Sharon Avrunin-Becker

Creating ZIP Code-Level Maps with SAS®, Barbara Okerson

A Map is Just a Graph Without Axes, Nat Wooding

“Google-like” Maps in SAS, Darrell Massengill

SAS Macros to Produce Publication-ready Tables from SAS Survey Procedures, Emma Frazier, Shuyan Zhang and Ping Huang

Hospital Readmissions: Characteristics of readmits within 30 days and beyond 30 days, Daniel Clark, Pradeep Podila, Edward Rafalski and George Relyea


When Little Objective Data Are Available, Find Root Causes and Effects with Interrelationship Digraphs and JMP®, Melvin Alexander

From Raw Data to Beautiful Graph using JSL, Michael Hecht

I’m a SAS Programmer. Why should I JMP?, Barbara Okerson

Using JMP® Partition to Grow Decision Trees in Base SAS®, Mira Shapiro

Pharma and Healthcare

Coding For the Long Haul With Managed Metadata and Process Parameters, Mike Molter

Imputing Dose Levels for Adverse Events, John R Gerlach and Igor Kolodezh

Identifying patient characteristics towards reducing hospital readmissions: Propensity Score Matching using JMP Pro, Pradeep Podila, George Relyea and Daniel Clark

Patient Profile Graphs Using SAS®, Sanjay Matange

Using SAS to read, modify, copy, and create comments on a Case Report Form in .pdf format, John Fulda

The Baker Street Irregulars Investigate: Perl Regular Expressions and CDISC, Peter Eberhardt and Wei Liu

What Do Your Consumer Habits Say About Your Health? Using Third-Party Data to Predict Individual Health Risk and Costs, Satish Garla

Kaplan-Meier Analysis: A Practical Guide For Programmers, Madhi Saranadasa

Using the 7th Edition American Joint Committee on Cancer (AJCC) Cancer Staging Manual to Determine Esophageal Cancer Staging in SEER-Medicare Data, Johnita Byrd and Felix Fernandez

Survey of Population Risk Management Applications Using SAS(r), Jack Shoemaker

Statistics and Data Analysis

PROC SURVEYSELECT as a Tool for Drawing Random Samples, Taylor Lewis

A SAS Macro for Finding Optimal k-Means Clustering in One Dimension with Size Constraints, Fengjiao Hu and Robert Johnson

SAS® Macros CORR_P and TANGO: Interval Estimation for the Difference between Correlated Proportions in Dependent Samples, Pei-Chen Wu, Patricia Rodriguez de Gil, Thanh Pham, Diep Nguyen, Jeanine Romano, Jeffrey D. Kromrey and Eun Sook Kim

Using Predetermined Factor Structures to Simulate a Variety of Data Conditions, Kevin Coughlin, Jeffrey Kromrey and Susan Hibbard

Forecasting Enrollment in Higher Education using SAS Forecast Studio, Erik Bowe and Steven Merritt

Analyzing Multiway Models with ANOM Slicing, Peter Wludyka

Maximizing Confidence and Coverage for a Nonparametric Upper Tolerance Limit for a Fixed Number of Samples, Dennis Beal

Dealing with Missing Data for Credit Scoring, Steve Fleming

Evaluating the Accuracy Assessment Methods of a Thematic Raster through SAS® Resampling Techniques and GTL Visualizations, Robert Seffrin

Evaluating the Performance of the SAS® GLIMMIX Procedure for the Dichotomous Rasch model: A Simulation Study, Isaac Li, Yi-Hsin Chen and Jeffrey Kromrey

GEN_OMEGA2: A SAS® Macro for Computing the Generalized Omega-Squared Effect Size Associated with Analysis of Variance Models, Anh P. Kellermann, Jeanine Romano, Patricia Rodríguez de Gil, Than Pham, Patrice Rasmussen, Yi-Hsin Chen and Jeffrey D. Kromrey

Area under a Receiving Operating Characteristic (ROC) Curve: comparing parametric estimation, Monte Carlo simulation and numerical integration, Paulo Macedo

You like What? Creating a Recommender System with SAS, Wayne Thompson

An Intermediate Primer to Estimating Linear Multilevel Models using SAS® PROC MIXED, Bethany Bell, Whitney Smiley, Mihaela Ene, Phillip Sherlock, Jr. and Genine Blue

Modeling Categorical Response Data, Maura Stokes

Coder’s Corner

Let SAS® Do the Coding for You, Robert Williams

Format Follows Function: User-Written Formats and User-Written Functions that talk to the SAS Metadata Server, Philip Busby

Writing Macro Do Loops with Dates from Then to When, Ronald Fehd

Database Vocabulary: Is Your Data Set a Dimension (LookUp) Table, a Fact Table or a Report?, Ronald Fehd

Report Dates: %Sysfunc vs Data _Null_;, Bill Parman

Summarizing Character Variables Using SAS® Proc Report, Priya Suresh and Elizabeth Heath

Proc Compare – The Perfect Tool for Data Quality Assurance, Ted Shelly

The Power of Combining Data with the PROC SQL, Stacey Slone

Comparisons of SAS Mixed and Fixed Effects Modeling for Observed over Expected Count Outcomes in the Presence of Hierarchical or Clustered Data, Rachel E Patzer and Laura Plantinga

Selecting Earliest Occurrence: Watch Your Step, David Abbott

Handling data with multiple records per subject: 4 quick methods to pull only the records you want, Elizabeth Leslie

Fit Discrete Distributions via SAS Macro, Feng Liu

The BEST. Message in the SASLOG, Andrew Kuligowski

Array Applications in Determining Periodontal Disease Measurement, Liang Wei, Laurie Barker and Paul Eke

Automating Data Vetting Using SAS Macros, Forrestt Severtson

Using Arrays to Handle Transposed Data, Michael Leitson

How SAS Processes If-Then-Else Statements, Michael Leitson and Elizabeth Leslie

Don’t Get the Finger… You Know the FAT Finger Creating a Modular Report Approach using BASE SAS, Penny Eckert

PROC FORMAT in DATA Step mathematics, Elizabeth Schreiber

Using Heatmaps and Trend Charts to Visualize Kidney Recipients’ Post- Transplant Hospitalizations, Sebastian Perez

Resistance is Futile: SAS Enterprise Guide Assimilates PC SAS, Sheryl Weise

The Short-Order Batch, Carol Martell

How Many Licks to the Center of that Column?, Spencer Childress

Using SAS to calculate Modularity of a Graph for Community Detection Problems, Song Chen

Explore RFM approaches using SAS, Ruiwen Zhang


Using SAS to Examine Social Networking Difference between Faculty and Students, Abbas Tavakoli, Joan Culley, Hein Laura, Blake Frazier and Williams Amber

Getting Out of the PROC PRINT Comfort Zone to Start Using PROC REPORT, Imelda C. Go and Abbas S. Tavakoli

SAS Macros to Conduct Common Biostatistical Analyses and Generate Reports, Dana Nickleach, Yuan Liu, Adam Shrewsberry, Robert Steven Gerhard, Kenneth Ogan, Sungjin Kim and Zhibo Wang

Let the Code Report the Running Time, Zi Feng

Not just another macro, Y. Christina Song

SAS Web Editor, is it the right choice for you?, Rebecca Ottesen and Jamelle Simmons

Does the Percentage of College Student and Military Personnel Group Quarters Affect Political Contributions per Zip Code? Visualization with PROC GMAP, Jamelle Simmons

GLIMMIX_Rasch: A SAS® Macro for Fitting the Dichotomous Rasch Model, Yi-Hsin Chen, Isaac Li and Jeffrey Kromrey

POSTEQUATE: A SAS® Macro for Conducting Non-IRT Test Post-equating, Isaac Li and Jeffrey Kromrey

Analytical Approach for Bot Cheating Detection in a Massive Multiplayer Online Racing Game, Andrea Villanes Arellano

Role of Fibrinogen, HDL Cholesterol and Cardio Respiratory Fitness in Predicting Mortality Due to Cardio-vascular Disease: Results From the Aerobics Center Longitudinal Study, Srinivasa Madhavan, Steven Blair and Abbas Tavakoli

Comparing PROC MI and IVEWare callable software, Bruno Vizcarra and Amang Sukasih

Winning the War on Terror with Waffles: Maximizing GINSIDE Efficiency for Blue Force Tracking Big Data, Troy Martin Hughes

Stock Prices Analysis, Dhanashree Gadkari


ISO 101: A SAS® Guide to International Dating, Peter Eberhardt and Xiao Jin Qin

RUN_MACRO Run! With PROC FCMP and the RUN_MACRO Function from SAS® 9.2, Your SAS® Programs Are All Grown Up, Dylan Ellis

Copyright Information

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

Copyright Information

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 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


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=””>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

Copyright Information

These Proceedings are the official record of the 18th annual SouthEast SAS Users Group (SESUG) Conference held in Savannah, GA on September 26 – 28, 2010 at the Hyatt Regency Savannah. 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 2010: The Proceedings of the SouthEast SAS Users Group, Savannah, GA, 2010

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 © 2010 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

%whatChanged: A Tool for the Well-Behaved Macro, Frank DiIorio

While You Were Sleeping, SAS® Was Hard At Work, Andrea Wainwright-Zimmerman

Which SASAUTOS Macros Are Available To My SAS® Session, Harry Droogendyk

QC Your SAS® and RDBMS Data Using Dictionary Tables, Harry Droogendyk

SAS/Data Integration Studio® – Creating and Using a Generated Transformation, Jeff Dyson

ExcelXP on Steroids: Adding Custom Options To The ExcelXP Tagset, Mike Molter

Mobile Macros – Get Up to Speed Somewhere New Fast, Patricia Hettinger

SAS® and Relational Databases: What You Must Know, Patricia Hettinger

A Serious Look Macro Quoting, Ian Whitlock

The Path, The Whole Path, And Nothing But the Path, So Help Me Windows, Art Carpenter

ODS Layout for RTF – A custom tagset, Richard A. DeVenezia

The DoW-Loop Unrolled, Paul M. Dorfman

PROC_CODEBOOK, Automating the Review and Documentation of SAS® Files, James Terry

Coders’ Corner

A View Toward Performance, Ed Heaton

Using SAS® to Produce Report-Ready Summaries of Likert-Type Survey Data: PROC TABULATE, Output Delivery System, PROC TEMPLATE, Imelda Go

Recoding “ALL THAT APPLY” Variables from Handhelds and Portable Computers, Wafa Handley, Barbara Bibb, Lilia Filippenko, Jay Levinsohn, Donna Medeiros

Making Sense of Census Data, Robert S. Matthews

By Your Command: Executing Windows DLLs from SAS® Enterprise Guide, Darryl Putnam

How to run an error check to stop SAS®, Dan Blanchette

%RESTRUCT – SAS® macro with Proc Univariate, Milorad Stojanovic

IF and %IF You Don’t Understand, Ian Whitlock

Automation of Data Updates: A Case Study, Carry Croghan

Using DICTIONARY Views to Eliminate Tedious Visual Review, Christine Davies

Application Dispatcher: Some Tweaks and Tricks, Carol Martell


Bars and Lines: A Quick Introduction to PROC GBARLINE, Garland D. Maddox

Which Job Sent *THAT* Error Message – How to Generate a Lookup List From Your Metadata, Robert Janka

Your Friendly Neighborhood Webcrawler: A Guide to Crawling the Web with SAS®, James Cox

SAS® Abbreviations Are Your Friends; Use a Template Method to Code!, Elizabeth Ceranowski

Foundations and Fundamentals

Take Control: Understanding and Controlling Your Do-Loops, Sarah A. Woodruff, Toby Dunn

Building the Better Macro: Best Practices for the Design of Reliable, Effective Tools, Frank DiIorio

The Data Step; Your Key To Successful Data Processing In SAS®, Don Kros

SAS® Formats: Effective and Efficient, Harry Droogendyk

Fun with Functions, Yogini Thakkar

Merging into Hash: Some Practical Examples of Converting MERGE Statements into Hash Objects, Ying Liu

The MEANS/SUMMARY Procedure: Getting Started, Art Carpenter

Leave Your Bad Code Behind: 50 Ways to Make Your SAS® Code Execute More Efficiently, William E. Benjamin Jr

Know What Your Business Client Wants: An Introduction to how analytics is used to understand loyalty program in the hospitality industry, Tracy Li-moshenko

It’s Five O’Clock Somewhere!!! Handling Dates And Times In SAS®, Toby Dunn, Sarah A. Woodruff

Evolve from a Carpenter’s Apprentice to a Master Woodworker: Creating a Plan for Your Reports and Avoiding Common Pitfalls in REPORT Procedure Coding, Allison Booth

SAS® Programmer’s Paradise: New Goodies in SAS® Enterprise Guide® 4.3, Stephen Slocum

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

Hands-On Workshops

Statistical Analysis – The First Steps, Jennifer Waller

Macro Quoting – How and Why, Ian Whitlock

PROC TABULATE: Doing More, Art Carpenter

SAS/GRAPH® Elements You Should Know – Even If You Do Not Use SAS/GRAPH®, Art Carpenter

Two Guys on Hash, Paul M. Dorfman, Peter Eberhardt

How To Use Proc SQL select into for List Processing, Ronald Fehd

Traffic Lighting Your Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®, Vince DelGobbo

Planning and Support

If you Have Programming Standards, Please Raise Your Hand: An Everyman’s Guide, Dianne Louise Rhodes

If You Can’t Learn It From A Book, Why Are You Reading This?, Steve Noga

At Your Service: Your Roadmap to Support from SAS®, Kathy Council

SAS-L and Beyond, Joe Kelley


Using SAS® to Examine Missing Data in Psychometric Research, JoAnne Herman, Elizabeth Register, Abbas Tavakoli

SAS® Maps as Tools to Display and Clarify Healthcare Outcomes, Barbara B. Okerson

LAG Function Combined with Conditional Functions – Useful in Identifying Differences in Like Data, Andrew Hummel

Solving Kenken Puzzles – By Not Playing, John R. Gerlach

ES_ANOVA: A SAS® Macro for Computing Point and Interval Estimates of Effect Sizes Associated with Analysis of Variance Models, Jeffrey D. Kromrey, Bethany A. Bell

How to Monitor “Don’t Know” and “Refusal” Non-responses in a Large National Survey – Using Simple SAS® Macros, a Few PROCs, and Data Steps., Mariah Cheng, Timothy Monbureau

Proc Report Data = Subject.Event_Chronology;, Christina Carty, Elizabeth Spence


Guide to ODS Graphics Editor in SAS® 9.2, Mirjana Stojanovic

Customizing Saved Proc Import Code, Carolyn D. Williams

Fitting multivariate random-effects models using SAS® PROC GLIMMIX, Lei Li

A SAS/AF® Application for Organizing the Data Management Activities of the CHIMES Follow Up Study, Emily A. Mixon, Valisa R. Brown, Karen B. Fowler
Technique of Using PROC SQL, Hui-Ping Chen

Analysis and Visual Review of Error Matrices in SAS® Stat Studios, Robert Seffrin

Sample Size Calculation to Evaluate Mediation Analysis, Rajendra Kadel

Developing a Telco Revenue Forecasting and Device Optimization Analytics Tool, Lan Guan

The SAS® User Group Community Activity, Don Kros

Using Dictionary Tables to Explore SAS® Datasets, Phillip Julian

Reporting and Information Visualization

Business intelligence 2.0: Are we there yet?, Greg Nelson

Using Linux Shell Commands, vi Editor, and Base SAS® to Parse through Log Files and Gather Log-information, Fuad J. Foty

Distance mapping in health and health care: SAS® as a tool for health geomatics, Barbara B. Okerson

SAS® Proc Report and ODS ExcelXP Tagsets to Produce Customized Excel Output Without DDE, Mira Shapiro

ODS RTF TEXT My New Best Friend!, Brian Spruell

SBSBOXPLOT: A SAS® Macro for Generating Side-by-Side Boxplots, Jason A. Schoeneberger, Grant B. Morgan, Bethany A. Bell

Yes! SAS® ExcelXP WILL NOT Create a Microsoft Excel® Graph; But SAS® Users Can Command Microsoft Excel® to Automatically Create Graphs From SAS® ExcelXP, William E. Benjamin Jr

Geocoding Crashes in Limbo, Carol Martell, Daniel Levitt

Producing Maps Using SAS® Enterprise Guide®, Harmon L. Jolley

Model Visualization Using JMP®, SAS®, and Excel, Jon Weisz

The Systems Development Life Cycle (SDLC) as a Standard: Beyond the Documentation, Dianne Louise Rhodes

Introduction to Graphics Using SAS/GRAPH® Software, Mike Kalt

Statistics and Data Analysis

A Taste of ADaM, Beilei Xu, Changhong Shi

Detecting Medicaid Data Anomalies Using Data Mining Techniques, Aran J. Canes, Qiling Shi, Shenjun Zhu

SAS® Macros for Estimating the Attributable Benefit of an Optimal Treatment Regime, Jason S. Brinkley

Potential Change in Reliability Measures Based on Decreased Sample Size for the Census Coverage Measurement Survey, Vincent T. Mule

A SAS® Macro to Compute Added Predictive Ability of New Markers Predicting a Dichotomous Outcome, Kevin Kennedy, Michael Pencina

Using SAS® Text Miner 4.1 to create a term list for patients with PTSD within the VA, Matthew R. Richardson, Stephen L. Luther, Donald Berndt

A Macro for Calculating Summary Statistics on Left Censored Environmental Data using the Kaplan-Meier Method, Dennis J. Beal

Using SAS® PROC CLUSTER to Determine University Benchmarking Peers, Elayne Reiss, Sandra Archer, Robert L. Armacost, Ying Sun, Yun Fu

Developing a Model for Person Estimation in Puerto Rico for the 2010 Census Coverage Measurement Program, Colt S. Viehdorfer

Stationarity Testing in High Frequency Seasonal Time Series, David A. Dickey

The Graph Template Language and the Statistical Graphics Procedures – An Example-Driven Introduction, Warren Kuhfeld

Take a Whirlwind Tour Around SAS® 9.2, Diane Hatcher

The Next Generation: SAS/STAT® 9.22, Phil Gibbs

Copyright Information

These Proceedings are the official record of the 17th annual SouthEast SAS Users Group (SESUG) Conference held in Birmingham, AL on October 25 – 27, 2009 at the Sheraton Birmingham Hotel and the Birmingham-Jefferson Convention Complex. 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 2009: The Proceedings of the SouthEast SAS Users Group, Birmingham, AL, 2009

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

Application Development

Customer Retention Predictive Modeling in HealthCare Insurance Industry

From Obscurity to Utility: ADDR, PEEK, POKE as DATA Step Programming Tools

High Performance Analytics with In-Database Processing

Importing Complicated Excel® Files into SAS® Drug Development (SDD)

Maximum SAS®: Analyzing and Increasing Performance

No More Blue Screens – Running SAS® on Windows Servers

Putting Lipstick on Legacy SAS® Code

Resolving Value Differences among Duplicates, A Rule-based Approach

SAS® Macro Design Issues

Supporting a SAS® Server Architecture

Use SAS® to Check Misspelled Words in Excel Files

Coders’ Corner

A Macro to Unravel Macros

A SAS® Macro for Deming Regression

A SAS® Macro to Automate the Process of Define.xml

A Simple SAS® Utility to Dynamically Create Variable Names and Recode the Associated Values

A User-Friendly Macro for Last Observation Carried Forward

Adapt to Change of Table Numbers in Deliverable with One Click

Daunting Tasks Made Simple with Input Techniques and Macro Processing

Exchanging data between SAS® and Microsoft Excel

Exploring SAS® PROC CDISC Model=ODM and its Undocumented Parameters

Macro Solution to Oracle Limitation

Macro to Retain Group Variable Names in PROC REPORT’s ODS RTF Outputs

Multiple Imputation for Survey Data Analysis

SAS® Macro Autocall and %Include

Short, Sweet and Simple…how to do more with less in SAS®

True or False: Evaluating Logical expressions

Utilizing the SAS® Macro Facility to Interface with PROC COMPARE

Foundations and Fundamentals

A Little Stats Won’t Hurt You

A Real Case Use of the Data Step Debugger

A Serious Look Macro Quoting

DATA Step versus PROC SQL Programming Techniques

Don’t Be a SAS® Dinosaur: Modernizing Programs with Base SAS 9.2 Enhancements

Getting from SAS® 9.1.3 to SAS® 9.2: Migration Tools or Promotion Tools

Handling Dates in the Macro Facility

Implementing User-Friendly Macro Systems

Industrial Strength Analytics: A Brief Overview of SAS/OR®

Labels, Labels, and More Labels

Looking Beneath the Surface of Sorting

Navigating the SAS® Business Intelligence Client Tools

Tips for Moving to SAS® Enterprise Guide® on Unix

Your Friend – Custom Formats

Hands-on Workshops

A Hands-on Tour Inside the World of PROC SQL®

Advanced PROC REPORT: Getting Your Tables Connected Using Links

Graphing the Easy Way with SAS® Enterprise Guide® (or How to Look Good With Less Effort)

How to Use ARRAYs and DO Loops: Do I DO OVER or Do I DO i?

List Processing Basics: Creating and Using Lists of Macro Variables

More Tips and Tricks for Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®

SAS® Add in to MS Office – A Tutorial

Streamlining Data Analysis

The SAS® Hash Object in Action


A Macro for Computing the Mantel-Fleiss Criterion

A Modular Approach to Develop Complex Data Errors Checking Program in Clinical Trial Environment

A System To Standardize Creating Files Using Visual Basic 6.0 and SAS® Automation

Are Differences in Marital Status an Important Factor for KAP Related to HIV/AIDS in Saoner Rural Area?

Building Effective Statistical Programming Teams for Clinical Trials

Constructing Baseline of Customer’s Hourly Electric Usage in SAS®

Graphs in Flash, using Graph Template Language (GTL)

MIXED_DX: A SAS® Macro for Two-Level Linear Model Diagnostics

Mapping Nested e-CRF Data into SDTM Domains

Matching SAS® Data Sets with PROC SQL: If at First You Don’t Succeed, Match, Match Again

ODS Graphics Designer

Quartile Conundrum

Using SAS® to Explain Mediator and Moderator Effect for Social Support of Mothers of Mentally Ill Children

Using SAS® to Explore the Impact of a Care Management Maternity Program

Reporting and Information Visualization

Advanced Topics in ODS

Cool Maps with Custom Areas

Exploring JMP® 8 Integration with SAS® 9.2:
A Rich Set of Development Tools for the Analytic/Dynamic Report Application Developer

Export Customized Graphs Directly into Microsoft Word Using Dynamic Data Exchange

Inline Formatting with ODS Markup

Integrating Geocode Data from the Google Map API and SAS/GRAPH®

No More Downloading – Using SAS/ODS® to Create Graphs and HTML Documents for z/OS Systems
– Updated for SAS® V9.1

Notes from an Intersection: Google Earth @ SAS®

Pleasing the Client: Creating Custom Reports with SAS® ODS Layout and Proc Report

Stop Light Reporting with PROC REPORT

Tips and Tricks IV: More SAS/GRAPH® Map Secrets

Using ODS Select to Limit SAS® Output

Using the Excel XP tagset and DDE to create At-A-Glance Summary Spreadsheets
–Compiled, Written, and Formatted with one SAS® click!

Simple but Clever

An Approach to Creating Archives That Minimizes Storage Requirements

Automating Distribution of Formatted Reports Using Base SAS®

Boot Camp for Programmers: Stuff You Need to Know That’s Not in the Manual
– Best Practices to Help Us Achieve Reproducibility

Cr8_In_List – Easy Table Driven Programming

ODS Packages: Putting Some Zip in Your ODS Output

PROC MIXED: Macro to Assess Fixed and Random Effects for Significance
Using the Likelihood Ratio Test and the Approximate Mixture Method

Resetting Variables to Zero

SCL is Gone, How Do I Get Variables From My Users Into SAS Enterprise Guide®?

Source Code Documentation: When Comments Get in the Way

THINK Before You Type. Best Practices Learned the Hard Way

Taking the PROC FREQ a Step Beyond

Using Formats, MP Connect®, and Other SAS® Efficiency Techniques to save Time and Disk Space

Statistics and Data Analysis

A Logistic Regression Model to Predict Freshmen Enrollments

A Monte Carlo Study to Evaluate the Robust Standard Error Feature in PHREG procedure

A New Effect Modification P Value Test Demonstrated

An Easy and Convenient Method for Constructing Contrasts

An Introduction to SAS/IML® Studio for SAS/STAT® Users

Developing Business Failure Prediction Models Using SAS® Software

Enrollment Simulation in Clinical Trials

Estimation of Coefficients of Individual Agreement (CIAs) for Quantitative and Binary Data using SAS® and R

Getting Correct Results from PROC REG

Imputation for Censored Observations in Survival Studies Allowing for a Positive Cure Rate

Jittering: A SAS® Macro to Shift Overlapping Plots

Methods, Models, and More: New Analyses Available with SAS/STAT® 9.2

SAS® and Clinical IVRS: Beyond Schedule Creation

The Effect of Missing Data on Repeated Measures Models

The Use of SAS® in MetaAnalysis

Copyright Information

These Proceedings are the official record of the 16th annual SouthEast SAS Users Group (SESUG) Conference held in Birmingham, AL on October 19 – 22, 2008 at the TradeWinds Island Resorts. 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 2008: The Proceedings of the SouthEast SAS Users Group, St Pete Beach, FL, 2008

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

Business Intelligence

BI-001: Introduction to the SAS® 9 Business Intelligence Platform: A Tutorial
Greg Nelson

BI-002: Interrogate the Interrogator: Presenting SAS® Usage Information Using BI Tools
Emilio Power, Shawn D. Edney

BI-003: Best Practices for SAS® BI Administrators: Using SAS Configuration Troubleshooter to Keep SAS Solutions and SAS BI Applications Running Smoothly
Tanya C. Kalich

BI-004: A Programming Methodology for Creating CDISC Domain Data Sets
John R. Gerlach

BI-005: SAS® Administration, More relevant than ever
Shawn D. Edney

BI-006: An Approach for Deriving a Timing Variable in SDTM Standards
Shaoan Yu, Joyce Gui

BI-007: Using PSI to monitor predictive model stability in the database marketing industry
Shihong Li, Sandeep Kharidhi, Matt Kramer

BI-008: Building a Clinical SAS® Programming Group from the Ground Up
Devin J. Hunt, Nicole C. Close

BI-009: SAS: The Ultimate Dashboard Machine
Jeff Wright (Presented by Greg Nelson)

BI-010: Making Sense of Enterprise Business Intelligence (EBI) Log Configuration Files to Gain Valuable Insight on User Behavior
Piyush Patel, Sandeep Kharidhi

Coders’ Corner

CC-011: Simple SAS Web Services with Ruby
Daniel Olguin

CC-012: Ruby Functions from the SAS DataStep
Daniel Olguin

CC-013: Die Macro Die!
Daniel Olguin

CC-014: Have your SAS® program email information to you or your clients
Bob Bolen

CC-015: Using External Files to Maintain An Application
Edgar Adams

CC-016: A macro for nearest neighbor imputation
Lung-Chang Chien, Mark Weaver

CC-017: PivotTable | A Powerful Tool for Data Exploration in the Pharmaceutical Industry
Wei (Lisa) Lin, June Cheng

CC-018: Exploring the Undocumented PROC SQL _METHOD Option
Kirk P. Lafler

CC-019: Formats – Let the Data Do it
Janet Stuelpner

CC-020: Conversion from Daylight Savings to Standard Time
Audrey Ewen

CC-021: Checks and Balances Using a Macro
Liza M. Thompson

CC-022: Another Way to Make Use of Variable Labels
Stephanie R. Thompson

CC-023: Smoke and Mirrors!!! Come See How the _INFILE_ Automatic Variable and SHAREBUFFERS Infile Option Can Speed Up Your Flat File Text-Processing Throughput Speed
William E. Benjamin

CC-024: Using Lookup Tables to Match Data
Wenyu Hu, Fang Chen, Liping Zang

CC-025: Poor man’s Parallel Processing using the DATA Step View
Erik Tilanus

CC-026: Gracefully Terminate a DATA step If the Input Data File is Not Available
Erik Tilanus

CC-027: Order From Chaos: Using the Power of SAS® to Transform Audit Trail Data
Yun Mai, Susan Myers, Nanthini Ganapathi, Vorapranee Wickelgren

CC-028: Standardization of Lists of Names and Addresses using SAS® Character and Perl Regular Expression (PRX) Functions
Elizabeth Heath, Priya Suresh, Ruben Chiflikyan

CC-029: 6 Cool things you can do with Display Manager
Jenine Milum

CC-030: Automated Data Converting of Character into Numeric Fields
Mila Chiflikyan, Nick L Kinsey, Ruben Chiflikyan, Valentina Grouverman

CC-031: Using Functions SYSFUNC and IFC to Conditionally Execute Statements in Open Code
Ronald Fehd

CC-032: Renaming Tool Series
Vincent Weng, Ying Feng

CC-033: Creating Order from Chaos Using SAS Functions
Kristine L. Dougherty, Vicky Feldman

CC-034: Tying it Together: Using ODS to Insert EXCEL® Hyperlinks
James E. Snider, Garland D. (David) Maddox

CC-036: Use of Post Processor in Clinical Data Reporting
Niraj J. Pandya

CC-037: SAS® Log Summarizer—Finding What’s Most Important in the SAS® Log
Milorad Stojanovic

CC-038: Stupid Human Tricks with PROC SURVEYSELECT®
David L. Cassell

CC-039: Parameter Passing by Name
Ian Whitlock

CC-172: Creating common information structures using list’s stored in data step hash objects
Shawn D. Edney


CS-041: SET, MERGE, and Beyond
Erik Tilanus

CS-042: The Art of Debugging
Ian Whitlock

CS-043: Dataset Options: Beyond DROP, KEEP, RENAME, and WHERE
Sarah A. Woodruff, Ed Heaton

CS-044: Are Your SAS® Programs Running You?
Marje Fecht, Larry Stewart

CS-045: A Row is a Row is a Row, or is it? Get Comfortable with Transposing your Data
Christianna S. Williams

CS-046: PROC TABULATE and the Neat Things You Can Do With It
Wendi Wright

CS-047: A Propaudeutic For Proc SQL Joins
Lisa Mendez, Toby Dunn

CS-048: “SAS macros are just text substitution.” ARRRRGGGHHH!!!!
Dianne Piaskoski

CS-049: Macro Quoting
Toby Dunn

CS-050: The Devil Is in the Details: Styles, Tips, and Tricks That Make Your Microsoft Excel Output Look Great!
Eric Gebhart

CS-051: SAS® Resources: Places to Find Answers and Ideas
Nat Wooding

CS-052: Database Vocabulary: Is Your Data Set a Dimension (LookUp) Table, a Fact Table or a Report?
Ronald Fehd

CS-053: SAS® Add in to MS Office — A Tutorial
Angela M. Hall

CS-054: Crossing the Border: Steps to Writing SAS® Stored Processes
Peter Eberhardt

CS-055: The Various Mechanisms of Calculated OLAP Cube Measures
Angela M. Hall

CS-056: “Development, Test, Production … Oh My!” Making It to the Land of Oz (also known as a satisfied IT Department) Using SAS®9 and Business Processes
Angela M. Hall

CS-057: SAS® Hash Objects: An Efficient Table Look-Up in the Decision Tree
Ying Liu

CS-058: Rule based filtering — categorizing unwanted inputs
Richard A. DeVenezia

CS-059: The DoW—Loop Unrolled
Paul M. Dorfman, Lessia S. Shajenko

CS-060: MISSING VALUES: Everything You Ever Wanted to Know
Malachy J. Foley

CS-061: The Impossible — An Organized Statistical Programmer
Brian Spruell, Kevin Mcgowan

CS-062: You Want ME to use SAS® Enterprise Guide®??
Vince DelGobbo

Hands-on Workshops

HOW-063: How to Read, Write, and Manipulate SAS dates
Jenine Milum

HOW-064: SAS® Macro Programming Tips and Techniques
Kirk P. Lafler

HOW-065: Using SAS® to Parse External Data
Andrew T. Kuligowski

HOW-066: PROC SQL for DATA Step Die-Hards
Christianna S. Williams

HOW-067: PROC REPORT…Your How-to Guide for Producing Customized Summary Tables
Debbie Buck

HOW-068: A “SAS® Programmer’s” Guide to SAS® Enterprise Guide®
Marje Fecht, Rupinder Dhillon

HOW-069: The Plot Thickens from PLOT to GPLOT®
Wendi Wright

HOW-070: Using SAS Arrays to Manipulate Data
Ben T. Cochran

HOW-071: Tips and Tricks for Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®
Vince DelGobbo

Mining the Past, Seeing the Future

MPSF-072: Evaluating Predictive Models (Part 1):Computing and Interpreting the c Statistic
Sigurd W. Hermansen

MPSF-073: Model Validity Checks In Data Mining: A Luxury or A Necessity?
Michael Speed, Simon Sheather

MPSF-074: Making Sense of Census Data
Robert Matthews

MPSF-075: A Reintroduction to Spline Modeling for Non-Linear Trends
Derek Montrichard

MPSF-076: Tailoring the use of SAS® Enterprise Miner
Sascha Schubert

Anpalaki J. Ragavan

MPSF-078: PDA Data Collection: Data Collection issues…SAS® Data Step to the Rescue!
Mira Shapiro

MPSF-079: Evaluating Predictive Models (Part 2):Assessing Whether More Complex Models Predict Better
Sigurd W. Hermansen

MPSF-080: Teaching Data Mining: the University of Alabama and SAS®
Michael D. Conerly, J. Michael Hardin

MPSF-081: Biosurveillance and the Holy Grid — Does it Compute?
Russell Gann


PO-082: Rounding in SAS®: Preventing Numeric Representation Problems
Imelda Go

PO-083: Evaluating Sample Code for an Interview
Stephanie R. Thompson

PO-084: Health Status and Attitudes Towards Health in Medical Expenditure Panel Survey (MEPS) Sample Population
Pramit A. Nadpara

PO-085: Using SAS® Graphics to Explore Behavioral Health Cost Risk
Barbara Okerson

PO-086: Using SAS® to Analyze Longitudinal Study
Abbas S. Tavakoli, Kirby Jackson, Linda Moneyham, Carolyn Murdaugh

PO-087: Architecting a Regulatory Compliant Macro Library using SAS® Drug Development
Ginger Redner, Margaret M. Coughlin

PO-088: T.I.P.S. (Techniques and Information for Programming in SAS®)
Kathy Harkins, Carolyn Maass, Mary Anne Rutkowski

PO-089: ATTENUATE: A SAS® Macro for Computing Confidence Intervals for Disattenuated Correlation Coefficients
Jeffrey D. Kromrey, Robert H. Fay, Aarti P. Bellara

PO-090: Two SAS® macros for DIF Analysis
Shiqi Hao

PO-091: Parsimony vs. Complexity: A Comparison of Two-Level, Three-Level, and Cross-Classified Models Using Add Health and AHAA Data
Bethany A. Bell, Corina M. Owens, John M. Ferron, Jeffrey D. Kromrey

PO-092: Using the SAS/GRAPH® Annotate Facility to Create Timeline Plots
Erin L. Abner, Marta S. Mendiondo

PO-093: SS_SIM: A SAS® Macro for Evaluating the Statistical Properties of the Standard
Setting Process

James T. Coraggio, John M. Ferron, Jeffrey D. Kromrey

PO-170: Lessons Learned from Integrating SAS Applications
C. Jenny Shiao

Simple But Clever

SBC-114: Joins: How to Put it All Together
Janet Stuelpner

SBC-116: An innovative approach to the “other specify” recoding procedure in research survey
Ruben Chiflikyan, Barbara Bibb, Mai Nguyen

SBC-117: NOTEs in a SASLOG : Of LOST CARDs and MERGE Statements with Repeats of By Values
Andrew T. Kuligowski

SBC-119: Breaking Up Isn’t Hard To Do After All
Toby Dunn

SBC-120: Utilizing Hash Tables to Obtain Matched Post-Hoc Control Populations
Elayne Reiss, Jeffrey Reiss

SBC-121: Techniques for Developing Quality SAS® Macros
Ginger Redner, Liping Zhang, Carl Herremans

SBC-123: Data Manipulations Using Arrays and DO Loops
Patricia H. Hall, Jennifer Waller,

SBC-125: Quick ’n Dirty, Small, Useful Utility Macros
Harry J. Droogendyk

SBC-126: Which SAS AUTOs Macros Are Available to My SAS® Session?
Harry J. Droogendyk

SBC-127: Identifying and listing outliers without using PROC Format option Other=Invalid
Ruben Chiflikyan, Mila Chiflikyan, Donna Medeiros

SBC-128: Names, Names, Names — Make Me a List
Ian Whitlock

SBC-129: Tips and Tricks to Make SAS® Life Easier
Claudine Lougee

SBC-130: Using Unnamed Pipes to automate loading a sas data warehouse using only Base SAS®
Vicky Feldman, Kristine L. Dougherty

SBC-131: How to Create Variables Related to Age
Joyce Gui, Shaoan Yu

SBC-132: JavaObj, the newest production component object
Richard A. DeVenezia

SBC-133: Undocumented and Hard-to-find PROC SQL® Features
Kirk P. Lafler

SBC-134: An Optimal Way to Import Excel Worksheets into PC SAS®
Nathaniel Derby

SBC-135: Using Data to Write SAS® programs
Kevin McGowan, Brian Spruell

SBC-137: Parameter-Driven Data Validation and Transformation Or The Marriage of Microsoft Excel and SAS® Macro Variables to Solve ETL Problems
Hugh Shinn, Wanda J. Hopkins

SBC-138: Using the SAS® INPUT Statement for Not So Friendly File Formats
Inga B. Allred, Barbara Felts

Seeing is Believing

SIB-094: Flexible SAS®
Daniel Olguin

SIB-095: Degree Data for All: A Web Report Studio Reporting Solution
M. Paige Borden

SIB-096: Tag Clouds — A list of tokens, sized by relative frequency
Richard A. DeVenezia

SIB-097: Combining Text and Graphics with ODS Layout and ODS Region
Barbara Okerson

SIB-098: SAS® Graphics on ODS 9.2 Performance-Enhancing Steroids
Daniel P. O’Connor

SIB-099: Generating Fantastic Graphs in Ten Seconds or Less
Ben T. Cochran

SIB-101: An Added Dimension: Exploring OLAP Cubes with SAS® Enterprise Guide®
Rupinder Dhillon

SIB-103: Creating Your Own Worksheet Formats in exportToXL
Nathaniel Derby

SIB-104: You Use SAS®, Your Boss Uses EXCEL, Guess Where Your Results are Going to Appear! Digging Deeper into ODS to Put SAS Data into EXCEL
William E. Benjamin

SIB-105: Customized Excel Output Using the Excel Libname
Harry J. Droogendyk

SIB-106: Automation Of An Audit Waterfall Using SAS® Macros and ODS Tagsets.ExcelXP
Denise A. Kruse

SIB-107: Innovative Ways to Enhance Proc SQL Output
Kalyani D. Chaturvedula

SIB-108: New SQL Performance Optimizations to Enhance Your SAS® Client and Solution Access to the Database
Mike Whitcher

SIB-109: Tips to Customize SAS/Graph®… for Reluctant Beginners et al.
Claudine Lougee

SIB-110: Moving from Listing Reports to Visual Reports using SAS/GRAPH® Maps
Elizabeth Ceranowski

SIB-111: PROC REPORT in Color … What’s Your STYLE?
Wendy Boberg

SIB-112: Ride the Wave — Using Waterfall Graphs to Easily Depict Gaps between Starting and Ending Values
Rebecca Bremer Booth

SIB-113: SAS® Graphs in Small Multiples
Andrea Wainwright-Zimmerman

Statistics and Data Analysis

ST-139: Interpreting Three-way Interactions Using SAS®
Anh Le, Maribeth Johnson

ST-141: Complex Survey Data Analysis in SAS® and the Link between PROC SURVEYFREQ and SURVEYMEANS
Taylor H. Lewis

ST-142: Creating county-level estimates from National Weather Service data
Liang Wei, Laurie Barker

ST-143: Don’t Be Loopy: Re-Sampling and Simulation the SAS® Way
David L. Cassell

ST-144: Let Me Look At It! Graphic Presentation of Any Numeric Variable.
Anastasiya Osborne

ST-146: Time Series Analysis with SAS® and R
Samuel T. Croker

ST-147: Surviving Survival Analysis – An Applied Introduction
Christianna S. Williams

ST-148: Count Regression Models in SAS®
David Steenhard

ST-150: PROC SQL for Exact Testing Trend in Proportions
Jonghyeon Kim, Neal Oden, Sungyoung Auh

ST-151: Interactive Outlier Review and Regression Analysis in Stat Studio
Robert Seffrin

ST-152: Marketing Mix Modeling : Techniques and Challenges
Patralekha Bhattacharya

ST-154: Calculating point estimate and confidence interval of Hodges-Lehmann’s median differences using SAS® software
Lingling Han

ST-155: Stopping stepwise: Why stepwise and similar selection methods are bad, and what you should use
David L. Cassell

ST-156: Optimizing the Marketing Mix
Patralekha Bhattacharya

ST-157: SAS® Code for Variable Selection in Multiple Linear Regression Models Using Information Criteria Methods with Explicit Enumeration for a Large Number of Independent Regressors
Dennis J. Beal

ST-158: Lithium Battery Analysis: Probability of Failure Assessment Using LR
Travis A. Moebes

ST-159: A SAS® Macro for Statistical Power Calculations in Meta-Analysis
Guy Cafri, Jeffrey D. Kromrey

ST-160: Reject Inference Methodologies in Credit Risk Modeling
Derek Montrichard

ST-161: Techniques for Evidence-Based Decision Making Using SAS®
Ian Stockwell

ST-162: Introduction to Bayesian Analysis Using SAS® Software
Maura Stokes

ST-163: SAS® Stat Studio: A Programming Environment for High-End Data Analysts
Rick Wicklin

The Institute for Advanced Analytics is pleased to host the archive of past proceedings of the Southeast SAS Users Group (SESUG) Annual Meetings as a service to the SAS user community. The digital library contains 1,059 papers presented at the meeting since 1999. Future proceedings will be added as they become available each year. The archive, which contains a wealth of practical information for SAS users, can be browsed by year or searched using keywords. In the first 30 days of operation the library servers recorded over 15,739 downloaded files, or an average of 525 per day.

Copyright Information

These Proceedings are the official record of the 15th annual SouthEast SAS Users Group (SESUG) Conference held in Hilton Head, SC on November 4–6, 2007 at the Hilton Head Marriott Resort & Spa. 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 2007: The Proceedings of the SouthEast SAS Users Group, Hilton Head, SC, 2007

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

Application Development

AD01 : Simplifying the Sample Design Process With PROC PMENU
Liza M Thompson

AD03 : %XMLPORT: An XML Substitute for SAS PROC CPORT/CIMPORT (almost)
Andy E Barnett

AD05 : PROC INFOMAPS – Let Your Design Document Build Your SAS V9 Information Map
Chuck Bininger

AD07 : Treemap Presentation as a Corporate Dashboard
Larry J Day, Richard W Dickinson

AD08 : Building Your Own Real-Time SAS Server Monitor under UNIX
Houliang Li

AD09 : Multiple File Processing with SAS
Kevin McGowan

AD10 : SAS DI: Introduction to User Written Transforms and Status Handling
Mike Miller

AD11 : Integrating SAS and Microsoft .NET for Data Analysis
Mai Nguyen, Shane R Trahan, Jonathan M Cirella, Patricia Nguyen

AD13 : Developing Flexible Reports to Respond to Routine External Data Requests
Patricia J Ramsey, Esther Johns

AD14 : Improving Efficiency Using the “Virtual Merge”
Steve G Sanders

AD15 : Intelligent SAS Log Manager
Paul D Sherman

AD16 : PROC TIMEPLOT – An Old Way to PLOT New Data
James W Terry Jr.

AD17 : Two Portals, One Sign-On: Gateway to University Reporting
Ali Y Yorkos, Maureen H Murray

Coders’ Corner

CC01 : Generating Random Numbers from a Discrete User-Defined Distribution
Amy L Boulris

CC03 : Making Presentations More Fun with DATA Step Graphics Interface (DSGI)
Hui-Ping Chen

CC04 : A SAS Macro to Automate the Process of Pooling Sites
Lili Chen, Changhong Shi

CC05 : The SQL Procedure: When and How to Use It?
Ying Feng

CC06 : Using PRX to Search and Replace Patterns in Text Files
Wenyu Hu, Liping Zhang

CC08 : Creating a Stored Macro Facility in 10 Minutes
Erik S Larsen

CC09 : ABC Macro and Performance Chart with Benchmarks Annotation
Jing Li

CC11 : PC Tips for Mainframers
Claudine Lougee

CC12 : SAS XML Mapper to the Rescue
Carol A Martell

CC13 : You’ve Sent Mail: Sending Reports Automatically Through SAS
Theresa McVie

CC14 : Sorting Out the Possibilities Using RETAIN
Tommy L Retzlaff, Cara D Woodruff

CC15 : Increasing Student Progress Monitoring via PROC REPORT and ExcelXP Tagset
Elayne Reiss

CC16 : The Lazy RSUBMIT
Stephanie R Thompson

CC17 : Let’s Play a Game: A SAS Program for Creating a Word Search Matrix
Robert Matthews

Data Mining

DM01 : Making Web Results Relevant with SAS
Russell Albright, Jake Bartlett, David Bultman

DM02 : Example of Longitudinal Cluster Analysis with Dietary Data over Time
Robert L Bauserman, Ann Albertson, Nort Holschuh, William McCarth

DM03 : Analyzing Large Social Networks with MP Connect, SAS/IntrNet and %DS2CONST
Shane L Hornibrook

DM04 : Mining Medicaid Encounter Data: What, Why, and How?
Wei Jiang

DM05 : A Methodological Approach to Performing Cluster Analysis With SAS
William F McCarthy

DM07 : Data Mining and Investigating Treatment Options of Osteomyelitis with MRSA
Hamed Zahedi

DM08 : Discrete Choice Modeling with PROC MDC
John O Ang

DM09 : Yankees and Red Sox: A Time Series Analysis of Win Percentage Correlations
Grant A Johnson

Data Presentation

DP01 : Getting Started with PROC DOCUMENT and ODS
David W Kelley

DP02 : Visual Representation of Longitudinal Change in Cluster Analysis
Robert L Bauserman, Ann Albertson, Nort Holschuh, William McCarthy

DP03 : Developing a Dashboard to Aid in Effective Project Management
Paige Borden, Maureen Murray, Ali Yorkos

DP04 : To Cube or Not to Cube: Is OLAP the Better Choice?
Paige Borden, Evangeline Collado

DP05 : Recreating an Excel-Based Report with SAS and ODS
Linda M Lacey

Hands-On Workshops

HW01 : Creating Multi-Sheet Excel Workbooks the Easy Way with SAS
Vince DelGobbo

HW02 : Dynamic Projects in SAS Enterprise Guide: How to Create and Use Parameters
Susan J Slaughter, Lora D Delwiche

HW03 : Planning for and Designing a Data Warehouse: A Hands-On Workshop
Greg S Nelson

HW04 : Using Dictionary Tables: An Introduction to SAS Metadata
Frank DiIorio

HW05 : List Processing Basics: Creating and Using Lists of Macro Variables
Art Carpenter, Ronald J Fehd

HW06 : How to use PROC SQL SELECT INTO for List Processing
Ronald J Fehd

HW07 : Using INFILE and INPUT Statements to Introduce External Data into SAS
Andrew T Kuligowski

HW08 : How to Read, Write, & Manipulate SAS Dates
Jenine M Milum

Introduction to SAS

IS01: The Beginner’s Guide to Beginning in SAS
Frank DiIorio

IS02: Set, Match, Merge… Don’t You Love SAS
Peter W Eberhardt, Ying Liu

IS03: Formats, Informats and How to Program with Them
Ian Whitlock

IS04: Interactions Between the DATA Step and External Files – INFILE/INPUT and More
Andrew T Kuligowski


PO01 : A SAS Macro: Similar Code for the Similar Schools Data Processing
Imelda C Go

PO06 : A Study on Kentucky Highway Fatalities
Ryan J Glassford

PO07 : Application of an Exact Covariate Matching Macro in Outcome Analysis
Guiping Yang, Stephen Stemkovski

PO09 : Data Management Strategies
Abbas S Tavakoli, Kirby Jackson, Linda Moneyham, Kenneth Phillips, Gene Meding, Carolyn Murdaugh

PO10 : Use of ARIMA Time Series and Regressors to Forecast the Sale of Electricity
Beatrice Ugiliweneza

PO15 : Data Mining to Investigate University Expectations of Work
Guoxin Tang

PO16 : %TRAVERSE: A Knuth-style Recursive Procedure to Obtain Directory/Filenames
Andy E Barnett

PO17 : Reducing PROC CORR Output using ODS and DATA Step
Carry W Croghan

PO18 : Benefits of Using Bridging Metadata
Doug Janssen

PO19 : ROBUST_ES: A SAS Macro for Computing Robust Estimates of Effect Size
Jeffrey D Kromrey, Kevin B Coughlin

PO21 : Customized Base SAS Implemented Solvers
Ruben Chiflikyan, Mila Chiflikyan, Jean E Richardson, Renee B Karlsen, Donna Medeiros

PO22 : The CORR Procedure and Power of GTL
Mirjana Stojanovic, Donna Hollis, Laura Archer

PO23 : SSN Validation – Virtually at No Cost
Milorad Stojanovic

PO24 : Using SAS to Track Recruitment in a Multi-Center Study of Diabetes
Stephan A Villavicencio, Therese B Gibson, Patricia A Cleary

PO26 : SAS Macro Notes: Lines and Columns in the Log
Paul D Sherman


SD01 : “Powerful” SAS Techniques from the Windows API
Samuel T Croker

SD02 : The Twain Shall Meet: Facilitating Data Exchange between SAS and Matlab
Dimitri Shvorob

SD03 : Fast Prototyping using SAS/AF Software
Phil F Busby

SD04 : Creating Data-Driven Data Set Names in a Single Pass Using Hash Objects
Jack F Hamilton

SD05 : The SAS Community: How To Be a Part of It!
Gary E Schlegelmilch

SD06 : Old But Not Obsolete: Undocumented SAS Procedures
Barbara B Okerson

SD07 : The Sum of All Fears: or, So You’re the SAS Administrator?
Richard Phillips, Danny Grasse

SD08 : The DOW-Loop Unrolled
Paul M Dorfman, Lessia S Shajenko

SD09 : DATA Step Hieroglyphics
Harry Droogendyk

SD10 : Music to My Ears: Using SAS to Deal with External Files (and My iPod)
Sean Hunt

SD11 : Managing Your SAS Data Warehouse Project From Design to Delivery
Linda Sullivan, Paige Borden

SD12 : Exploring Cellular Automata
Daniel Olguin

SD13 : Smart SAS Tricks
Monal Kohli

SD14 : When PROC REPORT and TAGSETS Collide…
Eric Gebhart

Statistics and Data Analysis

SA01 : New SAS Statistical Software: Just Over the Horizon
Tonya Balan

SA02 : Structural Equation Modeling Using the CALIS Procedure
Yiu-Fai Yung

SA03 : Maryland Region Meteorologically Adjusted Ground-Level Ozone Trend Analysis
George G Antczak, Adrienne Wootten

SA04 : Using SAS/OR to Determine the Optimal Path to Graduation
Sandra J Archer, Robert L Armacost

SA05 : Information Criteria Methods in SAS for Multiple Linear Regression Models
Dennis J Beal

SA06 : Automated Realtime Forecasting of Stream Conditions with SAS
Samuel T Croker, Tomonori Ishikawa, Shane L Hornibrook

SA07 : PROC MIXED: Underlying Ideas with Examples
David A Dickey

SA08 : Selection Bias Adjustment: Root Canal Therapy and Self-Reported Oral Health
Mark S Litaker, Sandre F McNeal, Gregg H Gilbert

SA09 : Estimating the False Discovery Rate using SAS and JMP
Jason A Osborne, Clayton A Barker

SA10 : Virtual and Traditional Teams: Are they Really Different?
Andrea J Roofe, K. Galen Kroeck

SA11 : Cleaning Data the Chauvenet Way
Paul D Sherman, Lily Lin

SA12 : Data Mining Episode Groupers
Patricia B Cerrito


TU01 : DATA Step Hash Objects as Programming Tools
Paul M Dorfman, Lessia S Shajenko

TU02 : Delivering Multi-Sheet Excel Reports from a Parameterized Stored Process
Harry Droogendyk, Richard DeVenezia

TU03 : Efficiency: How Your Data Structure Can Help or Hurt!!!
Toby A Dunn

TU04 : Testing Survey Skip Patterns Using Metadata-Generated SAS Code
David Gilbertz

TU05 : Adapting Your SAS Programs into the SAS9 Paradigm
Warren Repole

TU06 : SAS Formats, More Than Just Another Pretty Face
Ying Liu

TU07 : Moving Forward with FORMATS
David Maddox

TU08 : Data Quality Management, Data Cleansing, and Discrepancy Reporting
Jenine M Milum

TU09 : Introduction to the SAS 9 Business Intelligence
Greg S Nelson

TU10 : User-Written DATA Step Functions
Robert S Ray, Jason Secosky

TU11 : Point-and-Click Style Editing in SAS Enterprise Guide
Susan J Slaughter, Lora D Delwiche

Copyright Information

These Proceedings are the official record of the 14th annual SouthEast SAS Users Group (SESUG) Conference held in Atlanta, GA on October 8–10, 2006 at the Sheraton Atlanta. 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 2006: The Proceedings of the SouthEast SAS Users Group, Atlanta, GA, 2006

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

Applications Development

AP01: %STPBEGIN: How EG Almost Removed the L-word from My Relationship With SAS
Rupinder Dhillon, Peter Eberhardt

AP02: Using Proc Pmenu to Develop a User Friendly Utility Rate Design System
William T Bland, Allen B Dunn, James P Hilton

AP03: Designing an Application with Business Intelligence
Brian W Deitch

AP04: Top-Down Programming with SAS Macros
Edward Heaton

AP05: Be Your Own Task Master – Adding Custom Tasks to EG
Peter Eberhardt

AP06: Using a Control Dataset to Manage Production Compiled Macro Library
Curtis E Reid

AP08: SAS Match Merges: The Driving Force behind a Web-Based Data Coding System
Barbara Felts, Wafa Handley, Chuchun Chien, Inga Allred

AP09: Perl Regular Expressions in SAS
Kevin McGowan

AP10: A Practical Approach to the Stored Compiled Macro Facility in a Clinical Trial Environment
Mirjana Stojanovic, Dorothy Watson, Donna Hollis

AP11: Return of the Codes: SAS’, Windows’, and Yours
Mark Tabladillo

AP12: Data Warehouse Implementation: Where We Are 1 Year Later
Evangeline Collado, Linda S Sullivan

AP13: Why Write a Macro? Then Again, Why Not?
John W Davison, Jr.

AP14: Modifying the LogParse PassInfo Macro to Provide a Link between Product Usage in Rtrace Log and Time Used in Job Log
Ronald J Fehd

AP15: Service-Oriented Architectures: Going from Buzz to Business
Dan Jahn

AP16: DIFFTREE: A Macro to Compare Corresponding Files under Two Directory Trees
Andy E Barnett

Coders’ Corner

CC01: Putting SAS Dataset Variable Names into a Macro Variable
Stephanie R Thompson

CC03: Proc Format, a Speedy Alternative to Sort/Merge
Jenine Milum

CC04: While You Were Sleeping – Scheduling SAS Jobs to Run Automatically
Faron Kincheloe

CC05: SYMPLIFY your Data Set Transposition with SYMPUT, and Make it Data-Driven Too!
Christianna S Williams

CC06: A Better Means: The ODS Data Trap
Myra A Oltsik, Peter Crawford

CC07: The BEST. Message in the SASLOG
Andrew T Kuligowski

CC09: SAS Abbreviations are Your Friends, Use a Template Method to Code!
Elizabeth B Ceranowski

CC10: What’s Really in Your Data? A Quick and Easy Utility to Analyze any SAS Dataset
Thom Clay, Jamila Ervin, Michele Laughlin, Toni Wiliamson

CC11: Journeymen’s Tools: Data Review Macro FreqAll: Using Proc SQL List Processing with Dictionary.Columns to Eliminate Macro DO loops
Ronald J Fehd

CC12: PC Tips for Mainframers
Claudine E Lougee

CC13: Transferring vs. Transporting Between SAS Operating Environments
Mimi Lou

CC14: Dup, Dedup, DUPOUT – New in PROC SORT
Heidi Markovitz

CC15: Generating Multivariate Normal Data by Using PROC IML
Lingling Han

CC16: Dare to COMPARE – Three Methods of Preparing Your Data to Compare Values
David Maddox

Data Presentation

DP01: Effective Forecast Visualization With SAS/GRAPH
Samuel T Croker

DP02: Graphics for Statistical Concepts and Data Display
David A Dickey

DP03: Sorting ODS HTML Tables by Column Headers Using Javascript
Laura W Covington, Neal Oden

DP04: Analyzing Large Social Networks with MP Connect, SAS/IntrNet, and %DS2CONST
Shane L Hornibrook

DP05: Generating Participant Specific Figures Using SAS Graphic Procedures
Carry W Croghan, Marsha K Morgan

DP06: SAS/GRAPH: Introduction to the World of Boxplots
Brian M Spruell

DP07: Using Advanced Features of DDE to Customize Formatted Tables in Excel
Dennis J Beal

DP08: Water Usage Distribution and Its Relation with Income Using SAS and ArcGIS
Fariba Nowrouzi Kashan

DP09: ColdFusion and SAS: No Pain Meds Required
Carol A Martell

DP10: Now – That’s Your Style!!!!!
Chevell T Parker

DP11: Release 2.1 of SAS Add-In for Microsoft Office–Bringing Microsoft Powerpoint to the Mix
Chris J Hemedinger, Jennifer Clegg, Eric Hill

DP12: Overview: SAS Web Report Studio 3.1 and SAS Add-In for Microsoft Office 2.1
Eric Rossland, Tom Carter, Kari Richardson

ETL: Extract, Transform and Load

ET01: Demystifying the SAS Excel Libname Engine – A Practical Guide
Carol A Martell, Paul A Choate

ET02: The Ins and Outs of SAS Data Integration Studio
Chris Olinger, Tim Weeks

ET03: Detection and Quantification of Asymmetric Peaks
Carry W Croghan, Ronald W Williams

ET04: Collect, Clean, Conquer – A Field Guide to Surviving Master Data Clean-up
Jessica Baldwin-Finke

ET05: Many to One Using a SAS DATA Step and PROC MEANS
Jennifer L Waller

ET06: DATALINES, Sequential Files, CSV, HTML and More: Using INFILE and INPUT to Introduce External Data into the SAS System
Andrew T Kuligowski

ET07: When PROC SQL Is Overwhelmed: How to Use the SyncJoin Algorithm to Match Millions of Records Fast
Houliang Li

ET08: Master Data Management–What It Is and Why You Should Care
John E Bentley

ET09: Data Step Interfaces with the Macro Facility
Toby A Dunn

ET11: What’s New In Data Quality?
Phillip G Smith

Hands On Workshops

HW01: Answering the Right Question with the Right PROC
Carrie L Mariner

HW02: The How and Why of SAS Macro Language
Carrie L Mariner

HW03: PROC SQL for DATA Step Die-hards
Christianna S Williams

HW04: Generating Fantastic Graphs the Quick and Easy Way with Enterprise Guide
Ben T Cochran

HW05: Creating AND Importing Multi-Sheet Excel Workbooks the Easy Way with SAS
Vince DelGobbo

HW06: SAS to Publishable Excel… Seamlessly: Using ODS, XML, and Other Tricks
Marje Fecht, Harry Droogendyk

David Maddox

HW08: An Animated Guide : The SAS DATA Step Debugger
Russell M Lavery


PO01: Using Contour Plots to Promote EHR Use in Physician Offices
Barbara B Okerson

PO02: The Absolute Nitty-Griddy of ODS Layout: Part I
Annette I Ladan

PO03: Selecting Variable Names into a Macro Variable Facilitates Data Analysis
Fenggang Peng

PO04: PUB_BIAS: A SAS Macro for Detecting Publication Bias in Meta-Analysis
Gianna M Rendina-Gobioff, Jeffrey D Kromrey

PO05: Hexadecimals in SAS: Have You Been Hexed?
Imelda C Go

PO06: MLM_SIM: A SAS Macro for the Statistical Investigation of Mixed Models
Jeffrey D Kromrey, James T Coraggio, Ha Phan, Jeanine Romano, Melinda Hess, Reginald Lee, Constance Hines, Stephen Luther

PO07: Creating Unique Digital Signatures Using CRC32 Standard
John C Fulda

PO08: A Relational Understanding of SDTM Tables
John R Gerlach, Glenn O’Brien

PO09: How to Implement the One-Time Methodology
Mark Tabladillo

PO10: SAS Programs to Select Controls for Matched Case-Control Studies
Robert Matthews, Ilene K Brill

PO11: SAS Programs for Extracting Data from LexisNexis Documents
Robert Matthews, Thomas Bender

PO12: A Case Study In Deploying SAS Programs on Unix Using Windows Based Tools
Samuel T Croker

PO13: Proc SQL, To Collapse Many-to-One Relationship
Tadesse Haileyesus

PO15: Tired of Typing? Got a Layout Definition with No Column Headers? Have WE Got a Fix For YOU!
Thom Clay, Jamila Ervin, Michele Laughlin, Toni Wiliamson

PO16: Creating RTF Tables with Univariate Analyses of Multiply Imputed Data
Marie G Gantz

PO17: Oracle’s RANK() Smells Good: Using RANK() in Pass-through Queries
Richard A DeVenezia

PO18: Potential Duplicate HIV/AIDS Patient Names Across States. A CDC Puzzle
Bikila bi Gwet

PO19: One Method for Improving Quality of Data in Longitudinal Study
Milorad Stojanovic, Ruth E Heuer

Simple But Clever

SC01: The TEMPLATE Procedure Styles: Evolution and Revolution
Kevin D Smith

SC02: Sudoku Puzzles – Using a Cube to Solve the Square
John R Gerlach

SC04: Six Cool Things You Can Do in Display Manager
Jenine Milum

SC05: The Pegboard Game: A Recursive SAS Macro Solution
Houliang Li

SC06: Sleepless in Wherever: Resolving Issues in Scheduled Jobs
Faron Kincheloe

SC07: Taking the Proc Summary a Step Beyond
Priya Suresh

SC08: See What You Are Missing: Finding Missing Data Records
Kim R Truett

SC09: %IFN – A Macro Function
Ian Whitlock, Chang Y Chung

SC10: Already Sorted? Make Good Use of It!
Paul M Dorfman, Lessia S Shajenko

SC11: Handling Dates in the Macro Facility
Toby A Dunn

SC13: Solving Jumble Puzzles: Dictionaries, Hashes and Permutations
Richard A DeVenezia

SC14: Controlling Macro Output or, “What Happens in the Macro, Stays in the Macro”
Frank DiIorio

SC15: An Annotated Guide: Using Proc Tabulate and Proc Summary to Validate SAS Code
Russell M Lavery

SC16: From Synapse to Syntax: a Panel Discussion on Problem Solving
Peter Eberhardt, Richard DeVenezia, Paul Dorfman, Ian Whitlock

SC18: Exploring SAS Generation Data Sets
Kirk P Lafler

SC19: How to Implement the SAS Data Step Hash Object
Bill Parman

SC20: Postcards From Camp ETL: A Manual For Surviving SAS ETL Studio
Alan R Mann

SC21: An Easy, Concise Way to Summarize Multiple PROC COMPAREs Using the SYSINFO Macro Variable
Lex S Fennell

Statistics, Data Mining and Data Analysis

ST01: The Design and Use of Metadata: Part Fine Art, Part Black Art
Frank DiIorio, Jeff Abolafia

ST02: Using SAS Enterprise Miner to Examine General Education Issues
Patricia B Cerrito

ST03: A Simulation Study of Sequential Testing Approaches in Genetics
Andres Azuero, David T Redden

ST04: Segmentation of Data Prior to Modeling
Gregg Weldon, Zidun He

ST05: They Asked for a Segmentation Scheme, Not Clusters
Jeff G Zeanah, Gary Huff

ST06: Gene Expression Profiling of DNA Microarray Data using Association rule and Structural Equation Modeling
Mussie Tesfamicael

ST07: Predictive Modeling To Analyze Hospital Charges Versus Reimbursements
Chakib Battioui

ST08: Individual Growth Analysis Using PROC MIXED
Maribeth Johnson

ST09: Application of the Generalized Linear Model to the Prediction of Lung Survival
Andrew D Karem

ST12: Combining PROC GENMOD Models with Multinomial Outcomes Using PROC MIANALYZE
Marie G Gantz

ST13: Modern Regression Analysis
Robert Cohen

ST14: Comparing Time series, Generalized Linear Models and Artificial Neural Network Models for Transactional Data Analysis
Joseph Twagilimana

ST15: Designing Information-Service Products: A Hierarchical Bayesian Approach
Nanting Chou, David D Steenhard

ST16: Data Mining of Dental Information
Christiana Petrou

ST17: Effect Modification Investigation Using SAS – A Model Building Exercise
Vanessa Bundy, Paule Barbeau, Maribeth H Johnson

ST18: Using Nominal Variables to Classifying College Enrollments
Arnold L Hook


TU01: %WINDOW: Get the Parameters the User Wants and You Need
Michael A Mace

TU02: ODS: Odious or Not
Janet E Stuelpner

TU03: How Do I Look it Up If I Cannot Spell It: An Introduction to SAS Dictionary Tables
Ilene Brill, Peter W Eberhardt

TU05: Demystifying the SAS Macro Facility – by Example
Harry J Droogendyk, Marje Fecht

TU06: SAS MACROS: Tips, Techniques, and Examples
Andrew M Traldi

TU07: Stars and Models: How to Build and Maintain Star Schemas Using SAS Data Integration Server in SAS 9
Johnny R Starling, Nancy Rausch

TU08: Exploring DICTIONARY Tables and SASHELP Views
Kirk P Lafler

TU09: My ODS – Real-World Uses of Modifying Table Templates
Steve James

TU10: Using SAS ODS to Extract and Merge Statistics from Multiple SAS Procedures
Stuart D Long, Jeff Abolafia, Lawrence Park

TU12: The New World of SAS: Programming with SAS Enterprise Guide
Chris J Hemedinger

TU13: How to Think Through the SAS DATA Step
Ian Whitlock

More results »