WUSS 2015 Conference Proceedings

San Diego, California
September 9-11, 2015

Advanced Techniques

(PDF) ODS Output Datasets that Work for You
Authors: Stuart D. Long, Westat; Edward E. Heaton, self; Daniel R. Scharf, Westat

(PDF) Beyond a One-Stoplight Town: A Base SAS Solution to Preventing Data Access Collisions through the Detection, Deployment, Monitoring, and Optimization of Shared and Exclusive File Locks
Keywords: SAS, file lock, exclusive file lock, read-write file lock, shared file lock, read-only file lock, file access collision, LOCK statement, control table, file access tracking, file access metrics, software reliability, software robustness, data set availability, exception handling
Author: Troy Martin Hughes

(PDF) SAS Spontaneous Combustion: Securing Software Portability through Self-Extracting Code
Keywords: SAS, software portability, LIBNAME statement, AUTOEXEC.sas file, configuration file, exception handling, DLCREATEDIR option, software initialization, control tables, exception reporting, stoplight highlighting, automation, software development lifecycle, SDLC, software quality
Author: Troy Martin Hughes

(PDF) Why Aren’t Exception Handling Routines Routine? Toward Reliably Robust Code through Increased Quality Standards in Base SAS
Keywords: SAS, exception handling, exception reporting, error handling, software quality, software reliability, software robustness, software availability, forgiveness, permission, SYSERR, SYSCC, ERRORABEND option, NOERRORABEND option, SYSERRORTEXT, SYSWARNINGTEXT
Author: Troy Martin Hughes

(PDF) DATA Step Merging Techniques: From Basic to Innovative
Keywords: Merge, MERGE Statement, Join, Fuzzy merge, SET Statement, Key-indexing, HASH Objects
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) Using Arrays to Quickly Perform Fuzzy Merge Look-ups: Case Studies in Efficiency
Keywords: ARRAY statement, DO loop, temporary arrays, MERGE statement, Hash Objects, Big Data, Brute force Techniques, PROC PHREG
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) A Brief Introduction to Some Object-Oriented Programming (OOP) Concepts for SAS Programmers
Author: Andra Northup, Advanced Analytic Designs, Inc.

(PDF) Using SAS EG 71 Stored Processes
Author: David Mitchell, Solution Design Team

(PDF) Secrets from a SAS Technical Support Guy: Combining the Power of the SAS Output Delivery System with Microsoft Excel Worksheets
Author: Chevell T. Parker, SAS

(PDF) Formats: Not just another pretty face.
Author: Christine Riddiough, SAS

Analytics and Statistics

(PDF) Application of Data Mining in Energy Industry: A Case Study of NOx Prediction
Author: Jongsawas Chongwatpol, NIDA Business School, National Institute of Development Administration

(PDF) Pattern-Mixture Random-Effects Models for Non-Ignorable Missing Data in Longitudinal Studies
Authors: Shelley Blozis, University of California, Davis; Ricardo Villarreal, University of San Francisco

(PDF) Coding your own MCMC algorithm
Author: Chelsea Lofland, UC Santa Cruz

(PDF) Yes, PROC FREQ does that!
Author: AnnMaria De Mars, 7 Generation Games

(PDF) Approximation methods and quadrature points in PROC NLMIXED: A simulation study using structured latent curve models
Authors: Nate Smith, University of California, Davis; Shelley Blozis, University of California, Davis

(PDF) Sample Size Convergence of Denominator Degrees of Freedom Method Options in SAS PROC MIXED
Author: Timothy Banh, University of California, Davis

(PDF) Constructing Confidence Intervals for a Single Binomial Proportion in SAS
Author: William Garner, Gilead Sciences, Inc

(PDF) Generalized Estimating Equations for Depression Dose Regimes
Author: Karen Walker, InVentiv Health Clinical

(PDF) SAPs are for saps: A guide to the ins and outs of SAPs in iterative, observational, or publication-oriented research
Authors: Michelle Turner, ICON Clinical Research; Lawrence Rasouliyan, ICON Clinical Research

(PDF) An Example of Discriminate Analysis in SAS using Seal Vocalization Data
Author: Mengyu Liu, University of Southern California

(PDF) Managing and Monitoring Statistical Models
Keywords: SAS, manage, monitor, statistical models
Author: Nate Derby, Stakana Analytics

(PDF) Latent Analysis Applications for Regression Models
Author: Deanna Schreiber-Gregory, National University

(PDF) Data Analyses in Multivariate Regression
Author: Chii-Dean (Joey) Lin, San Diego State University

(PDF) Introduction to SAS Quantile Regression (PROC QuantSelect and PROC QuantReg )
Author: Peter L. Flom, Contractor

(PDF) Advanced Techniques for Fitting Mixed Models Using SAS/STAT Software
Author: Phil Gibbs, Jill Tao, Kathleen Kiernan, SAS

(PDF) SAS/STAT 14.1: Methods for Massive, Missing, or Multifaceted Data
Author: Maura E. Stokes, SAS

Applications Development

(PDF) Enhancing the Portability and Reusability of SAS Enterprise Guide Projects
Author: Thomas E. Billings, MUFG Union Bank

(PDF) Set Yourself Free – Use ODS Report Writing Technology in SAS Enterprise Guide Instead of Dynamic Data Exchange in PC SAS Part II SAS Code Revealed
Author: Robert Springborn, Office of Statewide Health Planning & Development

(PDF) A Risk Factor Coding Custom Report Created With ODS Report Writing Interface With Recent Literature and Peer Review
Author: Robert Springborn, Office of Statewide Health Planning & Development

(PDF) Strategies for Error Handling and Program Control: Concepts
Author: Thomas E. Billings, MUFG Union Bank

(PDF) Directly Import Data from PDF into SAS Datasets
Authors: William Wu, Herodata LLC.; Steven Li, Medtronic Clinical Operations; Yun Guan, n/A

(PDF) Are You Missing Out? Working with Missing Values to Make the Most of What is not There
Keywords: Missing Value, CALL MISSING, MISSING Function, MISSING System option, MISSTEXT, null value
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) Leads and Lags: Static and Dynamic Queues in the SAS DATA STEP
Author: Mark Keintz, Wharton Research Data Services

(PDF) Understanding the SAS DATA Step and the Program Data Vector
Author: Steven J. First, Systems Seminar Consultants, Inc.

(PDF) Find What You Are Looking For And More in SAS Enterprise Guide
Author: Casey Smith, SAS

Coders’ Corner

(PDF) Time to Re-Group: Keeping SAS Code Dynamic through Derived Formats
Author: Sara Bodach, Genentech, Inc.

(PDF) Getting Started with Proc FCMP
Author: Danny Rithy, California Polytechnic State University

(PDF) The breakthrough of SAS University Edition: What is it and how do I get it?
Author: Chelsea Lofland, UC Santa Cruz

(PDF) The Data Set statement: What are my options?
Author: Mark Kirkham

(PDF) Doing more with SAS Arrays
Author: Rahul Pillay, Northrop Grumman

(PDF) Master Macro Variables – by Examples
Author: Sophia Yue

(PDF) Maintaining Formats when Exporting Data from SAS into Microsoft Excel
Keywords: SAS, Excel, export, formats
Authors: Nate Derby, Stakana Analytics; Colleen E. McGahan, BC Cancer Agency

(PDF) Alternative use of proc corr: product co-distribution analysis
Author: Amarnath Vijayarangan, EMMES Services Pvt Ltd

(PDF) 3N Validation to Validate Proc Compare Output
Author: Amarnath Vijayarangan, EMMES Services Pvt Ltd

(PDF) Quick Tips for SAS Enterprise Guide
Author: Scott P. Leslie, STATisfy Analytics

(PDF) Quotes within Quotes: When Single (‘) and Double (“) Quotes are not Enough
Keywords: Quotes, Macro variable resolution, Apostrophe, Single quotes, Double quotes, parsing, %BQUOTE
Author: Arthur L. Carpenter, CA Occidental Consultants

Data Management/Data Science

(PDF) Data Labs with SAS and Teradata: Value, Purpose and Best Practices
Authors: Tho H. Nguyen, Teradata; Bob Matsey, Teradata; Paul Segal, Teradata

(PDF) Top Ten SAS Performance Tuning Techniques
Keywords: SAS, performance tuning, CPU, I/O, Memory, Storage, efficiency, programming efficiency, Programming Time, author, SAS Press, SAS Press author, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) A Shared File System on SAS Grid Manger in a Cloud Environment
Authors: Yingping Zhang, Software Engineer; Margaret Carver, co-author; Gabriele Paciucci, co-author; Steve Paper, co-author

(PDF) Managing Tables in Microsoft SQL Server using SAS
Authors: Jason Chen, Kaiser Permanente; Jon Javines, Kaiser Permanente; Alan Schepps, Kaiser Permanente; Yuexin Cindy Chen, Kaiser Permanente

(PDF) Architecting Data Management: 7 Principles using SAS(R), DataFlux(R) and SQL
Author: Bob Janka, Modern Analytics

(PDF) The Basics of PROC FCMP
Author: Dachao Liu, Northwestern University

(PDF) Standardizing the Standardization Process
Authors: Frank A. Ferriola, Jr., Financial Risk Group; Avery Long, Financial Risk Group

(PDF) A Practical Introduction to SAS(r) Data Integration Studio
Authors: Erik S. Larsen, Independent Consultant; Frank A. Ferriola, Jr., Financial Risk Group

(PDF) Smartmeter Case Study for SAS/Intel Solutions in IoT
Authors: Suleyman Sair, Intel Corporation; Pat M. Herbert, SAS

(PDF) How to Speed Up Your Validation Process Without Really Trying?
Author: Alice M. Cheng, Chiltern International

(PDF) Leveraging APIs in SAS to Create Interactive Visualizations
Author: Rebecca Ottesen, City of Hope

(PDF) Decision Management with DS2
Author: Tho H. Nguyen, Teradata

Data Presentation and Reporting

(PDF) Dynamic Dashboards Using Base-SAS Software
Keywords: sas, dashboard, dashboards, dynamic dashboards, drill-down, drill-down dashboards, histogram, hbar chart, vbar chart, pie chart, sgplot, sgpanel, sgrender, sas author, sas consultant, sas trainer, sas presenter, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) How is Your Health? Using SAS Macros, ODS Graphics, and GIS Mapping to Monitor Neighborhood and Small-Area Health Outcomes
Author: Roshni Shah, MPH, Santa Clara County Public Health Department

(PDF) Web Reporting by Combining the Best of HTML and SAS
Authors: Jason Chen, Kaiser Permanente; Kim Phan, Kaiser Permanente; Yuexin Cindy Chen, Kaiser Permanente

(PDF) SAS to Excel: A Journey with ODS Excel
Authors: Rohini Rao, Omeros Corporation; Paul D. Hamilton, Omeros Corporation

(PDF) Exploring SAS Visual Analytics capabilities to go from Fat to Fit!
Author: Viraj R. Kumbhakarna, MUFG Union Bank

(PDF) Case Study: SAS Visual Analytics dashboard for pollution analysis
Keywords: WUSS 2015
Authors: Viraj R. Kumbhakarna, MUFG Union Bank; Baskar Anjappan, MUFG Union Bank

(PDF) Fraudulent Patterns: Stacking Annotated Data Sets On A US Map Using PROC GPROJECT and PROC GMAP
Author: Hanna Peterson, HealthDataInsights

(PDF) SAS Graphing Done Right: Two Good Alternatives to PROC GPLOT/GCHART
Author: Isaiah Lankham, University of California Office of the President

(PDF) Something Old, Something New… Flexible Reporting with DATA Step-based Tools
Author: Peter J. Lund, Looking Glass Analytics

(PDF) Take Your Data Analysis and Reporting to the Next Level by Combining SAS Office Analytics, SAS Visual Analytics, and SAS Studio
Authors: David Bailey, SAS; Tim Beese, SAS; Casey Smith, SAS

(PDF) Staying Relevant in a Competitive World: Using the SAS Output Delivery System to Enhance, Customize, and Render Reports
Author: Chevell T. Parker, SAS

Hands-On Workshops

(PDF) A short introduction to longitudinal and repeated measures data analyses
Author: Leanne Goldstein, City of Hope

(PDF) How to Use ARRAYs and DO Loops: Do I DO OVER or Do I DO i?
Author: Jennifer L. Waller, Georgia Regents University

(PDF) Building and Using User Defined Formats
Keywords: format, informat PROC FORMAT, picture format, format library, fmtsearch, DB2
Author: Arthur L. Carpenter, CA Occidental Consultants

(PDF) Using PROC SGPLOT for Quick, High-Quality Graphs
Authors: Lora D. Delwiche, Self-Employed; Susan J. Slaughter, Avocet Solutions

(PDF) Quick Results with SAS Enterprise Guide
Keywords: SAS, SAS EG, Enterprise Guide, Point-and-click programming, MS-Excel, data manipulation, system documentation, process flow diagrams, built-in wizards, sas training, sas trainer, sas consulting, sas consultant, sql training, sql trainer, sql consulting, sql consultant, author, sas press, sas press author, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd, Ryan Paul Lafler
Authors: Ryan Paul Lafler, High School Student; Kirk Paul Lafler, Software Intelligence Corporation

(PDF) WUSS 2014 ENCORE: Creating Multi-Sheet Microsoft Excel Workbooks with SAS : The Basics and Beyond Part 1
Keywords: ODS, Microsoft Excel, XML, ExcelXP tagset, multi-sheet workbook
Author: Vincent DelGobbo, SAS

(PDF) Creating Multi-Sheet Microsoft Excel Workbooks with SAS : The Basics and Beyond Part 2
Keywords: ODS, Microsoft Excel, XML, ExcelXP tagset, multi-sheet workbook
Author: Vincent DelGobbo, SAS

Industry Focused Solutions – Finance

(PDF) Getting Loopy with SAS DICTIONARY Tables: Using Metadata from DICTIONARY Tables to Fulfill Submission Requirements
Author: Nina Worden, Santen

(PDF) Graphical Results in Clinical Studies A focus on graphics used in oncology
Authors: Nora Ruel, City of Hope Cancer Center; Paul Frankel, City of Hope Cancer Center

(PDF) How much is $1 worth?
Author: Ross Lallian, CalPERS

(PDF) Exposure-Response Plots Using SAS
Author: Janette Garner, Gilead Sciences

(PDF) Building and Customizing a CDISC Compliance and Data Quality Application
Keywords: CDISC, ADaM, SDTM, compliance, data quality, tool, application
Author: Wayne (Weizhen) Zhong, Accretion Softworks

(PDF) From Stocks to Flows: Using SAS HASH objects for FIFO, LIFO, and other FO’s
Author: Mark Keintz, Wharton Research Data Services

(PDF) Finding the National Best Bid and Best Offer
Author: Mark Keintz, Wharton Research Data Services

(PDF) Reducing Credit Union Member Attrition with Predictive Analytics
Keywords: Credit union, attrition, logistic regression
Authors: Nate Derby, Stakana Analytics; Mark Keintz, Wharton Research Data Services

Professional Development

(PDF) Google Search Tips and Techniques for SAS Users
Keywords: Google, google search, web search, internet search, Google Search Complete!, SAS, JMP, scsug 2014, search, search tips, search techniques, tips, techniques, consultant, sas consultant, consulting, sas consulting, sql consultant, sql consulting, jmp, jmp consultant, jmp consulting, author, sas author, sas press author, sas author lafler, trainer, sas trainer, sas trainer, training, sas training, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd, Shipp, Charlie Shipp, Charles Shipp, Charles Edwin Shipp, @ShippAhoy
Authors: Charles Edwin Shipp, Consider Consulting Corporation; Kirk Paul Lafler, Software Intelligence Corporation

(PDF) Differentiating Yourself
Keywords: sas, differentiate, skills, mooc, massive open online course, massive open online content, worldwide classroom, sas classroom, sas university edition, sas u, support.sas.com, sascommunity, sascommunity.org, youtube, sas youtube channel, author, sas press, sas press author, consultant, sas consultant, consulting, sas consulting, trainer, sas trainer, training, sas training, lafler, kirk lafler, kirk paul lafler, @sasnerd
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) A Pseudo-Interactive Approach to Teaching SAS Programming
Author: Hunter Glanz

(PDF) SAS Certification As a Tool for Professional Development
Authors: Susan J. Slaughter, Avocet Solutions; Andra Northup, Advanced Analytic Designs, Inc.

(PDF) It’s Not That You Know It, It’s How You Show It
Author: Jim Christine, dataceutics.com

(PDF) No Regrets: Hiring for the Long Term in Statistical Programming
Authors: Chris Moriak, AstraZeneca; Graham Wilson, AstraZeneca; Elizabeth Meeson, AstraZeneca

SAS Essentials Workshop

(PDF) Basic SAS PROCedures for Quick Results
Keywords: SAS, PROCs, Procedures, procedures, quick results, reporting, sas consultant, sas speaker, author, sas press, sas press author, sas programmer, sas trainer, Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Author: Kirk Paul Lafler, Software Intelligence Corporation

(PDF) SAS Macro Programming for Beginners
Authors: Lora D. Delwiche, Self-Employed; Susan J. Slaughter, Avocet Solutions

(PDF) S-M-U (Set, Merge, and Update) Revisited
Author: Andrew T. Kuligowski, HSN

(PDF) Chi-Square and T-Tests Using SAS : Performance and Interpretation
Author: Jennifer L. Waller, Georgia Regents University

(PDF) Easy Come, Easy Go- Interactions between the DATA Step and External Files
Author: Andrew T. Kuligowski, HSN

(PDF) You Say ‘Day-ta’, I Say ‘Dat-a’ – Measuring Coding Differences, Considering Integrity and Transferring Data Quickly
Keywords: Proc Download, Proc Upload, Proc Import, Proc Export, SAS Proc Download, SAS Proc Upload, SAS Proc Import, SAS Proc Export, SAS Data Transfer Services, Data Transfer Services, SAS DTS, SAS Remote Library Services, Remote Library Services, SAS RLS, SAS Network File Compression, SAS/Connect, SAS Improving Resources, SAS Performance Booster, SAS Improving Performance, SAS Resource Consumption, SAS Resource Measurement, SAS Data Step vs SQL, SAS Data Step vs Proc Sql, Jason Beene, Jason R. Beene, Mary Katz, Mary Federico, Mary Federico Katz, SAS Increasing Efficiency, SAS Data Integrity, SAS Data Quality
Authors: Mary Federico Katz, Wells Fargo Bank; Jason R. Beene, Wells Fargo Bank

ePosters

(PDF) Using Bootstrapping to Evaluate LOS Median Differences between Two Knee Arthroplasty Procedures
Author: Yubo Gao, University of Iowa Hospitals and Clinics

(PDF) Guidelines for Protecting Your Computer, Network and Data from Malware Threats
Keywords: SAS, antivirus, malware, malware threats, internet security, Lafler, Ryan Lafler, Ryan Paul Lafler, Kirk Lafler, Kirk Paul Lafler, @sasNerd
Authors: Ryan Paul Lafler, High School Student and Software Language Enthusiast; Kirk Paul Lafler, Software Intelligence Corporation

(PDF) SAS at Los Angeles County Assessor’s Office
Author: Anthony Liu, Los Angeles County Assessor’s Office

(PDF) Illustrating preliminary procedures for multi-dimensional item response theory
Authors: Chong Ho Yu; Samantha Douglas, Azusa Pacific University; Anna Yu, Claremont graduate university

(PDF) A strategy for understanding your data: Binary Flags and PROC MEANS
Keywords: binary, flags, proc means, sri international
Authors: Tejaswini Tiruke, SRI International; Glen Masuda, SRI International

(PDF) The Knight’s Tour in Chess — Implementing a Heuristic Solution
Keywords: SAS, Chess, Knight’s Tour
Author: John R. Gerlach, Dataceutics, Inc.