BookmarkSubscribeRSS Feed
Aman4SAS
Obsidian | Level 7

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

3 REPLIES 3
SASKiwi
PROC Star

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;

Aman4SAS
Obsidian | Level 7

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

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