03-27-2018 12:03 PM
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?
filename AmSpirit sftp "test.txt"
cd = '/'
host = 'sftp.xxxx.com'
pass = 'xxxxx'
proc export file=AmSpirit
03-27-2018 12:16 PM
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