proc sql; select Manager_Name, Employee_Name, Total_Sales format=COMMA10.2 from (select l.Employee_ID, sum(Total_Retail_Price) as Total_Sales, Employee_Name, Country from orion.order_fact as l, orion.employee_addresses as p where l.Employee_ID=p.Employee_ID and year(Order_Date)=2011 Group by Country, l.Employee_ID, Employee_Name) as l, (select l.Employee_ID, Manager_ID, Employee_Name as Manager_Name from orion.employee_organization as l, orion.employee_addresses as p where l.Manager_ID=p.Employee_ID) as p where l.Employee_ID=p.Employee_ID Order by Country, Manager_Name, Total_Sales desc; quit; Employee_Name is shown as Zhou, Tom, but I need it to change it to Tom Zhou
... View more