topic Re: sgplot color control for multiple series with group= in SAS Programming

sgplot color control for multiple series with group=

CP2 — Wed, 12 Sep 2018 21:04:45 GMT

hello,

I am trying to show two lines for each group in the group= statement of an sgplot. One line would be the actual value and the other would be the 12 month moving average. I want the actual to be a solid line and the moving average to be a dashed line but I also want the colors to be the same for each item in the group.

I thought that I could exclude the color from the lineattrs so that the defaults would just be used for each of the series but it's not working the way I had hoped. I've tried a lot of the suggestions online but still not working. Originally I want to do this with two by variables (drug and prodname) but that was making it more complicated. I ended up wrapping the plot in a macro and calling out each drug and product name to plot separately.

The following is an hypothetical example with a drug called 'abcdrug' and prodname is blank. Is there a simple statement I can add or ods graphics option I can use without creating numerous lines of code? I often want to do these sorts of graphs on the fly and sometimes not worth creating all the code for it.

%macro shareplot(dname=, prod=) ;
proc sgplot data=share (where = (drug="&dname." and prodname="&prod.")) ;
title "Shares Over Time";
title2 "&dname., &prod." ;
series y=share x= month/ group=strength lineattrs=(thickness=2 pattern=solid) legendlabel="Share by Month" ;
series y=share_12 x= month/ group=strength lineattrs=(thickness=2 pattern=longdash) legendlabel="Share by Month - 12 month MA" ;
YAXIS LABEL = 'Share (%)' ;
YAXIS min=0 max=1 ;
FOOTNOTE " ";
where MONTH>='01JAN2013'd ;
run;
%mend plot ;
%shareplot(dname=abcdrug);

Re: sgplot color control for multiple series with group=

Reeza — Wed, 12 Sep 2018 21:23:14 GMT

Have you looked at DATA ATTRIBUTE Maps? That's likely what you're after.

https://blogs.sas.com/content/iml/2017/01/30/auto-discrete-attr-map.html

Re: sgplot color control for multiple series with group=

Ksharp — Thu, 13 Sep 2018 12:53:39 GMT

Check option grouplc= seriese ......./group=strength grouplc= Or statment : styleattrs ...........

Re: sgplot color control for multiple series with group=

CP2 — Thu, 13 Sep 2018 14:46:37 GMT

thanks for your response. I spent time using the suggestions in the link but I still cannot get the colors to be in sync between the actual and moving average.

Re: sgplot color control for multiple series with group=

Reeza — Thu, 13 Sep 2018 14:47:12 GMT

Post your code so we can see and work off what you've already done please.

Re: sgplot color control for multiple series with group=

CP2 — Thu, 13 Sep 2018 14:59:59 GMT

I suppose i can add 'lineattrs' in the map instead of marketstyleelement and hardcode in the colors. I'll try this. Let me know if you have other suggestions related to data attribute maps.

Re: sgplot color control for multiple series with group=

Reeza — Thu, 13 Sep 2018 15:06:05 GMT

Without seeing what you've already done, it's pretty hard to make any suggestions here.

@CP2 wrote:
I suppose i can add 'lineattrs' in the map instead of marketstyleelement and hardcode in the colors. I'll try this. Let me know if you have other suggestions related to data attribute maps.

Re: sgplot color control for multiple series with group=

CP2 — Thu, 13 Sep 2018 15:28:48 GMT

can you help me figure out why I am getting errors with this supposedly simple loop and scan? I'm trying to add a color to the attribute map.
%let VarName = strength_; /* specify name of grouping variable */
proc freq data=Have
ORDER=FORMATTED; /* or ORDER=DATA|FREQ */
tables &VarName / out=Attrs(rename=(&VarName=Value));
run;
%let colorlist=blue, red, green, lightblue, cyan, orange, fuscia, brown, lavendar, purple ;
%LET color_count = %sysfunc(countw(%quote(&colorlist), %str(,) )) ;
data DAttrs;
ID = "&VarName";
set Attrs(keep=Value);
length linecolor $11. linecolor $100. ;
do i = 1 to %eval(&color_count.) ;
linecolor = %scan(&colorlist., i ) ;
put linecolor ;
end ;
run;