Help using Base SAS procedures

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

Reply
Contributor
Posts: 27

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

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!

Super User
Super User
Posts: 7,042

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

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.

Contributor
Posts: 27

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

It is SAS (r) Proprietary Software 9.4 (TS1M1)
Occasional Contributor
Posts: 10

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

[ Edited ]
Ask a Question
Discussion stats
  • 3 replies
  • 498 views
  • 0 likes
  • 3 in conversation