PROC TRANSPOSE FOR MULTIPLE VALUES KANHAIYA …

← Back to document page

PROC TRANSPOSE FOR MULTIPLE VALUESKANHAIYA GUPTA, TCS, FOND DU LAC, WISCONSINABSTRACTPROC TRANSPOSE can be used to rotate ( TRANSPOSE ) SAS data sets. This procedure transforms the data from rows to columns or from columns to rows. But PROC TRANSPOSE has some limitations. It doesn't works as required for MULTIPLE VALUES of VAR parameter FOR ID/BY parameter. This paper demonstrates how TRANSPOSE can be done when VAR parameter has MULTIPLE VALUES without losing any record in TRANSPOSEPROC TRANSPOSE <DATA=input-data-set> <LABEL=label> <LET> <NAME=name> <OUT=output-data-set> <PREFIX=prefix>;BY <DESCENDING> variable-1 <...<DESCENDING> variable-n> <NOTSORTED>;COPY variable(s);ID variable;IDLABEL variable;VAR variable(s);OptionsDATA= input-data-set names the SAS data set to : most recently created SAS data setLABEL= label specifies a name for the variable in the output data set that contains the label of the variable that is being transposed to create the current : _LABEL_LET allows duplicate VALUES of an ID variable.

PROC TRANSPOSE FOR MULTIPLE VALUES KANHAIYA GUPTA, TCS, FOND DU LAC, WISCONSIN ABSTRACT PROC TRANSPOSE can be used to rotate (transpose) SAS data sets.

  Multiple, Value, Corps, Transpose, Proc transpose for multiple values kanhaiya, Kanhaiya