topic Re: Automate file transfer from SFTP server in SAS Programming

Automate file transfer from SFTP server

Shahrukhh_Khan — Wed, 27 May 2020 07:56:10 GMT

Hi All,

I need to transfer some files from SFTP server to SAS server on daily basis based on the SFTP date and time.

For example i need to transfer all the files for date 14th May or 17th May.

Can someone please help how i can access the SFTP date time from SAS.

With "mget" i can pull all the file available in SFTP but i want to pull the file only for the specific day.

Re: Automate file transfer from SFTP server

JasonDiVirgilio — Thu, 28 May 2020 14:48:56 GMT

You should be able to use the DIR option to get a listing of files in the folder. You could then parse that listing to determine which files have the dates you want and "get" them by name.

https://documentation.sas.com/?docsetId=lestmtsglobal&docsetTarget=p0xln1fiwsr340n1xxf4mkmfxp6f.htm&docsetVersion=9.4&locale=en

Re: Automate file transfer from SFTP server

Shahrukhh_Khan — Fri, 29 May 2020 07:40:41 GMT

Thanks Jason for your reply.

I am not familiar with unix command.

Could you please give sample code related to DIR command so that i can relate it to my code and fetch the file name from SFTP server based on the date.

Thanks in Advance.

Re: Automate file transfer from SFTP server

Patrick — Fri, 29 May 2020 10:22:42 GMT

Before you even start using SAS get your SFTP command right to only select the files you're after. There will be a lot of examples when Googling the moment you take SAS out of the picture.

Once you've got the SFTP command as needed you then can call it from within SAS using Filename Pipe.

Re: Automate file transfer from SFTP server

JasonDiVirgilio — Fri, 29 May 2020 20:20:52 GMT

Refer to the link to SAS Documentation I included. Example 4 uses the DIR option to the filename statement when using SFTP. It gives you a directory listing as output which you can then parse to figure out what files you want to include.

Example 4: Reading Files from a Directory on the Remote Host

This example reads the files test.dat and test2.dat from a directory on the remote host.

filename infile sftp '/users/xxxx/' host="unixhost1" dir;
data _null_;
   infile infile(test.dat) truncover;
   input a $25.;
   infile infile(test2.dat) truncover;
   input b $25.;
run;

Re: Automate file transfer from SFTP server

Shahrukhh_Khan — Mon, 01 Jun 2020 07:02:09 GMT

Thanks Jason,

I will try DIR option in my code.

Re: Automate file transfer from SFTP server

Shahrukhh_Khan — Mon, 01 Jun 2020 07:03:02 GMT

Thanks Patrick for your reply.