topic Re: macro out of proper order? in New SAS User

macro out of proper order?

mmea — Thu, 25 Feb 2021 12:00:40 GMT

Hi i am running this code



* Your source file;
filename _bcin "F:\Report_&todaysDate._kl%scan(%sysfunc(time(),time8.0),1,:).xlsx";

* Your destination file;
filename _bcout "\\hh\Report_&todaysDate._kl%scan(%sysfunc(time(),time8.0),1,:).xlsx";

%binaryFileCopy()

But it doesnt work - it should copy a file into another folder? It says that the macro is not use in proper order

Re: macro out of proper order?

andreas_lds — Thu, 25 Feb 2021 12:04:54 GMT

Please post the complete log as text using using "insert code" function.

Re: macro out of proper order?

mmea — Fri, 26 Feb 2021 10:27:48 GMT

Re: macro out of proper order?

PaigeMiller — Thu, 25 Feb 2021 12:29:24 GMT

The macro named %binaryFileCopy has not been defined, so SAS cannot use it. You must first define the macro by that name using any one of a number of methods, which you have not done.

Re: macro out of proper order?

mmea — Fri, 26 Feb 2021 10:07:07 GMT

How can I define the macro

Re: macro out of proper order?

Kurt_Bremser — Fri, 26 Feb 2021 10:25:11 GMT

@mmea wrote:

How can I define the macro

You run the code that contains the macro definition.

You probably need to get that particular code from the place where you found the use of the macro.