Taking Art's example from
http://communities.sas.com/message/118406#118406
as a starting point:
proc sql;
create table want as
select sum(sex='M') as a,
count(*) as b,
calculated a/calculated b as c
from sashelp.class
;
quit;
but trying to replicate it using the EG query builder, I can get the query builder to create a and b as advanced expressions, but when I try to create c as an advanced expression of dividing b into a by clicking on them, it reuses the formulas. If I manually type in calculated a / calculated b, it works fine.
Does anybody know how I can get EG to use "calculated a" instead of the formula for a when I use it in the Query Builder?
Tom
P.S. I'm doubting my sanity. I'm SURE this used to happen in an earlier version of EG!