topic SAS to FTP - error in SAS Procedures

SAS to FTP - error

stuart_snap — Tue, 21 Jul 2015 17:07:08 GMT

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.

Re: SAS to FTP - error

LinusH — Tue, 21 Jul 2015 17:14:00 GMT

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

Re: SAS to FTP - error

stuart_snap — Tue, 21 Jul 2015 19:14:57 GMT

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.

Re: SAS to FTP - error

Tom — Tue, 21 Jul 2015 19:47:10 GMT

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'

;