I have created a proc SQL statements to merge datasets in a given year. I would like to repeat this merge step for many years. Here is my sample program for the year 1985. proc sql; create table folder1.OPT_price1985 as select a.*, b.* from folder1.OPT1985 as a , folder1.price1985 (keep = secid date close volume) as b where a.secid  = b.secid and a.date = b.date; quit; I would like to repeat this like a do loop for 20 years. I tried the do loop macro but it did not work. ... View more