Transcription of PROC TRANSPOSE FOR MULTIPLE VALUES …
{{id}} {{{paragraph}}}
Example: biology
PROC TRANSPOSE FOR MULTIPLE VALUES …
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 …
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
Without PROC SQL and, WITHOUT PROC SQL AND THE MACRO LANGUAGE, Proc SQL, Introduction to Proc SQL, PROC, Become Really Productive, Become Really Productive Using PROC SQL, Queries, Joins, and WHERE Clauses, Advanced Subqueries In PROC SQL, A Primer for SAS Programmers, Structured Query Language, Big data in R, Columbia University, Microsoft SharePoint Server 2013, SharePoint Server 2013