topic Dynamic macrovariable in SAS Programming

Dynamic macrovariable

Planck — Wed, 26 Apr 2017 16:03:07 GMT

Hi all,

I have several macrovariable named:

&mAA
&mAB
&mBA
&mBB
...

Each of them has a string value.

Now I create a macro with two arguments

mymacro ( firststring, secondstring)

I want this macro to be able to modify the current value of one of my macrovariable with the value of secondstring.

Which macrovariable need to be modified? That's the point:

The value of the firststring can be "AA","AB","BA,"BB",...

If it is AA I need to modify &mAA

If it is BA I need to modify &mBA

Globally I need to do

&m&firststring.. = &secondstring.;

But like this of course, it is not working, and I don't really know how to do it?

Do you have an idea?

Thanks

Re: Dynamic macrovariable

Astounding — Wed, 26 Apr 2017 16:11:16 GMT

You'll need to construct a %LET statement to assign a value to a macro variable. The contents of your macro might end up looking like this:

%let m&firststring = &&m&secondstring;

Or, it might end up being:

%let m&firststring = &secondstring;

It's not clear which result you are looking for (probably the second one, based on your sample attempted code), but both of these are somewhere in the ballpark.

Re: Dynamic macrovariable

Planck — Wed, 26 Apr 2017 16:25:48 GMT

It's indeed the second one. Sorry if I was not completely clear.

Thanks very much for the answer! 🙂