Number of Columns Must Match
When two or more data ranges are provided as input and column-wise computations are performed, the two data ranges must contain the same number of columns. Otherwise, only the dimensions of the smaller data range are used (some macro functions will signal an error). If the data ranges contain a different number of rows, most macro functions perform computations up to and including the last row of the shortest column.
*
For example, with column ranges, the macro definition V6 = V1:V3 AND V4:V6 generates three output columns (both data ranges contain three columns). Column V1 is AND-ed with column V4; column V2 is AND-ed with V5 and column V3 is AND-ed with V6. However, V6 = V1:V3 AND V4:V5 returns only two output columns (the first column range contains three columns, the second contains only two, and the lesser of the two is used). In this case, column V1 is AND-ed with column V4 and column V2 is AND-ed with V5. Column V3 is not used.
*
With cell ranges, the macro definition V7 = V1[1:5]:V2 AND V4[10:50]:V5 generates two output columns (both input ranges have two columns). The output columns V7 and V8 will contain five values (cells 1-5 AND-ed with cells 10-14). The macro definition V7 = V1[1:5]:V2 AND V4 generates only one output column, because the second data range contains only one column.
*
Specifying a column without a cell range is equivalent to specifying the entire column (that is, a cell range of one through the length of the column).
Copyright IBM Corporation 2015. All Rights Reserved.