Optimize IT resource capacity and performance with SAS

Problem with creating Excel library

Reply
Super Contributor
Posts: 258

Problem with creating Excel library

Hi I m getting error while creating library using excel engine.

I am  using SAS 9.3

my code

libname abc Excel "c:\anuj\test.xls";

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

i have install both file from link:

http://support.sas.com/downloads/package.htm?pid=893#

problem still has not been resolved.

Kindly suggest

Esteemed Advisor
Posts: 5,995

Re: Problem with creating Excel library

Looks like the typical bitness problem. Try using the PC Files Server.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Respected Advisor
Posts: 2,919

Re: Problem with creating Excel library

While you have installed the PC File Server you are not using the correct LIBNAME to use it as described in this link:

43802 - Installing SAS® 9.3 PC Files Server and using it to convert 32-bit Microsoft Office files to...

For example: libname test pcfiles path='drive:\yourdirectory\yourfile.xls' server='yourserver' port=9621;

Super Contributor
Posts: 258

Re: Problem with creating Excel library

Priviously i was using 9.2 where simple i run my codes with using -libname xyz EXCEL "Path" now i m using 9.3 and getting error please suggest

Post a Question
Discussion Stats
  • 3 replies
  • 469 views
  • 0 likes
  • 3 in conversation