Presentations:Stevecavill Papers and Presentations

From sasCommunity
Jump to: navigation, search

  Papers and presentations by Steve Cavill
Contact Steve at his discussion page.


  1. How can I simplify ETL when I only have Base SAS
    Categories: Macro Language, Presentations, Stevecavill Papers and Presentations, WUSS 2014
    Base SAS has been used for decades to copy data from source database systems to create tables for analysis and reporting. Probably billions of lines of Base SAS code have been written for that purpose. Maintaining that code to account for table definition changes can be error-prone and ..→
  2. What just happened? A visual tool for highlighting differences between two data sets
    Categories: COMPARE Procedure, Macro Language, Presentations, Stevecavill Papers and Presentations, WUSS 2016
    Base SAS includes a great utility for comparing two data sets - PROC COMPARE. The output though can be hard to read as the differences between values are listed separately for each variable. It's hard to see the differences across all variables for the same observation. This talk presents a ..→