Using the except statement in the filter and query task

[DerekAdams]

Hi there.

I can write a code block with the following ,

proc sql noprint;
create table chek as
select period, t_ref, l_ref, p_ref
from closing
except
select period, t_ref, l_ref, p_ref
from new;
quit;

but can this be replicated in the filter and query task of EG? Message was edited by: holliesmate

[LinusH]

Filter and query task in EG 4.1 does not support set operators, only joins.

/Linus

[DerekAdams]

Thanks Linus