Build reports by using ODS to create HTML, PDF, RTF, Excel, text reports and more!

ods html make columns rows (swap)

Occasional Contributor
Posts: 8

ods html make columns rows (swap)

hi everyone, an amateur here Smiley Happy

..trying to find a way to have columns & rows swap their places.

You know, like you have one long row with many columns and you'd rather have it vertically, so row goes down as a column.

Is something like this possible, for html but no only?

many thanks, L.

SAS Employee
Posts: 30

Re: ods html make columns rows (swap)

It sounds like you're trying to do a transpose. Check out PROC TRANSPOSE here and see if that might be able to do what you want.

Super User
Posts: 24,028

Re: ods html make columns rows (swap)

It's not clear how ODS HTML and your table structure are related. 


It depends on your data and what you're doing but transposing data is usually a trivial task.

Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation