WUSS 2006 Conference Proceedings – WESTERN USERS OF SAS SOFTWARE

Irvine, California
September 27-29, 2006

Analytics
Coders’ Corner
Data Integration and ETL
Data Presentation and Business Intelligence
Hands-On Workshops
Industry Solutions
Management, Careers and Professional Development
Posters
SAS Essentials
Tutorials

Analytics

(PDF) Mixed Model Selection via the Information-Theoretic Approch using SAS
Authors: Jesse A. Canchola, California State University, East Bay; Torsten B. Neilands, University of California, San Francisco

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

(PDF) Hierarchical Logistic Regression Modeling with SAS GLIMMIX
Authors: Jian Dai, University of California, Davis, CA; Zhongmin Li, University of California, Davis, CA; David Rocke, University of California, Davis, CA

(PDF) Model Selection Methods in PROC MIXED
Author: George C. J. Fernandez, University of Nevada – Reno, Reno NV 89557

(PDF) Easy Methods to Investigate Large Datasets Using ODS Graphics and New Features in SS 9
Authors: Aimee Foreman, Ovation Research Group, San Francisco, CA; Miriam G. Cisternas, Ovation Research Group, Carlsbad, CA

(PDF) Multi-Dimensional Data Presentation
Author: Karl Glaser, Roche Colorado Corporation, Boulder, Colorado

(PDF) How to Analyze Terabytes of Data with a Word
Author: Mark Gustafson, Analysis Group Inc., Los Angeles, CA

(PDF) Using Propensity Scores to Adjust For Treatment Selection Bias
Authors: Scott P. Leslie, MedImpact Healthcare Systems, Inc., San Diego, CA; Patrick Thiebaud, MedImpact Healthcare Systems, Inc., San Diego, CA

(PDF) The Logic and Logistics of Logistic Regression
Authors: Lawrence Rasouliyan, Ovation Research Group, San Francisco, California; Dave P. Miller, Ovation Research Group, San Francisco, California

(PDF) Environmental Samples Below the Limits of Detection – Comparing Regression Methods to Predict Environmental Concentrations
Authors: Daniel Smith, Environmental Health Investigations Branch, California Department of Health Services, Richmond, CA; Elana Silver, Environmental Health Investigations Branch, California Department of Health Services, Richmond, CA; Martha Harnly, Environmental Health Investigations Branch, California Department of Health Services, Richmond, CA

(PDF) Creating Statistical Graphics in SAS 9.2: What Every Statistical User Should Know
Authors: Robert N. Rodriguez, SAS; Tonya E. Balan, SAS

(PDF) An Approach Finding the Right Tolerance Level for Clinical Data Acceptance
Author: Karen Walker, Walker Consulting LLC, Chandler, Arizona

(PDF) Find the Best Prospects for a New Product by Using a Data Mining Model
Author: Ting Wu, Education Testing Services, Monterey, CA

Coders’ Corner

(PDF) What’s the DIF?
Author: Nikki M. Carroll, Kaiser Permanente, Denver, CO

(PDF) Easy Graphs with PROC FORMAT, PROC GPLOT, and ODS
Author: Apryl DeLancey, Fairbank, Maslin, Maullin & Associates, Santa Monica, CA

(PDF) Font Color or Highlight? You Name It!
Author: Guanjun Feng, PacifiCare -A United Healthcare Co., Cypress, CA

(PDF) Dynamic Code Creation Using Call Symput and the SAS Macro Language
Author: Mark Gustafson, Analysis Group Inc., Los Angeles, CA

(PDF) A Close Look at Numeric Formats
Author: Vijay Kumar, Gilead Sciences, Inc., Foster City, CA

(PDF) Applying SPC Methods to Improve Work Flows in High Volume Business Environment
Author: Arkady M. Kushnir, American Express, Salt Lake City, UT

(PDF) Simple Rules to Know When Working With Indexes
Keywords: Index, Where-clause
Author: Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA

(PDF) Using Arrays to Calculate Medication Utilization
Author: Scott P. Leslie, MedImpact Healthcare Systems, Inc., San Diego, CA

(PDF) Calculating Duration via the Lagged Values of Variables
Author: Pon Su, Health Economics Resource Center (HERC), Department of Veterans Affairs, Menlo Park, CA

(PDF) Essential ODS Techniques for Creating Reports in PDF
Author: Patrick Thornton, SRI International, Menlo Park, CA

(PDF) Using SAS Catalog and Printto to Document SAS Projects
Author: Patrick Thornton, SRI International, Menlo Park, CA

(PDF) Missing Fun with Functions
Author: Kathryn A. Vald s, SRI International, Menlo Park, CA

(PDF) Parameter Gathering Techniques for Data Driven Programming
Author: Renato G. Villacorte, Fairbank, Maslin, Maullin & Associates, Santa Monica, CA

(PDF) Get the Correct Hazard Ratio from SAS PROC PHREG Procedure
Author: Betty Ying Wang, Genentech Inc., South San Francisco, CA

Data Integration and ETL

(PDF) How to Leverage Oracle Bulk-load for Performance
Author: Jun Cai, Qwest Communications International Inc., Denver, CO

(PDF) What’s New in Data Quality?
Author: Pat M. Herbert, DataFlux A SAS Company, Cary, NC

(PDF) Advanced Warehousing with SAS 9
Author: Gary J. Mehler, SAS

(PDF) Optimizing Your SAS Performance with Grid Computing
Keywords: Grid Computing, Benchmark, SAS Performance
Author: Sy J. Truong, Meta?Xceed, Inc, Milpitas, CA

(PDF) Examples of Data Manipulation in SAS: Filling in “Known” Missing Data
Author: Chong Ho Yu, Arizona State University, Tempe AZ 85287

(PDF) Using SAS to Create Teradata Multiload Scripts and Check Load Status
Author: Wei Zhang, Department of Technology Services, State of Utah, Salt Lake City, Utah

Data Presentation and Business Intelligence

(PDF) n the Compute Block: Issues Associated with Using and Naming Variables
Keywords: PROC REPORT, Compute Block, Computed variables, Composite names, Report items
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) SAS’s Various Varying Variables, or 1000+ Ways to Manipulate SAS Variables
Author: Paul A. Choate, California State Developmental Services, Sacramento, CA

(PDF) Release 2.1 of SAS Add-In for Microsoft Office – Bringing Microsoft PowerPoint into the Mix
Authors: Jennifer Bradshaw Clegg, SAS; Eric Hill, SAS

(PDF) Enterprise Guide for Business Analysts
Author: Sunil Kumar Gupta, Quintiles, Thousand Oaks, CA

(PDF) Information for All: Why and How to Make Accessible SAS Output
Authors: Jennifer S. Harper, MSPH, California Department of Health Services, Epidemiology and Prevention for Injury Control (EPIC) Branch, Sacramento, CA; Lisa Pappas, SAS

(PDF) Creating and Modiying PDF Bookmarks
Author: Tikiri B. Karunasundera, Allergan Inc., Irvine CA

(PDF) A Dashboard Application Developed Using SAS GRAPH Proc Annotate
Author: Timothy A. Kenney, Kenney IS Consulting, Inc., Ojai, CA

(PDF) PDF Can be Pretty Darn Fancy: Tips and Tricks for the ODS PDF Destination
Author: Peter J. Lund, Looking Glass Analytics, Olympia, WA

(PDF) A Researcher’s Guide to Making Descriptive and Analytic Tables that are Ready to Publish
Author: Kathryn Martin-Fingar, Department of Public Health, Los Angeles, California

(PDF) SAS/MACRO NOTES: LInes and Columns in the Log
Keywords: (Line):(Column), Log, NOTE:, Line Numbers, Macro debugging
Author: Paul D. Sherman, San Jose, CA

(PDF) Make Your IT Resource Work Hard When and Where You Need In Your BI Environment
Authors: Barbara Sutton, Hewlett-Packard Company, Cupertino, Califormia; Susan E. Davis, Hewlett-Packard Company, Cupertino, Califormia

(PDF) SAS Macros for Creating Custom Formatted Excel Workbooks
Author: James J. Van Campen, SRI International, Menlo Park, CA

(PDF) Between Automation and Exploration: SAS Graphing Techniques for Visualization of Survey Data
Authors: Chong Ho Yu, Arizona State University, Tempe, AZ; Samuel DiGangi, Arizona State University, Tempe, AZ; Angel Jannasch-Pennell, Arizona State University, Tempe, AZ

Hands-On Workshops

(PDF) Data Driven Annotations: An Introduction to SAS/GRAPH’s Annotate Facility
Keywords: Annotate functions, Annotate Facility, Annotate table, Annotate variables, ANNO= option
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) Creating AND Importing Multi-Sheet Excel Workbooks the Easy Way with SAS
Keywords: Microsoft Excel, ODS, XML, XLSP2SAS, multi-sheet workbook, SAS XML Libname Engine, SAS XMLMap
Author: Vincent DelGobbo, SAS

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

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

(PDF) Getting in to the Picture (Format)
Author: Andrew H. Karp, Sierra Information Services, Sonoma, CA USA

(PDF) A Hands-On Tour Inside the World of SQL
Keywords: PROC SQL, queries, views, joins
Author: Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA

(PDF) A Pragmatic Programmers Introduction to Data Integration Studio: Hands on Workshop
Keywords: ETL Studio, Data Integration Studio, data warehousing, change data capture, transformations, ETL.
Author: Gregory S. Barnes Nelson, ThotWave Technologies

Industry Solutions

(PDF) Have It Both Ways: Macros that Produce Publication- Quality Tables and Stand-alone Code
Authors: Linda M. Collins, PharmaStat LLC, Newark, CA; Lisa Brooks, VaxGen Inc., Brisbane, CA; Michael Rea, VaxGen, Inc., Brisbane, CA; Alan Hopkins, PharmaStat LLC, Newark, CA

(PDF) Real-Time Sales Volumes Projection with SAS – A Challenge in Implementing a Data-Based Solution in the Automobile Industry
Author: Keiko I. Powers, J. D. Power and Associates, Westlake Village, CA

(PDF) New CDISC Training Initiative
Author: Dana Rafiee, Destiny Corporation, Rocky Hill, CT

(PDF) Step by Step PROC CDISC and More
Keywords: PROC CDISC, SDTM, ODM, CDISC Implementation
Author: Sy J. Truong, Meta?Xceed, Inc, Milpitas, CA

(PDF) Text Mining Internet Discussion Groups: an Automotive Case Study
Author: John S. Wallace, Business Researchers, Inc., San Francisco, CA

Management, Careers and Professional Development

(PDF) Mapping Performance Skills: A Leadership Code Book
Keywords: Management, leadership, performance evaluation, resource managment
Authors: MaryAnne DePesquo Hope, Health Services Advisory Group, Phoenix, Arizona; Laura A. Giordano, Health Services Advisory Group, Phoenix, Arizona

(PDF) From the Outhouse to the Penthouse: 5 Secrets to Enhancing Your Net Worth in the SAS Marketplace
Author: Molly Meade Hall, Synchrony Solutions, Redondo Beach, CA

(PDF) How to Keep Your Job and Advance in Your Career: A Panel of Manager Viewpoints
Authors: Dana Rafiee, Destiny Corporation; Jan M. Hanley, Rand Corporation; Peter Yribar, Genentech Inc; Jim Baker, Amgen, Inc; Paul A. LaBrec, i3 Statprobe

(PDF) Managing Remote and Virtual Teams: Real World Examples form SAS Professionals
Authors: Sarbjit Rai, Genentech Inc.; Dana Rafiee, Destiny Corporation; Sy J. Truong, Meta-Xceed Inc,; Peter Yribar, Genentech Inc; Steve Yao, Amgen Inc

(PDF) Changing Careers to Become a SAS Programmer in the Biotech/Pharmaceutical Industry
Keywords: SAS Career, Biotech, Pharmaceutical
Author: Sy J. Truong, Meta?Xceed, Inc, Milpitas, CA

(PDF) Techniques For Introducing SAS To Novice Programmers
Author: Renato G. Villacorte, Fairbank, Maslin, Maullin & Associates, Santa Monica, CA

Posters

(PDF) Skewness, Multicollinearity, Heteroskedasticity – You Name It, Cost Data Have It! Solutions to Violations of Assumptions of Ordinary Least Squares Regression Model Using SAS
Author: Leonor L. Ayyangar, Health Economics Resource Center, VA Palo Alto Health Care System, Menlo Park, CA

(PDF) Detecting Structural Change Using SAS ETS Procedures
Authors: Archie J. Calise, Queensborough College of the City University of New York; Joseph E. Earley, Loyola Marymount University, Los Angeles

(PDF) Just Skip It!
Author: Helen D. Carey, Carey Consulting, Kaneohe, HI

(PDF) Turn Your SAS Programs into Web Applications, the Simple Way
Author: Mickey Cheng, AMGEN, Inc., Thousand Oaks, CA

(PDF) Using SAS Macros to Track Student Retention, Progression, and Graduation Rates
Authors: Gary Levy, University of Utah, Office of Budget & Institutional Analysis (OBIA); David Ma, University of Utah, Office of Budget & Institutional Analysis (OBIA)

(PDF) Testing for Verb Types in Spanish: An Application of SAS to Corpus Linguistics
Authors: Roberto Mayoral-Hern ndez, University of Southern California; Lindsey N. Chen, University of Southern California

(PDF) Getting Your Random Sample In PROC SQL
Author: Richard Severino, Convergence CT, Honolulu, HI

(PDF) “Table 1” in Scientific Manuscripts; Using PROC REPORT and the ODS System
Author: Carter Sevick, DoD Center for Deployment Health Research, San Diego, CA

(PDF) PROC SQL: A Powerful Tool to Improve Your Data Quality
Keywords: PROC SQL, SAS Macro, Data Validation
Author: Keh-Dong Shiang, City of Hope National Medical Center, Duarte, CA

(PDF) Using SAS/CONNECT and the Windows API to Preserve File DateTime Stamps in a Platform Migration Project
Author: Wayne F. Woo, Novartis Vaccines and Diagnostics, Emeryville, CA

SAS Essentials

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

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

(PDF) How to Find Asnwers: 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, K?ne ohe, HI

(PDF) SAS Date and Time Functions 101
Author: Nikki M. Carroll, Kaiser Permanente, Denver, CO

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

(PDF) Introduction to Formats: Simplifying Programming and Improving Data Presentation
Author: Elizabeth A. Roth, RAND Corporation, Santa Monica, CA

(PDF) The Easy Way to Flexible Code: SAS Macro Variables
Author: Mel Widawski, Brettmel Development

Tutorials

(PDF) Advanced PROC Report: Traffic Lighting – Controlling Cell Attributes With Your Data
Keywords: Traffic Lighting, CALL DEFINE, STYLE=, Formats, ODS
Author: Arthur L. Carpenter, California Occidental Consultants

(PDF) Sample Survey Data and the Procs you OUGHT To Be Using
Author: David L. Cassell, Design Pathways, Corvallis, OR

(PDF) SAS/AF Software Rises Again – Enhancements in SS 9.2
Author: Lynn Curley, SAS

(PDF) The Beginners Guide to ODS MARKUP: Don’t Panic
Author: Eric A. Gebhart, SAS

(PDF) Steps to Success with PROC MEANS
Author: Andrew H. Karp, Sierra Information Services, Sonoma, CA USA

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

(PDF) Output Delivery System Tips and Techniques
Author: Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA

(PDF) Exploring SAS Generation Data Sets
Keywords: Generation data sets, generation groups
Author: Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA

(PDF) User Written DATA Step Functions
Author: Jason Secosky, SAS