WUSS 2007 Conference Proceedings

San Francisco, California
October 17-19, 2007

Analytics and Statistics

(PDF) Recreating the SELECTION=SCORE Model Specification with the BEST=n Effect Selection Option for PROC SURVEYLOGISTIC
Authors: Sara R. Adams, ICON Clinical Research, San Francisco, CA; David R. Mink, ICON Clinical Research, San Francisco, CA; Dave P. Miller, ICON Clinical Research, San Francisco, CA

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

(PDF) Wait Wait, Don’t Tell Me You’re Using the Wrong Proc!
Author: David L. Cassell, Design Pathways, Corvallis, OR

(PDF) They Were Our Dreams Tables and Graphics for Survival Analysis using ODS
Author: Wei Cheng, Isis Pharmaceuticals, Inc., Carlsbad, CA

(PDF) An Example of SAS Application in Public Health Research — Predicting Smoking Behavior in Changqiao District, Shanghai, China
Author: Ding Ding, San Diego State University, San Diego, CA

(PDF) An Adaptive Algorithm to Compute Power for the Hochberg Sequential Rejective Procedure: A Correlated Data Example
Authors: Jimmy Thomas Efird, Cancer Research Center of Hawaii, and John A. Burns School of Medicine, University of Hawai at Manoa, Honolulu, HI; Susan Searles Nielsen, Public Health Sciences Division, Fred Hutchinson Cancer Research Center, Cancer Epidemiology Research Cooperative, Seattle, WA

(PDF) Survival Analysis Plots Using SAS ODS Graphics
Authors: Lida Gharibvand, University of Nevada, Reno; George C. J. Fernandez, University of Nevada, Reno

(PDF) The Use of Propensity Scores and Instrumental Variable Methods to Adjust For Treatment Selection Bias
Author: Scott P. Leslie, MedImpact Healthcare Systems, Inc., San Diego, CA

(PDF) Data Mining Using SAS Enterprise Miner
Author: Randall Matignon, Piedmont, CA

(PDF) BFF: Binary Flags Forever (Or, Boole’s Paradise)
Authors: David J. Pasta, ICON Clinical Research, San Francisco, CA; Eric P. Elkin, ICON Clinical Research, San Francisco, CA

(PDF) Using Regression Diagnostics and Clustering Criteria to Uncover ID Errors
Authors: David J. Pasta, ICON Clinical Research, San Francisco, CA; Eric P. Elkin, ICON Clinical Research, San Francisco, CA; Rory Michaelis, ICON Clinical Research, San Francisco, CA

(PDF) An Introduction to SAS Stat Studio: A Programmable Successor to SAS/INSIGHT
Keywords: exploratory data analysis, statistical graphics, computational statistics
Authors: Rick Wicklin, SAS; Peter Rowe, CART Statistics & Modeling Team, Wachovia Corporation

(PDF) Hypothesis Testing: An SQL Analogy
Keywords: missing data, Null hypothesis, outer join, consolidated pivot table
Authors: Leroy Bracken, Boulder Creek, CA; Paul D. Sherman, San Jose, CA

(PDF) Case Study: Development of an HIV casefinding algorithm with SAS Enterprise Miner
Authors: Tamara S. Slipchenko, DM Consulting, San Diego, CA; Candice Bowman, VA San Diego Healthcare System, San Diego, CA; Yuexin Chen, VA San Diego Healthcare System, San Diego, CA; Catherine Sugar, School of Public Health, UCLA, Los Angeles, CA; Allen L. Gifford, VA New England Healthcare System and Boston University, Boston, MA

Applications and Development

(PDF) Enhance Your Programming with SAS DATA Step Views
Author: Thomas E. Billings, Kaiser Permanente, Oakland, California

(PDF) IMPROVING DATA ENTRY by 70% Importing Multiple Excel Worksheets Using DDE (Dynamic Data Exchange)
Authors: Humberto Cisneros, Arizona Supreme Court, Administrative Office of the Courts, Phoenix, Arizona; Mark McDermott, Arizona Supreme Court, Administrative Office of the Courts, Phoenix, Arizona

(PDF) SAS Web Report Studio – Enabling Flexible Reporting for End-Users
Author: Kevin Davidson, Independent SAS Consultant, Houston, TX

(PDF) Advanced techniques for processing large datasets (Parallel Programming)
Author: Victor de Leon, Blue Shield of California, San Francisco, CA

(PDF) Is your UNIX/SAS System Healthy?
Author: Victor de Leon, Blue Shield of California, San Francisco, CA

(PDF) The SORT Procedure: Beyond the Basics
Author: David Fickbohm, Homegain. Com, Emeryville, CA

(PDF) The XMLmap and the DATA Step programmer
Author: Timothy A. Kenney, Kenney IS Consulting, Inc., Ojai, Ca.

(PDF) Tips and Tricks to Reduce Typing SAS Code
Author: Myra A. Oltsik

(PDF) SAS and Plug-Ins, Extensibility, Scalability and Execution Tracing in the SAS Environment; A SAS Developer s Approach in Applying Web Development Concepts in SAS
Author: Joe Perry, Perry & Associates Consulting, Oceanside, CA

(PDF) Secret Sequel: Keeping Your Password Away From the LOG
Keywords: PROC SQL, SQL pass through, password, SYMBOLGEN
Authors: Paul D. Sherman, San Jose, CA; Arthur L. Carpenter, CA Occidental Consultants

(PDF) Importing Excel Files Into SAS Using DDE
Author: Curtis A. Smith, Defense Contract Audit Agency, La Mirada, CA

(PDF) The Output Delivery System (ODS) from Scratch
Author: Kevin D. Smith, SAS

(PDF) SAS DICTIONARY: Step by Step
Keywords: DICTIONARY Views
Author: Patrick Thornton, SRI International, Menlo Park, CA

Coders’ Corner

(PDF) Simulating Student Responses Based on a Nominal Response Model
Author: Angela Austin, CTB/McGraw-Hill

(PDF) Get Your DATA Step Amped on Java
Author: David Bell, Independent Consultant

(PDF) Hurry!!!, Hurry!!! Step Right UP. Use The Magical Compound Where Clause to Eliminate Data Steps, Reduce Processing Steps, Speed Job Turnaround, and Mystify Your Friends
Author: William E. Benjamin, Jr., Self-employed

(PDF) A SAS Algorithm for Separating Multiple Variable Fields
Authors: Pollie Bith-Melander, Asia-Pacific Institute of Medicine and Infectious Diseases; Kavitha Alimineti, Asia-Pacific Institute of Medicine and Infectious Diseases; Chieko Kimata, Asia-Pacific Institute of Medicine and Infectious Diseases; Natalie Hiratsuka, APITMID Research Core; Miki Hong, APITMID Research Core; Jimmy Thomas Efird, John A. Burns School of Medicine & Kathleen Baker, University of Hawaii

(PDF) In The Compute Block: Issues Associated with Using and Naming Variables
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) Double Your Pleasure, Double Your Words
Keywords: Perl Regular Expressions
Author: David L. Cassell, Design Pathways

(PDF) Abbreviations are Your Friends, Use a Template Method to Code!
Author: Elizabeth B. Ceranowski, SAS

(PDF) Quick Record Lookup without an Index
Author: Paul A. Choate, CA Developmental Services

(PDF) Macro To Put Variable Labels Into A SAS Dataset From A Crosswalk Table
Author: Adam Chow, Health Economics Resource Center

(PDF) Guidelines for Organizing SAS Project Files
Keywords: Macros, code, organize
Author: Nate Derby, Washington Mutual

(PDF) A SAS Algorithm for Block Randomization
Authors: Jimmy Thomas Efird, John A. Burns School of Medicine; Miki Hong, John A. Burns School of Medicine; Pollie Bith-Melander, Asia-Pacific Institute of Medicine and Infectious Diseases; Chieko Kimata, APITMID Research Core; Caroline Jiang, University of Hawaii; Kathleen Baker, Hawaii Department of Health

(PDF) Govern the Clock : Adding the Run Date and Time of a SAS Program to Your LOG, LST, and RTF Output
Author: Eric P. Elkin, Ovation Research Group

(PDF) Writing a lean and mean PROC MEANS: CLASS vs. BY and OUTPUT vs. ODS OUTPUT
Author: Eric P. Elkin, Ovation Research Group

(PDF) Blogging for SAS Programmers
Author: David Fickbohm, HomeGain

(PDF) SASHELP Provides Zipcodes
Author: David Fickbohm, HomeGain

(PDF) Wake Up and Look at the Log: How to Code a Nag Macro
Author: Ann Olmsted, CV Therapeutics, Inc.

(PDF) How to Avoid Commonly-Seen Correct but Problematic SAS Programming Pitfalls
Author: Keiko I. Powers, J D Power and Associates

(PDF) Using Annotate to Create Flowcharts
Authors: Priya Saradha, PPD, Inc.; Gurubaran Veeravel, PPD, Inc.

(PDF) Analyzing Multiple Records Per Subject with BY-Group Processing and RETAIN. Easier than You Think . . .
Author: Carter Sevick, DoD Center for Deployment Health Research

(PDF) Automating Regression Analysis and PDF Report Output with the Use of Macros: Tricks for Disabling Default Delimiters and Making Use of Counters
Authors: Svetlana Smorodinsky, California Department of Health Services; Bob McLaughlin, California Department of Health Services

(PDF) Auto-Attributes: No More Typing of Variable Labels (and Other Attributes)
Authors: Jonathan M. Squire, C2RA; Johnny Tai, Comsys

(PDF) Listing Unexpected Data using VVALUEX
Author: Patrick Thornton, SRI International

(PDF) A Macro for Saving Output as a Genuine Excel Workbook
Author: James J. Van Campen, SRI International

(PDF) Adding the Feature of Age Adjustment for the Survey-related Procedures of SAS Age Adjusting Prevalence Estimates from Population Based Survey Datasets
Author: Zhiwei Zeng, County of Los Angeles

Data Presentation and Business Intelligence

(PDF) Clinical Data Repository and SAS
Author: Karthikeyan Chidambaram, Cognizant Technology Solutions

(PDF) Validation Techniques in Clinical Trails Using SAS Enterprise Guide
Author: Venkata R. Darbha, Quintiles

(PDF) Revisiting DDE: An Updated Macro for Exporting SAS into Custom-Formatted Excel Spreadsheets: Part I Usage and Examples
Keywords: DDE, Excel, Export, X4ML
Author: Nate Derby, Washington Mutual

(PDF) Revisiting DDE: An Updated Macro for Exporting SAS into Custom-Formatted Excel Spreadsheets: Part II Programming Details
Keywords: DDE, Excel, Export, X4ML
Author: Nate Derby, Washington Mutual

(PDF) Utility Macros for Enterprise Miner
Author: Daniel P. Edstrom, Noel-Levitz

(PDF) New SAS/GRAPH Procedures for Creating Statistical Graphics
Author: Dan Heath, SAS

(PDF) Use of Selected Third Party XML Tools in Conjunction with the Importing, Exporting, and Manipulation of XML files within the SAS System
Author: Don Hurst, Zymogenetics

(PDF) Getting the MAX Out of PROC MEANS
Author: Scott P. Leslie, MedImpact Healthcare Systems, Inc

(PDF) Exporting SAS/GRAPH Output for Inclusion in Web Pages and Other Software Applications
Author: Jim Simon, SAS

(PDF) A Scattered Approach to Quality Control
Authors: Christina Schmunk, Defense Manpower Data Center/ Northrop Grumman; Komal Sunak, Defense Manpower Data Center/ Northrop Grumman

(PDF) A One-Page Many-Survey Report using Metadata and PROC REPORT
Author: Patrick Thornton, SRI International

(PDF) Producing an Automated Data Dictionary as an RTF File (or a Topic to Bring Up at a Party If You Want to Be Left Alone)
Author: Cyndi Williamson, SRI International

Database Management and Warehousing

(PDF) Detecting Possible Anomalies in Large Data Tables: Methods and Concepts
Author: Thomas E. Billings, Kaiser Permanente

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

(PDF) LDAP and Integrated Technologies: A Simple Primer
Authors: Brian Kowalczyk, Kowal Computer Solutions, Inc.; Richard Kerwin, RK Consulting, Inc.

(PDF) Cleaning Data the Chauvenet Way
Keywords: outlier, maverick, robustness
Authors: Lily Lin, Independent Consultant; Paul D. Sherman, Independent Consultant

(PDF) RDBMS Setup and Authentication in SAS 9
Authors: Paresh M. Patel, Shlomish Consulting, Inc; Richard Kerwin, RK Consulting, Inc.

(PDF) Automated Programming Techniques for the Data Warehouse Manager
Author: Renato G. Villacorte, Fairbank, Maslin, Maullin & Associates

Hands-On Workshops

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

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

(PDF) A SAS Programmer s Guide to SAS Enterprise Guide
Author: Marje Fecht, Prowerk Consulting Ltd.

(PDF) WHERE vs. IF Statements: Examples in Usage and Differences
Author: Sunil Kumar Gupta, Quintiles

(PDF) A Hands-on Tour Inside the World of PROC SQL
Keywords: PROC SQL, SQL, query, subset, phonetic, CASE, view, index, join
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Dynamic Projects in SAS Enterprise Guide: How to Create and Use Parameters
Authors: Susan J. Slaughter, Avocet Solutions; Lora D. Delwiche, University of California, Davis

(PDF) Writing Code in SAS Enterprise Guide
Authors: Susan J. Slaughter, Avocet Solutions; Lora D. Delwiche, University of California, Davis

(PDF) How to Use a System of SAS Macros for Creating Excel Workbooks
Author: James J. Van Campen, SRI International

Management, Careers and Professional Development

(PDF) How to Do More Work with Less
Author: Phuong T. Dang, Genentech, Inc.

(PDF) Consulting – Critical Success Factors
Keywords: Consultant, Consulting
Authors: Kirk Paul Lafler, Software Intelligence Corporation; Charles Edwin Shipp, Shipp Consulting

(PDF) Collaborate with SAS Users Around the World with sasCommunity.org
Keywords: sasCommunity.org, virtual community, blogs, events, forums, search
Authors: Kirk Paul Lafler, Software Intelligence Corporation; Charles Edwin Shipp, Shipp Consulting

(PDF) SAS Styles ODS, Right? No Programming! Discover a Professional SAS Programming Style that will Last a Career
Author: Joe Perry, Perry & Associates

Posters

(PDF) Point-and-Click Style Editing in SAS Enterprise Guide
Authors: Lora D. Delwiche, University of California, Davis; Susan J. Slaughter, Avocet Solutions

(PDF) Using the NPAR1WAY Procedure to Investigate Philanthropy Preference Survey Data
Authors: Joseph E. Earley, Loyola Marymount University; Kimberly Rodriguez, Loyola Marymount University

(PDF) A Simple Way to Create a Running Total
Author: David Fickbohm, HomeGain

(PDF) Time Series Cross Sectional Analysis of Total Nitrogen Concentration in Truckee River, Nevada Using SAS
Author: Anpalaki J. Ragavan, University of Nevada, Reno

(PDF) A Datum to Remember: Using the RETAIN Statement
Authors: Nina Worden, Pacific Data Designs Inc; Chunmei Yang, Pacific Data Designs Inc

(PDF) Skinny to Fat: In Search of the Ideal Dataset
Author: Nina Worden, Pacific Data Designs Inc

SAS Essentials Workshops

(PDF) A Guided Tour Through the SAS Windowing Environment
Author: Casey Cantrell, Clarion Consulting

(PDF) Time to Take the Wheel: A Hands-on Introduction to SAS Programming
Author: Casey Cantrell, Clarion Consulting

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

(PDF) Tap Into the Power of Formats
Author: Nikki M. Carroll, Kaiser Permanente

(PDF) An Introduction to SAS Character Functions (Including Some SAS 9 Functions)
Author: Ron Cody

(PDF) Once Written, Twice Applied: The Basics of Array Processing in SAS
Author: Elizabeth A. Roth, RAND Corp.

Tutorials

(PDF) Statistical Inference Illustrated
Author: Richard Read Allen, Peak Statistical Services

(PDF) Advanced PROC REPORT: Doing More in the Compute Block
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) Data Driven Annotations: An Introduction to SAS/GRAPH s Annotate Facility
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) The Power of the BY Statement
Author: Paul A. Choate, State of California

(PDF) Data Driven Annotations: An Introduction to SAS/GRAPH s Annotate Facility
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) The TRANSPOSE Procedure or How to Turn your Data Around
Author: David Fickbohm, HomeGain

(PDF) SAS ODS Technology for Today s Decision Makers
Author: Sunil Kumar Gupta, Quintiles

(PDF) Exploring the World of PROC SQL Joins
Keywords: PROC SQL, joins, inner join, outer join
Author: Kirk Paul Lafler, Software Intelligence Corporation

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

(PDF) Automating the SORT-SORT-MERGE and Overcoming the Many to Many MERGE: %ProcMerge
Author: Carter Sevick, DoD Center for Deployment Health Research

(PDF) Health Outcomes Research Using Time-to-Event Analytic Approaches
Authors: Tyler C. Smith, DoD Center for Deployment Health Research; Besa Smith, DoD Center for Deployment Health Research

(PDF) Adventures in Arrays
Author: Jane S. Stroupe, SAS