BookmarkSubscribeRSS Feed
TomKari
Onyx | Level 15

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!

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 0 replies
  • 1140 views
  • 0 likes
  • 1 in conversation