I'd suggest opening a track with SAS Tech Support on this. Assuming you are using your own user account for sending email, can you change an email's sensitivity manually within your email client? ... View more

Take a look at the documentation or do a search on the communities  Numeric Precision  ... View more

I just checked by %put %sysfunc(getoption(errorabend));, and the value is 'NOERRORABEND'. Therefore, this should not be the root cause. I plan to compare all of options tomorrow to see if there is any difference between my EG and Unix environment.   ... View more

Thanks a lot @Reeza , I tested and the cast function works well. It provides me the correct ratio. There is only minor question not resolved that I cannot apply "count" on single field for more than one times. I will try to ask this in database forum.    My problem is resolved. Thanks a lot for your help and have a great weekend! Wayne ... View more