What engine installed in my SAS?(Unix)

Reply
Regular Contributor
Posts: 186

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!

Regular Contributor
Posts: 211

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

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
Grand Advisor
Posts: 17,338

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

Libname engine is not supported in SAS Unix in SAS 9.3

 

You can try PROC EXPORT. 

Esteemed Advisor
Posts: 6,646

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

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
Regular Contributor
Posts: 186

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

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.
Esteemed Advisor
Posts: 6,646

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


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
Respected Advisor
Posts: 3,831

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

[ Edited ]

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

 

 

Regular Contributor
Posts: 186

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

ERROR: The XLSX engine cannot be found
thanks
Grand Advisor
Posts: 17,338

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.

 

 

Grand Advisor
Posts: 9,576

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

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

 

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

 

Regular Contributor
Posts: 186

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
  • 136 views
  • 0 likes
  • 6 in conversation