*hand26.txt;

DATA ONE;
 INPUT X A $ C $;
CARDS;
1 A X
1 A X
1 A Z
2 B W
2 C G
3 V E
4 E F
6 G K
;
DATA TWO;
 INPUT X B $ D $;
cards;
1 X R
2 Y S
3 Z T
3 V E
5 W A
;

PROC SQL;                   *display unique rows NOT found in other table;
 SELECT *
  FROM ONE
    EXCEPT
 SELECT *
  FROM TWO;

PROC SQL;                   *display rows NOT found in other table;
 SELECT *
  FROM ONE
    EXCEPT ALL
 SELECT *
  FROM TWO;

PROC SQL;                   *display unique rows based on common columns;
 SELECT *
  FROM ONE
    EXCEPT CORR
 SELECT *
  FROM TWO;

PROC SQL;                   *display unique rows;
 SELECT *
  FROM ONE
    INTERSECT
 SELECT *
  FROM TWO;

PROC SQL;                   *display unique rows based on common column;
 SELECT *
  FROM ONE
    INTERSECT CORR
 SELECT *
  FROM TWO;

PROC SQL;                   *unique rows of X, others overlayed;
 SELECT *
  FROM ONE
    UNION
 SELECT *
  FROM TWO;

PROC SQL;                   *display unique rows based on common column;
 SELECT *
  FROM ONE
    UNION CORR
 SELECT *
  FROM TWO;

PROC SQL;                   *unique rows of X, others overlayed;
 SELECT *
  FROM ONE
    OUTER UNION
 SELECT *
  FROM TWO;

PROC SQL;                   *display unique rows based on common column;
 SELECT *
  FROM ONE
    OUTER UNION CORR
 SELECT *
  FROM TWO;