BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
98ighcfdvxcghjk
Calcite | Level 5

Hello,

 

I always have trouble starting procedures in SAS and I can never create a libname statement correctly on the first try. What i have currently is:

 libname xl XLSX "c:NidiaSAS\SASLearn\h188a.xlsx";
run;

But it gives me the errors 

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

 

I am not sure what I am doing wrong, can someone show me how to fix it so it can read my data?

1 ACCEPTED SOLUTION

Accepted Solutions
PaigeMiller
Diamond | Level 26

@98ighcfdvxcghjk wrote:

Hello,

 

I always have trouble starting procedures in SAS and I can never create a libname statement correctly on the first try. What i have currently is:

 libname xl XLSX "c:NidiaSAS\SASLearn\h188a.xlsx";


How about this:

 

libname xl XLSX "c:\NidiaSAS\SASLearn\h188a.xlsx";

with a backslash after c:

--
Paige Miller

View solution in original post

3 REPLIES 3
SASJedi
SAS Super FREQ
Please check out the solution to this problem at https://communities.sas.com/t5/SAS-Analytics-U/ERROR-XLSX-engine-cannot-be-found/m-p/567972/highligh...
If that doesn't clear it up, let me know.
Check out my Jedi SAS Tricks for SAS Users
98ighcfdvxcghjk
Calcite | Level 5

That does not help me at all, after running the code it tells me I still get the same errors. 

PaigeMiller
Diamond | Level 26

@98ighcfdvxcghjk wrote:

Hello,

 

I always have trouble starting procedures in SAS and I can never create a libname statement correctly on the first try. What i have currently is:

 libname xl XLSX "c:NidiaSAS\SASLearn\h188a.xlsx";


How about this:

 

libname xl XLSX "c:\NidiaSAS\SASLearn\h188a.xlsx";

with a backslash after c:

--
Paige Miller

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 949 views
  • 1 like
  • 3 in conversation