You can submit the COMPARE procedure
to compare the contents of two tables, selected columns in different
tables, or columns within the same table.
If you compare the contents of columns from different data sources, PROC COMPARE might
report numeric precision differences because of a
data source's implementation of a
data type.
To compare columns from
different data sources, you can specify an equality criterion to control
how values are compared. Two options for the PROC COMPARE statement
determine the equality criterion for comparing values:
CRITERION=
specifies the criterion
for judging the equality of numeric values.
METHOD=
specifies the method
for judging the equality of numeric values.
For more information
about these options, see the COMPARE procedure in Base SAS Procedures Guide.