topic Re: Moving text files in SAS Programming

Moving text files

SAS_INFO — Mon, 05 Jun 2017 00:29:24 GMT

Hi ,

I would like to move .txt files from one folder to another .

The txt files are like ab001.D170605.EDLY.txt

the following code is not working

%put x mv "&fpath/AB001.D&tdate..EDLY.TXT" &apath.;

x mv "&fpath/ET001.D&tdate..EDLY.TXT" &apath.;

where fpath = source location

apath=destination location

Re: Moving text files

Reeza — Mon, 05 Jun 2017 00:35:37 GMT

Steps to debug this:

1. Does it work in command line

2. Does it work without macros

3. Does it work with basic skeleton macro

4. What does not work mean?

Re: Moving text files

SAS_INFO — Mon, 05 Jun 2017 01:43:13 GMT

I have checked without macros, but its not moving the file

Re: Moving text files

SAS_INFO — Mon, 05 Jun 2017 01:57:56 GMT

also tried this.

x "move "/data/DEVELOPMENT/LANDING/IN_FILES/ET001.D170605.EDLY.TXT" "/data/DEVELOPMENT/LANDING/ARCHIVED_IN"";

but the files are not moving and log is as follows:

GOPTIONS ACCESSIBLE;
24 x "move "/data/DEVELOPMENT/LANDING/IN_FILES/ET001.D170605.EDLY.TXT" "/data/DEVELOPMENT/LANDING/ARCHIVED_IN""
24 ! ;
25
26 GOPTIONS NOACCESSIBLE;
27 %LET _CLIENTTASKLABEL=;
28 %LET _CLIENTPROCESSFLOWNAME=;
29 %LET _CLIENTPROJECTPATH=;
30 %LET _CLIENTPROJECTNAME=;
31 %LET _SASPROGRAMFILE=;
32
33 ;*';*";*/;quit;run;
34 ODS _ALL_ CLOSE;
35
36
37 QUIT; RUN;
38

Re: Moving text files

Reeza — Mon, 05 Jun 2017 02:09:16 GMT

So what was the answer to Q#1 and 2?

Also, you're using EG, did you confirm that XMCD is enabled?

Re: Moving text files

Jagadishkatam — Mon, 05 Jun 2017 02:29:17 GMT

could you please try the below code without the quotes to the path mentioned within the x command after the mv command

x "mv /data/DEVELOPMENT/LANDING/IN_FILES/ET001.D170605.EDLY.TXT /data/DEVELOPMENT/LANDING/ARCHIVED_IN";

Re: Moving text files

SAS_INFO — Mon, 05 Jun 2017 02:48:21 GMT

I haven't tried in command line and how to check CXCD is enabled

Re: Moving text files

SAS_INFO — Mon, 05 Jun 2017 02:51:45 GMT

Hi Jag,

Tried wat u said:

x "move /data/DEVELOPMENT/LANDING/IN_FILES/ET001.D170605.EDLY.TXT /data/DEVELOPMENT/LANDING/ARCHIVED_IN";

But nothing happened

Re: Moving text files

Jagadishkatam — Mon, 05 Jun 2017 03:17:55 GMT

could you please try with mv rather than move

Re: Moving text files

SAS_INFO — Mon, 05 Jun 2017 03:21:39 GMT

Wolaa,, it worked, with MV

Re: Moving text files

SAS_INFO — Mon, 05 Jun 2017 03:57:55 GMT

Hi Jag,

Tried the following and its working:

x "mv /data/DEVELOPMENT/LANDING/IN_FILES/ET002A.D170605.EDLY.TXT /data/DEVELOPMENT/LANDING/ARCHIVED_IN";

But I would like to use the macros for location and tdate of the file as:
x "mv &fpath/ET002A.&tdate..EDLY.TXT &apath";

where &tdate is todays date

Re: Moving text files

Reeza — Mon, 05 Jun 2017 04:00:05 GMT

Post the full code you're trying to use, include the macro declarations. We don't know how you're defining them or what they look like

Re: Moving text files

Tom — Mon, 05 Jun 2017 04:00:36 GMT

That is why I always call operating system commands using PIPE instead of using X or %SYSEXEC. When you call the command using an INFILE with PIPE engine you can read the response from the operating system. If you had done that here you would have seem right away that the operating system did not understand the move command.

1    data _null_;
2      infile "move x y" pipe ;
3      input;
4      put _infile_;
5    run;

NOTE: The infile "move x y" is:
      Pipe command="move x y"

/bin/ksh: move: not found
NOTE: 1 record was read from the infile "move x y".
      The minimum record length was 25.
      The maximum record length was 25.

Re: Moving text files

SAS_INFO — Mon, 05 Jun 2017 04:06:19 GMT

Hi Reeza,

Sure...

* flat file data path;

%global fpath;

%let fpath = /data/DEVELOPMENT/LANDING/IN_FILES;

* archive file data path;

%global apath;

%let apath = /data/DEVELOPMENT/LANDING/ARCHIVED_IN;

Moving Flat Files:

This is working:

x "mv /data/DEVELOPMENT/LANDING/IN_FILES/ET002A.D170605.EDLY.TXT /data/DEVELOPMENT/LANDING/ARCHIVED_IN";

What i need is :

x "mv &fpath/ET002A.D&tdate..EDLY.TXT &apath";

Re: Moving text files

Reeza — Mon, 05 Jun 2017 04:12:18 GMT

tdate is not defined anywhere.

@SAS_INFO wrote:

Hi Reeza,

Sure...

* flat file data path;

%global fpath;

%let fpath = /data/DEVELOPMENT/LANDING/IN_FILES;

* archive file data path;

%global apath;

%let apath = /data/DEVELOPMENT/LANDING/ARCHIVED_IN;

Moving Flat Files:

This is working:

x "mv /data/DEVELOPMENT/LANDING/IN_FILES/ET002A.D170605.EDLY.TXT /data/DEVELOPMENT/LANDING/ARCHIVED_IN";

What i need is :

x "mv &fpath/ET002A.D&tdate..EDLY.TXT &apath";

Re: Moving text files

SAS_INFO — Mon, 05 Jun 2017 04:14:42 GMT

Hi Reeza,

data _NULL_;
25 infile"move &fpath/ET002C.D170605.EDLY.TXT &apath" pipe;
26 input;
27 put _infile_;
28 run;

NOTE: The infile "move /data/DEVELOPMENT/LANDING/IN_FILES/ET002C.D170605.EDLY.TXT /data/DEVELOPMENT/LANDING/ARCHIVED_IN" is:
Pipe command="move /data/DEVELOPMENT/LANDING/IN_FILES/ET002C.D170605.EDLY.TXT /data/DEVELOPMENT/LANDING/ARCHIVED_IN"

/bin/bash: move: command not found
NOTE: 1 record was read from the infile "move /data/DEVELOPMENT/LANDING/IN_FILES/ET002C.D170605.EDLY.TXT
/data/DEVELOPMENT/LANDING/ARCHIVED_IN".
The minimum record length was 34.
The maximum record length was 34.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Re: Moving text files

Reeza — Mon, 05 Jun 2017 04:18:53 GMT

@SAS_INFO Once tdate was defined it worked correctly for me.

So define tdate. And post your code using the editor and take some time to format the question. We take the time to answer your questions but it's easier if you organize your process clearly from the beginning.

%let tdate = %sysfunc(today(), yymmdd6.);
%put &tdate;

Re: Moving text files

SAS_INFO — Mon, 05 Jun 2017 05:46:48 GMT

Sure, Reeza

Apologies

Re: Moving text files

quiphan — Sat, 07 Aug 2021 01:15:00 GMT

/*hi @SAS_INFO
the macro variables are resolved within the _NUll_ data step, so try this */
* flat file data path;
%global fpath;
%let fpath = /data/DEVELOPMENT/LANDING/IN_FILES;

* archive file data path;
%global apath;
%let apath = /data/DEVELOPMENT/LANDING/ARCHIVED_IN;

%let tdate = %sysfunc(today(), yymmdd6.);
%put &tdate;

data _NULL_;
infile "move &fpath./ET002A.D&tdate..EDLY.TXT &apath." pipe;
input;
put _infile_;
run;