topic Re: SAS EG | Exporting using PCFF in SAS Enterprise Guide

SAS EG | Exporting using PCFF

MariaD — Wed, 31 Oct 2018 18:21:07 GMT

Hi Folks,

We are using SAS PCFF to export to local disk in SAS EG. We use a code like below:

proc export data=sashelp.class

dbms=ACCESSCS

outtable="Class" replace;

database="C:\temp\Test.accdb";

server="xx.xx.xx.xx";

port=9621;

run;

If we export to local disk, C or D, the codes execute fine. But if we replace to network drive (\\computer\folder or Z:\folder) the following error appear:

ERROR: Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 1.23 seconds
cpu time 0.01 seconds

Of course the user has permission to write in the network drive. There is any limitations to export to network drive (mapped or not)?

Regards,

Re: SAS EG | Exporting using PCFF

tomrvincent — Wed, 31 Oct 2018 18:53:53 GMT

Any success with other dbms values?

Re: SAS EG | Exporting using PCFF

MariaD — Wed, 31 Oct 2018 19:04:13 GMT

Hi @tomrvincent, you mean Excel for example? We don't tried but I'll test and let you know.

Re: SAS EG | Exporting using PCFF

SASKiwi — Wed, 31 Oct 2018 21:02:00 GMT

Try remotely logging onto your PCFF file server and try the UNC file path in Windows Explorer on that server. If it doesn't work there it won't work from SAS and you will need an IT administrator to sort it. Possibly firewall rules might be getting in the way.

Re: SAS EG | Exporting using PCFF

MariaD — Wed, 31 Oct 2018 21:36:10 GMT

Hi @SASKiwi,

We open the windows explorer on PCFF's machine and we can access the network drive without any problem, using "\\ machine \ folder" or "Z: \ folder". Do you think could be a permission problem to access network drive? Would be better to add the SERVERUSER and SERVERPASS options on PROC IMPORT?

Regards,

Re: SAS EG | Exporting using PCFF

SASKiwi — Wed, 31 Oct 2018 21:54:21 GMT

Yes, it does look like a permissions-type problem. There is no harm in trying the SERVERUSER and SERVERPASS options to see if it fixes the problem. I'm wondering if there is a problem with permissions delegation which might require Kerberos settings changed.

Re: SAS EG | Exporting using PCFF

MariaD — Tue, 06 Nov 2018 21:29:27 GMT

Hi @SASKiwi,

In fact, SERVERUSER and SERVERPASS does not resolved the problem. Could you please inform me how to change Kerberos settings? We use Unix user and password to connect to metadata on SAS EG.

Regards,

Re: SAS EG | Exporting using PCFF

SASKiwi — Wed, 07 Nov 2018 00:52:23 GMT

Kerberos settings are very site-specific. I suggest you ask one of your IT administrators who is familiar with this.