- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
have you tried with XLS or XLSX Replace options.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Can you please post the code that you used for importing excel file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
have you tried with XLS or XLSX Replace options.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
options validvarname=any;
proc import out = multi
datafile = "test.xlsx"
dbms = xlsx
replace;
getnames = Yes;
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content