topic Re: PROC SGPANEL: How to display panel label in the bottom? in ODS and Base Reporting

PROC SGPANEL: How to display panel label in the bottom?

A_Kh — Tue, 08 Jul 2025 14:43:37 GMT

Hello Community,

Could anyone fix the below code to display panel labels in the bottom of each panel (which is on top of panel right now)? I expected colheaderpos=bottom option to resolve the issue, but apparently I'm not using the right option.
Thank you!

proc sgpanel data=sashelp.cars noautolegend description="";
	where type eq 'Sedan';
	panelby origin/novarname columns=3 rows=1 colheaderpos=bottom;
	vbox invoice;
	rowaxis integer label="Price";
run;

Re: PROC SGPANEL: How to display panel label in the bottom?

FreelanceReinh — Tue, 08 Jul 2025 15:25:31 GMT

Hello @A_Kh,

The documentation of the PANELBY statement says that the COLHEADERPOS= option "has no effect if the panel uses the PANEL layout" (which is the default of the LAYOUT= option). So use a different layout: COLUMNLATTICE looks very similar to you current layout.

panelby origin/novarname columns=3 rows=1 colheaderpos=bottom layout=columnlattice;

Re: PROC SGPANEL: How to display panel label in the bottom?

A_Kh — Tue, 08 Jul 2025 17:19:03 GMT

Hi @FreelanceReinh ,

Thank you for explanation. Could we have the column label underneath the column, not separated by space?

Re: PROC SGPANEL: How to display panel label in the bottom?

FreelanceReinh — Tue, 08 Jul 2025 22:06:04 GMT

There doesn't seem to be an option of the PANELBY statement to control that space. In this case you could specify the NOHEADER option and create your own header using SG annotation. Not sure if this would be worth the effort, though.

Re: PROC SGPANEL: How to display panel label in the bottom?

Ksharp — Wed, 09 Jul 2025 01:48:33 GMT

You want this ?

proc sgpanel data=sashelp.cars noautolegend description="";
	where type eq 'Sedan';
	panelby origin/novarname columns=3 rows=1 noheader proportional uniscale=row;
	vbox invoice/category=origin;
	rowaxis integer label="Price";
run;

Re: PROC SGPANEL: How to display panel label in the bottom?

A_Kh — Wed, 09 Jul 2025 18:40:34 GMT

Thank you, @Ksharp , this works for me. Would it be possible to hide the variable name "Origin" in the bottom?
I could label it and use the label instead of variable name, but hiding it completely would be perfect.

Re: PROC SGPANEL: How to display panel label in the bottom?

Ksharp — Thu, 10 Jul 2025 00:55:02 GMT

Here you go.

proc sgpanel data=sashelp.cars noautolegend description="";
	where type eq 'Sedan';
	panelby origin/novarname columns=3 rows=1 noheader proportional uniscale=row;
	vbox invoice/category=origin;
	rowaxis integer label="Price";
	colaxis display=(nolabel);
run;

Re: PROC SGPANEL: How to display panel label in the bottom?

Tom — Sat, 12 Jul 2025 17:51:14 GMT

And you can add NOTICKS to COLAXIS to get rid of the little tick marks.

colaxis display=(nolabel noticks);