SAS Compare

A procedure for comparing two tables.

Contents

  1. SAS Compare
    1. Usage
    2. Id Statement
      1. ListBase and ListComp Options

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

SAS/Compare (last edited 2023-03-30 20:17:16 by DominicRicottone)