On the excel sheet, the labels are not printing. It is using the column names instead. What am I missing in my code?
ods EXCEL file="\\networkfilepath_&SYSDATE..xlsx" ;
ods EXCEL options(sheet_name='Negative Margin Audit');
proc print data=work.AP_Audit_NegMgn3
style (header) = {background=cyan}
style (grandtotal) = {background=cyan} ;
format order_margin dollar10.2;
format movement_margin dollar10.2;
format total_charge dollar10.2;
format Carrier_Pay dollar10.2;
format Carrier_Extra_Pay dollar10.2;
format Carrier_Total_Pay dollar10.2;
label order_id = 'Order ID'
movement_id = 'Movement ID'
Dispatcher_User = 'Dispatcher User'
office_code = 'Dispatcher Office'
operations_user = 'Operations User'
customer_id = 'Customer ID'
revenue_code_id = 'Revenue Code'
override_payee_id = 'Carrier Code'
Order_Status = 'Order Status'
bill_distance = 'Order Distance'
total_charge = 'Revenue'
Carrier_Pay = 'Carrier Pay'
Carrier_Extra_Pay = 'Carrier Extra Pay'
Carrier_Total_Pay = 'Carrier Total Pay'
Order_Margin = 'Order Margin'
movement_margin = 'Movement Margin'
processing_status = 'Processing Status'
Broker_Commission_Eligible = 'Broker Commission Eligible'
bol_received = 'BOL Received'
Delivery_Date = 'Delivery Date'
ordered_date = 'Ordered Date'
Dispatch_Date = 'Dispatched Date'
Origin_City = 'Origin City'
Origin_State = 'Origin State'
Destin_City = 'Destination City'
Destin_State = 'Destination State';
sum order_margin;
sum movement_margin;
sum total_charge;
sum carrier_pay;
sum carrier_extra_pay;
sum carrier_total_pay;
run;
ods EXCEL close;
/*Create EXCEL file using work table data*/
