What engine installed in my SAS?(Unix)

Reply
Super Contributor
Posts: 271

What engine installed in my SAS?(Unix)

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!

Super Contributor
Posts: 282

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

Posted in reply to GeorgeSAS
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
Super User
Posts: 23,771

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

Posted in reply to GeorgeSAS

Libname engine is not supported in SAS Unix in SAS 9.3

 

You can try PROC EXPORT. 

Super User
Posts: 10,278

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

Posted in reply to GeorgeSAS

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super Contributor
Posts: 271

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

Posted in reply to KurtBremser
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.
Super User
Posts: 10,278

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

Posted in reply to GeorgeSAS

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Respected Advisor
Posts: 4,736

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

[ Edited ]
Posted in reply to GeorgeSAS

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

 

 

Super Contributor
Posts: 271

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

ERROR: The XLSX engine cannot be found
thanks
Super User
Posts: 23,771

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

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.

 

 

Super User
Posts: 10,784

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

Posted in reply to GeorgeSAS

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

 

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

 

Super Contributor
Posts: 271

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

ERROR: The XLS engine cannot be found.


Thank you Ksharp
Ask a Question
Discussion stats
  • 10 replies
  • 197 views
  • 0 likes
  • 6 in conversation