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

Really just trying to do two changes to the normal style:

  • Change all border colors from blue to black
  • Border the entire box (top and left edges have no border now)

I'm using ODS Tagsets.ExcelXP and Proc Report\Tabulate for outputs.

Thanks!        

1 ACCEPTED SOLUTION

Accepted Solutions
wcp_fnfg
Obsidian | Level 7

proc template;

  define style styles.lucy;

  parent=styles.normal;

  style Body from Body /

  Pagebreakhtml='<BR> <BR>';

  class header /

  borderleftwidth = 1px

  bordertopwidth = 1px

  borderleftcolor = #000000

  bordertopcolor = #000000

  borderrightcolor = #000000

  borderbottomcolor = #000000

;

  class data /

  borderleftcolor = #000000

  bordertopcolor = #000000

  borderrightcolor = #000000

  borderbottomcolor = #000000

;

  end;

run;

View solution in original post

4 REPLIES 4
RW9
Diamond | Level 26 RW9
Diamond | Level 26

You would need to define a new one, inheriting from a base one, e.g.:
proc template;

     define style MyStyles.UpdatedStyle;

     parent = styles.normal;

     style Table /

          bordercolor = cxC1C1C1;

     end;

run;

For what items can be changed, goto the styles (right click on results, select templates, and look at style.default).

wcp_fnfg
Obsidian | Level 7

I know it's something like this, but I used that and my output is still blue borders and has no top\left borders.

FWIW, I'm on EG5.1

wcp_fnfg
Obsidian | Level 7

Attaching the output spreadsheet (minus data for security).

This is my template, but nothing seems to change the border color...

proc template;

     define style styles.Lucy;

     parent = styles.normal;

     replace Header from Header/

          bordercolor = red

   borderstyle = dotted;

     replace Table from Table/

          bordercolor = black;

     replace Data from Data/

          bordercolor = black;

     replace Default from Default/

          bordercolor = black

          frame = box;

     end;

run;

wcp_fnfg
Obsidian | Level 7

proc template;

  define style styles.lucy;

  parent=styles.normal;

  style Body from Body /

  Pagebreakhtml='<BR> <BR>';

  class header /

  borderleftwidth = 1px

  bordertopwidth = 1px

  borderleftcolor = #000000

  bordertopcolor = #000000

  borderrightcolor = #000000

  borderbottomcolor = #000000

;

  class data /

  borderleftcolor = #000000

  bordertopcolor = #000000

  borderrightcolor = #000000

  borderbottomcolor = #000000

;

  end;

run;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 4 replies
  • 1383 views
  • 3 likes
  • 2 in conversation