https://communities.sas.com/t5/SAS-Enterprise-Guide/subqueries/m-p/2007#M673 Does SAS Enterprise Guide support the use of subqueries? I am using version 3.0.<BR /> <BR /> thanks Wed, 03 Jan 2007 01:45:43 GMT deleted_user 2007-01-03T01:45:43Z https://communities.sas.com/t5/SAS-Enterprise-Guide/subqueries/m-p/2007#M673 Does SAS Enterprise Guide support the use of subqueries? I am using version 3.0.<BR /> <BR /> thanks Wed, 03 Jan 2007 01:45:43 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/subqueries/m-p/2007#M673 deleted_user 2007-01-03T01:45:43Z https://communities.sas.com/t5/SAS-Enterprise-Guide/subqueries/m-p/2008#M674 I haven't tested it in EG3, but using EG4, there is no problem writing conditions such as <BR /> WHERE age &gt; (SELECT MEAN(age) FROM sashelp.class)<BR /> in a condition.<BR /> <BR /> The only thing is that you do not have a graphic interface to write the subquery code for you. Thu, 04 Jan 2007 09:23:20 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/subqueries/m-p/2008#M674 Olivier 2007-01-04T09:23:20Z