Architecting, installing and maintaining your SAS environment

Problem with creating Excel library

Reply
Super Contributor
Posts: 266

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

Super User
Posts: 7,854

Re: Problem with creating Excel library

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 3,260

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: 266

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

Ask a Question
Discussion stats
  • 3 replies
  • 598 views
  • 0 likes
  • 3 in conversation