Creating vertical detail tables
===

I'm looking for a way to create vertical tables in SAS where the variables are each treated as rows (as opposed to each row being an observation).

For example lets say I have some data for a bunch of companies, some of which is more important than others.  It is easy to make proc report spit out a summary table with a few variables like this:

    Name Price Shares MarketCap
    co1    $5    100    $500
    co2    $1    100    $100
    co3    $2    200    $400

What I want to do after this is print a page of detailed information for each company which is essentially a table with a column for the description and a column for the value (and maybe a third column for the calculation).

    Company 1
    
       Location:   CA
            CEO:   Bob Johnson
       Industry:   Semiconductors
    
         Shares:   100
    Share Price:   $5
     Market Cap:   $500

The only way I can think of to do this in SAS is to basically transpose everything, create a new character variable that has the label (Location, Stock Price, Etc) and a second character variable that has the value and then make a two column report BY company to get a page for each. This is messy since some of the values are numeric and others are character so to get them to display on one column requires creating a new character variable and filling it with text versions of the numeric variables.

I figure there has got to be an easier way to create a vertical table since there are so many easy ways to create the horizontal tables.
