SAS 9.3 x64 import and export Excel problems solution
you should use BBS search, actually has given a solution in the following link
http://bbs.pinggu.org/forum.php?mod=redirect& goto=findpost& ptid=1417110& pid=12754566& from^^uid=50
http://bbs.pinggu.org/forum.php?mod=redirect& goto=findpost& ptid=1417110& pid=12754704& From ^^uid=50
actually, the problem is SAS x64 version (including 9.2 and 9.3), which is not the case in SAS 9.3 x86.
SAS9.3 64 software cannot import Excel file, is the cause of import SAS software like Microsoft Office software of Excel and Access files,
is use Microsoft company provides data interface engine (Access database engine), if the Office software installation, data interface engine
will be installed at the same time, but is generally installed the 32-bit data interface engine, SAS software for 64, The Proc import program cannot borrow the 32-bit data interface engine of
Office, so it cannot import Excel and Access files. The following error occurs:
Error: Connect: Class not registered
Error: Error in the Libname statement
the solution is to download the Accessdatabaseengine_x64 program provided by Microsoft. The download address is as follows:
http://www.microsoft.com/zh-cn/download/details.aspx?Id =13255
if it cannot be installed after downloading, it is because the 32-bit Accessdatabaseengine is already installed on this machine and should be uninstalled before installing.
problem solution, see the SAS online support document:
http://support.sas.com/kb/37/412.html
Read More:
- Methods of exporting configuration and importing configuration in IntelliJ idea
- Solutions to Excel 2007 “cannot shift object off sheet”
- Problems and solutions of installing Ubuntu 12.04 in win7
- Solutions to network connection problems in Ubuntu 16.04.3
- Solutions to some problems encountered in programming with vs2017
- Problems and solutions in using Linux
- Solutions to the failure of importing Python 3.7 SSL module
- Call Excel to report an error (the exception comes from HResult: 0x80010105 (RPC)_ SERVERFAULT))
- Server configuration excel export HResult: 0x800A03EC
- Problems and solutions of error reporting in using swiper in Vue
- [Python] pandas Library pd.to_ Parameter arrangement and example of Excel operation writing into excel file
- Problems in compiling VTK with cmake: solutions to error configuration process, project files may be invalid
- Creating Server TCP listening socket 127.0.0.1:6379: bind: No error。。。 Solutions to problems encountered in startup
- Problems and solutions in learning opengl
- Write about the problems and solutions when configuring OpenGL in vs2015
- To solve the problem of C # calling excel interface error, prompt: the COM object of Microsoft. Office. Interop. Excel. Applicationclass is forcibly converted to the interface type “Microsoft. Offi”
- Possible causes and solutions of 404 problems in accessing servlet pages
- Some problems and solutions in learning opengl in vs2017
- XLRDError: Excel xlsx file; Not supported error reporting solutions
- Solutions to problems encountered when installing isc-dhcp-server on debian9.6