- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Do you have password-less authentication in sftp set up?
Meaning that
sftp user@host
gets you connected automatically without a further prompt?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
The mainly problem was that we haven't access priority in that path of SFTP. we asked to define another path for SFTP.