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,
Thanks folks! We reconfigure the SAS PC File Server and now it's working.
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?
Thanks folks! We reconfigure the SAS PC File Server and now it's working.
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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.