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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.