Plotting a series on quarter and year

[brokenpc1]

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.

[DanH_sas]

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 

[Reeza]

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/4...

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

[Ksharp · Accepted solution]

https://communities.sas.com/t5/Graphics-Programming/Creating-a-line-graph-using-SG-plot-with-multipl...

[brokenpc1]

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.