Data visualization with SAS programming

ODS Labels are not printing..

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

ODS Labels are not printing..

[ Edited ]
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*/

Accepted Solutions
Solution
2 weeks ago
SAS Employee
Posts: 118

Re: ODS Labels are not printing..

Have you tried specifying the LABEL option in the PROC PRINT statement?

View solution in original post


All Replies
Solution
2 weeks ago
SAS Employee
Posts: 118

Re: ODS Labels are not printing..

Have you tried specifying the LABEL option in the PROC PRINT statement?

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 111 views
  • 0 likes
  • 2 in conversation