Introduction › How to Navigate through Q&R Query › Menu Options

Menu Options

Most menu functions can be performed using toolbar buttons.

Note: Most of the functions have shortcut keys that can be used instead of clicking the toolbar button.

Additional functions that do not have toolbar equivalents are described in the following list:

• File, Save Macros—Saves the SAS code generated from your query to a query macro file (.QRM) so it can be run in production on the mainframe.
• File, Save As Template—Saves the Steps of your query in template (.QRT) format so it can be used to create similar queries.
• File, Delete Query, Delete Template—Deletes a query definition file (.QRQ) or query template file (.QRT) from the disk.
• View, Viewing, and Navigation options—Available for Q&R Charting. The viewing options let you choose between a Chart Only, Properties Only, or Chart and Properties view of the Q&R Charting window. The navigation options (First, Previous, Next, and Last) provide an alternate means of moving between charts and views.
• Options, Debug Options—Turns debugging on and off. If debugging is turned on, debug information can be viewed in the SASLOG. Turning on debug can be helpful in diagnosing problems in SAS code entered in a Data Derivation or User Code step.

  Default: Sets the debugging option to the same setting as the Q&R Mainframe Server.

• Options, Settings:

  Excel Tab

  Use this tab to modify your Microsoft Excel directory path.

  Other Tab

  The Other tab is comprised of two features:

  • Use Smart Update—By default, Smart Update is active. When selected, Q&R Query automatically invokes Smart Update processing whenever a query is opened. Smart Update processing automatically identifies and helps to correct discrepancies between existing queries and the current Meta Database. With Smart Update you can modify the Q&R Mainframe Server, complex or unit values across all files in an existing query.
  • Use Notepad as my default editor—By default, this option is inactive. When selected, SASLOG and SASLIST displays are automatically presented through the Notepad application instead of the normal Q&R Query application dialog. Select this option if you prefer the capabilities of Notepad for viewing SASLOG and SASLIST files over the capabilities provided by the normal Q&R Query application panel.

• Options, Extract data using long labels—By default, this option is active. When selected, the column names in CSV output created by running a Q&R Query will be long descriptive element names. When not selected, the CSV output will contain short (eight character) element names.
• Options, Run with completed query only—By default, this option is active. When this option is selected, a query that contains validation errors will not run unless you approve the option to run it anyway. When not selected, the prompt is not displayed and the query is submitted to the mainframe.
• Options, Connect to a Q&R Distributed Server—Lets you change the Q&R Distributed Server to which you are connected. When selected, you will be prompted to close all currently open Q&R windows, then the Q&R Query Connect window appears. Fill in the IP address and port number of the Q&R Distributed Server you want to connect to and click ok. You will be connected to the new Q&R Distributed Server. In addition, this server becomes the default used the next time you start Q&R Query.

  Notes:

  • The Q&R Distributed Server that you are configured to connect to and the status of the connection are displayed in the status bar of the Q&R Query window. If your connection to the Q&R Distributed Server is disconnected, you can use this option or you can click the server name in the status bar.
  • In order to ensure that your Q&R Query environment is properly synchronized with the Q&R Distributed Server, all current Q&R Query windows will be closed prior to establishing or reestablishing a Q&R Distributed Server connection. You will be prompted to save any modified queries or view definitions before a new connection is made.