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.
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
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.
Sorry for the dumb question but can you give me an example of how to do it?
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.