The design view is the
default view for working with queries. This view provides an easy
to use interface for designing a query. You can perform the following
tasks with the design view:
-
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 dragging 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 on the workspace or by
right-clicking the table and selecting
Add All Columns.
-
use the
Column Editor tab
to specify column expressions, aggregations, and sort. You can also
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.
-
check the
Messages tab
for information about warnings and errors such as invalid column expressions.
-
open the
Properties panel
to specify the output table information.