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;
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?
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?
Thanks, I changed it all to .xlsx and it works fine. Thanks for the quick response, appreciate it. J
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.