topic Re: PROC SGPLOT in Graphics Programming

PROC SGPLOT

marianhabesland — Wed, 29 Nov 2017 22:54:24 GMT

I have this code so far for making a box plot:

TITLE "Diastolic Blood Pressure by Ethnicity/Race Group" BOLD;
PROC SGPLOT DATA = HypAnl.HypPrimanl;
VBOX DBP / GROUP = EthRaceCd
FILLATTRS= (COLOR=LIGHTRED) LINEATTRS= (COLOR=BLACK);
YAXIS LABEL = "Latest DBP Measurement"
LABELATTRS=(Weight=Bold)
VALUES = (10 TO 100 BY 10);
XAXIS LABEL = "Ethnicity/Race Group"
LABELATTRS=(Weight=Bold);
REFLINE 90 / LABEL= "Hypertension Threshold"
LINEATTRS= (COLOR=RED);
INSET "Data Source: HypAnl.HypPrimAnl (As of December 31, 2014)";
RUN;

My current box plot looks like this:

And I want it to look like the one below. Specifically what I want to change is that the groups (Hispanic, NH Asian etc) actually appear on the X-axis with gridlines. Any ideas?

Re: PROC SGPLOT

ballardw — Wed, 29 Nov 2017 23:28:21 GMT

To get axis labels try using Category=EthRaceCd instead of Group=

To your Yaxis statement add GRID to get gridlines at the tick marks.

Gridattrs would be used to control the appearance of the grid lines.

Re: PROC SGPLOT

marianhabesland — Thu, 30 Nov 2017 00:02:35 GMT

When I change group to category it does show the label like I want it, but it also only produces one box plot, like this:

Re: PROC SGPLOT

ballardw — Thu, 30 Nov 2017 00:18:05 GMT

Show data in the form of a data step and the actual code you used with category.

I have pages of output with category and get one box for each level of the category variable.

Re: PROC SGPLOT

marianhabesland — Thu, 30 Nov 2017 00:56:35 GMT

I am using a data file that is formatted like this. These are the two variables that are included in the box plot. The code I provided over is the entire code that I used to produce the box plot.

Re: PROC SGPLOT

marianhabesland — Thu, 30 Nov 2017 02:56:43 GMT

It actually works if I do both Group and Category. The legend at the bottom still shows up though, so will have to fix that somehow.

Re: PROC SGPLOT

PeterClemmensen — Thu, 30 Nov 2017 08:41:14 GMT

Use the NOAUTOLEGEND option in the procedure statement to suppress the legend at the bottom.

If you want the legend somewhere else, you can control that with the KEYLEGEND Statemend.

Re: PROC SGPLOT

Reeza — Thu, 30 Nov 2017 16:08:57 GMT

Switching to Category worked for me. What exact version of SAS do you have, I'm using 9.4M3

TITLE "Diastolic Blood Pressure by Ethnicity/Race Group" BOLD;

PROC SGPLOT DATA = sashelp.heart;
	VBOX diastolic / category = smoking_status
		FILLATTRS= (COLOR=LIGHTRED) LINEATTRS= (COLOR=BLACK);
	
	REFLINE 90 / LABEL= "Hypertension Threshold"
		LINEATTRS= (COLOR=RED);

	INSET "Data Source: HypAnl.HypPrimAnl (As of December 31, 2014)";

	YAXIS LABEL = "Latest DBP Measurement"
		LABELATTRS=(Weight=Bold)
		VALUES = (10 TO 100 BY 10);

	XAXIS LABEL = "Smoking Group"
		LABELATTRS=(Weight=Bold);

RUN;