I recently purchased a new computer which lead to a new install for SAS and Microsoft Office. When trying to use the import wizard, I get the following error: SAS/STAT 14.1 SAS/ETS 14.1 SAS/OR 14.1 SAS/IML 14.1 SAS/QC 14.1 NOTE: Additional host information: X64_8PRO WIN 6.2.9200 Workstation NOTE: SAS initialization used: real time 1.59 seconds cpu time 1.14 seconds ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. NOTE: Import Cancelled. I googled the error and found multiple articles saying that this was due to a problem with Office being 32-bit and SAS and Windows being 64-bit. I uninstalled Office and reinstalled a 64-bit version of Office. Unfortunately this didn't fix the error. I thought that maybe it had to do with the fact that the excel files I was trying to upload were originally saved using a 32-bit office package. As such, I created new excel files but it still doesn't work. I also trying saving the files as a regular xls file instead od xlsx but this also failed. Please help!
... View more