** run this in Jan **; data master; set jan; run; ** run this in the month of feb **; %let want_month=2 ; options mprint; %macro month; %let list=Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec; proc append base = master data = %scan(&list,&want_month); run; %mend month; %month ** run this in the month of march**; %let want_month=3 ; options mprint; %macro month; %let list=Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec; proc append base = master data = %scan(&list,&want_month); run; %mend month; %month ** run this in the month of april **; %let want_month=4 ; options mprint; %macro month; %let list=Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec; proc append base = master data = %scan(&list,&want_month); run; %mend month; %month At the end of april the output would be as follows: rundate product premthbal curmthbal 1/5/2012 aaa . 1 1/5/2012 abc . 2 1/5/2012 bbb . 3 1/5/2012 ccc . 4 1/5/2012 ddd . 5 1/5/2012 eee . 6 1/5/2012 fff . 7 1/5/2012 ggg . 8 2/5/2012 aaa . 9 2/5/2012 abc . 8 2/5/2012 bbb . 7 2/5/2012 ccc . 6 2/5/2012 ddd . 5 2/5/2012 eee . 4 2/5/2012 fff . 3 2/5/2012 ggg . 2 3/5/2012 aaa . 1 3/5/2012 abc . 2 3/5/2012 bbb . 3 3/5/2012 ccc . 4 3/5/2012 ddd . 5 3/5/2012 eee . 6 3/5/2012 fff . 7 3/5/2012 ggg . 8 4/5/2012 aaa . 3 4/5/2012 abc . 2 4/5/2012 bbb . 1 4/5/2012 ccc . 3 4/5/2012 ddd . 2 4/5/2012 eee . 1 4/5/2012 fff . 3 4/5/2012 ggg . 2
... View more