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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.