Specify a Column Expression
To specify a column
expression:
-
On the Column Editor tab, specify a name for the column.
-
Select
table-name.column-namefrom the Expression column. If you added a new column manually, then you must make sure that you specified a table name and a column name. -
Click
to open the expression builder. The table name and
column name are added automatically as the default SQL expression.
The expression is limited to 1024 characters. -
On the Fields tab, select columns from the source tables that you have added to the data query.
-
On the Functions tab, select the functions to apply to the source column.
-
Enter arithmetic operators and expressions such as CASE statements directly in the SQL expression area.
-
Click Apply to save the column expression.
Note: If you click 
after you click Apply, then
your last change to the expression is undone. However, because the
expression window is closed, you might not notice the undo.
after you click Apply, then
your last change to the expression is undone. However, because the
expression window is closed, you might not notice the undo.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 8, 2019