topic Boxplot: how to get rid of the line "name of former variable" under the graph in SAS Programming

Boxplot: how to get rid of the line "name of former variable" under the graph

Lacona — Tue, 03 Sep 2019 01:26:34 GMT

Hey all,

Under my boxplots is a line saying "name of the former variable" (= Name der früheren Variable) and the following actual names (DomBox WorldBox OpWeek) are not exactly under the boxplots and the color of the letters is not matching the color of the boxplots, instead there are odd little colored squares.

data box_gross;
set movie (drop=reldate prodbud);
run;

proc sort data=box_gross;
by title;
run;

proc transpose data=box_gross out=boxplot (rename=(col1=Gross _name_=Box));
var dombox opweek worldbox;
by title;
run;

proc sgplot data=boxplot;
vbox gross/group=box;
xaxis display=(nolabel);
yaxis values=(0 to 1.6E9 by 5E7) grid;
title HEUREKA;
run;

I couldn't find anything helpful in SAS help center or here in the posts.
Maybe someone could help me?

Thank you!

Re: Boxplot: how to get rid of the line "name of former variable" under the graph

ChrisNZ — Tue, 03 Sep 2019 01:54:15 GMT

Have you tried keylegend title= ?

See here .

Re: Boxplot: how to get rid of the line "name of former variable" under the graph

Lacona — Tue, 03 Sep 2019 02:56:32 GMT

Great! The "name of former variable" is vanished now.
But unfortunately, the names are not directly unter the boxplots and still have these colored squares.
How can I fix that?

Re: Boxplot: how to get rid of the line "name of former variable" under the graph

ChrisNZ — Tue, 03 Sep 2019 03:24:34 GMT

If you want each box labelled in each group, maybe proc sgpanel is better then. See here.

Re: Boxplot: how to get rid of the line "name of former variable" under the graph

Lacona — Tue, 03 Sep 2019 03:45:32 GMT

keylegend and category did it! Thank you!!!

proc sgplot data=boxplot;
vbox gross/group=box category=box dataskin=pressed;
xaxis display=(nolabel);
yaxis values=(0 to 1.6E9 by 5E7) grid;
keylegend/title="";
title HEUREKA;
run;

graph looks now like this:

Almost perfect.

Is there an option to change the order of the xaxis values from alphabetic to something else? I would like to have OpWeek first, then DomBox, then Worldbox.

Re: Boxplot: how to get rid of the line "name of former variable" under the graph

ChrisNZ — Tue, 03 Sep 2019 04:24:17 GMT

Please try the VALUES= option.