The Little SAS® Book for Enterprise Guide® 4.1

4.1. Selecting Columns in a Query

To run a query, you must tell SAS Enterprise Guide which columns to include in the result. When you first open the Query Builder, no columns are selected. You select columns in the Select Data tab of the Query Builder window where you can also set properties for columns.

Here is a sample of the Volcanoes data table which contains six columns of data about volcanoes around the world. To create a query, click the data icon in the Project Explorer or Project Designer to make it active, and select Data Filter and Query from the menu bar. The Query Builder opens with the Select Data tab on top. You can also open the ...