xxxxxxxxxx
ods excel file="/shares/spoint_ops_analytics/Logistics Library/Perfect Delivery/Errors Detail/Perfect_Delivery_Errors_Detail.xlsx" options(sheet_name='ERRORS_DETAIL');
proc report data=WORK.ERRORS_TO_INCLUDE_FORMAT;
columns _all_;
run;
ods excel close;
xxxxxxxxxx
%let Today = &SYSDate9;
ods _all_ close;
proc export data=WORK.ERRORS_TO_INCLUDE
outfile="/shares/spoint_ops_analytics/Logistics Library/Perfect Delivery/Errors Detail/Perfect_Delivery_Errors_Detail_&Today.xls"
dbms=xls replace;
sheet='ERRORS DETAIL';
run;
quit;