WUSS 2009 Conference Proceedings

San Jose, California
September 1-3, 2009

Analytics and Statistics

(PDF) Application of Segmented Regression Analysis to the Kaiser Permanente Colorado Critical Drug Interaction Program
Author: Nikki M. Carroll, Kaiser Permanente

(PDF) Don’t Be Loopy: Re-Sampling and Simulation the SAS Way
Author: David L. Cassell, Design Pathways

(PDF) Getting Correct Results from PROC REG
Keywords: Descriptive statistics, Statistical significance, SAS
Author: Nate Derby, Statis Pro Data Analytics

(PDF) Automating the Process of Scoring a Generalized Linear Model Fitted using PROC GENMOD
Author: Prakash Gurumurthy, ISO Innovative Analytics

(PDF) Using SAS for Nonparametric Statistics
Author: Gerald R. Hobbs, West Virginia University

(PDF) PROC NLP Approach for Optimal Exponential Smoothing
Author: Srihari Jaganathan, Cognizant Technology Solutions

(PDF) Developing Business Failure Prediction Models Using SAS Software
Author: Oki Kim, Statistical Analytics LLC

(PDF) The SURVEYFREQ Procedure in SAS 9.2: Avoiding FREQuent Mistakes When Analyzing Survey Data
Author: Kathryn Martin-Fingar, California State Department of Public Health

(PDF) Using PROC LOGISTIC to Estimate Willingness to Pay for Fresh Produce
Keywords: WUSS
Author: Mikael Peterson, California Polytechnic State University, San Luis Obispo

(PDF) Modeling Spatial and Temporal Variations of Arsenic in Surface Water
Author: Anpalaki J. Ragavan, University of Nevada, Reno

(PDF) Group Confidence Limit Plots Using PROC GPLOT and PROC SGPLOT
Author: Robert A. Rutledge, Sun Microsystems

(PDF) Guidelines for Reliability, Confirmatory and Exploratory Factor Analysis
Authors: Diana D. Suhr, University of Northern Colorado; Mary Shay, Cheery Creek School District, Greenwood Village, CO

(PDF) Capturing and Presenting PROC TTEST Results Using ODS and PROC REPORT
Author: Patrick Thornton, SRI International

(PDF) Optimal Model Selection By a Genetic Algorithm Using SAS
Author: Jerry Tsai, Clintuition

Methods, Models, and More: New Analyses Available with SAS/STAT 9.2
Author: Robert N. Rodriguez, SAS

Choice Experiments for Market Research and Other Features in JMP 8
Author: John P. Sall, SAS

Applications Development

(PDF) The Little Engine That Could: Using EXCEL LIBNAME Engine Options to Enhance Data Transfers between SAS and Microsoft Excel Files
Author: William E. Benjamin, Jr., Owl Computer Consultancy, LLC

(PDF) ODS Statistical Graphics: How You SHOULD Be Developing Your SAS Applications
Author: David L. Cassell, Design Pathways

(PDF) Best Practices in IO Configuration for your SAS9 Applications
Author: Margaret A. Crevar, SAS

(PDF) Portable SAS: Language and Platform Considerations
Author: Robert A. Cruz, Info-Mation Systems

(PDF) Web-Based Integration of Data Collection and Reporting Based on SAS Foundation Technologies
Authors: Beate Danielsen, Health Information Solutions; Eileen Walsh, Soora Wi, Kaiser Permanente

(PDF) List Processing Routine CallXinc: Calling Parameterized Include Programs Using a Data Set as List of Parameters
Keywords: contents, data review, freq, ifc, list processing, global macro variable, mode, nrstr, parameter, parameterized include program, summary, sysfunc, transpose, univariate
Author: Ronald J. Fehd, Centers for Disease Control

(PDF) Using the SmryEachVar Data Review Suite
Keywords: call execute global macro variables, includes, list processing, module, nrstr, parameters, routines, source2, subroutines
Author: Ronald J. Fehd, Centers for Disease Control

(PDF) Getting from SAS 9.1.3 to SAS 9.2: Migration or Promotion
Author: Diane Hatcher, SAS

(PDF) ODS Graphics Designer: Your Tool of Choice for Interactive, Batchable Graphics
Author: Sanjay N. Matange, SAS

(PDF) Proc Format, a Speedy Alternative to Sort/Merge
Author: Jenine M. Milum, Wachovia

(PDF) The Power to Show: Ad Hoc Reporting, Custom Invoices, and Form Letters
Author: Daniel O’Connor, SAS

(PDF) An Automated Tool for Data Change Implementation
Authors: Alexander Pakalniskis, Cedars-Sinai Medical Center; Peixin Wang, Cedars-Sinai Medical Center; Alein T. Chun, Cedars-Sinai Medical Center; Nilesh Bajania, Cedars-Sinai Medical Center

(PDF) Improving Efficiency of Excel Summary Production with SAS Data Steps Prior to PROC DBLOAD Export
Author: Keiko I. Powers, J. D. Power and Associates

(PDF) Implementation of an Inventory Routing System Using the SAS Suite of Products
Authors: Dominique M. Richard, self-employed; Joel Adler, University Informatics Associates, Inc.

(PDF) Fast Solution for Identifying and Quantifying Gaps in Messy Time Segments
Author: Lorne M. Salter, Salter Data Consultants

(PDF) Relentless Testing with SAS
Author: Lorne M. Salter, Salter Data Consultants

(PDF) Introduction to XML Spreadsheets for SAS Programmers, Parts I & II
Author: James J. Van Campen, SRI International

CDISC Methodologies for FDA Submissions

(PDF) BRIDGing CDASH to SAS: How Harmonizing Clinical Trial and Healthcare Standards May Impact SAS Users
Author: Clinton Brownley, independent statistical consultant

(PDF) The Second CDISC Pilot Project: A Metastandard for Integrating Databases
Authors: Gregory C. Steffens, Eli Lilly & Co.; Ian Fleming, Genentech, Inc.

(PDF) CDISC Implementation on a Rheumatoid Arthritis Project Partnership
Authors: Patricia L. Gerend, Genentech, Inc.; Chris Price, Roche Products Limited; Olivier Leconte, Roche Products Limited; Michelle Zhang, Genentech, Inc.

(PDF) How a SAS/IntrNet tool was created at the FDA for the detection of potential drug-induced liver injury using data with CDISC standard
Authors: Ted J. Guo, FDA; John Senior, FDA; Kate Gelperin, FDA

(PDF) CDISC for the Medical Device and Diagnostic Industry: An Update
Keywords: CDISC, SDTM, CDASH, Devices, Diagnostics
Author: Carey G. Smoak, Roche Molecular Systems, Inc.

(PDF) The CDISC Study Data Tabulation Model (SDTM): History, Perspective, and Basics
Keywords: SAS Drug Development, Report Management, User Interface, Application Development, Regulatory Compliance, Web-enabled
Author: Frederick Wood, Octagon Research Solutions, Inc.

Coders’ Corner

(PDF) Age is Just a Number: Accurately Calculating Integer and Continuous Age
Authors: Sara R. Adams, Icon Clinical Research; Chris Colby, Icon Clinical Research

(PDF) Wonderful Unix SAS Scripts: SAS Quickies for Dummies
Author: Raoul A. Bernal, Amgen Inc.

(PDF) Pointer/Indirect LIBNAMEs: a Platform-independent Method to Manage Access to & Contention for SAS Format Catalogs
Author: Thomas E. Billings, Kaiser Permanente

(PDF) Using Functions SYSFUNC and IFC to Conditionally Execute Statements in Open Code
Keywords: assertions, function, ifc, nrstr, parameterized include program, sysfunc
Author: Ronald J. Fehd, Centers for Disease Control

(PDF) SYMply PUT: GET the Most Out of SYMPUT and SYMGETN
Author: Robert E. Howard, Veridical Solutions

(PDF) SAS and SQL “Join” Forces to Perform a Many-to-Many Merge
Authors: Ginny Lai, ICON Clinical Research; Eric P. Elkin, ICON Clinical Research

(PDF) The Next Step with Macros – Double Ampersand Macros &&helpme&i..
Author: Jennifer R. Rosson, Unicon

(PDF) Selecting a Stratified Sample with PROC SURVEYSELECT
Author: Diana D. Suhr, University of Northern Colorado

(PDF) Efficiently Handle Lists of Items using the SAS Macro Language– Save Time and Reduce Errors
Author: Jerry Tsai, Clintuition

(PDF) Cleaning Duplicate Observations on a Chessboard of Missing Values
Author: Mayrita Vitvitska, ClinOps, LLC

(PDF) Pros and Cons of X command vs SYSTASK command
Author: Irina Walsh, ClinOps, LLC

(PDF) Playing Favorites: How to Manage Date Conflicts When Some Date Ranges are Preferred Over Others
Author: Eric C. Wong, Palo Alto Medical Foundation Research Institute

(PDF) Working with SAS on a Remote UNIX Server from a Local Windows
Keywords: SAS , Remote, UNIX, Server, Windows, Client, SSH.
Author: Alexandre Zolotovitski, Sun Microsystems Inc

Data Presentation and Business Intelligence

(PDF) You Want ME to use Enterprise Guide??
Keywords: Enterprise Guide
Author: Vincent DelGobbo, SAS

(PDF) Introduction to PROC GPLOT
Author: Jimmy Thomas Efird, Cincinnati Children’s Hospital

(PDF) ODS Packages: Putting Some Zip in Your ODS Output
Author: Eric A. Gebhart, SAS

(PDF) Inline Formatting with ODS Markup
Author: Eric A. Gebhart, SAS

(PDF) Dashboard Reports for Predictive Model Management
Author: Diane Hatcher, SAS

(PDF) An Example of Using Different Methods to Create Excel Outputs from SAS
Authors: Julie A. Kilburn, City of Hope; Rizvan Mamet, City of Hope; Anna ter Veer, City of Hope; Ann Vanderplas, City of Hope; Rebecca Ottesen, City of Hope; Joyce C. Niland, City of Hope

(PDF) Revolutionary BI: A Vision for Business Intelligence
Author: Chuck Kincaid, COMSYS

(PDF) Effective Graphics Using SAS/GRAPH SG Procedures
Author: Sanjay N. Matange, SAS

(PDF) Introduction to the Graph Template Language
Author: Sanjay N. Matange, SAS

(PDF) Repo Your Missing Data Using PROC REPORT
Author: Ethan Miller, SRI International

(PDF) Breaking New Ground with SAS 9.2 ODS Layout Enhancements
Author: Daniel O’Connor, SAS

(PDF) Daring Enterprise Guide Code Changes with a Safety Net
Author: Lorne M. Salter, Salter Data Consultants

(PDF) Using PROC REPORT to Cross-Tabulate Multiple Response Items
Author: Patrick Thornton, SRI International

(PDF) SAS on iPhone BI Gone Mobile
Keywords: iPhone, Mobile Computing, SAS Delivery
Author: Sy J. Truong, Meta-Xceed, Inc.

(PDF) CSSSTYLE: Stylish Output with ODS and SAS 9.2
Author: Cynthia L. Zender, SAS

(PDF) Have It Your Way: Rearrange and Replay Your Output with ODS DOCUMENT
Author: Cynthia L. Zender, SAS

Creating a Report in the SAS Information Delivery Portal using SAS Information Maps
Author: Jenine M. Milum, Wachovia

Databases and Warehouses

(PDF) Exploring DICTIONARY Tables and SASHELP Views
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Simple but Effective SAS-based Automation Techniques to Combine SAS Data Libraries
Author: Joe Perry, Perry & Associates Consulting

Hands-On Workshops

(PDF) Advanced PROC REPORT: Getting Your Tables Connected Using Links II
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) ODS Statistical Graphics 101
Author: Wei Cheng, Isis Pharmaceuticals, Inc.

(PDF) More Tips and Tricks for Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS
Keywords: ODS, Microsoft Excel, XML, ExcelXP tagset, multi-sheet workbook
Author: Vincent DelGobbo, SAS

(PDF) Solving Your Problems with SAS Enterprise Guide – SAS Without Programming
Author: AnnMaria De Mars, University of Southern California

(PDF) Exploring Output Delivery System (ODS) Programming Techniques
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) SAS Macro Programming Tips and Techniques
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Getting Up to Speed with PROC REPORT
Author: Kimberly Stinson LeBouton, KJL Computing

(PDF) Using PROC SGPLOT for Quick High Quality Graphs
Authors: Susan J. Slaughter, Avocet Solutions; Lora D. Delwiche, University of California, Davis

(PDF) SAS System and SAS Program Validation Techniques
Keywords: SAS Validation, Program Validation, Change Control, Version Management, Develoment Cycle
Author: Sy J. Truong, Meta-Xceed, Inc.

Health Outcomes and Healthcare Research Methodologies

(PDF) Trend Analyses of Health Indicator and Risky Health Behavior Variables in Nevada
Authors: Moses Anabila, University of Nevada Center for Research Design and Analysis, CRDA; George C. J. Fernandez, University of Nevada Center for Research Design and Analysis, CRDA

(PDF) Strategic Business Intelligence and Analytics in Healthcare
Authors: Bharat Chitnavis, Smith Hanley Consulting; Gary Wood, Smith Hanley Consulting; Shelley Muhs, Smith Hanley Consulting

(PDF) Computing Hazard Ratios and Confidence Intervals for a Two-Factor Cox Model with Interaction Terms
Authors: Jing Wang, Fred Hutchinson Cancer Research Center; Marla J. Husnik, Fred Hutchinson Cancer Research Center

(PDF) Using Recycled Predictions for Estimating Marginal Effects
Authors: Zhongmin Li, UC Davis Health System; Geeta Mahendra, UC Davis Health System

(PDF) Custom Outcomes Benchmarking Reports Using Dynamic Data Exchange (DDE), the Only Way to Go
Authors: Rebecca Ottesen, City of Hope; Julie A. Kilburn, City of Hope; Ann Vanderplas, City of Hope; Anna ter Veer, City of Hope; Rizvan Mamet, City of Hope; Joyce C. Niland, City of Hope

(PDF) Evaluating the Change in Lung Function Over Time: Practicalities of Using ESTIMATE and CONTRAST Statements
Author: David J. Pasta, ICON Clinical Research

(PDF) Reporting Quality of Cancer Care for the National Comprehensive Cancer Network – A SAS Bridge to Excel
Authors: Anna ter Veer, City of Hope; Rebecca Ottesen, City of Hope; Ann Vanderplas, City of Hope; Julie A. Kilburn, City of Hope; Dorothy Romanus, City of Hope; Joyce C. Niland, City of Hope

Management, Careers and Professional Development

(PDF) Beef Up Your Career: Job Survival Steps During This Economic Recession
Author: Raoul A. Bernal, Amgen Inc.

(PDF) How to Maintain Happy SAS 9 Users
Author: Margaret A. Crevar, SAS

(PDF) Avoiding Mouse Elbow
Author: Malachy J. Foley

(PDF) Connect with SAS Professionals Around the World with LinkedIn and sasCommunity.org
Authors: Kirk Paul Lafler, Software Intelligence Corporation; Charles Edwin Shipp, Shipp Consulting

(PDF) Quality Outcomes and SAS: Structuring, Managing and Working in SAS-Based Programming Groups
Author: Joe Perry, Perry & Associates Consulting

(PDF) Managing Independent Consultants — An Oxymoron?
Author: David Polus, COMSYS Information Technology Services, Inc

Posters

(PDF) Validating the Bland-Altman Method of Agreement
Author: Ramya R. Fernandez, UNLV , George Fernandez, UN Reno

(PDF) A Beginner’s Example of PROC MIXED for the Analysis of Letter Identification Using Reaction Time
Author: Sarah R. Greene, SRI International

(PDF) Using SAS PROC TRAJ to Improve Estimates of Assortative Mating for Problem Behavior
Author: Kelly Knight, University of Colorado at Boulder

(PDF) The Evolution of a SAS/GRAPH Application
Author: Jenine M. Milum, Wachovia

(PDF) Using SAS to Enhance Interviewer Productivity at the University-based Center for Research Design and Analysis
Author: Martha Rodriguez-Salazar, University of Nevada Center for Research Design and Analysis, CRDA George Fernandez, University of Nevada Center for Research Design and Analysis, CRDA

(PDF) ‘Table 1’ in Scientific Manuscripts; Using PROC REPORT
Author: Carter Sevick, DoD Center for Deployment Health Research

(PDF) Skinny to Fat: In Search of the ‘Ideal’ Dataset
Author: Nina Worden, ClinOps, LLC

(PDF) A Biometric Analysis of Twin Data Using PROC MIXED
Author: Mo Zheng, University of Southern California

SAS Essentials Workshops

(PDF) Five Ways to Create Macro Variables: A Short Introduction to the Macro Language
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) Roadmap to Documentation, Training, Technical Support, and support.sas.com
Author: Kathryn A. Council, SAS

(PDF) ERRORS, WARNINGS, and NOTES (Oh My): A Practical Guide to Debugging SAS Programs
Authors: Lora D. Delwiche, University of California, Davis; Susan J. Slaughter, Avocet Solutions

(PDF) A Little Stats Won’t Hurt You
Keywords: Descriptive statistics, Statistical significance, SAS
Author: Nate Derby, Statis Pro Data Analytics

(PDF) The Fundamentals of Data Step Programming I: The Essence of Data Step Programming and By-Group Processing
Author: Arthur Xuejun Li, City of Hope Comprehensive Cancer Center

(PDF) The Fundamentals of DATA Step Programming II: Looping
Author: Arthur Xuejun Li, City of Hope Comprehensive Cancer Center

(PDF) The Fundamentals of DATA Step Programming III: Array Processing
Author: Arthur Xuejun Li, City of Hope Comprehensive Cancer Center

Tutorials

(PDF) Practical Uses of the DOW Loop
Author: Richard Read Allen, Peak Statistical Services

(PDF) Leave Your Bad Code Behind: 50 Ways to Make Your SAS Code Execute More Efficiently
Author: William E. Benjamin, Jr., Owl Computer Consultancy, LLC

(PDF) Advanced PROC REPORT: Getting Your Tables Connected Using Links I
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) Manual to Automatic: Changing Your Program’s Transmission
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) The Basics of the PRX Functions
Author: David L. Cassell, Design Pathways

(PDF) An Introduction to SAS Character Functions
Author: Ron Cody, consultant

(PDF) Discriminant Analysis, a Powerful Classification Technique in Predictive Modeling
Author: George C. J. Fernandez, University of Nevada – Reno

(PDF) No, It’s Not Magic: De-mystifying the SAS Macro Facility
Author: Jay A. Jaffe, JaffCo

(PDF) Base SAS Tips, Tricks and Techniques
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) DATA Step versus PROC SQL Programming Techniques
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Creating Macro Variables Using the %LET Statement or the SYMPUT Routine
Author: Arthur Xuejun Li, City of Hope Comprehensive Cancer Center

(PDF) Efficient Statistical Programming? – These Small Steps Make the Difference
Author: Keiko I. Powers, J. D. Power and Associates

(PDF) If I Only Had a Map: Getting From Here to There Common Approaches to Solving DATA Step Logic Issues
Author: Kim M. Wilson, SAS

(PDF) Tiptoe through the Templates
Author: Cynthia L. Zender, SAS

Creating Statistical Graphics with ODS in SAS 9.2
Author: Robert N. Rodriguez, SAS