WUSS 2011 Conference Proceedings

San Francisco, California
October 12-14, 2011

Analytics and Statistics

(PDF) Boost your confidence in a 2×2 standard table
Author: Iuliana Barbalau, ClinOps

(PDF) Estimating Disease Prevalence from Clinical Data Using Capture-Recapture
Author: Carol Conell, Kaiser Permanente

(PDF) An Introduction to the Analysis of Rare Events
Keywords: SAS, Poisson regression, PROC COUNTREG
Author: Nate Derby, Stakana Analytics

(PDF) Assessing resource adequacy uncertainty in California electricity summer demand using the MCMC procedure in SAS Enterprise MinerTM
Author: Miguel Garcia-Cerrutti, CA Energy Commission

(PDF) What’s happening if there is “B” in the general linear modeling output?
Author: Jason Shilong Kuang, Kelley Blue Book, Inc.

(PDF) Beyond Breslow-Day: Homogeneity Across R x C Tables
Authors: Ginny P. Lai; David R. Mink; David J. Pasta

(PDF) Fitting latency models in epidemiological studies
Keywords: SAS, other words
Authors: Bryan Langholz; David B. Richardson

(PDF) Consistency of Treatment Effect cross Regions
Authors: Yunfeng Li; Lily Llorens; Ganesh Tamarana

(PDF) Evaluation of the Psychometric Properties of the Inventory of the Dimensions of Emerging Adulthood
Authors: Nadra E. Lisha; Rachel Grana; Ping Sun; Louise A. Rohrbach; Donna Spruijt-Metz; Alan Reifman; Steve Sussman

(PDF) Before and After Models in Observational Research Using Random Slopes and Intercepts
Author: David J. Pasta, ICON Clinical Research

(PDF) On Deck: SAS/STAT 9.3
Authors: Maura E. Stokes, SAS; Fang K. Chen, SAS; Ying C. So, SAS

(PDF) Why Dummy Variable Makes You SMART, and How to Do it SEXY
Author: Brian (Guanghui) Sun, Rick Hansen Institute

(PDF) Principal Component Regression as a Countermeasure against Collinearity
Author: Chong Ho Yu, Arizona State University

Applications Development

(PDF) Turbocharging Your Microsoft Office Environment with version 4.3 of the SAS Add-In for Microsoft Office
Author: Kevin Bickford, SAS

(PDF) Automating file pulls for recurring jobs ad-hoc reports or other SAS processes
Author: Ezekiel Budda, Department of Defense

(PDF) Protecting Macros and Macro Variables: It Is All About Control
Authors: Eric T. Sun; Arthur L. Carpenter

(PDF) Reading and Writing RTF Documents as Data: Automatic Completion of CONSORT Flow Diagrams
Authors: Arthur L. Carpenter; Dennis G. Fisher

(PDF) %GetTweet: A New SAS Macro to Fetch and Summarize Tweets
Authors: Satish Garla; Goutam Chakraborty

(PDF) How to easily convert clinical data to CDISC SDTM
Authors: Ale Gicqueau; Miki Huang; Stephen Chan

(PDF) Managing Your Intellectual Property: Optimizing Your Investment of Resources by Building a Searchable SAS Program Repository
Author: Joe Perry, Perry & Associates Consulting

(PDF) Benefits of JAVA Within SAS: Exploring the Differences of the new JavaObj and SAS/IML Studio
Author: Diana Shealy, California Polytechnic State University at San Luis Obispo

(PDF) Working the System: Our Best SAS Options
Authors: Patrick Thornton; Iuliana Barbalau

(PDF) SAS Macros in an Era of Apps
Keywords: iPhone, Mobile Computing, SAS Delivery
Author: Sy J. Truong, Meta-Xceed, Inc

Business Intelligence

(PDF) Comparison of K-means, Normal Mixtures and Probabilistic-D Clustering for B2B Segmentation using Customers Perceptions
Authors: Satish Garla; Goutam Chakraborty; Gary Gaeth

(PDF) Create Compelling Visualizations with Geographic Data and JMP 9
Keywords: JMP 9 maps geographic shapefile wms
Author: Laura Higgins, JMP

(PDF) Using affinity Models for Buyer Behaviors
Author: Matthias Kehder, Modern Analytics

(PDF) Modeling Interactive Advertising on TiVo: Overcoming the Challenges of Collinearity, Efficiency and Practicality
Author: Rachel Poulsen, TiVo

(PDF) If you imbed it ?
Author: Donald Price, Metropolitan State College of Denver

(PDF) Practically Perfect Presentations
Author: Cynthia L. Zender, SAS

Coders’ Corner

(PDF) Output SAS DATA Step Views: an Experimental Feature
Author: Thomas E. Billings, Union Bank

(PDF) Hunting for Columbus Eggs in the SAS Programming World: A Guidance to Creative Thinking for SAS Programmers
Author: Alice M. Cheng, Independent

(PDF) Macro Tabulating Missing Values, Leveraging SAS PROC CONTENTS
Author: Adam Chow, Dept. of Veterans Affairs

(PDF) Exporting Variable Labels as Column Headers in Excel using SAS
Author: Chaitanya Chowdagam, MaxisIT

(PDF) Sam and Max s Adventure in SAS Macro Land. (Quick and Easy tips for Macro programming)
Authors: Maxwell Wise, Educational Testing Service, Monterey, CA; Sam Chung, Educational Testing Service, Monterey, CA

(PDF) Sending Emails in SAS to Facilitate Clinical Trial
Author: Frank Fan, Clinovo

(PDF) Has Anybody Opened My File? Find Out Before Trying to Update it
Author: Olena Galligan, Teikoku Pharma, USA

(PDF) SAS Date refresher: cleaning up legacy code using ANYDTDTEw., ANYDTDTMw. and ANYDTDTMEw. informats
Author: Laura Kelly, Bank of America

(PDF) Efficient Techniques and Tips in Handling Large Datasets
Author: Jason Shilong Kuang, Kelley Blue Book, Inc.

(PDF) Conditional Processing Using the Case Expression in PROC SQL
Keywords: SAS, SQL, PROC SQL, SQL procedure, Case, Case expression, conditional processing, logic, logic scenarios, simple case, searched case, Lafler, Kirk Lafler, Kirk Paul Lafler
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) You Could Be a SAS Nerd If …
Keywords: SAS, Nerd, SAS nerd, Lafler, Kirk Lafler, Kirk Paul Lafler
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Producing Cumulative Distribution Frequency Figures with Minimal Important Difference Reference Lines to Assess Quality of Life Treatment Effects
Authors: Xiao Liu; Stefanie J. Millar

(PDF) VBA Microsoft Access 2007 Macros to Import Formats and Labels to SAS
Authors: Maria S. Melguizo Castro; Jerry R. Stalnaker; Christopher J. Swearingen

(PDF) Tag It, Bag It, Put It Out into Excel
Author: Ethan Miller, SRI International

(PDF) SAS Data Step Debugger: Your Liberator from Logic Errors
Author: Brandi Rhoads, Franchise Tax Board

(PDF) Macro Quoting to the Rescue: Passing Special Characters
Keywords: %BQUOTE, %QLEFT, %NRSTR, macro variable resolution, special characters
Authors: Mary F. O. Rosenbloom; Arthur L. Carpenter

(PDF) Using PROC CONTENTS and a Macro to Convert Internal Data Values to their Associated Format Values
Keywords: data-driven , proc contents, SAS, macro, do loop, rosenbloom, mary rosenbloom
Author: Mary F. O. Rosenbloom, Edwards Lifesciences, LLC

(PDF) Assigning a User-defined Macro to a Function Key
Keywords: SAS, Macro, user-defined macro, Function Key, macro call, validation, verification, V&V, duplicates, Rosenbloom, Mary Rosenbloom, Lafler, Kirk Paul Lafler
Authors: Mary F. O. Rosenbloom; Kirk Paul Lafler

(PDF) Best Practices: Clean House to Avoid Hangovers
Keywords: SAS, programming style, documentation, code-level documentation, PROC DATASETS, PROC OPTSAVE, PROC OPTLOAD, Rosenbloom, Kirk Paul Lafler, Lafler
Authors: Mary F. O. Rosenbloom; Kirk Paul Lafler

(PDF) Customized Graphics Made Simpler
Authors: Sofia Shamas, Maxisit Inc; Mansi Singh, Maxisit Inc

(PDF) Creating SAS Datasets from Varied Sources
Authors: Sofia Shamas, Maxisit Inc; Mansi Singh, Maxisit Inc

(PDF) Are You Taking it Day by Day or Having an Episode? Identifying and Describing Patterns in Longitudinal Data
Authors: Sarah A. Short; Dave P. Miller

(PDF) Using PROC SQL to Calculate FIRSTOBS
Author: David Tabano, Kaiser Permanente

(PDF) Quick ODS OUTPUT Statements
Author: Patrick Thornton, SRI International

(PDF) Adding PROC SQL to your SAS toolbox for merging multiple tables without common variable names
Author: Susan Wancewicz, University of California, San Diego

HTMLBlue That s Really, Really Where We re Going To!
Author: Warren F. Kuhfeld, SAS

Data Capture, validation, Manipulation and Integration

(PDF) Array, Hurray, Array; Consolidate or Expand Your Input Data Stream Using Arrays
Author: William E. Benjamin, Jr., Owl Computer Consultancy LLC

(PDF) The Many Uses of SQL Subqueries
Author: Tasha Chapman, State of Oregon DCBS

(PDF) SAS Formats and the Format Procedure
Author: Christine Riddiough, SAS

(PDF) Helping Students Become Effective Industry Statisticians: Supplementing Science with Data Savvy
Authors: Aleksandra Stein; Steven R. Kirby

(PDF) Probabilistic Record Linkage in SAS
Author: Glenn Wright, UCSF

Data Presentation

(PDF) Tips and Techniques for Automating the SAS Add-In for Microsoft Office with Visual Basic for Applications
Author: Tim Beese, SAS

(PDF) 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
Author: Steven C. Black, W. L. Gore & Associates

(PDF) Data Visualization of User Interface Navigation Using Interactive Treeview Diagrams
Authors: Aruna Buddana; Raghunathan Chakravarthy

(PDF) Making the Most Out of Multilabel Formats
Author: Tasha Chapman, State of Oregon DCBS

(PDF) Is the Legend in your SAS/Graph Output Still Telling the Right Story?
Author: Alice M. Cheng, Independent

(PDF) Using SAS GTL to Visualize Your Data When There is Too Much of It to Visualize
Authors: Perry Watts; Nate Derby

(PDF) Graphing a Progression of Time Series Plots with ODS Graphics
Keywords: SAS, graph, PROC GPLOT, time series
Authors: Nate Derby; Laura Vo; Perry Watts

(PDF) Now You Can Annotate Your Statistical Graphics Procedure Graphs
Author: Dan Heath, SAS

(PDF) The Perfect Marriage: The SAS Output Delivery System (ODS) and Microsoft Office
Author: Chevell T. Parker, SAS

(PDF) Let s Give Em Something to TOC about: Transforming the Table of Contents of Your PDF File
Author: Chevell T. Parker, SAS

(PDF) SAS Data Query and Edit Checks Web 2.0
Keywords: iPhone, Mobile Computing, SAS Delivery
Authors: Sy J. Truong; Carey G. Smoak

(PDF) A Guide for Using SAS and OpenXML to Create Charts in MS Excel
Author: James J. Van Campen, SRI International

(PDF) SAS Style Templates: Always in Fashion
Author: Cynthia L. Zender, SAS

Hands-On Workshops

(PDF) PROC TABULATE: Doing More
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) Statistical Graphics for Clinical Research Using ODS Graphics Designer
Authors: Wei Cheng, ISIS; Sanjay N. Matange, SAS

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

(PDF) Ready To Become Really Productive Using PROC SQL?
Keywords: Where, IF
Author: Sunil Kumar Gupta, Gupta Programming

(PDF) Quick Results with PROC SQL
Keywords: SAS, SQL, PROC SQL, query, case expression, view, join, inner join, outer join, Lafler, Kirk Lafler, Kirk Paul Lafler
Author: Kirk Paul Lafler, Software Intelligence Corporation

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

Hands-On Workshops / SAS Essentials

(PDF) PROC TABULATE: Getting Started
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) Graphing Made Easy with SG Procedures
Authors: Susan J. Slaughter; Lora D. Delwiche

Health Outcomes and Healthcare Research Methodologies

(PDF) Use CDISC SDTM as a data middle-tier to streamline your SAS infrastructure
Authors: Kalyani Chilukuri; Ale Gicqueau

(PDF) A SAS Macro Program to Calculate Medication Adherence Rate for Single and Multiple Medication Use
Authors: Li-Hao Chu; Aniket Kawatkar; Annie Gu

(PDF) Linkage of hospitalization records with time series data to define chronic disease events in a prospective epidemiologic study
Authors: Nadia Chung; Huiyan Ma; Jenna Voutsinas; Leslie Bernstein; Sophia Wang; James V. Lacey, Jr.

(PDF) Analyze This? Supporting Clinical Decisions Graphically When Not Enough Data is Available A Study Case: Challenges in NCI CTCAE Version 4 Grading
Author: Sheila Dayog, Genentech, A Member of the Roche Group

(PDF) Effects of Timing of Surgery in Children with Ureteropelvic Junction Obstruction: A Pediatric Health Information System (PHIS) Database Study using SAS
Authors: Andrea Masias; Vijaya Vemulakonda

(PDF) SAS Procedure Proc Mixed to Assess the Effects of School Health Policy Requirements on Change in Student Health Outcomes
Authors: Lori L. Miller; Fred Wilds

(PDF) Causal Methods for Observational Data
Author: Amanda Stevenson, University of Texas at Austin

(PDF) Clinical Data Review on iPad with DEFINE.XML
Author: Sy J. Truong, Meta-Xceed, Inc.

(PDF) Combining PROC SQL Summary Functions with Logical Expressions
Author: Glenn Wright, UCSF

(PDF) Clinical Data Integration for Observational Studies Using Electronic Health Records:Examples with Defining Pregnancy and Gestational Diabetes
Authors: Beinan Zhao; Eric C. Wong; Latha Palaniappan

(PDF) Estimating Sample Size through Simulations
Authors: Wuchen Zhao; Arthur Xuejun Li

Posters

(PDF) SAS DM Statements Unveiled
Author: Megha Agarwal, Clinovo

(PDF) Is Your SAS Library a Disk Hog? Here s How to Put it on a Diet
Author: Ross Bettinger, Modern Analytics

(PDF) ChiD, A Chi-2 -Based Discretization Algorithm
Author: Ross Bettinger, Modern Analytics

(PDF) Solve Eight Queens Puzzle with SAS Macro
Author: Jian Dai, Clinovo

(PDF) Using Vovici API in SAS 9.2
Author: Richard Koopmann, Jr., Capella University

(PDF) SAS since 1976
Authors: Zubair Shaik; Satish Garla; Goutam Chakraborty

(PDF) JMP Scripting: Advanced Techniques
Author: Erin Vang, Global Pragmatica

(PDF) SAS Program as a Backup Tool for an Adaptive Randomization System
Author: Yajie Wang, VA Palo Alto HCS

Resources

(PDF) At Your Service: Your Roadmap to Support from SAS
Author: Kathryn A. Council, SAS

(PDF) What is a SAS Mentor and why do I need one?
Author: Stanley E. Fogleman, Harvard Clinical Research Institute

(PDF) Improving Your SAS Skills and Expertise – Career Path Considerations
Keywords: SAS, SAS skills, what’s hot, what’s not so Hot, Enterprise Guide, EG, hash object, ODS, PROC SQL, PROC REPORT, Macro Language, Dictionary Tables, SAS/XML, sasCommunity, SAS-L, certification, JMP, JMP software, JMP Genomics, BI, Business Intelligence, Lafler, Kirk Lafler, Kirk Paul Lafler, Shipp, Charlie Shipp, Charles Shipp, Charles Edwin Shipp
Authors: Kirk Paul Lafler; Charles Edwin Shipp

(PDF) Top Ten SAS Sites for Programmers: A Review
Keywords: SAS, support.sas.com, LexJansen.com, Google, sasCommunity.org, SAS-L, SAS.com, NESUG.org, blogs.sas.com, SESUG.org, SAS Global Forum, SGF, Shipp, Charlie Shipp, Charles Shipp, Charles Edwin Shipp, Lafler, Kirk Lafler, Kirk Paul Lafler
Authors: Charles Edwin Shipp; Kirk Paul Lafler

(PDF) This is how we do it: teaching SAS in the Cal Poly Statistics Department
Authors: Rebecca Ottesen, City of Hope; Jimmy Doi, Cal Poly

(PDF) WUSS Conference Android App
Keywords: iPhone, Mobile Computing, SAS Delivery
Author: Sy J. Truong, Meta-Xceed, Inc.

SAS Essentials

(PDF) Tips and Techniques for the SAS Programmer
Authors: Helen D. Carey; Ginger Carey

(PDF) SAS Essentials I: SAS Functions for a Better Functioning Community
Author: AnnMaria De Mars, The Julia Group

(PDF) SAS Essentials II: Better-Looking SAS for a Better Community
Author: AnnMaria De Mars, The Julia Group

(PDF) SAS Essentials III: Statistics for Hamsters
Author: AnnMaria De Mars, The Julia Group

(PDF) SAS Macro Programming for Beginners
Authors: Susan J. Slaughter; Lora D. Delwiche

(PDF) Introduction to SAS Programming
Author: Lily Xu, Ohlone College

Tutorials

(PDF) An Introduction to SAS Character Functions
Author: Ron Cody, self-employed

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

(PDF) Power Analysis: What is Available and What You Need to Know
Author: Gerald R. Hobbs, West Virginia University

(PDF) SAS Macros for the Working Statistician
Author: William Krebs, Self-empolyed

(PDF) Powerful and Sometimes Hard-to-find PROC SQL Features
Keywords: SAS, PROC SQL, SQL, queries, case logic, views, Dictionary tables, macro variables, joins, query performance, tuning, Lafler, Kirk Lafler, Kirk Paul Lafler
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) HELP, My SAS Program isn’t Working: Where to Turn When You Need Help
Author: Kimberly Stinson LeBouton, KJL Computing

(PDF) Statistical Analyses Using SAS Enterprise Guide
Author: Scott P. Leslie, MedImpact Healthcare Systems, Inc.

(PDF) Tips and Tricks for SG Procedures and GTL for Clinical Graphs
Author: Sanjay N. Matange, SAS

(PDF) Getting Freqy with PROC REPORT
Author: Ethan Miller, SRI International

(PDF) Becoming a Better Programmer with SAS Enterprise Guide 4.3
Author: Andy Ravenna, SAS

(PDF) Understanding the Anatomy of a SAS Deployment: What’s in My Server Soup?
Authors: Mark L. Schneider; Donna Bennett; Connie Robison

(PDF) Up To Speed With Categorical Data Analysis
Authors: Maura E. Stokes; Gary G. Koch

Creating Statistical Graphics with ODS in SAS Software
Author: Warren F. Kuhfeld, SAS