topic Re: Uploading and copying file to and from SFTP site in SAS Data Management

Uploading and copying file to and from SFTP site

mlogan — Fri, 08 May 2020 02:53:33 GMT

Hi All,

I am trying to upload as well as retrieve a file from my pc to the SFTP site. Can someone please tell me what will be the sas code for both of these.

Thanks,

Kurt_Bremser — Fri, 08 May 2020 04:14:33 GMT

Do you have a local SAS installation, or does your SAS run on a server? Which frontend do you use, Enterprise Guide, SAS Studio or Display Manager?

mlogan — Sat, 09 May 2020 02:41:35 GMT

I have sas base installed on a local PC. I can use Enterprise Guide if I need to.

SASKiwi — Sat, 09 May 2020 04:55:44 GMT

Start by searching the SAS documentation (documentation.sas.com) using your key words file and SFTP. You will get answers faster that way. Then you will find links like this where there are a lot of code examples: https://documentation.sas.com/?docsetId=lestmtsglobal&docsetTarget=p0xln1fiwsr340n1xxf4mkmfxp6f.htm&docsetVersion=9.4&locale=en

Kurt_Bremser — Sat, 09 May 2020 06:26:18 GMT

You first need to set up passwordless (public/private key) authentication to your target servers.

From the documentation of FILENAME SFTP, I take it that SAS uses putty on Windows platforms (see example #3 in the link).