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-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

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