LIBNAME AND XLSX

[Ihsan-Mahdi]

I got this error

ERROR: Connect: Class not registered

[Kurt_Bremser]

---

@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.

[Ihsan-Mahdi]

Shouldn't this affect all functions?! Why the EXCEL engine in particular?!!

[Kurt_Bremser]

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.

[Kurt_Bremser]

Completely overlooked your maintenance level. LIBNAME XLSX was introduced with ML2.

Have your SAS updated to current (ML7).

[Tom]

Update your SAS installation.  Your current version in almost 7 years old.

https://blogs.sas.com/content/iml/2013/08/02/how-old-is-your-version-of-sas-release-dates-for-sas-so...

Old          9.4m1    15Dec2013 13.1

[Ihsan-Mahdi]

Working on it, thanks!