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 🙂
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.