12-14-2017 09:29 AM
I am posting this to warn users about a change in 9.4M1 that might impact production code that loads SAS data into Oracle. We had a group of users who ran regular uploads to a JReview Oracle data base. When we moved to 9.4M3 on Linux from 9.3 on Solaris, all numeric columns in the Oracle database were displayed in scientific notation. This happened for all numeric values, including integers.
Turns out that "In SAS 9.4M1, the new default value for the OR_BINARY_DOUBLE= LIBNAME option is YES".
The change was documented in the "What's New in SAS/ACCESS 9.4 for Relational Databases", but this behavior was extremely hard to find with any type of search. This option does not show up in a standard PROC OPTIONS.
libname oradb oracle user=uuuuuu password=pppppp path=pathname or_binary_double=no;
Now everything works fine. I hope this helps someone find this a bit faster.