Using the Except Operator in Proc SQL to Produce a Comparison Report

From sasCommunity

[edit] Proc SQL Except Operator

Teaching a New Dog Old Tricks: Using the EXCEPT Operator in PROC SQL and Generation Data Sets to Produce a Comparison Report

Stanley Fogleman

http://www.lexjansen.com/pharmasug/2007/cc/cc01.pdf

Abstract

It is possible to produce a comparison report on rather short notice using the EXCEPT operator in PROC SQL to list only those rows that have changed since the last time the report was run. The generation data set represents the data today versus whenever the report was last run.