MS Excel limits cells to 910 characters in length. The next version of SAS Add-In to Microsoft Office (AMO) addresses this issue by truncating records & giving the user a warning message, however what do you do with users today?

Answer: Truncate the format & informat in a SAS Data step to less than $910 and then update SAS Management Console columns accordingly (format, informat & length).

The error message:

Code:

data main_table_name;
informat csr customer_impact inv_comments keywords $900.;
set temp_table_name ;
format csr customer_impact inv_comments keywords $900.;
run;

Management Console: