topic Re: SFTP doesn't find the file in SAS Programming

SFTP doesn't find the file

Rakeon — Tue, 09 Oct 2018 15:36:23 GMT

Hi to all,

I need to use the SFTP protocol with SAS.

the sftp works with linux command by mobaxterm terminal.

But when I use the SFTP by libname of SAS, it doesn't work, because it doesn't find the file or directory which I have to download in my host.

filename tmep sftp ''
host="" 
user=""

optionsx="" 
lsa
lsfile=''

;



data aaa_;
length a $ 32767;
infile tmep truncover;
input a ;
run;

It say the directory or file doesn't exist.

what can I do?

is there some option to help me which path define the filename?

The system is linux that call sftp in another machine of linux.

Re: SFTP doesn't find the file

Kurt_Bremser — Tue, 09 Oct 2018 15:42:36 GMT

Do you have password-less authentication in sftp set up?

Meaning that

sftp user@host

gets you connected automatically without a further prompt?

Re: SFTP doesn't find the file

Rakeon — Tue, 09 Oct 2018 16:54:02 GMT

Yes, there is the password with the terminal Mobaxterm. But in the libname statement, when i put the pass option i get the error of invalid filename. Meanwhile In the optionsx we use the public key.

is there a way to set-up the password in sftp filename?

Re: SFTP doesn't find the file

Kurt_Bremser — Tue, 09 Oct 2018 17:44:10 GMT

You need to setup authentication in sftp with a private/public key pair. Only when you can use sftp without having to enter a password, you can use it from SAS.

Re: SFTP doesn't find the file

Rakeon — Wed, 10 Oct 2018 10:26:36 GMT

Kurt, thanks for your advice...it help us so much for improving.
The mainly problem was that we haven't access priority in that path of SFTP. we asked to define another path for SFTP.