I got this error
ERROR: Connect: Class not registered
@Ihsan-Mahdi wrote:
I got this error
ERROR: Connect: Class not registered
That points to a bitness (32/64) mismatch between SAS and your MS Office.
The older, Windows-only interfaces to MS Office files depend on MS JET or ACE modules, which need to be in the same bitness as SAS to work. So if you have 32 bit Office installed and 64 bit SAS, SAS will try to load the classes from the 64 bit environment, where they can't be found.
The newer DBMS=XLSX works with native SAS code and does not need any external software. XLSX are compressed XML, so it needs a ZIP engine (already present in SAS) and a XML engine (dito). It's just that LIBNAME XLSX came a little later.
Completely overlooked your maintenance level. LIBNAME XLSX was introduced with ML2.
Have your SAS updated to current (ML7).
Update your SAS installation. Your current version in almost 7 years old.
Old 9.4m1 15Dec2013 13.1
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.