proc transpose Resources

Sponsored White Papers, Webcasts, and Downloads

Learn the Basics of Proc Transpose: PROC TRANSPOSE is a powerful yet underutilized PROC in the Base SAS toolset. This paper presents an easy before-and-after approach to learning PROC TRANSPOSE. It contains three sample SAS input files, a set of basic PROC TRANSPOSE variations, and their output results. There is a Summary Sheet at the end...; Tags: Wells Fargo & Co., PROC TRANSPOSE; White papers 2009-02-27
Some Uses (and Handy Abuses) of PROC TRANSPOSE: PROC TRANSPOSE is a powerful - and somewhat underutilized - data manipulation tool in Base SAS. Using it, one can switch the significance of row and column identifiers, either globally or selectively within BY-groups. That is to say, it permits one to switch SAS Variables columns with logical record keys...; Tags: SAS Institute, Column, PROC TRANSPOSE; White papers 2004-04-14

Turning the Data Around: PROC TRANSPOSE and Alternative Approaches: PROC TRANSPOSE can be used to "Rotate" transpose SAS data sets i.e. the values of one given variable become variable names and variables in the input data set become observations in the output. The answers to three simple questions suffice to define the specification statements of PROC TRANSPOSE. This paper...; Tags: SAS Institute; White papers 2007-05-14
An Animated Guide: Proc Transpose: If one can think about a SAS data set as being made up of columns and rows, one can say Proc Transpose "Flips" the columns of data into rows of data -and also does the reverse flips rows into columns. The ability to "Flip" data is necessary because some SAS...; Tags: SAS Institute, Column; White papers 2007-05-14
Skinny to Fat: In search of the "Ideal" Dataset: With SAS, given a "Tall" table with numerous observations for a patient, it can be difficult to analyze data between rows. While creating a "Short" dataset with all observations for a patient in one row can be accomplished with PROC TRANSPOSE, in multivariable datasets the number of TRANSPOSE statements can...; Tags: Patient, SAS Institute; White papers 2007-05-14

Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
More from IBM
How to Drive Better Business Outcomes with Exceptional Web Experiences Download the eBook
Driving Business Agility through SOA Connectivity & Integration Read the White Paper from IBM
Linking Decisions and Information for Organizational Performance Read the Tom Davenport study