turn columns and rows in output

[Dao4free]

Hello everyone!
I need to turn columns and rows in output report.
If someone has any idea , I will be very thankful


Pavel

 

[dblan]

I'm not 100% what you are looking for, but if you want to turn columns into rows, you can use proc transpose.

For example, it can turn table:
Year Month Count
2007 Jan 2
2007 Feb 3
2008 Jan 4
2008 Feb 5

into:
Year Jan Feb
2007 2 3
2008 4 5

proc transpose data=<tablein> out=<tableout>;
by <field1> (Year in this ex);
id <field2> (Month in thie ex);
var <field3> (Count in this ex);
run;

 

[klaz2002]

Can you give an example of what you need to do? Otherwise, dblan has answered this question.

Klaz

 

[Dao4free]

I want to turn over my output table (html or excel) but with the assistance of SAS command, columns would be rows and reversed.See the example down there.
Dblan , klaz2002 thank you for the help.

site Vigo Duration Days
2-BUFF . . .
3-UUHS . . .
4-MKD . . .
6-UVR . . .




site 2-BUFF 3-UUHS 4-MKD 6-UVR
Vigo . . . .
Duration. . . .
Days . . . .





P.S.proc transpose reverses data, but I need to reverse only output