Setting up practice files - XLSX Engine Cannot be Found / LIBNAME error

[wing2wang]

Hello!

I am running through the Setup Instructions for SAS Enterprise Guide to complete the Essentials Course. _1egpg194 runs fine with no issues but the second program _2egpg194 returns various repeating errors:

ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.
WARNING: Libref XL is not assigned.
ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.
ERROR: Libref XL is not assigned.
ERROR: Libref XL is not assigned.
ERROR: Libref XL is not assigned.
ERROR: Libref XL is not assigned.
WARNING: Libref XL is not assigned.
ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.
ERROR: Libref XL is not assigned.
WARNING: Libref XL is not assigned.

I have run some code to see my current version of SAS etc:

Current version: 9.04.01M4P110916

Product expiration dates:

---Base SAS Software 29FEB2020 
---SAS/STAT 29FEB2020 
---SAS/GRAPH 29FEB2020 
---SAS/Secure 168-bit 29FEB2020 
---SAS/Secure Windows 29FEB2020 
---SAS Enterprise Guide 29FEB2020 
---SAS/ACCESS Interface to ODBC 29FEB2020 
---SAS Workspace Server for Local Access 29FEB2020 
---High Performance Suite 29FEB2020

As far as I can see, I have the most updated version of SAS Enterprise Guide so that shouldn't be causing any errors. Does anyone have any ideas?

[Kurt_Bremser]

You do not have SAS/ACCESS to PC Files licensed, so you will have to skip the parts in the course that deal with Excel import/export.

[Reeza]

I believe you can import files via the GUI or ODBC if really needed but definitely not a straightforward process.

[Cynthia_sas]

Hi:

  Although you could import files the issue with Programming 1 is that students need to have the XLSX Libname engine available to make the data for class. And, many of the practices and demos in the class use the XLSX engine. This engine was production in a later version of SAS. So, if the student does not have the ability to use the XLSX engine at work, they may want to consider getting SAS University Edition or SAS OnDemand for Academics so they can work with the class practices.

  There are some other postings in the Programming 1 forum, that are related to this and we've posted some links there about this error message.

Cynthia