BookmarkSubscribeRSS Feed

Spanning Headers in PROC REPORT

Started ‎07-06-2018 by
Modified ‎07-06-2018 by
Views 23,859

The text of a spanning header is used to form a label for multiple columns. The text for the spanning header is defined in the COLUMN statement by adding a quoted string that precedes the columns that are to have the header. Parentheses can be used to form groups of columns.

 

In the following example the text 'Size Measurements' forms a header that spans the means for both HEIGHT and WEIGHT.

 

proc report data=sashelp.class nowd;
 column sex ('Size Measurements' (height weight)),mean;
 define sex / group;
 define mean /  format=6.1;
 run;

Spanning.gif

 

You can also have nested spanning headers by nesting the parentheses:

  proc report data=sashelp.class nowd;
     columns ('Student Info' (name 
             ('Demographics' sex age))
             ('Measures' height weight));

 

NestedSpanning.gif

 

This article was originally published by Art Carpenter on sasCommunity.org.

Comments

The concept of spanned headers is very interesting and important in Proc Report! 👍

Version history
Last update:
‎07-06-2018 03:31 PM
Updated by:
Contributors

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Labels
Article Tags