topic Re: Refer to a Macro variable with a combination of Macro variable and dataset variable in SAS Programming

Refer to a Macro variable with a combination of Macro variable and dataset variable

Mushy — Sun, 15 Aug 2021 06:52:53 GMT

Hello All,

I have a macro variable test123=combination

In the data step I need to resolve this macro variable.

Example:

%let test123=combination;

data mac;

macval=123;

combval=?

run;

I want the value of combval=combination.

something like combval=&&test.(macval) where macval is referred for the suffix

is there a way without intermediate conversion of macval to macro variable?

Thanks

Mushy

Kurt_Bremser — Sun, 15 Aug 2021 08:53:08 GMT

To retrieve the value of a macro variable during data step execution, you need to use the SYMGET Function.

Kurt_Bremser — Sun, 15 Aug 2021 08:55:42 GMT

The statement would be

combval = symget(cats('test',macval));

Mushy — Sun, 15 Aug 2021 09:01:46 GMT

Thanks Kurt