resolving a macro variable to another macro variable

[riskassure]

Hi, I have the following question:

I have a bunch macro variables defined in a program:

%let ADX = 2
%let BDX = 21
%let CDX = 13
%let DDX = 5
%let EDX = 10

later in the program, I have the following macro defined:

%macro test(z);
data newdates&z;
set olddates;
if ref in (&&z.dx) and state = &z;
run;
%mend test;

But when I run the following:

%test(a)

it gave me an error message. I want &&z.dx to first resolve to the macro variable adx, and then resolve that to 2. How do I achieve this?

Thanks in advance!

~~CW~~

 

[klaz2002]

Try one more '&' before the z.

ex.

if ref in (&&&z.dx) and state= &z;

Klaz

 

[riskassure]

Thanks.. that did it!!!

~~CW~~