On a new install, PROC IMPORT and EXPORT are not working for xlsx files. Both SAS and MS Office are 64-bit. These PROCs work on two other computers I have. Running it on my new computer (details below) results in the following errors: ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement. The procedure code is basic: proc import datafile='C\Sample Data\xlsx data.xlsx' out=data1; run; I recently installed SAS 9.4 on a Microsoft Surface Book running Windows 10. The installed modules/versions are Base SAS 9.4_M3, SAS_STAT 14.1, SAS_GRAPH 9.4_M3, High Performance Suite 2.2_M4, and SAS/ACCESS to PC Files 9.4_M3. Both SAS 9.4 and Microsoft Office are 64-bit installations. The code above works on the other two computers on which I have run SAS 9.4. I haven't been able to determine what is different in the new setup that is causing the errors, unless it is simply Windows 10 (Surface book, doesn't work) versus Windows 7 (other 2 computers, works). But I haven't found any reported issues for importing xlsx files on Windows 10. I currently have SAS 9.4 on a Dell PC running Windows 7 (separate employer, separate SAS license). Before I switched to the Surface Book I had an HP PC also running Windows 7. Both of these computers had 64-bit SAS and 64-bit office, and PROC IMPORT and PROC EXPORT both worked with xlsx files. I don't have the exact version details for these two computers right now (both are SAS 9.4), but I can get it if it will be helpful. Any thoughts on what the problem might be?
... View more