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;
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
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
The option PASS= is a standard option for Filename FTP, not SFTP. Perhaps you should start there.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.