topic Re: FTP code not working in SAS Programming

FTP code not working

mariajriv01 — Mon, 05 Oct 2020 15:24:48 GMT

I'm running the following code without success:

filename

dir

ftp ''

host='xxxxxx'

user='xxxxxx'

pass=xxxxxx

prompt;

data _null_;

infile dir;

input;

put _INFILE_;

run;

I'm getting the following error:

ERROR: Open failed for file DIR

ERROR: The connection has timed out..

NOTE: The SAS System stopped processing this step because of errors.

Does anybody have any idea of what could be the problem?

Thanks!

Re: FTP code not working

Tom — Mon, 05 Oct 2020 15:33:14 GMT

What messages do you see in the log from the FTP engine? You can add the DEBUG option to the FILENAME statement and the FTP engine will display more information about its attempt to connect to that server.

Re: FTP code not working

mariajriv01 — Mon, 05 Oct 2020 15:41:47 GMT

Yes, I added the debug but the log dind't change. All I'm getting is the same 2 error lines.

Re: FTP code not working

Kurt_Bremser — Mon, 05 Oct 2020 15:48:21 GMT

Make sure that there is a FTP service active on the destination. Since FTP does not encrypt anything, it is no longer used for anything that requires authentication. Instead the SFTP/SSH protocol is used.