The
Design tab
is the default view for working with queries. This tab provides an
easy-to-use interface for designing a query. You can perform the following
tasks with the
Design tab:
-
Drag and drop tables or queries
from the SAS Folders tree onto the workspace.
-
Join tables by using your pointer
to select the source column, and then drag the pointer to the corresponding
column in the joined table.
-
Add columns to the
Column Editor tab
by clicking the column name from the table in the workspace or by
right-clicking on the table and selecting
Add All Columns.
-
Use the
Column Editor tab
to specify column expressions, aggregations, and sort. You can set
the attributes for a column, such as the type, format, and label.
-
View the
Output Columns tab
to see the number of output columns and attributes. When you specify
aggregations and pivot by columns, the number of output columns can
increase dramatically.
-
Click
to check that the query is valid.
-
Check the
Messages tab
for information about warnings and errors such as invalid column expressions.
-
Check the
Log tab
to view the SAS log. A SAS log is generated when you preview, run,
or validate a query.
-
Use the
Properties tab
in the right pane to specify output table information.