topic Re: Setting the Color of Sgplot Vline Group Clause Color in Graphics Programming

Setting the Color of Sgplot Vline Group Clause Color

DavidPhillips2 — Wed, 10 Dec 2014 21:30:16 GMT

I created a number of dynamic graphs using sgplot in SAS 9.2 using enterprise guide 5.1. They all use the group clause. Is there a way I can assign colors based on the value of the line.

E.g. the group is degree_level values are (degree1 degree2)

Logic is if degree_level =degree1 then make the line blue.

It looks like there is an easy way to do this in 9.3.

The basic code block is:

proc sgplot data=enrollment;

vline academic_period /response=students_enrolled stat=sum markers group=degree_level;

run;

Re: Setting the Color of Sgplot Vline Group Clause Color

Jay54 — Wed, 10 Dec 2014 22:54:51 GMT

Yes, there is an easy way to do this using SAS 9.3 SGPLOT using DiscreteAttrMap.

However, there is a way you can do this using the INDEX option with SAS 9.2 GTL. The index=column options tells the plot which graph data element to use for coloring the plot. a value of 1 means use GraphData1 element. You can set the index values the way you want in the column, and set the GraphData1-12 elements in the style with the colors you want to get your assignment.

You can use the %MODSTYLE macro to derive a style with the colors you want. You are not limited to 12 style elements, you can define more if you want. You may need to summarize your data by the category using PROC MEANS.

data stocks;

set sashelp.stocks(where=(date > '01Jan2001'd));

if stock='IBM' then index=3;

else if stock='Microsoft' then index=5;

else index=2;

run;

proc print;run;

proc template;

define statgraph ColorByIndex;

begingraph;

layout overlay;

seriesplot x=date y=close / group=stock name='a' index=index;

discretelegend 'a';

endlayout;

endgraph;

end;

run;

proc sgrender data=stocks template=ColorByIndex;

run;

Re: Setting the Color of Sgplot Vline Group Clause Color

DavidPhillips2 — Thu, 11 Dec 2014 13:56:45 GMT

Do I have to use sgrender? Can I use sgplot, which does not have a template function?

Re: Setting the Color of Sgplot Vline Group Clause Color

Jay54 — Thu, 11 Dec 2014 14:23:47 GMT

If you have SAS 9.3 or later, you can use SGPLOT with the Discrete Attributes Map feature. If not, and you want this result, you have to use GTL template with SGRender since SGPLOT does not expose the INDEX option.

If you look at the GTL code carefully, the main statements are the SERIESPLOT and DISCRETELEGEND. These are similar the the SERIES and KEYLEGEND statement in SGPOT. Rest of the code is boiler plate.

Re: Setting the Color of Sgplot Vline Group Clause Color

DavidPhillips2 — Thu, 11 Dec 2014 14:24:52 GMT

This method works however it is incredibly processor inefficient and leads to coding complications. The idea is to create a second table that will always have data for the given row and link it to the table you are querying. Is there a better way?

proc sql;

CREATE TABLE testTable(

ACADEMIC_PERIOD varchar(50),

STUDENTS_ENROLLED int,

STATUS varchar(50),

DEGREE_LEVEL varchar(50)

);