WUSS 2019 Proceedings

Final PaperOther Files
43714
11:00 - 11:30    - Seattle
   Counting The Work Days Until ….
Robert Ellsworth
Ellsworth Stewart Consulting Inc.
    File
43713
08:30 - 09:30    - Rainier
   Principles of Automation
Robert Ellsworth
Ellsworth Stewart Consulting Inc.
    File
43712
16:00 - 17:00    - West Seattle
   Writing to excel from SAS, DDE vs ODS
Robert Ellsworth
Ellsworth Stewart Consulting Inc.
    File
43713
08:30 - 09:30    - Bellevue II
   Exploring the Skills Needed by the Data Science / Analytics Professional
Kirk Paul Lafler
Software Intelligence Corporation
    File
10:30 - 11:30    - Rainier
   Saving and Restoring Startup (Initialized) SAS® System Options
Kirk Paul Lafler
Software Intelligence Corporation
    File
43712
17:30 - 18:00    - West Seattle
   A Quick Look at Fuzzy Matching Programming Techniques Using SAS® Software
Kirk Paul Lafler1 and Stephen Sloan2
1Software Intelligence Corporation, 2Accenture
    File
14:30 - 16:00    - Bellevue I
   A Hands-on Introduction to SAS® DATA Step Hash Programming Techniques
Kirk Paul Lafler
Software Intelligence Corporation
    File
15:30 - 16:00    - Bellevue II
   Limit of Detection (LoD) Estimation Using Maximum Likelihood from (Hit) Rate Data: The LoD_MLE SAS Macro
Jesse Canchola, Jeffrey E. Vaks, Shaowu Tang
Roche Molecular Systems, Inc.
    File
   A HOW on Hashing
Russ Lavery
contractor
43713
17:00 - 17:30    - Seattle
   Order, Order! Four Ways to Reorder Your Variables, Ranked by Elegance and Efficiency
Louise Hadden
Abt Associates Inc.
    File
43712
16:00 - 17:00    - Renton Club
   Great Time to Learn GTL: A Step-by-Step Approach to Creating the Impossible
Richann Watson
DataRich Consulting
    File
43714
09:00 - 10:30    - Bellevue I
   Interactive Graphs!
Richann Watson1 and Kriss Harris2
1DataRich Consulting, 2SAS Specialists Ltd
    File
43713
13:30 - 14:00    - Renton Club
   Are you Ready? Preparing and Planning to Make the Most of your Conference Experience
Richann Watson1 and Louise Hadden2
1DataRich Consulting, 2Abt Associates Inc.
    File
43712
14:30 - 15:00    - Rainier
   TB Fuzzy-Matches Made Easy: Designing shareable SAS code to accurately and efficiently identify exact and close genetic matching tuberculosis isolates
evan timme
Arizona Department of Health Services
    File
43714
11:30 - 11:40    - Bellevue I
   Measuring Test-Retest Reliability: The Intraclass Kappa
Dennis Fisher1, Grace Reynolds-Fisher1, Eric Neri2, Art Noda2, Helena Kraemer2
1California State University, Long Beach, 2Stanford University
    File
43713
14:00 - 14:30    - Renton Club
   One Boys’ Dream: Hitting a Homerun in the Bottom of the Ninth Inning
Carey Smoak
S-Cubed
    File
17:00 - 17:30    - West Seattle
   Python applications in SAS® programming for medical device clinical trial studies
Jianlin Li1 and Sherry Cao2
1Q2 Business Intelligence, 2Abbott Laboratories
    File
43712
16:00 - 17:30    - Bellevue I
   Using PROC FCMP to the Fullest: Getting Started and Doing More
Art Carpenter
CA Occidental Consultants
    File
16:00 - 16:30    - Bellevue II
   General, Age-Specific, and Total Fertility Rates in Montana, 2008-2017
Matthew Ringel
Montana Department of Public Health and Human Services
    File
43713
14:30 - 15:00    - Renton Club
   A Fun (if Snarky) Look at SAS® Certification Exams
Aaron Brown
SC Dept. of Education
    File
43714
11:00 - 12:00    - Bellevue II
   Getting the Message Across: Cutting Run Times and Updating Databases with SAS/ACCESS®
Elise Mara
San Francisco Department of Public Health
    File
09:00 - 09:30    - Renton Club
   Validate the validated: A python script for study leads to review clinical outputs
Varaprasad Ilapogu1, Janet Li2, masaki mihaila2, Ernesto Gutierrez2
1Ephicacy consultancy group, 2Pfizer
09:00 - 10:00    - Bellevue II
   SAS Jeopardy! 2019 Edition
Natasha Chapman
Oregon Department of Consumer and Business Services
43712
15:30 - 16:00    - Renton Club
   Modern data visualization for SAS users
Jay Ahn
State of Washinton
    File
17:30 - 18:00    - Bellevue I
   People Keep ASCIIng Me About These Characters
Dan Konkler, Rebecca Bowermaster, Stephanie Sanchez
Roche Molecular Solutions
    File
43713
14:30 - 15:00    - West Seattle
   I Don't Use Python or R - Why Should I Use Jupyter Notebooks?
Jack Hamilton
Kaiser Division of Research
16:00 - 17:00    - West Seattle
   Connecting to Datasets through Python and SAS
Joe Matise
NORC
    File
09:30 - 10:00    - Rainier
   Fun With The Fun King: The SAS® Solution to the Magic Square
Frank Ferriola
Charles Schwab
    File
43712
16:30 - 17:00    - Bellevue II
   Automating a Summary Report of PSM Model and Match Results
Desiree Hall and Blake Krebs
Optum
    File
14:30 - 15:30    - Renton Club
   Completely Reproducible Reports in SAS® Part 1: Text

16:00 - 16:30    - Rainier
   Multi-way Splits in Decision Trees Where The Dependent Variable Has More Than Two Levels
Russ Lavery1 and YuTing Tian2
1contractor, 2West Chester Uinversity
    File
43713
09:30 - 10:00    - Bellevue II
   Statistical Power Calculations Using SAS Software
Russ Lavery
contractor
    File
10:30 - 11:00    - Bellevue II
   Using convergence status in a macro to iterate through a series of models
Kristi Metzger
Children's Hospital of Philadelphia
    File
43712
17:00 - 17:30    - Renton Club
   Simple Steps for Great Graphics: Beyond the Default Settings for More Effective Data Visualization
Kristi Metzger
Children's Hospital of Philadelphia
    File
43713
17:30 - 18:00    - Resource Central
   Using Factor Analysis and Multivariate Analysis of Variance to Explore Academic Achievement in the 2016 Monitoring the Future Study
Stefanie Kairs
National University
    File
43712
17:30 - 18:00    - Renton Club
   Building Blocks of Beautiful ODS RTF Destination Reports: Using Microsoft Word’s Heading System to Add an Outline Content Pane
Debra Goldman
Memorial Sloan Kettering Cancer Center
    File
43713
15:30 - 16:30    - Seattle
   A Survey of Some of the Most Useful SAS Functions
Ron Cody
SAS Instructor
    File
14:00 - 15:00    - Seattle
   Writing Code With Your Data
Joe Matise
NORC
    File
43712
14:30 - 15:30    - West Seattle
   Git'r'done: Using Git in the production SAS environment
Joe Matise1, Deanna Schreiber-Gregory2, Richann Watson3, Louise Hadden4, Jared Dean5
1NORC, 2Henry M. Jackson Foundation, 3DataRich Consulting, 4Abt Associates, 5SAS
17:00 - 17:30    - West Seattle
   SAS to Excel: ODS Tagsets to Hundred Files or Hundred Tabs
Abdus Shahid
Western Oregon University
43714
09:30 - 10:00    - Renton Club
   Stay Ahead of the Curve: How to implement New FDA Recommendation Study Data Standardization Plan (SDSP) in your organization?
Aakar Shah1 and Heather Riley2
1Nektar Therapeutics, 2Pfizer
    File
10:00 - 10:30    - Bellevue II
   ‘Tis better to give than receive: considerations when sharing data
Melissa R. Pfeiffer
Children’s Hospital of Philadelphia
    File
43713
17:00 - 17:30    - Bellevue I
   Tips for the lazy typist (and other strategies for smart coding)
Melissa R. Pfeiffer1 and Kristi Metzger2
1Children’s Hospital of Philadelphia, 2Children's Hospital of Philadelphia
    File
17:30 - 18:00    - Resource Central
   LaTeX and SAS for creating and assembling Data Monitoring Committee reports
adam omidpanah
Axio Research
    File
11:30 - 12:00    - Rainier
   Tips for Correctly and Efficiently Comparing Two Files in SAS®
Aaron Brown
SC Dept. of Education
    File
08:30 - 10:00    - Bellevue I
   Everything is better with friends: Executing SAS code in Python scripts with SASPy
Isaiah Lankham1 and Matthew Slaughter2
1University of California Office of the President, 2Kaiser Permanente Center for Health Research
    File
43714
10:00 - 10:30    - Renton Club
   Root Cause Analysis Using Pinnacle 21 Validation Reports: How to Improve End-to-End Programming Processs
Aakar Shah1 and Tracy Sherman2
1Nektar Therapeutics, 2Ephicacy
    File
43713
11:30 - 12:00    - West Seattle
   Spec to Code in Seconds: Use Microsoft Excel for Repetitive Code Writing
Pinky Anandani Dutta
Axio Research LLC
    File
16:00 - 17:00    - Renton Club
   20 Years of Success and Failure to Learn From, the Best and Worst
Bob Hull
Precision for Medicine
    File
10:30 - 11:00    - West Seattle
   Using SAS to enhance data sharing across REDCap projects: Reducing errors, streamlining management, and improving quality
Rachel Myers
Children's Hospital of Philadelphia
    File
43714
10:00 - 10:30    - Seattle
   Quote the SASLOG
Andrew Kuligowski
independent
    File
43713
13:30 - 14:00    - Rainier
   Working with Sparse Matrices in SAS®
Andrew Kuligowski1 and Lisa Mendez2
1independent, 2IQVIA Government Solutions
    File
09:00 - 10:00    - Renton Club
   Using SAS® Visual Analytics to Effectively Visualize Health Care Data
Scott Leslie1 and Donavin Drummond2
1STATisfy Analytics, 2MedImpact Healthcare Systems, Inc.
16:30 - 17:00    - Seattle
   Easy Solutions To %LET You Reduce Repetitive Programming
Ekaterina Roudneva
UC Davis
11:00 - 11:30    - West Seattle
   Automating ADSL Programming Using Pinnacle 21 Specifications
Tracy Sherman1 and Aakar Shah2
1Ephicacy, 2Nektar Therapeutics
    File
18:00 - 18:30    - Resource Central
   Waiting to Receive Birth Control Counseling: Weighted Analyses of Public-Use Data
Marie Boman-Davis and Ritika Bhawal
National University
14:00 - 15:00    - Rainier
   User-Defined Multithreading with the SAS® DS2 Procedure: Performance Testing DS2 Against Functionally Equivalent DATA Steps
Troy Hughes
Datmesis Analytics
    File
43712
17:30 - 18:00    - Seattle
   Like, Learn to Love SAS® Like
Louise Hadden
Abt Associates Inc.
43713
09:00 - 10:00    - West Seattle
   From Readability to Responsible Risk Management: Facilitating the Automatic Identification and Aggregation of Software Technical Debt within an Organization Through Standardized Commenting in SAS® Program Files and SAS Enterprise Guide Project Files
Troy Hughes
Datmesis Analytics
    File
08:30 - 09:00    - Renton Club
   On customizing survival curves in SAS®
Michael Williams
ICON Clinical Research
43714
09:00 - 09:30    - West Seattle
   Analyzing factors influencing viewer count of TED Talks through Text Analytics
Yasha Pastaria and Miriam McGaugh
Oklahoma State University
    File
43712
16:30 - 17:00    - Rainier
   Better To Be Mocked Than Half-Cocked: Data Mocking Methods To Support Functional and Performance Testing of SAS Software
Troy Hughes
Datmesis Analytics
    File
43714
09:30 - 10:00    - West Seattle
   Decision Trees: a Gentle Introduction
Richard Hector
Banner M.D. Anderson Cancer Center
10:00 - 10:30    - West Seattle
   Loan Default Prediction
Amarjeet Cheema and Miriam McGaugh
Oklahoma State University
43713
15:30 - 16:00    - Renton Club
   Transporting Your SAS Content to SAS® Communities and Integrating Your Content into GitHub
Louise Hadden
Abt Associates Inc.
43714
11:40 - 11:50    - Bellevue I
   Choosing Wisely: Using the Appropriate Statistical Test for Trend in SAS
Christina Park1, Jui-Ting Hsiung1, Melissa Soohoo1, Elani Streja2
1University of California, Irvine, 2UC Irvine
    File
11:00 - 11:30    - West Seattle
   Telecom Industry : Customer Churn Prediction
Aakash Dwivedi and Dr Miriam McGaugh
Oklahoma State University
43712
15:30 - 16:00    - West Seattle
   Pipe it! Extract it! Build it!
smitha Krishnamurthy1 and Sofia Shamas2
1Roche Molecular Solution, 2
    File
43714
11:30 - 12:00    - West Seattle
   Who Do We Need to Follow-Up With? Developing a Process to Track Study Response Rates
Vincent Chan
IMPAQ International LLC
    File
43713
10:30 - 11:00    - Seattle
   Much Ado About Nothing: dealing with blank values in your data
Ron Walker
None
15:30 - 16:00    - West Seattle
   Python and R made easy for the SAS Programmer
Janet Li1 and Varaprasad Ilapogu2
1Pfizer, 2Ephicacy consultancy group
43712
17:00 - 17:30    - Rainier
   Bayesian Nonparametric Clustering in SAS®
Hend Aljobaily
University of Northern Colorado
    File
43714
10:00 - 10:30    - Rainier
   Proc Dtree VS Proc Hpsplit
YuTing Tian
Independent
    File
43713
11:00 - 11:30    - Bellevue II
   A strategy for speed Dating
YuTing Tian
Independent
    File
11:00 - 12:00    - Seattle
   Merge with Caution: How to Avoid Common Problems when Combining SAS Datasets
Josh Horstman
Nested Loop Consulting
    File
43714
09:00 - 10:00    - Rainier
   Fifteen Functions to Supercharge Your SAS® Code
Josh Horstman
Nested Loop Consulting
    File
43712
17:30 - 18:00    - Rainier
   Bespoke outputs, just like everyone else’s: using the SAS Macro Language to create template programs for standard presentations of your client’s clinical trial data
Sean-Paul Claypool
Synteract, Inc.
43713
13:30 - 15:00    - Bellevue I
   Doing More with the SGPLOT Procedure
Josh Horstman
Nested Loop Consulting
    File
11:30 - 12:00    - Bellevue II
   Implementing the Hamiltonian Monte Carlo sampling algorithm in PROC MCMC
Elsa Vazquez Arreola and Jeffrey Wilson
Arizona State University
15:30 - 17:00    - Bellevue I
   PARSING: Using SAS® When the Data Are Hiding in a Non-Standard Format
Andrew Kuligowski
independent
43714
11:00 - 12:00    - Rainier
   Treating the Data Overdose: Navigating Big Data to Find Answers to Our Growing Opioid Problem
Deanna Schreiber-Gregory
Henry M Jackson Foundation for the Advancement of Military Medicine
43712
17:00 - 18:00    - Bellevue II
   Exploring the Difference in Multicollinearty Adjustments Between Logistic and Linear Regression
Deanna Schreiber-Gregory
Henry M Jackson Foundation for the Advancement of Military Medicine
43713
14:30 - 15:00    - Bellevue II
   Variable Selection Using Random Forests in SAS
DENIS NYONGESA
KAISER PERMANENTE
    File
43714
11:00 - 11:30    - Bellevue I
   Polynomial Regression for Modeling Curvilinear Data: A Biological Example
Elisha Johnston
Palos Verdes Peninsula High School
43713
13:30 - 14:00    - Seattle
   Keyboard Macros! An awesome tool you may have never heard of - once you do, you will never program the same again (It's that amazing!)
Steven C. Black
Agility-Clinical
43714
09:00 - 10:00    - Seattle
   Should You Move Your SAS Into the Cloud?
Paul Janssen
Janssen Consulting, Inc.
    File
43713
10:30 - 11:30    - Renton Club
   Have it Your Way: Using the ODS Excel Destination with the Data Step Report Writing Interface
Pete Lund
Looking Glass Analytics
13:30 - 14:30    - West Seattle
   Using Jupyter to Take Your Data Science Workflow to the Next Level
Hunter Glanz
California Polytechnic State University
08:30 - 10:00    - Seattle
   A Strategy for Dealing with Pinnacle 21 Errors and Warnings
Carey Smoak
S-Cubed
    File
18:00 - 18:30    - Resource Central
   Ordinal vs. Multinomial. Does model selection make a difference?
Corey Leadbeater
National University
    File
43712
18:00 - 18:30    - Resource Central
   Birds of a Feather 1 - SAS Training and Education
43713
10:00 - 10:30    - Resource Central
   Birds of a Feather 2 - Machine Learning
15:00 - 15:30    - Resource Central
   Birds of a Feather 3 - Open Integration
17:30 - 18:00    - Resource Central
   Birds of a Feather 4 - Analytics/Data Science
43714
10:30 - 11:00    - Resource Central
   Birds of a Feather 5 - On the Job Learning and Collaboration
43713
15:30 - 16:30    The Top 10 Ways to Optimize Your SAS Code - Rainier
16:30 - 17:30    Top SAS Architecture Pitfalls: Lessons Learned the Hard Way - Rainier
15:30 - 17:30    Advanced Methods for Survival Analysis Using SAS - Bellevue II
13:30 - 14:30    Getting Started with Machine Learning - Bellevue II
08:30 - 09:00    Learning Data Science with SAS University Edition and JupyterLab - West Seattle
   Redefining Student Success
Samuel Berestizhevsky and Tanya Kolosova
InProfix Inc
   How to Be a Healthy and Successful Home-Based SAS Programmer in Pharma/Biotech Industry
Daniel Tsui
ICON Clinical Research
   Analyzing Non-normal Data in the Presence of Missing Data: Application in Social and Biomedical Studies
Niloofar Ramezani
George Mason University