WUSS 2011 Proceedings


  WUSS2011Best Contributed Paper Winner


Analytics & Statistics                                                                                                                 


Boost your confidence in a 2x2 standard table

Iuliana Barbalau, ClinOps


Estimating Disease Prevalence from Clinical Data Using Capture-Recapture

Carol Conell, Kaiser Permanente


An Introduction to the Analysis of Rare Events

Nate Derby, Stakana Analytics


Assessing resource adequacy uncertainty in California electricity summer demand using the MCMC procedure in SAS® Enterprise MinerTM

Miguel Garcia-Cerrutti, CA Energy Commission


What's happening if there is "B" in the general linear modeling output?

Jason Shilong Kuang, Kelley Blue Book, Inc.


Beyond Breslow-Day: Homogeneity Across R x C Tables

Ginny Lai, ICON Clinical Research


Fitting latency models in epidemiological studies

Bryan Langholz, University of Southern California


Consistency of Treatment Effect cross Regions

Yunfeng Li, Cerexa, Inc.


Evaluation of the Psychometric Properties of the Inventory of the Dimensions of Emerging Adulthood

Nadra Lisha, University of Southern California


“Before and After” Models in Observational Research Using Random Slopes and Intercepts

David Pasta, ICON Clinical Research


On Deck: SAS/STAT® 9.3

Maura Stokes, SAS Institute


Why Dummy Variable Makes You SMART, and How to Do it SEXY

Brian (Guanghui) Sun, Rick Hansen Institute


Principal Component Regression as a Countermeasure against Collinearity

Chong Ho Yu, Arizona State University


Applications Development


Turbocharging Your Microsoft Office Environment with version 4.3 of the SAS® Add-In for Microsoft Office

Kevin Bickford, SAS Institute


Automating file pulls for recurring jobs ad-hoc reports or other SAS processes

Ezekiel Budda, Department of Defense


Protecting Macros and Macro Variables: It Is All About Control

Art Carpenter, CA Occidental Consultants


Reading and Writing RTF Documents as Data: Automatic Completion of CONSORT Flow Diagrams

Art Carpenter, CA Occidental Consultants


%GetTweet: A New SAS® Macro to Fetch and Summarize Tweets

Satish Garla, Oklahoma State University


How to easily convert clinical data to CDISC SDTM

Ale Gicqueau, Clinovo


Managing Your Intellectual Property: Optimizing Your Investment of Resources by Building a Searchable SAS® Program Repository

Joe Perry, Perry & Associates Consulting


Benefits of JAVA Within SAS: Exploring the Differences of the new JavaObj and SAS/IML Studio

Diana Shealy, California Polytechnic State University at San Luis Obispo


Working the System: Our Best SAS® Options

Patrick Thornton, SRI International


SAS® Macros in an Era of Apps

Sy Truong, Meta-Xceed, Inc


Business Intelligence


Comparison of K-means, Normal Mixtures and Probabilistic-D Clustering for B2B Segmentation using Customers’ Perceptions

Satish Garla, Oklahoma State University


Create Compelling Visualizations with Geographic Data and JMP®9

Laura Higgins, JMP


Using affinity Models for Buyer Behaviors

Matthias Kehder, Modern Analytics


Modeling Interactive Advertising on TiVo: Overcoming the Challenges of Collinearity, Efficiency and Practicality

Rachel Poulsen, TiVo


If you imbed it…?

Donald Price, Metropolitan State College of Denver


Practically Perfect Presentations

Cynthia Zender, SAS Institute


Coders’ Corner


Output SAS® DATA Step Views: an Experimental Feature

Thomas Billings, Union Bank


Hunting for Columbus’ Eggs in the SAS® Programming World: A Guidance to Creative Thinking for SAS® Programmers

Alice Cheng, Independent


Macro Tabulating Missing Values, Leveraging SAS® PROC CONTENTS

Adam Chow, Dept. of Veterans Affairs


Exporting Variable Labels as Column Headers in Excel using SAS®

Chaitanya Chowdagam, MaxisIT


Sam and Max’s Adventure in SAS® Macro Land. (Quick and Easy tips for Macro programming)

Sam/Seunghee Chung, Educational Testing Service


Sending Emails in SAS® to Facilitate Clinical Trial

Frank Fan, Clinovo


Has Anybody Opened My File? Find Out Before Trying to Update it

Olena Galligan, Teikoku Pharma, USA


SAS Date refresher: cleaning up legacy code using ANYDTDTEw., ANYDTDTMw. and ANYDTDTMEw. informats

Laura Kelly, Bank of America


Efficient Techniques and Tips in Handling Large Datasets

Jason Shilong Kuang, Kelley Blue Book, Inc.


HTMLBlue That’s Really, Really Where We’re Going To!

Warren Kuhfeld, SAS Institute


Conditional Processing Using the Case Expression in PROC SQL®

Kirk Paul Lafler, Software Intelligence Corporation


You Could Be a SAS® Nerd If . . .

Kirk Paul Lafler, Software Intelligence Corporation


Producing Cumulative Distribution Frequency Figures with Minimal Important Difference Reference Lines to Assess Quality of Life Treatment Effects

Xiao Liu, ICON Late Phase & Outcomes Research


VBA Microsoft Access 2007 Macros to Import Formats and Labels to SAS®

Maria Melguizo Castro, University of Arkansas for Medical Sciences


Tag It, Bag It, Put It Out into Excel

Ethan Miller, SRI International


SAS Data Step Debugger: Your Liberator from Logic Errors

Brandi Rhoads, Franchise Tax Board


Assigning a User-defined Macro to a Function Key

Mary Rosenbloom, Edwards Lifesciences, LLC


Best Practices: Clean House to Avoid Hangovers

Mary Rosenbloom, Edwards Lifesciences, LLC


Macro Quoting to the Rescue: Passing Special Characters

Mary Rosenbloom, Edwards Lifesciences, LLC


Using PROC CONTENTS and a Macro to Convert Internal Data Values to their Associated Format Values

Mary Rosenbloom, Edwards Lifesciences, LLC


Creating SAS® Datasets from Varied Sources

Sofia Shamas, Maxisit Inc


Customized Graphics Made Simpler

Sofia Shamas, Maxisit Inc


Are You Taking it Day by Day or Having an Episode? Identifying and Describing Patterns in Longitudinal Data

Sarah Short, ICON Clinical Research


Using PROC SQL to Calculate FIRSTOBS

David Tabano, Kaiser Permanente


Quick ODS OUTPUT Statements

Patrick Thornton, SRI International


Adding PROC SQL to your SAS® toolbox for merging multiple tables without common variable names

Susan Wancewicz, University of California, San Diego


Data Capture, Validation, Manipulation, & Integration                             


Array, Hurray, Array; Consolidate or Expand Your Input Data Stream Using Arrays

William Benjamin Jr, Owl Computer Consultancy LLC


The Many Uses of SQL Subqueries

Tasha Chapman, State of Oregon – DCBS


SAS® Formats and the Format Procedure

Christine Riddiough, SAS Institute


Helping Students Become Effective Industry Statisticians: Supplementing Science with Data Savvy

Aleksandra Stein, Celerion/University of Nebraska-Lincoln


Probabilistic Record Linkage in SAS®

Glenn Wright, UCSF


Data Presentation 


Tips and Techniques for Automating the SAS® Add-In for Microsoft Office with Visual Basic for Applications

Tim Beese, SAS Institute


The Wonderful Wizard Of ODS - Using The EXCELXP Tagset Coupled With Proc Template, And Proc Report, To Twist Your World From Gray To All The Colors Of The Rainbow

Steven Black, W. L. Gore & Associates


Data Visualization of User Interface Navigation Using Interactive Treeview Diagrams

Aruna Buddana, TiVo Inc


Making the Most Out of Multilabel Formats

Tasha Chapman, State of Oregon – DCBS


Is the Legend in your SAS/Graph® Output Still Telling the Right Story?

Alice Cheng, Independent


Graphing a Progression of Time Series Plots with ODS Graphics

Nate Derby, Stakana Analytics


Using SAS® GTL to Visualize Your Data When There is Too Much of It to Visualize

Nate Derby, Stakana Analytics


Now You Can Annotate Your Statistical Graphics Procedure Graphs

Dan Heath, SAS Institute


Let’s Give ’Em Something to TOC about: Transforming the Table of Contents of Your PDF File

Chevell Parker, SAS Institute


The Perfect Marriage: The SAS® Output Delivery System (ODS) and Microsoft Office

Chevell Parker, SAS Institute


SAS® Data Query and Edit Checks Web 2.0

Sy Truong, Meta-Xceed, Inc.


A Guide for Using SAS® and OpenXML to Create Charts in MS Excel®

James Van Campen, SRI International


SAS® Style Templates: Always in Fashion

Cynthia Zender, SAS Institute





Art Carpenter, CA Occidental Consultants


Statistical Graphics for Clinical Research Using ODS Graphics Designer

Wei Cheng, Isis Pharmaceuticals, Inc.


Creating Stylish Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®

Vince DelGobbo, SAS Institute


Ready To Become Really Productive Using PROC SQL?

Sunil Gupta, Gupta Programming


Quick Results with PROC SQL®

Kirk Paul Lafler, Software Intelligence Corporation


Getting Up to Speed with PROC REPORT

Kimberly LeBouton, KJL Computing


Hands-on-Workshop/SAS Essentials


PROC TABULATE: Getting Started

Art Carpenter, CA Occidental Consultants


Graphing Made Easy with SG Procedures

Susan Slaughter, Avocet Solutions


Health Outcomes & Healthcare Research Methodologies


Use CDISC SDTM as a data middle-tier to streamline your SAS® infrastructure

Kalyani Chilukuri, clinovo


A SAS® Macro Program to Calculate Medication Adherence Rate for Single and Multiple Medication Use-

Hao Chu, Kaiser Permanent Southern California


Linkage of hospitalization records with time series data to define chronic disease events in a prospective epidemiologic study

Nadia Chung, City of Hope


Analyze This? Supporting Clinical Decisions Graphically When Not Enough Data are Available A Study Case: Challenges in NCI CTCAE Version 4 Grading

Sheila Dayog, Genentech, A Member of the Roche Group


Are You in Need of Validation? Psychometric Evaluation of Questionnaires Using SAS®

Eric Elkin, ICON Late Phase & Outcomes Research



Causal Methods for Observational Data

Amanda Stevenson, University of Texas at Austin


Effects of Timing of Surgery in Children with Ureteropelvic Junction Obstruction: A Pediatric Health Information System (PHIS) Database Study using SAS®

Andrea Masias, University of Colorado Anschutz Medical Campus


Using SAS Procedure Proc Mixed to Assess the Effects of School Health Policy Requirements on Change in Student Health Outcomes

Lori Miller, University of Washington


Clinical Data Review on iPad® with DEFINE.XML

Sy Truong, Meta-Xceed, Inc.


Combining PROC SQL Summary Functions with Logical Expressions

Glenn Wright, UCSF


Clinical Data Integration for Observational Studies Using Electronic Health Records: Examples with Defining Pregnancy and Gestational Diabetes

Beinan Zhao, Palo Alto Medical Foundation Research Institute


Estimating Sample Size through Simulations

Wuchen Zhao, University of Souther California




SAS® DM Statements Unveiled

Megha Agarwal, Clinovo


ChiD, A χ 2 -Based Discretization Algorithm

Ross Bettinger, Modern Analytics


Is Your SAS Library a Disk Hog? Here’s How to Put it on a Diet

Ross Bettinger, Modern Analytics


Solve Eight Queens Puzzle with SAS® Macro

Jian Dai, Clinovo


Using Vovici API in SAS® 9.2

Richard Koopmann, Capella University


SAS® since 1976

Zubair Shaik, Oklahoma State University


JMP® Scripting: Advanced Techniques

Erin Vang, Global Pragmatica


SAS Program as a Backup Tool for an Adaptive Randomization System

Yajie Wang, VA Palo Alto HCS




At Your Service: Your Roadmap to Support from SAS®

Kathy Council, SAS Institute


What is a SAS Mentor and why do I need one?

Stanley Fogleman, Harvard Clinical Research Institute


Improving Your SAS® Skills and Expertise - Career Path Considerations

 Kirk Paul Lafler, Software Intelligence Corporation


Top Ten SAS® Sites for Programmers: A Review

Kirk Paul Lafler, Software Intelligence Corporation


This is how we do it: teaching SAS® in the Cal Poly Statistics Department

Rebecca Ottesen (Jimmy Doi), City of Hope / Cal Poly SLO


WUSS Conference Android App

 Sy Truong, Meta-Xceed, Inc.


SAS Essentials


Tips and Techniques for the SAS® Programmer

Helen Carey, Carey Consulting


SAS Essentials I: SAS® Functions for a Better Functioning Community

AnnMaria De Mars, The Julia Group


SAS Essentials II: Better-Looking SAS for a Better Community

AnnMaria De Mars, The Julia Group


SAS Essentials III: Statistics for Hamsters

AnnMaria De Mars, The Julia Group


SAS Macro Programming for Beginners

Susan Slaughter, Avocet Solutions


Introduction to SAS® Programming

Lily Xu, Ohlone College




An Introduction to SAS® Character Functions

Ronald Cody, self-employed


An Introduction to Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®

Vince DelGobbo, SAS Institute


SAS Macros for the Working Statistician

William Krebs, Self-empolyed


Creating Statistical Graphics with ODS in SAS® Software

Warren Kuhfeld, SAS Institute


Power Analysis: What is Available and What You Need to Know

Gerry Hobbs, West Virginia University


Powerful and Sometimes Hard-to-find PROC SQL® Features

Kirk Paul Lafler, Software Intelligence Corporation


HELP, My SAS® Program isn't Working: Where to Turn When You Need Help

Kimberly LeBouton, KJL Computing


Statistical Analyses Using SAS® Enterprise Guide®

 R. Scott Leslie, MedImpact Healthcare Systems, Inc.


Tips and Tricks for SG Procedures and GTL for Clinical Graphs

Sanjay Matange, SAS Institute


Getting Freqy with PROC REPORT

Ethan Miller, SRI International


Becoming a Better Programmer with SAS® Enterprise Guide® 4.3

Andy Ravenna, SAS Institute


Understanding the Anatomy of a SAS® Deployment: What's in My Server Soup?

Connie Robison, SAS Institute


Up To Speed With Categorical Data Analysis

Maura Stokes, SAS Institute