topic Re: Export SAS data to Excel in ODS and Base Reporting

Export SAS data to Excel

PhanS — Mon, 04 Dec 2017 00:50:04 GMT

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.

Re: Export SAS data to Excel

Tom — Mon, 04 Dec 2017 01:23:29 GMT

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;

Re: Export SAS data to Excel

Kurt_Bremser — Mon, 04 Dec 2017 07:23:41 GMT

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

Re: Export SAS data to Excel

Reeza — Mon, 04 Dec 2017 15:54:44 GMT

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;

Re: Export SAS data to Excel

ballardw — Mon, 04 Dec 2017 16:43:34 GMT

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

Re: Export SAS data to Excel

PhanS — Tue, 05 Dec 2017 01:01:15 GMT

Hi Reeza,

Thanks you for your help. It worked out.

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

Phan S.

Re: Export SAS data to Excel

PhanS — Tue, 05 Dec 2017 01:03:23 GMT

Hi Tom,

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

I just posted my comment.

Phan S.

Re: Export SAS data to Excel

PhanS — Tue, 05 Dec 2017 01:07:21 GMT

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.