topic Re: The problem that Excel cannot import SAS with parameters in SAS Enterprise Guide

The problem that Excel cannot import SAS with parameters

jiashenke — Fri, 21 Dec 2018 06:02:21 GMT

SAS Server Server Server Server Operating System (Windows 2012)

SASServer software

SASEG Client Operating System (Windows 10)

SASEG software

Office 2013 or Office 2016

Access Database Engine (Excel ODBC Driver)

The following statement can be used to import Excel files into SAS, which is completely imported without parameters.

libname DDTWB XLSX "\\192.168.10.211\SASDocs\Test\HTST00003\Docs\SP\SDTM\HPR SP-001-T04-I Data Mapping Tool_HTST00003.xlsx" ;

Figure 1

The following statement can be used to import Excel file into SAS, then show Class not Registered, which calls Access Database Engine, the driver of Excel ODBC.

libname DDTWB EXECL“\\192.168.10.211\SASDocs\Test\HTST00003\Docs\SP\SDTM\HPR SP-001-T04-I Data Mapping Tool_HTST00003.xlsx" mixed=yes dbmax_text=23767 header=no;

Figure 2

Re: The problem that Excel cannot import SAS with parameters

Kurt_Bremser — Fri, 21 Dec 2018 09:16:23 GMT

Please copy/paste both logs as they are into windows opened with the {i} button. The contents of your pdf do not correlate (completely) with what you posted.

Re: The problem that Excel cannot import SAS with parameters

SASKiwi — Sat, 22 Dec 2018 21:24:33 GMT

Your class not registered error is most likely due to 64-SAS trying to communicate with 32-bit MS Office. This can be solved by downloading the MS Office 64-bit JET engine from the Microsoft website.

Why do you need to use the EXCEL engine when the XLSX engine successfully assigns?

Re: The problem that Excel cannot import SAS with parameters

jiashenke — Fri, 28 Dec 2018 00:52:02 GMT

Thank you very much！I'll collect it and send it to you later.

Re: The problem that Excel cannot import SAS with parameters

jiashenke — Fri, 28 Dec 2018 00:53:05 GMT

Thank you! I'll test it later.