Hi All,       I have one table from Oracle table, and there is one variable has float type,  the value is with two digits in original oracle table(for example 14.78).     If I use SQL pass through, I saw the value in SAS table is with two digits (for example 14.78), but the format and informat are blank in SAS.     Then if I use SAS proc compare, this value is different from my Teradata data which is 14.78, because right now the value in proc compare result is 15 for this oracle variable instead of 14.78.     Is there anyone know the reason? Thank you!   Jade ... View more

Hi All,       I have a question about automatically outputting the "Proc Compare" result to clients. What I want is to get a message when the tables being compared are different.     Anyone has any suggestion to do this? Thank you!       Right now I came up with:    1) get error message if the tables are different. I can get the error message in the log file if using syntax like below: PROC COMPARE BASE=count_test1 COMPARE=count_test2 ERROR NOPRINT; RUN; ERROR: Values of the following 1 variables compare unequal: test ERROR: The data sets WORK.COUNT_TEST1 and WORK.COUNT_TEST2 contain unequal values.      2) output the error message or log file to clients. I don't know how to proceed on this step.   Thank you! Jade ... View more