Help using Base SAS procedures

SAS to FTP - error

Reply
Contributor
Posts: 31

SAS to FTP - error

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. 

Super User
Posts: 5,424

Re: SAS to FTP - error

Posted in reply to stuart_snap

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

Data never sleeps
Contributor
Posts: 31

Re: SAS to FTP - error

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.

Super User
Super User
Posts: 7,039

Re: SAS to FTP - error

Posted in reply to stuart_snap

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'

;

Ask a Question
Discussion stats
  • 3 replies
  • 308 views
  • 3 likes
  • 3 in conversation