topic Re: enhancement for my code in Graphics Programming

enhancement for my code

mona4u — Mon, 11 Jun 2018 15:07:36 GMT

Hi,

I have this code



data have;
input study_name $ June July August;
datalines;
A 20 16 39
B 18 18 6
C 19 1 5
D 87 65 115
E 63 55 62
F 81 104 87
G 73 19 49
H 189 69 79
I 28 6 8
J 87 83 52
K 0 0 0
L 0 0 0
M 4 1 1
N 1 0 2
O 212 159 304
;

proc transpose data=have out=trans
   name=Month;
by study_name;
var June July August;

run;

Proc sgplot data=trans;
   vbar month / response=col1 group=study_name;
    yaxis grid display=(nolabel);
   Xaxis display=(nolabel);
run;

which produces this result in the picture.

Note that the months in the bar chart are not displayed as they are in their order, they have alphabetical order.

I tried to find an option to change that but I couldn't find. Also, I don't need to display the study_name in the chart and don't know how to change the default.

Re: enhancement for my code

PaigeMiller — Mon, 11 Jun 2018 15:11:37 GMT

It is always better to use numbers to represent calendar or clock values. So if June is 6 and July is 7 and August is 8, these will automatically plot in the desired order.

Also, instead of data as you have shown it, you could do less programming if you re-organzied the data before you create the SAS data set, something like

data have;
input study_name $ month value;
datalines;
A 6 20
A 7 16
A 8 39
B 6 18

Re: enhancement for my code

DanH_sas — Mon, 11 Jun 2018 15:14:27 GMT

Add DISCRETEORDER=DATA to your XAXIS statement, and set the legend title to be "".

roc sgplot data=trans;
   vbar month / response=col1 group=study_name;
    yaxis grid display=(nolabel);
   Xaxis display=(nolabel) discreteorder=data;
   keylegend / title="";
run;

Hope this helps!

Dan

Re: enhancement for my code

PaigeMiller — Mon, 11 Jun 2018 15:30:59 GMT

@DanH_sas wrote:

Add DISCRETEORDER=DATA to your XAXIS statement, and set the legend title to be "".
roc sgplot data=trans;
   vbar month / response=col1 group=study_name;
    yaxis grid display=(nolabel);
   Xaxis display=(nolabel) discreteorder=data;
   keylegend / title="";
run;
Hope this helps!

Dan

It might help get the right plot, but it is still a better practice to use numbers for calendar time periods rather than words like "August","June","July". Then, the discreteorder option is not needed. And there are many other potential benefits as well in the long run.