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

[lboyd]

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]

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]

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

[atzamis]

Hi,

 you could try

proc import datafile = 'path\filename.xlsx'

DBMS=excel OUT = dataset_name;

run;

http://support.sas.com/documentation/cdl/en/lestmtsref/69738/HTML/default/viewer.htm#n1nk65k2vsfmxfn...

http://support.sas.com/documentation/cdl/en/lrcon/69852/HTML/default/viewer.htm#p1x3150ol4cd98n1wnvi...

Which version dow you use?

http://support.sas.com/kb/49/468.html