Hi I m getting error while creating library using excel engine.
I am using SAS 9.3
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:
problem still has not been resolved.
Looks like the typical bitness problem. Try using the PC Files Server.
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;
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
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.