I'm not sure this is the right place but perhaps the right place can be pointed out.
Here's the problem. I have a win10 machine, sas9.4, and Office2019, all are 64 bit. I want read excel97 data files and i get an error:
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
See attached file for complete syntax. A co-worker googled something related to the "ERROR: Connect ..." statement and found this website
https://support.sas.com/kb/43/933.html
This link references sas 9.3 and Office 2010, 2013, and 2016.
Is this information current with respect to my machine and installed software?
@emaguin - Please mark your post as answered in that case.
I believe the EXCEL dbms can only handle XLSX files. Try the XLS dbms.
Respectfully, I converted an xls file to xlsx using Office 2019 and the described syntax would not read the xlsx file. And, where would a person find an installable version of excel 97 that would run on a win10 x64 machine. The alternative is to open and resave the files as csv, but we have, I guess, 3 waves * 4 respondents * 3 interview parts * 15 xls files per part.
Did you try using DBMS=XLS instead of DBMS=EXCEL?
I have no issues importing excel97 file. Instead of libname, use filename to point to the file
FILENAME dat '~/dat/class.xls';
PROC IMPORT DATAFILE=dat
DBMS=XLS replace
OUT=WORK.IMPORT;
GETNAMES=YES;
SHEET="All Students"n;
RUN;
n follows a non-standard file name or worksheet name, for example where there are embedded spaces. It should be inside the semi-colon not outside. Yours has none so it's not needed
Try running my code with the same options. Then check the whether you other options are applicable in the xls engine (perhaps Excel has been deprecated, it does not work in SAS UE)
Please post your code (not as a log) and a sample of your data (dummy it up if confidential).
SCANTEXT, USEDATE and SCANTIME are not valid statements when you use DBMS = XLS.
Check this link for the valid statements and options.
@emaguin - Please mark your post as answered in that case.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.