![]() |
The COLUMN macro function can be abbreviated by listing the data arguments separated by commas inside parentheses (for example, (for example, TEMP = MEAN((1,2,3,4), ALL). If not used inside another macro function, the pair of parentheses is not necessary (for example, V1=1,2,3 is equivalent to V1=COLUMN(1,2,3).
|
Creates a new column named TEMP with the first three cells containing the values "one ", "two ", and " three ".
|
Creates a new column named TEMP with the average of column V1 in the first cell and the standard deviation of column V1 in the second cell.
|
Creates two new columns named TEMP and VX where the column TEMP contains the values from column V1 followed by the values from column V3. The column VX contains the values from column V2 followed by the values from column V4.
|
Creates two new columns named TEMP and VX where the column TEMP contains the values from cells 1-10 of column V1 followed by all the values from column V3. The column VX contains the values from cells 1-10 of column V2 followed by all the values from column V4.
|
Creates two new columns named TEMP and VX, each containing a single value. The column TEMP contains the average of columns V1 and V2. The column VX contains the average of columns V3 and V4.
|
Copyright IBM Corporation 2012. All Rights Reserved.
|