The first one I got has 946201 rows and 16 columns. The second one I got has 946199 rows and 16 columns. I did use your code, and it showed 17 obs. I cannot figure out, because it is only 2 obs difference, but why this code generated 17 obs.
Appreciated if anyone can help!
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.