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.

Spanning Headers in PROC REPORT

From sasCommunity
Jump to: navigation, search

As part of the decommissioning effort for this article/tip has been migrated to

The new home for this article/tip is Spanning Headers in PROC REPORT (

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;


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));


Spanning headers can also be stacked, see Stacking Headers in PROC REPORT.