Multiple Lines graph for averages

[matt23]

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.

[Reeza]

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.

---

[matt23]

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

[Reeza · Accepted solution]

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