proc gchart how to order based on two columns

AJCFreeman — Fri, 10 Jun 2016 14:15:31 GMT

Hi,

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;
run;

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.

Re: proc gchart how to order based on two columns

ChrisNZ — Mon, 13 Jun 2016 23:25:28 GMT

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;

topic Re: proc gchart how to order based on two columns in SAS Programming

proc gchart how to order based on two columns

Re: proc gchart how to order based on two columns