Spanned Header across all columns

[spjcdc]

How can I have a header span ALL the column in a report.  All the examples I've seen show a blank column in column 1.

Thanks,

Steve

[Reeza]

What's your destination? How are you generating your report?

[spjcdc]

sorry for not providing more detail.  I'm planning on using Proc Report.  Currently the report is going to Excel but I don't know if that's a hard-and-fast requirement.  If we could get it to RTF that might work just as well. 

[data_null__]

proc report data=sashelp.class nowd list;
   columns ('Spanning all' _all_);
   run;

[spjcdc]

I tried to attach an example in Word but it said the file was too large.  In any case imagine the SASHELP.CLASS file with a header that spans the entire table with the text 'Table 1. SASHELP.Class'.  Underneath that are two spanned headers entitled 'First two variables' that span the Age and Sex columns and another header 'The other 3 variables' that span name, height and weight.  THen there'd be a row with Sex, Age, Name, Height and Weight with the actual data values following them. 

Steve

[data_null__ · Accepted solution]

proc report data=sashelp.class nowd list;
   columns ('Table 1. SASHELP.Class' ('First Two' _character_) ('The rest' _numeric_));
   run;

[spjcdc]

Thanks data _null_.  That's just what I needed.

Steve