The SAS Output Delivery System and reporting techniques

Excel Export on AIX

Accepted Solution Solved
Reply
Contributor
Posts: 53
Accepted Solution

Excel Export on AIX

[ Edited ]

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


Accepted Solutions
Solution
‎09-05-2017 07:54 AM
Super User
Super User
Posts: 8,349

Re: Excel Export on AIX

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.

View solution in original post


All Replies
Solution
‎09-05-2017 07:54 AM
Super User
Super User
Posts: 8,349

Re: Excel Export on AIX

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.

Contributor
Posts: 53

Re: Excel Export on AIX

Thank you for the pointers, that solved it for me

Contributor
Posts: 53

Re: Excel Export on AIX

Thank you for your answer Smiley Happy

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 249 views
  • 3 likes
  • 3 in conversation