The
Design tab is the default view for working with
data queries. This tab provides an easy-to-use interface for creating a
data query. You can perform the following tasks with the
Design tab:
-
-
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 data 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 data query.
-
Use the
Outputs tab in the right pane to specify
output table information.