I have the following macro:   %MACRO Loop_1; %DO i = 1 %TO 500 ; %Macro_first(&i); %END; %MEND Loop_1; The problem is that after a certain amount of loops, the log window becomes full and needs to be cleared before the code progresses.   I googled this, and found: dm 'log;clear;'; But I can't seem to implement it. If I put it outside the loop, it doesn't work (obviously). If I put it in inside the loop, the "dm" stays black, so it seems that it's not registering properly as a SAS statement, and when I use %dm, it's being read as a macro.   Any help is appreciated!  ... View more

So let's say I have a macro that loops through 2 iterations, and at the end of each iteration my output is of the form:   Iteration 1 output: data Example; input Variable $ Var1 Var2 Var3; datalines; Mean 195 163 100 Max 220 198 240 ; run;   Iteration 2 output: data Example2; input Variable $ Var1 Var2 Var3; datalines; Mean 25 125 500 Max 210 141 630 ; run;   Inside, my macro looks like this:   PROC datasets lib = work nolist; DELETE Example; %MACRO output_table(y); /* bla bla bla insert code */ PROC MEANS DATA = Example; var Var1 Var2 Var3; output out = Example&y; QUIT; PROC append base = Example data = Example&y; %MEND output_table; %MACRO iter_1_2; %Do y = 1 %TO 2; %output_table(&y); %End; %MEND iter_1_2; RUN;   My end result is just the tables concatenated, for instance: data Example_append; input Variable $ Var1 Var2 Var3; datalines; Mean 195 163 100 Max 220 198 240 Mean 25 125 500 Max 210 141 630 ; run; But what I really want is the summarized values of all the variables from all the tables. So in this case: For the Mean of Var1-Var3, I'd have: (195+25)/2 = 110, (163+125)/2=144, (100+500)/2 = 300 and for max, I'd have: max(220,210)=220, max(198,141)=198, max(240,630)=630 and my output would look like:   data Example_append; input Variable $ Var1 Var2 Var3; datalines; Mean 110 144 300 Max 220 198 630 ; run; I'm unsure what I'm doing wrong and how to get there. Is it a PROC means step on my appended data, after a transpose? I can't transpose them because of the repeat Vars in the rows.   Any help is appreciated. Apologies for any typos.   ... View more