MWSUG 2010 Conference Proceedings

Milwaukee, Wisconsin
October 10-12, 2010

Download the entire 2010 conference proceedings as a ZIP file (62MB)

Individual Paper PDFs:

Analytics, Statistics, Modeling, Forecasting, & Data Mining

Paper #22. Adequacy and Information Values: Two Tools for Ranking Predictors in Generalized Linear Models
Douglas Thompson, Assurant Health

Paper #21. An Introduction to Multiple Imputation of Complex Sample Data Using SAS® 9.2
Patricia Berglund, University of Michigan

Paper #45. Evaluation of Methods to Determine Optimal Cut Points for Predicting Mortgage Default
Valentin Todorov, Assurant Specialty Property
Douglas Thompson, Assurant Health

Paper #107. Ideas and Examples in Generalized Linear Mixed Models
David Dickey, North Carolina State University

Paper #33. Introduction to Logistic Regression (No paper available)
Maura Stokes, SAS

Paper #130. Kernel Density Estimation As an Alternative to Binning of Survey Data
David Corliss, University of Toledo

Paper #87. Monty Hall, Paul Erdös, and Monte Carlo
Irvin Snider, assurant Health

Paper #146. Novel Use of SAS® Software in Industrial and Biomedical Consulting, Research, and Teaching
Timothy O'Brien, Loyola University Chicago

Paper #75. PROC LIFEREG or PROC PHREG
Dachao Liu, Northwestern University

Paper #108. PROC MIXED: Underlying Ideas with Examples
David Dickey, North Carolina State University

Paper #76. Power to Detect Therapist Effects in Randomized, Controlled Trials of Interventions in Clinical Psychology
Douglas Thompson, Assurant Health
Fary Cachelin, California State University-Los Angeles
Ruth Striegel-Moore, Wesleyan University
Terry Wilson, Rutgers University

Paper #182. Some Basic Techniques for Data Quality Evaluation Using SAS®
George Hurley, The Hershey Company

Paper #37. Survival Analysis with PHREG: Using MI and MIANALYZE to Accommodate Missing Data
Chris Ake, Kaiser Permanente
Art Carpenter, Data Explorations

Paper #20. The Applied Use of Population Stability Index (PSI) in SAS® Enterprise Miner™
Rex Pruitt, PREMIER Bankcard, LLC

Paper #35. The Next Generation: SAS/STAT® 9.22
Maura Stokes, SAS

Paper #42. Using Base SAS® and SAS Enterprise Miner™ to Develop Customer Retention Modeling
Rex Pruitt, PREMIER Bankcard

Paper #125. Using SAS® to Assess and Model Time-to-Event Data with Non-Proportional Hazards
*** BEST PAPER ***
Michael Wilson, IUSM, Dept of Clinical Pharmacology

Applications Development

Paper #154. Application Development with SAS® Stored Processes
John Xu, 1ST Consulting LLC

Paper #73. Applied Revolutionary BI
Charles Kincaid, COMSYS

Paper #148. Better Decision Making with SAS® Enterprise Business Intelligence and Microsoft Outlook
James Tetterton, SAS

Paper #29. Google Maps and SAS/GRAPH®
Darrell Massengill, SAS

Paper #83. Introduction to Business Intelligence for SAS® Users
*** BEST PAPER ***
Thomas Miron, Systems Seminar Consultants

Paper #36. It's All about Variation: Improving Your Business Process with Statistical Thinking
Robert Rodriguez, SAS

Paper #89. Make it SASsy: Using SAS® to Generate Personalized, Stylized, Automated Email
Lisa Walter, Cardinal Health

Paper #16. Point-and-Click Programming Using SAS® Enterprise Guide®
Mira Shapiro, Capacity Planner, Consultant and Biostatistician
Kirk Paul Lafler, Software Intelligence Corporation

Paper #47. SAS® Data and Stored Process for BlackBerry
Sy Truong, MetaXceed, Inc.
DJ Penix, Pinnacle Solutions, Inc.

Paper #79. SAS® Macro Application Using Microsoft Excel As Both Control File and Process Documentation
Mike Tangedal, self

Paper #84. Seamless Dynamic Web Reporting with SAS®
DJ Penix, Pinnacle Solutions, Inc.

Paper #38. Seamless Web Data Entry for SAS® Applications
DJ Penix, Pinnacle Solutions, Inc.

Paper #69. Setting Up Project-specific SAS® Windows Environments
Philip Wright, The University of Michigan, Institute for Social Research

Paper #64. Some New and Not So New Batch Processing Techniques
Mike Vanderlinden, COMSYS
Brian Varney, COMSYS

Paper #138. Streamlining Reports: A Look into Ad Hoc and Standardized Processes
James Jenson, Self

Paper #149. Take a Whirlwind Tour around SAS® 9.2
Diane Hatcher, SAS

Foundations & Fundamentals (Beginning Tutorials)

Paper #109. 33 Tricks with PROC REPORT: A Quick Introduction to the Powerful REPORT Procedure
Ben Cochran, The Bedford Group

Paper #62. An Introduction to SQL in SAS®
Pete Lund, Looking Glass Analytics

Paper #85. Choosing the Right Tool from Your SAS® and Microsoft Excel Tool Belt
Jennifer First, Systems Seminar Consultants
Steven First, Systems Seminar Consultants

Paper #11. DATA Step and PROC SQL Programming Techniques
Kirk Paul Lafler, Software Intelligence Corporation

Paper #106. ERRORs, WARNINGs, and NOTEs (Oh My!): A Practical Guide to Debugging SAS® Programs
Lora Delwiche, University of California, Davis
Susan Slaughter, Avocet Solutions

Paper #159. Exploring, Analyzing, and Summarizing Your Data: Choosing and Using the Right SAS Tool from a Rich Portfolio
Douglas Thompson, Assurant Health

Paper #27. Macrotize! A Beginner's Guide to Designing and Writing Macros
Stacey D. Phillips, i3 Statprobe

Paper #153. PROC REPORT: Compute Block Basics
Art Carpenter, California Occidental Consultants

Paper #165. Reporting in the Age of Twitter: Concise Reports and Continuous Real-Time Monitoring
LeRoy Bessler, Bessler Consulting and Research

Paper #34. SAS® System Options: The True Heroes of Macro Debugging
Kevin Russell, SAS

Paper #98. Set, Match, Merge ... Don’t You Love SAS®?
Peter Eberhardt, Fernwood Consulting Group Inc.
Ying Liu

Paper #114. The Greatest Hits: ODS Essentials Every User Should Know
Cynthia Zender, SAS

Paper #48. The Mystery of the PROC SORT Options NODUPRECS and NODUPKEY Revealed
*** BEST PAPER ***
Britta KelseyBassett, The Schwan Food Company

Paper #99. The SAS® DATA Step: Where Your Input Matters
Peter Eberhardt, Fernwood Consulting Group Inc.

Paper #152. Turning Raw Data into Polished Reports
Lora Delwiche, University of California, Davis
Susan Slaughter, Avocet Solutions

Paper #39. Using SAS® Output Delivery System (ODS) Markup to Generate Custom Pivot Tables and Pivot Charts
Chevell Parker, SAS

Hands-On Workshops

Paper #97. A Cup of Coffee and PROC FCMP: I Cannot Function Without Them
Peter Eberhardt, Fernwood Consulting Group Inc.

Paper #143. A Hands-on Tour Inside the World of PROC SQL
Kirk Paul Lafler, Software Intelligence Corporation

Paper #12. Output Delivery System (ODS) – Simply the Basics
Kirk Paul Lafler, Software Intelligence Corporation

Paper #141. PROC REPORT Basics: Getting Started with the Primary Statements
Art Carpenter, California Occidental Consultants

Paper #139. PROC TABULATE: Getting Started
Art Carpenter, California Occidental Consultants

Paper #140. SAS/GRAPH® Elements You Should Know – Even If You Don’t Use SAS/GRAPH
Art Carpenter, California Occidental Consultants

Paper #100. The SAS® Hash Object: It’s Time To .find() Your Way Around
Peter Eberhardt, Fernwood Consulting Group Inc

Paper #51. Using PROC SGPLOT for Quick, High-Quality Graphs
Lora Delwiche, University of California, Davis
Susan Slaughter, Avocet Solutions

Health Care & Health Insurance

Paper #126. A SAS® Primer for Health Care Data Analysts
Christopher Schacherer, Clinical Data Management Systems, LLC
Brent Westra, Mayo Clinic Health Solutions

Paper #77. Characteristic Analysis of the Hospitalized Children with Lower Extremity Fractures in 2006: A Population-Based Approach
Yubo Gao, University of Iowa

Paper #123. Comparative Effectiveness Analysis and Statistical Methodology
Patricia Cerrito, University of Louisville
John Cerrito, Kroger Pharmacy

Paper #95. Gastrointestinal Diseases: Diagnoses, Misdiagnoses, and Comorbidities
Pedro Ramos, University of Louisville

Paper #168. Medical Guidelines: Consensus Panel Versus Healthcare Analytics
Patricia Cerrito, University of Louisville

Paper #91. Plotting Summary ROC Curves from Multiple Raters Using the SmryROCPlot Macro
Matthew Karafa, Cleveland Clinic Foundation
Nancy Obuchowski, Cleveland Clinic Foundation

Paper #127. SAS® with CLAS: Assessing Adherence to Federal Standards for Culturally and Linguistically Appropriate Services
Michelle Hopkins, Stratis Health

Paper #177. Tips for Automating Univariate Outcomes Analysis in Hematopoietic Stem Cell Transplantation
Peigang Li, CIBMTR, Medical College of Wisconsin, Milwaukee, Wisconsin
Xiaochun Zhu, CIBMTR, Medical College of Wisconsin, Milwaukee, Wisconsin
Min Chen, CIBMTR, Medical College of Wisconsin, Milwaukee, Wisconsin

Paper #103. To Investigate the Impact of Medicare Part D on the Cost Effectiveness of Diabetes Medications and Health Outcomes with SAS®
Xiao Wang, University of Louisville

Paper #71. Using HPMIXED and Other SAS® Procedures to Efficiently Analyze Large Dimension Registry Data
*** BEST PAPER ***
Matthew Fenchel, Cincinnati Children's Hospital Medical Center
Gary McPhail, Cincinnati Children's Hospital Medical Center
Rhonda VanDyke, Cincinnati Children's Hospital Medical Center

JMP

Paper #151. A DOE “Real Life” Example: Solid Phase Optimization of a Diagnostic Immunoassay
Steve Figard, Abbott Laboratories

Paper #46. Ad Hoc and Statistical Model Visualization Using JMP®, SAS®, and Excel
Jon Weisz, SAS

Paper #6. Comparing JMP® and SAS® for Validating Clinical Trials
Sandra Schlotzhauer, Schlotzhauer Consulting LLC

Paper #128. JMP® Simulation-Based Empirical Determination of Robust Scale Estimator and Comparison of Outlier Discrimination Performance
Gennadiy Gorelik, Consultant
Tarun Chandra, EmpiriQA LLC

Paper #180. SPC As Part of an Operations Intelligence System Combining JMP® and SAS®
Michael Haslam, Predictum, Inc.
Wayne Levin, Predictum, Inc.

Paper #161. Salesforce Effectiveness at Sears: An Analytic Approach to Goal Setting and Tracking
*** BEST PAPER ***
Carl Schleyer, Sears Holdings Corporation
Jason Chavarry, Sears Holdings Corporation

Paper #162. Simplifying Drug Discovery with JMP
John Wass, Quantum Cat Consultants

Paper #156. The “Forgotten” JMP® Visualizations
Sam Gardner, JMP Division, SAS Institute

Paper #82. Using JMP® and SAS® Software Together to Prepare a Last-Minute Research Project for Publication, Or Statistical Modeling of Breathing Relief in Sarcoidosis Patients
James Woods, Wayne State University Detroit

Paper #94. Using the JMP® 9 R Interfaces to Perform Bayesian Analyses: Why, How, and What
Dave LeBlond, Abbott

Paper #176. Visualization with JMP – The Overlay, Spinning, Surface, and Contour Plots
Mark Anawis, Abbott

Posters

Paper #72. Eliminating Redundant Custom Formats (or How to Really Take Advantage of PROC SQL, PROC CATALOG, and the DATA Step)
*** BEST PAPER ***
Philip Wright, The University of Michigan-Institute for Social Research

Paper #104. Mixing the Use of the Three Types of Comments for Ease of Use of SAS® Enterprise Guide® Code
Mark Menzie, Assurant Health

Paper #105. Pulling Together Existing Code for One-Touch Execution by Using %INCLUDE or Macro References
Mark Menzie, Assurant Health

Programming Beyond the Basics (Advanced Tutorials)

Paper #158. A Different View of PROC SORT
Steven First, Systems Seminar Consultants

Paper #118. A New Look at An Old Friend: Getting Reacquainted with Arrays
Joe Novotny, dunnhumbyUSA
Paul Kollner, dunnhumbyUSA

Paper #145. Application of DICTIONARY Tables and SASHELP Views
Kirk Paul Lafler, Software Intelligence Corporation

Paper #50. Best Practices and Advanced Tips and Techniques for SAS® Macro Programming
Gerry Bonin, We Energies

Paper #18. Boot Camp for Programmers: Stuff You Need to Know That's Not in the Manual - Best Practices to Help Us Achieve Reproducibility
Elizabeth Axelrod, Abt Associates Inc.

Paper #144. Hard-to-find, But Powerful, PROC SQL Features
Kirk Paul Lafler, Software Intelligence Corporation

Paper #142. PROC TABULATE: Doing More
Art Carpenter, California Occidental Consultants

Paper #26. SAS® Views - The Best of Both Worlds
David Thul, Blue Cross Blue Shield of MN

Paper #74. SGPANEL: Telling the Story Better
*** BEST PAPER ***
Charles Kincaid, COMSYS

Paper #119. Stuff We All Do: Mistakes We’ve Made That You Won’t Have To
Joe Novotny, dunnhumbyUSA
Michael Bramley, dunnhumbyUSA

Paper #174. The Ten Most Frequently Asked Macro Questions
Kevin Russell, SAS

Paper #150. Understanding WHERE Clause Processing and Indexes
Kirk Paul Lafler, Software Intelligence Corporation

Paper #157. Understanding the SAS® DATA Step and the Program Data Vector
Steven First, Systems Seminar Consultants

Paper #112. Using SAS® Macro Functions to Manipulate Data
Ben Cochran, The Bedford Group

Paper #90. Ways of Creating a Macro Variable
Kelley Weston, Quintiles

Paper #63. You Created That Report in SAS®!? The Power of the ODS PDF Destination
Pete Lund, Looking Glass Analytics

Reporting & Information Visualization

Paper #121. Integrating Multiple SAS/GRAPH® Procedures to Generate a Custom Image
Joshua Horstman, First Phase Consulting, Inc.

Paper #61. Make Your Tables Pop: Embedding Micrographics in PROC REPORT Output
Pete Lund, Looking Glass Analytics

Paper #60. More To It Than Meets the Eye: Creating Custom Legends That Really Tell a Story
Pete Lund, Looking Glass Analytics

Paper #86. Multivariate Data Displays for Evaluating Clusters
*** BEST PAPER ***
Robert Moore, Ameriprise Financial

Paper #67. ODS TAGSETS.RTF: Tips and Tricks
Xiangxiang Meng, University of Cincinnati

Paper #134. Tips and Tricks: More SAS/GRAPH® Map Secrets
Darrell Massengill, SAS

Paper #43. Two EDF Graphs for Assessing Agreement between Paired Data
David Meek, USDA MWA NLAE

Paper #68. Using the SGSCATTER Procedure to Create High-Quality Scatter Plots
Xiangxiang Meng, University of Cincinnati

Paper #164. Visual Display of Data in the Age of Twitter, Mobility, Web, Excel, and PowerPoint: Concise, Communication-Efficient, and Communication-Effective Graphs
LeRoy Bessler, Bessler Consulting and Research

Paper #66. Visualizing Key Performance Indicators Using the GKPI Procedure
Brian Varney, COMSYS

Resources and Support for SAS Users

Paper #10. Connect with SAS® Professionals around the World with LinkedIn and sasCommunity.org
Charles Edwin Shipp, Shipp Consulting
Kirk Paul Lafler, Software Intelligence Corporation

Paper #170. Creating a Successful Support Model for the SAS® Enterprise Intelligence Platform
Jerry High, Blue Cross and Blue Shield of Minnesota

Paper #120. Custom Google Searches, PDF Sticky Notes, and Other Tips for Organizing and Accessing SAS® Help Resources
*** BEST PAPER ***
Roger Muller, First Phase Consulting, Inc.
Joshua Horstman, First Phase Consulting, Inc.

Paper #171. Getting from SAS® 9.1.3 to SAS® 9.2: Practicalities of the Automated Tools
Diane Hatcher, SAS

Paper #135. SAS® Programmer’s Challenge: It’s All about the Options
Art Carpenter, California Occidental Consultants

Paper #163. Supporting Users, Software, and a BI Server: Using SAS® to Support SAS®
LeRoy Bessler, Bessler Consulting and Research

Paper #65. Technical Resources for Beginning SAS® Programmers
Brian Varney, COMSYS

Paper #8. Win with In-House Users Groups for SAS®, JMP®, and Special Interests
Charles Edwin Shipp, Shipp Consulting
Kirk Paul Lafler, Software Intelligence Corporation

SAS with Excel or Database

Paper #58. Base SAS® Methods for Building Dimensional Data Models
Christopher Schacherer, Clinical Data Management Systems, LLC

Paper #57. Building an Extract, Transform, and Load (ETL) Server Using Base SAS®, SAS/SHARE®, SAS/CONNECT®, and SAS/ACCESS®
Christopher Schacherer, Clinical Data Management Systems, LLC
Timothy Steines, Independent Consultant

Paper #111. Linking SAS® Reports to Spreadsheet Data
Ben Cochran, The Bedford Group

Paper #40. Macro Variables Make Life Easier: Applications with SAS® to Excel
*** BEST PAPER ***
Misty Johnson, State of Wisconsin Department of Health Services

Paper #15. Romancing Your Data: The Getting-to-Know-You Phase
Carole Jesse, Ally Financial

Paper #166. SAS® and Excel, A Winning Combination, Part 2: DDE (Dynamic Data Exchange), a Popular Solution around the World
LeRoy Bessler, Bessler Consulting and Research

Paper #113. The Ten Most Frequently Asked Questions about SAS® to Excel
Chevell Parker, SAS

Paper #110. Using PROC SQL to Build and Incrementally Update That Data Mart
Ben Cochran, The Bedford Group

Paper #52. Using SAS® Software's Metadata to Generate ETL Precursor Files in a Heterogeneous Database System
Alexander Pakalniskis, Cedars-Sinai Medical Center
Peixin Wang, Cedars-Sinai Medical Center
Nilesh Bajania, Cedars-Sinai Medical Center
Alein Chun, Cedars-Sinai Medical Center

Solutions

Paper #17. Building a Match Code Using SAS®
David Li, Prime Therapeutics

Paper #19. Happy Birthday! But ... How Old Are You, Really?
Elizabeth Axelrod, Abt Associates Inc.

Paper #93. How I Learned to Type 1,388,571 wpm, Or Creating Extensive Shift Tables
Kelley Weston, Quintiles

Paper #131. Mashups Can Be Gravy: Techniques for Bringing the Web to SAS®
Jack Fuller, COMSYS

Paper #124. Meta-Programming in SAS® with DATA Step
Paulo Tanimoto, KEMA Inc.

Paper #167. SAS® and Excel, A Winning Combination, Part 1: Easy Solutions for Multi-Sheet Excel Workbooks, Color-Coding, Imbedded Graphs, etc.
LeRoy Bessler, Bessler Consulting and Research

Paper #88. Simulating a Simple Solitaire Card Game Using SAS®
Robert Moore, Ameriprise Financial

Paper #25. Summaries by Class and Interval
Nathan Lindquist, U.S. Bank Credit Administration

Paper #49. Tables As Trees: Merging with Wildcards Using Tree Traversal and Pruning
Matthew Nizol, United BioSource Corporation

Paper #169. The Art of Being Color-Communication-Effective, Not Just Colorful
LeRoy Bessler, Bessler Consulting and Research

Paper #81. The Genealogy of Macros
Kelley Weston, Quintiles

Paper #117. This SAS® Program Says to Google, "What's Up Doc?"
Scott Davis, COMSYS

Paper #44. Use of FILENAME Statement to Create Automated Reports with Severe Weather Events Data from the National Weather Service
*** BEST PAPER ***
Valentin Todorov, Assurant Specialty Property

Paper #70. Using a Few Key Elements of SAS® DATA Step Code and a Couple of Procedures to Optimize the Observation Length of a Data Set
Philip Wright, The University of Michigan-Institute for Social Research