Search Results

Your search for paper sesug returned the following results.

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

JMP

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

Posters

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

Bonus

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

Posters

Running SAS on the Grid, Margaret Crevar

A Visual Approach to Monitoring Case Report Form Submission During Clinical Trials, Rebecca Horney

A Corporate SAS® Community of Support, Barbara Okerson

Do You Have Too Much Class?, Janet Willis

Using Macro to simplify to Calculate Multi-Rater Observation Agreement, Abbas Tavakoli

Mastering the Basics: Preventing Problems by Understanding How SAS® Works, Imelda Go

A SAS Users Guide to Regular Expressions When the Data Resides in Oracle, Kunal Agnihotri

Using Windows Batch Files to Sequentially Execute Sets of SAS Programs Efficiently, Matthew Psioda

SAS Programming tips and techniques for Data Mapping, Sheetal Nisal

PROC TTEST® (Old Friend), What Are You Trying to Tell Us?, Jeffrey Kromrey

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

JMP Analytics Applied in Diagnostic Radiology and Neurosurgery Trauma Research, Melvin Alexander

Evaluating Consumer Price Behavior Using JMP, Josh Klick

JMPing in: A SAS Programmer’s look at JMP, Barbara Okerson

Create compelling visualizations with geographic data and JMP 9, Jeff Perkinson

Making Your SAS Data JMP Through Hoops, Mira Shapiro

Posters

Practical Approaches to Counting in SAS: How to Get Started When You Don’t Know Where to Begin, Sharon Avrunin-Becker

MV_META: A SAS Macro for Multivariate Meta-Analysis, Julie Gloudemans, Corina Owens and Jeffery Kromrey

Using SAS to Streamline Periodic Reporting of Summary Statistics: Proc Format, Proc Freq, Proc Means,and Output Delivery System, Berwyn Gonzalvo

SoScatter Plots Using PROC SGPLOT for that Thursday Presentation, Sharon Hirabayashi

A Coding Practice for Preparing Adaptive Multistage Testing, Yung-chen Hsu

Using Dictionary Tables to Profile SAS Datasets, Phillip Julian

Using SAS to Ease the Proofing of Messy Text, Richard La Valley and Nat Wooding

A Macro to Change Windows Filenames, Daniel Levitt

Permutated-block randomization with varying block sizes using SAS Proc Plan, Lei Li

Business Intelligence and Analytics: Complements within a Decision Support Culture, Alan Mann, Emile Barnes and Albert Briggs

Proc CDISC: Implementation and Assessments, Sheetal Nisal and Shilpa Edupganti

Breastfeeding in Developing Countries: A Case Study of Nepalese Children/a>, Paerwen Paerhate

CI_MEDIATE: A SAS Macro for Computing Point and Interval Estimates of Effect Sizes Associated with Mediation Analysis, Thanh Pham, Eun Kyeng Baek, Merlande Petit-Bois and Jeffrey Kro

Coping with Job Loss, Dianne Rhodes

MISSING_ITEMS: A SAS Macro for Missing Data Imputation in Summative Response Scales, Patricia Rodriguez de Gil and Jeffrey Kromrey

Using SAS to Examine Aging Expectation (ERA-38) for Older Adults , Abbas Tavakoli and Julie Freelove-Charton

Using SAS GTL to Visualize Your Data when there is Too Much of it to Visualize, Perry Watts and Nate Derby

Time Series Regression: Using Proc GPLOT and Proc REG Together to Make One Great Graph, William Zupko

Does SAS Distance Measurement Differ from ArcGIS Distance Measurement?, Imam Xierali

Reporting and Information Visualization

Printable Spreadsheets Made Easy: Utilizing the SAS Excel XP Tagset, Rick Andrews

Graphing a Progression of Time Series Plots, Nate Derby, Laura Vo and Perry Watts

Introduction to ODS Graphics for the Non-Statistician, Mike Kalt

A PICTURE is Worth Alot of PUTS, Carol Martell

Quick and Dirty Formatted Excel Workbooks Without DDE or ODS, Andrea Wainwright-Zimmerman

Using SAS GTL to Visualize Your Data when there is Too Much of it to Visualize, Perry Watts and Nate Derby

SAS Code to Export and Create Pivot Tables in Excel 2007, Robert Williams

Statistics and Data Analysis

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

Eyes on the Road: A Methodology for Analyzing Complex Eye-Tracking Data, Mary Anne Bertola and Stacy Balk

Proc MIXED – Right Options to get Right Output, Shilpa Edupganti and Sheetal Nisal

Time Series Analysis: Separating Overlapping Events, M. Scott Elliott

Scatterplots: Basics, enhancements, problems and solutions, Peter Flom

Tailoring Logistic Regression Model Analyses with the ODDSRATIO Statement in PROC LOGISTIC, Taylor Lewis

Linear Logistic Test Model: Using SAS to Simulate the Decomposition of Item Difficulty by Algorithm, Sample Size, Cognitive Component and Time to Convergence, George MacDonald and Jeffrey Kromrey

Analysis of a Complex Survey Data, Varma Nadimpalli

PROC SURVEY Says!: Selecting and Analyzing Stratified Samples, Darryl Putnam

On Deck: SAS/STAT® 9.3, Robert Rodriguez

Acknowledging the Unknown: A SAS Macro for Investigating Omitted Variable Bias in Two-Level Linear Models, Jason Schoeneberger, Bethany Bell and Jeffrey Kromrey

Find Potential Fraud Leads Using Data Mining Techniques, Qiling Shi

Data Simulation for Evaluating Statistical Methods in SAS®, Rick Wicklin

Step by Step

Wandering Cross Reference Lines in PROC GPLOT, Sharon Avrunin-Becker

In Lockstep with the DoW-Loop, Paul Dorfman

Let’s Give’em Something to TOC About: Transforming the Table of Contents of Your PDF File, Bari Lawhorn

Introduction to SAS Macro Language, John Myers

Misquoting Jane Austen in the Name of Quality, Deborah Posner

Fuzzy matching – Is there a silver bullet?, Milorad Stojanovic

TWhy the Bell Tolls 108 times? Stepping Through Time with SAS, Peter Eberhardt and Yunbo (Jenny) Sun

A Step by Step Approach to Preparing for a SAS Intelligence Platform Environment Deployment/Migration, Brian Varney

href=”http://analytics.ncsu.edu/sesug/2011/SS15.Woodruff.pdf”>Keeping Up Appearances: Turning Specifications into SAS Format Libraries and Statements, Sarah Woodruff

Government and Health Care Apps

Healthcare Provider Cost Reporting Information System, Kim Andrews

Creating Correlated Variable Tables Dynamically, John Barrow and Aref Dajani

Macro Design and Usage in a Multi-Tier Architecture for ETL and Google Visualization API Integration, Manuel Figallo-Monge

Let SAS Do the Downloading: Using Macros to Generate FTP Script Files, Arthur Furnia

Fighting Fraud in a Pre-Payment Environment, Greg Henderson

ODS PDF and RTF application development , Benno Kurch and Shirish Nalavade

Development of a SAS Macro for Automated Data Cleaning of Major Outcomes of Interest in Hematopoietic Cell Transplantation, Peigang Li, Min Chen and Zhiwei Wang

Analysis of a Binary Outcome Variable Using the FREQ and LOGISTIC Procedures, Arthur Li

My annual reporting is requiring a full staff – Help!, Erin Lynch

A General-Purpose SAS Report Portal for the Web, Craig Ray

Assign Overpayment to Insurance Data with Adjustments, Qiling Shi

Automatization of Patient Characteristics Report/a>, Mirjana Stojanovic

Categorizing the Degradation State of Aircraft Generators using Rank Order Statistics and SAS CLUSTER Procedure, Tsung-hsun Tsai

Tips for Merging SAS/GRAPH® Output into Microsoft PowerPoint, Ferrell Drewry

Using SAS® to Create Custom Healthcare Graphics, Barbara Okerson


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

SAS® TIPS FOR INSTITUTIONAL RESEARCHERS TO TRACK STUDENT OUTCOMES EFFICIENTLY, Vijayalakshmi Sampath

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

Posters

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

TIPS AND TRICKS OF EFFICIENT SAS® PROGRAMMING FOR SDTM DATA, Eric Qi, Fikret Karahoda

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

Posters

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

Cornerstones

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

MPSF-077: NON LINEAR PROGRAMMING OF TIME SERIES DATA TO MINIMIZE EUTROPHICATION IN TRUCKEE RIVER, NEVADA
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

Posters

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

Posters

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

Serendipity

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

Tutorials

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

HW07: FORMAT FESTIVAL – An Introduction to SAS FORMATS and INFORMATS
David Maddox

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

Posters

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

Tutorials

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

Copyright Information

These Proceedings are the official record of the 13th Annual SouthEast SAS Users Group (SESUG) Conference held in Portsmouth, VA on October 23–25, 2005 at the Renaissance Hotel. 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 2005: The Proceedings of the SouthEast SAS Users Group, Portsmouth, VA, 2005

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

AD01-05: Everyone Trying to Update at the Same Time? Let’s Try the Source Control Manager! (SAS/AF Development Tool)
Larry Altmayer, U.S. Census Bureau, Washington, DC

AD02-05: So, Your Data are in Excel!
Ed Heaton, Westat

AD03-05: The Birth of an Information Delivery Portal at Briggs & Stratton
Sheryl Weise, WICS, Gastonia, NC

AD04-05: Systematic SAS Development, A Disciplined Approach
John W. Davison, Jr., Factotum, Inc., Leesburg, VA

AD05-05: Once Again on Efficiency and Base SAS
Milorad Stojanovic, RTI International

AD07-05: Ways to Store Macro Source Codes and How to Retrieve Them
Mirjana Stojanovic, Donna Hollis, Duke University Cancer Center Biostatistics

AD08-05: Using MS-ACCESS Metadata to Drive Automated SAS Data Processing
Gary N. Weeks, Centers for Disease Control, Atlanta, Georgia

AD09-05: Managing a Many to Many Merge using Formats, Direct Access, and Implied Hashing on Datasets Exceeding One Million Observations
Mark E. Asiala, Bureau of the Census, Washington, D.C.
John C. Gober Bureau of the Census, Washington, D.C.

AD10-05: SAS Macro Design Patterns
Mark Tabladillo Ph.D., MarkTab Consulting, Atlanta, GA
Associate Faculty, University of Phoenix

Coders’ Corner

CC01-05: Adding Web-Enabled Buttons to the SAS Tool Bar
John E. Bentley, Wachovia Bank, Charlotte NC

CC02-05: Question: How do I find out what that _TYPE_ value is from my PROC MEANS? Answer: the FINDTYPE Macro!
Dan Bruns, Chattanooga, TN

CC03-05: Tabulating Fractional Observations
Phil Busby, Live Data Systems, Inc. Apex, NC

CC04-05: The Functionality of Arithmetic SAS Functions for the CRO User
Phil d’Almada and Karen Graham, Rho, Inc.

CC05-05: Creating Zillions of Labels (and Other Documents) the Easy Way with ODS and Microsoft Word
Vincent Del Gobbo, SAS Institute Inc., Cary, NC

CC06-05: Building Reusable Programs as Includes or Macros
Ronald J. Fehd, SAS-L’s macro maven
Centers for Disease Control, and Prevention, Atlanta GA USA

CC07-05: What Do You Mean You Don’t Have SAS!!!?? Using the Power of the SAS Data Step to Create Cluster Scoring Code That Is Not Platform Dependent
Bill Hartley, M.S., Euro RSCG 4D Discovery, Glen Allen, VA

CC08-05: SAS Dating Tips – A Beginner’s Guide to SAS Dates
Erik S. Larsen, Independent Consultant

CC09-05: %CHECKDATA: An Enhanced Data Diagnostic Macro
John Stanmeyer, Trade Resources Company, Washington, D.C.

CC10-05: The Invisible Character Alt255 – Hidden Dragon Removing and Aligning Text in SAS Output
Eugene Tsykalov and Shi-Tao Yeh, GlaxoSmithKline, King of Prussia, PA

Data Presentation

DP01-05: Tips and Tricks: Using SAS/GRAPH Effectively
M. Darrell Massengill, SAS Institute, Cary, NC

DP02-05: Creating a Map within a Map with SAS/GRAPH
Barbara B. Okerson, Virginia Health Quality Center, Glen Allen, VA

DP03-05: ODS LAYOUT is Like an Onion
Rich Mays, University of Rochester Medical Center, Rochester, NY

DP04-05: A Gentle Introduction to the Powerful REPORT Procedure
Ben Cochran, The Bedford Group, Raleigh, NC

DP05-05: Is There an Art Historian in the County?
Keith J. Brown, UNC-Office of the President, Chapel Hill, NC

ETL

ETL01-05: Simplifying Existing Projects with Ideas from Data Warehousing
Rick Aster, Breakfast Communications Corporation, Paoli, PA

ETL02-05: The SQL Optimizer Project: _Method and _Tree in SAS 9.1
Russ Lavery, Numeric LLC, Chadds Ford, Pa

ETL03-05: Using SAS Enterprise ETL Server to Build a Data Warehouse: Focus on Student Enrollment Data
Evangeline Collado, University of Central Florida, Orlando, FL
M. Paige Borden, University of Central Florida, Orlando, FL

ETL04-05: RDBMS Sampling with SAS: Slow, Faster, Fastest
John E. Bentley, Wachovia Bank, Charlotte, NC

ETL05-05: Getting Started with SAS/Access for Oracle
F. Joseph Kelley, University of Georgia

ETL06-05: A Quick Tour of SAS ETL Studio to Build a Data Mart
Eric Rossland and Kari Richardson, SAS Institute, Cary, NC

Hands On Workshops

HOW01-05: How SAS Thinks
Neil Howard, Basking Ridge, NJ

HOW02-05: SAS 9 Programming Enhancements
Marje Fecht, Prowerk Consulting Ltd, Cape Coral, FL

HOW03-05: Five Ways to Create Macro Variables: A Short Introduction to the Macro Language
Arthur L. Carpenter, California Occidental Consultants, Oceanside, California

HOW04-05: SAS with Style: Creating your own ODS Style Template for RTF Output
Lauren Haworth, Genentech, Inc., South San Francisco, CA

HOW05-05: Moving Data and Analytical Results between SAS and Microsoft Office
Vincent Del Gobbo, SAS Institute Inc., Cary, NC

HOW06-05: A Gentle Introduction to Enterprise Guide 3.0
Ben Cochran, The Bedford Group, Raleigh, NC

HOW07-05: Using Dictionary Tables: An Introduction to SAS Metadata
Frank DiIorio, CodeCrafters Inc., Chapel Hill NC

Introduction to SAS

IN01-05: The SAS Data Step: Where Your Input Matters
Peter Eberhardt, Fernwood Consulting Group Inc., Toronto, ON, Canada

IN02-05: Formats, Informats and How to Program with Them
Ian Whitlock, Kennett Square, PA

IN03-05: A Tour of the SAS Reporting Toolbox
Frank DiIorio, CodeCrafters Inc., Chapel Hill NC

IN05-05: Preemptive DATA CLEANING: Techniques
Malachy J. Foley, Chapel Hill, NC

IN06-05: Summarizing Data with Base SAS PROCs
Deborah Babcock Buck, D. B. & P. Associates, Houston, TX

IN07-05: Manipulating Data: Elements of the DATA Step Language
Paul M. Dorfman, Independent SAS Consultant, Jacksonville, FL
Vyacheslav V. Tsiolko, Senior Reseracher, Institute of Physics, Kiev, Ukraine

IN08-05: Fun With Functions
Marje Fecht, Prowerk Consulting Ltd, Cape Coral, FL

IN09-05: The Program Data Vector As an Aid to DATA step Reasoning
Marianne Whitlock, Kennett Square, PA

Posters

PS01-05: A Snazzy Graph Featuring Five Variables, Axis Breaks, and Good Resolution
Rachel A. Baker, Savannah River National Laboratory, Aiken, SC
Anthony T. Baker, Westinghouse Savannah River Company, Aiken, SC

PS04-05: Emailing a SAS Report to Excel
Royce Claytor, Dominion Resources Services Inc.

PS05-05: Using SAS to Process Repeated Measures Data
Cyndie Gareleck, RAND Corporation
Terry Fain, RAND Corporation

PS06-05: Renaming SAS Variables
Imelda C. Go, South Carolina Department of Education, Columbia, SC

PS07-05: Robustness in Meta-analysis: A Macro for Computing Point Estimates and Confidence Intervals for Standardized Mean Differences and Cliff’s Delta
Kristine Y. Hogarty, Jeffrey D. Kromrey, John M. Ferron, Melinda R. Hess, and Constance V. Hines, University of South Florida, Tampa, FL

PS08-05: MXG DB2 – A Cookbook Approach
Juliana Hughes, Federated Systems Group, Inc. Mainframe Capacity Planning

PS09-05: The BEST. Message in the SASLOG
Andrew T. Kuligowski, Nielsen Media Research

PS10-05: “An Animated Guide: The Data Step Debugger”
Russell Lavery, Contractor for Numeric, LLC. Chadds Ford, PA

PS13-05: Using SAS/GRAPH GMAP to Enhance a Diabetes Wellness Campaign
Barbara B. Okerson, Virginia Health Quality Center, Glen Allen, VA

PS14-05: SAS Certification: Is it for You?
Sarbjit Rai, Genentech Inc., South San Francisco, CA

PS16-05: Macro Architecture in Pictures
Mark Tabladillo PhD, markTab Consulting, Atlanta, GA
Associate Faculty, University of Phoenix

PS17-05: Mapping an Exclusive Regular Expression Strategy
Mark Tabladillo PhD, markTab Consulting, Atlanta, GA
Associate Faculty, University of Phoenix

PS18-05: Funky Formats
Zeke Torres, 1016inc.com, Chicago, IL

Serendipity

SER01-05: Getting from What, to How, and Back to What —Recognizing and Measuring Professional Diversity. Or: The Other Side Of The SAS / IT Shop
Alan Mann, Principal Consultant, Skyline Solutions, Martinsburg, WV

SER02-05: Automated Excel-lent Validation
Janet Stuelpner, Left Hand Computing, Inc.

SER04-05: From Obscurity to Utility: APP Functions as Programming Tools
Paul Dorfman, Independent SAS Consultant, Jacksonville, FL, USA
Alexander A. Martchenko, STOPS Corp., Riga, Latvia

SER05-05: COPYGRID: Tracking Multi-Developer (and –Machine) Programs from Development to Production
Larry Altmayer, U.S. Census Bureau, Washington, DC

SER06-05: Laziness, Impatience, Hubris: Personality Traits of a Great Programmer
John E. Bentley, Wachovia Bank, Charlotte NC

SER07-05: Producing a Nonrefereed Professional Publication for SESUG or SUGI
Phil d’Almada, Rho, Inc., Chapel Hill, North Carolina

SER09-05: Using WEB Tools to Enhance Population Identification
Carol Martell, UNC Highway Safety Research Center, Chapel Hill, NC

SER10-05: Extracting Data from PDF Files
Nat Wooding, Dominion Virginia Power, Richmond, Virginia

SER11-05: Use a SAS Database Search Engine Instead of Writing a Program
Eugene Yeh, PharmaNet Inc., Cary, NC
Donovan Verrill, PharmaNet, Inc., Cary, NC

SER12-05: So You Want to Be a Manager? A Discussion On Issues to Consider Before Making a Career Move
Lauren Haworth, Genentech, Inc., South San Francisco, CA
Stephen M. Noga, Rho, Inc., Chapel Hill, NC
Andrew T. Kuligowski, Nielsen Media Research, Dunedin, FL

SER13-05: Hire Power
Neil Howard, Basking Ridge, NJ

SER14-05: Pruning the SASLOG – Digging into the Roots of NOTEs, WARNINGs, and ERRORs
Andrew T. Kuligowski, Nielsen Media Research

SER15-05: Tuning SAS 9 for Multiuser ETL Environments
Frank Bartucca, IBM Corporation, Austin, TX

Statistics and Analysis

SA01-05: SAS Code to Select the Best Multiple Linear Regression Model for Multivariate Data Using Information Criteria
Dennis J. Beal, Science Applications International Corporation, Oak Ridge, TN

SA02-05: Data Mining Methods to Examine Thousands of Possibilities in Categorical Data
Patricia B. Cerrito, University of Louisville, Louisville, KY

SA03-05: The Missing Link: Data Analysis with Missing Information
Venita DePuy, Duke Clinical Research Institute, Durham, NC

SA04-05: Statistical Shape Analysis with SAS
Katherine Gerber, University of Virginia, Charlottesville, VA

SA05-05: Using ODS to Perform Simulations on Statistics from SAS Procedures
Andrew A. Kramer, Ph.D., Cerner Corporation, Vienna, VA

SA06-05: Using PROC GENMOD for Loglinear Smoothing
Tim Moses and Alina A. von Davier, Educational Testing Service, Princeton, NJ

SA07-05: Clustering Analysis of Micro Array Data
John Schwarz, University of North Carolina, Chapel Hill, North Carolina

SA09-05: An Introduction to ODS for Statistical Graphics in SAS 9.1
Robert N. Rodriguez, SAS Institute Inc., Cary, North Carolina, USA

Tutorials

TU01-05: The Power of PROC FORMAT
Jonas V. Bilenas, JP Morgan Chase, Wilmington, DE

TU02-05: How Do I Look it Up If I Cannot Spell It: An Introduction to SAS Dictionary Tables
Peter Eberhardt, Fernwood Consulting Group Inc, Toronto, ON
Ilene Brill, University of Alabama at Birmingham, Birmingham, AL

TU03-05: An Introduction to the Simplicity and Power of SAS/Graph
Dan Bruns, Chattanooga, TN

TU04-05: Looking for a Date? A Tutorial on Using SAS Dates and Times
Arthur L. Carpenter, California Occidental Consultants

TU05-05: A SASautos Companion: Reusing Macros
Ronald Fehd, SAS-L’s macro maven,
Centers for Disease Control, and Prevention, Atlanta GA USA

TU06-05: MISSING VALUES: Everything You Ever Wanted to Know
Malachy J. Foley, Chapel Hill, NC

TU07-05: DATALINES and Sequential Files and CSV and HTML and More – Using INFILE and INPUT to Introduce External Data into the SAS System
Andrew T. Kuligowski, Nielsen Media Research

TU09-05: Proc SQL Tips and Techniques – How to get the most out of your queries
Kevin McGowan, Constella Group , Durham, NC
Brian Spruell, Constella Group, Durham, NC

TU10-05: Building Web Applications with SAS AppDev StudioTM 3.0
Frederick Pratter, Eastern Oregon University, La Grande, OR

TU11-05: Speaking Klingon: A translator’s guide to PROC TABULATE
Dianne Louise Rhodes, Westat, Rockville, Maryland

TU12-05: Proc Transpose or How to Turn It Around
Janet Stuelpner, Left Hand Computing, Inc.

TU13-05: Macro Bugs – How to Create, Avoid and Destroy Them
Ian Whitlock, Kennett Square, PA

Copyright Information

These Proceedings are the official record of the 12th Annual SouthEast SAS Users Group (SESUG) Conference held in Nashville, TN on October 31 – November 2, 2004 at the Loews Vanderbilt. 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 2004: The Proceedings of the SouthEast SAS Users Group, Nashville,TN, 2004

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

An Introduction to SAS/SHARE, By Example
Larry Altmayer

Software Testing Fundamentals—Concepts, Roles, and Terminology
John E. Bentley

Using SAS at SAS: The Mining of SAS Technical Support
Annette Sanders, Craig DeVault

Creating Meaningful Data from Web Logs Using Base SAS
Jenine Eason, Jerry Johannesen

Journeymen’s Tools: Two Macros — ProgList and PutMvars — to Show Calling Sequence and Parameters of Routines
Ronald Fehd

A Hiker’s Guide to Web Development
Steve James

A Quick and Dirty Query System using HTML, Proc SQL, and SAS IntrNet
Kevin McGowan

Building A SAS Application to Manage SAS Code
Phillip Michaels

Generate a Metadata for Analysis
Maria-Alexandra Paladines

SAS Macros: Tips, Techniques, and Examples
Andrew M. Traldi

Exceptional Exception Reports
Gary McQuown

Coders’ Corner

Tips of Installing SAS/IntrNet on Linux
Xiao (Michelle) Zhuang, Sharon Schiro

Journeymen’s Tools: The Writing for Reading and Reuse Program Header or Everything You Ever Wanted to Know About a Program but Were Afraid to Ask
Ronald Fehd

Merging: Avoid the Cones
Jessica Bonow

Transferring Your Mainframe SAS Programs to Your PC in Three Easy Steps
Michael A. Raithel

Tools to Transfer Data between SAS and Stata
Dan Blanchette

Quick and Easy Visualization of Longitudinal data with the WEBFRAME Graphics device
Kevin P. Delaney

Double Your Pleasure, Double Your Words…
David L. Cassell

Programmatic Handling of Varying Report Requirements
Jim Snider

Data Set Options – What Comes First
Jim Snider

Tip: How to Use a ‘quoted’ SAS Macro Variable to Select Observations
Gary Moore

Faster Flat File Testing
John E. Bentley

Using Acting Techniques to Create a Successful Presentation
Lois Levin

SAS Dating Tips – A Beginner’s Guide to SAS Dates
Erik S. Larsen

%WINDOW: SAS’ Diamond In the Rough
Alan Mann

Data Management

Using Different Methods for Accessing Non-SAS Data to Build and Incrementally Update That Data Warehouse
Ben Cochran

Methods of Storing SAS Data into Oracle Tables
Lois Levin

Using PROC COMPARE in a SAS/AF Application for Tracking Corrections made to SAS Datasets for a Clinical Trial
Emily A. Mixon, Karen B. Fowler

Building Efficient State Transition Diagrams from Charges, Collection and Call Detail Transactional Feeds
Brett C Peppe

Finding Needles in the Documentation Haystack
Susan Myers and David Smarrella

Sounding the Trumpet: Effective Failure Notification
Don Hopkins

Using SAS to Facilitate Data Comparisons
M. Rita Thissen, Elizabeth Heath

A Text Miner Analysis to Compare Internet and Medline Information about Allergy Medications
Chakib Battioui

To MDDB or not to MDDB – That is the question
Jeff Lessenberry

Data Presentation

Quality of Life Analysis for Patients Receiving Heart Implants
David Nfodjo , Christiana Petrou

A SAS Macro for Construction of Symbol Statements
James E. Blum

Using Dynamic Data Exchange to Customize Formatted Reports in Microsoft Excel
Dennis J. Beal

Statistical Analysis of Gene Expression Micro Arrays
John Schwarz

Automated Data Collection Using SAS and FTP
Phil Busby

Building a Web Based EIS for Data Analysis
Ed Confer

ODS, Proc GMAP and SAS/Intrnet: MAP Your Own Response Data
Lakshmi Pandey

Hands-On Workshops

Version 9 Programming Enhancements
Marje Fecht

Introduction to Proc SQL
Steven First

An Introduction to Macros
Deb Cassidy

Creating and Exploiting SAS Indexes
Michael A. Raithel

Version 9 ODS – Basics
Dana Rafiee

Moving Data and Analytical Results between SAS and Microsoft Office
Vincent DelGobbo

Introduction to SAS

The SAS Data Step: Where Your Input Matters
Peter Eberhardt

Why the DATA Step Does What It Does
Neil Howard

A Roadmap to SAS Documentation
Pat Moell, Sean Gargan

What’s That Note/Warning/Error Mean and How Do I Fix It?
Deb Cassidy

How to Incorporate Old SAS Data into a New DATA Step, or “What is S-M-U?”
Andrew T. Kuligowski

(In)Formats (In)Decently Exposed
Harry Droogendyk

When Bad Programs Happen to Good People: Shuffling, Shifting, and Structuring an Inherited SAS Program
Gary E. Schlegelmilch

Here’s the Data, Here’s the Report I Want – How Do I Get There?
Deborah Babcock Buck

The Utter Simplicity and Power of the TABULATE Procedure
Dan Bruns

Posters

P01: Doing More with SAS/GRAPH GMAP: A New Look at an Old Procedure
Barbara B. Okerson

P02: Matching SAS Data Sets: If at First You Don’t Succeed, Match, Match Again
Imelda C. Go

P03: Installing SAS/IntrNet on Windows and Linux
Xiao Zhuang, Sharon Schiro

P04: SAS-L: The Basics
F. Joseph Kelley

P05: The Evolution of a SAS/GRAPH Application
Jenine Eason

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

Serendipity

Methods for Minimizing Errors in Address Data
Milorad Stojanovic

Where’s The Match?
Jennifer L. Waller, Verna C. Brantley, Robert H. Podolsky

Array: Construction and Usage of Arrays of Macro Variables
Ronald Fehd

Avoiding Mouse Elbow
Malachy J. Foley

Cutting the SAS LOG Down to Size
Malachy J. Foley

Panel: Launching a Web Application
Mark Tabladillo PhD, Harry Droogendyk, Jenine Eason, Steve James, Crystal Vierhout

Fresh SAS Programming Tunes from Hashville
Paul Dorfman, Alexander A. Martchenko

Stata for the Struggling SAS Mind
Dan Blanchette

Tricks with the 4mat Procedure
Ben Cochran

SAS Add-In for Microsoft Office – Leveraging SAS Throughout the Organization from Microsoft Office
Jennifer Clegg, Stephen McDaniel

The Perks of PRX…
David L. Cassell

SAS Application for Human Health Risk Assessment for Hazardous Waste Combustion Facilities
Samuel E. Stinnette, Dennis J. Beal, Sharon K. Robers, Charles T. Hadden, Barney W. Cornaby

Bring the Data Warehouse to the Office with SAS Integration Technologies
Peter Eberhardt

A Different Approach to Learning SAS Software
Mirjana Stojanovic

Rules for Tools – The SAS Utility Primer
Frank DiIorio

Spatial Statistics Using the SAS Bridge for ESRI
Patricia B. Cerrito, Carol Hanchette, William Dakan, George Barnes, Robert Forbes


Statistics and Data Analysis

Binary Logistic Regression Model Optimization
Jerry Musial

A System to Calculate Market Value-at-Risk using SAS/IML and Oracle
George Rezek

Crossover Designs and Proc Mixed In SAS
Hossein N. Yarandi

Case Studies in Time Series
David A. Dickey

A Simulation Study to Evaluate ANOVA and GEE for Comparing Correlated Proportions with Missing Values
Mark S. Litaker, Daron G. Ferris

Using SAS to Make an Independent Assessment of Electronic Medical Records
Patricia B. Cerrito

Mixed Models Analysis of Microarray Experiments Using Pooled Error Estimates
Yuan Liu, James Blum

Structural Equation Modeling Assessing Micro Array Data
Mussie Tesfamicael

Taking it Home and Putting it into Practice
Diane Cunningham

Mixed Model Influence Diagnostics
Oliver Schabenberger

Tutorials

Eight Characteristics of a Successful Data Warehouse
Marty Brown

A Gentle Introduction to SAS/Graph Software
Ben Cochran

PICTURE Perfect: In depth look at the PICTURE format
Carry W. Croghan

An Overview of Non-parametric Tests in SAS: When, Why, and How
Paul A. Pappas, Venita DePuy

Case Studies in Time Series: Periodic Behavior and Related Issues
David A. Dickey

Dictionary Tables and Views: Essential Tools for Serious Applications
Frank DiIorio, Jeff Abolafia

SAS System Options are Your Friends
Edward Heaton

Losing the Fat: One Application’s Journey to the Internet
Jeff Lessenberry

Speaking Klingon: The Power of PROC TABULATE
Dianne Louise Rhodes

Pretty Dates All in a Row
Dianne Louise Rhodes

Toward Object-Oriented Macros in SAS
Mark Tabladillo

SAS Macro Design Issues
Ian Whitlock

A Second Look at SAS Macro Design Issues
Ian Whitlock

Copyright Information

These Proceedings are the official record of the 11th Annual SouthEast SAS Users Group (SESUG) Conference held in St. Pete Beach, FL on September 22-24, 2003 at the TradeWinds Island Grand 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 2003: The Proceedings of the SouthEast SAS Users Group, St Pete Beach, FL, 2003

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

Building Drill-down SAS Applications
Kirk Lafler, Charles Edwin Shipp

SAS System on Network Appliance
Darrell Suggs

The Revised NTP TDMS System
Gabriel Cano, Kevin McGowan, Jean Orelien

Developing and Deploying Java Applications Around SAS: What they didn’t tell you in class
Greg Barnes Nelson, Jeff Wright

The Dataset Attribute Family of Classes
Mark Tabladillo

A Hiker’s Guide to Web Development
Steve James

Bulletproofing and Knowledge Encapsulation in Statistical Macros
John K. Troxell

A Journeyman’s reference: The Writing for Reading SAS Style Sheet: Tricks, Traps, Tips, and Templates, from SAS-L Macro Maven
Ron Fehd

A Hybrid Modeling Platform to meet Basel II Analytics in Banking
Jeffery Morrision

Information System for State Trauma Advisory Committee – An application of SAS/IntrNet
Xiao Zhuang, Sharon Schiro

A Pinch of SAS, a Fraction of HTML, and a Touch of JavaScript Serve Up a Grand Recipe
Jonah P. Turner

SAS Macros are the Cure for Quality Control Pains
Gary McQuown

A Beginners Guide to Incorporating SAS Output into MS Office
Vincent Del Gobbo

ODS for Microsoft Excel
David Shamlin

Programming for Failure: When Programs Faw Down and Go Boom
Gary E. Schlegelmilch

Coders’ Corner

Musical Macros: A Soothing Solution for a Recurrent Data Step Headache
Phil D’Almada

Libname Start Your Engines
Janet E. Stuelpner

Spreading the News: Using System Options
Deb Cassidy

The Evolution of a Macro: Converting your SAS files to a Different Version
John C. Gober, Jana L. Smith, Debi Mullen

Create a Simple, Informative Summary from Proc T-Test Output
Jennifer Warner

How to Get What You Need, Part 1
Chris Toppe

How to Get What You Need, Part 2
Chris Toppe

Processing Large Lists of Variables and Parameters Using SAS Arrays and Macro Language
Eugene Tsykalov

Using the SAS system in Very Limited Time/Resource Environment
Milorad Stojanovich

Machine Reading of Warranty Claims for Classification
Robert McCurdy

SAS Dating Tips – A Beginner’s Guide to SAS Dates
Erik S. Larsen

Advantages of PROC SCORE
Mark Tabladillo

Using SAS Macro Language to Develop User-Written Functions
Deb Pine

A “Real” Drill-Down Graph
Jenine Eason

Data Management

New Technologies for Delivering Data to Internal and External Clients
Sigurd W. Hermansen

Data-driven Validation Rules: Custom Data Validation without Custom Programming
Don Hopkins

A Technique for Storing and Manipulating Incomplete Dates in a Single SAS Date Value
John Ingersoll

Checking Datasets before Submitting Code
Mark Tabladillo

Automated Testing and Real-time Event Management: An Enterprise Notification System
Greg Barnes Nelson, Danny Grasse

Demand for Analysis-Ready Data Sets: An Introduction to Banking and Credit Card Analytics
Bikila bi Gwet

PROC SQL: Why Use It When Simple IF THEN Statements Work?
Susan Myers, Inga Allred

Using DDE and SAS/Macro for Automated Excel Report Consolidation and Generation
Sandra Archer, Mengxi Li, Russell Denslow

Data Presentation

Special Education Practice and Policy: What Principals Know and Need to Know
Wendy Dickinson, Tanice Knopp, Janice Fauske

Pivoting Data. An Alternative to ACROSS Variables of the REPORT Procedure
Mr. Bikila (Kila) bi Gwet

Credit Card Portfolio Performance Assessment. A Case of Business Intelligence
Mr. Bikila (Kila) bi Gwet

SAS/Intrnet and Census Mapping: How Low Would You Like to Get?
Lakshmi Pandey, William Joseph Smith, David Sjoquist

Using SAS and Other Tools to Move an Institutional Research (IR) Office from Hardcopy Reporting to a Web-Based Environment
Sabrina L. Andrews, Evangeline Collado, Patricia Ramsey

Bookmarks, Links, and It Looks Great Printed Too, Come In and See What ODS PDF Can Do For You!
Kevin Delaney

Tedious Template Made Easy
Cindy Stroupe

Building a Web-based EIS for Data Analysis
Ed Confer

Introduction to SAS

Do You Want to Know a Secret (or Two)?
Chris Toppe

Working with SAS Date and Time Functions
Andrew Karp

A Gentle Introduction To SAS/GRAPH
Ben Cochran

Passing Along SAS Data – SET, MERGE, and UPDATE
Andrew T. Kuligowski

Posters

SAS to EXCEL: An Integrated Reporting System
Fran Cohen

UltraEdit–THE EDITOR for SAS Programming
Eugene Tsykalov

An Overview of SAS Certification and the Test Development Process
Linda Althouse, Marc Vaglio-Laurin

Tips for Running Simulations in SAS
Dave Dickey, Sandy Donaghy, Joy Smith

Dynamically Assigning TREPLAY Statements for Producing Multiple Plots Per Page
Alice Lail, Karen Wade

What is Missing in SAS?
Imelda Go

Creating an Intranet Toolbox of Selective Oracle Metadata
John C. Gober, Jana L. Smith, Debi Mullen

Data Acquisition Portal (DAP): Web Based Data Collection Application
Christina Carty, Linda Linzy, Norman Oals, Elizabeth Spence, Reuben Richards

Serendipity

Data Step Hieroglyphics – ?*)&:@|_%(}
Harry Droogendyk

SAS in the Office – IT Works
Peter Eberhardt

A Table-Driven ODS Macro
Diane E. Brown

Dynamic SAS Programming Techniques, or How NOT to Create Job Security
Suzanne McCoy, Steven Beakley

The Sublime Secrets of the SAS SQLheads
Sigurd W. Hermansen

“LAG with a WHERE” and other DATA Step Stories
Neil Howard

A Sampler of Code Techniques
Ian Whitlock

Using an Array as an IF Switch
Ed Heaton, Nazik Elgaddal

Pruning the SASLOG – Digging into the Roots of NOTEs, WARNINGs, and ERRORs
Andrew T. Kuligowski

Keeping Up With the FUN: New Functions in SAS 9
Deb Cassidy

Version 9 Data Migration: How to do it and know you’ve done it right
Diane Olson

That’s my Style
Himesh Patel, Jeff Cartier

Charting a Course through Your Data and Procedures: Bar, Flow, Gant, Histogram, Process, Pie and so many others
Gary McQuown

Easy and Simple Job Tracking
Phil Busby

Behind the Scenes at SAS-L
Joe Kelley

Statistics and Data Analysis

An Introduction to Genomics and SAS Scientific Discovery Solutions
Russ Wolfinger, Kristen Quinlan, Susan Flood

An Algorithm for Screening of Genes and Clusters from Microarray Experiments
James Blum

Management of CABG Patient Mortality Using SAS Logistic Regression by Cohorts: Age, Sex and Cleveland Clinic Defined Risk Factors, Five Years Of Data And Analysis Compressed Onto a 3 X 5 Pocket Guide
Lucinda Jenkins, Bing Dao Li, Mike Mueller, Steve Adzima

EFFECT_CI: A SAS Macro for Constructing Confidence Intervals Around Standardized Mean Differences
Melinda Hess, Jeffrey Kromrey

Using the SAS System to Construct n-Values Plots
Peter Wludyka, Amy Cox

Comparison of PROC MIXED and PROC GLM for Analysis of Repeated Measures Data
Hossein Yarandi

Too Many Choices! The IMPORTANCE of Rank-Ordering Independent Variables Prior to Exploratory Data Analysis
Gregg Weldon

Methods of Dealing with Values Below the Limit of Detection Using SAS
Carry Croghan, Peter Egeghy

A SAS Macro to Design Phase II Clinical Trials
Alan Cantor

Identifying Person Duplicates of Short Geographic Distance by Computer Matching
Vincent T. Mule

An Interactive Approach to Multiple Comparison Procedures
Peter Davis

METAPERM: A SAS Macro for Permutation Tests of Linear Models in Meta-analysis
Jeffrey D. Kromery, Kristine Y. Hogarty

An Analysis Tool for Reviewing Farm Economic Data Using SAS /AF
Van Johnson

Statistical Analysis of Genotype X Environment Interaction in Agricultural Research
K. Bondari

Missing Data Values: Analyzing their Effects on Rainfall Forecasts Using PROC EXPAND and the SAS Time-Series Forecasting System
Richard March

Preparing Data using SAS for Paired Sample Comparison in Epidemiology Research
Wei Zhao, Hua Li

Developing a Marketing Geographic Segmentation System Using SAS Software
Kellie M Poulin, Allison N. Freeman

Training and Professional Development

SAS’s Resources for Learning
Michele Ensor

Efficient Way to Learn SAS with Virtually No Cost
Mirjana Stojanovic

SAS Consultants: Sheep in Wolf’s Clothing
Gary McQuown

SAS Tip, An Affordable Alternative to Traditional SAS Training
Erin Christen

Ten Things I Wish I Knew Before I Became a SAS Software Consultant
Andrew Karp

So You Want to Write a Paper? That Paper about Writing a Paper
Dianne Rhodes

Tutorials

Dare to Compare – Tailoring PROC COMPARE Output
Maria Reiss

SAS Formats: Uses and Abuses
Carry Croghan

Am I Evil?: Proc Template Exposed!!!
Kevin Delaney

Greetings from the Edge – Using javaobj in DATA Step
Richard A. DeVenezia

Dictionary Tables: Essential Tools for Serious Applications
Frank DiIorio, Jeff Abolafia

Table Lookup By Direct Addressing: From V8 To V9
Paul Dorfman

A Peek at PROC DOCUMENT
Andrew H. Karp

An Animated Guide: Proc Report: The File Behind the Scenes
Russell Lavery

Contrasting Programming Techniques For Summarizing Voluminous SAS Output Using the SAS Output Delivery System(ODS)
Stuart Long, Lawrence P. Park

Getting What You Want Out Of A Many-to-Many Merge
Sonal R. Pathak, Shabnam Mehra

Using SAS and Other XML Tools Effectively
Scott E. Chapal

How Regular Expressions Really Work
Jack Shoemaker

How to Implement the One-Time Methodology
Mark Tabladillo

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

Excel Exposed: Using Dynamic Data Exchange to Extract Metadata from MS Excel Workbooks
Koen Vyverman

Creating a Compact Columnar Output with PROC REPORT
Walter R. Young

The Utter Simplicity and Power of the TABULATE Procedure
Dan Bruns

Copyright Information

These Proceedings are the official record of the 10th Annual SouthEast SAS Users Group (SESUG) Conference held in Savannah, GA on September 22 – 24, 2002 at the Savannah Grand Hyatt. 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 2002: The Proceedings of the SouthEast SAS Users Group, Savannah, GA, 2002

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

Handheld Computers for Data Entry: A Data Services Approach using Java and XML, Scott Chapal

A Programming Development Environment for SAS Programs, Tim Williams and Lee Walke

GoodsHound – Building Multi-Functional Web-Based Applications with SAS/IntrNet and JavaScript, Blake Sanders and Mikhail Gruzdev

The Value of SAS in Manufacturing, Eric Brinsfield

SAS High-speed Automated Reporting Queue – SHARQ, Eric Puhlman and Kasi Peek

Meta Data + HTML = Automated Status Reports, George DeMuth, Mike DeSpirito and Frank C. DiIorio

A Sample Delivery System for A Multi-Site Study Using SAS On A UNIX Platform, Gabriel Cano

(Web) Software Development: Best Practices for Developing Enterprise Applications, Greg Barnes Nelson and Danny Grasse

Integrating SAS Analytics with Microsoft-Based Desktop Applications, Jim Tarantino, Dr. Sam Yamamura and John Payne

Refactoring Design Patterns into a SAS Application, Mark Tabladillo, Ph.D.

Techniques for SAS Enabling Microsoft Office in a Cross-Platform Environment, Vincent DelGobbo

Bridging the Gap: From Spreadsheets to Websites, Mary K. Tucker and Maryanne Hope

Coders Corner

So Many Files, So Little Time to Type in all Their Names, Francis J. Kelley

Variable Cross-Referencing Macros – Tools for When Base SAS Isn’t Enough, Frank C. DiIorio 10

Adjusting Dates in a New Century, Malachy J. Foley

Simplifying SAS Security, Derek Morgan and Dr. Michael Province

SAS Completion Codes to Make Complex Programs Run Smoothly, Heidi Markovitz

Logicals From Libraries: Using Storage as a Bridge Between Sessions, Gary Schlegelmilch

Change Shape or Lose a Few: Data Set Reduction for Analysis, Philip J. d’Almada

Proc SQL and Data Cleaning, Felicita David

JMP Density Ellipse Script Code Made Easy, Charles E. Shipp and Kirk Paul Lafler

Data Management

Database Conversion: What about our programs?, John E. Bentley

Structure Approach Using MACRO Code, Allen J. Blackburn

Streamlining Data Extraction with SAS Made Easy with the Creation of a Centralized Code Repository, Gregory P. Fagan

Managing Multiple SAS/FSEDIT Data Entry with a SAS/AF Application for a Cohort Study, Emily A. Mixon and Karen B. Fowler

Data Verification and Consolidation of Files with Dynamic Code Generation using SAS Macro, Data Step Programming, and System Utilities, William Pierce

Mrs. Clean Tackles Dirty Data, Janet E. Stuelpner

Developing a Control Methodology for Customized Data Management and Processing, Mark Tabladillo, Ph.D.

Using SAS with a SQL Server Database, Rita Thissen, Yan C. Tang and Elizabeth Heath

Sprinting with SAS/Access, Howard Plemmons

Data Quality – The Fuel That Drives the Business Engine, Ron Agresta and Tony Fisher

Panel Discussion: Data Management – the Good, the Bad, and the Ugly, Fran Akridge and Bill Calvert

Graphics and Information Visualization

Using PROC GREPLAY With ANNOTATE Data Sets for Effective Multi-Panel Graphics, Walter T. Morgan

Using JMP to Develop a Model Specification for Daily Energy Consumption, Tom Fuchs

Focusing Healthcare Quality Improvement Dollars: Using SAS for Geographic Targeting, Barbara B. Okerson, Ph.D., Charlotte F. Carroll, M.S.

Enhancements to SAS/GRAPH in V9, Himesh Patel and Ravi Devarajan

No More Downloading – Using SAS/ODS to Create SAS Graphs and HTML Documents for OS/390 Systems, Patricia Wingfield

Posters

JMP Density Ellipses for Pharmaceutical Analysis, Charles E. Shipp and Kirk Paul Lafler

Contributed Using a RAM Disk to Speed up your Windows 2000, Erik H. Dilts

Using ODS to Capture Statistics from PROC GLM, Frank Roediger

Putting it Together (The Poster): A Data Set Joining Primer, Janet E. Stuelpner and Caroline Bahler

Missing Secrets, Robin Jones and Ian Whitlock

Generate Clinical Trial Randomization Plan in Graphic User Interface, Dr. Mark Carpenter and Sijian Zhang

Using Decision Trees to Identify Medicare Part B Providers for Audit, Noel N. McKetty and Dr. Donna Mohr

Alternatives to SAS IF-THEN/ELSE Processing, Imelda C. Go, Ph.D.

Reordering Variables in a SAS Data Set, Imelda C. Go, Ph.D.

Statistics, Modelling, & Data Mining

Analysis of Dosage-Response Data in Agricultural Research, Dr. Khorsand Bondari

A SAS Program for the Computation of the Crude, Stratified and Mantel-Haenszel Odds Ratio in Case-Control Study Data Analysis of Nx2xK tables, Ilene Brill and Dr. Fabio Barbone

Variance Estimates for Census 2000 using SAS/IML Software, Peter Davis

Research Across Multiple Systems: Probabilistic population Estimation (PPE), Diane Haynes, Shabnam Mehra and Rebecca Larsen, M.S.P.H.

FDR_TEST: A SAS Macro for Calculating New Methods of Error Control in Multiple Hypothesis Testing, Dr. Jeffrey D. Kromrey and Kristine Y. Hogarty

Comparison of Correlated Proportions using SAS PROC GLM: a Simulation Study, Dr. Mark S. Litaker and Dr. Daron G. Ferris

Automated Summarization of Risk Assessment of Discrete and Continuous Exposures in Epidemiological Studies using SAS ODS, Stuart Long and Rebecca Darden

Projecting South Florida County-Level Citrus Acreage Using Time-Series Analysis (SAS Automatic Forecasting System) and Multivariate Analysis (PROC FACTOR), Dr. Richard A. March

SAS Programs for Adding Functionality to the Occupational Mortality Analysis Program (OCMAP) Software, Robert Matthews and Dr. David Brown

Using a SAS IML Nonlinear Programming Procedure to Determine a Single Uniform Weighting Scheme for a Complex Survey Design, Richard A. Moore, Jr.

Using SAS to Estimate Variance by the Jackknife Method, Thomas Mule

A Macro for Computing a Goodness of Fit Statistic for Linear Mixed Models, Jean G. Orelien

The Lag-o-Matic: An Improved Method for Selecting Lag Structure of Multiple Predictor Variables in the Absence of Theory, Dr. David Sharp and Stephen Finnigan

Managing Missing Data with Multiple Imputation using PROC MI in SAS, Dr. Hossein N. Yarandi

Basic Usage of SAS/ETS Software to Forecast a Time Series, LTC Douglas McAllaster

Using SAS to Control Multistream Binomial Processes with a Chi-Squared Control Chart, Peter Wlydyka, Dan Cavey and Brett Friedlin

The New SAS Power and Sample Size Web Applications, Wayne Watson

Training and Professional Development

Programming Standards for Base SAS and SAS Macros, Devi Sekar

Take a Job or Consult: In Search of Greener Grass, Chris Toppe, Ph.D.

SAS Consultants: Sheep in Wolf’s Clothing, Gary M. McQuown

A Journeymans Reference: The Writing for Reuse SAS Style Sheet: Tricks, Traps, Tips, and Templates from SAS-Ls Macro Maven, Ron Ronald. Fehd

High Energy SAS – Managing the SAS Community in a Large Corporation, Jim Alessio and Mark Jordan

Tutorials

Output Delivery System Tips, Kirk Paul Lafler

Web Application Architecture: Choosing the right tools for the project, Eric Brinsfield

Sharing your Tips and Tricks with Others: Give Your Toolbox a Web Presence, John C. Gober

The Magnificent DO, Paul Dorfman

DATA Step Essentials, Neil Howard

The Ugliest Data I’ve Ever Met, Derek Morgan

Customized Reports – Have It Your Way!, Deb Cassidy

Don’t Be a Slave to Your SAS Programs, Marje Fecht and Larry Stewart

Program Comprehension: A Strategy for the Bewildered, Frank C. DiIorio

Putting it Together (The Tutorial): A Data Set Joining Primer, Janet E. Stuelpner and Caroline Bahler

The SAS Debugging Primer, Frank C. DiIorio

Bulletproofing and Knowledge Encapsulation in Statistical Macros, John K. Troxell

Macros: Tips, Techniques, and Examples, Andrew M. Traldi

SAS Software Macros–You’re Only Limited by Your Imagination, Part II; More Advanced Techniques, Peter Parker

SAS Macro Design Issues, Ian Whitlock

PROC FORMAT in ACTION, Jack N. Shoemaker

Here’s the Data, Here’s the Report I Want – How Do I Get There?, Deborah B. Buck

Proc Means and Summary: A Beginners Guide, Gary M. McQuown and Andrew H. Karp

The Power of PROC DATASETS, Lisa Davis

MERGING: Comparing the Data Step with SQL, Malachy J. Foley

Problem Solving Techniques with SQL, Kirk Paul Lafler

Multiple Uses for a Simple SQL Procedure, Rebecca Larsen, M.S.P.H.

Structured Query Language: Logic, Structure, and Syntax, Sigurd W. Hermansen

Vertical Solutions

Using Strategic Performance Management to Create Balanced Scorecards in a Healthcare Environment, Ben Cochran

Performance Management: Communicating the Results, Barrett Joyner and Greg Barnes Nelson

The Smart Courier for Healthcare, Diane E. Brown

Strategic Procurement: The SAS Solution for Supplier Relationship Management, Fritz Lehman

Copyright Information

These Proceedings are the official record of the 8th Annual SouthEast SAS Users Group (SESUG) Conference held in Charlotte, NC on October 14 – 17, 2000 at the Adams Mark. 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 2000: The Proceedings of the SouthEast SAS Users Group, Charlotte, NC, 2000

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

Advanced Tutorials

A Join for All Seasons, Caroline Bahler

XML and SAS: An Advanced Tutorial, Greg Barnes Nelson

The Utter “Simplicity?” of the TABULATE Procedure-The Final Chapter?, Dan Bruns

Writing the “Best” Program: The How and When of Efficient Programming, Frank DiIorio

Table Lookup via Direct Addressing: Key-Indexing, Bitmapping, Hashing, Paul M. Dorfman

DATA CLEANING: Preemptive Techniques, Mal Foley

Integrity Constraints and Audit Trails Working Together, Gary Franklin

You CAN Get There from Here (and Back Again): Adding Hot-link Drill-down Capabilities to ODS HTML Output, Ray Pass

Data Mining: An Overview of Methods and Technologies for Increasing Profits in Direct Marketing, C. Olivia Rud

Data Structure Determines Programming Effort, Ian Whitlock

Applications Development

Accessing FPL’s Data Warehouse Using SAS/ACCESS SQL Procedure Pass-Through Facility, Guillermo (Bill) Anton

Using DDE with Microsoft EXCEL and SAS to Collect Data from Hundreds of Users, Russell Denslow and Yan Li

Organizing Ultra-Quick Disk Table Lookup via Hybrid Indexing into a Directly Addressed SAS Data Set, Paul M. Dorfman

Using SAS/AF to Create Applications for Looking Up and Coding Adverse Events and Generic Drug Names in Clinical Trials, Karen B. Fowler and Emily A. Mixon

The Use of SAS in Revenue Management and Related Applications at ANC Rental Corporation, Chi Ip

The Dead Go Live! Injury Mortality Data via an Interactive Web-Application, Stephen P. James

SAS Macros Are the Cure for Quality Control Pains: Implementing a Macro Driven Evaluation of Survey Data for Quality Control, Gary M McQuown

A SAS/AF Application for Linking Demographic & Laboratory Data for Participants in Clinical & Epidemiologic Research Studies, Emily A. Mixon and Karen B. Fowler

Put Your Reports on the Web!!, Jim Nash

I’ll Have the TABULATEs a la ODS Please, With a Table of Contents On the Side, Ray Pass

Workflow on the Web: Using SAS/IntrNet to build an application for Dynamic Web Reporting, Deborah K. Pine and Gregory S. Barnes Nelson

A High-Level Summary Table Generation Language Supplying the Missing Link Between PROC MEANS Using a CLASS Statement and PROC TABULATE, Dorothy Pugh

Walk Our Children to School: An Internet Data Management Application, Carol A. Martell

Beginning Tutorials

Meta Data – Everyone Talks About It, but What Is It?, John E. Bentley

Here’s the Data, Here’s the Report I Want – How Do I Get There?, Debbie Buck

The Power of PROC DATASETS, Lisa M. Davis

You Could Look It Up: An Introduction to SASHELP Dictionary Views, Michael L. Davis

Introduction in Efficient SAS Programming via Incremental Refinement by Example, Paul M. Dorfman

Customize Your SAS Output with the Template Procedure: A Beginning Tutorial, Carol Gosselin and Joy Munk Smith

How to Incorporate Old SAS Data into a new DATA Step, or “What is S-M-U?”, Andrew T. Kuligowski

SAS Software Macros – You’re Only Limited by Your Imagination, Peter Parker

How to Use the Data Step Debugger, S. David Riba

Static SAS Web Publishing (SAS/IntrNet @ Social Work), Roderick A. Rose

SAS as a Utility Language: Using SAS for Solving Little Problems, Gary E. Schlegelmich

Ten Things You Should Know about PROC FORMAT, Jack N. Shoemaker

Maps: Where We Were and Where We Are, Clara L. Waterman

Coder’s Corner

%XTAB2HTM: Macro Using ODS to Convert PROC FREQ Cross-tabulation to HTML with a Table of Contents and Back Buttons, Ron Fehd

The Variable List Wildcard Character, Mal Foley

Mailing List Management, Imelda C. Go

Random Sample Selection, Imelda C. Go

Using SAS to Write SAS – Automate Your Programming Tasks, Pam Reading

Web-Application Bar-Charts without SAS/Graph, Steve James

Add Common Look and Feel to Your Web Applications Easily, Steve James

Generating a Table of Seeds for Random Number Generator, F. Joseph Kelley

A Macro to Center Text in a DATA _NULL_ Step, Erik S. Larsen

Using Proc Compare for Data Reliability, Sharon Stroud

Macro Design Considerations for a Word Wrapping Macro, Ian Whitlock

A Robust Generalized Axis-scaling SAS Macro, Dorothy E. Pugh

Panel Discussion on Problem Solving, Steve Noga, Frank C. DiIorio, Paul M. Dorfman, Ian Whitlock

Emerging Technologies

Using Data Mining Technology to Identify and Prioritize Emerging Opportunities for Mortgage Lending to Homeownership-Deficient Communities, Clark R. Abrahams, Frank R. Burnett and Jin-Whan Jung

Emerging Technologies Roadmap – A Decision Tree Guide to Understanding SAS Strengths, Greg Barnes Nelson and Eric Brinsfield

Extending the Data Warehouse: An Introduction to OLE DB, S. David Riba

Enterprise Integration Technologies – What is it, and What can it do for me?, Scott Vodicka

Information Visualization

ABC’s of Graphs in Version 8, Caroline Bahler

Dead Graphs – RIP (How Interactive Graphical EDA Techniques Can Markedly Enhance the Analysis/Display of Our Data), Dave DesJardins

Identifying Time Series Models, David A. Dickey

Using JMP version 4 Time Series Features to Analyze Passenger Demand Data and Closing Stock Prices, Bill Gjertsen

Laptop Demo of a “Browseable” Statistical Package, John Iwaniszek and George DeMuth

Data Mining Beyond the Observable: Underlying Construct Analysis (UCA), Alvin L. Killough, Donald W. Drewes and Christopher L. Edwards

A Dynamic Imagemap Generator, Carol A. Martell

Professional Development and User Support

Test Development: Ten Steps to a Valid and Reliable Certification Exam, Linda A. Althouse

Effective SAS User Support: Utilize the Power of the Intranet, Lisa Davis

Teaching SAS Web Publishing in a Web Environment, Roderick Rose and Sally Muller

How to Get the Online Information You Need: An Overview of “What’s Where” for SAS System Help, SAS Online Doc, SAS Online Tutor, and the Web, Judi Rourke-O’Briant

SAS Solutions

Implementing a Balanced Scorecard Solution on Top of SAP, using CFO Vision as an Interface, Christ D’haeveloose

Using SAS/IntrNet to Track the Impact of Welfare Reform in North Carolina, Dean F. Duncan, Kimberly A. Flair, Rosemary D. Hallberg, Sally S. Muller and Hye-Chung (Monica) Kum

Building Systems of Macros: The Print System and The Macro Reporting System (MRS), John Iwaniszek and George DeMuth

Integrating SAS in Corporate IT, John M. LaBore and Thomas H. Burger

Positioning SAS for Corporate Effectiveness, John M. LaBore and Thomas H. Burger

SAS & HEDIS: An Introductory Overview, Christopher J. Plummer

The Power of Hybrid OLAP in a Multidimensional World, Ann Weinberger

Statistics

A SAS Program for the Computation of Seroconversion Rates in a Prospective Study of HIV Discordant Couples in Lusaka, Zambia, Ilene Brill, Maurizio Macaluso, Susan Allen and Jareen K. Meinzen-Derr

SAS IML Code To Calculate an Upper Confidence Limit for Multivariate Statistical Distance, Margaret Connolly

Performing Exact Logistic Regression with the SAS System, Bob Derr

Computing the Approximate and Exact Leaving-One-Out Method in Multiple Group Logistic Discrimination with the SAS System, Mohamed H. Hussein

Macro in Scoring, Jukui Yi

Exploratory Data Analysis using PROC UNIVARIATE, Robert Maitland

Computation of p-values for Multiple Comparisons with a Control in the SAS System, Jean G. Orelien

Can A New Interpretation Of Survival Data Help Patients Successfully Modify Adverse Risk Profiles?, Gregory L. Pearce

Using The SAS System To Examine The Effect Of Augmentation On The Inter-Rater Reliability Of Holistic Ratings, Jim Penny, Robert L. Johnson and Belita Gordon

Using The SAS System To Examine The Reliability Of The Retrospective Measure Of Change, Jim Penny, Jennifer Martineau and Robert L. Johnson

Using the SAS System and QSR NUD*IST for Qualitative Data Analysis (QDA), Robert G. Stewart

Using SAS to Perform Robust I-Sample Analysis of Means Type Randomization Tests for Variances, Peter S. Wludyka

System’s Architecture

Multi-Process Connect; What, When, Where, How, and Why, John E. Bentley

Think Thin 2-D: “Reduced Structure” Database Architecture, Sigurd W. Hermansen

You can do THAT with SAS Software? – Using the Socket Access Method to Unite SAS with the Internet, David L. Ward

Copyright Information

These Proceedings are the official record of the 9th Annual SouthEast SAS Users Group (SESUG) Conference held in New Orleans, LA on September 22 – 24, 2001 at the Intercontinental. 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:

SSU 2001: Proceedings of the Southern SAS Users Group Conference New Orleans, LA, 2001

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

Data Warehousing

Producing Multipurpose Metadata for Data Quality, Trending, and a Data Dictionary
John Bentley

Simplified Software Project Management for the Rest of Us Or a Twelve Step Program for the Chronically Overworked Programmer, Project Leader or Manager
Tom Mannigel

A Scorecard Approach to Improving Data Quality
Robert Phelps, Phil Nousak

Data Warehousing – Lessons Learned
Fran Akridge

Biotech Warehouse – Stretching the Limit of Columns
Larry Bramblett

Use of SAS/ETS and the BLS-Census Data Ferret for the Comprehensive Everglades Restoration Program
Dr. Richard March

Data Quality — Spinning Straw into Gold
Bob Brauer

Using the SAS ACCESS Engine for DB2 OS/390 to Bulk Load Tables
Robert Maitland Jr., Tom Weber, George Bischoff

Using the SAS/Access Libname Technology to Get Improvements in Performance and Optimizations in SAS/SQL Queries
Fred Levine

Emerging Technologies

All I Really Want… A Wish List for New SAS Software Enhancements
Peter Parker

Version 9: Scaling the Future
Diane Olson, Robert Ra

Avoiding eOverload: Personalizing Web Content through Security, eIntelligence and Data Mining
Greg Barnes Nelson

Knowledge Management Using an Expert System Written in SAS
Anthony Dymond

SAS and Electronic Mail: Send e-mail Faster, and DEFINITELY More Efficiently
Roy Fleischer

Advantages and Disadvantages of Using MDDBs, HOLAP, EIS, and SAS/IntrNet in the Development of an Interactive System
Lori Guido, Richard Denby

Integrating SAS/Connect with Java
John LaBore, Randy Curnutt, Michael J. Pell

WAP Enabling SAS Applications
S. David Riba

Hands On Workshops

Who Needs To Know Program Syntax When You Have Enterprise Guide?

Basic Macro Processing

Version 8 ODS (Output Delivery System)

SQL Processing

Running SAS Applications on the Web

Creating Java Based Applications

Reading and Writing Data from Microsoft Excel/Word Using DDE

Interactive PROC Report

Graphing in SAS Software

Internet, Intranet and the Web

HTML for the SAS Programmer
Lauren Haworth

Delivering Information Everywhere using JSP and SAS
Pat Herbert, Bryan Boone

Using SAS/INTRNET Software
Kevin Davidson

Building a SAS Intranet Site
Tim Williams

Sounds Like a Good Idea, But What’s the ROI?
John Bentley

Web-Intelligence: A Primer
Don Henderson, Ralph Mittl

Case Studies in Data Management on the Web
Carol Martell

Using the SOCKET Access Method to Invoke SAS Programs
Rick Langston

Obtaining and Using Euro Currency Rates in SAS Programs
Rick Langston

A SAS-Based Approach to WEB-Based Surveys
Bernard Poisson

Avoiding Entanglements – Migrating Applications to the Web
Eric Brinsfield

Delivering OLAP Solutions to the Web
Tammy Gagliano, Tony Prier

WebHound: Your Best Friend for Web Traffic Analysis
Dean Duncan, Frank Lieble, Sally Muller, Carol Martell

Energizing End Users with a Slice of SAS and a Cup of Java
John LaBore, Randy Curnutt, Michael J. Pell

The Role of SAS/Intrnet in a Web-Enabled Database System
John Copeland, David W. King, Paul C. Gangarosa

The Beauty of OUT2HTM with Proc Report
David Steves

Web Based Report Ordering Combined with Base/SAS Mainframe Batch Processing
Andre Brainard

A Generic Solution to Running the SAS System on the Web without SAS/Intrnet
David Ward

Introduction to SAS

Introduction to the SAS Programming Language
Thomas Winn

The INPUT Statement: Where It’s @
Ron Cody

Manipulating Data: Elements of the DATA Step Language
Paul Dorfman

Passing Along SAS Data: SET, MERGE, and UPDATE
Andrew T. Kuligowski

Understanding and Using Functions
Frank DiIorio

Basic SAS PROCedures for Generating Quick Results
Kirk Lafler

Formats, Informats and How to Program with Them
Ian Whitlock

What’s Next?
Thomas J. Winn

Posters

Cubes on the Cheap
Jimmy DeFoor

Transforming Single Record Spreadsheet Data into Multiple Observations
Glenda Garner

Generating Matched Case Data Using PROC SQL
Imelda Go

Overcoming the Challenges of Longitudinal Data Collection
Imelda Go

Defining Test Data Using Population Analysis
Clarence W. Jackson

Web-Application Bar Charts without SAS/GRAPH
Steve James

Bootstrapping a Multidimensional Preference Analysis
E. Barry Moser, Xiaoming Liang

Detecting Anomalies in Your Data Using Benford’s Law
Curtis Smith

How American Express Saved $1M in CPU charges
Hermes Villalobos

Avoiding a (Graphic) Identity Crisis with ODS HTML Styles
Jaclyn Whitehorn

Implementing Digital Analysis Using SAS
Thomas J. Winn, Jr.

SAS Solutions and Vertical Products

OLAP Best Practices: What You Need to Consider When Building and Deploying an OLAP Application
Greg Henderson

Use of SAS/AF V8e to Compare Death Certificate Data with Health Survey Data from the National Center for Health Statistics
Gretchen Jones, Sandra T. Rothwell, Christine S. Cox

Creating Visit Specific CRF Checklists for a Longitudinal Study Using a SAS/AF Application
Emily Mixon, Karen B. Fowler

Supplier Management with SAS Supply Chain Solutions
Ed Hughes

Florida Community College System – Putting Minds to Work
Jeanette Humphrey, Howard Campbell, Brian Walsh

Using Recursion in the SAS System
David Ward

Creating Student Academic Profiles
Janice McBee

Sending E-mail From a Mainframe Using SAS in an MVS Environment
Michelle Gillespie, Douglas A. Pacas

Using SAS to Create Presentation Quality Spreadsheets in Excel
Joyce Hartley

V6 to V8 Applications: To Web or Not to Web?
Sharon Muha, Elizabeth Malcom

Point and Click Web Pages with Design-Time Controls and SAS/IntrNet Software
Vincent DelGobbo, John Leveille

AppDev Studio Release 2.0
Carl LaChapelle

A Modular Approach to Portable Programming
Michael Litzsinger, Lisa Brooks

OOP Needs OOA and OOD
Andrew Ratcliffe

Optimizing Data Extraction from Oracle Tables
Caroline Bahler

Serendipity

Elegant Tables: Dressing up your TABULATE Results
Lauren Haworth

Creating Adobe PDF Files From SAS Graph Output
Patrick McGown

Behind the Scenes at SAS-L
Francis J. Kelley

Dynamically Instantiating Widgets on SAS Frames: Why, How, and When
David Ward

Proc Format, a Speedy Alternative to Sort/Merge
Jenine Eason

Using the SAS Annotate Facility for Creating Custom Graphs
Patrick McGown

An Assembler Written in SAS
Ed Heaton

A Couple of Tasty SAS Programming Tunes
Paul Dorfman

Problem Solving Techniques with SQL
Kirk Lafler

Functional Functions
Gary McQuown, Dorothy Brown

Creating Regional Maps with Drill-Down Capabilities
Deb Cassidy

Structuring Base SAS for Easy Maintenance
Gary Schlegelmilch

Taming the Chaos: Managing Large SAS/AF Applications Using Programming Standards and the Source Control Manager of Version 8 of the SAS System
C. Michael Whitney

Debugging Made Easy
Andrew Ratcliffe

Statistics and Data Analysis

Modeling Data with Nonparametric Methods Using SAS Software
Robert Cohen, Dong Xiang

Individual Growth Analysis Using PROC MIXED
Maribeth Johnson

Power and Sample Size Determination for Linear Models
John Castelloe, Ralph G. O’Brien

Using the SAS System to Estimate Sample Size Requirements for Small Sample Confidence Intervals
Jim Penny

Optimal Solution of Discrete Resource Allocation Problems with SAS/OR Software
LTC Douglas McAllaster

A Confidence Interval Approach to Gene Chip Analysis
Jennifer Waller, Mark G. Anderson

The Output Delivery System for Data Analysis
Randy Tobias

Customizing Statistical Reports Using ODS and Proc Template
Joy Munk Smith, Sandra B. Donaghy

Getting Started with PROC LOGISTIC
Andrew Karp

Ideas on Variable Selection and Alternative Links in Procedure CATMOD
Kimberly DeJarnatt, James E. Dunn

Using the SAS System to Study the Gender and Level Measurement Equivalence of a Multi-rater Survey
Jim Penny

Using the SAS System to Demonstrate the Equivalence of On-line and On-paper Survey Administration across Levels of Raters
Jim Penny

Using SAS to Control Multistream Binomial Pocesses
Peter Wludyka, Sheri Jacobs

2001: A SAS/STAT Odyssey
Maura Stokes

A Simulation Study to Compare the Performance of Permutation Tests for Time by Group Interaction in an Unbalanced Repeated-Measures Design, Using Two Permutation Schemes
Mark Litaker, Bernard Gutin

Heel Ultrasound As A Predictor of Appendicular Bone Mineral Density
Rebecca Frederick, E. Barry Moser, Ellen R. Brooks

Survey Estimates and Variance Estimation Using the SURVEYMEANS Procedure
Hossein Yarandi, Shawn J. Kneipp

Bootstrapping the Levene Test for Equality of Variances
Robert Stewart

Tutorials

Conversion of SUDAAN Output into Publication-Quality Tables–A Simplified Approach
Charlotte Gard

ODS, YES! Odious, NO! – An Intro to the SAS Output Delivery System.
Lara Bryant, Sally Muller, Ray Pass

Changes & Enhancements for ODS by Example (through Version 8.2)
Sandy McNeill, David Kelley

SAS on the Web: How do I get There from Here?
Carol Martell, Ruth Marinshaw, Eric A. Rodgman

XML and SAS: An Advanced Tutorial
Greg Barnes Nelson

Multiprocessing with Version 8 of the SAS System
Cheryl Doninger

The Metamorphosis of a Study Design
Marge Scerbo, Craig Dickstein

Introduction to the SAS Macro Language
Thomas J. Winn

A Beginners Tour of a Project using SAS Macros Led by SAS-L’s Macro Maven
Ronald Fehd

Are Strings Tying You in Knots?
Deb Cassidy

INVALID: a Data Review Macro Using Proc FORMAT Option Other=INVALID to Identify and List Outliers
Ronald Fehd

Advanced Macro Topics
Steve First

Top-Down Programming with SAS Macros
Ed Heaton

The Power of PROC DATASETS
Lisa Davis

Evaluating the Use of Enterprise Guide in Introductory Statistics Classes
Sandra B. Donaghy, Joy Munk Smith

Fuzzy Key Linkage: Robust Data Mining Methods for Real Databases
Sigurd Hermansen

Point, Set, Match (Merge) – A Beginners Lesson
Jennifer Hoff Lindquist

Data Cleaning and Base SAS Functions
Caroline Bahler

PROC REPORT: How to Get Started
Malachy Foley

Direct Addressing Techniques of Table Look-Up: I Key-Indexing and Bitmapping; II Hashing
Paul Dorfman

Advanced Methods to Introduce External Data into the SAS System
Andrew T. Kuligowski

Rev Up Your Spreadsheets With Some V8 Power
Peter Eberhardt

Using Functions and Arrays in the SAS System to Manage and Manipulate Data
Ben Cochran

Changes and Enhancements to PROC MEANS in Version 8 of the SAS System
Andrew H. Karp

Anyone Can Learn PROC TABULATE
Lauren Haworth

The Utter Simplicity of the TABULATE Procedure – The Final Chapter?
Dan Bruns

ODS for PRINT, REPORT, and TABULATE
Lauren Haworth

PROC SQL – Is it a Required Tool for Good SAS Programming?
Ian Whitlock

To Annotate or Not to Annotate, There Should Be No Question!
Keith Cranford

How Fast Can You Type *or* Go Ahead and Get Snippity
John Gober

SESUG Proceedings

SESUG ProceedingsThe Institute for Advanced Analytics is pleased to host the archive of past proceedings of the Southeast SAS Users Group (SESUG) Annual Meetings as a courtesy to the SAS user community. The archive contains 1,751 papers presented at the meeting since 1999.

Browse the SESUG proceedings by year:

SESUG 2013, St. Pete Beach, Florida

SESUG 2012, Durham, North Carolina

SESUG 2011, Alexandria, Virginia

SESUG 2010, Savannah, Georgia

SESUG 2009, Birmingham, Alabama

SESUG 2008, St. Pete Beach, Florida

SESUG 2007, Hilton Head, South Carolina

SESUG 2006, Atlanta, Georgia

SESUG 2005, Portsmouth, Virginia

SESUG 2004, Nashville, Tennessee

SESUG 2003, St. Pete Beach, Florida

SESUG 2002, Savannah, Georgia

SESUG 2001, New Orleans, Louisiana

SESUG 2000, Charlotte, North Carolina

SESUG 1999, Mobile, Alabama

Search the entire SESUG archive:

Loading



Please note: The Institute for Advanced Analytics is not the publisher of the SESUG proceedings and it not responsible for its content. Questions or concerns about the proceedings should be addressed directly to SESUG.

Copyright Information

These Proceedings are the official record of the 7th Annual SouthEast SAS Users Group (SESUG) Conference held in Mobile, AL on October 31 – November 3, 1999 at the Adams Mark Hotel. 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 1999: The Proceedings of the SouthEast SAS Users Group, Mobile, AL, 1999

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

14 Steps to a Good GUI
John E. Bentley

A SAS 7 System: From CD to GIS MAPS
Samuel D. Calhoun

Comparison of CGI and Java Technology Provided in SAS/IntrNet Software
Barbara Walters, Don Chapman

Effective Strategies for Managing SAS Applications Development
Christopher A. Roper

Empowering Your End-Users’ Reporting Potential from SAS/AF Applications with SAS Enterprise Reporter
Gary Mason

Exporting Oracle Tables into SAS Tables Made Simple with Version 7 of the SAS System
Danny Walker

Householding and Its Relationship to Customer-to-Customer Marketing and Data Mining
Jacob Sacolick

Optimizing Data Extraction from Oracle Tables
Caroline C. Bahler

Using SAS, SAS/ACCESS and SQL Passthrough to Query and Join Oracle Tables
Barbara B. Okerson

Using SAS/AF to Create Applications for the Administrative Aspects of Data Management in Clinical Trials
Emily Mixon, Karen Fowler, Felicita David

Coder’s Corner

A Cross-reference for SAS Data Libraries
John R. Gerlach, Cindy Garra

A Modular SAS Programming to Support ABC Simulation Study
Sejong Bae, Michael Weaver

A SAS Program to Calculate and Plot Widths of (1-a) 100% Confidence Intervals for Binomial Proportions
Maribeth Johnson, Mark Litaker

An OBS Limit with a WHERE Condition
Ian Whitlock

Creating ASCII Fixed Length Record Files from SAS Data Sets
Lawrence Altmayer

Everything In One Record: Creating One-liners with Merges and Retains
Sharon W. Stroud, David P. Biggs

Generating SAS Reports and the Collation Problem
Imelda C. Go

Indexed Datasets 101
John Charles Gober

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

Make Your Own Macro Processor
Ian Whitlock

Managing the INTNX Function
Ian Whitlock

Matching Data Using SAS Programming and Human Judgment
Imelda C. Go

Pruning the SASLOG – Digging into the Roots of NOTEs, WARNINGs, and ERRORs
Andrew T. Kuligowski

Removing Macro Variables from the SAS Environment
Frank DiIorio

Shortcuts
Janet E. Stuelpner

The Power of SAS Input Statements
Imelda C. Go

Using SAS/AF to Create Data Entry Screens with Multiple Comment Fields Allowing for Unlimited Amounts of Text in Each Field
Robert S. Matthews

Using SAS ARRAYs: An Introduction to Easy Recodes
Francis J. Kelley

Your Friend the Colon: Some Efficiency Techniques for Comparing or Selecting Character Data
S. David Riba

Emerging Technologies

An Introduction to the Next Big Thing: Parallel Computing
John E. Bentley

SAS Skills in the Next Millennium: A Geek Peek into the (not so distant) Future
Greg S. Barnes Nelson, Jodi Barnes Nelson

Tech Report 2000: Telecommuting with SAS Saves Gas. The SAS Application Developer’s Guide to the Virtual Office
Eric C. Brinsfield, Matt Becker

Information Visualization

Data Summarization Methods in Base SAS Procedures
Lynn Bressler

Statistical Presentations Using the Power of PROC TABULATE
C. Olivia Rud

Using JMP for Technical Analysis of Stocks in Highly Volatile Markets
Bill Gjertsen

SAS Solutions

An Interactive GUI Front-End for a Credit Scoring Modeling System
Jeff Morrison, Futian Shie, Timothy Lee

Building a Customized Data Entry System With SAS/Intrnet
Keith J. Brown

CRM 101: Maximizing Return on Investment with the SAS Solution for CRM
Drury Jenkins

Deploying the SAS/MDDB in a Retail Environment
Ben Cochran

Building a Data Mart on top of SAP R/3-HR
Christ D’haeveloose, Sophie Dabaets

SAS I/T Service Vision: Delta Technology’s Performance Database
Bob Chaney

Tessera Rapid Modeling Environment: Production-Strength Data Mining Solution for Terabyte-Class Relational Data Warehouses
Mike Nichols, John Zhao, John David Campbell

Using SAS Software to Analyze Sybase Performance on the Web
Joseph Mirabal, Zhengyu Wang

Statistics, Data Analysis and Modeling

A Modular SAS Programming to Support ABC Simulation Study
Sejong Bae, Michael Weaver

A SAS Program for the Computation of Cumulative Exposure Estimates for Analysis of Cause-specific Mortality Rates in a Cohort of Synthetic Rubber Workers
Ilene Brill, Maurizio Mancaluso, Robert Matthews, Elizabeth Delzell

Analysis of Longitudinal Data: Comparison between PROC GLM and PROC MIXED
Maribeth Johnson

Forecasting Army Officer Attrition with Logistic Regression Using The SAS System
LTC Doug L. McAllaster

Hot-Deck Imputation: A Simple DATA Step Approach
Lawrence Altmayer

Recent Advances in Categorical Data Analysis
Maura E. Stokes

Statistics without DATA _NULLS_,
Michael C. Palmer, Cecilia A. Hale

Tutorial on Logistic Regression
Maura Stokes

Using the SAS System to Examine the Agreement between Two Programs that Score Surveys Using Samejima’s Graded Response Model
Jim Penny, S. Bartholomew Craig

Using SAS Perform the Analysis of Means for Variances Test
Peter Wludyka, Ph.D.

Utilizing SAS Software in the Evaluation of Virginia Tech’s Academic Eligibility Policy
Kristen H. Bush, Ph.D.

Systems Architecture

Distributing SAS/AF Models with Java Clients
Chris Bailey, Karl Moss

Extending the Data Warehouse: An Introduction to Ole DB
S. David Riba

No Program Is An Island: Passing Parameters to Tasks Launched by Servers and Schedulers
Michael L. Davis, Gregory S. Barnes Nelson

Optimizing SAS Software on Windows NT: A Guide to Performance Tuning Your Applications Server
Peter Parker

SAS Client-Server Development: Through Thick and Thin and Version 8
Eric Brinsfield

What’s New in Versions 7 and 8 for SAS files?
Jane Stroupe

Hiring the Best SAS Programmers
Neil Howard

How to Develop and Maintain a Corporate SAS Users Group
Bryan K. Beverly

Providing Web-Based Support for SAS users at NC State University
Joy Munk Smith, Sandra B. Donaghy

Telecommuting: The Workplace of the 90s
Thalene T. Mallus

Year 2000 Triage for Your SAS Applications
Mike Kalt

Advanced Tutorials

Advanced Manufacturing Applications with SAS
Perry Smith

Adventures in Arrays: A Beginning Tutorial
Jane Stroupe

Array Lookup Techniques: From Key-Indexing to Hashing (Part 2)
Paul M. Dorfman

Building Yield Management – GUI System at Norwegian Cruise Line by Using SAS/EIS and SAS/AF
Sam Sheng

Characteristics of a “Successful” Application
Caroline Bahler

Data Mining: An Overview of Methods and Technologies for Increasing Profits in Direct Marketing
C. Olivia Rud

Fuzzy Merges: Examples and Techniques
Malachy J. Foley

Macro Internals for the User – Developer’s Overview
Susan O’Connor

Mapping: “Would You, Could You …”
Clara Louise Waterman

The Writing for Reading SAS Style Sheet: Tricks, Traps & Tips from SAS-L’s Macro Maven
Ronald Fehd

Those Missing Values in Questionnaires
John R. Gerlach, Cindy Garra

User-Specified Text Flow Inside the Report Procedure
Donald Peterson, John R. Gerlach

Using IBM System/360/370/390 Data Types in a Non-Mainframe Environment
Francis J. Kelley

Beginning Tutorials

Array Lookup Techniques: From Sequential Search to Key-Indexing (Part 1)
Paul M. Dorfman

Do We Know How to Function?
Janet E. Stuelpner

Getting Started with Frame Technology
Christopher A. Roper

Getting Started with Macro
Ian Whitlock

How to Use the Data Step Debugger
S. David Riba

Programming Solutions with SAS Formats and Informats
Imelda C. Go

SAS Components to Help You Survive A Deserted Island
Stephen M. Noga

Seven Steps to SAS/GRAPH Savvy
Neil Howard

So Many PROCs, So Little Time: A Primer of Efficient Report Writing in Base SAS
Deborah Babcock Buck

Summarization – The Keys to Processing
Ron Coleman

The SAS Debugging Primer
Frank C. DiIorio

INSTITUTE FOR ADVANCED ANALYTICS

NC State University

This website is designed, written and produced by Dr. Michael Rappa © 2006-2013. All rights reserved.

...