BookmarkSubscribeRSS Feed
mtrapani
Calcite | Level 5

Hi,

I'm looking for some documentation on how to customize the font, color, and other attributes of the index page when using tagsets.excelxp and index='yes'.

Currently, this is the output generated...

ods output.PNG

...and below is what I am trying to achieve.  I want to emphasize to the user that the index is a set of clickable links.

ods desired.PNG

Any insight would be appreciated in this matter.

Thanks,

Mike

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

It is in your style somewhere.  When you start ods do:

ods tagsets.excelxp file="abc.xls" style=statistical options(index="yes");

...

Now your style will define the fonts/sizes etc.  Here is an example from SasWeb (which has these links in blue and Helvetica:

      style fonts /                                                          

         'TitleFont2' = ("<sans-serif>, Helvetica, sans-serif",2,bold italic)

         'TitleFont' = ("<sans-serif>, Helvetica, sans-serif",4,bold)        

         'StrongFont' = ("<sans-serif>, Helvetica, sans-serif",2,bold)       

         'EmphasisFont' = ("<sans-serif>, Helvetica, sans-serif",2,italic)   

         'FixedEmphasisFont' = ("<monospace>, Courier, monospace",2,italic)  

         'FixedStrongFont' = ("<monospace>, Courier, monospace",2,bold)      

         'FixedHeadingFont' = ("<monospace>, Courier, monospace",2)          

         'BatchFixedFont' = ("SAS Monospace, <monospace>, Courier, monospace",

         2)                                                                  

         'FixedFont' = ("<monospace>, Courier, monospace",2)                 

         'headingEmphasisFont' = ("<sans-serif>, Helvetica, sans-serif",2,bold

         italic)                                                             

         'headingFont' = ("<sans-serif>, Helvetica, sans-serif",2,bold)      

         'docFont' = ("<sans-serif>, Helvetica, sans-serif",2);

You would need to change one of these to be your font (I don't know off hand which one, but any of the above with Helvetica.  To change color, then replace the colors section in your template.

mtrapani
Calcite | Level 5

Ok.  I figured it would come down to manipulating styles and templates, but was hoping there was something simpler to modify only the index page and not the rest of the output.  Thank you for the assistance.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1276 views
  • 0 likes
  • 2 in conversation