About Designing Queries

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 Validate to validate your query. Use the Submit 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.