topic Re: PROC TEMPLATE GTL TABLE FONT COLOR MATCH WITH PLOT in Graphics Programming

PROC TEMPLATE GTL TABLE FONT COLOR MATCH WITH PLOT

sam1231 — Sun, 23 Mar 2025 20:12:08 GMT

I AM using sgrender to do line chart by grp and i need table below plot. this works fine but i want table font color match with line color in plot. how to do that?

proc template;

define statgraph lineblock;

begingraph;

layout lattice / rowweights=(.70 .10 .20);

/* Line Chart */

layout overlay / xaxisopts=(label="axp")

yaxisopts=(label="percentage (%) " );

seriesplot x=axp y=pchg / group=grp name="stdy"

lineattrs=(thickness=2 pattern=solid)

dataskin=gloss;

scatterplot x=axp y=pchg / markerattrs=(symbol=circlefilled size=8);

endlayout;

/* Block Plot */

layout overlay / xaxisopts=(type=discrete display=none ) walldisplay=none;

blockplot x=axp block=block / class=grp

display=(values label)

valueattrs=(color=color)

repeatedvalues=true;

endlayout;

endgraph;

end;

run;

Re: PROC TEMPLATE GTL TABLE FONT COLOR MATCH WITH PLOT

Ksharp — Mon, 24 Mar 2025 01:51:12 GMT

It would be better if you could post your sample data and PROC SGRENDER and desired output.

Re: PROC TEMPLATE GTL TABLE FONT COLOR MATCH WITH PLOT

DanH_sas — Mon, 24 Mar 2025 13:32:12 GMT

You might want to use an AXISTABLE here instead of a BLOCKPLOT to create this table. AXISTABLES can do exactly what you asked, but as @Ksharp said, we need a little more information to determine if that solution will wrk for you.

Re: PROC TEMPLATE GTL TABLE FONT COLOR MATCH WITH PLOT

sam1231 — Mon, 24 Mar 2025 17:34:21 GMT

I want font color in table same as font color in plot.

code:

proc template;

define statgraph barblock;

begingraph;

entrytitle 'Total Sales Across Regions';

layout lattice / rowweights=(.65 .35);

layout overlay;

seriesplot x=region y=sales / group=product name='stdy'

;

scatterplot x=region y=sales / markerattrs=(symbol=circlefilled size=8);

discretelegend "stdy" / title= " " titleattrs= (size=9pt weight=normal ) location=

inside halign=right valign=top

valueattrs= (size=9pt) border=false;

endlayout;

layout overlay / xaxisopts=(type=discrete label='Number of Stores per Region'

display=(label)) walldisplay=none;

blockplot x=region block=stores / class=product display=(outline values label)

repeatedvalues=true;

endlayout;

endgraph;

end;

run;

Re: PROC TEMPLATE GTL TABLE FONT COLOR MATCH WITH PLOT

Ksharp — Tue, 25 Mar 2025 01:41:35 GMT

As DanH_sas said try XAXISTABLE . Here is an example for proc sgplot, but you could find the similar statement in GTL.

data cars;
set sashelp.cars;
run;

proc sql;
create table have as
select origin,type,sum(invoice) as invoice,count(*) as count
 from cars
  group by origin,type;
quit;

proc sgplot data=have;
series x=type y=invoice/group=origin markers markerattrs=(symbol=circlefilled);
keylegend /location=inside position=ne across=1;
xaxistable count/x=type class=origin colorgroup=origin;
run;