@ERI_RAMIREZ wrote:
Thank you very much I almost done, i have one final question how can I PADL the variable ms=1, i want the macro read the data base as in this example:
rescap_01_2021 instead of rescap_1_2021
If you are using a %DO loop to increment a macro variable as if it was a number, like this:
%do month=1 %to 12;
But you need the value to have leading zeros then use the PUTN() function with the Z format to add the leading zeros.
%do year=2020 %to 2021 ;
%do month=1 %to 12;
%let month=%sysfunc(putn(&month,Z2.));
%let dsname=rescap_&month._&year;
...
... View more