topic Excel Export on AIX in ODS and Base Reporting

Excel Export on AIX

Criptic — Tue, 05 Sep 2017 10:07:05 GMT

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

Re: Excel Export on AIX

RW9 — Tue, 05 Sep 2017 10:22:53 GMT

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.

Re: Excel Export on AIX

devrant — Tue, 05 Sep 2017 10:47:21 GMT

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#p1d0tocg3njhmfn1d4ld2covlwm0.htm

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

Re: Excel Export on AIX

Criptic — Tue, 05 Sep 2017 11:55:07 GMT

Thank you for the pointers, that solved it for me

Re: Excel Export on AIX

Criptic — Tue, 05 Sep 2017 11:55:42 GMT

Thank you for your answer 🙂