sas 9.2 server error in libname excelcs

Reply
New Contributor
Posts: 3

sas 9.2 server error in libname excelcs

I am using sas 9.2 server (os is 64bit) to import the excel file (.xlsx format)

When I use the import procedure, it works,

PROC IMPORT OUT= WORK.aa

            DATAFILE= "...\aa.xlsx"

            DBMS=EXCELCS REPLACE;

     RANGE="Sheet1$";

     SCANTEXT=YES;

     USEDATE=YES;

     SCANTIME=YES;

RUN;

But when I use the libname statement, I get the error message as below,

libname aa excelcs "...\aa.xlsx";

ERROR: The EXCELCS engine cannot be found.

ERROR: Error in the LIBNAME statement.

Could someone help me to solve the issue? Thank!

Super Contributor
Posts: 282

Re: sas 9.2 server error in libname excelcs

Hi,

Does the following SAS Note apply?:

33228 - An error occurs when you use SAS® 9.2 to import or export Microsoft Excel or Access files in...

A similar issue also appears to be referred to later on in:

https://communities.sas.com/thread/33950

Regards,

Amir.

New Contributor
Posts: 3

Re: sas 9.2 server error in libname excelcs

Thanks Amir,

I got the point and it should

libname aa pcfiles path="XXX\aa.xlsx";

Ask a Question
Discussion stats
  • 2 replies
  • 270 views
  • 1 like
  • 2 in conversation