220 The Little SAS Book for Enterprise Guide 4.2 4.10 Changing the Result Type of Queries When you run a query using the Query Builder, you have a choice about the type of result the query produces. A query can produce a SAS data table, a SAS data view, or a report. A SAS data view is similar to a SAS data table, except that it does not contain any data. Instead, SAS data views contain the instructions required to create a new data table. Data tables and views generated by the Query Builder can be used as a source of data for tasks. Reports are for viewing or printing only. Chapter 4 Setting the default result type The default result type for queries is a data table, but you can change the default. To do this, open the Options window by selecting Tools Options from the menu bar. Click Query in the selection pane on the left to open the Query page. Near the bottom of this page is a drop-down list under Save query result set as. Select the desired result type. All subsequent queries you build will use this as the default result type.