SAS to FTP - error

[stuart_snap]

Hello fellow coders!

I am getting a very basic error trying to read a text file from a FTP server.  The error says that "The connection has timed out..", which I believe basically means it is not connecting at all.  Below is the code I am using to login (with fake login credentials).  The connection works fine using any number of FTP clients. I have tried it in EG and BASE... same error in both.  Any suggestions?

filename myfile ftp 'TEST.txt' cd='/Incoming folder/'

                            user='me1234 pass='passpass' host='sftp.randomcomp.com';

I assume I am missing something simple... but I have tried various things. 

[LinusH]

Your remote host is called sftp. Is it by any chance requiring a sftp connection? Perhaps try the sftp access method instead?

[stuart_snap]

Well, I feel dumb.  Thanks for pointing that out, Linus!

It seems like the SFTP process doesn't have a password option.  Are you familiar with the SFTP process?  I think I am missing a step.

[Tom]

Get it to work from command line on your SAS host system first.  What I have found is that if I save the key into a file then I use the IdentityFile option.

filename myfile ftp 'TEST.txt' cd='/Incoming folder/'

                            user='me1234 pass='passpass' host='sftp.randomcomp.com'

  options='-o IdentityFile=~/.ssh/me1234.txt'

;