Tag Archives: Sas

Solutions to problems in SAS 9.3 x64 importing and exporting Excel

From http://bbs.pinggu.org/thread-1191302-3-1.html

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