topic Re: I am not getting any output, only the title in SAS Programming

I am not getting any output, only the title

Oreolover25 — Fri, 28 Jan 2022 21:07:05 GMT

proc sql;
title "Employee with the Highest Total Sales";
select Employee_ID ne 99999999, sum(Total_retail_price*Quantity) as Total_Sales
from orion.Order_Fact
group by Employee_ID
having calculated Total_Sales >= all
(select sum(Total_retail_price*Quantity) as Total_Sales
from orion.Order_Fact)
;
quit;
title;

Re: I am not getting any output, only the title

Oreolover25 — Fri, 28 Jan 2022 21:08:46 GMT

Note: I am trying to calculate the employee with the maximum salary

Re: I am not getting any output, only the title

Amir — Fri, 28 Jan 2022 21:18:13 GMT

Hi,

Have you checked the log? Please share the log using the "</>" (Insert Code) icon, so that we can see the code being executed and any messages..

Kind regards,

Amir.