[an error occurred while processing this directive]

Reading into the PDV: where, keep, and in

When using a WHERE statement, don't use formulae as far as possible. That is, say

  where date>='01Jan1996'd;

rather than

  where year(date)>=1996;

WHERE statements can be used with OUTPUT statements. (WHERE=)