SAS EG | Exporting using PCFF

[MariaD]

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, 

[tomrvincent]

Any success with other dbms values?

[MariaD]

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

[SASKiwi]

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.

[MariaD · Accepted solution]

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,

[SASKiwi]

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. 

[MariaD]

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,

[SASKiwi]

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