topic SGPLOT for multiple variables in Graphics Programming

SGPLOT for multiple variables

joseph626 — Tue, 07 Mar 2017 18:41:14 GMT

Hi there!

I'm trying to draw some plot using proc sgplot;

for one variable, the code is as the following:

proc sgplot data= plot;
series y=A1 x=variable;
run;

However since there are options like colors following the series, and I actually want 10 series (y=a1, a2... a10) of y in the plot. Is there any easier way to draw these series of plots rather than writing 10 series?

Thanks!

Re: SGPLOT for multiple variables

ballardw — Tue, 07 Mar 2017 18:47:11 GMT

Often what your are thinking of requires restructuring your data so you can use a Group option.

The data should look like:

X Y Group

1 1 A1

2 3 A1

1 5 A2

Proc transpose may work for that.

Then your sgplot code would look like

proc sgplot data= plot;
series y=Y x=X / group=group;
run;

Re: SGPLOT for multiple variables

Jay54 — Tue, 07 Mar 2017 18:47:28 GMT

If you have multiple columns, one for each response, you have two options:

Use a series plot per column. Using Cycleattrs, colors will be set differently for each series automatically.
Transpose your data so you have a GROUP variable that has each series id. Then have only one column for response. Then you can use one SERIES statement with GROUP option. This is the preferred way.

See http://blogs.sas.com/content/graphicallyspeaking/2015/06/28/attributes-priority-for-the-inquiring-mind/

Re: SGPLOT for multiple variables

Rick_SAS — Tue, 07 Mar 2017 20:05:42 GMT

See this article on plotting multiple series. You might also want to be aware of some of the issues involved in Spaghetti Plots.