topic Issue defining colors for trendlines in SAS Programming

Issue defining colors for trendlines

Ananth_kumar — Thu, 16 Nov 2023 17:22:45 GMT

%macro create_trend_line(entity,x,y,width,height,chart_title,axis_label);

%_f_define_region(&x,&y,&width,&height);

proc sql noprint;

select distinct Yr_nb

into:year1-

from trend_lines_ctrl_srt

where Entity="&entity.";

quit;

proc sql;

create table trend_data as

select Yr_nb,

Mo_Name,

Ctrl_MBR

from trend_lines_ctrl_srt

where Entity = "&entity."

order by Yr_nb,

case Mo_Name

when 'JAN' then 1

when 'FEB' then 2

when 'MAR' then 3

when 'APRIL' then 4

when 'MAY' then 5

when 'JUN' then 6

when 'JULY' then 7

when 'AUG' then 8

when 'SEP' then 9

when 'OCT' then 10

when 'NOV' then 11

when 'DEC' then 12

else 13

end;

quit;

footnote;

proc sgplot data=trend_data noautolegend;

styleattrs datacolors=(red blue black);

series x=Mo_Name y=Ctrl_MBR / group=Yr_nb lineattrs=(thickness=2);

xaxis label="Month" type=discrete;

yaxis label="MBR Rate";

title "&chart_title";

keylegend / title="Years" position=bottom;

run;

title;

%mend create_trend_line;

I created this macro to generate trendline for years in the dataset, but unable to define custom colors.

Re: Issue defining colors for trendlines

ballardw — Thu, 16 Nov 2023 17:49:43 GMT

Will you have the same values of Yr_nb all the time? Then look up DATTRMAP= data set option for Proc SGplot to create set of properties such as line color for the values of Yr_nb. That would make the colors consistent across many graphs.

If you want that list in the styleattrs use DATACONTRASTCOLORS instead of datacolors.

Re: Issue defining colors for trendlines

PaigeMiller — Thu, 16 Nov 2023 17:51:07 GMT

I think in STYLEATTRS you want to use DATACONTRASTCOLORS=() and not DATACOLORS=()

Re: Issue defining colors for trendlines

Ananth_kumar — Thu, 16 Nov 2023 17:54:20 GMT

I have 3 years in Yr_nb = 2019 2022 and 2023 and the month on month the values for yaxis ctrl_mbr changes. I'm trying to apply a single color for 2019,2022 and 2023

Re: Issue defining colors for trendlines

Ananth_kumar — Thu, 16 Nov 2023 17:55:49 GMT

will this defines color for each year ? Thanks for responding

Re: Issue defining colors for trendlines

PaigeMiller — Thu, 16 Nov 2023 18:03:11 GMT

will this defines color for each year ? Thanks for responding

You can try it and find out

Re: Issue defining colors for trendlines

ballardw — Thu, 16 Nov 2023 18:57:46 GMT

@Ananth_kumar wrote:

will this defines color for each year ? Thanks for responding

Kind of depends on your data and what you place in the options. If your data has more group values then you supply on the list for Datacontrastcolors then you are back to colors from your active style and may duplicate. Or if you place the same color in the list more than once it may be pretty hard to tell.