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
... View more