This code wouldn't work as is. Here's a draft, untested that would be closer.
ods excel file="M:\CLIENT SERVICES\Employee Folders\Eddie\Statistics\Dual
Feed Raw Data.xlsx"
options(sheet_interval="none"
sheet_name="Dual Feed Raw Data");
title "Dual Feed Raw Data";
proc print data=work.report2;
run;
options(sheet_interval="none"
sheet_name="Average Total Attribution");
title "Average Total Attribution";
proc means data=work.report2;
var Total_Attributed;
run;
ods excel close;
There's still a bug about getting sheet interval properly set up, see this post:
https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-excel-amp-multiple-sheets/m-p/261953/highlight/true#M15551
... View more
