Hey,
I have a bit of trouble with xls export. This following code snippet runs in EG on Windows but when I executed in a SAS session on AIX it throws the following error: ERROR: No body file. EXCEL output will not be created.
ods excel file='/sas/text.xls';
proc print data=aaa;
run;
ods excel close;
The path is in a directory on the AIX and I can write files to that location via the EG but as I said in a SAS session on AIX it throws an error.
Anybody any ideas?
Thanks in advance and kind regards
David
Well, first off the ods Excel engine is for creating XLSX files - i.e. the latest Open Office format files, so good idea to call them that. Secondly AIX, I don't think Office is on that platform is it, so neither will the engine needed to create the files be. You will probably have to use pcfiles, or use a tagset output such as:
ods tagsets.excelxp file="...abc.xml";
...
This XML output can be opened in Excel.
Well, first off the ods Excel engine is for creating XLSX files - i.e. the latest Open Office format files, so good idea to call them that. Secondly AIX, I don't think Office is on that platform is it, so neither will the engine needed to create the files be. You will probably have to use pcfiles, or use a tagset output such as:
ods tagsets.excelxp file="...abc.xml";
...
This XML output can be opened in Excel.
Thank you for the pointers, that solved it for me
Thank you for your answer 🙂
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.