Moving files between Windows and unix

[Jibyjacob7]

Hi there,

we have a SAS program that moves files from windows to unix and create some outputs. however, it started producing error when we try transferring files.

ERROR: The task tasksystem produced an error

following is the code and it used to work fine. IT customer support has no clue about this error and they are asking to SFTP account.

I had to replace the folder names with *** due to security issues.

%let DataDrop_Report_FileName = *************..xls;

%TransferFile(filename=&DataDrop_Report_FileName,

from=\\*********\Business Intelligence\_Management Information\Reports\*****,

to=/sasdev/*******,

record=yes);

Please help..

can you guys help me set up a sftp libname to move files from Windows?

I do have the host name, user name and password for the SFTP account

[tomrvincent]

I use the 'copy files' task (under data) with these params and it works fine between win and linux with wildcards:

Source file specification: &download_from.
Destination path: &download_to.
Overwrite existing files: Yes
Resolve macro references in file paths: Yes
Convert line endings for text files: Yes

[Jibyjacob7]

Thanks for responding to my question. should be add this under a datastep? Can you please elaborate