topic Re: Spanned Header across all columns in ODS and Base Reporting

Spanned Header across all columns

spjcdc — Wed, 26 Aug 2015 17:28:40 GMT

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

Re: Spanned Header across all columns

Reeza — Wed, 26 Aug 2015 17:44:11 GMT

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

Re: Spanned Header across all columns

spjcdc — Wed, 26 Aug 2015 17:58:11 GMT

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.

Re: Spanned Header across all columns

data_null__ — Wed, 26 Aug 2015 18:07:13 GMT

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

Re: Spanned Header across all columns

spjcdc — Wed, 26 Aug 2015 18:11:55 GMT

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

Re: Spanned Header across all columns

data_null__ — Wed, 26 Aug 2015 18:25:08 GMT

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

Re: Spanned Header across all columns

spjcdc — Wed, 26 Aug 2015 19:23:56 GMT

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

Steve