Bringing in large character values to MS Excel through SAS AMO

0

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:

Share

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'.

Leave A Reply

Back to Top