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

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1256 views
  • 6 likes
  • 3 in conversation