topic Re: What engine installed in my SAS?(Unix) in SAS Programming

What engine installed in my SAS?(Unix)

GeorgeSAS — Mon, 01 May 2017 18:39:21 GMT

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!

Re: What engine installed in my SAS?(Unix)

AhmedAl_Attar — Mon, 01 May 2017 19:17:57 GMT

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

Re: What engine installed in my SAS?(Unix)

Reeza — Mon, 01 May 2017 19:31:20 GMT

Libname engine is not supported in SAS Unix in SAS 9.3

You can try PROC EXPORT.

Re: What engine installed in my SAS?(Unix)

Kurt_Bremser — Tue, 02 May 2017 11:37:00 GMT

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.

Re: What engine installed in my SAS?(Unix)

Patrick — Tue, 02 May 2017 11:56:20 GMT

@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#p05hxa7xihwolmn1sdjpfui9nosc.htm

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/

Re: What engine installed in my SAS?(Unix)

Ksharp — Tue, 02 May 2017 12:38:36 GMT

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

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

Re: What engine installed in my SAS?(Unix)

GeorgeSAS — Tue, 02 May 2017 15:40:17 GMT

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.

Re: What engine installed in my SAS?(Unix)

GeorgeSAS — Tue, 02 May 2017 15:41:11 GMT

ERROR: The XLSX engine cannot be found
thanks

Re: What engine installed in my SAS?(Unix)

GeorgeSAS — Tue, 02 May 2017 15:41:59 GMT

ERROR: The XLS engine cannot be found.

Thank you Ksharp

Re: What engine installed in my SAS?(Unix)

Kurt_Bremser — Tue, 02 May 2017 17:38:54 GMT

@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.

Re: What engine installed in my SAS?(Unix)

Reeza — Tue, 02 May 2017 18:38:39 GMT

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.