I got it to work using the following code but would really like if someone can help with something simpler, perhaps only using arrays without using the %do_over and %array macros. %macro sick (i); sick day&i. = S30Q4_30d_&i.+S30Q5_30d_&i.+S30Q6_30d_&i.+S30Q7_30d_&i.; %mend; %array(num, values = %numlist(1-30)); %do_over(num, macro= sick); %macro sick 2 (j, k); sickday&j. = S30Q4_60d_&k.+S30Q5_60d_&k.+S30Q6_60d_&k.+S30Q7_60d_&k.; %mend; %array(num2, values = %numlist(31-60)); %array(num3, values = %numlist(1-30)); %do_over(num2 num3, macro= sick2);
... View more