Cannot import excel to SAS

[Ecolife]

Hi,

This is Kelly and is my first time to post my question here...

The problem is that I couldn't import my excel to SAS...and I have checked the version of excel and it is excel 2016 64bit(office 365) and my PC is also X64 processor.

The error still shows:" Connect: Class not registered. Error in the LIBNAME statement." after I tried most solutions...including installing PC server and SAS re-installation. 

I have done the flowchart for troubleshooting: http://support.sas.com/kb/60/356.html#mdd-connect, and it says I should consult the technical support. Is there any further instruction for solving this problem? Or where should I ask for help? 

[Vish33]

Hi Kelly,

Can you please post the code that you used for importing excel file.

[Ecolife]

PROC IMPORT DATAFILE="d:\icd9.xlsx"
     DBMS=EXCELCS
     OUT=WORK.test REPLACE;
RUN;

I have tried EXCELCS and EXCEL but there are in the same result.

[Vish33 · Accepted solution]

have you tried with XLS or XLSX Replace options.

[Ecolife]

Thanks for your great help! It works since I changed DBMS=excel to xlsx... However, I still can't use import wizard to import my excel data...It seems that I should import them manually QQ

[Vish33]

You are welcome!  code always should work across versions. Is importing through wizard is failing? in that case we have to see the excel versions its supporting through  wizard.

[Ecolife]

It still doesn't work with the import wizard. My SAS version is 9.4, and my excel version is 64-bit 2016 office365(provided from my school...)

[emrancaan]

options validvarname=any;
proc import out = multi 
	datafile = "test.xlsx" 
	dbms = xlsx  
	replace;    
	getnames = Yes; 
run;

[Ecolife]

It's also a great solution. Thanks a lot!