SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
MariaD
Barite | Level 11

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, 

1 ACCEPTED SOLUTION

Accepted Solutions
MariaD
Barite | Level 11

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

 

View solution in original post

4 REPLIES 4
CurtisMackWSIPP
Lapis Lazuli | Level 10

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?

MariaD
Barite | Level 11

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

 

Tom
Super User Tom
Super User

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.

MariaD
Barite | Level 11

Hi, @Tom 

 

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

 

Regards, 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 925 views
  • 1 like
  • 3 in conversation