Error: engine XLSX cannot be found

[Nivethitha]

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

[Kurt_Bremser]

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

[Nivethitha]

I will check with the SAS administrator. Thank you! 

[SASKiwi]

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

[KathyKiraly]

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.

[CheeHian]

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?

[Kurt_Bremser]

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

[KathyKiraly]

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