topic How to SQPLOT series in SAS Visual Analytics

How to SQPLOT series

ishaqwright21o — Thu, 28 Oct 2021 22:15:57 GMT

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.

Re: How to SQPLOT series

Reeza — Thu, 28 Oct 2021 22:27:32 GMT

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.