topic Re: Proc Export Truncates to 255 Chars in SAS Programming

Proc Export Truncates to 255 Chars

JayS — Thu, 30 Mar 2023 14:12:49 GMT

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;

Re: Proc Export Truncates to 255 Chars

ballardw — Thu, 30 Mar 2023 14:20:51 GMT

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?

Re: Proc Export Truncates to 255 Chars

JayS — Thu, 30 Mar 2023 14:26:58 GMT

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