Learning SAS? Welcome to the exclusive online community for all SAS learners.

ERROR: The EXCEL engine cannot be found.

Accepted Solution Solved
Reply
Contributor
Posts: 49
Accepted Solution

ERROR: The EXCEL engine cannot be found.

Hi,

 

I am trying to import an xlsx file into SAS Studio 3.5 (university edition) using the following code:

 

libname orionx excel "\folders\myfolders\Projects\Filename.xlsx";

 

Where \folders\myfolders\Projects is a path in the SAS system.

 

On execution the log shows:

 

ERROR: The EXCEL engine cannot be found.
ERROR: Error in the LIBNAME statement.
 
Is this because of the difference in bitness of Excel and SAS Studio?
 
I've checked the bitness of Excel on my system (32-bit). If yes, how can I check the bitness of SAS Studio 3.5 (university edition)?
 
The following is what I can see in the About SAS Studio > Information:
 
SAS platform: Linux LIN X64 2.6.32-573.18.1.el6.x86_64

 

Does the 64 at the end indicate that it is 64-bit?

 

Is there is a way to access xlsx files using the EXCEL engine?

 

Or would I need to use the PCFILES or XLSX engines?

 

Also, once the bitness issue is resolved can I pick up a file directly from C:\...\Filename.xlsx instead by using this path instead of the \folders\myfolders\Filename.xlsx from within the SAS system?

 

Cheers,

 

Sandesh.


Accepted Solutions
Solution
‎07-19-2016 09:46 AM
Super User
Posts: 19,858

Re: ERROR: The EXCEL engine cannot be found.

Posted in reply to DataScientist

Yes that's correct. 

 

And no, SAS UE does not support connecting to a server. You can hack your way around it, but it's not officially supported. 

View solution in original post


All Replies
Super User
Posts: 19,858

Re: ERROR: The EXCEL engine cannot be found.

Posted in reply to DataScientist

Use XLSX rather than Excel. 

Regular Learner
Posts: 1

Re: ERROR: The EXCEL engine cannot be found.

It works thx!

Super User
Posts: 19,858

Re: ERROR: The EXCEL engine cannot be found.

Posted in reply to DataScientist

And no you can't use the c:\ path. 

 

SAS UE is on a UNIX box and a VM. Essentially it's like SAS is on a different computer, more similar to working with SAS on a server.

 

This is why the Excel engine doesn't work. 

It's also why you need to set up the shared folder. You can add further shared folders if you'd like to more frequently used locations. See the SAS UE FAQ to learn how. 

Contributor
Posts: 49

Re: ERROR: The EXCEL engine cannot be found.

Thanks for the prompt reply @Reeza. Will give it a go using the XLSX engine. So you're saying the reason why the EXCEL engine doesn't work is because SAS Studio University Edition is on a Unix box and the issue isn't relating to the difference in bitness, is this correct?

 

Also, if we are accessing a file from a different location, would using the SERVER= option help?

 

Cheers,

 

Sandesh.

Solution
‎07-19-2016 09:46 AM
Super User
Posts: 19,858

Re: ERROR: The EXCEL engine cannot be found.

Posted in reply to DataScientist

Yes that's correct. 

 

And no, SAS UE does not support connecting to a server. You can hack your way around it, but it's not officially supported. 

Contributor
Posts: 49

Re: ERROR: The EXCEL engine cannot be found.

Excellent, thanks very much @Reeza.

Super User
Posts: 19,858

Re: ERROR: The EXCEL engine cannot be found.

Posted in reply to DataScientist

Yes that's correct. 

 

And no, SAS UE does not support connecting to a server. You can hack your way around it, but it's not officially supported. 

Contributor
Posts: 49

Re: ERROR: The EXCEL engine cannot be found.

The "C:\...\Filename.xlsx" worked using the XLSX engine after making the path a shared folder as recommended in your solution.

Contributor
Posts: 49

Re: ERROR: The EXCEL engine cannot be found.

Posted in reply to DataScientist

Though the log displays that the code has successfully executed there is nothing in the newly created orionx library that the following line of code created:

 

libname orionx xlsx "C:\...\Filename.xlsx";

 

Shouldn't the library have the imported xlsx file or the SAS dataset that I was attempting to import?

Super User
Posts: 19,858

Re: ERROR: The EXCEL engine cannot be found.

Posted in reply to DataScientist

Libname creates a connection to the Excel file, it doesn't import anything. 

 

You still don't refer to it as C:/... Check the FAQ or right click the folder and get the path from properties. 

Contributor
Posts: 49

Re: ERROR: The EXCEL engine cannot be found.

Got it. Used the internal SAS folder "/folders/myfolders/..." that I uploaded the file to. I can now see the worksheets from the xlsx file in the newly created orionx library. Was able to view the data using a 'proc contents data=orionx.sheet1'. Sorry, I was a bit confused between proc import with what this was supposed to achieve.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 11 replies
  • 2688 views
  • 2 likes
  • 3 in conversation