06-10-2016 10:15 AM
I have a proc gchart and I would like to order the data based on 2 columns instead of one.
PROC GCHART DATA=data_set;
format MyMetric 8.0;
HBAR MyDim / discrete maxis=axis1 raxis=axis2 nostats sumvar=MyMetric DESCENDING
coutline=black patternid=subgroup subgroup=fillcolor annotate=anno_dataset nolegend noframe width=.6 space=.6;
right now i am displaying the data in descending order based on a MyMetric. but i would also like a second order in case of ties.
I ordered the data properly in a data set. However it doesn't keep the order of the data set.
it uses the alphabetic order for the second order based on MyDim.
06-13-2016 07:25 PM
Same trick as memtioned in your previous question.
Just adjust the order variable's value slightly to ensure the desired plot order.
data HAVE; MYDIM='A'; MYMETRIC=11; output; MYDIM='B'; MYMETRIC=10; output; MYDIM='C'; MYMETRIC=12; output; MYDIM='D'; MYMETRIC=12; output; run; data PLOT; set HAVE; if MYDIM='D' then MYMETRIC + - 1e-9; run; proc gchart data=PLOT; hbar MYDIM / discrete nostats sumvar=MYMETRIC descending; run;