Export SAS data to Excel

[PhanS]

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.  

[Tom]

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;

[PhanS]

Hi Tom,

Thanks you. I tried with your code but it appears not work.

I just posted my comment.

Phan S. 

[Kurt_Bremser]

Check if SAS/ACCESS to PC Files is installed and licensed.

[PhanS]

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.

[Reeza · Accepted solution]

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;

[PhanS]

Hi Reeza,

Thanks you for your help. It worked out.

However, this method appears not work: File, export, library/Member ... 

Phan S.

[ballardw]

---

@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.