Excel Export on AIX

[Criptic]

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

[RW9 · Accepted solution]

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.

[Criptic]

Thank you for the pointers, that solved it for me

[devrant]

Hi,

I'd check these options too:

http://blogs.sas.com/content/sasdummy/2012/02/11/export-excel-methods/

Especially these:
http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#p1d0tocg3njhmfn1d4...

http://blogs.sas.com/content/sasdummy/2012/01/25/export-to-excel-got-easier/

[Criptic]

Thank you for your answer 🙂