Using Q&R Query › Compose a New Query › Query Steps and Tasks › Query Tasks

Query Tasks

Q&R Query provides the following query tasks to modify the behavior of a step:

Data Filters

Subsets the input file based on qualifications criteria you specify.

Data Derivation

Creates a new element to include in the query file. The Data Derivation definition is automatically saved with the query; however, you can optionally save it to data derivation file (.QRD) and import it into another query.

User Code

Input SAS code without restriction. The SAS code is automatically saved with the query; however, you can optionally save the SAS code to user code file (.QRU) and import it into another query.

Note: Q&R Query does not restrict nor validate your code. You can debug the user code by looking at the SASLOG after making sure that the Options menu, Debug (Yes) is set.

Files

Specifies the source of the data input to the query step.

Key Selection

Defines keys as a collection of one or more elements used to identify each record in the data. Q&R Query initially fills in this information based on the current key structure of the file. Key Selection defines the elements to be used as keys and the order in which they appear in the output. The order of the keys impacts the Q&R Charting presentation. Q&R Charting allows the last two keys to be selected for either the X-axis or as the stack variable in 2D Stacked by Key charts.

Element Selection

Defines which elements are included in the output CSV files.

Note: By default, key elements are included in the CSV formatted file.

Statistical Selection

Identifies the type of statistics to perform on the data. The statistical calculations are performed on the selected elements using Proc Means. For example, Minimum, Maximum, Means, Standard Deviation, and Variance.