Hi,
when I try to import an Excel file I get the error:
PROC IMPORT datafile="C:\temp\test.xlsx"
OUT=test
DBMS=EXCEL REPLACE;
RUN;
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
SAS: 9.4 64bit
Office: 2016 32bit
PC file server: already installed
Have you got any advice?
Thanks
Simone
If you have local SAS installations, then the installation on that PC is defective or has a different license/productstatus.
I would STRONGLY recommend to get rid of the local installations and switch to a central SAS server. Usually reduces license costs, but is guaranteed to reduce administrative cost (see your current issue).
ACCESS to PC Files is not installed and/or not licensed.
Run proc product_status and proc setinit.
Hi,
in the setinit log I've the line:
---SAS/ACCESS Interface to PC Files
If I look at the Windows Services, PC File Server is running.
I've another machine with the same configuration, when i Run the proc import I don't get any error.
That's very strange
Check out the user manual:
If you are using libname to excel then it is excel, otherwise in proc import it should be xlsx.
Try that.
I have hundreds of program importing Excel files (using the proc import above), different user run them on different machine.
I've this kind of problem with just one PC.
If you have local SAS installations, then the installation on that PC is defective or has a different license/productstatus.
I would STRONGLY recommend to get rid of the local installations and switch to a central SAS server. Usually reduces license costs, but is guaranteed to reduce administrative cost (see your current issue).
Using the PC Files Server requires dbms=excelcs and supplying the server name.
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!