Question

When grouping is in effect, can the WHERE clause be used in PROC SQL to subset data?

Answer 1

No. In order to subset data when grouping is in effect, the HAVING clause must be used. The variable specified in having clause must contain summary statistics.

PROC SQL Made Easy