I haven't tested it in EG3, but using EG4, there is no problem writing conditions such as
WHERE age > (SELECT MEAN(age) FROM sashelp.class)
in a condition.
The only thing is that you do not have a graphic interface to write the subquery code for you.
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!