Another option is to use the EXCEPT set operator in Proc SQL. See Base SAS(R) 9.2 Procedures Guide Either the columns must be in the same order in both tables or you should user the CORRESPONDING keyword You can get the unmatched records in table first using something like this (untested) Proc SQL ;      Create table firstonly as           Select * from first                Except corr           Select * from second      ; Quit ; Then get the records in the second table not matched in the first by interchanging 'first' and 'second' in the code. Richard Message was edited by: Richard Carson ... View more