Put column value into a macro variable that's named from another column in same row

[BuildsStuff]

Hi, I have a table that contains a list of values and the macro variable name that I want to store that value in.

Simplified to this example:

ValueToStore	Macro_Name
Value A	TestContainerA
Value B	MacroNameBoy
Value C	MacroNameTT

So as a result, I'd like a macro variable named TestContainerA that has the value 'Value A'. MacroNameBoy would have the value 'Value B' and so forth.

I tried several things around this and can't get it working. Any suggestions on another way would be much appreciated:

Proc SQL;

Select macro_name

into :macro_name separated by ' '

From test;

Quit;

Proc SQL;

Select ValueToStore

into :&macro_name separated by ' '

From test;

Quit;

[Tom · Accepted solution]

A perfect use case for the CALL SYMPUTX() function.

data _null_;
  set test;
  call symputx(Macro_Name,ValueToStore);
run;

[BuildsStuff]

Holy mackerel. There's a function for everything. Love it! Thanks!

[PeterClemmensen]

Welcome to the SAS Community 🙂

Simply use CALL SYMPUTX in a data step instead of PROC SQL logic