topic Re: Move multiple files from One folder to Another using SAS EG in SAS Enterprise Guide

Move multiple files from One folder to Another using SAS EG

Abinaya — Mon, 04 Feb 2019 05:06:17 GMT

Hi,

I have requirement to create Archive of Older Files and the Current folder has SAS/log/lst/rtf/pdf/png files created with Datetime Stamp.

Now,I need to move all the files from the current folder to the Archive and just retain only the recent TimeStamped Set of files in Current.

I am planning to route all SAS Created Files to Current folder and in the same code writing the below Piece of Macro to move the previously created files.

%macro test;

%sysexec %str(mkdir ./Archive;mv ./Current/* ./Archive);

%mend test;

%test;

problem Area:

But after "/*" ,SAS Code is getting commented..

So,I am not able to select all the files from the Current Folder.

Can you please help me out to fix this approach?

Thanks in advance!

Regards,

Abi

Re: Move multiple files from One folder to Another using SAS EG

Reeza — Mon, 04 Feb 2019 05:14:13 GMT

Instead of %STR() try using quotation marks which will mask the asterisk (*) which is causing the issue.

Re: Move multiple files from One folder to Another using SAS EG

Abinaya — Mon, 04 Feb 2019 05:26:56 GMT

That's Great!

Thanks much Reeza..I can copy individual file..

But I am not able to copy all the files using below macro..Can you please help??

%let path=/sdsbai/common/SAS_new/Final_Testing;

%macro test;

%sysexec "mv &path/Test_case1/* &path/Archive";

%mend test;

%test;

Thanks!

Abi

Re: Move multiple files from One folder to Another using SAS EG

Reeza — Mon, 04 Feb 2019 05:30:40 GMT

mv is a system command that moves files from one directory to another, guessing Unix/Linux. %SYSEXEC passes the command to the operating system to execute.

So you need to find the correct unix command, but that's not a question I can answer - I google unix commands every time I need them :).

Re: Move multiple files from One folder to Another using SAS EG

Kurt_Bremser — Mon, 04 Feb 2019 10:11:09 GMT

Use the filename pipe method, and put the command in quotes:

filename oscmd "mkdir ./Archive;mv ./Current/* ./Archive 2>&1";

data _null_;
infile oscmd;
input;
put _infile_;
run;

You won't have a problem with seeming SAS syntax (eg comments) inside the command string, and all responses from the system will end up in the SAS log.

Re: Move multiple files from One folder to Another using SAS EG

Abinaya — Tue, 05 Feb 2019 04:44:02 GMT

Thanks all!!

Much appreciated Solutions 🙂