topic Re: SRX styles for output in Developers

SRX styles for output

JoeCofone — Mon, 20 Mar 2017 12:19:51 GMT

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;

Re: SRX styles for output

TomKari — Mon, 20 Mar 2017 15:51:50 GMT

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

Re: SRX styles for output

JoeCofone — Mon, 20 Mar 2017 16:16:05 GMT

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.

Re: SRX styles for output

Vince_SAS — Fri, 24 Mar 2017 12:52:14 GMT

The color should be specified as #ffc425

Vince DelGobbo

SAS R&D

Re: SRX styles for output

JoeCofone — Fri, 24 Mar 2017 12:55:15 GMT

Thanks, Vince.