The SAS Output Delivery System and reporting techniques

Different alignment for 2 different spanned headers in Proc Report?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 96
Accepted Solution

Different alignment for 2 different spanned headers in Proc Report?

[ Edited ]

Hi everyone,

I'd like the first spanned header to be left-aligned and the second one to be centered.  How can I  style spanned headers independently?

 

thanks!

 

 

 

edit: I'm using distinct columns to generate the report, not ACROSS.

 edit2: here's a minimal non-working example stolen from another thread:

ods listing close;

ods rtf file='c:\temp\usestyle1.rtf';
title "1) Justify ALL the Headers Left and then change the ones you do NOT want left-just";
proc report data=sashelp.class nowd
style(header)={just=l};
column ('Left Justify' age name ) ('Right justify' height weight);
define age / order style(header)={cellwidth=1.25in} 'Laboratory Test';
define name / display style(header)={cellwidth=1.25in} 'The Name';
define height / display style(header)={just=c cellwidth=1.25in} 'height';
define weight / display style(header)={just=c cellwidth=1.25in} 'weight';
run;
ods _all_ close;


Accepted Solutions
Solution
‎12-16-2015 02:21 PM
Frequent Contributor
Posts: 96

Re: Different alignment for 2 different spanned headers in Proc Report?

Found it (obviously, after 2 days of searching and exactly 15 minutes after posting).  Just use an escape character like this:

 

ods escapechar='^';
ods listing close;

ods rtf file='c:\temp\usestyle1.rtf';
title "1) Justify ALL the Headers Left and then change the ones you do NOT want left-just";
proc report data=sashelp.class nowd
style(header)={just=l};
column ('Left Justify' age name ) ('^S={just=r} Right justify' height weight);
define age / order style(header)={cellwidth=1.25in} 'Laboratory Test';
define name / display style(header)={cellwidth=1.25in} 'The Name';
define height / display style(header)={just=c cellwidth=1.25in} 'height';
define weight / display style(header)={just=c cellwidth=1.25in} 'weight';
run;
ods _all_ close;

View solution in original post


All Replies
Solution
‎12-16-2015 02:21 PM
Frequent Contributor
Posts: 96

Re: Different alignment for 2 different spanned headers in Proc Report?

Found it (obviously, after 2 days of searching and exactly 15 minutes after posting).  Just use an escape character like this:

 

ods escapechar='^';
ods listing close;

ods rtf file='c:\temp\usestyle1.rtf';
title "1) Justify ALL the Headers Left and then change the ones you do NOT want left-just";
proc report data=sashelp.class nowd
style(header)={just=l};
column ('Left Justify' age name ) ('^S={just=r} Right justify' height weight);
define age / order style(header)={cellwidth=1.25in} 'Laboratory Test';
define name / display style(header)={cellwidth=1.25in} 'The Name';
define height / display style(header)={just=c cellwidth=1.25in} 'height';
define weight / display style(header)={just=c cellwidth=1.25in} 'weight';
run;
ods _all_ close;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 1028 views
  • 0 likes
  • 1 in conversation