Bringing in large character values to MS Excel through SAS AMO


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:


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

Management Console:


About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Comments are closed.

Back to Top