topic Re: Create vector macro varaible in SAS Programming

Create vector macro varaible

Ronein — Tue, 20 Jul 2021 07:09:41 GMT

Hello

User define 2 macro variables

%let minYYMM=2007;

%let maxYYMM=2106;

I want to create another macro variable called List that will get YYMM values between &minYYMM and &maxYYMM.

So in this case the desired value of the new macro variable is 2007+2008+2009+2010+2011+2012+2101+2102+2103+2104+2105+2106

Thanks

Re: Create vector macro varaible

Kurt_Bremser — Tue, 20 Jul 2021 08:26:40 GMT

Use a DO loop with INTNX:

data _null_;
length vector $32767;
start = input("20&minyymm.01",yymmdd10.);
do while (start le input("20&maxyymm.01",yymmdd8.));
  vector=catx("+",vector,substr(put(start,yymmddn8.),3,4));
  start = intnx('month',start,1);
end;
call symputx("vector",vector);
run;

This loop can be used to directly create repeated code with CALL EXECUTE or similar.