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

How do I format a Proc Report in EG so that the .SRX generated displays any row/column banding that I apply?  It displays on the HTML, but not the SRX, so when I run the procedure in AMO, the formatting is lost.

 

options missing = '';
ods escapechar = '^';
proc report data = p1 style = pearl;
	columns div disc ees_tot ees
		('Traffic'('^S={background=ffc425} Inet' t_inet_d t_inet) ('Recr' t_recr_d t_recr)
		('Refr' t_refr_d t_refr) ('Reac' t_reac_d t_reac))
	;
	format ees_tot ees comma9.;
	define div / group;
	define t_inet_d / style(header) = [background=ffc425];
	break after div / summarize;
	rbreak after / summarize;
	compute after div;
		line ' ';
	endcomp;
	compute after;
		if div = '' then div = 'OGR';
	endcomp;
run;quit;
1 ACCEPTED SOLUTION

Accepted Solutions
JoeCofone
Fluorite | Level 6

Tom, I will in the future.  After messing around, I discovered that my issue is with the color itself.  The SRX won't recognize the SAS hexadecimal color FFC425, but will recognize GOLD.  I changed this and moved on.  I am assuming that if I modify the template used for the SRX style so that GOLD translates to FFC425 then I will be all set.

View solution in original post

4 REPLIES 4
TomKari
Onyx | Level 15

It would be best if you could include either a few records of garbage data, or change your code to use a SASHELP dataset.

 

Right now I can't run your code to see what your desired results should look like.

 

Tom

JoeCofone
Fluorite | Level 6

Tom, I will in the future.  After messing around, I discovered that my issue is with the color itself.  The SRX won't recognize the SAS hexadecimal color FFC425, but will recognize GOLD.  I changed this and moved on.  I am assuming that if I modify the template used for the SRX style so that GOLD translates to FFC425 then I will be all set.

Vince_SAS
Rhodochrosite | Level 12

The color should be specified as #ffc425

 

Vince DelGobbo

SAS R&D

 

 

JoeCofone
Fluorite | Level 6
Thanks, Vince.

sas-innovate-wordmark-2025-midnight.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. Sign up by March 14 for just $795.


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