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

Jedrek369 — Sat, 18 Sep 2021 11:18:18 GMT

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

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

Ksharp — Sat, 18 Sep 2021 11:54:39 GMT

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

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

%put _user_;

topic Mapp values of the first variable to values of the second variable using macro variables. in SAS Programming

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

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