You
can use SAS Visual Data Builder to design queries that perform
analytic data preparation. You can use a query to subset, sort, join,
and add calculated columns to tables.
As you design your query,
you can click

to validate your query. Use the

button to preview or run the query.
The preview option uses
a temporary table for the results. You can run the query after you
specify an output table for the query and save the query.