topic Re: please teach me how to read directly data set from .xls file in SAS Programming

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

tianerhu — Tue, 29 Dec 2020 04:05:22 GMT

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:

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

AnandVyas — Tue, 29 Dec 2020 03:53:50 GMT

Hi @tianerhu

You should use the xlsx engine.

https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=acpcref&docsetTarget=n0oj9f6i838mymn148890ckla700.htm&locale=en#n104ay5ypq1fb6n1cxxs1icsovy1

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

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

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

tianerhu — Tue, 29 Dec 2020 04:07:05 GMT

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

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

SASKiwi — Tue, 29 Dec 2020 05:22:20 GMT

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;

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

tianerhu — Tue, 29 Dec 2020 19:34:26 GMT

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.

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

SASKiwi — Tue, 29 Dec 2020 20:59:33 GMT

@tianerhu - Please update your post as answered.

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

tianerhu — Tue, 29 Dec 2020 21:26:44 GMT

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

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

tianerhu — Tue, 29 Dec 2020 21:27:57 GMT

You are right. Thank you .