topic Moving files between Windows and unix in SAS Programming

Moving files between Windows and unix

Jibyjacob7 — Wed, 03 Apr 2019 15:44:27 GMT

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

Re: Moving files between Windows and unix

tomrvincent — Wed, 03 Apr 2019 17:16:53 GMT

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

Re: Moving files between Windows and unix

Jibyjacob7 — Wed, 03 Apr 2019 18:12:55 GMT

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