topic Re: Question on Series plot in SGPANEL in Graphics Programming

Question on Series plot in SGPANEL

plf515 — Mon, 30 Sep 2013 16:35:41 GMT

I am working on ways to visualize series. Using the SASHELP.STOCKS data set, I am trying to panel by year. However, in the code below, the SERIES statement is linking December with the following January. I can't figure out how to fix this.

First, I create a new data set that has "month" separated for each year and decade created as well

data stocks;

set sashelp.stocks;

year = year(date);

month = mod(intck('MONTH', '01JAN1986'd, date), 12);

decade = floor(year/10);

run;

Next, I run the plot

proc sgpanel data = stocks;

panelby decade;

where stock = "IBM";

series x = month y = close;

run;

Resulting in the attached plot

Re: Question on Series plot in SGPANEL

ballardw — Mon, 30 Sep 2013 16:49:45 GMT

try making year a group variable on the series statement.

Re: Question on Series plot in SGPANEL

PGStats — Mon, 30 Sep 2013 16:53:40 GMT

How about adding /GROUP=year in the series statement ?

Re: Question on Series plot in SGPANEL

plf515 — Mon, 30 Sep 2013 16:54:32 GMT

That worked perfectly!