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.