topic Re: Getting an error when exporting to Excel with Libname in Microsoft Integration with SAS

Getting an error when exporting to Excel with Libname

jtuck — Fri, 13 Apr 2018 16:49:23 GMT

Hi everyone,

I'm trying to move my team away from using DDE to populate excel reports to using libname. Most of our code uses rsubmit and that works fine, but when I try to get to do the same thing without rsubmit I get an error.

IE, this works:

rsubmit;
libname xl xlsx '\filepath\filename.xlsx';

data xl.exampledataset1;
set exampledataset1;
run;

endrsubmit;

This does not:

libname xl xlsx '\filepath\filename.xlsx';

data xl.exampledataset1;
set servwork.exampledataset1;
run;

It throws this error:

ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.

Browsing suggests it's something to do with 64bit SAS vs 32bit Excel, but I would have thought our server was running the same version of SAS, Not sure how to confirm that though.

Thanks,

James

Re: Getting an error when exporting to Excel with Libname

kishangabani — Fri, 13 Apr 2018 19:53:46 GMT

Check your SET statement, library is wrong.

TRY:

SET xl.exampledataset1;

Re: Getting an error when exporting to Excel with Libname

Reeza — Sat, 14 Apr 2018 19:06:52 GMT

It sounds more like a versioning issue. If it's a version issue, the file gets created and then you get an error when trying to open the file.

You can check the version with the following to see if you have the same on your server and/or desktop. It's common to have different versions unfortunately.

rsubmit;

    proc product_status;
   run;

endrsubmit;

proc product_status;
run;