03-31-2016 09:57 AM - edited 03-31-2016 10:08 AM
03-31-2016 10:01 AM
Did you try
data db2lib.test2; set work.test; keep var1; run;
03-31-2016 10:53 AM
Is it numerical or char?
If numerical, you may hit the default max size for the mapped data type in DB2.
options sastrace=',,,d' sastraceloc=saslog nostsuffix msglevel=i;
04-01-2016 01:31 AM
It looks like the column is (per default) defined as integer in DB/2, where you have a range of -2147483648 to +2147483647.
One thing that came to my mind was to use PROC DS2 and define the column as BIGINT or FLOAT.
04-01-2016 06:35 AM
When numerical variable become this large, on can ask if they really need to be integers - are they par of calculations?
Another option is to use data set options to explicitly specify data types in the target database (DBTYPE).