topic Re: How do I get a HAVING clause in Filter & Query without manual coding in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-get-a-HAVING-clause-in-Filter-Query-without-manual/m-p/34903#M4409 You have the interface for the HAVING clause under the one for the WHERE clause, in the "Filter data" tab.<BR /> Sorry for showing no screen capture, but I can't see how to attach it.<BR /> <BR /> Olivier Fri, 01 Aug 2008 07:52:21 GMT Olivier 2008-08-01T07:52:21Z How do I get a HAVING clause in Filter & Query without manual coding https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-get-a-HAVING-clause-in-Filter-Query-without-manual/m-p/34902#M4408 In SAS/EG 4.1 (4.1.0.521) I am trying to use a HAVING clause in a Filter &amp; Query but I cannot see an obvious place in the Wizard. <BR /> <BR /> Problem Note 311 (http://support.sas.com/kb/3/311.html) suggests that simple HAVING clauses may be built from the interface ie without manual coding in a code module.<BR /> <BR /> Any thoughts or suggestions anyone ?<BR /> <BR /> May thanks.<BR /> <BR /> Down-Under-Dave<BR /> Wellington<BR /> New Zealand Wed, 30 Jul 2008 01:02:10 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-get-a-HAVING-clause-in-Filter-Query-without-manual/m-p/34902#M4408 DaveShea 2008-07-30T01:02:10Z Re: How do I get a HAVING clause in Filter & Query without manual coding https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-get-a-HAVING-clause-in-Filter-Query-without-manual/m-p/34903#M4409 You have the interface for the HAVING clause under the one for the WHERE clause, in the "Filter data" tab.<BR /> Sorry for showing no screen capture, but I can't see how to attach it.<BR /> <BR /> Olivier Fri, 01 Aug 2008 07:52:21 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-get-a-HAVING-clause-in-Filter-Query-without-manual/m-p/34903#M4409 Olivier 2008-08-01T07:52:21Z Re: How do I get a HAVING clause in Filter & Query without manual coding https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-get-a-HAVING-clause-in-Filter-Query-without-manual/m-p/34904#M4410 Olivier,<BR /> <BR /> Many thanks for your reply. It's very clear now you have pointed it out!<BR /> <BR /> Cheers.<BR /> <BR /> Down-Under-Dave<BR /> Wellington<BR /> New Zealand Sun, 03 Aug 2008 09:52:37 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-get-a-HAVING-clause-in-Filter-Query-without-manual/m-p/34904#M4410 DaveShea 2008-08-03T09:52:37Z