topic Re: XLSX engine cannot be found in SAS Programming

XLSX engine cannot be found

bphillips79 — Wed, 15 Mar 2023 15:14:43 GMT

Hi folks -

I'm using SAS's learning tool and I've run into a problem when trying to access the XLSX engine.

I'm running: 9.4 TS LEVEL 1M5

Code:

options validvarname=v7;
libname NP XLSX "U:\My SAS Files\9.4\coursefiles\EPG1V2\data\np_info.xlsx";

Error I'm getting:

1 options validvarname=v7;
2 libname NP XLSX "U:\My SAS Files\9.4\coursefiles\EPG1V2\data\np_info.xlsx";
ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.

I checked to see if Interface to PC was licensed and installed:

---SAS/ACCESS Interface to PC Files
31JUL2023

For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M5

Any ideas?

Re: XLSX engine cannot be found

SASKiwi — Wed, 15 Mar 2023 19:43:35 GMT

@bphillips79 wrote:

Hi folks -

I'm using SAS's learning tool and I've run into a problem when trying to access the XLSX engine.

I'm running: 9.4 TS LEVEL 1M5

Code:

options validvarname=v7;
libname NP XLSX "U:\My SAS Files\9.4\coursefiles\EPG1V2\data\np_info.xlsx";

Error I'm getting:

1 options validvarname=v7;
2 libname NP XLSX "U:\My SAS Files\9.4\coursefiles\EPG1V2\data\np_info.xlsx";
ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.

I checked to see if Interface to PC was licensed and installed:

---SAS/ACCESS Interface to PC Files
31JUL2023

For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M5

Any ideas?

Are you referring to SAS OnDemand for Academics or something else?

Re: XLSX engine cannot be found

Cynthia_sas — Wed, 15 Mar 2023 20:45:19 GMT

Hi: If you are using SAS OnDemand for Academics, the code for the class does work on the SAS OnDemand server. What will NOT work is the U: drive location you show. SAS OnDemand for Academics will NOT read any location except for OnDemand server files. Also, I'm confused by the SAS version you show because the OnDemand server is using a more current version. However, the XLSX engine was included in SAS Access for PC File Formats starting with SAS 9.4 Maintenance Release 2, so if you are by any chance using a LOCAL installation of SAS, it is possible that you don't have the XLSX engine because it was not part of your configuration.
Cynthia

Re: XLSX engine cannot be found

Kurt_Bremser — Wed, 15 Mar 2023 21:02:58 GMT

Run PROC PRODUCT_STATUS to see if everything is installed properly.

Re: XLSX engine cannot be found

bphillips79 — Thu, 16 Mar 2023 12:31:51 GMT

Hi Cynthia -

I realize I wasn't clear in my initial question. I'm using a SAS video training module and their provided files, but doing the activities on my local install. However, to your point about XLSX and PC File Formats, I think I have Interface to PC Files installed. That's what "For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M5" means, correct? And if I have do Interface to PC Files do I call PC Files or XLSX in my program?

Re: XLSX engine cannot be found

bphillips79 — Thu, 16 Mar 2023 12:33:20 GMT

Something else. I realize now I wasn't clear. I'm watching a SAS provided training video module and using the accompanying files they provided. But I'm doing so on my local machine install.

Re: XLSX engine cannot be found

bphillips79 — Thu, 16 Mar 2023 12:37:32 GMT

I did run that, and got a whole list of items. I posted in the lines regarding PC Files from licensing proc (I forget the syntax) and the product status. I didn't see anything about XLSX in either of the results though. Should I expect to see XLSX if it's licensed and/or installed?

Re: XLSX engine cannot be found

Kurt_Bremser — Thu, 16 Mar 2023 15:59:59 GMT

If PRODUCT_STATUS shows ACCESS to PC Files as installed without issues, then you need to open a track with SAS technical support. The XLSX engine is part of that module.

Re: XLSX engine cannot be found

Cynthia_sas — Thu, 16 Mar 2023 20:06:18 GMT

Hi:
Look in the Course Overview and Data Setup section at the top of the Table of Contents. There are 3 methods of making the data for your own SAS installation. The instructions you follow depend on the type of installation you have. If it turns out that you do not have SAS/Access for PC Files installed (this is what you need -- it contains the XLSX engine), then your best choice for practicing your be to use one of these options:
1) Use the Virtual Lab and SAS Studio that is INSIDE the course on the right side of the screen or
2) set up a SAS OnDemand account and use SAS Studio with SAS OnDemand to practice.
There is NOT any data setup required to use option 1. There is 1 folder to make and 1 program to run to do the data setup for #2.
Hope this helps,
Cynthia

Re: XLSX engine cannot be found

SASKiwi — Thu, 16 Mar 2023 20:32:02 GMT

I suggest you try the EXCEL engine as well and post the results of this statement:

 libname NP Excel "U:\My SAS Files\9.4\coursefiles\EPG1V2\data\np_info.xlsx";

This engine uses components of MS Office so that would need to be installed as well.

Re: XLSX engine cannot be found

Tom — Fri, 17 Mar 2023 02:37:23 GMT

Talk to your local SAS support to find out why XLSX engine is not working. Or open a ticket with SAS Technical Support. https://support.sas.com/en/technical-support.html

You could always just open the XLSX file with a spreadsheet program and save the sheet as a delimited text file (such as a CSV). Then you can read the text file using a data step. There is no way the data step modules are not installed because then SAS wouldn't work at all.

Re: XLSX engine cannot be found

bphillips79 — Fri, 17 Mar 2023 12:12:21 GMT

I ended up submitting a ticket. Turns out I have 64 bit SAS and 32 bit MS Office.

Re: XLSX engine cannot be found

bphillips79 — Fri, 17 Mar 2023 12:24:50 GMT

I ended up opening a ticket. Discovered I had 64 bit SAS and 32 bit MS Office. Apparently they don't talk to each other unless they're the same.

Re: XLSX engine cannot be found

Kurt_Bremser — Fri, 17 Mar 2023 12:29:51 GMT

@bphillips79 wrote:

I ended up submitting a ticket. Turns out I have 64 bit SAS and 32 bit MS Office.

Hm. From everything I know, the XLSX engine does not need any "external" software, so it should not be affected by the Office version installed (it also works on UNIX platforms, where there is no MS Office).

Re: XLSX engine cannot be found

Tom — Fri, 17 Mar 2023 13:06:10 GMT

@bphillips79 wrote:

I ended up opening a ticket. Discovered I had 64 bit SAS and 32 bit MS Office. Apparently they don't talk to each other unless they're the same.

That would only have an impact if you tried to use the EXCEL engine. The cause of your issue with the XLSX engine is something else.