https://communities.sas.com/t5/SAS-Enterprise-Guide/Using-the-except-statement-in-the-filter-and-query-task/m-p/66736#M6691 Filter and query task in EG 4.1 does not support set operators, only joins.<BR /> <BR /> /Linus Fri, 09 Jan 2009 11:18:39 GMT LinusH 2009-01-09T11:18:39Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Using-the-except-statement-in-the-filter-and-query-task/m-p/66735#M6690 Hi there.<BR /> <BR /> I can write a code block with the following ,<BR /> <BR /> proc sql noprint;<BR /> create table chek as<BR /> select period, t_ref, l_ref, p_ref <BR /> from closing<BR /> except<BR /> select period, t_ref, l_ref, p_ref <BR /> from new;<BR /> quit;<BR /> <BR /> but can this be replicated in the filter and query task of EG? Message was edited by: holliesmate Sat, 20 Dec 2008 03:34:04 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Using-the-except-statement-in-the-filter-and-query-task/m-p/66735#M6690 DerekAdams 2008-12-20T03:34:04Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Using-the-except-statement-in-the-filter-and-query-task/m-p/66736#M6691 Filter and query task in EG 4.1 does not support set operators, only joins.<BR /> <BR /> /Linus Fri, 09 Jan 2009 11:18:39 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Using-the-except-statement-in-the-filter-and-query-task/m-p/66736#M6691 LinusH 2009-01-09T11:18:39Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Using-the-except-statement-in-the-filter-and-query-task/m-p/66737#M6692 Thanks Linus Fri, 09 Jan 2009 18:49:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Using-the-except-statement-in-the-filter-and-query-task/m-p/66737#M6692 DerekAdams 2009-01-09T18:49:12Z