WUSS 2013 Conference Proceedings

Las Vegas, Nevada
November 13-15, 2013

Analytics and Statistics

(PDF) How Do I . . .? There Is More Than One Way To Solve That Problem; Why Continuing To Learn Is So Important
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) Automated Forward and Best Subset Selection for Generalized Additive Models using PROC GAM
Author: William Garner, Gilead Sciences, Inc.

(PDF) Our Quartiles Don t Agree!
Keywords: Quartile
Author: David W. Franklin, TheProgrammersCabin.com

(PDF) Using PROC NLMIXED to Fit Correlated Residual Error Structures in Nonlinear Mixed Models
Authors: Shelley Blozis, Univ of Calif, Davis; Jeffrey Harring, Univ of Maryland

(PDF) Dynamic Regression in ARIMA Modeling
Author: Ross Bettinger, Self

(PDF) Cheat sheet: Data Processing Optimization – for Pharma Analysts & Statisticians
Author: Karthikeyan Chidambaram, Genentech

(PDF) Using PROC ARIMA to Model Trends in US Home Prices
Author: Ross Bettinger, Self

(PDF) Subsampling with a Survey Sampling Design? DOMAIN Idea is To Get an Appropriate Variance Estimate
Author: Anita Rocha, Center for Studies in Demography & Ecology, University of Washington, Seattle

(PDF) User-specified likelihood expressions using NLMIXED; the GENERAL statement
Authors: Melissa McTernan; Shelley Blozis, UC Davis

(PDF) A Graphical Approach to Advise an Appropriate Statistical Analysis
Authors: Bret Moulton, University of Southern California; Robin Jeffries, University of Southern California

(PDF) The Impacts of the Canadian Wheat Board Ruling on the North American Malt Barley Markets: Demonstrating a Copula Approach to Data Simulation
Author: Heidi Schweizer, Montana State University

(PDF) Competing Risk Regression: Big Data Issues from Modest Sample Sizes
Authors: Katharine Kirby, University of California, San Francisco; Deborah Barnes, University of California, San Francisco; John Boscardin, University of California, San Francisco

(PDF) Simulation in SAS with Comparisons to R
Authors: Chelsea Lofland, UC Santa Cruz; Rebecca Ottesen, City of Hope

(PDF) Optimism of Best Subset Selection by AIC/BIC for Prognostic Model Building
Authors: Yinghui Miao, NCIRE; Irena Cenzer, UCSF; Katharine Kirby, UCSF; John Boscardin, UCSF

(PDF) Current Directions in SAS/STAT Software Development
Author: Funda Gunes, SAS

(PDF) Exact Testing Procedures in SAS for Categorical Data Analysis
Authors: Guogen Shan, UNLV; Darren Liu, UNLV

Applications Development

(PDF) Add Dropdowns and Redirects to Your SAS Output
Author: Barbara Ross, DataX Ltd.

(PDF) Design of Experiments (DOE) using JMP
Author: Charles Edwin Shipp, Consider Consulting Corp.

(PDF) It s not the Yellow Brick Road but the SAS PC FILES SERVER will take you Down the LIBNAME PATH= to Using the 64-Bit Excel Workbooks.
Author: William E. Benjamin, Jr., Owl Computer Consultancy LLC

(PDF) The Poor Man s Program Metadata Extractor
Author: Joe Perry, Perry & Associates Consulting, Inc.

(PDF) Generation of Subset Listings
Author: Bill Coar, Axio Research

(PDF) Implementation of DEFINE.XML Generators using SAS Hash Objects and User-Defined Functions
Author: Lei Zhang, Celgene Corp.

(PDF) Challenges in Moving to a Multi-tier Server Platform
Keywords: Server, Validation, Challenges
Author: Carey G. Smoak, Roche Molecular Systems, Inc.

(PDF) Uncovering Patterns in Textual Data for SAS Visual Analytics and SAS Text Analytics
Author: Daniel Zaratsian, SAS

Business Intelligence

(PDF) Using SAS Enterprise Business Intelligence to Automate a Manual Process: A Case Study
Author: Erik S. Larsen, Independent Consultant

(PDF) JMP Visual Analytics
Author: Charles Edwin Shipp, Consider Consulting Corp.

(PDF) How to be a Data Scientist Using SAS
Author: Chuck Kincaid, Experis Business Analytics

(PDF) Accomplish Optimal I/O Performance on SAS 9.3 with Intel Cache Acceleration Software and Intel DC S3700 Solid State Drive
Authors: Yingping Zhang, Intel; Curry Jeff, Intel; Roxas Frank, Intel; Benjamin Donie, Intel

(PDF) Cross Platform migration of SAS BI Environment: Tips and Tricks
Author: Amol Deshmukh, California ISO

(PDF) Solve Complex Business Challenges by Leveraging Advanced OLAP Cube Techniques and MDX Programming
Keywords: WUSS
Author: Stephen M. Overton, Author

(PDF) Decision Trees as a Predictive Modeling Method
Author: Gerald R. Hobbs, West Virginia University

Data Management

(PDF) Strategies and Techniques for Getting the Most Out of Your Antivirus Software for SAS Users
Keywords: SAS, antivirus, malware, Lafler, Ryan Lafler, Ryan Paul Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Authors: Ryan Paul Lafler, High School Student, Operating System and Security Software Enthusiast; Kirk Paul Lafler, Software Intelligence Corporation

(PDF) IMPROVING DATA ENTRY by 70% Importing Multiple Excel Worksheets Using DDE (Dynamic Data Exchange)
Authors: Humberto Cisneros, Arizona Supreme Court; Carrin Huff, Arizona Supreme Court

(PDF) Converting Entity-Attribute-Value (EAV) Source Tables into Useful Data with SAS DATA Steps
Authors: Thomas E. Billings, Union Bank; Baskar Anjappan, Union Bank; Junling Ji, Union Bank

(PDF) %CS: A SAS Macro to Calculate and Construct Composite Scores for Large Data
Author: Qinlei Huang, University of Minnesota /St Jude Children’s Research Hospital

(PDF) An Abbreviated PROC COMPARE with Traffic Lighting
Author: William Jay Conover, dataceutics

(PDF) How to Measure Your Success with a Two Dimension Array
Authors: Humberto Cisneros, Arizona Supreme Court; Carrin Huff, Arizona Supreme Court

(PDF) Access to Relational Databases Using SAS
Keywords: SAS, relational, SQL
Author: Frederick E. Pratter, Utopia Ltd Inc.

(PDF) %GrabTweet: A SAS Macro to Read JSON Formatted Tweets
Authors: Isabel Litton, California Polytechnic State University, San Luis Obispo; Rebecca Ottesen, California Polytechnic State University, San Luis Obispo

(PDF) Matching with Hash Objects
Author: Gregory Watson, University of California, Los Angeles

(PDF) The Ins and Outs of Web-Based Data with SAS
Author: Bill McNeill, SAS

(PDF) Sharpening Your Skills in Reshaping data: PROC TRANSPOSE vs. Array Processing
Author: Arthur Xuejun Li, City of Hope National Medical Center

Data Presentation and Reporting

(PDF) A Quick and Dirty Descriptive Data Summary
Authors: Nora Ruel, City of Hope Comprehensive Cancer Center; Rebecca Nelson, City of Hope Comprehensive Cancer Center

(PDF) Getting so Much when Reviewing Data with Touch
Author: Sy J. Truong, Meta-Xceed, Inc.

(PDF) Customize Comparison Tables for Clinical Studies
Authors: Polina Kukhareva, University of Utah; Katherine J. Roggenkamp, University of North Carolina

(PDF) Using SAS for Error Grid Analysis (EGA) of Glycated Hemoglobin A1c
Authors: Jesse A. Canchola, Tethys Bioscience, Inc.; Christopher Canchola, University of California, Santa Cruz

(PDF) Fly Over, Drill Down and Explore!
Author: Suzanne Brown, HealthInsight, NM

(PDF) Using SAS to Create Custom Tables and Presentations in Microsoft Office through Dynamic Data Exchange (DDE)
Author: Kathryn Martin-Fingar, UC San Francisco

(PDF) Creating Graphical Patient Profiles Using SAS
Author: William Garner, Gilead Sciences, Inc.

(PDF) Ma, How Long Do I Cook the Turkey For?
Author: David W. Franklin, TheProgrammersCabin.com

(PDF) Creating Custom Graphic Output Using the SG Annotate Data Set
Author: Doug E. Lassman, Quintiles

(PDF) From Database to your Desktop: How to almost completely automate reports in SAS, with the power of Proc SQL
Authors: Kirtiraj Mohanty, San Diego State University; Trinh Nguyen, San Diego State University

(PDF) A First Look at the ODS Destination for PowerPoint
Author: Tim Hunter, SAS

Hands-On Workshops

(PDF) Hands-on SAS Macro Programming Tips and Techniques
Keywords: SAS, Macro Language, macro, keyword macro, positional macro, SQL, SQL procedure, consultant, SAS consultant, consulting, SAS consulting, sql, sql consultant, sql consulting, author, sas author, sas press author, sql author, trainer, sas trainer, sas training, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Quick Results with PROC SQL
Keywords: SAS, SQL, PROC SQL, sql basics, proc sql basics, intro sql, intro proc sql, quick results sql, quick results proc sql, query, sql query, case expression, case sql, view, join, sql join, join sql, inner join, outer join, consultant, consulting, sas consultant, sql consultant, sql consulting, sas author, sql author, sql lafler, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd, software intelligence, software intelligence corporation, sas san diego, sql san diego, sas training, sas trainer, sql training, sql trainer, nesug trainer, sas trainer nesug, sas trainer san diego, sas training san diego, sql trainer san diego, sql training san diego
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Taking Full Advantage of sasCommunity.org: Your SAS Site
Authors: Arthur L. Carpenter, CALOXY; Donald J. Henderson, Henderson Consulting Services LLC

(PDF) Using PROC FCMP to the Fullest: Getting Started and Doing More
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) Survival 101 – Just Learning to Survive
Authors: Leanne Goldstein, City of Hope; Rebecca Ottesen, City of Hope and Cal Poly, SLO

(PDF) Using SAS ODS Graphics
Author: Chuck Kincaid, Experis Business Analytics

(PDF) Telling stories with your data – graphs, tables and basic, basic statistics with SAS Enterprise Guide
Author: AnnMaria De Mars, The Julia Group

(PDF) Some Techniques for Integrating SAS Output with Microsoft Excel Using Base SAS
Keywords: ODS, Microsoft Excel, XML, ExcelXP tagset, multi-sheet workbook, CSV, PROC EXPORT
Author: Vincent DelGobbo, SAS

Health Outcomes and Healthcare Research Methodologies

(PDF) Introduction to the CDISC Standards
Keywords: Clinical Data Interchange Standards Consortium, pharmaceutical, biotechnology, medical device, protocol, CDASH, Lab, SDTM, SEND, ADaM, define.xml, ODM, glossary, BRIDG, SHARE, Controlled Terminology, Therapeutic Areas, Questionnaires, Healthcare Link
Author: Sandra Minjoe, Accenture Life Sciences

(PDF) The Association of Morbid Obesity with Mortality and Coronary Revascularization among Patients with Acute Myocardial Infarction using ARRAYS, PROC FREQ and PROC LOGISTIC”
Authors: Ashwini S Erande, UCI; Shaista Malik, UCI

(PDF) Automated and Customized Reports as a Single Image File Using Graph Template Language (GTL): A Case Study of Benchmarking Reports in Medical Research
Authors: Monarch Shah, ICON Clinical Research; Ginny Lai, ICON Clinical Research; Eric P. Elkin, ICON Clinical Research

(PDF) Estimating the Impact of Lost to Follow-up on Breast Cancer Patients Disease-free Survival
Author: Debbie Yan Qun Huang, University of California, Los Angeles

(PDF) Building a Controlled Statistical Programming Environment
Author: Wayne F. Woo, Novartis Vaccines and Diagnostics

(PDF) Checklist for the Standardization of Quality Assurance and Optimization of HEDIS Programming
Author: Jason Hermosillo, Kaiser Permanente of Colorado, Denver, CO

(PDF) Repeated Measures ANCOVA with the MIXED and GLM procedures: Examining an intervention to reduce childhood obesity
Authors: Lauren Cook, University of Southern California; Jaimie N. Davis, University of Texas, Austin; Donna Spruijt-Metz, University of Southern California; Nicole Gatto, Loma Linda University

(PDF) Proper Estimation of Relative Risk Using PROC GENMOD in Population Studies
Author: Kechen Zhao, University of Southern California

(PDF) Weighting Multiple Years to Identify Trends: A Logistic Regression of Public Use Data
Author: Marie Boman-Davis, National University

(PDF) Macro to compute Charlson Comorbidity Scores from Medicare Data
Authors: Irena Stijacic Cenzer, UCSF/SFVA; Kathy Fung, SFVA; John Boscardin, UCSF/SFVA; Kenneth E. Covinsky, UCSF/SFVA; Louise Walter, UCSF/SFVA

(PDF) Converting Electronic Medical Records Data into Practical Analysis Dataset
Authors: Irena Stijacic Cenzer, UCSF/SFVA; Mladen Stijacic, UCSF/SFVA; Sei Lee, UCSF/SFVA

(PDF) Estimating Medication Adherence Using a Patient-Mix Adjustment Method
Author: Scott P. Leslie, STATisfy Analytics

(PDF) Graphical Representation of Patient Profile for Efficacy Analyses in Oncology
Authors: William Wu, Pharmacyclics, Inc.; Xiaoxian Dai, Pharmacyclics, Inc.; Linda Gau, Pharmacyclics, Inc.

Posters

(PDF) An Algorithm for ARIMA Dynamic Regression Variable Selection
Author: Ross Bettinger, Self

(PDF) Exploring the PROC SQL _METHOD Option
Authors: Kirk Paul Lafler, Software Intelligence Corporation; Charles Edwin Shipp, Consider Consulting Corporation

(PDF) Sharing SAS User-Related Information via Creative Commons Copyright Licenses
Author: Thomas E. Billings, Union Bank

(PDF) Plot Those Earthquakes!
Keywords: Plot Earthquakes GPLOT
Author: David W. Franklin, TheProgrammersCabin.com

(PDF) Ischemic Heart Disease: The Weekend Effect
Authors: Mahdi Khoshchehreh, Division of Cardiology, Department of Medicine, University of California, Irvine; Nasim Mirnateghi, Division of Cardiology, Department of Medicine, University of California, Irvine; Shaista Malik, Division of Cardiology, Department of Medicine, University of California, Irvine

(PDF) How to Compute Custom Hazard Ratio in SAS (V8.2&V9.2) PHREG Procedure
Authors: Liguo Cheng, Roche PDY; Yu Li, Roche PDY

(PDF) Helpful Tips for Novice Mainframe Programmers
Author: Rahul Pillay, Northrop Grumman

Quick Tips

(PDF) An Overview of Syntax Check Mode and Why it is Important
Author: Thomas E. Billings, Union Bank

(PDF) Constructing Begin-End Date Intervals from Event or As-of Dates in a SAS DATA Step
Author: Thomas E. Billings, Union Bank

(PDF) Array: Simplify Coding
Author: Kai Yang, City of Hope

(PDF) Creating a DOS Batch File to Run SAS Programs
Author: David W. Franklin, TheProgrammersCabin.com

(PDF) Sorting Your List of User-Defined Macro Variables
Author: Christopher Moore, Farmers Insurance Group

(PDF) Flexible Code: How Not to Get Stuck in a “Maze of twisty little passages, all alike”
Author: Paul D. Hamilton, Omeros Corporation

(PDF) JMP , Excel , and SAS Connectivity
Keywords: SAS, JMP, Excel, connectivity, SAS consultant, JMP consultant, SAS trainer, JMP trainer, author, sas press author, Shipp, Charlie Shipp, Charles Edwin Shipp, @ShippAhoy, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Authors: Charles Edwin Shipp, Consider Consulting Corp.; Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Need to Find a Date?
Author: Bill Coar, Axio Research

(PDF) Going the Distance: Google Maps Capabilities in a Friendly SAS Environment
Author: Anton Bekkerman, Montana State University

(PDF) Different ways of parallel processing using SAS
Authors: Arun Akkinapalli, eBay; John Prenner, eBay

(PDF) SAS Web Editor, is it the right choice for you?
Authors: Rebecca Ottesen, City of Hope and Cal Poly, SLO; Jamelle Simmons, Virginia Tech

(PDF) Navigate the SAS Log – GPS Style
Authors: Rebecca Ottesen, City of Hope and Cal Poly, SLO; Ethan Miller, UC Berkeley

(PDF) The Utility of the DATA Step Debugger in Logic Errors
Author: Darryl Nousome, University of Southern California

SAS Enterprise Guide

(PDF) Factor Analysis: Quit being a whiny baby and learn it with SAS Enterprise Guide
Author: AnnMaria De Mars, The Julia Group

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

(PDF) Importing and Displaying Data Using SAS Enterprise Guide : Las Vegas Style
Author: Scott P. Leslie, MedImpact Healthcare Systems, Inc.

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

SAS Essentials Workshop

(PDF) Strategies and Techniques for Debugging SAS Program Errors and Warnings
Keywords: SAS, error, errors, warning, warnings, SAS log, log, debug, debugging, consultant, sas consultant, sas consulting, sql, sql consultant, sql consulting, author, sas author, sas press, sas press author, trainer, sas trainer, sql trainer, training, sas train
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) The Essence of DATA Step Programming
Author: Arthur Xuejun Li, City of Hope National Medical Center

(PDF) How Best to Write a Loop in the DATA Step
Author: Arthur Xuejun Li, City of Hope National Medical Center

(PDF) The Many Ways to Effectively Utilize Array Processing
Author: Arthur Xuejun Li, City of Hope National Medical Center

Tutorials

(PDF) Tools for Imputing Missing Data
Author: Taylor H. Lewis, University of Maryland

(PDF) SAS on a Shingle, More Flippin withHash
Authors: Ethan Miller, Ethanomics LLC; Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Using SAS Macro Functions to Manipulate Data
Author: Benjamin Cochran, The Bedford Group

(PDF) Creating Excel-lent SAS Data Sets
Author: Benjamin Cochran, The Bedford Group

(PDF) Your Resume – Selling Yourself Using SAS
Authors: Rebecca Ottesen, City of Hope and Cal Poly, SLO; Susan J. Slaughter, Avocet Solutions

(PDF) A Tutorial on PROC LOGISTIC
Author: Arthur Xuejun Li, City of Hope National Medical Center

(PDF) Hasing in PROC FCMP to Enhance Your Productivity
Authors: Donald Erdman, SAS; Andrew Henrick, SAS; Stacey M. Christian, SAS

(PDF) Flexibility by Design: A Look at New and Updated System Options in SAS 9.4
Author: Jan Squillace, SAS

(PDF) Make a Good Graph
Author: Sanjay N. Matange, SAS