Mapp values of the first variable to values of the second variable using macro variables.

[Jedrek369]

Hello,

Is it possible to automate mapping unique values of the first variable to values of the second variables using macro variables? I don't want to write %let statement for every macro variable.

I have the following table:

X	Y
a	1
b	2
c	3

I want the following result:

%put &a.;
LOG: 1
%put &b.;
LOG: 2
%put &c.;
LOG: 3

[Ksharp · Accepted solution]

data have;
input x $ y;
cards;
a 1
b 2
c 3
;

data _null_;
 set have;
 call symputx(x,y);
run;

%put _user_;