In SAS Visual Data Builder, you might not be able to add columns that contain aggregations into your query. When you encounter this issue, nothing happens if you drag-and-drop the column from the Columns pane into the Query pane or if you double-click the column that you want to add into the query.

If you enable Developer tools in your browser and repeat the same step, the following error might appear:

This problem might occur in a scenario similar to the following:

1. Create a query in SAS Visual Data Builder.
2. Select a data set. In this example, the SASHELP.CLASS data set is used.
3. Select Sex and Age.
4. Select the aggregations GROUP BY for Sex and MAX for Age.

5. Save the query. In this example, the saved query is called DataQuery1.
6. Open a new query (in this example, it is DataQuery2) and add DataQuery1 (the query that you saved previously):

7. On the Select tab, add Sex. Note that it can be added without problems.
8. Try to add Age_MAX as well. Nothing happens when you try to add this column and an error occurs, as shown here:

To work around this problem, when creating DataQuery2, add the output table generated by DataQuery1 rather than the query itself.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Visual Analytics 7.51 is available at:

A fix for this issue for SAS Visual Analytics 7.5 is available at: