Transcription of PROC TRANSPOSE FOR MULTIPLE VALUES KANHAIYA …
{{id}} {{{paragraph}}}
Example: quiz answers
PROC TRANSPOSE FOR MULTIPLE VALUES KANHAIYA …
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.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
The SORT Procedure: Beyond the Basics, Sort, PROC SORT, PROC SORT Options NODUPRECS and NODUPKEY Revealed, Removing Duplicates Using SAS, 060-2009: Learn the Basics of PROC TRANSPOSE, 060-2009 Learn the Basics of Proc Transpose, PROC, SAS programs for making SDTM DM, Using the COMPUTE Block in PROC REPORT, Advanced Subqueries In PROC SQL, Converting Numeric and Character Data