Proc SGPANEL color by subject

[csa]

Hi All,

I am trying to generate a figure plot using the below code. I am getting the output as in the attached screen shot.

proc sgpanel data=have  ;
panelby SUBJID / layout=PANEL novarname columns=4 rows=2;
series x=x_axis_var y=aval /group=trt01p_ attrid=myid lineattrs=(pattern=mediumdash thickness=2);
scatter x=x_axis_var y=aval /group=trt01p_ attrid=myid markerattrs = (symbol=circlefilled size=8);

rowaxis integer grid values=(0,50,75,100) label="test";
colaxis integer grid values=(1 to 10 by 1) discreteorder=data label="Day";

run;
quit;

My query is how can we change the Blue color plots 'Green', Red color plots to 'Blue' and the bottom Legend with Green and Blue colors?

Thanks.

[ChrisNZ]

Moved to Graphics community

[GraphGuy · Accepted solution]

Looks like duplicate of this solved one(?)

https://communities.sas.com/t5/Graphics-Programming/Proc-SGPANEL-color-by-subject/m-p/749650#M21676

[FreelanceReinh]

Hi @csa,

Compared to the other thread, you inserted the attrid=myid option into the SERIES and SCATTER statements. However, without using the DATTRMAP= option in the SGPANEL statement there's nothing that "myid" refers to. So, in addition to this option you need an attribute map dataset, as described in Example: Create a Panel That Uses an Attribute Map:

data attrmap;
retain ID "myid";
input value markercolor $ linecolor $;
datalines;
1 green green
2 blue  blue
;

proc sgpanel data=have dattrmap=attrmap;
...

Note that most likely you will need to adapt the values of variable value above to your data, unless your variable trt01p_ happens to be numeric with values 1 and 2 (for the groups currently displayed in blue and red, respectively) and not formatted. If trt01p_ is character with values, say, "Active" and "Placebo" or formatted with these format labels, define value as a character variable (of sufficient length) in the DATA step above and replace 1 and 2 by Active and Placebo, resp., in the data lines.