Visit PhilaSUG Home Page Welcome to the PhilaSUG Archive

Archive of Past Meeting Announcements and Presentations



Welcome to the PhilaSUG Users Group Newsletter and Presentation Archive.  Here you can view previous Newsletters or scroll down and view Presentation Papers.

Table of Contents:

Meeting Announcements: Presentations:
Winter '97 Winter '99 Winter '01 Winter '03 Winter '05 Archive of Past Papers
Spring '97 Spring '99 Spring '01 Spring '03 Spring '05
Fall '97 Fall '99 Fall '01 Fall '03 Fall '05
Winter '98 Winter '00 Winter '02 Winter '04 Winter '06
Spring '98 Spring '00 Spring '02 Spring '04 Spring '06
Fall '98 Spring '00 Fall '02 Fall '04 Fall '06

Winter '07 Spring '07 Fall '07
Winter '08 Spring '08 Fall '08
Winter '09 Spring '09 Fall '09
Winter '10 Spring '10 Fall '10
Winter '11 Spring '11 Fall '11
Winter '12 Spring '12 Fall '12 Winter '13 Spring '13 Fall '13
Winter '14 Spring '14 Fall '14 Winter '15 Spring '15 Fall '15
Winter '16 Spring '16 Fall '16 Winter '17 Spring '17 Fall '17
Winter '18 Spring '18 Fall '18 Winter '19 Spring '19 Fall '19
[PhilaSUG Logo]
[HOME]
The Archive of Past Meeting Announcements was last modified: October 24, 2019. Comments and suggestions are always appreciated, email the WebMaster at webmaster@PhilaSUG.org
[PhilaSUG Logo]
[Archive
of Past
Papers]



WELCOME TO PhilaSUG

Archive of Past Papers


NOTE - The author(s) is the intellectual property owner of copyright to all papers published here.
NOTE - The author(s) have granted us a non-exclusive licence to publish their work.
NOTE - These papers are available to download.
To view files in .pdf format, download the free Adobe Acrobat Reader. Get Adobe Acrobat Reader


Table of Contents:

Fall 2019 (October 22, hosted by West Chester University Department of Mathematics and Applied Statistics Program ) Presentations
Spring 2019 (June 5, hosted by Cytel) Presentations
    Enforcing Data Integrity with SAS® Audit Trails
      Vincent Rabatin, Rabatin Software Services, CCP
      [ PDF]
    Using User Defined FORMATS and the INTNX Date Function to Extract LAGS and LEADS Using SAS® Date Variables as VALUES for the Look-Up
      Jonas V. Bilenas, Banking Industry Consultant
      [ PDF]
    Dictionary Tables and Views: Essential Tools for Serious Applications
      Frank DiIorio, CodeCrafters, Inc., Chapel Hill NC
      [ PDF]
      and dictionary Table Reference V9.4 [ PDF]
    Why and How to Use Condensed Indexes for Sorted SAS® Datasets
      Mark Keintz, Wharton Research Data Services
      [ Presentation not yet available]
    Throw Away the Key: Blockchain-ed Healthcare Data
      Kathy Zhai, GlaxoSmithKline
      [ PDPTX]
    SDTM Metadata and Define.xml — An Overview
      Sujaykumar Bothisathuvan, Cytel
      [ PPTX]
Winter 2019 (March 19, hosted by TD Bank) Presentations
    UNIX X Command Tips and Tricks
      David B. Horvath, CCP
      [ PDF]
    Using SAS® Regression Splines in the Banking Industry
      Jonas V. Bilenas, AB
      Nish Herat, Verizon
      [ PDF]
    Prescriber Profiling from a Pharmacy Benefits Management (PBM) Perspective
      J. Daniel Knapp, PerformRx
      [ DOCX]
    Rapid Rolling Window Regressions via Home Made Sum of Squares and Cross Products
      Mark Keintz, Wharton Research Data Services
      [ PDF]
    Email Me Routine Reporting with SAS Scheduler™
      Xiuyun (Katie) Zheng, TD Bank
      [ PPTX] part 1, and [ PPTX] part 2.
Fall 2018 (October 30, hosted by Janssen) Presentations
    The Present and Future of Define-XML
      Lex Jansen, SAS Institute
      [ PDF]
    Standards Driven Oncology
      Kevin Lee, Clindata Insight
      [ PDF]
    Developing Credit Risk Score
      Amos Odeleye, TD Bank
      [ PDF ]
    Proc Sort Revisited
    History Carried Forward, Mixing Time Series of Differing Frequencies
      Mark Keintz, Wharton Research Data Services
      [ PDF ],
    Poster - Automation of Clinical Trial Result Posting to ClinicalTrials.gov and EudraCT
Spring 2018 (June 18) Presentations
    Divide and Conquer Using a Hash Function
      Paul Dorfman, Dorfman Consulting
      Don Henderson, Henderson Consulting Services
      [ PPTX]
    Efficient Selective Unduplication Using the MODIFY Statement
      Paul Dorfman, Dorfman Consulting
      [ PPTX]
Winter 2018 (March 12) Presentations
    An Introduction to the SAS MACRO Language
      Jonas Bilenas, Barclays Bank
      [ PDF]
    Dates with Macros
      Alex Chaplin, Bank of America
      [ PDF]
    How to Beautify Your Report
      Haibin Shu, AccuClin Global Services
      [ PDF]
    Thinking Outside the SAS Box: UNIX Tools
      David B. Horvath, CCP, MS
      [ PDF]
Fall 2017 (November 28) Presentations
    New for SAS® 9.4: A Technique for Including Text and Graphics in Your Microsoft Excel Workbooks, Part 1
      Vincent DelGobbo, SAS Institute Inc.
      [ PDF]
    New for SAS® 9.4: A Technique for Including Text and Graphics in Your Microsoft Excel Workbooks, Part 2
      Vincent DelGobbo, SAS Institute Inc.
      [ PDF]
    Deep Neural Networks in SAS® Enterprise Miner
      Russ Lavery
      [ PDF]
    Machine Learning for SAS® Programmers
      Kevin Lee, Clindata Insight
      [ PDF]
    Using SAS® to run Survival Analysis on Nationally Representative Data
      Sri Banerjee, Walden University/Johns Hopkins
      [ PDF]
Winter 2017 (19 April) Presentations
    Using SAS® Dates and Times
      Jonas Bilenas, Barclays UK, PCB
      [ PPTX]
    How to Ensure Your Topline Results Are Correct?
      Haibin Shu, AccuClin Global
      [ PDF]
    A Careful Approach when merging datasets - while subsetting using WHERE or IF Statements
      Kamala Bharathi Madavarapu
      [ PDF]
    To COMPRESS or Not, to COMPRESS or ZIP
    Credit Score Modeling in SAS Enterprise Miner ™
      Tina (Xiaoyuan) Zhang
      [ PDF]
    SAS® Macros for Redacting Subject and Clinical Site Codes while Submitting Clinical Trial Data to FDA
      Venu Perla, Ph.D.
      [ PDF]
Fall 2016 (11 October) Presentations
    Financial Stress Testing using SAS®
          Wall Street & Main Street Nightmare
      Amos Taiwo Odeleye, TD Bank Financial Group
      [ PDF]
    Using SAS®/QC to Design Optimal Experimental Designs in Consumer Lending
      Jonas V. Bilenas, Barclays PCB
      [ PPT]
    Steps and Slides of Implementing Global Standards — Producing High Quality Programming Outputs Edition
      David Izard, Chiltern International
      [ PDF]
    Are You Ready for Dec. 17, 2016 — CDISC Compliant Data Submission
      Kevin Lee, Director of Data Science, Clindata Insight
      [ PDF]
    A Macro for Single Imputation
      Xingshu Zhu, Merck Co Inc.
      [ PPTx]
Spring 2016 (23 June) Presentations
    Is Your Randomization Really Random?
      Arteid Memaj and Carolyn Romano, Chiltern International
      [ PPTX]
    Scatterplots: Basics, enhancements, problems and solutions
      Peter L. Flom, Peter Flom Consulting, LLC
      [ PDF]
    SAS® Integration With NoSQL Database
      Kevin Lee, Director of Data Science
      [ pptx]
    Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming
    SAS Supervisor within You vs SAS: Debugging SAS Data Steps with the Program Data Vector
      Sasikumar Palanisamy, Chiltern International
      [ pptx]
Winter 2016 (16 March) Presentations
    Introduction to Text Mining and an Overview of SAS® Text Miner
    What's New in SAS® 9.4 for Programmers?
    An Animated Guide: Penalized Regression and Quantile Regression
      Russ Lavery
      [PDF]
    Data Normalization for Dummies Using SAS®
      Venu Perla, Ph.D.
      [PDF]

Fall 2015 (29 Oct.) Presentations
    Reducing Credit Union Member Attrition with Predictive Analytics
      Nate Derby, Stakana Analytics, Seattle, WA
      Mark Keintz, Wharton Research Data Services, Philadelphia, PA
      [ slides as PDF] [PDF]
    A Technique to Rescue Non-Parametric Outlier Data Using SAS®.
      Venu Perla Ph.D., Independent SAS Programmer, Cross Lanes, WV, PA
      [PDF]
    Creating Sophisticated Graphics using Graph Template Language
      Kaitlyn McConville, Rho®, Inc., Chapel Hill, NC
      Kristen Much, Rho®, Inc., Chapel Hill, NC
      [PPTX]
      [PDF] (reprinted from the 2015 PharmaSUG Proceedings)
    NOBS for Noobs
      David Horvath, PNC
      [PPT].
    Large Number Computations
      Dr. Jiangfan Li (James), Janssen Research & Development, Spring House, PA
      Poster on SAS macro library "Large Number Computations." This macro library enables SAS to perform accurate computation on any large numbers. The User Guide [HTML].

Spring 2015 (17 June) Presentations
    Get SMART to Stay in CONTROL and Avoid KAOS: Signal Management for Adverse Events in Real Time
      Peter Mroz, Janssen Research & Development
      [PDF]
Winter 2015 (12 March 2015) Presentations and Posters
    A Practical Approach to Building CCAR Loss Forecasting Models in SAS® 9.3
      Andre Toman, M&T Bank
      [ PDF]
    Application of SAS®! Enterprise Miner™ in Credit Risk Analytics
      Minakshi Srivastava, VP, GRM, Bank of America
      [ PPTX]
    EX+EC+DA = ADDA
    A CDISC Approach to Drug Accountability Calculation
      Haibin Shu, AccuClin Global Services
      [PDF].
    The Power of PROC FORMAT
      Jonas V. Bilenas, Barclays UK & Europe Retail and Business Banking Risk (UK & E RBB)
      [PDF].
    NOBS for Noobs
      David Horvath, PNC
      [PPT].
    Dealing with Variable Length Mainframe Files (EBCDIC) in an ASCII Environment

Fall 2014 Presentations and Posters
    FUNCTIONAL LOGISTIC REGRESSION IN SAS®
      LINLIN FAN, DEPARTMENT OF MATHEMATICS LEHIGH UNIVERSITY
      [ PDF]

Spring 2014 Presentations and Posters
    A Tutorial on the SAS® Macro Language
      John J. Cohen, A dvanced Data Concepts LLC, Newark, DE
      [ PDF] (reprinted from the SAS Global Forum 2012 Proceedings)
    PROC DATASETS; The Swiss Army Knife of SAS® Procedures
    Dealing with Variable Length Mainframe Files (EBCDIC) in an ASCII Environment
      Randy Noga, Automated Financial Systems (AFS)
      [ PPTX]


Winter 2014 Presentations and Posters
    LEADS AND LAGS IN SAS®
      Mark Keintz, Wharton Research Data Services, University of Pennsylvania
      [ PDF] (reprinted from the 2013 NESUG Proceedings)
    PROC DATASETS; The Swiss Army Knife of SAS® Procedures
      Michael A. Raithel, Westat, Rockville, MD and SAS Press Author
      [ PDF] (reprinted from the 2011 SAS Global Forum Proceedings)
      View it as an On-Demand WebinarView Now.

    An Animated Guide©: Proc Report:
      Russell Lavery, Contractor, Ardmore, PA
      [ PDF] (reprinted from the 2003 SESUG Proceedings)

    Challenges of Processing Questionnaire Data from Collection to SDTM to ADaM and Solutions using SAS®
      Karin LaPann, PRA International, Horsham, PA
      Terek Peterson, PRA International, Horsham, PA
      [ PDF] (reprinted from the 2014 SGF Proceedings)

Fall 2013 Presentations and Posters
    An Introduction to Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®
      Vincent DelGobbo, SAS Institute Inc., Cary, NC
      [ PDF] (reprinted from the 2012 SAS Global Forum Proceedings)
    Ways to Summarize Data Using SUM Function in SAS®
      Anjan Matlapudi, AmeriHealth Caritas
      [ PDF] (reprinted from the 2012 NESUG Proceedings)
    Application of SAS® Enterprise Miner™ in Credit Risk Analytics!
      Minakshi Srivastava, Bank of America
      [ PDF]
    SAS Macros® 101
    How I Learned to Stop Worrying and Love Macros
Spring 2013 Presentations and Posters
    The Perfect Marriage: The SAS® Output Delivery System (ODS) and Microsoft Office
    An Animated Guide: Knowing SQL internal processes makes SQL Easy
      Russ Lavery, Numeric Resources Contractor, Ardmore, PA
      [ PDF] (reprinted from the 2008 PhUSE Wiki)
    OpenCDISC: Beyond Point and Click
      Frank DiIorio, CodeCrafters, Inc., Philadelphia PA
      [ PDF] (reprinted from the 2013 PharmaSUG Proceedings)
    Automation of ADaM Dataset Creation with a Retrospective, Prospective, and Pragmatic Process
      Karin LaPann, MSIS, PRA International, Terek Peterson, MBA, PRA International
      [ PDF]
Using Categorical Variables in Regression Analysis
    Jonas V. Bilenas, Barclays UK&E RBB
    [ PDF]

Winter 2013 Presentations and Posters
Trend Reporting Using the MXG® Trend Performance Database
    Neal Musitano Jr., U. S. Department of Veterans Affairs, Information Technology Center, Philadelphia, PA
    [ PDF]

[PhilaSUG Logo]
[HOME]
The Archive of Papers was last modified: October 28, 2019. Comments and suggestions are always appreciated, email the WebMaster at webmaster @ PhilaSUG dot org
[PhilaSUG Logo]
[About]