DATA Step, Macro, Functions and more

Upload tab del file using sftp

Reply
Occasional Contributor
Posts: 7

Upload tab del file using sftp

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;

Super User
Posts: 13,941

Re: Upload tab del file using sftp

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

 

Occasional Contributor
Posts: 7

Re: Upload tab del file using 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

Super User
Posts: 13,941

Re: Upload tab del file using sftp

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

Ask a Question
Discussion stats
  • 3 replies
  • 80 views
  • 0 likes
  • 2 in conversation