As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

A Row Is a Row Is a Row, or Is it? A Hands-on Guide to Transposing Your Data

From sasCommunity
Jump to: navigation, search


Sometimes life would be easier for the busy SAS programmer if information stored across multiple rows were all accessible in one observation, using additional columns to hold that data. Sometimes it makes more sense to turn a short, wide data set into a long, skinny one -- convert columns into rows. Base SAS® provides two primary methods for converting rows into columns or vice versa – PROC TRANSPOSE and the DATA step. How do these methods work? Which is best suited to different transposition problems? The purpose of this workshop is to demonstrate various types of transpositions using the DATA step and to “unpack” the TRANSPOSE procedure. Afterwards, you should be the office go-to gal/guy for reshaping data.

Online Materials

View the pdf for A Row is a Row is a Row, or Is It? A Hands-on Guide to Transposing Your Data.

Contact Info

Please check out my user page. You can also email me.