Proc Export Truncates to 255 Chars

[JayS]

I have the below code running, however there is one field in the Dataset with over 1,000 characters (DetailDescription).

It seems the Proc Export procedure only exports 255 characters.

However, when I use EG to 'Send To' Excel all the characters are exported.
Anyone solved this one yet, as I'd like to use Proc Export as the job stream is automated.

TIA, Jay

PROC EXPORT
DATA=MyLib.DescriptionData
DBMS=XLS
LABEL
OUTFILE='/xxxx/xxxxx/SASGrid/OutputExcelData.xls'
REPLACE;
SHEET = 'Exported Data';
Run;

[ballardw · Accepted solution]

Is the EG "send to Excel" creating an XLS or an XLSX file? There are differences.

Did you try making the column wider to see if the cells just weren't displaying the whole value?

[JayS]

Thanks, I changed it all to .xlsx and it works fine. Thanks for the quick response, appreciate it. J