Other interesting pages ...
SAS Tip of the Month
SAS Cheat Sheet
Useful SAS Code
Full SAS Example
Basic Statistics
Contact Information
| New Hampshire, USA Cell: +1(603) 275-6809 Email: 100316.3451@compuserve.com URL: http://www.TheProgrammersCabin.com |
David W. Franklin
SAS Applications Capability
Position
Programmer/Analyst for systems developed using SAS. Specialties include developing and generating the CRT section of an E-Sub (NDA) to regulatory agencies, and building Data Analysis, Reporting and Data Management applications independent of operating system, i.e. applications that run on two or more operating systems.
Overview
David has had over twenty-three years experience developing SAS applications, with the last seventeen years for mainly pharmaceutical clients using micro and mini computer platforms. His task assignments include:
- Writing of SAS program development standards for SAS Programmers in a Biostatistics environment
- Generating E-Subs (NDAs) for Regulatory Review
- Analysis and Reporting
- Specialist development, including in-house CRT, Narrative Header generator, and CDISC/Warehouse applications
- Data Entry Applications
- Data Validation
- Clinical Data Management
Technical
SAS systems experience includes Base SAS (including SQL), SAS/FSP, SAS/AF (including Frame), SAS/EIS, SCL, Macro Facility, SAS/Graph, SAS/Assist, SAS/STAT and SAS/Insight on Windows, Alpha/VMS, UNIX (HP, SUN, DIGITAL), and VAX operating systems. Database systems experience includes Oracle (including Oracle Clinical), Clintrial and PL/SQL.
Published
- Presented papers at SAS Global Forum 2009 entitled Using SAS System and Dataset Options to Control Your Data, and Merging Data Eight Different Ways
- Presented papers at NESUG 2008 entitled Merging Data Seven Different Ways (Peoples' Choice Award), and Cryptography, The Art of Disguising The Written Word
- Presented papers at PharmaSUG 2008 entitled "Avoiding the "Ooh Nasty", and Adding Control to Your Data Using SAS System and Dataset Options (Best Paper Award)
- Presented papers at NESUG 2007 entitled "Controlling SAS Datasets Using SAS System and Dataset Options (or I need to track the data!)" and "Calculating the Quartile (or why are my Quartile answers different?)"
- Presented papers at PharmaSUG 2007 entitled "Finding Duplicate Records in a SAS Dataset", "Comparing ODS RTF Output Files in Batch Using SAS (or, 500 ODS RTF Documents to Compare in 15 minutes!)" and "Calculating the Quartile" (invited paper)
- Presented a paper at SUGI 22 entitled "Developing SAS Applications for Cross Platform Use".
- Presented a paper at SEUGI '96 entitled "CDMS A Complete Cross Platform Clinical Data Management System".
SAS Projects
| Jan1985-Pres. | Multiple Clients, Predominantly in the Pharmaceutical Industry Primary or QC SAS Programmer for reporting over 100 clinical studies (tables, listings and figures as well as adhoc requests from Clinicians, FDA, etc.) to requested specifications; developed numerous ISS databases and reported in the form of tables and figures for clinical submission to FDA; writing text for the CRT section of three successful FDA sNDA submissions; and numerous Annual Reports to the FDA. Output has been in ASCII format but in recent years have been using mainly ODS RTF for generation of RTF output files, however other formats including PDF and HTML have been used. Developed numerous applications that have included generation of the CRT section of an E-Sub (NDA) to regulatory agencies (included PDF links and bookmarks to required standards - replaced an off-the-shelf application); development of a program that generates Patient Narratives (cutting time for writing of Narratives by over 80%); solution of adding text for PDF bookmarks in ODS RTF generated tables, listings and figures so output can go directly into MDoc; and an application to generate Dynamic Listings of the data for review (has the facility for the reviewer to subset the listings at the patient level - this uses SAS to generate the Excel application and workbook with VBA macros, and the reviewers use this Excel workbook to review the data - replaced paper By Patient Listings). Mentored junior and senior programmers and gave numerous technical talks on topics including SAS (e.g. how to, and how SAS calculates various statistics), Word/Excel (usage and VBA related) and DOS (batch programming). Wrote SAS program development standards for SAS Programmers in a Biostatistics environment. Received numerous awards for my work including many that recognized a high-impact contribution that I had given to the client. |
Other
- Invited to be a Code Doctor at PharmaSUG 2009 in the Code Clinic
- Various courses, including:
- Testing SAS Programs for Part 11 Compliance
- Statistics and Reporting Using R
- Rapid Application and Object Orientated Development
- VBA Programming for Word and Excel
- Executive Information Systems, including Motore
- Multi platform Application Development
- Project and Time Management