topic Re: Macro Variable Parameter Not Recognized in SAS Programming

Macro Variable Parameter Not Recognized

Kody_devl — Wed, 15 Feb 2017 21:05:44 GMT

I have a Macro that I want to run if the Parameter that I feed it is user entered to STLD_YN = YES, Otherwise don't run the Marco.

Here is how I have it set up:

%Let STLD_YN = Yes;

/* &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& */

/* ON SETTLEMENT DAY ONLY*/

/* &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& */

/* Import Settled Loans */

%Settled(&STLD_YN.);

%macro Settled(Settle_Today_Y_N);

%let Settle_Today_Y_N = %upcase(&Settle_Today_Y_N); .....................

This works perfectly exept for the first time that I open the Project and run it. (If I re-run it, and every time after, it works)?

Here is the Log Error:

86 %Settled(&STLD_YN.);

180

WARNING: Apparent invocation of macro SETTLED not resolved.

ERROR 180-322: Statement is not valid or it is used out of proper order.

87 %macro Settled(Settle_Today_Y_N);

Why is it doing this on the first time only?

Many Thanks

Re: Macro Variable Parameter Not Recognized

Astounding — Wed, 15 Feb 2017 21:15:07 GMT

Most likely, your Project logic has a piece in the wrong place. There will be some sort of statement that either defines the macro (think %include here) or that defines the library to search for, to locate macro definitions (think options sasautos=). That piece of code might appear after the macro is called. Moving it earlier, before the macro is called, would handle that sort of problem.

Re: Macro Variable Parameter Not Recognized

art297 — Wed, 15 Feb 2017 21:16:00 GMT

You haven't really told the forum enough BUT, if you are submitting the commands in the order shown (and your macro is complete i.e., ends with a %mend; statement, then you are calling the macro before it has been compiled.

Thus, simply, don't use the

%Settled(&STLD_YN.);

statement until after you have run the code that defines the macro.

HTH,

Art, CEO, AnalystFinder.com

Re: Macro Variable Parameter Not Recognized

Shmuel — Wed, 15 Feb 2017 21:22:20 GMT

You should define the macro before using it and

no need to define macro argument if macro variable is already defined.

Either do:

%Let STLD_YN = Yes;
%macro Settled;
   %let Settle_Today_Y_N = %upcase(&STLD_YN); 
   ..................... 
%mend settled; 
%Settled(&STLD_YN.);

Or do:

%macro Settled(Settle_Today_Y_N);
       %let Settle_Today_Y_N = %upcase(&Settle_Today_Y_N); 
        .....................
%mendsettled; 
%Settled(YES);

Re: Macro Variable Parameter Not Recognized

Kody_devl — Thu, 16 Feb 2017 04:28:21 GMT

Shmuel,

I tried both options and they both worked.

Thanks!