How to SQPLOT series

[ishaqwright21o]

Hey,

I am trying to create an sgplot with for the months by year. 

Help....This is what i have tried so far.

proc sqplot data=mydata;

series x=months(char) y=nfreq /group=year(char);

run;

I was hoping sas could calculate the frequency of each month(nfreq). Looks like thats not the case. 

[Reeza · Accepted solution]

You're correct. You can pre-summarize your data using PROC FREQ, MEANS, SQL, proc of your choice and then display it using SGPLOT.

Note that PROC FREQ will also generate graphics but bar charts. Bar charts within SGPLOT do offer summarization options but not line charts.
For months to display appropriately it's probably best to convert that to a SAS date as well.