I wrote a paper at the end of the previous century with a macro to show the differences. SUGI 23: %COMPARWS: Compare with Summary: A Macro Using Proc Compare www2.sas.com/proceedings/sugi23/Posters/p170.pdf sas.community.org has a zip with the programs http://www.sascommunity.org/wiki/Macro_ComparWS_Compare_with_summary The above assumes that both data sets have the same keys. I wrote another macro which identifies the adds, changes, and deletes. http://www.sascommunity.org/wiki/Macro_Extract Ron Fehd
... View more