07-09-2014 12:44 AM
Recently when I tried to import excel data by SAS Import Wizard, I found "Connection Failed" in the log. I have searched solutions from the SAS web and I knew that the problem might be due to the system platform migrated from Windows 7 in 32-bits running previously to 64-bit at present.
My SAS licence (SAS 9.2 TS Level 2M3, W32_VSPRO platform, Windows Version 6.1.7601) are valid for the following modules:
BASE Base SAS
PCFILE SAS/ACCESS PC Files
WKSPSRVLOCAL SAS Workspace Server for Local Access
Should I run sumu92_x64.exe downloaded from SAS Migration Procedure to migrate the SAS 32-bit to 64-bit in order to solve the problem. The SAS Migration procedures may be too difficult for me to understand. Please advise me the simplest and efficently steps to solve my problem.
Upgrading from SAS 9.2 to SAS 9.4
If you are running SAS 9.2, then you must apply the third maintenance release (TS2M3) for that platform before upgrading to SAS 9.4.
The following product must be at release 6.2 or later:
SAS Enterprise Miner
The following products must be at release 4.3 or later:
SAS BI Dashboard
SAS Information Delivery Portal
SAS Information Map Studio
SAS OLAP Cube Studio
SAS Web Report Studio
The following product must be at release 4.21_M2 or later:
SAS Data Integration Studio (This is the version that runs on SAS 9.2M3.)
The following products must be at release 4.2 or later:
SAS Add-In for Microsoft Office
SAS Enterprise Guide
After meeting these baseline requirements, you can use the automated SAS tools to move to SAS 9.4. If you use export/import facilities to export a selection of SAS 9.2 content to a new SAS 9.4 deployment (instead of using the automated SAS tools), then you must also meet these baseline requirements first. An alternative to applying the third maintenance release is to migrate from SAS 9.2 to SAS 9.3 and then to SAS 9.4.
Thank you in advance for your help.
07-09-2014 02:31 AM
This bitness error 32 64 bit is very well known. As SAS is using the ACE driver (comes with MS-office) you need to have that of the same bitness. Going for 64-bit SAS you will need 64-bit office.
This bitness issue partially can be overcome using the PC-files server in the bitness of MS-office. With this information you must be able to find a lot of hits and solutions.