Hi Everyone,
I tried to export SAS data to Excel, used file, export...
Here is the log showed:
Error: Connect: Class not registered
Error: Error in the libname statement
My SAS is 9.4 64 bit and Excel is 64 bit.
Before this, I had the same message in SAS log, when I exported to Excel 32 bit.
Hopefully, someone can help. Thank you.
Phan S.
Did you try DBMS=XLSX, you should include your code and log.
proc export data=sashelp.class outfile='/folders/myfolders/temp.xslx' dbms=xlsx replace ; run;
Not sure what why you are still having issues with using PROC EXPORT. You probably should contact SAS support.
But why not just avoid the whole issue and use the XLSX engine instead? That way you are avoiding trying to get Excel software to run at all.
libname out xlsx 'filename of excel file.xlsx';
data out.mysheet ;
set mydataset;
run;
libname out close;
Hi Tom,
Thanks you. I tried with your code but it appears not work.
I just posted my comment.
Phan S.
Check if SAS/ACCESS to PC Files is installed and licensed.
Hello Kurt,
The software has an up-to-date licence and 64 bit.
I used proc export as provided by Reeze -- it worked.
This method appears not work: File, export, library/member,...
Thanks you.
Phan S.
Did you try DBMS=XLSX, you should include your code and log.
proc export data=sashelp.class outfile='/folders/myfolders/temp.xslx' dbms=xlsx replace ; run;
Hi Reeza,
Thanks you for your help. It worked out.
However, this method appears not work: File, export, library/Member ...
Phan S.
@PhanS wrote:
Hi Everyone,
I tried to export SAS data to Excel, used file, export...
Here is the log showed:
Error: Connect: Class not registered
Error: Error in the libname statement
My SAS is 9.4 64 bit and Excel is 64 bit.
Before this, I had the same message in SAS log, when I exported to Excel 32 bit.
Hopefully, someone can help. Thank you.
Phan S.
Show the code and entire log for the export attempted. Sometimes you get the "class not registered" because a previous statement does not end in a semicolon and SAS is trying to treat a line of code as an option not valid on the previous line.
Since this is coupled with an "Error in the libname statement" it may be that the lines before the Libname statement is the cause.
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.