How to make EG generate a "calculated" keyword in Query Builder

TomKari — Sat, 12 Oct 2013 16:59:13 GMT

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!

topic How to make EG generate a "calculated" keyword in Query Builder in SAS Enterprise Guide

How to make EG generate a "calculated" keyword in Query Builder