Hello everyone! Let me explain you what is my little problem. I have a SAS data set with 3 columns with Numerical format (Numeric Length 8), and I would like to insert them into a Teradata table with 3 columns with the next formats: Decimal(11,3), Integer, Decimal(11,3). Nonetheless I receive a ROLLBACK error. NOTE: I have enough permissions in the teradata library and I have a good conectivity. The SAS code I am using is the following: proc sql; insert into tdt.table_1 select C_1 format=BEST11.3, C_2 format=BEST11, C_3 format=BEST11.3 from lib.table_2; quit; Please, can anybody explain me how to change formats in order to move data from SAS into Teradata? Note: I have been reading the SAS Support link for Teradata formats, but I couldn't achieve the solution. http://support.sas.com/documentation/cdl/en/acreldb/69039/HTML/default/viewer.htm#n0v7nh4ylrihtin1te8xl0q3dvzv.htm Thanks in advanced!
... View more