topic Re: create vector macro var automatically in SAS Programming

create vector macro var automatically

Ronein — Tue, 02 Jun 2020 10:38:21 GMT

Hello

%let mon1=2020;
%let mon2=2016;
/*I want to create another macro variable called vector that will get value 2020+2016
instead of define it manually %let vector=2020+2016;
I want that it will be defined automatically */

Re: create vector macro var automatically

PaigeMiller — Tue, 02 Jun 2020 11:01:45 GMT

%let want = &mon1%str(+)&mon2;
%put &=want;

Re: create vector macro var automatically

ed_sas_member — Tue, 02 Jun 2020 13:22:42 GMT

Hi @Ronein

Here is another approach, using the CATX() function, and the plus operator as the delimiter:

%let vector= %sysfunc(catx(+,&mon1.,&mon2.));

Best,

Re: create vector macro var automatically

smantha — Tue, 02 Jun 2020 13:30:14 GMT

%let final_str=;
%do count=1 %to %eval(&n-1);
%let final_str=&final_str.%str(+)&&mon&count.;
%end;
%let final_str=&final_str.%str(+)&&mon&count.;

Re: create vector macro var automatically

Tom — Tue, 02 Jun 2020 13:44:53 GMT

I am not sure I understand what your question means. Is it as simple runnng a %LET statement?

%let mon1=2020;
%let mon2=2016;
%let vector=&mon1+&mon2;

530   %put &=vector;
VECTOR=2020+2016

Or did you want to assign a value to VECTOR in a way that its value will change without having to re-create it?

Something like:

data _null_;
  call symputx('vector','&mon1+&mon2');
run;

535   %put %superq(vector);
&mon1+&mon2
536   %put &=vector;
VECTOR=2020+2016
537   %let mon1=2030;
538   %put &=mon1 &=mon2 &=vector;
MON1=2030 MON2=2016 VECTOR=2030+2016

Re: create vector macro var automatically

s_lassen — Tue, 02 Jun 2020 14:16:35 GMT

Not quite sure what you want. Is it just one variable with the text you displayed? then just do

%let vector=&mon1+&mon2;

Or do you want the calculated sum? then do

%let vector=%eval(&mon1+&mon2);