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);

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