= SAS Compare =

A procedure for comparing two tables.

<<TableOfContents>>

----



== Usage ==

To compare two tables, try:

{{{
proc compare base=LIBREF.TABLE1 compare=LIBREF.TABLE2 printall;
run;
}}}



== Id Statement ==

To compare data on a case-by-case basic, use the '''`ID`''' statement.

{{{
proc compare base=LIBREF.TABLE1 compare=LIBREF.TABLE2;
    id ID;
run;
}}}

To show the differences by row, use the '''`TRANSPOSE`''' option.



=== ListBase and ListComp Options ===

Use the '''`LISTBASE`''' option to list all variables and observations found only in the base table. Or use the '''`LISTBASEVAR`''' and '''`LISTBASEOBS`''' options to show only one or the other.

Use the '''`LISTCOMP`''' option to do the same for the compare table. Similarly, there are '''`LISTCOMPVAR`''' and '''`LISTCOMPOBS`''' options.



----
CategoryRicottone