DATA Step, Macro, Functions and more

Failed to connect to server

Reply
Contributor
Posts: 55

Failed to connect to server

 

Hi , i was trying to importing excel file from server, after running the below code - i got an Error message  

'ERROR: Failed to connect to the Server: \\11.12.10.122

 

code:

PROC IMPORT DBMS=EXCELCS OUT=WORK.demo
DATAFILE="mydrive:\\11.12.10.122\BM SAS Excel \Client_2017_06_29_040011.xlsx";
server= '\\11.12.10.122\BM SAS Excel \';
PORT= 7156;
SHEET='ClientAccountnotComplete';
RUN;

 

Error Message:

 

ERROR: Failed to connect to the Server: \\11.12.10.122\BM SAS Excel \.

 

please help me to fix this error.

 

Thanks and Regards,

Siva

 

Super User
Posts: 6,938

Re: Failed to connect to server

I guess you want to connect to a PC Files server?

For server, supply just the hostname or the IP address, but not a path.

For datafile, supply the path to the file, without the server name or protocol.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 142 views
  • 1 like
  • 2 in conversation