topic Re: Macros within fcopy in New SAS User

Macros within fcopy

ashna — Thu, 15 Nov 2018 18:02:59 GMT

I have 10 files in one directory in FTP which has to be moved to another directory in FTP. For file move process I'm using Fcopy.

For all the 10files -starting of the filename is common (Report), Only the datepart and endpart of the file changes every month. I defiend datepart and endpart of the filenames to macro as the endpart of the filename are saved in table data as fname.

Filename examples :

1. Report_31-10-2018_wind.xlsx

2. Report_31-10-2018_water.xlsx etc.

Dataset : Data

fname

wind

water

health

proc sql;
	select count(fname) into:n trimmed from data;
	select distinct fname into:fn1 - :fn%left(&n)
			from data;
run;

data _null_;
	 call symput ('datepart',put(intnx('month',today(),0,"b"),yymmdd10.));
run;


data _null_;
			length msg $384;
			i=filename('in',"/temp/files/Report&datepart._&&fn&n..xlsx", "DISK", "RECFM=N");
			o=filename('out',"/temp/files/backup/Report&check._&&fn&n..xlsx", "DISK", "RECFM=N");

			rc=fcopy('_in', '_out');
				if rc=0 then
			put 'Copied _in to _out.';
				else do
					msg=sysmsg();
				  put rc= msg=;
	end;
i=filename('in');
o=filename('out');
run;

This code works perfect without errors. But moves only 1 file ie., fn10 file but not rest of the files.

Can any advice what I'm missing here.

Re: Macros within fcopy

Reeza — Thu, 15 Nov 2018 18:13:26 GMT

N never changes - you have no loop. You can use a data step with a do loop and make the string and then pass it to FCOPY or you can add a macro loop.

Re: Macros within fcopy

ashna — Thu, 15 Nov 2018 18:27:33 GMT

Can I define it as following

%macro fend;
	%do i=1 %to 5;
		%put filename=&&fn&i;
	%end;

And use fend instead of &fn&n in following statement?

i=filename('in',"/data/skynet/files/custom_billing/Cat/NSMIS/BNC/&cname&check._&fend..xlsx", "DISK", "RECFM=N");

Re: Macros within fcopy

Reeza — Thu, 15 Nov 2018 18:34:14 GMT

Do you already have the filenames in a a data set? If so you don't need a macro at all. Use FCOPY within the data step directly. Your code stays almost the same.

1. add a set statement to point to the data set with the filenames.
2. Change the files name using string functions instead of macro functions
3. Pass the variables to the FCOPY directly.

Re: Macros within fcopy

ashna — Thu, 15 Nov 2018 19:10:02 GMT

Thanks, for the advice,

I was over think for the simple solution 🙂