topic Re: Multiple Lines graph for averages in SAS Enterprise Guide

Multiple Lines graph for averages

matt23 — Wed, 20 Jun 2018 16:06:55 GMT

Hi,

I am trying to make a multiple lines plot for each month with a pretty big data with this code:

proc sgplot data=dataname;
series x=Hour y=Load / group=Month;
title 'Multiple Lines Plot (Months)';
run;

but I get this:

And I just want one average line for each month.

Re: Multiple Lines graph for averages

Reeza — Wed, 20 Jun 2018 16:12:23 GMT

You have to pre-summarize your data and then plot the averages.

@matt23 wrote:

Hi,

I am trying to make a multiple lines plot for each month with a pretty big data with this code:
proc sgplot data=dataname;
series x=Hour y=Load / group=Month;
title 'Multiple Lines Plot (Months)';
run;
but I get this:

And I just want one average line for each month.

Re: Multiple Lines graph for averages

matt23 — Wed, 20 Jun 2018 16:13:48 GMT

Sorry for the dumb question but can you give me an example of how to do it?

Re: Multiple Lines graph for averages

Reeza — Wed, 20 Jun 2018 16:17:36 GMT

Try one of the summarize task or query builder.

http://www2.sas.com/proceedings/sugi30/179-30.pdf

Proc means:

https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic.sas