You can use the Where and Having
tabs to filter data in SAS Visual Data Builder.
The SQL expression on
the
Where tab is applied to the input data. This SQL expression is often used to
subset data on the columns in the
source tables.
The SQL expression on
the
Having tab can be applied to either the input data or the
calculated columns. This SQL expression is typically used to subset data on calculated columns in the
output table.
The maximum length for a WHERE or HAVING clause is 4096
characters.