topic Re: ERROR: The XLSX engine cannot be found. ERROR: Error in the LIBNAME statement. in SAS Procedures

ERROR: The XLSX engine cannot be found. ERROR: Error in the LIBNAME statement.

lboyd — Mon, 20 Feb 2017 22:22:14 GMT

I received this error:

ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.

I am using the Dietary Screener Questionnaires in the NHANES: SAS Programs and I'm having trouble getting the first part of the code to work:

filename yourdata 'C:\data.xlsx';

libname psize xlsx 'C:\calib.portion.size.xlsx';

libname rcoeff xlsx 'C:\calib.equation.coeff.xlsx';

I get this error:

ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.

I ran:

proc setinint;
run;

and I have this: SAS/ACCESS Interface to PC Files 14AUG2017

So I'm unsure what the problem is.

Thank you!

Tom — Mon, 20 Feb 2017 22:51:24 GMT

What version of SAS are you running? Look at the top of the SAS log or post the value of the automatic macro variable SYSVLONG.

lboyd — Tue, 21 Feb 2017 13:59:11 GMT

It is SAS (r) Proprietary Software 9.4 (TS1M1)

atzamis — Fri, 10 Mar 2017 14:41:36 GMT

Hi,

you could try

proc import datafile = 'path\filename.xlsx'

DBMS=excel OUT = dataset_name;

run;

Which version dow you use?