WUSS 2016 Conference Proceedings

San Francisco, California
September 7-9, 2016

Advanced Techniques

(PDF) Finding All Differences in two SAS libraries using Proc Compare
Author: Bharat Kumar Janapala

(PDF) Talk to Me!
Author: Elizabeth N. Axelrod, Abt Associates Inc.

(PDF) MIghty PROC MI to the rescue!
Author: Cynthia Alvarez, ICON Clinical Research

(PDF) Ushering SAS Emergency Medicine into the 21st Century: Toward Exception Handling Objectives, Actions, Outcomes, and Comms
Keywords: SAS, exception handling, exception reporting, error handling, error trapping, exception, software communication, happy trail, happy path, graceful termination, business value, SAS macro language, SAS macros, SYSERR, SYSCC, software quality, software performance
Author: Troy Martin Hughes

(PDF) A Waze App for Base SAS : Automatically Routing around Locked Data Sets, Bottleneck Processes, and Other Traffic Congestion on the Data Superhighway
Keywords: SAS, file lock, locked data, exclusive file lock, shared file lock, read-only file lock, read-write file lock, ETL, extract-transform-load, software dependency, parallel processing, software speed, software efficiency, SAS macro language, SAS macros, LOCK statement
Author: Troy Martin Hughes

(PDF) Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS Code
Author: Josh Horstman, Nested Loop Consulting

(PDF) .LST Files with Proc Compare Result
Authors: Phaneendhar Reddy Vanam, PV; Manvitha Yennam, Percept Pharma Services; Srinivas Vanam, Percept Pharma Services

(PDF) Let SAS Do Your DIRty Work
Keywords: DIR UNIX CMD
Author: Richann Watson, Experis

(PDF) Check Please: An Automated Approach to Log Checking
Keywords: SAS LOG
Author: Richann Watson, Experis

(PDF) Let the Environment Variable Help You: Moving Files across Studies and Creating SAS Library On-The-Go
Author: David Liang, Chiltern International

User-Written vs. System-Generated SAS Source Code: Is System-Generated Code a Boon or Bane to Programmers?
Author: Thomas E. Billings, MUFG Union Bank

Analytics and Statistics

(PDF) Distance Correlation for Vectors: A SAS Macro
Author: Thomas E. Billings, MUFG Union Bank

(PDF) Short Introduction to Reliability Engineering and PROC RELIABILITY to Non-Engineers
Author: Danny Rithy, California Polytechnic State University

(PDF) How D-I-D you do that? Basic Difference-in-Differences Models in SAS
Authors: E. Margaret Warton, Kaiser Permanente Division of Research; Melissa Parker, Kaiser Permanente Division of Research; Andrew Karter, Kaiser Permanente Division of Research

(PDF) Fitting Threshold Models using the SAS Procedures NLIN and NLMIXED
Author: Todd Coffey, Washington State University

(PDF) Using SAS to analyze Countywide Survey Data: A look at Adverse Childhood Experiences
Author: Roshni Shah, Santa Clara County Public Health Department, San Jose, CA

(PDF) Employing Latent Analyses in Longitudinal Studies: An Exploration of Independently Developed SAS Procedures
Author: Deanna Schreiber-Gregory, National University

(PDF) Selection Bias: How Can Propensity Score Utilization Help Control For It?
Author: Deanna Schreiber-Gregory, National University

(PDF) Demystifying the CONTRAST and ESTIMATE Statement
Author: Hector Lemus, SDSU

(PDF) Knowledge is Power: The Basics of SAS Proc Power
Author: Elaina Gates, California Polytechnic University – San Luis Obispo

(PDF) Creating meaningful factors from dietary questionnaires
Author: Jenna Carlson, University of Pittsburgh

(PDF) Constructing Confidence Intervals for the Differences of Binomial Proportions in SAS
Author: William Garner, Gilead Sciences, Inc

(PDF) Equivalence Tests
Authors: John Amrhein, McDougall Scientific Ltd.; Fei Wang, McDougall Scientific Ltd.

(PDF) How we know an intervention works: Program evaluation by example
Author: AnnMaria De Mars, 7 Generation Games

(PDF) Simulating Queuing Models in SAS
Author: Danny Rithy, California Polytechnic State University

(PDF) Bayesian Concepts: An Introduction
Author: John Amrhein, McDougall Scientific Ltd.

(PDF) The REPORT Procedure: A Primer for the Compute Block
Author: Jane Eslinger, SAS

(PDF) Fitting Your Favorite Mixed Models with PROC MCMC
Author: Fang K. Chen, SAS

(PDF) Introducing the HPGENSELECT Procedure: Model Selection for Generalized Linear Models and More
Author: Robert N. Rodriguez, SAS

(PDF) An Animated Guide: Insights into the Logic of the ROC Curve
Author: Russell M. Lavery

Beginner’s Techniques

(PDF) The SAS Ecosystem A Programmer s Perspective
Author: Thomas E. Billings, MUFG Union Bank

(PDF) Don’t Forget About Small Data
Author: Lisa Eckler, Lisa Eckler Consulting Inc.

(PDF) Getting it Done with PROC TABULATE
Author: Michael Williams, ICON Clinical Research

(PDF) Identifying Duplicates Made Easy
Authors: Yunin Ludena, University of California, Davis; Elizabeth Guerrero Angel, University of California, Davis

(PDF) Making Prompts Work for You: Using SAS Enterprise Guide Prompts with Categorization of Output
Authors: Edward Lan, Los Angeles County Department of Public Health; Kai-Jen Cheng, Los Angeles County Department of Public Health

(PDF) Let the CAT Out of the Bag: String Concatenation in SAS 9
Author: Josh Horstman, Nested Loop Consulting

(PDF) Good Programming Practice [GPP] in SAS & Clinical Trials
Authors: Phaneendhar Reddy Vanam, PV; Srinivas Vanam, Percept Pharma Services; Manvitha Yennam, Percept Pharma Services

Big Data

(PDF) Top Ten SAS Performance Tuning Techniques
Keywords: SAS, performance tuning, CPU, I/O, Memory, Storage, efficiency, programming efficiency, Programming Time, author, SAS Press, SAS Press author, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) SAS integration with NoSQL database
Author: Kevin Lee, Clindata Insight

(PDF) Using Shared Accounts in Kerberized Hadoop Clusters with SAS : How Can I Do That?
Author: Michael Shealy, Cached Consulting, LLC

(PDF) Sorting a Bajillion Records: Conquering Scalability in a Big Data World
Keywords: SAS, data sorting methods, PROC SORT, SORT procedure, hash object ORDERED option, PROC SQL ORDER BY statement, software quality, software performance, software scalability, performance failure, performance testing, load testing, stress testing, sequential data sorting, runtime evaluation, memory usage evaluation
Author: Troy Martin Hughes

(PDF) Statistical Model Building for Large, Complex Data: Four New Directions in SAS/STAT Software
Author: Robert N. Rodriguez, SAS

Data Management

(PDF) Creating Viable SAS Data Sets From Survey Monkey Transport Files
Keywords: Survey Monkey
Author: John R. Gerlach, Independent Contractor

(PDF) Document and Enhance Your SAS Code, Data Sets, and Catalogs with SAS Functions, Macros, and SAS Metadata
Authors: Louise Hadden, Abt Associates Inc.; Roberta J. Glass, Abt Associates

(PDF) Avoid Change Control by Using Control Tables
Author: Frank A. Ferriola, Jr., Financial Risk Group

(PDF) Some Useful Macros to Make Your Data Work Easier
Author: Ting Sa, Cincinnati Children’s Hospital Medical Center

(PDF) Macro Replacer
Author: Rituraj Saxena, Santen Inc.

(PDF) File Management Using Pipes and X Commands in SAS
Author: Emily Sisson, Boston University School of Public Health

(PDF) An Array of Fun: Macro Variable Arrays
Authors: Kalina Wong, ICON Clinical Research; Sarah Short, ICON Clinical Research

(PDF) Tips and Tricks for Producing Time-Series Cohort Data
Keywords: Tips, Tricks, Time-Series Cohort
Author: Nate Derby, Stakana Analytics

(PDF) Ditch the Data Memo: Using Macro Variables and Outer Union Corresponding in PROC SQL to Create Data Set Summary Tables
Author: Andrea Shane, MDRC

(PDF) Don t Get Blindsided by PROC COMPARE
Authors: Roger D. Muller, Data To Events, Inc; Josh Horstman, Nested Loop Consulting

(PDF) The Power of the Function Compiler: PROC FCMP
Author: Christina Garcia, Cal Poly San Luis Obispo

(PDF) What just happened? A visual tool for highlighting differences between two data sets.
Author: Steve Cavill, justice.nsw.gov.au

(PDF) All Aboard! Next Stop is the Destination Excel
Author: William E. Benjamin, Jr., Owl Computer Consultancy LLC

(PDF) A Ringside Seat: The ODS Excel Destination versus the ODS ExcelXP Tagset
Author: Chevell T. Parker, SAS

Data Presentation and Reporting

(PDF) Something Old, Something New… Flexible Reporting with DATA Step-based Tools
Author: Peter J. Lund, Looking Glass Analytics

(PDF) Controlling Colors by Name; Selecting, Ordering, and Using Colors for Your Viewing Pleasure
Keywords: Color-naming Schemes, ARRAY, SAS Registry, PROC REGISTRY, PROC FSLIST
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) Color, Rank, Count, Name; Controlling it all in PROC REPORT
Keywords: PROC REPORT, PROC FORMAT, color selection, PROC RANK, user defined formats, traffic lighting
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) A SAS macro for quick descriptive statistics
Author: Jenna Carlson, University of Pittsburgh

(PDF) Indenting with Style
Author: Bill Coar, Axio Research

(PDF) The Fantastic Four: Running Your Report Using the TABULATE, TRANSPOSE, REPORT, or SQL Procedure
Author: Josh Horstman, Nested Loop Consulting

(PDF) Proc Document, The Powerful Utility for ODS Output
Author: Roger D. Muller, Data To Events, Inc

(PDF) Tweaking your tables: Suppressing superfluous subtotals in PROC TABULATE
Author: Steve Cavill, justice.nsw.gov.au

(PDF) The Dynamic Duo: ODS Layout and the ODS Destination for PowerPoint
Author: Jane Eslinger, SAS

Data Science

(PDF) Social Media, Anonymity, and Fraud: HP Forest Node in SAS Enterprise Miner
Authors: Taylor Larkin, The University of Alabama; Denise McManus, The University of Alabama

(PDF) Reproducible Data Science Using SAS in a Jupyter Notebook
Author: Hunter Glanz, California Polytechnic State University

(PDF) Descriptive Analysis of Donation Amount Data and Text Mining of Tweets on Presidential Primaries using SAS
Authors: Aditya Jakkam, The University of Alabama; Swetha Nallamala, Oklahoma State University

(PDF) Text Analysis of American Airlines Customer Reviews.
Authors: Saurabh Choudhary, Oklahoma State University; Rajesh Tolety, Oklahoma State University

(PDF) Clinton vs. Trump 2016: Analyzing and Visualizing Tweets and Sentiments of Hillary Clinton and Donald Trump
Author: Siddharth Grover, Oklahoma State University

(PDF) Categorization of Fitbit s Customer Complaints on Twitter
Authors: Jacky Arora, Oklahoma State University; Sapna Bhoir, Oklahoma State University

(PDF) Proc DS2: What’s in it for you?
Author: Viraj R. Kumbhakarna, MUFG Union Bank

(PDF) An Animated Guide: Incremental Response Modeling in Enterprise Miner
Author: Russell M. Lavery

(PDF) Bringing Google Analytics, Facebook, and Twitter Data to SAS Visual Analytics
Author: I-Kong B. Fu, SAS

(PDF) Best Practices in Machine Learning Applications
Author: Brett Wujek, SAS

Graphics

(PDF) Customized Flowcharts Using SAS Annotation
Author: Abhinav Srivastva, PaxVax Inc

(PDF) Customizing Plots to Your Heart s Content Using PROC GPLOT and the Annotate Facility
Author: Debbie Yan Qun Huang, UCSF

(PDF) Making SAS the Easy Way Out: Harnessing the Power of PROC TEMPLATE to Create Reproducible, Complex Graphs
Author: Debra A. Goldman, Memorial Sloan Kettering Cancer Center

(PDF) Jumping Into SAS ODS Graphics Overnight
Author: Roger D. Muller, Data To Events, Inc

(PDF) SAS Graphing Done Right: Two Good Alternatives to PROC GPLOT/GCHART, Part 2
Author: Isaiah Lankham, University of California Office of the President

(PDF) Animated Graphs for a New Era
Author: Mitchell Collins, Cal Poly SLO

Hands-On Workshops

(PDF) Combining Reports into a Single File Deliverable
Author: Bill Coar, Axio Research

(PDF) Advanced Programming Techniques with PROC SQL
Keywords: SAS, SQL, PROC SQL, sql basics, proc sql basics, intro sql, intro proc sql, quick results sql, quick results proc sql, query, sql query, case expression, case sql, view, join, sql join, join sql, inner join, outer join, consultant, consulting, sas consultant, sql consultant, sql consulting, sas author, sql author, sql lafler, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd, software intelligence, software intelligence corporation, sas san diego, sql san diego, sas training, sas trainer, sql training, sql trainer, nesug trainer, sas trainer nesug, sas trainer san diego, sas training san diego, sql trainer san diego, sql training san diego
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Building and Using User Defined Formats
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) How to analyze correlated and longitudinal data?
Author: Niloofar Ramezani, University of Northern Colorado

(PDF) Introduction to Survival Analysis in SAS
Authors: Leanne Goldstein, City of Hope; Rebecca Ottesen, City of Hope

(PDF) How to Speed Up Your Validation Process Without Really Trying
Authors: Alice M. Cheng, Independent; Michael Wise, Experis; Justina M. Flavin, Independent Consultant

(PDF) How to Use PROC Tabulate – A Hands-on Workshop
Author: Tasha Chapman, Oregon Department of Consumer and Business Services

(PDF) Exchanging Data Between SAS and Excel: Basic SAS Techniques
Author: William E. Benjamin, Jr., Owl Computer Consultancy LLC

Industry Solutions

(PDF) You are the Concierge a CDISC compliant project management tool on SDD
Keywords: poster presentation, poster design, poster template
Author: Chen Shi, Santen Inc.

(PDF) Hierarchical Generalized Linear Models for Behavioral Health Risk-Standardized 30-Day and 90-Day Readmission Rates
Author: Allen Hom, UnitedHealth Group

(PDF) Did the Protocol Change Work? Interrupted Time Series Evaluation for Health Care Organizations.
Authors: Carol Conell, Division of Research Kaiser Permanente Northern California; Alexander C. Flint, Department of Neuroscience. Kaiser Permanente, Redwood City, CA

(PDF) A Case of Retreatment Handling Retreated Patient Data
Authors: Sriramu Kundoor, Seattle Genetics; Sumida Urval, Seattle Genetics

(PDF) Are you ready for Dec 17th, 2016 – CDISC compliant data submission?
Author: Kevin Lee, Clindata Insight

(PDF) Why and What Standards for Oncology Studies (Solid Tumor, Lymphoma and Leukemia)?
Author: Kevin Lee, Clindata Insight

(PDF) SDD project management tool, real-time and hassle free—- A one-stop shop for study validation and status tracking
Author: Chen Shi, Santen Inc.

(PDF) Building Better ADaM Datasets Faster With If-Less Programming
Author: Lei Zhang, Celgene Corporation

(PDF) SAS Office Analytics: An Application In Practice Data Monitoring and Reporting Using Stored Process
Authors: Mansi Singh, Roche Molecular Systems Inc; Kamal Chugh, Roche Molecular Systems Inc; Chaitanya Chowdagam, MaxisIT Inc; Smitha Krishnamurthy, Roche Molecular Systems Inc

(PDF) SDTM Bookmarking Automation: Leveraging SAS, Ghostscript and Form-Visit Study Data
Authors: Nasser Al Ali, Genentech; Maria Paz, Genentech

(PDF) Handling longitudinal data from multiple sources: experience with analyzing kidney disease patients
Authors: Elani Streja, UC Irvine; Melissa Soohoo, UC Irvine

(PDF) A Well-Formatted and Easy-to-Navigate Solution for Submitting SAS Source Code in NDA Submission
Authors: Jeff Xia, Merck; Lugang Larry Xie, Merck & Co.

Professional Development

(PDF) What s Hot Skills for SAS Professionals
Keywords: SAS, SAS skills, what’s hot, what’s hot in sas, the hottest topics in sas are, what’s not so Hot, Enterprise Guide, EG, hash objects, ODS, PROC SQL, SQL, PROC REPORT, Macro Language, Dictionary Tables, BI, SAS/XML, sasCommunity, SAS-L, LexJansen.com, certification, JMP software, consulting, sas consulting, consultant, sas consultant, Author, SAS Press Author, Google Search Complete!, google search, web search, internet search, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Creating Dynamic Documents with SAS in the Jupyter Notebook to Reinforce Soft Skills
Author: Hunter Glanz, California Polytechnic State University

(PDF) Contributing to SAS By Writing Your Very Own Package
Authors: Hunter Glanz, California Polytechnic State University; Emily Johnson, California Polytechnic State University

(PDF) Collaborations in SAS Programming; or Playing Nicely with Others
Authors: Kristi Metzger, Metzger Consulting; Melissa R. Pfeiffer, MRP Consulting

(PDF) A Brief Introduction to WordPress for SAS Programmers
Author: Andra Northup, Advanced Analytic Designs, Inc.

(PDF) How to Use LinkedIn to Effectively Boost Your Career Development
Keywords: LinkedIn, Career Development
Author: Nate Derby, Stakana Analytics

SAS Essentials Workshop

(PDF) SAS Studio: A New Way to Program in SAS
Authors: Lora D. Delwiche, Self-Employed; Susan J. Slaughter, Avocet Solutions

(PDF) An Animated Guide: An Introduction to SAS Macro Quoting
Keywords: Macro str nrstr quoting masking
Author: Russell M. Lavery

(PDF) Macro Basics for New SAS Users
Author: Cynthia L. Zender, SAS

(PDF) Errors, Warnings, and Notes (Oh My): A Practical Guide to Debugging SAS Programs
Authors: Lora D. Delwiche, Self-Employed; Susan J. Slaughter, Avocet Solutions

SAS Jeopardy
Author: Tasha Chapman, Oregon Department of Consumer and Business Services