topic Re: Plotting a series on quarter and year in Graphics Programming

Plotting a series on quarter and year

brokenpc1 — Mon, 26 Jun 2023 15:42:31 GMT

Hi there,

I would like to plot a series of revenue data on quarter and year using proc sgplot. The data I have is like the following:

Year	Quarter	Revenue
2020	Q1	4,215
	Q2	4,868
	Q3	7,520
	Q4	7,045
2021	Q1	6,653
	Q2	9,113
	Q3	4,676
	Q4	2,933
2022	Q1	3,701
	Q2	3,692
	Q3	3,721
	Q4	5,478

In Excel, I can make a series like the following:

However, I can't figure out how to make X axis having quarter and year using proc sgplot like it did in Excel. Any tricks here please?

Thank you.

Re: Plotting a series on quarter and year

DanH_sas — Mon, 26 Jun 2023 16:04:52 GMT

Here is one way:

proc sgpanel data=sashelp.prdsale;
panelby year / layout=columnlattice noheaderborder colheaderpos=bottom novarname;
colaxis display=(nolabel) values=(1 2 3 4) valuesdisplay=("Q1" "Q2" "Q3" "Q4");
vline quarter / response=actual markers;
run;

In your case, you have Q1-Q4 in your data instead of 1-4, so you can drop the VALUES and VALUESDISPLAY option.

Hope this helps!

Dan

Re: Plotting a series on quarter and year

Reeza — Mon, 26 Jun 2023 16:07:51 GMT

SGPANEL, with yearly 'panels' is probably the easiest method.

How to move header to bottom and format it:
https://communities.sas.com/t5/Graphics-Programming/X-axis-labeling-with-two-variables-sgplot/td-p/413669

How to get a line graph:
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/grstatproc/n17inxbz8ldbcen145mwnmlqe6nv.htm

Re: Plotting a series on quarter and year

Ksharp — Tue, 27 Jun 2023 11:35:10 GMT

https://communities.sas.com/t5/Graphics-Programming/Creating-a-line-graph-using-SG-plot-with-multiple-x-axis-month/td-p/873763

Re: Plotting a series on quarter and year

brokenpc1 — Sat, 01 Jul 2023 15:32:31 GMT

Thank you all for answering my question! I think @Ksharp 's answer is most relevant to my situation, although I still don't know how to put year under months, but yeah, it's almost there.