BookmarkSubscribeRSS Feed
GeorgeSAS
Lapis Lazuli | Level 10
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!

10 REPLIES 10
AhmedAl_Attar
Rhodochrosite | Level 12
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
Super User

Libname engine is not supported in SAS Unix in SAS 9.3

 

You can try PROC EXPORT. 

Kurt_Bremser
Super User

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
Lapis Lazuli | Level 10
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
Super User

@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
Opal | Level 21

@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
Lapis Lazuli | Level 10
ERROR: The XLSX engine cannot be found
thanks
Reeza
Super User

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
Super User

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

 

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

 

GeorgeSAS
Lapis Lazuli | Level 10
ERROR: The XLS engine cannot be found.


Thank you Ksharp

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 10 replies
  • 1118 views
  • 0 likes
  • 6 in conversation