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

[ruch]

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]

Please post the code that was used.

You might also have a look at this entry https://communities.sas.com/t5/General-SAS-Programming/SFTP/td-p/160607

Bruno

[ruch]

%let host=trans.nsc.no;

%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]

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]

Yes ,But i got error during reading only.