Help using Base SAS procedures

Unable to import Excel file

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

Unable to import Excel file

Hi, I was unable to import an excel workbook with only one sheet into SAS 9.4.

 

I tried using the IMPORT/EXPORT option in the files and after inserting the file in the BROWSE option, I get a message, "failed. check log"

And the log says as follows.

 

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.

 

I tried other methods as well. I tried the following codes but none of them worked

 

PROC IMPORT = "C:\Users\Arushi Arora\Desktop\data slum";
DATAFILE="filename"
<DBMS=EXCEL>
<OUT= ARUSHI.ANALYSIS>
<REPLACE>;


PROC IMPORT OUT = ANALYSIS
DATAFILE="C:\Users\Arushi Arora\Desktop\data slum\filename.xlsx"
DBMS=EXCELCS REPLACE;
RUN;

 

PROC IMPORT Datafile="C:\Users\Arushi Arora\Desktop\data slum\filename.xlsx"
DBMS=excelcs
OUT=ANALYSIS REPLACE;
Sheet="ARUSHI" ;
Run;

 

All these showed error.!!!!

HELP.


Accepted Solutions
Solution
‎06-12-2017 02:53 AM
PROC Star
Posts: 7,467

Re: Unable to import Excel file

Posted in reply to Arushiarora0

Try dbms=xlsx

 

Of course, it and all of the ones you tried assume that you license SAS/Access for PC File formats

 

Art, CEO, AnalystFinder.com

 

View solution in original post


All Replies
Solution
‎06-12-2017 02:53 AM
PROC Star
Posts: 7,467

Re: Unable to import Excel file

Posted in reply to Arushiarora0

Try dbms=xlsx

 

Of course, it and all of the ones you tried assume that you license SAS/Access for PC File formats

 

Art, CEO, AnalystFinder.com

 

Super User
Posts: 7,760

Re: Unable to import Excel file

[ Edited ]
Posted in reply to Arushiarora0

Arushiarora0 wrote:

Hi, I was unable to import an excel workbook with only one sheet into SAS 9.4.

 

I tried using the IMPORT/EXPORT option in the files and after inserting the file in the BROWSE option, I get a message, "failed. check log"

And the log says as follows.

 

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.


Most of the time, it's one of the two:

- ACCESS to PC Files is not licensed

- or the same was not (correctly) installed

Do

proc setinit;
run;

and post the resulting log.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 12

Re: Unable to import Excel file

Posted in reply to Arushiarora0

Thanks. The second code worked after changing the code with "xlsx"

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 316 views
  • 0 likes
  • 3 in conversation