Welcome to the PharmaSUG 2017 Interactive Schedule Grid. Use the links below to jump to a portion of the schedule, then click on a paper title to view the abstract and other details!

(Revised May 16, 2017)

Monday AM Early

Monday AM Late

Monday PM Early

Monday PM Late

Tuesday AM Early

Tuesday AM Late

Tuesday PM Early

Tuesday PM Late

Wednesday AM Early

Wednesday AM Late




Monday AM Early

Section 8:00 AM 8:15 AM 8:30 AM 8:45 AM 9:00 AM 9:15 AM
Applications Development Automated Generation of Clinical Study Reports using SAS® and RTF (Literate programming) Challenge for Dramatic Streamlining of TLFs Creation Process with SAS and Java Stop waiting - Get notification email at the end of SAS® code execution using SAS® EMAIL Engine
Beyond the Basics One Project, Two Teams: The Unblind leading the Blind Automating Title and Footnote Extraction Using Visual Basic for Applications (VBA) and SAS" Using Hash tables for AE search strategies
Career Planning The Road Not Often Taken
Data Integrity Conversion of CDISC specifications to CDISC data - specifications driven SAS programming for CDISC data mapping Data Integrity: One step before SDTM Real Time Clinical Trial Oversight with SAS
Data Standards The Untapped Potential of the Protocol Representation Model CDISC's CDASH and SDTM: Why You Need Both!
Data Visualizations & Graphics Multipage Adverse Event Reports Using PROC SGPLOT Mapping Participants to the Closest Medical Center
Hands-on Training SAS Studio - the next evolution of SAS programming environments
Techniques & Tutorials SAS® and ISO8601: A practical approach Converting Non-Imputed Dates for SDTM Data Sets With PROC FCMP Merge With Caution: How to Avoid Common Problems when Combining SAS Datasets

Monday AM Late

Section 9:45 AM 10:00 AM 10:15 AM 10:30 AM 10:45 AM 11:00 AM 11:15 AM 11:30 AM
Applications Development Integration of multiple files into a study report using Word VBA macros Laboratory Data Standardization with SAS Migration to SAS Grid: Steps, Successes, and Obstacles for Performance Qualification Script Testing Building a Better Dashboard Using SAS® Base Software
Beyond the Basics The REPORT Procedure and ODS Destination for Microsoft Excel: The Smarter, Faster Way to Create First-Rate Excel Reports Clinical Data Visualization using TIBCO Spotfire® and SAS® I've Got to Hand It to You; Portable Programming Techniques
Career Planning The Road Not Taken: SAS for Pharmacometrics
Data Integrity Let's Check Data Integrity Using Statistical (SAS®) Programmers with SAS® Data Change Report Clinical and Vendor Database Harmony; Can't we all just get along? Check Your Data: Tools for Automating Data Assessment
Data Standards SDTM - Just a Walk in the (Theme) Park, Exploring SDTM in the Most Magical Place on Earth Implementation of STDM Pharmacogenomics/Genetics Domains on Genetic Variation Data ADQRS: Basic Principles for Building Questionnaire, Rating and Scale Analysis Datasets The CDISC Trial Design Model (TDM), the EPOCH variable, and the Treatment Emergent Flag: How to Leverage these to Improve Review
Data Visualizations & Graphics Visualizing Enrollment Over Time Make it personal: Upgrade your figures by adding individual patient data to the common figure types
Hands-on Training Usage of Pinnacle 21 Community Toolset 2.x.x for Clinical Programmers
Submission Standards Submission Musings
Techniques & Tutorials Defensive Programming -- Tips and Techniques for Producing that Dataset, Table, Listing or Figure First Time Special Symbols in Graphs: Multiple Solutions Application of Deming Regression in Molecular Diagnostics using a SAS® Macro

Monday PM Early

Section 1:15 PM 1:30 PM 1:45 PM 2:00 PM 2:15 PM 2:30 PM 2:45 PM 3:00 PM
Applications Development Here Comes The Smart Mock Table: A Novel Way of Creating Clinical Summary Tables Without Any Table Programming (No Kidding!) Leveraging Centralized Programming Resources Using SAS Integration Technologies Controlled Terminology Without Excel Supporting the CDISC Validation Life-Cycle with Microsoft Excel VBA
Beyond the Basics Expansion of Opportunities in Programming: DS2 Features and Examples of Usage Object Oriented Programming in SAS A Macro to carry values through observations forwards or backwards over null values within a by group or a SAS(R) dataset. Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS® Code
Career Planning The Elusive Data Scientist: Real-world analytic competencies What Makes a Candidate Stand Out? Strategies and decisions for marketing yourself as an independent contractor
Data Standards ADaM Grouping: Groups, Categories, and Criteria. Which Way Should I Go? Harmonizing CDISC Data Standards across Companies: A Practical Overview with Examples Ahead of the Curve: Leading with Industry Data Requirements
Hands-on Training SAS® Life Science Visual Analytics
Healthcare Analytics Analyzing data from multiple clinical trials using SAS® Real World Evidence Topology-based Clinical Data Mining for Discovery of Hidden Patterns in Multidimensional Data
Submission Standards Use of Traceability Chains in Study Data and Metadata for Regulatory Electronic Submission Preparing Analysis Data Model (ADaM) Data Sets and Related Files for FDA Submission How will FDA Reject non-CDISC submission?
Demo Theater Creating Role-based Clinical Reviews from CDISC Data with JMP® Clinical Comparison and Reusability Reporting of Metadata End-to-End Demonstration Using  SAS®  Analytics

Monday PM Late

Section 3:30 PM 3:45 PM 4:00 PM 4:15 PM 4:30 PM 4:45 PM 5:00 PM 5:15 PM
Applications Development Using SAS® ODS EXCEL Destination with SAS University Edition® to send graphs to Excel SAS Application to Automate a Comprehensive Review of DEFINE and All of its Components An Efficient Solution to Efficacy ADaM Design and Implementation Generating Homeomorphically Irreducible Trees (Solving the Blackboard Problem in the Movie "Good Will Hunting")
Beyond the Basics Harnessing the Power of the Manifest File in the SAS® Life Science Analytics Framework Don't Get Lost! A High-efficiency, Low-tech Solution for Navigating Your Department's Many-Many-Many SOPs and Guidance Documents Reporting Non-Printable and Special Characters for Review in Excel A SAS®sy Study of eDiary Data
Career Planning Schoveing Series 3: Living by Knowing When to STOP Show Me The Job!!! Becoming a Successful Manager of SAS® Programmers from an Ex-Programmer's Perspective Creating a Winning Resume Reflecting Your Skills and Experience With Honesty and Integrity.
Data Standards Standardized, Customized or Both? Defining and Implementing (MedDRA) Queries in ADaM Data Sets Where Is the Link Broken - Another Look at SDTM Oncology Tumor Packages RELREC - SDTM Programmer's Bermuda Triangle Planning to Pool SDTM by Creating and Maintaining a Sponsor-Specific Controlled Terminology Database
Hands-on Training Point-and-Click Programming Using SAS® Enterprise Guide®
Healthcare Analytics Developing Your Data Strategy Put the "K" in Your KAB: Know How to Efficiently Program with Knowledge, Attitudes, and Behavior Survey Data
Submission Standards The Do's/Don'ts, An SDTM Validation Perspective. The should/shouldn't when explaining issues in the Study Data Reviewers Guide Leveraging Study Data Reviewer's Guide (SDRG) in Building FDA's Confidence in Sponsor's Submitted Datasets Documenting Traceability for the FDA: Clarifying the Legacy Data Conversion Plan & Introducing the Study Data Traceability Guide
Demo Theater Merge Your_Skills  Career_Goals  Company; by YouSubjID; Generating Efficacy Outputs: Programmer's view Supercharge your TFL review process with Zeroarc’s Analysis Lifecycle Management Software

Tuesday AM Early

Section 8:00 AM 8:15 AM 8:30 AM 8:45 AM 9:00 AM 9:15 AM
Applications Development A novel method to track mapping of all CRF variables into SDTM datasets. Using SAS® for Application Programming Interface Requests Three Issues and Corresponding Work-Around Solution for Generating Define.xml 2.0 Using Pinnacle 21 Enterprise
Data Standards Leveraging metadata when mapping to CDISC Standards with SAS® machine learning in a Results as a Service plus Model (RAAS+) ADaM Compliance - Validating your Specifications Clarifications About ADaM Implementation Provided in ADaMIG Version 1.1
Data Visualizations & Graphics Effective Ways to Perfect the Visualization of Clinical Trial Results Automated DSMB Presentation in SAS: Yeah, I'd Submit That! How to auto populate PowerPoint presentations so you don't have to
Hands-on Training Survival 101 - Just Learning to Survive
Industry Basics A Practical Guide to Healthcare Data: Tips, traps and techniques SDTM Cartography - Learn To Create SDTM Mapping Specifications
Statistics & Pharmacokinetics Multiple Imputation: A Statistical Programming Story Multiplicity Controlled Analyses Using SAS/IML Adverse Event Data over Time
Techniques & Tutorials Tips and Best Practices using SAS® Analytics Dear Dave, Please See the .LST File for Our Validation Differences. Thanks, Bad Validation Programmer
Demo Theater Benefits of placing Functional Service Provider (FSP) teams in Eastern Europe.

Tuesday AM Late

Section 9:45 AM 10:00 AM 10:15 AM 10:30 AM 10:45 AM 11:00 AM 11:15 AM 11:30 AM
Applications Development Important and Valuable Things You Can Do with SAS® Metadata DICTIONARY Tables and SASHELP Views Obtaining an Automated Summary of PROC COMPARE Results: &SYSINFO and VB Script R Shiny Clinical Review Tools on the Horizon
Data Standards LBTEST/LBSTRESU and ADaM lab parameters: The dilemma of mapping one-to-many or many-to-one Programming Efficiency in the Creation of ADaM BDS Datasets The Benefits of Traceability Beyond Just From SDTM to ADaM in CDISC Standards The CDISC SDTM Exposure Domains (EX & EC) Demystified. How EC Helps You Produce A Better (more compliant) EX.
Data Visualizations & Graphics Mean and Individual Subject Graphs of Concentration vs. Time Data Using PROC SGPLOT SAS vs Tableau: Creating Adverse Event/ Concomitant Medication Time line plot The basics of Graphics Template Language and output by PROC DOCUMENT Bird's eye view of the data, a graphical exploration!
Hands-on Training New for SAS® 9.4: Including Text and Graphics in Your Microsoft Excel Workbooks, Part 2
Industry Basics Data Monitoring Committee Report Programming: Considering a Risk-Based Approach to Quality Control Building a Fast Track for CDISC: Practical Ways to Support Consistent, Fast and Efficient SDTM Delivery How to define Treatment Emergent Adverse Event (TEAE) in crossover clinical trials
Statistics & Pharmacokinetics Population PK/PD Analysis - SAS® with R and NONMEM® Make Customization Easy Combining Survival Analysis Results after Multiple Imputation of Censored Event Times
Techniques & Tutorials Data Quality Control: Using High Performance Binning to Prevent Information Loss The Proc Transpose Cookbook Building Intelligent Macros: Using Metadata Functions with the SAS® Macro Language
Demo Theater SAS® and Jupyter Notebooks – Reproducible Research Made Easy Analytics in Pharma and Healthcare Automate Common Clinical Analytics with SAS® Studio Tasks

Tuesday PM Early

Section 1:15 PM 1:30 PM 1:45 PM 2:00 PM 2:15 PM 2:30 PM 2:45 PM 3:00 PM
Beyond the Basics Programming LYRIC Response in Immunomodulatory Therapy Trials Good artists copy;Great artists steal; (implement pseudo R ,Jquery & code in Base SAS without installing R or other Applications Simplifying Your %DO Loop with CALL EXECUTE A Case of assessing adverse events of interest based on their grade changes
Data Standards Deriving Rows in CDISC ADaM BDS Datasets Considerations and Conventions in the Submission of the SDTMIG Tumor and Response Domains A Critique of Implementing the Submission Data Tabulation Model (SDTM) for Drugs and Medical Devices
Hands-on Training Five Ways to Create Macro Variables: A Short Introduction to the Macro Language
Management & Support Managing conflicts across Cross Functional and Global Virtual Teams Stakeholder Management: How to be an effective lead SAS® programmer Beyond "Just fix it!" Application of Root Cause Analysis Methodology in SAS® Programming. Insight into Offsites: creating a productive workflow with remote employees.
Quick Tips Basic SDTM House-Keeping Visual Basic for Applications: A Solution for Handling Non-ASCII Removal and Replacement Same statistical method different results? Don't panic the reason might be obvious. What Are Occurrence Flags Good For Anyway? How to Create a Journal-Quality Forest Plot with SAS® 9.4 Remove the Error: Variable length is too long for actual data Is There a Date In That Comment? Use SAS To Find Out. My bag of SAS lifehacks
Submission Standards Good versus better SDTM: Including Screen Failure Data in the Study SDTM? Good Data Validation Practice Quality Check your CDISC Data Submission Folder Before It Is Too Late!
Techniques & Tutorials SAS® Studio: We Program Clinical Trials Data: It's a Scary World Out There! or Code that Helps You Sleep at Night Check Please: An Automated Approach to Log Checking
Demo Theater Accelerate Your CDISC Mapping via the SAS® Auto Mapper Agile in Regulated Environments Biostatistical solutions accelerating drug/device development

Tuesday PM Late

Section 3:30 PM 3:45 PM 4:00 PM 4:15 PM 4:30 PM 4:45 PM 5:00 PM 5:15 PM
Beyond the Basics Writing Efficient Queries in SAS Using PROC SQL with Teradata Making Documents 'Intelligent' with Embedded Macro Calls, DOSUBL and Proc STREAM: An example with the CONSORT Flow Diagram SAS Programmer's Guide to Life on the SAS Grid
Data Standards Considerations in Submitting Standardized Electronic Data Under the Animal Rule: The Use of Domains in the SDTMIG and the SENDIG Common Programming Errors in CDISC data
Hands-on Training Single File Deliverables: Next Steps
Management & Support Lead Programmer Needs Help: Dedicated Programming Project Manager to the Rescue! Sponsor Oversight of CROs Data Management and Biostatistical Abilities Mentoring and Oversight of Programmers across Cultures and Time Zones
Quick Tips Importing CSV Data to All Character Variables Generating Colors from the Viridis Color Scale with a SAS® Macro PROC DOC III: Self-generating Codebooks Using SAS® Everyone can use a little Currency - when dependent data set updates silently make your analysis data set out of date. Multi-Dimensional Arrays: Add Derived Parameters Common mistakes by programmers & Remedies
Submission Standards Awareness from Electronic Data Submission to PMDA and FDA -- Lesson & Learnt from hands-on experiences -- Overview and Application of the HCV Vertical Resistance Analysis Template Creating Define-XML version 2 including Analysis Results Metadata with the SAS® Clinical Standards Toolkit
Techniques & Tutorials Hashtag #Efficiency! An Exploration of Hash Tables and Other Techniques SAS® Debugging 101
Demo Theater Integration & Innovation: Pharma-CRO Relationship LSAF ROC: Version Control, Audit Trail and Workflow on Your SAS® Environment Replicating the Classroom with online learning in Statistics and Biostatistics

Wednesday AM Early

Section 8:00 AM 8:15 AM 8:30 AM 8:45 AM 9:00 AM 9:15 AM
Applications Development Excel-VBA Tool to Auto-Create Validation log and Review Form using List of TLF's. SAS Macro for Derivation of Best Overall Response per RECIST v. 1.1
Data Standards Gray Areas of ADaM and Ways to Provide Color
Data Visualizations & Graphics A Combined AE + CM Graph using SAS The %NEWSURV Family of Macros: An Update on the Survival Plotting Macro %NEWSURV and an Introduction to Expansion Macros
FDA Wednesday Statistical Review and Data Standards: It’s Gettin’ Better All The Time
Healthcare Analytics Removing the Mask of Average Treatment Effects in Chronic Lyme Disease Research Using Big Data and Sub-Group Analysis A Business Solution for Improved Drug Supply Chain Visibility
Industry Basics Good Programming Practices at Every Level
Management & Support The Cross Border Program - Strengthening the Sponsor-Partner Offshore Experience
Demo Theater The fourth lie – false resumes Analytics Tool for your Data Review, Monitoring, and Visualization Needs – Optimizing use of Data Standards

Wednesday AM Late

Section 9:45 AM 10:00 AM 10:15 AM 10:30 AM 10:45 AM 11:00 AM 11:15 AM 11:30 AM
Applications Development A Vivid and Efficient Way to Highlight Changes in SAS Dataset Comparison Work with me here...(or there or anywhere): Practical Cloud Collaboration with JMP Clinical for Clinical Trial Data Reviews Metadata integrated programming
Data Visualizations & Graphics Using Animated Graphics to Show PKPD Relationships in SAS 9.4 Translating Statistics into Knowledge by Examples Using SAS Graphic Procedures When one is not enough or multi-celled plots: comparison of different approaches
FDA Wednesday Update on Data Standards Innovation and Regulatory Review: What is JumpStart? Use of Data and Metadata at FDA: How Has it Changed, Where is it Going?
Healthcare Analytics Multinomial Logistic Regression Models With Sas® Proc Surveylogistic Two Roads Diverged in a Narrow Dataset...When Coarsened Exact Matching is More Appropriate than Propensity Score Matching
Industry Basics How to find the best MDR solution for your organization
Management & Support Woops, I Didn't Know! An Elegant Solution to Let Your Entire Department Benefit from Individual Lessons Learned A Review of "Free" Massive Open Online Content (MOOC) for SAS® Learners
Demo Theater Preparing for the Coming CDISC Data Storm Big Data for SAS programmers Creating Analysis Results Metadata (ARM) with Pinnacle 21