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?
have you tried with XLS or XLSX Replace options.
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.
have you tried with XLS or XLSX Replace options.
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.
options validvarname=any;
proc import out = multi
datafile = "test.xlsx"
dbms = xlsx
replace;
getnames = Yes;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.