please teach me how to read directly data set from .xls file

[tianerhu]

I want to use engine to read an excel spreadsheet , but failed .

please give a help , thank you.

libname readit "C:\Users\Documents\My SAS Files\9.4\chapter 6\soccer.xls";
proc print data = readit.soccer;
run;

The following is the log said:

126 libname readit "C:\Users\Documents\My SAS Files\9.4\chapter 6\soccer.xls";
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
127 proc print data = readit.soccer;
ERROR: Libref READIT is not assigned.
128 run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):

The following is one example from my book:

[AnandVyas]

Hi @tianerhu 

You should use the xlsx engine.

https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=acpcref&docsetTarget=n...

This statement assigns the libref, myxlsx, to a Microsoft Excel .xlsx file and uses the XLSX engine:

LIBNAME myxlsx XLSX 'c:\demo.xlsx';

[tianerhu]

Thank you , but it not what I want, I add one example from my book.

[SASKiwi]

So what is wrong with this?

libname readit xlsx "C:\Users\Documents\My SAS Files\9.4\chapter 6\soccer.xls";
proc print data = readit.soccer;
run;

[tianerhu]

Now, I have sloved this problem. Thank you so much.

libname readit xlsx  "C:\Users\Documents\My SAS Files\9.4\chapter 6\soccer.xlsx";
proc print data = readit.soccer;
run;

need to change two place:

the first place:(choose the blue part)

do not choose the following:

the second place :

change " soccer.xls " to "soccer.xlsx "   in the program

Ok,  the program work well.

Thank you again.

[SASKiwi]

@tianerhu - Please update your post as answered.

[tianerhu · Accepted solution]

libname readit xlsx  "C:\Users\Documents\My SAS Files\9.4\chapter 6\soccer.xlsx";
proc print data = readit.soccer;
run;

[tianerhu]

You are right. Thank you .