topic Re: Get Files from SFTP server to unix server with help of SAS DI 4.6 in SAS Data Management

Get Files from SFTP server to unix server with help of SAS DI 4.6

ruch — Tue, 22 Sep 2015 12:00:19 GMT

Hi All ,

I need to get and copy (with rename) files from SFTP server to Unix Server with the help of DI 4.6.

Files that i need to read are .dat files.

Can anyone suggest me the approach to do this . I have tried with File name option but it doesn't work and gave error

It trying to get file from sas work as per below error :

NOTE: get File.dat "/saswork01/SAS_workEF2F012F00C6_tns-lk-test-ma-comp/#LN090018"

ERROR: Directory or file File.dat doesn't exist.

I am not able to understand why its trying to get file from saswork,it should go and get details of the files from SFTP system not saswork.

BrunoMueller — Wed, 23 Sep 2015 08:29:34 GMT

Please post the code that was used.

Bruno

ruch — Wed, 23 Sep 2015 12:55:48 GMT

%let sftpOption=-o IdentityFile=/uttrekk/prodadm/.ssh/winback_prod;

%let filename=CMD*.dat;

%let sftpPath=/home/t000315/;

filename myfile sftp "&sftpPath.&filename." host="&host." options="&sftpOption.";

data work.test_sftp;

infile myfile truncover;

input File_Names $100.;

run;

BrunoMueller — Wed, 23 Sep 2015 18:21:16 GMT

Currently the code is only reading from the fileref myfile but not writing it anywhere. Checkout this blog entry Copy a file using a SAS program: another method by @ChrisHemedinger

You will find usefull information on how to do a binary file copy.

Bruno

ruch — Thu, 24 Sep 2015 06:13:49 GMT

Yes ,But i got error during reading only.