TRANSPOSE Procedure

Tips: Does not support the Output Delivery System

You can use the ATTRIB, FORMAT, LABEL, and WHERE statements. For more information, see Statements with the Same Function in Multiple Procedures. You can also use any global statement. For a list, see Global Statements in SAS Statements: Reference.

Syntax

PROC TRANSPOSE <DATA=input-data-set> <DELIMITER=delimiter> <LABEL=label> <LET>
<NAME=name> <OUT=output-data-set> <PREFIX=prefix> <SUFFIX=suffix>;
BY <DESCENDING> variable-1
<…<DESCENDING> variable-n>
<NOTSORTED>;
COPY variable(s);
ID variable;
IDLABEL variable;
VAR variable(s);

Table of Procedure Tasks

Statement Task Example
PROC TRANSPOSE Statement Create an output data set by restructuring the values in a SAS data set, transposing selected variables into observations Ex. 1, Ex. 2, Ex. 3, Ex. 5
BY Statement Transpose each BY group Ex. 4
COPY Statement Copy variables directly without transposing them Ex. 6
ID Statement Specify a variable whose values name the transposed variables Ex. 2
IDLABEL Statement Create labels for the transposed variables Ex. 3
VAR Statement List the variables to transpose Ex. 4, Ex. 6