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 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 1759 views
  • 6 likes
  • 3 in conversation