WUSS 2005 Conference Proceedings

San Jose, California
September 21-23, 2005

Coders’ Corner

(PDF) Comparing the SAS XML Libname Engine with ODS MARKUP in the Creation of XML Files
Keywords: XML, XML Libname Engine, ODS MARKUP
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Duration Calculation from a Clinical Programmer s Perspective
Author: Alice M. Cheng, Scios Inc., Fremont, CA

(PDF) Illustrating Concatenation Operations with PROC APPEND
Keywords: PROC APPEND, concatenate
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Intelligent SAS Log Manager
Keywords: SAS, Log, Macro, Symbolgen, MLogic, MError
Author: Paul D. Sherman, Western Digital Corporation, Fremont, CA

(PDF) It’s the lines per page that counts
Authors: Jonathan M. Squire, C2RA, Cambridge, MA; Johnny Tai, Comsys, Portage, MI

(PDF) Just Skip It
Author: Helen D. Carey, Carey Consulting, K?ne ohe, HI

(PDF) %MACRO Bag of Tricks
Author: Rodger Madison, RAND Corporation, Santa Monica, CA

(PDF) Macros to Help Organize and Standardize SAS Projects
Keywords: macros libname symput
Author: Patrick Thornton, SRI International, Menlo Park, CA

(PDF) MISSING VALUES: Everything You Ever Wanted to Know
Author: Malachy J. Foley, Chapel Hill, NC

(PDF) Old Fashion but Still Useful: Applications for Running the X Statement to Issue DOS Commands in the Windows Operation System
Author: Na Li, Pharmacyclics, Sunnyvale, CA

(PDF) Overcome Programming Problems with SAS Automatic Variable N
Keywords: AUTOMATIC VARIABLE, SAS/GRAPH, ANNOTATION, PROC REPORT, ARRAY, ODS TEMPLATE
Author: Louie Huang, Baxter BioScience, Westlake Village, California 91362, USA

(PDF) Patient Profile, a Simple Approach
Author: Sandy Chang, Gilead Sciences, Inc., Foster City, California

(PDF) The General Method for Variable Recoding and Its Applications in SAS
Authors: Randi Chen, Pacific Health Research Institute, Honolulu, Hawaii; Ka-On Fong, Pacific Health Research Institute, Honolulu, Hawaii

(PDF) Sign of the Times: Using SAS to Produce Conference Signage
Keywords: ODS PDF WATERMARK BACKGROUND
Author: Daniel K. Downing, Caremark, Scottsdale, Ariz.

(PDF) Understanding WHERE Clause Processing and Indexes
Keywords: WHERE Clause, Index
Author: Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA

(PDF) What’s Your _TYPE_? Finding the CLASS You Want In PROC SUMMARY
Author: Frank A. Ferriola, Jr., Pacioli Companies, Highlands Ranch, CO

(PDF) Why Use PROC DATASETS
Author: David Fickbohm, Homegain+, Emeryville, CA

Data Analysis and Statistics

(PDF) A Comparison of Missing Data Handling Methods
Author: Catherine Truxillo, SAS Institute Inc, Cary, NC

(PDF) Introducing the GLIMMIX Procedure for Generalized Linear Mixed Models
Author: Oliver Schabenberger, SAS

(PDF) SAS/STAT Version 9: Progressing into the Future
Author: Maura E. Stokes, SAS

(PDF) A Comparison of Two Procedures to Fit Multi-Level Data: PROC GLM versus PROC MIXED
Keywords: GLM, PROC MIXED, Healthcare, Hierarchical data, ICC
Author: MaryAnne DePesquo Hope, Health Services Advisory Group, Phoenix, AZ

(PDF) A Macro Mapping Date and Time Variable to CDISC Date and Time Variable
Authors: Song Liu, Biogen Idec, San Diego, California; Brett Sellars, Biogen Idec, San Diego, California

(PDF) A Programmer s Guide to Statistical Procedures
Author: Jim F. Edgington, Gilead Sciences, Inc., Foster City, California

(PDF) Analysis of Group-Randomized Designs: A clinic-based breast cancer rescreening example
Authors: Jesse A. Canchola, University of California, San Francisco & California State University, East Bay; Regina Otero-Sabogal, University of California, San Francisco

(PDF) Analyzing Sample Data with the SAS Survey Procs
Author: David L. Cassell, Design Pathways, Corvallis, OR

(PDF) Characterizing Patterns of Longitudinal Data Completeness through Successive Refinement
Authors: Lawrence Rasouliyan, Ovation Research Group, San Francisco, California; David J. Pasta, Ovation Research Group, San Francisco, California

(PDF) Classification Using Neural Networks: From Human to Machine Learning
Authors: Mable Kong, CSU East Bay, Alameda, CA; Qian (Julia) Zhang, CSU East Bay, Albany, CA

(PDF) Combining Segmentation and Targeting Modeling: A Winning Formula
Authors: Aaron Lai, InfoAtlas, Inc., Oakland, CA; Howell Kiung, InfoAtlas, Inc., Oakland, CA; Oiching Yeung, InfoAtlas, Inc., Oakland, CA

(PDF) Computing Exact Power for Multivariate Repeated Measurements Design
Authors: Jimmy Thomas Efird, Biostatistics and Data Management Facility, John A. Burns School of Medicine, Honolulu, HI; Kavitha Alimineti, Biostatistics and Data Management Facility, John A. Burns School of Medicine, Honolulu,

(PDF) Effects of PROC EXPAND Data Interpolation on Time Series Modeling when the Data are Volatile or Complex
Author: Keiko I. Powers, J. D. Power and Associates, Westlake Village, CA

(PDF) Principal Component Analysis vs. Exploratory Factor Analysis
Author: Diana D. Suhr, University of Northern Colorado

(PDF) Revisiting the cross-over: A two-period design using a treatment and a placebo
Authors: Qian (Julia) Zhang, California State University, East Bay; Mable Kong, California State University, East Bay

(PDF) Using SAS to Calculate Arizona Judicial Salaries
Authors: Mark McDermott, Arizona Supreme Court, Phoenix, AZ; Humberto Cisneros, Arizona Supreme Court, Phoenix, AZ

(PDF) Using Statistical Graphics to Understand Your Data (Not Just Present Results)
Author: David J. Pasta, Ovation Research Group, San Francisco, CA

(PDF) What moves wholesale electricity prices in the Pacific Northwest?
Authors: Aaron Lai, InfoAtlas, Inc., Oakland, California; Raymond Wan, InfoAtlas, Inc., Oakland, California

Data Presentation

(PDF) Creating Multi-sheet Excel Workbooks with ODS
Author: David W. Kelley, SAS

(PDF) Introduction to Graphics Using SAS/GRAPH Software
Author: Ted Durie, SAS

(PDF) ODS HTML and CSS
Author: Ted Durie, SAS

(PDF) A Peek at PROC DOCUMENT
Author: Andrew H. Karp, Sierra Information Services, Inc., Sonoma, California USA

(PDF) Better Communication, Analysis and Decisions SAS plus GIS
Author: Stephen Trammell, ESRI, Redlands, CA

(PDF) Coding with Compassion Giving Everyone Access to The Power to Know
Keywords: 508, accessible, accessibility, graph, ods, sas, output, pdf, gaccessible, disability, government, html, w3c, wai, tabulate, report, standards, gchart, annotate, graphs, figures, device driver
Authors: Jennifer S. Harper, MSPH, California Dept. of Health Services, Epidemiology and Prevention for Injury Control (EPIC) Branch, Sacramento, CA; Lisa Pappas, SAS

(PDF) Drill down into your SAS data on the web while using XML, javascript and HTML
Author: Bruce Kayton, San Diego, CA

(PDF) Introduction to SAS maps
Keywords: GMAP SQL
Author: Gur Hoshen, American Institutes for Research, Palo Alto, CA

(PDF) Unleashing the Power of MULTILABEL Formats
Author: Andrew H. Karp, Sierra Information Services, Sonoma, CA

(PDF) Using SAS, MySQL, and PHP to Empower End-Users to Generate Dynamic Descriptive and Analytic Statistical Web Reports
Authors: Jeremy Morris, University of Utah, Office of Budget & Institutional Analysis (OBIA); Gary Levy, University of Utah, Office of Budget & Institutional Analysis (OBIA); Ray Dahl, University of Utah, Office of Budget & Institutional Analysis (OBIA)

(PDF) Using SAS with XML to Create Custom Formatted Excel Workbooks
Keywords: SAS, Excel, XML
Author: James J. Van Campen, SRI International, Menlo Park, CA

Data Warehousing and Database Management

(PDF) Enhancements to the SAS Data Storage Architecture
Author: Bill Oliver, SAS

(PDF) Pipeline Parallelism Performance Practicalities
Author: Michelle Buchecker, SAS

(PDF) Database-ics A Primer for Creating a Usable Database in SAS
Author: Frank A. Ferriola, Jr., Pacioli Companies, Highlands Ranch, CO

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

(PDF) Extreme Web Access: What to Do When FILENAME URL Is Not Enough
Author: Garth W. Helf, Hitachi Global Storage Technologies, San Jose, CA

(PDF) Looking into Oracle with SAS: Designing a simple SAS Windows interface for an Oracle Database.
Keywords: SAS, Oracle, Database, Windows, Interface
Author: Allison Mercer, CTB/McGraw-Hill, Monterey, California

(PDF) Producing Multipurpose Metadata for Data Quality, and a Data Dictionary
Author: John E. Bentley, Wachovia Bank, Charlotte NC

(PDF) The SQL Optimizer Project: _Method and _Tree in SAS 9.1
Author: Russell M. Lavery, Contractor for Numeric, LLC

(PDF) The Optimizer Project: WHERE The Statement Is Not The Clause
Keywords: SQL, Query, Database, Beancounting, Data Modeling, Creating Efficient SQL
Authors: Paul D. Sherman, San Jose, CA; Russell M. Lavery, Ardmore, PA

Hands-On Workshops

(PDF) Moving Data and Analytical Results between SAS and Microsoft Office
Author: Vincent DelGobbo, SAS

(PDF) A Hands-On Tour of the 5 Most Exciting Features Found in PROC SQL
Keywords: PROC SQL, queries, case, views, indexes, joins
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Extreme Graphics Make Over: Using SAS/GRAPH to Get the Graphical Output You Need
Authors: Miriam G. Cisternas, Ovation Research Group, San Francisco, CA; Arthur L. Carpenter, California Occidental Consultants, Oceanside, CA

(PDF) Graphing the Probability of Event as a Function of Time Using Survivor Function Estimates and the SAS System’s PROC PHREG
Keywords: survival analysis, Kaplan Meier, Cox Regression, lifetest, phreg
Authors: Tyler C. Smith, Department of Defense Center for Deployment Health Research, Naval Health Research Center, San Diego, CA; Besa Smith, Department of Defense Center for Deployment Health Research, Naval Health Research Center, San Diego, CA

(PDF) Introduction to Summary Tables in SAS Enterprise Guide
Keywords: “Summary Tables”, “Enterprise Guide”, “PROC TABULATE”, reports, styles
Authors: Lora D. Delwiche, University of California, Davis, CA; Susan J. Slaughter, Avocet Solutions, Davis, CA

(PDF) PROC REPORT Basics: Getting Started with the Primary Statements
Author: Arthur L. Carpenter, California Occidental Consultants, Oceanside, California

(PDF) SAS with Style: Creating your own ODS Style Template for RTF Output
Author: Lauren E. Haworth, Genentech, Inc., South San Francisco, CA

(PDF) Version 9 Changes and Enhancements
Author: Dana Rafiee, Destiny Corporation

(PDF) WHERE vs. IF Statements: Examples in usage and differences
Author: Sunil Kumar Gupta, Gupta Programming

Posters

(PDF) A Journey to Ellis Island: Profiling Historical Immigration Using SAS and JMP Time Series Methods
Keywords: SAS, JMP, regression, Granger causality
Authors: Archie J. Calise, Queensborough College of the City University of New York; Joseph E. Earley, Loyola Marymount University, Los Angeles

(PDF) Can Matrix Capture Missing Data Values?
Keywords: PROC IML, PROC SQL, Macro and Matrix
Author: Keh-Dong Shiang, City of Hope National Medical Center, Duarte, CA

(PDF) Comparing Macros to Arrays to Simple Code for Input Statements: a Visual Display for the Novice Programmer
Keywords: beginner macro macros array arrays
Author: Lara Jungvig-Hilton, RAND Corporation, Santa Monica, CA

(PDF) Deployment of a Data Transfer Application Using PROC SQL and Nested Macros
Keywords: Mapping Table, PROC SQL and Nested Macros
Author: Keh-Dong Shiang, City of Hope National Medical Center, Duarte, CA

(PDF) Identify Customers from Multiple Lists Using Fuzzy-Matching Technique
Authors: Raymond Chan, InfoAtlas, Inc., Oakland, California; Howell Kiung, InfoAtlas, Inc., Oakland, California

(PDF) Making Your Data File More Versatile for Web Applications
Author: Maureen Ross, DMDC-West

(PDF) SAS Application Detects, Quantifies, Prioritizes and Reports Errors in Public Mental Health Data: Impact on Quality of Data Reported
Keywords: Detect Quantify Prioritize Report Errors
Authors: Bryan Fisher, California Department of Mental Health, Sacramento, CA; Christine Beck, California Department of Mental Health, Sacramento, CA

(PDF) Summary Tables in SAS Enterprise Guide PROC TABULATE Made Easy
Keywords: “Summary Tables”, “Enterprise Guide”, “PROC TABULATE”, reports, styles
Authors: Susan J. Slaughter, Avocet Solutions, Davis, CA; Lora D. Delwiche, University of California, Davis, CA

(PDF) The Use of Formats, Concatenate and Sum for Reporting on Check All That Apply Variables
Keywords: beginner format formats concatenate sum
Author: Lara Jungvig Hilton, RAND Corporation, Santa Monica, CA

(PDF) Using Proc Mixed to Model Daytime Log-Cortisol Slopes
Authors: Eric Neri, Stanford University School of Medicine, Palo Alto, CA; Helena Chmura Kraemer, Stanford University School of Medicine, Palo Alto, CA; Arthur M. Noda, Stanford University School of Medicine, Palo Alto, CA; Yung Wang, Stanford University School of Medicine, Palo Alto, CA

SAS Essentials

(PDF) Arrays by example
Keywords: array, subscript, array-elements, _TEMPORARY_, %LET
Author: Diana D. Suhr, University of Northern Colorado, Greeley, CO

(PDF) Get it together: Combining data with SAS MERGE, UPDATE, and SET
Keywords: MERGE, SET, Combining Data, UPDATE, Table Look-up
Author: Mel Widawski, MHW Consulting, Culver City, CA

(PDF) Habits that Help: Developing Good Programming Style
Author: Casey Cantrell, Clarion Consulting, Los Angeles, CA

(PDF) How SAS Does Quick Results
Author: Neil H. Howard, Independent Consultant

(PDF) SAS Essentials
Author: Neil H. Howard, Basking Ridge, NJ

(PDF) How to Find Answers: Using SAS Resources
Keywords: Resouces, documentation, web sites, help, OnlineDoc, training, SAS-L, books, Users Groups, sample code
Authors: Ginger Carey, University of Hawai i, Honolulu, HI; Helen D. Carey, Carey Consulting, Kane ohe, HI

(PDF) Job Security: Using the SAS Macro Language to Full Advantage
Author: Arthur L. Carpenter, California Occidental Consultants

SAS Solutions

(PDF) Getting the Best Performance from V9 Threaded PROC SORT
Author: Scott Mebust, SAS

(PDF) Migrating to SAS 9: Impact and Opportunity
Author: Maria Keyser, SAS

(PDF) A Regulatory Compliant Process for Developing SAS -Based Reports
Author: Chuck Reap, SAS Institute Inc., Cary NC

(PDF) SAS 9 BI Tools: Making Your SAS Analytics and Reports Available to Everyone in the Decision-making Process
Author: Steve Harris, SAS

(PDF) A Meeting of the Minds
Author: Kathryn A. Vald s, SRI International, Menlo Park, CA

(PDF) Anyone Can Learn PROC TABULATE
Author: Lauren E. Haworth, Genentech, Inc., South San Francisco, CA

(PDF) Building SAS Business Intelligence Applications in the Analytic Work Group: Synergistic Benefits
Keywords: Business Intelligence application analysis macro
Authors: Christine Beck, Department of Mental Health, State of California, Sacramento, CA; Bryan Fisher, Department of Mental Health, State of California, Sacramento, CA; Waling-Waling Rosello, Department of Mental Health, State of California, Sacramento, CA; Tom Wilson, Department of Mental Health, State of California, Sacramento, CA

(PDF) Data Collection, Database Management and Reporting in Real-Time based on SAS and Other Applications
Keywords: SAS/IntrNet, JavaScript, real-time, application server, web server, CPQCC, quality improvement
Authors: Beate Danielsen, Health Information Solutions, Rocklin, CA; Barbara Murphy, Stanford University, Palo Alto, CA; Jeffrey B. Gould, Stanford University, Stanford, CA

(PDF) Data Integrity through DEFINE.PDF and DEFINE.XML
Author: Sy J. Truong, Meta-Xceed, Inc, Fremont, CA

(PDF) Documenting Your Data Using the CONTENTS Procedure
Keywords: CONTENTS LABEL WUSS 2005
Author: Curtis A. Smith, DCAA, La Mirada, CA

(PDF) How to Get Promoted: Planning for Career Growth
Keywords: balance, money, preparation, recognition, reward
Author: Sandra Minjoe, Genentech Inc, South San Francisco, CA

(PDF) Make em %LOCAL: Avoiding Macro Variable Collisions
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) Modular Programming using AF/SCL
Author: Kevin Graham, Montura, San Francisco, California

(PDF) ODS Statistical Graphics for Clinical Research
Author: Wei Cheng, Isis Pharmaceuticals, Inc., Carlsbad, CA

(PDF) SAS Certification: Is it for You?
Author: Sarbjit Rai, Genentech Inc., South San Francisco, CA

(PDF) The Perks of PRX
Author: David L. Cassell, Design Pathways, Corvallis, OR

(PDF) To Merge or Not to Merge
Authors: Helen Davis, Defense Manpower Data Center, Seaside, CA; Kathy Gates, Defense Manpower Data Center, Seaside, CA

(PDF) Transforming Data for CDISC and ISS
Author: Sy J. Truong, Meta-Xceed, Inc, Fremont, CA

(PDF) Understand, Document, and Automate Your Programs and Data Tables
Keywords: metadata, documentation, process model, Service Oriented Architecture (SOA), Business Process Management (BPM), Real Time Enteprise (RTE), Business Activity Monitoring (BAM), ontology, object
Author: Anthony M. Dymond, Dymond and Associates, LLC, Concord, CA

(PDF) Validating Your SAS Systems
Author: Sy J. Truong, Meta-Xceed, Inc, Fremont, CA

(PDF) WHERE vs. IF Statements: Knowing the difference in how and when to apply
Author: Sunil Kumar Gupta, Gupta Programming

Tutorials

(PDF) Customizing ODS Statistical Graphs
Keywords: ODS Graphics Style Graph Template Scatterplot
Authors: Cynthia L. Zender, SAS Institute Inc., Cary, NC; Catherine Truxillo, SAS Institute Inc., Cary, NC

(PDF) 200 Reports, 1 Program: An Automated Approach to Creating Graphical Reports with SAS Software
Keywords: SAS GRAPH REPORT MACROS AUTOMATED
Author: Michael J. Yee, The Permanente Medical Group, Inc., Oakland, CA

(PDF) An Introduction to SAS Character Functions (Including some new V9 functions)
Author: Ron Cody, Ed.D.

(PDF) Enterprise Guide for Business Analysts
Author: Sunil Kumar Gupta, Gupta Programming, Simi Valley, CA

(PDF) Get Going with PROC SQL
Author: Richard Severino, Convergence CT, Honolulu, HI

(PDF) Improving Your Graphics Using SAS/GRAPH Annotate Facility
Authors: David J. Pasta, Ovation Research Group, San Francisco, CA; David R. Mink, Ovation Research Group, San Francisco, CA

(PDF) Introduction to Arrays
Keywords: array, tutorial
Author: Eric P. Elkin, University of California, San Francisco, CA

(PDF) Meta Data That You (Probably) Didn t Know That You Had: A Beginners Guide to Using SAS Dictionaries and Automatic Macro Variables
Keywords: dictionaries, automatic macro variables
Author: Richard F. Pless, Ovation Research Group, Highland Park, IL

(PDF) Tips & Techniques with PROC MEANS
Author: Andrew H. Karp, Sierra Information Services, Inc., Sonoma, California USA

(PDF) Simple Tests of Hypotheses for the Non-statistician: What They Are and Why They Can Go Bad
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) Tips and Techniques for the Windowing Environment
Keywords: Customiziing Sas, SAS Display Manager, SAS in Windows
Author: Mel Widawski, MHW Consulting, Culver City, CA

(PDF) Using the COMPUTE Block in PROC REPORT
Author: Jack F. Hamilton, Kaiser Foundation Health Plan, Oakland, California