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; ... View more

I have scheduled code that makes the same table each night, which is shared. Some people accidentally leave the table open - then it does not update. Is there a way in the code to close the table in someone else's session?   Thanks! ... View more