Hi All
I have gone through couple of blogs on the same error, I have tried all the suggested options and posting my issue.
#1. While trying to export xls file using DBMS=EXCEL option in the below code :
PROC EXPORT DATA= WORK.soma
OUTFILE= "C:\User\app-502396530\Documents\My SAS Files\test1.xls"
DBMS=EXCEL REPLACE;
SHEET="Historical INFO";
RUN;
ERROR:Connect: Class not registered
ERROR: Error in the libname statement.
If I use DBMS=EXCELCS, I get an error saying
ERROR: Failed to connect to server.
#2. While trying to export csv file using the below code, the code gets executed without errors and the log
says that file SUCCESSFULLY created, But I am unable to see the created file at the location(mentioned in the code):
PROC EXPORT DATA= WORK.segments_final
OUTFILE= "C:\User\app-502396530\Documents\My SAS Files\test1.csv"
DBMS=CSV REPLACE;
RUN;
To use EXCELCS you need to have the PC Files Server installed on your SAS for Windows server, or on another dedicated node. With SAS for Windows, installing the PC Files Server is easy and SAS can launch it via "autostart", no additional configuration required.
However, it's even easier if you can use DBMS=XLSX.
Chris
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.