|
The MERGE macro function can be specified using braces ( {}). Simply insert the arguments within braces separated by commas (for example, TEMP = {1,2,3} is equivalent to TEMP = MERGE(1,2,3)).
|
|
TEMP = MERGE(3, 4, "five") or TEMP = {3, 4, "five"}
Creates three new columns named TEMP, VX, and VY, containing the values 3, 4, and "five " respectively.
|
|
TEMP = V1:V3 or TEMP = MERGE(V1:V3)
Creates three new columns named TEMP, VX, and VY, where TEMP is a copy of the column V1, VX is a copy of the column V2, and VY is a copy of the column V3.
|
|
Creates five new columns named TEMP, VW, VX, VY, and VZ. TEMP is a copy of column V1; VW is a copy of column V3; VX through VZ are copies of columns V5 through V7.
|
|
Creates one new column named TEMP, where each row is the average of the corresponding row across columns V1, V3, and V5. An average is only computed up to the last row of the shortest input column.
|
|
Creates five new columns named TEMP, VW, VX, VY, and VZ. TEMP is a copy of the values in rows 10-50 of column V1; VW is a copy of the values column V3; VX through VZ are copies of the values in rows 1-30 of columns V5 through V7.
|
|
TEMP = AVG(MERGE(V1, V5:V6)) or TEMP = AVG({V1, V5:V6})
|
|
Copyright IBM Corporation 2015. All Rights Reserved.
|