A numeric overflow error might occur when you use SAS/ACCESS^® Interface to Greenplum to create or insert data into a Greenplum database table from a SAS data set. The problem occurs if one or more columns in the table has a format that specifies a scale greater than zero.

Here is an example. A SAS data set column has a format of 8.2 and it stores a value of 100,000. Executing either of the two code samples below can produce the error.

  data db.table;
     set sas.table;
run;

ERROR: CLI execute error: [SAS ACCESS to Greenplum][ODBC Greenplum Wire Protocol
       driver][Greenplum]ERROR: numeric field overflow(Detail A field with
       precision 7, scale 2 must round to an absolute value less than 10^5. Rounded 
       overflowing value: 100000.00;File numeric.c;Line 3962;Routine apply_typmod;) :
       [SAS ACCESS to Greenplum][ODBC Greenplum Wire Protocol driver][Greenplum]Failed
       transaction. The current transaction rolled back.

Workaround

   proc sql;
       create table db.table(dbtype=(Income='numeric(8,2)' Salary='numeric(8,2)' Cash='numeric(8,2)') as
       select * from sas.table;
   quit;

Operating System and Release Information