I would like a macro variable that is referenced to change -1 and +1 with each iteration. For example in the following loop, each iteration from the start year of 2011 to the end year of 2013 should give the year minus 1 (YM1), the year (Y), and the year plus 1 (YP1).
%macro Loop_year(startyear=, endyear=);
%DO I = &startyear %TO &endyear;
%put YM1 is &I-1;
%put Y is &I;
%put YP1 is &I+1;
%end;
%mend Loop_year;
%Loop_year(startyear=2011, endyear=2013);
This is what I get:
YM1 is 2011-1
Y is 2011
YP1 is 2011+1
YM1 is 2012-1
Y is 2012
YP1 is 2012+1
YM1 is 2013-1
Y is 2013
YP1 is 2013+1
But this is what I want:
YM1 is 2010
Y is 2011
YP1 is 2012
YM1 is 2011
Y is 2012
YP1 is 2013
YM1 is 2012
Y is 2013
YP1 is 2014
Would this be possible? Thanks in advance
Like this?
%macro Loop_year(startyear=, endyear=);
%DO I = &startyear %TO &endyear;
%put YM1 is %eval(&I-1);
%put Y is &I;
%put YP1 is %eval(&I+1);
%end;
%mend Loop_year;
%Loop_year(startyear=2011, endyear=2013);
Result:
YM1 is 2010 Y is 2011 YP1 is 2012 YM1 is 2011 Y is 2012 YP1 is 2013 YM1 is 2012 Y is 2013 YP1 is 2014
Like this?
%macro Loop_year(startyear=, endyear=);
%DO I = &startyear %TO &endyear;
%put YM1 is %eval(&I-1);
%put Y is &I;
%put YP1 is %eval(&I+1);
%end;
%mend Loop_year;
%Loop_year(startyear=2011, endyear=2013);
Result:
YM1 is 2010 Y is 2011 YP1 is 2012 YM1 is 2011 Y is 2012 YP1 is 2013 YM1 is 2012 Y is 2013 YP1 is 2014
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.