Home
Contact
SAS Paper Search
SAS:MWSUG papers
SAS:NESUG papers
SAS:PharmaSUG papers
SAS:PharmaSUG China papers
SAS:PhUSE papers
FDA/PhUSE CSS posters
SAS:PNWSUG papers
SAS:SCSUG papers
SAS:SESUG papers
SAS:SeUGI papers
SAS:SUGI papers
SAS:VIEWS papers
SAS:WUSS papers
SAS:CDISC papers
Fortune records
Marsh 1001
India
South America

Powered by SAS® 9.01.01M3P02162005.

Valid XHTML 1.0 Transitional

Google
  Search results
SAS Conference Proceedings: Midwest SAS Users Group 2017
October 8-10, 2017, St. Louis, Missouri, 88 papers
MWSUG 2017   MWSUG 2016   MWSUG 2015   MWSUG 2014   MWSUG 2013   MWSUG 2012   MWSUG 2011   MWSUG 2010   MWSUG 2009   MWSUG 2008   MWSUG 2007   MWSUG 2006   MWSUG 2005   MWSUG 2004   MWSUG 2003   MWSUG 2002   MWSUG 2001   MWSUG 2000   MWSUG 1999   MWSUG 1998   MWSUG 1997   MWSUG 1996   MWSUG 1995   MWSUG 1994   MWSUG 1993   MWSUG 1992   MWSUG 1991   MWSUG 1990  

[Original source: http://www.mwsug.org/index.php/2017-proceedings.html]

Midwest SAS Users Group 2017: Best Papers and honorable mentions

Computing Risk Measures for Loan Facilities with Multiple Lines of Draws
  Chaoxian Cai, BMO Harris Bank (Best Paper in Banking and Finance)
Demystifying Intervals
  Derek Morgan, PAREXEL (Best Paper in Beyond the Basics SAS)
A Big Data Challenge: Visualizing Social Media Trends about Cancer using SAS® Text Miner
  Mia Lyst, Pinnacle Solutions, Inc; Scott Koval, Pinnacle Solutions, Inc; Yijie Li, Pinnacle Solutions, Inc. (Best Paper in Data Visualization and Graphics)
Correlation and Structural Equation Analysis on the Effects of Anti-Discrimination Policies and Resources on the Well Being of Lesbian, Gay, and Bisexual College Students
  Brandy Sinco, University of Michigan; Michael Woodford, Wilfred Laurier University, Ontario, CA; Jun Sung Hong, Wayne State University; Jill Chonody, Indiana University (Best Paper in Data for Good)
Automated Validation of Complex Clinical Trials Made Easy
  Richann Watson, Experis; Josh Horstman, Nested Loop Consulting (Best Paper in Pharmaceutical Applications)
Macro that can Provide More Information for your Character Variables
  Ting Sa, Cincinnati Children's Hospital Medical Center (Best Paper in Rapid Fire)
Writing Code With Your Data: Basics of Data-Driven Programming Techniques
  Joe Matise, NORC (Best Paper in SAS 101)
Multiple Imputation of Family Income Data in the 2015 Behavioral Risk Factor Surveillance System
  Jia Li, NIOSH; Aaron Sussell, NIOSH (Best Paper in Statistics / Advanced Analytics)
From Device Text Data to a Quality Dataset
  Laurie Smith, Cincinnati Children's Hospital Medical Center (Best Paper in Tools of the Trade)
SAS/GRAPH® and GfK Maps: a Subject Matter Expert Winning Combination
  Louise Hadden, Abt Associates Inc. (Best Paper in e-Posters)

BI / Customer Intelligence
Banking and Finance
Beyond the Basics SAS
Data Visualization and Graphics
Data for Good
Hands-on Workshops
Pharmaceutical Applications
Rapid Fire
SAS 101
Statistics / Advanced Analytics
System Architecture and Administration
Tools of the Trade
e-Posters

BI / Customer Intelligence
tweet!  If You Build It, Will They Understand? Designing Reports for the General Public in SAS® Visual Analytics
  Jesse Sookne, SAS; Ed Summers, SAS; Julianna Langston, SAS; Karen Mobley, SAS
Pages: 20 Size: 820 Kb 
tweet!  Accessibility and SAS® Visual Analytics Viewers: Which Report Viewer Is Best for Your Users' Needs?
  Jesse Sookne, SAS; Kristin Barker, SAS; Joe Sumpter, SAS; Lavanya Mandavilli, SAS
Keywords: accessibility a11y SAS Visual Analytics mobile BI business intelligence section 508 wcag
Pages: 18 Size: 989 Kb 
Banking and Finance
tweet!  The Cox Hazard Model for Claims Data: Bayesian non-parametric approach
  Samuel Berestizhevsky, Consultant; Tanya Kolosova, Co-author
Pages: 17 Size: 1398 Kb 
Best Paper
tweet!  Computing Risk Measures for Loan Facilities with Multiple Lines of Draws
  Chaoxian Cai, BMO Harris Bank
Keywords: risk measure exposure at default credit conversion factor union find loan structure
Pages: 10 Size: 399 Kb 
tweet!  Untangle Customer's Incrementality using Uplift Modeling with a Case Study on Direct Marketing Campaign
  Hairong Gu, Alliance Data; Yi Cao, Alliance Data; Chao Xu, Alliance Data
Pages: 8 Size: 437 Kb 
Beyond the Basics SAS
tweet!  Advanced Macro: Driving a Variable Parameter System with Metadata
  Art Carpenter, CA Occidental Consultants
Keywords: Metadata macro language CALL EXECUTE %NRSTR %TSLIT
Pages: 10 Size: 373 Kb 
Best Paper
tweet!  Demystifying Intervals
  Derek Morgan, PAREXEL
Keywords: Date and Time Intervals INTCK() INTNX() Date and Time Interval Functions Customizing date and time intervals
Pages: 15 Size: 209 Kb 
tweet!  Extraction and Use of Text Strings with SAS when Source exceeds the 32k String Length Limit
  John Schmitz, Luminare Data
Keywords: SAS SQL explicit pass-through XML text dbms
Pages: 10 Size: 290 Kb 
tweet!  Fifteen Functions to Supercharge Your SAS Code
  Josh Horstman, Nested Loop Consulting
Keywords: MWSUG 2017
Pages: 9 Size: 411 Kb 
tweet!  You Did That With SAS? Combining Text with Graphics Output to Create Great Looking Reports.
  Ben Cochran, The Bedford Group
Pages: 13 Size: 632 Kb 
tweet!  Tackling Unique Problems by Using TWO SET Statements in ONE DATA Step
  Ben Cochran, The Bedford Group
Pages: 9 Size: 228 Kb 
tweet!  Exploring HASH Tables vs. SORT/DATA Step vs. PROC SQL
  Lynn Mullins, PPD; Richann Watson, Experis
Keywords: hash PROC SQL
Pages: 14 Size: 239 Kb 
tweet!  DATA Step in SAS Viya: Essential New Features
  Jason Secosky, SAS
Pages: 14 Size: 550 Kb 
tweet!  DOSUBL and the Function Style Macro
  John King, Ouachita Clinical Data Services, Inc.
Keywords: DOSUBL MACRO FUNCTION
Pages: 6 Size: 507 Kb 
Data Visualization and Graphics
tweet!  An Introduction to ODS Statistical Graphics
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords: sas, ods, graphs, statistical graphics, sgplot, sgpanel, sgscatter, programmer, sas programmer, author, sas press, sas press author, consultant, sas consultant, consulting, sas consulting, educator ...
Pages: 13 Size: 781 Kb 
tweet!  Waterfall Plots in Oncology Studies in the Case of Multi-Arms Design
  Ilya Krivelevich, Eisai Inc; Kalgi Mody, Eisai Inc; Simon Lin, Eisai Inc
Pages: 15 Size: 474 Kb 
tweet!  A Macro that can Create U.S State and U.S County KML Files
  Ting Sa, Cincinnati Children's Hospital Medical Center
Pages: 10 Size: 725 Kb 
Best Paper
tweet!  A Big Data Challenge: Visualizing Social Media Trends about Cancer using SAS® Text Miner
  Mia Lyst, Pinnacle Solutions, Inc; Scott Koval, Pinnacle Solutions, Inc; Yijie Li, Pinnacle Solutions, Inc.
Keywords: SAS Text Mining Cancer Visual Big Data Social Media
Pages: 8 Size: 917 Kb 
tweet!  Data Can Be Beautiful: Crafting a Compelling Story with SAS® Visual Analytics
  Cheryl Coyle, SAS
Pages: 20 Size: 1253 Kb 
tweet!  Patient Safety with SAS® Visual Analytics
  Piyush Singh, TCS; Prasoon Sangwan, TCS; Ghiyasudin Khan, TCS
Pages: 12 Size: 1183 Kb 
Data for Good
Best Paper
tweet!  Correlation and Structural Equation Analysis on the Effects of Anti-Discrimination Policies and Resources on the Well Being of Lesbian, Gay, and Bisexual College Students
  Brandy Sinco, University of Michigan; Michael Woodford, Wilfred Laurier University, Ontario, CA; Jun Sung Hong, Wayne State University; Jill Chonody, Indiana University
Pages: 22 Size: 643 Kb 
tweet!  Exploring the Relationship Between Substance Abuse and Dependence Disorders and Discharge Status: Results and Implications
  Deanna Schreiber-Gregory, Henry M Jackson Foundation for the Advancement of Military Medicine
Pages: 25 Size: 344 Kb 
tweet!  Lag Models with Social Response Outcomes
  David Corliss, Peace-Work
Keywords: paper sample
Pages: 9 Size: 539 Kb 
tweet!  The (Higher) Power of SAS®
  Andrea Frazier, Presence Health
Pages: 3 Size: 142 Kb 
Hands-on Workshops
tweet!  Hands-on Introduction to SAS® and the ODS Excel® Destination
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords: SAS, ODS, Output Delivery System, Excel, ODS Excel, %DS2CSV macro, %DS2CSV, author, sas press, sas press author, consultant, sas consultant, sql, sql consultant, Lafler, Kirk Lafler, Kirk Paul Lafl ...
Pages: 26 Size: 1537 Kb 
tweet!  Using a Few SAS Functions to Clean Dirty Data
  Ben Cochran, The Bedford Group
Pages: 9 Size: 104 Kb 
tweet!  Base SAS® and SAS® Enterprise Guide® ~ Automate Your SAS World with Dynamic Code; Your Newest BFF (Best Friend Forever) in SAS
  Kent Phelps, Illuminator Coaching, Inc.; Ronda Phelps, Illuminator Coaching, Inc.
Keywords: SAS, sas professionals, sas programming, sas intuition, sas quest, sas wis-h-dom, Enterprise Guide, EG, graphical user interface, GUI, DATA step, base sas, program node, sas commands, routines, cal ...
Pages: 35 Size: 1331 Kb 
tweet!  A Hands-On Introductory Tour of SAS® ODS Graphics
  Ted Conway, Self
Pages: 4 Size: 500 Kb 
tweet!  Intermediate SAS® ODS Graphics
  Chuck Kincaid, Experis Business Analytics
Pages: 28 Size: 1000 Kb 
Pharmaceutical Applications
tweet!  Mapping MRI data to SDTM and ADaM
  Lingling Xie, Eli Lilly and Company; Xiaoqi Li, Eli Lilly and Company
Pages: 10 Size: 415 Kb 
tweet!  ISO 8601 and SAS®: A Practical Approach
  Derek Morgan, PAREXEL
Keywords: ISO 8601 Formats Informats IS_8601_CONVERT routine
Pages: 9 Size: 134 Kb 
tweet!  AIR Binder 2.0: A Dynamic Visualization, Data Analysis and Reporting SAS Application for Preclinical and Clinical ADME Assays, Pharmacokinetics, Metabolite Profiling and Identification
  Hao Sun, Covance, Inc.; Kristen Cardinal, Covance, Inc.; Richard Voorman, Covance, Inc.
Pages: 26 Size: 1934 Kb 
Best Paper
tweet!  Automated Validation of Complex Clinical Trials Made Easy
  Richann Watson, Experis; Josh Horstman, Nested Loop Consulting
Keywords: automated validation SAS COMPARE
Pages: 35 Size: 299 Kb 
tweet!  ADQRS: Basic Principles for Building Questionnaire, Rating and Scale Analysis Datasets
  Nancy Brucken, InVentiv Health Clinical; Karin Lapann, Shire
Keywords: ADaM ADQRS questionnaire rating scale
Pages: 6 Size: 85 Kb 
Rapid Fire
tweet!  Ignorance is not bliss - understanding SAS applications and product contents
  Jayanth Iyengar, Data Systems Consultants LLC
Keywords: SAS Modules Base SAS SAS/Access SAS Display Manager
Pages: 7 Size: 699 Kb 
tweet!  Quotes within Quotes: When Single (') and Double (") Quotes are not Enough
  Art Carpenter, CA Occidental Consultants
Keywords: Quotes Macro variable resolution Apostrophe Single quotes Double quotes parsing %BQUOTE
Pages: 7 Size: 240 Kb 
tweet!  No News Is Good News: A Smart Way to Impute Missing Clinical Trial Lab Data
  Ming Yan, Eli Lilly
Pages: 4 Size: 447 Kb 
Best Paper
tweet!  Macro that can Provide More Information for your Character Variables
  Ting Sa, Cincinnati Children's Hospital Medical Center
Pages: 7 Size: 453 Kb 
tweet!  Cleaning Messy Data: SAS Techniques to Homogenize Tax Payment Data
  Aaron Barker, Iowa Department of Revenue
Pages: 8 Size: 410 Kb 
tweet!  PROC DOC III: Self-generating Codebooks Using SAS®
  Louise Hadden, Abt Associates Inc.
Pages: 8 Size: 312 Kb 
tweet!  What Are Occurrence Flags Good For Anyway?
  Nancy Brucken, InVentiv Health Clinical
Keywords: ADaM OCCDS OCCyyFL occurrence
Pages: 4 Size: 27 Kb 
SAS 101
tweet!  An Introduction to PROC REPORT
  Kirk Paul Lafler, Software Intelligence Corporation
Keywords: sas, report, reports, reporting, PROC REPORT, compute block, author, sas press, sas press author, consultant, sas consultant, consulting, sas consulting, programmer, sas programmer, educator, sas e ...
Pages: 17 Size: 886 Kb 
tweet!  If you need these OBS and these VARS, then drop IF, and keep WHERE
  Jayanth Iyengar, Data Systems Consultants LLC
Keywords: DATA step subsetting IF WHERE efficiency
Pages: 9 Size: 672 Kb 
tweet!  The Essentials of SAS® Dates and Times
  Derek Morgan, PAREXEL
Keywords: Introduction Dates Times Datetimes Formats Informats Functions Intervals
Pages: 20 Size: 234 Kb 
tweet!  PROC SORT (then and) NOW
  Derek Morgan, PAREXEL
Keywords: PROC SORT National Language Support
Pages: 9 Size: 125 Kb 
tweet!  Working with Datetime Variable from Stata
  Haiyin Liu, University of Michigan; Wei Ai, University of Michigan
Pages: 3 Size: 150 Kb 
tweet!  Merge with Caution: How to Avoid Common Problems when Combining SAS Datasets
  Josh Horstman, Nested Loop Consulting
Keywords: MWSUG 2017
Pages: 14 Size: 479 Kb 
tweet!  Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS® Code
  Josh Horstman, Nested Loop Consulting
Keywords: MWSUG 2017
Pages: 10 Size: 744 Kb 
tweet!  Parsing Useful Data Out of Unusual Formats Using SAS®
  Andrew Kuligowski, HSN
Pages: 15 Size: 249 Kb 
tweet!  The Building Blocks of SAS® Datasets - S-M-U (Set, Merge, and Update)
  Andrew Kuligowski, HSN
Pages: 13 Size: 328 Kb 
tweet!  Before You Get Started: A Macro Language Preview in Three Parts
  Art Carpenter, CA Occidental Consultants
Keywords: Macro variables scope macro timing %LET statement symbol tables %MACRO %MEND %LOCAL %GLOBAL
Pages: 9 Size: 522 Kb 
Best Paper
tweet!  Writing Code With Your Data: Basics of Data-Driven Programming Techniques
  Joe Matise, NORC
Pages: 9 Size: 270 Kb 
tweet!  Make That Report Look Great Using the Versatile PROC TABULATE
  Ben Cochran, The Bedford Group
Pages: 12 Size: 211 Kb 
tweet!  The Battle of the Titans (Part II): PROC TABULATE versus PROC REPORT
  Kirk Paul Lafler, Software Intelligence Corporation; Ben Cochran, The Bedford Group; Ray Pass, Retired - and loving it!
Keywords: sas, report, reports, reporting, PROC TABULATE, tabulate, PROC REPORT, report, detail output, summary report, Excel spreadsheet, enhanced report, author, sas press, sas press author, consultant, sa ...
Pages: 14 Size: 798 Kb 
tweet!  A Walk through Time: Growing Your SAS Career
  Art Carpenter, CA Occidental Consultants
Keywords: INTCK INTNX MDY Timeline SAS Programming Career Development
Pages: 8 Size: 521 Kb 
Statistics / Advanced Analytics
tweet!  Using SAS to Compare Two Estimation Methods on the Same Outcome: Example from First Trimester Pregnancy Weights
  Brandy Sinco, University of Michigan; Edith Kieffer, University of Michigan; Kathleen Welch, University of Michigan; Diana Welmerink Bolton, University of Michigan
Pages: 15 Size: 237 Kb 
tweet!  Logistic Model Selection with SAS® PROC's LOGISTIC, HPLOGISTIC, HPGENSELECT
  Bruce Lund, Independent Consultant
Pages: 18 Size: 802 Kb 
tweet!  Claim Analytics
  Mei Najim, Gallagher Bassett Services, Inc.
Pages: 18 Size: 1237 Kb 
tweet!  Unconventional Statistical Models with the NLMIXED Procedure
  Robin High, University of Nebraska Medical Center
Pages: 14 Size: 402 Kb 
Best Paper
tweet!  Multiple Imputation of Family Income Data in the 2015 Behavioral Risk Factor Surveillance System
  Jia Li, NIOSH; Aaron Sussell, NIOSH
Pages: 4 Size: 203 Kb 
tweet!  GREMOVE, Reassign, and let's GMAP! A SAS Trick for Generating Contiguous Map Boundaries for Market-Level Research
  Chad Cogan, Arbor Research Collaborative for Health; Jeffrey Pearson, Arbor Research Collaborative for Health; Purna Mukhopadhyay, Arbor Research Collaborative for Health; Charles Gaber, Arbor Research Collaborative for Health; Marc Turenne, Arbor Research Collaborative for Health
Keywords: GREMOVE maps healthcare markets contiguity
Pages: 19 Size: 375 Kb 
tweet!  Correcting for Selection Bias in a Clinical Trial
  Shana Kelly, Spectrum Health
Pages: 8 Size: 368 Kb 
tweet!  Dimensionality Reduction using Hadamard, Discrete Cosine and Discrete Fourier Transforms in SAS
  Mohsen Asghari, Computer Engineering and Computer Science Department, University Of louisville; Aliasghar Shahrjooihaghighi, Computer Engineering and Computer Science Department, University Of louisville; Ahmad Desoky, Computer Engineering and Computer Science Department, University Of louisville
Pages: 12 Size: 675 Kb 
tweet!  Nothing to SNF At: Evaluating an intervention to reduce skilled nursing home (SNF) length of stay
  Andrea Frazier, Presence Health
Pages: 4 Size: 163 Kb 
tweet!  How Can an NBA Player Be Clutch?: A Logistic Regression Analysis
  Logan Edmonds, Oklahoma State University
Pages: 18 Size: 1321 Kb 
tweet!  Multicollinearity: What Is It and What Can We Do About It?
  Deanna Schreiber-Gregory, Henry M Jackson Foundation for the Advancement of Military Medicine
Pages: 12 Size: 554 Kb 
tweet!  Oscars 2017 - Text Mining & Sentimental Analysis
  Karthik Sripathi, Oklahoma State University
Pages: 9 Size: 453 Kb 
tweet!  Text and Sentiment Analysis of customer tweets of Nokia using SAS® Enterprise Miner and SAS® Sentiment Analysis Studio
  Vaibhav Vanamala, Oklahoma State University
Pages: 8 Size: 794 Kb 
tweet!  Tornado Inflicted Damages Pattern
  Vasudev Sharma, Oklahoma State University
Pages: 11 Size: 633 Kb 
tweet!  Agricultural Trip Generation - Linking Spatial Data and Travel Demand Modeling using SAS
  Alan Dybing, North Dakota State University - Upper Great Plains Transportation Institute
Pages: 9 Size: 635 Kb 
Getting Started with Multilevel Modeling
  Mike Patetta, SAS
Power and Sample Size Computations
  John Castelloe, SAS
Tips and Best Practices Using SAS® in the Analytical Data Life Cycle
  Tho Nguyen, Teradata; Paul Segal, Teradata
System Architecture and Administration
Using Agile Analytics for Data Discovery
  Bob Matsey, Teradata
The Future of the SAS Platform
  Amy Peters, SAS
Tools of the Trade
tweet!  Generating Reliable Population Rates Using SAS® Software
  Jack Shoemaker, MDwise
Pages: 6 Size: 147 Kb 
tweet!  Check Please: An Automated Approach to Log Checking
  Richann Watson, Experis
Pages: 19 Size: 288 Kb 
tweet!  Arbovirus, Varicella and More: Using SAS® for Reconciliation of Disease Counts
  Misty Johnson, State of WI-DHS
Keywords: Communicable disease SAS LAST by-group macro variables re-useable code symbolgen PUT 64-bit SAS FIND SUBSTR PROC FREQ PROC TABULATE PROC REPORT ODS
Pages: 8 Size: 281 Kb 
tweet!  Code Like It Matters: Writing Code That's Readable and Shareable
  Paul Kaefer, UnitedHealthcare
Keywords: SAS coding standards best practices version control git comments documentation software development programming
Pages: 11 Size: 278 Kb 
Best Paper
tweet!  From Device Text Data to a Quality Dataset
  Laurie Smith, Cincinnati Children's Hospital Medical Center
Pages: 6 Size: 68 Kb 
tweet!  Proc Transpose Cookbook
  Doug Zirbel, Wells Fargo and Co.
Pages: 12 Size: 677 Kb 
tweet!  Get Smart! Eliminate Kaos and Stay in Control - Creating a Complex Directory Structure with the DLCREATEDIR Statement, SAS® Macro Language, and Control Tables
  Louise Hadden, Abt Associates Inc.
Pages: 9 Size: 286 Kb 
tweet!  An Array of Possibilities: Manipulating Longitudinal Survey Data with Arrays
  Lakhpreet Gill, Mathematica Policy Research
Pages: 8 Size: 740 Kb 
tweet!  Fully Automated Updating of Arbitrarily Complex Excel Workbooks
  David Oesper, Lands' End
Pages: 4 Size: 34 Kb 
e-Posters
tweet!  Red Rover, Red Rover, Send Data Right Over: Exploring External Geographic Data Sources with SAS®
  Louise Hadden, Abt Associates Inc.
Pages: 9 Size: 437 Kb 
Best Paper
tweet!  SAS/GRAPH® and GfK Maps: a Subject Matter Expert Winning Combination
  Louise Hadden, Abt Associates Inc.
Pages: 22 Size: 1075 Kb 
tweet!  Data Quality Control: Using High Performance Binning to Prevent Information Loss
  Lakshmi Nirmala Bavirisetty, Independent SAS User; Deanna Schreiber-Gregory, Henry M Jackson Foundation for the Advancement of Military Medicine
Pages: 9 Size: 482 Kb 
tweet!  Let's Get FREQy with our Statistics: Let SAS® Determine the Appropriate Test Statistic Based on Your Data
  Lynn Mullins, PPD; Richann Watson, Experis
Keywords: FREQ Cochran-Armitage Binomial Proportion Confidence Intervals
Pages: 14 Size: 256 Kb 
Powered by SAS®.
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.
Copyright © 1999-2017 Lex Jansen. All rights reserved.