SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS numeric variables loaded into Oracle display in scientific notation

Reply
Highlighted
New Contributor
Posts: 2

SAS numeric variables loaded into Oracle display in scientific notation

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.  

 

Solution:

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.  

Cheers

Eric

Ask a Question
Discussion stats
  • 0 replies
  • 270 views
  • 7 likes
  • 1 in conversation