CODEWITHSUNDEEP
sas
Buras
Buras

Reputation: 3099

SAS : How to overwrite default 97 characters truncation?

I use ods tagsets.excelxp 

ods tagsets.excelxp
file='C:\xxx\xxx.xls' 
options(autofilter="yes"
            sort="yes"
...
ods tagsets.excelxp close;

Everything is fine except

WARNING: Data too long for column "Description"; truncated to 97 characters to fit.

How can I overwrite this, and set a different truncation limit ?

Upvotes: 0

Views: 601

Answers (1)

Reeza
Reeza

Reputation: 21264

I don't think that warning applies to the Tagsets but to the Listing destination so turning that off before running the tagset code should help.

Or is it truncating in your excel file?

Upvotes: 1

Related Questions