topic How to annotate N counts below X axis in SGPANEL in Graphics Programming

How to annotate N counts below X axis in SGPANEL

mnithinshetty — Mon, 23 Aug 2021 03:15:14 GMT

Hi All,

Note:I am reposting this question in graphics group.

I am trying to produce a graph from sgpnel. Please see the attatched to see desired output.

the requirement is to display the N count below the X axis. I am finding a major challenge to do annotation in sgpanel output.

Initially, I displayed N count along the X axis using colaxistable statement in proc sgpanel procedure. but this option will provide us N count inside the graph area, which customer don't want now.

1) Are we able to do annotations to get N count below X axis in sgpanel procedure.

Please let me know if you need more information.

Any input will help me.

Thanks in advance.

Re: How to annotate N counts below X axis in SGPANEL

ballardw — Mon, 23 Aug 2021 03:43:06 GMT

Data: Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.

Your current Proc Sgpanel code would help.

A non-docx document. Some of use won't or can't by organization policy open such from unknown sources.

Re: How to annotate N counts below X axis in SGPANEL

a_SAS_sin — Mon, 23 Aug 2021 16:36:15 GMT

Someting like this?

proc sort data=sashelp.cars out=cars;
	by origin;
run;
data cars;
	set cars;
	Dummy=1;
	label dummy='N';
run;

proc sgpanel data=cars ;
	where origin in ('Europe' 'USA');
	panelby origin  ;
	vbox length / category=type nomean nofill ;
	colaxistable type / 
		class=type classdisplay=cluster 
		valueattrs=(size=9pt weight=bold)
		nolabel;
	colaxistable Dummy / 
		valueattrs=(size=9pt) 
		pad=5;
	colaxis display=none;
	rowaxis display=none;
	rowaxis grid minorgrid;
run;

Re: How to annotate N counts below X axis in SGPANEL

mnithinshetty — Tue, 24 Aug 2021 03:48:58 GMT

Yes. But In your example N count is still inside the data area. right. ! it should be completely outside. there are two ways I may think of, I am not sure it is going to meet my expectation, 1)use sgrender procedure and then boxplot template + axis table. 2)need to expand annotations that fit to X labels... I tried second option here, by creating formats which has tick marks label along with N counts and apply the formats colaxis statement using valuesfotmat= option. as of now it dint work as expected. the problem I am facing is I am not able to separate format applications for each panel. Example attached.

Re: How to annotate N counts below X axis in SGPANEL

a_SAS_sin — Tue, 24 Aug 2021 09:08:29 GMT

To give the notion that the axiatable not "inside the data area" you just need to create some kind of separation; in the code I sent, if you just had a refline on the Y axis with a value of 140 will give you the idea that the axistable is separated from the chart.

Using annotations to exactly place datalabels is quite complex since SGPANEL only allows the values GRAPHPERCENT, GRAPHPIXEL, LAYOUTPERCENT, and LAYOUTPIXEL.

Using GTL and SGRender might be a solution, but you asked for sgpanel...

Re: How to annotate N counts below X axis in SGPANEL

mnithinshetty — Thu, 26 Aug 2021 04:37:54 GMT

I have received a solution for this requirement.
Please see the discussion subject "Annotation in proc SGPANEL" in SAS programming forum.

Thank you for your reply.