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;
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.
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
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.
The color should be specified as #ffc425
Vince DelGobbo
SAS R&D
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.