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;
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.