Help using Base SAS procedures

SAS to FTP - error

Reply
Contributor
Posts: 24

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,255

Re: SAS to FTP - error

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: 24

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: 6,499

Re: SAS to FTP - error

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
  • 295 views
  • 3 likes
  • 3 in conversation