WUSS 2014 Conference Proceedings

San Jose, California
September 3-5, 2014

Analytics & Statistics

(PDF) Reanalysis of Ecological Data from the 1989 China Study Using SAS Enterprise Guide
Author: Thomas E. Billings, MUFG Union Bank

(PDF) Fuzzy Bootstrap Matching
Author: Dale Harrington, Well Point

(PDF) Quick Analysis and Visualization of Excluded and Missing Data
Author: Polina Kukhareva, University of Utah

(PDF) SAS Macros for Standard Incidence Ratio Calculation
Authors: Natalia V Udaltsova, Kaiser Permanente; Michael Silverberg, Kaiser Permanente

(PDF) Markov Chain Model Forecast for Interrelated Time Series Data Using SAS/IML
Author: Gongwei Chen, Washington State Caseload Forecast Council

(PDF) A Statistical and Visual Exploration of the Surveillance, Epidemiology, and End Results (SEER) Database Using SAS
Author: Christopher Yim, California Polytechnic State Univeristy – San Luis Obispo

(PDF) Analyzing Phased Interventions with Segmented Regression and Stepped Wedge Designs
Authors: Eric C. Wong, Palo Alto Medical Foundation Research Institute; Po-Han Chen, Palo Alto Medical Foundation Research Institute; Dorothy Hung, Palo Alto Medical Foundation Research Institute

(PDF) Efficient Cut-point Estimation and Validation using PROC PHREG
Author: Alan Mitchell, Cancer Research and Biostatistics

(PDF) Options in Estimating Nonlinear Mixed Models: Quadrature points and Approximation Methods
Authors: Nate Smith, University of California Davis; Shelley Blozis, University of California Davis

(PDF) Using SAS to do it all
Authors: Chelsea Lofland; Rebecca Ottesen

(PDF) Using and Understanding LSMEANS and LSMESTIMATE
Author: David J. Pasta, ICON Clinical Research

(PDF) Using PROC FACTOR for variable inclusion in PROC SURVEYLOGISTIC: A Case Study
Keywords: Proc Surveylogistic, Proc Factor, behavioral health, risky behaviors, NDSU, SAS
Author: Deanna Schreiber-Gregory, North Dakota State University

(PDF) Decision Trees as a Predictive Modeling Method
Author: Gerald R. Hobbs, West Virginia University

Applications Development

(PDF) Differences in Functionality of Error Handling Features, SAS Enterprise Guide vs. Batch
Author: Thomas E. Billings, MUFG Union Bank

(PDF) Table Lookup Techniques: From the Basics to the Innovative
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) Wow! You did that with SAS Stored Processes?
Author: David Mitchell, Solution Design Team

(PDF) Automation of Appending Reports: A Sexy New Look
Author: Bill Coar, Axio Research

(PDF) When Software Development is Your Means Not Your End: Abstracting Agile Methodologies for End-User Development and Analytic Application
Keywords: SAS, software development, software development lifecycle, SDLC, agile, agile methodologies, Scrum, Lean, Extreme Programming, waterfall development, best practices
Author: Troy Martin Hughes

(PDF) Best Practices: Subset Without Getting Upset
Keywords: SAS, subset, subsetting, by-group, by-group processing, subgroup analysis, best practice, SQL, SAS SQL, PROC SQL, joins, LEFT join, Coalesce, Rosenbloom, Lafler
Authors: Mary F. O. Rosenbloom, Edwards Lifesciences LLC; Kirk Paul Lafler, Software Intelligence Corporation

(PDF) SAS DICTIONARY: Step by Step
Keywords: VOPTION, VGOPT, VTITLE, VLIBNAM, VENGINE, VEXTFL, VMACRO, VMEMBER, VTABLE, VVIEW, VCOLUMN, VINDEX, VDCTNRY, VCATALG, VFORMAT, VCHKCON, VREFCON, VTABCON, VCNTABU, VCNCOLU, VINFOMP, VFILTER, VDATAIT, VPROMPT, VPRMXML, VDEST, VSTYLE, VFUNC, VREMEMB
Author: Patrick Thornton, SRI International

(PDF) Macro Design Ideas: Theory, Template, Practice
Author: Ronald J. Fehd, Stakana Analytics

Beyond the Basics

(PDF) An Introduction to SAS Hash Programming Techniques
Keywords: SAS, Hash, hash object, hash data step construct, how to sas hash, sas hash basics, hash methods, hash programming, hash technique, hash programming technique, match-merge, join, author, author lafler, sas press, sas press author, sas press author lafler, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Not All Equals are Created Equal: Nonstandard Statement Structures in the DATA Step
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) Set Yourself Free – Use ODS Report Writing Technology in SAS Enterprise Guide Instead of Dynamic Data Exchange in PC SAS
Author: Robert Springborn, Office of Statewide Health Planning & Development

(PDF) Set Yourself Free – Use ODS Report Writing Technology in SAS Enterprise Guide Instead of Dynamic Data Exchange in PC SAS Part II SAS Code Revealed
Author: Robert Springborn, Office of Statewide Health Planning & Development

(PDF) The Three I’s of SAS Log Messages, IMPORTANT, INTERESTING, and IRRELEVANT
Keywords: notes, warnings, errors
Author: William E. Benjamin, Jr., Owl Computer Consultancy LLC

(PDF) Intervals, Enhanced
Author: Derek P. Morgan, Mallinckrodt Pharmaceuticals

(PDF) Delivering Dynamic, Real-Time Reports to MS Office Users as Stored Processes
Authors: Sy J. Truong, Meta-Xceed; Carey G. Smoak, Roche Molecular Systems, Inc

(PDF) Different ways of calculating percentiles using SAS
Author: Arun Akkinapalli, eBay Inc

(PDF) A Survey of Some Useful SAS Functions
Author: Ron Cody

Big Data

(PDF) Leads and Lags: Handling Queues in The SAS DATA STEP
Author: Mark Keintz, Wharton Research Data Services

(PDF) Conquering Big Data Analytics Challenges with SAS, Teradata and Hadoop
Authors: Tho H. Nguyen, Teradata; Paul Segal, colleague; John Cunningham, colleague

(PDF) SAS and Teradata: Innovators and Leaders for Big Data Analytics
Authors: Tho H. Nguyen, Terradata; John Cunningham, Terradata

(PDF) SAS In-Database Analytics for Teradata: Stop the Data Movement
Authors: Tho H. Nguyen, Teradata; Paul Segal, Teradata

(PDF) SAS In-Memory Analytics: Beyond Foundation SAS
Authors: John Cunningham, Teradata; Tho H. Nguyen, Teradata

(PDF) Parallel Data Preparation with the DS2 Programming Language
Authors: John Cunningham, Teradata; Tho H. Nguyen, Teradata

Data Management

(PDF) Macro free automation to identify and drop variables with all values as missing
Authors: Amarnath Vijayarangan, Genpact, India; Vamse Goutam, Genpact

(PDF) Generation Data Groups and their Data Set Metadata (AKA Dropping Bread Crumbs).
Author: Jess Watkins, CVS Caremark

(PDF) How can I simplify ETL when I only have Base SAS
Author: Steve Cavill, NSW Bureau of Crime Statistics and Research

(PDF) Reporting MDM Data Attribute Inconsistencies for the Enterprise Using DataFlux
Author: Ernesto Roco, Hyundai Capital America

(PDF) Advanced Multiprocessing Techniques for Performance Improvement of SAS Processes
Author: Viraj R. Kumbhakarna, JP Morgan Chase & Co

(PDF) A Hitchhiker’s guide for performance assessment & benchmarking SAS applications
Author: Viraj R. Kumbhakarna, JP Morgan Chase & Co

(PDF) A Practical Approach to Process Improvement Using Parallel Processing
Author: Viraj R. Kumbhakarna, JP Morgan Chase & Co

(PDF) Automate & Shrink SAS programs using DO loops & Macros!
Author: Arun Akkinapalli, eBay Inc

(PDF) Tweet-o-matic: An Automated Approach to Batch Processing of Tweets
Authors: Isabel Litton, California Polytechnic State University; Rebecca Ottesen, City of Hope

(PDF) Don’t Let a Bad Date Ruin Your Day: Dealing with Invalid Dates in SAS
Author: Lucheng Shao, Ivantis, Inc

(PDF) Dealing with Missing Data in Clinical Trials
Author: Lucheng Shao, Ivantis, Inc

(PDF) From a One-Horse to a One-Stoplight Town: A Base SAS Solution to Preventing Data Access Collisions through the Detection and Deployment of Shared and Exclusive File Locks
Keywords: SAS, software quality, software reliability, software robustness, data set availability, file access collision, LOCK statement, software performance
Author: Troy Martin Hughes

Data Presentation & Reporting

(PDF) Automated Log Analyzer Dashboard
Authors: Amarnath Vijayarangan, Genpact, India; Palanisamy Mohan, Cognizant Technology Solutions

(PDF) %ICD: Using Hash Objects to Separate Records Coded in ICD-9-CM from Records Coded in ICD-10-CM
Author: Eduard Poltavskiy, UC Davis

(PDF) Macros to Manage your Macros?
Author: Garrett Weaver, University of Southern California

(PDF) Using SAS Enterprise Business Intelligence to Automate a Manual Process: A Detailed Case Study
Author: Erik S. Larsen, Independent Consultant

(PDF) Using R in the SAS System
Author: Alan Mitchell, Cancer Research and Biostatistics

(PDF) The Evolution of SAS Programs Used to Analyze Judicial Salaries
Authors: Humberto Cisneros, Arizona Supreme Court; Carrin Huff, Arizona Supreme Court

Hands-On Workshops

(PDF) Point-and-Click Programming Using SAS Enterprise Guide
Keywords: SAS, SAS EG, Enterprise Guide, Point-and-click programming, MS-Excel, data manipulation, system documentation, process flow diagrams, built-in wizards, sas training, sas trainer, sas consulting, sas consultant, sql training, sql trainer, sql consulting, sql consultant, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd, Shapiro, Mira Shapiro
Authors: Kirk Paul Lafler, Software Intelligence Corporation; Mira Shapiro, Analytic Designers LLC

(PDF) Programming With CLASS: Keeping Your Options Open
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) Using PROC SGPLOT for Quick, High-Quality Graphs
Authors: Susan J. Slaughter, Avocet Solutions; Lora D. Delwiche, University of California, Davis

(PDF) Are You a Control Freak? Control Your Programs – Don’t Let Them Control You!
Keywords: Control file, macro list, CALL SYMPUTX, CALL EXECUTE, macro language, macro arrays, Rosenbloom, Carpenter
Authors: Mary F. O. Rosenbloom, Edwards Lifesciences LLC; Arthur L. Carpenter, CA Occidental Consultants

(PDF) How to Use Proc Tabulate – Hands-on workshop
Author: Tasha Chapman, Oregon Department of Human Services

(PDF) The SAS Hash Object in Action
Author: Paul M. Dorfman, Independent SAS Consultant

(PDF) Getting Your Hands on Reproducible Graphics
Keywords: ODS Graphics Designer, TEMPLATE, SGRENDER, GTL, macros
Authors: Rebecca Ottesen, City of Hope; Leanne Goldstein, City of Hope

Industry Solutions

(PDF) TLF Validation Etiquette:What to Say, When to Say, How to Say, Why to Say
Author: Karen Walker, InVentiv Health Clinical

(PDF) Practice Pattern Instrumental Variables for Comparative Effectiveness
Authors: Carol Conell, Division of Research Kaiser Permanente Northern California; Alexander C. Flint, Department of Neuroscience Kaiser Permanente Northern California

(PDF) Exploring Phase 1 ADaM Deriving System from SDTM
Author: Yiwen Li, Gilead Sciences

(PDF) Particle Swarm Optimization in SAS
Author: Gregory Watson, University of California, Los Angeles

(PDF) Breaking Eggs to Make Omelets: Distributing Analytic Effort with Scrambled Datasets
Authors: E. Margaret Warton, Kaiser Permanente Division of Research; Howard Moffet, Kaiser Permanente Division of Research; Andrew Karter, Kaiser Permanente Division of Research

(PDF) Big Data in a Small Trial: Visual and Statistical Analyses in an N-of-1 Clinical Trial
Author: Marie Boman-Davis, National University

(PDF) Delivering SAS Reports and Data to Web Portal
Author: Sy J. Truong, Meta-Xceed

(PDF) Expediting Access to Critical Pathology Data
Authors: Leanne Goldstein, City of Hope; Rebecca Ottesen, City of Hope; Julie A. Kilburn, City of Hope; Joyce C. Niland, City of Hope

Posters

(PDF) Using SAS and the Centers for Disease Control and Prevention 2010 Natality Data to Estimate the Effect Size of Prenatal Visits on Preterm Birth
Author: Melissa Borelli, National University Graduate Student

(PDF) Design of Experiments (DOE) Using JMP
Keywords: Charles Edwin Shipp, Kirk Paul Lafler, Charlie Shipp, Design of Expermients, DOE using JMP, JMP Design of Experiments, JMP, WUSS
Author: Charles Edwin Shipp, Consider Consulting Corporation

Design of Experiments (DOE) Using JMP
Author: Charles Edwin Shipp, Consider Consulting Corporation

Analyzing Alcohol Behavior of San Luis Obispo County
Author: Ariana (Audi) Montes, California Polytechnic University

Enhancing Infrastructure for Growth
Authors: Bill Coar, Axio Research; Amber Randall, Axio Research

Professional Development

(PDF) Suggestions for Writing Better SAS User Group Papers
Author: Thomas E. Billings, MUFG Union Bank

(PDF) SAS Certification as a Tool for Professional Development
Authors: Andra Northup, Advanced Analytic Designs; Susan J. Slaughter, Avocet Solutions

(PDF) Careers in Biostatistics and Clinical SAS Programming: An Overview for the Uninitiated
Author: Justina M. Flavin, Independent Consultant

(PDF) Recruiting for Retention
Authors: Kathy Greer, DataCeutics; John Reilly, DataCeutics

Quick Tips

(PDF) JMP Visual Statistics
Keywords: Charles Edwin Shipp, Kirk Paul Lafler, JMP, JMP Visual Statistics, WUSS
Author: Charles Edwin Shipp, Consider Consulting Corporation

(PDF) Alert when one is not Alert: SAS Call Sound Function
Authors: Amarnath Vijayarangan, Genpact, India; Palanisamy Mohan, Cognizant Technology Solutions; Vamse Goutam, Genpact

(PDF) A SAS Macro to Produce Summary Statistics Tables Allowing Additional Stratification
Authors: Amanda Liu, Cerus Corporation; David E. Tappe, Cerus Corporation

(PDF) PROC COMPARE: What Did I Inadvertently Change?
Author: Melissa R. Pfeiffer, MRP Consulting

(PDF) Take a Macro Break from ODS-Generated Section Breaks in RTF Files
Authors: Faith Beery, ICON Clinical Research; Ginny Sen, ICON Clinical Research

(PDF) It’s Simpler than You Think: An example of a Patient Summary Report generated using SAS and ODS PDF
Authors: Julie A. Kilburn, City of Hope; Leanne Goldstein, City of Hope

(PDF) Conjunction, What’s Your Function?: How PRXCHANGE Saved The Day
Keywords: PRXCHANGE, Perl Regular Expressions, text substitution, WUSS, WUSS 2014
Authors: Mary F. O. Rosenbloom, Edwards Lifesciences LLC; Jennifer Mares, Edwards Lifesciences LLC; Trina Patel, Edwards Lifesciences LLC

(PDF) DATA Step MODIFY and UPDATE Statements: Do They Preserve Integrity Constraints?
Author: Baskar Anjappan, MUFG Union Bank, N.A.

(PDF) Quick Tips on Powerful use of Arrays
Author: Rahul Pillay, Northrop Grumman

(PDF) List Processing Macro Call-Macro
Author: Ronald J. Fehd, Stakana Analytics

(PDF) Using Cardinality Ratio for Fast Data Review
Author: Ronald J. Fehd, Stakana Analytics

(PDF) Reassigning character variable lengths across multiple datasets for Efficiency and Consistency
Authors: Srinivas Vanam, Percept Pharma Services; Phaneendhar Reddy Vanam, Percept Pharma Services, Inc.; Mahipal R. Vanam, Percept Pharma Services, Inc.

SAS Essentials Workshop

(PDF) SAS Debugging 101
Keywords: SAS, error, errors, warning, warnings, SAS log, log, debug, debugging, sas debugging, sas debugging techniques, consultant, sas consultant, sas consulting, sql, sql consultant, sql consulting, author, sas author, sas author lafler, sas press, sas press author, trainer, sas trainer, sql trainer, training, sas training, sql training, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) You Say ‘Day-ta’, I Say ‘Dat-a’ – Processing Your DATA Efficiently and Ensuring Its Integrity
Keywords: Proc Download, Proc Upload, Proc Import, Proc Export, SAS Proc Download, SAS Proc Upload, SAS Proc Import, SAS Proc Export, SAS Data Transfer Services, Data Transfer Services, SAS DTS, SAS Remote Library Services, Remote Library Services, SAS RLS, SAS Network File Compression, SAS/Connect, SAS Improving Resources, SAS Performance Booster, SAS Improving Performance, SAS Data Step vs SQL, SAS Data Step vs Proc Sql, Jason Beene, Jason R. Beene, Mary Katz, Mary Federico, Mary Federico Katz, SAS Increasing Efficiency, SAS Data Integrity
Authors: Mary Federico Katz, Wells Fargo Bank; Jason R. Beene, Wells Fargo Bank

(PDF) Getting Up to Speed with PROC REPORT
Author: Kimberly Stinson LeBouton, K.J.L Computing

(PDF) The Essentials of SAS Dates and Times
Author: Derek P. Morgan, Mallinckrodt Pharmaceuticals

(PDF) Paperwork without tears: Completing your reporting requirements in 10 easy steps
Author: AnnMaria De Mars, 7 Generation Games

(PDF) SAS Essentials I (or How I Learned to Stop Worrying and Love SAS)
Author: Tasha Chapman, Oregon Department of Human Services

(PDF) SAS Essentials II (or How to Train Your SAS Data Sets)
Author: Tasha Chapman, Oregon Department of Human Services

(PDF) SAS Essentials III (or How to Succeed in SAS Without Really Trying)
Author: Tasha Chapman, Oregon Department of Human Services