ROWCAT Function
concatenates rows without using blank compression
- ROWCAT( matrix<, rows<, columns>>);
The inputs to the ROWCAT function are as follows:
- matrix
- is a character matrix or quoted literal.
- rows
- select the rows of matrix.
- columns
- select the columns of matrix.
The ROWCAT function takes a character matrix or submatrix as its
argument and creates a new matrix with one column whose elements
are the concatenation of all row elements into a single string.
If the argument has n rows and m columns,
the result willhave n rows and 1 column.
The element length of the result will be m
times the element length of the argument.
The optional rows and columns arguments may be used
to select which rows and columns are concatenated.
For example, the statements
b={"ABC" "D " "EF ",
" GH" " I " " JK"};
a=rowcat(b);
produce the 2 ×1 matrix:
A 2 rows 1 col (character, size 9)
ABCD EF
GH I JK
Quotes (") are needed only if you want to embed blanks or special
characters or to maintain uppercase and lowercase distinctions.
The form
- ROWCAT( matrix, rows, columns)
returns the same result as
- ROWCAT( matrix[rows, columns])
The form
- ROWCAT( matrix, rows)
returns the same result as
- ROWCAT( matrix[rows,])
Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.