Cheat Sheet for Data Queries

Add another data source.

Drag and drop the table or data query from the SAS Folders tree onto the workspace.

Add an aggregation to an existing column.

On the Column Editor tab, click to highlight the Aggregations cell for the column to which you want to add an aggregation, and click the ellipsis button.

Create a calculated column.

On the Column Editor tab, click the plus sign (+) to the left of the last entry in the Column Name list. A new line appears. Click to highlight the Expression cell of the new line, and click .

Filter data.

Click the Where or Having tab, depending on how you want to filter the data.

Change or add a join condition.

On the Joins tab, click the plus sign (+).

Delete a column.

On the Column Editor tab, right-click the name of the column, and select Remove Column.

Pivot data.

On the Column Editor tab, click to highlight the Pivot By cell for the column that you want to pivot values, and then click the ellipsis button.

Sort data.

On the Column Editor tab, click to highlight the Sort cell for the column by which you want to sort the data. Select the sort preference from the drop-down list.

Validate a data query.

On the toolbar, click .

Preview the results of a data query.

On the toolbar, click , and select Preview to preview the results.

Save a data query.

On the toolbar, click .

Run a data query.

After saving the data query, on the toolbar, click , and select Run to run the data query.

Schedule the data query to run.

After saving the data query, on the toolbar, click . In the Schedule dialog box, specify information.

View the results of a data query.

After you preview or run the data query, click the Results tab.