Winter 2009 Presentations

Building the Better Macro: Best Practices for the Design of Reliable, Effective Tools, by Frank DiIorio, CodeCrafters, Inc. [PDF]

A SAS® Programmer’s Guide to Generating Define.xml, by Michael Molter, INC Research, Raleigh, NC [PDF]

Fall 2008 Presentations

A Sampler of What's New in Base SAS® 9.2 (July 2008) highlights the top new features and performance improvements in DATA step, PROC SQL, and PROC SORT. [PDF]

Copy of Rick Langston's Presentation [PPT]

Tabular Reporting Data Standard, by Frederick Cieri, Planning Data Systems. [ ZIP file for the presentation containing: paper, sample program, sample data and Power Point presentation]

Iterative Macro Processing with Dynamic Domains, By: Brian Clawson [paper DOC and presentation PPT]

The Art of Debugging by Ian Whitlock [PDF]

Statistics for Clinical Trial SAS Programmers 1: paired t-test, by Kevin Lee, Therakos, Exton, PA [PDF]

E-Mail z/OS CICS Exception Reports in Plain Text Format Using DATA _NULL_ and MXG® Software, by Neal Musitano Jr., U. S. Department of Veterans Affairs, Information Technology Center [PDF]

Generate a Customized Axis Scale with Uneven Intervals in SAS® Automatically , by Perry Watts, SAS® User, Elkins Park, PA [PDF]

Spring 2008 Presentations

Useful SAS® Web Links, by Michael Davis, Health Market Science, Inc. [PowerPoint Slideshow Presentation PPT]

MISSING VALUES: Everything You Ever Wanted to Know, by Malachy J. Foley, Chapel Hill, NC [PDF]

Planning and Implementation of Dynamic Training to SAS Programmers in a Global Environment, by Stephanie Christofides and Mark Penniston, Omnicare Clinical Research [PDF]

Selecting an Occupational Medicine Network Provider, John Toczek , by John Toczek, ARAMARK Corporation [PowerPoint Slideshow Presentation PPS]

Using the New SURVEY Procedures From a Modeling Perspective, by Jonas Bilenas, JP Morgan Chase Bank [PDF]

Building the RELREC Domain for Pregnancy Data, by Haiping Zhou, Xiang (Alice) Zong, Merck & Co. Inc. [Poster not yet received]

Statistics for Clinical Trial SAS Programmers 1: paired t-test, by Kevin Kyosun Lee, Therakos [Poster had to be withdrawn]

Winter 2008 Presentations

Undocumented and Hard-to-find PROC SQL Features, by Kirk Paul Lafler, Software Intelligence Corporation [PDF]

Exploring DICTIONARY Tables and SASHELP Views, by Kirk Paul Lafler, Software Intelligence Corporation [PDF]

Automated Bulk Loading of Documentum® Using XML Control files Created with Base SAS®,

John Booterbaugh, PharmaLogic, LLC, Sanatoga, PA
Terek Peterson, Shire, Wayne, PA
Kate Wilber, Shire, Basingstoke, Hampshire, UK
[PDF]

Using the SAS XML Mapper and ODS PDF to create a PDF representation of the define.xml (that can be printed), by Lex Jansen, TAKE Solutions [PDF]

Using SAS® Enterprise Guide® to Create Standalone Programs, by Mike Todd, Nth Analytics [PDF]

Methodologies for converting Excel Spreadsheets to SAS® datasets, by Karin LaPann, ViroPharma Incorporated [PDF]

FIRST. AND LAST. TO THE RESCUE, by Sanjiv Ramalingam & Gary Cope, Octagon Research Solutions [PDF]

Fall 2007 Presentations

Concepts and Thoughts for a CDISC /FDA Pilot and. Interfacing with HL7 RCRIM Projects. by Edward Helton, SAS Institute Inc. [No paper was submitted]

Outperforming SAS® Indices for Sorted Datasets, by Mark Keintz & Shuguang Zhang, Wharton Research Data Services [No paper was submitted]

The Rest of the Way There… Creating Multiple Graphs on a Single Page by Terek Peterson & Mary Buckwalter, Shire [PDF]

Steps to Success with Data Analysis & Reporting Using PROC MEANS by Andrew H. Karp, Sierra Information Services [PDF]

Minimal-Space Storage for Integer Data, by Allan Glaser, Merck & Co., Inc. [PDF]

An Alternative Method of Transposing Multiple Variable for Report Generation by Li Luo, Wyeth Pharmaceuticals [not yet submitted]

T.I.P.S. (Techniques and Information for Programming in SAS®), by Mary Anne Rutkowski, Kathy Harkins & Carolyn Maass, Merck & Co., Inc. [not yet submitted]

Annotate Facility, by Showreddy Maramreddy, PharmaNet Development Group [not yet submitted]

Spring 2007 Presentations

Effective Use of SQL in SAS Programming, by Yi Zhao, Merck & Co. Inc. [PDF]

Creating a Standardized CDISC Compliant Database from Legacy Data, by Nate Freimark, Omnicare Clinical Research [not yet submitted]

Reading From Alternate Sources: What To Do When The Input Is Not a Flat File, by Michael L. Davis, Aetna Inc. [PDF Slides ]

Standard SAS Macros for Standard Date/Time Processing, by Qin Lin and Tim Kelly, Applied Clinical Intelligence, LLC [PDF ]

Winter 2007 Presentations

Dictionary Tables and Views: Essential Tools for Serious Applications, by Frank DiIorio, CodeCrafters, Inc. [PDF]

The Implementation of Define.xml: Metadata for SAS-Based Clinical Data, by Tang Li, Cephalon [PPT]

An Introduction to SAS Character Functions (Including some SAS 9 functions), by Dr. Ron Cody, Independent Consultant [PDF, PPT]

Oracle Clinical for SAS Programmers, by Kevin Lee, Adolor Corporation [PDF]

Designing and Building an Administrative Model for the SAS® Drug Development Tool, by Margaret Coughlin, Merck & Co., Inc. [PDF]

Because We Can: Using SAS System Tools to Help Our Less Fortunate Brethren, by John Cohen, AstraZeneca Pharmaceuticals [saved in PPS format and zipped]

Fall 2006 Presentations

Converting Data to the CDISC SDTM Standard Using SAS Data Integration Studio, by Barry R. Cohen, Octagon Research Solutions, Wayne, PA [PDF]

Speaking Scalability with SAS, by Margaret Crevar, SAS Performance Lab Manager, SAS Institute, Cary, NC [PPT]

Old Car, But New Engine!, by Haibin Shu, Duramed Research Inc. [PPT]

Minimal Pain Migration, by John Dennis, Quaker Chemical Corp. [PPT]

Annotated SAS/GRAPH® Plot of z/OS® Goal Mode Performance Indexes Using Macros and MXG® Software, by Neal Musitano Jr., Department of Veterans Affairs, Information Technology Center, Philadelphia, PA [PDF]

Spring 2006 Presentations

DBCompare: A Powerful Tool to Compare Data. Definitions of Datasets Across Multiple Databases., by Balakrishna Dandamudi, SFBC International [Paper not yet submitted]

The Best of Cheesy, Sleazy SAS® Tricks, by Michael Davis, Aetna Inc. [MS Word DOC] and [PowerPoint slides]

DATA Step Hash Objects and How to Use Them, by Paul Dorfman, Dorfman Consulting, and Lessia S. Shajenko, Bank of America. [PDF]

Macros to get to "Know Thy Data", by

Diane Foose, GlaxoSmithKline, Collegeville, Pa
Mike Gunshenan, GlaxoSmithKline, Collegeville, Pa
Rick Morales, GlaxoSmithKline, Collegeville, Pa [DOC]

Winter 2006 Presentations

ODS 201: Making Life Easier with the SAS® Output Delivery System, Presented By: Andrew H. Karp Sierra Information Services, Inc. [Paper not yet submitted]

What is an Advisory Committee Meeting and How to Prepare for One?, By: Kathy Harkins & Mary Anne Rutkowski Merck & Company [PDF]

GROUP PROCESSING AND BY'S NOTSORTED OPTION, by Karuna Samudral, Octagon Research Solutions, Inc., Wayne, PA Gregory M. Giddings, Centocor R&D Inc., Malvern, PA [DOC]

PULSE AIM, by Sam Preston, Aetna Informatics Manager [PDF]

Making Sense of PROC TABULATE., by Jonas V. Bilenas, JP Morgan Chase, Wilmington, DE [PDF]

USING RADAR CHART TO DISPLAY CLINICAL DATA., by Shi-Tao Yeh, GlaxoSmithKline, King of Prussia, PA [PDF]

Fall 2005 Presentations

Moving Data and Analytical Results between SAS and Microsoft Office, by Vincent DelGobbo, SAS Institute Inc., Cary, NC
This paper discusses using the HTML and XML support in Base SAS software to move data between SAS and Microsoft Office (versions 2002 and later). You can use the techniques described here regardless of the platform on which SAS software is installed (including a mainframe). Read the paper (PDF) | Download the source code (ZIP)

SAS and Computing Speed [Microsoft PowerPoint Show], by Michael Boldin, Wharton School

Summarizing All Categories Where Some Are Not in the Data [DOC], by Gregory M. Giddings, Centocor R&D

E-Mail z/OS® SAS®/MXG® Tape Management Reports with ODS Traffic Lighting [PDF], by Neal Musitano Jr., Department of Veterans Affairs

Retrieving SAS Programs Back From PDF Files [PDF], by Eric Zhang, Centocor Inc., Malvern, PA

The Skinny On Fat SAS Data Set Processing [Microsoft PowerPoint Show], by Gopal Rajagopal, Merck & Co. Inc.

Array Programming Basics [PDF], By John J. Cohen, AstraZeneca LP, Wilmington, DE

Spring 2005 Presentations

Using SAS ETL Studio to Create a CDISC-Compliant Clinical Data Warehouse [PDF], by Barry Cohen, Planning Data Systems, Inc.

Loop-Do-Loop Around Arrays [PDF], Wendi Wright, Educational Testing Service

Creating ActiveX Graphs for Presentations using SAS Enterprise Guide [PDF], by Terek Peterson, Cephalon, Inc. and Robert Gordo, Cephalon, Inc.

Winter 2005 Presentations

Recursive Subroutine Macros [PDF], By Chang Y. Chung, Princeton University

You Could Look It Up: An Introduction to SASHELP Dictionary Views [PDF], By Michael Davis, Bassett Consulting Services

Data Validation: Using PROC SQL [PDF], and related zipped material on the paper, by Balakrishna Dandamudii, SFBC New Drug Services.

Power of PROC FORMAT [PDF], by Jonas Bilenas, JP Morgan Chase

Sending SAS® files here, there and everywhere (receiving too!) [PDF], by Stephen Rhoades, IMS HEALTH Inc., Plymouth Meeting, Pa.

Fall 2004 Presentations

New Features in SAS Version 9 [ppt PowerPoint], By Rick Langston, SAS Institute

Base SAS® Enhancements in SAS®9 Course Notes [PDF], SAS Institute Inc.

GRAPHICAL DISPLAY OF DATA – A NONPARAMETRIC APPROACH [PDF], by Shi-Tao Yeh, GlaxoSmithKline, King of Prussia, PA

SAS® Data Quality - Cleanse [MS Word], by Michael Krumenaker - Sr. Project Manager, Palisades Research, Inc.

PHARMACOKINETICS MADE FRIENDLIER A Brief Introduction for SAS Programmers [MS Word], By Sarah Wheeler

How to Quickly Customize your SAS Session [ppt PowerPoint], By Mary Anne Rutkowski and Kathy Harkins, Merck & Company

Handling SAS@ Formats Catalogs across Versions [PDF], By Karin LaPann, AstraZeneca, Wilmington DE

Spring 2004 Presentations/Readings

A Patient Profile Using ODS RTF [PDF], By Terek Peterson, Cephalon, Inc.

PROC SQL - Is it a Required Tool for Good SAS Programming? [PDF], by Ian Whitlock

SAS/STAT Software: SAS 9.1 Power and Sample Size Computations with SAS Overview Statistical power analysis characterizes the ability of a study to detect a meaningful effect size— to read more ... http://support.sas.com/rnd/app/da/new/pdf/PSS.pdf

PROC POWER in SAS 9.1, by Deborah J. Bauer, Russ Lavery (This paper requires Acrobat 5.0 or later due to its 128-bit RC4 Encription)

ODS Step by Step [PDF], by Wendi L. Wright, Educational Testing Service, Princeton, NJ

Using PROC PRINCOMP for Survey Data Reduction [MS Word], by Catherine Trapani, Educational Testing Service

Winter 2004 Presentations:

ODS Step by Step [PDF], by Wendi L. Wright, Educational Testing Service, Princeton, NJ

The Use and Abuse of the Program Data Vector [paper and slides in PDF format], by Jim Johnson, Covance Periapproval Services Inc., Radnor, PA

CALL EXECUTE: the More Powerful but Less Well Known SAS. System Routine [PDF and PPS format], by Balakrishna Dandamudi, SFBC New Drug Services

An Animated Guide©: Speed Merges: SAS V9.1 Hashing [PDF], by Russell Lavery, Contractor for About-Consulting, Chadds Ford, PA

[HOME]

The Archive of Papers was last modified: January 22, 2010. Comments and suggestions are always appreciated, email the WebMaster at webmaster@PhilaSUG.org

[About]