Desktop productivity for business analysts and programmers

Multiple Lines graph for averages

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

Multiple Lines graph for averages

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:

Screen Shot 2018-06-20 at 12.02.45 PM.png

And I just want one average line for each month.

 


Accepted Solutions
Solution
‎06-20-2018 04:26 PM
Super User
Posts: 23,958

Re: Multiple Lines graph for averages


All Replies
Super User
Posts: 23,958

Re: Multiple Lines graph for averages

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:

Screen Shot 2018-06-20 at 12.02.45 PM.png

And I just want one average line for each month.

 


 

Frequent Contributor
Posts: 89

Re: Multiple Lines graph for averages

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

Solution
‎06-20-2018 04:26 PM
Super User
Posts: 23,958

Re: Multiple Lines graph for averages

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 88 views
  • 0 likes
  • 2 in conversation