topic Re: Proc export xlsx not working sometimes in New SAS User

Proc export xlsx not working sometimes

ashlyn — Thu, 03 Oct 2019 06:54:28 GMT

Hi, I have been troubling over a set of proc export codes which works perfectly fine sometimes but fails sometimes too even though it is the exact same codes.

proc export data=myoutput
outfile='/idn/home/myfolder/myoutput.xlsx'
dbms=xlsx
replace;
run;

I ran some checks using "proc setinit;run;" and found out that "SAS/ACCESS Interface to PC Files" is the issue.

When export fails, I checked and "SAS/ACCESS Interface to PC Files" is not in my SAS system. My only solution is to restart my computer and "SAS/ACCESS Interface to PC Files" appears again.

Does anyone know why "SAS/ACCESS Interface to PC Files" is missing from my SAS system sometimes?

Thanks!

Re: Proc export xlsx not working sometimes

Kurt_Bremser — Thu, 03 Oct 2019 07:26:12 GMT

How do you use SAS?

Local with Display Manager
Local with Enterprise Guide
Remote with Enterprise Guide
Remote with SAS Studio
Remote login and Display Manager
University Edition (cloud)
University Edition in local virtual machine
On Demand for Academics

Re: Proc export xlsx not working sometimes

ashlyn — Thu, 03 Oct 2019 07:42:00 GMT

Hi KurtBremser, I use Remote with Enterprise Guide

Re: Proc export xlsx not working sometimes

Kurt_Bremser — Thu, 03 Oct 2019 07:47:59 GMT

Then check the server connection when it works and when it fails. If you have multiple servers in the server list, make sure you always use the same.

In the server list, right-click on the server and select Properties; record the host name and port number for reference.

It might be you have a grid installation, and one of the grid servers is misconfigured. Or some other peculiarity in the setup. Once you have the information, get in touch with your SAS admin.

Re: Proc export xlsx not working sometimes

SASKiwi — Thu, 03 Oct 2019 07:52:35 GMT

The only scenario I can think of that might explain this strange behaviour is you are connecting to a SAS grid where the server nodes have inconsistent SAS licences. Check with your SAS administrator regarding your problem.

Re: Proc export xlsx not working sometimes

ashlyn — Thu, 03 Oct 2019 08:34:10 GMT

Thanks @Kurt_Bremser! I checked both server properties and I definitely see some peculiarity. I will contact my SAS Admin.

Re: Proc export xlsx not working sometimes

ashlyn — Thu, 03 Oct 2019 08:35:07 GMT

Thanks @SASKiwi! I spotted the inconsistent licences. I will check with my SAS Admin.