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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: