The Data Derivation task is used to create elements that are not typically a part of the data. For example, if your data includes the maximum CPU time and minimum CPU time, but does not show the differences between those values, you can create an element to represent this comparison.
Note: The Name Field has a maximum length of eight characters.
The Data Derivation task panel has the following fields:
Specifies the name of the desired element.
Specifies a brief description of the desired element.
Specifies the data type of the derived element. The options are Alphabetic, Date, Date Time, Hex, Numeric, Time, Time of Day, and Money.
Specifies the precision of a numerically derived element or the length of an alphabetically derived element.
Specifies the style in which the element appears in the final output, using standard SAS formatting conventions.
Displays the formula used to create the value of the element. For example, DIFCPU=MAXCPU-MINCPU;
Loads a derivation formula that was previously saved.
Stores the current derivation formula in a .QRD file. Once the Data Derivation code is saved, it can be imported into another query using the Finder button.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |