Menus

The File menu contains actions that allow a user to open existing queries and save newly created or modified queries. Also available in the File menu are actions that allow the current query to be cleared or to establish a new connection to a different datasource.

Check your application to see if each of the actions described below is available for use. Some applications or platforms restrict which actions are presented to the user.

File

New

New Query Clears the exsting query definition and allows user to begin creating a new query.
 Open 

Open from a file Allows user to specify an existing file to read and then visually display.
 

Open from dataset view Allows user to specify an existing SAS view to read and then visually display.

Save

Save to a file Saves the current definition of the query to a file.
 

Save dataset view Saves the current definition of the query as a SAS view. The view can then be used by other SAS applications.
 

Save results as dataset Executes the query and saves the output rows in a new SAS dataset.
View

View Results Displays a non-modal dialog for viewing the results of the query.

Advanced Joins Allows for changing the order of joins in the query. Relationships can also be inserted, modified and deleted.
Insert

Insert Table Allows the user to insert as many tables into the query as needed.