BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
morglum
Quartz | Level 8

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;

1 ACCEPTED SOLUTION

Accepted Solutions
morglum
Quartz | Level 8

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

1 REPLY 1
morglum
Quartz | Level 8

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;

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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