topic Re: macro parameter in SAS Programming

macro parameter

Ronein — Wed, 22 May 2019 08:07:13 GMT

Hello

I want that value in second column will be macro parameter name and value of first column will be the value of the macro parameter.

So:

parameter Mon1 will get value 1901

parameter Mon2 will get value 1904

parameter Mon3 will get value 1907

parameter Mon4 will get value 1908

What is the way to do it?

Data aaa;
input YYMM mon $;
CARDS;
1901 Mon1
1904 Mon2
1907 Mon3
1908 Mon4
;
Run;

Re: macro parameter

Kurt_Bremser — Wed, 22 May 2019 08:18:49 GMT

call symput() or call symputx().

Re: macro parameter

Ronein — Wed, 22 May 2019 08:21:01 GMT

Data aaa;
input YYMM mon $;
CARDS;
1901 Mon1
1904 Mon2
1907 Mon3
1908 Mon4
;
Run;

data _null_;
set aaa;
call symput(mon,YYMM);
run;
%put &Mon1 ;
%put &Mon2 ;
%put &Mon3 ;
%put &Mon4 ;