Sometimes I need to repeat the same exercise for multiple times, for example faculty want retention rate not just for one year but multiple year, it is easy to use %macro macroname (parameter1, parameter2) in conjunction with %do varname = &value1 &to &value2 to customize the year range in the do loop statement per clients request.
eg;
%macro step (strtyear, stopyear);
%do yr= &strtyear %to &stopyear;
….continue coding
%end;
%mend step;
%step (11, 14);