Desktop productivity for business analysts and programmers

Using the except statement in the filter and query task

Reply
Contributor
Posts: 30

Using the except statement in the filter and query task

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
Esteemed Advisor
Posts: 5,202

Re: Using the except statement in the filter and query task

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

/Linus
Data never sleeps
Contributor
Posts: 30

Re: Using the except statement in the filter and query task

Thanks Linus
Ask a Question
Discussion stats
  • 2 replies
  • 198 views
  • 0 likes
  • 2 in conversation