What engine installed in my SAS?(Unix)

[GeorgeSAS]

libname aa excel '/aaaaa/aaaa/bbbb/test.xls' ;

                ERROR: The EXCEL engine cannot be found.

Hello all,

How to check what engine has been installed in my SAS?

Thanks!

[AhmedAl_Attar]

You can run the following
Proc product_status; run;

Proc product_status: Is an undocumented (9.2) procedure that lists the the release level (or version number) of each installed component of SAS in the system in the SAS log

[Reeza]

Libname engine is not supported in SAS Unix in SAS 9.3

You can try PROC EXPORT. 

[Kurt_Bremser]

Dealing with .xls files in SAS was always done by using a Microsoft-supplied, Windows-only software module. So you can't read or write .xls files directly on a UNIX platform. A mechanism to achieve this was provided by using the PC Files Server on a Windows machine and using the excelcs engine in SAS. You might consider doing that.

With 9.4, a platform-independent access to Open Office format (.xlsx) is implemented in SAS, and therefore you don't need any other tools to read/write such files in a variety of ways (import/export, libname) on any supported platform.

A license for SAS/ACCESS to PC Files is required in any case.

As a stable, solid workaround that does not need any license beyond SAS/Base I recommend to communicate via plain text (csv) files.

[GeorgeSAS]

Thank you Kurt,
FYI,in unix .xls can be generated by ods tagsets.excelxp.
but I don't know how to update a sheet of an existed file with this.

[Kurt_Bremser]

---

@GeorgeSAS wrote:
Thank you Kurt,
FYI,in unix .xls can be generated by ods tagsets.excelxp.
but I don't know how to update a sheet of an existed file with this.

---

This is an often encountered mistake. tagsets.execlxp does not create a true xls file, it writes a form of XML that Excel understands. Just look at the file with a text editor.

[Patrick]

@GeorgeSAS

If possible use the XLSX engine instead of the EXCEL engine.

I've just pasted your Error message into Google and it appears this Error can also get thrown when you've got a 32/64Bit issue.

http://support.sas.com/kb/49/468.html

To compare the capabilities of the different engines:

http://support.sas.com/documentation/cdl/en/acpcref/69731/HTML/default/viewer.htm#p05hxa7xihwolmn1sd...

And here one of Chris Hemedinger's great blogs which also might be helpful to you:

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

[GeorgeSAS]

ERROR: The XLSX engine cannot be found
thanks

[Reeza]

You're using software from 2011 that has no updates. 

Expecting it to work with software versions that are after isn't a fair expectation. 

Upgrade, use DDE or a different software tool.

[Ksharp]

Also try XLS enging, if your excel is english language.

libname aa xls '/aaaaa/aaaa/bbbb/test.xls' ;

[GeorgeSAS]

ERROR: The XLS engine cannot be found.


Thank you Ksharp