Creating a Query

Creating a New Query

On the main SAS Studio toolbar, click New Options button and select New Query. A query window opens on a new tab in the work area.
New Query Window

Adding Tables to a Query

On the Tables tab in the query window, click Add button and select Table. From the Choose a Table window, expand the appropriate library and select the table that you want to use. The table is added to the query.
Note: You can also add tables to the query by using the Libraries of the navigation pane. Click Libraries and expand the appropriate library. Drag the table that you want to use to the Tables tab of the query window.