topic Re: Copy directories and sub directories dynamically in SAS Programming

Copy directories and sub directories dynamically

Rohit12 — Tue, 25 Apr 2017 09:21:57 GMT

%let source=c:\New folder;

%let target=c:\shubham;

data source ;

infile "dir /b ""&source\"" " pipe truncover;

input fname $256. ;

run;

data target ;

infile "dir /b ""&target\"" " pipe truncover;

input fname $256. ;

run;

data new;

set source ;

length cmd1 $100.;

cmd1 = catx(' ','xcopy',quote(catx('\',"&source",fname)),quote("&target"));

cmd= cat('X ',cmd1);

infile cmd filevar=cmd end=eof ;

do while (not eof);

input;

put _infile_;

end;

run;

Below is the error that comes up

ERROR: Invalid physical name.

fname=file1.txt cmd1=xcopy "c:\New folder\file1.txt" "c:\shubham"

cmd=X xcopy "c:\New folder\file1.txt" "c:\shubham" eof=0 _ERROR_=1 _INFILE_= _N_=1

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 1 observations read from the data set WORK.SOURCE.

WARNING: The data set WORK.NEW may be incomplete. When this step was stopped there were 0

observations and 2 variables.

WARNING: Data set WORK.NEW was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.01 seconds

My goal is to copy all directories and subdirectories dynamically

how can I do that

Re: Copy directories and sub directories dynamically

RW9 — Tue, 25 Apr 2017 09:39:00 GMT

This line:

infile cmd...

As you can see from the error, CMD variable contains:

X xcopy "c:\New folder\file1.txt" "c:\shubham"

Which is not valid SAS syntax. Infile requires a path/filename, or fileref.

What is it your copying, what is the process? As I mentioned before, programs which create/copy folders/files should never really be needed. You process should take care of that - i.e. follow an operating procedure, be inline with IT requirements, permissions etc. Simply copying an pasting directories/files willy nilly will flag you up to IT.

Re: Copy directories and sub directories dynamically

Rohit12 — Tue, 25 Apr 2017 09:49:21 GMT

what I want is that I want to copy all the directories and subdirectories through sas

for ex-I wan to copy from old folder which contain file1.txt and file2.txt path- c:\old folder to a new path c:\new folder

how can I do this by SAS program

Re: Copy directories and sub directories dynamically

RW9 — Tue, 25 Apr 2017 09:53:46 GMT

I understand what you want, I don't understand why you want to do that. Its never a good idea to multiple your file system, it sounds like there is some reasoning as to copying that, maybe thats a fixed copy and you don't want to alter it? If so open it as read only and work with it in your work area - this is just an example.

Re: Copy directories and sub directories dynamically

Rohit12 — Tue, 25 Apr 2017 10:02:58 GMT

what i want is that whenver I run SAS program it should copy file from one directories to another

how caN i acheive that using SAS or any other way

please help me

Re: Copy directories and sub directories dynamically

Kurt_Bremser — Tue, 25 Apr 2017 11:49:29 GMT

filename oscmd pipe "xcopy c:\source\* c:\target /s /y 2>&1";

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

will copy all files in c:\source to c:\target, including all subdirectories. /y prevents prompting when a file already exists in the target.

The filename pipe and data step are used to catch output from the command and write it to the SAS log; if you don't need that, you can issue the xcopy command in a X statement.

I recommend doing the filename/data step method at least while testing.

Re: Copy directories and sub directories dynamically

data_null__ — Tue, 25 Apr 2017 12:05:54 GMT

@Rohit12 wrote:

%let source=c:\New folder;

%let target=c:\shubham;

data source ;

infile "dir /b ""&source\"" " pipe truncover;

input fname $256. ;

run;

data target ;

infile "dir /b ""&target\"" " pipe truncover;

input fname $256. ;

run;

data new;

   set source ;

   length cmd1 $100.;

cmd1 = catx(' ','xcopy',quote(catx('\',"&source",fname)),quote("&target"));

cmd= cat('X ',cmd1);

   infile cmd filevar=cmd end=eof ;

   do while (not eof);

     input;

     put _infile_;

   end;

run;

Below is the error that comes up

ERROR: Invalid physical name.

fname=file1.txt cmd1=xcopy "c:\New folder\file1.txt" "c:\shubham"

cmd=X xcopy "c:\New folder\file1.txt" "c:\shubham" eof=0 _ERROR_=1 _INFILE_= _N_=1

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 1 observations read from the data set WORK.SOURCE.

WARNING: The data set WORK.NEW may be incomplete. When this step was stopped there were 0

         observations and 2 variables.

WARNING: Data set WORK.NEW was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

My goal is to copy all directories and subdirectories dynamically

how can I do that

Looks to me like you want to execute the XCOPY with PIPE not X command. See if this works...

data new;
   set source ;
   length cmd1 $100.;
  cmd1 = catx(' ','xcopy',quote(catx('\',"&source",fname)),quote("&target"));
 
   infile dummy pipe filevar=cmd1 end=eof ;
   do while (not eof);
     input;
     put _infile_;
   end;
run;

Notice the change to the INFILE statement.

Re: Copy directories and sub directories dynamically

Rohit12 — Thu, 27 Apr 2017 08:11:57 GMT

No it does not works

below is the note that is coming in that's why it is not copying it