topic Re: Question about proc sg plot and group = option in Graphics Programming

Question about proc sg plot and group = option

asishgautam — Tue, 24 Apr 2012 16:31:00 GMT

I have a dataset that I need to use to create a simple series plot - well a whole bunch based on the different crossings of the "by variables". I am able to do this but I received a comment on the lack of consistency in the color coding for the categorical variable in my "group = " option. For most plots, I have 5 distinct values in the variable listed in the "group = " option - thus, I will get 5 different plots for most "by groups". However, for several crossings of my "by group", I may have 3 or 4 distinct values for the "group = " option. This causes the color coding to get messed up. Is there a way for me to specify the color to be used for each series based on the value of the variable in my "group = " option? I looked around and apparently in GTL - there is the GraphDataN class that can control colors and other options for each "group"- however, I don't think this is what I am looking for since I want to control the color/marker options based on the value of the "group".

5 categories:

history - blue circle

prior forecast - red cross

high scenario - green star/"x"

mid scenario - brown triangle

low scenario - purple square

4 categories

history - blue circle

high scenario - red cross

mid scenario - green star/"x"

low scenario - brown triangle

3 categories

history - blue circle

prior forecast - red cross

blended scenario - green star/"x"

Basically, I want the color and marker to be consistent based on the "group=" variable.

Re: Question about proc sg plot and group = option

GraphGuy — Tue, 24 Apr 2012 17:10:26 GMT

Which Proc (or other) are you using to plot the data?

Re: Question about proc sg plot and group = option

asishgautam — Tue, 24 Apr 2012 17:23:44 GMT

proc sgplot v 9.2

Re: Question about proc sg plot and group = option

PGStats — Tue, 24 Apr 2012 17:45:22 GMT

If you are using version 9.3 you should look at Attribute maps. I think it does exactly what you want.

Re: Question about proc sg plot and group = option

asishgautam — Tue, 24 Apr 2012 18:00:08 GMT

I am using 9.2. We should be upgrading to 9.3 soon.

Re: Question about proc sg plot and group = option

PGStats — Tue, 24 Apr 2012 18:37:32 GMT

Another idea, If your different graphs can be generated togetter (from the same dataset) with a BY variable, then using UNIFORM=GROUP will provide consistent group attributes.

Re: Question about proc sg plot and group = option

asishgautam — Tue, 24 Apr 2012 19:05:37 GMT

This did the trick so far. I am still interested in knowing if we can control colors and marker attributes based on the value of the "group= " option.

Re: Question about proc sg plot and group = option

stacey11 — Tue, 08 May 2012 18:32:09 GMT

I have this exact problem and would love to use the UNIFORM=GROUP option except that I need to generate a completely separate output file for each value of the BY Group. When I do it now it generates the separate plots per BY group as expected but into the same file. I need a separate RTF file per BY group. I'm using v9.2 and PROC SGPLOT. Is it possible to to do this?

Re: Question about proc sg plot and group = option

DanH_sas — Tue, 08 May 2012 19:10:44 GMT

The ODS RTF statement has an option called NEWFILE=BYGROUP that may do just what you need. It will add an index to the end of the filename you specify.

Hope this helps!

Dan

Re: Question about proc sg plot and group = option

stacey11 — Tue, 08 May 2012 19:44:17 GMT

Thanks Dan! That did work as you promised though I'm not sure I'm going to be able to use it because I need more control over the individual elements of each outputted plot and will probably have to do the BY groups as individual macro calls. I'm feeling stuck though because I have the same problem as the original poster...I need to assign marker characters based on values in the data rather than those assigned sequentially by GraphValuex so they'll be consistent across graphs. Is there any way to do that?

Re: Question about proc sg plot and group = option

DanH_sas — Tue, 08 May 2012 19:53:38 GMT

As PGStats mentioned, attribute maps are THE way to do this at 9.3. However, at 9.2, you can also simulate this in GTL by using the GROUPINDEX option. I show a little example of this in the first installment of "Roses are red, violets are blue...". Take a look at that example and see if that helps you.

Thanks!
Dan

http://blogs.sas.com/content/graphicallyspeaking/2012/02/27/roses-are-red-violets-are-blue/

http://blogs.sas.com/content/graphicallyspeaking/2012/03/01/roses-are-red-violets-are-blue-part-2/

Re: Question about proc sg plot and group = option

stacey11 — Tue, 08 May 2012 21:21:05 GMT

Yes! This worked great. Thanks a lot!

Re: Question about proc sg plot and group = option

HarshadMadhamshettiwar — Mon, 02 Mar 2015 08:16:10 GMT

Hello Experts,

how do we create a plot using the set of data like below:

Category	element	value	date
cat1	a	20	Jan-10
cat1	a	30	Feb-10
cat1	a	40	Mar-10
cat1	a	25	Apr-10
cat1	b	10	Jan-10
cat1	b	15	Feb-10
cat1	b	20	Mar-10
cat1	b	25	Apr-10
cat2	c	30	Jan-10
cat2	c	35	Feb-10
cat2	c	25	Mar-10
cat2	c	50	Apr-10
cat2	d	45	Jan-10
cat2	d	50	Feb-10
cat2	d	60	Mar-10
cat2	d	55	Apr-10

From above data we can see that , category "cat1" have two elements "a and b" , category "cat2" have two elements "c and d" and for all of them we have "values" and "date".

Que is how do we create plot which looks like this:

Motive is to see how category looks at an aggregated level along with how its elements are contributing. So above plot will be for "CAT1 and all its elements (here A and B)" and we will have same for "CAT2". That is only two output graphs.

Thanks,

Harshad M.

Re: Question about proc sg plot and group = option

DanH_sas — Mon, 02 Mar 2015 14:51:30 GMT

Try the following and see if it is what you want:

data sample;

input Category $ element $ value date $;

cards;

cat1 a 20 Jan-10

cat1 a 30 Feb-10

cat1 a 40 Mar-10

cat1 a 25 Apr-10

cat1 b 10 Jan-10

cat1 b 15 Feb-10

cat1 b 20 Mar-10

cat1 b 25 Apr-10

cat2 c 30 Jan-10

cat2 c 35 Feb-10

cat2 c 25 Mar-10

cat2 c 50 Apr-10

cat2 d 45 Jan-10

cat2 d 50 Feb-10

cat2 d 60 Mar-10

cat2 d 55 Apr-10

;

run;

proc sgplot data=sample;

by category;

series x=date y=value / group=element;

run;

Re: Question about proc sg plot and group = option

Rick_SAS — Mon, 02 Mar 2015 14:57:01 GMT

And if you have multiple Y variables, you can follow the steps in this post to transpose the data so that you can use the GROUP= option:

Plotting multiple series: Transforming data from wide to long

Re: Question about proc sg plot and group = option

HarshadMadhamshettiwar — Wed, 04 Mar 2015 14:25:25 GMT

if we also want to have category y2axis then I would add a line your code

proc sgplot data=sample;

by category;

series x=date y=value / group=element;

series x=date y=CAT_value/group=Category; /*here CAT_value is a variable having the value variable aggregated to the category level

so as to be able to plot category*/

run;

Can also be found at :

Thanks.

Harshad M.