topic How to sftp files in SAS Programming

How to sftp files

Havi — Tue, 12 Feb 2013 08:16:17 GMT

Hi All

Please advise.

I extract huge datasets and convert them to CSV format. I have these files saved on a UNIX server. What is the best way to send these files to a Big data VM appliance. Is it possible to send them from my remote session in unix while converting them to CSV? What are some of my alternatives?

Thanks a million

Re: How to sftp files

LinusH — Tue, 12 Feb 2013 11:45:35 GMT

Can't that this is a SAS issue really. How the file transfer is made is a matter of DW architecture.

SAS-wise, do you have a batch job that does signon to a remote UNIX SAS session, and creates those files there?

If you don't want to involve the scheduler on the UNIX host, it could seem simple to kick a shell script on UNIX that handles the sftp part.

There is also a SFTP filename "engine" available in SAS, if you would like to have the logic within the SAS job.

Re: How to sftp files

Haikuo — Tue, 12 Feb 2013 14:22:43 GMT

Depending on your environment, there would be more than one options, some of the popular ones are:

1. If you have SAS/CONNECT, your Unix server is running SAS and you only transfer SAS files, please see :"Proc Download"

2. Google "Samba drive"

Make sure you have SFTP server running on your Unix server:

3. Use one of the SFTP clients, the one I use the most is "WINSCP"

4. Filename SFTP if you have SAS 9.2 or higher.

Haikuo