Hi Everyone, I am running 20 simulations that return 1 line of information each. I am looking at taking these line (that returns in a separate tab of excel) and automatically exporting them into one excel document. Currenlty I have: ODS EXCEL FILE=" C:\Users\len676\Desktop\Simulation_Novack\Log[x]\A_log_gamma_results.xls" /*style=normal*/; ODS EXCEL options ( sheet_name="result 1"); ODS EXCEL options ( sheet_name="Result_2"); proc print data=MM.RESULT_2 NOOBS label ;run; ODS EXCEL options ( sheet_name="Result_3"); proc print data=MM.RESULT_3 NOOBS label;run; ODS EXCEL options ( sheet_name="Result_4"); proc print data=MM.RESULT_4 NOOBS label ;run; ODS EXCEL options ( sheet_name="Result_5"); proc print data=MM.RESULT_5 NOOBS label;run; ODS EXCEL options ( sheet_name="Result_6"); proc print data=MM.RESULT_6 NOOBS label ;run; (this countinues to RESULT_20) proc print data=RESULT_2 NOOBS label ;run; ODS EXCEL CLOSE; ODS LISTING;
... View more