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!

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register 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
  • 959 views
  • 0 likes
  • 1 in conversation