SAS SQL

用这code 作了另一个比较产生error message

WARNING: A table has been extended with null columns to perform the EXCEPT set operation.
ERROR: Column 5 from the first contributor of EXCEPT is not the same type as its counterpart from
      the second.
ERROR: Column 6 from the first contributor of EXCEPT is not the same type as its counterpart from
      the second.
ERROR: Column 9 from the first contributor of EXCEPT is not the same type as its counterpart from
      the second.
ERROR: Column 10 from the first contributor of EXCEPT is not the same type as its counterpart
      from the second.
ERROR: Column 12 from the first contributor of EXCEPT is not the same type as its counterpart
      from the second.
ERROR: Column 13 from the first contributor of EXCEPT is not the same type as its counterpart
      from the second.
1830  quit;
NOTE: The SAS System stopped processing this step because of errors.

应该是两个数据集不同源，变量属性不同，试试compare吧
proc compare base=old comp=new;listall;run;
hope it help!

Thanks. List all, or listall, seem to be wrong. Delete this, I can still see it works. Any better suggestions?