My macro would generate a table with 2 columns, one is from Jan, 2014 to Dec 2014 (once per month) as Time, one is the number that I wanted. But the result is ramdom. So I want to run it 60 times and ave the number that I wanted. Don't know how to write the execute macro 60 times in do loop code. Help me please........ Thanks Hi, all I end up add the macro in the code to execute macro analysis 30 time to bootstrap data for random selected results. %Macro doit; %do i =1 %to 30; %if i > 30 %then %do; %analysis('01jan14'd,'31jan14'd, '01-01-2014','01-31-2014') %end; %end; %mend; %DOIT
... View more