topic How to form the macro application with macro variable in SAS Programming

How to form the macro application with macro variable

thanikondharish — Tue, 26 Nov 2019 05:51:13 GMT

%let sex=F;
%macro &sex;
Proc print data=sashelp.class;
Run;
%mend;

%&sex;

I wrote one application but i am getting error .
Please help to fix this

Re: How to form the macro application with macro variable

PeterClemmensen — Tue, 26 Nov 2019 05:56:36 GMT

As the %Macro Statement Documentation says: "A macro name must be a SAS name, which you supply; you cannot use a text expression to generate a macro name in a %MACRO statement".

Which means that you can not use a macro variable in a %Macro Statement.

Re: How to form the macro application with macro variable

thanikondharish — Tue, 26 Nov 2019 06:02:18 GMT

Thaks,
Is there any other option?

Re: How to form the macro application with macro variable

SASKiwi — Tue, 26 Nov 2019 06:35:23 GMT

Why do you want to create macros with dynamic names? It makes your code hard. Here is one way:

%let sex=F;
options mprint;

data _null_;
  macro_name = "&sex";
  call execute('%nrstr(%macro '!!macro_name!!';)');
  call execute('%nrstr(proc print data = sashelp.class;run;)');
  call execute('%nrstr(%mend '!!macro_name!!';)');
  call execute('%nrstr(%'!!macro_name!!';)');
run;

You could also write the same statements to an external text file then %INCLUDE them.

Re: How to form the macro application with macro variable

PeterClemmensen — Tue, 26 Nov 2019 06:33:28 GMT

First of all, why do you want to create a macro with a dynamic name? The dynamic part of a macro should be its arguments.

Re: How to form the macro application with macro variable

Kurt_Bremser — Tue, 26 Nov 2019 08:12:51 GMT

Even if you could, you don't. It creates unmaintainable code.

DO NOT DO IT. DO NOT EVEN THINK ABOUT IT.

What for do you even think this is needed?

Re: How to form the macro application with macro variable

thanikondharish — Tue, 26 Nov 2019 08:37:18 GMT

I want to create 3 macro applici at a time
1-F
2-M
3-O

Re: How to form the macro application with macro variable

Kurt_Bremser — Tue, 26 Nov 2019 09:08:59 GMT

And what is the difference between those macros? You're much better off creating one macro that expects one of F,M,O as a parameter and acts accordingly.