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
Without PROC SQL and the Macro, WITHOUT PROC SQL AND THE MACRO LANGUAGE, MACRO, PROC SQL, SQL Procedure: User's Guide, SAS Macro, Calculating Statistics Using PROC MEANS, PROC, Become Really Productive Using PROC, Become Really Productive Using PROC SQL, Advanced Subqueries In PROC SQL, Techniques and Information for Programming, Data Normalization for Dummies Using SAS, System do the work! Automate your SAS