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
[PhilaSUG Logo]
[HOME]
The Archive of Past Meeting Announcements was last modified: March 15, 2008. 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 - These papers are available to download. To view DOC files and you do not have Microsoft Word or compatible word processor, download the free viewer.

To view files in .pdf format, download the free Adobe Acrobat Reader. Get Adobe Acrobat Reader


Table of Contents:

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

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