topic Re: Error: engine XLSX cannot be found in Programming 1 and 2

Error: engine XLSX cannot be found

Nivethitha — Tue, 22 Mar 2022 11:47:21 GMT

Hi,

I am using xlsx engine in libname statement and I got the below error in SAS studio.

Can anyone help me to resolve this error? Thanks!

Code:

libname __amspec xlsx "../../data/spec/M16-109_ADaM Specs1.xlsx";

Error message in SAS log:

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

proc setinit;
run;

NOTE: PROCEDURE SETINIT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Original site validation data
Current version: 9.04.01M7P080620
CPU A: Model name='' model number='' serial=''.
Expiration: 29NOV2022.
Grace Period: 45 days (ending 13JAN2023).
Warning Period: 46 days (ending 28FEB2023).
System birthday: 03JAN2022.
Operating System: LIN X64 .
Product expiration dates:
---Base SAS Software 29NOV2022 (CPU A)
---SAS/STAT 29NOV2022 (CPU A)
---SAS/GRAPH 29NOV2022 (CPU A)
---SAS/ETS 29NOV2022 (CPU A)
---SAS Integration Technologies 29NOV2022 (CPU A)
---SAS/Secure 168-bit 29NOV2022 (CPU A)
---SAS Enterprise Guide 29NOV2022 (CPU A)
---SAS/ACCESS Interface to PC Files 29NOV2022 (CPU A)
---SAS/ACCESS Interface to ODBC 29NOV2022 (CPU A)
---SAS Workspace Server for Local Access 29NOV2022 (CPU A)
---SAS/ACCESS to Hadoop 29NOV2022 (CPU A)
---High Performance Suite 29NOV2022 (CPU A)
---SAS Add-in for Microsoft Excel 29NOV2022 (CPU A)
---SAS Add-in for Microsoft Outlook 29NOV2022 (CPU A)
---SAS Add-in for Microsoft PowerPoint 29NOV2022 (CPU A)
---SAS Add-in for Microsoft Word

proc product_status;
run;

For Base SAS Software ...
Custom version information: 9.4_M7
Image version information: 9.04.01M7P080520
For SAS/Secure 168-bit ...
Custom version information: 9.41_M4

Re: Error: engine XLSX cannot be found

Kurt_Bremser — Tue, 22 Mar 2022 11:54:09 GMT

Many of the products mentioned in your license are not installed. Have your SAS administrator rectify that.

Re: Error: engine XLSX cannot be found

Nivethitha — Tue, 22 Mar 2022 12:10:49 GMT

I will check with the SAS administrator. Thank you!

Re: Error: engine XLSX cannot be found

SASKiwi — Wed, 23 Mar 2022 00:12:21 GMT

SAS/ACCESS Interface to PC Files provides the XLSX engine.

Re: Error: engine XLSX cannot be found

KathyKiraly — Wed, 20 Jul 2022 20:15:13 GMT

PROC SETINIT displays the products your company or school has licensed. PROC PRODUCT_STATUS displays the products that are installed.

proc product_status;

run;

You must have SAS/ACCESS Interface to PC Files in SAS release 9.4 M2 or higher to use the XLSX engine.

Re: Error: engine XLSX cannot be found

CheeHian — Thu, 21 Sep 2023 03:25:25 GMT

I have the same problem when I run this code:

"engine XLSX cannot be found" error occurred.

After I ran PROC PRODUCT_STATUS; run;, I can see that I have "SAS/ACCESS Interface to PC Files" and the version is 9.4 M7.

So what else am I missing?

Re: Error: engine XLSX cannot be found

Kurt_Bremser — Thu, 21 Sep 2023 06:21:24 GMT

You seem to have everything in place, so this is something for SAS Technical Support.

Re: Error: engine XLSX cannot be found

KathyKiraly — Thu, 21 Sep 2023 15:21:31 GMT

You can contact SAS Technical Support here: https://support.sas.com/en/technical-support.html.