Using the Design Tab

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:
  • Drag and drop tables or data 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 the Validate button 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.

See Also

Working with Tables in Data Queries
Working with Columns in Data Queries
Working with Filters in Data Queries
Working with Joins in Data Queries
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 8, 2019