topic Re: Xcopy in SAS Programming

Xcopy

SASPhile — Thu, 15 Jun 2017 15:39:50 GMT

I have to copy 14K files from one directory to another. when using the below code, the cmd window opens 14K times and this is interrupting from doing further work.

1. How to make it work with out interrupting the user?

2. If the files are already presnt in destination folder, either delete them or overwrite them. The following code popups cmd window to manually key in the response by the user.

How to achieve above two conditions?

options noxwait noxsync;
data _null_;
%do i=1 %to &count.;
%sysExec xcopy "&landing_zone.\&&memname&i" "&dest.\";
%end;
run;
proc printto;
run;

Re: Xcopy

jdwaterman91 — Thu, 15 Jun 2017 16:22:48 GMT

Have you tried specifying the XMIN Option?

Re: Xcopy

LinusH — Thu, 15 Jun 2017 16:55:02 GMT

Can't you use /s and omit the looping?

Re: Xcopy

SASPhile — Thu, 15 Jun 2017 17:01:41 GMT

No ,havent tried

Re: Xcopy

SASPhile — Thu, 15 Jun 2017 17:04:18 GMT

never tried that.

Looping lets me choose only the files of interest. I'm not sure how /s works.

if there are

abc.txt

pqr.txt

xyz.txt

and I want to choose only pqr.txt and xyz.txt based on some conditions, I will pass the two file names into a macro array and loop them to move to a new folder.

Imagine i had to move 14k files out of 50k

Re: Xcopy

Reeza — Thu, 15 Jun 2017 17:21:17 GMT

You're passing a system command and need to find the relevant system option.

For XCOPY that appears to be /Y

See the Microsoft documentation, here:

https://support.microsoft.com/en-us/help/240268/copy,-xcopy,-and-move-overwrite-functionality-changes-in-windows

Re: Xcopy

SASPhile — Fri, 16 Jun 2017 21:15:17 GMT

When the number of file sizes increases, I'm getting an error.
Xcopy.exe Application error popup.

Re: Xcopy

Reeza — Fri, 16 Jun 2017 21:37:48 GMT

Like I mentioned you're using Windows command, SAS is just passing it to the system. Figure out what works in the system and that's a Windows question, not a SAS question.

Then incorporate that solution here.