|
The LIKE macro has a negative version, NOT LIKE. The format for this is identical to LIKE. NOT LIKE returns a one if the string in data1 does not match the template defined by data2.
|
Creates a new column named TEMP containing the value one (since the two strings match).
|
Creates a new column named TEMP containing the value one (string compares are case insensitive).
|
Creates a new column named TEMP, where each value is one if the corresponding row value of the column V1 is equal to the string "gold" followed by any number of characters. Otherwise, each value is zero.
|
Creates a new column named TEMP, where each value is one if the corresponding row value of the column V1 is equal to the string "g" followed by any character, followed by "ld". Otherwise, each value is zero.
|
Creates a new column named TEMP containing all ones (since every number is equal to itself).
|
Creates a new column named TEMP, where each value is the row value of column V1 compared to the corresponding row value of column V2.
|
Creates three new columns named TEMP, VX, and VY. The column TEMP contains the strings in V1 compared to the corresponding row strings of column V4. The column VX compares columns V2 and V5. The column VY compares columns V3 and V6.
|
TEMP = V1[10:20] LIKE V2 or TEMP = V1[10:20] LIKE V2[1:11]
Creates a new column named TEMP, where the first 11 cells contain the results of comparing the strings in rows 10-20 of column V1 to rows 1-11 of column V2. The other cells in TEMP are empty.
|
Copyright IBM Corporation 2013. All Rights Reserved.
|