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

 

Hands-on-Workshops

                                                                                                         

PROC TABULATE: Doing More

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

 

Posters

 

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

 

Resources

 

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

 

Tutorials

 

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