topic Re: SAS PC File Formats | Error importing or exporting from network in SAS Programming

SAS PC File Formats | Error importing or exporting from network

MariaD — Tue, 22 Sep 2020 12:43:10 GMT

Hi folks,

Our users have SAS PC File Server installed on their computers. The SAS PC File Server is started automatically as a service. Our SAS Server is Linux on 9.4M5.

We don't have any problem importing or exporting to local drive, the user and password information in this case is not required.

But if the user tried to import or export over the network the following error appears:

proc import file="\\network\directory\File.xlsx" 
     out=class
     DBMS=EXCELCS REPLACE;
     PORT=9621 ;
     SERVER="my-computer-name";   
run;

ERROR: Unable to open file \\network\directory\File.xlsx. It does not  exist or it is already opened exclusively by another user, or you need permission to view its data.

If we add user and password information, even if we add domain on user name, the following error appears:

proc import file="\\network\directory\File.xlsx" 
     out=class
     DBMS=EXCELCS REPLACE;
     PORT=9621 ;
     SERVER="my-computer-name"; 
	 SERVERUID="my.user";
     serverpass="{sas002}FF5BB7293C5BE73F1BF62E514719C47C138D163D42D54M38"; 
run;

ERROR: Server is unable to authenticate user credentials. (missing or invalid SERVERUSER='<domain\username>'; SERVERPASS='<password>'; enclosed in quotes).

Any idea?

Regards,

Re: SAS PC File Formats | Error importing or exporting from network

CurtisMackWSIPP — Tue, 22 Sep 2020 14:11:44 GMT

Can the users save a file to that path using Excel? Also, does the account under which is the PC File Server service is running have the needed permissions?

Re: SAS PC File Formats | Error importing or exporting from network

MariaD — Tue, 22 Sep 2020 14:16:36 GMT

Thanks folks! We reconfigure the SAS PC File Server and now it's working.

Re: SAS PC File Formats | Error importing or exporting from network

Tom — Tue, 22 Sep 2020 14:32:05 GMT

Can you explain what part of the configuration needed to be changed to fix the issue? It might help others in the future that have similar issues.

Re: SAS PC File Formats | Error importing or exporting from network

MariaD — Tue, 22 Sep 2020 15:59:21 GMT

Hi, @Tom

In fact, our service desk uninstall and install it again.

Regards,