Expression Builder
The Expression Builder is a component that enables you to create
SAS expressions that aggregate columns, perform conditional processing,
and perform other tasks in a SAS Data Integration Studio job. For
example, the following display shows an expression used in a WHERE
clause in an SQL query.
The Expression
Builder is displayed from tabs in the property windows of many SAS
Data Integration Studio transformations. It is used to add or update
expressions in SAS, SQL, or MDX. The expression can transform columns,
provide conditional processing, calculate new values, and assign new
values. The expressions specify the following elements, among others:
An expression
can be as simple as a constant or a column name, or an expression
can contain multiple operations connected by logical operators. For
example, an expression to define how the values for the column COMMISSION
are calculated can be
amount * .01.
An example of conditional processing to subset data can be amount > 10000 and region = 'NE'. Other examples
are an expression to convert a character date into a SAS date or an
expression to concatenated columns.