Upload tab del file using sftp

[Jpep]

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;

[ballardw]

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

[Jpep]

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

[ballardw]

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