Filtering

Data Controller for SAS® enables you to create complex table filters. The "dynamic" setting enables the dropdown values to be pre-filtered by previous filter clauses. Filtered views are shareable! They are also used when embedded in VA.

The clause shown above the grid is the resolved WHERE clause that was applied, so it uses SAS syntax - a date, datetime or time filter reads as a SAS literal, eg SOME_DATE = '20APR2042'd, rather than the internal day or second count.

Shared Filters

When filters are submitted, the query is stored, and a unique URL is generated. This means you can share the link to a filtered view of a table! This can be used for VIEW, for EDIT and also for downloading data.

Dynamic Where Clause

When filtering without a dynamic where clause, all values are always returned in the selection box.

By contrast, when the dynamic where clause box is checked (default), the values in the second and subsequent filter clauses are filtered by the previous filter clause settings, eg: