Could someone please help me with how SAS/SQL processes nested queries or subqueries. Would it do the inner select, "select sum(price) from MasterFile" only once or with each iteration of the outer query? proc sql;
create table categorySpend as
select categoryid, sum (price) as CategoryRevenue, (select sum(price) from MasterFile)as TotalRevenue
from MasterFile
group by categoryid;
quit;
... View more