Western Users of SAS Software
2012 Proceedings

Best Contributed Paper Winner

Analytics & Statistics

Building, refining & scoring financial transaction sequence analytics
Robin Way
Corios LLC

Sample Size Calculation and Power Analysis for Design of Experiments Using Proc Glmpower
Chii Dean (Joey) Lin
San Diego State University

The influence of small sample sizes on empirical Bayes’ predictors in longitudinal data sets
Jennifer Wang
University of Central Arkansas

The Steps to Follow in a Multiple Regression Analysis
Theresa Ngo
Warner Bros. Home Video

Moving Beyond Caveman Communication to Explain the Statistics Behind Your Model: So Easy a PhD Can Do It!
Kari Kelso, PhD
VSP Global

Sensitivity analysis of nonlinear mixed-effects models for longitudinal data that are incomplete
Shelley Blozis
UC Davis

Comparison of Implementation of A Bayesian Approach to Nonlinear Mixed Effects Model in SAS and WinBUGS
Hui Wang
UC Davis

Assessing Interim Data Using Figures
William Coar
Axio Research

Estimating Harrell’s optimism on predictive indices using bootstrap samples. Irena Stijacic Cenzer^1,  Yinghui Miao^2,  Katharine Kirby^1,  John Boscardin^1 ^1University of California, San Francisco, ^2NCIRE

Survival Analysis with PHREG: Using MI and MIANALYZE to Accommodate Missing Data
Art Carpenter¹ and Christopher Ake^2
1CALOXY, ²Kaiser Permanente

Up To Speed With Categorical Data Analysis
Maura Stokes
SAS Institute

Being Continuously Discrete (or Discretely Continuous): Understanding Models with Continuous and Discrete Predictors and Testing Associated Hypotheses
David Pasta
ICON Late Phase & Outcomes Research

Look Out: After SAS/STAT® 9.3 Comes SAS/STAT 12.1!
Maura Stokes
SAS Institute

Weighting Adjustment Methods for Nonresponse in Surveys
Taylor Lewis
U.S. Office of Personnel Management

SAS Procedures for Analyzing Survey Data
Tony An
SAS

Automobile Sales Modeling using Granger-Causality Graph with PROC VARMAX in SAS® 9.3
Akkarapol Sa-ngasoongsong and Satish Bukkapatnam
oklahoma state university

Multivariate Statistical Analysis in SAS: Segmentation and Classification of Behavioral Data
Rachel Poulsen
TiVo

Power Analysis: What is Available and What You Need to Know
Gerry Hobbs
West Virginia University

Now You Can Annotate Your Statistical Graphics Procedure Graphs
Sanjay Matange
SAS

Applications Development

Set Yourself Free -Use ODS Report Writing Technology in SAS EG Instead of Dynamic Data Exchange in PC SAS Robert Springborn OSHPD/Healthcare Outcomes Center

An IOM Application Package for Producing Sophisticated Tables You Can Ever Mockup in Microsoft Word® with Simple SAS® Coding
Jian Dai¹ and Gulan Zhang^2
1Clinovo, ²Abbott Vascular

Bridging the Gap Between SAS® Applications Developed by Business Units and Conventional IT Production
Thomas Billings¹ and Euwell Bankston^2
1Union Bank, ²Union Bank Los Angeles

Macro Quoting to the Rescue: Passing Special Characters
Mary Rosenbloom¹ and Art Carpenter^2
1Edwards Lifesciences, LLC, Irvine, CA, ²California Occidental Consultants, Anchorage, AK

Metadata, Macros, and Documenting SAS® Programs
Patrick Thornton
SRI International

Custom Analysis and Reporting with the JMP® Application Builder
Laura Higgins
SAS Institute

Windows PowerShell and SAS: Use Them to Drive Each Other Crazy
Chris Hemedinger
SAS

Business Intelligence

Do I need a Dashboard or a Report?
Patricia Aanderud¹ and Angela Hall^2
1And Data Inc, ²SAS Institute

SAS® 9.3® BI Case Study: Performance Scalability and Tuning on Servers with Intel® Xeon® Processor E7 Family Yingping Zhang Intel

Get Your " Fast Pass " to Building Business Intelligence with SAS® and Google Analytics
Angela Hall¹ and Patricia Aanderud^2
1SAS Institute, ²And Data, Inc

De Rigueur - Adding Process to Your Business Analytics Environment
Diane Hatcher
SAS Institute

Guide Users along Information Pathways and Surf through the Data
Stephen Overton
Overton Technologies, LLC

Coders’ Corner

A Clean Way to Convert a Character String by Using SAS Functions
Minghui Yang
Boeing

IFC and IFN Functions: Alternatives to Simple DATA Step IF-THEN-ELSE, SELECT-END Code and PROC SQL CASE Statements
Thomas Billings
Union Bank

I Hate Typing Variable Names
Mark Kirkham
Merrick Bank

Creating a ZIP File using Native SAS® Features
Jack Hamilton
Kaiser Division of Research

Out = is on the way out. Use ODS OUTPUT instead.
Stanley Fogleman
Harvard Clinical Research Insitute

The Power of "The FILENAME" Statement
Megha Agarwal
Gilead Sciences

The Lost Sibling of the Semi-colon
William Coar
Axio Research

Best Practices: PUT More Errors and Warnings in My Log, Please! Mary Rosenbloom^1 and Kirk Paul Lafler^2 ^1Edwards Lifesciences, LLC, Irvine, CA, ^2Software Intelligence Corporation, Spring Valley, California

Best Practices: Use Coding Shortcuts to Avoid Typsos and Add Flexibility
Mary Rosenbloom¹ and Kirk Paul Lafler^2
1Edwards Lifesciences, LLC, Irvine, CA, ²Software Intelligence Corporation, Spring Valley, California

JMP® Coders 101 Insights
Charlie Shipp¹ and Kirk Paul Lafler^2
1Consider Consulting, Inc., ²Software Intelligence Corporation

Updating Reporting Data Sets for Recent Changes
Rebecca Ottesen and Julie Kilburn
City of Hope

Nuisances of Report Automation that Involve Change Tracking
Julie Kilburn and Rebecca Ottesen
City of Hope

Array, Hurray, Array; Consolidate or Expand Your Input Data Stream Using Arrays
William E Benjamin Jr
Owl computer Consultancy LLC

A Concise Display of Multiple Response Items
Patrick Thornton
SRI International

Data Management

Biology research data cleaning technical
Kai Yang
city of hope

SAS Rule-Based Codebook Generation for Exploratory Data Analysis
Ross Bettinger
Modern Analytics, Inc.

Hire Winners! Tips for Finding Qualified Candidates and Great SAS Programmers
Kathy Doan
Wells Fargo Bank

Figure Out Your Programming Logic Errors via DATA Step Debugger
Wuchen Zhao
University of Southern California

Obtaining A List of Files In A Directory Using SAS Functions
Jack Hamilton
Kaiser Division of Research

Simplifying Effective Data Transformation Via PROC TRANSPOSE Arthur Li City of Hope

100 things to do in your first 100 days as a New SAS Programmer
Kari Kelso, PhD
VSP Global

Making Fuzzy Merges More Precise using the COMPARE Function in SAS®
Kathryn Martin
Maternal, Child and Adolescent Health Program, CA Department of Public Health

SAS In-Database Procedures on eBay’s Teradata System Reduces Processing Time by a Factor of 4
Arun Akkinapalli,  Mithun Yarlagadda,  Gurudev Karanth,  John Prenner
eBay Inc.

Developing an Analytics Center of Excellence (or the Care and Feeding of Magical Creatures)
Chuck Kincaid
Experis Business Analytics

Countdown of the Top 10 Ways to Merge Data
David Franklin
TheProgrammersCabin.com

Scalability of Table Lookup Techniques
Rick Langston
SAS Institute

Using the New Features in PROC FORMAT
Rick Langston
SAS Institute

Data Presentation and Reporting

An efficient method to create a large and comprehensive codebook
Wen Song,  Kamya Khanna,  Baibai Chen
ICF International

The Evolution of SAS Programs Used to Analyze Judicial Salaries Humberto Cisneros and Carrin Huff Arizona Supreme Court

Building Calendars with Proc Report
Frank Bereznay
Kaiser/IBM

Appending Reports: A Review and Fresh Look
William Coar
Axio Research

Proficiency in JMP® Data Visualization
Charlie Shipp¹ and Kirk Paul Lafler^2
1Consider Consulting, Inc., ²Software Intelligence Corporation

Extend the Power of SAS® to Use Callable VBS and VBA Code Files Stored in External Libraries to Control Excel Formatting Routines
William E Benjamin Jr
Owl Computer Consultancy LLC

Rediscovering the DATA _NULL_ for Creating a Report, And Putting That Text File Into RTF Format In a Single Datastep
David Franklin
TheProgrammersCabin.com

PROC PRINT - the Granddaddy of all Procedures, Enhanced and Still Going Strong!
David Franklin
TheProgrammersCabin.com

SAS on a Shingle, Flippin with Hash
Ethan Miller¹ and Kirk Paul Lafler^2
1SRI International, ²Software Intelligence Corporation

Using ODS PDF, Style Templates, Inline Styles, and PROC REPORT with SAS® Macro Programs
Patrick Thornton
SRI International

Is the Legend in your SAS/Graph® Output Still Telling the Right Story?
Alice Cheng¹ and Justina Flavin^2
1Chiltern International Ltd, ²SimulStat, Inc.

Visualizing Data Techniques, Including Autocharting and Big Data
Justin Choy
SAS Institute

Hands-On Workshops

Getting Up to Speed with PROC REPORT
Kimberly LeBouton
KJL Computing

Basic Statistics with SAS Enterprise Guide: For Learners and Teachers and Everyone Else
AnnMaria De Mars¹ and Chelsea Heaven^2
1The Julia Group, ²The Julie Group

Import Excel: Go Beyond The Wizard With Data-Driven Programming
Renato Villacorte
Fairbank, Maslin, Maullin, Metz, & Associates

The SAS® Hash Object: It’s Time To .find() Your Way Around
Peter Eberhardt
Fernwood Consulting Group Inc.

The Armchair Quarterback: Writing SAS® Code for the Perfect Pivot (Table, That Is)
Peter Eberhardt
Fernwood Consulting Group Inc

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

Quick Results with SAS ODS Graphics Designer
Sanjay Matange
SAS

Basic SAS® PROCedures for Producing Quick Results
Kirk Paul Lafler
Software Intelligence Corporation

Doing More with the Display Manager: From Editor to ViewTable – Options and Tools You Should Know
Arthur Carpenter
CALOXY

Health Outcomes and Healthcare Research Methodologies

Developing Integrated Summary of Safety Database using CDISC Standards
Rajkumar Sharma
Genentech, Inc.

How Do Child Support Order Amounts Affect Payments and Compliance?
Mark Takayesu
Orange County Department of Child Support Services

Dynamically Determine Treatment Populations and Denominators
Ruth Johnson
Quintiles

A SAS Macro for Displaying Institutional Risk-Adjusted Performance: Forest vs. Funnel Plots
Zhongmin Li and Geeta Mahendra
University of California, Davis Medical Center

Power plant emissions, pediatric asthma, and school attendance: A spatial identification analysis
Anton Bekkerman¹ and Jake Morgan^2
1Montana State University, ²

Implementing the New ICH Development Safety Update Report(DSUR)
Rajkumar Sharma
Genentech Inc.,

Analysis of Dietary Patterns over Freshman Year of College
Chelsea Lofland
Self

PROC FREQ Is More Than Just Simply Generating a 2-by-2 Table
Wuchen Zhao
University of Southern California

Modular processing for Prep-to-research anaylsis- interfacing XML SAS and Microsoft Excel David Tabano Kaiser Permanente Institute for Health Research

Exploratory Factor Analysis with the World Values Survey
Diana Suhr
University of Northern Colorado

Using SAS® to calculate incidence and prevalence rates in a dynamic population
Li-Hao Chu and Fagen Xie
Kaiser Permanente Southern California

Composite Indices for Health Outcomes in Epidemiologic Studies: Multi-dimensional Coding Using SAS
Nadia Chung,  Huiyan Ma,  Jenna Voutsinas,  Leslie Bernstein,  Sophia Wang,  James Lacey
City of Hope

Exploratory and Descriptive Data Analysis for Site-Level Outcomes
Amanda Stevenson
University of Texas at Austin

Posters

Connect with Professionals Around the World with LinkedIn®, sasCommunity.org®, and Business Media Charlie Shipp^1 and Kirk Paul Lafler^2 ^1Consider Consulting, Inc., ^2Software Intelligence Corporation

Blurring the line between confirmation and exploration: Model comparison of structural equation modeling in JMP/SAS
Chong Ho Yu
Azusa Pacific University

Building Macros and Tracking Their Use
Richard Koopmann
Capella University

PROC BOXPLOT - Using the CLIPFACTOR option to produce more readable figures
Heidi Nasizadeh and Michelle Wang
Sangart

SAS Essentials Workshop

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

44 Tricks with the Format Procedure
Ben Cochran
The Bedford Group

The SAS® DATA Step: Where Your Input Matters
Peter Eberhardt¹ and Lucheng Shao^2
1Fernwood Consulting Group Inc., ²University of California Irvine

Services R Us
Kathy Council
SAS Institute

Habits that Help: Developing Good Programming Style
Casey Cantrell
Clarion Consulting

SAS Programming Basics: Getting Your Data In and Understanding the Data Step
Helen Carey
Carey Consulting

SAS Programming Basics: Manipulating and Checking Your Data
Helen Carey
Carey Consulting

SAS Programming Basics: Producing Results from Your Data
Helen Carey
Carey Consulting

SAS® Enterprise Guide®

SAS Enterprise Guide Best of Both Worlds – Is it Right for You?
Sunil Gupta
Gupta Programming

Update, Insert, and Carry-Forward Operations in Database Tables using SAS® Enterprise Guide®
Thomas Billings and Sreenivas Mullagiri
Union Bank

SAS Enterprise Guide: Point, Click and Run is all that takes… Aruna Buddana TiVo Inc

Revenue Assurance: Using SAS® to Identify Revenue Leakages
Sunil Goklani,  Ahmed Darwish,  Scott Pena
DIRECTV

I Want to Get Married Too: Assessing the Relationship between Marital Status and Education for African American Women
Shanetta Robinson,  Tara Jiles,  AnnMaria Demars
Pepperdine University, Graduate School of Education & Psychology – Educational Doctoral of Organizational Leadership Program

SAS Enterprise Guide: It's More Than a Gift from Outer Space
Patricia Aanderud
And Data Inc

Tutorials

Demystifying PROC SQL Join Algorithms
Kirk Paul Lafler
Software Intelligence Corporation

SAS "IML" (Introduction at the Master's Level)
Anton Bekkerman
Montana State University

An Introduction to Git Version Control for SAS Programmers
Stephen Philp
Pelican Programming

Bend Excel to Your Will Using SAS TAGSETS and PROC REPORT
Ethan Miller
SRI International

Innovative Techniques: Doing More with Loops and Arrays
Arthur Carpenter
CALOXY

Programming With CLASS: Keeping Your Options Open
Arthur Carpenter
CALOXY

Google® Search Tips and Techniques for SAS® and JMP® Users
Kirk Paul Lafler¹ and Charles Edwin Shipp^2
1Software Intelligence Corproation, ²Consider Consulting, Inc.

Create Your First SAS Stored Process
Patricia Aanderud¹ and Angela Hall^2
1And Data Inc, ²SAS Institute

Feedback on SAS Technology Directions – Big Data, High Performance Data Mining and Cloud Infrastructure
Diane Hatcher
SAS Institute

Not Just for Scheduling: Doing More with SAS® Enterprise Guide® Automation
Chris Hemedinger
SAS Institute

PROC REPORT Unwrapped: Exploring the Secrets behind One of the Most Popular Procedures in Base SAS® Software
Allison Booth
SAS Institute

---