topic Re: Upload tab del file using sftp in SAS Programming

Upload tab del file using sftp

Jpep — Tue, 27 Mar 2018 16:03:45 GMT

I have a table in my work that I would like to upload to a vendor sftp site making the file a tab delimited. I am using base sas coding in 9.4.. I have searched on these boards for something similar and did not see much but have been trying the below code. The error is Invalid option name pass. which I have seen pass= for the password of the sftp in other posts. Anyone have any simile code to help?

Thank you!

filename AmSpirit sftp "test.txt"
cd = '/'
host = 'sftp.xxxx.com'
user='xxxxxxxxxx'
pass = 'xxxxx'
debug;

proc export file=AmSpirit
data=work.TestFile
dbms=tab replace;
run;

Re: Upload tab del file using sftp

ballardw — Tue, 27 Mar 2018 16:16:50 GMT

Could this apply to your case?

Requirement When you submit code that contains a FILENAME SFTP statement from SAS Enterprise Guide that runs on a Windows workspace server, you must specify authentication by using the OPTIONS or OPTIONSX option.

You may need to put your password into Options or Optionsx as PASS is not a standard option for Filename sftp

Re: Upload tab del file using sftp

Jpep — Tue, 27 Mar 2018 16:21:01 GMT

This is from base sas 9.4 and not EG; but if I need to in base could you elaborate on how to do this? thanks

Re: Upload tab del file using sftp

ballardw — Tue, 27 Mar 2018 17:48:35 GMT

The option PASS= is a standard option for Filename FTP, not SFTP. Perhaps you should start there.