The TRANSPOSE procedure always produces an output data
of whether you specify the OUT= option in the PROC TRANSPOSE statement. PROC
TRANSPOSE does not print the output data set. Use PROC PRINT, PROC REPORT
or some other SAS reporting tool to print the output data set.
The output data set contains the following variables:
- All transposed variables are the same type and length.
- If all variables that the procedure is transposing are numeric,
the transposed variables are numeric. Thus, if the numeric variable has a
character string as a formatted value, its unformatted numeric value is transposed.
- If any variable that the procedure is transposing is character,
all transposed variables are character. Thus, if you are transposing a numeric
variable that has a character string as a formatted value, the formatted value
- The length of the transposed variables is equal to the length
of the longest variable being transposed.
PROC TRANSPOSE names
transposed variables using the following
- An ID statement specifies a variable in the input data set whose
formatted values become names for the transposed variables.
- The PREFIX= option specifies a prefix to use in constructing the
names of transposed variables.
- If you do not use an ID statement or the PREFIX= option, PROC
TRANSPOSE looks for an input variable called _NAME_ from which to get the
names of the transposed variables.
- If you do not use an ID statement or the PREFIX= option, and the
input data set does not contain a variable named _NAME_, PROC TRANSPOSE assigns
the names COL1, COL2, . . . , COLn to the transposed
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.