sas 9.2 server error in libname excelcs

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

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!

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：libname Server Error Serve EXCEL procedure message server cannot engine

When you specify dbms=excelcs in proc import, the procedure actually uses the PCFILES LIBNAME engine.
Hence, when you try to use LIBNAME statement, you should use the engine name PCFILES like this:

LIBNAME aa PCFILES PATH='...\aa.xls';

Also remember to use path=, it can't be omitted.