topic Re: SAS query in SAS Programming

How to move disk files around

scb — Wed, 14 Mar 2018 09:13:47 GMT

I have multiple txt files in dir D:\in and would like to transfer all the txt files to dir D:\out

Is there SAS command can copy the mutiple txt files from one directory to another?

Thanks.

RW9 — Wed, 14 Mar 2018 09:12:45 GMT

The simplest method is to use the OS commands, for example on windows:

data _null_;
  x 'copy "d:/in/*.txt" "d:/out"';
run;

You could also use a datastep to read in the files (infile) and write them out again (file).

You could use fcopy function.

Try having a go and coming back with questions.

Oligolas — Wed, 14 Mar 2018 13:49:16 GMT

Hi,

well I personally use robocopy to also recreate the structure of the subfolders:

DATA _NULL_;
  x 'ROBOCOPY "D:\in" "D:\out" *.txt /MIR';
RUN;

It performs the job without carrying about the existence of the 'out' Folder.

Reeza — Wed, 14 Mar 2018 14:43:46 GMT

FCOPY() function as of SAS 9.4+